Prem R B Contact: +91-998**-*****
E-Mail: *******@*****.**.**
PROFESSIONAL SUMMARY: Over 15+ years of rich experience in the arena of- Domain & Business Process Experience
- Oracle Application - PeopleSoft Application - AR Process Management
- Payroll Process - Vendor Management - Collections
- Transition Planning - Customer Relationship - Resource Planning & Hiring
- Quality & Documentation - Auditing - Statutory Compliances
- Metrics & Reporting - Flux Analysis - Tax Reporting ERP Experience
- Experience in implementing/upgrading Oracle R12 (in house).
- Testing and Support Experience during implementation and upgrade of Oracle R12.
- End user hands on experience and upgrade experience in PeopleSoft Applications (PS 8.0, 8.5, 9.1, & 9.2). Projects & Transition Experience:
• In house implementation/upgradation experience in: o Oracle R12 & 11i.
o PeopleSoft FS Module 8.0, 8.5, 9.1 & 9.2.
o PeopleSoft HR Module 9.1 & 9.2.
• Handled Migration Testing activities viz. UAT activities, Load Testing, rigorous testing, coordinating with Apps IT team and various other LOBs, attending feedback calls, etc.
• Hands on with Oracle BI Discoverer.
• Knowledge of financial module of Tally version 6.3 & 5.4.
• Well versed with Windows, MS Office (Excel, Word, PowerPoint and Access).
• Process Improvement, Clean-up & other projects:
o Automation of manual timecard processing.
o Reduced DSO from 49 days to 35 days.
o Moved 65% of vendors to ACH payment method.
o Reviewed Flowdowns/contracts with customers & vendors. o Member of Transactions Quality (Internal) Audit team and AR Internal Reporting Team. o Super user for Oracle system upgradation projects. o Special Projects, assisting other internal teams’ projects, etc.
• Planning & coordinating the knowledge transfer training by US team to India team. o Transition of Accounts Receivables Process.
o Transition of Collection Process.
o Transition of Vendor Management process.
o Transition of Payroll Process.
• Monitored and communicated progress and bottlenecks during the transition.
• Created performance measures related to the objectives.
• Logging, tracking, and following open issues to resolution and establishing target dates.
• Implemented an ongoing performance management process, as part of business-as-usual following transition. Educational Qualification:
Chartered Financial Analyst (C.F.A.) – Institute of Chartered Financial Analyst of India
Completed C.A. (Inter) – Institute of Chartered Accountants of India
Masters in Financial Management – Pondicherry University
Bachelor of Commerce - Madras University
Organizational Experience:
Nov 2009 to Till date:
Volt Information Sciences, USA (Arctern Consulting P Ltd, Bangalore) o Operations Manager – US Payroll, Accounts Receivables & Collections and Vendor Management. Prem R B Contact: +91-998**-*****
E-Mail: *******@*****.**.**
Mar 2005 to Nov 2009:
Oracle India Pvt. Ltd., Bangalore
o Team Leader - Accounts Receivable Process
Oct 1997 to Feb 2005:
M/s Sundar, Ranganath & Srinivasan, Chartered Accountants, Chennai o Accounts & Audit Consultant (Jan 2002 to Feb 2005) o Served as an articled clerk as part of Chartered Accountancy Course (Oct 1997 to Sep 2001)
Key Deliverables – US Payroll:
Timecard Processing:
o Maintain payroll information by designing systems; directing the collection, calculation, and entering of data.
o Balance the payroll accounts by resolving payroll discrepancies. o Provide payroll information by answering questions and requests. o Maintain payroll guidelines by writing and updating policies and procedures. o Comply with federal, state, and local legal requirements by studying existing and new legislation; enforcing adherence to requirements; advising management on needed actions. o Maintain employee confidence and protects payroll operations by keeping information confidential. o Complete operational requirements by scheduling and assigning employees; following up on work results. o Maintain payroll staff by recruiting, selecting, orienting, and training employees. o Maintain payroll staff job results by counseling and disciplining employees; planning, monitoring, and appraising job results.
o Contribute to team effort by accomplishing related results as needed. Employee Benefits:
o Ensure accurate and timely validation and processing of sick pay, holiday pay, PTO and longevity payouts.
o Ensure accurate set up and processing of per diem and salary exempt. o Publish metrics pertaining to Compliance.
o Maintain payroll guidelines by writing and updating policies and procedures. o Comply with federal, state, and local legal requirements by studying existing and new legislation; enforcing adherence to requirements; advising management on needed actions. o Maintain employee confidence and protects payroll operations by keeping information confidential. o Complete operational requirements by scheduling and assigning employees; following up on work results. Employee Support (Hotline):
o Handling the team which answers incoming employee calls regarding Pay and Timekeeping issues. o Responsible for maintaining a high level of professionalism with callers, remaining courteous with callers. o Meet performance metrics for inquiries by phone and email within established SLAs and meeting minimum daily/weekly volumes.
o Maintain caller information in the customer service database during and after each call. o Learn and stay updated on payroll troubleshooting tactics, system knowledge and stay informed of any changes in company activities that may impact the employee pay cycle.
Key Deliverables – Accounts Receivables & Collections and Vendor Management: Managing Accounts Receivables & Collections Team responsible for: o Creation & review of various transactions viz. invoices, credit memos, adjustments, refunds, sub system interface, manual journals, preparing the aging of receivables, provision for bad debts, etc. o Periodical (Weekly, Monthly, Quarterly & Year) closing activities for closure of books & reconciliation of AR sub ledger to GL.
Prem R B Contact: +91-998**-*****
E-Mail: *******@*****.**.**
o Preparing reconciliations for all AR accounts with GL and identify and close the open items if any contributing for the reconciliations under Records to Report (RTR). o Making a monthly analysis of aging of receivables and reporting the same to General ledger controllers under Records to Report (RTR).
o Adjustments to the invoices based on company policies and within control framework under Order to Cash (OTC).
o Preparing Non-Trade invoices based on request if any from business units and approval of BU managers under Order to Cash (OTC).
o Posting AR balances to GL on Weekly basis and analyzing for the unposted items if any from AR to GL. o Preparing weekly aging report of customers.
o Regular & consistent follow-up through email/phone with customers having past due items. o Calls with Customers to handle and fix disputes/discrepancies, expedite payments, etc. o Communication to past due customers with the help of Legal Department. o Forecasting monthly collections from the customers. o Ensuring that customer payments are received in a timely manner. o Developing and maintaining effective business relations with customers. o Publishing Top Aging Customers report to Management in US. o Escalating high value past due items and follow them up until they are cleared from Top Aging Customers Report.
o Reviewing and analyzing weekly aging reports prepared by the team to ensure that customer accounts are managed effectively.
o Weekly aging status meeting with Director in US. o Monthly review of sales tax, potential bad debts, unclaimed credits and on account items. o Preparation and Submission of various periodical reports to Management Team in US. o Working closely with Credit Department.
o Liaise with contract administration, sales, legal and operations departments. o Setting up SLA and maintaining Metrics of the Process. o Complying with SOX requirements on internal controls. o Maintaining an escalation/issue log to do the root cause analysis and fix issues at source level. Managing Vendor Management Team responsible for:
o Forecasting monthly collections from the customers and payables to the vendors. Analyze the variances. o Ensuring that customer payments are received and vendor payments are released in a timely manner. o Daily forecast to Treasury on payment to be released to the vendors. o Escalating Vendor past due items to Management.
o Maintaining portal access to the vendors.
o Staffing Assignment Verification.
o US & Canada Vendor Tax Reporting.
o Supporting Payroll, Disbursements, Vendor Maintenance & Expense processing teams. o Liaise with Contract Administration, Sales, Tax, Legal and Operations departments. o Member of Internal Quality Audit Team and facilitate external audits. Team Management:
o Communicate and reinforce organizational goals and initiatives in a way that helps team members to understand their contribution and accountability to the success of the organization. o Proactive sessions with individuals to ensure effective conflict management. o Planning & coordinating the training for new joinees. o Mentoring the team and motivating them through Rewards & Recognition program. o Providing positive and collaborative work environment. o One-on-one meetings with team members to give timely feedback and address their areas of concern. o Budgeting and Resource Planning.
o Team building and Team Bonding activities.