Project Manager

Sunil Rohilla Cell no: 509-***-**** *********@*****.***

SAP- Solution Architect - SAP FICO/FICA/FSCM Skype ID: Sunil_rohilla

Over 21 years of total experience after completing Business Administration in Finance Management from a reputed Management Institute “Symbiosis (SIMS)” from Pune, India.

Currently, working as an FICO Lead for Paragon Offshore Drilling in the new Implementation of Banking, EBS along with other production support activities.

SAP HANA Certified experience of Proof of Concept (PoC). Have installed SAP HANA on Amazon web services on cloud and have good understanding of SUM Tool for conversion.

Have good understanding and worked on PoC for SAP PRA (Production Revenue Accounting) for joint venture Accounting.

Global Rollout project with Template for Latam Countries for Mexico, Argentina, and Columbia.

Earlier worked as Practice Manager for Oil & Gas, Utilities and Public Sector.

I have more than 17+year’s experience in SAP FICO, FICA, and FSCM starting from an FICO Consultant, Project Manager, Program Manager, and Solution Architect and as a practice Manager along variety of projects experience form SAP end to end implementation. SAP Production Support.

Worked for Utilities Industries with more than 4 years of experience in FICA related activities and integration with Device Management, AMI (Advanced Meter Infra structure) and also fair understanding with ETRM (Energy Trading and Risk Management).

Handled Account Manager and Project Management role for last 5 yrs and opened new accounts for India’s leading company by working as Principal Consultant at Owens Corning, Ohio, e-Bay, San Jose, CA, M.U.D., Omaha, Nebraska, Applied Materials, Santa Clara & Warner Bros to name few

Working with large maintenance project transitions to Onsite and offshore Model which are in the range of 2- 5 Million USD.

Worked for Middle East and South Africa companies as a Solution Architect and provided some of the good solution and converted into project which has benefit client as well as organization such Kewalram Textile, DEWA, FEWA etc.

Good understanding of ASAP Methodology and other testing tools used or data Migration and up gradation project. We also have Veloci-Q as an Internal Tools utilized for auditing as well testing purpose and very good understand of customization/enhancement and Record to Reporting (RTR).

Good Understanding of EBS, Banking, Treasury and also 3rd party solution such as Open Text Read soft which was used for interfacing with SAP AP system.

Have worked in USA for service & manufacturing related industry which are extensively integrated with CRM. Have helped from FICO point of view in implementing Texaware.

Worked on PoC for Funds Management and Grants Management for Manitoba with CRM Module.

Have worked for Onsite/Offshore Model for Multinationals, Multi-linguistics & Multicultural people in India and outside India. Also, SAP Implementation for Japanese, European and US client from Hong Kong, Singapore, United Kingdom, Poland and Denmark.

Have Good Knowledge about the European Union (EU) and Non EU Finance and Tax related matter after working in United Kingdom, Poland and Denmark.

Have worked almost 4 years experience in the Corporate Finance division before entering into the field of SAP. Have good knowledge Finance related matters like Treasury & other various formalities in Import, Export, and Banking and also in Foreign Exchange.

Have been in the support role for FICO module and have supported approximately 300 users at a time in India’s largest Automobile Manufacturing Company.

Handled Presentment, Data Archiving related project using ADK Tool (DART) along with Open text

Product Costing Implementation and Material ledger in one of most complex and largest Automotive Industries scenario. Worked extensively in the field of Costing and profit center accounting.

Worked on CIN 2.1B version of Taxation for providing various automotive taxation solutions.

Recently undergone In-house training for Business Warehouse (BW), Strategic Enterprises Management (SEM) in BPS (Business Process Simulation) and CPM (Corporate Performance Management.

Have done E-Biz course for understanding the various e-enabling application.

Good team player, Strong team orientation & leadership qualities, hard working and enthusiastic and lead the project for SAP Implementation with European Client.

Have good understanding of business processes in Logistics.

Very good logical skills suitable for process design, development & implementation.

Excellent communication and presentation skills and Customer Oriented attitude.

IT EXPERIENCE (Descending order)

Nat soft Corporation 1 year

Tech Mahindra (erstwhile Mahindra Satyam), Pune, Mumbai, India 5 years Solution Architects / Principal Consultant for SAP Finance- North America.

Guru Solution, Fremont, CA 0.6 years Project Manager.

Cap Gemini US LLC, Burbank, CA 1.8 years Global Finance Team Lead

Wipro Technologies, Pune, India 6.5 years Program Manager

Tata Technologies Limited, Pune, India 2 years SAP FICO CONSULTANT

EDUCATION

Post Graduate in Management studies (MBA), Symbiosis Institute of Management Studies, Specialization in International Finance and Marketing. (1994-1996)

Bachelor of Technology in Instrumentation Engineering (B.E.) from PREC, Pune University, Specialisation in Microprocessor Technique from Pune India. (1990-1994).

Leadership Course (Online/Practical Classes) for Project Management from Singapore University (2013-2014)

Please refer Annexure for detailed project list

SAP PROJECT DETAILS (Descending order)

PROJECT 19

Client

3M, St. Paul/Minneapolis

Duration

FEB, 2017 onwards

Project

Treasury Consultant – Global Operation Support - GOS

Position

Treasury Lead Consultant

Contribution

Configuration, Major and Minor Enhancement, Unit Testing, User Acceptance testing for Implementation of various business scenarios.

Working with various Banks for interfaces with SAP PI Mapping, Swift.Net through BCM (Bank Communication Management).

Monitoring of BNK_MONI for various banks and issues related to the same activities.

Treasury Manager for product such IRS (Interest Rate Swap), Bonds, Derivatives etc. and updation of Reference Interest Rates and handling of performance through TJ05/TI12.

In-house cash handling through Payment Order – External and Internal – IHC0.

Netting process for Intercompany and Vendor through IHC.

Hedging and Hedging Exposure 2.0

Handling of Issue of mass volume of payment orders for F110 and F111.

Cash Pooling and ZBA Transfer with Automatic clearing through Bank search string.

Cash Management – Cash and Liquidity Forecasting.

Upgrade from SP09 to SP10 and handling issues related to IHC.

Environment

SAP ECC6 with EHP7, SP10

PROJECT 18

Client

Paragon Offshore, Houston (Oil and Gas- Drilling- Surface and Deep Sea)

Duration

June -16 to Feb, 2017

Project

Banking Interface- Outgoing and Incoming & Production Support

Position

FICO Lead Consultant

Contribution

Single Handle worked for Business Blueprinting, configuration, Unit Testing, User Acceptance testing for Implementation of various payment method –

ACH, Fed Wire, Check, SEPA etc. through PEXR2003 and interfacing with BoA.

Fixed the issues with Revaluation or Remeasurement of Foreign currency issues,

Implementation of SAP BAI2 – Incoming File with limited scope and later other addition will be carried out phase wise manner.

Revaluation Issue and other support related activities.

Handling Day to Day to other production support related activities related to Plant Maintenance.

Environment

SAP ECC6 with EHP7, SP5

PROJECT 17

Client

Microsoft Technologies, Redmond, Seattle

Duration

July -15 to June, 2016 (11 months)

Project

FICO/FICA Consultant at SESIT (Strategic Enterprise Service and information Technologies)

Position

FICO/RMCA/FICA/RAR 1.1 Consultant for production support

Contribution

Working from realization for the Collection and dispute Management System The following items has been worked in the collection management system which are:

Dunning Procedure and Enhancement and customization reporting.

Collection Management, Collection Strategy with customization and enhancement.

Dispute Management

Ability to Send Statements to Customers

Ability to Send Dunning Letters to Customers

Payment Run for Contract Accounts Receivables and Payables (FICA)

Existing data feeds to IQMA (Invoice Query Management Access) Production support handling in BIT handling within RMCA

Also working for Treasury In-House Clearing (IHC) with all Banking configuration in BAI2 and other mapping requirement with Biz Talk. Also worked on Bank Communication Management (BCM) with SWIFT network.

Revenue Recognition (RAR 1.1) ( Billed and unbilled Revenue Recognition) based on service related categories B and BRFplus Workbench

Activation of Revenue Accounting Classes, contract and POB (performance obligation)

Environment

SAP ECC6 with EHP7, SP5

PROJECT 16

Client

FMC Technologies ( Oil and Gas- Upstream Services- Subsea and Surface )

Duration

Jan-15 to Jun, 2015 ( 6 month)

Project

Rollout Project – FICO Consultant at Houston, Texas for Mexico

Position

FICO Lead Consultant –Houston

Contribution

Recently, rollout Global template for Mexico and transitioned to Mexico team for further taking it to Latam Countries with Global+ Local requirement (6 month).Rollout project for product costing.

Preparation of all additional FS FOR Mexico –Electronic Accounting-S.A.T, Deferred Tax to VAT movement, Faced the challenge of multiple currencies handling in the company code to ensure that both US GAAP and Mexico GAAP reporting can take place from SAP.

Rollout project and extending the company code to Treasury with Non-USD exposure with IHC handling

Data extracted from SAP and sent to BI reporting purpose.

Interface handling to Buzon, Baking Interface – BAI2 for Bank of America.

Also, worked on product costing result key analysis and product costing being Make-to-Order.

Handled Data Presentment and Archiving rollout project with Open text through ADK Tool (DART) for e.g. FI_DOCUMNT and CO objects.

Environment

SAP ECC6 with EHP6, SP14 up gradation package.

PROJECT 15

Client

Pratt and Whitney – Canada/Houston and Public Sector Manitoba

Duration

Mar, 2014 – Jan 2015 ( 10 months)

Project

Production Support for NEW GL for Pratt and Whitney Canada Project

Position

FICO Consultant with hands on at client premises at Quebec

Contribution

FI support Lead and Rollout Project

Working as Team Lead for production related Issue for Banking and working for other change request for project with FICO, MM, SD, and Project System team to complete the various configurations related to FICO area.

Also, involved with Rollout project for GL account with additional accounts finalization for Banking, AR, AP and Asset Accounting. Global Trade Services Integration (GTS) by activating and extending the existing feeder system to new organization structure and legal Units, Foreign Trade Organization, Foreign Trade, Item Category, Partner Function, Country Groups etc.,

SAP Funds Management and Grant Management with SRM (including Public Procurement Services and integration with CRM for Grantee relationship for Manitoba, Canada

Environment

SAP ECC6 with EHP4 up gradation package.

PROJECT 14

Client

DEWA (Dubai Electric & Water Association), Dubai

Duration

June 2013- Jan, 2014 (8 months)

Project

Production Support Lead and Implementation for FICA

Position

Production Support -Onsite

Contribution

NEW GL Implementation, Document Splitting.

Business Partner and AR synchronization

Handled Dunning Procedure customization with Workflow to connect and disconnect with AMI (Advanced Meter Infrastructure system.

Collection Strategies and dispute Management

Customization and Integration with Insurance and claim system

Billing Estimation reading with MR units (Device Management), unbilled revenue reporting

Environment

SAP ECC6 with EHP4 up gradation package.

PROJECT 13

Client

Land Transport Authority – LTA- Singapore

Duration

Jan 2013- June, 2013 ( 6 months)

Project

Production Support Lead and Implementation for Treasury & Fund Management updation -BCS

Position

Production Support Manager-Onsite

Contribution

FI Implementation

Fund Management and Treasury Upgrade Project from SAP 4.6 to ECC5 and Production Support handling for GL, AP, AR and AA

Plant maintenance process and Fund Management is established by entering an FM account assignment (commitment item, funds center, and fund).

Derivation Rule for FM Account Assignment Element for CO Assignment.

Derivation of Commitment items

Order Settlement.

Fund Reservation

Fund Management- Budget Availability with Workflow system- BCS

Integration with CRM for Grantor and Grantee for allocation of Budget and preparation of Flexible Budget.

Used BRF (Business Rule frame for various integration and special requirement)

Environment

SAP ECC6 with EHP4 up gradation package.

PROJECT 12

Client

REC Silicon, Moses Lakes, WA

Duration

Oct, 2010- Jun, 2011 (9 Months)

Project

Production Support Lead and Implementation for Process Costing for Chemical Industry

Position

Production Support Manager-Onsite

Contribution

FI support Lead

Working as Team Lead for production related Issue for NEW GL and other activities Banking and working for other change request for project with FICO, MM, SD, and Project System team to complete the various configurations related to FICO area.

Process Costing with Procurement Alternative and Mixed Ratios: This is very unique business requirement due to various product outcome along with By-product and Co-product material. Assisting with SAP America to streamline the process and to carry out the process costing.

Environment

SAP ECC6 with EHP4 up gradation package.

PROJECT 11

Client

Warner Bros, Los Angeles, California

Duration

Jan, 09- Oct, 10 (1.8 years)

Project

Production Support FICO Global Lead

Position

Production Support Manager-Onsite

Contribution

Banking & other FI support Area: Working as Team Lead for production related Issue for Onsite and offshore team for Banking, Product Costing & Material Ledger. Also, working with other change request for project with FICO, MM, SD, and Project System team to complete the various configurations related to FICO area. Worked on Banking IDoc smooth daily uploading file after applying OSS patches which was an issue here in WB.

Also, working with recent transition with offshore and helping offshore team for smooth transition at various locations in India, Poland and USA.

Product Costing & Material Ledger: Working as Team Lead for the Global Product Costing release and Material Ledger for Warner Home Video (WHV). Also, working with offshore team for daily support assistance required time to time for various tickets. Material Ledger with Price Determination (Single/Multi) along with revaluation of consumption which is mandatory requirement in Brazil. Also, worked on the invoice of Nota Fiscal Electronica (NFE).

Environment

SAP ECC5

PROJECT 10 29th Aug, 08- Jan, 09

Client

Applied Material, Santa Clara, California

Duration

Aug, 08-Jan 09 (6 months)

Project

Solar Business Group SAP ECC6 Implementation

Position

Sr. FICO Lead

Contribution

Worked with FICO, MM, SD, Project System team to complete the various configurations related to FICO area in the field of Revenue Recognition, Backlog Booking and Billing system and result key analysis and settlement of various cost and booking WIP for Title of good and reporting of the same till final Title Transfer.

Further, working in the area of FICO configuration for freezing the cost center, profit center Hierarchy & GL account finalization with SAP and business team.

Also, involved in the month and year closing requirement for AMAT related activities with centralized system.

Environment

SAP ECC6

PROJECT 09 1st Jun, 08- 27th Aug, 08

Client

Kennametal Inc. Latrobe, Pennsylvania

Duration

4 months

Project

Data Conversion for existing into separate landscape and Archiving

Position

Project Manager

Contribution

Worked with FICO, MM, and SD, PP team to complete the 42 various extraction, closeout and upload program. The data cleansing was done through MS access for all the validation. This include separate for infrastructure hosting for SAAP 4.6C installation and copy of the system and then unit testing within very strict timeline. We contributed by working hard and providing comfort level for IT team and confidence to “ Go Live” as per given timeline.

Worked further in archiving objects for FICO and COPA segment transaction with the help of DART – Data Archiving and Retention Tool- SARA and SARI (Archiving Management Module) through Archiving Development Kit.. The Input and output parameters was discussed with business before archiving the data so that the same will be available for reporting purpose to the auditing team for later stage. The data was written and then deleted from the SAP server and was brought to the data management server. The reporting can be fetched as per the business requirement.

The archiving done for the condition record and it was first updated to the specified path and then deleted to save the memory data by 5 GB.

Environment

SAP 4.6c version

PROJECT 8 15th Nov, 07- 29th May, 08

Client

Apple Inc., Cupertino

Duration

6 months

Project

e-Invoice Automation

Position

FICO Module Lead

Contribution

Working at the conceptual design and solution for the paperless Invoicing through the third party “Readsoft” and validating all Invoices and automation of the sap for all US/Canada, EMEA and APAC region.

Worked on Optical Archiving of the digital images which were once matched with the physical Invoices and then later deleted the data and brought to the different Data Management Server.

Customized Revenue Recognition Accounting solution

Environment

SAP 4.7 version

PROJECT 7 15th Jun, 06 – Nov, 07

Client

Metropolitan Utilities District (M.U.D.), Omaha, Nebraska

Duration

18 months

Project

End to End SAP Implementation with SAP-ISU(FICA) Module

Position

Project Manager cum FICO Module Lead

Contribution

Worked from RFP stage to evaluation stage. Worked closely with Sales people to get M.U.D. account single handed and continuously working from As-Is, To-Be, blueprint and now on Realization phase.

Worked for the interface Banner Non-SAP (ISU) to SAP (FICA): The interface was developed to provide the financial accounting in SAP along with details of utilities through the business partner and contract account. Also, implemented the MM-FI related configuration along with Group Asset Management, Cost allocation, Accounts Payable with check printing. The banking files were used for incoming bank check reconciliation. The various extractions of the data were done through MS access.

1.Revenue account determination (main/sub determination)- Billed and Unbilled

2.Dunning & collections (dunning procedure currently utilized to send important notice reminder with interest charge amounts. However, later business decide to continue send the delinquency letter from Banner system as AP and AR application was still in the Banner system.

3.Internal Order handling for the Maintenance Area.

4.Preparation of functional specifications for custom reports in the FI-CA area, including an aging report.

5.Worked extensively on EMIGALL with data conversion for contract account creation and transfer balances.

6.Knowledge transfer of FI-CA functionality & CCS processes to team members.

7.Payment Run in FICA for contract Accounts Payables and Receivables.

8.Payment plan options for Receivables.

Environment

ECC 6.0 version with SAP-ISU (FICA)

PROJECT 6 15th Aug, 05 – 31st May, 06

Client

eBay Inc., San Jose, CA, USA

Duration

10 months

Project

SAP FI Enhancement & Upgrade project.

Position

FICO Module Lead

Contribution

Being the first person for eBay from Wipro. Initially, came for small projects and gradually increased the project by providing good standard SAP solutions.

I have also laid foundation good foundation by our skills and made Wipro as strategic partner for future engagements.

Worked for the Banking solution: Classic approach as per the client requirement through the IDoc. The interface was developed to provide the acknowledgement file and then also upload the BAI2 version file into SAP.

In-house Cash Management/Treasury Management Module: Implemented end to end solution for the cash management for the Treasury dept within eBay to consolidate the reporting and provide the actual cash management position for the Treasury people.

We have implemented BAI Current Day Reporting and thereby automating the Cash Concentration through Automatic Bank Transfer.

Environment

SAP 4.7 version

PROJECT 5 14th Feb, 05 – 12th Aug, 05

Client

Owens Corning, Toledo, Ohio, USA

Duration

7 months

Project

SAP FI Enhancement & Upgrade project.

Position

FICO Module Lead

Contribution

Being the first person for OC from Wipro who started with small projects and gradually increased the project by providing good standard SAP solutions.

I have also laid foundation good foundation by our skills and made Wipro as strategic partner for future engagements.

The profit center accounting and cost center accounting solutions were appreciated by the OC, client. We have also implemented AR related reports which will help them in overdue & better collection point of view. Also, made complex program, thereby integrating two different systems in SAP 47 and SAP 3.1 which has different concept, one is one profit center accounting and other on Business Area. We have provided solution to the business so that consolidation can happen from business area point of view through IDoc.

Helped business in CRM Texaware deployment from US taxation point of view. Also implemented Credit Management and integration with CRM.

Successfully Implemented and handled offshore and Onsite team for the above delivery. Involved in the upgrading the project plan from 3.1i to 4.7 SAP Implementation which may start in the near future.

Resolving any issues on timely basis with Finance & Logistic Manager.

Environment

SAP 4.7 & SAP3.1i version.

PROJECT 4 5th July, 04 – 25th Dec, 04

Client

Pitney Bowes (PB) Europe Rollout Project

Duration

6 months

Project

SAP Implementation Rollout Project, Denmark

Position

FICO Module Lead

Contribution

SAP Configuration as per business solution requirement and matching with existing settings.

SAP Implementation of the Rollout Project for Denmark Location from Finance, Controlling, Banking, Asset Management as per Pitney Bowes Standard and Danish taxation Requirement.

Implementation of Extrastat and Intrastate Reporting.

Implementations of House Bank, Banking Statement in GIRO, International format and local Dutch format with Danske Bank from SAP 4.6 versions.

Provided the Interface with Banking by automating the GIRO payment.

Resolving any issues on timely basis with Finance & Logistic Manager.

Cost Center Accounting and profit center accounting mapping with old system.

Environment

SAP 4.6B version.

PROJECT 3 26th Jan, 04 - 15th May, 04

Client

Gillette CEBOM SAP Implementation –Poland and U.K.

Duration

5 months

Project

Enhancement & Support of the existing SAP implementation

Position

Onsite Finance Coordinator for SAP Imp and enhancement for Poland and U.K.

Contribution

Had done Requirement Study & Implemented Poland CEBOM sap Implementation from existing SAP to CEBOM SAP Implementation for both FICO Config. Point of view which involves creation of company code and establishing all the Poland related taxation requirement.

Also worked on data archiving objects which are related to the CO and COPA objects.

Implemented EU related Intra-stat and Extra-stat Reporting as per EU requirement

Implemented various cost center and profit center reporting.

Resolved User issues on timely basis.

Environment

SAP 4.6B

PROJECT 2 10 Mar 2003 – 31st Oct, 2003

Client

Sanyo APAC (Asia Pacific ) Rollout Project, Hong Kong, Singapore

Duration

3+6 months

Project

The special support after "GO Live" provided for 8 locations for all FICO and Asset Accounting.

Position

CO Lead

Contribution

The entire CO related Master data uploading.

Joined the project at Advance stage where lot of EUT manuals and translation were required to be carried out. Provided further training to the Power user/users.

Joined the Singapore project During m one month stay in Singapore, right from the blueprint to the final stage testing including the Rice object were completed for FIAA.

Also, worked for the RICE object related FICO for the specific china location requirement and Japan Head Quarter requirement. 6. Also, worked extensively to test all the report and uploading program before going Live.

Fully handled the three company code uploading data and matching the same in SAP. 7.

Got the Best award in FICO Module and bringing the Controlling Module to the “GO LIVE’.

Supporting all the 8 locations for stabilizing the system.

Providing the training & looking for bugs for the various RICE objects.

Also looking for the various production system support related problem related to Chinese translations.

Coordinating with the help of translator for Chinese, Japanese Users and resolving the issues of the various countries legal and other reports requirement.

Environment

SAP 4.6B version

PROJECT 1 22nd Jan, 2001 to 16th Feb, 2003

Client

Tata Motors, Pune, India

Non-Auto project, Tata Motors, Pune, India

Maval Foundry, Tata Motors, Pune, India

Duration

25 Month (> 2 years approx.)

Project

Non Auto Project for Indirect Material in TELCO ENGG, Pune from FI/CO point of view.

Position

Team Member -FICO Consultant

Contribution

Scope of the project study for Indirect Material. Business process study for Indirect Material. Business Blue Print preparation. Transaction Testing, Rationalization of Data Scope of the project study for Indirect Material.

Business process study for Indirect Material. Business Blue Print preparation. Transaction Testing, Rationalization of Data.

Non-Auto Project for Indirect Material in TELCO ENGG, Pune from FI/CO point of view.

Maintenance of Car plant during Post Go Live scenarios in FI AND CIN related areas.

Mainly worked for Open Item Management to clear the data. Interface with VCM for various exception report. End user training for CIN2.1B up gradation. Customization of TDS was and new process adopted. Archiving of the FI/CO data was done for car plant.

Small Difference problem in CIN was resolved which was supposed to be consulted from SAP, being old version not supported by SAP. Developed various programs to resolve the same. Also, in future, the same problem was resolved with user exist.

Handled Data Presentment and Archiving rollout project with Open text through ADK Tool (DART) for e.g. FI_DOCUMNT and CO objects.

Data handling design proposed to actually archiving in reversal order .i.e. any dependent object needs to be first identified before archiving.

Environment

SAP R/3 4.0B, Windows NT, Oracle 8.0.5

Financial Activities 1st Sept, 1996 – 10th Jan, 2001

Company

Greaves Limited, Mumbai. India

Insilco Limited (sister concern of Degussa-Huls, Germany) at New Delhi, India

Position

Finance Executives

Contribution

1. Working with banks, Financial Institution and other Non Banking Finance company.

2. Being Management Graduate, groomed into various department of Import, Export Handling division. Procurement to Payment, Opening of Letter of Credit etc.,

3. Worked in Treasury division for covering the exchange risk.

4. Also, responsible for various time to time reporting .i.e. monthly, half yearly and yearly reporting and statutory requirement from Banks.

5. Also, worked with Internal Auditors for streamlining the various departments’ points and updating the same to the Managing Director of the company.

Contact this candidate