SUMMARY

• 14 years of Accomplished Functional Consultant Experience in Developing and Implementation of Business Warehouse/Business Intelligence Solutions, which includes SAP BW/BI 3.5/7.0/7.3/7.4 , SAP BODS 3.1/4.2 and Business Objects XIR 2/3.1/4.0/4.1 , SAP BODS, SAP Lumira, SAP HANA and Tableau
• Upgrade Experience in SAP BW from 3.5 to BI 7.0/7.3/7.4 and in depth knowledge of migrating data sources from BW 3.x to BI 7.x
• Successfully executed multiple SAP Projects with more than 6 full life cycle implementations, other upgrade, conversion and BAU projects.
• Experience with different industries - FMCG, Retail, Manufacturing, Oil and Gas, and Federal Government.
• Proficient in Data Extraction from SAP ECC (FI CO-GL, CCA, PCA, AA LO-MM, PM, SD etc.) IS Retail, Transport Management TM and Generic Extractors using Function Module’s.
• Excellent knowledge of SAP BW components like Data Source Enhancement, User Exits, OLTP extraction, Loading (Full/Delta Up-Load), Scheduling, Monitoring, Process Chains, Data Mart and Open Hub Service.
• Done implementations using SAP ASAP/Scrum Methodology and comprehensive understanding of SAP Best Practices like LSA+ .
• Experience with Enterprise HANA Platform 1.0 SP9/10 and in HANA Studio with Perspectives like HANA Modeler, BW Modeling in Design, Development of HANA DB Objects like Catalog, Packages, Information models (Attribute views, Analytical views, Calculation views), Analytic Privileges, Procedures, Decision Tables, Import/Export/Migrate, Setup(Delivery Units, Schema mapping)
• Worked on Data Provisioning techniques like SAP SLT, Business Objects Data Services Designer (BODS) 4.2 with SAP, Non-SAP Data sources in Design, Development Extraction/Migrate/Import of new projects and their related data as identified into SAP HANA, maintain ETL jobs for loading real-time data replication from various Data Sources into SAP HANA Database
• Created Information Views Using GUI and SQLScript in SAP HANA
• Knowledge of S/4HANA CDS Views
• Extensively Worked on SAP BI CCM, CMC, Life Cycle Manager (LCM) and Promotion Management.
• Extensively worked on SAP BW 7/7.3/4- BO 3.1/BI 4.0/4.1 Integration
• Installation and Configuration of SAP BODS 4.2 - Repository and Job Server.
• Installation and Configuration of SAP Lumira Server
• Strong expertise in SAP HANA Data Provisioning/Replication techniques like SLT, SAP BODS 4.0/4.1 and Smart Data Access (SDA).
• SAP HANA Live development using Virtual Data Model (VDM) that includes Private Views, Reuse Views & Query Views.
• Expertise in creating SAP Lumira Visualization for SAP HANA Solutions
• Create Visualisations in SAP Lumira
• Knowledge and Exposure to Hadoop Ecosystem-HDFS, Hive and Sqoop
• Knowledge of SAP ESP and Continuous Queries
• Expertise in Performing Post Go Live Activities and Other Support Activities like Creation of Ticket Analysis Report, Off Shore Resource Utilization Report, and Time Sheet Maintenance of the Support Team.
• Excellent Team Player with good logical reasoning ability, coordination and interpersonal skills.

PROFESSIONAL EXPERIENCE

Sr SAP BW/BI Hana Consultant

Confidential

Responsibilities:

• Monitoring Data Loads
• Semantic Partitioned Info Cubes (SPO) for 0RT PA TRAN CONTROL, 0RT PA TRAN MOV FIN and 0RT PA TRAN GDS MOV
• Sales Basket Analysis and Article Analysis Queries on 0RT PA TRAN CONTROL
• Housekeeping Activities - Deleting of PSA and Change Log Tables, Monitoring of DIM tables and Performance Improvements
• Function Upgrade Activities for SAP BW 7.4
• Loaded Master Data-0RPA MEAN, 0RPA MARAM, 0MATERIAL and 0RPA PROMOTIONS and ZRPA PRODUCT ATTR
• Creation of Queries to Evaluate Carriers, Transports and Customers in TM
• Loading TM Master Data-BSH, CFIR, SFIR, TAL, TDL and TRQ etc
• Creation of Multi Providers-ZTMS MP11/M13/16
• Publish SAP HANA Models into SAP BW-Analytical Index’s and Creation of Composite Providers
• Importing SAP BW Info Providers into SAP HANA
• Involved in Transporting SAP BW Transports from Dev to QA and to Prod
• Creation of Custom Reuse and Query Views in SAP HANA- LO Sales TM Tendering and TM Freight Order
• Installed SAP HANA Live Extension Assistant
• Creation of Virtual Tables in SAP HANA Studio using SDA
• Creation of Delivery Units and Transport Containers for Transporting SAP HANA Objects
• Performing Schema Mapping and Table and Schema Creations in SAP HANA
• Preforming UoM and Currency Conversions in SAP HANA
• Creation of Pruning Tables in SAP HANA
• Creation of Decision Tables with Update and Return Values
• Analyzing the Expensive Query’s using Monitoring Views and Explain Plans in SAP HANA
• Creation of SAP Lumira Datasets- both SAP SAP HANA and Non SAP Data Sets SAP BI IDT
• Creation of Lumira Visualizations and Story boards based on SAP HANA Views
• Building Custom Hierarchies and Measures in SAP Lumira
• Installation of BW Modeling Tool in SAP HANA
• Creation of Process Chain for Master and Transactional Data
• Involved in Installation of SAP BI 4.1 Server/Clients.
• Configuration of SAP BI 4.1 Services
• Creation of OLAP Analysis and WebI Reports using BICS Layer.
• Promoting SAP BI Objects to QA and Production Environments through Promotion Management.
• User Creation and Assigning Security Profiles in SAP HANA and SAP BI 4.1
• Extract, define and publish universes (Connections, Data Foundation, Business Layer) from relational and OLAP sources for data analysis in SAP BO Information Design Tool (IDT)
• Data Replication and Migration using SAP BODS and SLT
• Supporting Solutions Post Go Live

Environment: SAP IS Retail, SAP TM 9, SAP ECC, SAP BW 7.0/7.3/4 SP08, SAP BI 4.1, SAP BODS 4.2, SAP Lumira 1.27 and SAP HANA SPS10, SAP SLT and SAP HANA Live

Sr SAP BW/BI HANA Consultant

Confidential

Responsibilities:

• Requirement gathering from Business and Application Consultants
• Involved in Requirements gathering and preparing the Functional design and Technical design
• Semantic Partitioned Info Cubes (SPO) for 0RT PA TRAN CONTROL, 0RT PA TRAN MOV FIN and 0RT PA TRAN GDS MOV
• SLT for Replication of SAP ECC Tables
• Schema and Table Creations in SAP HANA
• Preforming UoM and Currency Conversion in SAP HANA
• Development of HANA objects Attribute Views, Analytic Views, Calculation Views
• Created/maintained Schemas and packages, worked with Analytical privileges
• Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Creation of Universes on top of HANA calculation views and developed the Webi reports.
• Creation of Process Chains for Master and Transaction Data
• Creation of Open Hub Destinations to send data from SAP BW to External Servers
• Involved in SAP BI performance tuning tasks like Splitting of Adaptive Processing Server
• Creation of OLAP Analysis and WebI Reports using BICS Layer.
• Creation of Jump Views in OLAP for Office.
• Exposing SAP Extractors using RODPS OS EXPOSE
• Creating Jobs and Data Flows to move data from SAP CRM to Teradata
• Worked on ABAP Data Flows, Query, Validation, Case and MAP CDC Transformations
• Creation of Repositories in Development and Quality Environments
• Monitoring and Scheduling SAP BODS Jobs in DS Management Console
• Object Promotion in SAP BODS Management Console
• Creation of Universes in IDT for Non SAP Data Sources Teradata
• Promotion of SAP BI Objects

Environment: SAP ECC 6, SAP IS Retail SAP HANA SAP BW 7.3/7.4, BEx, and OLAP Analysis for Office/Web and SAP BODS/BI 4.1.

Confidential

Lead & Sr SAP BW/BI HANA Consultant

Responsibilities:

• Analyzed and translated business requirements into technical specifications, data flow diagrams and data models.
• Identifying and documenting necessary KPI and reporting requirements to build a reporting architecture.
• Activation of the Business Content-Info Objects and Cubes for Inventory Analytics, FI GL, AP, AR and AA and customizing them as per the requirement.
• Building Hierarchies for GL Account, Profit Centers, and Cost Centers etc.
• Performed LO-Cockpit extraction to pull data from R3 SD modules into BW system extracting the Header and Line item data from the Sales and Distribution (SD) module(LIS 11 VAHDR/VAITM,2LIS 12 VCHDR/VCITM,2LIS 13 VDHDR/VDITM).
• Performed LO Extraction to pull data from Plant Maintenance for 2LIS 16 I0NOTIF, 2LIS 17 I0NOTIF and 2LIS 18 NOTIF for Maintenance Notifications Info Cube (0QM C10)
• Extracted data from 2LIS 02 ITM, 2LIS 02 SCL, 2LIS 03 S194 and populated into the procurement info cubes 0PUR C07, 0PUR C08, and 0PUR C09 to appraise the service levels.
• Created Annual Values and Transactions 0FIAA C04 and Asset Movements 0FIAA C03 Info cubes
• Schedule, performance and monitor periodic data loads from SAP R/3/ ECC to BW,
• Maintained Process Chains to automate and schedule the data loads.
• Performance Tuning Activates like Building Aggregates, Creating Secondary Indexes and Partitioning
• Integrated SAP BI with SAP ECC and SAP BI 7.3 to build BICS Layer.
• Created BEx Queries including RRI RSBBS Interfaces
• Several complexes-cross tab reports and sub-reports are published using Crystal Reports
• Designed Complex Hierarchies for Profit Center, Cost Center and GL
• Managing Transports in SAP BW
• SAP BI CMC Administration tasks - User/Groups creation, Application and Folder Security, Scheduling of reports and Configuration SAP BW, ECC and BI connections
• Life Cycle Manager Administration tasks- Creation of Jobs and Promotions across landscape.
• Created HANA Objects Attribute Views, Analytic Views, Calculation Views
• Created Schemas and packages, worked with Analytical privileges
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Created Universes on top of HANA calculation views and developed the WebI reports.
• Data Replication using SAP SLT and SAP BODS
• Worked with BODS functionalities Project, Job, Work flow, Data flow, Data store to import the tables from ECC to HANAInvolved in the Installation of SAP BI 4.0 and SSO between SAP BW and SAP BI 4.0
• Configuration of BI Servers in Central Management Console.
• Configuring Monitoring/Auditing Database in SAP BI 4.0
• Creation of Tableau Dashboards.
• Created and deployed WebI & Crystal Reports through BI Launch pad.
• Extensively Worked in SAP Analysis for Office to Views and use as Data source for Crystal Reports and WebI
• Creation of Visualization Data Sets
• Support UAT and GO Live Activities

Environment: SAP 4.7/ECC6.0, SAP BW 7/7.3, SAP BI 4.0, SAP Crystal Reports, Tableau and MS SQL Server, SAP HANA, SAP Zen Design Studio and SAP Visual Intelligence SAP Lumira

Confidential

SAP BI/BW Consultant

Responsibilities:

• Gathered Requirements from Business Units and Created Design Documents
• Performed Analysis, Designed Info cubes and DSO’s for FICO, MM and SD modules
• Designed Purchasing Inventory 0IC C03, Sales Overview Cubes 0SD C03
• Enhanced COPA Info Cubes and Multi Providers, ANZ regions for FY 08, 09, 10 and 11
• Activated profit center accounting cubes (0PCA C01, 0PCA C02), accounts payable cubes (0FIAP C02, 0FIAP C03), accounts receivable cubes (0FIAR C02, 0FIAR C03), Sale cubes (0SD C01, 0SD C02, 0SD C03, 0SD C05) from Business Content.
• Configured data sources in R/3 by using LO Cockpit (LBWE) initialized the setup tables. Scheduled and implemented delta mechanism for periodic loads
• Experience in complex re-initialization process to achieve selected company code based data
• Built Open Hub Destination for sending out BW data to external applications
• Designed Universes for Financial Billing System and Order Processing Reports
• Managed and Monitored Data Loads. Optimized Load Performance
• Migrated 3.x Data sources to B.I 7.0 data sources with transformations and DTP'S
• Addressing the Change Request’s
• Designed and maintained Universes and exported them to the Production Environment.
• Design and Migration of WebI Reports from Development to QA and QA to Production Environments
• Resolution of Remedy tickets from users and updating the solutions on the BMC Remedy database
• Monthly Server Maintenance tasks SAP BO Patching.
• User Creation and Granting the Permissions on Folders and Applications in SAP BO CMC
• Maintenance of the BO XI R2/ 3.1 platform on the Windows
• Used BODI Designer to create complex mappings using different transformations to move data into warehouse.
• Analyzing the specifications and identifying the source data that needs to be moved to the data warehouse
• Worked with various transformations to load data from ODS to data warehouse SAP BODS .

Environment: SAP R/3 4.7. SAP ECC 6, BI 3.5/7, Crystal Reports 2008, SAP BO 3.1,SAP BO Data Services 3.1, MS SQL Server 2005/2008, Oracle 10g, BPC 7.5 and Remedy

Confidential

SAP BI Analyst

Responsibilities:

• Requirements gathering from users; involved in preparation of Design documents for BW.
• Created generic extractors based on view, info set query
• Sole Responsible for following areas: COPA, Purchasing and Secondary Sales
• Analyzed query usage statistics and BW System statistics information using ST03N.
• Worked on Generic Data Extraction tool (RSO2) to create Data Sources for transaction data
• Created ODS objects to stage the data before transferring from Info source to the Info cube.
• Integrated Secondary Sales (SQL Server) using UD Connect
• Created Enhanced Standard Purchasing Cubes
• Designed and developed reports using the query designer. The reports included variables, variants, restricted key figures, calculated key figures, formulas, structures, exceptions, and filters.
• Extracted data from SAP R/3 system (FI/CO, SD, MM, HR-PA,PD and Payroll) into SAP BW system through CO-PA, FI-GL and Generic R/3 data extraction techniques.
• Activated and installed standard Business Content for FI/CO, HR, SD and MM Info Cubes like Accounts Payable: Line Items, Transaction Data (Profit Centers), Statistical Key Figures, Sales Order, Sales Delivery cube.
• Loading Data from Flat File (as the Source System.) in to BW.
• Deletion of PSA data, change log data as per the request of the business analysts
• Reconstruction of Data Targets DSO’s from PSA

Environment: SAP BI 7.0 Net Weaver 2004 /BW 3.5, SAP R/3 4.6C, ECC 5.0, BEx, Oracle 10g, and SQL Server 2003

Confidential

SAP BW Associate

Responsibilities:

• Performed data extractions from SAP R/3 and Non-R/3 systems to BW.
• Worked extensively on LO Cockpit extractions.
• Used both initializations delta update and full update methods.
• Optimized load performance by adjusting packet sizes, data selections and number of info Packages.
• Developed, generated reports in SD, FI/CO and MM modules to Client’s specifications using SAP BW BEx Analyzer.
• Involved in the Business Process study and Identifying the reporting requirements
• Query development using BEx Analyzer/Browser, Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way
• Created custom cubes, Multi Cube for customer and vendor cycle core returns, sales order item/quantity Sales order header for fill rates, custom ODS, Custom Info Sources
• Worked on standard Info Sources from the Business Content for MM - Purchasing for Transactional data
• Created Aggregates, worked on Performance Tuning and Production Support
• Requirements gathering from users; involved in preparation of Design documents for BW.
• Created generic extractors based on view, info set query
• Sole Responsible for following areas: COPA, Purchasing and Secondary Sales
• Analyzed query usage statistics and BW System statistics information using ST03N.
• Activated and installed standard Business Content for FI/CO, HR, SD and MM Info Cubes like Accounts Payable: Line Items, Transaction Data (Profit Centers), Statistical Key Figures, Sales Order, Sales Delivery cube.
• Loading Data from Flat File (as the Source System.) in to BW.
• Deletion of PSA data, change log data as per the request of the business analysts
• Reconstruction of Data Targets DSO’s from PSA

Environment: SAP BW 3.0b, SAP R/3References: Available On Request