Mar 2020 – Aug 2022 · 2 yrs 5 mos

•  Expertise in Data Warehousing, AB INITIO (ETL) programming, and fulfillment of data warehouse project tasks including Data Extraction, Cleansing, Transforming and Loading. Involved in all stages of SDLC during projects, Analyzed designed and tested the new requirement for performance, efficiency and maintainability using ETL tool AB INITIO.
•  Experience in Ab Initio parallel and serial flow batch graphs, conditional components, other components like Transform, Read and Write XML, Read and Write Multiple files, Partition graphs.
•  Participated in meetings with Users, Business analysts in understanding the business requirements and analyzed use cases to develop detailed Test Plan
•  Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
•  Extensively used various components like Input, Output (Table/File), Filter by Expression, Rollup, Sort, Sort with in Groups, Dedup sort, Reformat and Join etc...
•  Performed major role in understanding the business requirements and designing and loading data into Data Warehouse.
•  Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target systems using Abinitio.
•  Documentation of all modules for user level and system level maintenance.
•  Handling production issue

Apr 2017 – Feb 2020 · 2 yrs 10 mos

• Handle Production related incident tickets for Unix/Datastage Applications, troubleshoot incidents, follow up with the daily stream cycle and maintain the application.
• Maintain the root cause analysis and issue tracker sheet in a centralized location.
• Analyze the critical user issues and provide fix in production
• Create, scheduling and monitoring the daily, weekly and monthly basis batch jobs and related scripts.
• Create various Business Critical reports for the Applications and have the same sent over to Client's top management.
• Change review to ensure no miss production system.

Oct 2015 – Mar 2017 · 1 yr 5 mos

•  Interacted with End user community to understand the business requirements and in identifying data sources.
•  Designed Incremental loading process to load data into staging tables.
•  Had participated in Daily incident meetings with the client and also weekly meetings to increase the efficiency of the project.
•  Improve the batch performance and stabilize the application.
•  Documentation of all modules for user level and system level maintenance.
•  Analyze the critical user issues and provide fix in production.
•  Analyze stack holder needs, scope of problem and develop business case to address the problem.
•  Change review to ensure no miss production system.

Mar 2013 – Sep 2015 · 2 yrs 6 mos

•  To enhance or implement new codes/mappings as per the Business requirement
•  To monitor whether the processed data are correct as per the Business logic.
•  Resolve/develop tactical solutions for reported problems in the production environment.
•  Prepared SQL Queries to validate the data.
•  Developed Ab-Initio graphs for the one time history load into Oracle staging tables.
•  Have worked on extracting, cleansing (dealing with missing elements, parsing into standard formats) combining data from multiple sources and de-duping the data.
•  Prepared technical design document, Implementation Plans to make the code GO-LIVE.
•  Have assisted the support team members in analyzing the tickets which involve code view and debugging.
•  Supported production implementations and post-change validations.

Mar 2011 – May 2013 · 2 yrs 2 mos

•  Handle Production related incident tickets for Unix Applications, troubleshoot incidents, follow up with the daily stream cycle and maintain the application.
•  Had Interacted with the clients for requirements with respect to the project and worked accordingly.
•  Experience in working as Abinitio support personnel and resolved the tickets within SLA.
•  Monitor the Batch Jobs associated with Unix Applications and troubleshoot issues
•  Had participated in Daily incident meetings with the client and also weekly meetings to increase the efficiency of the project.
•  Monitor Systems and ensure any potential issues are proactively monitored and handled in a timely fashion to avoid incidents resulting from them.
•  Create, scheduling and monitoring the daily, weekly and monthly basis batch jobs and related scripts.
•  Create various Business Critical reports for the Applications and have the same sent over to Client's top management.