PROFESSIONAL SUMMARY:

• 6+ 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 DataStages 11.3/9.1/8.x/7.x(Information Server, WebSphere, Ascential DataStage).
• Perform the analysis of the requirements from a business value perspective to determine the feasibility of constructing the application.
• Strong data warehousing experience using IBM DataStage Components like DataStage Designer, DataStage Director, DataStage Administrator and IBM information server, ERwin, SQL Server, Oracle PL/SQL and involved in all the stages of Software Development Life Cycle (SDLC).
• Thorough understanding of DW principles (Fact Tables, Dimensional Tables, Dimensional Data Modeling - Star Schema and Snow Flake Schema).
• Familiar in using highly scalable parallel processing Infrastructure using DataStage Enterprise Edition (Parallel and Server).
• 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, DB2, Teradata and Flat files into the staging area.
• Experienced in Data Warehousing, Application Development and Production Support.
• Experience in DMExpress and File Port
• Experience in MDM analysis for existing customers that have customer data in multiple systems.
• Good Experience with different RDBMS like Oracle 12c/11g/10g/9i/8i and Teradata 15.0.
• Expertise in creating reusable components such as Shared containers, Local Containers and in creating custom transformations, functions and routines.
• Experienced in Onshore - Off Shore coordination Development and Production Support Team.
• Excellent understanding of the DBA functions including creating tables, table spaces, databases and indices and extensive experience in UNIX Shell Scripting and Windows batch CMD Scripting..
• Worked on Scheduling tools like Control-M for automating jobs run.
• Having excellent track record as a strong team player with effective communication, analytical and multi-tasking skills, resourceful, result driven and self-motivated.

TECHNICAL SKILLS:

ETL Packages: IBM Information Server(IBM WebSphere DataStage 11.3/9.1/8.7/ 8.1/8.0.1/7. x, Parallel extender(PX), IBM WebSphere Quality Stage)

Databases: Oracle 12c/11g/10g/9i/8i, MS SQL Server,Teradata 15.0, DB2 UDB, Sybase, MS Access.

Database Tools: SQL* Plus, SQL Loader, TOAD, SSIS, DB2 Import, DB2 Export.

Database Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT and Dimension Tables, Erwin, Rational Rose, Microsoft VISIO.

Operating System: Windows NT / 2000 / XP Pro / Vista, Windows Server / 2008, UNIX, Linux

Programming Languages: SQL,PL/SQL, Shell scripting, C, C++, Java, VB 5.0

Web Technologies: HTML, XML.

Modeling Languages: UML.

Other: Neteeza, TeamForge, ClearCase etc.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

ETL DataStage Developer

Responsibilities:

• Involving in data Extraction and data Transformation from source database and loading to Enterprise Data Warehouse with DataStage
• Working closely with the sales team and gathering the functional requirements and working with project manager to give a high level design and the cost associated with the project.
• Working with datastage designer and director to design job to extract data from external files and tables
• Using IBM information server DataStage 11.3 to create jobs using stages like Aggregation, Transformation, Source Dataset, Row generation, Column generation, lookup, join, merge, surrogate key generator and vector stage etc.
• Developing jobs to aggregate the source using Aggregator and handled duplicate records using Remove Duplicate Stage.
• Using parallel extender to create jobs using stages like Aggregation, Transformer, Join, Merge, Surrogate key generator etc.
• Using shared containers created reusable components for local and shared use in the ETL process.
• Involving in the Design, Development and Production support of Data Warehouse and working closely with clear case for secure Import and Export of dataStage jobs.
• Designing dataStage jobs using stages like Oracle, ODBC, Transformer, Join, Merge and sort to populate and incrementally load the source data into target tables
• Creating jobs to produce unit test data using Row Generator, Column Generator, Sequential file and Dataset to perform unit test plan(UTP)
• Schedule the DataStage jobs using DataStage director and using scripts in Control-M scheduler schedule the jobs.
• Proficiency in diverse facets of business analysis including Business process mapping, data architecture, technical architecture and work flow analysis.
• Creating Stored Procedures for faster data extraction from databases.
• Creating data validation scripts to verify the loading process from source to ODS to Data Warehouse.
• Document the source target mapping and unit test plans and scripts for DataStage jobs

Environment: IBM InfoSphere DataStage 11.3, Oracle 12c, SQL, PL/SQL, Sybase, Shell Script, TOAD 9.7.2.5, ERWIN, Control-M, UNIX Shell scripts and Win NT.

Confidential, Pittsburg, PA

ETL DataStage Developer

Responsibilities:

• Analyzing the user requirements and high level design documents, and develop various ETL jobs to load desired data from OLTP to OLAP system.
• Work with ISD staff, clients to evaluate, and implement solutions including both packaged system solution and custom development application options.
• Prepare requirement documents, assist in design documents, test cases and other related documents and involved in project implementation issues.
• Analyzed the given source dimensions and target fact table structures to develop surrogate key tables referencing required dimensions.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the DataMarts.
• Using shared containers created reusable components for local and shared use in the ETL process.
• Imported and exported repositories across Data Stage projects.
• Analyzed data with discrepancies through error files and log files for further data processing and cleansing.
• Used IBM information server DataStage 9.1 to create jobs using stages like Aggregation, Transformation, Source Dataset, Row generation, Column generation, lookup, join, merge, surrogate key generator and vector stage etc.
• Scheduling the Jobs and Creating Job sequences to load Tested data.
• Worked on performance tuning and enhancement of Data Stage job transformations.
• Summed key performance indicators using Aggregator stages as an aid to Decision Support Systems.
• Used Data Stage Director Runtime engine to schedule and execute developed jobs and job sequences used log events to monitor job progress and performance.
• Performed Unit testing and participated in weekly status meetings and conducting internal and external reviews as well as formal walkthrough among various teams and documenting the proceedings.

Environment: IBM Info Sphere DataStage 11.3/9.1, Oracle 12c and Oracle11g, SQL*plus, SQL server, Unix/Linux, Netezza, TOAD 9.7.0, ERWIN, Autosys Scheduling tool

Confidential, Princeton, NJ

DataStage Developer

Responsibilities:

• Extensively worked on IBM information server DataStage 8.1 to create Parallel Jobs using various stages like Aggregator, Transformer, Dataset, Row Generator, Column Generator, Filter, Funnel, Join, Lookup, Lookup File Set, Copy, Peek, Oracle Enterprise, DB2 UDB, Change Capture, Remove Duplicates, Merge, Pivot, Sequential file and FTP Stages.
• Analyzed, designed and developed ETL jobs for Vendor Feeds.
• Encrypted files before sending to vendors.
• Created shell scripts to integrate the process of Hashing, Encrypting and FTP.
• Created Data stage jobs to load data to internal data feeds.
• Scheduled and monitored the jobs in Production.
• Reviewed the errors in Organizational Manager production jobs and apply fixes.
• Created the logical and physical data model for Data Mart.
• Implemented Slowly Changing Dimension Type2 process for Data Mart.
• Developed jobs to load dimension and fact tables.
• Maintained the DataMart database objects.
• Documented the entire ETL Process in the ETL Design document.
• Improved the run time for the process that loads the fact table.

Environment: IBM Info Sphere DataStage 8.1, SQL Server 2005, Oracle 11g, TOAD 9.5.0, SQL Loader, Control-M, Erwin, Red Hat LINUX, Netezza.

Confidential, St Louis, MO

DataStage ETL Developer

Responsibilities:

• Developed various ETL jobs to Load Data Warehouse from Lawson ERP, Tecsys and PMM systems.
• Worked with the migration of ETL jobs from DataStage 7.5.2 to WebSphere DataStage 8.0.1.
• UsedDataStageDesigner to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different DataMarts.
• Used several stages like Sequential file, Hash file, Aggregator, Funnel, Change Capture, Change Apply, Row Generator (debugging stage), Peek, Remove Duplicates, Copy, Lookup and RDBMS during the development process of theDataStagejobs.
• Created complex data stage jobs in Enterprise Edition using various stages.
• Involved in building various logics to handle Slowly Changing Dimensions, Change Data Capture, Upserts and Deletes for Incremental Loads in to the DataWarehouse.
• DevelopedDataStageparallel jobs to load data from sequential files, flat files and Oracle.
• Involved in building Logic for Error Management and capture daily load status in to Audit Process Tables for daily ETL runs.
• Developed various Sequence jobs to maintain the process flow.
• Performed Unit Testing.
• Analyzed and implemented new Business rules for the existing jobs.

Environment: IBM DataStage 8.0.1, LAWSON ERP, Oracle 10g, Oracle 9i, SQL Server2000, TOAD 9.6, Erwin, Autosys, Windows NT, UNIX, Microsoft Visio.

Confidential

Datastage developer

Responsibilities:

• Translated business processes into DataStage jobs for building data marts.
• Worked with different sources such as Oracle, SQL Server and Excel, Flat, COBOL files.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transforming and finally loading into the data marts.
• Identified source systems, their connectivity, related tables and fields and ensured data consistency for mapping.
• Created source table definitions in the DataStage repository by studying the data sources.
• Created error files and log tables containing data with discrepancies to analyze and re-process the data.
• Created job schedules to automate the ETL process.
• Troubleshooted the designed jobs using the DataStage Debugger.
• Tuned DataStage transformations and jobs to enhance their performance.
• Extracted data through SQL Server stage and loaded data to Oracle tables.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

Environment: IBM DataStage 8.1, Basic ERwin 4.0, TOAD, Oracle 10g, Windows 2000/NT, IBM AIX, Unix shell scripts, MS SQL server 2000, DB2 UDB 8.0

Confidential

ETL Developer

Responsibilities:

• Defined sources and targets and the business rules that define how the data gets transformed.
• Extracted and transformed data from multiple sources (Oracle, Sybase, SQL Server, flat file, XML) and loaded into Oracle tables.
• Extensively worked on IBM information server to create Parallel Jobs using various stages like Aggregator, Transformer, Dataset, Row Generator, Column Generator, Filter, Funnel, Join, Lookup, Lookup File Set, Copy, Peek, Oracle Enterprise, DB2 UDB, Change Capture, Remove Duplicates, Merge, Pivot, Sequential file and FTP Stages.
• Developed jobs to aggregate the source data using Aggregator and handled duplicate records using Remove Duplicate stage.
• Used IBM information server to create jobs using stages like Aggregation, Transformation, join, merge, surrogate key generator and vector stage etc. Used Meta Broker with Ascential products sssuch as Ascential Quality Stage, DataStage for direct tool-to-tool import/Exports
• Scheduled and monitored automated weekly jobs
• Performed the Unit testing of individual modules and their integration testing
• Debugged and sorted out the errors and problems encountered in the production environment.

Environment: IBM information server DataStage 7.5, Oracle 10g, ERwin, WinSQL, TOAD, SQL*Plus, PL/SQL, UNIX Shell scripts.