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: Google BigQuery, MySQL, PostgreSQL, T-SQL
  • Object Orientated Programming: Python (pandas, polars, sqlalchemy), VBA
  • Cloud Platforms: AWS, Azure, dbt, Microsoft Fabric, Power BI Service
  • 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 partnership). Discounts are offered for longer term agreements of 1 week or more.

Work Experience

Senior Data Analyst
Munich Re | Aug 2024 - Present
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.

Data Analytics Consultant
Self-Employed (various clients) | Jun 2022 - Aug 2024
Python
SQL
Excel
Excel VBA
Google Cloud Platform
Tableau
Power Query
MQL5
Power BI
Snowflake

Global Return Asset Management

  • Built algorithms (Python, REST APIs) that back-tested strategies and optimized performance for a multi-million dollar hedge fund.
  • Led a cloud-based data warehouse workstream (AWS) to store historic data and run ETL scripts.

Perfected Claims

  • Developed dashboards tracking the progress and success of mass-tort cases. (Power BI, Power Query).
  • Salesforce data (via API) is transformed into insightful, actionable insights for the business.
  • Created models and marts in dbt to drive Power BI reports (PostgreSQL, dbt Cloud, GitHub)
  • Implemented deployment pipelines and security group / role features (Microsoft Fabric / Power BI Service).

Other

  • Trained organizations to improve all aspects of data analysis including data transformation and visualization.
  • Advised on and implemented data warehouse and ETL systems for several clients (T-SQL, Python, Google BigQuery).

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