SUMMARY

• About 8 years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various Data Warehousing, Reporting and Software Applications.
• About 8 years of Exclusive Experience in Ab Initio (GDE, Co>operating system).
• Expertise in ETL tools using Ab Initio (GDE, Co>operating system) and SQL Loader for data migration to Enterprise Data Warehouse.
• Experience in preparing code documentation in support of application development, including high level and detailed design documents, unit test specifications, interface specifications, etc.
• Worked with ODS (Operational Data Source), Data validation and cleansing process using Ab Initio.
• Experience in Ab Initio EME/Sandbox to implement version control and impact analysis to manage various project across the organization.
• Performance tuning the complex Ab Initio graph, worked with tuning the memory parameter and Ab Initio best practice approach to implement the ETL process
• Ability to demonstrate command and use of industry accepted Ab Initio best practices.
• Strong development skills including the ability to work through the entire development life (SDLC) cycle from gathering requirements through implementation, development, production, support and documentation of the complete project.
• Worked extensively in the GDE (Graphical Development Environment) configuring, connecting, and testing the components to produce executable flow graphs on UNIX environment, Proficient with various Ab Initio Data Cleansing, Parallelism, and Transformation and Multi File System techniques.
• Thorough knowledge of DML (Data Manipulation Language), Unix Shell scripting
• Developed various UNIX shell wrappers to run Ab Initio and Data base jobs. Practical experience with working on multiple environments like production, development, testing.
• Experience in Using CFG (Continuous Flow Graphs) and also develop graphs for batch processing.
• Used Conduct>IT for job scheduling wherein created several plans using resources.
• Very Good Programming skills using UNIX/Shell Scripts and PL/SQL for Automation of ETL process.
• Worked with Block Box, White box, Component END - to-END ETL process and worked closely with Development team to resolve any bugs.
• Strong skills in defining and implementing solutions, tools, processes and procedures to provide enterprise data integration and ETL services that meet business requirements.
• Extensive knowledge in Dimensional Data Modeling, Star schema, Snow-Flake schema, creation of Fact and Dimension Tables, OLAP, OLTP and thorough understanding of Data-Warehousing concepts .
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and Possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Excellent Knowledge of Data Warehousing Concepts.

TECHNICAL SKILLS

ETL Tools: Ab Initio Co>Operating System 3.0, GDE 3.0

Operating Systems: Windows XP/2000/NT, Linux, UNIX

Languages: C, XML, SQL, PL/SQL

RDBMS: Oracle11g, MS Access,SQL Server.

Internet: HTML, PHP, ASP, JavaScript.

GUI: Developer 2000, TOAD.

Scripting: UNIX korn shell, JavaScript, XML, XSD

Utilities: Autosys Scheduling tool,Control-M, JIL Jobs.

PROFESSIONAL EXPERIENCE

Confidential, Pasadena, CA

Sr. Programmer Analyst Professional/Sr. Ab Initio Developer

Responsibilities:

• Involved in analysis of functional requirements and specifications.
• Worked extensively in creating mapping, technical detail design, Unit Test cases, and Implementation and Post Implementation documents.
• Worked assisting development team in requirement understanding, development and code reviewing for each release of project.
• Developed several generic graphs for application using dynamic dml and xfrs.
• Worked on all phases of SDLC of AbInitio project for several releases.
• Worked extensively in design, development, testing and deployment of Ab Initio graphs.
• Strong experience in extracting data from Mainframeto perform Historical and Incremental loads to Oracle Database.
• Also worked on creating the standard process documents for different projects to share among the team
• Worked on implementing enhancements in sql and mainframe projects.
• Worked with multiple teams in different projects in Production support and maintenance for several Projects.
• Responsible for troubleshooting and providing fix on daily bases to production Support team.
• Release specialist for several releases to Implement, validate and post implementation of project.

Environment: AB Initio GDE 1.14.136/1.15/3.0, Co>Op 2.17/3.0, IBM AIX Version 5, Oracle 10g, sql developer, IBM Trivoli (TWS),Unix Scripting

Confidential, Bloomington,IL

Abinitio Developer

Responsibilities:

• Performed Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs
• Involved in creating detail data flows with source and target mappings and convert data requirements into low level design templates.
• Responsible for setting up Repository projects using Ab Initio EME for creating a common development environment that can be used by the team for source code control.
• Implemented various levels of parameter definition like project parameters and graph parameters instead of start and end scripts.
• Developed graphs based on data requirements using various AB Initio Components such as Rollup, Reformat, Join, Scan, Normalize, Gather, Broadcast, Merge etc., making use of statements/variables in the components for creating complex data transformations.
• Created generic graphs for loading and unload Teradata tables using pre and post Run SQL components to clean WEL tables that are created due to the intermediate process failures.
• Performed data cleansing using AB Initio functions such as is valid, is error, is defined
• Extensively used string functions, date functions and error functions for source to target data transformations.
• Well experienced in using Partition (Partition by key, partition by round robin) and De partition components (Concatenate, Gather, and Interleave, Merge) to achieve data parallelism.
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
• Implemented Lookups instead of joins, in-memory sorts to minimize the execution times while dealing with huge volumes of data
• Replicate operational table into staging tables, transform and load data into warehouse tables using Ab Initio GDE.
• Deployed and ran the graphs as executable Korn shell scripts in the applications system.
• Developed Unix Korn Shell script wrappers to run Ab Initio deployed scripts, perform audit checks/data reconciliation and error handling to ensure data accuracy.

Environment: Ab-Initio v1.15, Co>Op 2.15, Oracle and UNIX Sun OS 5.9

Confidential, Edison, NJ

Abinitio Developer

Responsibilities:

• Extensively used Ab-Initio ETL tool in designing & implementing Extract Transformation & Load processes. Different Ab Initio components were used effectively to develop and maintain the database.
• Understood the business requirements with extensive interaction with Business analysts and reporting teams, and assisted in developing the low level design documents.
• Created several packages to set up and share global variables, types and transforms which were extensively used for many Ab Initio graphs.
• Implemented a 6- way multifile system in the test environment that is composed of individual files on different nodes that are partitioned and stored in distributed directories in multifile system.
• Extensively used File management commands like m ls, m wc, m dump, m copy, m mkfs etc.
• Responsible for 24 X 7 production support of Ab Initio Process.
• Debugged the failures from the log files and re ran the jobs, by analyzing the checkpoints with in graphs
• Used UNIX Schell Scripting, XML and XSD.
• Monitored Daily loads, Submissions of extracts and been the point of contact for customers.
• Responsible for deploying Ab Initio graphs and running them through the Co-operating systems mp shell command language and responsible for automating the ETL process through scheduling.
• Involved in Comprehensive end-to-end testing.
• Worked on improving the performance of Ab Initio graphs by using Various Ab Initio performance techniques like using lookup Tables, In-Memory Joins and rollups to speed up various Ab Initio Graphs.
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.

Environment: Ab-Initio v1.14, Co>Op 2.14, Oracle and UNIX Sun OS 5.9.

Confidential, Jersey City, NJ

Ab initio Developer

Responsibilities:

• Implemented Ab Iinitio graphs based on the business requirement.
• Responsible for creating the deployment plans.
• Debugging and resolving the issues of the Code.
• Involved in requirements gathering, worked out the designs, prepared the technical design document by attending meetings with the client.
• Preparing the unit test cases and perform unit testing and peer reviews at the end of each phase Scheduling the jobs using Cron.
• Involved in writing wrapper scripts for bringing up and down of all the processes,
• Handled the entire design and development of the application.
• Also used the concepts of PDL and Component folding for efficiency sake.
• Also developed a frame work for capturing the Rejects, Errors and logs in each and every process.
• Involved in supporting the QA for testing the application and fixed the bugs.
• Monitoring the jobs in UAT and PROD
• Participate in the Ab Initio code review calls.
• Attending Tollgate review meetings.
• Participating in Release Formalities.

Environment: Ab-Initio v1.15, Co>Op 2.15, Oracle and UNIX Sun OS 5.9

Confidential

Ab initio Developer

Responsibilities:

• Implemented Ab Iinitio graphs based on the business requirement.
• Interaction with Tech-Lead on daily basis for requirement gathering and status update.
• Responsible for creating the test cases.
• Involved in requirements gathering, worked out the designs, prepared the technical design document by attending meetings with the client.
• Preparing the unit test cases and perform unit testing and peer reviews at the end of each phase Scheduling the jobs using Cron.
• Involved in writing wrapper scripts for bringing up and down of all the processes,
• Handled the entire design and development of the application.
• Also used the concepts of PDL and Component folding for efficiency sake.
• Also developed a frame work for capturing the Rejects, Errors and logs in each and every process.
• Involved in supporting the QA for testing the application and fixed the bugs.
• Responsible for creating the deployment plans.
• Monitoring the jobs in UAT and PROD
• Debugging and resolving the issues of the Code.
• Participate in the Ab Initio code review calls

Environment: Ab-Initio v1.15, Co>Op 2.15, Oracle and UNIX Sun OS 5.9

Confidential

Ab initio Developer

Responsibilities:

• Implemented Ab Iinitio graphs based on the business requirement.
• Interaction with Tech-Lead on daily basis for requirement gathering and status update.
• Responsible for creating the test cases.
• Responsible for creating the deployment plans.
• Monitoring the jobs in UAT.
• Debugging and resolving the issues of the Code.
• Participate in the Ab Initio code review calls.
• Understanding the Business requirements, co-ordination with developers and Business Analysts directly.
• Involved in requirements gathering, worked out the designs, prepared the technical design document by attending meetings with the client.
• Preparing the unit test cases and perform unit testing and peer reviews at the end of each phase Scheduling the jobs using Cron.
• Involved in writing wrapper scripts for bringing up and down of all the processes,
• Handled the entire design and development of the application.
• Also used the concepts of PDL and Component folding for efficiency sake.
• Also developed a frame work for capturing the Rejects, Errors and logs in each and every process.
• Involved in supporting the QA for testing the application and fixed the bugs.

Environment: Ab-Initio v1.15, Co>Op 2.15, Oracle and UNIX Sun OS 5.9

Confidential 

Oracle Developer

Responsibilities:

• Experience in assisting the Application Developers in creatingconceptual database designsthat meet the business and technical objectives.
• Used conceptual models and extended conceptual models with business rules to develop logical data models.
• Designed Oracle Logical Objects including Triggers, Stored Procedures, and Sequencesthat helped in automating various operations in the database.
• Developed complex reports likeMatrix Reports, Tabular Reportsfor the systems using running totals, sub totals, grand totals and daily balance by using lexical parameters.
• DevelopedFront-end formsdepending upon the logic such as Master-detail form and complex forms for the application.
• DevelopedSQL*Loader scriptsto load flat files into source staging database and plan the loads to run concurrently without any manual intervention.
• Fine Tuned SQLfor the maximum efficiency in various schemas across databases usingOracle Hints, Explain plans and Trace sessionsfor Cost based and Rule based Optimization.
• Performedmanual testingon the application and Involved in defects fixing team.
• Created new and modified database procedures, functions, triggersand other database objects by using TOAD tool.

Environment: Oracle 6i, Developer 2000, TOAD, SQL, PL/SQL, SQL Plus, Windows 2000.