EXECUTIVE SUMMARY

• Over 7 Years of IT experience in Designing, Development, and Maintenance of ETL solutions by using AbInitio and Datastage.
• 7+ Years of experience in AbInitio and more than Two years of experience in datastage.
• Strong knowledge on EME, admin activities, plans, Co Op System, GDE, BRE, ACE and Op Console.
• Having knowledge on Hadoop technologies.
• Strongly worked on Air Commands, parallelism, multi file systems and PDL.
• Developed UNIX Shell scripts for running the pre/post processes and automated the scripts for cleansing the data.
• Expertise in working with relational databases such as Oracle, DB2, Teradata and SAP BW.
• Extensively made use of all components in abinitio viz., Reformat, Join, Roll up, Scan, Redefine, Sort, Filter by expression, Lookup etc…
• Used different stages of Datastage Designer likeLookup, Join, Merge, Filter, Transformer, Sort, Remove Duplicates, Etc.
• Identified business needs, evaluate business and technical alternatives, recommended solutions and participated in their implementation.
• Experienced in Performance tuning techniques for ETL Graphs and jobs.
• Experience in resolving on - going maintenance issues, bug fixes and monitoring the ETL Graphs and Jobs.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Experience in automation of the ETL Processes by using scheduling tool Autosys.
• Interacted in all testing phases and with the customers and supporting them during customer acceptance testing.
• Worked for Customer Interface Team to resolve customer issues related to Technology Packages.
• Proficient in understanding Business processes and translating them into requirements.
• Good Experience in Abinitio and UNIX.
• Good knowledge in ETL tools Datastage and Reporting tool such as cognos.
• Self-Starter and comfortable in high intensity and challenging work environment.
• Good communication and technical skills, Interpersonal relations, hard working and result oriented as on individual or in team.
• Ability of learning new concepts quickly, working well under pressure and communicating ideas clearly and effectively.
• Excellent decision making skills with a positive approach.
• Dedicated and highly ambitious to achieve personal goals as well as the organizational goals.

TECHNICAL SKILLS

ETL Tools: AbInitio, Datastage

Scripting Languages: Shell Scripting.

Programming Languages: SQL, PL/SQL, Java and XML.

Operating Systems: UNIX, Windows.

Database Tools: Oracle, Teradata, DB2 and SAP ECC,BW.

Other Tools/Packages: Cognos, Win SCP, MS Visio, MS Office and Autosys.

PROFESSIONAL EXPERIENCE

ETL-AbInitio Developer

Confidential

Responsibilities:

• Developed the graphs for extracting, transforming and loading data into data marts/data warehouse by using Abinitio for vision application.
• Used EME for version controlling by check in and out and performed admin activities.
• Designed reusable routines and shell scripts for file validations.
• Used Performance tuning techniques for ETL Graphs.
• Strongly worked on air commands, parallelism, multi file systems and PDL.
• Extensively worked on mapping skills one format to different formats.
• Developed UNIX Shell scripts for running the pre/post processes and automated the scripts for graphs and cleaning the space.
• Extensively Working on enhancements, Changes of existing solutions.
• Evaluate business and technical alternatives, recommended solutions and participated in their implementation.
• Documenting the ETL process flow for better maintenance and analyzing the process flow.
• Working on production issues, fixing them and documenting for future reference.
• Used different components in abinitio like Join, Reformat, Merge, Aggregator, Sort, Lookup, Etc.
• Extensively worked with files and oracle DB.
• Helped scheduling abinitio jobs in autosys and to maintain logs in log directories.
• Created shell scripts to perform validations and run jobs on different instances (DEV, TEST and PROD).
• Provided integration and post production support for the ETL and reporting systems.
• The Graphs were scheduled, monitored by using Autosys.
• Providing 24/7 production support.

Environment AbInitio, UNIX AIX, Oracle, Pl/Sql Developer, WIN SCP, Windows, Microsoft Visio and Microsoft Office.

ETL Migration (AbInitio-Datastage) Developer

Confidential

Responsibilities

• Used IBM Datastage Designer for FSR ETL Application to develop jobs for extracting, cleaning, transforming and loading data into data marts/data warehouse.
• Used different stages of Datastage Designer likeJoin, Merge, Filter, Copy, Aggregator, Transformer, Sort, Data Set, Funnel, Lookup, Remove Duplicates, Modify, Change Data Capture, Change Apply, Surrogate Key, Column Generator, Row Generator, Etc.
• Worked with Join, Look up (Normal and Sparse) and Merge stages.
• Worked with sequential file, dataset, file set and look up file set stages.
• Created shell scripts to perform validations and run jobs on different instances.
• DataStage jobs were scheduled, monitored, performance of individual stages was analyzed and multiple instances of a job were run using Datastage Director.
• Supporting the production on 24/7.

Environment Datastage, Unix, Oracle, Teradata, DB2, SAP ECC&BW, Windows, Microsoft Visio and Microsoft Office.

ETL-AbInitio Developer

Confidential

Responsibilities

• Developed the graphs for extracting, transforming and loading data into teradata by using Abinitio.
• Used EME for version controlling by check in and out and performed admin activities.
• Designed reusable routines and shell scripts for file validations.
• Used Performance tuning techniques for ETL Graphs.
• Strongly worked on GDE, Co Op system, Air Commands, parallelism, multi file systems and PDL.
• Extensively worked on mapping skills one format to different formats.
• Developed UNIX Shell scripts for running the pre/post processes and automated the scripts for graphs and cleaning the space.
• Evaluate business and technical alternatives, recommended solutions and participated in their implementation.
• Documented the ETL process flow for better maintenance and analyzing the process flow.
• Working on testing issues, fixing them and documenting for future reference.
• Used different components in abinitio like Join, Reformat, Merge, Aggregator, Sort, Lookup, Etc.
• Extensively worked with oracle, teradata and db2.
• Created shell scripts to perform validations and run jobs on different instances (DEV, TEST )
• Provided integration and post production support for the ETL.

Environment AbInitio, Unix, DB2, Oracle, Teradata, Teradata Sql Assistant, Pl/Sql Developer, Windows, Microsoft Visio and Microsoft Office.

ETL-AbInitio Developer

Confidential

Responsibilities

• Developed the graphs for extracting, transforming and loading data into teradata by using Abinitio.
• Used Performance tuning techniques for ETL Graphs.
• Strongly worked on GDE, Co Op system, Air Commands, parallelism, multi file systems and PDL.
• Extensively worked on mapping skills one format to different formats.
• Developed UNIX Shell scripts for running the pre/post processes and automated the scripts for graphs and cleaning the space.
• Evaluate business and technical alternatives, recommended solutions and participated in their implementation.
• Documented the ETL process flow for better maintenance and analyzing the process flow.
• Working on testing issues, fixing them and documenting for future reference.
• Used different components in abinitio like Join, Reformat, Merge, Aggregator, Sort, Lookup, Etc.
• Extensively worked with oracle and db2.
• Created shell scripts to perform validations and run jobs on different instances (DEV, TEST )
• Provided integration and post production support for the ETL.

Environment AbInitio, Unix, DB2, Oracle, Pl/Sql Developer, Cognos, Windows, Microsoft Visio and Microsoft Office.