SUMMARY

• Have 12+ years of experience in SAP HANA, S/4 HANA, SAP BW/HANA along with SAP HANA CDS Views and SAP HANA Scripting Views, SAP HANA SDA, SAP BO,, ABAP/4 programming as a Team lead.
• Worked with the global clients on complete implementation of S/4 HANA, SAP HANA, SAP native HANA modeling and other Data Warehousing Tools, SAP BW/4 HANA and SAP BW development, Go - Live support
• Responsible for the Technical Design S/4 HANA, SAP HANA, SAP BW, SAP BO project development lifecycle from project preparation, BBP (Business Blue Print), realization, final preparation, requirements gathering, functional technical design documents, development, unit testing, Integration testing, Use Acceptance Testing, Go-live and post Go-live support
• Key player in the project related to SAP (ETL, EDW, BEX, BO) across functional tracks like Demand planning, Sales Planning Sales Forecasting Reports, SD, Inventory Reports, Invoice Detail Report, Manufacturing Productivity Reports
• Worked extensively with BEx analyzer and Query designer, developed several queries of varying complexities, made use of functionalities; Navigation attributes, Hierarchies, Filters, Restricted key figures, Calculated key figures, Exceptions, Conditions, Variables and Structures. Organized the queries into various workbooks and views. Created Charts for the Bex Reports, Work books
• Analysis, design, and implementation of reports SAP Business Objects for the deployment of strategies in the Business Analysis, Contribute to designing, developing, implementing, and maintaining business intelligence (BI) applications
• Strong understanding of SAP Business Intelligence and SAP Data Warehousing concepts
• Develped and Design CDS Analytical Consumption views, Composite views and Basic views using Hana Developer Studio using ABAP Perspective.
• Good working knowledge of Associations and Annotations for Consumption view development and Reporting rompts Using Annotations Base CDS Views
• Consume CDS data model used by SAP S/4HANA can be considered a successor to SAP HANA Live Reports as CDS views as source provides front end reporting using BO WEBI .
• Key player in the project related to SAP HANA Design, SAP BO Reporting across functional tracks like SD, CRM, MM, PP, QM, SCM demand planning, Generic extraction, HCM, HR, FI-AP (Accounts Payable) FI-AR(Accounts Receivables), FI-GL, SAP GRC,SD Warranty & SD Unit Cost, Manufacturing Productivity, Inflation, Spend Analytics, Inventory 2.0. Plant Maintenance
• Developed complex IDT, WEBI Reports, Dashboards, Lumira visualizations Worked with SAP WEBI reports source as a SAP HANA Information Views, WEBI reports were scheduled on weekly basis, the output was sent in excel format to customer mail box directly
• Experience in SAP HANA data provisioning using SAP LT replication server (SLT) and data service, SDI.
• Design & creation of HANA attributes views, analytic views, calculation views, analytics privileges, attribute mapping, and calculated attributes, calculated measure, restricted measure, currency as unit of measure
• Defined solution roadmap for HANA, BW & BOBJ application integration into Grainger’s landscape
• Managed key SAP HANA, BW & Business Objects initiatives with an oversight responsibility to deliver projects on time
• Good knowledge on building HANA views, SLT, SDI/SDA and ETL process using Data Services
• Good knowledge and understanding of change management process using SAP Solution manager

TECHNICAL SKILLS

SAP ERP: ECC 6.0, 5.0, SAP 4.6B, 4.6C, 4.7

Modules: SAP BW 7.3 (BW-on-HANA),SAP BW 7.4, BW 3.x,BI 7.0, BI7.5, RPM, SD, MM, PP, PM, QM, SCM/SRM, CRM, HR, FI-CO, APO,VISTEX,PMR, JDA D&F

BI Tools: SAP Business Objects 4.1,4.0/XI 3.1, Design studio1.2/1.6,Tableau 10.1, Web Intelligence 4.1, Xtract Universe, SLT, Crystal Reports 2011, Universe Design 4.1, IDT 4.1, Explorer, Infoview, CMS, CMC, Live office, Import Wizard, Xcelsius 2008, Transport manager, Analysis for office, SAP LT, SDI/SDA,BODS, Analysis for Office, Analysis for OLAP 4.0,Lumira, Visual BI(1.5.5), Worksoft Certify, SAC, Power BI.

App. & Web Servers: IIS, Tomcat 3.x, SAP EP 5.0/6.0

Programming Languages: ABAP/4, C, C++, Java, VB.NET, XML, HTML/DHTML, ASP.NET

Operating Systems: Windows 2000/NT, UNIX, Linux, MVS/ESA, OS/2, Z/OS

Content Management Tools: Vignette, VSS, Documentum, SAP EP Portal, MS Sharepoint, Confluence

Databases: SAP HANA SP-9,DB2, IMS DB, SQL, TERADATA

Other Tools: Microsoft Office, HP ALM, Microsoft Visio, FTP, Control, Test-director,JIRA

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

SAP HANA Applications Lead

Responsibilities:

• Worked in Native HANA modelling, HANA 2.0, HANA Git Pane and XSA based development.
• Good awareness functional area SD/MM, SAP AP, AR.
• Provide SAP support including analysis, development, testing, tracking, and problem resolution.
• Research SAP HANA production problems and/or enhancement issues and make appropriate code changes to the system, Initiate action and evaluate issues to develop alternative solutions. Apply expert knowledge and experience to resolve problems.
• Experience with SAP HANA 2.0, Smart Data Integration (SDI), SDA, SAP SLT, HANA Security, XSA and Web IDE. HANA Native Storage Extension (NSE) Implementation .
• Ability to optimize the performance of enterprise business intelligence solutions by means redesigning or re-architecting SAP HANA modelling structures or data flows.
• Good knowledge on building HANA views, SDI/SDA and ETL process using SLT, Data Services
• Lead troubleshooting efforts on complex performance tuning problems in SAP HANA Modeling
• Communicate and articulate model designs to peers, customers and governance teams
• Develop and maintain detailed documentation that captures design strategy across data models.
• Extensively worked on SAP HANA Modeling - HANA Calculation views, SAP WEBI Reports
• Lead troubleshooting efforts on complex performance tuning problems in SAP HANA Modeling
• Communicate and articulate model designs to peers, customers and governance teams
• Develop and maintain detailed documentation that captures design strategy across data models.
• Extensively worked on SAP HANA Modeling - HANA Calculation views, SAP WEBI Report
• Extensively worked on S/4 HANA CDS Views, Enhanced the Existing S/4 Hana Simple Finance CDS Views, Accounts receivables,, accounts payable, sales overview reports
• Customized the existing CDS Views by adding new fields/ Joining multiple CDS Views building the Master Report.
• Good working knowledge of S/4 HANA Associations and Annotations for Consumption view development

Confidential, Bentonville, AR

BW4HANA Technical Consultant

Responsibilities:

• Develop SAP BW On HANA Advanced DSOs (ADSO), Open ODS Views, Composite Providers, Open Hub Destinations, End user Assistance and support on general issues
• Worked in B4HANA Migration Converted Multi Providers to Composite Providers using B4HANA tool SAP BW4 TRANSFER INPLACE
• Responsible for the in B4HANA Migration Technical Architect & Design B4HANA Objects, SAP HANA Studio, SAP B4HANA, SAP B4HANA project development lifecycle from project preparation, BBP (Business Blue Print), realization, final preparation, requirements gathering, functional technical design documents, development, unit testing, Integration testing, Use Acceptance Testing, Go-live and post Go-live support
• Worked in B4HANA Migration Converted SAPI data source to ODP enabled
• Worked in Created new composite providers for infosets and reports,
• Good functional knowledge on RTR, OTC,MM value streams S/4 HANA
• Worked on Enhancements/ rollout / Implementation in customer projects S/4 Hana
• Worked in B4HANA Migration Cube to ADSO conversions,
• Analyze, design, and create end-to-end Business Objects Data Integrator (BODS) mapping documents.
• Involved and Classical Hierarichal data source conversion
• Implemented New Inplace transfer tool post implementation of SAP OTESreleted source systems ECC and GRC, SCM Systems and BWHANA System
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool
• Created the ETL Jobs in BODS in a multi-developer environment maintaining versions in CR

Confidential

BW4HANA Technical Consultant

Responsibilities:

• Extensively worked on SAP HANA CDS Modeling - HANA Calculation views, HANA CDS Views.
• Extensively worked on S/4 HANA CDS Views, Enhanced the Existing S/4 Hana Simple Finance CDS Views, Accounts receivables,, accounts payable, sales overview reports
• Prepared the list of all CDS Views (1709, SP2, Relevant are 455 as per Fiori Query Browser) categorizing the business content by Application.
• Designed the Dynamic Reporting Facility for Business Users consuming CDS Views direct from “Analysis for Office” that really helps business users understanding and leveraging the existing data with out New development effort/budget.
• Key player in the project related to SAP (ETL, EDW, BEX, BO) across functional tracks like Demand planning, Sales Planning Sales Forecasting Reports, SD, Inventory Reports, Invoice Detail Report, Manufacturing Productivity Reports
• Analysis, design, and implementation of reports SAP (BEX, BO) for the deployment of strategies in the Business Analysis
• Customized the existing CDS Views by adding new fields/ Joining multiple CDS Views building the Master Report.
• Good working knowledge of S/4 HANA Associations and Annotations for Consumption view development
• Develop SAP BW On HANA Advanced DSOs (ADSO), Open ODS Views from, Composite Providers, Open Hub Destinations
• Worked extensively in Virtual Data Model (VDM) development in Core Data Services (CDS) in S/4HANA.
• Good knowledge Embedded Analytics in S/4 HANA & Using Emebeed CDS views .
• Worked extensively in PTP And OTC area to Create Planning Reports such as OEM Planning, Supplier Planner and Critical .
• Worked in SAP HANA Data Provisioning via SLT and BODS, SAP (Native) HANA modeling using Calculation View, and programming including SQL and SQL Script Views .
• Worked with Functional team and business to convert the requirements to Realtime S/4 HANA Reports
• Key player in the project related Development and Design SAP HANA information Views, CDS Views, SQL Scripted Views, HANA live reports using front end tools BO WEBI and Analysis for office excel.
• Involved in SAP HANA Security including User Management, Roles, and Privilege,
• SAP HANA Performance Optimization, Troubleshooting and Performance Analysis

Confidential

S/4 HANA Technical Consultant

Responsibilities:

• Extensively worked on SAP HANA Modeling - HANA Calculation views, HANA CDS Views, analytical Privileges, Column store views and performed SQL, Creating Function using PL/SQL the Function Editor coding to push data into data base intensively.
• Created custom CDS composite, basic and consumption views for real time reporting in s/4
• Utilized standard basic SAP S/4HANA CDS views consisting of master data for various consumption CDS query views, Maintained standard runtime hierarchies for profit center, cost center and financial statement versions,Created table functions in case of complex database functions where CDS has limitations in ansi sql
• Develop Custom Reports in BEX Query Designer and SAP Business Objects’ Web Intelligence
• Experienced in reporting with SAP modules: MM, SD, FI, QM, PP.
• Support activity such as Process chain monitoring, Performance tuning on data load jobs, Query performance optimization in BW,
• Extensively worked Bex Analyzer, Analysis Office, WEBI..
• Extensively worked on S/4 HANA CDS Views, Enhanced the Existing S/4 Hana Simple Finance CDS Views, Accounts receivables,, accounts payable, sales overview HANA live reports.
• Analysis, design and implementation of reports SAP (Tableau, BEX, BO Lumira) for the deployment of strategies in the Business Analysis.
• Involved in SAP HANA Security including User Management, Roles, and Privilege,
• SAP HANA Performance Optimization, Troubleshooting and Performance Analysis .
• Native Hana hands-on development experience: creating SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access), SAP HANA Live (Analytics)
• Developed Tableau visualizations and dashboards using HANA Views

Confidential

S/4 HANA Technical Consultant

Responsibilities:

• Involved in full life cycle of implementation of S/4 HANA Live which includes Analysis, requirements gathering, development, reporting, Go-live and Post Go-live support.
• Worked extensively in OTC PTP area to Create Planning Reports such as OEM Planning, Supplier Planner and Critical components .
• Interacted with Business in getting requirements in OTC(Order To Cash), PTP (Plan To Produce), STP (Source To Pay), LTT(Logistics To Transportation) translated to HANA live reports .
• Extensively worked on SAP BW and HANA Live for SAP TM (Transportation Management), SAP QM (Quality Management), LTT (Logistics To Transportation) and OTC BO Operational reports.
• Extensively worked on SAP HANA Modeling - HANA Calculation views, HANA CDS Views, analytical Privileges, Column store views and performed SQL, Creating Function using PL/SQL the Function Editor coding to push data into data base intensively.
• Designed, implemented and migrated complex Universes and Business Objects Reports and S/4Hana with Lumira, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
• Extensively worked on S/4 HANA CDS Views, Enhanced the Existing S/4 Hana Simple Finance CDS Views, Accounts receivables,, accounts payable, sales overview HANA live reports.
• Worked with business in Implementing Hana Live queries in OTC, RTR,
• Worked extensively in Virtual Data Model (VDM) development in Core Data Services (CDS) in S/4HANA.
• Good knowledge Embedded Analytics in S/4 HANA & Using Emebeed CDS views .
• Worked extensively in PTP And OTC area to Create Planning Reports such as OEM Planning, Supplier Planner and Critical .
• Develop SAP BW On HANA Advanced DSOs (ADSO), Open ODS Views, Composite Providers, Open Hub Destinations
• Worked with Functional team and business to convert the requirements to Realtime S/4 HANA Reports
• Key player in the project related Development and Design SAP HANA information Views, CDS Views, SQL Scripted Views, HANA live reports using front end tools BO WEBI and Analysis for office excel.
• Involved in SAP HANA Security including User Management, Roles, and Privilege,
• SAP HANA Performance Optimization, Troubleshooting and Performance Analysis.
• Native Hana hands-on development experience: creating SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access), SAP HANA Live (Analytics)

Confidential

SAP BW/BI/HANA Techinical Consultant

Responsibilities:

• Involved in full cycle of implementation of SAP BW on HANA, SAP HANA on BO, which includes Analysis, requirements gathering, development,reporting, Go-live and Post Go-live support
• SAP HANA Troubleshooting and Performance Analysis
• Lead the interaction between Infrastructure and BI development teams
• Define and maintain design guidelines related to HANA and BI systems
• Developed custom DSO’s, InfoCubes and MultiProvider for BI and IP reports.
• Extensively worked on SAP HANA Modeling - attribute views, analytic views, calculation views, analytical Privileges, Column store views and performed SQL, Creating Function using PL/SQL the Function Editor coding to push data into data base intensively
• Involved data replication from SAP ECC to SAP HANA via SAP Landscape Transformation (SLT)
• Involved in SAP HANA Security including User Management, Roles, and Privilege
• Universe Design - UDT, Web intelligence - Webi Information Design Tool - IDT, Crystal Reports, CMC
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting
• Broadcast data via SAP BW Open Hub APD Destinations like Data Warehouse, MDG, CRM, SD IP: Vistex Sales teams
• Report development on SAP BO 4.0 WBBI & IDT tools, Sales Planning, Inventory reports by the agreed improvements
• Experience in designing and developing the Universe & IDT and updating the existing Universes to CMC, Scheduling the processes and administering the BO activities. Scheduled the reports in info view
• Translate the Business KPIs into HANA & Define the Reporting Layouts Using SAP BO WEBI reports
• Experience with HANA Live and Virtual Data Mart (VDM). Building custom applications using VDMs
• Involved in creating custom schema, non-ECC tables and SQL queries in SAP HANA
• Involved in Data Provisioning from SAP ECC, SAP BW and non-SAP sources via SLT, BODS and DXC, HANA security including User Management, Roles and Analytic Privileges
• Experienced with different Relational databases like Teradata Hadoop with HANA, Oracle and SQL Server, Created HANA optimized data providers Info cubes and DSO created in SAP BW
• Enhance DPA reports by the agreed improvements
• Create the Business Blue-Print document
• Helping to the R&A team in critical issues in BEX reporting
• Key player in the project related to SAP (ETL, EDW, BEX, BO) across functional tracks like Demand planning, Sales Planning Sales Forecasting Reports, SD, Inventory Reports, Invoice Detail Report, Manufacturing Productivity Reports
• Analysis, design, and implementation of reports SAP (BEX, BO) for the deployment of strategies in the Business Analysis
• Created many complex and customized reports for specific business requirements and also involved in new features of SAP BI security like Analysis authorization
• Maintained Process Chains to automate and schedule the data loads
• Major Responsibilities include Data loading Monitoring /Issue resolution
• Key player in the project related to SAP (ETL, EDW, and BEX) across functional tracks SD, FI, CRM, and FI-GL
• Involved SAP CRM BW Production support with BW Go-Live support activates (Global Orders, Global revenue, Global Cost, Open Service order)
• Reconciliation of data with interfaces., Analysis of Dockets and Solving
• Month end and Year End activities, Compression, PSA deletion and maintaining aggregates as a part of performance tuning, Maintained Process Chains to automate and schedule the data loads
• Attending client meetings and taking care of these requirements
• Handling any new CR’s