SUMMARY

• 7+ years of experience in IT and extensive experience in ETL tool using IBM WebSphere Datastage (Ver8.7, 8.5/8.1/8.01/7.5/7.1 ) InfoSphere Information Server Edition.
• Experience in delivering solutions involving cross functional teams across the enterprise.
• Expertise in Dimensional data modeling, Star schema modeling, Snowflake modeling, identification of fact and dimension tables. Excellent knowledge of studying the data dependencies using Metadata of DataStage and preparing job sequences for the existing jobs to facilitate scheduling of multiple jobs.
• Very good knowledge and understanding of Master Data management (MDM), processes such as collapse, merge, split etc.
• Performance tuned many ETL and DB modules, participated in end to end stress testing.
• Strong knowledge of Extraction Transformation/Verify and Loading (ETL/EVL) processes using IBM Ascential DataStage, UNIX shell scripting, and SQL Loader.
• Expertise in working with various operational sources like DB2, DB2UDB, SQLServer, Oracle, Teradata, Sybase, Flat Files etc.
• Extensively worked on Parallel Extender on Orchestrate Environment for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve job performance.
• Significant experience in Evolving Strategies and developing Architecture for building a Data warehouse by using data modeling tool Erwin.
• Experience in integration of various data sources like Sybase, MS Access, Oracle, DB2, SQL Server and Teradata
• Strong experience in high - end programming experience using SQL, PL/SQL, ANSI SQL, SQL*Plus, SQL*Loader, Unix Shell Programming/Scripting.
• Extensive experience in loading high volume data, and performance tuning.
• Played significant role in various phases of SDLC project life cycle, such as requirements definition, functional & technical design, development, testing, Production Support and implementation.
• Efficient in several capacities, including software version control, Installation, Administration, Open Deploy Configuration, Analyst Programmer, and finding solutions to business problems.
• Excellent team member with problem-solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and an enthusiastic team player.

TECHNICAL SKILLS

ETL Tools: Ascential Datastage 9.1, 8.7/8.5/8.0.1/7.5/7.0/6.0 (Designer, Director, ManagerAdministrator), Parallel Extender, Integrity, MetaStage, MetaBrokers, Informatica Power 8.0/5.1.1 (Designer, Server Manager, Repository Manager)

RDBMS: Oracle 10g/9i/8i/8.0/7.0, Sybase Server 11.5.1/11.0.3 , MS SQL Server 6.5/7.0/2000 , DB2 UDB, S Access 2000/97.

Tools: Erwin 4.1/3.5, Autosys, SQL*Loader and SQL Navigator

Scripting/Lang..: C, C++, HTML, VBScript, JavaScript, SQL, PL/SQL and XML

GUI: Visual Basic 6.0/5.0/, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0)

Web Technologies: ASP.Net, C#, VB.Net, XML/XSL, ASP, JavaScript, VBScript, ADO.Net, ADO

Application Server: Web sphere 4.x/5.0

Operating Systems: UNIX (AIX 4.2/4.3,5.2,Linux, Sun Solaris2.6/2.8,5.0 HP-UX), MS DOS 6.22, Windows 3.x/95/98/2000/XP, Win NT 4.0.

PROFESSIONAL EXPERIENCE

Confidential, Florida

Responsibilities:

• Transforming, integrating, and loading data into data warehouse database
• Perform data manipulation using DataStage transforms
• Used the Data Stage Director for scheduling, validating, running and monitoring the jobs
• Create and use DataStage Shared Containers, Local Containers for DS jobs and retrieving Error log information
• Mapping Documents, ETL Job Scheduling and maintenance document
• Performed import and export of Data Stage Jobs using DS Manager
• Creating jobs involving Aggregator, transformer Stages creating reusable components using shared containers
• Integrated Sources from Oracle and Flat Files
• Created Data stage Sequencers to run Batch jobs
• Used merge, lookup, change capture and transformer
• Used the transformations like Lookup, Filter, Aggregator, transformer in the development of data stage jobs
• Develop and implement strategies for performance tuning
• Used Sequential file, Oracle Enterprise, fileset, datasets, change capture, filter stage for designing the jobs in the DataStage Designer
• Used Data Stage Director for running and monitoring & scheduling the jobs
• Worked with Data Stage Manager for Export & Import Jobs
• Involved in Unit Testing and integration testing

Environment: IBM Infosphere Data Stage 8.7, 8.5 (Parallel Extender), Oracle 8i, SQL, TOAD, UNIX, Windows NT 4.0

Confidential

DataStage Developer

Responsibilities:

• Worked on two big migration projects Paymentnet3 to Paymentnet4 and Legacy to Paymentnet4 and actively participated in the team discussions regarding the modeling, architectural and performance issues of PNET4 and used Microsoft Visio for design documents
• Designed and developed data stage jobs for multiple countries data using ODBC, Aggregator, sort,Sequential file, Transformer stages, Filter stages, multiple rows Lookup, Teradata Enterprise stage.
• Worked with the Data Governance team to resolve various issues with the Processer data and provided support for fixing the data and mapping issues.
• Assess and monitor potential sources of impacts due to Planned Release, DBCR(s), Production Defects and communicate any cross impacts against the existing pool of Custom Objects to Custom Objects stakeholders across the SDLC
• Set up checkpoints for cross impacts at end of core release design and build phase
• Designed the technical document for various jobs, unit test documents with various scenarios, Acceptance level of test case results.
• Worked in all phases of the lifecycle development, coherent with Data Cleansing, Data Conversion, Performance Tuning, SDM documentation and production implementation.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
• Wrote Technical Unit Test cases for functional testers and uploaded them to HP Quality Center 9.2.
• Shell scripts were written to run the sequencers and copying files from root directory to destination directory.
• Well versed with IT service management and escalation process. Attended several production operations and reliability management meetings.
• Collaborated with cross team and solved critical production problems.
• Performed impact analysis of business requirements on ETL Process.
• Actively worked during nights and weekends during go-live and post production.

Environment: IBM Infosphere Data Stage 8.7, 8.5,7.5 (Parallel Extender), Teradata V13.10, DB2 UDB 8.1, Oracle, SQL Assistant 13, SQL, Windows NT server, AIX UNIX,MS Visio.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Experience with Real time and near Real time data movement and integration architecture.
• Experience and deep understanding of both analytical database design and operational data structures.
• Experience working in highly complex and heavily matrixed environments.
• Implemented various projects for EDW (Enterprise Data Warehouse), DMIH (Data Movement Integration Hub), ODS (Operational Data Store), MMDB (Medical management DB), IDM (Integrated Data marts), and Encounters adhering to HCSC standards and procedures.
• Expertise in Dimensional Modeling, DataStage and UNIX.
• Interacted with Business users in getting the business requirements, identifying the relationship within and between the groups of data.
• Designed the technical document for various jobs, unit test documents with various scenarios, Acceptance level of test case results.
• Achieved high degree of performance in ETL processes for giga bytes of data and extremely large files.
• Worked in all phases of the lifecycle development, coherent with Data Cleansing, Data Conversion, Performance Tuning, SDM documentation and production implementation.
• Well versed with IT service management and escalation process. Attended several production operations and reliability management meetings.
• Collaborated with cross team and solved critical production problems.
• Performed impact analysis of business requirements on ETL Process.
• Ensured that the model and mapping rules are viable when coupled with source data realities.
• Provided ongoing monitoring of the Project Plan as related to ETL deliverables and dependencies.

Environment: IBM Infosphere Data Stage 8.5, 7.5 (Parallel Extender), CVS, Zena, Teradata V13.10, Oracle,DB2 UDB 8.1, SQL Assistant 13, SQL, Windows NT server, AIX UNIX.

Confidential, Phoenix, AZ

Responsibilities:

• Interacted with business users in gathering the business requirements, identifying the relationship within and between the groups of data.
• Created the Functional/Technical specification documents by maintaining standards of the enterprise
• Designed the technical document for various jobs, unit test documents with various scenarios and acceptance level of test case results.
• Actively participated in discussions and implementation of Error Handling and Reject management, Audit management process.
• Designed and developed parallel jobs for extracting, cleansing, transforming and loading the data from the database and load into the ODS and GL
• Used stored procedure stage in parallel jobs .
• Worked extensively on different stages like Aggregator, Merge, Join, Copy, Modify, Lookup, Lookup Fileset, Filter, Oracle Enterprise, Column Generator, Row generator stages for Data cleansing and Data Transformation.
• Worked with disparate Sources such as Oracle, DB2 UDB and Flat files from Mainframe System.
• Used Autosys to schedule the jobs. Wrote shell scripts to schedule the job.
• Used DataStage Manager for importing & creating metadata definitions from repository, view and edit the contents of the repository.
• Extensively worked in the performance tuning of the program, ETL Procedures and processes, tuning the SQL used in Transformations and fine-tuning the database.

Environment: Data Stage 7.5, WinCVS, Erwin4, Oracle 8i/9i, DB2 UDB 7.2, TOAD 7.4, PL/SQL, C++, Windows NT server, AIX Unix 5.2.

Confidential, Milwaukee, WI

Responsibilities:

• Involved in translating business requirements into technical program specifications.
• Extensively worked on Parallel and Server Jobs.
• Worked on Job Sequencer to run multiple Parallel and Sever Jobs.
• Worked on Pipeline Parallelism and Partition Parallelism. Different partitioning methods like round robin, random, auto, hash.
• Worked on Extracting Data from Oracle Database and load the data into Teradata Database.
• Various parallel stages like join, lookup, funnel, copy, head, sort, peek.
• Involved in Source System Analysis, Extracting and analyzing the data.
• Performance tuned slowly running jobs into quick and efficient, reduced overhead.
• Developing Prototype Datastage Parallel Jobs using DataStage Designer and testing.
• Preparing the Specifications for the tested Prototype Jobs.
• Parallel Jobs using DataStage Designer to develop processes for extracting, cleansing, Transforming, Integrating, and loading data into data warehouse.
• User defined Routines and Transformations by using Universe Basic
• Used DataStage Transforms, Shared Containers, Local Containers for DS jobs
• Developed UNIX scripts to automate the Data Load processes to the target Data warehouse using Autosys Scheduler.
• Worked on Unix Shell Scripting to Load the data into DM Teradata Database from DWH Teradata Database.
• Distributed the data load to different available processors to speed up the job on Orchestrate environment
• Created Shared Container to simplify the Datastage design, to use as a common job component through out the project.
• Responsible for source system analysis, data transformation, data loading and data validation from source systems to Transactional Data system and Warehouse System.
• Extensively used ETL to load data from Oracle to Teradata and Flat files to Oracle.
• Extracting Data from Complex Fat File Systems.

Environment: DataStage 7.0/6.1, Ascential DataStage Version Control, Erwin4.0, Teradata, ORACLE, PL/SQL, Shell Scripts, COGNOS 7.2, Windows 2000, AIX UNIX 5.2.

Confidential, CA

Responsibilities:

• Assisted in updating the logical model with all related entities, attributes and relationships between entities based on the rules provided by the business manager using Erwin.
• Involved in requirement gathering, analysis and study of existing systems.
• Extensively used DataStage Designer for developing Server jobs, Parallel jobs and performed complex mappings based on user specifications.
• Used DataStage Designer for Extracting Data, Performing Data Transformations and Aggregate Data.
• Performed lookups using Hashed files.
• Used DataStage Manager to store and manage reusable Metadata, and created custom routines and transforms for the jobs.
• Experience in using DataStage Director to Validate, Run, Schedule and Monitor DataStage jobs.
• Worked extensively on all the stages such as OCI, Sequential, Aggregator, Hashed Files, Sort, Link Partitioner, Link Collector and ODBC.
• Developed jobs in Parallel Extender using different stages like Transformer, Aggregator, Lookup, Source dataset, External Filter, Row generator, Column Generator and Peek stages.
• Distributed load among different processors by implementing the Partitioning of data in Parallel Extender.
• Used Ascential MetaStage for data integration and standardization for loading in Oracle data warehouse.
• Used Partition methods and collecting methods for implementing parallel processing.
• Extracted data from Oracle and DB2 databases, transformed data and loaded into Oracle data warehouse.
• Also extracted data from Flat files, Sequential files and access files, applied transformations and loaded the data into Oracle data warehouse.
• Created DataStage jobs and Job sequences and tuned them for better performance.
• Developed UNIX shell scripts to automate the Data Load processes to the target Data warehouse.

Environment: Data Stage 7.x(Parallel Extender), Ascential Datastage Version Control, Erwin4.0, Oracle 8i/9i, DB2 UDB 7.2, TOAD 7.4, PL/SQL, Windows NT server, AIX Unix 5.2.