Rosalint Celcia
Data Analyst | Business Intelligence | Power BI (Advanced DAX) · SQL · Reporting Automation
Hire this person
Send a job offer directly to this candidate
About
Data Analyst and BI professional with 9 months of hands-on experience across two internships in EdTech and investment banking (BFSI), building executive dashboards and automated reporting systems and operating a production data pipeline. Skilled in Power BI (Advanced DAX), SQL Server, Power Query, Looker Studio, Power Automate, and Advanced Excel. Consolidated 15+ fragmented Google Sheets into a centralized Power BI reporting system, designed 20+ dashboards used by senior leadership, and automated 50%+ of manual reporting workflows.
Strong in KPI development, data modelling, ETL, data validation, and stakeholder-facing executive reporting.
Experience
Data Analyst Intern at ADDA247 (2026-02 – 2026-07)
- Owned daily and monthly executive reporting for 6 senior leaders across EdTech, Banking & Finance, and Tech Skills verticals, delivering decision-ready business insights.
- Cut report-preparation time from 2-4 hours to near-zero by consolidating 15+ fragmented Google Sheets into a centralized Power BI reporting system - a single source of truth for leadership.
- Designed and deployed 20+ interactive Power BI and Looker Studio dashboards, enabling self-service KPI tracking and eliminating recurring ad-hoc reporting requests.
- Automated 50%+ of manual reporting workflows through data modelling and ETL using XLOOKUP, INDEX-MATCH, Pivot Tables, dynamic formulas, and live Power BI-connected data feeds.
- Tools: Power BI, DAX, Power Query, SQL, Looker Studio, Power Automate, Advanced Excel, Google Sheets
Data Analyst Intern at AKAM INNOVATIONS (2024-12 – 2025-04)
- Designed and built a 6-page Power BI dashboard using Advanced DAX, Sankey charts, and custom visuals, tracking revenue forecasts, risk indicators, and investment trends with banking-specific KPIs for a Bahrain-based Islamic investment banking client.
- Operated and maintained the client's automated Excel → SQL Server (SSMS) → Power BI reporting pipeline, initiating daily Power Automate refreshes that sustained 10× faster daily reporting than the prior manual process and supported a 30% improvement in SLA adherence.
- Handled end-to-end ETL in SQL Server - data validation, cleansing, and incremental-load optimization - reducing data errors by 25% across 3 reporting environments.
- Eliminated 100% of recurring manual chart preparation by converting stakeholder reporting requirements into reusable Power BI visualizations, partnering with client-side and consulting teams to define KPIs.
- Tools: Power BI, Advanced DAX, SQL Server, SSMS, Power Automate, Excel, Power Query
Education
M.Sc. in Artificial Intelligence & Data Science – Karunya Institute of Technology and Sciences (2023 – 2025)
Bachelor of Computer Applications (BCA) – Holy Cross College, Tiruchirappalli (2020 – 2023)
