AMANDEEP SINGH BASRA
Dubai,UAE
Summary
A highly skilled professional with expertise in Power BI, SQL, and Python, specializing in data modelling and analysis. Demonstrates strategic thinking and creativity in business intelligence, report automation, and dashboard development. Proficient in statistical analysis and Data Analysis Expressions (DAX), with a strong focus on enhancing data-driven decision-making processes. Career goals include advancing the integration of innovative data solutions to drive business success.
Overview
9
9
years of professional experience
Work history
Assistant Manager, Analytics
Aster Dm Healthcare
Dubai, UAE
08.2022 - Current
- Created end to end digital solution from gathering data from multiple sources like PostgreSQL, MySQL, MS SQL Server through complex SQL queries, Excel and csv. Preprocessed the data through Python script & Power Query in producing report through Power BI desktop and published the report to Power BI service for data driven business decision. Optimized report with a focus on usability and performance.
- Developed dashboards like social media leads conversion dashboard, Business Unit Cohort Performance dashboard. Nurture/Maternity Patient compliance dashboard, customers movement dashboard, NPS dashboard, Referral dashboard, Sales dashboard resulting in a 50% increase in operational efficiency and 80% reduction in report development time.
- Automated the campaign evaluation process through a user-interactive Power BI dashboard, reducing the manual efforts by 80% and providing the key insights for campaigns effectiveness.
- Improved dashboard usability by implementing interactive visualizations resulting in a 20% increase in user engagement.
Senior Analyst
Capgemini Invent
01.2019 - 08.2022
- Responsible for analyzing and visualizing Microsoft official Corporate Finance users' queries raised in Budgeting, Restatement and Forecast Cycles.
- Data analysis through ad hoc MSRA (Microsoft Reporting and Analysis) report creations and validate users' queries and provide insights on Data Discrepancy, General Questions etc.
- Responsible to analyze the raw data and convert them into meaningful insight with the help Power BI to support in making informed decision.
Data Analyst
Collabera Technologies
01.2017 - 01.2019
- Designed and developed dashboards from gathering data using SQL Server and various Excel sources.
- Integral part of team in throughout data gathering and data analysis framework involving data cleaning, processing, analyzing, visualizing and reporting.
- Extract the desired data from relational databases and make reports as per client requirements on hourly basis such as maximum revenue generated products, stores, area, region, peak hours of customers visiting, products are in demand etc.
Education
BSC(H) - Mathematics
PGDAV College
Skills
- Power BI
- Power Query/M language
- Data Modeling
- Data Analysis Expressions (DAX)
- SQL
- Python
- Statistical analysis
- Strategic thinking
- Creativity
- Business intelligence
- Report automation
- Dashboard development
- Data analysis
Accomplishments
Pinnacle Process Excellence Award Q2 CY25 (Aster Retail)
Timeline
Assistant Manager, Analytics
Aster Dm Healthcare
08.2022 - Current
Senior Analyst
Capgemini Invent
01.2019 - 08.2022
Data Analyst
Collabera Technologies
01.2017 - 01.2019
BSC(H) - Mathematics
PGDAV College
Similar Profiles
RAJASEKAR B SRAJASEKAR B S
ASSISTANT MANAGER – BIOMEDICAL DEPARTMENT at ASTER CLINICAL LAB LLP (ASTER DM HEALTHCARE)ASSISTANT MANAGER – BIOMEDICAL DEPARTMENT at ASTER CLINICAL LAB LLP (ASTER DM HEALTHCARE)
Shiju K NShiju K N
PROCUREMENT EXECUTIVE at Aster DM Healthcare Limited (Aster Medcity Hospital)PROCUREMENT EXECUTIVE at Aster DM Healthcare Limited (Aster Medcity Hospital)
Jayalakshmi GajendranJayalakshmi Gajendran
Submission/Resubmission Officer - Coding at Aster DM HealthcareSubmission/Resubmission Officer - Coding at Aster DM Healthcare
ROA SAGHAYROONROA SAGHAYROON
Business Development Manager at Aster DM HealthcareBusiness Development Manager at Aster DM Healthcare
DENIS SSEMATADENIS SSEMATA
Equipment operator at Emirates GroupEquipment operator at Emirates Group