SUMMARY:

• ETL Developer with 6+ years of experience in implementing ETL Data Warehousing applications for Medical & health Insurance, Auto & Home Insurance and Credit reporting 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 / Language Details: Unix Shell Scripting (Korn),SQL, PL/SQL,Cs

Databases: Oracle 9i,10g & SQL server

Operating Systems: UNIX AIX/Sun Solaris/HP, Microsoft Windows X/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.
• 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
• Involved in performance testing of graphs by running the schedules with prod volumes and monitoring the system performance.
• Developed UNIX scripts in Korn Shell environment to automate specific load processes and stored procedures using PL/SQL.

Technical Environment: Ab-Initio (GDE 3.2.3.9.x/3.2.1.6.x Co>Operating System 3.x/2.15), Oracle (Toad), DB2, Autosys 4/R11, UNIX shell scripting (Korn/Bash), HP ALM 11.0,

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.

Technical 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)

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.

Technical 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)

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.

Technical 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)

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.

Technical Environment: Oracle (Toad), UNIX shell scripting