Vivek Bhatia

About Vivek Bhatia

I am Vivek Bhatia, a proactive and detail-oriented Data Analyst with a robust skill set in data analysis, statistical modeling, and business intelligence tools including SQL, Python, Excel, Tableau, and Power BI. With a background in Civil Engineering, I excel in transforming complex data into actionable insights that drive strategic decision-making. In my role at Quantium as a Data Analytics Intern, I developed expertise in statistical analysis, data visualization, and dashboard reporting, contributing to evidence-based commercial recommendations. At KPMG India, I specialized in SQL-driven data mining and predictive analytics to target high-value customer segments. My internships at Accenture, Tata Group, and PwC Switzerland strengthened my proficiency in machine learning, quantitative analysis, and ETL processes, enabling me to deliver insightful solutions and communicate findings effectively to stakeholders. Armed with a Bachelor\'s degree in Civil Engineering from CAREER POINT UNIVERSITY, HAMIRPUR, and certifications in Data Analytics and Visualization, I am skilled in database management, data warehousing, and agile project management methodologies. I possess strong problem-solving abilities, critical thinking skills, and business acumen, coupled with a collaborative approach and excellent communication skills. Let\'s connect to discuss how my comprehensive skill set and passion for data analysis can contribute to the success of your team and organization.

Experience

1. Junior Analyst

   Coronis It Systems Pvt. Ltd

   May 2024 — Present · Mohali district, IN

   Developed and implemented advanced DAX measures and calculated columns to support Revenue Cycle Management (RCM), focusing on medical billing and accounts receivable (AR) in the healthcare industry. • Built dynamic DateDifference and DateStatus logic to track claim aging, status, and payment timelines. • Utilized DATEDIFF(), IF(), and RELATED() functions to calculate key date differences, enhancing real-time claim tracking. • Implemented custom Aging Categories to identify overdue payments and trends in AR aging, improving cash flow management. • Designed metrics like AR Pay $ Value and Payment Received Through AR % to evaluate payment recovery efforts and AR performance. • Applied advanced DAX functions including SWITCH(), CALCULATE(), and DIVIDE() to create flexible business logic based on aging criteria and thresholds. • Optimized data modeling and report performance by designing a star schema, improving query efficiency and scalability. • Created an interactive Power BI dashboard to visualize KPIs such as Claim Age, Number of Accounts, and Overall Payment Value for management and stakeholders. • Collaborated with cross-functional teams to gather accurate data and ensure result-driven insights aligned with business and operational goals. • Handed over the final report to the team leader, who presented it during a client meeting. The project was approved for monthly data updates and payment tracking. • Published the report on Power BI Service, enabling real-time updates via the server. The interactive dashboard helps the client easily monitor payment status and performance throughout the process. • Project is currently ongoing and under regular maintenance to ensure up-to-date reporting and decision support.

Education

• CAREER POINT UNIVERSITY, HAMIRPUR

  Bachelor's of Technology (B.Tech.), Civil Engineering