Post Job Free

Resume

Sign in

Sap Bw Data Modeling

Location:
Texas City, TX, 77590
Salary:
120000
Posted:
April 18, 2024

Contact this candidate

Resume:

Vishnu.V

Senior SAP Certified Consultant

919-***-****

Durham,Nc Open to relocate

ad43m6@r.postjobfree.com

Profile synopsis:

12+ years of total IT experience with magnificent involvement in SAP Applications through SAP BW, BWonHana, BW- IP, Anaplan, BW4Hana, BOBJ,SAC & S/4 hana handling multiple projects and implementation cycles that includes preparation of functional and technical specifications and realizing the technical specifications using BW modeling and reporting tools, coordinate the SIT and help the end users during UAT testing and preparation of cut off and GO Live and post GO Live support.

SAP expertise:

Data Modeling: Proficient in SAP data modeling, Info Cube design & administration, DSO objects design & administration, Multi Provider design and on Repartitioning & Remodeling.

Extraction: Extraction of data from SAP Logistics (Generic, LO cockpit), FI, CO, HR, MDG, SRM, SD, TPM, MM, PP, PM, BPC, CRM, PRM and other SAP(S/4, ECC), Non-SAP, and Flat File Source Systems.

Enhancements: Experience with Data source enhancements in R/3. Involved in writing user exits to populate data to enhanced fields and in writing customer exits on BEx Variables.

Reporting: Experience in creating effective BEx Queries, defining all types of Variables, Filters, Conditions & Exceptions, Formulas, Calculated Key figures, restricted key figures. Extensively worked on Web Application Designer (WAD), creating the Web templates, and executing Dashboards and broadcasting those in different report output formats to end users by using Information Broadcasting

Staging & Loading: Experience with proper data architecture, PSA maintenance, Info Packages, Data Transfer Process (DTP) and Delta functionality. Involved in creating, monitoring, and troubleshooting process chains.

Integrated Planning: Proficient in planning data Analyzing, Data modeling. Involved in optimizing the FOX code for the better performance.

BW4HANA: Experience in modeling with new objects like Composite Provider, ADSO’s, Enhanced Master Data. Worked on Calculation Views and CDS views.

SAP Analytics Cloud: Experience in creating story design and implementing both reporting and planning solutions.

Anaplan: Experience in data uploads into Anaplan application, data validation, solving data upload issues.

SAC: Worked on functional and technical components of planning, budgeting and forecasting solutions using SAC Planning.

S/4 Hana : Expertise in S/4HANA migration projects, helping clients transition from legacy SAP ERP systems(ECC) to the new S/4HANA platform.

Certifications and Awards:

SAP Certified Consultant - SAP Analytics Cloud – Planning

Recognized as Best Performer by the Client “Unilever” in 2016.

Recognized as Best Performer in the team “British American Tobacco” in 2023.

Contribution/Mentorship :

Trained the project team in understanding the Business logics and provided knowledge sharing on the project landscape.

Involved in CoE activities and KT sharing sessions on SAP modules BW HANA and Anaplan for on-boarded employees.

Education

Bachelor's in Computer Science,India- Apr 2011

Projects handled:

Client: British American Tobacco, USA,UK Aug 2022 to Mar 2024

Implementation Partner: LTIMindtree

Role: BW/4HANA & SAC DEVELOPER

Industry: TOBACCO

Project: DEVEOPS

Responsibilities:

During this period, I am part of DevOps track and my responsibilities in the team is to monitor the support incident’s, handling Change Request’s. I worked closely with the end users of USA, UK, Malaysia, UAE, Africa Middle East.

Worked on multiple Change Requests, which involves End to End requirement gathering, which involved design, build, FUT, SIT and UAT. Go-live and Post Go-live support.

Worked closely with end users for requirement gathering and provided support on various issue like authorization issues and provided clarification on the incident’s raised the users.

Worked on implementing and designing both reporting and planning solutions.

Was SPOC for planning data loads and educated user on reports consolidation.

Involved in collaborate with the cross-functional team to develop an integrated SAC solution to support business processes and project

Handled design, implement and deliver the functional and technical components of planning, budgeting and forecasting solutions using SAC Planning.

Developed stories and models in SAC as per the reporting requirement.

Created SAC Dashboards on top of CAR data using live connection.

Consumed the SAP BW data in the SAC for building the reports on top of this data with stories canvas, responsive, grid, formulas, cross calculations, input controls, linked analysis.

During enhancements worked on Calculation and CDS Views.

Handed Kinaxis system Data loads and provided support to Kinaxis team during Single Subscriber Go-live.

Handled APO related ticket’s and involved in APO data reconciliation.

Having knowledge on Power BI and helped end users in undering the dashboards.

Owned Access related ticket’s and provided guidance to the end users on their system access issues.

Having exposure on Manufacturing, Procurement modules.

Handled S/4HANA migration projects, helping clients transition from legacy SAP ERP systems to the new S/4HANA platform.

Creating and trouble shooting both live data connections and import data connections S/4HANA, BW/BPC and non-SAP applications.

SAP tools and services to facilitate the migration from legacy SAP ERP systems to S/4HANA, including the SAP S/4HANA Migration Cockpit and SAP Readiness Check.

Created report on finance modules using data source 0FI_GL_4

Deployed the finance report by using the datasource tables BSEG and BKPF.

Having strong knowledge on finance related source tables FI_ACDOCA_10.

Client: Unilever, Germany

Implementation Partner: LTIMindtree

Industry: FMCG

Project: Fusion Oct 2021 to May 2022

Role: BW/4HANA & SAC Consultant

Responsibilities:

During this period, I Was part of migration track and in this team my responsibility were to migrated BW version objects into Hana version as per the logic and performed validation for the migrated objects.

Performed End to End validation on Migrated objects.

Performed end to end report’s validation and fixed the issues which were part of validation.

Process Chain’s created and monitored the data loads.

Helped the team to understand the report’s logic for validation

Involved in collaborate with the cross-functional team to develop an integrated SAC solution to support business processes and project

Worked on design, implement and deliver the functional and technical components of planning, budgeting and forecasting solutions using SAC Planning.

Project: BPC Headcount Planning

Client: British American Tobacco, UK

Implementation Partner: LTIMindtree May 2021 to Jul 2021

Role: BW/BPC Consultant

Industry: Tobacco

Responsibilities:

During this period, I was part of BPC Headcount Planning track and my responsibilities in the team is to create new BPC roles across the system as per the requirement.

End to End requirement gathering to go live, which involved design, build, FUT, SIT and UAT. Also involved in Cut Over, Go-live and Post Go-live support.

Creation of Data Access Profiles and Market level and Market equivalence.

Changing the Teams and Task profiles as per the requirement.

Creation of Composite Roles by using DAPs at Market level and Market equivalence.

Worked on User ID creation for SAC planning users.

Project: Operational Analytics

Client: ADIDAS, Germany

Implementation Partner: LTIMindtree sept 2020 to Mar 2021

Role: BW on Hana Consultant

Industry: Textile, Footwear

Responsibilities:

During this period, I was part of Operational Analytics track and my responsibilities in the team is to enhance the reports and to explain the BW logic to MSTR team to create the reports accordingly in MSTR portal.

Worked upon enhancing Global Shortage report with adding few additional fields.

Creation of Master data objects in M3D cockpit to use the objects in Exasol.

Helped the MSTR team to understand the BW reports logic to implement the same report in MSTR portal.

Worked on Exasol platform.

Involved in maintaining data warehouses and data lakes using AWS Redshift and Athena.

Involved in design, build and maintain the data pipelines that bring data into data lakes

Project: Remote Conversion

Implementation Partner: LTIMindtree

Client: Unilever, Germany April 2020 to May 2020

Role: BW/4Hana Consultant

Industry: FMCG

Responsibilities:

During this period, I was part of Remote Conversion track and my responsibilities in the team is to validate the migrated objects and to validate the data between Source system and BW system.

Worked for BW upgrade (7.5) Upgrade project.

Involved in Upgrade OSS notes implementation. Involved in Scope check for a data flow.

Involved in Scope Transfer. Involved in code scan and code adjustment.

Involved in Inventory data extraction from source and end to end data validation.

Helped team in understanding the logics.

Project: Respond

Implementation Partner: LTIMindtree

Client: ADIDAS, Germany Feb 2020 to Mar 2020

Role: BW Hana Consultant

Industry: Textile, Footwear

Responsibilities:

During this period, I was part of Respond track and my responsibilities in the team is to monitor the data loads and requirement gathering for enhancing the reports.

Monitor the SAP BW batch jobs through Bachman and rectify the data load failures appropriately to meet the critical delivery timeline of the reports.

Requirement gathering to enhance the existing reports.

During enhancements worked on Calculation and CDS Views.

Enhanced the Sales Report.

Project: IBP Planning

Implementation Partner: LTIMindtree

Client: ADIDAS, Germany Aug 2017 to Jan 2020

Role: BW -IP Consultant

Industry: Textile, Footwear

Responsibilities:

During this period, I Was part of KSRM Support track and in this team my responsibilities are to resolve the tickets raised by the users and I was the primary contact for the Anaplan system for data loading and validation.

Handled Anaplan data loads with end-to-end data validation.

Involved in Bug fixes in Anaplan Application.

Handle the enhancement requests from users.

Extensively worked on Forecast data.

Prepared documentation on Customized Layouts and explained to the end users how to use the Customized layouts.

Rectify the data load failures appropriately to meet the critical delivery timeline of the reports.

Proactively carried out data reconciliation of Planning Cubes Vs Backup Cubes data.

Proactively carried out Actuals data Reconcile between Source system Hana and IP System.

Helped the Users on the System Login issues.

Project: LeverEdge

Implementation partner: Blueprint Technologies LTIMindtree

Client: Unilever, Germany Feb 2015 to July 2017

Role: BW Consultant

Industry: FMCG

Responsibilities:

During this period, I Was part of Support track. I was responsible for handling the process chain changes and during system down as well. I worked closely with the end users of Thailand, Philippines, Vietnam, and Cambodia and Loas

Rectify the data load failures appropriately to meet the critical delivery timeline of the reports.

Handle the assigned L2 tickets by identifying the issue and proposing a solution.

Involved in preparation of configuration document, Training manual and have given end user training.

Handle the enhancement requests from users where the effort is less than 5-man days.

Proactively carry out reconciliation of critical data like sales and stock

Communicate on the larger teams on daily load status and availability of reports to the user.

Performed BW Data archiving, Retention Management activities and support activities.

Send out monthly load statistics to the key stake holders.

Project: LeverEdge(PH4DT)

Implementation partner: Blueprint Technologies

Client: Unilever, Germany Jul 2014 to Jan 2015

Role: BW Consultant

Industry: FMCG

Responsibilities:

During this period, I Was part of Philippines track (PH4DT) and in this team I worked for the Country Philippines and delivered critical Inventory reports as per the requirement from the Client.

Handled the inventory and sales module end to end from requirement gathering to go Live, which involves design, build, UT, SIT and UAT. Also involved in Cut over, Go-Live and Post Go-live support.

Direct interaction with Philippines country team to gather the requirements and support the UAT and Post Go Live Support.

Extensively worked in extractions, LO-Cockpit(Logestic) extraction using V3 update and enhancements and writing User-Exit programs as per requirements.

Involved in developing Inventory Report like Weeks Cover Report and Inventory Interface Report.

Involved in data source enhancement of 2LIS_02_VAITM, 2LIS_13_VDITM.

Uploaded Master Data and Transaction Data from ECC.

Worked extensively on BEx Query Designer to create Queries on ODS Objects, Info Cubes, Multi Providers, and published Web Reports.

Having exposure on Manufacturing, Procurement modules.

Created queries using variables restricted key figures, filters, exceptions, conditions, and free characteristics.

Project: LeverEdge(SRMR)

Implementation Partner: Blueprint Technologies

Client: Unilever, Germany Apr 2014 to June2014

Role: BW Consultant

Industry: FMCG

Responsibilities:

During this period, I Was part of Small Request and Medium Requests Team (SRMR) track and in this team, I worked for the Country Thailand and delivered the reports as per the requirement from the Client.

Delivered two critical Change Requests as part of SRMR Team, well within the stipulated time.

Enhanced the Annual purchase report with Invoice date field, which required addition of new field to 2LIS_02_ITM and modifying the relevant BADI to populate data into the enhanced field.

Created a detailed stock report which give the closing stock status and movements relevant to the closing stock.

Worked in translation of the reports from English to Thai language, which are used in query.

Handled postproduction support Training and preparing manuals for end users.

Having direct interaction with end users for the requirement gathering and supported them during UAT phase to post Go-live support.

Project: Devops

Company: Pravahya Consulting Pvt.Ltd

Client: Eli Lilly Jan 2012 to Apr 2014

Role: BW Consultant

Industry: FMCG

Responsibilities:

During this period, I was part of DEVOPS track and in this team my responsibilities were to deliver the reports as per the requirement and supporting the end users by providing training manuals.

Involved in data source enhancement of 2LIS_11_VAITM, 2LIS_12_VDITM with profit center field based on look up into MARC table.

Created Plan Vs Actual reporting, sourcing actual data from ECC and using plan data from Files.

Worked extensively on BEx Query Designer to create Queries on ODS Objects, Info Cubes, Multi Providers, and published Web Reports.

Worked with Report-to-Report Interface (RRI) to drill down from Info Cube to ODS item and schedule line level information.

Scheduled and automated data loads from R/3 to BW and optimized the load performance by adjusting the packet size, data selection and number of Info Packages.

Involved in performance enhancement features such as cube partitioning, indexing, maintaining aggregates and compression.

Performed BW Data archiving, Retention Management activities and support activities.



Contact this candidate