ALAN SANTHOSH
Wales,UK
Summary
Results-oriented candidate aiming for dynamic positions in distinguished firms, applying more than 6 years of analytical and visualization skills to enhance organizational performance.
Overview
7
7
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work history
Executive- Power BI Developer
MACQUARIE GLOBAL SERVICES PRIVATE LTD
, India
05.2024 - 06.2025
- Developed and maintained Power BI dashboards using Power Query for data transformations and DAX for calculations.
- Participated in agile development cycles within cross-functional Scrum teams to deliver timely dashboard enhancements.
- Translated dashboard requirements into user stories and acceptance criteria in Azure DevOps for effective sprint tracking.
- Contributed to sprint estimation and task breakdowns to facilitate predictable Power BI deliveries.
- Designed scalable tabular models with efficient DAX and Power Query transformations to enhance report performance.
- Enabled Row Level Security (RLS) using DAX functions in Power BI Desktop, publishing reports to Power BI Service.
- Leveraged SQL to extract data from corporate databases for comprehensive risk assessment analysis.
- Configured scheduled data refreshes in Power BI Service, ensuring reliable reports for real-time decision-making.
- Utilized Alteryx to design and implement data workflows that automate data transformations, enhancing the
efficiency of data processing for risk-related insights
Associate Consultant- Power BI developer
KPMG GLOBAL SERVICES
07.2022 - 05.2024
- Developed data models and Power BI dashboards to facilitate strategic decision-making for global clients.
- Led unit and UAT testing of dashboards, ensuring accuracy and compliance with business rules.
- Managed Power BI workspaces, gateways, and deployment pipelines, enhancing CI/CD practices.
- Collaborated within cross-functional Scrum teams to deliver comprehensive Power BI solutions bi-weekly.
- Designed data models tailored to business needs, establishing relationships between various data sources.
- Wrote efficient DAX queries to optimise data retrieval and created diverse visualisations in Power BI Desktop.
- Performed data validation through SQL queries to guarantee accurate data flow in dashboards.
- Maintained workflows using Alteryx Designer to transform flat file data for Power BI integration
Senior Data Analyst
Orange Business Services
12.2020 - 07.2022
- Collected revenue data from Member Firms to identify growth opportunities.
- Delivered technical support for data collation and transformation using ETL tools.
- Integrated Power BI with Azure Data Factory to orchestrate data workflows.
- Extracted data from multiple source systems, including databases and flat files.
- Cleansed and transformed extracted data to align with business requirements.
- Prepared Power BI reports on order status and SLA management for stakeholder presentations.
Analyst
Imperial Auto Group
08.2018 - 12.2020
- Preparation of Process as per customer requirement.
- Preparation of charts on resource planning.
- Create excel based solutions for data analysis, reporting and manipulation using VBA scripts, including the development of custom functions, forms and dashboards.
- Track and evaluate key operational metrics and KPI's to identify bottlenecks in operational workflows and propose process improvements to streamline operations.
Education
Intermediate Schooling - Science
St Paul's School
B-TECH - Mechanical Engineering
World College of Technology and Management
India 04.2014 - 04.2018
Skills
- Power BI , Alteryx
- SQL, VBA
- Azure DevOps and Scrum
- Agile methodologies
Certification
- Microsoft Power BI Data Analyst (PL-300)
- Alteryx Core Designer
Timeline
Executive- Power BI Developer
MACQUARIE GLOBAL SERVICES PRIVATE LTD
05.2024 - 06.2025
Associate Consultant- Power BI developer
KPMG GLOBAL SERVICES
07.2022 - 05.2024
Senior Data Analyst
Orange Business Services
12.2020 - 07.2022
Analyst
Imperial Auto Group
08.2018 - 12.2020
B-TECH - Mechanical Engineering
World College of Technology and Management
04.2014 - 04.2018
Intermediate Schooling - Science
St Paul's School
Similar Profiles
Harsh JainHarsh Jain
Executive at Macquarie Global Services Private LimitedExecutive at Macquarie Global Services Private Limited
Garima SaxenaGarima Saxena
Assistant Manager - Macquarie Capital at Macquarie Global Services Private LimitedAssistant Manager - Macquarie Capital at Macquarie Global Services Private Limited
Vikas BagriVikas Bagri
Senior Associate at Macquarie Global Services PrivateSenior Associate at Macquarie Global Services Private
ANDY YEBOAHANDY YEBOAH
Welder fabricator technician at Bless inn Metal Work's LimitedWelder fabricator technician at Bless inn Metal Work's Limited
Alia ZafarAlia Zafar
SEN Teacher at Cheetham COE community academySEN Teacher at Cheetham COE community academy