Name: Bala Sri Vani

Email: aduxec@r.postjobfree.com

Contact: +1-657-***-****

LinkedIn: https://www.linkedin.com/in/sri-b-17b3a4253/

Location: California, CA

SAP BI Lead, SAP Senior consultant

PROFESSIONAL SUMMARY:

●SAP Professional with over 10+ years of experience mainly focused on Design, Development, and Implementation of SAP BW4HANA, BW 7.5, 7,4 / 7.0 / BW 3.5B, 3.1C, R/3 (4.7C) which includes ABAP. Experienced in S/4 HANA (1709, 1809 & 1909) Embedded BW & Embedded BPC. Involved in six life cycle implementations, Support projects and Roll-Out Projects.

●Involved in Design part and development of BW objects, Transformations, Business Content configuration using SAP ASAP methodologies.

●Involved in different steps of development lifecycle blueprint, implementation, migration upgradation and support.

●Experience in working along with core team and handled multiple roles of Senior BI Lead Onsite Coordinator, BW4HANA Consultant and data warehouse Developer / Technical Consultant.

Technical Skills:

SAP Systems

SAP S/4 HANA (1709,1809,1909), ECC 4.6c, 6.0, SAP BW 3.x, SAP BW 7.x, SAP BW/4HANA, SAP Solution Manager

SAP Business Warehouse

BW Queries, BEX Reporting, BOBJ,BW Data Modeling, Extraction, Data Loading and Enhancements in BIW, Open Hubs, APDs

SAP BW/ 4 HANA

SAC, SAP HANA Design Studio, SAP HANA Modeler, S/4 Embedded Analytics, Embedded BPC& MDG & SAP PAPM (Profitability & Performance Management)

Reporting Tools

Eclipse, SAP BEX Query Designer, Web Application Designer (WAD), Analysis for Office (AFO).

Functional Area

FI-AP (Accounts Payable), FI-AR (Accounts Receivable), FI-GL(General Ledger), CO-PA, Material Management (MM), Sales and Distribution (SD), LO (Logistics Cockpit), Finance and Control (FI-CO), HR-PA (Human

Programming Languages:

ABAP/4, SQL

Education:

●Jawaharlal Nehru Technological University, India, Master of Engineering in Computer Science

●Jawaharlal Nehru Technological University, India, Bachelor of Engineering in Computer Science

Professional Experience:

Client 1: Embecta, Franklin Lakes, NJ JUL 2020 to Present

Role: SAP BI Lead

Responsibilities:

●Extensive experience in LSA and LSA++ architecture.

●Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes based on HANA ASAP Methodology.

●Experience in Modeling & Customization of Info Objects Advanced DSOs and Composite providers, and Open ODS views.

●Strong experience in S/4HANA data modelling and embedded analytics solution architecture development.

●Strong experience in the design and implementation of SAP S/4HANA reporting migration solution for embedded analytics projects.

●Worked on SDA, RFC adapters between multiple HANA DB to S/4 systems.

●Worked on S/4 Embedded BW, BPC data models.

●Created reports in Eclipse and Bex Query Designer with Variables, Formulas, structures, exceptions, and conditions, calculated key figures, and restricted key figures.

●Performed BW4HANA upgrade activities.

●Extensively worked on Change Management & Incident Management.

●Experience working on HANA Enterprise Modelling including Attribute Views, Analytical Views, Calculation Views, building CDS Views.

●Detailed understanding and experience with the SAP HANA technology, landscapes and any related interdependencies.

●Strong knowledge of reporting solutions on top of SAP HANA.

●Implement data models using SAP HANA best practices

●Expertise in SAP HANA Data Modeling (creating information Models, Packages, Attribute, Analytical, Calculation Views and Data Provisioning technology SLT, Smart Data Access.

●Hands on experience in Core data services to import S/4HANA data and build Consumption Views.

●Expertise in developing Analytic Solutions using SAP HANA and SAP Business Objects toolset like WEBI, AFO

●Ability to design and build complex workflows to facilitate various business requirements.

●Hands on Experience with key technical objects used in the creation of a SAP BW data model; design and build.

●Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and Info Cubes.

●Experience in building BW models Composite provider, ADSO in HANA Studio.

●Good understanding and experience in providing security restrictions on models

●Worked on HANA modeling scenarios and activities such as adding a system, and creating schemas and content models, attributes, and measures.

●Experience in Data Extraction from Hana information model, Calculation view, CDS view.

●SLT connection created for replication process using SAP HANA studio and SAP LT replication server for transactional integrity.

●Understanding and writing SQL Queries with All types of Joins.

●Weekend and Critical month-end closure activities were handled effectively and made operation smooth to for clients onshore.

●Efficiently managed teams of various sizes and worked with the team to achieve company and client goals.

●Identified the gaps in the requirements as a part of the design.

●Extensively involved in creating Solman charm, CHM and updating all technical documents in Solution manager.

●Involved in SAP BW security authorization roles design for firefighter access.

●Monitoring and implementing the solutions to the errors in the Production System.

●Developed process chains to automate the initialization and delta updating of all data

●Developed generic data source using database views and custom function modules, also created Badi for Data source enhancements.

Environment: BW4HANA, S/4 HANA Embedded BW, BPC and AFO

Client: Becton Dickinson, San Diego, CA Feb 2019 to July 2020

Role: SAP Senior consultant

Responsibilities:

●Active participation in few phases of a project: This includes modelling, Design and development, Reporting.

●Cross verified Build specs before giving sign off to them.

●Performance tuning and transportation of objects and Extraction of data.

●Understand the client’s reporting requirements, functional, and technical specification.

●Expertise is creating and enhancing the extractors using BADI.

●Expertise in modeling end to end data flows from ECC to BW.

●Created Customized FI & CO Reports like Due date for net payment Analysis Report, Customer Order Analysis Report & Head count Report, G/L Account Reports.

●Experience in enhancing existing BW flows including (BW objects, ABAP Logics in Routines and data sources)

●Experience in SAP HANA data modeling using Attribute View, Analytic View and Calculation View

●Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views.

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

●Experienced in loading data from tables in HANA Database to BW data marts. Experienced in HANA Studio .

●Open Life cycle Management

Proactive team player with excellent with excellent interactive and interpersonal skills to communicate with team members, developers, clients and end users at all levels.

●Experience in Migration from BW to BW4HANA as Housekeeping activities and involved creating reports using AFO.

●Involved in Archiving of info providers and rescheduling activities.

●Proactive team player with excellent interactive and interpersonal skills to communicate with team members, developers, clients, and end users at all levels.

●Develop and maintain productive working relationships with client personnel.

●Experience with incident management and HPALM and HPQC.

Environment: BW4HANA, S/4 HANA Embedded BW, BPC and AFO

Client: Johnson & Johnson, NJ Oct 2018 to Feb 2019

Role: SAP Senior consultant

Responsibilities:

●Extensively worked on SAP NetWeaver 2004s BI. Created, Transported and Maintained several BW/BI objects such as Multiproviders, Infosets, Realtime (transactional) and Basic Infocubes, DSO(formerly ODS), Transformations (Transfer and Update rules), DTPs (Infopackages), extract Datasources (Infosource), DSOs for Direct Update (transactional ODS), Write-optimized DSOs, complex BEx queries,

●Expensively designed and created the Configured Aggregation Levels, custom Filters and Functions, Planning Sequences, Input enabled Bex queries to support user interaction.

●Worked on ABAP Routines, User exits Customer exits.

●Participated in Cutover activities during go-live and provided support for data loads/issues.

●Extensively involved in creating reports in Bex query Designer’s new layout, Exception Aggregation to define complex queries, defining Exceptions, Conditions are later deployed in a variety of scenarios like Excel workbooks and web applications.

●Created queries in the Bex and also created variables, text variables, structures, calculated key figures, restricted key figures, exceptions, conditions.

●Expertise with BI reporting for Data Analysis with Bex Analyzer, BI Accelerator, Web Application Designer and implemented Bex Queries, Variables and Workbooks Loaded data for Master Data objects Attributes, Texts, and Hierarchies.

●Created Process chains and Meta Chains for loading Master data and also for loading Transactional data .

●Involved in PSA and change log deletion for reducing the table space issues.

●Daily meetings have been setup with the end users for designing the reports and extensively trained.

●Expertise BOBJ Admin activities(Info view and CMC). Scheduling reports and created user account and provided authorizations for the users based on user group.

●Involved in Universe design, development using information design tool and universe design tool(IDT and UDT).

Environment: SAP BI 7.0, BW 3.5, SAP ECC 6.0/5.0

Client: DXC Technologies, BANGALORE Jul 2016 to Jun 2018

Role: SAP BI Consultant

Responsibilities:

●Assist in the evaluation and development of tools, technology, processes, and services to solve business and technical challenges

●As a SAP CPM BW/IP consultant involved in Design, configuration and implementation of SAP Commercial project management upgraded from CPM 1.0 to CPM 2.0

●Ability to work effectively in a complex matrix environment with virtual teams of high-level professionals

●Created Functional specifications based on the business requirements in SD module.

●Involved in setting up a procedure to extract R/3 data for SD using LO, Generic Extraction and customizing to the requirement using Business Content.

●Enhanced Sales Info cube with a custom field and a standard database field to meet the user requirements.

●Worked on different areas like Order to Cash, Budget to Reporting Finance Asset Accounting, SRM, and Procure to pay areas based on functional specifications.

●Designed and developed Asset Accounting flow from ECC and developed Asset Reports BEx reports.

●Used BW- IP to build planning applications in SAP.

●Worked on the function modules and exits for data extraction and data source enhancements.

●Coordinating between the offshore and onsite workload issues and taking care of the issues and concerns of the client.

●Improved the system performance and worked closely with basis assisting them in applying the patch upgrade. Worked on the BIA accelerator for rollups and re-indexing of the data targets.

●Working closely with the basis to resolve the issues in production and performed testing at multiple levels for issues in production.

●Worked on the installation of business content, activating the data source, developed a number of transfer routines, and worked extensively on the administrator workbench, modified transfer structures, and updated rules.

●Involved with performance tuning of queries by maintaining Aggregates, Compression, partition of info cubes.

●Experience in APD scenarios (Analysis processing and design) which is data mining tool, to improve query performance.

●Working with CKF and RKF for BEx reporting.

●Working with CMOD code for master and transaction data.

●Delivered Documentation for all new objects and enhancements.

●Conducted workshop training for the end users on BEx tools and various reports execution.

Environment: SAP BI 7.0, BW 3.5, SAP ECC 6.0/5.0

Client: Hewlett Packard Inc, BANGALORE Jul 2015 to Jun 2016

Role: SAP Consultant

Responsibilities:

●Created a custom Info cube for monitoring the material movements and warehouse stocks and populated this Info Cube with data extracted from the above data sources.

●Uploaded master and transactional data from flat file and SAP R/3 as the OLTP source

●Created Info packages for initial, full, and delta uploads for both master data and transactional data.

●Involved in performance tuning by maintaining aggregates, compression, partitioning, and indexing of info cubes.

●Expertise includes Data Analysis, Data Modeling, Data Cleansing, Transformation, Integration, Data import.

●Involved in writing Routines as per the requirement.

●Proficient in data modeling using MDM and BW extended star schema models.

●Used Delta Update process for loading the data to BI from R/3 in specific intervals.

●Worked extensively on Repartitioning of info cube.

●Developed several Process Chains for loading data into the Data Targets.

●Involved in Transport objects from Dev to QA system using Transport

●Developed basic cubes for Customers and Quotations, Created aggregates and indexes for Info Cubes to improve the query performance.

●Loaded business content, and performed activation of SAP-supplied Info Objects.

●Extensively used Process Chains to automate data loading process.

●Successfully exported the daily snapshot data to another BW system using Open Hub Service.

●Set up extraction using LO LBWE Execution Cockpit V-3 updates.

●Involved in the Analysis, design, and development of Info cubes and ODS objects

Environment: SAP BI 7.0, BW 3.5, SAP ECC 6.0/5.0

Client: Nestle, BANGALORE Jan 2013 to Jul 2015

Role: SAP Consultant

Responsibilities:

Designing a Technical Documentation for Complicated Reports .

Classification and design of dimensional dependencies for Characteristics, Key Figures and navigational attributes based on functional requirement, granularity of information to be captured.

Classification and design of Info Areas, Info Object, Info Providers, ODS, Info sets and Info Sources based on functional requirement, accessibility by different user groups and data sources.

Design and development of SAP’s Business Warehouse Reporting .

Modified standard and created custom Info Source/Data Source, ODS, and Info Cubes.

Created and Activated Communication Structure, Transfer Structure, Transfer Routine, Update Rules (both ODS and InfoCube level).

Design, Create and Maintain standard/custom InfoObjects, InfoCubes, ODSObjects,

DataSources, InfoSources, Update Rules, Transfer Rules and Communication Structures.

Execute Info Package, Read Data from PSA and update Data targets.

Modification/Activation of Standard Business Content.

Environment: SAP BI 7.0, BW 3.5, SAP ECC 6.0/5.0

Contact this candidate