Personal details

Anup M. - Remote data analyst

Anup M.

Data Analytics Consultant
Based in: 🇬🇧 United Kingdom
Timezone: London (UTC+1)

Summary

https://anupmistry123.wixsite.com/home
https://www.linkedin.com/in/anupmistry123/

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:

Independent consultant delivering expert analysis to enable businesses to 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 / Machine Learning

  • API integration

  • Automation

  • ETL

  • Data visualization

  • Statistical analysis

Work Experience

Data Analytics Consultant
Self-Employed (various clients) | Jun 2022 - Present
Python
SQL
Excel
VBA
Google Cloud Platform
Tableau
Power Query
MQL5
Microsoft Power BI
Snowflake
Successfully completed 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 across multiple industries. • Built and currently maintain an algorithm (Python) that evaluates and optimizes portfolio performance. • Data is extracted via REST APIs and analysis is presented through dashboards to the fund manager. -- RSA Insurance -- • Delivered interactive Tableau dashboards (via a GCP database) that track the KPIs of over 100 car repair garages. • Upskilled the staff to use the dashboards effectively, through training workshops. • The analysis allows the client to optimize processing times and explore ways to reduce costs. -- CentroMotion -- • Analysed the cost-savings and benefit of switching suppliers from the US to low-cost countries. • Used SQL (Azure) and Python, with results presented in Tableau and Excel, producing an estimated 25% annual saving of parts and raw materials costs. -- 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, NinjaScript and MQL5 (a trading language similar to C++).
Data Analytics Team Manager
Efficio Consulting | Jul 2021 - May 2022
Python
SQL
Excel
VBA
Tableau
AWS (Amazon Web Services)
• 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.

Education

University of Bath
Bachelor's degree・Physics (with 1 year placement)
Oct 2010 - Jul 2014

Personal Projects

Trading algorithm for futures scalping | MT5, MQL5, Python, Excel
2024
Python
C#
SQL
VBA
Power Query
MQL5
Microsoft Power BI
- 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.
Strategy analysis for New York hedge fund | Python, Excel, JSON, API
2024
Python
JSON
Excel
API
Pandas
Power Query
Excel Power Query
- 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.