Post Job Free

Resume

Sign in

Sap Bw Hana

Location:
Redmond, WA
Posted:
December 24, 2023

Contact this candidate

Resume:

VEENA MADHURI PULAVARTHY

ad17a8@r.postjobfree.com +1-980-***-**** REDMOND, WA

https://www.linkedin.com/in/veena-pulavarthy-70618056/

Experience Summary

I am an SAP certified with 12+ years of total experience in IT with an expert knowledge of end-to-end solution delivery,

Integration, data modeling and reporting.

Worked as SAC planning consultant, BW4HANA Consultant, SAP HANA Developer, BW & BOBJ Consultant Sr. SAP BI Consultant and BPC consultant for Multiple industries like Telecom, CPG, Automobile and Manufacturing Industries.

Have a deep technical understanding and implementation expertise in SAP, Azure & Integrations. Deep expertise in SAP HANA, SAP BW-BI, SAP Datawarehouse cloud, SAP Analytics Cloud, Azure Data Factory, Azure Databricks, Power BI, Tableau, Business Objects/Lumira in addition to having experience with data modeling, optimization, data extraction, loading and, transformation.

Hands-on functional configuration and design experience with SAP SAC Planning

Hands on experience designing, developing, and maintaining Analytical Designer Templates using Java script.

Have a good experience in SAP FP&A, CapEx, OpEx, P&L Planning, Forecasting & Budgeting.

Having experience in Planning, Forecasting BI, and Predictive Analytics using SAP Analytics Cloud.

Proficient in building Data actions, Multi actions and Allocation Process.

Expertise / Knowledge of SAC predictive capabilities, augmented analytics, forecasting, Smart Assist, Smart Predict, Smart Discovery, creating story canvasses, advanced story designing, blending data, formulas, cross calculations, input controls, linked analysis.

Ensure data that is used for various analytics applications is modelled and maintained in a way that promotes quality, reuse, usability, consistency, accuracy, and maintainability.

Technical Skills

Cloud Platforms: SAP Analytics cloud (SAC), Embedded Analytics, Azure

SAP HANA: HANA 2.0 XSA, HANA 1.0, S/4 HANA

SAP BI/BW: BW/4HANA, BW on HANA 7.5/7.4/7.3, BI 7.0, BW 3.5

Data Provisioning: SLT, SDA, SDI, BODS

Reporting Tools: SAP BPC, SAP BOBJ, Analysis for office (AFO), Tableau, Lumira, Webi, Power BI and Design Studio

ERP: SAP SD, SAP HR, SAP MM and SAP FI

Databases: HANA2.0/1.0, Oracle, DB2, SQL, MS Access 2010

Project Management: JIRA, Microsoft Suite (Project, Visio, MS Office, PowerPoint)

Experience

Company: HCL

Client: FCC USA

Location: Hyderabad INDIA

Duration :10/2022 – 07/2023

SAP SAC & Planning Consultant

Analytics Lead in SAP Analytics cloud and Embedded Analytics implementation for multiple use cases.

Technical expertise in financial planning and performance management through data collection and structuring, analyzing, planning, and reporting company financial performance across all Free Cash Flow KPIs to achieve financial targets by synthesizing data into meaningful conclusions and recommendations.

Experience in developing reporting and analytical solutions based on SAP data using SAP HANA

Have working knowledge of Planning & Scheduling: Processes/Activities/Tasks/Data Prompts/Gar

Charts/Attachments, within SAC Planning Calendar, and Publishing them for users

Tailored Reports (AR/AP/G/L, Financial), Dashboards, KPIs, in SAP Analytics Cloud. Worked with creation / enhancement of SAC Models along with Stories / Dimensions / Measures, after extracting data both from Live & Import Data Connections (Flat-Files! On-Premise / Cloud) for Stories; for Reporting, Analysis & Financial Planning. Added Dimension Associations (with Attributes), Filters (Report / Page / Story) Level, Input Controls (Measure / Dimension) Level, Linked Analysis (for Reports /

Charts), Calculations on Measures (along w/ incorporating Input Controls), etc.

Company: TCS & IBM

Client: PepsiCo Inc USA

Location: Hyderabad INDIA

10/2018 to 12/2019 & 05/2022 -09/2022

SAP BW to Microsoft Azure Migration,

SAP SAC & SAP BW4HANA

Worked on SAP BW to AZURE Migration, migrated all the reports from Bex to Power BI.

Involved in transforming the SAP BW data into AZURE storage and transforming data in Azure data bricks and stored into delta tables.

Created multiple SAP open hubs destinations (OHD) on Master data tables and transaction data on top on info cubes and ADSO’s.

Copying data via Open Hub Destination local table, which underneath can be DSO, Info Cube, MultiProvider, DataSource, etc.

Created the complete documentation of SAP Bex reports and SAP Web intelligence reports.

Involved in reconciling the data SAP BW reports to Power BI.

Involved in loading data from SAP BW open hub to AZURE table through data factory.

Created Analytic applications using Application designer.

Created Dashboard story in SAC using Canvas, Responsive pages and Digital boardroom.

Performed Administration work in SAP Analytics Cloud - Add / Delete / Edit Users, Profiles, etc. Created Permissions, and assigned them to Users / Groups / Teams. Managed SOs & SAML Attributes.

Experience with ETL tools such as SDA/SDI, Flow graphs and BODS (Data services)

Involved in Group reporting at SAP S/4HANA using Fiori applications by using a virtual data model based on Core Data Services-CDS.

Ability to deploy complete Project to different Spaces, after constructing all Artifacts / Services O Comfortable at all aspects of SAP On-Premise to SAP Cloud; and SAP Cloud to Cloud Integrations

Developed SAP Analytics cloud analytics solution involving data wrangling, multi model set-up,

model development, story development, KPI dash boarding for multiple streams of reporting

and business unit.

Company: TCS

Client: ZF GERMAN

Location: Hyderabad INDIA

Duration:01/2020 - 04/2022

SAP BW4HANA & SAC Developer

Working on BW4HANA migration projects.

SAP BW/4 HANA Modeling for ADSO and Open ODS, Extraction and loading of data from source systems

Development the Composite Providers from Logistics and sales from SAP and Legacies Data Sources.

Consolidate in the advance DSO objects the information of the processes that involve the SAP and SQL legacy systems.

Use the new technologies of SAP SDA Smart Data Access which allows us to extract and load the information of non-SAP systems.

Use the ODP Operation Data Provisioning to connect the SAP Data Sources.

Use Fiori to Manage, Active and Load data into the SAP BW Objects.

Create new queries From Data Mart - composite provider and calculation view direct.

Modeler the full Data Flow by creating Generic and Standards Data Sources from ECC to replicate to SAP BW4HANA.

Created Private / Public Models from Scratch/Data Source/File Upload, maintained Pre-defined Dimension Types (Account, Time, Version, Organization), added/maintained Dimensions, Measures, Accounts, established Relationships, maintained Model Settings, performed Data Wrangling, Mass Data Entry, Linked Analysis, Table Thresholds / Conditions defined on Model / Story Level for re-use, Formatting, define/re-use Styling Rules for various Uses Cases, Cross Calculations bound to Input Controls for users, add Dimension Members for new Plan Master Data, upheld Security / Data-Locks, sustained custom Properties, Hierarchies (Parent Child, Level-Based), Model Versions, System Properties (Unit/Currency Conversions.

Working knowledge of Predictive Analytics, Digital Boardroom, Project Smart Insight, Search to Insights, Smart Discovery, Smart Predictive, Natural Language Processing and Value Driver Trees (VDT); for Stories, in SAP Analytics Cloud

Proficient in various Predictive Scenarios: Classification / Time Series / Regression.

Have working knowledge of Data Actions, Triggers, Allocations and implementing / re-using Allocation Rules in Stories O Have working knowledge of Business Content for Integrated Financial Planning (FP&A: P/L, B/S, Cashflow Planning, Revenue Planning, Cost & Activity Planning, Product Cost Planning).

Experienced with Power BI Data Modelling and Customized, built data model regions.

Developed Power BI reports and dashboards from multiple data sources and publish them on Power BI Service.

Developed formulas for reports in Data Analysis Expression (DAX) language.

Company: CGI

Client: BELL CANADA

Location: Hyderabad INDIA

05/2010 - 09/2018

SAP BW/BO/ BPC Consultant

Possessing a great experience in maintaining the documentation, preparing the check lists required for Pre& Post Go-live Activities and created the Status Update Sheet to standardize the business communication.

Worked in IFRS Revenue recognition project in HANA and BW implementation to meet IFRS 15 and IFRS 16.

Involved in Data Acquisition & ETL to the extraction of data from all relevant source systems, preliminary staging of the data, validation and transformation of the data, and finally migrating the data in a Normalized Database for further processing by SAP RAR.

Involved in the processing of transformed and normalized source data from SAP RAR into Revenue Accounting Items (RAI), the creation of accounting contracts, the calculation of periodic revenue and contract assets / liabilities, the execution of manual adjustments, and the posting of summarized revenue related data.

Developed Queries to access data from various SAP BW Info Providers like DSO (ODS), Info Cubes, InfoObjects, Multiproviders and InfoSets using BE Query Designer. Reconciled BI reports with ECC & Legacy data. Performed analysis for Loading and Query performance. Worked with Navigational Attributes, both Time Dependent and Independent. Worked on Financial

Created universe using the IDT from the relational data sources for workflow reporting.

Creating OLAP Connections in Central Management Console (CMC).

Worked on Advance Analysis tool on top of BEx queries and design the reports in Analysis Workspace using BICS Connections

Worked on Web Intelligence reporting using BICS connections on top BEx Queries without creating Universe.

Designed and Developed Web Intelligence Reports using the features like Master/Detail, Charts, Cross-Tabs, Drill Down to analyze the data. Restricted the data using the Prompts and filters.

Worked with the onsite team to meet the specified project deadlines. Work in unison during product development.

Education and Training

Jawaharlal Nehru Technological University Kakinada, India

Bachelor’s Degree in Electrical & Electronics

05/2010

Certifications

SAP Certified Application Associate – SAP Analytic Cloud

SAP Certified Application Associate - SAP Analytic Cloud Planning

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

SAP Certified Application Associate – SAP BusinessObjects Web Intelligence 4.1.



Contact this candidate