SANJAY KUMAR RAI
Address : FLAT NO 704, BUILDING NO 34, SANSKRUTI HOUSING SOCIETY, 90 FEET ROAD, THAKUR
COMPLEX, KANDIVALI EAST, MUMBAI - 400101
Tel : 9619880103, 9588034886
E Mail : email@example.com
Seeking higher level assignments in Accounts & Finance with an organization of repute
Pro- active and result oriented ICWA with 15 years of extensive experience in all aspects of accounting and
finance management. Currently associated with Etisalat DB Telecom Pvt. Ltd. (Leading Telecom
Service Provider in Middle East Asia) as Sr. Manager – Corporate Finance. Demonstrated hands on
management style in the development and implementation of strategic plans, to ensure company growth.
Proficient in handling operations in compliance to the rules and regulation laid by various governing bodies
Extensive experience in conceptualizing and implementing financial procedures, with working capital
management, profit monitoring and building internal financial controls. Ability to ascertain needs / goals
streamlines operations and envisions new concepts; effectively communicate direction and commit people to
action. An analytical and innovative team player possessing excellent communication, interpersonal,
coordination, presentation, team building and leadership skills. Have exposure to Accounting Software like
SAP/Oracle 11i & R12.
AREAS OF STRENGTH INCLUDE
Accounts: Supervising the consolidation of group accounts and preparation of financial statements (Balance
Sheet & Profit and Loss account). Checking data, maintaining and scrutinizing statutory books of accounts viz,
journal, ledger, cash / Bank book and subsidiaries in compliance with time & accuracy norms. Preparing the
monthly provision for Operational Expenditure with discussion of respective Department in the organization.
MIS: Preparing & supervising the preparation of MIS reports to provide feedback to top management on
financial performance, viz. fund management and aging analysis, Budgeting & monthly forecasting. Ensuring
that all income/expenses at the end of the month accounted properly viz. Adm., Projects, Sales & Marketing
and other expenses. Preparing comparison sheets of Actual v/s Budget or Actual v/s Forecast. Finding the delta
/ variance with appropriate reasons & presenting it to the management.
Financial Planning & Management: Formulating budgets and conducting variance analysis to determine
difference between projected figures & actual expenditure and implementing corrective actions. Monitoring
inflow & outflow of funds, ensuring optimum utilization of available funds as well as handling project
Systems: Designing and implementing systems (Like SAP FICO & Oracle R12, 11i); Meeting with key users
to determine system, business plans plus reporting requirements and Review all aspects of system delivery and
drive improvement programs. Participating in development of system enhancements and coordination of
business user acceptance testing (UAT).
November 2010 to Till Date: Etisalat DB Telecom Pvt. Ltd. (is a joint venture between Etisalat and
Dynamix Balwas Group Etisalat DB and its Subsidiary has the Unified Services Access License in 15 Circles
in India. These licenses enable the company to provide a full spectrum of telecom services covering the
population of over 900 million across the circles).
Sr. Manager Corporate Finance (Corporate Account Payable Head)
Job Responsibilities (One years time span):
Responsible for timely and accurate reporting of all compliance schedules as per Financial Reporting
Calendar; (reporting to Assistant Vice President, FRC Head as well as Finance Controller).
Involvement in Monthly as well as Quarterly closing activity (Financial Reporting IGAAP / IFRS).
Designing and implementing new system and procedures and improving existing system to achieve better
result and promote innovative working culture.
Taking adequate measures to monitor the inflow/outflow of funds, ensuring optimum utilization of available
funds towards the accomplishment of available funds.
Formulating budgets and analytical analysis for timely corrective actions.
Ensuring Statutory viz. Income Tax, Service Tax, VAT & WCT.
Financial Reporting :
General Ledger Scrutiny as well as Trial Balance Review.
Co-ordination with other team member for necessary rectification / correction in accounts, if require.
Consolidation of Various schedules like 1) Other Liability / Sundry Creditor’s (Capex/Opex) incl.
grossing up – regrouping etc. 2) Network Expenses, 3) Admin Related Expenses, 4) Provision for
Capex / Opex Creditors, 5) Rent Schedule, 6) Prepayment Schedule 7) Expense Schedule etc.
Responsible for Providing the DATA to Corporate Consolidation team for Account Payable.
Monthly Expense / Balance Sheet Schedule.
Forex related reporting.
Accounts Payable :
Managing Corporate Account Payable Team of seven members.
Responsible for vendor & Employee payments.
Strengthening & control of payment process.
Monthly provision for final accounts.
Monthly cash flow projection of vendor payments.
Vendor account reconciliation.
Control of Electronic payment process.
Monthly salary payment & analysis.
Compliance of industrial law -PF/ESI, Service tax Invoices.
Finance records and Advance Settlement.
Inter Unit Reconciliation
Monthly Audit Schedule preparation & Consolidation.
BRS for all three operative bank account.
Management Reporting :
Monthly MIS based on Financial Reporting / Trial Balance.
Providing various MIS reports with analysis for assisting management in strategic decision making &
Monitoring /Reporting Cash Flow on the operation of the company to review the cash position and
forecasting funds required for numerous expenses. .
ERP Implementation (Oracle Financials R12) :
Core Member of ERP Committee for Implementation of Oracle R12.
Major role in Implementation of Payable module as well as support function.
Ensure reporting requirements and Review all aspects system delivery and drive improvement programs.
Participating in development of system enhancements and coordination of business user acceptance testing
Internal Control :
Assist in Analyzing and modeling relevant business processes.
Assist in preparation of various business process by KPMG on Account Payable/ Bank / Cash Management
Invoice Processing & Payments etc.
Successful implementation of Oracle R12 (Payable/ GL Modules) across PAN India
Successfully implemented GIS module of Oracle across PAN India.
March 2009 to October 2010: Bharti Airtel Ltd., (Broadband & Telephone Division).
Manager Finance (Channel & Collection Accounting Head) – Bangalore South Regional Circle office
Timely release of incentives / commission to channel Partner/Franchisee :
Checking of channel partner commission with marketing plan, new acquisition, churn subscriber, pays out
Maintaining tracker, F & F of CP, closing of channel partner quarries.
CP payout not in order: CP payment not happing due to non submission of bill to maintain tracker.
Track all sales schemes and accounting entries.
Ensuring channel reconciliation on a monthly basis and sign off.
Agreements status BU wise/ monitoring the expiry dates.
Interaction with depts. for operational issues
Weekly Collection Bank account reconciliation:
Daily reconciliation with APS, bank loader file & Oracle payment.
Daily collection entry in Oracle, weekly BRS, action for old items appearing in BRS > 7 days.
Coordination with CSD team for necessary corrective action for payment related like cheque reversal, other
circle collection, IUT entry of collection, Registration charges entry.
Provisioning of revenue and collection related cost.
Ledger scrutiny and schedule analysis.
Manual receipt for collection- audit checks
Surprise checks / Month end cash certificates
Subscriber Security Deposit and Refund Management:
Timely process of Security deposit received from subscriber (PD case).
Checking of security deposit balance in Arbor SD module, cross checking of SD refund cases updated in SD
Refund entry in Oracle, Monitor of PD case aging > 60 days not refunded.
PD case not refunded within 60 days: Subscriber details to be shared with CSD team.
Reconciliation between Arbor v/s Oracle:
Debtors & Security deposit received from Subscriber between Arbor v/s Oracle.
Difference above as per SVCCL limit to be closed immediately.
Provision for Bad debts:
Accounting provision for bad debts, Bad debts w/off.
Responsible for timely and accurate reporting of all compliance schedules of Channel & collection
accounting as per Financial Reporting Calendar; (reporting to DGM Finance, FRC).
Monthly Closing activities related to Channel & Collection accounting.
Successfully implemented process of timely release of incentives / commission to channel
Implemented Bank Reconciliation process for 8 collection bank account of South Region
(monthly 125 Crores (approx) collection).
January 2007 to February 2009: Reliance Retail Ltd., Jaipur, Rajasthan
Manager – Commercial
Financial accounting and Internal Controls:
Monthly balance sheet reconciliation of all Profit centers for the state by +5th working day (of next month).
Reviews to include GL/AP/AR reviews and schedules advising the nature and purpose of items sitting in the
balance sheet. The comments must be disc with State Ops head and Commercial head and actions taken to
ensure all existing assets are good for recovery and all liabilities due for payments.
Objective: Reconciled & well controlled balance sheet.
Ensure quarterly confirmation of all vendor and receivable accounts. By the 15th of 1st month of
subsequent quarter. Include all accounts > 50,000 overall ensuring 80% payables are covered. Generate
weekly ageing reports to bring focus & accountability.
Objective: External validation of AP/ AR.
Compliance with all local state rules like timely payment of APMC, Octroi, VAT, Service tax and other
government levies pertaining to the Agri business. Ensure full utilization of all Input Tax credits; escalate
surplus credits (if any) to State commercial in time.
Objective: Regulatory and legal compliances.
Check and validate with business and operations all master data maintained for the State E.g. Bills of
Materials, Sub contracting orders Materials Masters, pricing etc. Escalate all issues timely to Central
Controller and seek changes.
Objective: Understand and review the SAP set-ups so as to understand impact in Accounting.
Inventory control and review to prime focus. Follow policy of perpetual Inventory checking, escalate
variances. Review and monitor stock keeping norms and actual and suggest improvement measures that
Objective: Inventory control.
Thorough understanding of Inventorisation policies and Product costing template. Monitor revenue /
costing against various alternate supply sources. Discuss & optimize sourcing strategy to provide
competitive edge to business.
Objective: Understand drivers of Product cost and support business in Decisions towards optimization
Assist State commercial in effective cash management by reviewing all Imprest and Capex Budgets.
Discuss with business to understand needs and suggest measures by which cycle times of working capital
can be improved to in turn bring efficiency.
Objective: Fund management and Imprest balance reviews.
Planning & Management information systems:
Weekly tracking of GM/ sales targets against AOP, monitor short falls and build alternate plans with
business head to capture lost ground.
Objective: Timely financial reporting.
Specific focus on Overhead Cost Management, Monthly review & monitoring of CC/ Mandi and CPC
overhead target against plan, signify and define areas of cost reduction including closing sub optimal CCs
or Labor deployment optimization.
Root cause analysis of High store Dump/Shrink, focus on doubtful store or CPC from where they eliminate.
Drive this KPI for 5% improvement.
Monthly monitoring of CPC Dump/Shrink and Transit Losses. Identify all cases >5% and do a root cause
analysis. Hold all relevant stakeholders like D&L / CPC accountable for any unexplained losses.
Review Markdown sales, work with area operations / commercial to bring down incidence.
Daily monitoring of stores inventory to escalate overstocking or inventory build beyond one day.
Monitor and Track the Primary Freight cost.
Monitor and Track Secondary Transport Cost and optimization of number of trips to reduce costs.
Partner in Implementation of the Price Benchmarking SOP and together with Business team ensure
authentic pricing for our sourcing operations.
Spot checks at stores to see process of markdowns. Suggest internal control improvements on how we can
better the current process.
Provision of Expenses as per SLAs in operation to ensure completeness of Books for expenses on a monthly
Handled end to end accounting & commercial activities of Fruit & Vegetable segment for
Successful implementation of SAP FICO & Material module for Fruit & vegetable segment.
March 2005-December 2006: Reliance Infocomm Ltd.
Cluster Commercial Head
Overall In charge of the all the Commercial and Collection Activities of the Hissar, Rohtak and its mission
Towns. Management of the Commercial & Commercial Activities in co-ordination with the other
departments in ensuring the compliance of all the Commercial Policies and target achievements.
Credit Monitoring and Ensuring the Dunning Activities as per the Credit Policy of the Company for the Post
Monitoring the Sales Accounting, ensure implementation of credit control policy/parameters, strict control
on prepaid dealer appointment procedure, close monitoring on incentive scheme working and issuance of
credit / debit notes.
Incentive Scheme working and issuance of credit notes for Post Paid Channel Partners.
Reconciliation and balance confirmation of Channel Partner accounts.
Channel Engagement – Timely Sales order Execution, commission/ Subsidy payment, channel visit &
survey as per SLA.
Channel Internal Audit & Financial control (Penalty adherence, Recovery, NAC & Subsidy).
AOP Vs Actuals, Review of Channel Balances, F&F e.t.c..
Internal Audit scores- No Audits with major observations. Clean NOC compliance.
Inventory Management- Handsets.
Channel MIS – Monitoring/Reporting and reconcile with GL.
NOC compliances Tracker.
Clearance of F&F of all cases for all channels.
Ensuring Quality Post Paid & Pre paid Customer Acquisition in the Cluster from the entry stage to period of
the customer remains in our Network.
IUC Payment of Hissar Cluster to IUC partners based on reconciliation.
Co-ordination of the Circle office for all the various functions and ensuring the smooth transactional flow of
the various activities
Ensuring the timely completion of the Audits by ensuring the proper co-ordination with the Internal &
Making the exceptional Reports for the various requirements of Management.
January 2000- February 2005: Akai Consumer Electronics India Ltd., (A Videocon Group Co. )
Chandigarh, (Akai Consumer Electronics India Ltd. is subsidiary of world Electronics giant Akai Electric Co.
Ltd., Japan. “AKAI” is one of the Leading brand names in CTV, DVD player, VCR, VCP and Audio system
Regional Accountant – Promoted and Transferred from Videocon International Ltd.
Monitoring the Sales Accounting, ensure implementation of credit control policy/parameters, strict control
on dealer appointment procedure, close monitoring on incentive scheme working and issuance of credit /
Debtor’s management from monitoring the invoice preparation to tracking collection from the dealers and
weekly reporting to management regarding outstanding status and determination of credit limits.
Monitoring of cash and bank transactions and responsible for Fund management on the basis of proper
scheduling for payment to suppliers and collection from various debtors and branches.
Responsible for recovery of old outstanding through negotiation and if require legal action.
Sales tax – Punjab (Sales Tax returns, arrangement of various sales tax forms, sales tax assessment and
other related works).
Responsible for timely Reconciliation of accounts Inter Branch & Inter Company and Dealers.
Co-coordinating with branch offices, sales, service department, C&F and Head office in Meeting the
deadlines related to Accounts & Administrative functions and answerable for their operational performance.
Ensuring Timely submission of daily & monthly MIS to H.O.
Interaction with Internal Auditors.
Successfully completed pending sales tax assessment cases of four states.
Rewarded as best performer in the year 2003-2004.
January 1997- December 1999: Videocon International Limited
Aurangabad & Mumbai (Maharashtra)
Joined as Officer Management Audit and promoted as Sr. Executive – Systems & Audit
Auditing of Factory accounts and the Sales branches all over the Country.
Auditing of system & schemes at various branches and with a view to reduction of cost & working it cost
Verification of credit notes issued for various schemes.
Reconciliation of Dealers accounts and Inter Branch & Inter Company.
Preparation of monthly expenditure & revenue report of branches and comparing actual with benchmark
set by the management.
Finalization of accounts of the branches.
Making Audit Reports for discussion with the Zonal heads / Directors of the company.
October 1993- October 1996: M/s Jain Mathur Associates
Article ship under CA Training
Carrying out Internal Audit / Tax Audit and prepare final audit reports.
The firms for which Internal audit is carried out to name few of them were M/s J .K. Synthetics, R.S.B.C.C.
& Central Bank Branches.
Maintenance of books of accounts and drawing Balance sheet.
June 2001 Associate Cost and Works Accountant (ACWA) from I.C.W.A.I
July 1992 Master of Commerce (M. Com.) with 72% from Ajmer University, Rajasthan.
July 1990 Bachelor of Commerce (B. Com.) with 54% from Ajmer University, Rajasthan.
Stood 2nd in order of merit in Govt. Commerce College, Kota (Rajasthan) in M.Com. (A.B.S.T.)
SAP – Implementation
Ms Office: MS Excel (incl. Vlookup, Pivot, IF formula’s & Macros), MS Word, Power Point & MS Access.
Date of Birth : 5th July 1974
Family Profile : Father – Shri Chandrabhan Rai, Retired from Private Sector.
: Mother - House Wife
: Wife - House Wife
: Children- Eleven year old Son & Four year old Daughter.
Marital Status : Married
Languages Known : Rajasthan, Hindi, English & Bhojpuri
Reference: Will be available on request.