SUMMARY:

• Over 7 years of IT experienceas developer, designer and support personnel in Development, Maintenance, Integration & Migration of Extract transfer and Load (ETL) processes using the Ab Initio Software .
• Experience in data modeling, data management, data warehousing, data transformation, and metadata and reference data management .
• Strong working knowledge of Data Warehousing techniques and Concepts experience including ETL processes, Star Schema/Snowflake Schema .
• Experience with various Abinitio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and Multi - file System (MFS) techniques.
• Worked with multiple ETL sources extracted and transited data from existing production system to test, QA and production environment
• Experienced in developing UNIXshell wrapper scripts to run Ab Initio graphs. Practical experience with working on multiple environments like production, development and testing.
• Thorough understanding of the issues involved in mappings, development and integration of a software product.
• Provided 24 x 7 support for the projects during go-live and post production support activities.
• Extensive work experience in identifying performance bottlenecks and tuning Ab Initio Load graphs and SQL queries for optimized and better performance.
• Well versed in application of Data Cleansing in the Enterprise Data Warehouse.
• Experience in data profiling and data quality.
• Well worked with ORACLE 10g, 11g and Shell Scripting.
• Used Toad to verify the counts and results of the graphs.
• Good experience in providing ETL Effort duration estimates with the WBS (Work Breakdown Structure) activities involved.
• Team player and self-starter with strong interpersonal and communication skills with an ability to work in a team.

TECHNICAL SKILLS:

PROGRAMMING LANGUAGES: SQL, C, PL/SQL, COBOL

ETL Tools: Ab-initio GDE 1.15,3.1.5

Co >Opsys (3.0 to2.15),: Informatica

OPERATING SYSTEMS: SUN Solaris 8.x, HP 11i, Linux, Unix, Windows, MAINFRAMES MVS

DATABASE AND TOOLS: Oracle 9i/8i/7.x, SQL Server 6.5/7.0, Oracle, Toad, DB2

SHELL & UTILITIES: Korn, BASH

DESIGN TOOL: MS-VISIO

TRAINED SKILLS: Mainframes (COCOL, JCL, VSAM & CICS)

PROFESSIONAL EXPERIENCE:

Confidential, NC

Senior Ab initio ETL Consultant

Environment: UNIX (OS), SQL, Ab Initio (GDE: 3.0, Co>Op: V3-0, Conduct>IT Plans), Operation Console (Job Scheduling tool).

Responsibilities:

• Analyzed business process workflows and developed ETL procedures to move data from source to target systems.
• Extracted source data using Ab initio from various source systems such as mainframes, OLTP databases, Unix flat files, XMLs.
• High level project architecture design, effort estimation and impact analysis.
• Currently handling the tasks of Support & Development, Code Migration & Support, Change Management & Implementation Support.
• Work allocation, mentorship, capability development and related activities.
• Review the code & design document created by team and suggesting changes for continuous improvement of team's deliveries.
• Utilized lookup and update strategy transformations to lookup values from different tables and update slowly changing dimensions.
• Extensively used Ab Initio Debugger to debug the code and fix the CRs.
• Extensive exposure to various complex techniques involved in Ab initio design and development like Compiled Transforms, Reusable Datasets, Parameter Definition Language (PDL), Meta programming, Component Folding, XML processing through Web Services, Multiple Layout data processing from various source systems like mainframes, OLTP databases, Unix flat files, XMLs.
• Basic understanding of Business Rules Environment (BRE), Application Configuration Environment (ACE), Hadoop Framework and GPFS.
• Helped & Led Offshore development team in realizing designed ETL technical specifications.
• Worked as a team member in support side and involved In developing. Now working as onsite coordinator.

Confidential, Foster city, CA

Ab initio ETL Consultant

Environment: AbInitio (GDE 3.1.5), EME, Oracle11g, SQL, PL/SQL, Autosys, UNIX

Responsibilities:

• Working as ETL Developer in understanding the requirements of the End Users/Business Analysts and developing applications for ETL Process using Ab Initio process.
• Participated in business, Detail design and Technical specification documentation for Client’s standards, procedures and naming conventions.
• Involved in data quality, source to target mappings, applying various validations and business rules associated with ETL processes.
• Working closely with the Clients and the Business partner of the clients.
• Understanding Client requirements and providing functional insights.
• Providing the Technical solutions for the business requirements.
• Planning for all the phases of the project and tracking the status of the project at each phase.
• Issue resolution/ Risk Mitigation and status reporting of the project activities.
• Developed ETL code using Ab Initio Tool to load data from cross platforms into ODS and BDW Tables where the data will be extracted for reporting purpose.
• Configured graph parameters, sandbox parameters, project Psets and environment variables for Production/Development and performance tuning for load graph process.
• Testing involves both Unit & Integration Testing.
• Lead an onshore/offshore team and Responsible for guiding less experienced team members.
• Supported Testing Team in providing data, loading the Data in Test Environment, provided SQL’s for testing the Test cases.
• Worked in Scrum & Agile Methodology Environment.
• Well versed with various Ab Initio parallelism techniques, implemented Ab Initio graphs using Data parallelism and multi-file (MFS) techniques.
• Played major role as point of contact in tracking issues and communicating them to vendors, management and stakeholders. Involved in preparing BRD's (Business Requirement Documents) documents for the new code rollout.

Confidential

Ab initio Developer

Environment: AB-INITIO GDE 1.14, CO>OP 2.14, EME, HP UNIX, Oracle, SQL Server

Responsibilities:

• Constructing the ETL code using the Abintio GDE which involved reading the EBCIDIC, Flat files and applying complex transformations on them to load to the target tables .
• Automation of Ab initio graphs using Autosys Jobs .
• Post production support and ticket resolution within the warranty period.
• Improvising the existing process by performance tuning of the graphs.
• Testing - unit testing & integration testing.
• Created few user defined functions as per requirements.
• Responsible for overseeing the Quality procedures related to the project.