PROFESSIONAL SUMMARY:

• Senior SAP BW/HANA/BO/BI Consultant with over 13 years of expertise in SAP PHARMA/RETAIL/AUTO/CONSTRUCTION industries implementing business applications to increase reporting capabilities of the company.
• Involved in five full life cycle implementations, of SAP BW/BI - 7.5,7.4, 7.3, 7.0, 3.5 || BOBJ - 4.0, 4.1, 4.2 || HANA.
• Involved in all phases of ASAP for BW which includes requirements gathering, functional technical design documents, development, unit testing, integration testing, UAT, Go-live and post Go-live support.
• In-depth exposure in technical as well as functional areas like SD, MM, PP, EWM, SRM, APO, FICO from SAP BW ETL and reporting perspective.
• Good experience in Onshore and offshore model delivery for Global Clients.
• Excellent communication, interpersonal, positive work attitude and self-motivated to work independently as well as in a team. Good Understanding of both business processes and technical development.

KEY FUNCTIONAL AREAS:

• Developing HANA modeling artifacts like Attribute view, Analytic view and Calculation graphical and script view.
• Having Experience with SAP HANA Data Provisioning (SLT) for data extraction from SAP.
• Developing data modeling from HANA to BW using ODP (Operation Data Provision) interface
• Developing multiple SQL script stored procedures to achieve complex business scenarios and performance tuning.
• Have extensive experience in data analysis and SQL programming to analyze and debug the complex SQL queries.
• Having very good experience in HALM concept to transport objects in SAP HANA Landscape.
• Experience in integration of HANA with BO Components.
• Experienced in configuring SAP HANA Live content for business requirement.
• Had worked on HANA Security by creation of users, roles and assignment of analytic privileges.
• Expert in Analyzing and Extracting SAP data into BW using R/3 structures of LO-Cockpit SD, PP, MM functional areas including development of complex customer exits to support extended extractor structures on SAP R/3 side.
• Expertise in identifying and installing Business Content ODP-SAPI and HANA CDS views.
• Worked on real time replication scenario between SAP source system and SAP BW by using ODP-SLT.
• Worked extensively on extraction of data from Non-SAP Applications via DB/UD connect, Flat File and SAP data via ODP-Extractors. Good understanding of SDA/SDI extractions.
• Hands on experience in designing and optimizing of below complex custom and standard Hana mixed data modeling objects using LSA++ design principles.
• Traditional - ODS/DSO, Info Cubes, Remote Cubes, SPO, Virtual Providers, Info Sets, Multi Providers, Aggregates, Compression, Update rules and Transfer Routines, Info Spokes.
• Advanced - Data Source, Info Objects, Field Based, ADSO, Transformations, Info Packages, DTP, Composite Provider, Open Hub, APD, Indexes, Partitioning, Process Chains, Open ODS Views, Expose BW Models and build complex custom Calculation Views using Graphical / SQL CE library functions / SQL Scripts.
• Designed, developed custom BW Queries using Bex functionalities like cell definitions, conditions, exceptions, customer exist, replacement path variables, structures, restricted / calculated key figures, jump analysis using RRI, virtual characteristics / key figures.
• Expert in resolving production support issues and analyzing the issues related to load failures. Monitored and managed data loads scheduled for daily, weekly, monthly with full update and delta mechanism.
• Extensively worked on Performance tuning at modeling level, reporting level and in improving the load and read performance by maintaining indexes, partitioning, dynamic tiering
• Designed processes to minimize data quality risks and proactively identify potential data issues.
• Used Rev-Trac, CHARM TMS tools to collect BI/BW and R/3 Objects in Dev and transported throughout the System landscape.
• Built several Generic Extractors using function module, table, view, query info set and custom CDS views.
• BADI implementation for data source enhancement for addition field population.
• Hands on coding complex logics using latest 7.4 ABAP syntaxes in SE38 Report, BADI, functional modules, field, start, expert, end routines. Coded AMDP SQL Scripts in the BW transformations.
• Test application code from a technical perspective to verify that programs follow standards and meet technical specifications by unit and integration testing.
• Expert in debugging the data load failures to identify root cause and providing permanent fixes.
• Developed several variable user-exists and F4 BADI implementation for faster retrieval of F4 selection parameters.

TECHNICAL SKILLS:

BI/BW: BI 7.5 on Hana, SAP Netweaver BI 7.4, 7.3, 7.0, 3.5, 3.2, 3.1C, 3.0B, 3.0A

SAP R/3: S/4 HANA, ECC 6.0, 5.0, 4.7, 4.6C, 4.5B, 4.0B

SAP Modules: FI-CO, SD, MM, PP, EWM, APO, IS - RETAIL.

BO: BO XI 3.x, 4.0, Universe Design Tool, Information Design tool, Data Integrator (BODS).

Reporting Tools: Query Designer, BEx Analyzer, BEx Web, Web Intelligence, Dashboard design, Cognos, Crystal report, Business Objects Explorer, Analysis for Office, Lumira, SAC, POWER BI.

Database: HDB, Oracle 10g, SQL server, MS Access, and DB2

Operating Systems: UNIX, Windows 10/7/XP/2000/2003/NT 4.0/98/95

Languages: ABAP/4, C, C++, VB, SQL

Applications: MS Office, MS Visio, MS Power Point, MS SharePoint, HP Quality Center, BMC Remedy Action Request System version 7.1, HP Open View Service Center, HP - ALM-QC, PDOCS4.

PROFESSIONAL EXPERIENCE:

Confidential

SAP BW / BI Consultant

Environment: BW 7.5 on HANA, SAP ECC, BOBJ - WEBI, Analysis for Office, SAC.

Responsibilities:

• Involved in implementing and delivering FI GL / PO data set using LSA++ Architecture.
• FI related generic and standard Master data attribute and text data sources were activated.
• Built master data custom hierarchy consisting of 5 levels coming from different columns in a flat file. ABAP logic is used to achieve the parent child relationship.
• Built custom and standard extractors as per the business requirement using customer exists / BADI's / Function modules and installed business content.
• Built complex transformations using start/end/expert routines using 7.4 ABAP syntaxes / AMDP SQL Script and modeled data flows using ADSO, Open ODS, Composite Providers.
• Extensively worked on HANA models creating (Graphical / Script) based Calculation Views with functions like Star Joins, Calculated Columns, Restricted Columns, Input Parameters, Variables, Currency Conversion, Hierarchies, and user privileges.
• Exposure to SQL Script Functions and Procedures, Debugging and Performance Tuning and Optimization
• Developed user exists for Bex variables and developed complex queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BW query designer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Best practices were implemented like F4 BADI for faster retrieval of selection screen F4 values, Usage of control table for FULL DTP, IP, Bex variable default selection values.
• Built AO and WEBI FI & PMA hierarchy-based reports. (Spend by Supplier, Freight Cost report, UDC, GL transaction summary and detail)
• Built SAC Analytical interactive retail visualization applications using UI elements with scripting to trigger the events and created models by blending, data wrangling.
• Maintained Cutover Steps post and pre transportation of SAP objects used for development and enhancements.

Confidential, Peoria, IL

SAP BW / BI Consultant

Environment: BW 7.5 on HANA, SAP ECC, BOBJ - WEBI, Analysis for Office.

Responsibilities:

• Responsible for extracting standard/generic sales order, delivery, and billing transactional and master data related extractors from MACH1 machine system and integrate into existing EOMP (Engine) data in Business warehouse.
• Data modeling, master data maintenance and data loading (automatic and manual) were built to support new solution.
• The user experience was improved with the dealers in relation to engine and transmissions for oil and gas segment reports.
• Developed dashboard reports using SAP Webi to include all the required KPI’s
• Designed/developed and implemented Outbound Datasets using new and modified BW data models.
• Enhancements to BW for supplemental data that is currently supplied by CEOPS.
• OMP changes for enhancements that are not feasible in BW.
• Downstream system changes and testing.
• Modelled ADSO, Open ODS, Composite Provider for Sales, Delivery and Billing data.

Confidential, Marysville, OH

SAP BW / BI Consultant

Environment: SAP BW 7.5 on Hana, SAP ECC, SAP SRM, BOBJ - WEBI, Design Studio, Analysis for OLAP.

Responsibilities:

• Local reporting of financial and cost element accounting data. Includes Cost center reports, commitments, actual line items and GL cum balance reports.
• Responsible for delivering integrated planning application tool to adjust budget, CoP, forecast balances along with the ability to track on how each Operating unit is performing against the actual vs budget and actual vs latest estimate.
• Performance tuning of the back end and front end to speed up reporting.
• Worked closely with security team to test the developed Roles and Auth objects for owners/end users to access control to BW objects and hierarchical report data.
• Built complex transformations using start/end/expert routines and modeled data flows using ADSO, Open ODS, Composite Providers.
• Converted Bex workbooks to Analysis for office. Built design studio financial dashboard.

Confidential, Warren dale, PA

SAP BW / BI Consultant

Environment: SAP Netweaver W/BI 7.4, SAP ECC, BODS, QlikView, POWER BI, SQL Server.

Responsibilities:

• Responsible for development and implementation of customer service, revenue forecast and project system application requirements.
• Customer service - Service Notification Fact, Service Operation Fact, Service Order Cost Fact, Service Order Status, Service Operation Status.
• Revenue Forecast - Sales Order Fact, Reservation Fact, Billing Plan Fact.
• Project System - Project Notification Claim Fact, Project PRL Fact, Network, Operation Fact, Cost Transaction Fact, Project Notification Current Approver.
• As a team member involved in accounts receivable, measuring point, maintenance plan schedule and SD pricing (Booking / Commissions) data flows.
• Extensively used complex generic function module extractors and standard extractors.
• Developed complex data models in BW by understanding complex stored procedures written in SQL and BODS data flows.
• Used Qlik View tool to load data from SAP BW and BODS DWH system and tocompare and validate data.

Confidential, Collegeville, PA

SAP BW / BI Consultant

Environment: SAP BW 7.4 on Hana, SAP ECC, IP, WAD, BOBJ - WEBI, Analysis for OLAP.

Responsibilities:

• Extracted data from SAP tables (ZFI PH2550P, PARCT, WITH ITEM, T059Z) including pool table (T001Z).
• Enhance standard and custom extractors based on view, functional modules and tables to meet the business requirements.
• Virtual Cube expert, inverse routines, virtual characteristics and key figures (BADI’s) are used extensively to derive the business logic.
• Configure and extract Columbia (3FI SL ZO TT) ZO Special ledger totals and line item data.
• ABAP report was developed to overcome fixed length issue via BEX and WEBI.
• ABAP report was developed to avoid extra blank lines coming from WEBI text output.
• Transactional Data sources used in R14 - general ledger, special ledger, withholding tax, concur travel & expense CT&E.
• Involved in the Hana upgrade project to verify OTP and GMX applications.
• Responsible for delivering and testing OTP Security Roles - Display, historical and non-historical to meet audit requirements.
• As a team member involved in the design, development and testing of GMX ECX template interface submission project. These templates capture, calculate and report markup on a monthly basis. This enables mark-up tracking and the elimination of intra-group profits (mark-up) in the Confidential consolidated income statement.
• Involved in deploying automatic interface template submission functionality globally and streamlining their current manual template submission process.
• GMX ECX Earn-In Interface submission extracts intercompany sales and intercompany cost of sales transactions at SKU level from ECC general ledger.
• GMX ECX Earn-Out Interface submission extracts inventory disposals that occurred during the month from ECC Z4 special ledger.
• GMX ECX Inventory has three templates that are used to collect a global view of inventory. Finished goods template extracts snapshot of FG inventory balances - gross FG units, reserve FG units, in-transit units, receipts and local standard cost
• Gained fair knowledge on working on SAP BW on HANA and SAP HANA capabilities.
• Good knowledge in importing, loading and replicating SAP Tables using SLT.
• Expertise in creation of Attribute view, Analytical and Calculation View.
• Expertise in creation of time attributes, calculated attributes calculated and restricted measures.

Confidential

SAP BW / BI Consultant

Environment: SAP Netweaver BW/ BI 7.4, SAP ECC/APO/HR, BOBJ 4.1, BIA, IS-Retail.

Responsibilities:

• End Node Project - As a team member involved in requirement gathering, design, development and testing of BW End Node forecasting solution for APO Demand Planning (DP) and Supply Network Planning (SNP).
• Primarily responsible for delivering a key solution for re-alignment process as planning objects move from one End Node or Forecast Group to another.
• Developed Confidential and Luxotica - Whole sale and Retail data models to deliver various key performance indicators (KPI’s - demand history, shipment history, make to order, warranty history, store needs, door count..etc.) for demand planning and supply network planning.
• Built back up/remote/waterfall data sources using SNP and DP planning areas.
• Created WEBI and Bex reports in APO and BW to satisfy the business needs.
• Psionic Project - Responsible for requirement gathering, design, development and testing of DC Inventory, Style country channel pricing BW data feeds to 7th online planning system.
• DC Inventory Data Feed - The high level file layout is intended to receive the Confidential DC Inventory information for each Plant and Stock Category at the year/month/week level. Style Upload - Country/Channel Level Pricing - This file is used to load local currency from each region/country/channel level. Both the data feeds are for AFA materials.
• Delivered Dock to stock data model and reports based on ECC - ZRFPUTAWAY table.
• Replicated R/3 Warehouse Management Reports into BW - LT23 replenishments, customized ZOTO shipping, Ship-stat LNAD packing and ZRFPICK picking.
• Built several generic delta data sources based on ECC - WM/Shipping ZTABLES, VIEW and FUNCTION MODULE.
• Gathered additional business requirements from WM analysts based on their daily activities and provided a seamless reporting solution (Report to Report interface).
• Worked on SAP Lumira in preparing data for visualization and discovery.

Confidential

SAP BW / BI Consultant

Environment: SAP BI 7.3/3x, SAP ECC, BIA, BPC, BOBJ, SolMan and Charm.

Responsibilities:

• As a team member involved in design, development and testing of visibility to profitability - V2P supply chain reports.
• Delivered MRP Forecasted Inventory Report that was intended to aid in planning decisions and inventory management by enabling comparison of inventory at actual, budgeted, projected, and MRP forecasted quantities and values.
• Responsible for Inventory Variance Analysis Report that provides comparative analytics of inventory balances at actual vs actual, budgeted or projected data between two time periods.
• Developed Inventory Usability Report that provides visibility into inventory obsolescence risk based on calculation of remaining shelf life and batch expiration and also provide future obsolescence data.
• DOH report was built based on financial reported COGS and total gross inventory for both actual and forecast data.
• Stabilized MRP data model and associated reports and also supported all the daily BW production/business issues as well as future enhancements.
• Involved in user and documentation.
• Worked extensively in writing requirement documents, detailed design documents and test scripts - HP Quality Center.
• Validated data from SAP against the BW data. Identified error and back track them in data targets and handle the errors.
• Created the reports using BOBJ WEBI and universes for various inventory and financial reports.
• Worked with report developer to deliver financial reporting on Crystal reports
• Created and Maintained Complex Input Template & Report in 10.0 using EPM Editor & dynamic formatting as per user requirement for their consolidation process.
• Develop Dimension formula and Script logic for consolidation process.
• Integration between BI & BPC by creating Transformation and conversion file.
• Validate data in BPC with BI & finance team and fixed all issues.

Confidential

SAP BW / BI Consultant

Environment: SAP BI 3.5, SAP ECC, WAD, BEX ANALYZER.

Responsibilities:

• Built CRSD (Customer Request Shipment Date) report for sales executives and managers which provide lead time measurement for closed delivers on delivery date, CRSD date and actual shipment date.
• Created Gross Margin actual and plan report to compare the actual revenue and COGS for product line and product categories.
• Delivered Wheatland Sales Management Score Card Summary & Detailed reports which contain bookings, shipments, budgets and comparisons.
• Developed JMC (WT & AT) Inventory Analysis Report to track number of days left for Finished Goods and Raw Materials at plant level based on inventory and net shipments. User just keys in a date, eighteen queries are refreshed and the required fields are mapped to fill the buckets.
• Developed custom Atlas supply chain reports that include shipment, bookings, inventory levels, exchange rates and freight reports using CKF’s, RKF’s and cell s.
• Deployed Prior year end, current year average, prior month end and current month Inventory and Shipment analysis queries.
• Created Variables with Exit type to calculate first and last day in fiscal period from date entry.
• Developed ABAP start routine to calculate working days in fiscal period and number of working days month to date using function modules that include first day in period, last day in period and factory date.
• Automated and generated Atals executive dashboard using WAD to broadcast last working day based on factory calendar.
• Used APD to push inventory load into a DSO for last 200 days using inventory report and 0mat plant.
• Used event based program triggering in process chain to trigger non-uniform broadcasts.
• Built Agent field based authorization object (zauth) for users to display only their data.
• Updated BW steps in FI, OTC, P2P and PL2PR integration ECC 6.0 upgrade test scripts. Developed custom queries to validate existing ECC data flow into BW.
• Worked with Chainalytics team and provided them with history of business data for their study.

Confidential

SAP BW / BI Consultant

Environment: SAP BI 3.5/7.0, SAP ECC/IP/BODS, TOAD, COGNOS

Responsibilities:

• As a team member involved in design, development and testing of user requirements for SAP BW implementation by identifying needs of the business users.
• Involved in the design, development and prototyped migration of over 120 cognos reports from existing legacy oracle data warehouse to BI 7.0. Non-SAP data includes EDOC, GETS and LIMS using DB connect and UD connect.
• As part of the data migration project worked on setting up extracts from SAP that includes Purchase orders, revaluations and production orders.
• Involved in the development of Global Master Data Harmonization: Merge data from multiple SAP systems with dissimilar Master Data using integrated planning and BPS.
• Deployed standard and custom inventory reports from Multiple R/3 Systems. Includes Stock Overview, Slow moving inventory and Inventory Valuation Reports.
• Deployed purchase order item data and catered Vendor Evaluation Reports.
• Local reporting of financial and cost element accounting data. Includes Cost center reports, commitments, actual line items and GL cum balance reports.
• Configured BI 7.0 Admin Cockpit for monitoring query runtimes, data loads etc. Created new queries and activated technical content to read relevant data per IT needs.
• Developed various info-objects, ODS, Cubes, Multi Providers, Info-sets, Transformations, Update rules, Transfer rules, Info packages, DTP Transformations, Complex start/update routines, delta loads and process chains as part of development in the above projects.
• Developed user exists for Bex variables and virtual key figures as well as developed complex queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in Bex query designer to facilitate data analysis in a drill down or summarized way to give detailed level of information on the portal.
• Worked on WAD (Web Application Designer) to insert multiple queries and to make cosmetic changes to the reports.
• Developed various BW-BPS planning area/planning levels/ planning functions/ planning packages including BPS cubes (transactional cubes) to load demand planning data. Also developed web interfaces to upload planning data into BPS cubes using Business Server Pages (BSP).
• Developed and Scheduled of complex loads using process chains for SAP and NON-SAP loads.
• Managed various BW Transport issues to make sure the smooth transition of BW objects from development to production.
• Supported all the daily BW production/business issues as well as future enhancements.
• Day to day management of various info cubes/ODS’s. Monitored data loads of master data and transaction data and tuned the data load performance.
• Support pack upgrade from SP 11.0 - SP18.0
• Involved in user and documentation.
• Worked extensively in writing requirement documents, detailed design documents and test scripts. (Tools: eDoc, One Source).
• Validated data from SAP and Non-SAP against the BW data. Identified error and back track them in data targets and handle the errors.
• Used global system change control (GSCC) track wise tool to move the changes to production and also to track and document changes made to global systems.
• Worked closely with compliance to ensure CSV Compliance.
• Worked closely with security team to test the developed SAP BW Roles, Composite Roles and Authorization objects for power/end users to access control to BW objects and hierarchical report data.
• Worked closely with portal team to test the developed application tab and associated queries.