Personal details

Anup M. - Remote data analyst

Anup M.

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

About

Microsoft Certified Power BI, Python, and SQL professional with 10+ years of experience delivering high impact analytics solutions. Skilled in data visualization, dashboard design, and technical problem solving to drive actionable, data-driven insights for businesses.

Technical Proficiencies:

  • Visualization Tools: Power BI (Microsoft Certified PL-300)
  • Database Languages: MySQL, PostgreSQL, T-SQL, Snowflake SQL
  • Object Orientated Programming: Python (pandas, polars, snowspark, sqlalchemy), VBA
  • Cloud Platforms: AWS, dbt, Microsoft Fabric, Power BI Service, Snowflake
  • Other: DAX, Excel, Power Automate, Power Query

Data Analysis Skills:

  • Automation
  • API integration
  • ETL
  • Dashboard UX Design
  • Data modelling and architecture
  • Data storytelling
  • KPI Development

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 also specialise in building trading algorithms and back-testing models, in MQL4, MQL5, MT4, MT5, Interactive Brokers API.
  • For freelance jobs and long term mentoring, intro calls are free (allowing you to assess the suitability of a collaboration). Discounts are offered for longer term agreements of 1 week or more.

Work Experience

Senior Data Analyst
NHBC | Feb 2026 - Present
Python
SQL
Excel
Power Query
Power BI
Snowflake
Microsoft service fabric
Snowpark
  • Created dashboards that analyse the profitability of new home insurance in the UK (Power BI, Power Query).
  • Created the Power BI template that all dashboards are derived from.
  • Improved quality of service by creating workflows around best practice and stakeholder engagement.
  • Built ETL pipelines to service stakeholder reports and dashboards (Python, Snowflake).
Senior Data Analyst
Munich Re | Aug 2024 - Jan 2026
Python
Excel
Transact-SQL
Microsoft SQL Server
Power BI
  • Created dashboards that show the performance of UK home insurance portfolios (Power BI, Power Query).
  • Modelled over ÂŁ200m of written premium, helping stakeholders to make data-driven decisions.
  • Created and maintain data architecture that extracts JSON data into KPI reports (Python, SQL, Excel).
  • ETL pipelines have effectively enabled the pricing team to self-serve over 5m rows of data for business intelligence.

Projects

Trading algorithm for futures scalping | MT5, MQL5, Python, Excel
2025
Python
C#
SQL
Excel VBA
Power Query
MQL5
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
- 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.

Education

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