PROFESSIONAL SUMMARY:

• I have 7 years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various Data Warehousing and Software Applications.
• Over five years of Data Warehouse experience as a developer, designer and analyst in designing and developing of Extract transfer and Load (ETL) processes using the AB INITIO Software
• Strong knowledge in Dimensional modeling like Star Schema and Snowflake Schema.
• Experience in Data Profiling.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processes using Ab Initio.
• Experience with Ab Initio Co>Operating System, application tuning and debugging strategies. Proficient with various AB Initio Parallelism and Multi File System technique.
• Experience with various Ab Initio components such as Join, Rollup, Concat, Gather, Interleave, Dedup Sorted, Merge, Scan, Partition, Validate, FTP etc.
• Experience in various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and MFS techniques.
• Used Ab Initio as an ETL tool to pull data from source Systems,Cleanse,Transform and load data into databases.
• Experience in designing and implementing Ab Initio EME Metadata projects.
• Worked with Continuous Components and XML Components in Ab Initio.
• Extensively used Ab Initio EME data store/sandbox for version control, code promotion, and impact analysis.
• Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server, and MS Access.
• Good exposure to SQL, PL/SQL stored procedures, Triggers and Packages.
• Experience in UNIX Shell Scripts including Korn Shell Scripts, Bourne Shell Scripts.
• Good working knowledge writing UNIX Shell scripts, SQL and PL/SQL queries for ETL process.
• Good Knowledge in designing the Logical and Physical Modeling for Dimensional Model using best Data modeling practices like Kimball & Inman Methodologies.
• Experience in working with various Heterogeneous Source Systems like Oracle, MS SQL Server, Terra data, DB2 and Flat files.
• Knowledge in Transformation rules management using Business Rules Engine ( BRE )
• Experience in Teradata SQL Assistant and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, Exposure to T pump on UNIX/Windows environments and running the batch process for Teradata CRM.
• Involved in a upgrade from V2R5 to V2R6.Implemented many efficiencies in present processing utilizing many of the performance enhancements in this upgrade.
• Experience in debugging and implementing various techniques in tuning the graphs to improve the performance.
• Experience in using EME for version controls and dependency analysis.
• Knowledge in using Lean project management/Lean software development.
• Having experience in coordination with Onsite and Offshore teams.
• Clear and thorough understanding of business processes and workflow.
• Worked in waterfall as well as Agile methodology.
• Effective Team Player with excellent quantitative, analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

ETL Tools: Ab Initio (GDE 1.15, Co>Operating System 2.15), Informatica

Database: Oracle 10g/9i/8i/7i, Teradata 2R6.0/5.0, MS SQL Server 2000, DB2

Scheduling & Reporting Tools: Autosys, EME, Cognos, Business Objects

Operating Systems: Windows 2000/XP/NT, A/X, Sun Solaris5.9, Red Hat Linux

Data Warehousing: OLTP, OLAP, Normalization, Facts, Dimensions, Star Schema, Snow Flake Schema

Data Modeling: Erwin

Programming Languages: C, SQL, Java, PL/SQL, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Collierville, TN

Ab initio Developer

Responsibilities:

• Responsible for analyzing and understanding mapping tech .xls for the business requirements and make code changes.
• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Partition by round robin, reformat, rollup, join, scan, normalize, gather, merge etc
• Involved in estimation activity for development efforts
• Involved in Establish and/or continuously improve upon development guidelines, standards and procedures
• Designed and Developed various Ab Initio Graphs and business rules using Ab Initio function
• Worked on Business rule engine to create/generate xfr’s
• Developed SQL scripts for TeraData Using TeraData SQL Assistant
• Developed and Troubleshooted Data load for TeraData using FAST Load, Multi Load, T Pump Techniques
• Responsible for loading configuration data from dev environment to QA and then to prod.
• Responsible for Designing and developing shell scripts (wrapper) to validate data.
• Responsible for writing SQL’s in SQL Developer to validate if the data load was correct.
• Designed and Created various Ab Initio Multi File System’s (MFS) to run graphs in parallel
• Design and development of Ab Initio load graphs to load tables in Oracle.
• Documenting of complete Ab Initio Graphs.
• Involved in unit testing of the Ab Initio graphs.
• Involved in meetings to gather information and requirements from the business.
• Written SQL scripts with .Sql extensions like Joins which will be used in Database Components of Ab Initio to extract the data from different source tables and to load the target table using Update DB and Load DB table components with the support of dbc file in graphs.
• Responsible for fully understanding the source systems, documenting issues, following up on issues and seeking resolutions.
• Prepared the Detailed Design Document for the all the modules required for development.
• Confirm the field mapping to the new data warehouse from the old data warehouse is identified for which the one - to-many and many to one fields are properly matched and resolved.

Environment: Ab-Initio 1.15 GDE, CO-OP 2.15, EME, ORACLE 10g, Teradata 13, Erwin 5.0, Rational Clear Quest WebV-7.0, UNIX Shell Scripts.

Confidential, Reston, VA

Ab initio Developer

Responsibilities:

• Preparation of technical specification for the development of Ab Initio Extraction, Transformation and Loading (ETL) graphs to load data into various tables in Data Marts.
• Developed complex Ab-Initio XFRs to derive new fields and solve various business requirements.
• Used Ab Initio built in components: Reformat, redefine, FTP, Input file, Output file, Join, Sort, Partition by Key, Gather, Normalize.
• Generated configuration files (.CFG) using korn shell script, DML specifies the record format with delimiters which are used in components for building graphs in Ab Initio
• Responsible for validating the graphs against the pre defined ETL design standards.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re usable graphs.
• The data in ADW database is extracted, Transformed and loaded into Data mart using Ab Initio graphs.
• Various Ab Initio Commands such as m ls, m cp, m mv and m db were used extensively to operate with multifiles.
• Responsible for the Dimensional data modeling and populating the business rules using mappings into the repository for Metadata management.
• Performance tuning of Ab Initio load processes, participating in various data cleansing and data quality exercises.
• Maintained warehouse Meta data, naming conventions, and warehouse standards for future application development.
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes.
• Provided production support by monitoring the processes running daily 24/7.

Environment: Ab Initio (GDE 1.15, CO>Operating System, 2.15.1), Oracle 10g, SQL Server 2005, UNIX Shell Scripts, AutoSys 4.5.1 and Clear Case.

Confidential, Waukegan, IL

ETL Ab Initio Developer

Responsibilities:

• Primary production support for all the Batch Jobs.
• Involved in scheduling Batches through ESP, monitoring and supporting them.
• Implemented re start ability UNIX shell scripts when there are batch jobs dependent on other
• Implemented Ab-Initio configuration and set up well-tuned environments for Production Development & Testing
• Automated ETL process using UNIX shell scripting for Production, Testing and development environment
• Tuned the Graphs by removing unnecessary Sorts, used Lookup files, to enhance the performance
• Monthly and weekly refresh ETL processes were automated using custom UNIX shell scripts
• Designed Parallel Partition Ab-Initio Graphs for a high volume data warehouse
• Implemented the Parallel application by replicating the components and processing modules into number of partitions
• Involved in the building and migration process
• Extensively worked using Multi-file system, which gives the user the ability to centrally control the distributed data files and they provide the scalability and the kinds of access patterns that require parallel applications
• Involved in Ab-Initio Graph Design and Performance tuning to Load graph process
• Created batch process using Fast Load, Unix Shell and Teradata SQL to transfer cleanup and summarize data
• Developed and automated control validations for the ETL process to appropriately tie the source and target data
• Responsible for developing Ab-Initio ETL processes for Client, Dimensions and Fact table loading

Environment: Ab-Initio 1.14 GDE, CO-OP 2.14, CVS-Version control, ORACLE 9i, Teradata 2R6.0, Erwin 5.0, UNIX (SunOS 5.9), SQL, SQL*Loader, Mainframe, Windows 2000.

Confidential, Tulsa

ETL Ab Initio Developer

Responsibilities:

• Implemented Ab-Initio configuration and set up well-tuned environments for Production Development & Testing
• Designed and deployed Ab-Initio ETL graphs for ODS and DSS data warehouse by studying the business requirements from the functional design document and from the business users
• Developed ETL process to extract data from multiple sources like SQL server2000, Oracle tables and load Teradata Warehouse Fact and Dimension tables
• Extracted, transformed and loaded data from operational data sources into target Oracle database.
• Responsible for data validation and verification of business transformation rules.
• Designed and developed generic Ab Initio graphs to transform the data using Ab Initio built-in components i.e. Reformat, Partition, Rollup and join.
• Tuned the Graphs by removing unnecessary Sorts, used Lookup files to enhance the performance
• Automated Monthly and weekly refresh ETL processes using custom UNIX shell scripts
• Implemented a 8 and 12 way Multi-file system that is composed of individual files on different nodes that are partitioned and stored in distributed directories
• Designed Parallel Partition Ab-Initio Graphs for a high volume data warehouse
• Involved in Ab-Initio Graph Design and Performance tuning to Load graph process

Environment: Ab-Initio 1.13 GDE, CO-OP 2.13, EME, ORACLE 8i/9i, Teradata 2R5.0, Autosys, Cognos, Erwin 5.0, UNIX (IBM AIX 5 L v5.1), SQL, SQL*Loader, DB2, Windows 2000.

Confidential, VA

Abinitio Developer

Responsibilities:

• Created the Sandboxes in Development and as well as in QA environment using the EME.
• Developed the graphs using the GDE, with components partition by round robin, partition by key, rollup, sort, scanning, dedupsort, reformat, join, merge, gather, concatenate component.
• Developed Ab Initio graphs for Data validation using validate components.
• Involved in monitoring Ab Initio jobs using AB report options
• Divided the Graph into Phases and created checkpoints to avoid Deadlocks and also involved in Testing and debugging of the Graphs.
• Implemented Lookups, In-memory Joins and Rollups to speed various Ab Initio graphs.
• Wide usage of Lookup files while getting data from multiple sources and size of data is limited.
• Modified the AB INITIO components parameters, utilize data parallelism and thereby improve the overall performance to fine tune the execution times.
• Using Validate components like, Check Order, Compare Records, Validate records, Tested, debugged, and checked the data records.
• Wrote Tivoli Maestro Schedule scripts to schedule the Ab Initio graph.
• Heively used Perl Scripts, Unix Shell scripting for writing SQL execution scripts in Data Loading Process.
• Involved in Quality Assurance and Quality Auditing
• Defined, developed, and maintained an automation/regression Testing harness
• Involved in Data cleansing Auditing
• Involved in writing Unit Test script and unit Tested graphs as per the script.
• Database testing is performed using TOAD.

Environment: Ab Initio (GDE 1.13, Co>Operating System 2.13), Oracle 8.1.7.4, DB2, Sybase, MS-Access,Erwin 3.5.2, Business Objects Suite (Supervisor, Designer), SQL, PL/SQL, SQL *Loader,Solaris8,Unix Shell Scripts, Windows NT/2000.