Recommended expert

Amit Mangotra

Predict outcomes of tennis matches and place bets

Amit Mangotra
Courbevoie, France

Experience

Jan 2023 - Apr 2023
4 months
Paris, France

Predict outcomes of tennis matches and place bets

Personal Project

  • Extracted and processed data using Power Query in Excel
  • Selected features, developed and evaluated models using Python and logistic regression
  • Used ChatGPT to write Python code; utilized numpy, pandas and scikit-learn libraries
Jan 2022 - Dec 2022
1 year
Paris, France

Head Data & Business Intelligence

KRITIKAL SOLUTIONS

  • Reporting to the CEO, created a new BI function to lead the data‐to‐decisions business transformation mandate of the CEO
  • Hired talent, built a 4‐member team, played the role of a mentor, and carried out performance reviews
  • Delivered a project every 4-8 weeks; prioritized projects in consultation with different functions; built dashboards for HR, Technology, Finance and Sales for monthly leadership meet and to enable invoicing, people allocation, cost allocation
  • Focused on automating dashboards to derive efficiency gains; developed data management guidelines and conducted change management workshops to ensure data quality
  • Selected Looker as the data visualization tool and created the first commercial dashboards permitting drill down
  • Tools: Looker, Google Sheets, Google Script, MySQL
Jan 2019 - Dec 2019
1 year
Paris, France

Consultant Power BI

ODEALIM

  • Worked with the CFO to migrate from Excel to Power BI Pro reporting solution for tracking sales and operational KPIs
  • Captured business requirements and planned the creation of different reports in consultation with client
  • Integrated data from different sources by extracting and transforming using Power Query and M, conducted data quality checks, created anomaly reports and built data models
  • Conducted change management workshops, created PowerPoint documentation, and shared best practices
  • Tools: Power BI Desktop & Service, Oracle database, Excel, PowerPoint
Jan 2018 - Jun 2018
6 months
Paris, France

Project Manager New Service Development & Launch

MARLINK

  • Managed launch of equipment‐insurance service in collaboration with the CMO; projected annual revenues of over $2 Mn
  • Drove the project’s agenda in an international and cross‐functional setting with a team of 7 across Netherlands, Belgium, Norway and France
  • Pre‐empted roadblocks and managed resource‐plan changes with the project steering committee
  • Delivered business case, pricing, segmentation, competitor benchmarking, sales kit, contract and service‐delivery process
Jan 2017 - Jun 2017
6 months
Paris, France

Senior Analyst Commercial Intelligence (CI)

MARLINK

  • Reported to the Director Pricing & CI; in charge of commercial performance reporting for the Management Committee
  • Automated reports and redesigned process to reduce report generation time: coordinated data extraction from multiple sources and transformed data using Power Query to create Excel dashboards
  • Created a gap analysis document for improving data quality in the data pipeline
  • Ensured knowledge transfer and process documentation at end of contract
  • Tools: Power BI, SSAS, Excel (Power Query, PowerPivot), PowerPoint
Jan 2014 - Jan 2015
1 year 1 month
Paris, France

Consultant Pricing & Budgeting

OUIBUS (now BlaBlaBus)

  • Prepared the annual budget used for setting commercial objectives by month and by route; built an adaptable model using past performance and consultations
  • Supported the Director Pricing in project and resource planning for the critical summer‐holiday pricing round
  • Modeled price levels for 20+ buses/day on highest revenue generating routes; recommended price adjustments for peak seasons
  • Trained two junior consultants and allocated responsibilities to support the launch of domestic inter-city services
  • Created an Excel‐based pricing tool to extract data, enable price analysis, simulate forecast versus budget, and ensure compliance with pricing policy
  • Tools: Excel, QlikView, PowerPoint
Jan 2014 - May 2014
5 months
Paris, France

Business Analyst Sales & Revenue Reporting for Pullman Hotels

ACCOR

  • Reported to the Director Sales & Reservations for 5 Pullman Hotels; produced weekly and monthly reports for sales, reservations and revenue management
  • Prepared reports on KPI trends by hotel, segment (MICE, Corporate, Leisure), region, channel and customer by combining data from GDS, Opera Sales and Catering, and Group‐Web sales
Jan 2013 - Feb 2013
2 months
France

Consultant Loyalty Analytics

IZICAP

  • Participated in creating a proof‐of-concept to showcase to potential investors
  • Segmented merchants using analytics and generated benchmarks for performance and loyalty KPIs
  • Created a data management system to store million+ transactions using MySQL and built SQL queries to create dashboards
Jan 2011 - Aug 2011
8 months
Paris, France

Senior Analyst Pricing Analytics

REVENUE MANAGEMENT SOLUTIONS

  • Assisted in defining the annual pricing strategy for McDonald’s in a Scandinavian country-market
  • Recommended price moves for 30+ products in 100+ restaurants using price elasticity, store segmentation, channel differences, VAT impact, and psychological pricing
  • Managed ad‐hoc projects such as promotion analysis and SKUs pricing; ensured timely delivery of presentations
  • Tools: SQL Server, Excel, PowerPoint
Jan 2009 - Present
17 years 2 months

Founder & Independent Consultant

GRIDEASY

  • Win consulting projects through a multi-channel approach: networking, job‐boards, partnerships, repeat business with clients
  • Continuously upgrade skills and generate consulting revenues by developing multiple data services: AI, BI, Analytics & Pricing
  • Build a business‐support structure: register business, choose website builder subscription, create website, branding via LinkedIn video posts; deal with complex issues such as contractual litigation by hiring legal experts
Jan 2008 - Feb 2009
1 year 2 months
Paris, France

Freelance Analyst Market Research & Reports Travel & Tourism

EUROMONITOR

  • Prepared 15+ country reports and databases on the tourism sector via interviews and secondary research
  • Identified key economic and policy drivers for tourism and their impact on strategies of hotels, airlines, travel operators and car rentals
  • Modeled forecasts for tourist segments by type, purpose, transportation and source/destination using historical data and trends
Jan 2006 - Dec 2007
2 years
New Delhi, India

Manager SAP BU Market Intelligence

HCL TECHNOLOGIES

  • Led a team of 2 analysts to create a competitor benchmarking tool for the SAP business unit
  • Developed a bid evaluation tool for bid/no‐bid decisions by quantifying influencers; the tool was adopted by other business units
Jan 2003 - Dec 2006
4 years
New Delhi, India

Business Analyst and Assistant Manager Corporate Branding

HCL TECHNOLOGIES

  • Reported to the Vice‐President to help set up a corporate function unifying all brands under an umbrella brand
  • Worked with partners to develop brand positioning, guidelines, campaigns, media plans and allocate a €1 Mn media budget
  • Developed processes for monitoring brand health: brand tracking surveys, website traffic analysis, and campaign effectiveness studies

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Information Technology (22 years), Professional Services (17 years), Tourism (2 years), Telecommunication (1 year), Sport (0.5 years), and Food and Beverage (0.5 years).

Information Technology
Professional Services
Tourism
Telecommunication
Sport
Food and Beverage

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Business Intelligence (22 years), Marketing (21 years), Information Technology (17 years), Research and Development (1.5 years), Finance (1 year), and Product Development (0.5 years).

Business Intelligence
Marketing
Information Technology
Research and Development
Finance
Product Development

Summary

Track record of achieving project results working in cross functional teams, in international settings, and across hierarchy

Unique dual skillset that allows an appreciation of business as well as supporting data technology

Languages

English
Advanced
French
Advanced

Education

Oct 2001 - Jun 2003

Indian Institute of Management (IIM) Calcutta

MBA · Marketing & Information Systems Management · Kolkata, India

Oct 1997 - Jun 2001

Indian Institute of Technology (IIT) Delhi

Bachelor of Technology · Industrial Engineering · New Delhi, India

Certifications & licenses

No Code AI & Machine Learning: Building Data Science Solutions

MIT Professional Education

Executive Education Online Certification – Digital Marketing Analytics

MIT Sloan School Of Management

Executive Education Online Certification – Using Data To Improve Pricing Performance

MIT Sloan School Of Management

Executive Education Online Certification – Business Analytics: From Data To Insights

The Wharton School

BI (ETL, DW Modelling And Reporting)

CNAM Paris

Predictive Modelling Using SAS Enterprise Guide And SAS Enterprise Miner

SAS Education

SQL For Databases

CNAM Paris

Profile

Created
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Amit based?

Amit is based in Courbevoie, France.

What languages does Amit speak?

Amit speaks the following languages: English (Advanced), French (Advanced).

How many years of experience does Amit have?

Amit has at least 23 years of experience. During this time, Amit has worked in at least 13 different roles and for 11 different companies. The average length of individual experience is 2 years and 9 months. Note that Amit may not have shared all experience and actually has more experience.

What roles would Amit be best suited for?

Based on recent experience, Amit would be well-suited for roles such as: Predict outcomes of tennis matches and place bets, Head Data & Business Intelligence, Consultant Power BI.

What is Amit's latest experience?

Amit's most recent position is Predict outcomes of tennis matches and place bets at Personal Project.

What companies has Amit worked for in recent years?

In recent years, Amit has worked for Personal Project, KRITIKAL SOLUTIONS, and GRIDEASY.

Which industries is Amit most experienced in?

Amit is most experienced in industries like Information Technology (IT), Professional Services, and Tourism and Hospitality. Amit also has some experience in Telecommunication, Food and Beverage, and Sport and Recreation.

Which business areas is Amit most experienced in?

Amit is most experienced in business areas like Business Intelligence, Marketing, and Information Technology (IT). Amit also has some experience in Research and Development (R&D), Finance, and Strategy and Planning.

Which industries has Amit worked in recently?

Amit has recently worked in industries like Information Technology (IT), Professional Services, and Sport and Recreation.

Which business areas has Amit worked in recently?

Amit has recently worked in business areas like Information Technology (IT), Business Intelligence, and Marketing.

What is Amit's education?

Amit holds a Master in Marketing & Information Systems Management from Indian Institute of Management (IIM) Calcutta and a Bachelor in Industrial Engineering from Indian Institute of Technology (IIT) Delhi.

Does Amit have any certificates?

Amit has 7 certificates. Among them, these include: No Code AI & Machine Learning: Building Data Science Solutions, Executive Education Online Certification – Digital Marketing Analytics, and Executive Education Online Certification – Using Data To Improve Pricing Performance.

What is the availability of Amit?

Amit is immediately available for suitable projects.

What is the rate of Amit?

Amit's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Amit?

To hire Amit, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1000
750
500
250
Market avg: 700-860 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.