SUMMARY

• More TEMPthan 12 years of SAP BW experience.
• About 4 years of experience of HANA 1.0 as HANA Modeler/Architect
• About 7 years of experience on BODS
• More TEMPthan 15 years of experience in Data warehousing and SAP R/3 Enterprise.
• More TEMPthan 5 years of Business Objects experience
• Proficient with planning, analysis, design implementation (LSA), trouble shooting and performance testing support of SAP BW.
• Involved in implementation of SD, MM, FI, CO,IM,PM and HR modules
• Involved in Design and implementation of SAP BW using ASAP Methodology
• Extensively worked with ABAP on User Exits, Update Rules and Transfer Rules
• Developed Crystal Reports and Bex Reports.
• Worked on BO 4.1/3.X (Web Intelligence, Xcelsius and Universe Designer)
• Excellent planning, analytical, written Communication and Interpersonal skills.
• Work experience of 2 years in Informatica
• Knowledge of CRM, APO, SEM
• Knowledge of RDS, SAP River, Predictive Analytics, R Language

TECHNICAL SKILLS

.SAP Functional Expertise: Defining Functional Requirements based on User Requirements, Interacting with business users to gather requirements, Assisted in developing InfoObjects, DSO, InfoCubes, Queries, Reports. Implementation experience of SD and MM modules. Good working experience of New Dimension Products SEM and APO

SAP Technical Expertise: SAP R/3 4.6C, BW 3.5/BI 7.0 with SAP Tools (AWB, BEX Query, ABAP Editor, Extraction process for both R/3 and non - SAP OLTP systems, Generation of web reports using SAPGUI for HTML), Worked with Business Objects (Web Intelligence and Dashboard/Xcelsius) and HANA 1.0 (SP7) Technology.

PROFESSIONAL EXPERIENCE

Confidential, Newark NJ

HANA Architect/Lead Developer

Environment: BOBJ 4.0 SP4, SAP BW 7.3, Native HANA 1.0(SP7), SAP ECC, ABAP/4 HANA 1.0, HANA Studio, ISU(MI,CRM,UCES,CPI), SLT, BODS 4.2, Maximo, IDT, Webi, Dashboard, Design Studio, Lumira

Responsibilities:

• Involved in XI2 Reports migration to BI 4.1
• Design and Development of Universes using IDT needed for teh reports upgradation from UDT
• Worked on Single Sign On for teh BOBJ applications
• Involved in guiding teh future strategy like HANA/Big Data
• Worked on performance testing of HANA models
• User Interaction for data validation and approvals of teh Webi reports
• Design and development of Dashboards using universes
• Trained Business users on teh reporting usage

Confidential, Wichita KS

BW HANA Architect/Lead Developer

Environment: BOBJ 4.0 SP4, SAP BW 7.3, Native HANA 1.0(SP7), SAP ECC, ABAP/4 HANA 1.0, HANA Studio, SLT, BODS 4.2, Maximo, IDT, Webi, Dashboard, Design Studio, Lumira

Responsibilities:

• Interacted with Key Business Managers for gathering teh requirements, prepared Technical Specifications based on teh Functional Specifications
• Designed and developed Attribute views, Analytic Views and Calculation views
• Worked on SQL Scripting to derive teh complex Calculation view
• Designed and developed teh native HANA applications (HANA Modeling, Trouble shooting, Debugging)
• Extracted data from ECC system into HANA Database using BODS for Finance Applications
• Did ECC tables replication to HANA system
• Exported teh Developed views to Test and Production Systems using Application Life Cycle Manager
• Created Analytic Priveleges
• Worked on performance testing of HANA models
• Established teh systems and procedures for teh Finance Reporting Systems for teh first time.
• User Interaction for data validation and approvals
• Guided teh HANA developer, Webi Reporting developer and also offshore time to deliver teh reporting applications.
• Trained Business users on teh reporting usage

Confidential, Hershey PA

BW HANA Architect/Lead Developer

Environment: BOBJ 4.0 SP4, SAP BW 7.3, SAP BW 7.3 on HANA 1.0(SP9), SAP ECC,ABAP/4 HANA 1.0, HANA Studio, Jira, Remedy,HP Quality Center, Mulesoft, JDA Supply Planning, Life Cycle Manager

Responsibilities:

• Designed and developed Attribute views, Analytic Views and Calculation views. Worked on SQL Script to deliver teh data from HANA to teh Unix Server database.
• Worked on Smart Data Access
• Interacted with Key Business Managers for gathering teh requirements, prepared Technical Specifications based on teh Functional Specifications
• Designing teh BW data extractors, DSOs and later on building Analytic Views on DSOs, creating Calculation view.
• Exported teh Developed views to TEST and Production Systems using Application Life Cycle Manager
• Created Analytic priveleges and SQL Procedures
• Worked on performance testing of HANA models
• Established teh systems and procedures for teh HANA Environment for teh first time.
• Established teh naming conventions, development land scape for HANA environment.
• Hershey is having Standard BW system on Oracle and also BW on HANA (Sidecar concept). All teh critical applications are being developed in BW on HANA.
• Developed teh generic data sources based on Function Module, Views, Tables needed for teh Project. Completed teh BW development to load teh data in to BW on HANA.
• Worked with models related to Supply Chain Management Area
• Developed Shipper Reporting Application and Packaging Datamart Application

Confidential

Lead Application Consultant

Environment: BOBJ 4.0 SP4, SAP BW 7.3 SP8, SAP ECC,ABAP/4, Microsoft SQL Server, Oracle Databases, Information Design Tool, Web Rich Client, Web Intelligence, Dash Board Designer, Solution Manager, BWA, HANA 1.0, BODS 4.2, CMC, BI Launch Pad, Design Studio

Responsibilities:

• Worked on Plant Alanytics applications extensively (Supply Chain Management, MM,PP,SD,IM).
• Part of Technical upgrade of BW 7.0 to BW 7.3
• Involved in HANA Migration with DMO OS/DB provided by SAP
• Worked on HANA 1.0 Data Provisioning involving teh areas SLT, BODS
• Worked on HANA 1.0 Data Modeling involving Attribute Views, Analytic Views, Calculation Views, SQL Script
• Worked on conversion of Infocubes, Standard DSOs to HANA Optimization in BW on HANA landscape.
• Worked on SAP Business Content related to HANA like Time Data
• Built Transient Infoproviders, Composite Infoproviders using BW HANA optimized Infoproviders along with HANA Views
• Extracted HANA views data via DB Connect in SAP BW staging process
• Involved in teh design, development and implementation of Valve Test Results application project, source data from Oracle databased of Valve tests information (Allan Bradely Testers).
• Designed and developed Pitch Chart application to display plan, actual production on teh dashboard, source data from SQL Server databases (Vorne Machines Interfaces).
• Worked on Business Objects 3.X/4.0 Environment (Web Intelligence, Dashboard Designer) Creating teh Universes, Creating Webi Reports and Dash Boards/Xcelsius.
• Created Universes based on Multiproviders after interacting with teh keybusiness Users.
• Created Dash Boards making connection using BICS.Designed Dash Boards making use of maps, guages, pie charts, alertscharts, selectors.
• Design of teh BW system consists Start Routines, Update rules.
• Design and Development of InfoObjects, DSOs and InfoCubes, Data Extraction from SAP R/3 and legacy systems.
• Creating reports using BEx Analyzer using variables, calculated key figures, restricted key figures, wherever required for queries to generate reports
• Transported teh BW objects to testing/production systems from development system using Change and Transport Organizer
• BW Support to take care of Plant Analytics Dashboards round teh clock
• Facilitated migration of Microsoft based applications to robust QlikView applications and trained Key Business Users.
• Worked on Design Studio creating teh reports for Plant Analytics
• Involved in teh migration of BODS 4.1 to 4.2

Confidential, North Carolina

Sr Consultant

Responsibilities:

• Gather and document teh detailed reporting requirements and recommend BI Solution Architecture that best satisfies teh business need
• Conducted workshops to gather functional requirements from business users and management
• Involved in BW 3.0 Migration to BI 7.0
• Design and Development in BI 7.0
• Worked on Business Objects 4.0 Environment (Web Intelligence, Dashboard Designer) Creating teh Universes, Creating Webi Reports and Dash Boards.
• Created Universes based on Multiproviders after interacting with teh keybusiness Users.
• Created several Web Intelligence queries with cross tabs, grouping of data,context operators, YTD calculations etc.
• Created Web Intelligence Reports using BICs connection on BEx queries.
• Created Dash Boards making connection using Query as a Webservice.Dash Boards designed making use of maps, guages, pie charts, alertscharts, selectors.
• Involved in implementing BW development using SAP Solution Manager 4.0
• Involved in teh design, development and implementation of Hand Held Mobile application project called Project Speed
• Desing of teh BW sytem consists Start Routines, Update rules, Currency Conversion to meet teh reporting requirements.
• Design and Development of InfoObjects, DSOs and InfoCubes, Data Extraction from SAP R/3 and legacy systems.
• Creating reports using Bex Analyzer using variables, calculated key figures, restricted key figures, wherever required for queries to generate reports
• Transported teh BW objects to testing/production systems from development system using Change and Transport Organizer
• Worked extensively with ABAP for start routines, update rules, transfer rules, APD processes
• Process chains design and development
• Build Infoproviders using APD process
• BW Support to take care of data load issues, hyper care, performance tuning, root cause analysis

Confidential, North Carolina

SAP BW Team Lead Consultant

Responsibilities:

• Gather and document teh detailed reporting requirements and recommend BI Solution Architecture that best satisfies teh business need
• Conducted workshops to gather functional requirements from business users and management
• Involved in BW 3.0 Migration to BI 7.0
• Design and Development in BI 7.0
• Worked on Business Objects 3.X Environment (Web Intelligence, Xcelsius 5.4) Creating teh Universes, Creating Dash Boards
• Created Universes based on Multiproviders after interacting with teh keybusiness Users.Exported them to teh folder on teh Enterprise Server
• Created several Web Intelligence queries with cross tabs, grouping of data,context operators, YTD calculations etc.
• Created Dash Boards making connection using Query as a Webservice.Dash Boards designed making use of maps, guages, pie charts, alertscharts, selectors.
• Involved in implementing BW development using SAP Solution Manager 4.0
• Involved in teh design, development and implementation of Regional Controlling Reporting System in Business Warehouse.
• Involved in design, development and implementation of EDW Migration to SAP BW Migration in totality involving Sales and Distribution, Inventory Management, Supply Chain Management, Production Planning.
• Desing of teh BW sytem consists Start Routines, Update rules, Currency Conversion to meet teh reporting requirements.
• Design and Development of InfoObjects, DSOs and InfoCubes, Data Extraction from SAP R/3 and legacy systems.
• Developed reports using business explorer.
• Interacting with Systems group for transports by sending requests for teh same.
• Implemented extraction, transformation and loading (ETL)of data to Business Warehouse objects from Legacy systems using Business Objects Data Integrator.
• Optimization of BW system using line item dimension, aggregation and partitioning techniques.
• Creating reports using Bex Analyzer using variables, calculated key figures, restricted key figures, wherever required for queries to generate reports
• Transported teh BW objects to testing/production systems from development system using Change and Transport Organizer
• Worked extensively with ABAP for start routines, update rules, transfer rules, APD processes
• Process chains design and development
• Developed Infospokes and Open Hubs
• Build Infoproviders using APD process
• BW Support to take care of data load issues, hyper care, performance tuning, root cause analysis

Confidential, Boston, USA

SAP BW Team Lead Consultant

Environment: SAP BW 3.1,FI, ECCS, SEM 3.1B, Arc Plan 4.0, SAP R/3 4.6C, Oracle 9.2, Sun OS, Cognos.

Responsibilities:

• Worked for Project Renaissance, a SAP BW Global Data warehouse for Corporate Finance Reporting system which went live on 3rd February,2005.
• Monitoring of Data loads on daily basis, identification of errors and rectification
• Reconciliation of data loaded in to BW system consisting of several ODSs and Several InfoCubes
• Creation of Aggregates, evluation based on teh study of existing queries based on RSRT analysis
• Compression of InfoCubes from time to time after verification of data
• Performance tuning of teh BW system
• Modification and development of queries using webtools
• Study and modification of transfer rules, update rules for performance improvement
• Design and development, modification of process chains
• Design and development, modification of BEx reports
• Transportmanagement of Process chains
• Error resolution for data loading
• User Interaction

Confidential, North Carolina, USA

SAP BW Technical Lead Consultant

Environment: SAP BW 3.1, SEM 3.2, SAP R/3 4.70, FI-FM(BCS), SQL Server 7.00, Unix, NT, ABAP/4, SAP Portal 6.2

Responsibilities:

• Worked along with Development team from start to Go live period, Project Preparation, Blueprinting, Realization, Final Preparation and Go live and Support
• Development of Reports as per user needs
• Training of end users
• Creation of users and authorization for reports usage
• Design and Development of Reports and InfoCubes for Historical data of AMS system in Finance, HR, Payroll, Purchase, Budget areas
• Design and Development of Reports and Transactional InfoCube for FM-BCS in SEM-BPS:Creating planning area, planning profiles, entering data by manual planning
• Searching Notes and Opening tickets using OSS (Online SAP Service)
• Performance tuning of BW system using compression of InfoCubes
• Experienced with setting up connections between R/3 and BW systems
• Transported teh BW objects to testing/production systems from development system using Change and Transport Organizer
• Experienced with design and development of BPPs using RWD InfoPak publisher.
• Experience with SAP BW Webreporting using Portal
• Experience in installation of BW software and update with patches
• Configured teh BW system with R/3 and also created teh users
• Transported from DEV to QAS and Production Systems

Confidential, Basingstoke UK

Senior SAP BW Support Consultant

Environment: SAP BW 3.1(3.3BI Content Add On), SAP R/3 4.70, FICO, MM, SD, QM Modules, Oracle 9.2, Unix, NT, ABAP/4

Responsibilities:

• Worked along with Development team during Go live period
• Daily monitoring of Data loads
• Development of Reports as per user needs
• Trained end users
• Creation of users and authorization for reports
• Laison with IBM AMS team for any new developmental issues
• Searching Notes and Opening tickets using OSS (Online SAP Service)
• Performance tuning of BW system using compression of infocubes
• Experienced in Inventory cubes (Non Cumulative)
• Reconciliation with R/3 data from time to time
• Experienced with setting up connections between R/3 and BW systems
• Transported teh BW objects to testing/production systems from development system using Change and Transport Organizer
• Experienced with setting up of clients in BW and R/3

Confidential, Paris

Senior SAP BW Consultant

Environment: SAP BW 2.1C/3.0B,SAP APO 3.0A,SAP R/3 4.6B,Oracle 8,Unix,NT,ABAP/4, Informatica

Responsibilities:

• Involved in teh design, development and implementation of Business Warehouse using Star and extended star schema. Administering teh BW system, configuring teh system and users. Coordinate with SAP Basis people from teh OLTP team. Involved in full life cycle of teh project
• Design and Development of InfoObjects, ODS and InfoCubes for Sales and Distribution. Data Extraction from SAP R/3 and legacy systems.
• Worked on DP and SNP modules, Master data creation, Environment settings,Demand calculations using Heuristic approach, supply and network planning.
• Developed reports using business explorer.
• Production support for BW/APO system which went live in June 2003.
• Interacting with Systems group for transports by sending requests for teh same.
• Implemented extraction, transformation and loading (ETL)of data to Business Warehouse objects from Legacy systems using Informatica.
• Optimization of loading times using line dimension, aggregation and partitioning techniques.Monitoring teh data load during teh night time for successful loading of data
• Creating reports using Bex Analyzer using variables, calculated key figures, restricted key figures, wherever required for queries to generate reports
• Interacted with basis team for setting connections between R/3 and BW systems
• Transported teh BW objects to testing/production systems from development system using Change and Transport Organizer
• Interacted with basis team for setting up of clients in BW and R/3
• Enhanced teh R/3 data sources using userexits
• Web reports development using WAD

Confidential, SanJose

Senior BW Consultant

Environment: SAP SEM 3.0B/3.1B, SAP R/3 4.6C, Oracle 8, Solaris, ABAP/4

Responsibilities:

• Interacted with end user managers in knowing their requirements and preparing Gap Analysis of existing systems.
• Identified teh data sources for teh data modeling and design of information warehouse
• Worked on Business Planning Module (BPS) and Business Consolidation Module (BCS) extensively with planning views,
• Planning profiles, authorizations and planning areas for sales.
• Implemented status and tracking system for teh BPS module.
• Designed and developed BPS: Cost Center Planning and Sales Profit Planning Info cubes, BCS (Company/Profit Center) Cube, ECCS Cube.
• Designed and build teh data extractors need for teh ODS, InfoCubes for PCA, CCA area with appended structures, function enhancements (user exits).
• Designed teh InfoObjects,InfoCubes required for teh company in CO-PCA,CO-CCA areas.
• Involved in data loading, Full update with delta initialization, Delta update for these InfoCubes.
• Fulfilled teh end user reporting requirements by developing teh reports with drilldown facility, Variables in BExAnalyzer.
• Involved in all phases of development Design phase, Testing phase and Production phases.
• Build Multicubes to develop critical reporting needs of teh client
• Searching Notes and Opening tickets using OSS (Online SAP Service)
• Trained teh key end users for usage of BW System with reference to Bex Analyzer

Confidential

BW Consultant

Environment: SAP BW 2.1C/3.0B,SAP R/3 4.6B,Oracle 8,Unix,NT,ABAP/4,Business Objects.

Responsibilities:

• Interacted with end user managers in knowing their requirements and preparing Gap Analysis of existing systems.
• Identified teh data sources for teh data modeling and design of information warehouse
• Designed and build teh data extractors need for teh ODS, Info Cubes of Logistics area with appended structures, function enhancements (user exits).
• Designed teh InfoObjects, InfoCubes required for teh company in teh Logistics area like Purchase, Inventory, Materials Movements, Frieght Costs, Inbound Delivery
• Implemented LO extraction for teh Business Content data sources
• Involved in data loading, Full update with Delta Initialization and later Delta update
• Designed and implemented Generic extraction wherever LO extraction not possible.
• Fulfilled teh end user reporting requirements by developing teh reports with drilldown facility, Variables in Box Analyzer.
• Involved in all phases of development Design phase, Testing phase and Production phases.
• Build Multicubes to develop critical reporting needs of teh client
• Build Crystal Reports using Crystal Enterprise,SAP Edition
• Searching Notes and Opening tickets using OSS (Online SAP Service)
• Trained teh key end users for usage of BW System with reference to Bex Analyzer.

Confidential, Melbourne

BW Consultant

Environment: SAP BW 2.0b/2.1c, SAP R/3 4.6, Oracle 8, Unix, NT, ABAP/4

Responsibilities:

• Interacted with user managers at Powercor to know their requirements of reports
• Identified teh source systems to develop BW ModelTelstra:PAIR (Project and Investment Reporting).
• Involved in teh design, development and implementation of Business Warehouse using Star and extended star schema. Administering teh BW system, configuring teh system and users. Coordinate with SAP Basis people from teh OLTP team. Involved in full life cycle of teh project
• Design and Development of InfoObjects, ODS and InfoCubes. Data Extraction from flat files.
• Developed reports using business explorer.
• Production support for Telstra BW systems which went live in October 2001.
• Reconciliation of Accounts in Project Management System of Telstra.
• Interacting with Systems group for transports by sending requests for teh same.
• Development of email facility in BW System to update super users daily on teh time of InfoCubes update.
• Implemented extraction, transformation and loading (ETL)of data to Business Warehouse objects from Legacy systems.
• Optimization of loading times using line dimension, aggregation and partitioning techniques.
• Monitoring teh data load during teh night time for successful loading of data.
• Creating reports using Bex Analyzer using variables, calculated key figures, restricted key figures, wherever required for queries to generate reports.
• Experience with CTS Layer management
• Trained end users for reports usage and BW system usage
• Worked in areas of APO-DP, APO-SNP, APO-PP, APO-DS, and APO-SCC.

Confidential, Los Angeles

Role: ABAP/4 Consultant

Environment: SAP R/3 4.6, Oracle 8, Unix, NT, SD, ABAP/4

Responsibilities:

• Defined business requirements and completed configuration activities for teh SD module.
• Teh work involved defining various organizational units like Sales Organization, Sales Offices, Sales Group, Sales District & assigning them to each other so as to accurately reflect teh organization structure.
• Customizing of Partner Determination by creating various Partner Functions and maintaining these at Customer master level, Sales Document item level & Billing document item level.
• Maintenance of Sales representatives & Sales Territories.
• Development of functional specifications in support of development activities.
• Worked with a team ABAP/4 programmers on various programs during implementation.
• Worked on Customer rebate implementation.

Confidential

SD Consultant

Environment: SAP R/3 4.6, Oracle 8, Unix, NT, SD, ABAP/4

Responsibilities:

• Creation of new order type to map requirements of Complex Order types by integrating Project Systems with Sales Order with Billing plan & Letter of Credit.
• Creation of new item categories, schedule line categories & delivery item categories to map requirements of Sales BOM's & dynamically defined Item hierarchies in Sales Order.
• Worked on Make-to-Order process scenario using Sales Orders with variant configuration.
• Mapped Sales Order with scenarios like Drop Ship, Marshalling & Sales Orders with externally procured Services.
• Customizing several returns scenarios by creation of new Order Types, maintained copy control Procedures, Credit memo request, and Debit memo request.
• Production System Go Live & post implementation support.

Confidential, Detroit

SD Consultant/Datawarehousing.

Responsibilities:

• Implementation of Sales and Distribution Module for teh company.
• Configuration of new organization structure
• Identify business processes required for teh new company
• Configuration of new business scenarios pertaining to Sales, Shipping and Billing.
• Configuration of Pricing, Taxation and Masters.
• Prototyping and testing of Output Documents pertaining to Shipping.
• Extension of Material Masters and customer Masters.
• Development and Testing of Programs to convert open orders.
• Modifying and testing of reports based on new organisational structures.
• Customization and Configuration of MM Module Module
• User training, interacting with other modules team members for teh speedy implementation of teh package.
• Definition of material types, material groups to support various combinations of stock and valuated materials, valuation types, automatic account assignments, creation of new account assignment categories, processing of various types of special stocks such as consignments, sub-contracting, third party processing, pipeline handling, evaluation of vendor on customer developed criteria, quota arrangements and processing of payments based on evaluated receipt settlement, ABC Analysis etc.
• Established teh Company structure including setting up of Plants, Purchasing organizations, Storage locations and Warehouses by making use of standard structure of R/3 Reference Model and mapping until it exactly fits teh needs and structure of teh organization.
• Defined a standard pricing procedure for determining teh best effective price for various materials using various condition types.
• Testing all reports based on LIS and other programs