Aramco Data

SUMAN PABBATHI

Phone: +* (***) *** – **** Email: *******@*****.***

SAP CERTIFICATION

SAP Certified - Reporting, Modeling and Data Acquisition with SAP BW/4HANA 2.x

SAP Certified - SAP Analytics Cloud: Planning

SAP Certified - SAP Activate Project Manager

AWS Certified Developer – Associate

PROFILE SUMMARY

14 years of experience in SAP BI BW4HANA NATIVE HANA SAC DATA SPHERE.

SAP SAC/BIW/BI/BPC/BW4HANA/NATIVE HANA/SAC 11 Full Live Implementations and 3 Global Production Support projects.

Expertise on SAC (ETL/Model/Analytic Cloud reporting).

Expertise in gathering business requirements (Extensively worked with Core team), systems analysis, systems design & solution architecture, developing solutions for complex business applications through all phases of the system development life cycle including analysis, design, configuration, development, testing, production support/maintenance functions, end-user training, prepared Functional/technical design Documents, prepared SIT/UAT test scripts, cutover activity, hyper care for production support.

Extensive experience in data modeling and preparing datasets, merging, appending, hierarchies, custom calculations, formatting values, data wrangling, dimensions and measures.

Experience in creating stories canvas, grid, Smart Discovery, advanced story designing blending data, formulas, cross calculations, input controls, linked analysis.

Well versed in visualizations and their usage charts, tables, maps, filters, dropdown menus, hiding functions, interactive objects, pictures.

Experience in SAP BI - involved from design phase to go - live. Extensively involved creation of Functional Spec to Technical Specs and System Integration Test Scripts / User Acceptance Test Scripts.

As an Architect provide the solution as part of end-to-end implementation.

Expertise in SAP BW Data Modeling (BW 3.X, BI 7.x and BW4 HANA): Design and Development of BW Data models (Advanced Data Store Objects ADSO, Open ODS, Composite Provider, Calculation views, SDA, SDI, SLT, Data tiering, Data flows...Etc.).

Extensive experience in loading the data from S/4 HANA, R/3, ECC, Oracle, BODS, 3rd party & legacy systems – Inbound and Outbound across system.

Extensive experience in Data Modeling, Extraction, Cleansing, Loading, Scheduling, Monitoring, Delta Management, Reporting, troubleshoot issues with data integrity and User, Authorization & Security administration.

SAP FI – AR/AP Account Receivable / Payable build report replica of SAP OLTP.

Worked on SAP Supply Chain MM Material Management / Inventory aging reports, purchasing reports.

Organized several GFT (Green Field Training) programs on SAP BW and BW/4 HANA also for lateral joiners.

Demonstrated ability to communicate with all levels within in a business environment, Handled single resource onshore/offshore model.

Strong work experience with Extraction, Modeling, Bex Query Designer, Workbooks, APD, Query as info provider, OHD, RFC function module and WAD.

A highly motivated, energetic and professional team leader with excellent analytical, problem-solving skills and ability to interact with individuals at all levels

Worked on Transportation, Plant Maintenance, Production Planning standard business content.

Expert in handling P1 to P4 incidents and resolved the incidents within SLA timelines.

As a SME provide the solution across the projects. Involved in data migration.

Guide the team for implement the solution and to meet the deliverables.

KEY SKILLS

~ Requirement Gathering/Analysis ~ Business Model Designing

~ Training, Mentoring & Development ~ Data Staging (ETL Process)

~ Data Modelling ~ Building Reports

~ Quality Management ~ Product Support & Enhancement

~ Reporting and Performance Tuning

IT SKILLS

Visualization Tool

Software

ERP

Reporting Tool

SAP Analytics Cloud (SAC)

SAP BW 3.x/7.0/7.3/7.4/7.5, BW on HANA, SAP BW4HANA, Native HANA, EPM 10

SAP ECC 6.0, S/4 HANA

Bex, Query Designer, BOBJ (WEBI), Powerbi, Analysis for Office (AFO)

WORK EXPERIENCE

ETEK IT Solutions Inc

Jan 2022 – Till Date

HCL TECHNOLOGIES LTD

Dec 2020 – Aug 2021

ACCENTURE SOLUTIONS PVT LTD

OCT 2008 – OCT 2020

RAFFLES SOLUTIONS PVT LTD

JAN 2008 – MAY 2008

EDUCATION

MBA from Vinayaka Mission University.

Bachelor of Commerce in Computer Applications from S.V. University.

SAP ANALYTICS CLOUD(SAC)

Involved in Early decisions – Informing Business the possibilities of their requirements at early stage of the project.

Collaborate with Functional, Business Teams to understand the requirements.

Conduct sessions with technical teams, communicate business requirements to teams.

Understanding the Limitations of SAC, Estimating the Complexity of Dashboards and thereby measuring the timelines to build the dashboards.

Ability to design different solutions based on sources and connection types without compromising on performance.

Cleaning and validating the data to ensure accuracy, completeness and uniformity

Exposing SAP BW/S4/HANA Data Models into SAC using Live connection.

Created Dashboard story in SAC using Responsive pages.

Worked on BPC Project – Write Back Functionality to BW tables.

Display story in Mobile SAC app using Responsive pages.

Manage User creation in SAC and assign roles to individual users.

Good Understanding SAP Analytics Cloud Content. Implemented stories using different features of SAC.

Implemented complex calculations in SAC stories. Consume CDS views into SAC.

Have good understanding on Planning Tools like What if analysis, Value driver tree simulation.

Advanced Planning functions like Data Actions, Allocations, Distributions & Spreading.

Forecasting by combining actuals plus Plan, Predictive Forecasting, Trend Analysis

BW4HANA

Involved in requirement gathering for development, Data modelling and designing reports as per the requirement. Also Involved in Installing BI Technical Content.

Installed Business Content for standard / custom Info objects, Advanced DSO and Composite Providers, Calculation Views etc.

Gathering requirements from multiple stake holders, convert into FS, prepare TD, create SIT/UAT scripts.

Worked in Logistics Extractors, data loading and delta management.

Good Understanding on concepts like SLT, SDI, SDA, Open ODS views, LSA++

Extract data from SAP ECC, S/4 HANA, BW, Legacy systems like Blue Yonder, Logility etc.

Extensively worked on Data Pull / Push mechanism SAP vs non-SAP.

Responsible for planning cut-over activities for the go-live support for the development work.

Worked on enhancements and resolved basic support problems.

Extensively worked in Production Support projects with various Manufacturing & Food Processing.

Experience in working with Ticketing tools like Service Now, HP Service Management & JIRA tools.

Experience in working with Testing tools like HP ALM.

Assigned and resolved open tickets within SLA timelines.

Monitoring tools like Autosys, Solution manger.

Experience Summary

Reynolds Consumer Products

Implementation

Feb ’22 – Till Date

Florida Crystal

Support / Development

Dec ’20 – Aug ‘21

Toronto Hydro

Implementation

July ’20 – Oct ‘20

British Telecom

Implementation

Nov ’19 – Jun ‘20

Alstom

Support / Development

Feb ’19 – Nov ‘19

T-Mobile

Implementation

Mar ’17 – Jan ‘19

Astellas (Pharmaceuticals)

Support / Development

Jan ’16 – Feb ‘17

Saudi Aramco

Implementation

Nov ’14 – Jan ‘16

Hostess Brands

Implementation

Jan ’14 – Nov ‘14

SAB Miller

Implementation

Sept ’13 – Jan’14

TELUS

Implementation

Nov ’12 – Oct ‘13

SAB Miller Global

Support / Development

Apr ’10 – Oct ‘12

SAB Miller

Implementation

Jul ’09 – Apr ‘10

Canadian National Railways

Implementation

Oct ’08 – Jun ‘09

Competitive Intelligence

Implementation

Jan ’08 – May ‘08

PROFESSIONAL EXPERIENCE:

ETEK IT Solutions Inc (Implementation) Reynolds Consumer Products Feb ’22 – Till Date

Responsibilities:

Implanted Demand Planning / Supply Planning solution in BW4HANA, build stories in SAC dash boards.

Experience in developing Planning & Analytical model in SAC. Consume HANA views, SLT tables & Flat Files for ETL.

Good understand & experience in SAP Data Sphere.

Extract Planning data into BW from Planning tools – Logility, Blue Yonder via share point, pull & push mechanism.

Create Functional specs based on BRD business requirement document, technical specs, unit test scripts (SIT/UAT). Prepare cut over documentation for go-live.

Develop the existing BW solution into HANA and SAC data modeling & Dash boards.

Migrating Bex, BOBJ, AFO queries into SAC Stories.

Migrate BW data flows into HANA views and consume HANA views into SAC.

Configure Live connection / Import connection consume SAP / Non-SAP source into SAC.

Consume difference sources data sets and build single dash boards using link dimension.

Configure connection between SAP HANA to SAC.

Extensive experience in data modeling and preparing datasets, merging, appending, hierarchies, custom calculations, formatting values, data wrangling, dimensions and measures.

Created Live connection and consume existing BW4HANA queries.

Well versed in visualizations and their usage charts, tables, maps, filters, dropdown menus, hiding functions, interactive objects, pictures.

Created Dashboards by consuming Calculation Views & Bex Query from HANA.

Config Planning models using Import connection, copy data from actual / forecast / plan data and create new version. Create Autosys jobs for data loads in across systems.

Consume data source, data sets from SAP & Non-SAP (AWS/Azure/Google etc..) into Data Sphere.

Integration, cataloging, semantic modeling, data-warehousing, and virtualizing workloads for SAP and non-SAP data into Data Sphere.

HCL (Support / Development) Florida Crystal Corporation Dec ’20 – Aug ‘21

Responsibilities:

Experience in developing Planning & Analytical model in SAC. Consume HANA views, CDS Views & Flat Files for ETL.

Configure connection between SAP HANA to SAC.

Create calculation views (Virtual tables, base views, reuse views, reporting views).

Extensive experience in data modeling and preparing datasets, merging, appending, hierarchies, custom calculations, formatting values, data wrangling, dimensions and measures.

Created Live connection and consume existing BW4HANA queries.

Experience in creating stories canvas, grid, formulas, cross calculations, input controls, linked analysis.

Well versed in visualizations and their usage charts, tables, maps, filters, dropdown menus, hiding functions, interactive objects, pictures.

Created Dashboards by consuming Calculation Views & Bex Query from HANA.

Copy data from Actual / Forecast / Plan data and create new version.

Experienced SAC as a planning tool, creating planning data models and working with categories actual, budget, planning, forecast, rolling forecast, predictive capabilities.

Worked on Predictive Scenario based on Measure.

Import and export data with in SAC and non-SAP.

Extraction Data load to SAC from flat file and SAP HANA.

Familiarity with analytic applications and analytic designer, screen layout, widgets.

Worked on HANA Views, HANA Modeling.

Accenture (Implementation) Toronto Hydro July ’20 – Oct ‘20

Responsibilities:

Template creation for TSD / SIT / UAT / Cutover activities.

Handling BW/BO team – responsible for end to end (Documentation / build / SIT / UAT / Go-Live).

Created TSD / UT / SIT documents based on FSD. Focused on Asset Accounting (AIPP/FA Continuity Schedule (AR02), Construction WIP, Asset Capitalization ECC report convert into BW Bex reports).

Provided complex solution for Asset Accounting / Account Receivable - Business require current data as well as historical data, identified field, tables, data source suits for historical data from ECC.

build data model E2E (enhance standard/custom sources in ECC/HANA VIEWS, create new BW data flow and BW Bex super query & WEBI). Taken care of cutover Activates (TR – TOC and data loads in across systems).

Created Live Connection/Import Connection, build Live/Import Model for Planning purpose.

Created MD/TD (Dimensions/Models) data flows, take care of complete ETL in SAC.

Expert in transformation, create calculated columns, transpose measures.

Created HANA Views for BOBJ Webi & SAC reports.

Created Virtual tables, base views and final report views in Native HANA.

Creation Story and Dashboards in SAC.

Maintain SIT / UAT defect tracker and update the UAT defect status in HPALM.

Accenture (Implementation) British Telecom Nov ’19 – June ‘20

Responsibilities:

Template creation for LDM (Logical Data Model), BW objects TD, Test Scripts, AFO.

Handling BW team – responsible for end-to-end ChaRM process in BW4, prepare TD, Test Scripts, AFO, LDM.

Delivered financial related reports Gross Profit, Profit & Loss, Balance Sheet, Corporate Function.

Other than project deliverables supported to other projects as a SME and trainer for SAP BW GFT trainings.

Create HANA Views for SAC Stories & BOBJ Webi reporting.

Consume HANA Calculation views via live connection.

Worked on interface for hierarchies from Non-SAP to SAP via BODS.

Configured virtual tables related to CFIN (Central Finance) using SDA.

Configured ADSO, Composite Providers, Views, Bex Queries and feed to AFO as well as SAC reports.

Used ACDOCA (0FI_ACDOCA_10), configured virtual tables for entire project.

Ownership on ChaRM end to end until go-live for phase 1.

Created Live Connection/Import Connection, build Live/Import Model for Planning purpose.

Created MD/TD (Dimensions/Models) data flows, take care of complete ETL in SAC.

Configured ETL (MD/TD) connection, created Model using Live Connection, Acquired Model using Import Connection.

Expert in transformation, create calculated columns, transpose measures.

Creation Story and Dashboards in SAC.

Create story based on Bex query, using link dimension to accommodate user requirements.

Create charts, tables, story, dash board.

Accenture (Support / Development) ALSTOM Feb ’19 – Nov ‘20

Responsibilities:

Handled entire BI lead activities / project management activities (resource recruitment, one single POC for BI).

Responsible for Daily / Weekly / Monthly / Yearly data loads – Optimized 15 hours to 6 hours data load time. Got appreciation from Accenture Leadership as well as from Client.

Implemented successfully CI on special char issue it got significantly reduced daily / weekly occur issues.

Provided RFP / CR estimations and participated in the bid other than support activities.

Handled P1/P2 tickets and implemented permanent solution for P1/P2 and got significantly reduced P1/P2.

Groomed the juniors and peers, with in a minimal span of time they handled the issues individually with minimal supervision.

Owner ship on creation of Project Plan, MSPS / My Wizard creation and prepare base line activities for across SAP teams.

Handled CR for existing & new report functionalities, responsible for end to end till deploy the CR.

Support for existing BOBJ Webi & Powerbi reports, enhance the reports as part of change request.

Accenture (Implementation) T-Mobile Apr ’18 – Jan ‘19

Responsibilities:

Part of T-Mobile – Slovak Telkom SAP BI - Implementation.

Handling team lead activities / project management activities (resource recruitment) and as a Developer.

Gathering requirements from onshore and assign objects to offshore.

Whole responsible for SAP BI deliverables from offshore point of view.

Provided Functional Specs/Technical Specs/Unit Test Scripts/Naming Convention/Process - templates.

Prepared - Functional/Technical/Unit Test documents. Co-Ordinate with client team in finalizing the BW interface requirements.

As a SAP BI – Lead, helping entire team and grooming junior resource.

Other than project deliverables supporting to other projects as a SME and part of Accenture Empanel.

Created BOBJ Webi reports, source as a Bex Queries.

Implemented complex BW interfaces between SAP to SAP and SAP to Non-SAP applications.

Accenture (Implementation) T-Mobile Mar ’17 – Mar ‘18

Responsibilities:

Part of T-Mobile - Czech Republic Telkom SAP BI - Implementation.

Handling team lead activities / project management activities (resource recruitment) and as a Developer.

Gathering requirements from onshore and assign objects to offshore.

Whole responsible for SAP BI deliverables from offshore point of view.

Provided Functional Specs/Technical Specs/Unit Test Scripts/Naming Convention/Process - templates.

Prepared - Functional/Technical/Unit Test/Cut Over documents. Co-Ordinate with client team in finalizing the BW interface requirements.

As a SAP BI – Lead helping entire team and grooming junior resource.

Other than project deliverables supporting to other projects as a SME and part of Accenture Empanel.

Implemented complex BW interfaces between SAP to SAP and SAP to Non-SAP applications.

Created BOBJ Webi reports, source as a Bex Queries.

Got huge appreciations from Client as well as Accenture Leadership for Interface success.

Accenture (Support / Development) Orion Astellas - Pharmaceuticals Jan ’16 – Feb ‘17

Responsibilities:

Responsible for Ascend (Japan) and AUS (USA) regions SAP BI - HANA - AO support activities.

Handling team lead activities and project management activities.

Stabilized USA region daily/weekly/monthly activities (data loads activities/reconciliation ECC vs BI).

Data loads which is took around 10 hours, after optimization it came down to 5 hours. (Save 5 hours daily overall project level).

Received Award from client Director as well as couple of Awards from Accenture leadership and huge appreciations from client/Accenture leadership.

Handling Service requests/tickets/minor enhancements.

Taking Continuous Improvement initiative and delivered successfully.

Received Award from client and got appreciations from onshore stakeholders as well as Accenture leadership.

Involving BO/BODS/HANA Live - AO support activities.

Accenture (Implementation) Saudi Aramco Nov ’14 – Jan ‘16

Responsibilities:

Part of SAUDI ARAMCO eSight implementation - WS4 Single BI/BW on HANA Developer resource and single point of contact for BI on shore.

Using BI 7.4, EPM 10 and HANA technologies. Singlehandedly worked on analysis, design, build, test and deployment phases for all BI interfaces.

Gathering requirements and providing estimations, full fill the gap analysis for non-SAP to SAP / Non - SAP to SAP Interfaces.

Worked end to end implementation as well as till post go-live support.

Prepared Functional/Technical/Unit Test/Cut Over documents. Co-Ordinate with client team in finalizing the BW interface requirements and get sign off for all the documents.

Implemented complex BW interfaces between SAP and Non-SAP applications. Received STAR award from Saudi Accenture leadership.

Successfully delivered BW on HANA interfaces project in e-Sight Saudi Aramco.

Configured inbound / outbound interface ECC vice versa BW vice versa BPC.

Accenture (Implementation) Hostess Brands Jan ’14 – Nov ‘14

Responsibilities:

Single Developer resource and single point of contact for BI offshore.

Handling team lead activities and project management activities.

Independently worked on design, build, test, deployment and PGLS phases for all BI interfaces.

Involved in requirement gathering and providing estimations.

Prepared Functional design, Technical design and Test scripts and Executed BI objects test scripts.

Provided estimations for CR's, Enhancements. Resolved the production incidents within the SLA.

Delivered 50 reports (SD, FI, CO, MM, PP) and 15 workbooks.

Monitored the daily data loads and reconciled BI reports against ECC as part of Pre and PGLS.

Accenture (Implementation) SAB Miller Flash Sept ’13 – Jan ‘14

Responsibilities:

Involved in gap analysis for SD and FI modules against existing legacy systems.

Installed HANA optimization BI objects.

Prepared FI and SD Functional/Technical specs, test scripts and executed in HP ALM (11.0 version).

Created HANA optimized objects. Managed BI team by distributing the tasks properly to team members.

Handled onshore and offshore co-ordination. Worked on Non-SAP systems using Data Services (BODS).

Designed BODS jobs for BI HANA. Managed BI team by distributing the tasks within the team members.

Accenture (Implementation) TELUS Nov ’12 – Sept ‘13

Responsibilities:

Single point of contact for 3 BI Projects and led offshore team.

Implemented BI - SD, MM, HR, FI and CO modules from scratch. Extended BI SME support to other projects in DU to resolve the critical issues.

Expertise in Data Model and BI reporting. Received IDC level Individual Accelerate Award month of Sept 2013.

Handled Support and Implementation projects parallel. Implemented BI for Guatemala & Manila BI - BPC consolidation related data modal.

Monitoring Data loads handled the issue while monitoring time for Corp, I&L & FDM projects.

Incident Management: Handled the Incidents and to resolve the issues within SLA.

Supporting SME to onshore team for other projects FDM & I&L (providing solutions in BI related issues). Handle the Network issues while monitor time month end loads, weekend loads and AD-hoc loads.

Participated Estimation in the Implementation & CR's stuff.

Supporting to BPC team inbound & outbound process chains stuck & explaining the Functionality of BI data modal.

Received Star Awards from project level as well as Stellar Award from IDC level.

Helped to Basis & BPC teams related BI issues.

Accenture (Support / Development) SAB Miller Global Apr ’10 – Oct ‘12

Responsibilities:

Having on shore experience on pre and post go live (PGLS) activities.

Successfully completed R0, R1 & R2 Go-Lives. Supported from On-Shore R0, R1 Go-Live & PGLS activities.

Extraction of Data on Daily/weekly/Monthly basis from various R/3 and Non-R/3 System to BW system.

Maintain Incident Tracker (Assigning the tickets related team), Managing the Monitoring team.

Supporting technically within the team, Handle the Network issues while monitor time month end loads, weekend loads and Adhoc loads.

Training to ASE's Data load monitoring and How to resolve the incidents, explaining the Functionality of the different reports and data models.

Participating Estimation in the CR stuff, supporting to BO team (when they are struck related BEx, Query Designer and WAD issues) explaining the Functionality of the Reports.

Helping to Basis team, BPC & MDM team related BI issues, Participated with On - Shore team Release0, Release1 & Release 2 Cut over Activities.

Having very good knowledge on support activities.

Managing the team activities and handling the client and supporting to onsite coordinating team.

Supporting enhancements and resolve the issues within SLA.

Monitoring of Info packages and analyzing the reasons for frequent failures of Infopackages.

Maintaining Work History for all the tickets until it is closed.

Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads.

To inform the onsite people with detailed dashboard details, if there any delay completion of data loads.

To communicate with the customer who posted the Ticket.

Collecting the load failure information and analyzing the load failures and providing RCA to the client.

Accenture (Implementation) SAB Miller July ’09 – April ‘10

Responsibilities:

Involved from Design phase, GAP Analysis up to Go live activities.

Prepared and got sign off from client Functional Design Specs and Technical Design Specs.

Extensively worked on multidimensional models to meet the end user requirements and designed custom Cubes and ODS objects.

Created and activated Info Cubes, Info Sources, Multi-Providers, Transfer structures, Transfer rules, Communication structures, Update Rules (both ODS and Info Cube level) and conversion techniques.

Extensively involved in Design and creating Processes Chains to automate the process of loading data into data targets.

Uploaded master data and transactional data from SAP R/3 via data staging to PSA, DSO and Info Cubes. Worked with data flows from R/3 to BW.

Creation of queries with the usage of various functionalities of BEx like CKF, RKF, variables, conditions, exceptions, structures and cell functionalities.

Developed APD for improve the performance of Query.

Having good experience on understanding the functionality while creating reports.

Accenture (Implementation) Canadian National Railways Oct ’08 – June ‘09

Responsibilities:

Customize and maintained of BW components like Info Objects, Data Sources, Info Sources, Info Cubes, ODS (Operational Data Store), Multi provider, Communication structures, Transfer structures, Transfer rules, Update rules, Info packages and scheduling the data requests.

Extracted data using functional module based on different data base tables.

Areas Controlling, Plant maintenance, Sales Document data. Prepared Technical Design Documents and Unit Test Plan Documents.

Query development in Bex Query Designer with almost all the options in Query Designer, Web Application Designer Worked extensively on creating Web Reports.

Supported pre-Go-Live activities and Cut-Over activities.

Raffles (Implementation) Competitive Intelligence Jan ’08 – May ‘08

Responsibilities:

Created and activated Info Cubes, Info Sources, Multi-Providers, Transfer structures, Transfer rules, Communication structures, Update Rules (both ODS and Info Cube level) and conversion techniques.

Created MDX Queries and involved in Dashboard Reporting.

Extensively involved in Design and creating Processes Chains to automate the process of loading data into data targets.

Managed data loading using both full update and delta management. Also scheduled and monitored data loads to ensure smooth uploads by managing packet sizes and eliminating inconsistencies.

Created Customized Info Objects, Created Customized table involved in ABAP Programming.

Created Customized Cubes, ODS and Multi provider, Info sources, Communication Structure, Transfer Structure, info packages. Created Bex Reports.

Contact this candidate