Contact Details

Mobile: +60-111-***-**** Email: ad4h5x@r.postjobfree.com

Professional Summary

For over 12 years, I've been immersed in the world of SAP BW/BI, BW on HANA, and Embedded BPC. I've played a pivotal role in every stage of the business application lifecycle, from initial implementation and ongoing support to seamless upgrades, migrations, and rollouts.

Business Areas - Sales and Distribution, MM Inventory, HR, MM Purchasing, FI-GL, PP.

Good understanding of Data Modeling using BW Extended Star Schema.

Expertise in BW/BI – ADSOs, Composite Providers, Info Cubes, Info Sources, Info Object maintenance, ODS Objects, Update rules, Transfer rules, DSO objects, DTP, Transformations, Data source, Info package, Info set, Multi provider, Etc.

BW on HANA – Calculation views, Composite providers using HANA Calculation Views and ADSOs.

Embedded BPC – Planning ADSO, Planning Filters, Standard and custom Planning Functions, Planning Sequences and Input ready queries.

BW/BI Reporting - Business Explorer Analyzer and Analysis for Office.

Customizations - Logistics Cockpit configuration and customization, Generic extractors & Enhancement of data source.

BW/BI Backend consultant – LO-Cockpit, Generic extraction.

Experience in process chain management, Monitoring and scheduling the batch jobs

Good Knowledge of ABAP Dictionary and BI related ABAP.

Good Knowledge in WebI.

A team player with exceptionally good organizational, analytical and interpersonal communication skills.

Education

Master of Computer Applications from Andhra University.

Professional Experience

Organization

Duration

The eCEOs Sdn Bhd

Feb 2021 – Till date

Capgemini Malaysia

Sep 2019 – Jan 2021

Infosys

July 2018 – Aug 2019

Tech Mahindra

Feb 2013 – June 2018

IBM India Pvt Ltd

Aug 2011 – Apr 2012

Skills Set

SAP Expertise : SAP BW 3.5, BI 7.0, BW 7.5 on HANA with Embedded BPC.

Enterprise Application Tools : SAP ECC 6.0

Reporting Tools : WebI, BEx Analyzer, BEx Designer, Analysis for Office.

Other Tools : Remedy, Footprints, HP ALM, TFS and DevOps.

Work Experience

Project 7# Support

Company The eCEOs Sdn Bhd., Malaysia

Project/Client CaTS DevOps, Petronas

Role Senior Consultant

Duration Jan 2023 to till date.

Roles and Responsibilities:

Conduct thorough root cause analysis to identify and address the underlying causes of user issues, ensuring timely and accurate resolution.

Offer comprehensive assistance to users in their daily activities, enhancing productivity and satisfaction.

Oversee the entire change request lifecycle, from design to deployment, ensuring smooth implementation of system updates and improvements.

Monitor month-end data loads and collaborate with FICO on reconciliation activities to maintain accurate and reliable financial information.

Project 6# Rollout

Company The eCEOs Sdn Bhd., Malaysia

Project/Client CaTS Phase2 Rollout (Petronas)

Role Senior Consultant

Duration Feb 2021 to Dec 2022

Company Capgemini Malaysia

Project/Client CaTS Phase2 Rollout (Petronas)

Role Senior Consultant

Duration Sep 2019 to Jan 2021

Roles and Responsibilities:

Constructed robust planning objects, including ADSOs, aggregation levels, planning functions, filters, sequences, and input-ready queries, for seamless planning operations.

Developed Analysis for Office Workbooks, enabling users to directly save planned data to ADSOs using planning sequences, fostering efficient data management.

Used copy, delete and repost planning function extensively.

Created custom planning functions and formula functions to address specific planning needs and enhance flexibility within the system.

Designed HANA Calculation Views using joins and unions, enabling efficient data aggregation and retrieval.

Comprehensively leveraged input variables to tailor calculations and enable dynamic data manipulation.

Developed composite providers on HANA Calculation Views using joins to construct adaptable data structures, maximizing data utility.

Enhanced existing HANA Calculation Views by incorporating new fields and modifying logic to meet changing business needs.

Refactored ABAP transformations into AMDP transformations, leveraging HANA's in-memory capabilities for performance optimization.

Conducted technical UAT to guarantee system reliability and functionality.

Prepared clear and detailed technical documentation on developed objects to facilitate understanding and maintenance by other team members.

Project 5# Migration

Company Infosys Ltd.

Project/Client BI Transformation (Kone Corporation)

Role Senior Assoc Consultant

Duration Dec 2018 to Aug 2019

Roles and Responsibilities:

Streamlined data flows by strategically migrating from LSA to LSA++ architecture, leveraging ADSOs and Composite Providers for enhanced performance and flexibility.

Migrated DSOs, Info cubes to ADSOs and Multi-providers, Infosets to composite providers using join conditions from HANA Studio.

Developed queries on composite providers and published the queries to menu roles.

Leveraged SAP HANA's in-memory computing power by building Attribute, Analytical, and Calculation views for lightning-fast data analysis and reporting.

Optimizing the ABAP code in the transformations.

Created portal views on Bex queries to be consumed by portal users.

Project 4# Development

Company Infosys Ltd.

Project/Client DLM Optimization (Kone Corporation)

Role Senior Assoc Consultant

Duration July 2018 to Nov 2018

Roles and Responsibilities:

Optimizing the process chains based on the dependencies.

Used events and interrupts to handle the data flows.

Eliminating the regional dependencies in the data load using global filters.

Automated the manual steps in process chains based on the events and interrupts using third party scheduling tool.

Project 3# Development and Support

Company Tech Mahindra Ltd.

Project/Client Arthrex BICC

Role Senior Software Engineer

Duration April 2015 to June 2018

Roles and Responsibilities:

Involved in BW7.5 on HANA migration.

Played an active role in developing, customizing data sources using view and function module.

Derived Material Classification Master Data in BW using transactional data.

Used APDs to load data from query as Info Provider for Non-Cumulative key figures.

Used queries as Info provider to load data to targets.

Designed and developed process chains for transaction data loads with the help of Info Packages. And these Process chains are scheduled for periodic loads.

Designed and developed House Keeping chins to delete PSA.

Played an active role in developing DSO, Info Cubes and loading data from different source systems.

Created custom queries and defined Calculated Key Figures, Restricted Key figures.

Played an active role in ABAP routines in BI system like start routines, end routines and transfer routines.

Played an active role in cut over activities for LIS data sources as part of Go-Live.

Project 2# Implementation

Company Tech Mahindra Ltd.

Project/Client SPMCIL

Role Software Engineer

Duration Apr 2013 to March 2015

Responsibilities:

Installed and customized Business content in BI and ECC. Activated data sources in ECC for Transaction data and Master Data.

Installed the business content standard reports in SD, MM, FI and PP modules played an active role in extracting data i.e. SD, MM and FI data.

Demonstrated proficiency in controlling data flow using DTPs, transformations, and various process chains.

Setting up of procedures for extracting data from SAP ECC 6.0 and Customizing Data sources as per requirements.

Played an active role in developing DSO, Info Cubes and loading data into them.

Created & Used Variables with User Entry/default Value & Replacement Path.

Designing BEx queries using filters, Variables, navigational attributes and structures for detailed drill down data analysis to get required level of information.

Installation of standard report as per client requirement

Developed the Reports by using BEx Explorer

Designed and developed process chains.

Project 1 # Support

Company IBM India Pvt Ltd

Project/Client Cable and Wireless Worldwide, UK

Role SAP BW Consultant

Duration Aug 2011 to Apr 2012

Responsibilities:

Proactively monitored and optimized daily, weekly, and monthly data load chains, resolving any failures with swift action.

Analyzed Info Package performance, identified root causes of recurring issues, and implemented effective solutions.

Maintained meticulous documentation of all data load tasks and issues, ensuring complete records for future reference.

Performed regular data reconciliations between SAP ECC and SAP BW, verifying data integrity after weekly and monthly loads.

Actively participated in BW cut-over processes associated with ECC stack upgrades, ensuring seamless data migration.

Responsively contributed to Change Request execution, supporting project initiatives and data model modifications.

Provided flexible data refresh capabilities through manual and scheduled chain execution, based on user needs.

Integrated newly created data transfer processes (DTPs) into automated scheduling mechanisms for smooth data flow.

Contact this candidate