Ping Mo

Ping Mo

Sr. Data Warehouse Analyst

Followers of Ping Mo620 followers
location of Ping MoMinneapolis, Minnesota, United States

Connect with Ping Mo to Send Message

Connect

Connect with Ping Mo to Send Message

Connect
  • Timeline

  • About me

    Sr. Manager, Data Management at Ameriprise Financial Services, Inc.

  • Education

    • University of Minnesota - Carlson School of Management

      1998 - 2000
      MBA MIS/Finance
    • Zhejiang University

      1986 - 1990
      Bachelor of Science (B.S.) Optical Electronics
  • 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
  • Licenses & Certifications

    • EdX Honor Code Certificate for Tackling the Challenges of Big Data (February 3, 2015 - March 17, 2015)

      EdX
      Mar 2015
      View certificate certificate