SUMMARY:

• SAP BW & SAP HANA Consultant with 13+ years of experience which includes 11+ years in SAP BI/BW, BW on HANA and HANA Native.
• Experience includes gathering requirements from business or IT, design & implement end - to-end SAP BW solutions, propose & implement BW system upgrades, onsite-offshore & client coordination, technical developments, system testing, user, documentation.
• Design and Implement Order To Invoice (OTI) solution in Native HANA based on SLT Tables.
• Design Graphical Calculation Views for Sales, Delivery and Invoice. And then combine them together in a CV with VBAP as left table
• Create Custom SQL procedure to handle duplication of Quantity due to Joins
• Create Custom Status of Order as per Biz Requirement
• Define Custom Aging Buckets based on daysdifference and Product Category
• Create logic to show data in any user entered UOM
• Create logic to show data going back till user entered number of days
• Implement Batch SQL Proc for Batch Processing using Delta Logic via SLT
• Design and Implement HANA Views on lines of BEx Query for Tableau Dashboards
• Design and Implement Revenue Growth Management (RGM) Net Revenue calculation project based on Actuals and Plan using existing Actuals Data in BW and using HANA to derive Planning Data coming from various sources. Merging them together in a VP and prepare Actuals Vs Planning BEx Queries
• Data Provisioning
• SLT Expert - Configure SLT & Replicate transparent/pool/cluster ECC tables as well as views from ECC to HANA using complex transformational and performance settings for faster loads & minimize impact on ECC; Monitoring and Error handing Expert Functions
• SDI - Exposure to create Flow graphs using LogReader for real-time replication and POC on ABAP Adapter for scheduled load
• DXC - Exposure to Set up and configure DXC. Replicate BW Datasources via DXC in HANA IMDSO
• ODP - Create ODP DS based on HANA view to load data in batch mode in BW. Used to load z IO from view to show certain Dates (existing in HANA) in BEx variable prompt.
• Implement HANA modelling solutions in HANA studio - Design modelling objects which includes creation of attribute views, analytic views, calculation views
• Consume SAPSR3 BW objects in HANA calculated views
• Consume HANA views in BW Master Data IO, Virtual Cube, Open DSO and building Bex queries on top of it
• Transported SAP HANA content with Enhanced CTS (CTS+) via SCTS HTA Or as a ABAP TR via RevTrac
• Combine BW data with various SAP ECC/Non-SAP systems loaded in HANA via views in HANA Studio
• Design Virtual Providers (with Input Parameters) on top of HANA models for reporting on BEx.
• Technical and Functional migration of BW DB2 system to HANA DB.
• Redesign of existing BW 7.1 DB2 landscape to BW 7.3 on HANA using LSA++ architecture. Design Solution to determine Core and Extensions.
• Simplify the existing SAP BW landscape. Use BW 7.4 HANA features (like Open ODS, SPO, Hybrid Providers, HANA optimized DataStore Objects and HANA-optimized InfoCubes) to optimize and reducing loading runtimes
• Specialized in LO cockpit, COPA, FI-GL, CRM and Generic data extraction methods
• Specialized in customer exit enhancements of data sources at SAP OLTP source system
• Worked on multiple implementations in various modules (MM, SD, PM, PP, COPA and FICO)
• Design & implement of Customized Infoobjects, Info Cubes, DSO Objects, Multi providers, Infosets, APDs, SPO’s
• Design & implement new dataflows for LO, MM, SD, FICO, COPA, CRM extractors
• Experience with SAP BW 7.3 on HANA, SAP BW 7.4 on HANA migration
• Done functional upgrade /Migration of BW 3.5 data flow to BW 7.3
• Done Non-Unicode to Unicode conversion upgrade
• Worked on SAP BW Accelerator, Real Time Data Acquisition, Currency and Unit Conversion
• Created ABAP Routines in transformations and maintained complex Process Chains
• Managed a BW on HANA Performance Management Project to Fine tune Daily PC Schedule, Do a Health Check-up of Entire HANA system.
• Worked on Aggregates, Indexes, partitioning and Compression/collapse
• Developed reports in front-end involving Calculated key figures, Restricted key figures, Structures, Variables, Conditions, Exceptions, Cell Editor, Formulas, RRI’s.
• Created customized Workbooks.
• Created web reports using Web Application Designer formatted reports using report designer.
• Worked on Information Broadcasting for distribution of BI Data through different channels and in different formats.
• Worked on integration of BW Reports to Enterprise Portal.

TECHNICAL SKILLS:

Domain: SAP HANA, SAP BW

Programming Languages: ABAP, SQL

Operating System: Windows, Z/OS

Tools: /DB/Packages: HANA Studio, SAP BW 7.4 (on HANA)

PROFESSIONAL EXPERIENCE:

Confidential, Boston

SAP HANA Architect

Responsibilities:

• Design and Implement Order To Invoice (OTI) solution in Native HANA based on SLT Tables
• Design Graphical Calculation Views (CV) for sales, billing, delivery, master data and then combine all in final CV
• Design and Implement Revenue Growth Management
• Propose various solutions with pros-cons for real-time solution of SD data
• Drive the set up and test SDI for batch and real-time replication

Confidential, Milwaukee

SAP BW and HANA Developer

Responsibilities:

• Configure SLT system for real-time replication of 300 ECC tables in HANA
• Configure the Mass Transfer ID, add additional fields and write transformations in SLT via LTRC and LTRS respectively
• Develop BW data flow to bring ECC tables’ data (via full/delta datasources) in BW and load till OHD flat files and send to HANA system via OS Command in Process chain.
• Design Calculation View based on SQL in HANA Studio to replicate ECC reports in HANA

Confidential, Cincinnati

SAP BW Developer and Project Manager

Responsibilities:

• Requirement Gathering and Project Estimation
• Resource Allocation, forming a team,
• Invoice creation, project audits, coordinate client meetings, manage deliverables and timelines
• Design the solution on varied technologies - SAP Enterprise Portal, ABAP and BW
• Develop the BW solution of updating BW DSO from EP via ABAP FMs
• Testing and delivering End-to-End solution

Confidential, Cincinnati

SAP BW on HANA Developer

Responsibilities:

• Technical and Functional migration of BW DB2 system to HANA DB.
• Redesign of existing BW 7.1 DB2 landscape to BW 7.3 on HANA using LSA++ architecture. Design Solution to determine Core and Extensions.
• Simplify the existing SAP BW landscape. Use BW 7.3 HANA features (like Open ODS, SPO, Hybrid Providers) to optimize and reducing loading runtimes.
• Design Business Objects Universes using Information Design Tool

Confidential

Project Manager and SAP BW Developer

Responsibilities:

• Technical migration of BW DB2 system to HANA DB.
• Research and guide the team to use new technical developments by SAP
• Guide the team on SAP HANA and migration process
• Coordinate with various teams - BASIS, Functional, Client IT, SAP Practice
• Prepare the project plan and ensure on-time delivery

Confidential

SAP BW Solution Architect, BW Developer, Team Lead

Responsibilities:

• Implement extraction from FI, CO, CO-PA, CRM, PM (Plant Maintenance), MM and SD, including both standard BI Content Datasources and generic Datasources
• Configure Datasources, InfoObjects, Transformations, InfoPackages, DTPs, DSO, Infocubes, Append Structures, User Exits, UD Connection, ABAP function Modules, Transfer & Update rules, Infospoke, OHDs, APDs, Process Chains, Reports using Query Designer
• Prepare technical specifications and coordinate with functional consultants for developments and support issues
• Gather, consolidate, and document report needs and requirements from all business groups to manage the development effort. Analyse report requirements and determine the appropriate SAP BEx solutions to be utilized for each requirement.
• BEx Query Performance Optimization of simple to ultra-complex BEx queries
• Develop and Support BPS Planning Layouts & Functions and IP Aggregation Levels & Planning Functions
• Ensure Process Chains are being monitored by the team and help them in rectification
• Ensure Client Satisfaction and SLA compliance
• Manage Daily, Weekly and Monthly reporting and client meetings
• Initiate and Suggest Root Cause Solutions (PBI) for frequently/critical issues
• Initiate and Suggest Process Improvement Suggestions (PIS)

Confidential, Wayne

SAP BW Developer and Project Manager

Responsibilities:

• Managed project management activities - created SOW, Risk Management Plan, ensured all developments are delivered within stipulated time frame.
• Followed Global Onsite-Offshore Delivery Model.
• Did Server side setup to enable settings for JCA.
• Installed the J2EE server and the Universal Data Integration (UDI) specific add-ons.
• Added a RFC server and created a new RFC destination.
• Configured the J2EE server for UD Connect.
• Then loading data in cube and designing SAP BEx reports on the same ground as their current MSI reports were.

Confidential, Omaha

SAP BW Developer, Informatica Support, Mainframe Support, SQL

Responsibilities:

• Mainframe-Informatica support at Confidential Inc for their Contracts-Invoices EDI based Legacy system
• 24*7 Onsite On-Call Support and error correction
• Extracting, Transforming and Loading the data from Legacy in MS SQL server using Informatica.
• Developed SAP BW Proof Of Concept starting Nov 2006
• Requirements gathering and scoping of POC.
• Set up end-to-end ETL & BEx Reporting in SAP BW based on BI Content extractors

Confidential

Mainframe and Informatica Developer

Responsibilities:

• Ensure Client Satisfaction and SLA compliance
• Manage business user and IT communications.
• Enhancements/Maintenance to existing PMS, CALC and AMS sub-systems.
• Monitoring & fixing current critical systems based on Informatica, SQL, COBOL, JCL, ADSO/IDMSSoft Skill and Project Management Experience
• Excellent communication, problem solving and analytical skill
• Team Management, Delivery Management, Daily/Weekly Status Dashboards, Creation of Project, Milestones, Invoice based on Milestones (FP) / Timesheet (T&M) Compliance, Quality Management Processes, Project Audits, Project Closure
• Consulting responsibilities - Business Process mapping, System Configuration, Integration testing and User
• Global Delivery Model experience which includes working onsite at client locations in USA as well as offshore locations in India
• Communicate with the business users & IT on current issues and finalizing future projects with business users, client manager and other stake holders
• Coordinate between onsite and offshore team
• Provide technical and functional guidance to offshore team
• Design Solutions and Prepare estimations for new implementations/enhancements
• Coordinate with the functional consultants for requirement gathering and GAP analysis
• Coordinate with SAP on various product issues
• Propose solutions to automate regular activities and root-fixes
• Experience in resolving production support tickets within SLA, real time-bound resolutions of process chain failures
• Well versed with ASAP and Agile Implementation methodology including Project documentation including Business Blueprint, RFP, BCP etc.
• Knowledgeable in the usage of SMP, Remedy, Clarify tools for logging in Problem tickets