Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Skillshighlights
Corecompetencies
Work Availability
Work Preference
Languages
Software
Quote
Interests
Affiliations
Websites
Timeline
Hi, I’m

Prem Bhatt

Revenue Analyst
Prem Bhatt

Summary

Results-driven finance analyst with over 7+ years of experience in financial planning, data analysis, and risk management. Proven ability to build economic models, enhance capital efficiency, and provide actionable insights that assist in strategic decision-making. Experienced in managing various financial operations, ensuring compliance with regulations, and implementing operational efficiency improvements. Proficient in using advanced analytical tools and techniques to develop solutions that provide significant value and consistently deliver positive results.

Overview

11
years of professional experience
7
years of post-secondary education
1
Certification
3
Languages

Work History

Capita Plc
Leeds, West Yorkshire

Revenue Analyst
01.2024 - Current

Job overview

  • Accountable for opening accounts, applying reliefs, discounts, and exemptions, and starting recovery proceedings as needed in compliance with council tax rules and regulations
  • Enhanced the precision of revenue forecasting by 15%, which eased an increase in Council Tax revenue from £131.179 million in 2023/24 to £166.040 million in 2024/25
  • Conducted systematic reviews tracking monthly variations related specifically towards residential property classifications revealing pivotal insights into maintaining satisfactory forecast cycles amid fluctuating economic conditions
  • Aided in strategic decision-making by tracking Business Rates Income, which grew from £47.221 million to £49.968 million
  • Achieved a 95% accuracy rate in financial forecasts, thereby improving budgeting and resource allocation processes
  • Streamlined reporting processes through automation, resulting in a 25% reduction in time spent using Excel, SQL, and Power BI
  • Discovered opportunities for revenue growth, leading to enhanced financial performance
  • Collaborated with cross-functional teams to develop comprehensive sales plans aligned with company goals and objectives.
  • Maintained strong relationships with customers through effective communication and prompt resolution of issues related to invoicing or payment disputes.

Capita Plc
Leeds, West Yorkshire

Sales Data Analyst – Financial Services
05.2023 - 01.2024

Job overview

  • Company Overview: BBC - TV Licensing
  • Created customized financial strategies for clients that aligned with their goals, resulting in a 5% increase in license fee revenue, reaching £3.66 billion for the 2023/24 period
  • Achieved a 95% client satisfaction rate, exceeding industry standards, and upheld high retention levels, demonstrating the BBC's dedication to exceptional service
  • Delivered financial solutions to more than 100 clients, fostering business growth and sustaining 23.9 million active licenses as of March 2024
  • Addressed client inquiries efficiently, maintaining a 95% satisfaction rate and adhering to BBC customer service excellence
  • Developed strategic financial plans that resonated with clients' objectives, ensuring sustainable success and bolstering the BBC's financial health
  • BBC - TV Licensing

Wincanton logistics
Leeds, West Yorkshire, UK

Supply Chain Analyst
07.2022 - 04.2023

Job overview

  • Enhanced operational efficiency by 15% through the analysis of weekly supply chain data and conducting stock audits
  • Oversaw and recorded over 50 deliveries each week, achieving a 98% accuracy rate while managing an inventory exceeding 10,000 items
  • Coordinated logistics and provided support to a project team of 20 members, facilitating smooth collaboration and execution of tasks
  • Developed reports, monitored progress, and tracked project expenditures up to £500,000, ensuring adherence to budgetary constraints
  • Cultivated strong partnerships with more than 15 subcontractors to guarantee timely deliveries and successful project outcomes
  • Reduced lead time for product deliveries through effective coordination with suppliers and vendors.
  • Assisted in the development of annual budgets for supply chain operations, contributing to overall financial planning efforts.

S&P Global
Ahmedabad, Gujarat, IND

Finance Data Analyst
08.2017 - 03.2021

Job overview

  • Developed over 20 financial models, enhancing forecast precision by 15% and facilitating informed strategic decisions
  • Discovered growth prospects through comprehensive market analysis, resulting in a 10% increase in portfolio returns
  • Reduced market, credit, and liquidity risks, leading to a 12% decrease in overall financial exposure
  • Produced financial reports and presentations that improved stakeholder engagement by 20%
  • Achieved a forecasting accuracy rate of 95%, which supported effective resource allocation and budgeting
  • Enhanced capital efficiency by 25% through strategic guidance on investment and allocation
  • Provided actionable insights that reinforced decision-making and the execution of strategies
  • Optimized processes to address challenges, thereby increasing operational efficiency by 20%
  • Integrated data from 15 databases and 30 spreadsheets, allowing for thorough analyses
  • Utilized Excel, SQL, Python, and R to advance analytics and boost decision-making accuracy by 25%
  • Created over 50 data visualizations, which improved stakeholder clarity and engagement by 30%
  • Performed statistical experiments that yielded insights, enhancing project outcomes by 15%

IBI Global Research Solutions
Ahmedabad, Gujarat,IND

Data Research Analyst Intern
07.2014 - 12.2014

Job overview

  • Developed research methodologies, defined objectives, ensuring 95% success in meeting goals for 10+ major projects
  • Analyzed 50+ market reports, identifying trends and contributing to a 20% increase in market share
  • Conducted in-depth market analyses, increasing client market share by 20% through actionable insights
  • Guided strategic planning and product development, achieving a 10% ROI improvement
  • Evaluated market shifts, driving a 15% enhancement in business performance
  • Collaborated with cross-functional teams to develop data-driven solutions for complex business challenges.
  • Utilized advanced statistical techniques to analyze large volumes of structured and unstructured data.
  • Optimized data-driven decision making for the team by generating insightful reports on key performance indicators.

Education

Leeds Beckett University

Master Of Science from Business Accountancy
May.2021 - Jun.2022 (1 education.year_Label & 1 education.month_Label)

University Overview

Gujarat Technological University

Master of Business Administration from Finance Management
01.2015 - 07.2017

University Overview

Gujarat University
Ahmedabad,IND

Bachelor of Commerce from Foundation : Accounting, Taxation And Economics
01.2011 - 05.2014

University Overview

Skills

Power BI

undefined

Certification

Project Finance Certified, Ahmedabad Management Association (A.M.A), India, 07/01/14, 12/31/14, Entitled ACCA qualification exemptions: FBT - Business and Technology. Entitled CIMA qualification exemptions: CGMA Finance Leadership Program (Level 4) & CIMA's Apprenticeships (Level 5)

Accomplishments

Accomplishments
  • Awarded the Exceptional Achiever Award at S&P Global (2018) for achieving 100% quality level and 105% productivity, while actively contributing to projects that improved business operations and enhanced client service.
  • Quarter Winner Award from IBI Global Research Solutions (2015) for outstanding performance and contributions to key projects.
  • Volunteered at St. Chands Church and Black Ship Scouts, Leeds, UK (09/01/21 - 04/30/22), contributing to community outreach and organizational activities.

Skillshighlights

Skillshighlights
  • Financial Products/Solutions
  • Business Planning and Management
  • Budget Development and Analysis
  • Mergers & Acquisitions (M&A)
  • Lead Generation & Cross-Selling
  • Financial Planning/Investment Solutions
  • Complexity and Judgment
  • Customer Service Excellence
  • Effective Decision-Making
  • Team Supervision & Leadership
  • Analytical & Problem-Solving
  • Purchasing, Finances, and Payments
  • Risks Analysis and Management
  • Revenue Growth & Networking
  • Financial Analysis and Reporting

Corecompetencies

Corecompetencies
Advanced Excel (Pivot Tables, Macros), Power BI, Tableau, SQL, SAP/Oracle Financials, Hyperion/TM1, QuickBooks/Xero, Python/R, Alteryx, Data Analytics, Attention to Detail, Problem-Solving, Communication, Collaboration, Adaptability, Strategic Thinking
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Work Preference

Work Type

Full Time

Work Location

RemoteHybrid

Important To Me

Work-life balanceWork from home optionPersonal development programsCareer advancementTeam Building / Company RetreatsCompany CultureStock Options / Equity / Profit SharingHealthcare benefitsFlexible work hoursPaid time off401k match4-day work week

Languages

English
Advanced (C1)
Hindi
Advanced (C1)
Gujarati
Advanced (C1)

Software

SQL

Advanced Excel

Tableau

Python

R

Microsoft Office

Cognos

C

Java

Abby 140

Quickbooks

Xero

SAS Programming

Quote

Dream Larger, Live Larger ♠

Interests

Rowing

Mount Climbing

Lacrosse

Horse Riding

Clubing

Movies

Music

History

Geo Politics

Journal reading

Affiliations

Affiliations
  • Ahmedabad Management Association (AMA) – Certification in Project Finance (2014).
  • Association of Chartered Certified Accountants (ACCA) – Qualification Exemptions in Business & Technology (2022).
  • Chartered Institute of Management Accountants (CIMA) – Qualification Exemptions in Level 4 & 5 (2022).
  • St. Chands Church & Black Ship Scouts, Leeds – Volunteering for community outreach programs.

Websites

Timeline

Revenue Analyst
Capita Plc
01.2024 - Current
Sales Data Analyst – Financial Services
Capita Plc
05.2023 - 01.2024
Supply Chain Analyst
Wincanton logistics
07.2022 - 04.2023
Leeds Beckett University
Master Of Science from Business Accountancy
May.2021 - Jun.2022 (1 education.year_Label & 1 education.month_Label)
Finance Data Analyst
S&P Global
08.2017 - 03.2021
Gujarat Technological University
Master of Business Administration from Finance Management
01.2015 - 07.2017
Data Research Analyst Intern
IBI Global Research Solutions
07.2014 - 12.2014
Gujarat University
Bachelor of Commerce from Foundation : Accounting, Taxation And Economics
01.2011 - 05.2014

Similar Profiles

CREATE PROFILE
Prem BhattRevenue Analyst