Summary
Overview
Work History
Education
Skills
Timeline
MOHITH PAUL KOSHY

MOHITH PAUL KOSHY

Melbourne,VIC

Summary

Results-driven Business Intelligence Analyst with a proven track record in developing actionable insights through advanced data analysis, dynamic Power BI reporting, and strategic dashboard creation. Skilled in optimizing business processes, enhancing KPI monitoring, and driving data-informed decisions that improve performance metrics and maximize profitability. Passionate about leveraging data to empower stakeholders, improve operational efficiency, and achieve organizational objectives. Seeking to contribute expertise in business intelligence, trend analysis, and financial reporting to a dynamic and growth-focused organization.

Overview

11
11
years of professional experience

Work History

Business Intelligence Analyst

1Bill Holdings (formerly Compare & Connect)
03.2023 - Current
  • Designed, published, and maintained dynamic Power BI reports for the executive team, enabling real-time monitoring of business KPIs
  • Consolidated and analyzed large datasets to create visually compelling and data-driven insights, supporting the CEO and CFO in developing an investor pack that played a pivotal role in the successful sale of the business to Origin Energy.
  • Compiled the Business Performance Review (BPR) pack, summarizing critical business metrics and performance insights
  • Maintained and ran the estimated P&L statement up to the Gross Profit (GP) line, ensuring accurate financial forecasting and budgeting each month
  • Reconciled sales data, monitored cancellations, and implemented measures to ensure low cancellation rates
  • Ensured accurate partner payments by maintaining high standards of data reconciliation and compliance
  • Calculated and validated commission payouts for internal staff, ensuring accuracy and timely processing
  • Developed conversion-focused dashboards to track individual agent performance, facilitating a business model shift from volume-based to conversion-based strategies
  • Created targeted dashboards to monitor broadband attachment rates, leading to an increase from30-31% to45% through strategic insights and interventions
  • Business Insights - Analyzed real estate agency lead data, evaluating lead quality, conversion rates, and key performance parameters to optimize lead management and sales outcomes
  • Conducted detailed sales analysis to identify customer demographics with higher conversion rates and higher cancellation propensity, informing targeted strategies

Data Analyst

Compare & Connect
01.2021 - 03.2023
  • Responsible for undertaking data cleaning, identifying sources of data and hosting it in readily accessible centralized network
  • Analyzing the performance and trends of suppliers and customers using historical, time-trend designs and statistical techniques
  • Projecting financials of the organization like sales, costs, revenue and profit and loss
  • Creating and maintaining databases using statistical packages and tools such as PowerBI and Excel
  • Provides statistical findings and results to the Chief Financial Officer on ad-hoc reporting, forecasts, and process improvements using summaries charts, tables, and graphs

Sales Consultant

Compare And Connect Pty Ltd
10.2017 - 06.2022
  • Met activity targets which include sales, customer service, compliance
  • Consistently highest cross-sell ratio helping the business understand potential on cross- sell
  • Worked across different campaigns thus getting a broader outlook towards the business

Data Scientist (Intern)

Coles
07.2018 - 12.2018
  • Used machine learning algorithms to segment customers based on category
  • Created a clustering model using hierarchical and k-means clustering integrating demographic factors and consumption trends
  • Helped in running marketing campaigns and other promotions to a target audience established by clustering techniques
  • Tools worked on SQL, R, Tableau and Excel

Business Analyst

Ugam Solutions
06.2015 - 06.2017
  • Part of the team leveraging Ugam’s proprietary Assortment Intelligence solution to solve assortment optimization related problems of retailers (online as well as brick and mortar)
  • Have been a key member of the team contributing towards solution development, implementation and delivery
  • Primarily engaged in understanding the assortment related problems of retailers and helping them solve it leveraging available data such product information, consumer demand signals, etc
  • Have worked on statistical models providing key guidance to our clients with respect to future planning
  • Proficient in data mining and crunching large unstructured data sets to derive meaningful insights and provide recommendations to client accordingly
  • Led a project with one of the specialty retailers in the electronics space and help the retailer in building consumer focused assortment in categories wherein the retailer hardly any presence
  • Have worked across different teams to get understanding of the other aspects of the value chain where the focus is to drive retailers top line as well as bottom line
  • Hands on experience with respect to SEO and content development projects
  • Responsible for documentation and implementation of the SOP for the solution and provide on job training to fresh recruits in the team
  • Have contributed towards business proposals and other pre-sales activities

Risk Analyst

Amazon
06.2014 - 05.2015
  • Part of TRMS department at Amazon, which is entrusted with the responsibility of making Amazon.com one of the safest portals for online transactions
  • Worked in the domain of Anti Money Laundering Operations and did KYC, customer verification and screening of all fraudulent activity
  • Job profile involved screening buyer and seller profiles and ensuring their authenticity before any transaction on Amazon.com is done
  • Primarily involved in implementation of the process aimed at screening buyers and sellers, using explicit guidelines and by interacting with various financial institutions and law enforcement agencies
  • Also responsible for analyzing a profile and then taking key decisions based on the research, findings and process knowledge
  • Dealt with different stake holders within and outside the organization
  • Was part of the screening process for new hires and made key contributions to the overall SOP
  • Involved in day-to-day planning and scheduling of tasks, developing and implementing training programs for the new recruits
  • Have been cross-trained on multiple processes and have worked with different teams within TRMS department to analyze different investigations and buyer/seller profiles
  • Have consistently been in the top three performers within a team of60 people and maintained a high IPH (Investigations per Hour), three times more than the rest of my team

Education

Master's degree - Data Analytics

RMIT University, Melbourne, VIC
12.2019
  • Relevant courses
  • Database Concepts
  • Multivariate Analysis Techniques
  • Data Visualization
  • Regression
  • Analysis Machine Learning
  • Quantitative Methods in Finance
  • Applied Bayesian Statistics

Bachelor of Arts - BA - Economics

Christ University
12.2014

Skills

  • SQL
  • Microsoft Power BI / Tableau
  • Microsoft Excel
  • R
  • SAS
  • Data visualization
  • Big data analytics
  • Business intelligence analysis

Timeline

Business Intelligence Analyst - 1Bill Holdings (formerly Compare & Connect)
03.2023 - Current
Data Analyst - Compare & Connect
01.2021 - 03.2023
Data Scientist (Intern) - Coles
07.2018 - 12.2018
Sales Consultant - Compare And Connect Pty Ltd
10.2017 - 06.2022
Business Analyst - Ugam Solutions
06.2015 - 06.2017
Risk Analyst - Amazon
06.2014 - 05.2015
RMIT University - Master's degree, Data Analytics
Christ University - Bachelor of Arts - BA, Economics
MOHITH PAUL KOSHY