PROFESSIONAL SUMMARY:

• Over 7 years of IT experience in analysis, design, development, testing, implementation and support on Data warehousing.
• Good skills set in SQL, PL/SQL, Oracle, SQL server, UNIX Shell Scripts, Data Modeling, Data Warehousing strategies and IBM DataStage.
• Experience in Data Warehousing Star / Snowflake Schema Design, Requirement Analysis, User Interaction, Logical and Physical database design, Strong Backend Development, Exposure and experience with various ETL tools.
• Area of expertise encompasses Data Model, ETL phases of Data Warehousing. This is achieved with an emphasis on relational data modeling and dimensional data modeling for OLTP and OLAP systems
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse
• Created ETL guidelines document which involves coding standards, Naming conventions for Development and troubleshooting of DataStage jobs.
• ETL experience ranging from debugging and production support to setup maintenance, and debugging, version control, software and license installation and patching
• Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.
• Scheduling the jobs using Autosys and Control - M.
• Export & Import, Performance Tuning of DataStage, Backup and Recovery
• Worked and extracted data from various database sources like Oracle, DB2 and SQL Server.
• Experience in using Job Sequencer to control the flow of parallel jobs.
• Experience in UNIX shell scripting, Perl scripting and administering Job sequences using crontab.
• Experienced in writing PL/SQL scripts for extracting required data from the source tables and loading them to the target files.
• Involved in Unit Testing of DataStage Jobs and integration testing in pre-production environment.
• Have good Analytical and Problem Solving skills and Excellent Communication and Interpersonal Skills, ability to understand and adapt to new technologies and environments faster.
• Participated in discussions with the Project Managers, Team Lead and Team Members on technical and or business requirements.
• Ability to work independently as well as in a team

TECHNICAL EXPERIENCE:

ETL Tools: IBM Datastage (8.x/9.x) Enterprise Edition/Parallel Extender

Databases: Oracle, SQL Server, DB2/UDB, MS/Access.

OS: UNIX (AIX), Linux, MS DOS, Windows NT/2000/XP

Languages: C, C++, SQL, PL/SQL Basic, UNIX Shell programming

Scheduling Tools: Autosys, Control -M.

Modeling Tools: ERWin, MS Vision.

DB Utilities: Toad, SQL Plus

Data Access Tools: Putty, Secure CRT

MS Tools: SharePoint, MS Project, MS Word, MS Excel, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

DataStage Developer

Responsibilities:

• Design DataStage jobs to code to read the data from source databases/flat files and load them to the target Oracle ODS tables.
• Extensively worked on Parallel Jobs using various stages like Join, Lookup, Filter, Funnel, Copy and Slowly changing dimension, Change Data Capture (CDC), Sequential File, Oracle Enterprise, Merge and Transformer.
• Designed Functional Specification Document and Mapping documents according to the transformation rules.
• Defining and implementing JIL files to automate the DataStage jobs and monitoring them.
• Scheduled Interfaces by Using Autosys and few jobs through DataStage Director
• Used different types of Stages like Sequential File, Lookup stage, Transformer, Change capture, Remove Duplicates, External source, XML input/output, Funnel, Sort, Aggregator, and ODBC for developing different Jobs.
• Export/Import the DataStage code from different environments to perform different levels of testing.
• Follow DataStage coding standards and use performance tuning to fine tune the process and meet the SLA.
• Oversees overall systems testing and the migration of platforms and applications to production.
• Involved in source data analysis and data cleansing.
• Use Autosys to automate the DataStage jobs and handle failure scenarios.
• Attend Status Meetings with the Clients and interact very closely with offshore to finish the Tasks to reach Deadline.

Environment: IBM DataStage 8.7, Oracle, MS SQLServer 2000, SQL, PL/SQL, UNIX Shell Scripts, Autosys, Winscp, UNIX-AIX, Windows XP.

Confidential, Cleveland, OH

DataStage Developer

Responsibilities:

• Involved in analyzing the system and gathering the requirements.
• Developed various ETL jobs including Data Extractions, Transformations rules based on business requirements using IBM InfosphereDatastage9.1.
• Performed Job tuning which helps in reducing the production time for the daily job runs.
• Worked with the project and business teams to understand the business processes involved.
• Used DataStage Designer to develop multiple processing jobs to read data from source and load into Oracle. Used DataStage Manager for import/export jobs, metadata from one project to another project.
• Extensively worked with Parallel Extender/Enterprise Edition (EE) using Parallel Processing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sources.
• Used different types of Stages like Sequential File, Lookup stage, Transformer, Change capture, Remove Duplicates, External source, XML input/output, Funnel, Sort, Aggregator, and ODBC for developing different Jobs.
• Used PL/SQL languages for writing stored procedures and functions and were called in DataStage Jobs.
• Coordinated with team members for changes in design.
• Performed file manipulation in UNIX.
• Used DataStage Sequencer to run jobs in sequence.
• Used Autosys to trigger the jobs on a daily basis.
• Participated in the system testing and unit testing.
• Production support and maintain for the all applications owned.
• Responsible for Documenting and support maintenance.

Environment: IBM DataStage 9.1, Oracle, MS SQLServer 2000, SQL, PL/SQL, UNIX Shell Scripts, Autosys, UNIX-AIX, Windows XP.

Confidential, Florham Park, NJ

DataStage Consultant

Responsibilities:

• Involved in analyzing the system and gathering the requirements.
• Worked with the project and business teams to understand the business processes involved.
• Responsible for developing the process & testing as it pertains to data flow for the interfaces.
• Extensively worked with Parallel Extender/Enterprise Edition (EE) using Parallel Processing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sources.
• Used different types of Stages like Sequential File, Lookup stage, Transformer, Change capture, Remove Duplicates, External source, XML input/output, Funnel, Sort, Aggregator, and ODBC for developing different Jobs.
• Used DataStage Director to Run and Monitor the Jobs performed, automation of Job Control using Batch logic to execute and schedule various DataStage jobs.
• Used PL/SQL languages for writing stored procedures and functions and were called in DataStage Jobs.
• Configured File for Parallel extender as per number of processors available to process the data by using DataStage Manager.
• Coordinated with team members at times of change in Business requirements and change in design.
• Used DataStage Sequencer to run jobs in sequence.
• Developed UNIX shell scripts for scheduling the jobs and for automation of loading processes.
• Participated in the system testing and unit testing.
• Production support and Maintenance for the all applications owned.
• Responsible for Documenting and support maintenance.

Environment: DataStage 8.5, Oracle 9.x, Erwin, PL/SQL, DB2, SQL, UNIX Shell Scripts, Windows XP/2000

Confidential, Overland Park, KS

DataStage Developer

Responsibilities:

• Extensively worked with Parallel Extender/Enterprise Edition (EE) using Parallel Processing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sources.
• Involved in modeling database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Involved in Design and development of Data model using Erwin.
• Designed and implemented slowly changing dimensions (SCD’s) methodologies.
• Used different types of Stages like Sequential File, Lookup stage, Transformer, Change capture, Remove Duplicates, External source, XML input/output, Funnel, Sort, Aggregator, and ODBC for developing different Jobs.
• Used version Control for data stage to track the changes made to the data stage project components and for protecting jobs by making read only.
• Wrote SQL/PLSQL Procedures to improve the Performance while extracting and loading tables.
• Migrated Jobs from Development to QA and to Production Environments.
• Wrote UNIX scripts for record count in a file.
• Scheduled the jobs using Control - M Scheduler.
• Developed UNIX shell scripts for scheduling the jobs and for automation of loading processes.
• Analyzed the performance of the jobs and project and enhance the performance using standard techniques.

Environment: DataStage 8.1, SQL, Oracle, PL/SQL, DB2, Toad, UNIX Shell scripting, Control-M.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked for commerce clients in designing and developing databases for POS systems. The system was developed to maintain the entire information about the material availability and finished goods, delivery details, purchases, vendor’s information and catalog information.
• Creating PL/SQL Procedures, Packages, Functions for billing module.
• Developing Forms and Reports.
• Developed custom reports for various modules as per the client requirement.
• Query Optimization, Tuning SQL queries.
• Unit Testing on Forms and Reports and PL/SQL Stored Procedures, Functions, Triggers, Packages.
• Developed Oracle Stored procedures and database objects for the whole billing database.
• Created Stored Procedures, Functions and Triggers using SQL*Plus to be invoked by shell scripts and forms.
• Tuned the billing module to improve the performance, because of growing number of transactions.
• Developed the Oracle Reports to show the users various employee reports, Salary slabs, promotion, tax, loans and advances.

Environment: Oracle 9i RDBMS Enterprise Edition, Microsoft windows server 2003, PL/SQL, Oracle 9i Application Server Enterprise Edition, SQL loader.