Shantan Tanuku
London
Summary
Experienced Power BI Developer / Senior Data Analyst with 5+ years of success delivering enterprise-grade BI solutions, automated data pipelines, and cloud-based reporting systems. Expert in Power BI (DAX, Power Query, RLS), SQL, and Python, with a strong track record of transforming raw data into actionable insights through advanced dashboards and scalable data models. Skilled in integrating data from diverse sources (Azure, AWS, GCP, SQL, APIs, Web Scraping) to build end-to-end analytics solutions that support smarter, faster decisions across functions like Finance, Marketing, HR, and Supply Chain. Proven ability to reduce manual reporting, cut costs, and improve performance through predictive analytics, KPI tracking, and workflow automation. Adept at working in Agile (Scrum/Kanban) environments, engaging with stakeholders, and enabling teams through BI training and self-service analytics adoption.
Overview
7
7
years of professional experience
Work History
Power BI Developer | Senior Data Analyst
Scuderia Car Parts
06.2023 - Current
- Enterprise BI Development: Designed and deployed 15+ Power BI dashboards with advanced DAX measures and optimised data models, delivering real-time insights for Finance, Sales, and Supply Chain leadership.
- Cloud Data Integration: Integrated Azure Synapse, AWS RDS, and GCP BigQuery sources into Power BI, enabling a single source of truth across global operations.
- Automated Data Pipelines: Engineered ETL workflows using Power Query, SQL stored procedures, and Python, cutting report refresh cycles by 30% and reducing manual intervention.
- Web Scraping & API Feeds: Built Python-based scraping and API connectors to pull competitor pricing, customer sentiment, and industry data directly into BI dashboards — creating a live market intelligence view.
- Data Quality Automation: Developed SQL/Python scripts to validate data before loading into BI, reducing discrepancies by 25% and ensuring accurate KPIs.
- Predictive Analytics in BI: Embedded forecasting and pricing optimization models directly into Power BI reports, allowing scenario simulations and increasing repeat customer engagement by 15%.
- Row-Level Security & Governance: Implemented Power BI Service governance with RLS and usage monitoring, securing sensitive financial and sales insights.
- Cloud-First Strategy: Automated pipeline deployments via AWS Lambda and Azure Data Factory, scaling reporting processes without manual scheduling.
- Stakeholder Empowerment: Trained 20+ users on advanced Power BI, fostering a self-service BI culture and improving independently generated insights by 20%.
- Operational & Supply Chain BI: Combined real-time and historical data to optimise demand planning, cutting inventory costs by 12% while reducing stock-outs.
- Competitive Edge: Automated trend scraping and integrated it into Power BI dashboards, enabling leadership to react faster to competitor moves and market shifts.
Artificial Intelligence Developer
Icom Solutions
11.2022 - 05.2023
- AI-Driven BI Integration: Developed and deployed multi-class prediction and sentiment analysis models in Python, and integrated outputs into Power BI dashboards, enabling business users to monitor customer sentiment in real time.
- Cloud Analytics Pipelines: Designed data pipelines using AWS S3, Azure Data Factory, and SQL Server, automating the ingestion of large-scale text and call centre datasets into BI platforms.
- Web Scraping and API Automation: Built Python scraping scripts and REST API connectors to pull external customer and competitor data, enriching analytical models, and dashboards.
- Operational Automation: Automated data cleaning, transformation, and loading tasks, reducing manual processing effort by 40% and accelerating insight delivery.
- Advanced Data Visualisation: Created Power BI and Python visualisations (heat maps, NLP dashboards) to uncover patterns in unstructured text and call-centre speech data, improving decision-making speed.
- Model Deployment & Optimisation: Maintained 12 predictive models with automated retraining pipelines, ensuring consistent accuracy and reliable results in BI environments.
- Stakeholder Reporting: Delivered interactive reports to business leaders, combining predictive insights with BI storytelling, and increasing adoption of AI-driven analytics across the company.
Power BI Developer
Styxtech
06.2022 - 10.2022
- HR Analytics Dashboards: Designed and implemented Power BI dashboards for HR leadership, tracking headcount, attrition, hiring funnel metrics, and employee performance KPIs. Improved visibility of workforce trends and reduced manual HR reporting effort by 40%.
- Marketing Data Integration: Built dashboards combining CRM, campaign, and digital analytics data, enabling marketing teams to measure ROI, lead conversion, and campaign effectiveness in real time.
- Data Modelling & Automation: Created optimised data models (star schema) and DAX measures to standardise KPIs across HR and Marketing datasets, ensuring accuracy and consistency.
- SQL and Power Query Pipelines: Automated extraction and transformation of HRIS and CRM data using SQL views and Power Query, reducing refresh times and cutting down on manual intervention.
- Cloud Connectivity: Integrated Azure SQL Database and API feeds (for campaign performance data) into Power BI, delivering a single source of truth for HR, Marketing, and stakeholders.
- Stakeholder Training: Conducted training workshops for HR and Marketing managers, enabling self-service BI adoption, and reducing dependency on static reports.
Associate Data Analyst
V2VALUE BIZ Solutions Private Limited
06.2019 - 12.2020
- Transaction Classification BI System: Developed an automated system to classify transactions by advertiser brand, purchase channel, type, location, and category, and visualised insights in Power BI dashboards for merchant performance analysis.
- Rule-Based & Automated Analytics: Contributed to building a rule corpus that improved the accuracy and consistency of transaction categorisation, reducing manual classification effort, and ensuring clean BI reporting.
- Regex & Data Automation: Designed and executed optimised regex-based queries to extract brand names from millions of transactions, automating a process that previously required significant manual effort.
- Merchant Intelligence Dashboards: Built an automated clustering pipeline to categorise unknown merchants, feeding results directly into Power BI reports used by business teams to track new merchant performance.
- Scalable Data Solutions: Scaled merchant data processing systems to handle millions of records with minimal manual intervention, improving reporting reliability, and efficiency.
- Location Data Standardisation: Developed a USA location corpus and built a custom spell-checker to standardise city names, ensuring accurate mapping of geographic data in BI dashboards.
- Marketing Data Insights: Enabled marketing teams to segment customers more effectively by providing cleansed and categorised datasets, visualised through interactive BI reports.
Intern Data Analyst
V2VALUE BIZ Solutions Private Limited
01.2019 - 05.2019
- Analysed complex datasets using Python and R, providing actionable insights that supported business strategies.
- Ensured the accuracy and reliability of data through extensive cleaning, verification, and validation.
- Developed interactive data visualisations and reports for non-technical stakeholders.
- Optimised machine learning models by selecting relevant features, and improving classifier performance.
- Managed and maintained structured databases, ensuring smooth data flow and up-to-date access for analysis.
- Analysed data processes, identified areas for enhancement, and recommended improvements.
Education
MSc - Data Science
Kingston University
London, ENG06.2022
Bachelors Of Technology - Mechanical Engineering
Pragati Engineering College
India01.2020
Skills
- Power BI: Dashboards, DAX, Power Query, Dataflows, Paginated Reports
- SQL: T-SQL, ETL, Stored Procedures
- Python: Pandas, NumPy, APIs, Automation
- Azure: Synapse, Data Factory, Data Lake
- AWS: RDS, Lambda, S3
- GCP: BigQuery
- Tableau
- Advanced Excel: Power Pivot, VBA
- KPI Tracking
- Predictive Analytics
- Data Modelling: Star Schema, Snowflake
- Forecasting
- Agile Methodologies: Scrum, Kanban
- Stakeholder Engagement
- BI Training & Enablement
Timeline
Power BI Developer | Senior Data Analyst
Scuderia Car Parts
06.2023 - Current
Artificial Intelligence Developer
Icom Solutions
11.2022 - 05.2023
Power BI Developer
Styxtech
06.2022 - 10.2022
Associate Data Analyst
V2VALUE BIZ Solutions Private Limited
06.2019 - 12.2020
Intern Data Analyst
V2VALUE BIZ Solutions Private Limited
01.2019 - 05.2019
MSc - Data Science
Kingston University
Bachelors Of Technology - Mechanical Engineering
Pragati Engineering College
Similar Profiles
Shantan TanukuShantan Tanuku
BI Developer / Tableau Specialist at Scuderia Car PartsBI Developer / Tableau Specialist at Scuderia Car Parts
Santan TanukuSantan Tanuku
AI Applications Engineer | ML-Powered Analytics at Scuderia Car PartsAI Applications Engineer | ML-Powered Analytics at Scuderia Car Parts
Shantan TanukuShantan Tanuku
Supply Chain Optimization | Data Analyst at Scuderia Car PartsSupply Chain Optimization | Data Analyst at Scuderia Car Parts
Selin YozkanSelin Yozkan
Store Colleague at Holland & BarrettStore Colleague at Holland & Barrett
Regina BrewRegina Brew
Registered Nurse at Ontario Health at HomeRegistered Nurse at Ontario Health at Home