SUMMARY

• Around 7 years of IT experience with special emphasis on system analysis, design, development and implementation of ETL methodologies in all phases of Data warehousing life cycle and Relational databases using IBM DataStage 8.7/8.5/8.1/7. x/6.x(Information Server, WebSphere, Ascential DataStage, Datastage quality stage).
• Strong data warehousing experience using IBM DataStage Components like Datastage Quality stage, Datastage Designer, Datastage Manager, Datastage Director, Datastage Administrator and Parallel Extender, ERwin, SQL Server, Oracle PL/SQL and involved in all teh stages of Software Development Life Cycle (SDLC).
• Thorough understanding of DW principals (Fact Tables, Dimensional Tables, Dimensional Data Modeling - Star Schema and Snow Flake Schema).
• Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension phenomenon (SCD), surrogate key assignment and CDC (Change Data Capture).
• Experienced in Oracle PL/SQL to develop oracle functions, stored procedures, packages and triggers and experienced in in corporation of various data sources like Oracle, SQL server, Teradata and Flat files into teh staging area.
• Experienced in Data Warehousing, Application Development and Production Support and excellent noledge of different RDBMS like Oracle 8i/9i/10g/11g/12C, MS SQL Server and Teradata.
• Expertise in creating reusable components such as Shared containers, Local Containers and in creating custom transformations, functions and routines.
• Experienced with legacy systems and good understanding of SQL, RDBMS and Object-Oriented technologies.
• Excellent understanding of teh DBA functions including creating tables, table spaces, databases and indices and extensive experience in UNIX Shell Scripting and Windows batch CMD Scripting.
• Good experience on Autosys jobs using Web GUI and proven track record in troubleshooting of Datastage jobs and addressing production issues.
• Having excellent track record as a strong team player with TEMPeffective communication, analytical and multi-tasking skills, resourceful, result driven and self-motivated.

TECHNICAL SKILLS

Data Warehousing: IBM Infosphere DataStage/Ascential Data Stage 8.7/8.5/8.x/7.x/6.x/5.x (Designer, Director, manager, Administrator), PX, Quality stage, Integrity, MetaRecon, MetaStage, MetaBrokers, Data Mining, Data mart, Metadata, OLAP, OLTP.

Databases: Oracle 12c/11g/10g/9i/8i/8.0/7.0, Sybase IQ 11.0/12.0,MS SQL Server 6.5/7.0/2000/2005 , Teradata 5.0/6.0,DB2UDB, MS Access 7.0/’97/2000.MYSQL,POSTGRESSQL

Tools: Erwin 4.1/3.5, Data Reports, Seagate Crystal Reports 6.x/5.x/4.x/3.x, SQR 3.x, SQL*Loader, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), MS Access Reports, TOAD

Programming: SQL, PL/SQL, ANSI SQL, Transact SQL, SQL*Plus 3.3/8.0, TOAD, C, C++, Unix Shell Scripting

Others: HTML 4.0, ASP 3.0/2.0, JSP, CGI, PERL, DHTML, MS Excel, MS Office, MS-Project.

Environment: Sun Solaris 2.6/2.7/2.8, HP-UX, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98/2000, Win NT 4.0, SCO Unix.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

DataStage Programmer

Responsibilities:

• Involved in gathering business requirements for existing jobs and for teh new development processes.
• Actively interacted with data modeler in developing data mart design with Facts and Dimension tables for data warehouse.
• Created jobs using DataStage designer to import data from heterogeneous sources like Db2, Oracle, Flat files and SQL server.
• Used technical specifications and business rules for transforming teh extracted data.
• Worked with DataStage Manager for importing and exporting table definitions/metadata and routines between DataStage projects.
• Extensively created user defined routines in addition to teh DataStage in-built routines and transforms to handle various special and complicated data manipulations.
• Performed source data analysis and data cleansing.
• Involved in performance tuning of teh DataStage jobs.
• Used DataStage Director to schedule, monitor and run jobs.
• Used DataStage Administrator for creating DataStage projects and setting up purging criteria.
• Involved in unit testing, system and integration testing.
• Modified UNIX shell scripts for file validations and job scheduling.
• Created detailed technical documentation for teh jobs developed.

Environment: IBM DataStage 8.7/8.5, Oracle 12c/11g, DB2 V5,Win SCP, Windows 7/XP, IBM AIX, MS Visio, TOAD, Unix shell scripts, SQL Developer, JIRA, Outlook Express.

Confidential, Philadelphia, PA

ETL DataStage Developer

Responsibilities:

• Worked with business customers for requirements gathering, Logical Design, Physical Design model meetings to understand teh data flow, frequency of data loads.
• Worked with architects and subject-matter experts to design comprehensive solutions.
• Created Mapping documents, Igraphix ETL process flows, Design spec documents, Unit test cases for DataStage ETL jobs
• Loading data in Oracle Tables using SQL Loader.
• Designing and developing of PLSQL - Packages, procedures to load & Validate Repair - table Data.
• Extensive experience in handling and creating In-bound and Out-bound files from legacy systems.
• Tuning SQL Statements using Explain Plan in Oracle.
• Captured Data from variety of sources including ASCII files, EBCDIC files, and Main Frame datasets.
• Used Teradata MultiLoad/FastLoad Utility for Fast Loading or Unloading of Data into Teradata Tables.
• Performance tuning of DataStage ETL- Jobs and Teradata Tables.
• Involved in Code Migration from one environment to another environment using DataStage Manager’s Import/Export functionality for Migrating DataStage Jobs.
• Extensively used DataStage Director utility Monitor and debug Data Stage code.
• Extensively used Quality stage for data cleansing and to standardize address information.
• Analyze newly converted data to establish a baseline measurement for data quality in Data Warehouse.
• Involved in DataStage Administration tasks such as creation of Projects, Environment variables and configuration files.

Environment: Ascential DataStage 7.2/7.5/8.0, TOAD, Oracle 10g/9i,DB2 8.x/7.x, Teradata 12.0, SQL, PLSQL, SQL Loader, Shell Scripts, AutoSys, PVCS, BOXI, UNIX AIX 5.2, Windows XP.

Confidential, El Dorado Hills, CA

ETL DataStage Developer

Responsibilities:

• Worked with business customers for requirements gathering, Logical Design, Physical Design model meetings to understand teh data flow, frequency of data loads.
• Worked with architects and subject-matter experts to design comprehensive solutions.
• Involved in Defined Best practice doc, Development standards doc for DataStage Jobs.
• Created Mapping documents, Igraphix ETL process flows, Design spec documents, Unit test cases for DataStage ETL jobs.
• Data Warehouse is implemented using Complex Flat Files from various Source Systems
• Captured Data from variety of sources including ASCII files, EBCDIC files, and Mainframe datasets
• Performed code revisions with programmers.
• Used Most of teh Other Parallel Stages like Row Generator, Column Generator, Modify, Funnel, Filter, Switch, Aggregator, Remove Duplicates and Transformer Stages etc extensively
• Involved in developing UNIX scripts to automate teh Data Load processes.
• Developed DS Routines for extract job parameters from files and developed DS routines for job Auditing.
• Involved in creating AutoSys for Scheduling teh Job dependencies and Timings.

Environment: IBM Infosphere DataStage/Ascential DataStage 7.2/7.5/8.0 (Parallel Extender), TOAD, Oracle 10g/9i, SQL, PLSQL, SQL Loader, Shell Scripts, AutoSys, VSS, UNIX AIX 5.2, Windows XP.

Confidential, Central Islip, NY

ETL DataStage Developer

Responsibilities:

• Gathering requirements and writing specifications for ETL Job modules.
• Involved in Defining and designing teh process for Extraction, Transformation and Loading Data from various source systems to ODS & Data warehouse.
• Analyze newly converted data to establish a baseline measurement for data quality in Data Warehouse.
• Designing and developing Master controlling sequencer jobs using teh DataStage Job Sequencer.
• Developed Common UTL - ETL Jobs, PLSQL Procedures which will run teh ETL-Jobs.
• Performance tuning of DataStage ETL- Jobs.
• Define constraints and derivations to implement business rules in DataStage jobs.
• Developed DS Routines for extract job parameters from files and developed DS routines for job Auditing. Perform data manipulation using BASIC functions and DataStage transforms.
• Design complex job control processes to manage a large job network
• Involved in developing UNIX scripts to automate teh Data Load processes.
• Involved in All ETL Testing Process, Bug Fixing.
• Implemented and Maintained ETL jobs in production.

Environment: Ascential DataStage 7.0/7.2 (Parallel Extender), Oracle 9i, DB2, DB2UDB, Mainframe, PVCS, SQL, PL/SQL, TOAD, Control M, Hummingbird, Shell Scripts, Universe Basic, HP UNIX, Windows 2000.

Confidential

ETL Data stage Developer

Responsibilities:

• Data Warehouse is implemented using sequential files from various Source Systems.
• Meeting with Source system users & Business Users to create data share agreements and BI requirements.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Involved in Designing Parallel Extender Jobs.
• DataStage Jobs version control and Migration using Version management & DS-Manager tools.
• Perform data manipulation using BASIC functions and DataStage transforms
• Define reference lookups and aggregations.
• Define constraints and derivations.
• Create master controlling sequencer jobs using teh DataStage Job Sequencer
• Create and use DataStage Shared Containers, Local Containers for DS jobs and retrieving Error log information.
• Design, build, and manage complex data integration and load process
• Developed UNIX scripts to automate teh Data Load processes to teh target Data warehouse.
• Involved in creating Control M for scheduling teh Job dependencies and Timings.

Environment: Ascential DataStage 7.0 (Parallel Extender & Server), Oracle 9i, DB2 UDB, TeraData, PeopleSoft, Mainframe, PL/SQL, AutoSys, Erwin 4.2, TOAD, SQL Developer, PVCS, Queryman, Business objects 5.1, Shell Scripts, Hummigbird 11.0, HP Unix, Windows XP.