Summary
Overview
Work History
Education
Skills
Websites
Certification
Awards
Affiliations
Languages
Accomplishments
Timeline
Generic

Poonam Singh

Pune

Summary

Dynamic Senior Manager with extensive experience at Morgan Stanley, specializing in financial reporting and performance optimization. Proven track record in leading data migration initiatives, achieving $627K in cost savings, and enhancing report accuracy. Skilled in Informatica PowerCenter and team leadership, driving successful project outcomes through collaboration and strategic planning.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Senior Manager

Morgan Stanley
Mumbai
10.2019 - Current
  • Led the mainframe decommissioning initiative for multiple finance pipelines, successfully migrating over 20 million rows of data away from the mainframe, resulting in a cost savings of approximately $627K for the organization.
  • Enhanced and developed numerous BRM reports, significantly improving daily P&L sign-offs and balance sheet reporting processes, ensuring seamless financial operations and reporting accuracy.
  • Developed dynamic averaging solutions for user balances, effectively managing large report extractions while collaborating closely with cross-functional finance teams to gather requirements and align on business objectives.
  • Led end-to-end regulatory disclosure reporting project, coordinating with stakeholders to understand data requirements, integrating six distinct data source pipelines into the data warehouse, and applying reporting logic to deliver timely reports. This initiative resulted in a 70% reduction in manual efforts previously handled by controllers.
  • Optimized report performance by centralizing complex rule logic into a Rule-Engine (Elm code) and storing derived dimensions in an SCD table, improving report efficiency by 50% and enhancing transparency for users regarding the underlying logic in report columns.
  • Designed and implemented stored procedures for MTD & YTD calculations, alongside scripting in Python for streamlined file handling within the ETL process, improving operational efficiency.
  • Contributed to audit item enhancements across multiple teams, collaborating with the DevOps team and consistently receiving recognition through appreciation awards during townhall meetings for outstanding performance.
  • Led a team of 5 members in the successful execution of projects, overseeing pipeline work, providing accurate work estimations, and ensuring streamlined, on-time delivery of key milestones. Demonstrated strong leadership in project management, fostering collaboration and optimizing team performance to meet organizational goals efficiently.

Senior Consultant

PricewaterhouseCoopers Pvt. Ltd.
Mumbai
02.2016 - 09.2019
  • Collaborated in client requirement discussions to design and develop a data model using Erwin, ensuring alignment with specific report requirements and business needs.
  • Created comprehensive source-to-target mapping documents and technical design documentation, detailing data flow and transformation logic for clear implementation guidelines.
  • Designed and implemented an ETL pipeline to efficiently extract transactional data from Oracle systems and load it into the data warehouse, ensuring smooth integration and high data integrity.
  • Automated several reports using stored procedures, streamlining the application of business logic and enabling monthly report generation based on user-defined parameters, significantly reducing manual effort and enhancing report accuracy.
  • Led a team of four members, providing guidance, technical support, and regular communication with project managers and end-users to ensure timely delivery and successful project outcomes.

Programmer Analyst

Cognizant Technology Solutions
Pune
02.2013 - 01.2016
  • Led Consumer HUB Projects/SSCRs (Informatica Powercenter Developer) for HIX/CIRS integration, where the source system provided member crosswalk files in a fixed-length format on a daily basis. Managed the ETL layer to process and transform the source crosswalk file, updating data and applying business rules using transformations like Router, Normalizer, and Aggregator.
  • Designed and implemented ETL processes that converted the transformed data into XML format using the XML Generator transformation. This XML was subsequently passed to MDM (Master Data Management) via MQ (Message Queue) for further processing, ensuring efficient data flow and accuracy.
  • Developed GetContractList ETL process using Informatica Powercenter Developer, sourcing raw data from various source systems in a combination of common file formats and additional files. This solution enabled new data elements for the GetContractList SOA (Service-Oriented Architecture) service.
  • Transformed Consumer HUB into the primary source of reference data for the GetContractList service, streamlining service calls by consolidating the majority of required data in a single source. This resulted in a significant reduction in service calls, contributing to improved Service Level Agreements (SLAs) and operational efficiency.

Education

B.Tech - Computer Science

SSGGSIET
Nanded, Maharashtra
01.2012

H.S.C - Science

Mumbai Board
R.K.T College Ulhasnagar
01.2008

S.S.C -

Mumbai Board
S.I.C.E.S English High School Ambernath
01.2006

Skills

  • Informatica PowerCenter
  • SSIS
  • Morgan ETL tool
  • Informatica Data Quality
  • Oracle 12c
  • MySQL
  • IBM DB2
  • Sybase
  • Teradata
  • Autosys scheduling
  • PowerBI
  • GIT hub
  • Data modelling
  • Erwin
  • Python
  • Unix shell scripting
  • ELM code
  • Financial reporting
  • Team leadership
  • Project management
  • Performance optimization

Websites

Certification

  • Informatica Certified Professional on 'PowerCenter Data Integration 9.x:Developer Specialist'
  • Microsoft Certified Azure Fundamentals(AZ-900)
  • Microsoft Certified Azure Data Fundamentals(DP-900)
  • Microsoft Certified Azure Data Engineering (DP-203)

Awards

  • Associate of the Quarter award, Cognizant
  • Star of the Quarter award, Cognizant
  • PwC experience award, PwC
  • Putting client first, Morgan Stanley

Affiliations

  • Travelling
  • Reading Books

Languages

Hindi
First Language
English
Proficient (C2)
C2
Marathi
Advanced (C1)
C1

Accomplishments

  • “Associate of the Quarter award”, Cognizant
  • “Star of the Quarter award”, Cognizant
  • “PwC experience award”, PwC
  • “Putting client first”, Morgan Stanley
  • "Innovation at IST Circle of Excellence Award", Morgan Stanley
  • "Team Project Success Award" at FFT India Townhall, Morgan Stanley

Timeline

Senior Manager

Morgan Stanley
10.2019 - Current

Senior Consultant

PricewaterhouseCoopers Pvt. Ltd.
02.2016 - 09.2019

Programmer Analyst

Cognizant Technology Solutions
02.2013 - 01.2016

B.Tech - Computer Science

SSGGSIET

H.S.C - Science

Mumbai Board

S.S.C -

Mumbai Board

Similar Profiles

CREATE PROFILE
Poonam Singh