EXPERIENCE SUMMARY:

• Total 18 years of IT experience in Design, Development and Solution of Enterprise wide IT solutions.
• 12+ years of extensive career experience in Solution architect, Development, Analysis and Design of ETL methodologies in all the phases of the Data Warehousing life cycle and Expert in all the stages of Software Development Life Cycle to large clients in various industries such as Retail, Manufacturing, Banking, Healthcare, and Insurance.
• Over 10 years of extensive experience IBM Web Sphere 11.5/9.1/8.5/8.1.0/8.0.1 (Data stage, Information Server, Quality Stage, Information Analyzer, Metadata Server) and experience in Ascential DataStage 7.5 using components like Data Stage Designer, Data Stage Manager, DataStage Director, DataStage Administrator and Parallel Extender and MQ Series
• 5 Years of experience as Solution Architect in Accenture
• 4 Years of experience as Technical Architect in Data warehousing with Target Corporation
• Strong understanding of the principles of Data Integration Techniques from online and OLTP system with different departments, Data Warehouse using Fact Tables, Dimension Tables, Star Schema modeling and Snowflake Schema modeling
• Experience in MQ connector to send messages from one application to other using datastage
• Integrate SAP BW data to EDW by using datastage
• Experience in Data Modelling, Data Quality and Data Governance
• Implemented successfully Master Data Management for Retail domain
• Implemented Data quality from scratch in card domain with generic framework
• 5 years of experience in product development with Power Builder and Oracle
• Detail oriented with effective communication and presentation skill
• Establish and supported 24*7 Production support activities for ETL
• Trained in Hadoop Administration and ability to manage multi cluster environment
• Good Knowledge of Green Plum

TECHNICAL SKILLS:

ETL Tool: IBM Web Sphere 11.3/ 9.1/8.7/8.5/8.1/8.0.1 ,Data stage, Information Server, Quality stage, Metadata Server, Ascential DataStage 7.5 Quality Stage 7.x, 8.0, Informatica 9.1 and 6.1

RDBMS: Oracle 11g/10g/9i/8i, DB2, Teradata, Sybase

Programming Languages: Unix Shell Scripting, PL/SQL, Power Builder8/7/6/5,VBA,Java

Operating Systems: Linux/Unix, IBM AIX 4.3, Win XP/NT 6.0/5.0/4.0

Tools: FrontPage 98/2000,Star Team, Excel, Power Point, MS VISIO, Erwin, AUTOSYS

EMPLOYMENT HISTORY:

Confidential

Maanger

Responsibility:

• Define Solution architecture to bring data from OLTP health exchange system and integrate with county data supplied by external system and Google analytics
• Involved in understanding Business Process from end users, Data Profiling and coordinated with Business Analysts to solution HADR and bring data in warehouse
• Implemented Infosphere CDC to bring changes from OLTP system.
• Involved in preparing the source to target data mapping for ETL design and development.
• Developed DataStage ETL jobs and Sequencers in the Enterprise Warehouse based on the client’s requirements.
• Designed jobs in Parallel Extender PX using different stages like Transformer, Aggregator, Lookup, Join, Merge, Modify, Remove Duplicate, Oracle Stage, Sort, Peek, Row Generator, Column Generator, Sequential File, and Data Set.
• Performed the Unit testing for jobs, sequencers and services, developed to ensure that it meets the requirements
• Designed the Audit frame work to support the ETL audit requirement to generate audit report for business

Environment: IBM WebSphere DataStage 11.5 (Designer, Quality Stage, Director, Administrator) Oracle12c, DB2, Erwin, TOAD 9.5, Win SCP, Linux, Autosys

Technical Architect

Responsibility:

• Implemented numerous process and performance improvements initiatives in projects (e.g. SVN for version control, ticket management and metadata management)
• Technical deliverables of Project including architecture, design, build and implementation phase
• Participate in Design and development of Source to Target mapping and data profiling activity
• Developed ETL architecture to bring data from different sources

Environment: Informatica 9.6 Oracle, Autosys, AIX UNIX, Shell scripts, MS Visio.

Technical Architect

Responsibility:

• Define architecture to bring data from TSYS and intergrate with Vertica and DB2
• As part of this role, I have implemented conversion program to convert TSYS files of credit cards in readable format and bring data in to ODS place. We have also integrated online marketing data and card statement data to generate promotional offers for credit card customers
• Enhanced system for chip card technology and integrated data with card holder information
• Implemented numerous process and performance improvements initiatives in projects (e.g. SVN for version control, ticket management and metadata management)
• Technical deliverables of Project including architecture, design, build and implementation phase
• Architected framework for data quality tracking and process balancing checkpoints.
• Co - ordinate and communicate with cross functional team
• Designed Various Data stage Jobs for the dimensions and fact tables using Join, Transformer, Funnel and Oracle Connector stages of Data stage.
• Worked with the IBM CDC replication team to move the data from the Fusion Hub to the DMS system.
• Developed the Automation Process to run the conversion process for the multiple dealers using the Data stage Start loop activity, End Loop Activity and Nested condition

Senior Software Engineer

Responsibility:

• Reviewed the Functional Design Specification (FDS) provided by the Business Team, Raised concerning issues present in the FDS by understanding the functionality illustrated to do the conversion.
• Extensively used IBM DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Marts and Involved in preparing of High Level, Low Level Design Documentation.
• Developed and loaded data warehouse tables such as dimension, fact and aggregate tables using IBM DataStage
• Managed multiple releases at same time

Programmer Analyst

Responsibility:

• Developed ETL architecture for Vendor Report Card using Data Stage
• Developed framework for common shared object to align with strategies for Enterprize Data warehouse
• Integrate Target.com data with Guest data warehouse for marketing team
• Integrate Purchase Order and Automatic Receiving technique data with data warehouse
• Solution framework for Back haul to support optimizing techniques for container movement from Import warehouse with Regional Distribution center
• Implemented concept of common business reference data and technical meta data
• Architected Audit framework and automate this with Control-M so that report will be available on time
• Implemented common technical framework for Key generation and key validation in warehouse to maintain standards around ETL processes
• Created ETL Architecture for developer community to use across enterprise wide.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts
• Along with technical work, several improvement in defining standards around ETL processes which were brought in client team attention and successfully implemented in projects
• Perform data modelling activities and help in implementing meta data management and version mechanism in Erwin subject area

Environment: IBM WebSphere DataStage 7.5 (Designer, Director, Administrator, Quality Stage), AQT, Erwin, DB2, Autosys, AIX UNIX, Shell scripts.

Developer

Responsibility:

• Developed DataStage Parallel & Server jobs for extraction transformation and loading of the data from source systems.
• Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs.
• Extensively used all activities like Routine Activity, Wait for File Activity, Exception Handler and Notification Activity.
• Worked extensively on different types of stages like Sequential file, Lookup File set, ODBC Stage, Aggregator, Transformer, Copy, Merge, Join, Filter, Column Generator, Funnel, Peek, Change Capture, Change Apply Stage, and several other stages for developing Parallel Jobs.
• Used DataStage Director to Run and Monitor the Jobs performed, automation of Job Control using Batch logic to execute and schedule various DataStage jobs.

Environment: IBM WebSphere DataStage 7.5 (Designer, Director, Administrator, Quality Stage), AQT, Erwin, DB2, Autosys, AIX UNIX, Shell scripts.

Software Engineer

Responsibility:

• Writing mapping specification and developing mapping and creating sessions and workflow (Informatica ETL) to achieve population of data in different data marts like (Household profiler and finance data mart) from Marketing data warehouse.
• Interpreted logical and physical data models for Business users to determine common data definitions. Analyzed the Data models of the source systems to develop Mapping Specs
• Extensively used Informatics client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager to achieve data population in various data marts.
• Developed Scripts to automate the Data Load processes to target Data warehouse
• Responsible to tune ETL procedures and schemas to optimize load and query Performance. Extensively used various Performance tuning Techniques to improve the session performance (Partitioning etc).
• Designing and developing stored procedures to extract data from the external feeds and load it into data warehouse and data marts. 
• Developed shell scripts and stored procedures to achieve pre and post ETL processes objectives

Environment: Informatica Power Centre 6.1, Business Object 6.1

Application Programmer

Responsibility:

• Wrote gap analyses document.
• Develop Data Model for the Budget Module.
• Design of Forms by using PowerBuilder and PFC

Environment: Software: PowerBuilder, Erwin Database: ORACLE 8.0