DINESHKUMAR M
POWER BI DEVELOPER
Chennai
Summary
Dedicated Data Analyst with over 4+ years of experience. I am eager to apply my diverse skills and analytical expertise to the data analyst position at your company. My solid background in data analysis positions me as a valuable asset for your organization
Overview
4
4
years of professional experience
3
3
years of post-secondary education
3
3
Languages
Work History
Power BI Developer
Swag Tech Solutions
Chennai
07.2020 - Current
- Having 4+ years of experience in BI tools like Power BI Desktop, Power BI Service, and SQL Server.
- Hands on experience on Power BI Desktop and Power BI Service. Development and worked on Creating Reports & Dashboards.
- Developed effective Reports & Dashboards and Worked on existing dashboards and done enhancements as per the Clients Requirement. Designed Data Modeling and Maintained relationships between data using different Joins.
- Determined business critical priorities and their requirements including financial, expenditure, revenue, sales, customer, products data.
- Defined KPI's to gauge the company's overall long term performance.
- Writing reports to share knowledge gained from the complied data
- Cleaning the data and improving the data quality by removing duplicates, errors, or outliers
- Skilled in writing complex DAX formulas to derive meaningful insights from raw data.
- Experience in extracting, transforming, and loading data from diverse sources using Power Query, SQL, and other data integration tools.
- Familiarity with integrating Power BI with various data sources such as Excel, SharePoint, SQL Server, and cloud platforms like Azure.
- Experienced in creation of Appending and Merging Queries.
- Published and Shared Reports into Power BI Service.
- Installing & Configuring a Gateway Connectivity and giving access to OnPremises data Gateway.
- Experienced in deployment and scheduling refresh.
- Experienced in SQL queries relevant to Power BI.
Education
Bachelor of Science - Mathematics With Computer Applications
D.G.Vaishnav College
Chennai, India 05.2017 - 04.2020
Skills
POWER BI DESKTOP
POWER QUERY EDITOR
POWER BI SERVICE
DAX
DATA MODELING
DATA VISUALIZATION
SQL SERVER
ORACLE
MS OFFICE
PROJECT 1
DOMAIN: SALES Pharma
CLIENT: Merck & Co
ENVIRONMENT: Power BI and SQL Server
DESCRIPTION:
- The purpose ofthis dashboard isto analysisthe key KPImatrices ofthe Merck &co. Production industriestomonitor and understand the financialfigures of the Pharma".
ROLES AND RESPONSIBILITY:
- Gathered business requirements from users and converted them to technical specifications by building dashboards and reports.
- Converted businessrequirementsinto technicalspecifications and decide timeline to accomplish
- Created relationships between data and develop tabular and other multidimensional data models.
- Experienced with Power BI Data Modelling and Customized, built data model regions.
- Received support and advice from consultants who are already working at our Clients site
- Transformed raw data into valuable and meaningful insights in the form of appealing dashboards and reports
- Creation of Power BI filter like visual level filter and page level filter
- Built Measures and Calculated columns using DAX.
- Implemented row-level security in Power BI workspaces
- Charted creation and data documentation explaining parameters, models, and relations.
- Developed Power BI reports and dashboards from multiple data sources and publish them on Power BI Service.
Additional Information
DOMAIN: Healthcare
CLIENT: MedCare Hospitals
ENVIRONMENT: Power BI and SQL Server
DESCRIPTION:
- MedCare Hospitals is a network of healthcare facilities specializing in comprehensive patient care across multiple specialties. The project involved analyzing patient demographics, treatment outcomes, and operational efficiency metrics to improve healthcare delivery.
ROLES AND RESPONSIBILITY:
- Extracted and integrated data from Electronic Health Records (EHR) systems and operational databases using SQL Server.
- Developed interactive dashboards in Power BI to visualize key performance indicators (KPIs) such as patient wait times, bed utilization rates, and readmission rates.
- Implemented predictive analytics models to forecast patient admission rates and optimize resource allocation. Collaborated with healthcare professionals to translate data insights into actionable strategies for enhancing patient care and operational workflows.
- Collaborated with healthcare professionals to translate data insights into actionable strategies for enhancing patient care and operational workflows.
- Conducted data quality assessments and implemented data cleansing processes to ensure accuracy andreliability of reporting
Timeline
Power BI Developer
Swag Tech Solutions
07.2020 - Current
Bachelor of Science - Mathematics With Computer Applications
D.G.Vaishnav College
05.2017 - 04.2020
Similar Profiles
SHABEER ASHABEER A
DevOps Engineer at SWAG TECH SOLUTIONSDevOps Engineer at SWAG TECH SOLUTIONS
Megan KirkMegan Kirk
Front Desk Receptionist at Salon SwagFront Desk Receptionist at Salon Swag
Armaan ChaudhryArmaan Chaudhry
SENIOR SALES CONSULTANT at Go SwagSENIOR SALES CONSULTANT at Go Swag