OBJECTIVE

• Effectively utilizing the technically enriched experience and further leveraging it to higher level cadres thereby being productive and profitable resource of the Organization I work with. And to be a unique player with the right blend of the technical and business domains.

SUMMARY

• Over 14+ years of extensive IT experience with 12+ years in ETL tools using IBM/Ascential DataStage Designer, Manager, Director and Administrator.
• Extensive experience in developing ETL processes to extract, transform and load data from various source and archive systems into Data Warehouses and Data Marts using IBM and Ascential DataStage Designer, Manager, Administrator and Director.
• Detailed and problem solving oriented in DataStage jobs and addressing production issues such as performance tuning and enhancement.
• Expertise in working with various heterogeneous and operational sources like SQL server, ODBC, Oracle, DB2, Teradata, Flat files into a staging area.
• Developed ETL processes that extracts data from SAP and load into TM1
• Diverse knowledge of data dependencies using Metadata of DataStage and preparing job sequences for existing jobs to facilitate scheduling of multiple jobs.
• Worked with production support, ETL Issues and Performance tuning
• Experience in developing Parallel jobs using various stages including Transformer, Aggregator, Sort, Join, Merge, Lookup, Filter, Compare, Funnel, Column Import, Column export, Modify, Remove Duplicates, Change Data Capture, Peek, Head, Tail, Copy, Store procedure, Datasets, Sequential File, XML Input, XML Output, Row Generator and Column Generator etc.
• Excellent in Creating/Developing PeopleSoft Projects, Records/Tables, Fields, Pages, and AppEngine programs to automate job schedule process and run the ETL batch jobs through PeopleSoft EPM.
• Used Netezza Performance Server system analytic appliance to implement Portfolio Management System, Credit Loan Performance, EPIC and Cerner medical billing systems.
• Excellent understanding of business processes & interface with IT
• Strong writing and documentation skills for the management, development and control of documentation
• Substantial ability in cross - functional and global environments to manage multiple tasks & assignments concurrently
• Multilingual, highly organized, detail-oriented professional with strong technical skills
• Exceptional verbal and written communication skills, interpersonal, analytical skills and strong ability to perform as part of a team
• Excellent understanding in business process of Pharmacy Benefit Management System (PBM System), Healthcare, Retail, Insurance, Market Research, Financial and Banking domains.
• Excellent SDLC working knowledge with Enterprise Data Warehouse projects.
• Achieved true end-to-end enterprise meta data integration via meta data sharing among data modeling, data integration and business intelligence tools and standards
• Responsible to work with Critical Production Performance Issues and ETL Performance tuning for various processes

TECHNICAL SKILLS

ETL Tools: IBM InfoSphere/Ascential DataStage 8.7/8.5/8.0.1/7. X (Designer, Director, Administrator & Manager), IBM QualityStage, Data Mining, OLTP, OLAP, SQL*Loader and PeopleSoft EPM 8.9

Reporting Tools: Business Objects 5.0/5.1, Cognos Report Studio

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 3.5.2/3.X and MS-Visio

Databases: Oracle 10g/9i/8i/, PL/SQL, DB2, Teradata 13, MS SQL Server 6.5/7.0, MS Access 7.0/97/2000, MS Excel, Netezza Performance Server, Netezza Aginity, Teradata Queryman, Teradata SQL Assistant.

UNIX Tools: C Shell, K Shell, Bourne Shell, Perl, AWK, VI, SED

GUI: Visual Basic 6.0/5.0/4.0/3.0 , FrontPage 97/98/ 2000

Languages: C/C++, VB Script, JAVA Script, SQL, PL/SQL

Environment: Windows NT 4.0/2000/XP, Win 95/98/3.1, MS DOS 6.22, HP-UX, SCO Unix, Linux, IBM AIX, Sun Solaris, IBM-PC Compatibles

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. IBM DataStage ETL Lead

Responsibilities:

• Responsible to analyze, architecture and design Dynamic and Parameter driven multi instance ETL solutions across PCe member’s projects.
• Responsible to design ETL framework model for PCe member’s projects
• Responsible to design and develop complex Extract, Transform and Load (ETL) processes from various source systems like EPIC and Cerner medical billing systems and Meddius Data Acquisition Pulse systems to target system.
• Responsible to configure and maintain member facing Data Stage servers
• Responsible to Lead and Support co development (co-dev) team members
• Responsible to provide status in daily scrum meetings, sprint planning and retrospective meetings along with sprint demos
• Responsible to work with Critical Performance Issues and ETL Performance tuning
• Analyze, Design and develop Architecture Design and High Level Design documents
• Develop and review Low Level Design and Detailed Design documents
• Create, modify and review ETL Source to Target Mapping Documents
• Responsible to participate in peer review meetings and provide review comments
• Responsible to work with Quality Assurance Testing (QA) and resolving data related and ETL performance related Issues and enhancements.
• Responsible to provide Application Performance improvements, tuning, functional enhancements and resolving performance bottle necks etc.
• Responsible to work with Data Architects and ETL Architect to design, develop and implement multitenant enterprise data warehouse systems and processes.

Environment: IBM InfoSphere DataStage 8.7 (Designer, Director, Administrator), Netezza Appliance Server, Netezza Aginity, NZLoad Script, Oracle, SQL, PL/SQL, Flat files, UNIX, Shell Scripts, Erwin, MS Visio, MS-Office, Autosys, Agile Project Management Tool CODE/JIRA.

Confidential, Bentonville, AR

Sr. IBM DataStage Design Lead

Responsibilities:

• Responsible to work with Critical Production Performance Issues and ETL Performance tuning for various processes
• Responsible to analyze, estimate and design future need of performance growth to increase SKU counts
• Analyze, Design and develop Architecture Design and High Level Design documents
• Responsible to design and develop mission critical Extract, Transform and Load (ETL) processes from various sources to target systems like item complexity, forecast demand, fulfillment, bill of material, vendor cutover, master data and reporting wok bench etc.
• Responsible to provide Performance improvements, tuning, functional enhancements and resolving performance bottle necks
• Develop and review Low Level Design and Detailed Design documents
• Responsible to work with System Integration Testing (SIT) support team and resolving ETL performance related Issues and enhancements.
• Responsible to work with User Acceptance Testing (UAT) team and resolving user queries.
• Responsible to work with Production Deployment and Code Migration Support and resolving code deployment issues.
• Worked with performance improvement strategies by implementing new concepts like database virtual columns, table partitioning algorithms etc. into existing ETL processes.
• Analyzed and proposed new designs to avoid over sorting and unnecessary joins etc.

Environment: IBM InfoSphere DataStage 8.5 (Designer, Director, Administrator), Oracle, Teradata 13, Teradata query man, Teradata SQL Assistant, DB2, Mainframe, SQL, PL/SQL, Flat files, UNIX, Shell Scripts, Erwin, MS Visio, MS-Office, Mainframe CA7, AnthilloPro.

Confidential, Southfield, MI

Sr. ETL DataStage Designer/Lead

Responsibilities:

• Responsible to develop and enhance Relational Data Modeling for Staging and ODS (Operational Data Store) environment
• Responsible to prepare and maintain Production environment
• Developed various ETL processes that extracts data from SAP and load into TM1
• Responsible to develop and enhance Data Base Scripts for Staging and ODS Env.
• Responsible to develop and enhance Batch Scheduling Scripts for Batch Scheduling
• Responsible to develop and enhance Open Process Charts for Batch Scheduling
• Participate in Architecture Design and High Level Design document reviews
• Participate in various Low Level Design and Detailed Design document reviews
• Participate in various Mapping and Test Case document reviews
• Responsible to design and develop various Extract, Transform and Load (ETL) processes from various sources and archive systems into Operational Data Store (ODS).
• Responsible to design and develop ETL processes to populate data from FACETS to ODS and then to Enterprise Data Warehouse (EDW).
• Responsible to develop Member, Provider, Group, Plan, Pharmacy and other ETL processes to load data into DW table after various checks and validations including ETL architecture design and development.
• Responsible to develop Case Management processes to load patient care/case details into DW table after various checks and validations including ETL architecture design.
• Responsible to provide Quality Assurance Testing (QA) support and resolving Issues.
• Responsible to work with System Integration Testing (SIT) support team and resolving ETL Issues and enhancements.
• Responsible to work with User Acceptance Testing (UAT) team and resolving user queries.
• Responsible to work with Production Deployment and Code Migration Support and resolving code deployment issues.
• Responsible to work with Critical Production Support Issues and ETL Performance tuning for various processes.

Environment: IBM InfoSphere DataStage 8.5 (Designer, Director, Administrator), UNIX, TOAD, Oracle 10g/9i/8i, MS SQL Server, MS Access, SQL Script, UNIX Script, PL/SQL, MS-Visio, Axway Automator v4 3, ERwin, SQL Developer, Cognos, Harvest, ACES framework.

Confidential, Deerfield, IL

Sr. ETL DataStage Designer/Lead

Responsibilities:

• Used IBM WebSpehere DataStage 8.0 as ETL tool to Extract, Transform data from source systems such as Oracle, Flat files and load into DSS tables.
• Developed Claim process to load claims into fact transaction claim table after various checks and validations including ETL architecture design and development.
• Developed Drug process to load drug related information into drug related tables after various checks and validations including ETL architecture design and development.
• Developed Patient process to load patient related information into patient table after various checks and validations including ETL architecture design and development.
• Developed Provider process to load provider related information into provider table after various checks and validations including ETL architecture design and development.
• Developed Group process to load group related information into group tables after various checks and validations including ETL architecture design and development.
• Developed ETL audit process called Auto Balancing Audit Control (ABAC).
• Worked with System Integration Testing (SIT) support and resolving ETL Issues and enhancements.
• Developed various ETL processes that extracts data from SAP and load into TM1
• Worked with Production Support and ETL Performance tuning for various processes.
• Developed Technical Design/Design Specification Documents, Mapping Specification Documents, ETL Component Specification Documents and ETL Derivation specifications for various processes.

Environment: IBM WebSphere DataStage 8.0.1 (Designer, Director, Administrator), Ab Initio, Oracle, SQL, PL/SQL, Flat files, UNIX, Shell Scripts, Erwin, MS Visio, MS-Office

Confidential, Deerfield, IL

Sr. ETL DataStage Designer/Lead

Responsibilities:

• Used IBM WebSpehere DataStage 8.0 as ETL tool to Extract, Transform data from source systems such as Oracle, Flat files and load into Billing & Payment tables.
• Developed Billing batch process (Invoicing) including ETL architecture design.
• Developed Payment batch process (Vouchering) including ETL architecture design.
• Developed Customer Billing Transmission (CBT) batch process including ETL architecture design and development.
• Developed ETL audit routine and reusable audit process job
• Worked with System Integration Testing (SIT) support and resolving ETL Issues.
• Worked with ETL Performance tuning for various processes.
• Developed Technical Design/Design Specification Documents, Mapping Specification Documents, ETL Component Specification Documents and ETL Derivation specifications.
• Experience in Parallel Extender (DS-PX) developing Parallel jobs using various stages including Lookup, Aggregator, Join, Transformer, Sort, Merge, Filter, Compare, Funnel, Remove Duplicates, Change Data Capture, Peek, Head, Tail, Copy, Row Generator and Column Generator.

Environment: IBM WebSphere DataStage 8.0.1 (Designer, Director, Administrator), Oracle, SQL, PL/SQL, Flat files, UNIX, Shell Scripts, Erwin, MS Visio, MS-Office

Confidential, Deerfield, IL

Sr. ETL DataStage Developer/Lead

Responsibilities:

• Used IBM WebSpehere DataStage 8.0 as ETL tool to extract data from source systems such as Oracle, Flat files to target system.
• Used Lookup transformations to manipulate the information.
• Used Transformer stage for different transformations and aggregations.
• Experience in Parallel Extender (DS-PX) developing Parallel jobs using various stages including Lookup, Aggregator, Join, Transformer, Sort, Merge, Filter, Compare, Funnel, Remove Duplicates, Change Data Capture, Peek, Head, Tail, Copy, Row Generator etc.
• Used DataStage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Designed and Developed DataStage jobs using DataStage Designer and DataStage Manager. In depth experience in dealing with different stages.
• Used Lookup transformations to manipulate the information.
• Used Transformer stage for different transformations and aggregations.
• Developed DataStage jobs using DataStage Designer and DataStage Manager. In depth experience in dealing with different stages.
• Developed / Enhanced UNIX shell / wrapper scripts to run DataStage sequences.
• Worked with EE stage and developed jobs.
• Developed Technical Design Documents/Design Specification Documents, Mapping Specification Documents, ETL Component Specification Documents and ETL Derivation specifications.

Environment: IBM WebSphere DataStage 8.0.1 (Designer, Director, Administrator), Oracle, SQL, PL/SQL, Flat files, UNIX, Shell Scripts, Erwin, MS Visio, MS-Office

Confidential, Schaumburg, IL

Sr. ETL DataStage Developer

Responsibilities:

• Used DataStage 7.5.2 as ETL tool to extract data from source systems such as Oracle, Mainframe, Flat files to target system
• Used Lookup transformations to manipulate the information
• Used Transformer stage for different transformations and aggregations
• Developed DataStage jobs using DataStage Designer and DataStage Manager. In depth experience in dealing with different stages.
• Used DataStage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Worked with production support, ETL Issues and Performance tuning
• Developed Extract, Transform, and Load processes for extracting data from various systems and loading into Staging Tables, Data Warehouse Tables and Data Mart Tables.
• Worked with Master Data Service (MDS) calls to extract the data from mainframe
• Developed Technical Design Documents/Design Specification Documents, Mapping Specification Documents, ETL Component Specification Documents, ETL Derivation specifications and Unit Test Plan/Case documents
• Designed/Developed and tested DataStage jobs to lead data into DW
• Developed several transformations in the process of building DW

Environment: Ascential DataStage 7.5.2 EE (Designer, Director, Manager, Administrator), DB2/UNIX, TOAD, Oracle 9i/8i, Netezza Performance Server, PL/SQL, MS-Visio.

Confidential, NYC, NY

ETL DataStage Consultant

Responsibilities:

• Used DataStage 7.X/6.X as ETL tool to extract data from source systems such as
• Used DRS and Hashed file Stage as a reference table based on a single key
• Used Lookup transformations to manipulate the information
• Used Transformer stage for different transformations and aggregations
• Developed DataStage jobs using DataStage Designer and DataStage Manager. In depth experience in dealing with different stages including Transformer, Aggregator, Sort, Hash Lookup, Inter Process, Link Collector and Link Partition.
• Worked with EE stage and developed jobs
• Experience in Parallel Extender (DS-PX) developing Parallel jobs using various stages including Lookup, Aggregator, Join, Transformer, Sort, Merge, Filter, Compare, Funnel, Remove Duplicates, Change Data Capture, Peek, Head, Tail, Copy, Row Generator and Column Generator
• Used DataStage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Worked with production support, ETL Issues and Performance tuning
• Extensively worked with PeopleSoft EPM 8.9
• Developed Extract, Transform, and Load processes for extracting data from various systems and loading into PeopleSoft EPM Staging Tables, Data Warehouse Tables and Data Mart Tables.
• Excellent in Creating/Developing PeopleSoft Projects, Records/Tables, Fields, Pages, and AppEngine programs to automate job schedule process and run the ETL batch jobs through PeopleSoft EPM.
• Used Netezza Performance Server system analytic appliance to implement Portfolio Management System and Credit Loan Performance
• Developed Technical Design Documents/Design Specification Documents, Mapping Specification Documents, ETL Component Specification Documents and ETL Derivation specifications.
• Designed data movement processes through a QualityStage application
• Designed/Developed and tested DataStage jobs to lead data into DW
• Developed several transformations in the process of building DW

Environment: IBM DataStage 7.5.1 EE (Designer, Director, Manager, Administrator), DB2/UNIX, PeopleSoft EPM 8.9, QualityStage, Win SQL, Oracle 9i/8i, Netezza Performance Server, PL/SQL, Business Objects 5.1, Windows NT, MS-Visio, Erwin.

Confidential, Lexington Park, MD

ETL Developer

Responsibilities:

• Designed, Developed and tested ETL jobs to lead data into DW
• Responsible for creating/executing and scheduling ETL jobs
• Responsible for creating mapping document
• Used Lookup transformations to manipulate the information
• Designed data movement processes through a QualityStage application
• Performed investigation, Standardization, Matching and Survivorship on the data
• Monitored resolution of data quality and integrity issues

Environment: Ascential DataStage 7.5.1 EE (Designer, Director, Manager, Administrator), Oracle 9i/8i, PL/SQL, MS SQL Server, SQL*Loader, QualityStage, Windows NT, UNIX, Waha Transformer, UDB, Erwin

Confidential

DataStage Consultant

Responsibilities:

• Used Lookup transformations to manipulate the information
• Worked with EE stage and developed jobs
• Used Transformer stage for different transformations and aggregations
• Responsible for creating/executing and scheduling DataStage jobs
• Designed/Developed and tested DataStage jobs to lead data into DW
• Replaced manual extraction with automatic process using DataStage jobs
• Designed data movement processes through a QualityStage application
• Developed several transformations in the process of building DW

Environment: Ascential DataStage 7.5.1 EE (Designer, Director, Manager, Administrator), Oracle 9i/8i, PL/SQL, SQL*Loader, DB2, QualityStage, PeopleSoft EPM 8.9, Teradata V2 R5, Business Objects 5.1, Windows NT, UNIX, Shell Scripting, UDB, Erwin.

Confidential

DataStage Developer

Responsibilities:

• Responsible for creating mapping document
• Interacted with users for report requirements
• Used Transformer stage for different transformations and aggregations
• Replaced manual extraction with automatic process using DataStage jobs
• Used ODBC stage to extract the data from different data sources

Environment: Ascential DataStage 6.0(XE)/5.2, SQL*Loader, Oracle 8i, DB2, ERWIN 4.0, UNIX, Shell Scripts, Windows NT 4.0/2000