Neha Sharma

Experience

• 

  Tata Consultancy Services

  Mar 2013 - Apr 2017

  Etl Developer

  Understanding the complete Process of ICRS data model• Understand upstream and downstream applications of ETL to determine and automate dependencies.• Involved in requirement gathering.• Involved in Creation of Understanding document.• Responsible for Creation of Design and Mapping specification Document• Responsible for ETL Development to extract, transform, and distribute data across one or more data stores from a wide variety of sources and Database Script• Involved in Unit Testing, Integration Testing and Application Testing• Involved in Data Loading• Run the loads during SIT and UAT time.• Monitor the loads and send the weekly status report with the time taken by each session.• Writing unit tests and log defects during development.• Provide problem-solving expertise and complex analysis of data to develop business intelligence integration designs.• Work with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment. • Expertise in debugging the mappings.• Maintain the code versioning in SVN and update CM instructions accordingly and supporting the deployments.• Participated in Daily Client meetings and status updates.• Responsible for Pre/Post Implementation and Support activity Show less

• 

  Fiserv

  Apr 2017 - Dec 2022

  Understand the complete Process of Assurant (TWG) data model.• Understand multiple data source system and destination system• Understand upstream and downstream applications of ETL to determine and automate dependencies.• Participating in the design calls.• Involved in requirement gathering.• Involved in Creation of Understanding document.• Responsible for Creation of Design and Mapping specification Document• Responsible for ETL Development to extract, transform, and distribute data across one or more data stores from a wide variety of sources and Database Script• Involved in Unit Testing, Integration Testing and Application Testing• Involved in Data Loading• Run the loads during SIT and UAT, so that the data available for testers.• Monitor the loads and send the weekly status report with the time taken by each session.• Writing unit tests and test result and log defects during development.• Coordinate with the source and target systems to make sure the data flowing accurately.• Provide problem-solving expertise and complex analysis of data to develop business intelligence integration designs.• Work with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment. • Performance tuning of mappings, SQL queries and sessions (session partitioning) to optimize session performance.• Worked on variable assignment concept to pass the mapping parameters/variables to worklets and workflows.• Mapping data, establishing interfaces, developing and modifying functions, programs, routines, and stored procedures to export, transform and load data and meeting performance parameters, resolving and escalating integration issues.• Expertise in debugging the mappings.• Maintain the code versioning in SVN and update CM instructions accordingly and supporting the deployments.• Participated in Daily Client meetings and status updates.• Responsible for Pre/Post Implementation and Support activity Show less

  • ETL Developer

    Apr 2017 - Dec 2022

  • Tech Lead Data Architect

    Apr 2017 - Dec 2022
• 

  Infinite Computer Solutions

  Dec 2022 - now

  Senior Technical Lead

  Understand the complete Process of Assurant Rating Engine.• Understand multiple data source system and destination system• Involved in requirement gathering and in impact analysis.• Involved in SQL programming• Responsible for creating complex T- SQL queries, views and stored procedure• Responsible for writing code with various logic like upsert/merge, dynamic SQL, CTE, temp table, table variables etc.• Debugging and error handling in SP’s• Involved in Unit Testing, Integration Testing and Application Testing• Coordinate with the source and target systems to make sure the rates are showing accurately.• Provide problem-solving expertise and complex analysis of data for any production issues.• Performance tuning of SQL queries to optimize the performance.• Using Azure DevOps for maintaining for work items, user stories for every release.• Participated in Daily Client meetings and status updates.• Responsible for Pre/Post Implementation and Support activity Show less