Summary
Work History
Education
Skills
Timeline
Generic

Praveen Karunanithi

Vellore

Summary

Seeking a fulfilling position in challenging and dynamic field of data analytics that offers growth opportunities and allows me to utilize and enhance my skills, experience and abilities while being resourceful, innovative and flexible.

Work History

Team Lead BI Analyst

AGS Healthcare
Vellore
  • Working as Team Lead BI Analyst at AGS Healthcare, Vellore with overall 6 years of experience with Health Care, Data Analysis and Finance domain knowledge in handling data to generate and prepare a data visualization using Power BI
  • Knowledge in SQL querying, connecting and exporting the data from various data sources
  • Develop Dashboards and KPIs using MS Power BI platform and publish schedule reports and dashboards to meet the business requirements
  • Created constructive and interactive dashboards and enhanced the existing dashboards as per client requirements
  • Created effective Data Modelling, filters and slicers as per client requirements
  • Created roles to implement Security (RLS) for the Reports
  • Used DAX expressions like Logical, Aggregate, and Time Intelligence & Date Functions based on requirements
  • Experienced in creating the hierarchy to drill down, drill through the reports and cross report drill through
  • Performed various level of testing which includes unit testing functional, regression, integration and performance testing
  • Created and updated the task in Jira as a ticket tracking tool and confluence as a documentation
  • Having good skills in trouble shooting On-Premises Gateway to refresh the dashboards/ reports.

Data Analyst

AGS HEALTHCARE
Vellore
  • Developed and implemented interactive dashboards in Power BI for the Clinical project, offering stakeholders real-time access to valuable insights on clinical trial data
  • Defined KPIs measuring company's long-term performance
  • Delivered reports to the business team in a timely manner
  • Contributed to the development of Clinical Trials Overview Dashboard
  • Integrated data from multiple sources, including EHR (Electronic Health Records) & Clinical Trial data bases to create a comprehensive view of Trial data
  • Provided training and support to users to ensure they could effectively utilize the dashboard for their clinical data analysis needs.
  • Maintained documentation of all the activities related to Business Intelligence Solutions.
  • Maintained up-to-date knowledge of current trends in Business Intelligence technologies.

BI Data Analyst

AGS HEALTHCARE
Vellore
  • Presented the analysis to internal and external teams and Explained data from a sales perspective and relevance to Key Performance Indicators (KPI)
  • Delivering reports to Sales team on timely manner
  • Created calculated columns and measures using Dax and prepared report and dashboards in power bi
  • Built Pages with Slicers for Quick filters, Generated Report Level filters while handling huge volumes of data
  • Executed and tested the required queries and reports before publishing the dashboard
  • Implemented Role Based Security as part of user level security in Power BI
  • Designing and developing Power BI scripts for importing data from Source.

LEAD BI ANALYST

AGS HEALTHCARE
Vellore
  • Extracting data from multiple sources like flat files, Excel, Oracle and SQL server and validating data and loading into Final Destination
  • Creation of POWER BI Filter like visual Level filters and page level filters
  • Created Dashboards and applied Drill down Drill through functions and created tooltip on sheet level as per requirement and create drill down and drill through reports
  • Working on DAX functions like Date & Time, Information, Filter & Value, Logical, and Text
  • Working with gateways and scheduling the refresh and Creating reports and dashboard
  • Updating weekly status and keeping track of overall development status for the project
  • Participating Weekly, Daily and Ad-hoc meetings
  • Experience in performance analyzer for performance tuning and query optimization.
  • Identified opportunities for improvement in existing database structures and querying techniques.
  • Evaluated employee performance regularly and provided feedback as needed.

Education

B.C.A (Computer Application) -

S.S.S College of arts and science

Skills

  • Power BI Desktop
  • Power Query Editor
  • Power BI Service
  • Business Intelligence
  • Data Modelling
  • Dax Queries
  • SQL
  • Data visualization

Timeline

Team Lead BI Analyst

AGS Healthcare

Data Analyst

AGS HEALTHCARE

BI Data Analyst

AGS HEALTHCARE

LEAD BI ANALYST

AGS HEALTHCARE

B.C.A (Computer Application) -

S.S.S College of arts and science

Similar Profiles

  • Subhiksha Sivakumar

    Subhiksha SivakumarSubhiksha Sivakumar

    Senior AR Caller at Ags healthcareSenior AR Caller at Ags healthcare

    View Profile
  • Radhakrishna Goud

    Radhakrishna GoudRadhakrishna Goud

    Quality Analyst at AGS HealthcareQuality Analyst at AGS Healthcare

    View Profile
  • Mohammed Ashik Babu

    Mohammed Ashik BabuMohammed Ashik Babu

    AR Caller at AGS HealthcareAR Caller at AGS Healthcare

    View Profile
Praveen Karunanithi