Data Analyst | Business Analytics | AI & Automation Solutions
📍 India | 🎯 Targeting MSc Business Analytics / Digital Engineering — Germany
🏆 Top 100 Innovation Award — PwC Internal Competition (Mail-Shield Project)
Data Analyst with 5+ years of experience at PwC and Tata AIG, specialising in solving real-world business problems through data, automation, and AI-driven workflows.
I focus on transforming raw data into actionable insights — building dashboards, risk models, and automated systems that directly improve business performance.
| Category | Tools |
|---|---|
| Data Analysis | SQL, Python (Pandas, NumPy), Advanced Excel |
| Visualisation | Power BI, DAX |
| AI & Automation | Microsoft Copilot, Power Automate, Amazon Bedrock |
| Analytics Concepts | Business Analytics, Risk Scoring, Feature Engineering |
| Other | ServiceNow, CSOD (Learning Management Systems) |
🏆 Top 100 — PwC Internal Innovation Competition
📌 Automated phishing detection and reporting workflow built for enterprise scale
- Designed end-to-end workflow using Power Automate + Microsoft Copilot + M365
- Reduced phishing reporting time from ~5 minutes to near-instant execution
- Saved approximately 42 business hours per team
- Built dashboards for real-time threat monitoring and cybersecurity response
- Python simulation of detection logic available in this repo
📌 Data-driven system to identify high-risk learners and enable early intervention
- Built a risk scoring model using training attendance, scores, and engagement data
- Performed data cleaning, feature engineering, and pattern analysis
- Created Power BI dashboards for decision support
- Enabled targeted intervention to improve training ROI
📌 Identifying early behavioural signals of device disengagement using FitBit tracker data to inform Bellabeat's onboarding strategy
- Identified early device disengagement signals using FitBit data.
- Built engagement risk score in BigQuery, visualised in R,
- delivered as 3-page interactive Power BI dashboard.
- Preparing for MSc admission in Germany (Business Analytics / Digital Engineering)
- Deepening skills in Python, SQL, and data storytelling
- Building portfolio projects that bridge analytics and real business impact
To work as a Data Analyst / Business Analytics professional in Germany, contributing to data-driven decision-making, process automation, and scalable analytics solutions in an international environment.
- 🔗 LinkedIn: linkedin.com/in/prantadasgupta
- 📧 Email: pranta.dasgupta.de@gmail.com