SUMMARY

• Over 9 years of experience in Data modeling, Data warehouse Design, Development and testing using ETL and Data Migration life cycle using IBM Web Sphere DataStage 8.x/7.x.
• Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts
• Designed and developed ETL processes using Data Stage designer to load data from Oracle, Flat Files to target Oracle Data Warehouse database.
• Analyzed design requirements. Identified Re - usable Stages.
• Used partitioned parallelism in parallel jobs and implemented workload algorithm.
• Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML
• Used exports and imports DataStage components and Scheduled DataStage Jobs.
• Performance tuning and Query optimization to enhance job performance
• Involved in job scheduling using TWS 8.6 (Tivoli workload scheduler)
• Worked as Data Analyst to ensure the data looked correct to End users and as per Business requirements
• Involved in preparation of Test Plan, Test Cases and Test Run Plan Document
• Involved in extensive coordination with global product groups for problem analysis and resolution.
• Experience in UNIX Shell Scripting.
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills.

TECHNICAL SKILLS

S/w life cycles: V-Model, Agile

ETL: IBM Infosphere DataStage ( v7.1, v8.5, v8.7 and v9.1), Informatica 9.1(Knowledge)

Job Scheduling tools: TWS 8.6 (Tivoli Workload Scheduler)

RDBMS: Teradata 13.10,Oracle 9i,10g,11g,PL/SQL, MS SQL 2000, 2008 & MS Access

CM Tools: MS Visual Source Safe, Share Point & Borland Star Team, Subversion (svn)

GUI Tools: TOAD, SQL Developer, JIRA, HP ALM 10.4/11.0

Operating Systems: UNIX, Windows NT server

Change Data Capture: CDC, QRep, Logminer

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Datastage developer

Responsibilities:

• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.
• Involved in design, source to target mappings between sources to operational staging targets
• Extensively used DataStage Tools like Infosphere DataStage Designer, Infosphere DataStage Director for developing jobs and to view log files for execution errors
• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.
• Created UNIX shell scripts to extract and load data from source files to EDW

Environment: IBM Web sphere DataStage 8.7, Oracle 10g/11i, TWS 8.6, Toad 7.3, Borland Star team, Flat Files, CSV, SQL, PL/SQL, UNIX

Confidential, Irvine, CA

ETL Analyst

Responsibilities:

• Gathered business scope and technical requirements.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into target database
• Involved in defining data transformation rules and identifying required data sources and fields.
• Extensively used Parallel Job Stages like Stored Procedures, Dataset, Aggregator, Join, Transformer, Sort, Merge, Filter, Modify, Lookup, Funnel and Pivot
• Used the Datastage Designer to develop processes for Extracting, Cleansing, Transforming, Integrating and Loading data into target database.
• Extensively used Merge, Aggregator, Remove Duplicates, and IPC Stages.
• Involved in writing Shell scripts for reading parameters from files, invoking data stage jobs, and FTP files to specific locations
• Performed Unit testing and Integration testing of the module
• Gathered business scope and technical requirements.

Environment: IBM Web sphere DataStage 8.5, Teradata 13.10, DB2, ERWIN 4.2, Toad 9.1, Share point, Flat Files, CSV, SQL, PL/SQL, Windows NT 4.0, UNIX

Confidential

ETL Analyst

Responsibilities:

• Worked closely with BA team and data modeler and database architect during the design and development of ETL technical specification document
• Developed Parallel jobs using different stages like transformer, lookup, peek, funnel, column import, column export, join and merge etc.
• Designed and created custom routines to perform business rules
• Documented the Data Warehouse development process and performed knowledge transfer to Business Intelligence developer

Environment: Ascential DataStage 7.1, UNIX AIX 5.3, DB2 UDB, Oracle 9i\10g, MQ Series, PL/SQL, Toad 7.5, Flat Files, XML, Autosys, Erwin 4.0

Confidential

ETL Associate

Responsibilities:

• Designed and developed validation processes for Data warehouse using DataStage
• Used DataStage Administrator to control purging of Repository and DataStage client applications or jobs they run and reset.
• Processed Cleansing, Purging and Optimizing of the data in warehouse
• Developed and implemented all ETL (Extract, Transform and Loading) Components based on the filter rules to obtain needed data from different source systems for calculating required metrics using PL/SQL.
• Developed Server Side functionality by using PL/SQL and UNIX shell programming.
• Constructed SQL Scripts to validate the data after loading process
• Transformations including aggregation and summation construct from operational data source to Data warehouse.

Environment: Ascential DataStage 7.1, Oracle 9i/8i, PL/SQL, Auto Loader, UNIX IBM AIX 5L 5.2

Confidential

Test Engineer

Responsibilities:

• Analyzing functional requirements and creating test scenarios
• Creation of Functional Test Cases
• Test Case Execution, Manual Testing and logging Defects
• Daily status reporting.

Environment: VB .Net, ASP, VB Scripting, Oracle 9i/10G, Toad 7.1, XML, Adobe Flash, Windows NT Server.