Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Timeline
Generic

RAJEEV GOWLIKAR

Louisville,USA

Summary

Data Analyst with 3+ years of experience in healthcare claims processing and data management. Proficient in SQL, Python, Tableau, and Power BI, specializing in ETL development, data extraction, modification, validation, and reporting. Experienced in managing large datasets, identifying trends, and providing actionable insights to improve organizational processes. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Data Analyst (claims)

Elevence Health, Anthem
12.2020 - 10.2023
  • Optimized client engagement strategies, notably with Elevance Health, leveraging AI to improve client satisfaction scores by 25%
  • Utilized SQL and Python for efficient data extraction, and created comprehensive visual reports on performance, updates, and escalations using Power BI and Tableau
  • Streamlined claims processing, ensured data accuracy, and optimized patient record management by integrating ERP systems with traditional healthcare operations, including billing and resource allocation
  • Applied SAS to analyze and transform healthcare data into actionable insights for claims processors, maintaining compliance and improving overall operational efficiency
  • Resolved 2000+ claims, proving claims quality by reducing resolution time by 20%, and processed 15,000 claims monthly using FACETS, ensuring accurate reimbursement
  • Awarded the Impact Award (2022, 2023) for 100% accuracy and production, recognized for Excellent Quality management problem-solving skills and innovation in claims management
  • Monitored and analyzed Healthcare Key Performance Indicators (KPIs) to assess organizational performance, improve patient outcomes, ensure compliance with standards, and identify areas for improvement.

Marketing Data Analyst Intern

N Digital I360
06.2020 - 11.2020
  • Collected and preprocessed data from marketing campaigns, social media, and website analytics to ensure data accuracy.
  • Created and maintained dashboards and visualizations in Excel, Tableau, and Power BI to present insights to the marketing team.
  • Analyzed digital advertising, email marketing, and social media campaigns, identifying key performance indicators (KPIs) to optimize results.
  • Conducted market research and customer segmentation, enhancing targeted marketing strategies and improving lead acquisition.
  • Collaborated with sales, product, and finance teams to align marketing strategies with business objectives, driving data-driven decisions.

Education

Master of Science - Business Analytics

University of Louisville
Louisville, KY
12.2024

Bachelor of Science -

St.Joseph's Degree College Affiliated By OU
Hyderabad, India
08.2020

Skills

  • Python, C/C, SQL, Java, R
  • Microsoft Office Suite, SQL Server Management Studio (SSMS), NoSQL, Tableau, Power BI, SAP, Linux/Unix, AWS, Jupyter, NumPy, Pandas
  • MySQL, PostgreSQL, SQL Server, MongoDB, NoSQL Databases
  • Agile, Eclipse, GIT, JIRA
  • Data Modeling, Data Warehousing, Data Modeling, Data quality assurance processes, Data Mining, Data Visualization and Presentations, and Database Management
  • Marketing Analytics, Data-driven decision-making, Customer Segmentation, ROI Analysis, and Predictive modelling
  • Business Needs Analysis, A/B Testing, Report Preparation, NoSQL Databases, Google Analytics
  • Claims Technologies, Fraud Detection, Predictive Analytics

Websites

Certification

  • Certificate in Digital Marketing from UpGrad, Generative AI Digital Marketing, Developed and hosted a Swiggy Food Delivery App blog on WordPress, optimized, ran ads, and analyzed performance insights.
  • Data Analytics, Data Visualization from Data Camp ,SAS-University of Louisville Joint Certificate in Data Analytics
  • Google Analytics Certification and Facebook Certification
  • Diploma in Fitness, 2020, Certificate in Theater Arts from Samahara Acting School 2023

Projects

Healthcare Business analyst-FACETS-claims application, I worked on optimizing the Facets claims application, which handles the entire lifecycle of healthcare claims from submission to reimbursement. R for Analytics-Final project, Developed an R function for EPL data analysis, calculating league standings and handling data variations and inconsistencies. Deep Learning Final project, Binary Classification of Mushroom Data presented on the Cleaned dataset using modal imputation, one-hot encoding, and Z-score for binary classification. Classified mushrooms into edible and poisonous categories using various techniques.

Timeline

Data Analyst (claims)

Elevence Health, Anthem
12.2020 - 10.2023

Marketing Data Analyst Intern

N Digital I360
06.2020 - 11.2020

Master of Science - Business Analytics

University of Louisville

Bachelor of Science -

St.Joseph's Degree College Affiliated By OU
RAJEEV GOWLIKAR