SUMMARY

• Over Seven years of experience of using Ab Initio tool in developing strategies for ETL (Extraction, Transformation and Loading) mechanism in complex and high volume Data Warehousing projects.
• Strong development skills includes ability to work through the entire development life (SDLC) cycle from gathering requirements through implementation, development, production, support and documentation of the complete project.
• Worked extensively in the GDE (Graphical Development Environment) configuring, connecting, and testing the components to produce executable flow graphs on Unix environment.
• Proficient with various Ab Initio Data Cleansing, Parallelism, Transformation and Multi File System techniques.
• Expert in writing UNIX Shell Scripts including Korn Shell Scripts, Bourne Shell Scripts.
• Extensively wrote Wrapper scripts for job scheduling by using Korn shell.
• Practical experience with working on multiple environments like production, development, testing.
• Expertise knowledge in Dimensional Data Models using Star schema and Snow - Flake schema used in relational, dimensional and multidimensional modeling, creation of Fact and Dimension Tables, OLAP, OLTP and thorough understanding of Data-Warehousing concepts.
• Working knowledge of Oracle Database Administration (DBA) and Strong SQL and PL/SQL, SQL Loader, Query Optimization skills in programming.
• Ability to quickly grasp new concepts and apply software methodologies as per business needs.
• Excellent interpersonal skills and professional communication skills and have worked extensively in a team oriented environment with a strong desire to achieve specified goals.
• Extensively used Ab Initio EME Data store/Sandbox for version control, code promotion, and impact analysis.
• Provided the 24x7 support for production and testing daily, monthly and weekly data refresh and worked with fixing complex/critical production problem.
• Hands on experience with large scale volume of data marts.
• Worked with deploying CPU heavy ETL process and tuning the complex Ab Initio process.
• Worked with testing team and developed Unit test plan, test cases for component, data, stress test, regression test etc.
• Have solid experience on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus.
• Experienced in using the Oracle SQL* Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.

TECHNICAL SKILLS

Database: Oracle, DB2, SQL Server, Teradata

Languages: SQL, PL/SQL

Operating Systems: Windows XP/Vista/7, UNIX (HP-UX, AIX, Sun Solaris), MS-DOS, Linux

Data Warehouse Tools: Ab Initio (Co-Op - 2.15, 2.16 and 3.0, GDE 1.15, 1.16 and 3.0), EME, Informatica (7.0/8.0)

Internet: HTML, PHP, ASP, JavaScript, VBScript

GUI: VB 6.0,Developer2000

Scripting: UNIX, Korn shell, JavaScript

Utilities: Control-M, CA7, TWS

PROFESSIONAL EXPERIENCE

Confidential, Northbrook, IL

Ab Initio Developer

Responsibilities:

• Involved in analysis of existing Ab Initio Graphs, Korn Shell Scripts, and deployment procedures and documenting them.
• Participated in Software Requirements Specifications (SRS) meetings with various downstream businesses, technical teams.
• Developed number of Ab lnitio Graphs for the ETL processes based on business requirements using various Ab lnitio components like Partition by Key, Partition by round robin, reformat, join, rollup, gather, replicate etc.
• Involved in gathering and documenting requirements from Business users.
• ETL performance enhancement using data-parallelism (m-file), component-parallelism and pipeline-parallelism, in-memory sorting.
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
• Redesigned the existing graphs and documented all the new and enhancement requests.
• Identified critical fields by analyzing cross field and functional relationships along with the pattern matching techniques and using dependency analysis through Ab Initio EME web interface and using some custom prepared Ab Initio Generic Graphs.
• Ab Initio graphs are created to search for required pattern data in a dataset using regular expressions.
• Involved in the estimation of project timelines and completed all the tasks in the estimated timeline.
• Involved in preparing project documentation outlining the whole process and project reports.
• Created UNIX scripts to generate DML expressions for database files from tables DDL, DML using m db: gendml utility.
• Created test plans and test cases and responsible for unit testing.
• Created and automated a comparison process to compare the results generated by the old application (Mainframes) and the new application and captured the unmatched records.
• Analyzed the issues with the unmatched records and provided code fix to the problems.

Environment: Ab Initio (Co-Op - 3.0, GDE - 3.0), TWS Maestro,Ab InitioData Profiler, UNIX, SQL, EME and Windows, Oracle 10g, Teradata, SQL Server.

Confidential, Memphis, TN

Ab Initio Developer

Responsibilities:

• Analyzed Functional Requirements Interacted with End user and Source Programmers for business understandings.
• Lead complete cycle of SQL to Ab Initio conversion projects. Developed graphs to replicate the SQL, PL/ SQL code and implemented in production.
• Created mapping documents based on the requirements from Business Analysts.
• Prepared detailed design document for the developers to develop the graphs.
• Unloaded the data from various source systems flat files (fixed length, delimited), xml's and from various Databases.
• Developed Ab Initio graphs to unload the data from various source systems and applied the transformations on data according to business rules and load the data into target database.
• Performing transformations of source data with Transform components like Join, Dedup Sorted, Normalize, Reformat, Filter-by-Expression, Rollup etc.
• Worked on Multi file systems to implement the data parallelism.
• Developed Generic graphs for the error validations.
• Used EME for Version Control.
• Code reviewed for the other developers and made performance improvements.
• Performed unit testing, system testing and followed all the deployment process.

Environment: Ab Initio (Co-Op - 2.15, GDE - 1.15), Control-M,Ab InitioData Profiler, UNIX, SQL, EME and Windows.

Confidential, Parsippany, NJ

Ab Initio Developer

Responsibilities:

• Involved in System Study & Business Requirements Analysis & Documentation.
• Developed and supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Ab Initio and provide technical support and hands-on mentoring in the use of Ab Initio.
• Worked with various Components like Reformat, Join, Filter-By Expression, Sort, Rollup, Scan etc., to transform the data.
• Replicate operational data into staging area, Transform and load data into warehouse tables using Ab Initio GDE and responsible for automating the ETL process through scheduling and exception-handling routines.
• Database Query Optimization and I/O tuning techniques have been used for performance enhancements.
• Generated database configuration (.dbc) files for source and target databases, which are used in Ab Initio graphs.
• Developed graphs to extract Historical and Incremental Data.
• Responsible for extracting daily text files from ftp server and historical data from DB2 Tables, cleansing the data and applying transformation rules and loading to staging area.
• Responsible for creating parameterized graphs, which are used to create common DMLs, XFRs during data transformation phase prior to creating load ready files.
• Divided Ab Initio graphs into phases with checkpoints to safeguard against failures.
• Extensively written and used UNIX shell scripts for wrapper scripts.
• Developed various graphs for data cleansing using Ab Initio functions like is valid, is error, is defined and various string and math functions.
• Developed Ab Initio ETL process and interpret the transformation rules for all target data objects and develop the software components to support the transformation as well as estimating task duration.
• Responsible for consolidating customer records from various sources to create master customer list.

Environment: Ab Initio (Co-Op - 2.16, GDE - 1.16), Autosys,Ab InitioData Profiler, UNIX, SQL, EME and Windows.

Confidential, Columbus, OH

Ab Initio Developer

Responsibilities:

• Involved in analyzing business needs and document functional and technical specifications based upon user requirements with extensive interactions with business users.
• Involved as designer anddeveloperfor Enterprise data warehouse.
• Created the mini-specs for different applications.
• Making automate the development ofAb Initiographs and functions utilizing the Meta data from EME.
• Developed variousAb Initiographs to validate using data profiler, comparing the current data with previous month data, applying the AMS standards.
• Used DifferentAb Initiocomponents like partition by key and sort, Dedup, rollup, scan, reformat, join and fuse in various graphs.
• Written DML expressions for Mainframe data (COBOL copy book).
• Used checkpoint and phasing to avoid deadlocks and to re-run the graph in case of failure.
• Also used components like run program and run sql components to run UNIX and SQL commands in Ab Initio.
• Performing transformations of source data with transform components like join, match sorted, Dedup sorted, reformat and filter-by- expression.
• Wide usage of lookup files while getting data from multiple sources and size of the data is limited.
• Involved in project promotion from development to UAT and UAT to promotion.
• Involved in Production implementation best practices.
• Implemented Data Parallelism unitizing MFS in the graphs, which deals with data, divided into segments and operates on each segment simultaneously through theAb Initiopartition components to segment data.
• Used phases and checkpoints to avoid deadlocks inAb Initiographs to facilitate recovery after failures.
• Using modification of theAbInitio EME to house the required redaction Meta data.
• UsedAb InitioData Profiler to analyze & validate source data and Data types, and also to determine join datasets by analyzing cross functional relations.
• Has used Control M for scheduling jobs in Development Environment.
• Used different EME air commands in project promotion like air tag create, air save, air load, air project export etc.

Environment: Ab InitioGDE 1.15, Co>Operating System 2.15, Control-M,Ab InitioData Profiler, UNIX, windows,TERADATA, Teradata SQL Assistant v2r6, Oracle, DB2, SQL Server.

Confidential, St. Louis, MO

Ab Initio Developer

Responsibilities:

• Translated business-reporting requirements into data warehouse architectural designs and analyzed source and target data models and made necessary changes.
• Implemented Ab Initio configuration and set up well-tuned environments for Production and Development.
• Responsible for creating Generic Graphs using theAb Initiocomponents for ODS and DSS environment.
• Involved in the complete ETL process life cycle.
• Develop preprocessing and validation graphs.
• Involved in populating huge data from ODS, OLTP systems.
• Develop, implement, and maintain data feeds into and out of the data warehouse using the Ab Initio.
• Prepare business and technical documentation.
• DB2 was utilized as source system.
• Production support on weekly rotation basis to monitor daily and weekly jobs.
• Create and maintain Slowly Changing Dimension (SCD) TYPE I and TYPE II table's database.
• Output from the file directly stored into the reporting application tables using Load DB Table.
• Create Data and Type validation graphs for performing data cleansing.
• Interpret the transformation rules for all target data objects and develop the components to support the transformation.
• Create graphs for Data standardization and Data integration into mart.
• Performance tuning of Ab Initio ETL graphs and processes using various parallelism techniques, proper memory usage, planned phasing and layout.
• Performance testing of ETL routines.
• Perform various Database operations like create, drop and update tables and views.
• Developed Korn shell scripts for file processing.
• Utilize various Ab Initio components like Lookup, Join, Rollup and Reformat to process data.
• Analyze and develop production schedule for ETL processes in the system.
• Study relationship between tables to determine dependencies for individual jobs schedule.
• Scheduling of Shell Scripts was done by Autosys.
• Developed JIL Files for running Autosys Jobs.
• Set up development, QA & Production environments.
• Migrated jobs from development to QA to Production environments.
• Created Process Flow diagrams using MS VISIO.

Environment: Ab Initio (Co-Op - 2.15, GDE - 1.15), Korn Shell, Oracle 10g, Teradata, SQL Server, TWS Maestro, PVCS.