Ilyas Fakhruddin
Data & Analytics professional
Hire this person
Send a job offer directly to this candidate
About
Data & Analytics professional with nearly 3 years of experience developing analytical datasets, turning operational, financial, and performance data into dashboards that support management reporting, KPI monitoring, and data-driven decision-making. Expertise in data modeling, DAX, Power Query, and SQL with hands-on experience in ETL/ELT processes, data modeling, and data quality controls including validation and reconciliation to integrate and optimize data from multiple sources. Proven track record of collaborating with stakeholders to translate requirements into scalable BI solutions that drive business insights.
Passionate about transforming complex datasets into actionable insights.
Experience
Data Intelligence Intern at Starcom Media Worldwide, Publicis Groupe (2025-07 – 2025-12)
- Leveraged SQL (Google BigQuery) on Google Cloud Platform, ETL processes, and data normalization techniques to perform data modeling and transform complex marketing data into accurate, business-ready datasets.
- Built dynamic dashboards on Looker Studio, applying dashboard development best practices and star schema design to visualize client and competitor performance for Publicis Media's APAC and Global clients.
- Performed brand coverage checks for clients and competitors using third-party data platforms ensuring market visibility and benchmarking.
BI Developer (Contract based role) at Jubilee Life Insurance (2024-09 – 2024-12)
- Architected enterprise-wide Power BI dashboards that centralized data from Oracle SQL Developer, MS Excel, and web sources, ensuring seamless data integration.
- Collaborated with stakeholders across the organization to gather requirements and align strategies, delivering actionable insights and enhancing data accuracy.
- Engineered performance reports covering HR, Finance, Sales, Underwriting and other multi-departmental performance KPIs, utilizing DAX for data modeling and time-series analysis while applying data warehousing principles such as star schema to highlight business strategies.
- Conducted MS Power BI trainings (scratch to advance level) for user-adoption enablement across impacted teams.
Management Trainee Officer at Lucky Cement Limited (2023-11 – 2024-08)
- Extracted and updated yearly and quarterly financials with 100% accuracy, complying with audited accounts.
- Developed MS Power BI dashboards to track logistics, cement production & sales, inventory turnover, and other financial/operational KPIs hence reducing manual reporting and improving productivity and operational performance reporting.
- Involved in project management for a $120M clinker expansion project by analyzing LCs and comparing EPC budgets vs. actual expenses.
Data Analyst at Al Intisar Solution Pvt. Ltd (2022-12 – 2023-11)
- Architected and managed MS Power BI and Tableau dashboards for local and international clients centralizing data from SQL databases, MS Excel and, web sources.
- Created forecasting and prediction models, offering a precision level of +/- 90%.
- Facilitated requirement gathering sessions with clients and partnered with cross-functional teams to drive project completion.
Education
Masters in Analytics and Visualization in Data Visualization, Analytics, Forecasting, Automation, Statistics, and Causal Analysis – Singapore University of Social Sciences (2025-01 – 2026-05)
Bachelors in Electrical Engineering in Statistics & Probability, Power Generation & Dispatch, Differential Equations, Data Structures & Algorithms – DHA Suffa University (2019-09 – 2023-06)
Applied Business Intelligence and Analytics in MS PowerBI, Tableau, SQL, Python, MS Excel – VBA, Data Storytelling – DHA Suffa University (2021-06 – 2021-12)