Prasanna Kumar - FP&A

4
Prasanna Kumar # 301-E North First Lane Dooravani Nagar Bangalore 560016 – Mobile 9880519379 E-mail: [email protected] A highly motivated and result driven professional with strong desire to learn, contribute and make a positive difference to the organization AREAS OF EXPERTISE Transition Management Variance Analysis, Forecast and Cost analysis Develop the dashboards Automate the process with VBA Coding Complex Expense & Revenue reporting Financial Statements Analysis & Preparation B/S & P&L reconciliation and accounting Problem Solving Skill Audit of SOX compliance Operation Management Teamwork & Staff Supervision Influencing and leading Relationship Management TM1 Administrator PROFESSIONAL EXPERIENCE Associate Manager State Street HCL Services Jan 2013 – 4 th Jan 2016 Reporting & Analysis Forecast & Variance analysis on IT spend Variance Analysis: Tracking / Analyze the material variances from the targets fixed v/s actual and Action Plan Prepare, analyze & track the aged accrual and financial recommendations to controller for decision making purposes Analyze & allocation of contract cost Monitor performance indicators, highlighting trends and analyzing causes of unexpected variance Supervision of Financial Analyst(s) Oversee and manage the continued development of Budgeting, Financial Forecasting, Operating Plan and Modeling tools Ad-Hoc Reporting and Analysis Quarterly and Monthly Financial reports Implement and work with a Business Intelligence Tool and Dashboard reports Improve performance by evaluating processes to drive efficiencies and understand ROI in programs, new projects Develop financial models and analyses to support strategic initiatives Analyze complex financial information and reports to provide accurate and timely financial recommendations to management for decision making purposes Supporting Senior Management Team and controllers with in-depth analysis Prepare presentations to Board of Directors and Senior Management Team Perform detailed account analysis and corporate month-end processing and reporting Automation & Query Building by using VBA code: Accrual booking, forecast Query & Estimate v/s estimate query Developed and automated financial monthly reporting

Transcript of Prasanna Kumar - FP&A

Page 1: Prasanna Kumar - FP&A

Prasanna Kumar

# 301-E North First Lane Dooravani Nagar Bangalore 560016 – Mobile 9880519379 E-mail: [email protected]

A highly motivated and result driven professional with strong desire to learn, contribute and make a positive difference to the organization

AREAS OF EXPERTISE Transition Management Variance Analysis, Forecast and Cost analysis Develop the dashboards Automate the process with VBA Coding Complex Expense & Revenue reporting Financial Statements Analysis & Preparation B/S & P&L reconciliation and accounting

Problem Solving Skill Audit of SOX compliance Operation Management Teamwork & Staff Supervision Influencing and leading Relationship Management TM1 Administrator

PROFESSIONAL EXPERIENCEAssociate Manager State Street HCL Services Jan 2013 – 4th Jan 2016Reporting & Analysis

Forecast & Variance analysis on IT spend Variance Analysis: Tracking / Analyze the material variances from the targets fixed v/s actual and

Action Plan Prepare, analyze & track the aged accrual and financial recommendations to controller for decision

making purposes Analyze & allocation of contract cost Monitor performance indicators, highlighting trends and analyzing causes of unexpected variance Supervision of Financial Analyst(s) Oversee and manage the continued development of Budgeting, Financial Forecasting, Operating

Plan and Modeling tools Ad-Hoc Reporting and Analysis Quarterly and Monthly Financial reports Implement and work with a Business Intelligence Tool and Dashboard reports Improve performance by evaluating processes to drive efficiencies and understand ROI in

programs, new projects Develop financial models and analyses to support strategic initiatives Analyze complex financial information and reports to provide accurate and timely financial

recommendations to management for decision making purposes Supporting Senior Management Team and controllers with in-depth analysis Prepare presentations to Board of Directors and Senior Management Team Perform detailed account analysis and corporate month-end processing and reportingAutomation & Query Building by using VBA code:

Accrual booking, forecast Query & Estimate v/s estimate query Developed and automated financial monthly reporting

Delivery and Staff Contribution: Goal Setting : Setting and review and evaluate performance and support to achieve goals Manage & monitor operational activities Recruiting, training, appraising and supervising staff Ensure people management & Issue Management Transition Management Design and coordinate the training programs for employees in order to enhance work efficiency Motivate the teams

Page 2: Prasanna Kumar - FP&A

Prasanna Kumar

Lead IBM Daksh Pvt. Ltd June 2008 – Sep 2012

Reporting, Analysis and Accounting: Prepare Income statement & Balance sheet Perform actual verses budget variances and generate variances report for management. Assist in preparing monthly financial forecasts and yearly financial budget Prepare variance & forecast report on Spend items Prepare business reports and perform ad-hoc financial analysis to support business operations Prepare and analyses the Account Receivable aging scheduler and cost driver Analysis Cost & Recovery reconciliation Prepare and analyze the Income and Expense report; Cost & Revenue Report, Labor Claim report,

Gross Spend report & Mobility Report Analyze and post Journals; Accrual, Prepaid entries, Periodicities and deferral entries Expense Reimbursement Report Computing monthly fixed asset depreciations Responsible for budget accounts set-up/transfer; general ledger and chart of accounts

maintenance Supervises the work of assigned personnel; determines priorities, schedules, reviews reports,

controls, reconciliation and computations; recommends and provides training to assigned personnel

Automation & Query Building: Automate the various recurring activity by using VBA code and awarded twice as “Star Top Talent Award and Star Performer”Lead Function: Controller: Bond Approval, ICA Creation and Billing & Capital Expenditure Approver Manage & monitor operational activities Ensure people management & Issue Management Design, coordinate & conduct the training programs for employees in order to enhance work

efficiency, motivate and to gain skills Motivate the team members

Research Analyst Thomson Corporation Pvt. Ltd May 2006 - Jun 2008

Prepare & analyze Quarterly, Interim & Annual Financial Statement Segment Analysis Report based on Product/Services & Geography Cost driver analysis Prepare and Analyze Ratios; Solvency, Profitability, Capital Market & Performance Ratio Calculate Book Value, Net asset value, closely held shares, Market cap and Working capital etc. Analysis on extra ordinary items & their impact on EPS & DPS

Assistant (Accountant) Lakshmipathai & Co Jan 2003 - Dec 2004

Prepare Balance sheet, P&L and Cash Flow Statement Analyze and post JE Maintain Books such as Purchases, Sales, Cash/Bank- Receipts & Payments, Debit Notes, Credit

Notes & passing the day to day Journal Entries Prepare and audit the expense and income items Assist auditor during Interim audit and annual audit

PROFESSIONAL ACHIEVEMENT Star Performer Award 2014

Page 3: Prasanna Kumar - FP&A

Prasanna Kumar

Top Talent Award 2012 Top Talent Award 2011 Awarded “Top Rank performer & Star performer” 2010 Recognized as Quality Champ for 100% Quality 2009

Educational Qualification  Course Board/University Institution CompletedMBA (Banking and Finance) Alagappa University KIET, Bangalore 2011-2012B.Com Bangalore University B.E.S Evening college Bangalore 2002-2003

Application/Technical SkillsApplications & Tool Specialization TM1 Administrator, Hyperion, Essbase, Khalix, Oracle, SAP , VBA &

MS Access , People Soft, TM1

I consider myself familiar with Finance & Accounts. I hereby declare that the above stated information is true and correct to the best of knowledge and belief.

Place:Date: (Prasanna Kumar M Y)