SUMMARY

• Ten Plus years of IT experience in Implementation, Production support of various projects using Data Warehousing Tools, Reporting Tools, Data migration Projects and ERP Applications.
• Extensive experience in design and developing ETL interfaces/SQL Scripts for large scale data migration projects.
• Strong Business Intelligence Implementation Experience Using IBM Web Sphere Data Stage 9.1/8.1/7.x/6.x and BW 7.0/3.5, Business Objects 3.1 and Teradata.
• Extensive experience using Dimensional Data Modeling - Star Schema, Snow-Flake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Strong working experience with BI Components Info Cubes, Data Store Objects, Process Chains, Info Packages, DTP, Reporting and fixing data load issues.
• Excellent knowledge in HANA Modeling, BW Powered by HANA.
• Excellent knowledge in HANA Data Provisioning using SAP LT Replication Server (SLT).
• Experience with HANA data modelling using Attribute views, Analytic views and Calculation views.
• Experience with HANA security (User management/Roles/Privileges), SQL,SQL Script & CE script
• Extensively Worked with BO Universe, Webi, BexQuery Designer, WAD and Visual Composer.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Excellent experience in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports.
• Excellent Hands on experience with SQL Scripts and Database Stored Procedures.
• Involved in design and development of queries, workbooks from InfoCubes, DSO and MultiProviders.
• Extensively worked with Customizations-Data Source Enhancements, User Exits, Data extraction from flat files for master data and transactional data, update/transfer rules creation and Business Content Activation.
• Extensive experience in Loading and Extracting Data from SAP ECC / BW using IBM SAP BW Pack 4.0/4.1 and SAP R3 Pack 5.0.
• Extensive experience in Data Cleansing and Address Standardization using Trillium.
• Strong working experience on Data Warehousing applications, designed and developed solutions for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Extensively worked with various DB/Sources Teradata, Oracle, SQL Server, MS Access, Flat files and XML for data extraction and data loading.
• Experience in requirement gathering, Preparing Tech specification and implementation, end-user training and documentation.
• Hands on experience in all aspects of software development life cycle (SDLC), SOA & Agile Software Development.
• Possesses Technical, Project management skills and Involved in different phases of Project life Cycle.
• Provide project planning and resource estimation. Test and evaluate new products.

TECHNICAL SKILLS

Primary Skills: IBM Info Sphere Data stage 9.1/8.1/7.5, SAP BW 7.0/3.5, ECC 6.0, SQL Server and SAP HANA.

Languages: C, C++, Java/J2EE, VB, VB Script, ASP, JSP, UNIX Shell Scripting, SQL*Plus, PL/SQL, ABAP/4.

Database: HANA1.0, Teradata, Oracle 9i/8i, MS SQL Server, DB2 UDB, MS Access.

Reporting Tools: Business Objects 3.1, Business Explorer, WAD and Visual Composer.

Modeling Tool: Microsoft Visio 2000, TOAD, Rational Rose.

Web Server: IIS, Apache, Java Web server, Web Sphere Application Server.

OS: Sun OS, UNIX, Linux, MS-DOS and Windows.

PROFESSIONAL EXPERIENCE

Confidential

Sr.Consultant

Responsibilities:

• Which involves implementing Infor AS/AP SCM Solution across all Plants.
• Responsible for Technical design of Interfaces for 12 Breweries in a phased manner as per Brewery Go-live schedule.
• Responsible for Business requirement gathering and creating technical requirement documents as required by development teams.
• Extensively Involved in Design, Development and Deployment of data Integration interfaces for Infor, SAP and Legacy applications using SQL Scripts and IBM Info sphere Data stage.
• Responsible for Creating ETL technical/mapping documents and development/deployment of Brewery Planning Project Interfaces.
• Responsible for development and deployment of scheduling jobs for using IBM Work load Scheduler.
• Managed offshore development team for delivery /support of Project requirements as per the time line.
• Supporting/Training the offshore team for timely delivery of the Project requirements.
• Involved in Creation/Enhancing of Multiple SQL Objects like (Tables, Synonyms, Functions, Stored Proc, Triggers, Views, etc.,) as required by the Brewery Planning Project.
• Responsible for promotion of all the technical changes across Brewery Planning Project during each go-live phase and break-fixes.
• Resolved all the Production issues during Go-Live, Hyper care and transitioning to support teams.

Environment: IBM Info Sphere Information Server 9.1, Data Stage 7.x/9.1, SQL DB, Infor 10, SAP SNP, UNIX, and IBM Work Load Scheduler 3.1.

Confidential

Sr.Consultant

Responsibilities:

• Which involves implementing SAP APO Solution for ABI’s 12 Breweries.
• Extensively Involved in Design, Development and Deployment of APO data Integration interfaces for SAP and Legacy applications using IBM Info sphere Data stage.
• Responsible for Creating ETL technical/mapping documents and development/deployment of APO DP and SNP ETL Interfaces.
• Involved in development and deployment of scheduling jobs using IBM Tivoli.
• Responsible for Business requirement gathering and supporting offshore team for timely delivery of the objects.
• Involved in IBM Info sphere Data stage upgrade from 8.x to 9.1. Extensively involved in testing multiple interfaces during the upgrade.
• Trained Offshore team for developing APO related ETL interfaces, configuring datastage and SAP connector.
• Involved in SAP Plugin upgrade and testing of all the interfaces which are using SAP/Datastage Plugin.

Environment: IBM Info Sphere Information Server 9.1, Data Stage 7.x/9.1, BW 7.x, SAP SNP, Teradata, Oracle, UNIX, and IBM Work Load Scheduler / Tivoli.

Confidential, Dublin, OH

Sr.Consultant/Integration Architect

Responsibilities:

• Worked as Sr.Consultant for Building MBT (MedicalBusinessTransformation) Hybrid Business Intelligence Solution using SAP /Data stage/ Teradata / Business Objects.
• Responsible for Analyzing BW Open hubs/Data sources/ ECC extractors for the Interface requirements and updating the development team for required enhancements to the Open Hubs/DSOs/ Data sources/ETL Interfaces.
• Responsible for Business requirement gathering and ETL architecture and Developing ETL Jobs.
• Involved in preparing technical design documents from BW/Data stage/Teradata.
• Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Alerts, Breaks, Prompts and Formula using Web intelligence.
• Formatted Reports as per the User requirements using the functionalities in Business Objects, which allows the users to analyze the data.
• Involved in Training Power users and end-users on Universes Created and Reports.
• Involved in the Integration Architecture for the Conversion Objects from SAP and non-SAP sources to MBT ECC using IBM’s RTL Methodology.
• Responsible for Coordinating with FDA’s, Process team for the functional requirements analysis and translate them to High level design and Technical Spec as per standards.
• Involved in preparing and implementing conversion designs for Master Data and Transactional Data (Includes Data cleansing and Mater data/Address standardization) using IBM Information Server.
• Responsible for working with development leads (ETL) for effective development and testing the solution.

Environment: SAP BW 7.x, SAP ECC, Solution Manager 7.0, Teradata, DB2, Business Objects 3.1, IBM Info sphere Information Server 8.1, Data Stage v8.1,Sybase Power Designer and Linux.

Confidential, St.Paul, MN

BI Consultant

Responsibilities:

• Worked on Clear View and Pulse Project data integration from external systems to Data Warehouse and Hyperion Essbase using IBM Web sphere data stage.
• Involved in creation of Data Sources, Info Sources and Source Systems for extraction of data from External systems to Data Warehouse.
• Designed and developed Data stage Jobs to extract data from multiple source systems and loading it to target system.
• Worked with DTP to transform and map the data extracted through Open Hub Service.
• Created Info spokes and Process chains for extracting data from Data warehouse system called these process chains and Info spokes from the third party tools.
• Designed and developed process for non-SAP source stems data into BW using push and pull options.
• Designed and created Queries, Reports and Workbooks using Bex Analyzer and Query Designer.
• Worked extensively on data load Issues from external systems to BW.
• Installing and Configuring Data stage SAP Packs and Hyperion Essbase Packs for IBM Data stage.

Environment: IBM Info sphere Data Stage v8.1, SAP BW 7.0, SAP ECC 6.0, Oracle, SQL Server, Linux, and Hyperion Essbase.

Confidential, Beaverton, OR

BI Consultant

Responsibilities:

• Worked as BI consultant for Release Cycle which involves HUT, SIT, WIL and dry run Process of Confidential America, Europe and Confidential Asia BI systems.
• Extensively involved in fixing the issues with BC, LO and Generic data sources.
• Develop/Enhance BI architecture by modeling, designing, testing and appropriate backend structures(including extractors, Data sources, PSA, DSOs Info Cubes and Info providers) need to meet business reporting requirements.
• Worked on highly customized data model employing Transactional ODSs, Custom Code to manage common data from multiple source systems.
• Fixing of all the BI process Issues in the B3/B4 architecture (i.e. Staging layer, Integration layer, Operational layer and Analytical layer) and ensuring data is available for Business user reporting.
• Involved in fixing of Master Data & transactional data load Issues and ensuring data availability for business reporting.
• Extensively worked on the data load issues from SAP ECC and External systems to Data Warehouse.
• Working with functional, Configuration and Basis teams for fixing Issues.
• Created OLAP Universes and Webi reports on top of BW Cubes and Bex queries.
• Trained business users for creating ad hoc reports using BO Webi.
• Fixing the problems with process chains, scheduling the process chains and working with Autosys team for fixing the process issues.

Environment: SAP BW 7.0, ECC 6.0, Oracle, SQL Server, Business Objects 3.1, Informatica, Windows XP, UNIX, Shell Scripting.

Confidential, Marysville, OH

ETL/BI Consultant

Responsibilities:

• Created standard and custom Info Cubes, Info Object and Info Sources, Web reporting, Extraction, Transfer Structures, Operational Data Store (ODS), and queries using Query designer.
• Used IBM Data Stage as an ETL tool to extract data from different source systems (SAP R/3, Flat Files, SQL Server, DB2, SAP BW) to Target SAP BW, SAP R/3 and Oracle.
• Experience in extracting data from SAP R/3 using LO Cockpit, Generic Extraction, and BC extraction.
• Extensively worked on Develop/Enhance data loads (Full/Init/Delta) from ECC, Data loads from Flat files and external system to BW Objects (Info Cubes/ODS/PSA).
• Developed SQL Stored Procedures for efficient execution of complex logic in DB and Executing Stored Procedures from Data stage Jobs.
• Extensively worked with Source systems, data sources, info sources, transfer rules, update rules, Info providers and work books.
• Installed and Configured Ascential BW Pack and R/3 Pack.
• Created OLAP Universes and Webi reports on top of BW Cubes and Bex queries.
• Supported business users for creating ad hoc reports using BO Webi.
• Overall responsibility for planning and implementation of architecture in a Data stage environment. Lead a team from Offshore and Onsite.
• Installed and Configured Data Stage Server and Clients.
• Used Data Stage Designer to develop interfaces for extracting, transforming, integrating, and loading data into SAP BW and SAP R/3.
• Developed Trillium Batch/Real time Jobs for Data Cleansing and Address Standardization.
• Developed several transformations in the process of building Data Warehouse database.
• Extensively used SAP BW load, SAP BW Extract, ABAP, R3, and IDOC stages in Data Stage Development.
• Involved in testing of Data Warehouse upgrade projects.

Environment: Ascential Data Stage 7.5,SAP BW 3.5, ECC 5.0,SAP CRM, Business Objects 3.1,Quality Stage, SAP BW Load Pack, SAP R3 Pack, Java Script, Trillium 7.x, AS400, Oracle,SQL Server, Windows XP, SUN UNIX, Shell Scripting.

Confidential, Marysville, OH

ETL/BI Consultant

Responsibilities:

• Involved in Requirement gathering and Creation of Source system, data sources, info sources, transfer rules, update rules, and Info providers.
• Used IBM Data Stage as an ETL tool to extract data from different source systems (SAP R/3, Flat Files, SQL Server, DB2, SAP BW) to Target SAP BW, SAP R/3 and Oracle.
• Designed and Implementation of ETL architecture in IBM Data Stage Environment.
• Installed and Configured IBM Data Stage Server and Clients.
• Installed and Configured Ascential SAP BW Pack and R/3 Pack.
• Created Source systems and Infopackges, which connects Data Stage and SAP BW for loading data to PSA, ODS and Info Cubes.
• Used Data Stage Designer to develop interfaces for extracting, transforming, integrating, and loading data into SAP BW and SAP R/3.
• Developed Trillium Batch Jobs for Data Cleansing and Address Standardization.
• Developed several transformations in the process of building Data Warehouse.
• Extensively used SAP BW load, SAP BW Extract and ABAP stages in Data Stage Development.
• Used Lookup transformations to manipulate the information.
• Developed user defined Routines and Transformations.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.
• Worked on Universe Database to create Hash Files, Intermediate files while ETL process.
• Involved in end user training and working with user groups in the various phases of the implementation.

Environment: SAP BW, SAP R/3, SAP BW Load Pack, SAP R3 Pack, Ascential Data Stage 7.5, Windows NT, AS400 DB2, Oracle, SQL Server, SUN UNIX, Shell Scripting.

Confidential, Detroit, MI

ETL Consultant

Responsibilities:

• Created ODS and Info Cubes as per requirement.
• Used IBM Data Stage as an ETL tool to extract data from different source systems (SAP R/3, Flat Files, SQL Server, DB2, SAP BW) to Target Enterprise Data Warehouse, SAP R/3 and Oracle.
• Installed and Configured Data Stage Server and Clients.
• Extensively used DATASTAGE Px for ETL design and development.
• Prepared ETL Design document.
• Used Sequential File stage, CFF Stage, Oracle 9i Stage, Look up stage, Datasets, Joiner stage, Transformer, Aggregator stages, Filter, merge, Funnel, Remove duplicate, FTP, SAP BW and SAP R3 Stages.
• Used Job Sequencer and the Job Control to prepare master jobs.

Environment: Ascential Data Stage 7.1,SAP BW, SAP R/3, SAP BW Load Pack, SAP R3 Pack, Windows NT, SUN UNIX, Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Used Data Stage as an ETL tool to extract data from sources systems to Target Database Oracle.
• Designed complex Data Stage mappings between sources (external files and databases) to Operational staging targets using Oracle as the target database in Data Warehouse.
• Used Data Stage Designer to develop jobs for extracting, transforming, integrating, and loading data into data warehouse database.
• Developed several transformations in the process of building Data warehouse database.
• Developed Stored Procedures for Oracle Database and calling them from data stage.
• Used Complex Flat File Stage In server Jobs to Load Data from Mainframe Systems.
• Used Lookup transformations to manipulate the information.
• Developed user defined Routines and Transformations, Scheduling the Jobs Using Autosys.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.
• Worked on Universe Database to create Hash Files, Intermediate files while ETL process.
• Interacting with User Groups/ Corporate Testing Groups/Business people.

Environment: Ascential Data Stage 7.0,AS400, Oracle 9i, PL/SQL, SQL Loader, Business Objects, MVS, Lotus Notes 5.0, Windows NT, UNIX AIX, Shell Scripting.