Ajay Kumar Mohanty

Ajay Kumar Mohanty E-Mail:-, Mobile: -, - JOB OBJECTIVE Seeking Senior Managerial level assignments in Financial Planning & Analysis, Financial Management & Costing/ Accounts with a growth oriented organisation. PROFESSIONAL EXPOSURE Finance Operation Service Delivery Budgeting, Forecasting Vendor Management SLA Preparation and Job Assignment Variance Analysis Recruitment Project Testing and Implementation Expenditure Analysis Payroll Management HC Costing and Chargeback Finance Control Procurement Project Cost Analysis and Month-end Chargeback Costing and Cost Analysis Induction KPI Metrics Month-end Close Training and Development AREA OF EXPERTISE Financial Planning & Analysis Preparing short term / long term budgets and designing business plans / strategies for maximizing profitability & revenue generation & realize corporate goals. Formulating budgets and conducting ratio/ ageing/ variance analysis to determine difference between projected & actual results and implementing corrective actions. Determining financial objectives, preparing & implementing systems, policies & procedures and reporting variances to facilitate internal financial control. Responsible for formulating a long-term business plan for the business, revenue analysis, and budgeting and forecasting. Ensuring financial analysis, pricing/profitability analysis, evaluation of risk/opportunities and executive reporting/analysis. Preparing, reviewing and distributing monthly financial reports to stores and cost/profit centres. Tracking expenses and revenues vs. budget and reforecast and analysing fluctuations. Cross Charging and re-classing costs/IT charge accounts for Month-end Closing. Assisting in the budget & reforecast process and maintaining budget and reforecast information in the accounting system. Systems Implementation Have been selected as a Lead to develop, test and deliver OBIEE Reports (GRNI,SOX Compliance, Invoice On Hold, KPI and Management Dashboard) in HARSCO. Automated IT Cost and Chargeback table across HARSCO. Have been a part of the Oracle Implementation team for Brazil in HARSCO. Have been part of Testing and Manual Uploading of Sub ledgers in Blackline. Also part of automation from Oracle and JDE testing for automation of Blackline in HARSCO. Had been selected as a key member for implementing Hyperion planning & Reporting Suite in Electronic Arts, EMC. Training and Development Have been awarded as an internal trainer on “Presentation Skill”, ”Stress Management”,”Finance for Non Finance Executives”,MS Excel and Hyperion/HFM. Developed Several Training and Development Contents for new employess. Handling Induction program for New Employees. ORGANIZATIONAL EXPERIENCE Since Sep’13 with Harsco India ServicesPvt. Ltd., Hyderabad as Manager-Finance Operation Role: Responsible for developing Function budgets and using financial early warning forecast systems for the product Lifecycle Services functions. Provide financial and budgetary forecasts for the Global and local leadership for use in short and long term company financial and budgetary planning, ensuring reporting system interoperability and data integrity. Work closely with the business to support their operational activities related to broader finance functions. Provide accounting services while ensuring quality of financial and management information that support effective decision making. Deliver Budgets / Targets in line with Global Guidance letters. Provide periodic reports to Global and Local business head with in depth analysis. Work on developing business case for new projects / expansions. Month-end Reclass and Accrual Entries for OBIEE and GBS Team (IT Allocation). Developing and Delivering Management Reports in OBIEE. Balance Sheet reconciliation (Sub ledger level) in Blackline. Creating UNSPC codes and doing the GL Mapping. Highlights Was responsible for Successfully Transitioning Investor Relations Reporting from USA to India. Automated IT Cost and Chargeback table across HARSCO. Effectively Transitioned Balance Sheet Reconciliation and T&E Analysis Reports from UK to India. Automated Capital Lease JE uploads successfully in Oracle for UK, MEA, USA and Canada. Set up an efficient SLA review mechanism which is used for cross charging internal clients / customers. Mar’09 to Sep’13 with Electronic Arts (EA) as Sr. Analyst–Financial Planning & Analysis Role: Acting as a team lead for 4 members supporting various labels & studios across multiple locations. Responsible for setting up individual & team goals, tracking their progress and conducting annual appraisals. Working as a primary FP&A contact for the Corporate SG & A Team with an annual budget of $9 Million. Responsible for preparing its annual budget, setting up Staff month rates by project, working on quarterly reforecast, conducting variance analysis calls etc Posting of Month-end accrual entries (Bonus and 401 K) and Re-class entries for IT and Non-IT departments. Worked as a Finance Lead for FP&A exercise of Global IT Shared services with a total budget of $39.5M. Partnering with accounting, investor relations, and the rest of the global FP&A team in preparation of the quarterly earnings book used in the earnings call. Key reports; trended P&L’s & platform performance reports. Prompting the global finance transformation effort including operating expense analysis, capital expenditure reporting, and headcount reporting and process improvements. Highlights Was responsible for creating a highly successful team from scratch. Have hired fresh college graduates and moulded them into highly successful team members. Successfully designed and developed several financial dash boards for Management. Actively involved in transitioning of the FP&A process for Shared IT and Non-IT(Legal,HR,Finance) functions from Redwood Shores to Hyderabad. Successfully automated and rolled out Management Dash board, which saved 2-Man Hour Cost and a Transition Cost of $50K; DETs (Department Expenses Template) for 78 different verticals had been automated and delivered for monthly forecast. This Saved Two-Man hour cost every month and transition cost upto $45K(got accolades from CAO for best Customer Service); A key member in Fun Committee and CSR Team; Sep’06 to Mar’09 with EMC Data Storage India Services (Pvt) Ltd, Bangalore as a Sr. Analyst - APAC Role Successfully Transitioned Weekly Sales Estimate, Pipeline and Target Bonus Reports from Singapore to India. Prepared Weekly Forecast Report for 13 countries all across APJK region. Prepared T & E Expenditure Analysis Report for APJK region. Prepared Monthly/Quarterly Variance Analysis reports from P & L. Prepared weekly Cash Flow Analysis. Prepared Monthly/Weekly Leadership HC report for Management. Helped in HR Cost Analysis. Responsible for comparing Actual performance with the business plan targets and assisting in defining, automating, and implementing weekly, monthly and quarterly reporting, forecasting and budgeting processes. Achievements Holds the distinction of implementing Essbase and Brio in 2006-07. Weekly Sales and Pipe line Forecast Reports. Weekly Cash Commitment Report. Monthly HC Movement Report. Responsibilities: Identifying business scenarios and accordingly preparing process flows. Identifying Pipeline Orders and Shipment details. Performing defining process of various business issues relating to Cash Flow Analysis and Monthly Target Rates. Accountable for identifying various existing reports and studying old necessity for reports in Brio. Mar’05 to Sep’06 with NaandiFoundation, Hyderabad as Sr. Executive-Finance Role Managing Secretarial Practices being an Executive Asst. to the CEO. Conducting Monthly Budget Meeting and Budgetary Control. Responsible for comparing Actual performance with the business plan targets and assisting in defining, automating, and implementing weekly, monthly and quarterly reporting, forecasting and budgeting processes. Preparing Project reports for different funding agencies. Preparing Expenditure analysis with proper Charge back accounts against fund allocation. Helping KPMG and other Funding Agency Auditors for Statutory Audit. Achievements Holds the distinction of getting Funds from Michel-Susan Dell Foundation(MSDF) $5Million and $1million from DFID,UK. Got PF waiver worth INR 33 Lakhs for a not-for-profit organisation. Successfully automated Monthly Budget Meeting (MBM) trackers. Dec’03 to Feb’05 with Pokarna Ltd., Hyderabad as Asst. Manager-Finance Role Managing Day-to-day Accounts and Preparing MIS reports. Preparing Cost Sheets . Sep’01 to Nov’03 with Nanz Food Products Ltd., New Delhi as Asst. Manager-Accounts and Finance Role Managing Day-to-day Accounts and Preparing MIS reports. Taking Care of FTS. Jun’94 to May’99 with Padhi& Co. CA Associates., Berhampur,Odisha as Audit Assistant EDUCATION MBA (Finance) from Berhampur University, Odisha in 2001. PGDHRM from Pondicherry University in 1998. LLB from Berhampur University,Odisha in 1997. TRAINING UNDERTAKEN Undergone training on Advanced certificate in PC applications at BDPS for 6 months in 1998. Oracle Training under Oracle University,New Delhi in 2001. IT AND TECHNICAL SKILLS Operating Systems: Windows XP, 2010, 9x, 2000 Server, DOS. ERP:Oracle 11i,R12 Application Software: MS Office, Hyperion Enterprise,OBIEE Accounting Package:Tally Data Warehousing:Cognos,Brio and Oracle tools (IBM) ACHIEVEMENTS Have been rated Significantly Above Targetin2014 and received a letter of appreciation from the Director Finance Europe of HARSCO. Received Impact award for 2016 from CEO,HARSCO. Received CAO’s Customer Satisfaction Award in 2011 and Special Appreciation Award for successful transition of FP & A process in 2009 at Electronics Arts. Received Start Performer Appreciation award from CFO,APAC at EMC in 2007. PERSONAL DETAILS Date of Birth: 30thMay 1973 Permanent Address: B#317,ARK Towers,Mayuri Nagar,Miyapur,Hyderabad-500049. Contact No.: - Passport no: A- Valid US B1 visa: Expiring Apr 2019 Extra-Curricular Activities A Master Trainer in HARSCO and facilitated training programs on Presentation Skills, Basic Excel, Portfolio Management, Management dashboard, Stress Management. Participated in intercompany Badminton and Carom Tournament conducted by HYSEA. Leading the Fun-factory team in HARSCO and was a part of the fun-factory team in EA. An active social worker and part of CSR teams in different companies for last 10 years.