+1-636-***-****

ad4b5n@r.postjobfree.com

Professional Summary:

16+ years of IT experience on SAP BW/4HANA, SAP BW on HANA, SAP Enterprise HANA and SAP ABAP

Expert analytical skills coupled with interpersonal, communication, presentation and self-organizing skills with strong problem-solving abilities and effectiveness in working independently, as a team lead and as a committed team player.

Expertise in SAP BW/4HANA, SAP BW on HANA, Native Hana Modeling, SAP Enterprise HANA, SAP ABAP and SAP Analytic Cloud, SAP Analysis for Office, Design Studio, BOBJ, Power BI development

Excellent knowledge on: SAP BW/4 HANA, Advanced DSO(ADSO), Open DSO Views, Transient Providers, Composite Providers, Hybrid Providers, Publishing HANA Model in SAP BW, SAP BW Security, Import SAP NetWeaver BW Model to HANA, LSA and LSA++, ODP API like SLT

Excellent knowledge on SAP BW 3.5 and all 7.0 versions InfoObjects, DataSources, Insources, InfoCubes, DSO, Multiproviders, Transformations, Info packages

Experience in migrating to SAP BW/4HANA

Extensively worked on LO Cockpit, FI-GL, CO-PA, HR, Generic Data Source, DB Connect customization and extraction.

Experience in advanced analytics (LSA++ Architecture).

Experience in ABAP/SQL for BW/4HANA programming (AMDPs).

Experience in SDI, STL, ODP, and SDA data provisioning methods.

Experience in Stored procedures, AMDPs, and functions. Strong working experience in data analysis, design, development, implementation and testing of data warehousing using data conversions, data extraction, data transformation and data loading (ETL).

Expertise in ETL techniques and proficient in loading techniques such as Full load, Delta load and also in data modelling.

Experience in Query Browser, KPI Designer, Analytics Path Framework Modelling, Analytics view pages, Report Design and Query Design

Extensively used Service Now tool to log incidents, track defects, generate reports and create Change Requests.

Knowledge in SAP-IP Integrated planning

Knowledge in BPC 10.0 with support experience

Technical Skills

Data Warehousing Tool : SAP BI 7.5, 7.X, BW on Hana, BW-IP, BW4HANA.

Planning and Consolidations : SAP BPC 10.0/10.1/11, SAP Analytics Cloud Planning.

Reporting Tool : SAP Business Explorer, BOBJ, SAP EPM and Analysis for Office,

SAC, Design Studio

ERP : SAP R/3

Database : Oracle, HANA

Languages : C++, SAP BW ABAP

Certifications

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

IBM Enterprise Design Thinking Practitioner

IBM Retail Industry Jumpstart

IBM Automation: Compass V2 badge

Education

M.C.A from Osmania University May 2003.

BCom (Commerce) from Osmania University.

Employment

Employer

Designation

From

To

Danta Infotech LLC

SAP BW consultant

Apr 2023

Till date

TCS

Associate Consultant

Aug 2022

Feb 2023

IBM

TEAM LEAD, SENIOR ADVISORY CONSULTANT

Oct 2008

Jul 2022

SUNVIEW CONSULTING PVT LTD

Associate Consultant

Oct 2007

Oct 2008

Project Thesis

Client : IFF (International Flavors & Fragrances) Apr 2023 – Till date

SAP BW on Hana Consultant/BW4HANA

Instrumental in requirement understanding, Build the objects, Testing, Cutover and handover Build, cutover and promoting the changes to Production

Analyzing the data load activities and set up process as its recently gone live

Worked on Currency conversion issues

Design and Build of the assigned Change Request’s including Analysis

Provide solutions on the CR’s, attended Design forum workshops to provide alternate/most feasible solutions to CR’s

Worked on BW reports authorization issues

Updated LO Extractions and set up table as part of the assignment

End and Start routines ABAP logic as required

Detailed documentation of every CR i.e Functional specification and Global configuration document creation.

Worked on CDS Views by creating CDS views and pulling the sales data into BW

Resolved a complex master data issue which was effecting all the transaction data loads

Worked on Native HANA modeling related to HANA Calculation views, stored procedures and table functions as part of the assignment

Client : DuPont Aug 2022 – Feb 2023

SAP BW HANA Consultant

Involved in Business requirements gathering and Preparation of Technical Specifications documents and Training guides.

Worked on Calculation views, ADSO, Composite Providers

Worked on resolving issues with Complex Queries and BW reports

Add ABAP code in Start, End Routine and InfoObjects by InfoObjects in Transformation, CMOD, and Customer EXIT.

Client : BBC Feb 2021 - July 2022

SAP BW Hana Consultant/BW4HANA

Gather Business requirement for the change requests, development and promoting the changes to production

Conducting Business workshops with Business users for requirement gathering

Prepare Design documents and Process flows for Common and Business unit Specific Scenarios

Handled High Critical P2 and other priority incidents as part of AMS

As a team lead helped the junior team in resolving the issues in process chain loads

Worked on high complex CRs as part of enhancement

Worked on the HANA Calculation views and optimization

Analysis for office used for Reporting

Performance tuned the FIGL report from 3min to 80seconds

Trouble shooting and fixing issues related to SAC dashboards

Client : PZCUSSONS Aug 2017 – Jan 2021

SAP BW on Hana Consultant

Handled high critical P2 and other priority incidents as part of AMS

Worked on High complex Change requests

Experienced in working on native HANA modeling related to HANA Calculation views and optimization

Analysis for office used for Reporting

Performance tuning of the reports which are taking long time to run.

The sales report was crashing in Analysis office. Analysed and resolved the issue as multiple exit variables was having issue

Currency conversion was not working and worked on Enhancement in the calculation view to get the conversion correct

The BI Report crashing due to length exceeded more than Actual. In the backend, the keyfigure was updated by increasing the length, created data domain and mapped it across. This had impact and had to be adjusted by activating the composite providers across the landscape.

AO was limited to 5lakh cells and user experiencing issues resolved

AO issues with templates breaks and corrective actions have been performed to resolve the issues by connecting the query back in AO

Helped the Graduate Hire Team to monitor for resolving the issues in process chain loads

Authorization at Reporting was limited to Plant and profit center through Authorized dso with Security knowledge– resolved issues

Native HANA modeling related to Calculation view lock issues resolved by updating the activity issues in HANA and Ability to apply traces to fix issues

Involved in requirement gathering analysis, developed Blueprint and rendered Business Troubleshot and resolved production issues including process chain failure and reports number not matching with SAP and develop new Z data flow (Z Source, DSO, Cube, DTP, transformation, Bex) as per requirement.

Client : Lam Research Jul 2010 - Aug 2017

SAP BW on Hana Consultant

Managing the BI team of four. Working on the tickets assigned. Monitoring the process chains which runs 24/7. Fixing the critical/non critical job abends with in the SLA. Working with the MMIO team and Basis team in resolving the issues related to Job abends.

Supporting Performance tuning activities. Housekeeping activities for Master data, Cubes and DSOs in production system. PSA/Changelog cleanups

Coordinating with the onsite team on the assigned tasks and getting the things done.

Supporting the upgrade projects which requires clearing delta queues in ECC system during upgrade and testing of the process chains and resolving upgrade related issues.

To work on other tools like ISM Maximo for creating Change requests in LAM for transporting the objects to the production systems.

Giving KT to the new joinees. Helping the new joinees through smooth onboarding process and guiding them with all the setup process required for the client.

Running the Weekly version setups for Phoenix Phase 1a and 1b on Sundays which is a weekly weekend activity.

Developed custom programs for versions deletions from BPC cubes and created process chains

Worked on routines, variable exits

Developed program to delete data from the BPC audit tables based on the versions

Worked on open hub destinations to export the master data to flat file and open hub extracts from query to .csv files

Archiving the cubes/DSOs data to NLS (Near Line Storage)

Monitoring and fixing issues related to critical and Non critical job abends

Worked on different enhancements on ECC datasources and in BW

Worked on developing dashboards in Design Studio

Worked on converting Multi providers to composite Providers

Creating change requests in service now tool

Worked on Open Hub extracts where Query is the source and .csv files are the targets

Client : KAO Brands May 2009 - Jun 2010

SAP BW Consultant

Extensively worked on the new development and enhancements of the queries and Workbooks

Involved extensively in the enhancements of the Infocubes and Multiproviders

Involved in the documentation of all the technical specifications of the enhancements and new developments related to the queries, workbooks, and infoobjects

Validation for the correctness of the data after the enhancements of the reports

Involved in identifying the data loads which are taking long time to run in the Production system and also provided solutions to improve data load performance

Involved in preparing Functional Design Specifications based on the business requirements.

Worked on extraction of data from legacy systems, flat files, and SAP R/3 using Business Content Extractors (LO Cockpit), CO-PA, and Generic Extractors.

Used data staging via Persistent Staging Area (PSA) to update Info Providers with Master Data and Transactional Data from SAP R/3.

Used ODS Objects as intermediate storage for data extracted from external systems to further update from ODS Objects into Info Cubes using update rules.

Used Formula Builder and Routines to create Transfer rules and Update rules for loading data into ODS Objects and Info Cubes.

Created Info Set queries involving ODS Objects and Master Data Info Objects, and MultiProvider queries involving ODS Objects and Info Cubes to improve reporting flexibility.

Created Aggregates and Indices on Info Cubes to improve reporting performance.

Involved in BW security, created Roles and Authorizations for Info Cubes and other Metadata objects.

Assigned Workbooks and reports to specific roles and users in BEx Browser.

Designed BEx Queries with Filters, Free Characteristics, Calculated and Restricted Key Figures, Variables, Conditions and generated Reports with Exceptions.

Created process chains to automate data load processes and monitored the scheduled process chains.

Client : Nycomed Apr 2009 - May 2009

Associate SAP BW Consultant

Worked on the Generic Datasources with respect to function module

Validation of datasources data present in the Extract checker (RSA3) with SD related transparent tables after making changes to the function module

Capturing the Datasource, function module in the transports

Documenting all the process chains used in the Production system

Documenting the technical specifications, test scripts of all the queries present in the Production system

Documenting all the Custom cubes and the standard cubes present in the production system

Client : AT & T Oct 2007 - Oct 2008

Associate SAP BW Consultant

Involved in designing/developing/configuring the SAP-BI Objects Info Objects, Info cubes Info sources, ODS, Data sources, Transfer Rules & Update Rules, Transformations, DTP’s, Info providers, Multiproviders, Info package, Process Chains Activation and Enhancement of Business Content, APD.

Created formula variables with replacement path to calculate Billing document count and data calculations.

Created various process chains for master data, transaction data and hierarchies.

Improved performance of queries using compression and aggregates

Prepared Blueprint Document based on the requirement given by the client.

Worked on SD cubes with standard Logistics data sources and generic data sources.

Contact this candidate