PROFESSIONAL SUMMARY:

• Over 11+ years’ experience in IT industry with over 10+ years of SAP Business Warehousing/Business Objects and ABAP 4.x experience. Proficient with planning, design implementation, troubleshooting and performance tuning support of SAP Business Information Warehouse Reporting and BOBJ Reporting.
• Experience in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
• Worked in reimplementation of SAP BW IS - Retail for about 2 years and 4 years in developing reports in SAP BW, Bex, Webi for Manufacturing industry and 2 years in CPG industry and in e-Commerce industry.
• Involved in multiple Full life cycle Implementations with exposure to all phases of project from business process prototyping, Blueprinting, Configuration, Development, Integration Testing, Cutover and Training to Go Live. 
• Responsible for providing end to end solutions to clients, transitioning and sustaining production support activities, defining Project Standards, Development of Architecture, Review of Design, GAP Analysis, Project Schedules, Team Management, ensuring optimum utilization of resources and complete delivery within budget. 
• BI Design - Info Cubes design, Info Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Update rules, Transfer rules, Info Packages using AWB. Proficient in Data modeling using MDM and BW extended star schema models.
• Experience in ETL i.e. Data Extraction, Data Transferring, Data Loading such as SAP BI and Informatica.
• Primarily focused on Front end reporting (Work books, Web templates, Dashboards) on SAP BW along with its integration with SAP Portal, KM and third party tools like Business Objects and Crystal reports.
• Experience in Integrating and Extracting data into Business Objects environment from the SAP BW database system. Created WEB Intelligence Reports, Formatting reports (BOBJ), as per user requirements.
• Experience in Hierarchies, Authorizations, BW Statistics, Archiving, Process chains and Open hub.
• Knowledge on SAP BW 7.5 data modelling like composite providers, Transient providers, Open ODS Views.
• Gathered and analyzed the requirement for the global data warehousing project.
• Leveraging Semantically Partitioned DSO feature Loaded and managed mass data volume for several regions.
• Designed Dashboards using SAP BO Design Studio
• Designed SAP BW on HANA Composite Provider as semantic layer using BW on HANA Modelling tools in HANA Studio.
• Generated SAP HANA Analytic Views for standard DSO’s in HANA and used them in calculations Views.
• Enhanced Loading performance by Pushing down ABAP Logic into SAP HANA Script Based calculation view and improved performance by 40%. Reduced loading time by 3 hours.
• Loaded data into SAP BW with SAP HANA Calculation View as source using DB Connect.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Implemented LSA++ architecture in the BW on HANA Landscape.
• Worked extensively on HANA modelling for BW Objects.
• Created SAP BO Analysis for Office Reports for analytical reporting.
• Designed webi reports with complex formatting.
• Designed SAP BO design studio Dashboards for Sales and Procurement.
• Loaded data from legacy BW system into BW on HANA using BODS for history data.
• Migrated HANA content from development, testing environment to Production environment using Charm integrated LCM Process.
• BI Reporting - Experience in Design and Development of Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting, RRI, Reporting Agent and Broadcaster.
• Expertise in Data Source Enhancement, Generic Extractors, User Exits, Data Loading, Scheduling, Monitoring, Process Chains, Multi Providers, Info Sets, Remote Cubes, Data Mart and Open Hub Service. 
• Experienced with creating aggregates, compression and partitioning, BW Upgrade and Performance Tuning in BI/BW, Net weaver 2004s environment and migration from BW 3.5 to BI 7.0 and upgrading to 7.3. BW Report Design, Query Design, KPI Reporting, Testing, and Performance Tuning
• BEx Worked Extensively in BEx Analyzer in building Queries, saving it in Workbooks (Excel work Sheets). BW Expertise in SAP BW components like Info Cubes, Multi providers, Info Source, Info Objects, Update Rules and Transfer Rules, Which Includes Data Modeling.
• Reporting Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, Conditions, RRI, and Jump queries.
• Web Reporting Developed Web reports, Web items, customized Web templates using Web application designer (WAD) and query designer.
• Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning.
• Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation, Direct and Flexible update of Master data.
• Experience in the technical and functional system upgrade from SAP BW 3.1C to SAP BI 7.0 (NW2004s). Business Area: FI-CO, SD, MM, PP.
• Worked on SAP BPC 10.0 production support.
• Upgraded and migrated Bex queries, workbooks, WAD templates from SAP BW 3.1 to SAP BI 7.0
• ABAP - Reporting, User Exits, Customer modifications. Proven success in performing all reporting features, OLTP Extraction from SAP R/3 into BW using different extraction structures. Functional expertise in SD, MM and FI/CO. In-depth knowledge of reporting flow from R/3 to SAP BW.
• Worked with the project team and multiple end-users to resolve accounting issues and identify opportunities for business process improvements. Provided production support in BW reporting.
• Worked on 24/7 production support and AMC for large organization.
• Participated in identifying and implementing continuous business process improvements in planning, month-end closing, and consolidation. Documented functional and technical specifications for production support and project enhancements. Participated in change management activities.
• Assisted in ongoing communication to SAP and BW end-users on business process and systems changes, and issues resolutions.

TECHNICAL SKILLS:

ERP/ETL Tools/Reporting Tools/Data Modelling Tool: SAP R/3 ECC 5.0, 4.7/4.6c/4.5/4.0, SAP BW 3.0 - 7.4, SAP SCPM 1.0,SAP BPC 10.0, BEx Reporting, Web Reporting & BW 3.5/3.x/2.x, BOBJ WEB Intelligence, Business Objects XI 3.1(Web Intelligence, Xcelsius), SAP Business Objects Lumira, SAP BODS, SAP Design Studio 1.2

SAP Modules: MM, SD, PP, PS, QM, FI/CO and IS -Retail

Data Modeling Tool: HANA Studio 1.0

Operating System: SAP ABAP/4, SQL

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Sr. SAP BW Consultant

Responsibilities:

• Worked with the users to get the requirements, performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional team.
• Participating and finalizing the functional requirements from the business users.
• Responsible in converting the functional requirements to technical designs 
• Successfully developed complicated reports for Inventory (OSMI-Obsolete Slow Moving Inventory) which Is a most complicated and high priority Global Report and different Forecast reports for individual facilities.
• Successfully developed complicated reports in SD, MM, PP, PS and FI/CO modules Developed custom function module extractors, used ABAP routines in transformations.
• Providing project work load and timelines to the business users. 
• Responsible for defining technical strategy and tactical plan for implementing data and information delivery solutions.
• Worked on Global and regional reports. 
• Participated in design reviews, spec reviews, code reviews, test plan reviews. 
• Worked with various standard as well as custom BI/BW objects for FI, CO, SD, MM, PP, PS, and QM of ECC. 
• Worked on customization and enhanced the extract structure to support business needs 
• Developed various transformations to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements.
• Extensively worked on end to end implementation of Catalyst project for controlling reports.
• Designed and implemented a centralized data model which is feeding data for many other controlling reports like catalyst report, Management dashboard report and Project Management dashboard reports.
• Installed SAP delivered standard Data sources to retrieve the standard cost and Actual cost related information for Material and Production order.
• Built reports those will help the power user to determine standard cost, Actual cost and deviation of each material and production orders based on different projects and WBS elements.
• Created cost element hierarchies in BW for PM and DM dashboard reports to populate cost values based on different costing element groups for each project and WBS elements.
• Written end routine to lookup standard cost information for Material and production orders.
• Actively involved in Data Extraction from SAP ECC and through flat files.
• Redesigned and implemented Supply chain data warehouse model to provide data feeds to external system.
• Implemented the new logic to calculate 2, 4, 8, 24 and 52 weeks Demand summary of each material based on different plants.
• Created custom DSO to store the demand details of each material with new logic.
• Implemented the new logic to capture snapshot of production orders completed and those completed on time for Adoption matrix report.
• Extensively worked on end to end implementation of Material Master Report project.
• Enhanced 0MAT PLANT ATTR and 0VENDOR ATTR data sources to fetch data for new fields using customer exit.
• Created new generic data source based on infoset query to extract all the required fields including WAERS and MEINS fields from MBEW table and created new data flow in BW.
• Worked on conducting workshops to go over the new tasks with the system administrators and SAP Basis Consultants and also created an application by application migration approach from SAP BW to HANA system.
• Written lookup code to read data from 0MAT PLANT, 0MATERIAl, 0VENDOR and other existing DSO’s to populate data for Material Master Report.
• Created secondary indexes to improve the loading performance SELECT statements written in lookup code.
• HANA and Business Objects Development done across all the business Areas for the BI Projects: Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
• Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Developed data flows and work flow using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
• Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.
• Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non sap data Flat file upload and direct extraction connection DXC to acquire the data into SAP HANA Data Mart.

Environnent: SAP R/3 ECC 6.0, SAP BI 7.0, 7.31. SAP HANA 1.0, SAP BOBJ Webi, Dashboard

Confidential, St Charles, MO

SAP BW/ SCPM Lead Consultant

Responsibilities:

• Working with Product Engineering Group on multiple engagements, developing RDS solutions across the key focus areas of the Business. Experience spans on various scenarios of S&OP, Inventory, Cash to Cash, Order to Cash, Cost & Profitability Analysis, Forecast, Cost center accounting, Profit center accounting & ECCS, SRM, Purchasing, Accounts Payable/Receivables, resulting to the BI reporting KPI’s like the Days of coverage, Stock outs, Forecast accuracy, Forecast Bias, Forecast based on various time indicators, Inventory Value based on material type (RM, FG & WIP), Perfect Order Fulfillment, OTIF, Vendor Order Fulfillment, Customer Diversity, Price exception-Floor Price vs. Selling Price. Exceptional knowledge on the Procure to pay process, Cash to Cash, Inventory & the material management functionalities.
• Analyzed the client system for suitable SCPM data sources for the different scenarios of SCPM.
• Installed SCPM BI content on the top of BI system.
• Enhanced the SCPM Std DSO's and Cubes according to the client requirement.
• Played the BI/BW Senior developer as well as the BI architect role for the complete client Novus BW system which includes gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, Redesigning the existing models as wells as the Reporting structures, Unit testing, trouble-shooting, integration and user acceptance testing, documentation, training and maintenance.
• Used MM, Inventory, SD and PP Modules
• Analyzed the client system for suitable SCPM data sources for the different scenarios of SCPM.
• Installed SCPM BI content on the top of BI system.
• Enhanced the SCPM Std DSO's and Cubes according to the client requirement.
• Worked on customization and enhanced the extract structure to support business needs.
• Designed and developed various Data targets and Info providers like DSO (ODS), Infocubes, Infoobjects, Multiproviders and Infosets using Admn workbench (EDW, RSA1).
• Developed Transfer Rules and Update rules to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements.  

Environment: SAP ECC 6.0; SAP BI 7.0, SCPM 1.0

Confidential

SAP BW Technical Lead

Responsibilities:

• Developed various documents like Data flow, Data mapping, Data dictionary, Functional and Technical specs to support the enhanced design. 
• Created various BW backend objects which include restructuring of the Basic cubes, DSOs, Datasources, Infosources, Transformations, DTPs and Process chains. 
• Developed complex ABAP code in the end routines and start routines of the Transformation to satisfy the existing functions and latest business needs. 
• Developed DTPs and Infopackages and created various routines with ABAP for the selections.
• Handled the huge loading for historical conversion from the ECC and the legacy BW systems in D and Q environments 
• Identified, designed, developed and loaded the required Master data objects to support the new model. 
• Supported and provided BW expertise for SAP BPC team in modeling various backend object for storing master data, Actual and Planned data. 
• Involved in Unit and QA testing and performed the tuning to improve the query as well as the loading performance. Created and refreshed the BWA indexes as well as DB stats and business owners. 
• Created various transports, collected the required objects and migrated to the target systems. 
• Developed, conducted and presented various training to the users as well as the project members.

Environment: SAP ECC 4.7, SAP BW 3.5 (IS-retail)

Confidential, Minneapolis, MN

Senior BW Consultant

Responsibilities:

• Assessed project requirements defined by customer, including desired reports and performance expectations. Involved in Business blue print and technical specification. Developed of Functional Specifications for standard cost reporting. Developed Technical Design Documents including GAP Analysis.
• Configured and activated Business content according to the requirement based on the Application areas. Extracted data from data source 2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM to extract an opening stock balance, material movements and valuated revaluations in Financial Accounting.
• Created Multicube to all access reportable Objects on daily and monthly level. Configured, activated and enhanced Business content for base actual cost and project actual cost according to the requirement. Extracted data from BW to APO system and from Planning Area to Info cubes.
• Generates the BEx Reporting between actual data and planned data and facilitating the clients to analyze the Business scenario. Provided production support in BW reporting. Generated reports using BEx Analyzer and Crystal Reports.
• Participated in identifying and implementing continuous business process improvements in planning, month-end closing, and consolidation. Documented functional and technical specifications for production support and project enhancements. Participated in change management activities.
• Multidimensional Data Model using Extended Star Schema designed and developed Info cubes, DSO, Info Source and Data Source. Used Open Hub for exporting data out of SAP BW into other formats. Created Start Routines, Transformation rules for DSO and Info Cubes.
• Provided support for data load, validation, performance monitoring and tuning. BW Data load scheduling, monitoring and troubleshooting data extraction / load problems.
• Analyzed OLAP performance using BW statistics. Improved query and load performance using Aggregates, Partitions, Indices, Packet Size, Data Selection, and Data Compression.
• Used SAP BW Business Rules to improve report performance and functionality. Assisted fellow team members in solving their report issues.

Environment : SAP ECC 6.0, SAP BI 7.0

Confidential, Atlanta, GA

Senior BW Consultant

Responsibilities:

• Proficiently involved and gathered requirements during the validation phase.
• Responsible for both pre-upgrade and post upgrade activities.
• Extensively Coordinated with BASIS on site consultant.
• Proficiently analyzed custom conflicting and standard conflicting info objects during the initial phase of the upgrade.
• Modified and recreated some of the ODS, Info cubes, Multi provider reports and web templates.
• Modified some of the start and field routines as per the client requirement
• Created bulk transport request using revtrack tool.
• Proficiently involved for unit testing in development and integration testing in Quality.
• Developed Transfer rules, update rules using export data source for data migration for historical data.
• Upgrade Bex queries from 3.0 to 7.0.
• Extensively monitored weekly status calls from the client and update accordingly.
• After go- live last week and the objects are running successfully in production.
• Involved in production support for the same upgrade project

Environnent: SAP ECC 6.0, SAP BI 7.0

Confidential, Atlanta, GA

Confidential Production Support

Responsibilities:

• Uploading Master data and Transactional data of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50.
• Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.
• Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Handled the tickets of priority P1, P2 and P3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
• Used Process chains, for Sequential Background Scheduling of Master Data and Transactional Data.
• Created custom queries and defined Calculated Key Figures, Restricted Key Figure

Environment: SAP R/3 ECC 4.7, SAP BW 3.1. BW 3.5, 7.0