Amit M. - Analytics and Pricing - Senior Project Manager and Team Leader

Go to Website

Courbevoie, France

Experience

Jan 2022 - Dec 2023

2 years

Paris, France

Head Data & Business Intelligence

Kritikal Solutions

Reported to the CEO and created a new BI function to lead the data-to-decisions business transformation mandate
Hired talent, built a 4-member team, served as 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 meetings to enable invoicing, people allocation, and 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 2020

2 years

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
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

Worked closely with the CMO to manage the launch of an equipment-insurance service; projected annual revenues of over $2 Mn
Drove the project’s agenda in an international and cross-functional setting with a team of 7 colleagues across Netherlands, Belgium, Norway and France
Pre-empted roadblocks and managed resource-plan changes in consultation 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 processes to reduce report generation time, coordinating data extraction from multiple sources and transforming it 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 the end of the contract
Tools: Power BI, SSAS, Excel (Power Query, PowerPivot), PowerPoint

Jan 2014 - Dec 2015

2 years

Paris, France

Consultant Pricing & Budgeting

Ouibus (now BlaBlaBus)

Prepared the annual budget used for setting commercial objectives by month and by route, using past performance and consultations with the client
Supported the Director Pricing in project and resource planning for the critical summer-holiday pricing round
Modeled price levels for 20+ buses/day on high-revenue routes during the high-volume summer season and recommended price adjustments for year-end holidays
Trained two junior consultants and allocated responsibilities to support the launch of domestic inter-city services
Created an Excel-based pricing tool to support the new pricing mechanism: extracted data from different sources, enabled price analysis, simulated forecast versus budget, and ensured 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 in Paris region, producing weekly and monthly reports for sales, reservations and revenue management activities
Prepared reports on KPI trends by hotel, by segment (MICE, Corporate, Leisure), by region, by channel and by customer, combining data from GDS, Opera Sales and Catering system and Group-Web sales

Jan 2013 - Dec 2014

2 years

France

Consultant Loyalty Analytics

IZICAP

Participated in creating a proof of concept to showcase to potential investors for securing next round of funding
Segmented merchants using analytics and generated benchmarks for performance and loyalty KPIs in each segment
Created a data management system to store over a million transactions using open-source MySQL and built SQL queries to create dashboards

Jan 2011 - Dec 2012

2 years

Paris, France

Senior Analyst Pricing Analytics

Revenue Management Solutions

Assisted the senior consultant in defining the annual pricing strategy for McDonald’s in a Scandinavian market
Recommended price moves for 30+ products in 100+ restaurants using price elasticity, store segmentation, channel differences, VAT hike impact, pricing policy and psychological pricing
Managed ad-hoc projects such as promotion analysis and SKU pricing, ensuring timely delivery of presentations
Tools: SQL Server, Excel, PowerPoint

Jan 2009 - Present

16 years 11 months

Paris, France

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 - Dec 2011

4 years

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 adopted by hotels, airlines, travel operators and car rentals
Modeled forecasts for tourist segments and sub-segments by type (inbound, outbound, domestic), by purpose (leisure, business), by transportation (air, sea, land) and by source country or destination

Jan 2006 - Dec 2007

2 years

New Delhi, India

Manager SAP BU Market Intelligence

HCL Technologies

Created a competitor benchmarking tool for the SAP business unit by leading a team of 2 analysts
Developed a bid evaluation tool for bid/no-bid decisions by quantifying influencers; the tool was subsequently used 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, including brand tracking surveys, website traffic analysis and campaign effectiveness studies