PROFESSIONAL SUMMARY:

• Over 13 years of SAP Experience in SAP Business Intelligence tools of SAP BW on HANA, SAP Native HANA,SAP BW, BO and SQL.
• Implemented Three full life cycle end to end implementations solution delivery for different modules of Logistics (SD, PM, PP, MM, QM, WM) Financial (FI - CO, COPA), HCM, SCM & Retail in SAP BI, involved in all phases like Requirements Gathering, Gap analysis, Blue-printing, design Functional and Technical specification, development, performance tuning, integration and UAT, documentation, code and peer code reviews, training and trouble-shooting.
• Extensively involved in Technical development, Transition management, solution consultant, and Leadership management/Offshore Coordinator.
• Have been working as a Solution Design Consultant in BW on HANA since BW 7.5 and HANA 1.0 SP5 & lately with SP12 version.
• Extensive Knowledge on BW4/HANA using ECC.
• Experienced in HANA Application Life Cycle Management using CTS, Delivery unit
• Worked on BW on HANA non cumulative cubes to extract the inventory data.
• Involved as a Architect role in previous assignment to propose the End-to-End solution using BW on HANA for the Plant Maintenance business to get the Equipment Expenditure Replacement Cost at Functional location.
• Worked on FI Accounting and Asset Accounting - Profit/Loss accounting
• Knowledge on S4/HANA creating views using CDS
• Working on S/4 HANA POC for the client Spirit Aero Systems using CDS
• Extensively involved in PM- Equipment Expenditure Replacement cost using 0Equipment, 0Plant,0Functional Location and 0Notifications master data
• Proposed a complex solution for towards the Service line Deliveries Tolerance report by using multiple
• Experience in optimizing, performance tuning Native HANA, BW on HANA based on SAPs proven best practices and standard design principles
• Involved as a Architect role in previous assignment to propose the End-to-End implementation projects solution for various functional areas.
• Designing HANA Modeling Information views using modeling techniques.
• Certified in HANA - HA100/300 & 200 (Application & Tech Associate certification)
• Experienced in working with stake holders and cross functional teams to assist with gathering and evaluating detailed project requirements
• Expertise in BW Powered by HANA, HANA-Optimized Cubes, Advanced DSOs (ADSO) and Composite providers.
• Worked on BODS (Data Services) to extract the data from Non Legacy Systems like Oracle server in to HANA system using Data harmonization
• Experience in Configuring and Consuming SAPBW objects and HANA models/views clients such as BO (Dashboards & WEBI), Tableau for Visualization &Predictive Analysis and AO- Analysis Office.
• Good understanding on Star Schema and Extended Star Schema.
• Worked on BO(UDT, IDT, and WEBI) more on visualization .
• HANA admin activities: User / role management, HANA security, expensive statement analysis, performance/memory issues.
• Participated in design reviews, spec reviews, code reviews, test plan reviews
• Worked on Standard extractors in 0FI GL 4, 0FI AR 4, 0FI GL AP, 0FI GL 14 of general Ledgers and COPA Extraction for Profitability Analysis.
• Created Open Hub interface to transfer BW to BPC team as Flat Files to load to an external system
• Participated in design reviews, spec reviews, code reviews, test plan reviews
• Translate complex business requirements into technical design solutions as per Data warehousing standards to meet user expectations.
• Experience and knowledge of the various methods to access and extract master data and fact data (including consolidated data) from DWH to BPC (Business Planning and Consolidation)
• SAP Tableau - Deploy the standard graphing techniques of visualization in SAP Lumira for bar charts, line charts, histograms, pie charts and scatter plots
• Solution HANA optimization and performance tuning expertise
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS:

Operating System: Windows NT 4.0, and Windows 2000 to XP.

ERP: SAP R/3 (Version 4.7E, Ecc5.0 and ECC6.0)

Database: SAP Hana (Certified), Oracle 8i. MS SQL, MS-Access,

Business Intelligence Tools: SAP BW3.5, Bi 7.0/ 7.3/7.4,Bex Analyzer & Designer BO 4.0/4.1, and Lumira

Other(Ticketing Tool): Solution Manager, BMC Remedy

FUNCTIONAL  MANAGEMENT AND LEADERSHIP SKILLS:

• Involved in transition management and team management as lead consultant.
• Has worked in very large transformational projects in a multi-culture environment.
• Involved in POC, Project Preparation Plan, Workshops & Estimations Product orientations and Client Demos.

PROFESSIONAL EXPERIENCE:

Confidential, SFO, CA

SAP BW on HANA/BO Consultant

Environment: . SAPBW 7.5 and HANA 1.0.

Responsibilities:

• Worked on SAP BW on HANA implementation MP& IM project for the Client Levis from Gathering requirements, Development. Testing including Defect Fix Management towards the sprints with both Native HANA and SAP BW on HANA Landscapes based on Agile Methodology.
• Responsible for providing input into the technical deployment plan for history data conversion and SAP BW HANA .
• Experience working on HANA Enterprise Modelling including Attribute Views, Analytical Views, Calculation Views &Variables and Input Parameters.
• Experience working on HANA Optimized InfoCubes, HANA Optimized ADSO's, Composite Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA .
• Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes.
• Experience in Importing BW models Info Cube, DSO in HANA as Analytical view.
• Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE STUDIO
• Used Information Design Tool IDT to create connections to SAP HANA databases, Create data foundations and also created Business layer and publish these connections and layers to Repository.
• Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence WEBI
• Involved in developing and conducting extensive Unit testing, Integration testing FIT, Regression testing, User Acceptance Testing UAT and documentation.
• Provide test support - resolving defects in a timely manner (expected defect turnaround under 24 hours on average).

Confidential, Santa Clara, CA

SAP BW on HANA Consultant

Environment: SAP HANA, Tableau.

Responsibilities:

• Involved in the all the stages of the product life cycle. Performed requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
• Designed the HANA modeling views as a HANA Modeler/Developer for the Pipeline Conversion Ratio. and Account and internal Customer Account Mapping to the Territory.
• Experienced in HANA Application Life Cycle Management using CTS, Delivery unit
• Created SAP HANA information models such as HANA Views (only Calculation views) with graphical and SQL Scripting and Stored Procedures to design the models for Data Analytics
• Have been working as a HANA Developer with SP12 version.
• Worked on BW on HANA non cumulative cubes to extract the inventory data using standard extractors.
• Extensively involved in HANA development using VDM
• Created Calculation Views by using various nodes like Aggregation, Join, Union and Projection.
• Extensively worked on SAP HANA SQL scripting in the development of scripted based calculation view models Worked on Performance monitor / Tuning HANA Views.
• Expert in creating SAP HANA Views using Tableau dashboards
• Experience in creating Data Blending by merging data from different datasets. Created visualizations using scatter plots, Gantt charts, Bubbles, Bullets, Heat maps.
• Perform a assessment on Performance optimization on existing model which has issues.
• Developed a SAP HANA modeling views for SAP ERP standard report for displaying Actual Cost Line Items for Cost Centers using both Graphical and SQL script for Data Analytics and Reporting.
• Developed a SAP HANA Analytics modeling views for SAP ERP Cumulated Time Evaluation Results.
• Extensively worked on Calculation Views (Standard, Time and Derived)of both Graphical and Script.
• Creation of Hierarchies, Variables and Input parameters.
• Have been working as a HANA Developer with SP11 version.
• Proposed a complex solution for Service line towards the Deliveries Tolerance Report by using multiple calculation views of Graphical & SQL based on the Factory calendar of the plant.
• Extensively involved in HANA development using VDM
• Worked on Performance monitor / Tuning Hana Views.
• Adopted parallel techniques/filter pushdown/variables/input parameters, Hierarchies in developing models to achieve the performance
• Working on HANA models optimization (Source) for long running reports.

Confidential, San Jose, CA

SAP BW/HANA BOBJ Consultant

Environment: SAP BW on HANA, BO, Tableau

Responsibilities:

• Involved in the all the stages of the product life cycle. Performed requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
• Implemented full life cycle end to end implementations solution delivery for different modules of Logistics (SD,PM, PP,MM,QM,WM),HR, CRM, SRM & Financial (FI-CO, COPA) in SAP BI, involved in all phases like Requirements Gathering, Gap analysis, Blue-printing, design Functional and Technical specification, development, performance tuning, integration and UAT, documentation, code and peer code reviews, training and trouble-shooting.
• Extensively involved in PM- Equipment Expenditure Replacement cost using 0Equipment, 0Plant,0Functional Location and 0Notifications master data
• Deployment the solution for the Delivery Business process.
• Involved in Hyper care, UAT, Defect fixing
• BI Design - HANA optimized Info Cubes design, Composite Providers, Advanced DSO, ODS Objects, Proficient in Data modeling using MDM and BW extended star schema models.
• Development of Advance DSOs in HANA Studio using Eclipse tool and mapping the transformations to Advance DSO’s, reloading data from standard DSOs and HANA cubes to Advance DSO’s.
• Converting Multi-provider to Composite provider using program RSO CONVERT IPRO HCPR.
• Creating composite provider in order to replace Info sets.
• Replacing the Standard DSO’s and HANA Optimized Cubes with Advance DSO’s and Multi-providers and Info-sets by Composite Providers.
• Testing the BEX queries on Composite provider and noticed performance improvement.
• BI Reporting - Experience in Design and Development of Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting, RRI.
• Worked on all the technical data modeling artifacts of SAP HANA like creation of Attribute Views, Analytic Views, and Calculation Views (graphical and scripted (SQL).
• Extensively worked on SAP HANA SQL scripting in the development of scripted based calculation view models
• Extractions: LO, FI, CO-PA, HR, CRM, SRM Master data Extractors (BI Content & Generic), Set-up Tables, Delta management (Update methods), Delta Queues etc.
• Working with stakeholders to collect, analyze, define, and document requirements for reports, dashboards, scorecards, and analytics
• Build and maintain effective dashboards, visualizations, reports, and analytics using Tableau technologies for real time analysis
• Involed in testing and hyper care before handover to the customer.
• Design and develop various reports using Dashboard/TABLEAU to meet the customer needs.

Confidential, Burbank, LA

SAP BW/HANA BOBJ Consultant

Environment: SAP HANA BEX Designer, WEBI & Analysis Office

Responsibilities:

• Worked with the users to get the requirements, performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional team
• Design SAP HANA data modeling using Attribute View, Analytic View, Calculation View, Procedures.
• Woked on Standard extractors in 0FI GL 4, 0FI AR 4, 0FI GL AP, 0FI GL 14 of general Ledgers and COPA Extraction for Profitability Analysis .
• Extensively worked on Logistics’ (SD,PM, PP,MM,QM),HR, CRM, SRM & Financial (FI-CO, COPA) in SAP BI, involved in all phases like Requirements Gathering, Gap analysis, Blue-printing, design Functional and Technical specification, development, performance tuning, integration and UAT, documentation, code and peer code reviews, training
• Excellent knowledge on: HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP Net Weaver BW Model to HANA .
• Expertise in Identification the Technical requirements mapping the data identification
• Worked with BW related ABAP for Reporting Exit for MTD and YTD
• Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and Info Cubes.
• Experience in Importing BW models Info Cube, DSO in HANA as Analytical view.
• Good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users in SAP HANA.
• Expert in Data-Provisioning techniques for Real time Data migration process using SLT SAP Landscape Transformation to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
• Extractions: LO, FI, CO-PA, HR, CRM, SRM Master data Extractors (BI Content & Generic), Set-up Tables, Delta management (Update methods), Delta Queues etc.
• Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis BusinessObjects Explorer MS Excel.
• Created Open Hub interface to transfer BW to BPC team as Flat Files to load to an external system
• Experience in different methods of Data Provisioning techniques like SLT, Flat File and DXC.

Confidential, Manila, PH

Sr SAP BW/HANA Consultant

Environment: SAP BW, HANA and BO Analysis Office..

Responsibilities:

• Good exposure in designs developed for the project will pertain to SAP, and is to be implemented using Capgemini ASAP methodology, showcasing Capgemini strength in delivering end-to-end SAP implementations across the globe, thus requiring highly technical skills and background essential for project completion.
• Working with stakeholders to collect, analyze, define, and document requirements for reports, dashboards, scorecards, and analytics
• Build and maintain effective dashboards, visualizations, reports, and analytics using Tableau technologies for real time analysis
• Integrate different Sources system and handle various types of data migrates to SAP HANA .
• Extractions: LO, FI, CO-PA, HR, CRM, SRM Master data Extractors (BI Content & Generic), Set-up Tables, Delta management (Update methods), Delta Queues etc.
• Worked on extracting the data from ECC, CRM to SAP BW
• Experience in ABAP with Routines, Start routines and Functional modules.
• Extensive ETL (user exit coding and customization using ABAP) and report development experience using BEx/Webi/Dashboard/Analysis
• Maintain documentation of issue tracker on deliverables and prioritization of the workload balancing.
• Ability to work well in co-ordination with team members from various locations and very large teams
• Experience in Requirement Gathering in new process, Fit-Gap Analysis Study, Process Mapping, Post Implementation Support, Production Support, Testing and End User Training.

Confidential

SAP BW Consultant

Environment: SAP BW 7.0, BEX Designer

Responsibilities:

• Experience in Requirement Gathering, Fit-Gap Analysis Study, Process Mapping, Post Implementation Support, Production Support, Testing and End User Training.
• Experience in Upstream and Downstream process in OIL and Gas.
• Focal point for data load team to the entire production system for Shell - chemicals
• Designing the Transient and Composite providers to publish the required user specific reports. line charts, histograms, pie charts and scatter plots
• Experience in ABAP with Routines, Start routines and Functional modules.
• Experience in Logistics (SD,PM,PP), Finance control, HR, CRM, SRM to extract the data from Source system(SAP/Non SAP).
• Worked on the Enhancements of the tickets (Change Tickets) like Design Change in the Queries, Web Templates such as adding the new functionalities as per the User Requirements.
• Involved in the solving the tickets raised by users and PFP (Process Focal Point).
• Involved in designing the SOX documentation for the change management and release management and preparing the process documents for each and every enhancement.
• Handled the tickets of different severities by following SOP (Standard Operating Procedures) and never missed the SLA (Service level agreement).
• Extensively worked on Support and Maintenance issues.
• Scheduling and Monitoring of different types of data loads (like CM, CS, FI-CO, PP, PM) and solve data load fails as on Very High Priority.
• As a Second line support team member involved in solving different types of tickets
• Responsible for the Rev track system in maintaining, creating Rev Tracks for the shell Chemicals area used in transports

Confidential

BW/BI Consultant

Environment: SAP BW 7.0, BEX Designer.

Responsibilities:

• Gathered requirements, Designed the Technical Specification Documents from the Business Requirement Documents or Functional Design Documents for the Local Regulatory Reporting and Head Office Reporting Requirements.
• Offshore BI Operations Productions monitoring teams is very much successful in providing the detail level of analysis for the unusual process in the BWP System and manual actions as possible and ensure the 100% report availability daily.
• Refreshing and compressing the cubes according to the Client specified Periods
• Extensively involved in solving, when the error occurs recurring.
• Updating and maintain the issue tracker on shift basis for future reference, and issue tracker is updated online and sent to onsite with the daily status mail.
• We were very much successful in taking part with onsite team to get the best RA in the last 3 months.
• BI Reports and R/3 reports both are crossed checked, to identify the critical targets by using the Reconciliation reports.
• The Issues that are addressed by the Client, which in turn need to be investigate on Process & Execution.
• All Master Data and Transactional loads for Burbank are taken care, and ensure that is completed, by doing some manual actions (De activating aggregates) if necessary.
• Involved in Maintaining the Tracking the Object List, Issue Track List and leading the team for a particular country.
• Involved in the Modeling to create the, Multi provider, Info cubes, DSO, Info Objects Transformations, for Master and Transactional Data Loadings.
• Experience in Data modeling using Extended Star Schema design
• Created & maintained info Objects, custom data sources and transformations.
• Queries were developed using Filters, Restricted Key figures, Calculated Key figures and
• Formulas, Cell Definition, Structures, Filters, Free characteristics, Variables, Offset Variables.
• Involved in Performance Testing to Improve the Query Performance.
• Involved in the Reviewing the TDD’S and Unit Testing for the Reports and Maintaining the UAT Documents.
• Involved in Performance Testing to Improve the Query Performance
• Extensively worked on Cell based and Transactional Queries.