SUMMARY

• 7 years of IT experience working in Data Warehouse/Data Mart design, development, UNIX/SQL, Data Analysis and documentation.
• About 5 years of working experience in Ab Initio ETL Development/ Testing in High volume environment.
• Expert in using Ab Initio ETL tool for implementing extensive transformations and conditions.
• Working knowledge on BRE.
• Extensive knowledge in EME, checkins, checkouts, command line interface, air commands and Dependency analysis.
• Experienced in System Administration, Analysis and Testing Implementation of client server applications.
• Expertise in Rational Unified Process (RUP) Best Practices methodology, Use Cases, Software Development Life Cycle (SDLC) processes and Object Oriented Design Technologies
• Scheduled ETL jobs using Autosys.
• Hands on experience in development of Data Warehouses/Data Marts using Ab Initio Co>OP, GDE, Component Library, Oracle and UNIX for mainly Banking/Financial/Credit Card industries.
• Experience in Data Warehousing concepts like Dimensional Modeling/ Kimball Methodology, Star Schema, Snowflake Schema and ETL.
• Worked with Teradata utilities like Fast Load, MultiLoad, etc.
• Worked in PVCS and EME Data store for source control maintenance and analyzing dependencies within and between various graphs.
• Experience in migrating applications from one EME Datastore to another.
• Experienced in interacting with EME Data store with several air commands.
• Hands on experience with code implementations on mainframe and unix.
• Well versed with various Ab Initio parallelism techniques and implemented number of Ab Initio Graphs using Data parallelism and Multi File System (MFS) techniques
• Experience in integration of various data sources such as flat files, ASCII, EBCDIC files, XML files, DB tables etc.
• Also experienced in working with Mainframe Data Files, COBOL Copybook
• Well versed in UNIX shell, Perl and wrapper scripts.
• Reasonable knowledge in Stored Procedures, Functions, Triggers, Indexes and Cursors using SQL and PL/SQL.
• Excellent analytical, interpersonal and communication skills with aptitude to assimilate new technologies.
• Excellent ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS

ETL Tools: Ab Initio Co>Os & EME 2.14,2.15, GDE 1.14,1.15, Informatica 6.0

DSS/Reporting: Business Objects 5.x/6.x/XI, (Infoview, WebI), Crystal Reports

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

Tools: & Languages: TOAD, Autosys, VB, SQL, PL/SQL, C, TSO Mainframe

Designing Tools: Microsoft Visio 2000, Erwin 4.1

Operating System: Windows 95/98/2000/NT, UNIX (Sun, SCO, AT&T), MS DOS

Methodologies: Dimensional modeling of STAR, SNOWFLAKE.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Abinitio Developer

Responsibilities:

• Worked as Abinitio developer and involved in documentation, analyzing the system.
• Designed and developed various Ab initio graphs
• Developed JILs for the project and deployed those in DEV, SIT, UAT and Production environments.
• Written wrapper scripts for archiving and cleaning up.
• Involved in major part of testing the code and debugging the issues.
• Preformed all code Check - in and Check- out operations with EME..
• Developed generic graphs using psets to minimize development and maintenance costs.
• Involved in decreasing application run times significantly by using performance tuning.
• Assigned phases and set up checkpoints to complex graphs having large number of components to protect against failure, avoid dead lock and easy recovery of failed graphs.
• Migrated jobs from development to QA to Production environments.
• Analyzed the systems, met with users and business units in order to refine the requirements.

Created functions, procedures, packages, triggers in PL/SQL, utilized bulk load, bulk collect, dynamic SQL. Used SQL*Loader to load data from flat files. Designed small application schemas in Oracle.

• Responsible for the overall quality and timeliness of the deliverables.
• Created UNIX shell scripts for FTP, merge and send success/failure mails .
• Implemented Data cleansing and created DML for the XML files to be used in Ab-Initio.
• Created test cases for various scenarios for unit testing.
• Developed a process to execute graphs/scripts in serial or parallel mode with full restartability. This process was used to execute production jobs on daily/Weekly/Monthly schedules.

Environment: AB Initio GDE version 1.15.11, Co>Operating System 2.15, Oracle10G, Autosys, SQL Plus, SQL Loader, SVN.

Confidential, VA

Sr.Abinitio Developer

Responsibilities:

• Involved in requirement study, analysis and design of the system.
• Involved in defining programming standards, database design, program development and finally testing and implementing the system
• Used EME for checking and checkout for graphs and also maintains graph versions.
• Designed and developed the Ab Initio graphs to standardize the data validation
• Written JIL scripts for the corresponding graphs and deployed in the Dev Environment.
• Coordinated the Development and Implementation of Strategic Plans

Environment: Ab Initio, Oracle, Autosys, Excel-2003

Confidential, CT

Sr.Abinitio Developer

Responsibilities:

• Worked as a senior developer on the complex ETL development projects with multiple team members.
• Worked as lead for the creation of all design review artifacts during project design phase, facilitate design reviews, capture review feedback and schedule additional detailed design sessions as necessary.
• Involved in the requirements definition and analysis in support of the extensive data analysis.
• Designed and developed Logical and Physical Models using Erwin.
• Developed demo graphic reports on daily production loads to forecast the data behavior.
• Process tuned existing Ab Initio processes for efficiency using parallel components, lookup files and MFS concepts.
• Developed process for efficiently testing changes to the current production systems.
• Developed UNIX shell scripts and extensively involved to automate the entire load process through Autosys
• Profiled the data for Business Users using Ab Initio Data Profiler and developed data analysis reports and helped Business Analysts to write the requirements.
• Created different types profiling reports to perform functional dependency analysis.
• Involved in discussions with BA’s and Business users in building business rules for the ETL applications.
• Created Batch processes using Fast Load,FastExport, Mload, BTEQ, Unix Shell and
• Teradata SQL to transfer cleanup and summarize data
• Teradata Utilities to load data into Incremental/Staging tables and then move data from staging into Base tables
• Integrated lot of common environment APIs into the ETL applications to increase reusability of the code and reduce development resource hours.
• Developed extensively easy to understand tech-spec to make it easy for coding by the offshore team.
• Worked on creating Application Support Guide, Implementation Plans, Trace Matrix and Application SLAs.
• Designed lot of Unix API’s to generate dynamic XFR’s and dynamic DML’s.
• Written various shell wrappers to in corporate Ab Initio graphs and shell script calls.
• Designed and developed Tivoli Work Scheduler scripts as database outage friendly by using global resources.
• Implemented lot of defensive programming techniques to avoid customer impact issues by detecting them ahead of time in the process.
• Worked with high volume of data files on Windows and NT platforms.
• Good exposure with Mainframe EBCDIC format files to handle with Ab Initio.
• Team member for Design, Coding and Implementation
• Written various shell wrappers to in corporate Ab Initio graphs and shell script calls
• Design, Development, and Enhancement of new functionalities
• Defined production support methodologies and strategies.
• Logging in the different issues related to the development phase.

Environment: Ab Initio GDE 1.16.1, Co>Operating System 2.16, AIX UNIX, Sun Solaris UNIX, IBM Mainframes, Oracle, Teradata, SQL Plus, SQL Loader, Toad.

Confidential, Pleasanton CA

Ab initio Developer

Responsibilities:

• Translated requirements into system solutions and developed implementation plan and schedule.
• Defined and documented the technical specification designs of all programming applications.
• Ensured that proper development processes and standards are followed, conducted code reviews.
• Used various Programs, conditional components and transform functions, sub graphs, most components like datasets, filter, join, and sort, Partition etc and used lookups.
• Responsible for developing data extracts and transformation programs.
• Extensively used Ab-Initio GDE editor - Record Format editor, Key Specifier Editor, Transform Editor, Expression Editor, and Package editor.
• Extensively used Unix shell scripting, general file manipulations, ftp etc
• Took care of Performance Tuning and loading tasks.
• Created and configured Ab-Initio scripts and wrapper scripts as Autosys jobs. Reviewed the status of the jobs running.
• Interacted with Oracle, DB2, TSO, Spufi, AIX, Teradata (MultiLoad, FastLoad, FastExport, TPump, and BTEQ), XML (Read XML component using exemplar as well as XSD’s) with normalizations and complex transformations down the flow, Queues (Continuous flows, MQ subscribe, MQ Publish), HL7 formatted inputs (custom format) etc.
• Participated in various stages of SDLC meetings on behalf of ETL, to facilitate refined definition of specs and requirements, and suggested correction spec docs etc, which many times facilitated in fruition of projects I handled.

Environment: Ab-Initio GDE 1.15, Ab-Initio Co>Operating System 2.15, Oracle 10g, SQL,PL/SQL, Oracle, AutoSys, DB2 MVS 390, TSO, Spufi, Teradata V2R6.2, UNIX AIX, UNIX Korn Shell, BO(Crystal Reports), Hyperion system 9 BI+ IR studio, Windows XP.

Confidential, GA

Ab Initio Developer

Responsibilities:

• Developed UNIX shell scripts to automate the Data Load processes to the target Data warehouse Developed mapping documents for Inbound/Outbound Interfaces.
• Migrated the Ab Initio Graphs from Development to testing and testing into Production environments.
• Administered Ab Initio Repository using Air utility command reference.
• Developed graphs to Process In bound XML files using AB INITIO.
• Developed Ab Initio graphs for purging the data from used Flat files in the process.
• Generated korn shell scripts to monitor the Data warehouse processes.
• Created the DML files to In Bound/ Out Bound Ab Initio Graphs
• Designed and developed snow flake schema structures & which will map the data from Legacy databases to Oracle database.
• Developed Ab Initio graphs for 13 out bound interfaces.
• Handled complex data formats, which included Vector type of record format coming as a source from Mainframe as part of Acquisitions Transaction and Maps using AB INITIO Normalize and later on De-normalize component.
• Developed the Ab Initio graph to handle the 2000 character Header and Trailer file.
• Troubleshoot and created automatic scripts/generators.
• Checked the accuracy of the data loaded into Teradata and assured the linkage of keys on the various tables.
• Created Sandboxes and Projects for different group of users on Repository.

Environment: Ab Initio, Business Objects 5.1, Oracle 8i, SQL Server 2000, Teradata V2R4, Tpump, UNIX, Solaris and Windows 2000.

Confidential

Developer

Responsibilities:

• Developed and implemented processes that apply business rules to the customer and revenue data.
• Worked with different Sources such as Oracle, SQL Server, Excel and Flat files.
• The data that was obtained from various sources were fed into the staging area in Teradata.
• Enterprise wide templates were created for handling SCD, Error handling etc.
• Sometimes to prepare Design document gathering requirements from the clients.
• Worked in resolving production issues to correct the code or data or to enhance the performance.
• Customized Multi load scripts in Teradata to load data into Teradata tables as part of the Ab Initio post session task.
• Extensively used Ab Initio built in string, math, and date functions.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Generated Configuration files, DML files, XFR files specifies the Record format, which are used in components for building graphs in Ab Initio.
• Used Enterprise Meta Environment (EME) for version control, Control-M for scheduling purposes.
• Designed and developed complex Aggregate, Join, Router, Look up and Update strategy transformation based on the business rules.
• Created Dynamic lookup transformation to increase the session performance.
• Responsible for migrating the folders or mappings and sessions from development to production environment.
• Created Business Objects metadata repository, selected tables from the warehouse catalog, created facts, attributes, lookup table, relationship definition, reporting objects, metrics, cubes, reports, filters.
• Designed and developed Business Object universes for report generation.
• Involved in resolving the loops, cardinalities, contexts and check the integrity of the universes
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality
• Created UNIX shell script to automate the stop/start the information servers.
• Created and used UNIX shell script in the pre/post session Ab Initio process to create/drop index and collect statistics of the warehouse tables.
• Created different types of reports, such as Master/Detail, Cross Tab and Chart.
• Used various Teradata Index techniques to improve the query performance
• Responsible for loading data into warehouse from different sources using Multiload and Fastload to load millions of records.
• Performed tuning and optimization of complex SQL queries using Teradata Explain. Created several custom tables, views and macros to support reporting and analytic requirements.
• Involved in creating Partition Primary Index, Secondary, Join and Hash indexes for efficient access of data based on the requirements.

Environment: Ab Initio, Business Objects 5.1, Oracle 8i, SQL Server 2000, Teradata V2R4, Teradata Administrator, BTEQ, Queryman, Tpump, FastLoad, MultiLoad, COBOL, XML, AIX UNIX, Solaris and Windows 2000.