SUMMARY:

• Expertise as a Senior Technical Lead consultant with around 12 years of experience in IT projects, Developing and deploying SAP enterprise application solutions and Implementing latest solutions in SAP Business Analytics.
• I have worked on 15 projects which most of the projects are end to end global SAP implementations.
• Sound experience with proven record in Leading teams and providing technical solutions to customers out of which 75% of implementation experience comes from Finance, Manufacturing, Retail industries, Insurance and SAP Internal IT and HR.
• Worked on multiple Tailored POC’s in different SAP Technologies for customers spanning across Oil and Gas, Retail industries, HR and finance
• Experienced in Oil & Gas, Distribution, Manufacturing & Confidential Industries and Its Integration with SAP ECC, SAP BW and external systems.
• Expertise in designing/creating of process chains, Info objects, DTP/Info sources, Transformation/ Transfer structures, Communication structures, Info providers (Standard and Custom Info Cubes, Data Store Object/ ODS, Multi - providers.
• Worked on Multiple Migrations from BW 7.0 to BW 7.3 & from BW 7.3 to SAP BW 7.4.
• Extensively worked in SAP BW modelling with respect to SAP HANA using Composite providers, Advance DSO by using HANA Studio.
• Strong experience in Data Warehousing, Business Intelligence Concepts in Implementations, migration activities Integration & upgrade projects.
• Responsible for Development and delivery of SAP BI Solutions in SAP HANA, SAP BW SAP BPC and BO. Developing Architecture and Design flow, writing technical, functional Documents.
• Supported all phases of a project life cycle including analysis, design, development, testing, deployment of solutions, postproduction support/maintenance and Cutover activities
• Pilot Test, data validation and Post-go live end-user and User documentation.
• Involved in support projects, resolving issues related to User queries, Bug fixes, Change Requests according to SLA.
• Responsible for completion of all deliverables resulting high quality and requirements gathering, along with configuration, and overall implementation of the solution.
• Recommend solutions to leadership, project teams, and other stakeholders adapting style to both technical and non-technical audiences. Collaborate with other architects to ensure continuity of solutions.
• Communicate effectively with Customers, Business Users, Team Members, Senior management, all other IT Teams and functions to achieve and align with the project.
• Extensive Experience on SAP BI 7.0, SAP 7.3, SAP BI 7.4, SAP 7.5, Embedded BPC,BPC10.1 SAP HANA, Side Car HANA, S/4 HANA, Embedded BW, SAP Native HANA, LUMIRA, SAP SLT, HANA LIVE, HANA Studio, SAP Bex Query Designer, Analysis for Office (AO) to develop and Implementation the project plans and determine how to leverage technology to create solutions that satisfy the business requirements.

SKILL:

BW Modeling: Composite providers, Advanced DSO’s, Embedded BW in 7.5, ABAP transport workbench, RKF’s, CKF’s, Cubes, DSO’s, Multi providers, Transformations, DTP, Master Data, Process chains, Hierarchies, APD, Analysis for Office (AO)

BPC Objects: Create Aggregates, Planning Functions, Planning Sequences Filters and Variables. Models, Packages.,SAP Business Explorer, SAP Query Designer. AO Reports and workbooks.

SAP HANA Modeling: Calculation Views, Analytical Views, Attribute Views and Scripted Views. SLT & SDA connectivity Joins, Union, Input parameters. Create Users, Roles, Analytical privileges, Grant Roles, Stored Procedures, Flow Graphs in Web ID. HANA 2.0.GIT HUB, Containers.

SAP HANA: Native HANA, BW on HANA, HANA Side Car scenario.

SAP HANA Performance Tuning Techniques: Star Join concepts and Snapshot on the Dataset Implementing filter conditions materializing the views. SLT Replication.

Reporting Tools: Query Designer, BEx Analyzer, WAD web application designer, Business objects Analysis for Office (AO), Explorer, LUMIRA, Design Studio, SBEE (Smart Business Executive Edition), WebI, Tableau.UI5

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Providing End-to-end solution for new Business line in Exxon
• Expertise in developing HANA Data Models including Developed HANA Views to extract Master data and Transaction data for BPC modelling
• Provide Detailed Design Document to Client on the Development objects and data flow.
• Expert level experience in modeling graphical calculation views, scripted calculation views.
• Extensively worked on SAP HANA Modeler (HANA Design studio), Designing Schemas, and Creating Packages, Calculation view, Stored Procedures, and a model consisting of replicated SAP tables.
• Developed complex SAP HANA Models Including Time Dependent Functionality and Flow Graphs
• Created SAP HANA Procedures to execute Flow Graphs.
• Developed Flow Graphs and loaded data in to Materialized Tables.
• Very Familiar with Finance data running in to Consolidation models and Management Model.
• Developed and Executed financial Reports.

Confidential, Cypress, Texas

Responsibilities:

• As a green field Implementation of this project, Developed every single object right from Info Objects, ADSO’s Composite providers, Planning objects, Planning sequence planning Filters, Aggregates, and the data models along with Bex reports.
• Expertise in handling expectations in HANA SQL Scripting.
• Developing & Supporting the Consolidations System.
• Document the Consolidations process and BPC workflows.
• Verify Business Rules and developed planning function for Inter Company Eliminations and Consolidations.
• Always Ensure and maintain account types for GL Accounts to avoid data discrepancies in Consolidation Model
• Created process chains to load the BPC data based on the Company code and Fisc Period.
• Created Bex Queries in SAP HANA Studio, and executed the report packages in AO
• To Engage with customer and involve in Design Discussions to Integrate Work Day to SAP solution
• Developed GL EPM Reports and Packages, Execute the packages to Validate the data.
• Developed HR Data flow and Designed as per business needs and created Reports on Employee Data.
• Created master data objects for WBS Element and Developed data flow for Project Systems
• Developed BW objects for Actuals and commitments in Project systems, and developed reports in Analysis for office (AO)
• Executed DMP to push data in to Consolidation model and management model.
• Tested the GL data in EPM in financial package in Analysis for office (AO)
• Resolved Complex Account Master data issues that run into Data mismatch and Split between Account Types. worked with HR and Finance team to Smoothly Integrate the Functionality between Work day and SAP BPC Data Flows.
• Played a key role in the Design, Customization, Development of the solution.
• Connected with Informatica team to push down the transformation logic and account lookup logic between Work Day &SAP
• Involved and helped with the mapping exercise with Chart of Accounts for Confidential Between work day accounts and Confidential SAP BPC Accounts
• Optimized Data elements as a part of design optimization and provided optimized and Improved Solution.
• Delivered solution from Ideation to Execution Successfully with high quality and at most user satisfaction.

Confidential

Responsibilities:

• Designed and developed SAP BPC Objects in the areas of Finance.
• Developed Composite providers and ADSO’s
• Tested the finance data to make sure its balanced to zero.
• Supported month end loads and ensure smooth month end closure
• Responsible for master data changes and addition of new accounts
• Developed HANA View’s on top of CDS Views to load data in to ADSO’s
• Developed Data models on SAP HANA Calculation Views, planning functions, planning sequence.
• Expertise in front-end Query Components such as Calculated key figures, Restricted key figures, Structures, Variables, Conditions, Exceptions and Workbooks.
• Extensive worked on Advanced DSOs, planning DSO's Composite Providers, Generated Calculation Views from SAP BW.
• Created Aggregates and Planning objects and Involved in designing of planning applications to meeting business needs in HR, Capex, Sales & operational planning and Buying income planning model.
• Working on planning function, planning sequence to filled major in business functional likes reclass, sales allocation, margin adjustment & HR pay calculation.
• Handled Selective data deletions and reloads of data based on the Version. worked with Finance Tables and Business Planning Tables ACDOCA for Lumira Dash Boards
• Created SDA Tables for GL extraction from SAP S4 System
• Created Planning Functions, Created Planning Models for SAP BPC
• Build data models in SAP BW platform using DSOs, Info Cubes and Multi Providers.
• Develop Reports as per Customer Specifications using Business Explorer.
• Develop test Scripts. Conduct unit, integration, regression and functional testing.
• Go live support. Documentation for the developed solutions.
• Analyzing the requirements and design viable data model solutions.
• Participate in business and project meetings and project blue-printing.
• Update Project Management on the project status by tracking deliverables.
• Track issues and risks, communicate status and escalate concerns to project management.

Confidential, Piscataway New Jersey

Sr. SAP HANA and Tableau Consultant

Technologies: SAP BW 7.4, SAP BW 7.5 SAP BW on HANA, SAP Analysis for Office,SAP Side Car HANA, SAP SLT, Tableau 10.1.3

Responsibilities:

• To Engage with customer and Develop the HANA Models aligning to the BI Reporting solution.
• Responsible as an SME to Develop & Deliver Native HANA Models and Tableau Dashboards.
• Responsible to connect with other business teams to understand the data flow.
• Responsible to and design and develop architecture for Tableau dashboarding solution.
• Created SAP SLT Connectivity to access Data from other Data sources.
• Configured SAP SDA to access tables from other systems in SAP HANA.
• Created HANA Views by importing BW objects and developed calculation views in HANA studio
• Developed analytical privileges on SAP HANA views for data security.
• Interacted with Business users on the Functionality Tableau Dashboards and UI of the Tableau Dashboards.
• Arrived at different insights with business data on which added more flexibility to users
• Worked on reconciliation of data and validation of KPI s Incorporating SAP Bex Query logic in SAP HANA worked with Finance Tables and Business Planning Tables and the sales information.
• Validation of reports in in Analysis for office
• Played a key role in the Design, Customization, Development of the solution.
• Delivered effective dashboard designs and impressive Dashboard performance using SAP HANA and Tableau.

Confidential

Sr. SAP HANA Lead

Technologies: SAP BW 7.5, S/4 HANA, HANA LIVE, Lumira, Analysis for Office, SDA, Embedded BW, BPC with HANA.

Responsibilities:

• To Engage with customer and Develop the unified One SAP solution in the BI Space
• Responsible as an SME (Subject matter Expert) to Deliver and lead a team of 4 in the project
• Responsible to connect with cross functional teams to plan the delivery activities and communicate to team.
• Installation of BI content in S/4 HANA and Executing HANA Live views in Analysis for office (AO) across all process areas
• Designed and developed Process Design Documents (PDD) in the areas of OTC. worked with Finance Tables and Business Planning Tables ACDOCA for Lumira Dash Boards
• Converted the Same Reports to AO.
• Played a key role in the Design, Customization, Development of the solution.
• Involved and helped with the mapping exercise with BW, BI Content and HANA optimized Data elements in S/4 HANA to analyze the KPIs in order to recommend new solutions.
• Created Embedded BW Objects for real-time reporting solution.
• Created calculation views on S/4 HANA Tables and CDS Views
• Implemented and Developed AR, shelf life, and Broker Determination Reports(Analysis for office)
• Optimization by defining Business rules and other specifications to meet business requirements.
• Worked on Data Conversion efforts specific to shelf life from both the systems east/west and central.
• Worked on in the initial Blue Printing phase and engaged in workshops with the business to understand the ’AS- IS’ and ‘TO- BE’ requirements and developed the GAP analysis and estimates.
• Delivering projects from ideation to implementation and support.
• User acceptance testing UAT participation and led it to closure

Confidential, San Jose, CA

Sr. SAP BW on HANA Architect

Technologies: SAP BW/HANA, R, Predictive analytics

Responsibilities:

• Responsible to deliver the solution to Confidential and lead the development team
• Responsible as a single point of contact and lead for delivery activities.
• Developed and created technical architecture and worked on technical objects to deliver.
• Primary responsibility was to understand SLT Configuration and Technical Landscape.
• Followed the Technical Guide provided by SAP to achieve Smooth Migration to SAP SDI
• Closely worked with SAP Security and lead my development/Admin Colleagues to create and Setup Respective Roles, Profiles and users.
• Created Schemas as a part of the migration Process.Created the blueprint of the solution
• Listed and maintained activities to process the migration
• Connected the views to the new Data source based on SAP SDI.
• Created Flow graphs on HANA SDQ. performed UAT User Acceptance Test and Regression tests on the solution

Confidential, Newtown Square, PA

SAP HANA and SAP BI Lead

Technologies SAP BW on HANA, HANA Side Car, Native HANA, HANA Studio 95 and SAP CRM, SBEE (Smart Business Executive Edition. Analysis for office.

Responsibilities:

• Leading and Aligning with the functional teams to understand the requirements
• Lead a team of 5 as SME for this project along with technical delivery activities
• Data Provisioning from ECC via SLT for Developing CRM Data
• Cleaning up data and maintaining Data consistency and developing Lumira Dashboards.
• Filtering based on defined criteria, remove or add new calculated columns or changing column data type In SLT.
• Initial loading of data and Following up with other SLT activities
• Monitoring the SLT Replication Status in Replication Monitor
• Validating SLT Replicated Data with the Source Systems.
• Maintaining Settings in SLT for individual tables as per requirement
• Followed best practices on Data Provisioning with SLT.
• Created HANA artifacts such as Attribute views, Analytic views and Calculation views as per the Business requirements/KPI defined.
• Objective is to reconcile the business master data and the created output from the HANA models and connecting to Tableau Desktop
• Created Analytical Privileges and procedures to achieve security concept for the users
• Created roles for the users and enabled them to the respective views
• Transport of HANA artifacts across landscape using Delivery Units.
• Followed HANA best practices.
• Unit Test & Integration test of the deliverables & hand it over for UAT
• Bug fixing and post go live Support. Actively participated on UAT Activities
• Developed Lumira Dashboards based on HANA views
• Worked on Odata services for UI5 Development for HANA XS pulling data from HANA views
• Developed UI5 screens for mobile dashboards with HANA XS worked on SAP HANA XS connectivity for UI5 solution

Confidential, Newtown Square PA

SAP HANA and SAP BI Lead

Technologies SAP BW on HANA, HANA Side Car, Native HANA,HANA Live, HANA Studio 95 and SAP CRM, SBEE (Smart Business Executive Edition.

Responsibilities:

• Responsible as an SME (Subject matter Expert) to Deliver and lead a team of 4 in the project
• Responsible to connect with cross functional teams to plan the delivery activities and communicate to team.
• Created HANA artifacts such as Attribute views, Analytic views and Calculation views as per the Business requirements/KPI defined.
• Objective is to replicate all the BEX Query's KPI logic into HANA layer importing the BW info Providers.
• Transport of HANA artifacts across landscape using Delivery Units.
• Built various stories using SAP’s internal reporting tool SBEE (Smart Business Executive Edition) consuming.
• Followed HANA best practices.
• Unit Test & Integration test of the deliverables & hand it over to UAT.
• Bug fixing UAT and post go live Support. Developed UI5 screens for mobile dashboards with HANA XS worked on SAP HANA XS connectivity for UI5 solution

Confidential, Newtown Square PA

SAP HANA and SAP BI Lead

Technologies SAP BW on HANA, HANA Side Car, HANA Studio 95 and SAP CRM, SBEE (Smart Business Executive Edition.

Responsibilities:

• As a Lead my primary responsibility was to make a Successful Data provisioning connection with SLT and develop and design HANA Models for Resource management project & develop reports.
• Involved in design work shop & understand the HANA architecture & requirement scope for RM project.
• Align with Basis team to Set up SLT Server and establish a successful connection.
• Align with the HR Functional Team to understand the Tables to be replicated in SAP landscape with SLT.
• Replicated individual tables in SLT and Monitored the Replication process.
• Checking the Status in SAP front End and checking table Data in HANA studio. updating current activity SLT status on tables to dependent teams
• Identifying the required fields from the existing BEx reports in BWand finding the source tables and fields of the same from source system with the platform team to replicate the tables from source systems to HANA system.
• Coordinating with the platform team to replicate the tables from source systems to HANA system.
• Creation of Attribute Views, Calculation Views and Analytical Views in HANA.
• Mapping the text tables with the actual keys in the source to replicate the master data similar to BW.
• Complete reconciliation of HANA DB with RM Application in to BW System.
• Creation of virtual providers, enabling the Info objects from Hana Studio to BW virtual provider.
• Creation multi providers and accessing the data from virtual providers for reports.
• Building BEx reports on top of the data targets. Implementing Business Logics in BEx for HR analytical Reports.
• Analyzing the data on reports and testing the same in comparison with the existing application.
• Involved in testing & bug fixing on tickets raised by users in UAT.

Confidential, Newtown Square PA

SAP BI Sr Developer

Technologies SAP BI 7.3 BEx, Query Designer. SAP LUMIRA

Responsibilities:

• Primary responsibility was to understand the Business Requirements and perform Technical changes.
• Developed Tech Specs and coordinated different tasks with the extended Team SAP IT TCS Colleagues.
• Creation and review of new BI Modeling Objects and BEx Queries based on Technical Specifications.
• Involved in modifications of WAD templates for the complete project as per business requirement.
• Created Variables, Formulas, and Alerts as per business requirement.
• Creation and Scheduling of data loads using Process Chains.
• Creation of Test Description Documents and uploading the same in SAP project space.
• Documented Reporting Level Architecture along with the load Process of the process chains.
• Developing BEX Reports and LUMIRA Dashboards.

Confidential, Newtown Square PA

SAP BI Sr. Developer

Technologies SAP BI 7.3 BEx Reporting, WAD Reporting.

Responsibilities:

• Single point of contact for Utilization Projects & requirement changes.
• Worked in SAP AG for Technical Design discussions in Project Initiation Phase.
• Developed Technical Specs and co-ordinate tasks with the team.
• Involved in Requirement gathering for Utilization and P&L Projects
• Creation of Test Description Documents and uploading the same in SAP Solution Manager.
• Successful co-ordination &completion of Integration Testing, UAT & Regression Testing.
• Documented Reporting Level Architecture along with the load Process of the process chains.
• Responsible for Successful Handover and Post production support.
• Support the team with complete documentation & process know how.