Jul 2018 – Sep 2023 · 5 yrs 2 mos · Pune, Maharashtra, India

Dec 2015 – Jun 2018 · 2 yrs 6 mos · Charlotte, North Carolina Area

• Automate the existing process which was highly manual.
• Worked on Requirement Gathering, Analysis, Design , Implementation, Testing and Maintenance.
• Involved in End-to-End implementation working in Agile methodology.
• Created mapping specifications documents.
• Worked on Business Requirement Document (BRD), High Level Design Document(HLD) and Low Level Design Document (LLD).
• Involved in Designing the overall process including number of tables to be created as well as naming convention.
• Managed multiple (3) projects at the same time right from On-Boarding of Informatica to Implementation of project.
• Worked on estimation tool to finalize the timelines and identifying different risk for project
• Performed Unit Testing, System Testing, regression testing and Functional testing for various modules.
• Trained in Agile and implemented all Agile methodologies in project.
• Worked on Offshore-Onshore Model.
• Developed Informatica code to download the data from Share-Point List and it rewarded by the client as well as with Infosys.
• A strong work ethic combined with a commitment to excel in all projects undertaken.

Dec 2014 – Dec 2015 · 1 yr

• Worked as Business Intelligence Lead primarily in Informatica, BODS, SQL- Server and UNIX.
• Lead both the Conversion projects to the successfully data migrated into Production.
• Directly worked with Client Involving Required gathering, Design and Implementation.
• Created AP270 Data Conversion Strategy Approach document to determine how and scope of the data that will be converted as a part of Conversion Team
• Involved in all Dress-Rehearsals and until the data is loaded into the Production.
• Develop technical design documents (both low level and high level), mapping specifications (source to target mapping docs) and unit testing documents.
• Developed Unix Scripts to SFTP .txt files using NDM.
• Used Workflow Repository Manager for importing, exporting the objects through XML, DG.
• Build various ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy
• Identifying and removing Bottlenecks to improve the performance of Mappings, Sessions and Workflows using partitioning, fixing bottlenecks at source and target level.
• Created Test Pans, Test Scripts, Naming Conventions Document, etc.
• Performed code review in project and established myself as one of the SME.

Oct 2011 – Nov 2014 · 3 yrs 1 mo

• AGL:
• Worked as Informatica Senior developer to create mappings, Mapplets, sessions and workflows for the proposed ETL solution in Informatica
• Used Workflow Repository Manager for importing, exporting the objects through XML, working on the Deployment group and basic administrative tasks.
• Integrating various T1/T2/T3/T4 objects into different environments
• Involved in Status reporting, Client calls, Query resolution
• Was involved in End to End reports for the statistics of Data Migration project.
• Developed code using excel micro which automates .xmls file when imported in Informatica creates workflows/mapping and sessions. This has saved around 2000$ of effort as total of 114 workflows/sessions/mappings were created using this excel tool.
• Level 3:
• Developer:
• Understanding Existing Ab Initio Project and coming up with mapping documents for the target fields.
• Understand functional requirements and develop technical requirements and solution blueprint for this Module comparing with Ab Initio Process
• Converted all the jobs of Ab Initio Jobs into Informatica.
• Worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Sequence Generator, Aggregator, Stored Procedure, Sorter, Normalizer, Union etc.
• Develop technical design documents (both low level and high level), mapping specifications (source to target mapping docs) and unit testing documents.
• Production Support:
• Responsible for all production and enhancements related offshore activities.
• Ensured daily/weekly/monthly data loads/job completes at their schedule time without any data/refresh issues and communicating with the downstream and stake holders in case of any variance.
• Analysis of all production Issues and ensuring the STF (Short Term Fix) and LTF (Long Term Fix) for them.
• Enhanced Time Tracking Tool used at project level. Send out the defaulters list and publishing out different reports used for DART