AMANDEEP SINGH BASRA
NEW DELHI
Summary
Results-driven Data Analyst with proven expertise at Aster Dm Healthcare in optimizing report development, achieving an 80% reduction in time. Skilled in Power BI and strategic thinking, I excel in creating impactful dashboards that enhance decision-making and operational efficiency, demonstrating creativity and a strong analytical mindset.
Overview
8
8
years of professional experience
Work History
Data Analyst
Aster Dm Healthcare
Gurugram
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
New Delhi01.2016
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
Timeline
Data Analyst
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)
Aprajita VishainAprajita Vishain
Deputy Manager- Product Management at Aster DM HealthcareDeputy Manager- Product Management at Aster DM Healthcare