Law

SUMMARY

• Over 8+ years of experience in System Analysis, DataStage, Design Development  in Data Warehousing, Data Integration, Data Migration, Quality Stage, Oracle, PL/SQL, Teradata and DBD2 UDB.

• Around 5years in-depth experience in Extraction Transformation and Loading (ETL) processes using Ascential Data Stage 7.x/6.x (Parallel Extender). Worked on Data Stage client tools Data Stage Designer, Data Stage Director, Data Stage Manager and Data Stage Administrator.

• Excellent experience in using Stages like Complex Flat File, Dataset, Copy, Fileset, Oracle Enterprise, Join, Sequencer, Aggregator, Merge, Filter, Transformer, Lookup, Funnel, Compress etc.,

• Experience in Designing, Compiling, Testing, Scheduling, and Running Data Stage jobs.

• Experience in Creating and administering tables in Teradata.

• Expertise in OLTP/OLAP System Study, Analysis and Dimensional Modeling, E-R modeling. Involved in Designing Dimensional Model (Star schema and Snowflake schema), database  administration, Multi Dimensional Model, Fact and Dimensional Tables, Slowly Changing  Dimensions. Worked with CDC (Change Data Capture).

• Used to various databases Oracle 9i/8i, DB2, MS Access, SQL Server and Sybase.

• Extensive Experience working with Database tool TOAD, SQL Loader etc

• Experience working with Parallel Extender for Parallel processing to improve job performance while working with bulk data sources. Worked with most of the parallel stages applying different partitioning techniques.

• Strong working knowledge with Oracle database Design and SQL Scripting, DB2, PL/SQL and  TOAD.

• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System

Testing and Load Testing. Seamlessly migrated the Code from Development to Testing, UAT and Production.

• Involved in Performance Fine Tuning of ETL programs. Tuned DataStage and Stored procedures Code.

• Successfully interacted with end-users, developers and top management.

• Excellent analytical, problem solving, communication and interpersonal skills, with ability to  interact with individuals at all levels.