Financial Analyst Data

Akhil Nandakumar

Email: *************@*****.***

Phone: 416-***-****

Career Summary

Strategy analyst with 3+ years of experience in professional services in the area of market research, strategy analysis, business consulting, solution implementation, data analytics and project management

Core Competencies

Management consulting: Corporate strategy development, market research and forecasting, process improvement, competitor intelligence, feasibility studies and business performance enhancement

Excel: Lookup functions, matching functions, pivot tables, formulas, conditional formatting and plugins (CapIQ, Fuzzy-lookup and Think-cell)

Tableau, Power BI & MS PowerPoint: Data visualization and reporting through data dashboards

Database creation and management: SQL and MS Access

Technical/ Computer Science Knowledge: Exploratory data analysis, data mining and model development using Python & R Programming

Project management: PRINCE2 practitioner certified

Analytical thinking and problem solving coupled with good communication and reporting skills

Professional Experience

Project Management Financial Data Analyst (Contract) Dec 2019 - Present

Metrolinx – Toronto, Canada

Working with the project management office to design and run internal controls on project cost and contract invoices for various TTC projects under Metrolinx

Designed templates for running internal controls on cost of resources, tracking time charged on projects and comparing them with vendor invoices for documentation

Designed templates for comparing ERP financial reports with PMO internal controls for each project under Assetlinx program

Updating resource allocation for each project according to FY budgets and project milestones

Assisting project manager in creating and updating total financial forecast and accruals for a major project under Assetlinx program and ensuring that the project always stays under the final budget cap

Strategy Analyst (Fulltime) Mar 2018 – Jun 2019

Deloitte – Hyderabad, India

Part of global strategy team, working with internal business partners in framing internal strategy across different sectors and regions

Key Projects:

Accountable for preparing and maintaining global competitive database via tracking competitors for each business/ service lines and delivering performance dashboards depicting competitor revenue and growth rate comparisons for individual service lines (Tech consulting, Audit, Tax, Overall Advisory) along with M&A and Alliances update

oCreated tableau dashboards for competitive landscape highlighting performance

Designed and delivered revenue projection models for consulting & audit business, analyzing the viability of current Multi-Disciplinary Operating Model in the context of audit independence restrictions

Conducted market research for para-legal services by analyzing legal & regulatory environments, government policies & standards and competitor activities for executive member firms in their respective markets including US, China, Canada, South Korea, India, Japan, Germany and UK

Assisted CEO’s PMO office in collecting and analyzing financial data for selected member firms and collaborating with designated strategy consultants for creating member firm consolidation case studies for the executive management

Performance Improvement Consultant (Fulltime) Apr 2016 – Mar 2018

Ernst & Young – Kerala, India

Working with EY performance advisory units in MENA region (Middle East and North Africa), on client engagements in the area of market research, operational efficiencies and process improvements

Key Projects:

Delivered a consumer experience benchmarking exercise for a major government utility authority in GCC through root cause investigations and recommend processes to revamp their customer service operations

Delivered market research and business entry feasibility study for a major aviation catering company operating out of middle east

oFramed recommendations on key business decisions for brand development

Enhanced the organization structure of a major government regulation authority in GCC and created a competency matrix for various job roles across different departments to maximize operational efficiency

oCreated a competency dictionary in spreadsheet which can be used by the hiring team as a reference for job requirements in more than 150 job titles (according to hierarchy) across all departments in the firm

Developed performance dashboards in Tableau for the IT risk management partner of GCC, extracting data from the project management excel sheet and reporting results in the area of pursuit wins and project completions

Led pursuit teams in the area of IT risk management and participated in lead aspects of proposal development, pricing and negotiation process under tight deadlines with a conversion rate of more than 65 % for the MENA IT risk mitigation team

Recent Education & Certifications

Certificate in Big Data Analytics (enrolled, Part-time) Sep 2019 – Mar 2020

York University of Continuing Studies – Toronto, Canada

Project:

Melbourne real estate price estimation using logistic regression model

Predicting customer subscription based on telemarketing campaign for a banking institution using decision tree algorithm

Airbnb price bucketing for customers in New York using K-Means Algorithm and Clustering Algorithm

oTools used – Python, R, SQL and MS Excel

Post Graduate Diploma in Management Jul 2014 - Apr 2016

Accredited equal to Canadian master degree by WES

Rajagiri Business School – Kerala, India

Internship: Business analyst at Ernst & young

Assisting EY knowledge economics sector team in creating thought leadership papers

Contact this candidate