PROFESSIONAL SUMMARY:

• Responsible for the Technical Architect & Design 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
• 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.
• Consume CDS d Confidential 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.
• Developed complex IDT, WEBI Reports, Dashboards, Confidential 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 d Confidential provisioning using SAP LT replication server (SLT) and d Confidential 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 D Confidential Services
• Expertise in creating, organizing, publishing and scheduling reports using Confidential

PROFESSIONAL EXPERIENCE:

Confidential

HANA Technical Architect

Environment: HANA 2.0,SAP HANA, SLT, HANA D Confidential base, Business Objects, D Confidential Services .

Responsibilities:

• Performed impact analysis on the legacy reporting systems to know the usage of the existing d Confidential .
• Designed and Developed the Hybrid HANA\BW Data Models to extract Stable and Current d Confidential sets from Confidential system to support UKIE, Singapore and MENA Expense Reporting
• Created 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 d Confidential into d Confidential base intensively.
• Develop SAP BW On HANA Advanced DSOs (ADSO), Open ODS Views from, Composite Providers, Open Hub Destinations
• Develop Custom Reports in BEX Query Designer and SAP Business Objects Web Intelligence
• Involved in Build and Test Plan and Test cases by running multiple busiess scenarios.
• Analysis, design and implementation of reports SAP (Tableau, BEX, BO Lumira) for the deployment of strategies in the Business Analysis.
• 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 D Confidential Access), SAP HANA Live (Analytics)
• Developed Tableau visualizations and dashboards using HANA Views
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Confidential

BW HANA Technical Architect

Environment: HANA, SAP HANA,S/4, SLT, HANA D Confidential base, HANA Live, Business Objects, D Confidential Services .

Responsibilities:

• Developed reporting solution to support auditing, Analysis and Tax Compliance for Confidential
• To perform Ad hoc transactional d Confidential analysis in real/near real time to support the day to day operations as well support the closing activities
• Key player in the project related to SAP HANA Models Design across functional tracks like Demand planning, Sales Planning Sales Forecasting Reports, SD, Inventory Reports, Invoice Detail Report, Manufacturing Productivity Reports, Analysis implementation of HANA live reports.
• Developed SAP BO reporting solution in SAP FI, SAP CO
• Utilized standard basic SAP S/4HANA CDS views consisting of master d Confidential 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 d Confidential base functions where CDS has limitations in ansi sql
• Analysis, design and implementation of reports SAP (Tableau, BEX, BO Lumira) for the deployment of strategies in the Business Analysis.
• Worked with SAP IDT & BO WEBI Reports source as a HANA Calculation Views, SAP BO WEBI Reports were scheduled on weekly basis, the output was sent in excel format to customer mail box directly
• SAP HANA D Confidential Provisioning using SAP LT Replication Server (SLT), SAP HANA Troubleshooting and Performance Analysis
• 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.
• Define and maintain design guidelines related to HANA and BI systems
• Imported the Hana Views and created a model in Power Bi.
• Created MTD, QTD and YoY Dashboards.
• Validated the reports and Dashboards.

Confidential

BW HANA Technical Architect

Environment: HANA 1.0 SP12,SAP HANA, SLT, HANA D Confidential base, Business Objects .

Responsibilities:

• Designed and Developed the Control Reports to Reconcille d Confidential between multiple systems inorder to track the Expense Information in a Given Batch .
• Worked extensively in Virtual D Confidential Model (VDM) development in Core Data Services (CDS) in S/4HANA.
• Good knowledge Embedded Analytics in S/4 HANA & Using Emebeed CDS views .
• Develop Custom Reports in BEX Query Designer and SAP Business Objects’ Web Intelligence, BO lumira. using PL/SQL the Function Editor coding to push d Confidential into d Confidential 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,
• Developed ABAP FM to Extract d Confidential in BW, D Confidential source enhancemet, User exits.
• Worked extensively in PTP And OTC area to Create Planning Reports such as OEM Planning, Supplier Planner and Critical .
• Develop Custom Reports in BEX Query Designer and SAP Business Objects’ Web Intelligence, BO lumira.
• 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 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 D Confidential Access), SAP HANA Live (Analytics)

SAP HANA Technical Architect

Environment: HANA 1.0 SP12,SAP HANA, SLT, HANA D Confidential base, Business Objects .

Responsibilities:

• Created BW/HANA based complex interfaces to support Expense Appraisal Tool.
• Developed Macro Based Custom Extractors to Retrive d Confidential from TE Clusters in ECC.
• Created D Confidential flows using BW functionality to store the Expense Cluster Information into multiple ADSO,Composite Providers.
• Created Hybrid D Confidential Models using calculation views to access expense d Confidential from the Cluster d Confidential from ECC.
• Created D Confidential flows to the external systems to implement Appraisal Process in .Netbase systems using OHD
• Designed MIS Applications to FTP the files from SAP to MS EDW.
• Extensively worked on SAP HANA Modeling - calculation views, analytical Privileges, Column store views and performed SQL, Creating Function using PL/SQL the Function Editor coding to push d Confidential into d Confidential base intensively
• Developed SAP reporting solution to reconcile the d Confidential between the EDW and EAT systems.

Confidential

SAP BW/HANA Technical lead

Environment: SAP BW7.5, SAP BEX, HANA studio PL/SQL, Business Objects front-end

Responsibilities:

• Created BW/HANA based complex interfaces to support Confidential Specific reporting systems (EAT, MyEngagements, FR, COE and Marketing Reports).
• Involved in full cycle of implementation of SAP BW on HANA, SAP HANA on BO which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support
• Translate the Business KPIs into HANA & Define the Reporting Layouts Using SAP BO WEBI reports
• Experience with HANA Live and Virtual D Confidential Mart (VDM). Building custom applications using VDMs
• Involved in creating custom schema, non-ECC tables and SQL queries in SAP HANA
• Involved in D Confidential 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 d Confidential bases like Terad Confidential Hadoop with HANA, Oracle and SQL Server, Created HANA optimized d Confidential providers Info cubes and DSO created in SAP BW
• Analysis, design, and implementation of reports SAP (BEX, BO) for the deployment of strategies in the Business Analysis
• 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
• Involved on D Confidential Analysis, SQL, Hadoop integration with HANA.
• Developed custom DSO’s, InfoCubes and MultiProvider for BI and IP reports.
• Extensively worked on SAP HANA Modeling - calculation views, analytical Privileges, Column store views and performed SQL, Creating Function using PL/SQL the Function Editor coding to push d Confidential into d Confidential base intensively
• Involved d Confidential replication from SAP ECC to SAP HANA via SAP Landscape Transformation (SLT)
• Involved in SAP HANA Security including User Management, Roles, and Privilege
• Confidential Design - UDT, Web intelligence - Webi Information Design Tool - IDT, Crystal Reports, Confidential
• Involved in Information Design Tool Creation of D Confidential Foundation, Confidential for HANA reporting
• Broadcast d Confidential via SAP BW Open Hub APD Destinations like D Confidential 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

Confidential

SAP BW Consultant

Environment: SAP BW 7.0, CRM, SD, FI

Responsibilities:

• Designed the TDD for Modeling Specs, RDD for Report Technical Specs, Delivery Check list Document, Data flow diagram Document
• Tasks included analysis of d Confidential requirements and the translation of these requirements into a custom dimensional d Confidential models.
• Activated Business Content objects and designed, developed and modified Info Objects, Info Cubes, DSO Objects, Transformations and DTP’s
• Created a D Confidential flow for Infocubes and Data store objects to hold the Planning and actual data from CRM and ECC.
• Created Transformations and customized by adding routines and formula to derive the accounting fiscal period from Date and territory Explosion.
• Extracted d Confidential from CRM and ECC using standard extraction procedures for the Trade Promotions LE and for the Real Time Reporting LE
• Designed and developed BEx queries with customer exits (CMOD) variables to meet the advanced reporting requirements.
• Involved in checking Unit testing results and coordinating with the Functional consultants to fulfill the user requirements.
• Developed Reports to generate Actual/ Plan Funding and the Actual / Plan Spending report for the Trade Promotions.
• Involved in Transports and fixing the transport issues.
• Involved in giving to the end users on the reports.

Confidential

Technology Consultant

Environment: BI 7.0

Responsibilities:

• Involved in Requirement gathering and analysis
• Participated in discussions & meetings with TMS team to understand the D Confidential flow to be fed to BI system from ZOTM DB Connect
• Designed the Document Templates for Modeling Technical Specs, Report Technical Specs, Delivery Check list Document, D Confidential flow diagram Document
• Involved in checking Unit testing results and coordinating with the Functional consultants to fulfill the user requirements.
• Created an Infocube to Hold the Data of Deliveries and Shipments History Data
• Created the D Confidential flow from Data source through Standard DSO’s for Actual and History.
• Generated a D Confidential sources from the Infocube and DSO’s to load the D Confidential to OTM system for Actual Freight pay planning.
• Created Transformations and customized by adding routines and formula to derive the accounting fiscal period from Date.
• Extracted the Actual D Confidential from OTM System for Actual pay reporting and Accrual Reporting.
• Developed the Reports and web templates for freight pay reports and published Iveiw in the Portal.
• Identifying the fields and D Confidential Sources for BI reporting
• Enhanced D Confidential Sources which has eliminated most of the routines.
• Development of BI Objects - Info Objects, DSOs
• Verifying and validate the d Confidential with source system data
• Created Process chains for master d Confidential and Transaction data.
• Performed d Confidential loading and fixed various issues
• Creating and submitting the Ticket Status (Open/Close) report.
• Preparing Documentation for all the tickets that has been resolved during the week
• Handled the tickets of priority P1, P2 and P3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
• Coverage of Problem tickets according procedures in order to meet the SLA for production support.
• Involved in monitoring the process chains and working on change requests
• Involved in doing integration testing and maintaining the test Cases.
• Worked with BI Accelerator, involved in monitoring BIA activities.

SAP BI Lead Consultant

Confidential

Environment: SAP CRM, FI-GL, SD, FICO, PM SAP BW, BEX, ABAP/4, Flat Files, Oracle

Responsibilities:

• Designed the Document Templates for Modeling Technical Specs, Report Technical Specs, Delivery Check list Document, D Confidential flow diagram Document
• Involved in checking Unit testing results and coordinating with the Functional consultants to fulfill the user requirements.
• Created an Infocube to Hold the D Confidential of Deliveries and Shipments History Data
• Created Flat file D Confidential sources to Load D Confidential for Demand Planning and Supply Network Planning.
• Created the D Confidential flow from D Confidential source through Write Optimized DSO’s to Standard DSO’s for DP and SNP.
• Generated a D Confidential sources from the Infocube and DSO’s to load the D Confidential to APO system for Demand Planning and Supply Network Planning.
• Written Complex Routines to hold the latest version Data in the DSO’s from Flat files.
• Extracted the Planned Data from APO System for Demand Planning and Supply Network Planning.
• Developed the Reports for Demand Plan Vs Supply Plan, Sales Actual Vs Sales Plan and Supply Plan Vs Supply Actual.
• Involved in Analyzing the Performance of the queries and improving the query performance by analyzing the Cardinality of the Dimensions of the Info cube.

Confidential

SAP BW Consultant

Environment: SAP ERP 6.0, BI/BW, Business Objects 3.x, Datastage, HPQC, REMEDY, Flat Files

Responsibilities:

• Designed the Document Templates for Modeling Technical Specs, Report Technical Specs, Delivery Check list Document, D Confidential flow diagram Documents.
• Involved in BEx Query Design and formatting.
• Involved in Installing of Business content objects like Master d Confidential objects and different d Confidential targets.
• Setting transfer rules, writing transfer routines, writing start routine, and update routines.
• Created ODS structures, Info-Cubes, custom Queries, etc.
• Worked in creating Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx.
• Extensively used calculated and Restricted Key Figures, exceptions, Structures and conditions for the queries.
• Extensively worked on utilizing PSA for effective loads and Error Handling.
• Enhanced Business Content datansources according to the user requirement.
• Published the BEx queries in to Enterprise portals using iViews.
• Involved in transportation of objects to Development and Quality servers.
• Involved in the Integration testing in quality of Objects
• Involved in solving performance-related issues. Extensively worked in many Performance issue improvements in both loading and Execution activities.
• Involved in Transporting the BW objects from development server to Quality server for Regression testing and Unit testing.