SUMMARY:

• Over 5+ year of SAP BW experience which includes BW on HANA Development/Migration and Conversion experience
• Worked on 1 Full HANA Life Cycle Implementation.
• Served as a Techno Functional Consultant.
• Strong knowledge of business/process dataflow in organizations and experienced in data modeling concepts.
• Possess strong analytical and communication skills, reporting skills, personal organization and interpersonal skills.
• Worked on HANA Enterprise cloud Platform.
• Worked on BW powered by HANA 7.31 version using the latest BW features such as SPO’s, Composite Providers.
• Worked on BOBJ WEBI reports using different Universes like POSDM Universe and KPI universe
• Worked on HANA Live Views specially in POSDM and Inventory Areas
• Proficient and sound knowledge with Multidimensional data modeling using extended star schema, Design Implementation, and User Training of SAP Business Information Warehouse.
• Extensive experience in SAP BW 7.X configuration, which includes system Landscapes, Requirement gathering, Cube and ODS design, OLTP Extraction and Reporting.
• Excellent knowledge of SAP BW components like Data Source Enhancement, User Exits, OLTP extraction data, Loading (Full/Delta Up - Load), Scheduling, Monitoring, Data Mart, Open Hub Service, Reporting Authorizations, Reporting Agent, Roles, User Profile maintenance and Transports.
• Extensively worked in the customization and implementation of SAP BW IS Retail.
• Experienced in activating standard Business Content, extending and enhancing ODS (Operational Data Storage), InfoCubes according to the requirements.
• Experienced in Back-end BW Component Extractors, Info objects, Info providers, Hierarchies, Info sources, Transfer Rules, Update Rules, Info Cubes, Multi Cubes, ODS, Info packages and Info Cube Aggregates using BW Administrative Workbench.
• Experienced in extracting data from ECC (MM, IM, Purchasing) into BW using LO Cockpit Data sources.
• Exposure to SAP Best Practices and full life cycle project experience utilizing the ASAP methodologies.
• Experienced in assigning Roles to users, Creation of Authorization objects using Profile generator. Also assigned Roles to Pre-Calculated web templates.
• Expertise in front-end Business Warehouse Components like Queries, Restricted Key Figures, Calculated Key Figures, Structures, Variables, Exceptions, Conditions, R/RI, InfoSet Queries and WAD(Web Application Designer).
• Experienced in BEx Analyzer, BW queries, and Web reporting
• Customization of Web templates, Web reporting and Web items using BW 3.x WAD and query designer.
• Involved in Production Support issues like checking the Query Performance, monitoring of data loads for optimization.

TECHNICAL SKILLS:

ERP: SAP R/3 4.0B/4.6C/4.7, SAP BW 7.31/7.0/3.5

Languages: Working Knowledge of ABAP/4, SQL, C++, Visual Basic, PHP

Databases: Oracle 9/8.x, MS Access, MS SQL Server 2000, MySQL, HANA

Operating Systems: Windows NT/2000/XP, Unix/Linux.

Reporting tools: SAP Business Objects, WEBI, Design Studio, BEX, lumira

PROFESSIONAL EXPERIENCE:

Confidential, Fort Myers, FL

Business/Functional - Analyst

• Worked as a techno function person by bridging up the gap between Business and IT.
• Gathered the Business requirements for various project(s) and enhancements by understanding the Core Business Processes and translating them to technical team.
• Documented the Table/Field level details and explained the Business logic to development Team
• Exclusively worked on POSDM Sales, Returns, Promotions, Price Overrides, Discounts, and Markdowns areas along with Inventory, Purchasing and Billing.
• Exclusively worked on Allocations Process Requirement
• Worked on Franchising Business Process and proposed the design to Development team.
• Exclusively involved in all levels of testing (Unit Testing, Integration testing)
• Worked extensively on the root cause analysis of the issues raised by business and evaluating the errors to find the root cause and providing the inputs for the development team.
• Worked closely with Business to resolve data issues and errors on BW Bex and WEBI reports.
• Worked extensively on testing the new developments and the changes for new applications like Paypal and mPOS (mobile POS) Register testing.
• Strong functional knowledge on POSDM, Billing, Purchasing and Inventory.
• Hands on expertise on /N/POSDW/MON0 POS Workbench, imported and exported the transactions using /N/POSDW/XMLO and /N/POSDW/XMLI, also reprocessed the errored IDOCs using WE02
• Worked on enhancement of Purchasing SPO by adding additional fields from Schedule Line Extractor ( 2LIS 02 SCL) and did the data testing.
• Created the New Currency Type in RSCUR to convert CAD to USD based on 0CALWEEK.Did additional data validation using TCURR Table.
• Created Fashion Grade DSO/Data source and Transformation which includes start routines and formula functions.
• Created a ad-hoc APD to validate the Data between Store systems and POSDM TLOGF Table for Real time Sales.
• Worked on concatenation of 0RT SEASON Text ( Season Code Full Description) + Season Year + Rollout Description.
• Excellent understanding of BW Modelling/Reporting.
• In depth technical understanding of DTP’s/Cubes/DSO’s/SPO’s/Composite Providers/
• Extensively worked on Field level mapping analysis/Transformations, data Validation.
• Identified data discrepancies in SPO’s by understanding the field level routines /code issues.
• Created Process chains for Bex Broadcasting reports.
• Created broadcasting setting/workbooks.
• Created Data Archiving process for Sybase IQ NLS project
• Created SPO’s by extending the Partitions.
• Currently working on BW 7.4 Upgrade.
• Created Attribute, Analytical, Calculation Views.
• Used Inventory Visibility Calculation views which gives the On Hand at store. This view basically takes MARD Table stock and the unprocessed sales data from /POSDW/TLOGUS table to get to On hand.
• Based on the report requirement, created the calculated fields in the Calculation Views.
• Exclusively worked on the “is.retail.an.sales” analytical view which was used for real time Sales throughout the enterprise.
• Extended the attribute views by adding Plant, Zipcode for Geo special analysis in Lumira.
• Worked in Real Time Inventory analysis and created Calc views based on MARD/MSEG Tables.
• Worked on the Source System ( ECC) data validations with HANA Views and WEBI reports.
• Created Lumira to show Inventory On Hand Availability.
• For BOBJ testing, created Universes in Information Design Tool using SQL and HANA as the source.
• Created WEBI reports on POSDM Universe to validate the tenders, taxes, Sales, Returns, Discounts for the different scenarios like Price Overrides, Bonus Buys, Post Voids, Markdowns, Promotions, Suspend and Resume, Tenders, Merch cards payments etc.
• Created User Friendly and formatted reports which includes filter bar, Input Controls, Blocks, sections and Breaks.
• Created cross Tab reports at different granularities ( Comp Code, Sales Org, Distribution Channel, Year, Quarter)
• Created the Broadcast settings and worked on broadcasting reports in BW BEX/Portal using RSRD ADMIN T code. ( worked on Exec Flash reports which gives Daily, Monthly, Quarterly, Yearly Sales and Inventory Information for TY, Last Year and LLY )
• Created the ad-hoc Bex reports using the Customer Exit Variables, validated the data with backend SPOs and DS0s in RSRT to make sure the Logic is working fine.
• In BOBJ, Created the Publications for Business Critical reports.
• Worked on BW Bex Reports. Created Variables, Calculated Key Figures, Restricted Key Figures,
• Created WEBI reports using Input Controls.
• Analyzed the connectivity issues between BOBJ - WEBI reports and BW Bex Reports.
• Fixed the Plan Budget for Sales Flash report when data was not loaded in BW.
• Analyzed the root cause issue when Bex Broadcasting reports were not broadcasted.
• Analyzing the Orchestrator issues and fixing them by running manually based on the dependencies and validations with the Source data.
• Trained Business users on BW Bex Reporting
• Trained Cross Functional Teams and Business on WEBI Reports
• Always was the “Go To” Person from Business side.

Confidential, Fort Myers, FL

HANA- Migration/Conversion SAP BW/HANA Consultant

• Created SPO’s, Transformations, Info sources, Inventory Moved Out of Stock. SPO’s were partitioned by Brand.
• Worked on POSDM Std Data Source - 0RT PA TRAN CONTROL data source flow which feeds to a Write Ops DSO and then further up to SPOs. Added the International Key figures to SPO’s and enhanced the transformations.
• Added lot of Navigational Attributes to SPO/Multi Providers and moved huge transports to target system.
• Interacted with Business and explained the backend data flow/design. Explained the business on how they can report off the SPO Part Provider or on SPO itself.
• Created Open Hubs in BW on HANA to support Sales extracts such as “Merch Balancing Report” for Downstream/Partner systems.
• Created process chains for migration data flows from Legacy (PW2) to HANA.
• Validated the data after the migration and conversion and then got the Business signoff.
• Created test scripts for each of the functional areas.
• Worked with Business users/analysts to ensure the data integrity.
• Worked extensively on the Broadcasting. I created all the “validation” queries which are a part of Process chains and which will be triggered using Broadcasting.
• Created workbooks, and published those workbooks in portal and in turn created broadcasting settings in RSRD ADMIN and used them in the Process chains.
• Transported 300+ Queries using SAP Transport connection.
• Created composite provider which is a combination of Article Master, Generic Article and Article at Sales Org, distribution channel.
• Used 2LIS 13 VDKON/VDITM billing data sources for Cost and POSDM for Retail (0RPA SAT) enhanced the FAS Multi Provider and mapped the Cost (0RPA CST) from Billing SPO and Retail from POSDM to get the Gross Margin for reporting purposes.
• Involved in the technical discussion of Snap shots, Non Cum Cubes and Cost and Retail for Pre packs components and Franchising Design.
• Extensively worked on Migration of data from BW 7.31 MSSQL DB to BW (7.31) Powered by HANA DB.
• Created Export Data source on Cubes and DSO’s and did a data load based on date selection(s).
• Analyzed the mapping of fields in the Transformation in the new data model and making sure that the migration data matched exactly.
• Prepared Test scripts on Article Movements Data flow ( 2LIS 03 BF), Reval at Retail (2LIS 40 REVAL), Reval at Cost ( 2LIS 03 UM).
• Worked very closely with Cross functional teams (P2P team, POSDM, Master data) during integration testing.
• Worked extensively to fix defects on POSDM, billing areas.
• Prepared a comprehensive spreadsheet for entire Migration data loads which included the time taken, process used to load at the PSA level, write optimized DSO level, and the Cross Brand DSO and finally to the Part provider of SPO. This spread sheet was used as a base for Cutover.
• Compared the data loading times of In Memory DSO’s vs RDBMS DSO and documented the results.
• Extensively analyzed time taking queries in RSRT and gave recommendations for faster run times by changing the properties, maintained cache and pruning.
• Worked with Basis on the Background vs dialog work processed during the Migration time and adjusted the DTP’s accordingly.
• Worked closely with BW team lead/Architect on the HEC Proof of concept.
• Worked on the testing to ensure HEC is working as intended. Analyzed the run times of data loads on HEC.
• Documented the network latency b/w HEC and on premises data loads.
• Assisted the team on the Cutover Plan.
• Created BEX Reports to compare the HANA data with PW2 data(BW on Oracle system).
• Extensively used CKF/RKF’s and variables in the reports
• Identified all the Variables which were in Legacy system by looking base tables such as RSZGLOBV and installed and collected these variables and moved across HANA land scape.
• Created BEx queries and used Currency Conversions using Variables at the Bex layer.
• Assisted the EIM team in creating 40+queries which involves complex calculations/formula’s.
• Have Conceptual knowledge of BOBJ WEBI reports, Universes and semantics.

Confidential, Houston, TX

SAP BI Developer

• As a BW consultant involved in full lifecycle right from BW modeling, analysis, design specification, development, performance tuning and detailed reporting.
• Have a strong understanding of database design, data modeling, OLAP, and experience of SAP BW components, OLTP Extraction generic and custom specific extractors (LO-Cockpit).
• Worked in Bex Query Designer/BEX Analyzer/Browser/Web environment.
• Created Custom Info Cubes and also Implemented BW standard business contents for Purchasing, Sales and Distribution, Cross functional Master Data Areas.
• Created APJ ( Asia Pacific and Japan) Regional reports in query designer. Created complex reports which involve Variables, Restricted Key figures, calculated Key figures, formula variables.
• Worked with end users in requirement gathering. Prepared the Technical specs.
• Created Custom Info Objects, Info Cubes, Queries, ODS, Extractors, Update and Transfer rules for Purchasing Functional area. Worked on the Purchase Orders History Report by creating Generic Data source on EKBE Tables and created Custom cubes to cater Reporting Needs.
• Interacted with Business to understand the Legacy sales returns reports which comes from Oracle Data base. Created DB connect data sources in BW and created Custom cubes to get this requirement done
• Analyze Business Content Info Cubes and delivered the estimation for developing the enhancement and creating queries.
• Development of BW objects and responsible for data loading (master data and transactional data).
• Analyze, design and development of MultiCube based on the reporting needs.
• Customized info Sources. Customized info Cubes and used Transfer rules and Update rules. Updated Info Cube of Sales Analysis InfoCube, with customer Number, and Material number.
• Uploaded data for master data and transactional data into BW. Defined queries with BEX analyzer. Created custom info cubes (CO-PA) for cost allocation data.
• Involved in the Upgrade of BW 3.5 to BI 7.0 with the team.
• Migrated the 3.5 dlow to 7.0 using Transformations/DTP’s and adjusting the process chains.
• Heavily worked on reporting side to migrate the 3.5 reports to 7.0 and also to use the new 7.0 features from a reporting stand point.
• Data loads from R/3, flat files using PSA. The data loads for master data as well as transaction data (LIS info structures).
• Created queries for the reporting from the infocubes.
• Created Delivery Info Cube and Billing Info Cube.
• Developed Day billed report: - The Days billed report will monitor revenue for daily bill contracts.