Amit Mangotra
Predict outcomes of tennis matches and place bets
Experience
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
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
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
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
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
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
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
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
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
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
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
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
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).
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).
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
Education
Indian Institute of Management (IIM) Calcutta
MBA · Marketing & Information Systems Management · Kolkata, India
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
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Amit based?
What languages does Amit speak?
How many years of experience does Amit have?
What roles would Amit be best suited for?
What is Amit's latest experience?
What companies has Amit worked for in recent years?
Which industries is Amit most experienced in?
Which business areas is Amit most experienced in?
Which industries has Amit worked in recently?
Which business areas has Amit worked in recently?
What is Amit's education?
Does Amit have any certificates?
What is the availability of Amit?
What is the rate of Amit?
How to hire Amit?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Predict outcomes of tennis matches and place bets
Nearby freelancers
Professionals working in or nearby Courbevoie, France