SUMMARY:

• 8+ 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.
• Also experienced with Ab Initio Data Profiler and developed statistical analysis reports.
• 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, AIX

Methodologies: Dimensional modeling of STAR, SNOWFLAKE.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. Abinitio Developer

Responsibilities:

• Involved in meetings to gather information and requirements from the clients.
• Extensively used ETL to load data from Oracle database, XML files, Flat files data also used import data from IBM Mainframes.
• Responsible for trouble shooting, identifying and resolving data problems, Worked with analysts to determine data requirements and identify data sources, provide estimates for task duration.
• Developed Scripts to load the data from source to staging and staging area to target tables using different load utilities like Bteq, FastLoad and MultiLoad.
• Created JCL scripts to load data from mainframes.
• Gather information from different data warehouse systems and loaded into Kaiser System Consolidated model using Fast Load, Fast Export, Multi Load, Bteq and UNIX shell scripts.
• Used EME for version control, did dependency analysis and meta programming
• Generated Configuration files, DML files, XFR files specifies the Record format, which are used in components for building graphs in Ab Initio.
• Updated and inserted transactional data according to the business changes using continuous flows.
• Involved in creating Flat files using dataset components like Input file, Output file, Intermediate file in Ab Initio graphs.
• Developed graphs using multistage components.
• Extensively Used Transform Components: Reformat, Rollup and Scan Components.
• Implemented the component level, pipeline and Data parallelism in Ab Initio for ETL process for Data warehouse.
• Extensively used Partitioning Components like Broad Cast, partition by key, partition by Range, partition by round robin and Departition components like Concatenate, Gather and Merge in Ab Initio.
• Responsible for the automation of Ab Initio graphs using korn shell scripts.

Environment: Ab Initio (GDE 3.1.4, Co>operating system 3.1.2.2), Teradata V12, Teradata SQL Assistant, SQL, PL/SQL, Shell Scripts, TOAD, Clear Quest, DB2, Erwin.

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.
• Profiled the data for Business Users using Ab Initio Data Profiler and developed data analysis reports and helped Business Analysts to write the requirements.
• 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.
• Worked on STAR SCHEMA data ware house model.
• 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.
• 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.
• 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.
• Worked on Talend technology for data integration and data quality.

Environment: AB Initio GDE version 1.15.11, Co>Operating System 2.15, Oracle11G, Autosys, SQL Plus, SQL Loader, SVN, Talend, AIX UNIX.

Confidential

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

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
• 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

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.
• 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

 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 .
• 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.
• 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.