SUMMARY

• 9+ years in Analysis, Design, Development and Maintenance of various software applications using Oracle Technologies and Data Warehousing tool Ab Initio 3.0.6
• Experienced in all phases of the systems life cycle (SDLC), including project definition, analysis, design, development, coding, testing, implementation and support.
• Comprehensive understanding of Enterprise Data Warehousing (EDW) including but not limited Fact Tables, Dimension Tables, Star and Snowflake Schema Modeling.
• Extensive experience in development of PL/SQL Stored Procedures, Functions, Triggers and Packages to implement business logic.
• Involved in design and development of ETL solutions/processes using Ab Initio 3.0.6.
• Experience in working as Ab Initio admin. Work involves obtaining Ab Initio Key from Abinitio Support, Installing co>op, Setting up the Abinitio config file abinitiorc & .abinitiorc, Setting up the environment parameters using .profile and env files. EME access, starting Work Load manager, Creating war file for Ab Initio component like ACE/BRE, Operational Console and MetadataHub. Setting up bridge and reporter file for Ab Initio components.
• Proven Experience in Data Extraction, Transformation and Loading (ETL) processes.
• Experience in Data Migration including data mapping and loading using SQL*Loader.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing code/scripts.
• Extensive experience in developing UNIX Shell Scripts, job scheduling and monitoring using Cybermation ESP workstation & UNIX Crontab.
• Designed and deployed well - tuned Ab Initio graphs for UNIX environment.
• Worked with complex Ab initio components like Reformat, Normalize, scan, rollup, Join, Filter by Expression, Sort, Dedup Sorted, Lookup, Concatenate, Redefine format and many others. Good experience in resolving Ab initio dependency analysis errors.
• Worked with serial and multi files.
• Having knowledge in working with GUI application Power Builder 7.0 on database Oracle.
• Strong experience in understanding business requirements.
• Experience in gathering User requirements and preparing specification documents.
• Strong knowledge in building Test Plans and Test Cases.
• Excellent communication, interpersonal, presentation skills.

TECHNICAL SKILLS

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

Languages: C, C++,SQL, PL/SQL, Shell, awk

RDBMS: Netezza, Oracle 9i/10g/11g, SQL Server 2000/2008

ETL Tools: Ab Initio 3.x, SQL Loader, PL/SQL, SQL

GUI: Power Builder, Oracle Forms

Batch Process: Crontab, Cybermation ESP

Others: TOAD, CA Work Bench, MS Office

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Ab Intio Administrator

Responsibilities:

• Collecting the requirement for new environment.
• Placing the request for new server and the required software to be installed.
• Installing Co>operating system and placing request with Ab Initio for license key. Install the Abinitio key.
• Setting up the Abinitio config file abinitiorc & .abinitiorc,
• Configuring the Application HUB by creating apphubrc, file.
• Setting up the environment parameters using .profile and env files.
• Creating EME and granting access to the users to the EME.
• Starting Work Load manager
• Creating war file for Ab Initio component like ACE/BRE, Operational Console and MetadataHub.
• Setting up bridge and reporter file for Ab Initio components
• Setting up runtime environments, bridge and properties for Operational console.
• Common sandboxes required by the ACE projects must either be checked out to $AB APPCONF ROOT DIR/main/global, or specified via a config file
• Deploying the war file in Websphere Application Server (WAS)
• Analyzing and fixing issues in the Ab Initio server or Components.
• Perform Continuity of Business testing
• Creating stdenv, Project directories and multifile system.
• Checking out the sandboxes in new environments (SIT, UAT & Prod).
• Moving the tags from Dev to other environments (SIT, UAT and Prod) and deploy them.
• Deploying Oracle database objects in SIT, UAT and Prod environments
• Creating or updating the odbc.ini files for applications using Netezza database
• Creating SSH connection between two servers. Generally SSH connection will be established between the Ab Initio server and the server in which the EME is installed.

Environment: Intel, IBM AIX Version 5.3, Red Hat LINUX, Ab Initio 3.1.5.5, Shell scripts, Oracle 10g/11g, SQL & PL/SQL, SQL Loader,Netezza, Tibco

Confidential

ETL Ab Initio / Oracle PL/SQL Developer

Responsibilities:

• Prepare Design documents for various work streams in Project.
• Gathered business requirements and Mapping documents.
• Created Logical Tables, Dimensions, Facts and additional metadata in the Business Layer.
• Multiple graphs were built to unload all data needed from different source databases (Oracle & Sybase)
• Developed graphs using GDE, with components partition by round robin, partition by key, rollup, sort, scanning, dedupsort, reformat, join, gather and concatenate.
• Used components like run program and run sql to run UNIX and SQL commands in AB Initio.
• Also used components like filter by expression, partition by expression, replicate, partition by key and sort.
• Performing transformations of source data with Transform components like Join, Normalize and Reformat.
• Create Summary tables using Rollup, Scan & Aggregate. Deploy and test runs graphs as executable k-shell scripts.
• Modified AB Initio components parameters, utilize data parallelism and thereby improve overall performance.
• Used Data Parallelism, Pipeline Parallelism and Component Parallelism in Graphs, where huge data files are partitioned into multi-files and each segment is processed simultaneously.
• Working with Departition Components like Gather, Interleave to Departition and Repartition data.
• Involved in Coding and Unit testing of Ab Initio Code, review of Code and code promotions. .
• Involved in creating materialized Views and Indexes in Oracle.
• Analysis of maintenance request/minor enhancements in GRR application.
• Perform minor enhancements in Ab Initio/Oracle backend modules/shell scripts to in corporate maintenance request.
• Fixing production issues and carrying out data fixes requested by the users of GRR systems.
• Worked on task orders and request for proposals for these projects.
• Preparation of Checklists, identification of Test Cases, preparing Test Plans.
• Prepared Function Requirement Documents and documented process events and best practices.
• Involved in optimization of SQL statements using Explain plan.
• Worked on SQL*Loader and external Tables for Export/Import of data.
• Carried out extensive data validation with client’s data specialist validating complex SQL queries.
• Wrote cursors and control structures using PL/SQL.

Environment: Intel, IBM AIX Version 5.3, Red Hat LINUX, UNIX, Ab Initio 3.0.6, Shell scripts, Oracle 10g/11g, SQL & PL/SQL, SQL Loader

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in requirements gathering from Business and Functional teams.
• Prepared Function Requirement Documents. Documented process events and best practices.
• Created Logical Tables, Dimensions, Facts and additional metadata in the Business Layer.
• Involved in creating Stored Procedures, PL/SQL Packages, Triggers, Functions, ref Cursors, Collections, Varrays, Index by table, Bulk Collect, for all various oracle dbms utilities to implement the business logic.
• Analysis of maintenance request/minor enhancements in TDW application.
• Performing enhancements in shell scripts and apply data model changes in Oracle. .
• Fixing and resolving production issues and carrying out data fixes of TDW systems users.
• Worked on task orders and request for proposals for these projects.
• Preparation of Checklists, identification of Test Cases, preparing Test Plans.
• Involved in optimization of SQL statements using Explain plan.
• Worked on SQL*Loader and External Tables for Export/Import of data.
• Carried out extensive data validation with client’s data specialist validating complex SQL queries.
• Wrote cursors and control structures using PL/SQL.

Environment: UNIX, Shell scripts, Oracle 10g, SQL & PL/SQL

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in requirements gathering and as well in documentation.
• Involved in creating stored Procedures, PL/SQL Packages, Triggers, Functions, Ref cursors, Collections, Varrays, Index by table and Bulk Collect.
• Created custom triggers to automatically populate different tables.
• Developed SQL*Loader scripts to load data into staging tables from flat files.
• Used FTP to transfer files into different servers as needed.
• Performed enhancements in Power Builder, Oracle backend and in shell scripts.
• Involved in fixing production issues and carried out data fixes for Xponent users.

Environment: UNIX, Shell script, Power Builder 7, Oracle 9i, SQL & PL/SQL

Confidential

Lead Oracle PL/SQL Developer

Responsibilities:

• As a team Leader for this project, various responsibilities include but not limited to analysis and development of new requirements, managing maintenance request, performing enhancements in LPIN application.
• Involved in requirements gathering from business and functional teams.
• Involved in creating stored Procedures, PL/SQL Packages, Triggers, Functions, Ref cursors, Collections, Varrays, Index by table, Bulk Collect, for all various oracle DBMS utilities to implement the business logic.
• Created custom Triggers to automatically populate different tables.
• Developed SQL*Loader scripts to load data into staging tables from flat files.
• Used FTP to transfer files into different servers as needed by business users.
• Designing the changes that come as maintenance request.
• Coding the minor enhancements in Power Builder or in Oracle backend modules or in shell scripts to in corporate the changes requested in the maintenance request.
• Fixing the production issues and carrying out data fixes requested by the users of LPIN systems.

Environment: UNIX, Shell script, Power Builder 7, Oracle 9i, SQL & PL/SQL

Confidential

Oracle PL/SQL Developer

Responsibilities:

• As a team Leader for this project, various responsibilities include but not limited to analysis and development of new requirements, managing maintenance request, performing enhancements in COBRA application.
• Involved in requirement gathering from the functional teams .
• Involved in creating stored Procedures, PL/SQL Packages, Triggers, Functions, Ref cursors, Collections, Varrays, Index by table, Bulk Collect, For all various oracle DBMS utilities to implement the business logic.
• Created custom triggers to automatically populate different tables.
• Developed SQL*Loader scripts to load data into the staging tables from the flat files.
• Used FTP to transfer files into different servers as needed by business users.
• Performing minor enhancements in Power Builder, Oracle backend modules and in shell scripts to in corporate maintenance requests.
• Fixing and resolving production issues and carrying out data fixes of COBRA systems users.

Environment: UNIX, Shell scripts, Power Builder 7, Oracle 9i, SQL & PL/SQL

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in requirements gathering from the functional teams.
• Involved in creating stored Procedures, PL/SQL Packages, Triggers, Functions, Ref cursors, Collections, Varrays, Index by tables to implement the business logic.
• Created custom triggers to automatically populate different tables.
• Developed SQL*Loader scripts to load data into staging tables from flat files.
• Used FTP to transfer files into different servers as needed by business users.
• Performing enhancements in Power Builder, Oracle backend modules and in shell scripts to in corporate the maintenance requests.
• Fixing the production issues and carrying out data fixes requested by the users of DDMS systems.

Environment: UNIX, Shell scripts, Power Builder 7, Oracle 9i, SQL & PL/SQL

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in requirements gathering from the client and business users.
• Involved in creating stored Procedures, PL/SQL Packages, Triggers, Functions, Ref cursors, Collections, Varrays, Index by table and Bulk Collect.
• Created custom triggers to automatically populate different tables.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Developing and testing the new requirements for the Client.

Environment: UNIX, Shell scripts, Oracle 9i, SQL & PL/SQL