Experience

• 

  Igate

  Oct 2007 - Jan 2015

  • Performed research and worked closely with business users and analysts to gather requirements for enhancement requests as part of run the shop team. • Worked with business and offshore development team to implement data quality improvement solutions for Long term care data mart and reporting applications. • Implemented ETL projects for automated policy letter printing which helped client save dollar amount by minimizing number of letters being sent at incorrect address. • Supported around 15 downstream applications and enhanced ETL code as per business reporting needs. • Coordinated Informatica Powercenter version upgrade with admin and development team. • Automated ETL job runs using appworx and shell scripting for better support monitoring Show less • Performed analysis of Data warehouse to incorporate new Account receivables module of ERP as a source for a manufacturing client. • Developed ETL components to load invoices fact and orders dimension data to data warehouse using Informatica. • Prepared and executed system integration test cases and worked on defect fixes. • Created design and supporting documents for deployment. • Developed business object reports for campaign analytics of LTC Group insurance for marketing team. Show less • Performed analysis of Data warehouse to incorporate new ERP system as a source for a manufacturing client. • Prepared analysis, design documents, source to target mapping documents. • Developed Informatica ETL workflows, sessions and mappings using lookup, aggregator, expression, joiner transformations to load shipment, sales order fact to data warehouse. • Prepared and executed unit test cases for ETL components. • Deployed code to production environment. • Researched, designed and implemented scalable applications for information identification, extraction, analysis, retrieval and indexing. Show less

  • Technical Lead

    Apr 2012 - Jan 2015

  • Senior Software Engineer

    Apr 2010 - Mar 2012

  • Software Engineer

    Oct 2007 - Mar 2010
• 

  Capgemini

  Jan 2015 - Jun 2018

  Project lead

  • Worked closely with Actuaries and Business users to capture requirements to convert GGY AXIS (valuation tool) data transformation logic into ETL using Informatica Powercenter to increase efficiency and tractability.• Analyzed and implemented robust solution in ETL to fix multiple data quality issues, which helped actuarial team in correcting reserve amount being reported to GL.• Led an offshore team of 4 to implement Oracle to Greenplum database migration project to enable fast retrieval of data for financial reporting.• Implemented projects to convert legacy pl/SQL packages, mainframe processes to Informatica ETL code to improve data quality, performance and maintainability.• Built reconciliation processes in Informatica to reconcile data between critical financial applications to ensure data accuracy.• Enhanced multiple ETL, Database components for valuation application to achieve faster processing and accurate reserves data.• Collaborated with QA team to layout test plans and supported system integration testing, user acceptance testing for multiple Actuarial projects.• Prepared documents which includes design, source to target mapping, production support for successful transition to support teams• Trained in Agile development and executed projects using scrum methodologyTechnical Lead Show less

• 

  Wells fargo

  Jun 2018 - Dec 2020

  Senior software engineer team lead
• 

  Mufg

  Dec 2020 - Apr 2022

  Senior data analyst, enterprise data management

  Enterprise Data strategy and Analysis for MUFG Americas

• 

  Unitedhealth group

  Apr 2022 - now

  Senior data engineer