SUMMARY

• Over 12+ years of SAP Experience in SAP Business Intelligence tools of SAP BW on HANA, 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),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 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.3 and HANA 1.0 SP9 & lately with SP12 version.
• 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 Accountin and Asset Accounting - Profit/Loss accounting
• Knowledge on S4/HANA creating views using CDS
• Working on S/4 HANA POC for the client Confidential 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

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

SAP HANA Consultant

Environment: . SAP HANA 1.0, Tableau, Data Services

Responsibilities:

• Involved in the all the stages of 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.
• 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
• 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.
• Experienced in HANA Application Life Cycle Management using CTS, Delivery unit
• Expert in creating SAP HANA Views using Tableau dashboards
• Worked on FI Accountin and Asset Accounting - Profit/Loss accounting
• Experience in creating Data Blending by merging data from different datasets. Created visualizations using scatter plots, Gantt charts, Bubbles, Bullets, Heat maps.
• Worked on Non SAP tables as Sources and target in Business Objects Data Services.
• Build and maintain mapping tables
• Deployedtableauserver in clustered environment by adding worker machines.
• Developed KPI’s and dashboards based on reports, spreadsheets and charts.
• Timely respond to user requests and proided appropriate actions.
• Worked on data blending and increased the dashboard performance by extracting data.
• Developed different phases like Stage, SDL, EDW(EL - Enterprise Layer) to process the data
• Modifying the incoming data through Platform, Data Integrator transforms.
• Creating batch jobs, workflows, dataflow and mappings.
• Creating sequence and parallel workflows and data flows.

Confidential, Wichita, KS

SAP BW on HANA Consultant

Environment: SAP BW ON HANA, Tableau, WEBI & AO.

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.
• Knowledge on S4/HANA creating views using CDS
• Working on S/4 HANA POC for the client Confidential using CDS
• 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.
• 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 DSOsin 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:

• 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). n Activation and Enhancements of SAP Standard Business Contents.
• 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:

• 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 andTransactionalQueries.

Confidential

BW/BI Consultant

Environment: SAP BW 7.0, BEX Designer.

Responsibilities:

• Exclusively involved in PepsiCo implementation phases of QTG2 & QTG1 in IDC Bangalore.
• Exclusively Involved in Data source Enhancements for various master data and Transactional Data sources in Logistics.
• Exclusively involved in Generic Data Sources using Function Modules for various Modules in Logistics.
• Creation of Cubes and Data Store Objects for various applications in BW
• Set up procedure for extracting R/3 data for Customers, Sales Order in Sales and Distribution using LO-Cockpit.
• Involved in Info Cube maintenance i.e. Compression, Creating aggregates, Partitioning the Cube.