Ping Mo

Experience

• 

  ING USFS

  Jun 2000 - Oct 2005

  Sr. Data Warehouse Analyst

  Took a lead role to design ETL processes for the Enterprise ODS projects, working with source system experts to identify high level ETL logic and resolve technical issues, preparing detail ETL specifications and development plans, and coordinating the development team, which includes both employees and consultants. Worked on design specifications/transformation rules and developed 300+ ETL mappings/sessions of loading EII ODS and data warehouse and data marts by using Informatica PowerCenter. Migrated ETL code, parameter files, PMCMD scripts from Dev to QA, Integration, and Production. Tuned Informatica mappings to improve ETL overall performance to meet SLAs. Show less

• 

  System Dynamix

  Oct 2005 - Feb 2008

  ETL Architect/Team Lead

  I worked at ING, US Financial Services Corporate IT department. I was a tech lead on several projects, including Fund Operation Replacement project, for which we developed the Fund OPS data warehouse and data mart; SEC 22c2 project, for which we provided daily fund transaction of ING Funds to the third party to monitor market timing violations. I created high-level and detail level ETL design documents for the Data Integration Services/ETL development team, provided data integration solutions to meet various business requirements. I also guided the development team in ETL process coding, testing, and implementation and closely monitored every stage of the ETL development lifecycle. Show less

• 

  ING

  Feb 2008 - Jan 2013

  Lead Data Movement Engineer/ETL Architect

  As a lead data movement engineer, I work closely with project managers, business analysts, and other technical leads to identify data integration and consolidation needs; provide project estimates and prioritization, make ETL development plans, and ensure all the activities adhere to the ETL best practices and data management standards and rules. I also design ETL processes and provide both high-level and detail-level mapping design documents, process flows, and population specifications. Informatica is the major data integration tool I have been using for 10+ years. Since I joined ING, I have been involved in Enterprise Data Warehouse, ODS, Information Hubs, and various Data Mart projects as either developer and/or tech lead. I also mentor and oversee the junior level developers to ensure the quality of our work. Show less

• 

  Ameriprise Financial Services, Inc.

  Mar 2013 - now

  Senior Manager