PROFESSIONAL SUMMARY:

Over **+ years experience in IT industry with over 10 years of SAP Business Warehousing/Business Objects and HANA experience. Proficient with planning, design implementation, troubleshooting and performance tuning support of SAP Business Information Warehouse Reporting and BOBJ Reporting and HANA.

Experience in 3 end to end implementation and support and upgrade and migration projects.

Experience in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.

Proficient in Info Cubes design, Info Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Update rules, Transfer rules, Transformations,DTP, Info Packages using AWB.

Experience in Integrating and Extracting data into Business Objects environment from the SAP BW database system. Created WEB Intelligence(WebI) Reports formatting reports (BOBJ) as per user requirements.

Experience in Hierarchies, Authorizations, BW Statistics, Archiving, Process chains, Open hub and APD.

Experience in Design and Development of SAP BEx Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting, RRI, Reporting Agent and Broadcaster.

Implemented Single version of truth in reporting environments using SAP BI reporting tools (BEx, WAD & Business Objects) to support Operational, Analytical and Management reporting.

Experience with SAP ECC functional tables, BW Data Sources, BW extractors, and their data models.

Web Reporting Developed Web reports, Web items, customized Web templates using Web application designer (WAD) and query designer.

Knowledge in Xcelsius Dash board reporting and Webi Reporting.

Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning.

Strong in automating the data loads by identifying and eliminating manual process steps in reporting solutions. Expert in data recovery and work plans.

Expert in delta enabling existing and new data sources. Expert in LO implementation, enhancement, with delta relevant new user defined fields.

Very quick in finding the root causes of production issues and designing quick fixes and robust solutions for making the BI Landscape stable.

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 BW 3.1C to BI 7.0 (NW2004s). Business Area: FI-CO, SD, MM, PP.

Well-versed with SAP BW 7.3 migration features, Hybrid, Transient info providers, BWA objects, Semantically-partitioned objects (SPO's).

BW Upgrade experience of Migrating Frontend solution such as Queries, Workbooks & Web reports, Unit of Measure migration with BI 7.0, successful implementation and Delivery.

Expert in HANA, BW on HANA,BW modelling with best practices.

Expert in integrating non-sap data to sap BI,SAP Hana by designing best data provisioning ETL techniques, data flow and reporting solutions.

Integration and system compatibilities with BODS and HANA. (Data provisioning through SLT, Business Objects EIM, HANA Data modeler), Explore the usage of Base version of SAP HANA and SAP BW on HANA and its compatibilities and configuration tools.

Fine-tuned BW/HANA with ABAP and recommended corrective action.

Handled complete BW Architecture, Design and Integration with HANA, BW On HANA, BOBJ 4.x using layered scalable architecture++ (LSA++) with hybrid Analytic/BI application.

Experienced as SAP BI/BW Architect and hands-on developer of both traditional BW and BW on HANA with experience in design documents for BW on HANA.

Hands on in SQL Scripts, Procedures and SQL calculation views in HANA.

BW 7.4 on HANA : Open ODS view using Hana tables and virtual tables using SDA, Composite provider, ADSO,Field based and IO based modelling,

Designed SAP HANA data modeling using Attribute View, Analytic View, and Calculation View

Definition, design, and implementation of SAP SLT replication schemas in SAP HANA.

Proven experience with reporting including handling complex scenarios using joins, Union and SQL Script.

Ability to administer, monitors, troubleshoots, analyze, and resolve HANA & BW technical problems.

Redesign and deploy some BW 7.3 InfoCubes and DSO’s to take full advantage of HANA capabilities and new future.

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, BODS 4.0, SAP HANA 1.0,HANA Studio, SAP BO SCPM 1.0,Data Modelling using HANA Studio, BO 4.1/4.03.X, IDT4.1.Webi 4.1

SAP Modules

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

Reporting / Design Tools:

BEx Query Designer, BEx Analyzer, Web Application Designer(WAD), SAP BO BI 4.0, BO XI 3.X, Web Intelligence, Xcelsius, Deski, QaaWs, Infoview, IDT & UDT,

Operating System

SAP ABAP/4, SQL

EDUCATION :

BE degree in Electronics & Communications from Kuvempu University, Karnataka, India

CERTIFICATIONS:

SAP Certified Application Associate - SAP HANA- C_HANAIMP151(Edition 2015) passed with 84 %.

PROJECT SUMMURY :

Caterpillar Global Mining, Milwaukee

Sr SAP BW Consultant

May 2013 to Jan 2017

Caterpillar serves the worldwide mining community through its Caterpillar Global Mining organization. Global Mining is the single point of contact for global mineral producers and the primary link to the Caterpillar extended mining enterprise. They provide mine-specific product and service solutions that help customers enhance safety, improve efficiency, increase productivity and reduce cost per ton.

Responsibilities:

Participate in the requirement analysis with business users to identify and finalize requirements.

Perform application study and provide inputs for the development estimation.

Write code, and perform technical, analytical and configuration tasks.

Involved in the performance enhancement activities like enabling cache, maintaining aggregates etc.

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.

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.

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.

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.

Responsible for the documentation and successful transportation of the requests to upper landscapes.

Created user-exit variables to populate the values automatically on the selection screen. Complexity includes changing of one variable value based on the value generated for another variable.

Involved in production support activities.

Trained end-users on how to create ad-hoc queries in the production system.

Investigate and resolve production issues rapidly and communicate every aspect of technical design and development effort to Project Manager for project scheduling purposes.

Has successfully completed multiple life cycle SAP BI implementations and was as a key member of several project teams through all phases of implementation of SAP BW in SD and HR modules.

Demonstrated expertise Extensive experience in Standard Business Content of Various business modules and Custom InfoCubes, InfoObjects and Web reporting, Extraction (LO Cockpit, Generic Extractions), Transfer Structures, BI Transformations, Infopackage, Multiproviders, Data transfer process, Data Store Objects (DSO).

Proficient in data design models- Star Schema and Extended Star Schema model.

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

Novus International, St Charles, Missouri

SAP BW/SAP BO SCPM Lead Consultant

Dec2011 – Apr 2013

Nippon Soda Co., Ltd. in 1991, setting Novus on its path of Health through Nutrition based on science. With two products for the poultry industry and the vision of helping to feed the world affordable, wholesome food, Novus International was born. Since 1991, Novus has brought numerous products to the market, including more than 100 over the past decade, and developed product families including Methionine solutions, Novus’s comprehensive portfolio provides a holistic approach to solutions, service and sustainability for poultry, swine, aquaculture and cattle.

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 Datatargets and Infoproviders 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, SAP BO SCPM 1.0

ITC ABD (Agriculture Business Division)

SAP BW Technical Lead

Sep 2010 – Nov 2011

ITC is one of India's largest integrated agri business enterprises with significant presence across every node of the agri value chain. The leadership position of ITC's Agri Business is anchored in its strong and enduring partnerships with farmers across the country, which has revolutionized the agricultural sector in rural India.

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 and designed new process chains as per the need from client.

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.

Involved in defining the SAP Standard practices.

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)

Digital River, Minneapolis, MN, USA

Senior BW Consultant

June 2009 – July 2010

Digital River, Inc. One of the most trusted names in E-commerce and Web-based technology. Digital River provides its partners and suppliers with a variety of fulfillment, support and E-commerce related services. Some of these services may be provided through sites bearing partners’ and suppliers’ names and trademarks and are not in the sole control of Digital River. Additionally, Digital River may provide links from our Website to the websites of third parties who may provide services directly or on their behalf.

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 Multprovider to access all 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.

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.

In BI defined reconciliation process, rollup via Hierarchies on customer/product/sales, customized BI data model for BPC Actuals. Data loads done by defining process chains and included BI processes like info providers, packages, data sources to extract data from ECC6.0 and other source systems

Developing BW solutions related to change requests with support from functional teams by developing queries and/or infrastructure to support queries

Providing feedback for training strategy to provide better support to the BI7.0 user community

Expert in BW design, development, implementation and support of technical specifications related to ODS, cube, multi-provider, and query design development within the established time frames as it relates to change requests. Utilized Fox coding extensively in planning packages to modify, revaluation, copy, delete, intercompany eliminations

Environment : SAP ECC 6.0, SAP BI 7.0

Coca-Cola (CCE), Atlanta, GA, USA

Senior BW Consultant

Upgrade from SAP BW 3.x – SAP 7.0

Aug 2008 – Jan 2009

Coca-Cola Enterprises is the world’s largest marketer, producer and distributor of Coca-Cola

products. We operate in 46 U.S. states and Canada, and are the exclusive Coca-Cola bottler for

all of Belgium, continental France, Great Britain, Luxembourg, Monaco and the Netherlands. Their sales represent 18 percent of The Coca-Cola Company’s worldwide volume.

Responsibilities:

Worked on BW Upgrade project and did both Functional and Technical upgrade of BW 3.5 to BI 7 EHP1.

Performed BW Technical upgrade which includes Validate ABAP Dictionary, Check Infoobjects inconsistency & System Codepage Settings, Check F Partitions, create Primary & Secondary indexes etc.,

Fix all Upgrade related issues, apply SAP Notes, Testing.

Discussed Strategies of rolling out Netweaver 2004s Tools to update all users’ desktop, new Authorizations and Security for all Front-end tools for End user, super users, power users, Timeline for upgrading all front end tools such as queries, workbooks etc.

USER TRAINING :Provided Training for Super Users and Power users about How to Upgrade Queries and Workbooks, new BI 7.0 Tools such as 2004s Query Designer, Bex Analyzer, Web Reports, How To create Queries and Workbooks.

Provided after-sessions to resolve doubts and Questions from Users with new 2004s front end tools and provided solution whenever possible.

Created lots of How To’s & QRC documents that provides detailed steps with screenshots of How to Migrate a Query, Workbook to BI 7 versions, How to reproduce original BW 3.5 query version, How to do Information broadcasting with new 2004s, How to verify the version of Queries 3.5 or 7.0, Unit of Measure upgrade modifying the Numerator to Denominator ratios etc.,

Maintained process chains and resolved Errors and Dumps.

Analysis for potential migration of all BW 3.5 Queries & Workbooks to BI 2004s.

Discussed Strategies of rolling out Netweaver 2004s Tools across multiple landscapes.

Strategies for different level of security, User Access, different landscapes, Testing phase etc., for Migration Project.

Deliverables and documentation for BI Reporting Workshops for End Users. Etc.,

Environnent : SAP ECC 6.0, SAP BW 3.01, 7.0

Coca-Cola (CCE), Atlanta, GA, USA

CCE Production Support

June 2007 – Aug 2008

Responsibilities:

Post-Production Support -- Responsible for 24X7 hour support of the system on a regular basis.

Monitoring of process chains and analyzing the reasons for frequent failures of the Process Chains.

Involved in Load monitoring using RSPC, RSMO, SM37, and SM50.

Involved in escalating high-prioritized tickets regarding extractions, performance issues and also loads failures.

Maintaining Reconciliation's to verify the data in SAP R3 and SAP BW are same or not after the data loads.

Generated reports using BEx (Business Explorer) with variables, exceptions, restricted key figures, calculated key figures, conditions and formulas.

Analyzing business-reporting requirements that could be satisfied by the users.

Monitoring the performance of queries and effectively presented the report as per the requirement.

Modifying the reports as per the user requirements .

Increased the query performance with the help of RSRT.

Created Aggregates to increase Query performance.

Involved in maintaining lot of documentation for all the Support Activities.

To inform the onsite people if there are any deadlocks and communicate with the customer who posts the ticket.

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

Contact this candidate