PROFESSIONAL SUMMARY:

• Having 10 years of SAP experience which consists of 6 years on SAP BI/BW and 4 years on SAP HANA Native data modeling.
• 5 years on SAP BOBJ 3.x, 4.1 Tools - Web Intelligence, Analysis for Office/AOLAP and Tableau 8.2
• Loaded data from Source to Target systems using BODS tool.
• Gather the Business requirements and converting them into Blueprint.
• Experience on HANA LIVE Virtual Data models.
• Interacted with Clients to understand the business processes across various SAP functional areas.
• Created the Technical flow documents for the Business flows based on the Functional Specifications.

PROFESSIONAL EXPERIENCE:

Confidential, SFO, CA

SAP HANA Consultant

Environment: SAP HANA 1.0 SPS 85, SAP BW 7.4, SAP BOBj AO, Tableau

Responsibilities:

• Designed the Calculation Views on POS Inventory - BW HANA DSOs of Integration layers for LS US, Canada, Mexico, Asia and Europe.
• Created the Attribute Views on the imported BW Info Objects Structures.
• Imported the HANA - IM Optimized DSOs from BW system to HANA studio.
• Used the Star-Join Concept to join the Master Data Dimensions Calculation views to the transaction Data Analytic Views.
• Created calculated Columns and restricted Columns in the POS Calculation Views.
• Created the Tableau Dashboard reports on HANA Views for Geographical Analysis.
• Used the SQL statements to reconcile the data in HANA views and reports.
• Transported the HANA views from DEV to Quality using Change ID and Lifecycle Manager.
• Tested the Performance on the POS Calculation Views using SQL Statements and Visualize Plan and made changes accordingly.
• Document the Test Script Documents for the HANA Views and AO reports
• Created the Analysis for OLAP reports on the HANA Views according to the Client Requirements.

Confidential, Santa Clara, CA

SAP Native HANA Consultant

Environment: SAP Native HANA 1.0, SAP BOBj WebI, Tableau 8.4

Responsibilities:

• Designed the Attribute views, Analytic Views, Calculation Views (Graphical and Script-based) on ACCOUNT, USER and OPPORTUNITY base tables.
• Analyzed and documented the Client requirements of Millionaire reporting in SAP BW system and BO WebI layers.
• Used the joins like Inner, Referential, Outer in the HANA EDW views (Graphical and Script-based).
• Used SQL Window Functions to get Rank() and Cumalitive Totals based on Fiscal Periods for the Customers of the Millionaires in Script based calculation views.
• Developed the SQL Script based Calculation View to get the
• Create calculated columns, Restricted Columns, Input Parameters on the HANA Views according to the Reporting requirements.
• Moved the HANA Views from HANA DEV to HANA Quality using Export-Import options and also the LCM to transport the Data models to HANA Production systems.
• Created the WebI Reports on HANA Live Virtual Data model.
• Copied the existing Query Views, Reuse Views from HANA Live to the Template Views and customized them according to client Requirement to get the Millionaire Data.
• Developed the BODS data flows using filters and transforms logic to replicate the data from SFDC source system to HANA.
• Created the BODS Jobs to get the Data from SFDC Source.
• Created the Visualization Dashboards on Tableau tool on the HANA Views.
• Created Geographical visualization report with Tableau based on Global Locations for various Accounts and Opportunities.
• Used Sort, Grouping, Sets and Filters functions in the Tableau Reports.

Confidential

SAP BW on HANA Consultant

Environment: SAP BW 7.3, SAP HANA DB, SAP BOBj WebI, AOLAP

Responsibilities:

• Involved in the Documentation of Data Model Design Specifications based on the functional specifications.
• Created the HANA optimized DSOs and loaded the FI-GL based data from ECC.
• Created customized generic Extractors based on FI tables - BSEG, BKPF, FAGLFLEXA, FAGLFLEXT.
• Created HANA based DSOs and load data through ODP form the Analytic and Calculation views of HANA Studio.
• Created the Composite Providers on the FI business flows Based on the DSOs and Master Data objects.
• Data Reconciliation of Composite providers and the legacy BW Info Providers.
• Worked on the Virtual Providers on the Analytic and Calculation Views from HANA Studio.
• Created Sematic-Partition Objects on the DSOs to Partition data.
• Involved Creation and testing of the BEX and BO WebI Reports for Asset Management, P&C and Life and Recovery.
• Involved in AOLAP reporting on the DSOs and Composite Providers.
• Created Visualization Reports with bar & pie Charts and Geographical options on SAP Lumira.
• Loaded the Data to the Data Targets and tested the reports according to the business requirements.

Confidential, Springdale, AR

SAP BW on HANA Consultant

Environment: SAP BW 7.3, SAP BODS, SAP BOBj WebI, AOLAP

Responsibilities:

• Interacting with the Client POC on the estimates on the MANUGISTICS Business Flows consisting Forecasts, Budgeting, and Sales based on the Data and Reporting functional Specification.
• Analyzed the Oracle Source Tables and extracted the Data to SAP BW through SAP BODS tool.
• Used Transforms, merges and loop-up functions in BODS to extract data from MANU Oracle source tables and load to BW system.
• Created the Data flows, Data Stores and Jobs in the BODS system.
• Designed the SAP BW business flows for MANU Forecast, Budget, and Sales.
• Created the Composite provider to union the Forecast, Budget, and Sales DSOs.
• Used ABAP code in Routines and Date Calculations based on Tyson Fiscal Week, Week begin date and Week End date.
• Designed SPO DSOs based on Tyson Fiscal Year and included the SPOs in the Multi Provider.
• Extracted TBM (Tyson Business Manager) Data based on the HANA Calculation Views through ODP (Operational Data Provisioning) and Virtual Providers.
• Transported the BW Object from Development to Quality systems and tested the Business flows.
• Used CMOD ABAP code to calculate the 13 week before and after forecast Data in the BEx Queries.
• Designed the Process Chains for the MANU and TBM Flows for Master and Transaction Data.
• Designed the WebI and AOLAP Reports based on the BW BEx Reports for MANU and TBM.

Confidential

SAP Native HANA Consultant

Environment: SAP HANA 1.0; SAP BO WebI

Responsibilities:

• Documented the Functional and Technical Specifications for SAP EDW HANA requirement based on the business flow for FICO, COPA in the existing Legacy systems.
• Created Attribute views, Analytic views, and calculation views as a part of SAP HANA Modeling.
• Replicated the Application Tables from SAP ECC to SAP HANA Studio using the Real-time SLT Process.
• Used the Advance Replication Settings to Map, Transform the Data during Replication in the SLT Server.
• Created the Analytic Views using Transaction tables in Data foundation and joined the Attribute views in the logical join section.
• Used the various HANA studio Functions like Conversion, String, Mathematical, misc and Date to suit the business requirements in Calculated Columns and Restricted Columns.
• Involved in the performance tuning of the EDW HANA Views and SQL Script codes using Debugger and Explain Plan scenarios.
• Created the Analytic Privileges on the HANA Views based on Company code and Region level Securities.
• Transport and Imported the Data flows from BW Development system to Production
• Called the Calculation and analytic views to BOBJ 4.0 IDT Tool.
• Developed the WebI Reports Using the universes built on HANA Calculation and Analytic views.
• Formatted the BOBJ WebI reports using Merge, Alerts, charts, crosstabs, breaks, subtotals and Input controls.

Confidential

SAP Native HANA Developer

Environment: SAP HANA 1.0 SP05, WebI, AOLAP.

Responsibilities:

• Understanding the existing SAP BW Models and documenting the business flows in SAP EDW HANA.
• Involved in the Data Governance meetings with the clients.
• Developed the Attribute Views based on Master Data Tables in the SAP ECC.
• Developed the Analytic Views based on Transaction Data Tables in the SAP ECC for SD and Purchasing.
• Created the Analytic Views based on the transaction tables and master Data Attribute Created the Graphical Calculation Views by including the Analytic views using Unions, Projections and Joins based on the business logic.
• Created the necessary Calculated Attributes, Restricted Measures, Calculated Measures and Input Parameters using the HANA studio tool.
• Used the HANA studio Functions like Conversion, String, Mathematical and Date to suit the business requirements in Calculated Attributes and Calculated Measures.
• Developed SQLScript Calculation Views for Percentile, First, last, nth, Cumulative Totals logics on Sales data on Fiscal year periods.
• Created the HANA Analytic Privileges on the HANA Views in Studio to restricted Users.
• Reconciled the data with the existing BW Reports with the new HANA Models.
• Called the Calculation View to BOBJ 4.0 IDT Tool to create Universes.
• Created the Visualization Reports in SAP BOBJ Explorer 4.0 based on the Analytic Views, Calculation views and Universes using measures and Facets on the Information Spaces.

Confidential, Fresno, CA

SAP BW/BI Analyst

Environment: SAP BI.7.0, BEx Designer, BEx Analyzer, SAP ECC 6.0.

Responsibilities:

• Involved in Discussions with the client regarding Business Requirements.
• Identified and installed the BI content objects related to Billing, Inventory, and Budget (COPA), HCM - Payroll and Headcount.
• Extracted data from ECC using the Logistics procedure for Sales and Inventory.
• Extracted historical MSSQL data for Sales and Budget using the UD Connect.
• Involved in writing Start Routines, Field Routines and end routines.
• Enhanced the Billing and Inventory data Sources according to requirements.
• Developed Queries using RKFs, CKFs, Exceptions, Variables, Conditions, Cell editor, Replacement path, Formula collusion etc.
• Developed ABAP Code for Year-to-Date and Period-to-Date in CMOD.
• Transported all the ECC and BI Objects from Development to Quality and Production Systems.
• Created, Scheduled and Monitored Process Chains for the above flows.
• Involved in UAT with the Business Users in BI Quality system.
• Re-designed the Objects and made changes to the Flows and Reports to meet Requirements after UAT.
• Created the Data foundation, Business layer and published the universe to WebI.
• Created the Reports Using the BOBJ WebI tool on the universes.
• Created the BOBJ WebI reports by calling the BEx Queries using BICS connectivity.
• Created the Tab - wise reports for on the Sales and Billing in BOBJ WebI.

Confidential, Evansville, IN

Senior SAP BI Consultant

Environment: SAP BI/BW

Responsibilities:

• Involved in SD, SRM Business Flows.
• Installed Business Content Objects as per the client requirements.
• Based on the Functional Specs created Technical specs.
• Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.
• Based on the client requirement, Extracted the data using LO - Cockpit for logistic data.
• Involved enhanced the Sales and Distribution Sources according to the technical specifications.
• Used ABAP Code to enhance fields from tables to the data sources using CMOD.
• Created the business flows for SRM and SD.
• Involved in designing the Shopping cart Status and Details, Confirmation details for SRM flows.
• Worked on the 0BBP TD SC 1 and 0BBP TD SC APPR 1 to get the movement Data to SAP BW system from SRM.
• Used Standard BEx Reports for User requirements using Filters, Free Characteristics, Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables.
• Loaded and reconciled the data for the above flows with Data Targets, Reports and ECC Tables and RSA3.
• Tested the developed business flows in the Quality Server as a part of Unit Testing.
• Transporting the objects from Development server to Quality server.