SUMMARY

• An ETL Datastage Technical Lead with 11 years of IT Experience in in Information Management, end - to-end Data Warehousing, Business Intelligence, Data Integration & Data Migration. Developing Data Warehouse roadmap, strategy and architecture, enterprise data warehouse, ODS, dimensional data marts and end user reports.
• Hands-on knowledge of Data warehousing ETL and OLAP reporting tools, methodologies, 3NF & Dimensional modeling, Solution architecture, Technical architecture, Data Profiling, Data cleansing technologies, testing strategies.
• Hands-on experience in leading and designing Data Integration and migration for Data Warehouses including Data Profiling and Data analysis using IBM WebSphere DataStatge Parallel Extender 8.0/7.5 (Datastage Manager, Datastage Designer, DataStage Director, Datastage Administrator, Parallel Extender/Orchestrate),Quality Stage and ProfileStage.
• Develop full SDLC project plans to implement ETL solution and identify resource requirements.
• Implement,lead and guide on Datastage based ETL solution fulfilling stringent performance requirements.
• Head complex ETL requirements and design.
• Database Design Development of Conceptual, Logical and physical data model both 3NF and Dimensional data model.
• Provide Solution architecture, Technical Architecture, Tool Selection, Conceptualize solution approach.
• Project management Project initiation, scoping, estimation, costing, planning, Risk Management, finalization of technical / functional specifications, communication management, resource administration & optimization, and quality management of the product.
• As a team lead, possess strong abilities to mentor juniors and transfer knowledge to the client while empowering team members and work collaboratively.
• Target oriented, organized & persuasive with a strong commitment towards team's objective coupled up with good communication, presentation, analytical & team.

TECHNICAL SKILLS

Data Warehousing Tools: ETL - Ascential DataStage Server/PXE 8.0/7.5x, Abinitio ProfileStage 7.5/Information Analyzer, Qualitystage

RDBMS: Oracle 8i, 9i, 10g, DB2 v8.1,Sql Server

Geocoding Tools: CODE1

Languages: SQL, PL/SQL,Shell Scripting,PERL.

Tools: SQL*Loader,TOAD.Quality Center.

Data Modeling: ERwin 5.3.2/4.1

BI Tools: Business Objects, Cognos 8

Operating system: Windows 98, Windows NT, AIX UNIX, Sun Solaris, Linux

Source Code Control: VSS, Troom, PVCS,MKS

Scheduling Tool: Control M

PROFESSIONAL EXPERIENCE

Confidential

Senior Technical Lead

Responsibilities:

• Primary responsibities include supporting, maintaining and adding new functionalties to Mortgage applications for Confidential .
• Lead Architect for projects related to Conversion,Migration and Divestitures.
• Worked with business segment owners to coordinate technical/business transformation requirements gathering.
• Implemented Best practices related to datastage.
• Head /Develop complex ETL requirements and design.
• Developing Parallel routine using c ++ to be used across project.
• Resolving technical issues across projects
• Perform as active, leading role in shaping and enhancing overall ETL Datastage architecture.
• Provide technical leadership, complex systems development, and on going support for Datastage ETL and special and major projects.
• Responsible for setting up new projects ETL Estimates, Disk Size Estimates and design file system.
• Perform reviews of new and existing systems to ensure operational integrity and accomplishment of stated objectives. Designs, codes, tests, debug and documents programs.
• Analyze solutions and coordinates technology, productivity and performance initiatives.
• Managed enterprise application integration milestones & project risk mitigations while working with PMO team to deliver on-time and within budget.
• Assist and verify design of solution and production of all design phase deliverables.
• Developed number of Datastage Parallel Extender ETL jobs based on business requirements using various Datastage Component as CDC,Copy, Modify, Aggregator, Filter, Funnel, Join, Lookup, Merge, Datasets, Sequential files and transformer etc.
• Optimization/Tuning of Datastage Parallel Extender jobs to improve performance.
• Managing resources in the team across various projects in the mortgage application.
• Experince in Onsite/Offshore model.

Confidential, Round Lake, IL

Senior Datastage Developer

Responsibilities:

• Understanding the specifications for Data warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart.
• Responsible for Identifying and creating common components to use across projects.
• Standardizing code implementation using Parallel Extender to speed up development activities.
• Helped redefine existing practices for ETL for Datastage Parallel Extender jobs.
• Optimization/Tuning of Datastage Parallel Extender jobs to improve performance.
• Identifying and Addressing data quality Issues.
• Fine Tune SQL queries for Extracting Data and for System test cases
• Implemented a Combination of Star Schema and Snow Flake Schema
• Looping Datastage jobs to load partitioned tables.
• Read XML data using Datastage and load in to database tables.
• Extract data from SAP using Datastage provided SAP R/3 plugins.
• Creating XML files using Datastage.
• Implemented Type 2 SCD for Dimension tables and Hierarchies in Datawarehouse..
• Involved in System Testing and Performance Testing for Enterprise Data warehouse.
• Developed number of Datastage Parallel Extender ETL jobs based on business requirements using various Datastage Component as CDC,Copy, Modify, Aggregator, Filter, Funnel, Join, Lookup, Merge, Datasets, Sequential files and Transformer etc.
• Technical support to other teams of ETL and as well as trouble shooting issues with tool.
• Resolved issues occurred during regular testing and UAT Testing.
• Developed Unit Test\System Test plans for the modules designed and developed.

Confidential, Deerfield, IL

Tech Lead\Senior Datastage Developer

Responsibilities:

• Understanding the specifications for Batch ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Developed high level and low-level designs based on the business and functional requirements documents.
• Supported the extraction of data, from heterogeneous source systems involving Oracle database & Pipe separated flat files.Developed transformations based on the requirements and loaded the formatted data into the target tables using Datastage.
• Identifying Data anomalies using Information Analyzer.
• Reporting Data Quality Issues.
• Developed most Complex Datastage Parallel Extender ETL jobs based on business requirements using various Datastage Component.
• Data Modeling for EOB module and Audit table.
• Migrated existing process from Abinitio\Oracle PL\SQL to Datastage8 Parallel Extender.
• Fine tuning of Batch application Reducing processing time from 72 hours to 24 hours
• Developed batch jobs to produce various Flat File Layouts including Header and Trailer.
• Experience in designing Data Models, and in depth experience in writing SQL’s and tuning SQL’s for performance tuning on Oracle.
• Developed WRAPPER Scripts for BATCH jobs using UNIX.
• Developed SFTP and FTP Scripts.
• Proactively Peer Reviewed Datastage Parallel Extender code developed by junior team member and suggested modification.
• Used Datastage Jobs to Extract, Transform, and integrate data from multiple data sources and performed data cleansing and validations using Datastage predefined functions.
• Used datastage Built in Functions and Transformer stage to enrich and transform the data.
• Implemented partition techniques using the partition methods available in datastage.
• Developed Job Sequences and scheduled them using Datstage director
• Involved in Functional Testing, Regression Testing, Integration Testing, Performance and Load Testing.
• Good experience with testing the Datastage jobs as per the standards and loading the unit test results in the test director.
• Developed Test plans for the modules designed and developed.

Confidential

Senior Datastage Developer

Responsibilities:

• Profiling the data using Datastage Profile Stage.
• Standardizing data, Cleansing Data using Quality Stage
• Performing Column and Table analysis for the source tables.
• Reporting data structure, content and data quality issues in source systems by preparing Summary sheet for each system on the basis of reports generated.
• Interacting with the client for Knowledge Transfer sessions to understand the requirements and the business processes.
• Developed high level and low-level designs based on the business and functional requirements documents..
• Used the Data Stage Designer Parallel Extender to design and develop jobs for extracting, cleansing, transforming, integrating and loading data and performed data cleansing and validations using Datastage predefined functions.
• Developed number of Datastage Parallel Extender jobs based on business requirements for extracting and cleansing using various Datastage Components such as Sort, Change Capture, Dedeuplicate, DB2 Enterprise stage, Datsets, Sequential file stage, merge, join, modify etc.
• Used datastage Built in Functions and Transformer stage to enrich and transform the data.
• Developed Job Sequences and scheduled them using Datstage director.
• Developed Server routines using datastage manger for the project.
• Developed Error Management and Handling system for the project, designed and developed all the Tables required for the error Management.
• Involved in Performance and Load Testing and Reconciliation Process.
• Developed ETL standards for the project.
• Involved in performance tuning of datastage jobs.
• Preparing test cases for the modules designed and developed.
• Peer review of the deliverables.
• Version control using VSS.

Confidential

Senior Datastage Developer

Responsibilities:

• Interacting with the client for Knowledge Transfer sessions to understand the requirements and the business processes.
• The responsibilities include Development and Implementation of DataStage Parallel Extender ETL code using Datastage Designer 7.5.1.A.
• Used DataStage Manager for importing metadata for repository, new job categories and creating new data elements.
• Used the Data Stage Designer to design and develop jobs for extracting, cleansing, transforming, integrating and loading data and performed data cleansing and validations using Datastage predefined functions.
• Developed number of Datastage parallel jobs based on business requirements using various Datastage Stages such as copy, hash partinoning, round robin partioning,Dedeuplicate, DB2 Enterprise stage, Datasets, Sequential file stage, merge, join, modify,transformers etc and Built in Functions for enrichment and transformation of data .
• Developed Server routines using datastage manger for the project.
• Created job sequences and schedules for automation.
• Involved in performance tuning of datastage jobs
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Developed ETL standards for the project.
• Involved in Functional Testing, Regression Testing, Integration Testing, Performance and Load Testing.
• Preparing test cases for the modules designed and developed.
• Played an Configuartion Management Role for the Project
• Received Project Star Award for best performance in the Project.

Confidential

Datastage Developer

Responsibilities:

• Involved in Extraction and Transformation of data from CSV files and other database into data mart.
• Developing DataStage Jobs using Parallel Extender
• Created DataStage server jobs to load data from CSV files.
• Used DataStage Manager for importing metadata for repository, new job categories and creating new data elements.
• Used the DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Created job sequences and schedules for automation.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Unix scripting
• Solving PR and CR reported
• Write test scripts, Perform unit testing.
• Perform peer code review for developers.

Confidential

Senior Oracle Database Developer

Responsibilities:

• Interacted with end users for gathering requirements
• Developed various reports, packages, database procedures, functions and database triggers.
• Developed Quality Check routines that performed database validations as per Buisness rule.
• Developed Table scripts, Indexes and views.
• Involved in the design of tables.
• Developed Dynamic SQL’s.
• Responsibility includes maintaining, and enhancing the programs.
• Developed test data and conducted performance testing on the developed modules.
• Involved in performing unit and system integrated testing.

Confidential

Senior Oracle Database Developer

Responsibilities:

• Interacted with end users for gathering requirements
• Developed complex SQL and Stored Procedures, Packages in PL/SQL.
• Wrote PL/SQL stored procedures to implement business rules and validations. loaded the data from csv files into source tables by using SQL * Loader.
• Developed Table scripts, Indexes and views.
• Involved in the design of tables.
• Developed Dynamic SQL’s.
• Responsibility includes maintaining, and enhancing the programs.
• Developed test data and conducted performance testing on the developed modules.
• Involved in performing unit and system integrated testing.