Anup Mistry

Anup Mistry

Mentor
5.0
(57 reviews)
US$15.00
For every 15 mins
132
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.

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.
Spanish, English
London (+00:00)
Joined April 2023
EXPERTISE
8 years experience | 14 endorsements
8 years experience | 10 endorsements

REVIEWS FROM CLIENTS

Anup's profile has been carefully vetted and approved as a Codementor. Connect with Anup now, and leave a review for them once you're done!
SOCIAL PRESENCE
GitHub
anupmistry123
Config files for my GitHub profile.
0
0
procurement_analysis_tool
Visual Basic .NET
0
0
EMPLOYMENTS
Senior Data Analyst
Munich Re
2024-08-01-Present
  • Created dashboards that show the performance of UK home insurance portfolios (Power BI, Power Query).
  • Modelled over £200m...
  • 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.

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-08-01

Global Return Asset Management

  • Built algorithms (Python, REST APIs) that back-tested strategies and optimi...

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).
Python
SQL
Excel
View more
Python
SQL
Excel
Excel VBA
Google Cloud Platform
Tableau
Power Query
MQL5
Power BI
Snowflake
View more
Senior Data Analytics Consultant
Efficio Consulting
2020-07-01-2022-05-01
  • Product owner and delivery lead of the eFlow Sourcing Analytics product for procurement RFPs.
  • Was responsible for a 5-per...
  • Product owner and delivery lead of the eFlow Sourcing Analytics product for procurement RFPs.
  • Was responsible for a 5-person team that delivered analytics to over 50 external clients.
  • Collaborated with external clients across multiple sectors to successfully build end-to-end analytics solutions.
  • Identified strategic technology partnerships and led workstreams to create data architecture and dashboards.
  • Upskilled team members to deliver industry-leading procurement dashboards (Excel, SQL, Tableau).
Python
SQL
Excel
View more
Python
SQL
Excel
Excel VBA
Tableau
AWS
View more
PROJECTS
Trading algorithm for futures scalping | MT5, MQL5, Python, Excel
2025
- 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
View more