SUMMARY

• Abinitio ETL Developer with 7+ years of experience in implementing ETL Data Warehousing applications for Medical & health Insurance, Auto & Home Insurance, Retail and Telecom sectors.
• Key skills include Ab - Initio, Unix shell scripting, Oracle PL/SQL & Autosys scheduler.
• Other secondary skills include Informatica Power Center 9.x, MSBI.
• Involved in designing (low level)/developing Ab-Initio graphs for ETL projects built from-scratch.
• Actively involved in Design, Development, Testing, Maintenance and Support for Software Applications in Data Warehouse on Unix environment. Developed strategies for ETL (Extraction, Transformation and Loading) mechanism using Ab-Initio(Key Skill) in GDE (Graphical Development Environment) to produce executable graphs. Used Autosys Scheduler to schedule job flows for end to end processing.
• Participated in the data modeling discussions in designing the conceptual and physical data models.
• Comprehensive knowledge on Unix Shell scripting (Korn) and PL/SQL Programming. Proficient in client/server application development using Oracle 10g/9i/8i, PL/SQL, Stored Procedures and functions.
• Good knowledge on Data Warehousing concepts like Dimensional Data Modelling, Star schema, Snow-Flake schema, creation of Fact and Dimension Tables, OLAP, OLTP, etc.
• Well-organized, quick learner, self-motivated, team player with experience in interacting with end-users utilizing effective verbal and written communication skills. Good listener, desire to excel, meet deadlines and enjoy a fast-paced environment being other qualities.

TECHNICAL SKILLS

Technology / Programming Languages: Ab initio (GDE 3.0.1.14 Co>Operating System 3.0,2.14) Informatica Power center 9.3

Technology / Language Details: Unix Shell Scripting (Korn),SQL, PL/SQL,C

Databases: Oracle 9i,10g & SQL server

Operating Systems: UNIX AIX/Sun Solaris/HP, Microsoft Windows XP/2003/2000/9i/NT

Tools: / Packages: TOAD, SQL*Plus, Autosys Scheduler

Domain / Functional Area: Medical Insurance, Telecom and Retail sectors

PROFESSIONAL EXPERIENCE

Confidential

Abinitio Developer

Responsibilities:

• Participated in the KT sessions of the RRDDW project and understood the aim, requirements and architecture of the project.
• Understood the review cycle of the project. Analysed and reviewed the release requirements and Solution Design with the Designers so as to have proper understanding of the requirements.
• Performed the necessary changes as per the release requirements, performed unit testing and deployed the code to QA and UAT environments.
• Transformed and conditioned the non-formatted data into standardized format using Transform components like Reformat, Filter By Expression, Join and Sort components in Ab-Initio graphs. Worked on Multi File Systems in Ab-Initio to enable multiple partitions on different nodes so as to process data simultaneously.
• Worked on performance enhancement of graphs using lookups, in-memory joins, parallelism concepts, etc.
• Developed UNIX scripts in Korn Shell environment to automate specific load processes and stored procedures using PL/SQL.
• Proactively given support to level 1 and level 2 support groups for Ab-Initio jobs by developing hot fixes for failed jobs, monitoring the processing time for critical graphs and validating the data at the source and target ends.

Environment: Ab-Initio (GDE 3.0.3.9.x/2.15.6.x Co>Operating System 3.x/2.15), Oracle (Toad), DB2, Autosys 4/R11, UNIX shell scripting (Korn/Bash)

Confidential, North Carolina, Durham

Abinitio Developer

Responsibilities:

• Analysed and reviewed the Business Requirements Specification and Solution Design with the Designers so as to have proper understanding of the requirements.
• Created Sources definitions from Flat Files/Oracle DB and imported/created Targets definitions from the respective databases and created reusable Transformations.
• Transformed and conditioned the non-formatted data into standardized format using Transform components like Reformat, Filter By Expression, Join and Sort components in Ab-Initio graphs. Worked on Multi File Systems in Ab-Initio to enable multiple partitions on different nodes so as to process data simultaneously.
• Worked on complex Ab-Initio XFR’s to derive new fields and solve various business requirements. Developed generic graphs to extend a single functionality to many processes and reduce redundant graphs.
• Worked on performance enhancement of graphs using lookups, in-memory joins, parallelism concepts, etc.
• Developed UNIX scripts in Korn Shell environment to automate specific load processes and stored procedures using PL/SQL.
• Proactively given support to Application Support Group for Ab-Initio jobs by developing hot fixes for failed jobs, monitoring the processing time for critical graphs and validating the data at the source and target ends.
• Participated in regular project status meetings.

Environment: Ab-Initio (GDE 3.0.3.9.x/2.15.6.x Co>Operating System 3.x/2.15), Oracle (Toad), Autosys 4/R11, UNIX shell scripting (Korn/Bash)

Confidential, Omaha, NE

Ab-Initio Developer

Responsibilities:

• Acted as Ab-Initio developer in developing the End-to-End flow from sources to staging to Data mart.
• Analyze and review the Business Requirement Specification docs.
• Developed graphs for processing different kinds of claims with different processing logic.
• Prepared Low level design to understand the design for easing up the implementation.
• Developed UNIX shell scripts to cater to several project needs such as generating batch scripts, archival & cleanup processes, load summary reports to ensure load integrity and many more.
• Used Autosys scheduler to schedule jobs and defined conditions for them. Developed Oracle stored procs for any intermediate need of the project.
• Provided Level 3 Support to analyze, debug & troubleshoot failures and providing instructions on further proceedings and also provide hot fixes in case of issues.

Environment: Ab-Initio (GDE 3.0.3.9.x/2.15.6.x Co>Operating System 3.x/2.15), Oracle (Toad), Autosys 4/R11, UNIX shell scripting (Korn/Bash)

Confidential, Bloomington, IL

Ab-Initio Developer

Responsibilities:

• Analyzed and reviewed the Business Requirements Specification and Solution Design with the Designers so as to have proper understanding of the requirements.
• Created Sources definitions from Flat Files/Oracle DB and imported/created Targets definitions from the respective databases and created reusable Transformations.
• Transformed and conditioned the non-formatted data into standardized format using Transform components like Reformat, Filter By Expression, Join and Sort components in Ab-Initio graphs. Worked on Multi File Systems in Ab-Initio to enable multiple partitions on different nodes so as to process data simultaneously.
• Worked on complex Ab-Initio XFR’s to derive new fields and solve various business requirements. Developed generic graphs to extend a single functionality to many processes and reduce redundant graphs.
• Worked on performance enhancement of graphs using lookups, in-memory joins, parallelism concepts, etc.
• Deployed the Ab-Initio graphs as shell scripts and developed wrapper scripts which call the graphs, PL/SQL procedures sequentially to accomplish the requirements.
• Developed UNIX scripts in Korn Shell environment to automate specific load processes and stored procedures using PL/SQL.
• Proactively given support to Application Support Group for Ab-Initio jobs by developing hot fixes for failed jobs, monitoring the processing time for critical graphs and validating the data at the source and target ends.

Environment: Ab-Initio (GDE 1.13, Co>Operating System 2.13), Oracle (Toad), UNIX shell scripting, Control-Ms

Confidential

ETL Tester

Responsibilities:

• Involved majorly in developing UNIX shell scripts like wrappers, start up scripts, archival and cleanup script, mailing scripts for project usage.
• Created test cases to test the Oracle stored procedures, packages and functions to check the data validity from sources to target Database.

Environment: Oracle (Toad), UNIX shell scripting, Control-M

Confidential

Developer

Responsibilities:

• Analyzed and reviewed the Business Requirements Specification and Solution Design with the Designers so as to have proper understanding of the requirements.
• Created Sources definitions from Oracle source tables to Target Datamart tables
• Transformed the data using Oracle PLSQL stored procedures, packages, functions, cursors, etc and implemented the business functionality to load the transformed data into Datamart.
• Worked on performance enhancement of stored procedures using bulk collection methods, tuning the SQL queries, etc.
• Developed UNIX scripts in Korn Shell environment to automate specific load processes and stored procedures using PL/SQL.
• Proactively given support to Application Support Group for jobs by developing hot fixes for failed jobs, monitoring the processing time for critical graphs and validating the data at the source and target ends.

Environment: Oracle (Toad), UNIX shell scripting, Control-Ms