Anup Mistry

Anup Mistry

Mentor
5.0
(41 reviews)
US$15.00
For every 15 mins
101
Sessions/Jobs
View Video
ABOUT ME
Analytics Expert | SQL - Python - Excel - Power BI | 9 years exp.
Analytics Expert | SQL - Python - Excel - Power BI | 9 years exp.

For prospective mentees / freelance clients:

Transparent project quotations and plans - Regular project status updates - Will work to tight timelines - Discounts available for longer term projects

I specialise in:

  • SQL
  • Python
  • Excel / Power Query
  • Power BI / Tableau
  • VBA
  • Building trading algorithms and back-testing models

I aim to scope your problem quickly and efficiently, come up with a plan, and then work together to help you achieve your goal. I am patient, understanding and have a level of responsibility to ensure you are learning well and receiving value for money. I understand when there is time pressure and am willing to work with you to meet tight deadlines.

For freelance jobs and long term mentoring, intro calls are free (allowing you to assess the suitability of a partnership). Discounts are offered for longer term agreements of 1 week or more.

I am open to helping you with: 1:1 support, freelance jobs, code review, and long-term mentoring.

For prospective employers:

Data analytics consultant delivering expert analysis and visualisation to help businesses make improved data-driven decisions. Over nine years of experience, including 7 years in consulting and 2 years in commercial insurance. Seeking an opportunity to use my technical knowledge and people skills to create effective analytics solutions.

  • Project management and cost scoping

  • People management

  • Mentoring

  • Process optimisation

  • A/B testing

  • AI application to data models

  • Analysis automation

  • API integration

  • Data ETL

  • Data visualization

Spanish, English
London (+01:00)
Joined April 2023
EXPERTISE
8 years experience | 4 endorsements
9 years experience | 3 endorsements

REVIEWS FROM CLIENTS

5.0
(41 reviews)
Peace Okoye
Peace Okoye
March 2024
He was very knowledgeable about the subject matter.
Neel Sandell
Neel Sandell
March 2024
helped me quickstart tableau viz
Shreedhar
Shreedhar
February 2024
An exceptional mentor! Anup's guidance is invaluable. Highly recommend seeking his help for anyone looking to excel in their endeavors
Shreedhar
Shreedhar
February 2024
Understanding and helpful
Lee Wilson
Lee Wilson
February 2024
He was a tremendous help! He knew it extremely well!
Rishi sharma
Rishi sharma
February 2024
Anup , was very intelligent, communicative, and easy to work with. I appreciate you.
Julius Bzozowski
Julius Bzozowski
January 2024
Anup does a great job! Thank you!
Christian Sidwell
Christian Sidwell
December 2023
Fantastic communication, very knowledgeable and all-round nice person! 10/10
Raymond L Quesada
Raymond L Quesada
October 2023
Thank you for your instruction very helpful
Christy Orozco
Christy Orozco
October 2023
I want to give a big shout-out to Anup for his invaluable assistance in creating an Excel tracker. His expertise was instrumental, and I gained valuable knowledge in the process. Anup played a crucial role in developing a clean and impactful spreadsheet. Thank you, Anup!
SOCIAL PRESENCE
GitHub
anupmistry123
Config files for my GitHub profile.
0
0
procurement_analysis_tool
Visual Basic .NET
0
0
EMPLOYMENTS
Data Analytics Consultant
Self-Employed (various clients)
2022-06-01-Present
Successfully completed data analysis projects for clients such as US hedge funds, tech start-ups and multinationals. Project highlights: ...
Successfully completed data analysis projects for clients such as US hedge funds, tech start-ups and multinationals. Project highlights: -- Global Return Asset Management (current client) -- • Reputable New York based hedge fund managing assets using a variety of risk-based strategies. • Built and currently maintain an algorithm in Python that evaluates past portfolio performance, to optimise future strategies. The analysis is then used by the fund manager to implement strategy adjustments. -- RSA Insurance -- • Delivered a set of Tableau dashboards that track the performance of over 100 car repair garages across Canada. • Trained staff to use the dashboards effectively through tailored training programmes and workshops. • The analysis allows them to optimise processing times and explore ways to reduce costs. -- CentroMotion -- • A leading US hydraulics / brakes manufacturing company. I worked with their procurement team to analyse the cost-savings and potential benefit of switching the supplier base from the US to low-cost countries. • Used SQL and Python, with results presented in Tableau and Excel, producing an estimated 25% saving of parts and raw materials costs. -- Independent financial traders -- • Worked with experienced traders (10+ years exp.) to develop automated trading algorithms, including high frequency trading strategies for FX and US futures contracts. • This involves creating back-testing models, iterative testing, and reconciliation. • Tools used include Python, SQL, Excel and MQL5 (a trading algorithm language similar to C++).
Python
SQL
Excel
View more
Python
SQL
Excel
VBA
Tableau
Power Query
Microsoft Power BI
View more
Data Analytics Team Manager
Efficio Consulting
2021-07-01-2022-05-01
• Was responsible for a five-person team that delivered Efficio analytics products to internal and external clients. • Worked within many...
• Was responsible for a five-person team that delivered Efficio analytics products to internal and external clients. • Worked within many sectors including energy / utilities, manufacturing, financial services and public healthcare. • Expanded service offerings by rapidly growing the cross-functional team from one to five members within six months. • Enhanced customer satisfaction by implementing usage dashboards and conducting feedback sessions, resulting in a 50% increase in usage within six months. • Cultivated strong relationships with internal and external senior stakeholders, identifying technology use cases, contributing to product development, and successfully selling Efficio product suite licenses.
Python
SQL
Excel
View more
Python
SQL
Excel
VBA
Tableau
View more
Senior Data Analytics Consultant
Efficio Consulting
2020-07-01-2021-07-01
• Product owner and client delivery lead of the Efficio eFlow Sourcing Analytics product. This provided quantitative analysis of procurem...
• Product owner and client delivery lead of the Efficio eFlow Sourcing Analytics product. This provided quantitative analysis of procurement sourcing tenders (MySQL, Tableau, VBA, Python). • Improved the product scalability and reliability through code refinement, process automation and the creation of a no-code set-up wizard, reducing setup time from five days to one hour. • Collaborated with Consulting, Product and Engineering teams across many projects and internal workstreams, resulting in the development of successful tech products and the delivery of procurement analysis.
Python
SQL
Excel
View more
Python
SQL
Excel
VBA
Tableau
View more
PROJECTS
Trading algorithm for futures scalping | MT5, MQL5, Python, Excel
2024
- A professional futures trader wanted me to help him build a trading algorithm using MT5 / MQL5. - First we created lots of examples us...
- A professional futures trader wanted me to help him build a trading algorithm using MT5 / MQL5. - First we created lots of examples using Python, Excel clearly highlighting the desired inputs, trading strategy and expected outputs. - A plan with milestones was created with incremental demo and real-money testing planned for each stage (often real-money testing highlights additional issues). - After 3 months of building, testing and analysis, the algorithm was ready to trade with real-money. - The client was very happy and I continue to help him with other trading strategies, back-testing and custom indicators.
Python
C#
SQL
View more
Python
C#
SQL
VBA
Power Query
MQL5
Microsoft Power BI
View more
Strategy analysis for New York hedge fund | Python, Excel, JSON, API
2024
- A hedge fund manager wanted me create a back-testing model and analysis for a prospective strategy. - First JSON data was downloaded v...
- A hedge fund manager wanted me create a back-testing model and analysis for a prospective strategy. - First JSON data was downloaded via an API, and restructured into a useable format. - Worked examples were created in Excel using simple data to mimic the strategy. This ensured the logic was understood and agreed by both parties, prior to creating the Python code. - A Python script was created that replicated the trade logic and then outputted CSV files for analysis. - These files were then analysed in Excel and high level summaries created to report to the board of directors and investor groups. - The hedge fund is now a valued client who I continue to work with. I cannot share screenshots or example code due to an NDA that was signed.
Python
JSON
Excel
View more
Python
JSON
Excel
API
Pandas
Power Query
Excel Power Query
View more