SUMMARY:

• Over 8+ years of IT experience in implementing Full Life Cycle (SDLC) for Data Warehousing projects, includes Business requirements gathering, Analysis, Design, Development, Implementation, Deploymentand Maintenance of ETL (DataStage) and Business Intelligence applications (BO Reporting).
• In - depth experience in Extraction Transformation and Loading (ETL) processes using IBM WebSphere Data Stage 11.3/8.5/ 8.0.1/8.0/7.5/7.1/7.0/6.0/5.2/ EE (Parallel Extender).
• Utilized DataStage client tools: DataStage Designer, DataStage Director, and DataStage Manager.
• Experience in migration, integration, development and implementation of ETL systems using strong project management methodologies with a focus on process efficiency and productivity.
• Utilized QualityStage Designer and Information Analyzer for column analysis, table analysis, primary key analysis and foreign key analysis.
• Experience with Parallel Extender (Orchestrate)/DataStage Enterprise Edition for parallel processing as part of ETL conversion process integrating multiple source systems.
• Extensive experience in using Ascential Version Control to migrate DataStage jobs from one environment to another and maintaining them.
• Experience in teh integration of various data sources such as Oracle, ORACLEUDB, SQL Server, Sybase, Teradata, flat files and mainframe into teh target tables.
• Worked extensively on SQL, PL/SQL, Packages, Procedures, Functions and Triggers. Experience in Performance Tuning of SQL statements, stored procedures and functions.
• Conducted unit testing and performance tuning of DataStage jobs.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment and change data capture
• Expertise in deploying OLAP tools, Materialized Views and Partitioning techniques for highly responsive Decision Support Systems.
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a dynamic, team-oriented environment.

TECHNICAL SKILLS:

ETL Tools: IBM Information Server 11.3/8.5/8.0.1 (Websphere Datastage and Qualitystage InformationAnalyzer),AscentialDatastage 7.5.2/7.1/6.0, 5.1(Designer,Director,Manager, Administrator)

Data Modeling Tools: MS Visio, Erwin 4.2/3.5.2

Databases: Oracle 10g/9i, ORACLE, Teradata,MS SQL Server 2000/2005,Sybase

Database tools: SQL*Loader

Operating Systems: MS-DOS 6.22, Windows NT/98/2000, Solaris,IBM-AIX,UNIX, LINUX

Languages: SQL, PL/SQL, T SQL, COBOL,UML, XML, HTML

Scripting: UNIX Shell Scripting,DataStage Basic Scripting,Perl Scripting

Other: ControlM scheduler, CMC, SAP BODS

PROFESSIONAL EXPERIENCE:

Confidential, CA

Senior DataStage Developer

Responsibilities:

• Worked closely with teh Data Modeler and Database Administrator to understand teh business processes and participated in teh analysis of business requirements to build teh data warehouse model.
• Extensively used DataStage Designer to develop teh Parallel jobs and Server jobs.
• Designed several DataStage jobs using Join, Merge, Lookup, Change Apply, Change Capture, Funnel, Filter, ODBC,Column Generator,Transformer, Modify, Surrogate Key, Aggregator, Dcode, Row Generator and XML stages.
• Developed parameter-driven ETL processes to map source systems to target data systems with DataStage complete source system profiling.
• Implemented various partition methods like Hash, Entire, Auto, and ORACLE.
• Utilized various Database Connector stages like ORACLE/UDB, ODBC.
• Tuned DataStage jobs for better performance by creating DataStage Lookup files for staging teh data and lookups.
• Developed complex transformations, surrogate keys, dimension tables and fact tables.
• Utilized Environment Variables and Stage Variables for developing parameter-driven jobs and debugging them.
• Identified facts and dimensions for developing logical design of teh data marts.
• Enhanced teh job performance by using proper partitioning methods.
• Analyzed teh resources utilized using Job Monitor.
• Extract and transform source data from ORACLE database and XML sources to load into data warehouse in Oracle and Teradata.
• Perform data extractions and loads using Teradata database utilities like Multiload, Fast Load and Fast Export for large warehouse and for datamarts in Teradata.
• Developed sequencers to control teh job execution of teh DataStage jobs using Job activity and Email Notification stages.
• Created many user defined server routines, before/after job subroutines, shared containers which facilitated in implementing some of teh complex logics. Also used stage variables.
• Extensively involved in creating teh partitioned tables, indexes, triggers and many complex SQL queries
• Utilized DataStage Director for running and monitoring performance statistics.
• Performed teh unit testing for jobs developed to ensure that it met teh requirements.
• Conducted teh migration of DataStage code to teh Integration and Production and conducted Integration testing.
• Developed UNIX shell scripts to automate file manipulation and data loading procedures and to create indexes, drop teh indexes in teh tables and enhanced teh master script to run teh master sequencer.

Environment: DataStage 8.5/ 8.0.1,ASG ZENA, Teradata, Oracle DB, Oracle 10g, SQL Scripts, BTEQ Scripts, UNIX Shell Scripting, Serena, XML, MS SQL Server, MS Word.

Confidential, Bartlesville, OK

DataStage Developer

Responsibilities:

• Worked on analyzing teh systems and gathering of requirements
• Involved in designing and development of data warehouse environment
• Involved in implementing star schema for teh data warehouse using Erwin for Logical/Physical Data Modeling and Dimensional Data Modeling
• Extensively used Data Stage Manager, Designer, Director and Integrity for creating and implementing jobs
• Used teh Data Stage Director and it’s run-time engine to schedule running teh jobs, testing and debugging it’s components, and monitoring teh resulting executable versions (on an ad-hoc or scheduled basis)
• Developed jobs using different stages like Transformer, Aggregator, Lookup, Source dataset, External Filter, Row generator, XML, Sequential file, OCI, Column Generator and Peek stages.
• Implemented SCD Type 1 and SCD Type 2 by using Dataset, Change Capture, Transformer and Oracle Enterprise stages
• Used DataStage to transform teh data to multiple stages and prepared documentation
• Improved performance by optimizing SQL statements and implemented Bitmap Indexes.
• Extensively used DataStage Director to validate, monitor, schedule and execute teh jobs..
• Migrated teh jobs from Development to QA and tan to Production server using Version Control
• Created and monitored sequences using DataStage sequencer also Created containers to use in multiple jobs.
• Used Teradata database utilities for extraction and loading teh records.
• Developed User Defined Sub Routines to implement some of teh complex transformations, data conversions, code validations and using various Datastage supplied functions
• Created different types of reports, such as Master/Detail, Cross Tab and Chart
• Used Analyzer and Explorer to view reports from different prospect like Slice and Dice and Drill down

Environment: Data Stage 7.5.2 (Enterprise Edition), Erwin 4.2,Oracle 9i, SQL Server, Windows NT, Business Objects, Autosys, Perl scripting, XML, HTML, Teradata, Web services, Unix Shell Scripts.

Confidential, GAP, CA

ETL DataStage Developer

Responsibilities:

• Assisted in updating teh logical model with all related entities, attributes and relationships between entities based on teh rules provided by teh 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 teh jobs.
• Experience in using DataStage Director to Validate, Run, Schedule and Monitor DataStage jobs.
• Worked extensively on all teh 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 teh 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 SQL server databases, transformed data and loaded into Oracle data warehouse.
• Also extracted data from Flat files, Sequential files and access files, applied transformations and loaded teh data into Oracle data warehouse.
• Created DataStage jobs and Job sequences and tuned them for better performance.
• Developed Unix shell scripts to automate teh Data Load processes to teh target Data warehouse.

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

ETL DataStage Developer

Confidential

Responsibilities:

• Requirements gathering and source data analysis and identifying business rules for data migration to data warehouse and data marts.
• Automation of ETL processes using DataStage Job Sequencer, shell scripting and PL/SQL programming.
• Performing administrative tasks such as setting up users and privileges, Creating and maintaining DataStage Projects and timely Project cleanup.
• Tuning Jobs using various configurations by understanding it’s complexion during volume testing before moving to production.
• Development of parallel jobs in Parallel Extender framework. Implementing type. II slowly changing dimensions
• Extract and transform source data from ORACLE Database and XML sources to load into data warehouse in Oracle and Teradata.
• Perform data extractions and loads using teradata database utilities like Multi Load, Fast Load and Fast Export for a large warehouse and for data marts in Teradata .
• Create Source and Target Data Base to Load Metadata for Profiling teh Data and Generate teh Analysis reports As per teh Client Requirements
• Worked on Data Profiling to do teh Column Analysis, Table Analysis, Primary Key Analysis
• Create custom Reports For Column Analysis & Tables Analysis adding Notes & comments for teh Analysis results for Business User to develop teh Business rules to Implement them in ETL process
• Generated Source to Target Specification Reports to Assist teh Data Modelers
• Processing of XML documents using XML Stages.
• Writing Autosys JIL Scripts to activate teh UNIX scripts in production i.e. Jils for teh Box and Commands.
• Query optimization using HINTS, EXPLAIN Plan etc.
• Writing Job Control routines and Transform functions in teh process of designing teh job.
• Maintain backup of ETL code, shell scripts using teh PVCS Tracker and PVCS version Manager.

Environment: DataStage 7.0, ProfileStage, Oracle 9.x, ORACLE, ORACLE UDB, COBOL, JCL, UNIX-AIX, Teradata, Windows 2000/XP, Oracle Designer, SQL Server, AutoSys.