Pratik Mangalkar
Leeds,United Kingdom
Summary
I’m a Data Analyst with hands-on experience in SQL, Power BI, Python, and Excel, where I’ve built dashboards, performed deep-dive analyses, and delivered insights that help shape business decisions. I enjoy working with large datasets writing SQL queries, crafting Python scripts, and transforming raw data into clear, actionable stories.
Recently, I completed my MSc in Business Analytics & Big Data, where I focused on using data to solve real-world business problems. I thrive on turning complex information into interactive dashboards and clear insights that resonate with cross-functional teams and drives business success.
Overview
1
1
year of professional experience
5
5
years of post-secondary education
9
9
Certificate
Work history
Business Operations and Technology Associate
Grad Pathway
London
09.2024 - 05.2025
- Designed Power BI dashboards used by 3 departments, increasing visibility into user retention and feature usage by 60%.
- Cleaned and structured SQL datasets from 50K+ rows, cutting reporting time by 40% and improving data accuracy.
- Built Excel-based forecasting models with 90% accuracy, influencing quarterly planning decisions across sales and marketing teams.
- Presented findings to cross-functional stakeholders during Agile sprint reviews, leading to adoption of 2 data-driven workflow changes.
- Documented data processes and dashboard logic, reducing onboarding time for new analysts by approximately 25%.
Business Consulting Intern
NEXIX Security Labs
London
07.2024 - 11.2024
- Automated lead scoring using Python and SQL, boosting qualified lead conversion by 18% and reducing manual filtering by 3 hours/week across campaigns.
- Built interactive Power BI dashboards used weekly by sales managers, improving visibility into conversion rates and regional pipeline health across 4 key markets.
- Compiled a repository of 200+ company profiles to support market entry, resulting in 2 new qualified international leads.
- Presented competitor insights to business team, informing service changes and improving proposal response rate by 12%.
- Documented analysis workflows and created walkthroughs, enabling smooth project transition to two full-time analysts.
Education
MSc - Business Analytics and Big Data
09.2023 - 12.2024
- Modules: Advanced Data Analysis, Digital Business Strategy, Data-Driven Decision Making
- Coursework: Built an interactive dashboard to forecast company projections and manage financial performance.
BSc - Computer Science Engineering
06.2018 - 03.2022
Skills
- SQL(MySQL, T-SQL, Big Query,SSMS)
- Power BI(Data Transformation, DAX, Data Modeling,Dashbord)
- Excel(Advance)
- Python(pandas, numpy, matplot)
- Data Processing(Cleaning, Wrangling)
- KPI Reporting
- Statistical Analysis
- Relational Databases
- Problem Solving
- Cross-Functional Collaboration(Git, Click-up)
- Brainstorming(X-mind, Notion)
Certification
- Introduction to Strategy Consulting - BCG
- SQL for Data Science - Coursera
- Microsoft Power BI Desktop for Business Intelligence - Udemy
- Using Python to Manage Data - Coursera
- University Business Challenge - UBC2024
Timeline
Business Operations and Technology Associate - Grad Pathway
09.2024 - 05.2025
Business Consulting Intern - NEXIX Security Labs
07.2024 - 11.2024
University of Liverpool - MSc, Business Analytics and Big Data
09.2023 - 12.2024
Nagpur University - BSc, Computer Science Engineering
06.2018 - 03.2022
Development Projects
Data Visualization Hackathon – Sales Dashboard E-commerce Revenue Analysis Project
Techcanvass Hackathon - 4-Year Sales Data Analysis
- Built an interactive Power BI dashboard to analyze 4 years of sales data, addressing key business questions and uncovering sales trends.
- Performed data cleaning and transformation using Python (Pandas, NumPy) and T-SQL to ensure data accuracy and consistency.
- Developed a robust data model by establishing relationships between multiple tables and applying DAX measures for dynamic analysis.
- Leveraged Power BI features (Data Transformation, Dashboard Building, Interactive Visuals) to deliver actionable insights on category performance and customer behavior.
- Enhanced expertise in data storytelling, visualization best practices, and insight-driven decision-making.
E-commerce Revenue Analysis Project
Python (Pandas), SQL (T-SQL), Power BI
- Analyzed 50,000+ revenue records to identify revenue drivers, seasonal trends, and high-value customer segments for an e-commerce business.
- Performed data cleaning and transformation using Python (Pandas) and SQL to ensure data integrity and consistency.
- Built an interactive Power BI dashboard showcasing revenue distribution, category-wise performance, and promotional impact across product tiers.
- Discovered key revenue concentration areas and underperforming categories, leading to data-driven recommendations projected to increase revenue by 16%.
- Presented insights to mock stakeholders, emphasizing strategies for boosting sales and improving product mix profitability.
Database Algorithm for Tensistrength
- Created a dba to update the lexicon of the stress detecting tool Tensistrength and improve it's accuracy.
- The algorith we made was able to use NLP and accurectly append newly discoverd words from the text input to the existing Lexicon of Tensistrength resulting in improved accuracy.
- Used Python (pandas, tensistrength, nlp etc), Django, HTML/CSS, Git/Github.
Personal Information
Work Permit: Full Right to Work in the UK (Graduate Visa)
Similar Profiles
Anthony PeckAnthony Peck
Clinical Mental Health Counselor (current Student) at Midwestern University (Grad Program Online)Clinical Mental Health Counselor (current Student) at Midwestern University (Grad Program Online)
Matthew BaldwinMatthew Baldwin
Chemical production worker at GRAD speciality productsChemical production worker at GRAD speciality products
Chelsea RajpalChelsea Rajpal
Intern at GRAD GIRLS 2024 - VicICT4WomenIntern at GRAD GIRLS 2024 - VicICT4Women
Shubham PawarShubham Pawar
In-Store Assistant at Reliance Smart RetailIn-Store Assistant at Reliance Smart Retail
Alex DoddAlex Dodd
Administrative assistant at Specsavers OpticiansAdministrative assistant at Specsavers Opticians