Anup Mistry

Anup Mistry

Mentor
5.0
(53 reviews)
US$15.00
For every 15 mins
125
Sessions/Jobs
View Video
ABOUT ME
Analytics Expert | SQL - Python - Excel - Power BI | 10 years exp.
Analytics Expert | SQL - Python - Excel - Power BI | 10 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
  • 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:

Senior data professional delivering expert analysis to enable businesses to make improved data-driven decisions. Over 10 years of experience, including 7 years in consulting and 3 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
  • Algorithm development
  • AI / Machine Learning
  • API integration
  • Automation
  • ETL
  • Data visualization
  • SaaS (Software as a Service)
Spanish, English
London (+00:00)
Joined April 2023
EXPERTISE

REVIEWS FROM CLIENTS

5.0
(53 reviews)
genevieve Perry
genevieve Perry
November 2024
Anup is amazing! He came through again, even though I asked him to do something he'd never done before. I'm so grateful to have him as a mentor - he's truly a pleasure to work with!
genevieve Perry
genevieve Perry
November 2024
Anup is amazing! His business acumen and personality are both top-notch. I'm incredibly appreciative of the time he spent with me, appending queries and teaching me how to use Power Query. He's also super responsive and always on time, which I really appreciate. As someone with dyslexia, I sometimes struggle with directional instructions, but Anup was very patient and understanding. I'm so grateful I found him and will definitely reach out for more training in the future.
Amir Ali
Amir Ali
November 2024
Amazing support, guidance and overal mentorship from Anup. A true expert with Power BI - I've learned so much in our call, and progress more than weeks worth of solo effort in a short span of time. I plan to reach out and ask for mentorship again for any and all Power BI troubeshooting.
Sophy Polanco
Sophy Polanco
July 2024
Anup is very knowledgeable, patient, and professional. He coached me through creating an Excel dashboard that I needed help with. I would rate him a 10/10, I'm so glad we worked together on this project. I would reach out to him again to develop my Excel skills.
Stacey Payne
Stacey Payne
June 2024
Anup was very easy to work with, he read my troubleshooting problem prior to reaching out and quickly came up with a solution. The easiest process to solving an odd Power BI problem by far!
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!
SOCIAL PRESENCE
GitHub
anupmistry123
Config files for my GitHub profile.
0
0
procurement_analysis_tool
Visual Basic .NET
0
0
EMPLOYMENTS
Senior Data Reporting Analyst
Munich Re
2024-08-01-Present
• Work in the consumer insurance team focusing on analysing a UK home insurance portfolio. • Create dashboards that detail the performanc...
• Work in the consumer insurance team focusing on analysing a UK home insurance portfolio. • Create dashboards that detail the performance of the insurance portfolios (Power BI, Power Query). • Dashboards show key business metrics including loss ratios, earned premium and premium adequacy. • Enable pricing analysts and actuaries to obtain data extracts to aid pricing analytics (Python, SQL, Excel).
Python
Excel
Transact-SQL
View more
Python
Excel
Transact-SQL
Microsoft SQL Server
Power BI
View more
Data Analytics Consultant
Self-Employed (various clients)
2022-06-01-2024-07-01
Successfully completed projects for clients such as US hedge funds, tech start-ups and multinationals. Project highlights: Global Return...
Successfully completed projects for clients such as US hedge funds, tech start-ups and multinationals. Project highlights: Global Return Asset Management • Reputable New York based hedge fund using an algorithmic based approach to invest in multiple asset types. • Built and maintained an algorithm (Python, REST APIs) that evaluates and optimizes portfolio performance. • Lead a cloud-based data warehouse workstream (AWS) to store historic portfolio analysis and run Python scripts. Perfected Claims • The firm provides tech-powered case acquisition and development solutions to support law firms in mass tort cases. • Work with the head of technology to develop dashboards for the business (Power BI, Power Query, PostgreSQL) • Dashboards show case progress over time and flag development issues to the business. • Created deployment pipelines into production, security group / role features (Microsoft Fabric / Power BI Service). Data Analytics Advisor • Trained organizations to improve all aspects of data analysis including data transformation and visualization. • Example training topics include data architecture for Power BI dashboards; effective analytics for C-suite stakeholders and using Python to automate processes. • Advised on best-practice data strategy and architecture for clients requiring complex data systems. Independent financial traders • Collaborated with experienced traders (10+ years exp.) to develop 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, Metatrader and MQL5 (a trading language similar to C++).
Python
SQL
Excel
View more
Python
SQL
Excel
Excel VBA
Google Cloud Platform
Tableau
Power Query
MQL5
Power BI
Snowflake
View more
Data Analytics Team Manager
Efficio Consulting
2021-07-01-2022-05-01
• Was responsible for a five-person team that delivered analytics to internal and external clients. • Worked within many sectors includin...
• Was responsible for a five-person team that delivered analytics 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 team from one to five members within six months. • Increased customer usage by implementing KPI dashboards, resulting in a 50% increase within six months. • Cultivated strong relationships with internal and external senior stakeholders, identifying strategic technology partnerships and successfully selling product licenses.
Python
SQL
Excel
View more
Python
SQL
Excel
Excel VBA
Tableau
AWS
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
Excel VBA
Power Query
MQL5
Power BI
View more
Strategy analysis for New York hedge fund | Python, Excel, JSON, API
2024
- A hedge fund manager wanted me to create a back-testing model and analysis for a prospective strategy. - First JSON data was downloade...
- A hedge fund manager wanted me to 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