Divya Menon Email & Phone Number

New York, New York

Greater New York City Area

• Served as Technical Product Owner for multiple Risk monitoring applications.• Architected and Designed Solutions for Data management on multiple MIS applications. • Led the Data Warehouse and Reporting team in creating customized reporting solutions for Business problems.• Spearheaded the migration of the MIS Data marts from Sybase and SQL Server into a consolidated Data Warehouse in Greenplum. • Acted as Single Point of Contact for all Business Users• Led the global development team in: Development of ETL process to load data from multiple data sources. Creation of parameter-based mappings, mapplets and reusable transformations.

• Led the Data Warehouse team for the Mortgage Application Project.• Developed the logical and physical data-model using Erwin.• Was a key participant in building the Business Requirement Document and the data dictionary; and identifying scope limitations of the first deliverable for the Risk Data Warehouse.• Co-ordinated with external data providers like Fidelity, FiServe, Saxon etc. to finalize the data feed requirements.• Designed and developed the data load strategy from varied sources to warehouse to data marts.• Reviewed ETL strategies and Informatica code and made suggestions for improving the current process.• Conducted stored procedure reviews, for long running reporting procedures. Incorporated changes to these procedures which improved performance (from approximately 25 mins to under 3 mins).

• Design and develop multiple Data Marts using Ralph Kimball Methodology.• Design the ETL strategy for Finance, Workstation and CRM marts which takes feed from multiple source systems (Flat Files, Sybase, Oracle etc.) making use of conformed dimensions between the marts.• Developed numerous complex Informatica mappings, created mapping to load slowly changing dimension tables for Client Hierarchy reporting, used reusable transformations and mapplets for getting Blind Keys.• Scheduling data load via CA.• Performed basic Informatica Administrator activities such as creating repositories, migration of mappings between repositories, backing up repositories periodically, creating and managing users, groups and folders.• Provided Production Support for the ETL jobs.