Lohit Ramesh

OSSPLVS Address: #S14, 6th LOHIT RAMESH Cross, KEC Colony,Basaveshwara Nagar, Bangalore-79, Karnataka, India. Contact: - (M) E-mail-To build a career in the Business, Finance and Sales Pipeline corporate strategy and analysis areas, assisting the organization make critical decisions. CAREER CONSPECTUS ▪ A result oriented professional with nearly 9 years of experience in Finance & Accounts, Sales pipeline analytics and MIS Report and Expert level knowledge in Financial Analysis and Reporting, Statutory compliance. Lead Financial Analyst with expertise in budgeting, forecasting, variance analysis, and ad hoc reporting, Expert at building Excel-based financial models and tools to maximize profits and mitigate risks. Currently associated with Colt Technologies Pvt.Ltd. as Lead Financial Analyst (FP&A& Sales Analytics). A dynamic finance professional close to 9 yrs experience with a thorough grasp of the various financial policies and procedures, with the ability to relate theory with practice. Exceptional planning, execution and interpersonal skills with an analytical approach thus being able to comprehend and explain complex financial data easily. ▪ ▪ ▪ ▪ CORE COMPETENCIES • • • • Financial modeling & Reporting Forecasting & Budgeting Variance analysis Sales Pipeline Reporting and Analysis     Sales commission Calculation Presentations & Dashboards Performance metrics & KPI’s P&L Management  Trend Analysis & Ad hoc Reporting  Price/cost/margin analysis  Financial projections  Month Close exposure EXPERTISE IN REPORTING TOOL’s • • • ERP Exposure: Oracle, SAP, JDE BI Tools: BO, EDW, HyperionEssbase, BPC Sales Reporting: Sales force, C4C, Fusion  Analytics Reporting Tool : OXO, MicroStrategy, Tablue, TrueComp  MS Product’s: Excel /Macros, Access, PowerPoint, Word & Visio.  Others: Built & Design Excel/Macro based reports, modules & Shells. Edraw Max and Other Business Analytics Tools. PROFESSIONAL EXCELLENCE COLT TECHNOLOGIES, BANGALORE Sr.Lead Financial [FP&A and Sales Reporting Analytics] Jun 2014-Current • Analyze quarterly and monthly divisional financial statement including comparison of Actual results to Budget/Forecast and analysis of key financial metrics and trends. • Drive Budgeting, Forecasting and Analysis of the LOB/Function/Region on periodical basis, by working with leadership teams to accurately define assumptions and key drivers for business per process. • Investigate, review, analysis and publish the standard and adhoc reports, including profit and loss accounts, dashboards and review decks, as required by business, on the financial performance periodically on weekly/monthly basis, along with the details of reasons for the key variances to forecast and plans, trends MoM/YoY observations and suggestions, as applicable. • Assist to team of finance managers and analysts for various key weekly, monthly and quarterly business metrics: including bookings analysis, Backlog, GM analysis, HC and forecasting and Ensures timely and accurate financial reporting and submissions in HFM. • Create sales pipeline reports for management staff and use the data from reports to create sales forecasts. Develop detailed and accurate forecasts by Sales Region, Channels period, Product, LOB and MH Hierarchy. • Support the APAC & EMEA Regional business operations team with periodic reporting and analysis on the Revenue, Pipeline generation, Pipeline gaps, KPI Measurement, etc.., • Create sales reports for management staff and use the data from reports to create sales forecasts. Develop detailed and accurate forecasts by Sales Region, Channels period, Product, LOB and MH Hierarchy. NOTABLE CREDITS Awarded Colt Shine for the best performance for the Qtr. From Finance Director. Automated and build model for the Sales pipeline/Funnel, Bookings, Backlog, CAPEX and Revenue reports by developing a Macro in MS Excel and MS Access for it which in turn reduced the man hours consumed to produce the reports. Also won the ACE Award from Senior Management. Eawards 2015 from Regional and Sub-Regional Management for outstanding efforts and making the Site profitability Model (By Site/Period). JUNIPER NETWORKS, BANGALORE Senior Financial Analyst [FP&A and Sales Reporting Analytics] May 2013 – Jun 2014 • Play a key role in the annual budget and monthly forecast preparation including submissions in Hyperion for APACGBU [IT, Facilities, Finance, Legal & Tax]; conduct various Ad-hoc analyses and verifications to ensure the accuracy, rationality & achievability of corporate budgets and long-term plans • Prepare periodic variance analysis between actual, latest forecasts and budget relating to sales and gross profit, and make recommendations to improve profitability. • Prepare monthly cost center analysis, delving into variances to understand the drivers, making recommendations and highlighting issues where applicable • Drive monthly P&L reviews on BVA [IT, Facilities, Finance, and Legal&Tax]& help monitor financial efficiencies and targets. • Gather data/information for the development of measures and reports for historical and/or predictive analysis within the business unit to maintain efficient Rhythm of Business through weekly, monthly and quarterly reviews of business • Owner of business process for commission calculation for field sales organization, including independent representatives, and maintain and analyze complex data sets to determine horizontal and vertical relationships in sales data, preparing monthly commission packages for review by Business Partners, Managers and Finance Directors. • I lead regular discussions with my Global FBPs to facilitate the Commissions Forecast (having led the EMEA forecast in the previous fiscal). We draw on historic data trends to understand and illustrate the pipeline, and provide accurate estimations of attainment for quarter-end at an individual sales rep level, whilst calculating a subsequent earnings exit point for the reps (accounting for past and future commission, bonus, SPIFF, draw and strategic objective payments). NOTABLE CREDITS Awarded Juno’s Star for outstanding performance in 2013 Automated and build model for the Sales pipeline/Funnel, Bookings, Backlog, CAPEX and Revenue reports by developing a Macro in MS Excel and MS Access for it which in turn reduced the man hours consumed to produce the reports. ORACLE INDIA, BANGALORE Senior Financial Analyst [FP&A and Sales Reporting Analytics] Sep 2010 – Apr 2013 • Delivery Reporting and analytics to SFM’s &RFD’s Functions including Monthly Operating Reports, Quarterly Variance Analysis, Outlook, Forecasts and Budget Achievements. • Responsible for development of various customized dashboards in MS Excel, MS Access and OBIEE to be used by top management in decision making • Provide Operational Information through Financial and Statistical Reporting: Responsible for generation and distribution of the summary of daily, weekly, monthly and annual management information reports such as Pipeline, bookings, backlog, COGS and revenue reports for Oracle Hardware Products in terms of business unit, sales location, client industry and trade type to the top management in Europe, Middle East and Africa on daily basis. • Coordinate Management Reporting processes to ensure consistency across Functions, including improvements to standard reporting and the database tool (Sales Dashboard, Automations on Bookings, Pipeline)Identify and implement ongoing improvements for analysis & reporting. • Forecasting Models: Creating employee & non employee related expense P&L using model to arrive at the forecast numbers finalized post discussion with field and Ops. • OPEX Analysis: Arriving at actual Operational Expenditure & striving towards the optimization of OPEX. • Preparing monthly expense trackers & quarterly dashboards for regular business review. • Run daily close reports to identify trend & direction of monthly/Qtrly close performance with focus on ability to meet forecast & budget for the month. • Key roles in various global initiatives including automation projects for financial reports presentation with Oracle Business Intelligence tools,VBA Excel and Hyperion. NOTABLE CREDITS Achieved “Customer Star Award” for Q4’FY11 at Oracle India Pvt. Ltd. Awarded DF2 for the best performance for the Qtr from RFD’s Automated the Bookings, Backlog and Revenue reports by developing a Macro in MS Excel and MS Access for it which in turn reduced the man hours consumed to produce the reports and won the award from Vice President, Global Finance Operations. Received appreciation award from the SFM’s & RFD’s in 2011 & 2012 ACCENTURE INDIA, BANGALORE Financial Planning Analyst Aug 2006 – Sep 2010 • Assist business units of client (NCR) to close their financial books for period-end (Month/Quarter/Year) and enable them to report financial results. • Perform Account reconciliation for key Balance sheet & P& L Accounts (Cost, Revenue, Provisions, IIT, CMS Internal Orders, and CEI). • Projection of financial statements (BS, P&L, Cash flow statements) for multiple years and Provide guidance/alerts to business on operational and key financial indicators like Revenue, Cost, Inventories Margin, Margin % etc and Perform extensive analysis of Cost & Revenue transactions and reports. • Preparation & Maintenance of financial projection model: Variance Analysis, Budgets: Actual v/s forecast (spending variances to budget/forecast for the plants), Management reporting on a weekly, monthly and quarterly basis, Ad hoc analysis & Reporting non standard (Supporting file for E&O, Product Cost, Physical Verification report) based on request of financial information. • Maintain and updating key operation matrix & Reporting for internal management review (MOR, 3/3, SIPOC) • Respond promptly and accurately to queries from Business managers and local controllers (Monthly, Quarterly and yearly) • Attend weekly management meetings highlighting variances, suggesting corrective actions, and informing the team of impending requirements and Upload forecast and budgets into Hyperion, Reconciling outputs to what is expected and resolving any difference • Prepare monthly P&L, Reconciliation reports and work closely with controllers as needed, complying with deadlines and SOX requirements. • Review, investigate and correct errors and inconsistencies in financial entries, documents and reports (Expenses, forecasts, Pricing and financial reports) NOTABLE CREDITS Awarded with Star of the week, Team Spirit monthly certificates many times. Received appreciation award from the client in 2008 & Jan 2009. I was awarded as a strategic planner as well as best performer in Jan 2009 for automated the process to improve rigor and speed in the processing of critical information. Received Q2 Numero Uno Award in 2009 for preparing the high level process maps, prepared PowerPoint presentation on the process and developed various Excel & Access based trackers for the process INSTITUTIONAL COMPUTER ACADEMY Tally Accounting Faculty Aug 2000 – till now [PART-TIME] ▪ Taught Computerized Accounting programming (Tally and Busylite) ▪ Invited as a guest faculty for several colleges in order to enhance computerized finance accounting skill. NOTABLE CREDITS ▪ Awarded as Top Tally Faculty in the Harihar &DavanagereDist for developing E-Learning and E-Quiz patterns for the students. ▪ Link to view the Certificates http: www.scribd.com/doc/-/Tally-Experiance-CertificatesLOHIT SCHOLASTICS ▪ MBA (Finance & Accounts):SJCE College, Mysore. (Visveswaraiah Technological University, BELGAUM). – 1st Class. ▪ B.Com: SJVP College, Harihar. (Kuvempu University). –11th Rank (88%) PERSONAL DOSSIER ▪ Date of Birth ▪ Address : : ▪ Linguistic Abilities : Date: Place: BANGALORE 19th September 1982 #24, Kamala Venugopal,5th Cross, Lakshminagar, 3rd Stage 4th Block, Basaveshwara Nagar, Bangalore-79, Karnataka. English, Kannada & Hindi.