Ranjit Kakkrail
SAP FICO and OPENTEXT VIM Functional Consultant
Hong Kong- +852-********, E-mail: ********.**@*****.***
Profile Summary:
Total 10.8 SAP FICO years of experience including 5 years in OpenText VIM technology
Successfully completed 6 SAP FI-AP and Banking Implementation including 3 OpenText VIM, 3 Rollouts and 2 support project
Expertise in OpenText VIM, SAP FI {Accounts Payable, Bank Accounting, Withholding Tax, CCA, PCA, CEM}.
Experience in design and implementing Business process with Conversion Objects in OpenText VIM and FICO areas
Work Experience:
Company Name
Designation
Years
Capgemini India
Senior Consultant
From Nov 2013 To Till Date
Accenture India
Business and System Integration Team Lead
From Jul 2008 To Oct 2013
Raymond Ltd
Asst Manager
From Dec 2007 To Jun 2008
Kansai Nerolac Paints Ltd
IT Officer
From Jul 2006 To Dec 2007
IndusInd Media Comm Ltd
SAP Jr Consultant
From Apr 2005 To Jun 2006
Industry Exposure:
Chemical
Oil and Gas
Textiles
Metals& Mining
Qualification:
Completed Bachelors in Finance & Audit from Mumbai University (2004)
PGDBA with specialisation in Finance from ICFAI
Completed Local Certification Course SAP FICO & ABAP/4 courses from USIPL (2005).
Completed 3yrs Diploma in Software from Boston’s Institute (2003).
Completed 6mnths Diploma in Hardware (2003).
Technical skills:
OpenText VIM 5.0, 7.0 SP4, ICC 7.0.
ERP: SAP FICO (Experience in customizing, configuring, testing, user training and support in SAP R/3 Ver. ECC 6.0 EHP5, 4.7 & 4.6c)
Oracle 8i, SUN Java, C#, C, ASP, HTML, DHTML,XML, EJB, VB6.0, Tally6.3
Job Experience:
I.Capgemini India
Capgemini is one of the world's foremost providers of consulting, technology and outsourcing services. Present in 44 countries with more than 130,000 employees, the Capgemini Group helps its clients transform in order to improve their performance and competitive positioning.
Role in Capgemini: Helping the team for Preparing RFP’s at technical level, evaluating business process and mapping the same in OpenText VIM and SAP FI-AP, Banking. Direct Client facing role, interacting with business leads for understanding existing process. Participated in pre-sales strategy planning.
Created RFP and helped in bidding from technical perspective for client BPCL, which in turn made Capgemini to win this project bid.
Client/Company : BPCL / Capgemini
Role and Skill : SSME for OpenText VIM
Project : Implementation (For India country)
Project Duration : 07th Feb 2015 – 30th Dec 2015
Project & Role description
Bharat Petroleum Corporation Limited is an Indian state-controlled oil and gas company headquartered in Mumbai, Maharashtra. The Corporation operates two large refineries of the country located at Mumbai and Kochi.
My role in this project was as SSME for OpenText VIM. Guiding on ground consultant during deployment stage. Meeting with Stake holder, Milestone sign off, Delivery Management, Test Plan, Cutover strategy and also discussion on FI related configuration.
Client/Company : TATA POWER / Capgemini
Role and Skill : SAP FI-AP, Banking and OpenText VIM functional consultant
Project : Implementation (For India country)
Project Duration : 04th Nov 2013 – 30th June 2015
Project & Role description
Tata Power is India’s largest integrated power company with a significant international presence. From Fuel and Logistics to Generation and Transmission to Distribution and Trading-exploring various renewable sources of energy in India and globally, we now have a significant presence in wind, solar, hydro and geothermal energy space.
Role in this project as a solution architect and deliver the SAP FI-AP, Banking and OpenText VIM solution. Conduct Blueprint workshops to study AS-IS process and requirement gathering. Meeting with Stake holder, Milestone sign off, Delivery Management, Test Plan, Cutover strategy, and create Baseline config for OpenText VIM and also FI related configuration and prepare config rationale. Do baseline and integration testing. Prepare Test scripts. Work on Conversion objects.
Advisory services to design AP/P2P operations.
Conducted blueprint workshops to cover as-is process study, pain points, requirements and tobe process design – cutting across various departments with procure to pay process variations for post-facto and pre-facto invoicing
Solution blueprint preparation with VIM swimlanes and functional designs for all solution components
Carried on GAP Analysis for client requirements.
Coordinated with HDFC bank for implementing the payment file (SWIFT net ISO20022) based on bank and client requirement
Configuration of APP{Automatic Payment Program}, by maintaining House Bank, Bank GL and payment methods.
Configuration of Bank DMEE.
Created all required payment methods based on the business processes and requirement.
Implemented Electronic Bank statement with clearing in MT940 format, coordinated with HDFC bank for this process and getting the payment details on Bank Statement
Configured Electronic Bank Statement related steps in SAP.
Functional designs for change requests related to non-standard requirements
Preparation of test cases and test scripts
Preparation of end user guides
UAT support and bug fixes
Effectively delivered the end to end implementation of SAP Invoice Management by Open Text and Invoice Capture Center (OCR) as Functional lead and P2P expert.
VIM Rollout completed for Tata Power across all locations
Site Visit for Current State Assessment
Regression touch points of current system
Cut over and Testing Strategy definition
Perform VIM post Installation checks.
Worked with Super users during the each Phase of the project in order to achieve a smooth Go live.
II.Accenture India
Accenture is a global management consulting, technology services and outsourcing company with more than 230,000 people serving clients in more than 120 countries. Combing unparalleled experience, comprehensive capabilities across all industries and business functions, and extensive research on the world’s most successful companies
Client/Company : HB Fuller / Accenture
Role and Skill : SAP FICO / OpenText VIM
Project : Implementation (For US and Canada country)
Project Duration : 22nd Apr 2013 – 21st Oct 2013
Project & Role Description
For 125 years, H.B. Fuller has been a leading global industrial adhesives provider. HB fuller an adhesive company planned to implement SAP throughout all the countries. My role is as a solution architect for OpenText VIM and SAP FICO and managing Functional related object, wherein i need to interact with client team. Here in this project my role is to prepare the Blueprint doc based on client requirement, discuss with client while updating the BPD's. Create Baseline config and do FI related configuration and prepare config rationale. Do baseline and integration testing. Prepare Test scripts. Work on Conversion objects.
Worked as Functional Solution Architect for OPENTEXT VIM solution and SAP FI(AP,GL and AR).
Conducted blueprint workshops to cover as-is process study, pain points, requirements and tobe process design for SSC operations – cutting across various departments with procure to pay process variations for post-facto and pre-facto invoicing
Solution blueprint preparation with VIM Process Swimlanes and functional designs for all solution components.
Project Planning and weekly Stake Holder review meeting
Fit Gap Analysis
Configuring VIM document types, enhance indexing screen, and configure, enhancement and maintaining chart of authority (COA), PO & Non-PO Vendor Invoice Workflow approval set up.
Cut over Strategy
Perform VIM post Installation checks.
Analyze and resolve functional and Technical issues for testing Team
Analyze the functional and technical changes and impact of the changes on Existing system and provide testing efforts to the Client
Baseline config created { Configuring Company code, Controlling Area, Chart of Account}
Baseline config rationale prepared.
Organization model analysis and configuring the Organization structure according to the business model. Created organizational units, positions, users, and jobs roles and also assigning of different organizational unit. Involved in setting up of Organizational plan according to the project needs.
Understanding Current Technical Landscape of customer.
Client/Company : MAERSK OIL / Accenture
Role and Skill : OpenText VIM functional consultant and SAP FI-AP, Bank, JVA, AR, GL, Asset
Project : Implementation / RollOut (For Angola, Kazakhstan, US and Qatar country)
Project Duration : July 2011 - Apr01 2013
Project & Role Description
Mærsk Olie og Gas AS (Maersk Oil) is a midsize international oil and gas company operating an oil production of about 650,000 barrels per day and a sales gas production of up to some 1,000 million cubic feet per day. As a way to quickly and efficiently be able to take over new fields around the world, Mærsk Oil decided in 2007 to initiate a business excellence initiative, defining best practises and standardized processes. Mærsk Oil partnered with Accenture in this program. One outcome of the program was to initiate the build and roll-out of an SAP platform under a project called Mærsk Oil Unique SAP Experience (MOUSE).
Role- Gathering business requirements, conduct gap analysis, provide business process solutions, design and implement solutions to meet client`s specific requirements. Preparation of functional specifications for interface, reports and enhancements. PAT {Product Application Test} and PIT {Product Integration Test} is carried out. SUT {Super User Training} is carried out. UAT and Go live is done for Angola, Qatar and Kazakhstan.
Mapped all the AP business process flow through OPENTEXT VIM solutions.
Worked as Functional Solution Architect for OPENTEXT and SAP FI-AP,AR and Bank.
Coordinated with third party software solution READSOFT for OCR solution required for AP invoice process and mapping with OpenText.
Advisory services to design and setup SSC for AP/P2P operations.
Setting up SSC, Mailroom, central receiving station, Invoice sorting process & Help Desk process.
Conducted blueprint workshops to cover as-is process study, pain points, requirements and tobe process design for SSC operations – cutting across various departments with procure to pay process variations for post-facto and pre-facto invoicing
Solution blueprint preparation with VIM swimlanes and functional designs for all solution components
Effectively delivered the end to end implementation of SAP Invoice Management by Open Text and Invoice Capture Center (OCR) as project lead and P2P expert
VIM and ICC configurations to meet client requirements
Functional designs for change requests related to non-standard requirements
Single point contact for all P2P AP requirement
Creation of Company code and Assignment with CO area and COA.
Configuration of AR/AP Account groups and maintaining at company code level
Configuration of Master Data Screen Customization of Accounts receivable and Payable
Maintaining Number ranges for AP in sync with MM and AR.
Coordinated with HSBC bank for implementing the payment file (SWIFT net ISO20022) based on bank and client requirement
Configuration of APP{Automatic Payment Program}, by maintaining House Bank, Bank GL and payment methods.
Configuration of Bank DMEE.
Created all required payment methods based on the business processes and requirement.
Implemented Electronic Bank statement with clearing in MT940 format, coordinated with HSBC bank for this process and getting the payment details on Bank Statement
Configured Electronic Bank Statement related steps in SAP.
Configuration of Extended Withholding Tax for{Angola and Qatar}
Configuration of New GL functionality
Configuration of Terms of payment (With & without instalments)
Carried out PAT and PIT Strategy for testing the build.
Managed Cutover Strategy for uploading Master data's and transactional data.
Complete Unit testing and Integration of FICO carried out.
Carried out UAT with client super users.
CO-FI integration configuration.
Client/Company : Jemena / Accenture
Role and Skill : SAP FICO
Project : Implementation
Project Duration : Nov 2010 - May2012
Project & Role Description
Jemena - A leader in infrastructure management and development. Jemena is a leading infrastructure service provider; managing $8 billion of gas pipelines and electricity networks across eastern Australia. As well as owning or part owning $6.5 billion worth of assets, Jemena have the experience and expertise to provide excellence in operational solutions. Jemena’s considerable capabilities in infrastructure management and development are a springboard for ambitious growth targets in many new markets such as water. Now Jemena wants to merge 2 SAP systems into OneSAP with changes in their current business processes.
My role in this project is as a FICO (AR/AP) consultant, gathering and scoping the requirement and understanding their current business processes and interacting with the client and preparing the Business Blueprint and doing build at the realisation phase and simultaneously preparing the Configuration design document.
Mapping requirement and preparing Business Blueprint (Prepared based on AS-IS and TO-BE [DBPD document] process with GAP Analysis)
Prepared RFP for FSCM module and successfully approved by the business.
Configuration of AR/AP Account groups and maintaining at company code level
Preparing the strategy for the build phase process.
Configuration of Asset accounting-- Maintaining of COD, Asset class, Screen layout, Acct Determination, depreciation key etc..
Configuration of New GL functionality
Discussion for customised programs for AR and AP module.
Configuration of Chart of Accounts Master data
Configuration of Master Data Screen Customization of Accounts receivable and Payable
Configuration of Special G/L indicators for AR/AP
Configuring of maintaining & assigning Retained Earning Accounts
Configuration of new Document Types for AR/AP
Configuration of Terms of payment (With & without instalments)
Maintained Cutover Strategy for uploading Master data's and transactional data.
Complete Unit testing and Integration of FICO done.
CO-FI integration configuration.
Client/Company : Vale Mining / Accenture
Role and Skill : SAP FICO
Project : Implementation
Project Duration : June 2010 – 15th Nov 2010
Project & Role Description
Vale is a diversified mining multinational corporation and one of the largest logistics operators in Brazil. In addition to being the second-largest mining company in the world, Vale is also the largest producer of iron ore, pellets, and second largest of nickel.[5] Vale also produces manganese, ferroalloys, copper, bauxite, potash, kaolin, alumina and aluminium. In the electric energy sector, the company participates in consortia and currently operates nine hydroelectric plants. Vale is now decided to implement SAP, for making the business smoothly from the system point of view.
My role in this project is as a FICO consultant, Understanding and scoping the requirement study of the business processes and interacting with the onshore consultant for the issues which we find in BBP doc and doing the configuration and also helping the other FICO team member of project.
Mapping of Business Blueprint (Prepared based on AS-IS and TO-BE process with GAP Analysis)
FICO configuration & integration configuration of MM and SD is handled.
Material Ledger configuration done
Maintained Cutover Strategy for uploading Master data's
Functional specification and logic where build for specific development with the ABAP team.
Major configuration done as below
Configuration of Organisation structure at FI level
Configuration of New GL functionality with Business segment.
Configuration of Document splitting.
Configuration of CIN (Tax procedure creation, Withholding Tax, VAT Tax code creation)
Configuration of all AP and AR .
Minimum Knowledge on Material Ledger.
Configuration of Foreign Valuation
Configuration of Asset accounting with COD
Configuration of Controlling area.
Configuration of Automatic payment program.
Configuration of COPA with the Value flows.
Client/Company : Sekisui Chemicals / Accenture
Role and Skill : SAP FICO
Project : Implementation
Project Duration : Nov. 2009 - May 2010
Project & Role Description
Thorough Understanding and scoping the requirement study of the business processes and streamlining the FICO process in the project.
Mapping of Business Blueprint (Prepared based on AS-IS and TO-BE process with GAP Analysis)
I have handled certain challenges of insufficient requirements in the FICO areas.
With the FICO team i have done FICO configuration & for integration configuration of MM and SD was handled.
Done some COPA configuration and Cost Component structures were maintained and Costing sheet was designed.
Maintained Cutover Strategy for uploading Master data's
Functional specification and logic where build for specific development with the ABAP team.
Complete Unit testing of FICO, Integration testing and UAT also handled.
Issues Handled and resolved which was occured during Unit Test and Integration Test
SABRIX taxation was solely handled. Gathering the requirement from Client and then designing and building the same through IDOC functionality with ABAP team
Email and Fax functionality was introduced in Payment advice which will happened simultaneously.
Major configuration done as below
Configuration of New GL functionality.
Configuration of Document splitting.
Configuration of all AP and AR .
Configuration of Automatic payment program.
Configuration of maintaining asset class, account determination, depreciation key.
Configuration of COPA and maintained Cost component structure and costing sheet.
Client/Company : Kemira Chemicals / Accenture
Role and Skill : SAP FICO
Project : Roll Out
Project Duration : March 2009 - Oct. 2009
Project & Role Description
As FICO consultant i was the part of rolling out the SAP solution to the European Operations. The scope included Design, Build and Test. The salient feature was that the Build and Testing for European and US rollouts were handled entirely by the IDC Team. As part of FICO team i was supporting offshore FICO team members.
The Roles & Responsibilities included in support:-
--Understanding the client requirement as per that building the reports if necessary
--Configuring the FICO related part as per the business requirement.
--Handling tickets on all FI & CO sub modules as well the integration issues (FI-MM, FI-SD etc).
Major Configuration done as below
Configuration of Document splitting.
Configuration of all AP and AR .
Configuration of Automatic payment program.
Configuring of maintaining & assigning Retained Earning Accounts
Configuring of Account Assignments-- OBYC, OMWB, OB40, VKOA
Configuration of new Document Types
Configuration of Terms of payment (With & without installments)
Maintaining the Chart Of Depreciation.
Maintaining the Asset Class, Account Determination/Depreciation key / Depreciation area
Maintaining of New Internal Order, Cost Centre & Profit Centre Accounting
Created LSMW for Master Data upload & Transactional Data upload
Client/Company : BHP Billiton / Accenture
Role and Skill : SAP FICO
Project : Consulting and SME role
Project Duration : Jan. 2009 - March 2009
Project & Role Description
Worked as SAP Advisor and a consulting role.
Analyzing and Mapping the Process from Non-SAP to SAP.
Advising the Client and clarifying the doubts about the SAP process with business process.
Prepared Business Blueprint (Prepared TO-BE process)
Concepts of each SAP transaction when and where should be used business vise that was shared.
Client/Company : Scherring Plough Company
Project : Implementation
Project Duration : Aug. 2008 - Nov. 2008
Project & Role Description
Understanding and scoping the requirement study of the business processes and streamlining the FICO process in the project.
Thorough Understanding and scoping the requirement study of the business processes and streamlining the FICO process in the project.
Mapping of Business requirement (Prepared based on AS-IS and TO-BE process with GAP Analysis)
I have handled certain challenges of insufficient requirements in the FICO areas.
Major Configuration done as below
Configuration of FI- AP,AR,GL.
Configuration of CO- CCA, PCA.
Configuration of CIN for TDS (End to End).
Configuration of Currency setting XOY01 .
Cut-over strategy were maintained for how to upload the datas.
Created LSMW for Master Data upload & Transactional Data upload.
Guiding colleagues in all part of configuration of FI.
Handled Configuring of Account Assignments-- OB40, VKOA.
Prepared all important Functional spcs for Z development report after understanding the client requirement.
III.Raymond Ltd
Project Summary
Project Name: ERP – Drishte
SAP ECC 6.0
Raymond Limited
The Raymond Group was incorporated in 1925. It is today the largest integrated manufacturer of worsted fabric in the world, having over 60% market share in India. With a 500 million US$ turnover, they are today one of the largest players in fabrics, designer wear, denim, cosmetics & toiletries, engineering files & tools, prophylactics and air charter services in national and international markets. All its plant are ISO certified, leveraging on cutting-edge technology that adheres to the highest quality parameters while also being environment friendly
Project & Role Description
The company is replacing its legacy Fox/Sybase -based systems by implementing SAP software.
The implementation partner is SAP India. The modules implementing are SAP SD, FI, CO, MM, PP, QM, PM, BW
SAP used its ‘IS MILL SOLUTION’ for JK Files & Tools & ‘IS AFS SOLUTION’ for RAL & ColorPlus for implementation in Raymond Limited
The system is aimed to serve 400 users situated at different locations, which are connected through RF or Lease lines
Thorough understanding of all business processes of Raymond Limited related to JK Files & Tools, RAL & ColorPlus.
Thorough understanding of the integration between the different functional areas of FI & MM, FI & SD
Mapping of Business requirement and scoping the requirement study of the business processes and suggested for migrating to higher end of ERP implementation
Complete Unit testing FI and even Integration testing also
Function specification and logic for specific development with ABAP team.
Prepared LSMW for initial Master Data upload.
Solely responsible for FI configuration & for integration configuration of MM
Training to Process Owner, Power User and End Users of Finance
Major Configuration done as below
Maintaining the Organisation Structure {Creation & Maintenance of Company, Company Code, Controlling Area}
Configuration of Chart of Accounts Master data
Configuration of CIN for TDS (End to End)
Configuration of Currency setting OY01
Configuration of Master Data Screen Customisation ( customer/vendor groups)
Configuration f Special G/L indicators
Configuring of maintaining & assigning Retained Earning Accounts
Configuring of Account Assignments-- OBYC, OMWB, OB40, VKOA
Configuration of new Document Types
Configuration of Terms of payment (With & without installments)
Maintaining the Chart Of Depreciation.
Maintaining the Asset Class, Account Determination/Depreciation key / Depreciation area
Maintaining of New Internal Order, Cost Centre & Profit Centre Accounting
Created LSMW for Master Data upload & Transactional Data upload
IV.Kansai Nerolac Paints Limited
Project & Role Description
Project Done
SOA project– We are interacting with the Company called Cordys (Netherlands based company). Cordys BPMS is a single toolset, built from the ground up to offer comprehensive BPM and SOA capabilities, giving business managers direct control over new and existing processes. Thru this project comes to know the SD module process. And in this project we have used IDOC functionality for Interfaces getting the data from Non-SAP to SAP.
Depot Front End System – Simplifying & minimising the SAP screen and to reduce time for depot users while passing entry thru FI transactions. This was very helpful during peak Season.
Application Logs – Logs were getting generated in the ACCTIT, ACCTCR, ACCTHD table, due to this lots of space were used by this logs, duplication of Data were stored which were already present in some other table for eg BSEG,BKPF etc. Locked the table not allowed to pass the entry in the mentioned table.
SRM Project – FI related things done required open item of Vendor & but with different Logic for Vendor Balances with Opening & Closing Balance in month Range
Company Merger project – Transferring all balances of AP, AR, GL & Assets from Non-SAP to SAP thru LSMW. Created LSMW for that.
New TDS format implemented – New tax codes created in segregated format with Basic, Surcharge, Ed Cess, Higher & Sec Ed Cess. Certificate format changed with the help SAP note & the .sar file.
1% SHEcess Activity as per the budget 2007 related to Excise (March’07)
Archiving of data at regular interval (as per policy of company)
For a project worked as Project Leader: Helped the team member of all Modules that how to identify the unwanted programs & BDC which is not in use.
Major Configuration done as below
Configuration of CIN for TDS (New Tax Type, Tax codes with percentage in segregated format, Basic – Surcharge – Ecess - Sec Ecess)
Configuration of Special G/L indicator
Configuration of New Master Data Screen Customisation ( customer/vendor groups)
Configuring of Account Assignments-- OBYC, OMWB, OB40 for Sec Ecess
Configuration of new Document Types
Configuration of Terms of payment (With & without installments)
Created LSMW for Master Data upload & Transactional Data upload for Company Merger project
Improvement in the FI functionalities
Made configuration changes related to bill passing that they have to put the Section code while making entry, made has required field.
Written Validation for payment, whenever they are making payment they have to put Cheque number
Applied 45 notes related to TDS certificate
Written Substitution related to shift factor in Asset master, if the field kept blank then by default shift factor will be 1.
To track the IT expenses related to which item has been for that Validation done for certain GL code in Assignment field.
Other Activities
Giving Support to End users of 65Depots & 5 factories while doing there Daily Transaction
Solving the problem which is coming thru tickets.
Co-ordination with Basis consultant for Authorization Profiles.
Interaction with ABAP consultants to develop custom reports.
Learnt how to Create & Transport the Customising & Workbench Request. Fro Dev to Prod
V.Hinduja Group Ltd (IndusInd Media & Communication Ltd)
Project & Role Description
Joined company during 3 phase of Implementation
Created LSMW program for first time for MASTER creation of Vendors & Customers
Conducted workshop for auditors of Ernst & Young on SAP and its uses in the Business Environment.
One Year end process has been handled.
HANDLING THE OPEN & CLOSE POSTING PERIOD OF THE COMPANY.
Trained end-users in accounts receivable and accounts payable, the functional various areas like payment terms, manually processing incoming/outgoing Invoices/payments.
Learnt to make Closing & Transfer of balances to P& L appropriation. Balance sheet.
Other Activities
Supporting End users of Headends & branches while doing there Daily Transaction
Creation of Masters of GL, Vendor & Customers.