SUMMARY:

• Around 7 years of IT experience in Analysis, Design, Development and Maintenance of various Business applications.
• Strong experience in Ab Initio Architecture, GDE, Co>Operating System.
• Extensively used AIR commands to check in/check - out, perform dependency analysis and other EME related operations.
• Expertise in ETL process design and documentation like HLD, DLD and Data mapping documents.
• Good Experience in SQL, PL/SQL and database joins etc.
• Comprehensive knowledge of Mainframe programming, test plan, regression testing, and techniques
• Sound working knowledge in Parameterizing Ab Initio graphs and creating PSETS
• Experience in designing, developing, execute and maintain data extraction, transformation, and loading for multiple corporate Operational Data Store, Data warehousing, and Data mart systems.
• Extensive knowledge of Mainframe tools and techniques as well as Unit regression testing.
• Experience in EME, checkins, checkouts, command line interface, air commands and Dependency analysis.
• Well versed with various Ab Initio parallelism techniques and implemented number of Ab Initio Graphs using Data parallelism techniques
• Experience in integration of various data sources such as flat files, ASCII, EBCDIC files, XML files, DB tables etc.
• Strong Experience in working with Business Objects.
• Strong Experience in working with Autosys.
• Involved in creating the Logical and Physical design of the Data Warehouse (both Fact and
• Dimension tables) using both STAR and Snow Flake Schema approaches supporting slowly changing
• Dimensions.
• Experience in defining, creating, documenting, verifying and executing Test cases and work with development team to resolve product issues, create basic test plan and performing functional testing, Integration testing and performance testing.
• Extremely effective in System Development Life Cycle (SDLC) from analysis, design, development, testing and implementation in diverse range of software applications.
• Team player and self-starter, capable of working independently, self driven and can motivate a team of professionals.
• Extensively used Control-M and Autosys for job management
• Quick learner and ability to meet deadlines and work under pressure.
• Experience with databases like Teradata and Oracle 9i/11g.
• Knowledge of System Analysis and Design and Object Oriented Analysis & Design.
• Working Knowledge of Cognos and Informatica.

TECHNICAL SKILLS:

ETL Tools: Ab Initio GDE 3.1.5/3.0,Oxygen XML Editor 11.2, SQL server 2000/2005/2008/2012, Toad, Teradata SQL assistance, Control-M, Autosys

Database: Oracle 11i/10i/9i, SQL Server

Languages: C, C++, JAVA, SQL, PLSQL

Scripting Languages: UNIX/Shell script, HTML/DHTML, XML, SQL

Operating Systems: Windows XP, UNIX (IBM AIX, Solaris 9.0/10.0, LINUX)

Testing Tools: Quality Center

Source control tools: EME (Enterprise Meta Environment), and PVCS

Data Modeling: ERWIN 4.1, ERStudio 8, Visio

Version control Tools: Microsoft Visual SourceSafe

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Ab Initio Developer

Responsibilities:

• Working on GRU project the Finance Full Suite architecture endeavors to provide more control for the Finance function by creating a transparent flow of data and minimizing the number of adjustment/correction points to meet the organizations reporting needs.
• Used Lookups with Reformat component for fetching matched records based on the downstream process.
• Worked with Partition components like partition by key, partition by Expression. Efficient use of Multi files system, which comes under Data Parallelism.
• Involved in Unit Testing of the developed components.
• Interacting with Business users to understand each Interface in detail.
• Creating Ab Initio plans as per the dependency.
• Creating and implementing Autosys Ops Console to create, modify and to automate the process.
• Deploying Ab Initio code and Unix packages from env to env (Dev to UAT and UAT to PROD)
• Writing the wrapper scripts ( sftp scripts, emailing, zero byte file size) for housekeeping.
• Executing the stored Procedures through Ab Initio.
• Understanding the existing system architecture.
• Responsible for gathering business requirement from users and technical analysis.
• Creating low level design documents by using High level design documents.
• Analyzing and breaking down business requirements into tasks to offshore.
• Code review and necessary modifications where ever it’s applicable.
• Providing tech solutions and better performance techniques to the offshore.

Environment: Ab Initio Version 3.1.5, Co>Operating System- Version 3.1.1.6, UNIX, Oracle 10g, SQL Server, Ops Console, DB2

Confidential, OH

Ab Initio Lead

Responsibilities:

• The Enterprise Forecast & Planning (EFP) and Enterprise Finance Information (EFI) projects have direct dependencies on the Infrastructure & Architecture being deployed.
• Through EFI, and EFP efforts Finance has the opportunity to create more transparent financial results and enrichments and expose these results seamlessly to LOB Operational reporting and with Enterprise Forecasting and Planning, the OFSAA (Oracle Financial Services Analytic Application) solution bring EFI the ability to better leverage the infrastructure assets and reduce effort and cost for support and maintenance.
• Created wrapper scripts to execute the graphs. Incorporated features for restart ability and rollback in case of a failure.
• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Component like reformat, rollup, join, scan, normalize, gather, replicate, merge etc.
• Involved in development of the transformations (Filters, de-duping, Joins, Reformat etc) using Ab Initio ETL
• Developed business object in accordance to clients' needs and requirements.
• Unit testing and end-to-end system testing of the entire application.
• Responsible for cleansing the data from source systems using Ab Initio components such as reformat and filter by expression.
• Created .xfr and .dml files for various transformations and specifying the record format.
• Used Ab Initio GDE to generate complex graphs for the ETL process using Join, Rollup and Reformat transformcomponents and executed using Co>Operating System.
• Developed psets to impose reusable business restrictions and to improve the performance of the graph.
• Involved in setting up of sandboxes and maintaining sandbox parameters.
• Implemented Rollouts for Production Releases.

Environment: Ab Initio Version 3.1.4, Co>Operating System- Version 3.1.1.6, UNIX, Mainframe, Oracle 10g, Toad

Confidential, Richmond, VA

Ab Initio Developer

Responsibilities:

• Developed and supported the extraction, transformation and load process (ETL) for the Data Warehouse from heterogeneous source systems using Ab Initio.
• Used Ab Initio GDE to generate complex graphs for the ETL process using Join, Rollup and Reformat transformcomponents and executed using Co>Operating System.
• Extensive experience in scheduling the Ab Initio deployed scripts using Control-M and Auto sys
• Created .xfr and .dml files for various transformations and specifying the record format.
• Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions. Capacity of designing solutions around Ab Initio, with advanced skills in high performance in Ab Initio.
• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Component like Filter by Expression, Partition by Expression, Partition by round robin, reformat, rollup, join, scan, normalize, gather, replicate, merge etc
• Involved in development of the transformations (Filters, de-duping, Joins, Reformat etc) using Ab Initio ETL
• Performed the tuning of ETL process by means of maximizing the use of MFS, using lookup file instead of join if possible, removing unnecessary phasing, removing unnecessary components, making use of the indexes on the tables, etc. and thus to achieve an exceptional reduction of the total process time.
• Defining business rules and transformations for data coming from source systems into the data warehouse.
• Worked on improving the Performance of Ab Initio graphs.
• Modified the Ab Initio components parameters, utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Utilized Phases, Checkpoints to avoid deadlocks and multi-files in graphs and also used Run program, Run SQL components to run UNIX and SQL commands.
• Provided application requirements gathering, designing, development, technical documentation, and debugging. Assisted team members in defining Cleansing, Aggregating, and other Transformation rules.
• Analyze business requirements and developed metadata mappings and Ab Initio DMLs.
• Developed business object in accordance to clients' needs and requirements
• Able to interact effectively with other members of the Business Engineering, Quality Assurance, users and other teams involved with the System Development Life cycle.
• Involved in setting up of sandboxes and maintaining sandbox parameters.
• Tuning of Ab Initio Graphs for better performance.
• Documentation of complete Graphs and its Components
• Unit testing and end-to-end system testing of the entire application.
• Creating graphs that use xml.
• Support for user acceptance testing.
• Production migration and production support.

Environment: Ab Initio CO>OS 2.15/3.0, GDE 1.15/3.0, Business Objects3.1, Teradata utilities, DB2UNIX, QTP, SQL server, UNIX korn shell, Main Frame

Confidential, Lakewood, CO

Ab Initio Developer

Responsibilities:

• Study and understand all the functional and technical requirements to better serve the project
• Developed Ab Initio graphs using different components for extracting, loading and transforming external data into data mart.
• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Component like Filter by Expression, Partition by Expression, Partition by round robin, reformat, rollup, join, scan, normalize, gather, replicate, merge etc
• Developed Ab Initio graphs for Data validation using validate components like compare records, compute checksum etc.
• Implemented Data Parallelism through graphs, by using Ab Initio partition components.
• Documentation of complete Graphs and its Components.
• Implemented Data Parallelism through graphs, which deals with data, divided into segments and operates on each segment simultaneously through the Ab Initio partition components to segment data.
• Involved in Ab Initio Design, Configuration experience in Ab Initio ETL, Data Mapping,Transformation and Loading in complex and high-volume environment and data processing at Terabytes level.
• Involved in automating the ETL process through scheduling.
• Used Autosys for scheduling the jobs.
• Responsible for cleansing the data from source systems using Ab Initio components such as reformat and filter by expression.
• Developed psets to impose reusable business restrictions and to improve the performance of the graph.
• Developed several partition based Ab Initio Graphs for high volume data warehouse.
• Checked the accuracy of data loaded into Teradata and assured the linkage of keys on the tables for the various applications.
• Documenting the processes so as to enable better reusability and maintainability.
• Scheduling the bug fixes for development/UAT and production migration.
• Create test scripts for the Integration testing and support for Integration testing.
• Analyzing the Production bugs logged in Test Director.

Environment: Ab Initio CO>OS 2.15, GDE 1.15, Teradata utilities, Main Frame

Confidential, Oakland, CA

ETL Developer

Responsibilities:

• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.
• Developed Ab Initio graphs in accordance to the Business requirements and worked on Unit testing and as well as system testing.
• Played a key role in overall design of the entire application
• Wrote multiple Ab Initio transforms to covert currency values coming from different countries.
• Lead the design and development effort to consolidate all business rules into a common XFR for re-usability.
• Configuring Ab Initio Config files to interact with Teradata database.
• Worked on Common Extract and Load Graphs from a Teradata database.
• Reviewed and helped define test cases for system test and UAT.
• Played a key role in database design for tables used for reporting purposes
• Responsible for code reviews across all modules of the application.
• Anticipated and prepared teams through changes (requests from client, scope of work, adjustment in deadlines, etc.)
• Identified and applied best practices to issues at hand. Generated new perspectives and frameworks that allow problems to be solved. Makes difficult ideas and concepts easy to understand (e.g. using diagrams, analogies, etc.)
• Integrated requirements from multiple subject areas/business areas to define solution requirements.
• Facilitated and negotiated the resolution of conflicting requirements and out of scope requirements.

Environment: Ab Initio CO>OS 2.13, GDE 1.13 Oracle9i/8i, UNIX, Teradata, DB2, Mainframe

Confidential, Broomfield, CO

Jr. Ab Initio Developer

Responsibilities:

• Actively involved in all phases of project development life cycle.
• Involved in requirement gathering.
• Worked on the design and development of graphs.
• Worked on performance tuning of graphs.
• Worked on the documentation for the graphs.
• Developed stored procedures for loading of data into Oracle table.
• Created XSD documents for extraction and loading of XML data.
• Worked on shell scripting.
• Developed graphs with various Ab Initio components such as Read XML, Write XML, XML Reformat, Join, Lookup, Uncompress, Reformat, Partition by Key, Gather.
• Used Conditional Components, Conditional DML for data extracting and loading
• Used Multifiles and Serial files to extract and load data.
• Designed and developed parameterized graphs.
• Created sandboxes to manage graphs, .dbc files to connect to source and target databases.
• Used Oracle, Mainframe, XML, CSV files as source and target systems.
• Used EME for managing and Version control of Graphs.
• Used Autosys to, schedule, run and monitor Ab initio graphs.
• Designed Cognos Framework Manager using Name Spaces, Dimensional Maps, Query Subjects,
• Query Items and Packages.
• Created new query items for data cleansing and data scrubbing in Cognos.
• Created the reports in Query Studio, Report Studio
• Used BTEQ and Teradata SQL assistant to support queries in interactive and batch modes.
• Used FastLoad, MuliLoad, FastExport and Tpump to load and unload the data.
• Provided production support and resolved tickets in Mercury Quality Center

Environment: Ab Initio CO>OS 2.13, GDE 1.13, Oracle 8i/9i, Unix Korn Shell scripting, Teradata V2R7 SQL, PL/SQL, Autosys, Windows XP, UNIX, Cognos