Sales Project
Resume:
Curriculum Vitae
VIPUL K. ROHILLA
B.Com. (Hons.), Delhi University
C.S. (Intermediate), ICSI, New Delhi
A1/B-70 Janak Puri New Delhi-58
+91-981******* (M)
+91-011-******** (R)
****************@*****.***
************@**********.*** DOB- 23rd
Sep.1971.
Possessing Exposure in relation to Companies engaged in Manufacturing,
Service, Trading, Project & Joint Ventures activities in multiple modules
of ERP solutions:-
1. Defining, Supervision & Improvement of Process relating to
Accounting (Accounts Payable, Accounts Receivable, General Ledger
Accounting & Fixed Asset Accounting).
2. Supervision of Payroll related functions, for approx. 4500
Employees.
3. Supervision & supported the Taxation functions (Working knowledge of
Direct, Indirect & Labour Laws).
4. Supervision of analysis of Budget & Cost Control functions.
5. Coordinated & supported the Audit Functions (TV, Internal,
Statutory, Payroll, HO, and PSC).
6. Coordinated & supported the Reporting functions.
7. Coordinated & supported the Secretarial functions.
8. Coordinated & supported the other related matters assigned from time
to time.
Organizational Exposure
Name of Company Nature of Industry Duration of Designation Awarded
Employment
Group Co. of Mayar Import of Timber October 2010 onwards Senior
India Limited Logs & Newsprint Manger-Commercials &
Paper Receiveables
ENI India Limited- Joint Ventures of From April 2006 to Senior Supervisor-
On Outsource Basis, Exploration & September 2010 Accounting & Taxation
New Delhi Production of Oil, Functions.
Gas & Minerals
ABB Limited, Manufacturing & June 2004 to March Executive- Project
Faridabad-On Engineering Projects 2006 Logistics
Outsource basis of Traction
thru. Electrification,
Pricewaterhouse Power Transmission &
Coopers. Power Supply.
Indian Railways Manufacturing Unit October 2002 to May Senior Accountant
Catering & Tourism of Packaged Drinking 2004
Corp. Ltd., New Water
Delhi thru. a firm
of Chartered
Accountants
Dabur Research R & D unit of Dabur June 1995 to August Accountant
Foundation, India Limited 2002
Sahibabad
Vij & Company Share & Stock July 1993 to June Accountant cum Share
Brokers 1995 Market Assistant
Gujral Mohan & Firm of Chartered May 1992 to June Audit Assistant
Associates Accountants 1993
Educational Qualification
Standard Year of Board/University Achievements
Passing
Sr. Secondary 1988 CBSE 60% marks in Maths & Accounts
(approx.)
B.Com. (Hons.) 1992 Delhi University 65% marks in Maths & English
Language (approx.)
C.S.(Intermediate) 1996 ICSI 69% marks in Company Accounts
Information & Technology Achievements
Courses Perused Year of Instititute /Consultants
Passing
Course in Computers' Application 1995 Aptech Computer Centre, New Delhi
Course in Computer Basics, MS 2008 NIIT Limited, New Delhi
Office, E-Commerce, IT laws &
Security, Digital Signatures and
Privacy Protection
SAP-R/3 (ERP Solution) 2004 IBM Consultants-On the Job Training
FICO,PS,MM & SD Modules
ORACLE (ERP Solution) 2002 TCS Consultants-On the Job Training
FI Module
BAAN & MFGPRO(ERP Solution) 1998 BAAN Consultants-On the Job Training
FI Module
Switch Over from TALLY-ORACLE 2002 Manufacturing Unit of Packaged
Drinking Water
Key Responsibility Areas
KRAs relating to Project Execution & Controlling and Joint
Ventures.
Accounts Payable Purchase Accounting-(Relevant Exposure-10 Years)-
Functions/Accoun
ting Treatment Accounting Treatment of Materials, Services and Equipments
of Cost Aspects, procured, in accordance with Purchase, Service and Works Order in
relating to coordination with Purchase, Stores & Quality Assurance Department
Projects & Joint and in accordance with the relative Accounting Standard & Chart of
Ventures. Accounts of the Co.
Allocation of Project-Specific Cost to the relative Cost-Centre,
Job Centre of the Project & Joint Venture.
Apportionment of Common Cost to the relative Cost-Centre of the
Project & Joint Venture.
Division of Cost among the Joint Venture Partners, in their
respective Cost-Sharing Ratio.
Reconciliation of relative Inter Unit & Intra Unit Account Heads.
Accounting Treatment, Deposit & Filing of periodical returns
relating to TDS-Income Tax and Works Contracts Tax.
Management of Vendors & Service Providers and resolving their
disputes.
Accounts Revenue Accounting (Relevant Exposure-10 Years)-
Receivable
Functions/Accoun Defining the Sales Structure & Analysis of Sales Order in SD Module
ting Treatment of ERP Solution.
of Revenue
Aspects, Accounting Treatment of Materials, Services and Equipments
relating to sold/rendered, in accordance with Sales Order and in coordination
Projects & Joint with Sales Team and in accordance with the Invoicing requirements
Ventures. of the Project Contractor/Joint Venture Partners and relative
Accounting Standard and Chart of Accounts of the Co.
Approval of Billing stages of Sales Order, from the Project
Contractor/Joint Venture Incharge.
Issuance of Invoices, Cash Calls and Notices to the Project
Contractor/Joint Venture Partners, in terms of the Sales Order.
Revenue Recognition & its Accounting Treatment in BOA
Relevant approvals and updation of Sales Order in ERP Solution, for
arriving at the revised Sales Value of the Project/Joint Venture.
Reconciliation of relative Inter Unit & Intra Unit Account Heads.
Accounting Treatment, Deposit & Filing of Periodical returns
relating to VAT, Service Tax and Excise Duty.
Liasioning with Project Contractor/Joint Venture Incharge/Partners,
for related issues.
Cost Monitoring, Cost Definition, Analysis & Cost Controlling (Relevant Exposure-10
Analysis & years)-
Controlling of
Projects & Joint Defining the Cost Structure & Analysis of Costs in PS Module of ERP
Ventures Solution.
Defining & Analysis the Tender Costs, Budgeted Costs & Actual Costs
in ERP Solution.
Comparison of Actual Costs with Budgeted Costs and relative
variance analysis, for the purposes of Cost Controls.
Relevant approvals and updation of Cost Structure in ERP Solution,
for arriving at the revised Total/Staged Cost of the Project/Joint
Venture.
Funds Funds Management ( Relevant Exposure-10 Years)-
Management/Treas
ury Functions Funds Management from the Head Office, Bank and other sources,
for the keeping in view the Estimated/Actual Costs/Revised Actual Costs and
Execution & Sales Order/Revised Sales Value.
Completion of
Project/Joint Collection of funds from Debtors & Other Miscellaneous sources and
Venture Liasioning with Head Office & Bankers for Payment & Collection
Purposes.
Preparation & Analysis of Funds/Cash Flow Statement.
Projections as to periodical Inflow & Outflow of funds.
Reporting MIS Reporting (Relevant Exposure-10 Years)-
Functions
relating to Periodical Reporting relating to Total/Staged Actual & Budgeted
Projects/Joint Costs, Variance Analysis, Total/Staged Sales Value.
Venture
Computation of Gross Contribution/EBIT & Net Earnings of the
Project/Joint Venture.
Periodical Reporting for Accounting & Controlling of relative
Overhead Expenses.
IT Functions ERP Solutions (Relevant Exposure-10 Years)
relating to
Projects/Joint Undergone on the Job Training of Project Systems Module (PS), Sales
Venture & Distribution Module (SD), Materials Management Module (MM) & FICO
Module of SAP-R/3.
Integration of Modules and Sub-Modules of SAP-R/3.
Worked in the Capacity of Power User of PS & FICO Modules of
SAP-R/3.
Switch Over from Online TALLY System of Accounting to FI Module of
ORACLE-ERP Solution.
Periodical Reporting Functions
Reporting
Periodical Finalization of Books of Accounts for Internal &
External Reporting, in accordance with Schedule VI and relevant
Indian Accounting Standards.
Balance Sheet Accounts Reconciliation & Schedule Preparation.
Consolidation of Financial Statements, in accordance with the
Indian Accounting Standards.
KRAs relating to Audit Functions
Supervision &
Support of Transaction Verification, Internal & Statutory Audit, Head-Office
various Stages Audit, Audit from Joint Venture Partners, Production Sharing
of Audit Contract Audit and Payroll Audit-Undergone the various stages of
Functions. Audit & submission of reply to Audit Reports.-(Relevant Exposure-14
Years), for the purposes of Process Improvement, Internal Control
and Statutory Compliances.
Internal Auditor-Performed the Internal Audits for Super Cassettes
Industries and Indian Newspaper Society and as part of the internal
audit department of the Company-(Relevant Exposure-2 Years)
Audit of related Books of Accounts by statutory auditors and by
Inspectors & Investigators from various authorities-(Relevant
Exposure-7 Years)
Study of Prevalent relative Process, marking the shortcomings and
defining/suggest/Implement the corrective Process for a
transaction.
Study of Prevalent relative Internal Control, marking the
shortcomings and defining/suggest/Implement the corrective Internal
Control for safeguarding the transaction.
Have Undertaken the Investigation & Fraud Detection assignments for
Improvement of Process and Internal Controls.
KRAs relating to Payroll, Compensations & Statutory Compliances.
Supervision of
Books of Supervision as to Preparation, Accounting Treatment and Transfer of
Accounts- Payroll of Approx. 4500 Employees, in ERP solution, in terms of
Provident Fund, terms of appointment of Employees & guidelines issued by HR Deptt.
Gratuity &
Superannuation Treatment of applicable Labour Laws, such as, Provident Fund,
Trusts Gratuity, ESI.
Employee Tax Computation.
Payroll & other Labour Law related audits.
Accounting Treatment of Expense claims of Employees in accordance
with Eligibility norms of Employees and coordination with the
guidelines of HR Department.
Books of Accounts-Preparation & maintenance of Books of Accounts
Provident Fund Trust, Superannuation Trust & Gratuity
Trust Relevant Exposure-7 Years).
Investment-Investment of related contributions under the prescribed
securities & authorities-(Relevant Exposure-7 Years)
Loans & Settlements- Refundable & non- refundable loans &
settlement of Accounts-(Relevant Exposure-7 Years)
Other relative assignments.
KRAs relating to Secretarial, Correspondence & Liasioning Functions
Supported the Minutes & Resolutions- Writing of Minutes & Resolutions records of
Secretarial, Provident Fund Trust, Superannuation Trust and Gratuity
Correspondence & Trusts-(Relevant Exposure-4 Years)
Liasioning
Functions Share Transfer Work- At DSE and NSE Share Broker level in
Certificate form of shares-(Relevant Exposure-2 Years)
Handled with Vendors, Debtors, Employees and other staff members,
Statutory authorities, Banks, internal and other miscellaneous
correspondence & liasioning-(Relevant Exposure-14 Years)
Projects Undertaken
Accounting &
Taxation Undergone Project of Rs.200 crores for "Traction Electrification
and Power Supply "awarded by Delhi Metro Rail Corporation to ABB
Limited, in ERP Work Environment with completion time of two years.
Undertaken On-the-Job Training on multiple modules of ERP Solutions
(SAP-R/3)-PS, SD, MM & FICO, BAAN-FI Module, MFGPRO-FI Module and
ORACLE-FI module.
Miscellaneous Achievements
Leadership I have achieved success in maintaining the cordial relations with
Qualities other team members and eliminating the gap of superior and subordinate
from the team, resulting in emergence of an effective work force,
initiating their efforts towards the achievement of organizational
goals in an appreciable manner.
Performance Being self-starter, I expect minimum supervision from superiors in
Highlighters completing the assigned tasks.
I have achieved minimum response time in completing the assigned
tasks.
I have achieved high level of speed accompanied by accuracy in
effective completion of assigned tasks.
I have developed drafting & communication (both verbal & written)
skills.
I am capable and willing of working on demanding positions.
I have Steady Employment Record and Sound Family background.
I am simple to understand and to work with, versatile by nature, man
of principles and punctual by nature.
Career Objectives
Finance & Career in Finance, Accounts and Taxation.
Accounts Career in Internal Audit and Fraud Detection functions.
Career in the capacity of counseling & training relating to Finance &
Accounts, Taxation or any other related field.
Interpretation and commercial vetting of contracts and arrangements.
Usage of drafting skills.
Information & Career in the capacity of functional/implementation consultant of PS &
Technology FI & CO Modules of SAP-R/3.
Career in imparting training for Other Accounting Soft wares and
related functions.
Organizationa Offering Considerable compensation package:
l Structure Offering Sound Corporate Culture, Friendly Work Environment apart from
Good Promotional aspects.
Organization which is interested in retaining the suitable Employees'
for long, in actual.
Family Background
Nature of Father, aged about 74 Years, has done M.A.(B.Ed.) from Punjab
Relationship University and retired as 'P.G.T. (Economics)' from a school managed
by Govt. of N. C .T. New Delhi, in 1998.
Mother, aged about 72 Years, Housewife.
Sister, One, Eldest, aged about 49 Years, has done M.Com. from Delhi
University and is working as 'Executive Assistant', with Punjab
National Bank-Head Office at Bhikhaji Cama Place, New Delhi since
1985.
Brother, One, Elder, aged about 46 Years, has done M.Tech.
(Electrical), M.B.A. from Delhi University and is working as 'Head-SAP
Implementation & Maintenace', with M/S Tata Power Limited, Mumbai,
since May 2012.
Sister-in-Law, One, aged about 43 Years, has done M.Sc. (B.Ed) from
Delhi University) and is .working as 'PGT-Home Science' in a School
Managed by Govt. of NCT, New Delhi.
My Wife aged about 40 Years, has done M.Sc.( Maths ) from Delhi
University and is Housewife by Choice.
VIPUL KR.ROHILLA-APPLICANT
Contact this candidate