SUMMARY

• Senior - level SAP resource with 9+ years of SAP front end SAP HANA back-end BW and HANA DB
• SAP HANA in-Memory Platform core technology, including architecture, landscape design, installation, upgrades, performance tuning, system integration
• Managed the small team of analysts, developers, testers or engineers and drive delivery of a small module within a project Delivery, Maintenance and Testing
• Strong experience in solution architect on Enterprise HANA & BW on HANA
• Experience in publishing of BEx reports, BEx Workbooks and BEx Web applications using SAP BEx 7.x suite
• Experience on administration and operation including monitoring backup and restore security and user management
• Experience in SAP BW data modeling and customization leveraging optimization with SAP Vistex data
• Experience working on the profitability increase with better business decisions solutions developed by Vistex
• Strong Knowledge and Hands on experience on Technical Planning, Installations, Upgrades, HANA Migrations, Unicode Conversions for SAP Net Weaver platform, and SAP Business Object BI Platform
• End-to-end implementation of the SAP BItoolsets, which includes SAP Business Objects, WebIntelligence, Analysis for Office and Dashboards / Design Studio, as well as the connector configuration towards HANA DB both enterprise and BW
• Experience in SAP HANA development views provided that can be validated, and if gaps observed - recommended alternatives and improvements, as it relates to end design requirements of self-service Universes
• SAP HANA Data provisioning technology including SAP LT, Data Services, DXC
• Involved in Testing & Quality check for the work that is to be deployed to Production instance
• Lead and provided expertise to functional project teams and participated in cross-functional initiatives.

TECHNICAL SKILLS

Data Warehousing: SAP BW 7.x, HANA 1.0

Reporting Tools: SAP BO Web I 4.x, Crystal Reports 2008, BEx Designer

Dashboards: SAP Dashboard Designer

Programming Languages: ABAP/4

Operating Systems: Windows 95, 98, 2000, XP Window 7//98/XP/NT/2000, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

SAP HANA/Vistex Consultant

Responsibilities:

• Gathered and reviewed business requirements and interpret into an architectural design and information model for Non-SAP sources to SAP HANA environment
• Worked on sales commission and incentive compensation in Vistex leveraging in memory capabilities of SAP HANA
• Good knowledge SAP Paybacks and Chargebacks by Vistex
• Worked on Vistex solutions in accelerated cash flow and reduce vendor receivables by eliminating errors, delays and reduce administrative labor overhead costs.
• Worked on creating the technical objects related to Business Warehouse Vistex
• Involved as a key member in administer, monitors, troubleshoot, analyze and resolve technical problems
• Worked on Accountability for managing scope, issues/risks, timelines, financials and quality deliverables of engagements
• Supported pre-upgrade, system readiness checks and follow up activities of BW 7.3 to BW 7.4 upgrade.
• Worked on BW 7.3 data flows, developed semantic partitioning objects, migrated data flows using the BW migration tool, and created hybrid providers for real time reporting.
• Extensively involved in building Demo objects for the End users to present the reporting Flexibility in SAP BI 7.3 by using all the BEx components like BEx Query Designer, BEx Analyzer, BEx WAD.
• Documented the Functional and Technical Specifications for SAP HANA and SAP BW on HANA DB requirement based on the business flow for FI, SD, CO modules in the existing Legacy systems
• Participated in Blueprint and design sessions, review options and provide recommendations while communicating the benefits, risks and constraints to both the business and IT stakeholders
• Worked on configuration of HANA web services to enable other applications to access the HANA DB
• Translated the Business KPIs for Dashboards & Define the dashboard Layouts Import process
• Used Oracle as a source and SAP HANA as target with SAP Data Services as an Integrator
• Created Master data objects as Attribute views, joined multiple master data tables and when required and used in Analytical and Calculation views where entities are relevant
• Triggered the Replication of the Master data tables and Transaction data tables from SAP ECC to SAP HANA through Data Provisioning in HANA Studio

Environment: SAP HANA 1.0, SAP NW BI 7.x, SAP BO 4.0, BO Explorer 4.1 SAP ECC 6.0, SAP Lumira 1.27, BEx Query Designer, Crystal Reports 2011, WEBI, Xcelsius, Excel, Dashboards, SQL Server 2013, Tableau9.0

Confidential, CA

SAP HANA Modeler/Enterprise Consultant

Responsibilities:

• Extensively worked in SAP HANA Data Provisioning using SAP LT Replication Server while working for POC Project
• Involved in business development of the HANA solutions involving technology, process and organizational change initiatives
• Involved in planning, implementation including sizing, scoping, high availability and disaster recovery strategy
• Involved in analyzing and designing ECC 6.0 to BI 7.3 Data Flow and responsible for the deployment solutions for FI-AP, GL
• Worked on complex calculations like processing rebates, sales commission, bills back, chargeback and incentives and pay backs by Vistex
• Involved in SLT for replicating the data from ECC 6.0 to HANA
• Worked on performance tuning activities
• Designed HANA Attributes views, Analytic views, and Calculation views, Hierarchies. Analytics Privileges. Attribute Mapping, Calculated Attributes with currency as Unit of Measure, Comparing Object Versions, Export/Import of Models
• Created Universe on the top of HANA Analytical and Calculation views and developed WEBI reports and dashboards using IDT(Information Design Tool)
• Migrated HANA content from development, testing, to production environment using delivery units
• Created Reports in MM, SD, FI module such as product stock value available based on the product type, Best-selling products, Billed selling orders based on territory
• Created BEx Reports providing insight of Business Intelligence to aid the analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Customer Exit
• Translating Functional Specifications into Technical Specifications
• Translated the Business KPIs into HANA & Define the Reporting Layouts
• Interacted with business users to analyze the requirements of reports.

Environment: SAP HANA 1.0, SAP NW BI 7.x, SAP ECC 6.0, BO Explorer 4.1, SAP Crystal Reports for Enterprise 4.1, SQL Server 2013

Confidential, San Antonio, TX

SAP HANA/BW/BI Consultant

Responsibilities:

• Worked on Native HANA and SAP BW powered by HANA
• Experience on SAP Native HANA Data Provisioning (LT, DS), Data Replication, Modeling and Reporting
• Involved in designing Dataflow from SAP ECC 6.0 to SAP HANA Database
• Worked on all kinds of Join Types in SAP HANA
• Worked on Composite Providers, Transient Providers and Analytical Index
• Worked with partner vendors and develop technical peer relationships
• SAP HANA security with user/role/privilege/profile management, user authentication/SSO and authorization
• Experience in handling integration between multiple systems for reporting - SAP ECC, SAP Business Warehouse, and Business Objects integration
• Worked on converting the HANA information model to BW mode
• Imported BW models as information models in HANA system for the existing Info Cubes in BW

Environment: SAP HANA 1.0, SAP NW BI 7.x, BEx Query Designer, BEx Web Application Designer, BEx Analyzer SQL Server 2013

Confidential - East Hanover, NJ

SAP BW/BI Consultant

Responsibilities:

• Worked on SD, MM, FI and COPA Data Sources.
• Worked on data warehouse workbench for defining Info Objects, Info Cubes, Multi Providers, Aggregates, DSOs, Info Packages, DTP and Transformations
• Worked on LO Extractors to extract the data from R/3 to BW using Initialization, delta and Repairfull methods.\
• Involved in Installation of the Business Content objects
• Implemented the complete dataflow for the data source 0FI AR 4
• Extraction & Customization of data for different Staging scenarios using the COPA datasource including Data Loading Methods Init and Delta requests
• Involved in designing the Process Chains to extract the data for the designed dataflow
• Worked on BEx using Filters, Free Characteristics, Restricted Key Figure, Calculated Key Figures, Variables, Exceptions and Conditions
• Involved in Upgrade Post activities like Rescheduling Process Chains, Activation of Inactive Objects through Programs in Production System
• Worked on Material Management extractors 2LIS 03 BF and 2LIS 03 UM
• Used WDSO to implement the staging layer before transferring the data to Reporting Layer
• Involved in Various performance improvement activities like Building Aggregates to improve the query performance
• Involved in Dataload performance by performing the deletion of Indexes and providing the required restrictions in the Routines by restricting the data for the respective data packages
• Involved in database optimization by Periodical deletion of data from change log and PSA tables
• Validated the correct loading of the necessary data from the connected operational systems in time
• Monitoring system size and taking proper action by deletion of PSA or addition of space
• Created reports using the offset concept to display the data for multiple periods for Comparisonof the data
• Involved in Creation of the Text Variables using the processing type Replacement path
• Involved in Customer Discussions to understand Business the requirements.
• Involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains
• Monitoring periodic data loads from R/3, flat file to data targets using RSPC, RSMO, and SM37
• Involved on weekend activities like de-scheduling and rescheduling process chains based on the Business needs
• Handled the tickets of different severities by following standard operating procedures and never missed the service level agreement
• Solving the tickets raised by the user within the SLA Periods

Environment: SAP HANA 1.0, SAP NW BI 7.x, SAP BO 4.0, BEx Query Designer, BEx WAD, BEx Analyzer

Confidential - Chicago, IL

SAP BW/BI Consultant

Responsibilities:

• Involved in creation of Info Areas, Info Objects, Info Cubes, and DSO’s, and created required Transformations and DTP to load data into Data Targets.
• Uploaded Master Data and Transaction Data from Different Source systems.
• Designing and mapping source and target structures to load transactional data and master data.
• Activated and Installed relevant Business Content Info Objects.
• Enhanced the business content extractors 2LIS 11 VAHDR, 2LIS 11 VAITM and 2LIS 11 VASCL as per business requirement
• Worked on standard business content info cubes 0SD C01 (Customer) and 0SD C03 (Sales Overview)
• Involved in Data Modeling and Data Staging.
• Maintained routines for required objects.
• Developed Generic extractors to extract R/3 data.
• Involved in migration of data from BW 3.5 system to BI 7.0 system.
• Involved in transporting the cubes, Transformations and Multi Providers from Development to Quality system.
• Involved in preparation and review of Unit Test Plans & Documentation.
• Involved in Unit and Acceptance Testing and delivered all the objects within time with highest quality.
• Designed and developed queries in Query Designer to generate reports in BEx Analyzer.
• Created Exceptions, Conditions and Variables, Restricted Key-figures, Calculated Key-figures, New Selection and Formulae
• Worked on performance tuning of queries by, compression and indexing of info cubes.
• Created Process chains for Master data and transaction data loads.

Environment: SAP HANA 1.0, SAP NW BI 7.x, SAP NW BW 3.x, SAP BO 4.0, BEx Query Designer, BEx WAD, BEx Analyzer