Technical Data Analyst Intern - Trainity
(2025-03 - 2025-08)
Completed seven end-to-end analytics projects using SQL, Excel, and Power BI involving ETL, data cleaning, exploratory data analysis (EDA), dashboard development, data visualization, and business intelligence reporting.
- Operational Efficiency Optimization (SQL, MySQL): Analyzed 10,000+ operational records using SQL joins, aggregations, and window functions to identify campaign bottlenecks, improving engagement by 12% and operational efficiency by 18%.
- Bank Loan Risk Profiling (Excel): Cleaned and analyzed 50,000+ loan records in Excel using Pivot Tables, Power Query, Lookup functions, and statistical analysis to identify high-risk borrower segments with a 25% higher default probability.
- Cars Pricing Strategy (Excel): Performed regression and trend analysis on 11K+ car models to uncover price influencers, consumer preferences, and market gaps, supporting data-driven product strategy.
- Call Centre Staffing Optimization (Excel): Analyzed 117K+ calls; Reduced call abandonment rate from 30% to 10% through an optimized staffing model.
- MNC Hiring Process Diagnostics (Excel): Analyzed hiring trends across 10+ departments, identifying a 30% gender gap in technology roles and supporting diversity hiring recommendations.
- Instagram User Landscape (SQL): Analyzed 500K+ Instagram interactions using SQL joins and aggregations to identify loyal users, inactive accounts, and optimal advertisement timings for improved campaign performance.
- IMDb Movie Trend Exploration (Excel): Evaluated 10,000+ movies to analyze genre-wise ROI, director performance, and audience ratings, delivering business insights through an executive presentation.
Data Analyst Portfolio Projects - Portfolio Projects
(2024-12)
Designed and delivered real-world analytics projects showcasing business impact using Power BI.
- Sales Data Intelligence (Power BI): Built an interactive Power BI dashboard using data modelling and DAX to analyze $2.5M+ annual revenue, monitor profit margins (18% YoY growth), and identify the top three customer segments contributing 35% of total revenue.
- HR Attrition Insights: Cleaned and transformed HR data using Power Query and performed exploratory data analysis to identify key attrition factors. Developed interactive Power BI dashboards with DAX measures to monitor workforce metrics and delivered actionable insights for employee retention.
- Paralympics Performance Analytics (Power BI): Visualized 30+ years of data, uncovering medal trends and country performance; supported sports talent scouting and strategy.
Talent Acquisition Specialist - Artech Infosystem, Nagarro, IDC, Tantranzm, E-Solutions, Cosette Network
(2019-06 - 2026-07)
- Managed end-to-end recruitment for 100+ IT hiring requisitions across Domestic and MEA markets, successfully placing 50+ professionals in IT, Telecom, and Engineering roles.
- Partnered with hiring managers and clients to deliver Contract-to-Hire (C2H) and Permanent hiring solutions while optimizing sourcing strategies and reducing time-to-fill.
- Strengthened stakeholder relationships through client collaboration, recruitment reporting, and process improvement.
