PROFESSIONAL OVERVIEW

• Over 18 Years of SAP experience which includes 16 years of Solid Expertise in Building a SAP Business Warehousing, Business Objects S/4 HANA and HANA(Native) solution.
• Knowledge in ERP Functional Areas like SD, FI, HR, HCM,SRM & MM. Specialized expertise in SD -
• Sales Delivery and Billing, FI-CO - GL, AR, AP, Income Statement Balance Sheet Reporting, IS-Retail, IS-Oil, Confidential (DP and SNP), HANA and Business Objects 4.0, 4.1 Reporting (BOBJ).
• As a senior functional and technical consultant I possess strengths in the project design, leading small and medium sized teams, technical product/application development, source mapping and extraction.
• Has mastered both the functional and technical issues utilizing numerous tools, applications and platforms.

KEY SKILLS

• SAP BW 7.X Powered by HANA/ BOBJ BI 4.x/SAP HANA / SAP BW 3.5 / BI 7.0
• ERP ECC 6.0
• Oracle 11
• MS SQL Server 7.0 / 2000
• VB 6.0
• Confidential Reports and SQL / PL-SQL
• MS SQL Server
• Business Objects XIR2 / XI / 6.5 / 6.1.x / 5.X
• Web Intelligence
• Desktop Intelligence
• Designer
• Confidential Publishing Agent
• Dashboard Manager
• Universe Bulder
• Central Management Server (CMS)
• Central Management Console ( CMC)
• Confidential Reports 9 / XIR2
• Confidential X-Celsius
• BI Launch Pad
• IDT.

SUMMARY OF EXPERIENCE

• Four projects end to end. Duties include but are not limited to Mapping High Level Requirements, High Level design, BPP s, Preparing Project Plans, Blueprinting, Adhering to committed dates of Deliverables, Weekly Status Reports, Project Progress Report, Project Timelines, Cutover planning, Go Live checklist.
• Worked as Team Lead on 3 projects.
• Around one year experience to define solution based on SAP HANA Enterprise tools to build Engineering Change Management process reports.
• Have good understanding of Business Objects(BOBJ) 3.1/4.X architectures and functionality.
• Led multiple implementations of SAP BI in HCM and one in IS - Retail (AFS). Integrated the data from Personnel Administration, HR Payroll, Personnel Time Management and POSDM.
• Handled High Level Data Design, Data Modeling, Star Schema, Extended Star Schema and System Upgrade.
• BW Extraction & Reporting: Expertise in Data Extraction from SAP R/3 and Non SAP source and performance tuning of BI system for Confidential (SD,PP, MM HR, FI and CO-PA ).
• Business Objects Reporting: Worked on Business Objects Enterprise, Confidential Reports, and Live Office Documents, OLAP Universe, BICS, Confidential Query Designer, QaaWs (Query as a Web service) and Confidential Dashboard reporting.
• Confidential Reporting: Worked extensively in Confidential Analyzer in building Queries. Created Custom Queries, using Conditions, Exceptions, Variables, and Structures. Organized the queries into various workbooks. Also analyzed Web reporting functionality since the Confidential publishes its Comprehensive Annual Financial Report (CAFR) on the web. Good experience in performance tuning of queries.
• Upgrade projects: Responsible for a successful Technical migration of the BW Object to the BW 7.3 (NetWeaver 2004s). Worked with Basis team in Upgrading BW 3.5 to BW 7.3.
• BW Testing:-Handled testing tasks for Confidential like BW Test Plans, Data Extraction Test Plan, Data Access Test Plan, Query / Workbook Test Plan.
• BW Security: Implemented power user reporting access for Confidential using reporting objects like S RS COMP and S RS COMP1. Also created a Menu Role, which helped to differentiate SD HR and FI users and thus provide authorizations easily.

PROJECT EXPERIENCE

Confidential

HANA/ Confidential /BW Program Architect

Responsibilities:

• Worked on activated HANA Live content for IS-U FI-CA.
• Migration of data from legacy(3rd Party systems like BW, Click, Oracle) to S/4 HANA.
• Modeling and development of objects for AR Ageing Analytics using HANA CDS views.
• Design, manage and development of Work Management and Market Share Design Studio dashboards based on
• Service Order data on top of BW/HANA views(Attribute, Analytical Calculation views and DSO).
• Maintain security through SYS BI, SYS BIC and SYS REPO.

Environment: S/4HANA 1511 FPS01, SFIN 2.0, SAP BW 7.4 Powered by HANA, SAP ECC 6.0 and Confidential 4.1.

Confidential

BW on HANA/ Confidential Architect

Responsibilities:

• Upgrade/Migration to BW on HANA.
• MRP/LTP and Commodity Contract reporting.
• Modeling and development of objects for Commodity Contracts Analytics using HANA Attribute views, Analytical Views and Calculation views.
• Directed solutions to push the calculations to the HANA DB engine.
• Created SQL, SQL Script, CE Functions and ECC for checking the Commodity orders.
• Identification of source tables in ECC and other legacy systems (Demantra) to map the relationships for various tables.
• Creating catalogs, Schemas, tables and views in HANA system.
• Migrating existing DSO and Cubes to HANA DB.
• Delivering reporting solutions in Confidential, Design Studio, Analysis for OLAP/Office, Confidential & Explorer.

Environment: SAP BW 7.3 Powered by HANA, SAP ECC 6.0 and Confidential 4.0.

Confidential

BW/ Confidential Architect

Responsibilities:

• Business Objects upgrade from 4.0 to 4.1.
• Identifying user requirement and deliver requirements by using different BI tools like Dash Board design, design studio, Confidential, Confidential, Analysis for Office and BODS. Also train power and business users in these tools to build their own ad-hoc report.
• Performance tuning of BW.
• Identify KPI’s. Design and development enterprise dashboard for CEO and top management using Design Studio.
• users in BW/BI.

Environment: SAP BW 7.3, SAP ECC 6.0 and Confidential 4.1.

Confidential, Atlanta

BW/ Confidential /HANA Architect

Responsibilities:

• Involved in technical/functional upgrade of GP BW systems from 7.01 to BW 7.31.
• Design and development of Profit reports for Confidential .
• Design and develop Booking extract solution for sending data to third party system using BW and BODS.
• Provide analysis on the current and future deployments of “In-Memory” technologies.
• Replicated metadata from SAP ECC to HANA using SLT for Purchasing and Material Movement Data.
• Created HANA Models as part of HANA POC initiative to deliver Line item reporting for Purchasing.
• Test In-Memory optimized cubes and DSO objects in BW 7.3 by creating new or migrating existing objects.
• Worked as team lead managing 4 consultants. Tasks include getting requirements from business, assign deliverables to team members, managing time lines, preparing status reports and weekly updates to PM

Environment: SAP BW 7.3, SAP ECC 6.0 and Confidential 4.1.

Confidential, Birmingham, AL

BW/ Confidential Architect

Responsibilities:

• Design and Develop BW back end for IS-U and Confidential Sales, Leads & Opportunities.
• Developed Web Intelligence ( Confidential ) reports for SAP IS-U Billing, Sales & Confidential modules like FI-CA, AR, CCS.
• Part of Architecture & Design team for delivering dashboards to business users and power users by using different Confidential tools.
• Developed Confidential Dashboard with various custom components to meet the customer requirements.

Environment: SAP BW 7.3, SAP ECC 6.0, IS-U, Confidential 7.0

Confidential, Petersburg, FL

BW / HANA Architect

Responsibilities:

• Implementing full life cycle BW Project’s in Finance, Purchasing, Plant Maintenance, PLM and Sales and Distribution.
• Handled High Level Data Design, Data Modeling, Star Schema and Extended Star Schema.
• Modeled back end design for SPS Reports and PLM for Engineering Change in SAP BW.
• Worked with the users for defining the reporting needs and helped design/develop Confidential queries and pre-calculated reports using Confidential reporting features like variables, exception and conditions in Finance and Purchasing areas.
• Expertise in Data Extraction from SAP R/3 and Non SAP source.
• Conducted requirements gathering and design sessions to drive out reporting requirements.
• Actively involved in the BW 7.3 upgrade and successfully integrated BW with Portal and Microstrategy. Familiar with various upgrade issues.
• Developed 7.3 objects like SPO’s and Hybrid providers for various Inventory and Purchasing reporting scenarios.
• Build the complete solution including SLT to replicate data from ECC system into HANA, building Models in HANA for Material Requirement Planning and Spend Analysis.
• Designed, built and tested several Attribute views, Analytic views, Calculation views in SAP HANA.
• Analyze and Identify the impact of HANA DB on current strategy to use LSA architecture as a standard for data warehouse design.
• Optimized cubes and DSO objects in BW 7.3 by migrating existing objects to HANA DB.
• Assist evaluating and identify the implementation strategy for BW 7.3 on HANA DB.

Environment: SAP BW 7.3 Powered by HANA, SAP ECC 6.0, SCM, Microstratergy.

Confidential

BW/BOBJ Architect

Responsibilities:

• Modeled back end design for PO Audit Report and Sales Demand in SAP BI/BW 7.0.
• Designed the Back End and Front End ( Confidential and WAD) for Learning Management Systems(HR) for LEAN Initiative.
• Designed the Back End and created Confidential dashboards for mobile devices such as Ipad, Iphone and Blackberry using third party software Confidential .
• Worked on Confidential Reports and Confidential dashboards for Product Line and Portfolio Investment based on universe created on top of SAP BI Queries.
• Confidential dashboards for EB-Projects: Created Confidential reports on top of Universe created from Confidential report.
• The data from the Confidential report is converted into spreadsheet format and embedded in the .xlf file using third party tool Infoburst as interface tool between Confidential and Confidential .

Environment: SAP NW 2004's BW3.5 / BI 7.0, SAP ECC 6.0, SCM 7.0, Confidential XI 3.1

Confidential

BI/BW Architect

Responsibilities:

• Modeled back end design for Confidential SNP and DP application in SAP BI/BW 7.0.
• Developed Forecasting Error and Replenishment Error reports in SAP BW which are used by business for calculating safety stock.
• Enhanced Data Source 2LIS 11 VAITM with new fields Order Type and Order Status for extracting actual Sales data for previous months which is being used in calculating Safety Stock in Confidential .
• Created Confidential Reports and Confidential dashboards for Pegging and Inventory Status on top of SAP BI Queries using BI system as source system.

Environment: SAP NW 2004's BW3.5 / BI 7.0, SAP ECC 6.0, SCM 7.0, Confidential XI 3.1

Confidential, San Ramon, CA

Sr BI/BW Consultant

Responsibilities:

• Worked as an SAP BW Consultant for the full-scale implementation handling MM module.
• Worked on Confidential (MM, IM, SD, SRM) project to measure total cost productivity for US.
• Managed development plan effectively while updating Project Manager with weekly status
• Designed the architecture, data model, and the Technical Specification documents for GL, AR, AP and Tax Logical Partitions.
• Developed Production Planning and Costing objects in R/3 and BW environment
• Analyzed and utilized Financial General Ledger data for the variance allocation process.
• Configured SAP BI/BW objects, Start Routines, End Routine and Transformation as per business requirements .
• Participated in the complex development part of the allocation process and feature calculations.
• Developed Financial Dash Boards for BFR reporting. Performance tuning of Confidential and WAD queries.
• Prepared project documentation and other helpful documents for the end-users.

Environment: SAP NW 2004's BW3.5 / BI 7.0, SAP ECC 6.0, SRM 5.0

Confidential, Santa Clara, CA

Sr BI Consultant/Analyst

Responsibilities:

• Created links for WAD and Confidential reports on different info cubes like service orders data from SAP BI to Knowledge Management.
• Created function module extractor to extract data from COSB table as the business content extractor is not extracting service contract Information.
• Build Custom Extractors for FI Asset Accounting and Tax minute based extractors as the current Standard Extractor’s are supporting only day based extraction.
• Worked with the basis team on the architecture for the BIA and load balancing of the blades of the BIA for the various servers in the landscape.
• Developing new Web based reporting solutions like Web template development and publishing into BI Enterprise Portals as I-Views.
• Testing the developed objects as part of the Integration and Regression testing using Confidential Test Director.

Environment: SAP BI 7.0, ECC 6.0, Enterprise Asset Management, Confidential, WAD and Enterprise Portal

Confidential . Durham, NC

BI Lead Data Architect

Responsibilities:

• Lead an implementation team for Confidential on a MySAP HCM(Payroll) and Confidential successful Global project upgrade(technical and functional) implementation.
• Provide expertise and architectural leadership in the areas of Data Governance, Master Data Management, Analytics, Data Warehousing, Business Performance Monitoring and Data Mining for tools like SAP Netweaver, HCM, and ECC.
• Integrated of Confidential Sales into BW using extractors 0CRM SALES ORDER I, 0CRM QUTATION I and other relevant Data Sources.
• Designed and developed portal enabled internal and external reports for Services group. WAD was used to develop web queries and ported on to portal.
• Partner with core SAP implementation team to ensure consistency of Design
• Interface with user community
• Created Inventory Management Reports in Business Objects like Slow Moving items, Consignment Stocks, Stock over view, Stock Obsolescence / inventory aging etc. based on a BI Query. Created the Live Office Documents on the Confidential Report.
• Created Confidential Dashboard with reports like Balance Sheet Report, Income Statement, Cost Center Report 12 periods and Current Periods, Internal Orders current Period, AP Aging, AR Aging, AP and AR Line Items, Project Cash Flow Report.
• Set up Universe level conditions to restrict data based on report requirements.
• Created Database Objects such as Views, Functions, Stored Procedures with Respect to the Requirements of Universe and Reports Development.
• Installation and Configuration of SAP Integration Kit to integrate BusinessObjects (BusinessObjects Edge Series XI Release 3.0, Confidential Reports, Live Office, Confidential ) with SAP.

Environment: SAP BI 7.0, ERP ECC 6.0, Confidential 5.2, Confidential, Confidential, WAD, Business Objects XI R2 (Desktop Intelligence, CMC, CCM, Web Intelligence, Confidential Reports X, Designer, Universe Builder. SAP Integration Kit

Confidential, Durham, NC

BI Lead Data Architect

Responsibilities:

• Worked as Lead Architect for the BI/HCM solution rollout .
• Modules Implemented: Payroll, E-Recruitment, Revenue Recognition, Personnel Administration, Organization Management and EAM - Asset Management/History.
• Created reports like Time Evaluation Calculations, Force Active/Leave, Overtime, Vacation, Quota Transactions, Quota Balance, Employee Expenses for Payroll, Overview of Wage Types, No. of Transfers, Personnel Planning etc. in the area of Time Management, Payroll and Personnel Administration.
• Resolved number of issues as part of post Go-live; including identifying the text tables in ECC, created the generic extractor, replicated the data sources and loaded the text to corresponding Info
• Resolved multiple challenges faced due to integration of Confidential and SAP.
• Created user Prompts, conditions, and filters for various reports to specify the reporting parameters as per business requirements.
• Created Dashboards using Dashboard Builder in Dashboard Manager.
• Created Database Objects such as Views, Functions, Stored Procedures with Respect to the Requirements of Universe and Reports Development.
• Solid experience on Performance Tuning of Universe and Reports.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.

Environment: SAP BI 7.0, ERP ECC 6.0, FI-CO, HCM, HR, ABAP/4, Confidential Analyzer, WAD, Business Objects (Desktop Intelligence, Web Intelligence, Confidential Reports, Universe Builder).

Confidential, Beaverton, OR

Sr BI Consultant

Responsibilities:

• Understanding and gathering customer requirement in Netweaver 2004 S for apparel and footwear solutions and retail modules.
• Designed data model for extracting Promotion’s, Articles and POSDM from IS-Retail into BI.
• Preparing Blue Print and Design Specification for Process Manufacturing Reports.
• Prepared technical Specs for reports pertaining to Retail hub area
• Identifying and activating standard Business Contents for Retail/AFS.
• Extracting Articles data from IS-Retail (T-code MM41, MM42, MM43) to BW if the cost prices and the retail prices are approved for the articles, if they are not approved the articles will not be updated into the bw system and will be held up in Confidential .
• Identifying and setting up Master Data.
• Developed the BADI for integrating data from different sources into a single file while outputting the data using open hub service.
• Extensively worked on performance tuning aspects of reducing the load times and also sending data out of BW systems.

Environment: SAP BI 7.0, ECC 5.0, ABAP/4, IS-Retail

Confidential . Houston, TX

BW Team Lead

Responsibilities:

• Responsible for performing detail configuration of PP-PI including IS-Oil, sub-contracting, pipeline material, raw material purchasing, unit of measure conversion.
• Strategize architecture of Global Reporting via the Web from a single Global BW/SEM instance scalable upwards to three Global instances that serve 3 Global regions.
• MCU Reporting Tool is an excel based offline reporting tool that generates different reports for number of users. Due to limitations with this tool BW web reporting is implemented which will replace MCU Tool. Through the process reverse engineering 55 web templates is developed based on different queries and views.
• Replaced resource intensive SAP BW Confidential queries with scheduled Confidential Reports that reduced manual data consolidation and improved productivity and data quality.
• Created initial Classes & Objects, qualification for the Universes in both on/off line modes.
• Created reports for various Portfolios using the Universes as the main data Providers.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.

Environment: SAP BW 3.5, IS-Oil, IS-Utilities, ABAP, Oracle, Business Objects 5.1 (Designer, Reporter), Web Intelligence, Desktop Intelligence, Central Management Console, CCM.

Confidential

BW Consultant

Responsibilities:

• Implementation of Plant Maintenance and CO-PA module in BW.
• Developed ZPUR C21, ZPUR C25, ZPUR C28, ZPUR C33 and ZFIGL C01 cube for Rollup project.
• Consolidation of Purchasing and CO-PA Data from ODS through export generate data source. Lookups in update rules was used to populate fields as a part of rollup project.
• Developed the Extraction process for Material classification data.
• Developed start routines, update routines.
• Extracting data from Confidential Demand Planning data to BW.
• Load monitoring Critical master data, Regular master data, Transactional data,
• Texts, hierarchies.
• Development of process chains for Rollup project and load monitoring from SEM to BW.
• Developed a prototype for Investment planning in BPS.

Environment: SAP BW 3.5, SAP R/3 4.7, Confidential, Oracle, ABAP, RS Trace Tool

Confidential, ST Louis, MO

BW Consultant

Responsibilities:

• Preparing the Process Information and the Data Extraction document. BW Commission Reporting, which includes creating queries and the related workbooks.
• Exception reporting, Condition reporting are designed to pinpoint the bottlenecks of the organization.
• Testing BW Objects as a part of the Testing scenario.
• Presentation to Business/Client on the BW reports for their approval. Presenting the client with the progress reports.
• Setting up of Transfer Rules, Transfer Routines and Update Routines as required.
• Worked in data design, data modeling, Star schema and extended Star schema. Performed Info Cube rollup, Automatic deletion of Info Packages and used dynamic selection criteria. Worked on Reporting Agent configuration and settings.
• Resolved Business Explorer and analyzer issues.

Environment: SAP BW 3.1C / Oracle 8i, Windows NT, Confidential Analyzer.

Confidential, Atlanta, GA

BW Consultant

Responsibilities:

• Providing services in supporting the SAP BI system from offshore for Promotional Planning area where most part of the data comes from IS Retail, Confidential and SEM systems.
• Designed process for extracting Forecasting, Retro funding and Non-Retro funding data to BW.
• Responsible for 24X7 support of the BW system on a regular basis, responsibilities included scheduling of failed programs, monitoring of system resources, monitoring Process chains. If the process chain fails doing the loads manually. Monitoring of Info package Groups. Worked on full loads and deltas. Source system outage.
• Involved in escalating high-prioritized tickets regarding extractions, performance issues and load failures. Maintaining work history for all tickets until it is closed.
• Involved in the month beginning data loads to extract CO-PA and FI-SL data.
• Developed Process Manufacturing Reports for Material Variance.
• Implemented use of Aggregates; also investigated Info Cube physical segregation with ABAP exits.

Environment: SAP BW 3.1, SAP R/3 4.6C

Confidential

Associate Consultant

Responsibilities:

• Worked on activating the standard business content Info Cube 0SD C01 Customer, 0SD C03 Sales Overview, 0PUR C01 Purchasing Data and 0PUR C02 Vendor Evaluation
• Performed Data Extraction and Data Staging using LO Cockpit (LBWE) and extended the structures using user exits to support the business needs.
• Worked extensively on LO Cockpit. Loaded the data from R/3 to BW and used Initialization with delta update and full update methods.
• Involved with performance tuning of Queries by maintaining Aggregates, Compression, partition and indexing of Info Cubes.
• Worked extensively on Confidential Analyzer (RRMX) and created queries using BW-Reporting Variables, Navigational attributes and Filters. Developed workbooks, Queries and used RRI jump queries to drill down to other queries and R/3 transactions. Extensively used calculated and restricted key figures, restricted characteristics, structures, variables and conditions for the queries.

Environment: SAP BW 3.0B, SAP R/3 4.6C

Confidential

Module Lead

Responsibilities:

• Monitoring data loads. Escalation and resolving if there are any failures in Confidential .
• Performance tuning of queries and developing new queries based on client requirement.
• Developed new Info cubes and involved with up gradation of new patches.
• Involved in testing of objects in Development, Testing, Production and Sandbox after up gradation of patches.

Environment: SAP BW 2.0B

Confidential

ABAP Consultant

Responsibilities:

• Developed reports for MM, SD Modules.
• Developed Upload Programs for MM and SD.
• Created a report on Bill-of - Material (BOM) that gives the detail structure of components, which are required in production.
• Modified Sap-Script Programs and Layout sets according to client requirement.
• Created a report used to get the total material received by each plant (plant wise) and for a particular material received by all plants (material wise).

Environment: SAP R/3 Version4.6C

Confidential

ABAP Consultant

Responsibilities:

• Created a batch input program to load the change of vendor address by using call Transaction method (FK01, KE51)
• Created reports to Output the Vendor master data, Bank details in Vendor master, Sales order data
• Created a report based on the details of daily purchases made by company in a specific format.
• Created a report based on Purchase Requisition number that displays material number, qty, and delivery date as a basic list.
• Purchase details as first list & price details as second list.
• Developed custom reports for Sales Billing.

Environment: SAP R/3 Version 4.6B