Santhosh Rai

Ph: 713-***-****

Email: adchdq@r.postjobfree.com

Summary:

SAP BW/Hana Lead Consultant

Experienced SAP (BW&HANA) with more than 14 years of project experience.

Experience includes multiple SAP BW on SAP HANA database and BWHANA mixed modelling dashboard development

Motivated and results-driven BI Developer with a proven track record in Business Intelligence (BI), Data Warehouse (DWH) and Data Analytics related consulting projects.

Hands on experience with Theobald Software, Infobright, Tableau Desktop, Microsoft PowerBI, Sap Lumira.

Experience in working with SAP BOBJ, SQL Server(SSMC), SSIS, SSRS, and SAP HANA

Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy.

Experience with ASAP Methodology – Project requirement, Business blue prints, Realization, Final preparation, Go live and support.

Experience with Agile methodology.

Hands-on experience in analysis, architecture, implementation, migrations, upgrades, and production support of end-to-end SAP Business Intelligence environments including front-end BI (Business Objects), back-end (BW and HANA DB), Web Intelligence (WebI), Analysis for Office and Dashboards, Design Studio, and HANA DB connector.

Deployment of Business Objects solutions for corporate reporting using Webi Reports

Designed and implemented SAP BW, SAP BW on Native HANA and standalone SAP HANA data models using Advanced DSO, OPD’s, Open ODS View, and Composite Info Providers (mixed modelling HANA and BW data) using HANA Views.

SQL complex stored procedure in native hana, materializing data in native hana, delta logic, Windows functions in Sap Native Hana.

Good Knowledge SAP Native HANA. Experience HANA data modeling using Attribute View, Analytical view and Calculation view Experience in SAP HANA Data Provisioning using SAP LT Replication Server (SLT ) and Data services Knowledge.

Extractions - Extracted data from COPA, FICO, LO Logistics Cockpit and Generic Data Sources from Views.

Customizations - Experience in activating standard Business Content, extending and enhancing InfoCubes according to the requirements, Datasource Enhancements, User Exit Variables, Virtual Keyfigures, Start Routines and Formula Builder.

Familiarity with Business Objects suite, BWA and HANA.

Experience with Integrated Planning and or BPS.

BEx Reporting- Expertise in front-end Business Warehouse components for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions.

Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Performance Tuning, Aggregates, BW Transports.

Production Support: Extensive experience in support, Data loads, Validation and troubleshooting of transaction data and Master data, Change management, Transport Management, Roles & Security.

Education: Master’s Degree in Computer Sciences.

Technical Skills:

Languages: ABAP/4

SAP HANA: SAP HANA 1.0 & Design Studio.

ERP: SAP R/3 3.1, 4.0, 4.5B, 4.6B, 4.6C, 4.7, ECC 5.0, ECC 6.0

Data Warehouse Tools: SAP BW 7.5, 7.4, 7.3, 7.0, BW 3.5.

Cross Applications: ALE, IDOCS, RFC, LSMW, EDI.

Reporting tools: Bex Analyzer, WAD, Tableau Desktop, Tableau Server, Business Objects, Microsoft PowerBI, Sap Lumira, and Cognos 10.0.8.

RDBMS: Oracle 8i, DB2, SQL server 7.0.

DBMS: Info bright.

Summit Electric Supply, Albuquerque, NM Apr’19 to till date

SAP BW/Hana Lead Consultant

Created Sales Manager Dashboard, Daily Margin Dashboard, Service center Dashboard,

Account manager Dashboard.

Built Generic Data Sources to load the data from the flat file.

Created user and assigned roles to groups.

Created web based url iView’s and iView’s for sap applications.

Created Work set, role and assigned role to the user.

Enabling single sign-on.

Created Iviews based on Bex report and BO reports and published in the portal.

Created Test roles and Training roles assigned the dashboards to the respective role.

Bex Broadcasting.

Validated the data in Dashboard.

Created openhub to create a flat file for NAED to send it to the business.

Worked on report changes as per the business needs.

Enhanced data sources to bring the goal data to dashboards.

Created 0profit_ctr Hier and 0sales_off Hier utilized instead off service center.

Pulled Purchased order data with Pricing Condition to BW.

Created the financial sets for 0gl_account and replicated the changes in the dashboard.

Applied Materials, Santa Clara, CA Dec’18 to Apr’19

SAP BW/Hana Lead Consultant

Involved in INSIGHT project for preparing the Business Blueprint documents

Involved in preparing the AS-IS Analysis documents

Working on LSA 2.0 Architecture

Created EDL Objects in EDX and migrated the objects to BWX and built data flows for Master Data and

Transaction data

Worked with Master data for different areas like FICO, SD,MM

Created Generic Data sources from Views

Created Local and Meta Process Chains for all Master and Transaction data flows

Involved in transportation Activity in BW* landscape

Scheduled the data loads in BW* landscape and tested the data

Involved in NEWBI Application support.

Monitored Process chain (Daily, Weekly, Monthly, Quarterly and on Demand loads in BWP System)

Involved on converting DSO to in-memory DSO, SAP NetWeaver BW7.3 Powered by SAP HANA

Optimized BW Cubes for HANA Purpose

Prepared the COM Documents for Different Content Area.

Involved in CSS message ticket handling for NEW_BI_SUPPORT Component and IT Component after

Environment: SAP Native Hana, SAP NetWeaver BW7.3 Powered by SAP HANA, SAP ECC 6.0.

Chico’s FAS, Fort Myers, FL Sep’18 to Dec’18

SAP BW/Hana Lead Consultant

Hyperion Migration Project.

Worked on APD’s to extract data from query to load data DSO.

Extraction of data from SQL tables (Ecommerce data) to SAP BW.

Created Info objects, ADSO’s, Composite Providers per the data model.

Integrating BW reports and BO Reports in to Enterprise Portal.

Defined several transformations as per the need.

Used Transport Manager to perform transports.

Performed BW Master and transaction data loads on required basis.

Created and scheduled Process chain for daily Delta loads.

Provided support for data load, validation, performance monitoring and tuning.

BW Data load scheduling, monitoring and troubleshooting data extraction / load problems.

Environment: SAP NetWeaver BW7.5 Powered by SAP HANA, SAP HANA, SAP ECC 6.0

BJ’s, Westborough, MA Apr’18 to Sep’18

SAP BW Lead Consultant

Created Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need. Performed clean-up activities for the premigration of BW on HANA implementation. Optimized BW cubes for HANA purpose.

Extraction of COPA from BW to enterprise planning system.

Used Transport Manager to perform transports. Maintained Ztables in BW to load Master data. Performed BW Master and transaction data loads on required basis. Created and scheduled Process chain for daily Delta loads.

Multidimensional Data Model using Extended Star Schema designed and developed Info cubes, DSO, Info Source and Data Source. Used Open Hub for exporting data out of SAP BW into other formats. Created Start Routines, Transformation rules for DSO and Info Cubes.

Created IView’s from sap Applications. Created a web report in the portal.

Created work set and Role.

Provided support for data load, validation, performance monitoring and tuning. BW Data load scheduling, monitoring and troubleshooting data extraction / load problems.

Environment: SAP NetWeaver BW7.5 Powered by SAP HANA, SAP HANA, SAP ECC 6.0

Zekelman Industries, Chicago, IL Aug’17 to Mar’18

SAP BW Lead Consultant

Assessed project requirements defined by customer, including desired reports and performance expectations. Conducted interviews with clients to solidify the required business rules and fact-finding sessions with continued reviews throughout the project lifecycle.

Created full functional requirements for the development team. Developed report specs according to customer requirements.

Created BEx queries to simulate/validate results achieved from Cognos query. Per customer requirement, this approach was also used by the customer to gauge performance differences between Cognos and BEx.

Created and maintained all Framework Manager multi-dimensional models and packages while applying security to the Framework Models and packages.

Responsible for researching Cognos Software fixes patches and developing an implementation schedule for installation and maintenance issues or upgrades of Cognos software. Created and fine-tuned Infoqueries leveraging business rules in BW to minimize load on Cognos BI.

Environment: SAP NetWeaver BW7.4 Powered by SAP HANA, SAP HANA, SAP ECC 6.0, Cognos

Orion Engineered Carbons, Houston, TX Mar’17 to Aug’17

SAP BW Lead Consultant

Gathering and Assessment of requirements from Business Users.

Supporting the technical Applications and works.

Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.

Identified the reports for conversion.

Applied the conversion type from local to global currency.

Working on Functionality Development, Dashboards Creation, Reports and Documentation

Worked on extractors, routines, modeling, enhancements, migration, support issues, process chains, performance related issues and BEX reports.

Environment: SAP NetWeaver BW7.4 Powered by SAP HANA, SAP HANA, SAP ECC 6.0

SAP America, Newtown Square, PA Jun’15 to Jan’17

SAP HANA/BW Lead Consultant

Worked as Technical Architect on this project apart from handling and executing technical part of the project, Managed the project timelines including Critical path, baseline and resource onboarding.

Worked on reports like fast moving items, slow moving items, net profit and profit contribution.

Worked on Native HANA and SAP BW powdered by HANA

Worked on SAP HANA Data Provisioning (LT, DS), Data Replication, Modeling and Reporting

Designing SAP HANA Architecture & Landscape

Involved in designing Dataflow from SAP ECC 6.0 to SAP HANA Database

Involved in Transporting HANA Views from Dev to Pro using Delivery Units

Have hands on experience on modeling in creating Attribute, Analytic and Calculation Views

Worked on mixed scenarios between BW and HANA

Worked in Designing the BW models specific to HANA

Environment: SAP NetWeaver BW7.4 Powered by SAP HANA, SAP Native HANA, SAP ECC 6.0, Business Objects.

Summit, Albuquerque, New Mexico Jun’11 to May’15

SAP BW Consultant

Involved in Secondary sales reporting.

Adopted the simpler and cost-effective process to solve reporting performance issues.

Performance tweaks to reports due to high volume was resolved using Theobald Software, Infobright, and Tableau Desktop Integration.

Integrate SAP BW system with SQL Server Integration Services, extracted mass data with high performance and stability.

Data migrated from SAP BW to flat files and moved to Infobright which is a column-oriented analytical data warehousing technique built on MySQL

Connect Tableau to a MySQL database (Infobright Table) and set up the data source for analytics.

Maintained Ztables in BW to load Master data. Performed BW master and transaction data loads on required basis. Created and scheduled Process chain for daily Delta loads.

Troubleshooting data and technical issues related to SAP BW. Managed Client BW environment to co-ordinate development, testing and transports to Production.

Developed the reports in Tableau that are similar to reports in Business Objects.

Environment: SAP BW7.0, SAP ECC 6.0, Theobald Software, Infobright, tableau, Sql Server, SSIS.

Bayer, Pittsburgh, PA Oct’09 to Apr’11

SAP BI/BW Consultant

Involved in ERPDAY 2 project which is the integration of Bayer Health Care with Berlex.

Modification of BW Data Model to remove hardcoding of company code, controlling area as new company code 2083 is introduced.

ERP Day2 integration of C21 to U8P. Any hardcoded values for company codes, chart of accounts, controlling areas, to be revised to dynamic values for Company Code, Controlling Area as new company code 2083 added into the system with new cost centers, sales orgs, materials.

Extensively used ABAP Conversion Routines in Transfer Rules and Update rules

Involved in BW load/Query performance optimization.

Built Multi-providers, Aggregates to suit the business and reporting needs.

Involved in UAT (User Acceptance Testing) and Regression Testing for the reports developed on ERPDAY2

Participated in support activities including resolving tickets within the defined SLAs.

Environment: SAP BI, BW 3.5, SAP ECC 6.0, R/3, Flat Files, ABAP/4, and Windows

PepsiCo, Chicago, IL Dec’08 to Sep’09

SAP BI/BW Consultant

I have worked with Pepsi 1UP Team which was implemented by Accenture and they have couple of issues with the reports developed.

Developed new Queries on various Info Cubes related to CRM.

Extensively worked with Query building, Filtering, Structures, and Free Characteristics, Calculated Key Figures, Restricted Key figures and Variables.

Resolving Trouble Tickets on various issues like changes to the existing reports, creating new reports according to the end user requirement.

Created several reports like Equipment Location Report - Forecast Service Orders, Parts Reconciliation Report, and Warranty Report.

Worked on configuring the change request as per business requirements.

Environment: SAP BI 7.0, SAP ECC 6.0, CRM, Flat Files, ABAP/4, and Windows.

Bayer, Pittsburgh, PA Feb’07 to Nov’08

SAP BI/BW Consultant

Performed changes to the existing queries depending upon the end-user requirement.

Developed new Queries on various Info Cubes related to SD, MM and FI. Extensively worked with Query building, Filtering, Structures, and Free Characteristics, Calculated Key Figures, Restricted Key figures and Variables.

Created several reports like Sales analysis, Customer Profitability Analysis, Income Statement Toolkit, Top N ship to party and Top N Unpacked Goods, Income statement details-timeline, date range, year to year comparison.

Performed translation from English to German as per business requirements.

Worked on BEx Broadcasting to send the Sales order as an Email to Business scheduled every day, HTML as output format with Zip enabled.

Environment: SAP BI, BW 3.5, SAP R/3 4.7, Flat Files, ABAP/4, Windows.

Parkside Requirement. Apr’04 to Dec’06

BW Consultant

Involved in one Full Life cycle implementation.

Configured new business scenarios concerned to Sales, Shipping and Billing.

Expertise in solving the locking problems due to Parallel processes.

Involved in Data Source, Business Content, Transactional and Master Data Enhancements.

Extensively used RSA3, RSA7 to check the data extractor and delta upload.

Involved in the system Upgrade Process from SAP BW 2.1 C to SAP BW 3.0B.

Environment: SAP BW 2.1C/3.0B, SAP R/3 5.0 C, ABAP/4, MM, SD, FI/CO, Oracle and UNIX.

Schenker AG, Essen, Germany May’03 to Mar’04

ABAP Technical Analyst

Configured Workflows to initiate manually when Materials are to be updated.

Worked on Reporting on Workflow Progress, Performance, and Work items by Processing Duration.

Worked on Reporting on Agent behavior.

Configured RFC Destination and debugged RFC connections for Workflow to Connect WM and MM.

Developed user exit to before saving to Purchase Order (ME21N) to check and make the changes if necessary to header text entered by user (while creating the PO).

Environment: SAP 4.6B, ABAP/4, SD, MM and PP Modules, Oracle.

Sadre AG, Braunschweig, Germany. Apr’01 to Feb’03

SAP Technical Consultant.

Understanding the functional specifications and preparing the Technical Specifications.

Developed classical and interactive reports using ALV’s.

Developed BDC program for the Customer Master, Material Master and Vendor Master.

Developed BDC program to change Vendor details using XK02.

Environment: SAP 4.6B, ABAP/4, SD, MM and PP Modules, Oracle.

Immigration status: H1B

Nationality: Indian

https://www.linkedin.com/in/santhosh-k-rai-4944467/

Contact this candidate