SUMMARY:

• To work in a creative and challenging environment and help the organization to achieve objectives by applying my skills and abilities and thereby grow with the organization.
• Around 7 years of solid experience in the Analysis, Design and Development of Data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Ab Initio.
• Experience in writing SQL Scripts and good knowledge of Data Warehousing concepts.
• Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Highly experienced in ETL tool Ab Initio and has very good working experience with all the Ab Initio components.
• Expertise and well versed with various Ab Initio Transform, Partition, De partition, Dataset and Database components.
• Very good experience with Teradata, DB2 & Oracle Databases.
• Experience in direct Client interaction.
• Excelled on rapid completion and management of technological issues for assigned projects, earning recognition from managers and contributing in timely release to customer.
• Worked on projects in agile methodology.
• Rich experience in banking domain.
• Diagnosing technical problems and implement fixes.
• Resolving production issues, undertaking impact analysis and providing permanent solutions.
• Involved in end - to-end activities in the development life cycle i.e. Requirements management, Feasibility Study, Design technical solutions, Development & unit Testing, Design & Code Reviews, Testing Support, Defect Prevention planning, Release management, Planning & Tracking of the module, Dependency management, Status reporting, Onshore-Offshore co-ordination etc.
• Has keen interest in learning Big data related technologies and like to do hands on Hadoop, Hive, Mango DB and sqoop and also have exposure to Basics of J2EE.

KEY DOMAIN AND TECHNICAL KNOWLEDGE:

ETL Tools: Ab Initio.

Languages: Shell Script, SQL, PDL and Basics of Java.

Database: Teradata, DB2, Oracle.

Operating System: Windows XP/7/10, Linux.

Scheduler: Autosys, CA7 Mainframe.

Deployment Tools: Anthill Pro,Jenkins,uDeploy

Version Control Tools: Ab Initio EME

ORGANIZATIONAL EXPERIENCE:

Confidential

Responsibilities:

• Involved with Client for Requirement Analysis and Architecture design.
• Requirements gathering and translation to technical specifications.
• Prepare Technical Design Document, Data Mapping, Implementation Plan and Unit Test plans and getting approval for the same.
• Development of Many Generic Graphs and respective Psets using Ab Initio for ETL and creating generic UNIX shell script to trigger each of the graphs.
• Created condition in sub graph to identify Transform load or UMT load.
• Created Audit and reconciliation concepts to ensure no data loss.
• Migration of code to higher environments.
• Created copy of tables in Teradata and granted access to the testers for testing in SIT and UAT environment.
• Provided KT and support during/post implementation.
• Prepared work order checklist, security peer document, validation document for udeploy build, created snapshot URL and created change request for the production Implementation.
• Run Book creation for the L1 &L2 support team.

Confidential

Responsibilities:

• Involved with Client for Requirement Analysis and Architecture design.
• Requirements gathering and translation to technical specifications.
• Prepare Technical Design Document, Data Mapping, Implementation Plan and Unit Test plans and getting approval for the same.
• Development of Graphs/Psets using Ab Initio for ETL and creating UNIX shell script as a File watcher for 5th and 6th business day and trigger the graph.
• Created condition in sub graph to identify Regular run or Re run scenario.
• Migration of code to higher environments.
• Created copy of tables in Teradata and granted access to the testers for testing in SIT and UAT environment.
• Provided KT and support during/post implementation.
• Created calendar for 5th and 6th business day, Monitoring and scheduling jobs in Production environment using Autosys.
• Prepared work order checklist, security peer document, validation document for udeploy build, created snapshot URL and created change request for the production Implementation.
• Run Book creation for the L1 &L2 support team.

Environment: Ab Initio, Autosys, Teradata SQL assistant, UNIX, LINUX, Windows 10, EME.

Confidential

Senior System Engineer

Responsibilities:

• Involved with Client for Requirement Analysis and Architecture design.
• Requirements gathering and translation to technical specifications.
• Prepare Technical Design Document, Data Mapping, Implementation Plan and Unit Test plans and getting approval for the same.
• Development of Graphs/Psets using Ab Initio for ETL and creating UNIX shell script as a File watcher for 15 days and trigger the graphs when file arrives..
• Involved in the creation of NDM setup to receive the file from external site to our NDM server and then copy to ETL server for ETL processing.
• Migration of code to higher environments.
• Created copy of tables in Teradata and granted access to the testers for testing in SIT and UAT environment.
• Provided KT and support during/post implementation.
• Monitoring and scheduling jobs in Production environment using Autosys.
• Prepared work order checklist, security peer document, validation document for udeploy build, created snapshot URL and created change request for the production Implementation.
• Run Book creation for the L1 &L2 support team.

Environment: Ab Initio, Autosys, Teradata SQL assistant, NDM, UNIX, LINUX, Windows 10, EME.

Confidential

Responsibilities:

• Involved with Client for Requirement Analysis and Architecture design.
• Requirements gathering and translation to technical specifications.
• Prepare Technical Design Document, Data Mapping, Implementation Plan and Unit Test plans and getting approval for the same.
• Development of Graphs/Psets using Ab Initio for ETL and creating UNIX shell scripts to integrate the purpose of a job.
• Involved in the creation of NDM setup to receive the file from external site to our NDM server and then copy to ETL server for ETL processing.
• Migration of code to higher environments.
• Created copy of tables in Teradata and granted access to the testers for testing in SIT and UAT environment.
• Provided KT and support during/post implementation.
• Monitoring and scheduling jobs in Production environment using Autosys.
• Prepared work order checklist, security peer document, validation document for udeploy build, created snapshot URL and created change request for the production Implementation.
• Run Book creation for the L1 &L2 support team.

Environment: Ab Initio, Autosys, Teradata SQL assistant, NDM, UNIX, LINUX, Windows 10, EME.

Confidential

Responsibilities:

• Involved with Client for Requirement Analysis and Architecture design.
• Requirements gathering and translation to technical specifications.
• Prepare Technical Design Document, Data Mapping, Implementation Plan and Unit Test plans and getting approval for the same.
• Development of Graphs/Psets using Ab Initio for ETL and creating UNIX shell scripts to integrate the purpose of a job.
• Involved in the creation of NDM setup to receive the file from external site to our NDM server and then copy to ETL server for ETL processing.
• Migration of code to higher environments.
• Created copy of tables in Teradata and granted access to the testers for testing in SIT and UAT environment.
• Provided KT and support during/post implementation.
• Monitoring and scheduling jobs in Production environment using Autosys.
• Prepared work order checklist, security peer document, validation document for udeploy build, created snapshot URL and created change request for the production Implementation.
• Run Book creation for the L1 &L2 support team.

Environment: Ab Initio, Autosys, oracle, Teradata SQL assistant, NDM, UNIX, LINUX, Windows 10, EME.

Confidential

Responsibilities:

• Involved with Client for Requirement Analysis and Architecture design.
• Requirements gathering and translation to technical specifications.
• Prepare Technical Design Document, Data Mapping, Implementation Plan and Unit Test plans and getting approval for the same.
• Development of Graphs/Psets using Ab Initio for ETL and creating UNIX shell scripts to integrate the purpose of a job.
• Involved in the creation of NDM setup to receive the file from external site to our NDM server and then copy to ETL server for ETL processing.
• Migration of code to higher environments.
• Created copy of tables in Teradata and granted access to the testers for testing in SIT and UAT environment.
• Provided KT and support during/post implementation.
• Monitoring and scheduling jobs in Production environment using Autosys.
• Prepared work order checklist, security peer document, validation document for udeploy build, created snapshot URL and created change request for the production Implementation.
• Run Book creation for the L1 &L2 support team.

Environment: Ab Initio, Autosys, Teradata SQL assistant, NDM, UNIX, LINUX, Windows 10, EME.

Confidential

Responsibilities:

• Involved with Client for Requirement Analysis and Architecture design.
• Requirements gathering and translation to technical specifications.
• Prepare Technical Design Document, Data Mapping, Implementation Plan and Unit Test plans and getting approval for the same.
• Development of Graphs/Psets using Ab Initio for ETL and creating UNIX shell scripts to integrate the purpose of a job.
• Involved in the creation of NDM setup to receive the file from external site to our NDM server and then copy to ETL server for ETL processing.
• Migration of code to higher environments.
• Created copy of tables in Teradata and granted access to the testers for testing in SIT and UAT environment.
• Provided KT and support during/post implementation.
• Monitoring and scheduling jobs in Production environment using Autosys.
• Prepared work order checklist, security peer document, validation document for udeploy build, created snapshot URL and created change request for the production Implementation.
• Run Book creation for the L1 &L2 support team.

Environment: Ab Initio, Autosys, Teradata SQL assistant, NDM, UNIX, LINUX, Windows 10, EME

Confidential

Responsibilities:

• Participate in business and system requirements sessions.
• Requirements gathering and translation to technical specifications.
• Development of Graphs/Psets using Ab Initio for ETL and creating UNIX shell scripts to integrate the purpose of a job.
• Prepare Technical Design Document, Data Mapping, Implementation Plan and Unit Test plans and getting approval for the same.
• Develop code and perform unit testing.
• Migration of code to higher environments.
• Provide PSO KT and Provide support during/post implementation.
• Monitoring and Scheduling jobs in production environment.

Environment: Ab Initio, CA7, DB2, Mainframe, UNIX, LINUX, Windows 7, EME.

Confidential

Responsibilities:

• Participate in business and system requirements sessions.
• Interact with client to elicit architectural and non-functional requirements like performance, scalability, reliability, availability, maintainability.
• Requirements gathering and translation to technical specifications.
• Prepare Technical Design Document, Data Mapping, Validation Plan and Unit Test plans and getting approval for the same.
• Develop code and perform unit testing.
• Migration of code to higher environments.
• Provide PSO KT and Provide support during/post Implementation.

Environment: Ab Initio, CA7, DB2, Mainframe, UNIX, LINUX, Windows 7, EME.

Confidential

Responsibilities:

• Participate in business and system requirements sessions.
• Requirements gathering and translation to technical specifications.
• Prepare Technical Design Document, Data Mapping, Implementation Plan and Unit Test plans and getting approval for the same.
• Develop code and perform unit testing.
• Migration of code to higher environments.

Environment: Ab Initio, CA7, DB2, Mainframe, UNIX, LINUX, Windows 7, EME.