RAHUL KUMAR

Mobile: +1-718-***-**** ~ E- Mail: admy5p@r.postjobfree.com SAP BPC CONSULTANT

Need Work permit.Sponsorship to work in USA.

SYNOPSIS

A dynamic professional offering total 8 year of experience as a SAP BPC & SAP FICO Techno Functional Consultant (7 Years in SAP BPC) works for both BPC planning & consolidations as well.

Trained on SAP Cloud analytics from EY.

Strong experience in SAP Sales (Pre sales) for instance – Proposal creation for clients, Presentation to clients for SAP, Cost sheet, Client interaction for document submission, Payment follow up, invoices preparation for SAP Clients, Calling to SAP Clients.

Possess strong communication, collaboration & team building skills with proficiency at grasping new concepts and utilizing the same in a productive manner.

Effective interpersonal skills with abilities to meet deadlines & work under pressure.

BPC & BW Specific – (Worked in all phases of implementations), Work status, BPF, script logics, All Reports & complex Input schedule, Business understanding, Technical spec, functional spec, UAT, UT, SIT, Data loading from BW & Flat file, Controls and all system configuration in BPC. Highly experienced in financial statements for instances Balance sheet, PL, Cash Flow, Fixed assets schedules Etc as per accounting GAAP, SOLMAN for defects, Creation of Multi providers, Composite providers, Aggregates, Info cubes, DSO, Characteristics, Key figures, Query designer, Hana Studio/ Eclipse – Query creation from Hana Side, BW & BPC Transports, Open tickets with SAP & interaction with SAP to get the solution on issue, Taking interviews for SAP BPC for internal & External candidates, Software downloads from SAP Market place, SAP Notes apply in the systems, Hana Studio/Eclipse, Hana Views ( Calculation, Attribute, Analytic)

Skills- SAP BPC 7.5, 10, 10.1, SAP FICO, SAP BW, SAP Cloud Analytics and BPC Embedded S4 HANA 1610, Analysis of Office (AFO) Expert, JAVA, SQL. Macro, Consolidation Group Reporting HANA 1809, BPC embedded (RTC) Hana 1709.

4 End to end implementations full cycle (2 in Planning & 2 in Consolidation)

3 Short term implementations for short durations.

Out of total 7 implementations (4 were on standard BPC & 3 were on SAP S4 Hana)

Technologies wise implementations:

1.2 on SAP BPC Standard end to end implementations.

2.1 end to end consolidation implementation on Hana 1610- BPC Embedded.

3.1 end to end Sales Planning implementation on Hana 1710- BPC Embedded.

4.1 end to end implementation on Group Reporting – Consolidation – Hana 1809

5.4 standard implementations which were short terms not end to end.

Trained directly from SAP USA - Dallas on Group Reporting BPC Consolidation Hana 1809, this training was funded by my Current Organization HCL Technologies with the cost of $3500 USD along with other residential expenses.

EMPLOYMENT SCAN

Aug 2019 – Working Al Tuwairqi Group Lead Consultant

AL Tuwairqi Group – Saudi Arabia.

Basically it’s a support project & I am working as an In house Techno functional consultant here.

Its SAP BPC 10 NW Planning & Consolidation (Both) project. My tasks are:

Performing month end activities with Finance team to run consolidation activities with all steps.

After running that needs to check all Financial statements are giving perfect figures or not, Financial statements mean – Balance sheet ( Entity wise & console), PL (Same), Fixed assets schedule, Cash sflow statement, VAT reports etc. …. Most of the time when we run consolidation we always face issues, like some GLs are not giving correct balances & like retained earning has issues, some Gls are missing Etc, Other than that I also put JVs in all 4 modules which are for actual & final categories.. Here we have four models 1. Legal console 2. Zakat CONSOL 3. Cash flow 4. Management Consol.

I have overcome some major challenges & development from my end after my joining.

1.Models - Legal consolidation, Management Consolidation, Zakat Consolidation, Cost Planning, Manpower Planning, Quantitative Analysis (QA).

2.QA Model - is very complex which is made for costing profit/Production Planning & which has component like Material, Labor, Prime cost etc. based on Quantity and Amount .We have Material Heir at ECC, BW & BPC Level.

This model is 90% made in BW Rest 10% in BPC, In BW it has APD, Queries created on MP, Direct update DSO & Standard DSO.in MP we have 4 cubes. Created Hier for Material & GL for co code wise.

Data Loading from Cubes to Direct update DSO from process chain/Meta.

3.Performance improvement (Earlier running data managers were taking 2 -3 Hours, but it takes only 15 – 20 Mins).

4.Due to IFRS implementation I had to change the profit sharing ratio of affiliates companies, which already there was a code, so I had to replace that code with new code.

5.Development of AR/AP Affiliates report for legal consol. Development of Fixed assets report for legal console, Development of VAT TB.

6.Cash flow report changes where opening & closing had problems in the entire report along with periodic values.

7.Related party Report based on document types.

8.Created Production planning reports/Cost profit based on Contribution margin for 8 Co codes.

These reports are based on Qty, Variable cost, Fixed cost etc.

July 2018 – Aug 2019 HCL Technologies Lead Consultant

Project 2- Group Reporting Consolidation Hana 1809 – Mediakind USA.

All system configuration inclusive of master Data creation like consolidated COA, Dimensions, Ledgers, Versions, Consolidation frequencies, Consolidation Group, Consolidation Units & Hierarchies, Add Consolidation Data fields, Break down categories, Sub items, Number Range, Document type Based on 1SG Document & S4F95 Material.

Data collection for consolidation, Currency Translation, Data Validation, Validation rules.

Reclassification, Data Consolidation, Reporting for Consolidation inclusive Local & Group reports.

Data Monitor for running task, release universal Data, Balance carry forward.

Config of Intercompany elimination rules, Reclassification, Balance carry forward, Net income calculations.

Create custom analytical queries & use them in Fiori & in AFO, Transports, SAP Tickets creations & interaction with SAP to handle critical issues, SIT, UT, UAT, Solution manager for Defects, SAP Notes apply

All reporting for group reporting (Cash Flow, BS, PL, Equity report Etc) from Fiori, AFO.

Project 1 – Axalta Coating system USA & India – SAP BPC 10.1 embedded – Sales Planning on HANA 1709. Business deliverables based on Bex reporting with Analysis office.

Created Many planning reports with Bex query for Sales Planning for 18 Deliverables/Reports (Like – Country net sales, Matrices, Operation cost matrices, run rate modeler, Outlook summary for sales, Global early sales, Fixed assets, FX Outlook Etc.

The above reports were based on quarterly, YTD, Periodic values.

Worked on Data modeling in BW.

Worked on O data for Fiori Apps with O Data consultant.

Created composite provider & worked on Currency conversion in BEX query for Rates Data fetching from TCURR Table.

created multi providers based on actual & planned cube.

fields mapping from ACDOCA table to cube, Test script preparation for users.

Reconciliation of reports at cube level, Multi providers level.

Transport request (TR) movement, Defects downloads & update in SOLMAN & change the status in SOLMAN for ready to test.

System checking after transport with all info providers & reports, whether reports working fine, Master data.

HANA Data Modelling – Attribute view, Calculation view, Analytic view, Mapping ACDOCA & ACDOCP table fields to Info cube & Composite provider level.

SIT – All defect removal in reports in SIT.

Create composite provider, Multi providers. Char, Key figures Etc,

SAP Ticket raising for issues, working on change request post Go Live.

Transport collection in Dev & move it to QAS & PRD system for BW Objects, after checking all objects at all level.

Training to End users. Apse for All Documentations (FS, TS & BBP) For HCL & Sol Manager from client side.

Dec 2016 – July 2018 Ernst & Young Consultant

Working with EY.

Project -1 NBC universal – Planning project (USA-New York)

Project 2 - NZTA – (New Zeeland Transport Agency- Auckland New Zeeland) –Driver based planning

Project 3 - LPS – Indonesia (Worked onsite for LPS Planning project in Jakarta) – Opex, Capex & Financials – Planning Project

Project 4 – Open Text CANADA- S4 HANA 1610 Embedded consolidation project- Create info area, info objects char, Info object Key fig, Application component, Data source, Create transformation, DTP, Create Attributes, Create consolidation model, rate model, Ownership model, Create aggregation level, Query designer, AFO, Data loading from flat file etc, Work status.

Analysis of Office (AFO) Reports comprised - Balance sheet, PL, Trail Balance, Ownership, Fixed assets reports & other financial reports are prepared for the client, Query creation in Hana for reports.

All business rules (Ac transformation, BCF, Currency translation)

S4 HANA – Some basic knowledge of HANA - Trained on SAP HANA – Intro to Modeling, Hierarchy creation in HANA, Attribute view creation, Analytic view creation in HANA, Text join, system installation for HANA modeler, BW repository, etc.

Sep – 2015-dec 2016 Wipro InfoTech Associate Consultant

Aircel Limited - SAP BPC 10.1 Net weaver

Consolidation project – End to end implementation.

Worked on all phases of consolidation implementation (Requirement gathering, BBP, Development, UT, UAT, Sign off, Go Live, Post Go live support.

Development of all Financial statements (Balance sheet, PL, Cash flow, FA report, Changes in equity, IBA & other financial reports for IGAAP & MGAAP) at all Landscape.

Post Go live support.

Rules:

Carry forward

Account transformation

Interco elimination

Currency translation

April 2013 – Sep 2016 KPMG India Associate Consultant

KPMG INDIA -MANGAGMENT CONSULTING – IT Advisory

Project - 1

Maruti Suzuki India Pvt Ltd - SAP BPC 10 Microsoft – End to end implementation

Accountabilities:

Budgeting/Planning

Worked on all phases of planning implementation at all landscape (Requirement gathering, BBP, Development (Input schedules & reports), UT, UAT, Sign off, Go Live.

Models in Maruti Suzuki – Raw material Model, Sales, HR, Management consolidation & CAPEX.

ONGC TRIPURA POWER CORPORATION

Project 2 - Tender audit

To assess the eligibility criteria for Wipro, Accenture, L&T & KPIT for tender Bid.

There are some criteria for bidders for example.

Two Implementation projects should be more than 6 Crore, two support projects should be more than 1.5 crore.

Positive net worth certificates from the auditors, Insolvency certificate from the bank.

For implementation full agreement should be there with scope of services covered.

Such services should match with PO, Value in agreement should match with PO.

Balance sheet & PL with profit of the last three years, Certificate of incorporation.

Memorandum & article of association submission, existence certificate for last five years in SAP Implementation.

Bidder should have 20 SAP consultants on Pay roll, Bidder should have ISO 9001 certificate.

Bidder should not be blacklisted & went into litigation etc.

KUWAIT PROJECT – BPC 10.1-DEMO

Worked on BPC 10.1 for demo for the client of Kuwait.

Project – 3

BMW Financial services India – Internal Risk Management/ ITGC

Accountabilities:

Worked on 8 controls of IT audit for BMW for example, Interface between COFIS & SAP.

Calculation of Interest income, Penal interest & Pre payment charges, Interest amortization & EMI calculations.

Payment mapping inclusive of account payable & receivable, Offset of commercial loan with retail loan in SAP/COFIS.

Bank transfer instruction list – Loan approval method.

Documentation in E audit software of KPMG which is comprised of Signature & attachment of working notes etc.

Verification of completeness and accuracy of system generated reports like DPD report, reschedulement report, early termination report, VIN wise interest income report Etc.

Project – 4 – Orient Electric – SAP FICO Consultant

SOP of CO Module.

Report painter in CO module

Creation of sets by GS01 for grouping of Balance sheet & Profit and loss account.

Import & export of sets by GS08 & GS07.

Import & export of report by GR57 & GR58 T code, report creation by report painter.

Profit center mapping with cost center by creating groups VIA T code OKEON

Cash flow statement VIA T code FSI5, cost center wise budget upload

Profit center wise budget is matched with cost center wise budget

Cost center wise budget deletion, Upload of Profit center wise budget

Deletion of profit center wise budget & LSMW.

Creation of cost element, creation of cost element group.

Assigning cost element to Cost element group .creation of cost center by KS01.

Creation of profit center, costing run for price updation.

Creation of activity, Create company code, Fiscal year, variant, number range etc,MT940 transaction for book keeping

Quality process review (QPR) Documentation

QPR is documentation process of projects in which step by step achievements of projects & documentation.

QPR is consisted of:

proposal, SAN Risk eliminated, cost sheet, payment follow up mails, project number mail, partner approval

Invoices Etc, made QPR for more than 10 clients of KPMG

Dec2011 – Oct 2012 Siemens India Commercial Commercial Executive

Accountabilities:

MIS Reporting For Northern India, contract Billing in SAP, vendor Billing, excel Billing., credit note, cheques Handling.

Collection from debtor, creation Of purchase order, creation of WBS in SAP, contract Management in SAP.

Budgeting, Cheque Deposit in the Lakshmi Software, CST VAT & S Tax.

T codes in SAP - VF03,VA42,FB03,ME23N,CJ20N,IW75

June 2008 To March 2009 Met Life Treasury Accountant

Accountabilities:

Downloading of Bank Statements, Payment in SAP

Checking of Interface in SAP which is connected through Banks by FEBA T Code in SAP.

Upload MT 940 File in SAP by AL 11 T Code which have all bank related entries.

If MT 940 file does not get then up load Excel based sheet (JV), reallocation of funds from clearing accounts.

Bank Recs, posting of journal entries of Bank statement everyday by FB50 in SAP.

Reversal by FB08 in SAP, foreign Exchange Transaction, Fund transfer.

Reallocation by FAGLL03 from clearing Gls, coordination with Banks

Intercompany fund transfer (Sweep transaction), balance matching of all GL.

Month End activity

Cash Revaluation.

TRAINING ATTENDED

Sanjay Satpal & Associate for 3 months (Aug 2010- Oct 2010)

Accountabilities:

Made entries in Tally.

Worked on Special audit of B L Kashyap to asses the Variation in P&L

Conducted audit of Meenakshi Public school (Gurgaon Rajeev Chowk)

Assesed the cost of the projects, made New P & L account and found out the Variations in P & L, conducted BRS, Service tax and fund transfer activities.

100 Hrs computer Training on Internal Audit & Control by First Computer from Institute of Cost Accountants of India (ICAI).

SCHOLASTICS

CMA\ICWA(Cost Accountants)4th Group – Completed in December 2012

CMA\ICWA (Cost Accountants)3rd Group – Completed in June 2012

CMA\ICWA (Cost Accountants) 2nd Group – completed in June 2009.

CMA\ICWA (Cost Accountants)1st group completed in 2009 Dec.

M.B.A(Finance) from Symbiosis Center of Distance Learning .

B.Com. (Hons) from Shaheed Bhagat Singh College (M), Delhi University, India.

JAVA certified from Edu plus institute Dwarka Delhi, India.

IFRS.

PERSONAL DOSSIER

Linguistic Abilities : Hindi, English.

Present Address : 20 Cooper Square, New York, NY 10003, USA

Marital status : Married

Languages : English, German (Basic), Hindi

Contact this candidate