Viviek Bhatiyaa — Operations Associate

Most dashboards show numbers. Good dashboards explain what to do next. I’m a Power BI Developer & Data Analyst (PL-300 certified) with hands-on experience in SQL, DAX, data modeling, and interactive dashboard development — focused on turning raw data into clear, actionable business insights. I work closely with business and healthcare stakeholders to design performance-driven Power BI dashboards, optimize DAX measures, and build clean, scalable data models that support fast and accurate decision-making. 🏥 Healthcare RCM Experience In the Healthcare Revenue Cycle Management (RCM) domain, I’ve worked on: AR, Denials, Payments & Follow-ups analysis KPI dashboards for operational & financial performance Data validation, reconciliation & reporting accuracy 🛠 Tools & Skills Power BI | DAX | SQL | Data Modeling | Excel | Python | Tableau | Healthcare Analytics | Business Intelligence 📌 What you’ll find on my profile I regularly share: Power BI & DAX concepts explained simply Interview-focused DAX differences Real-world dashboard and time-intelligence insights If you’re: ✔️ Preparing for Power BI / Data Analyst interviews ✔️ Working on real-world dashboards ✔️ Looking to improve DAX & data modeling skills 👉 Follow my profile for practical Power BI learning. I’m open to Data Analyst / Power BI Developer roles and freelance BI projects where data is used to drive decisions — not just reports. 📩 Feel free to connect or message me.

Stackforce AI infers this person is a Data Analyst specializing in Healthcare Analytics and Business Intelligence.

Location: Chandigarh, India

Experience: 3 yrs 8 mos

Skills

Microsoft Power Bi
Dax
Data Analysis
Commercial Insights
Data Analytics
Customer Targeting
Data Visualization

Career Highlights

Expert in Power BI dashboard development.
Strong background in healthcare analytics.
Proficient in DAX for actionable insights.

Work Experience

Coronis IT Systems Pvt. Ltd

Junior Analyst (1 yr 2 mos)

Quantium

Data Analytics Intern (8 mos)

KPMG India

Data Analytics Consulting Intern (8 mos)

Accenture

Data Analytics and Visualization Intern (1 mo)

Tata Group

Data Visualisation intern (1 mo)

PwC Switzerland

Power BI Virtual Intern (1 mo)

Freelance

Autocad Designer | Autocad, Stadd pro, Primavera, Etabs and Excel (2 yrs 6 mos)

TDI INFRATECH LTD

Civil Engineering Intern | Autocad, BBS, Acounting,Project Management,Reporting (3 mos)

Education

Bachelor's of Technology (B.Tech.) at CAREER POINT UNIVERSITY, HAMIRPUR

Viviek Bhatiyaa

Operations Associate

Chandigarh, India3 yrs 8 mos experience

Key Highlights

Expert in Power BI dashboard development.
Strong background in healthcare analytics.
Proficient in DAX for actionable insights.

Stackforce AI infers this person is a Data Analyst specializing in Healthcare Analytics and Business Intelligence.

Contact

Skills

Core Skills

Microsoft Power BiDaxData AnalysisCommercial InsightsData AnalyticsCustomer TargetingData Visualization

Other Skills

CALCULATING MEASURESDEFINING KPISINSIGHT AND ACTIONSPOWER BI DASHBOARDSELF-REFLECTIONpower bi daxMicrosoft ExcelPower BIData ModelingCOMMERCIAL THINKINGDATA VALIDATIONPROGRAMMINGSTATISTICAL TESTINGANALYTICAL DASHBOARD CREATIONCUSTOMER SEGMENTATION

About

Experience

3 yrs 8 mos

Total Experience

1 yr 9 mos

Average Tenure

Current Experience

Coronis it systems pvt. ltd

Junior Analyst

May 2024 – Jul 2025 · 1 yr 2 mos · Mohali district, India · On-site

Utilized Power Query for cleaning and shaping raw AR & billing data, ensuring consistency and accuracy across claim records.
Integrated multiple data sources including SQL Server, Excel files, OneDrive Excel files, and SharePoint resources into Power BI for unified and scalable reporting.
Applied transformations such as merging queries, creating custom columns, and implementing error-handling logic for robust ETL processes.
Designed a star schema with fact tables (Claims, Payments) and dimension tables (Providers, Payers, Dates), improving query performance and scalability.
Created relationships, hierarchies, and role-playing dimensions to enable flexible reporting across different AR perspectives.
Implemented calculated columns and measures in DAX to support business rules like claim status, payment timelines, and overdue classification.
Engineered advanced DAX measures for KPIs such as AR Pay $ Value, Claim Aging Buckets, Payment Received %, enhancing AR performance tracking.
Developed time intelligence functions (DATEADD, DATEDIFF, SAMEPERIODLASTYEAR) to support trend analysis and month-over-month comparisons.
Applied filter context & row context logic for dynamic calculations, ensuring accurate claim categorization.
Built an interactive Power BI dashboard displaying KPIs such as Claim Age, Account Count, AR Payments, Inflow, Backlog, Trends, tailored for executives.
Applied conditional formatting, drill-through, slicers, and bookmarks for enhanced user interactivity.
Designed role-specific report views enabling finance teams, billing teams, and leadership to access relevant insights.
Published reports to Power BI Service, configured scheduled refresh using an on-premises data gateway, and set up data source credentials.
Implemented Row-Level Security (RLS) to restrict data visibility by payer/provider teams while maintaining governance.

Microsoft Power BICALCULATING MEASURESDEFINING KPISINSIGHT AND ACTIONSPOWER BI DASHBOARDSELF-REFLECTION+3

Quantium

Data Analytics Intern

May 2023 – Jan 2024 · 8 mos · Remote

Completed a job simulation focused on Data Analytics and Commercial Insights
for the data science team.
Developed expertise in data preparation and customer analytics, utilizing
transaction datasets to extract valuable insights and deliver data-driven
commercial recommendations.
Extended analytical capabilities to identify benchmark stores for conducting
uplift testing on trial store layouts, enabling evidence-based
decision-making.
Leveraged acquired data analytics and insights from previous tasks to create
comprehensive reports for the Category Manager, facilitating informed
strategic decisions and enhancing commercial applications.

COMMERCIAL THINKINGDATA ANALYSISDATA VALIDATIONPROGRAMMINGSTATISTICAL TESTINGData Analysis+1

Kpmg india

Data Analytics Consulting Intern

May 2023 – Jan 2024 · 8 mos · Remote

Completed a simulation focused on advising a client on customer targeting with the Data, Analytics & Modelling team
Assessed data quality and completeness in preparation for analysis
Analysed data to target high-value customers based on demographics and attributes
Developed dashboards to communicate findings with visuals

ANALYTICAL DASHBOARD CREATIONCUSTOMER SEGMENTATIONDATA ANALYTICSPRESENTATIONSDATA QUALITYData Analytics+1

Accenture

Data Analytics and Visualization Intern

May 2023 – Jun 2023 · 1 mo · Remote

Completed a simulation focused on advising a hypothetical social media client
as a Data Analyst at Accenture
Cleaned, modelled and analyzed 7 datasets to uncover insights into content
trends to inform strategic decisions
Prepared a PowerPoint deck and video presentation to communicate key insights
for the client and internal stakeholders

DATA ANALYSISDATA MODELINGDATA UNDERSTANDINGPROJECT PLANNINGSTORYTELLINGTEAMWORK+2

Tata group

Data Visualisation intern

May 2023 – Jun 2023 · 1 mo · Remote

Completed a simulation involving creating data visualizations for Tata
Consultancy Services
Prepared questions for a meeting with client senior leadership
Created visuals for data analysis to help executives with effective decision
making

ANALYSIS & PRESENTATIONCHARTS & GRAPHSDASHBOARDDATA CLEANUPDATA VISUALISATIONData Visualization+1

Pwc switzerland

Power BI Virtual Intern

Apr 2023 – May 2023 · 1 mo · Remote

Completed a job simulation where I strengthened my PowerBI skills to better
understand clients and their data visualisation needs.
Demonstrated expertise in data visualization through the creation of Power BI
dashboards that effectively conveyed KPIs, showcasing the ability to respond
to client requests with well-designed solutions.
Strong communication skills reflected in the concise and informative email
communication with engagement partners, delivering valuable insights and
actionable suggestions based on data analysis.
Leveraged analytical problem-solving skills to examine HR data, particularly
focusing on gender-related KPIs, and identified root causes for gender
balance issues at the executive management level, highlighting a commitment
to data-driven decision-making.

Power bipower bi daxpower pointCALCULATING MEASURESDEFINING KPISINSIGHT AND ACTIONS+4

Freelance

Autocad Designer | Autocad, Stadd pro, Primavera, Etabs and Excel

Apr 2021 – Oct 2023 · 2 yrs 6 mos · India · Remote

Collaborated with 20+ clients for the gathering the project requirements and created 2D house plans and structural plans of buildings
Prepared quantity estimates and bills with 100 percent accuracy

Tdi infratech ltd

Civil Engineering Intern | Autocad, BBS, Acounting,Project Management,Reporting

Jan 2020 – Apr 2020 · 3 mos · Mohali district, India · On-site

Utilized MS Excel to create bar bending schedules and quantity estimates, reducing steel wastage by 80%.
Fostered effective teamwork and knowledge sharing across cross-functional teams.