Vasanthi P

SAP HANA, BW on HANA, SAC, BOBJ, BODS Consultant

Email: ad4hsi@r.postjobfree.com Contact: +1-971-***-****

Professional Summary:

Senior SAP Consultant with around 7 years of experience in design, Implementation and production support of SAP BW on HANA, SAP BW/4HANA, SAP Analytics Cloud (SAC), SAP HANA Modeling, SAP BOBJ, SAP BODS, Power BI, SAP Analysis for Office, Web Intelligence, and Crystal reporting tools, and a good knowledge on SAP Data Sphere and S/4 Embedded Analytics.

Worked extensively with SAP Analytics Cloud, Power BI, BEx Query Designer, BEx Analyzer and Analysis for Office, SAP Lumira, Design Studio, Web Intelligence, Crystal Reports for creating custom and enhanced reports for business.

Data Modeling (Business Content and Customized BW Objects): Expertise in Installing Business Content and worked extensively on developing complex data flow structures based on LSA ++ architecture, with customizing Info Objects, Advanced DSO layers as staging, DTP, Transformations, Open Hub Destinations, Open ODS views, Process Chains, Info Sets, Multi providers, Virtual Providers, Bex Queries.

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

Experience in Native HANA modeling creating Indexes, Delta Merge, Analytic, Calculation, Attribute views, Joins, Input parameters, Aggregations, filters, calculated columns, restricted columns, OData, BODS, SLT, SDI and SDA configuration.

Extensively worked on SAP BODS -analysis, design and development of various data warehousing and data migration projects and BODS administration tasks like repository configuration, job server configuration, job scheduling and monitoring.

Expertise in data extraction/ETL methodology, transformations, loading using data integrator and BODS designer components - jobs, workflows, data flows, formats, data store and scripts.

Worked extensively on Bex functionalities – Cell definitions, Exception aggregations, Offsets, Customer Exit, free characteristics, rows, columns, formulas, calculated and restricted key figures.

Worked on SAP Analytics Cloud - performance optimization, ETL, data modeling/warehousing, data analysis, visualization and configuring connections, Integrating data from multiple sources.

Worked on Business Objects–Web Intelligence and generated different types of reports using all the features- sub queries, merge dimensions, combining multiple queries, drill down, ranking, hyperlinks, etc.

Extensively worked on Performance tuning at 3 levels in SAP BW – Database level resolving table space issues, Modeling level -data loads performance optimization and Frontend Report level – Query optimization.

Strong experience in ABAP methodology in ECC and BW - Creating Programs, Creating Function Modules, Debugging, User Exists, Customer Exists, End and Start and Expert Routines, DTP routines, Field routines, Extracting from multiple tables and Creating Views on tables.

Expertise in handling SAP BODS, SAP BO administrator activities from the central management console (CMC): user management, Creating and managing servers, connections, in-mail Monitoring alerts, Promotion Management, Authentication, scheduling reports, OLAP Universe, Database Connections, Information Design Toll(IDT), Universe design Tool(UDT) Creating and importing new users and roles from SAP systems.

Worked on version upgrade and patch upgrades of BW(7.3, 7.5), BO(4.2) systems and service window activities

Transports include Transportation of BW and R/3 Objects, collected objects in the Development System, and transported throughout the System landscape using Solman and Charm.

Experienced working with both onshore and offshore environment with Waterfall, Agile and hybrid methodologies.

Technical Skills:

ERP Applications: SAP BW 7.3, 7.4 and 7.5, ECC 6.0, SAP HANA 2.0, SAP BODS, SAP BOBJ 4.1, 4.2, SAP B/4HANA, SAP S/4HANA.

SAP BI/BW Expertise: Expertise in Installing Business Content and worked extensively on developing complex data flow structures based on LSA, LSA ++ architecture, with customizing Info Objects, Advanced DSO layers as staging, DTP, Transformations, Open Hub Destinations, Open ODS views, Process Chains, Info Sets, Multi providers, Virtual Providers, Bex Queries.

Extraction: data extraction from SAP Logistics (Generic, LO cockpit), SD, MM, HR, SRM, TPM, PP, BPC and FICO, Flat file, Non-SAP data base systems.

Transports: Collecting changes into TR’s and transporting across the landscape (DEV,Test, Pre-Production, Production systems).

Reporting: Bex Analyzer 7.0/7.3, Bex Query, Web Intelligence 4.2, Crystal Reports, SAP Analysis for Office, SAP Analytics Cloud, Power BI, SAP Lumira and Design Studio.

Other tools: Oracle SQL developer, Putty, MS Office, Service now ticketing tool.

Programming Languages: SQL, ABAP, Java, PLSQL, Python.

Professional Experience:

Client: A. O. Smith Corporation - Remote May 2022- Till Now Role: SAP BW on HANA, SAC, BODS Developer

Roles & Responsibilities:

Collaborating with clients, Understanding the business requirements, and translating them into technical specifications, designing and implementing them in BW data flows accordingly.

Working closely with data architects and implementing data pipelines, ETL processes, and transformations.

Performing data validation and performing, documenting UAT testing before and after migrations and upgrade windows.

Involved in full life cycle implementation which includes Analysis, requirement gathering, development testing, reporting go-live, and post-go-live support.

Worked on the development of multiple dashboards using SAP Analytics Cloud, integrated with multiple systems and Experienced in Importing and exporting data for different business requirements.

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

Worked on performance optimization, ETL, data modeling, data analysis, visualization and Configured connections between SAP SAC, SAP BW system, and non-SAP systems.

Worked on preparing datasets, data wrangling, dimensions, measures, Visualizations, Dashboards, stories canvas, responsive, grid, Smart Discovery, formulas, cross calculations, input controls, linked analysis.

Expertise in Native HANA Modeling, Configuring and extracting data through BODS, SLT and SDA, Creating HANA models using both physical tables and virtual tables.

Working on HANA Studio, creating Indexes, Delta Merge, Analytic views, Calculation views, Attribute views, Joins, Input parameters, Aggregations, filters, calculated columns, and restricted columns.

Working on ODP framework for CDS extraction provides delta capabilities.

developing SQL Scripts, PL/SQL Stored Procedures, Triggers, Functions and Packages.

Experienced in exporting HANA models to the reporting tool.

Replication of SAP BI objects to SAP HANA system through a Real-time replication process.

SLT (Landscape Transformation) Configuration Server using LTR & LTRC.

Migrating BW on HANA data to the BW/4 HANA system and resolving the issues.

Extracted data from LO extraction through ODP in SAP B/4HANA Database depending on requirements

Involved in complete Inventory Management in SAP BW/4HANA, how to load Inventory Management data in BW/4HANA and how the data is saved in the BW database tables.

Performance tuning in SAP BW – Database level resolving table space issues, Modeling level -data loads performance optimization and Frontend Report level – Query optimization.

Connecting with SAP Product Support and implementing S-Notes throughout the system landscape (development to production).

working on data loads from BODS to BW system through HANA.

Data extraction from SAP ECC to SAP BW system using BODS by creating RFC connection between BW and BODS.

Implementing data warehousing and data migration projects in SAP BO Data Services and Performing BODS administration tasks like repository configuration, job server configuration, job scheduling and monitoring.

Working on data extraction ETL methodology, transformations, loading using data integrator and BODS designer components - jobs, workflows, data flows, formats, data store and scripts.

Creating Users and assigning roles, Creating and monitoring jobs in BODS systems.

Design and develop ETL routines in BODS, modified or created new data services jobs to meet project requirements.

Working on installation, configuring the repositories, and establish the data connections.

TATA Consultancy Services-India Oct-2017 to Nov-2021

Role : SAP BW on HANA, SAP BO Consultant

Client : ASML, Netherlands

Roles & Responsibilities:

Performing a key role in understanding business requirements, designing, and implementing in BW on the HANA system.

Performing BW system refresh, pre and post refresh activities

Connecting with the end users daily and resolving the data load and report issues.

Interacting with the clients occasionally to discuss open issues.

Creating custom DTPs, info packages, Transformations, and Process chains.

Monitoring process chains, troubleshooting and solving data load issues including DSO activation errors, DTP, transformation issues, flat file loading issues, and Incorrect/Invalid data errors.

Creating data handling data load extractions from the ECC system through generic and LO cockpit methods and Troubleshooting V3 job failures and re-initializing data sources.

Extracting and monitoring data loads from multiple SAP and Non-SAP, flat file source systems.

Scheduling process chains and performing selective deletion from DSO’s.

Performing complete system sanity testing after downtimes and upgrades.

Performing pre- and post-activities during system upgrades and refresh activities.

Creating Start Routines, End Routines, and Field Routines based on business requirements and Debugging routines for troubleshooting data load issues.

Handling incidents, bug fixes, Non-standard changes, and moving the transport requests from development to the production system.

Created free characteristics, rows, columns, cells, and formulas, KPI using RKF, CKF, calculated and restricted key figures in Bex query designer as part of minor enhancement requested by the client.

Handling Analysis Office workbook issues and troubleshooting user authorization issues.

Performing housekeeping activities on weekends, including cleaning PSA and changing log tables using process chains.

analyzing repeated failures and providing permanent solutions as value adds for the client.

Worked on BEx Query Designer, BEx Analyzer and Analysis for Office for creating custom and enhanced reports for business.

Working on Bex functionalities like cell definitions, Exception aggregations, Offsets, Customer Exits, etc.

Generated different types web Intelligence reports using all the features- sub queries, merge dimensions, combining multiple queries, drill down, ranking, hyperlinks on Webi Rich Client.

Created Lumira, Design Studio dashboards, Web Intelligence and Crystal Reports Using data from SAP BW and relational database tables.

Trouble shooting Webi, Lumira, Design studio and Crystal reports issues.

Creating OLAP and Oracle database connections in BO and solving related issues.

Working on server configuration and creating servers instances on BO systems.

Scheduling reports to the email and to the shared locations using FTP and SMTP protocols.

Created medium universes using IDT (Information design tool) from relational data sources for workflow reporting.

Migrated universe from dev to test, acceptance, and production environments.

Creating new users, roles, access levels, and complete user management in BO.

Configuring LDAP and SAP authentications in BO.

Solving server-related issues and creating new servers and server groups in BO. Working on user management, servers, connections, and Monitoring

Maintaining DB connections and creating reports on Audit DB,relational database tables and Creating watch lists and mail alerts in BO Monitor.

Performing Saity tests on the system, pre-and post-upgrade activities in both BW and BO systems.

Stopping and starting BO servers from putty on the downtime and upgrade windows.

Troubleshooting technical or server issues in the BO system by going through servers’ logs.

Creating SOX documentation and SLR on every month changes and Incidents.

Handled tickets, Defects, Change Requests, and Problem tickets (RCA).

Maintaining Cutover Steps post and pre-transportation of SAP objects used for development and enhancements.

Education:

Completed Bachelor’s in Electronics and Communication Engineering from Acharya Nagarjuna University- 2017.

Contact this candidate