SUMMARY:

• More than eight Plus (13+) Years of Data warehousing ETL experience implementing Data Warehousing Applications including Analysis, Architecture, Design, Development, Support.
• Extensive experience in using DataStage 7.5 and 9.1.5 Oracle Data Integrator 11g/ 10.1.3.4/10.1.3.3/ Sunopsis, ETL, Datamart, OLAP, OLTP, Hyperion, Control M
• Solid understanding of Data Cleansing.
• Extensively worked on DataStage Manager, Designer, Director, Administrator and troubleshooting of the packages.
• Expertise includes analysis, design, and development, testing of data warehousing application using DataStage and Oracle Data Integrator ODI.
• Experience in Maintaining Reference Data Management System and Master Data Management System.
• Configuring of DataStage Systems and migrating data from Oracle, DB2, SQL Server, JMS XML Queues and files into Data Warehouse.
• Expertise in developing Strategies for Extraction, Transformation and Loading mechanisms using DataStage.
• Experience in Star / Snow Flake Schema, Conceptual, Logical and Physical Modeling.
• Proficient in Oracle 11g/10g/9i/8i/, MS SQL Server 2012/2008/2000/7.0/6.5, MS Access7.0/2000, SQL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000.

TECHNICAL SKILLS:

• DataStage 7.5, 9.1.5.
• ODI 11g/ 10.1.3.4/10.1.3.3/ Sunopsis.
• MS SQL Server 2012/2008/2000/7.0/6.5 .
• Oracle 11g/10g/9i/8i
• MS Access7.0/2000
• WinSCP.
• Putty.
• MSOffice.

PROFESSIONAL EXPERIENCE:

Confidential

Master Data Management Specialist

Responsibilities:

• Working with the Data Administration staff to develop and maintain Master reference Tables (MRT) data models.
• Developing and maintaining MRT DataStage Packages and supporting files in a UNIX environment to extract, transform, and load authoritative source data into the MRTs.
• Create and maintain shell scripts and master scripts which are used by scheduling systems like Control - M.
• Develop SQL queries using SQL 2012 to modify and update and test the existing data in the database.
• Work with functional managers and the team sponsor to obtain necessary resources to support the team's requirements
• Responsible for doing Data Steward activity which includes adding Disaster Declarations, Interest Rates, Congressional Districts and Indian Tribes to Data Steward Web Application.
• Providing day-to-day data support to Service Center Agency applications as the subject matter expert on the Master Reference Tables (MRT).
• Developing and maintaining project documentation using MS Office Tools
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Developing/enhancing DataStage ETL processes to extract source system data and format it into a consistent format for input to the MDM Initiate system.
• Lead the team of 5, familiarize the team with the customer needs, specifications, design targets, the development process, design standards, techniques and tools to support project task.
• Help keep the team focused and on track, motivate and inspire team members.
• Keep the project manager informed of task accomplishment, issues and status of ongoing projects.
• Ensure deliverables are prepared to satisfy the project requirements and schedule
• Provide day to day Production support.

Confidential

Senior IT Specialist

Responsibilities:

• Actively involved and led multiple projects including Feed replacements for the existing DataStage processes which load multiple tables for MRT’s.
• Providing day-to-day data support to Service Center Agency applications as the subject matter expert on the Master Reference Tables (MRT).
• Working with FSA business personnel to define requirements for extracting source system data for input into the Initiate MDM system
• Involved in training for IBM Initiate tool which is used by MDM.
• Reviewed functional and non-functional system requirements and constructed a conceptual design and detailed designs that align processes and technologies to achieve business objectives.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Worked with DataStage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding. Developed job sequencer with proper job dependencies, job control stages, triggers.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Involved in performance tuning and optimization of DataStage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Used ESP and Control-M job scheduler for automating the daily, weekly and monthly regular run of DataStage job cycle in both Production and Certification environments.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Create technical design documentation for the data models, data flow control process, metadata management and Preparing the mapping document for source to target.
• Created scripts to run on clients Database to diagnose problems and imported the results in form of .csv files and fixed the bugs.
• Participated in weekly/Monthly status meetings, and maintaining project documentation using MS Office Tools.

Confidential

Lead ODI Developer/OBIEE Developer

Responsibilities:

• Reviewed functional and non-functional system requirements and constructed a conceptual design and detailed designs that align processes and technologies to achieve business objectives.
• Worked with Cognos to generate report and these reports were sent through web-browsers to the client.
• Responsible for performance tuning of ETL jobs, extensively used ODI for ETL purposes.
• Assisted in preparing the SOA Designed document with Data Preparation, Data Procession and Data Completion Stage for end-to-end ODI & OBIEE process.
• Configured Oracle Data integrator (ODI) Master Repository & Work Repository on Oracle Database.
• Created ODI Interfaces using ODI Knowledge modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service)
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Create technical design documentation for the data models, data flow control process, metadata management.
• Worked on Insert and Update of the Target by associating the Update Key on the Target.
• Created ODI Datastores in the Model to store the metadata Reverse Engineered from Sources, Imported XML files with hierarchies are maintained under Hierarchy...
• Corrected the erroneous records of target by checking control and errors.
• Worked on ODI Topology, created Data Server, Physical Schema (Data and Work) under data server, Logical Schema as alias for Physical Schema.
• Created Context (DEV, UAT and PROD) to attach more than Physical Schemas to Logical Schema.
• Implemented CDC through ODI Journalization Knowledge Modules (KMs).
• Worked with the PL/SQL, SQL Loader, Toad to check for the quality of data as per the business needs
• Created scripts to run on clients Database to diagnose problems and imported the results in form of .csv files and fixed the bugs.

Confidential

Informatica/ODI (Sunopsis) Developer

Responsibilities:

• Coordinating with the functional team to understand the Budgeting and Forecasting process of the Health Ministry. Created Web Forms and Smart View templates for the users to load their budget and forecast information into Planning.
• Involved in installation, configuration and security setup for Oracle Data integrator 10.1.3.6 on Windows 2003 Platform across all the environments.
• Coordinating with Oracle DBAs in creating master and work repositories for Oracle data integrator (ODI). .
• Creating Metadata Load files for Account, Entity and various other dimensions using the Columns present in the Data stores.
• Configuring a File store, to host all the load files used by ODI.
• Worked with end users for BI data analysis and data validation. Responsible for Master Data Management (MDM) and Data Life Cycle process.
• Creating the Load rules necessary for the data load in Essbase. These Load rules will be leveraged by the ODI for data load.
• Finally creating the Interfaces necessary for Metadata load and Data load in ODI and also creating necessary transformations required for the Data load.
• Loading Actuals and Budget data for GL & Stat accounts into appropriate Essbase cubes using Oracle Data Integrator (ODI) interfaces.
• Automating the Metadata load, Data load and Exports by creating Packages, Scenarios and finally scheduling Scenarios using scheduler within ODI.
• Creating Income Statement, Balance Sheet Report, Cash Flow and several other financial reports using financial reporting studio.
• Managing the Database connections and security for the reports in Workspace.
• Training users in Smart View, Hyperion Workspace, and Financial Reporting Studio.
• Created Maxl scripts & batch scripts for process automation.
• Created Technical Documentation and provided support for testing & knowledge transfer activities.

Confidential

Lead ETL/ODI Consultant

Responsibilities:

• Identified customer requirements, wrote functional designs, reviewed technical designs, developed test schedules and reviewed testing plans, documented development and results of these plans.
• Gathered requirements and design of Data warehouse and Data mart entities.
• Developed various ODI interfaces to load data from Flat file & Relational Sources to Oracle DataMart.
• Worked with data management and other groups to make sure that quality procedures are integrated into their work processes.
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Implement Synchronous and Asynchronous Change Data Capture (CDC) techniques.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it, etc.
• Used Range, List, Hash and Range-List partitioning method.
• Created Bitmap Index as well implemented different Optimizer Hints for tunings.
• Developing of complex Interfaces and packages using ODI tool.
• Analysis and designing of Interfaces pipelines in ODI.
• Created Views, wrote functions, Procedures, Packages in PL/SQL.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created numerous reports, prompts and folders in Oracle Answers and used them in creating dashboards.
• Created Views, functions, Procedures and Packages in PL/SQL.