SUMMARY:

• More than 16+ years of IT industry and nearly 13 years of SAP experience in Finance, Consumer Electronics, Retail, Manufacturing and Utilities and Energy (Electric, Water and Gas) Industries.
• 9+ Years in SAP BW/BO and 3+ Years in SAP BW/4 HANA as Techno - Functional Consultant
• More than 13 SAP Live Implementations projects, 5 SAP Support Projects.
• Excellent knowledge on: SAP BW/4 HANA, Advanced DSO(ADSO), Open DSO Views, Transient Providers, Composite Providers, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA, LSA and LSA++, ODP API like SLT and SAPI.
• Developed and supported creation of BW Objects like InfoCubes, MultiProvider, Remote Cubes, Transactional Cubes, Data Marts, Info Source, Info Package, Data Source, Info Objects, Update rules, routines, and Transfer rules.

TECHNICAL SKILLS:

SAP Systems: SAP ECC 4.6c, 4.7, 5.0, 6.0, SAP IS-U, SAP IS-Retail, SAP BW 3.x, SAP BW 7.x, SAP BW/4 HANA, SAP POSDM

SAP Business Warehouse: BW Queries, BEX Reporting, BW Data Modeling, Extraction, Data Loading and Enhancements in BIW, Open Hubs, APDs.

SAP BW/ 4 HANA: SAP HANA Design Studio, SQLScript, CE Functions, PL/SQL

Reporting Tools: SAP BEX Analyzer, SAP BEX Query Designer, Web Application Designer (WAD)

Business Objects: - XCELSIUS, Dashboard, Universes, WEBI, Tableau 9 & 10 and Crystal Reports 2008/2011

Functional Area: FI-AP (Accounts Payable), FI-AR (Accounts Receivable), FI-GL(General Ledger), CO-PA, Material Management (MM), Sales and Distribution (SD), LO (Logistics Cockpit), Finance and Control (FI-CO), HR-PA (Human Resource - Payroll), HR-OM (Human Resource - Org Management), Human Resource (HR), Industry Specific Utilities (IS-U), Industry Specific - Retail (IS-R) and SAP POSDM.

PROFESSIONAL EXPERIENCE:

Confidential

SAP BW/ 4 HANA Technical Lead

Responsibilities:

• SAP BW/4 HANA Modelling for ADSO and Open ODS, Extraction and loading of data from Sales Stats (0UC SALES STATS 02) and Mass Extraction Activity for FI-CA: BP Items, Payments and Payments Lot, Promise to Pay, Installment Plans, Settlement Documents, Returns and Checks.
• Worked extensively in the Finance - Accounts Payable (FI-AP) - 0FI AP 1, 0FI AP 4; Accounts Receivable (FI-AR) - 0FI AR 1, 0FI AR 4; Finance - General Ledge (FI-GL) - 0FI GL 1, 0FI GL 2, 0FI GL 4, 0FI GL 6 and 0FI GL 10, CO-CCA Extractors (1 CO CCA 1.).
• Extensive understanding of FI-CA, CO, IS-U Billing, IS-U Customer Service and IS-U Device Management .
• Involved in requirement gathering for development, Data modelling and designing reports as per the requirement. Also Involved in Installing BI Technical Content.
• Installed Business Content for standard Info objects, Info-Sets, Info-Cubes, and Multi-Providers etc.
• Worked extensively on Open hub, APD tools to download data to the Third-Party Tools from BW
• Performed analysis, design, development and implementation of standard/customized Info-Cubes and ODS Objects for IS-U Billing, IS-U Device Management.
• Responsible for planning cut-over activities for the go-live support for the development work.
• Establishing connectivity between the SAP BW Info-Cubes/BEX Queries with Tableau 9 and designing Tableau queries for the end users.
• Importing KPI from legacy systems and ticketing systems to Power BI via SAP BW InfoCubes.
• Assisting the City’s user base to facilitate their jobs on the Portal for ESS (Employee Self Services) and MSS (Manager Self Services)
• Publishing Reports on the Portal and creating new Web Templates in WAD for publishing on Portal.
• Created PL/SQL Procedures for large loads special for IS-U (Installation Facts, Contract Accounts)
• Redesigned HANA Attributes Vies, and HANA Analytical Views for Sales Stats Extractor Loads and called them using the Open ODS (Using Database Tables/ Views) in SAP HANA Studio for SAP BW/4 HANA.
• Worked on both Load performance tuning and Report performance tuning by creating DB Statistics, Aggregation, OLAP Cache, Compression, Indexes and Partitioning

Confidential

Responsibilities:

• Extraction and loading of data from, Installation Facts (0UC INSTALLA), Sales Stats (0UC SALES STATS 02) and BP Items, Sales Stats and Stock Stats Mass Activity.
• Worked extensively in the Finance - Accounts Payable (FI-AP) - 0FI AP 1, 0FI AP 4; Accounts Receivable (FI-AR) - 0FI AR 1, 0FI AR 4; Finance - General Ledge (FI-GL) - 0FI GL 1, 0FI GL 2, 0FI GL 4, 0FI GL 6 and 0FI GL 10, CO Extractors (1 CO CCA 1) and (1 CO CCA 3).
• Involved in requirement gathering for development, Data modelling and designing reports as per the requirement. Also Involved in Installing BI Technical Content.
• Worked extensively on Open hub, APD tools to download data to the Third-Party Tools from BW
• Performed analysis, design, development and implementation of standard/customized Info-Cubes and ODS Objects for FI-CA, FI-AP, FI-AR, IS-U Billing, IS-U Device Management.
• Responsible for planning cut-over activities for the go-live support for the development work.
• Worked extensively on HANA Optimized Cubes, Migrated Old DATA Flows to Hana Optimized Flows, developed Open ODSs and HANA Analytical Views, HANA Attribute Views for the GRC (Global Rate Case) filling process.
• Wrote SQL Script on Installation Facts and Contracts Data calculating their new Measures for GRC Process
• Used WEBI to connect with the SAP HANA Database, in designing new Reports for bringing summarized view of large volumes of data.

Confidential

SAP BW Technical Lead

Responsibilities:

• Extraction and loading of data from Sales and Distribution (SD) related to the Sales (2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 V SCL), Shipping (2LIS 12 VCHDR, 2LIS 12 VCITM) and Billing (2LIS 13 VDHDR, 2LIS 13 VDITM) data from the LO Cockpit, and also related to the Logistic Invoice Verification and Procurement Process.
• Designed Reports, which majorly involves reporting for FI-AP and FI-AR Sales Report, Quarterly Revenue Reports, Profit and Loss % Reports, Amount Disbursement Reports, Balance Sheet etc.
• Created reports related to COPA like sales margin, sales growth, sales trend
• Involved in requirement gathering for Development, Data modelling and designing reports as per the requirement.
• Developed BW reports using BEX analyzer and Crystal Reports 2008, created queries with variables, restricted key figures, calculated key figures, conditions, exceptions etc.
• Responsible for planning cut-over activities for the go-live support for the development work.

Confidential

SAP BW Technical Lead

Responsibilities:

• Created many Proof of Concepts to help understand the requirement with the Business and to analyze the performance issues in the design
• Regular interaction with the functional team and end users to understand their Reporting Requirements and creating related informational document
• Created queries using BI- Reporting variables (using Offset values) for ITD (Inception to date), YTD (Year to date) and MTD (Month to date) Involved in requirement gathering for development, Data modelling and designing reports as per the requirement.
• Enhanced the update rules for COPA Info Cube to meet the new business requirements for Total Discounts, Gross Trade Sales and Net Sales
• Migration of old BW content (Transfer Rules, Update Rules and Old Transformations) in V3.5 to Hana Compatible Form in the areas of MM (Stocks Transfer etc.).
• Created reports on Material Master that outputs Material vaulted stock grouped by Material type and Plant. The report showed Material Number, Storage Location, Unit of Measure and description in addition to the group totals.
• Developed BW reports using BEX analyzer, created queries with variables, restricted key figures, calculated key figures, conditions, exceptions etc. Validating the transport with the help of BASIS and fixing any issues.
• Migration of Info-Providers from SAP BW Database to SAP HANA Database
• Converted the ABAP Logic used in Transformations to SAP HANA Compatible Code for In-Memory Optimization

Confidential

SAP BW Technical Lead

Responsibilities:

• Worked with Security team to Test and Document the access of different Roles (Power user and End user) with Queries and Workbooks on the new Security Authorization in BI (Analysis Authorization)
• Extracted data from the legacy systems like FDM (Financial Data Management) and Informatics into BI by Creating Info Objects, Info Cubes, DSO, Multi-Provider, Info Sources, Transformation rules
• Involved in Power User and End User training documents preparation as well as conducting sessions which ran parallel to testing. Extensively worked with FI-GL, FI-AR, FI-AP and COPA (Cost Profit Analysis) data sources
• Used routines (start routines, update routines) in update rules and transfer rules to update key figures in the Info-Cubes.

Confidential

SAP BW Technical Lead

Responsibilities:

• Involved in requirement gathering for development, Data modelling and designing reports as per the requirement.
• Data extraction from flat files, standard and custom R/3 tables and non-R/3 systems, Data Source, Info-Objects, transfer rules, Info Sources, Update rules, ODS, Info Provider, Multi Providers, BEX Analyzer, setting up batch jobs, Report-to-Report Interface (RRI), Process chains, DB Connect, Web Reporting, CTS Transports and OSS Notes.
• Rich experience in Aggregates, Performance Tuning, Partitioning, Compression, BW Statistics and BW Job Scheduling, Testing, Go-Live, Production Support, End-user training and Documentation.
• Installation of Business Content for standard Info objects, Info sources, and Info Cubes.
• Extensively worked on LO cockpit including customizing & performing necessary procedures like Setting up of Different updates, deleting set up tables, filling up of set up tables
• Data Migration of Master Data for Materials, FI-GL Balances, Orders and Deliveries, Material Stock Data etc. from legacy System to SAP ECC & SAP BI.

Confidential

SAP BW Technical Lead

Responsibilities:

• Worked on the Estimation Metrics for the Technical Object.
• Project Planning for the Realization Phase, Integration Testing and Go-Live Preparation phases
• Team Management and allocation/monitoring of the Objects assigned to Team members
• Configuration of SAP POSDM (Point of Sales Data Management) Module and LO(Logistics) Cockpit
• Configuration of SAP Data Sources like - 0RT PA, 0RT PA TRAN CONTROL and also Integration of SAP Retail System with SAP BW (POSDM) and SAP PI.
• Development of Info Objects (Characteristics, Key figures) for POSDM Interface
• Development of Info Providers (Info cube, DSO, Multi Providers) for POSDM Interface
• Designing Info-Providers (Info Cube, DSO, Info-Object - Master Data Upload) related to POSDM

Confidential

SAP BW Technical Lead

Responsibilities:

• Worked on Implementation of HR module like on Hiring, Termination, position, and transfer reports.
• Installed the HR business content like 0PA C01, 0PAOS C01, 0HR PA 0 and 0HR PA 1, 0EMPLOYEE ATTR, 0PERSON ATTR.
• Handling data load errors, compression, aggregate rollups, creating indexes, etc.
• Process chain creation for Master and Transactional data loads and also for PSA and Change Log Clean Ups.
• Development of generic data sources to upload the data from raw files, Data source enhancements through CMOD, Functional Module.
• Modifying the Process Chain to determine whether the self-load from the Info-Cube affecting the processing time for the data load from the flat file.
• Created Process Chain for periodic upload of master data, transactional data, scheduled, and monitored the delta load and full update load mechanisms.

Confidential

SAP BW Technical Lead

Responsibilities:

• Created DSO, Info-Cubes, Multi-Providers for Logistics module LO (Logistics).
• Implemented User Exits RSAP0001 for data logic modification as per the customer requirement
• Designing the Info Cubes, DSO, MP along with transformation and DTP and IP executions.
• Logical partitioning of the Info-cubes for global data in the BW system for performance tuning using aggregates before using in the BEX Reporting.
• Data Source enhancement using the User Exits for Sales order and Billing data using the LO-Cockpit extraction.