PROFESSIONAL SUMMARY:

• Over 14+ years of Professional Consulting Experience in the United States in Business Analysis, Data Analysis, Development and Implementation of Software Applications in the field of Data warehousing/Data Mart, ETL, Data Migration, Joint Application Development/Rapid Application Development and Database Development in Unix/Linux/AIX/HP - UNIX/Solaris & Windows.
• More than 9+ years of experience in Ab Initio, Pentaho, Talend, Datastage & Informatica ETL Tools in a high-volume Data Warehouse / Data Mart environment for various clients.
• More than 7+ years in developing procedures, packages in PL/SQL with good knowledge in Oracle Developer 2000 and SQL*Loader
• Experience in providing High Level Design and Low Level Design of Process and Business Analysis
• Experience in using EME, Continuous Flows, Trillium and Data Profiler.
• Experience in using Oracle Databases, DB2 UDB, Sybase, SQL Server, RedBrick, Netezza and Teradata.
• Experience in working with Mainframe Data Files, COBOL Copybook, JCL, Assembly language.
• Experience with UNIX shell scripts, Autosys JIL scripts, XML and Perl Scripts.
• Highly adaptive to a fast paced team environment and with a proven ability to work in a team Environment and individually
• Have excellent communication and written skills

TECHNICAL SKILLS:

Operating System: HP-UX, UNIX, AIX, Red Hat Linux 5.0/6.0, Sun Solaris, Windows 3.1/95.98/ME/XP/NT/2000, MS-Dos

Database: Oracle9i/8i/8.0/7.x, SQLServer, MS-Access, Informix, Redbrick, Sybase, DB2

GUI s: Developer2000, Visual Basic 5.0/6.0, Crystal Reports 8

Database tools: SQL*Plus, SQL*Navigator, SQL*Loader, ODBC, TOAD, SQL Navigator VISIO, Erwin, Trillium v7.5

Languages: C, HTML, SQL, PL/SQL, Pro*C

ETL Tools: Ab Initio, Datastage, Informatica, Talend, Pentaho

Scripting: Unix Shell scripting (ksh, csh, bash), Perl, XML

Scheduler: Autosys, CA/7

PROFESSIONAL EXPERIENCE:

Confidential

ETL Consultant/Lead

Responsibilities:

• Conducted business requirement meeting to identify the changes, requirements.
• Developed ETL code as per requirements.
• Developed various SQL queries for validations & snapshot views
• Provided L1/L2/L3 Support for RDW SF AQSN, RDW SF BOOK and Loan Lender Delinquency
• Developed UNIX and Autosys JIL scripts.

Confidential - Rockville, MD

Responsibilities:

• Conducted business requirement meeting to identify the changes, requirements.
• Working closely with End-Users and Business Analysts to develop the Source-Target Mappings.
• Working on data validation processes and High Level Design for ETL jobs
• Developed Datastage Jobs for FMS, COD and PEPS modules.
• Assisted QA Team in integration testing.

Confidential - Englewood, CO

ETL Designer

Responsibilities:

• Create Source-Target Mappings and created ETL specification Document.
• Designed ETLjobs using Data Integrator for CPNIbased with ETL Specification Document
• Developed, tested and implemented Pentahojobs.
• Interacted with infrastructure team, Database DBA’s, end-users to identify resources needed in terms of servers, estimation of space required, retention period, cleansing process and also backup processes.
• Led teams both on-site and offshore, where responsibilities included in identifying the right resources and allotment of work and progress in status of work.
• Assisted in testing effort and the UAT effort
• Integrated all of the processes in UAT/PROD

Confidential - Herndon, VA

ETL Designer/Developer

Responsibilities:

• Developed, tested and implemented Ab Initio graphs.
• Interacted closely with Business Analysts to understand the business and develop Source to Target Mapping Documents.
• Designed and developed High Level and Detail Designs for the CCI Conversion/Transition
• Worked on data validation by developing process specific graphs.
• Developed Autosys jobs, execution.
• Assisted with the testing and the UAT effort. Also integrated the processes in UAT/PROD.
• Provided production Support in BOT run and TC2 rrun.

Environment: Ab Initio (GDE - 1.15), Datastage 8.1,Pentaho, DB2, SQL Server, UNIX, Shell Script, Oracle, Mainframes, Windows NT, Shell Scripts, Mastero.

Confidential

Database Engineer

Responsibilities:

• Developed the ETL Process along with High Level Design and Low Level Design.
• Developed UNIX wrapper scripts like file watcher, remote ftp process scripts.
• In addition to development of Ab Initio processes was responsible for overlooking workload of 3 developers and 1 tester.
• Worked on Netezza and developed nzsql for data retrieval from target databases and also use unload utilities for loading.
• Responsible for migration and implementation of project in QA and PROD environments.
• Involved in gathering requirements and created design documents and mapping documents.
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner.
• Created metadata queries which would help in restart and to find out any missing link conditions or disabled tasks in a workflow.
• Developed ETL jobs using Talend.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Involved in the Unit testing and System testing.
• Worked on bug fixes on existing Informatica Mappings to produce correct output.

Environment: Ab Initio, Talend, UNIX, Shell Script, Oracle, Netezza, Windows

Confidential

ETL Consultant

Responsibilities:

• Analyzed existing graphs developed by various developers
• Tuned existing graphs and in some cased redesigned some graphs for better peformance.
• Developed Generic graphs with conditional components.
• Reduced the number of formal parameters being used by the graphs and made the process more modular.
• Developed Autosys jobs for GL Data Mart as well as the run book
• Worked closed with business analyts in putting together a Business requirement document.
• Analyzed and developed JIL scripts for Autosys jobs.
• Developed various graphs as per the business rules provided.
• Developed generic graphs which either loaded the data or unloaded the data from the tables.
• Prepared Runbook/Runguide for the complete process from end to end.

Environment: Ab Initio (GDE - 1.13), Informatica, DB2, Autosys, PERL, JCS, Nettezza, Oracle, AIX, Windows NT, Shell Scripts.

Confidential

ETL Consultant

Responsibilities:

• Worked with closely with Business Analysts in Analysis for existing Information available.
• Developed the Transformations and Mapping Documents.
• Part of the team which designed and developed High Level and Detail Designs based on JCL and Assembly language.
• Provided suggestion for better process implementations which were implemented.
• Developed, tested and implemented Ab Initio graphs.
• Developed generic and also conditional components in Ab Initio graphs.
• Worked on Ab Initio Mainframe Data Gateway (MDG)
• Worked on implementing the CRC code calculation from C/Java into an Ab Initio process.
• Converted record layouts from EBCDIC to ASCII
• Worked on data validation by developing process specific graphs.
• Worked on UNIX Shell wrapper scripts.
• Developed unit test cases, Quality Assurance test plans
• Executed QA test plans and also worked on Autosys.
• Also worked on the Mainframe to validate the QA results with the data on the Mainframe.

Confidential

Sr. Application Developer/Team Lead

Responsibilities:

• Worked with closely with Business Analysts in Analysis for existing Information available.
• Developed the Transformations and Mapping Documents.
• Developed Design document for both High Level and Detail Design document for Best Address and Best Score ETL Process.
• Responsible for coordinating between management and team members and assigning tasks to team members.
• Worked with COBOL Copybook creating EBCIDIC and ASCII DML formats
• Worked on data validation by developing process specific graphs.
• Developed UNIX Shell wrapper scripts

Confidential - Phoenix, AZ

Sr. Application Developer

Responsibilities:

• Gathered and analyzed requirements by meeting business stakeholders and othertechnical team members prior to the design of ETL.
• Understanding High Level ETL Requirement specifications to develop LLD for type-I, SCD Type-II and Type III mappings and done rigorous testing for various test cases.
• Preparation of QA migration and PROD migration Documents after development and testing in Development environment and executed Quality Assurance testing.
• Developed complex mappings as per the requirement using almost all transformations and effectively used Debugger for identifying errors and resolving them.
• Have done Informatica performance tuning and query tuning.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Team leader who was responsible for the assignment of tasks for the team members, creation of Metrics reports, weekly status reports, preparation of project plan and quality related documents & migration documents etc.

Confidential, Manhattan, NY

Sr. ETL Programmer/Analyst - Consultant

Responsibilities:

• Working closely with IBM, Oracle, TIBCO, AXCIOM, KPI and Ab Initio regarding the continuous flows components, Identifying the best approaching in resolving various issues causing bottleneck for the ETL process.
• Worked with Project Manager/Ab Initio consultants in identifying the bottlenecks and developing solutions to overcome the issues.
• Also assisting Business Analysts in Data Analysis and also Transformations and Mapping Documents.
• Developed Informatica mappings for loading tables and transformations.
• Also redone the Informatica jobs in Ab Initio.
• Point of Contact for a team of 4 developers in developing a high level ETL and Detail design for the Complete ETL Process.
• In addition to the above, providing Ad-hoc solutions for unexpected issues.
• Responsible for coordinating between management and team members and assigning tasks to team members.
• Worked with COBOL Copybook creating EBCIDIC and ASCII DML formats
• Worked with the Data Profiler developing business validation rules for the required fields identified.
• Also developed Data Prep Graph, Data Validation Graphs and Delta Processing Graphs
• Worked on Continuous Flow in sending the payload in XML to the TIBCO Bus.

Confidential

Sr Ab Initio Developer Consultant

Responsibilities:

• Worked closely with Users and Business Analysts in gathering requirements from User Inputs, existing SSP, and Omnibus Systems to prepare System Requirement Specification Document for the MSL Project.
• Worked hands-on the mapping document and finalizing the Transformation rules for loading the EDW/MSL Central Repository Table data elements.
• Designed and developed high level ETL and detail design for the ETL Process.
• Worked on the Data Validation rules of various input data files through the generic conditioning graph ensuring the integrity of data used for processing based on the rules.
• Developed Omnibus Prep graph which gets the Data in EBCIDIC format and split the single input into various Data files like Policy-tab, Client-Tab, Vehicle, Vehicle Coverage, SSPX, Client Relation, Premium, Discounts which provide the inputs for the various graphs in MSL Project.
• Worked with COBOL Copybook creating EBCIDIC and ASCII DML formats
• Solely responsible for creating of the Policy Term Load Ready File (LRF), Vehicle Driver LRF, Vehicle LRF, Premium LRF, Policy, Vehicle, Driver Discounts LRF, Vehicle Driver LRF, Vehicle Coverage and Earned Premium LRF which are used to populate the Common Repository Tables.
• Worked with Enterprise Meta Environment (EME), as it is the mode of Version Control. Also worked in migrating from the DEV environment to IT/FAT environment.
• Provided Production Support to the EDW Production jobs on a rotation basis.

Environment: Ab Initio (Co-Op-2.13 GDE - 1.13.14), Data Profiler, Informatica 7, TrilliumOracle 10g, DB2 UDB, Solaris, PL/SQL, Windows NT, Shell Scripts, Mainframe, MVS, ISPF, VSAM, XML, Java, JSM, TIBCO

Confidential

Database Developer

Responsibilities:

• Analyzed the existing Shell/Perl Processes, which loads data into the Data Warehouse
• Worked with the Data Profiler to provide a detail analysis for required Data Input fields.
• Analyzed and tested the graphs for the Member-Rewrite and Dims Projects.
• Worked with Loader scripts to load data into the Data Warehouse.
• Developed Ab Initio graphs for the comparisons of data using various Ab Initio components based on the requirements specified.
• Added additional functionality to the existing Data Profiler graph and fine tuned the graph bringing the running time down.
• Worked in the Quality Analysis team.
• Prepared Test Cases, Quality Analysis and Documentation for all of the above.

Environment: Ab Initio (GDE - 1.11.15), Data Profiler RedBrick, Sybase, Netezza, Tandem, SQL, Solaris/Linux/Unix, DBArtisan 7.0, VISO, WINSQL, Unix Shell Scripts, Perl, Business Objects, AutoSys