SUMMARY

• Over 3 years 8 Months of professional IT experience in Business Analysis, Design, Development and Implementation of various client server and decision support system environments with focus on Data Warehousing, Business Intelligence and Database Applications.
• In my 3 years 8 Months of experience, worked in Ab Initio Consulting with Data mapping, Transformation and Loading from Source to Target Databases in a complex, high volume environment.
• Extensively worked on several ETL Ab Initio assignments to extract, transform and load data into tables as part of Data Warehouse development with high complex Data models of Relational, Star, and Snowflake schema.
• Expertise and well versed with various Ab Initio components such as like Partition, De - partition, Database, Datasets, Transform, Sort, Join, Rollup and Miscellaneous.
• Experience in Data Extraction, Data Migration, Data Integration, Data Testing and Data Warehousing using Ab Initio.
• Well versed with various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data, Component, pipeline parallelism and Multi File System (MFS) techniques.
• Configured Ab Initio environment to connect to different databases using DB Config, Input Table, Output Table, and Update table Components.
• Experience in using EME for version controls, impact analysis and dependency analysis.
• Extensive experience in Korn Shell Scripting to maximize Ab-Initio data parallelism and Multi File System (MFS) techniques.
• Experience in providing production support to various Ab Initio ETL jobs and developing various UNIX shell wrappers to run Ab Initio and Data base jobs.
• Developed various UNIX shell scripts to run Ab Initio and Data base jobs. Good experience working with very large databases and Performance tuning.
• Good Experience working with various Heterogeneous Source Systems like Oracle, DB2 UDB, MS SQL Server, Flat files and Multi Files.
• Very good understanding of the several relational Databases such as Oracle and DB2. Wrote several complex SQL queries using sub queries, join types, temporary tables, OLAP functions etc.
• Experience in DBMS Utilities such as SQL, PL/SQL, TOAD, SQL*Loader.
• Able to interact effectively with other members of the Business Engineering, Quality Assurance, Users and other teams involved with the System Development Life cycle
• Expertise in preparing code documentation in support of application development, including High level and detailed design documents, unit test specifications, interface specifications etc.
• Excellent Communication skills in interacting with various people of different levels on all projects and also playing an active role in Business Analysis.

TECHNICAL SKILLS

ETL Tools: Ab Initio (GDE 1.13, 1.14, Co>Operating system 2.14, 2.15)

RDBMS: Oracle 8i/9i/10g, SQL Server, DB2, MS Access.

DB Tools: SQL*Loader, import/Export, TOAD

Languages: C, C++, SQL, PL / SQL, XML, Korn Shell Scripting.

Platforms: Sun Solaris 7.0, HP-UX UNIX, AIX, Windows NT/XP/2000/98/95.

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Ab Initio Developer

Responsibilities:

• Participated in ETL development process using Ab Initio.
• Performed analysis on the extracted data which is transformed and loaded into the Data Warehouse, to achieve quality and consistency.
• Involved in design, development and Implementation of the process..
• Developed graphs to take process huge sets of input data.
• Used Ab Initio partition components to achieve parallel data transformations and filtering.
• Responsible for the performance tuning of the ETL graphs.
• Prepared and implemented data verification and testing methods for the data warehouse.
• Implementing transformation rules using Ab Initio components.
• Created graphs for performing aggregation and joins on the records.
• Improvised the existing Ab Initio ETL process by identifying bottlenecks in the graphs and modifying them to make better use of the resources by utilizing the capabilities of the tool.
• Worked in close coordination with business analysts and reporting groups in designing aggregate business rules.
• Used Ab Initio components like Input file, Output file, Reformat, Join, Sort, Partition By key, Normalize, Input Table, Output Table, Update Table and Gather Logs for developing graphs.
• Developed Shell Scripts for Batch Processing, start and end scripts for invoking the AbInitio graphs.
• Developed an ETL process to update the ODS database with the new and changed records as a result of Transactions at the end of each month.
• Prepared Unit and Integration testing plans. Involved in Unit and Integration testing using the testing plans. Involved in UAT with user groups.
• Performed complex queries involving large data volumes of data. Some of these queries run parallel against the same table to improve the performance.
• Developed UNIX Korn shell wrapper scripts to accept parameters and scheduled the processes using ESP Scheduling.

Environment: Ab Initio Co >Op 2.15, GDE 1.14,Oracle 10g, Toad, SQL, PL/SQL

Confidential

Ab Initio Developer

Responsibilities:

• Participated in ETL development process using Ab Initio GDE 1.13.
• Developed generic graphs to take process all reference files.
• Involved in various documentations like Technical Design Document, Mapping Documents and review those documents.
• Developed a graph to post all the exceptions occurred during ETL process to the People Soft Server.
• Developed various Ab Initio Graphs for data cleansing using Ab Initio functions like is valid, is error, is defined, string * functions, date *functions.
• Involved in creating unit test plans, unit test cases, unit test scripts and unit test reports to verify accuracy of programs and the interdependent relationship of programs and systems.
• Involved in preparation and implementation of data verification and testing methods.
• Gathered Business requirements and Mapping documents.
• Multiple graphs were built to unload all the data needed from different source databases by configuring the dbc file in the Input Table component.
• Developed the graphs using the GDE, with components partition by round robin, partition by key, rollup, sort, scanning, dedupsort, reformat, join, merge, gather, concatenate components.
• Used components like run program and runsql components to run UNIX and SQL commands in AB Initio. Also used the components like filter by expression, partition by expression, replicate, partition by key and sort Components.
• Working with Departition Components like Gather, Interleave in order to departition and Repartition the data from Multi File accordingly.
• Performing transformations of source data with Transform components like Join, Match Sorted, Dedup Sorted, Denormalize, Reformat, Filter-by- Expression.
• Create Summary tables using Rollup, Scan & Aggregate.
• Deploy and test runs the graph as executable k-shell scripts in the application system.
• Modified the AB Initio components parameters, utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Used Data Parallelism, Pipeline Parallelism and Component Parallelism in Graphs, where huge data files are partitioned into multi-files and each segment is processed simultaneously.

Environment: Ab Initio Co >Op 2.15, GDE 1.13, Oracle 10g, SQL, PL/SQL.

Confidential

Ab Initio Developer

Responsibilities:

• Multiple graphs were built to unload all the data needed from source databases by configuring the dbc file in the Input Table component.
• Developed and Unit tested Ab Initio graphs using GDE for Extraction, Transformation and Loading of data from source to target.
• Extensively used Database and Dataset components like Input file, Input table, Output table and transform components like Join, Rollup, Scan, Filter by expression, Reformat and other components like Merge, Lookup, Dedup and Sort.
• Implemented component, pipeline and data parallelism using Ab Initio for ETL process.
• Extensively involved in performing EME dependency analysis and maintained version control using EME.
• Used Partition components like partition by expression, partition by key, etc., to run the middle layer processing parallel.
• Extensively used various inbuilt transform functions like string substring, string lrtrim, is null string lpad, string index, lookup functions, date functions, error functions.
• Effectively used Multi file system (MFS) to execute the graph parallel.
• Worked on improving performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups, in memory sort in joins and rollups to speed up various Ab Initio graphs and optimum maxcore parameter for memory optimization.
• Extensively worked in the UNIX environment using Shell Scripts.
• Worked on scheduling using ESPScheduling to schedule the jobs.

Environment: Ab Initio Co >Op 2.15, GDE 1.13, Oracle 10g, SQL, PL/SQL.