SUMMARY

• Associated with Information Technology industry for more than 7.4 years incorporating both Waterfall and Agile methodologies. I have been primarily working with data - warehousing as well as database fields during this tenure.
• Involved in all phases of DW&BI projects involving Requirements Gathering, Analysis, Design, Development, Testing, Implementation and Support.
• Extensive experience in working with Abinitio as an ETL tool for implementing transformations and conditions.
• Worked on various Abinitio components like Reformat, Sort, Rollup, Dedup Sort, Normalize, Lookups, Input Table, Output Table, Input File, Output File, Partition Components etc.,
• Extensive knowledge in EME checkins, checkouts, command line interface, air commands.
• Well versed with Abinitio parallelism techniques and worked on Ab Initio Graphs using Data parallelism and Multifile System (MFS) techniques.
• Developed Abinitio graphs to fetch data from DB2, Oracle, Excel, Flat Files, XML files and Mainframe.
• Expertise in working on different schemas like Star, snow flake.
• Worked on different dimension models like SCD1, SCD2 and SCD3.
• Hands on experience in development of Data Warehouses/Data Marts using Abinitio Co>OP, GDE, Component Library, Oracle and UNIX for mainly Banking/Financial/Insurance industries.
• Experienced in interacting with EME Data store with several air commands.
• Knowledge about advance concepts of Abinitio like PDL and Metaprogramming.
• Designed and encouraged use of Reusable graphs in Abinitio to promote reusability, eliminate coding redundancy and ease maintenance of Version control.
• Good knowledge in UNIX Shell scripting and scheduling tool like Tivoli and Control-M.
• Responsible for Debugging and Troubleshooting Abinitio graphs.
• Developed various UNIX shell wrappers to run various Abinitio jobs.
• Expertise in creating/developing Test cases, Test scenarios using standard and modular approach.
• Experience in testing/validating the Source, Stage and Target (End-to-End) data systems.
• Experienced in managing critical issues under stringent timelines during Production support.
• Proven abilities in improving Application performance, capacity planning.
• Diagnosed production issues to ensure a timely recovery and minimal impact to our business users.
• Excellent ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Expertise in the entire Software Development Life Cycle (SDLC).
• Planning data loads and implementing slowly changing dimensions (SCD).
• Hands on experience in creating Logical Data Models (LDM) and converting into Physical Data Models (PDM) and working on different types of Facts and Dimensions tables.
• Working experience in an offshore/onshore model and driven to learn new technologies.
• Motivating, mentoring and assisting the team members to face the challenge to meet team’s objective and client’s expectations.
• A strong communicator and team player with a proven track record of handling responsibilities effectively. Giving a great importance for time and ethics.

TECHNICAL SKILLS

• ETL Tool: Abinitio
• Operating System: UNIX, Windows, Linux
• Languages: C, C++, UNIX Shell Scripting, SQL, PL/SQL
• IDE Visual: C++ 6.0 (Threading, MDI, Dlls)
• Scheduling tool: Tivoli, Control - M
• Configuration Management: VSS, SVN
• DBMS: Oracle9i, Oracle 10g, SQL Server

PROFESSIONAL EXPERIENCE

Senior Abinitio ETL Developer

Confidential, Chicago, IL

Responsibilities:

• Responsible for application design, development and project maintenance of applications that are critical to the enterprise.
• Worked in the Data Management Team on Data Extraction, Data Cleansing and Data Validation.
• Created Ab Initio graphs that transfer data from various sources like Oracle, flat files and CSV files to the Oracle database and flat files.
• Worked on Multi file systems with extensive parallel processing.
• Implemented Lookups instead of joins, in-memory sorts to minimize the execution times while dealing with huge volumes of data.
• Extensively used Partitioning Components: Broad Cast, partition by key, partition by round robin and De-partition components like Concatenate, Gather and Merge in Ab Initio.
• Implemented Transform Components such as Dedup Sorted, Filter by Expression, Join, Normalize, Reformat, Rollup and Scan Components and created appropriate XFRs and DMLs.
• Used Lookup Transformation in validating the warehouse customer data.
• Performed bulk data load from multiple data source (legacy systems) to Oracle.
• Provide technical assistance for developing and enhancing Abinitio graphs.
• Create wrapper scripts and job schedule for sequential execution during Production deployment.
• Working on migration projects including the pre-analysis of the requirement and implementation.
• Coordinating and analyzing the existing business for the projects involved and documented client requirements, business needs and project objectives.
• Working closely with various Technical Support teams, conversion teams and Business Teams.
• Scheduling and deploying jobs to both UAT and production.
• Monitoring the daily scheduled jobs to perform data load and handling incidents and problems.
• Coordinating with both onsite and offshore teams and providing technical support if required to perform daily activities to other team members

Skills Used: Abinitio, UNIX shell scripting, Oracle, TOAD,PL/SQL, XML,XSD,DTD, Control-M.

Senior ETL Developer

Confidential, Chicago, IL

Responsibilities:

• Design of ETL system for movement of claims from hierarchical to relational format.
• Abinitio graph design and development (Includes XML data parsing, PDL, Meta programming), the design includes the code driven using metadata to make it more generic and less rework/ change request once moved to production.
• Understand the business requirements, analyze the source systems.
• Performed all code Check-in and Check-out operations with EME.
• Developed generic Abinitio graphs using psets to minimize development and maintenance costs.
• Development of UNIX shell scripts for Process automation.
• Involved in decreasing application run times significantly by using performance tuning.
• Assigned phases and set up check points to complex graphs having large number of components to protect against failure, avoid deadlock and easy recovery of failed Abinitio graphs.
• Preparation of ETL detailed design document and reusable process related documents.
• Responsible for the overall quality and timeliness of the deliverables.
• Involve in Unit testing and documented test cases.
• Developed a process to execute Abinitio graphs/scripts in serial or parallel mode with full restartability.
• Provide support for all the incidents, data integrity issues and any defect arise in during the stabilization period of a particular interface.
• Provide technical assistance for developing and enhancing Abinitio graphs.
• Create wrapper scripts and job schedule for sequential execution during Production deployment.
• Working on migration projects including the pre-analysis of the requirement and implementation.
• Coordinating and analyzing the existing business for the projects involved and documented client requirements, business needs and project objectives.
• Working closely with various Technical Support teams, conversion teams and Business Teams.
• Scheduling and deploying jobs to both UAT and production.
• Monitoring the daily scheduled jobs to perform data load and handling incidents and problems.
• Coordinating with both onsite and offshore teams and providing technical support if required to perform daily activities to other team members
• Performing daily duties such as updating status charts, providing daily status to customer management team. Ensured timely and accurate communications sent at all levels and regularly communicate to senior management regarding the status of specific application updates.

Skills Used: Abinitio, UNIX shell scripting, PUTTY, Oracle, TOAD, PL/SQL, Control-M

Abinitio Application Developer

Confidential

Responsibilities:

• Key resource for the team in Requirement Analysis, designing, developing, implementing and maintaining project from the ETL background.
• Create a design and framework for the generic AbInitio Code to handle the multiple and ever expanding list of data files coming from various sources.
• Designed various projects and successfully implemented in production with no defects.
• Good Experience in communicating with Business Users and responsible for preparing the ETL Mapping document based on the requirement and objective.
• Extensive support given to various teams including QA during development and deployment of AbInitio objects.
• Created ETL mapping Documents for different applications.
• Improved the performance level of various graphs by implementing different tuning methods.
• Creating and scheduling of Control-M jobs for Abinitio process.
• Optimizing performance by analyzing, ETL workflow and query patterns.
• Development of UNIX shell scripts.
• Involve in Unit testing and documented test cases.
• Involved in tracking and resolving the issues.
• Reviewing and optimizing the code to enforce standards.
• Preparation of ETL detailed design document and reusable process related documents.
• Dealing with processing logic, job scheduling or performance issues
• Developed UNIX shell wrapper scripts to send emails, to archive files etc.
• Prepared Application Handbook for future reference of Production support team.

Skills Used: Abinitio (GDE 3.0), UNIX Shell Scripting, PUTTY, Oracle, Tivoli, Control-M.

Abinitio Application Developer

Confidential

Responsibilities:

• Involved in Requirement Gathering, functional specification, High Level Design, Technical Design and Preparation of various modules.
• Responsible for end-to-end design comprising the HLD, LLD and other process designs.
• Involved in Performance tuning Graphs and Plans in Abinitio.
• Worked on Abinito Graph components such as Join, Reformat, FBE, Rollup, Run, Redefine format, Fuse, Sort, dedup sorted, datasets and database components.
• Solving of Abinitio Dependency errors.
• Jobs monitoring in both PROD and Test environments.
• Created tables and views in database.
• Worked on creation of various Test plans and Test data validation.
• Coding, testing, debugging, documenting and implementation of AbInitio Graphs.
• Developed parametrized graphs (Generic) for maintainability and for rapid development and enhancements.
• Responsible for converting History data to Staging ETLs through generic graphs that extract and stage data per reporting period basis.
• Developed UNIX wrapper scripts to accept parameters and scripts for sending mail to support team and reset the table status.
• Responsible for preparing Detailed Design documents for the projects.

Skills Used: Abinitio (GDE 2.1.4 and GDE 3.0), UNIX Shell Scripting, Oracle, PL/SQL, Tivoli.

Jr. Application Developer

Confidential

Responsibilities:

• Involved in Requirement Gathering, functional specification, High Level Design, Technical Design and Preparation of various modules.
• Developing the module based on the business requirement.
• Worked on creation of various Test plans and Test data validation.
• Providing technical assistance for developing and enhancing the code.
• Involved in performance tuning of the code.
• Worked on table creation based on HLD and LLD models.
• Developing high level and low level Visio design documents.
• Worked on performance tuning of the code.

Skills Used: IDE Visual C++, VSN, Oracle9i