Financial Analyst Investment

Hemanthe Sarath Ekenayake

(Hay_maan_ta E_ka_na_yaka) (US Citizen)

*** **** *****, *** *****, CA 94024 650-***-**** (H) 650-***-**** (C)

*********@*****.*** www.linkedin.com/in/hemanthe-ekenayake-hse1019

GLOBAL SENIOR FINANCIAL ANALYST

Employ Expertise in Business Finance in Competitive Corporate Environments

To Make Significant Value-Added Contribution to Financial Stability of the Firm

Results oriented and goal driven, organized and highly detail oriented with exceptional analytical skills, using efficient and effective mechanisms. Known for multitasking and interacting well with broad range of people. Creative and foresee outcomes beforehand, take mitigative action, and establish improved processes. Possess unique set of skills that is beneficial and an asset to organizations,

Expertise includes:

Short & Long-range Financial Planning Opex and Capex, Contract Management

Financial Planning, Analysis & Decision Support

Financial Forecasts & Cash Flow Management

Grant Accounting, Costing & Budgetary Control

Implementing ERP Systems, integration of financial systems & Enhancements

Change Management & Business Support

Administration, Operating & Capital Budgeting with Risk Identification

Project Evaluations & Modeling

Improve Systems & Processes

Knowledge of merger & acquisitions

Revenue Accounting, Forecasting & Analysis

TECHNICAL SKILLS

Platforms: ERP

Applications: Microsoft Suite, Oracle including R12, SAP

Databases: Oracle, Hyperion, PeopleSoft, Essbase, Ariba, Access, Sequel

Tools: Excel (advance level), Power Queries, Brio / Business Objects, Power BI, EIS

Other: SQL, Tableau

PROFESSIONAL EXPERIENCE

CISCO SYSTEMS INC, San Jose, CA (Contract through Larsen & Toubro Infotech Limited) Jul 2022– Dec 2022

Sr. Financial Analyst

Building and maintain the budget. Developing and implementation of a 12-month running forecasting model and involved in all aspects of forecasting leading capital and operating expenses processes.

Head count planning and reporting with collaborating with Key business partners establishing good relationships and driving business goals and initiatives.

Conducting budget vs actual and trend analysis reporting, while identifying drivers, variances, and areas for improvement.

Own regular and ad-hoc reporting and analysis to provide significant metrics and insights. Used PowerBI to great extend.

Used Purchase Orders in SAP Ariba systems in developing forecasting model and approved all Purchase Orders in Ariba system.

Preparation of periodic Head Count reports for the management

Use Essbase reporting system to produce various reports with graphs and statistical information for the management.

CISCO SYSTEMS INC, San Jose, CA (Contract through L&T Technology Services Limited) Feb 2021 – Oct 2021

Sr. Financial Analyst/Program Manager – Cloud & Non-Cloud Security Business Operations and Planning group

Developed and implemented a periodic forecasting mechanism and a Forecasting Model for the first time at the organization. The model consisted the World-Wide annual Capex and Opex expenditure and involved very complex areas to be considered and take realistic and accurate assumptions to be applied. All expense Purchase Orders were taken from the SAP Ariba system. Prepared and controlled budget. Annual Planing and I partnered Finance, Engineering, Sales and Product Development leaders in achieving the best results and established very close cordial relationships with them. Coordinated projects, making detailed plans to accomplish goals and directing the integration of technical activities.

Contract re-negotiation, Renewals, onboarding and management of contractors and suppliers of their performance, risks and adherence to agreements ensuring periodic maintenance is carried out on assets supplied by them.

Extracted large data sets from multiple sources and analyzed, measured performance, identified trends and developed variance reports using PowerBI, briefs and recommendations for necessary corrective actions to meet financial targets. Successfully carried out the liaison between Finance and Operational divisions. Prepared periodic reports and presentations for all levels of stakeholders.

Streamlined and automated a process of Budget Tool reporting by introducing Excel Power Query functionalities, which reduced the time taken to produce the final management reports to be done within few seconds, which saved the team hours of operational time.

Developed a database using Power Queries appending all GL transactions of last two years with rollup of certain account lines as needed for periodic reporting and presentations. These queries can be refreshed, and the database can be updated as and when new GL data is available. It created an efficient and effective process eliminating the existing time-consuming manual process. I shared best practices, identified gaps, drove changes and also helped determine priorities to achieve better results.

Lead the monthly and quarterly closing processes by making accruals, cross charges and necessary adjustments ensuring the organization’s financial position is accurately reflected in the final reports. Prepared periodic consolidation reports of P &L and Balance sheets for the organization involving more than 20 departments.

Helped sales team to quote complex configurable components in the product offered, which provides acceptable prices, which maximized the profits for the organization (PCQ).

Looking for the next opportunity Feb 2020 – Jan 2021

CISCO SYSTEMS INC, San Jose, CA, USA. (Contract through Insight Global Inc) Nov 2019 –Jan 2020

Sr Financial Analyst – Chief Technical and Architecture Organization

Developed and implemented a concise, effective and enhanced financial reporting with consolidations and key business insights using Essbase and Power BI on large data sets following an efficient and scalable financial process, which enabled the management to make effective strategic decisions. I was the key finance person in a cross functional team.

Project and program cost analysis and administration and management including grants, cost benefits, pricing and reporting. Took care of all innovation projects managing financing of them and reporting. Prepared bill of materials for each project taking into account of raw material, components and assemblies as required depending on projected use and business needs.

Analyzing and reporting all travel, promotional events against budgets and forecasts and produced relevant KPIs.

Design and build ETL (Extract, Transform, Load) pipelines to automate the ingestion of structured and unstructured data.

Prepared a model to show what products are moving and what are stagnated and becoming a burden to the organization at a given time. The process involved in analyzing sales Products, Predictive sales, sales Trends and Performance, sales Effectiveness, sales Pipeline and available Market Research. The model also contained product margins achieved. This helped the supply chain and marketing teams to determine competitive pricing for those products to achieve better sales.

Designed and implemented Modular and Reusable Extract, Transform and Load (ETL) processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Data Lineage Tracking, ETL Auditing, etc.

Grant Accounting and administration, Provider Contract Management, Month end close work, Accruals and adjusting journals passed and completed in a timely manner.

Setup new data visualization matrixes using Excel and Tableau systems, which helped the management to have an insight into the processes and achievements of the organization.

Worked on Strategic initiatives and managed Budgeting and short- and long-term Forecasting processes. Produced periodic variance analysis and headcount reports to key business leaders project management office (PMO) team and the senior management. Also assisted with the annual and long-range financial planning.

Developed, Maintained and distributed ad-hoc reports and critical financial models as needed.

Looking for the next opportunity Sep 2018 – Oct 2019

CISCO SYSTEMS INC, San Jose, CA, USA. (Contract through PDDN Inc),

Sr Financial Analyst / Project Consultant - Operational Services & Platforms Group, Investment Group and Worldwide Business Customer Experience Operations Group Dec 2017 –Sep 2018

Leading monthly, quarterly and annual consolidation and reporting of the group (Advance Services and Technical Services) using Essbase SmartView system. Streamlined and developed management and Head Count reports using SQL, Essbase and Power BI. Detected errors in the Essbase top level reports and corrected them producing accurate management reports. Included data mining and analysis using SQL

Partnered effectively with cross functional teams such as Product Development, Innovation Centers, Operations and Corporate Finance, translating business strategies and objectives to meet future financial goals while establishing strong relationships with the management team and project management team. Data mining and analysis produced clear data driven insights of the business operations, product performance and trends to the senior management for decision making. Became the person to go to for any financial needs.

Lead the Monthly, Quarterly Financial Planning and Analysis and Forecasting including short- and long-term modelling of Revenue, Opex, Capex and Human Resource needs. Analyzed relevant Purchase Orders from the Cisco iProcurement System, discussed with the requestors/managers for items needed renewal or completed and also determined month end accrual needs and produced relevant journal entries for the financial management system. Ensured that these Purchase Orders were taken into account in the monthly forecasts so that they were complete and accurate.

Produced Revenue including Quote to Cash and Expense analysis models with adjusting entries to help preparation of annual budget and periodic forecasting taking into account all deferrals and continuations. Prepared Group Financial templates and modeling with consolidated summaries to be used for the upcoming Annual Budgeting and Planning process.

Analyzing and reporting all travel, promotional events against budgets and forecasts and produced KPIs with travel dash boards which provided the management an insight to the effectiveness of the processes.

Constructed group monthly reporting package taking into account of group’s expected performance metrics in alignment with the company’s high-level goals and expectations after the business concept emphasized renewals and repeat business.

Assisted in month end close, general administration activities, made month end accruals and identified and made necessary adjustments so that monthly accounting was accurate,

Looking for the next opportunity Jan 2017 – Nov 2017

POLYCOM INC., San Jose, CA, USA Feb 2016 –Dec 2016

Sr Financial Analyst / IT Governance Analyst

Managed divisional budgeting forecasting, reporting, identifying, developing, and implementing improved processes where necessary. Managed all finances, planning & analysis and reporting for the Project Management Office.

Gathered operational and financial data including Revenue, Opex and Capex from Oracle R12 Financial system using SQL, Completing Financial Planning and analysis models taking into account of products such as Collaboration video, teleconference, telepresence and infrastructure software and preparing scorecard, dashboards and metric reporting.

Designed, Developed and implemented multidimensional Excel based dashboards with appropriate KPIs with an efficient business process.

implemented a business process that facilitated the consolidation and presentation.

Spearheaded IT Governance initiatives within Global IT teams, offering best options available.

Identified and led improvements needed to existing processes by carefully considering SOX requirements. Implemented an Access database to handle necessary manipulations required for Financial Planning and Analysis of Opex and Capex and reporting. It also facilitated uploading actual data onto newly implemented Project Management Clarity System, and bringing about efficient, effective, and economic way of processing data, leaving out existing Excel-based manual processes, which also improved the reporting time immensely.

Worked with IT teams and Project Management Team driving best operational practices, bringing about easier and smoother operations.

Took key role in Financial Planning and Analysis and creation of annual operating and capital plans and forecasts, bringing to light ongoing activities and costs making awareness of what was needed to be incorporated in annual budgeting and periodic forecasting. Analyzed the Purchase Orders from the iProcurement system and brought them up to the management for renewals and completions and also passed month end accruals in the system.

Attended in period-close process for IT organization, including accrual management, ensuring all accruals had been considered at month end, so financials reflected true and fair status. Streamlined accounts payable and receivable processes to achieve significant efficiencies and effectiveness.

Supported Project Management Office (PMO) in project reporting, variance analysis, costing, budgeting, and uploading to Hyperion system and initiating all projects being accurately budgeted and costed. Developed reports using Actual Cost (AC), Planned Value (PV) and Earned Value (EV) for the first time in the organization and implemented it, which provided insightful information of the project’s statuses, progress and they also helped in Budgeting and Forecasting. It facilitated corrective or preventive measures if projects are deviating from the baseline.

Managed third-party support and service and management contract renewals and management guaranteeing continuous services.

Analyzed contract terms, established amortization and payment schedules, implemented appropriate accounting treatment, and when opportunity arose, pricing and service levels were renegotiated to benefit and be advantageous for the organization

POLYCOM INC., San Jose, CA, USA Jul 2014 – Aug 2015

Senior Financial Analyst / Project Accountant (Contract through US Tech Solutions)

Provided technical guidance and direction in defining data architecture strategy for individual projects and business. Performed data reconciliations and functional testing of migration of PeopleSoft System to Oracle R12 / Oracle Financials. Helped establishment of Oracle R12 Oracle Financials Chart of Accounts for Global Operating Units. Took leading role in Oracle EBS R12 implementation. Completed quality assurance and user acceptance test programs. Prepared training materials and trained staff on the new system.

Worked with Project leaders to grasp costs and worked out financial benefits of proposed Capital projects, forecast resource needs and developed business cases. Also monitored project performance verse budgets, planed and presented monthly results to management.

Handled Project Accounting monthly open and close accounting process, reviewing monthly activity for accuracy and completeness and variance analysis.

Set up Project Accounting Reporting (using SQL to Excel), improving limited reporting available in Oracle.

Pioneered integration of Clarity System with Oracle EBS for Project Management, avoiding additional employment of staff and assuring that consistent system is available for Project Management operations.

Prepared monthly head-count report and helped finance team, Completed Financial Planning and Analysis, prepared company’s quarterly and annual published reporting. Overlooked the accounts payable and receivable processes improving various areas to avoided delays and inaccuracies.

CEREBIZ PVT LTD, Adelaide, Australia Dec 2012 – Jul 2014

Financial Consultant (Contract, Telecommute)

SAAS company. Executed improved processes and appropriate mechanisms. Improved productivity and profitability.

Developed standardized KPIs and dashboards with lots of flexibility, incorporating into Business Intelligent software that company produced, permitting clients to use them with minimal effort.

Prepared short / long-term financial planning and analysis and capital requirements, budgeting / forecasting, supporting production, sales, marketing, operations and research and development teams in this process.

Completed cost, profit volume, gross-margin analysis, variance analysis and reconciliations, raising transparency and determining favorable level of production and profitability.

Selected and implemented optimal costing, pricing and business models, allowing periodic forecasting and evaluation of profitability, Variances and helping management to make vigorous strategic decisions.

Revamped pricing of products and services based on markets, considering cost, customers, and competition in different market places, permitting serving customers more satisfactorily.

Managed all fund accounting and performance reporting and dealing with fund auditors getting audits completed in time.

Established annual budgeting of subscription, royalty revenue, and expenditure including capital, considering multiple element arrangements in recognizing relevant revenue and periodic forecasting, working on year-end close offs, and instituting accurate and robust processes

I helped the sales teams to bring “Increasing subscription renewals / decreasing churn" to the front burner of the team by bringing up those contracts that were coming up for renewal and also looking at what the clients need to enhance their operational abilities of the products they use. I guided the team ways of reducing turnover (churn) and increasing repeat subscription business and how critical it is for the success of the organization. I provided all the necessary analysis to achieve this goal.

CISCO SYSTEMS INC., (Contract through Insight Global), San Jose, CA, USA Sep 2012 – Dec 2012

Senior Financial Analyst, Supply Chain Network Design and Management Group

Completed Financial Planning and Analysis and produced financial models / metrics, which evaluated fulfillment options in Supply Chain Design and Management, reviewing different business models.

Instigated a template, determining company’s Weighted Average Cost of Capital, using it in discounted cash flows.

Analyzed financial data, improved processes, and recommended new Key Performance Indicators relevant to evaluating and controlling business unit performance portraying insights of product families’ performances.

Conducted cost analysis and prepared costing models taking into account of logistic costs, selecting optimal fulfillment partners.

CEREBIZ PVT LTD, Adelaide, Australia Aug 2010 – Sep 2012

Financial Consultant (contract, telecommute)

SAAS company. Introduced improved processes, appropriate costing methodology, and reporting framework. Achieved improved profitability.

Initiated Financial planning and Analysis, variance analysis, budgeting, and forecasting for operations, enabling company to produce meaningful financial reporting and control.

Advised management on impact of operational decisions on revenue and capital expense, and profitability, achieving optimal operational levels.

Setup financial reports and participated in implementation of process improvements, attaining better financial reporting and maximum economy and effectiveness in operations.

Analyzed market-survey data, establishing budgets, including competitors’ market share information and how performed in markets.

Designed and developed activity–based costing model, providing accurate costs of products and services.

At a time when strategic directions changed to concentrate on Renewals and Repeat Business in subscription and product sales, I developed improved sales process by looking at customer life cycle steps such as Reach, Acquisition, Conversion, Retention, Loyalty / Advocacy and determining what needs to be done at each of these steps. The outcome was having an advanced and comprehensive procedural document for the sales team. Then I introduced what needs to be done for renewal and repeat business in sales process making sales team understand the differences in new business sales vs repeat business process under these life cycle steps and taking advantage of these differences. Once they take those advantages the sales process yielded impressive results. It helped to Increase renewals and decrease churn.

Developed a set of key performance indicators (KPIs) specifically tracking and measuring across all steps of a customer lifecycle, which encouraged the sales team to achieve higher degree of confidence, satisfaction and accomplishments.

STANFORD UNIVERSITY, Stanford, Palo Alto, USA Jul 2007 – Jul 2010

Senior Financial Management Analyst

Performed annual budgeting, forecasting, financial analysis, and reporting. Accountable for design and implementation of improved processes and procedures where necessary.

Produced financial planning and analysis for short-term and long-term operations, bringing to light current levels of activities and strategically what resources were needed.

Introduced solid long-term forecasting process and reporting mechanism, improving transparency and accuracy.

Assembled annual budgeting, year-end close off, variance and trend analysis, reporting using Hyperion Planning System, which created smoother and accurate reporting.

Introduced streamlined process of completing budgets and variance analysis accurately and in faster manner, removing serious process errors and improving processes and results.

Downloaded and uploaded information using Business Objects from PeopleSoft, Hyperion Planning, and Oracle Financial Systems and prepared Departmental Reports, keeping departmental managers abreast of current situation.

Completed individual faculty salary reconciliation for 1st time, detecting process errors and short comings and improving processes, which eliminated management “fire drills” having to find additional funding for budget gaps.

Performed ad hoc financial analysis, reconciliations and reporting, contributing to being efficient and effective performer of finance team.

UNITED COMMERCIAL BANK, San Francisco, USA May 2007 – Jun 2007

Financial Consultant (contract)

Produced variance analysis reports and charts and graphs depicting insight of the projects and programs to the management.

Supported mortgage business by analyzing and identifying risks associated with new lending whether they have been adhered to prudent lending policies set by the bank. Brought to the attention of the management of financial risks associated with those landings that have not complied with those lending policies.

Developed a costing model, determining loan origination costs and completing complex reconciliations for auditors.

KANDYSOFT SOFTWARE CORPORATION, Adelaide, Australia Aug 2005 – Mar 2007

Software development and outsourcing company in Australia / New Zealand / Sri Lanka

Financial Adviser / Consultant (telecommute)

Implemented appropriate costing methodology. Worked towards obtaining required finances from lending institutions and improving strategic planning process.

Set up activity-based costing system, producing product and services costs accurately.

Restructured balance sheet with better debt-to-equity ratios, enabling obtaining additional finances.

Established consistent processes for financial planning, budgeting and forecasting on basis of expected growth.

Evaluated market survey data, preparing for setting up budgets and achieving solid base for budgeting.

HOUSING NEW ZEALAND CORP, Wellington, New Zealand Sep 1992 - Jun 2005

The provider of state mortgage and residential housing services after merging with Housing New Zealand Ltd in Jul 2001

Senior Financial / Investment Analyst Apr 2002 - Jun 2005

Developed a long term capital requirement model, presented to New Zealand Treasury and successfully obtained approval and necessary finance to meet the annual capital injections of $750 million per annum for initial five years

Prioritized investments. coordinated, managed projects by coordinating with all departments, external agencies and contractors acted as the person to go to in all matters relating to capital investment projects

Completed project feasibility studies, project costing and project evaluation models using ROI, NPV, IRR and payback methods, used “what if” scenarios in these models, identified risks associated with capital projects and advised on risk mitigating actions

Planed, prepared, and communicated schedules and progress reports of construction projects’ activities and expenditures, and assist others in establishing project schedules and milestones.

Prepared and uploaded project budgets into Hyperion Planning System and designed reporting system depicting budgets and actual accounting for capital projects

Acted as the principal capital investment liaison to all other operating units of the organization

Reporting Manager Jun 2000 – Mar 2002

Prepared Internal Reporting and annual published financial statements in compliance with the GAAP ensuring that the financial reporting obligations were met in a timely manner. Managed the external audit process and ensured the financial statements received unqualified audit opinion

Developed a financial reporting system to be uploaded into the New Zealand Treasury’s Government Consolidated Financial Information System complying with the Government Treasury requirements and regulations

Designed and successfully implemented home leasing accounting and reporting system to accommodate newly started home leasing program.

COMMUNITY HOUSING NEW ZEALAND LTD, Wellington, New Zealand

Finance Manager Aug 1996 – May 2000

Identified business and operational issues and implemented improved systems, procedures for internal controls and practices to maximize economy, efficiency and effectiveness while eliminating non-value-added functions

Designed and developed automated reporting solutions, which enabled business partners to manage the business more efficiently

Prepared and submitted periodic funding requests and applications to the New Zealand Treasury to obtain necessary funding within the approved limits and timings and monitor these funding to ensure that they were used in compliance with the terms specified

Developed, implemented and managed an improved budgetary control system using Hyperion system, which enabled financial planning, budgeting and forecasting to be accurate and efficient. It also enabled value added reporting mechanism

Centralised and managed the finance function after a merger including establishment of all operational resources. Had 8 staff under me. I trained ad performed periodic performance reviews and set up periodic team building sessions to keep up focus of the team on tasks in hand

Managed cash flow requirements for operational obligations whilst minimising the cost of debt funding

Documentation of systems and procedures and setup internal controls

Developed an automated accounting and reporting system in Oracle to meet Goods and Services Tax (GST)

Implemented the budgetary control system in Hyperion Planning, which improved budgeting and forecasting cycles and accuracy of them

Prepare and submit grant requests and applications and monitor and manage grant funds received for compliance with terms of grants.

Ensured a smooth month, quarter and year end close making all necessary accruals, adjustments and reconciliations were completed before closing off of ledgers

Management Accountant (Contract) Sep 1992 – Jul 1996

Help implementation of the Oracle Database and financials

Data collection, manipulation, reporting and providing management advise

Developed and implemented an improved budgetary control system, which enabled efficient budgeting and reporting. It also saved valuable staff time at critical month, quarter and year end times

Setup annual budgets and performed variance analysis and provided periodic forecasting to the Board

Designed and implemented a costing and reporting system, which enabled accurate internal and external reporting with financial and non-financial performance measures and took a leading role in setting up the Balance Score Card

Developed and published metrics that assist management of measurement of operational performance of their units

Designed, tested and implemented the annual property revaluation process in the property management system in Oracle Database

Completed month end close with all journal entries, reconciliation of accounts.

DEPARTMENT OF SCIENTIFIC AND INDUSTRIAL RESEARCH, Wellington, New Zealand Nov 1991 - Aug 1992

A state department, which under took scientific, research in all areas of Water and Atmosphere.

Project Accountant

Financial planning and analysis to achieve optimal use of financial resources

Preparation of annual capital and operating budgets

Provided financial advice and recommendations on project costs and variances to realign operations to meet set objectives

Established common overhead cost allocations to projects

Detected an error on payment of Goods and Services taxes, which has occurred over a period of time and presented to the Inland Revenue resulting a large tax refund to the division

D.N GOVAN & COMPANY LTD, Wellington, New Zealand Sep 1989 - Oct 1991

A Company involved in importing, wholesaling and retail, manufacture of foodstuff. Owned and managed a commercial and residential property portfolio.

Management Accountant

Prepared monthly management and financial analysis, cash flows, cost and profitability reports, break even analysis and product costs and pricing

Prepared Budgets and periodic sales and

Contact this candidate