SUMMARY:

• Over 13+ years of IT experience in SAP Implementation, BW HANA Migration, upgrade and Maintenance projects.
• SAP Certified Application Associate in SAP HANA.
• 10 years of experience in SAP BI, Native HANA & Business Objects.
• 3 years of experience in SAP - ABAP
• Experience in 2 full life cycle implementations including Business Blueprinting, Design, Development, Unit Testing, Integration Testing, Training Documentation and end user training.
• Extensively worked on creating schema, packages, attribute views, analytic views and calculation views in native HANA
• Experience in SAP HANA Administration and Performance Optimization.
• Strong development experience in SQL Script Views and stored Procedures.
• Extensively worked on ADSOs, Open ODS, Composite providers, InfoCube, MultiProvider, Virtual Provider, Transient Provider, Composite Provider, DSO, InfoObjects, Datasource, Transformation & DTP, Process Chains, Open Hub Destination, (OHD) and APD.
• Good knowledge on LSA++ modeling for BW on HANA
• Extensive knowledge and hands on using SAP Hana data provisioning tools(SAP BO Data Services, SAP LT Replication Server (SLT), Hana Smart Data Access (SDA), Hana Smart Data Integration (SDI)
• Experience in SAP HANA architecture, optimization techniques, delivery units (transports), CTS+, and Hana Native transport
• Experience in multiple module like SD, MM, PM, PP, FI-CO, SCM, Vistex, CRM, HR, BPC and EWM,
• Complete Software Development Life Cycle experience including requirements gathering/ analysis, prototyping, design, development, implementation, testing and documentation.
• Implemented multiple full life cycle Projects using waterfall and Agile methodologies.
• Strong production support experience involving data load monitoring, data load fixes, improving loading performance etc.
• Knowledge in BODS, Lumira & Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Plano, Texas

Environment: HANA 2.0, HANA DB migration, BI 7.5, Projects & Maintenance activities..

Responsibilities:

• Extensive use of BI features such as Semantic Partitioned Object-SPOs to save monthly snapshots of both transactional and master data during month-end close process for the licensed bottlers only for the last 36months.
• Implemented flex-time dimensions to derive CM, CMPY, 12MM, 12MM, PY, YTD, YTDPY, 2YFY and PYFY in the backend using extensive ABAP code to improve query performance.
• Developed HANA information views to compare case-sales volume of bottlers by Day, SKU & Store.
• Trained business users on “SAP Analysis for Office” on analyzing HANA Information views and ECC tables.
• Consolidating Sales, Delivery and Invoice data using HANA information views to derive key measures like open order, scheduled, shipped and invoice Quantities for dashboard.
• Integrating Actual sales data and APO demand planning data to determine sales index and forecast accuracy.
• Bai COPA HANA view report - uploaded Bai history volume in to BW and then combined with existing COPA sales data using composite provider.
• Developed SAP Native Hana Data Model for COPA year over year comparison report.
• Experience in SAP HANA Administration, Performance Optimization, Modeling using Different types of views and SQL Script
• S/4 HANA Testing - Test to make sure data sources are still working as before after migrated to S/4 Finance as finance table structures have changed with S/4 Finance upgrade.
• Developed FI-AR, FI-AP, and FI-GL in BW for financial reporting in BW
• Developed HR reports to provide reporting of SAP HR, Payroll, and Kronos 6.2 data to get payroll results from ADP and SAP HR to show Hours Worked and Amount paid by wage type and pay period details.
• Created Inventory Roll forward Report - Provides beginning and ending inventory balances in both Quantities and Amounts along with various buckets like production, Customer shipments, Stock Transfers, Shrinkage, Breakage and Obsolescence for both Finished Goods and Components.
• Developed Inventory WIP aging report to show last movement date for semi-finished products.
• Developed Concur report to reduce manual effort to collect report on spend categories across business units
• Developed EMO (Equipment movement order) reports to focus mostly on the number of deliveries and pickups. Also major measures include how fast delivering the product to the market (Speed to Market Rate) and performance goals for product placement.
• Developed APD to transfer daily sales data to TM1 for planning & Budgeting
• Developed Vistex charge backs agreement reports to provide a summary line for each billback agreement.
• Stock Transfer Projection report - Get projected stocks from MRP Long term planning based on MRP elements (Shipment Notification, Order Schedule lines and Simulation orders).
• Inventory Adherence Report - to monitor minimum and maximum safety stock limits against daily demand by plant, Material.
• Involved in BI 7.5 upgrade and patch Upgrades - Test, Roll out and cutover activities.
• Flattening the “sold to customer” hierarchy and delivery Agent hierarchy
• Safety Stock trend analysis report for Material Master - Brought in the change log data for the material master into BI which will have the history data of all changes in safety stock, Minimum safety stock, maximum stock level and maximum lot size.
• Created Production Sales Inventory report in BW system to carryout MRP long term planning for capacity (production, transportation) in WD business and DSD business.
• Analyzing performance bottlenecks in various areas like Data Extraction, Report execution and design issues.
• Responsible for entire development activities for the client - Data Delivery, Data Quality, Adhering to SLA for Application availability, Performance tuning, Memory Space Management, PSA administration, Query changes, Security Role Maintenance, Remedy Ticket Handling within SLA limits, Providing Metrics for Production Support as well as restoration issues.

Confidential

Responsibilities:

• Lead Role in activities like - SAP BI upgrade and implementation and in charge of cutover activities during SAP BI/Oracle Patch application, Legacy system upgrades and Enhancement Pack and SAP/BI Patch Upgrade projects.
• Extensively involved in the data extraction of CO-PA, LO, Generic (View, Function Module, Info set Query),
• Involved with performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing of Info Cubes, Splitting Data Loads, etc
• Extensively used BEx Analyzer to build Work Books.
• Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Variables, etc. For customized reporting using BEx Analyzer, BEx Query Designer.
• Involved in the production support, fixing errors in daily ETL Data load (Full/Delta up-load) Monitoring of the BW jobs and designed Process chains for Daily, Weekly, Monthly data loads.
• Involved in solving the tickets regarding extractions, Performance Issues and also load failures.

Confidential

Responsibilities:

• Data extraction from R/3 to BW by using LO Cockpit (LBWE) initialized the setup tables. Scheduled and Implemented delta mechanism for periodic loads.
• Extensively worked on Report Generation on BEx Analyzer using Navigational attributes Filters, Variables, Structures, Calculated and Restricted Key Figures, Conditions and Exceptions for the queries.
• Developed flexible queries using filters, navigational attributes, variables, in Bex analyzer to facilitate data analysis in a drill down or summarized way to give detail level of information.

Confidential

Responsibilities:

• Created the HR report to extract the job file and uploaded into third party system. This file will contain all active positions each run and only those positions that have become inactive since the last run of the program.
• Developed a report to prepare a public price list for the materials for the various sales organizations. This facilitates to the customers to avoid the manual interaction in preparing the price list every time when there is a change in the price.
• Developed a Confidential Function Module in R/3 to find the deliveries with discrepancy for the given date range and plant and developed a program in BIW to update Confidential by using this Confidential Function Module with delivery discrepancies data.
• Created Prototype in Module pool to fill up the weekly timesheet and send it to the project manager and to the user with attached documents.