SUMMARY:

• Overall 11+ years of experience in IT. 10 years of SAP BI/HANA/BW consulting experience with clients spanning across, Manufacturing and Retail in functional areas SAP PP, QM, FICO, SD, LE, MM, PS,HR and 5 years in Business objects solutions XI 3.1/ BI 4.1.
• Experience in Gap analysis, Blue Printing, Realization, Production support, Testing, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Data loading and Reporting. Expertise in Universe and Information Design Tool (IDT), Web Intelligence, Design Studio and Xcelsius Dashboard Design for development. Includes almost 2 year s in SAP HANA . 3end to end implementation, 2 Projects in 24/7 production Support, Upgrade and Migration Project and Development project. Worked in Manufacturing domain, Retail and CPG domain. I have more than 3 years of US work experience working for Major clients across US.

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 IP,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

SAP Consultant

Responsibilities:

• Integration between SAP system and Confidential e-commerce.
• Analyzed and the requirement and identified the BAPI’s to communicate the 2 systems through web server.
• Identified the right BAPI’s in SAP system according to requirement like to get Material avialbility, material price, order details, quote details, delivery.
• Modified the BAPI’s to get the Material Price and quantity, order details and quote details from SAP system.
• Created Web services in SAP system to talk to JAVA .

Environment: SAP S/4 HANA, ABAP, BAPI’s

Confidential, Milwaukee, WI

Sr SAP BW Consultant

Responsibilities:

• Expert in requirement gathering, documenting the requirements, designing and then implementing the solution for different complex Requirement.
• Involved in the overall design and implementation of SAP Business Intelligence solution which includes analysis, design, development, performed reviews, support and tuning of large, complex integrated reporting systems.
• Applied deep understanding of SAP BW to design solutions, troubleshoot issues both on the SAP BW and Business Objects side to maintain satisfactory report generation performance.
• Expert in evaluating and recommending best approaches and tools to support business and technical requirements.
• Worked extensively on standard and custom defined LO extractors. Used LO structures for extracting IR Data and also Generic for some complex requirements.
• Worked extensively on Inventory extractors and Non-cumulative and Snap shot model.
• Worked on standard production costing extractor to get different kind of costs from SAP ECC (local cost, supply chain cost and con cost).
• Worked HANA POC for finance team to leverage the existing information.
• Involved in migration of traditional data base to HANA Database.
• Worked on GL line item extractor to sync with inventory balances.
• Written Customer Exit Variables for calculating values with the help of the user entry variables.
• Expertise in using Analysis Process Designer to provide solution for complex business requirements.
• Involved in production activities like data load monitoring, fixing load failures, improving load performance, PSA clean up, table space tracking etc.
• Worked on improving load and reporting performance using APD (load) and BI accelerator.
• Extensively worked in ABAP to build report on system tables, function modules for generic extractors.
• Extensively used Information Broad casting to broad cast month end reports to different user groups.
• Reviewed and resolved both Front end and Back end performance issues.
• Created Information Broadcasting settings on queries to broad cast to mail box.
• Developed various RRI / Jump Targets using RSBBS and use customer exits for unique requirements. Resolved Query Performance issues using transactions such as RSRT and RSRTRACE.
• Created webi reports for product costing and published into portals.
• Build a scalable LSA++ architecture for the BW on HANA datawarehouse.
• Performed pre-migration activities for BW on HANA implementation from 7.3 to 7.4 and optimized BW modeling objects as per the need for BW on HANA.
• Created functional and technical specifications for Data models based on BW on HANA.
• Designed and created Master data HANA Attribute views.
• Designed and created Analytical and Calculated Views as per the reporting needs.
• Extracted data from legacy system to HANA database using Data services.
• Created analytic indexes and composite provider based on HANA View and BW Infoproviders as per the reporting needs.
• Worked on redeveloping of Bex web templates to Design studio with a different User Interface using different customized cascaded style sheets. 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.
• Used dynamic Tiering to keep data in memory or disk.
• 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, Missouri

SAP BW/SCPM Lead Consultant

• 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
• Installed SCPM BI content on the top of BI system.
• Used APD to get data from Inventory report to direct DSO through APD to get Inventory KPI’s
• Developed real time Infocubes for IP Planning.
• Designed and developed Info Objects, Info Providers, Aggregation Levels, Filters, Planning Functions, and Planning Sequences
• Configured and involved in troubleshooting custom IP applications using the BEx toolset including BEx Query Designer, BEx Analyzer, and BEx Web Application Designer
• Used the input-ready queries to create applications for manual planning and complex planning scenarios .
• Created variables to parameterize queries, planning functions, filters, and characteristic relationships.

Environment: SAP ECC 6.0, SAP BI 7.0 and Integrated Planning (IP), Fox Formulas, 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 includes 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 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 Bangalore, India

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.
• Generates the BEx Reporting between actual data and planned data and facilitating the clients to analyze the Business scenario.
• 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 Post Production 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.

Enivrement: SAP ECC 6.0, SAP BI 7.0

Confidential

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 call 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

CCE 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.

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