Vikrant Bansal

- Working at Germany (client side) for requirement gathering and understanding the system. - As Technical Analyst delivered Data Loading and transformation (ETL) process for data Warehouse. - Working with client to get the requirements and preparing HLD and LLD. - Developing Informatica. IDQ, Anaylst jobs a per client need. - Interacted with cross functional teams to work on solution and gap analysis. - Integration Acceptance Testing (IAT) of Informatica jobs.

- System and Business Analysis of Vm Ware architecture. - Preparing Solution Release document. - Interacted with cross functional teams to work on solution and gap analysis for Telecom Processing. - Code Review and Integration Acceptance Testing (IAT) of Informatica jobs. - Review and QA testing of ETL mappings, Defect logging/tracking and following them to closure. - Ensure compliance to the Quality activities. - Resolving technical difficulties of the team.

- Study of the existing OFI Reporting project and design the new ETLs and reports - Assisting Reporting team in creating reports and Integration Acceptance Testing (IAT) of reports along with the Informatica ETLs - Review, Unit testing and QA testing of ETL mappings and Reports, Defect logging/tracking and following them to closure. - Ensure compliance to the Quality activities. - Resolving technical difficulties.

- Study of the existing Goldman Sachs HR WorkWays™ Reporting project and design the new ETLs and reports with respect to MPHRO (Multi – Purpose Human Resources Outsourcing)- - Assisting Reporting team in creating reports and Integration Acceptance Testing (IAT) of reports along with the Informatica ETLs - Review, Unit testing and QA testing of ETL mappings and Reports, Defect logging/tracking and following them to closure. - Supporting the monthly Data Mart refresh and assisting the Cubes reporting team

- Analyzing and creation of ETL mappings using Informatica. - Review and Unit testing of ETL mappings, Defect logging/tracking and following them to closure. - Ensure compliance to the Quality activities.