Summary
Overview
Work History
Education
Skills
Timeline
Generic

Pranita Karki

Business Data Analyst
Grand Rapids,MI

Summary

Results-driven Data analyst bringing proven skills in administering creative solutions. Resourceful and dedicated to utilizing interpersonal skills by building strong internal protocols and instilling culture of responsibility and attentiveness.

Overview

4
4
years of professional experience
7
7
years of post-secondary education

Work History

Business Data Analyst

Health One Alliance
Dalton, GA
10.2021 - Current
  • Troubleshooted and improved exisiting ICHRA model which provides employers summary of their insurance plans' expenditure.
  • Developed python script that handles the process of electronic payments.
  • Built SQL table that assisted in GeoAccess project.
  • Built R script to identify competitors network.

Business Intelligence Intern

Priority Health
Grand Rapids, MI
05.2021 - 08.2021
  • Worked in collaborative, cross-functional team to ensure accuracy and quality of reporting.
  • Analyzed data for quality assurance by writing SQL code for Health Check data which resulted in an increase in members during Covid-19.
  • Created excel visualization that aided the data for Health Check report.
  • Created custom tables by joining and filtering preexisting database tables.
  • Analyzed data for Medication Therapy Management project to provide members with comprehensive medical review which supports business decision by modifying targeting list.
  • Created tableau dashboards for data visualization for Medication Therapy Management project.

Graduate Assistant

Seidman College Of Business
Grand Rapids, MI
08.2019 - 04.2021
  • Gathered, reviewed, and summarized literature from scientific journals such as Wiley Online Library
  • Provided comprehensive research assistance and support when designing and executing experiments.
  • Cataloged data into MySQL database.
  • Assisted in data analysis and data visualization using mostly power BI, Excel, SQL, SPSS and R depending on the faculty and type of data.
  • Lead a project in Seidman College of Business’s Dean’s Office to figure out proper utilization of resources: Analyzed data to find out how much time per week a classroom was occupied in a semester.
  • Developed a database using basic normalization techniques and used this database to drive PowerBI reports.
  • Worked with huge excel files using basic DAX queries to summarize course evaluations for a semester.
  • Analyzed data of stock prices by merging two datasets that resulted in a positive impact on stock prices of the products advertised in Superbowl based on audiences’ facial reaction.
  • Assisted to create predictive model for a research paper that explores how cross-functional integration among different areas of a company’s internal supply chain influences the firm’s performance.

Social Media Officer

Sastodeal.com
Kathmandu
11.2016 - 06.2018
  • Developed marketing content such as blogs, promotional materials and advertisements for social media.
  • Analyzed and reported social media and online marketing campaign results.
  • Monitored online presence of company's brand to engage with users and strengthen customer relationships.
  • Engaged online audiences by placing strong focus on sales process support and responding to inquiries and comments timely and knowledgeably.
  • Created an interactive platform for customers in order to increase website clicks and returning customers.
  • Planned and instituted social media marketing plan for clients in various industries.
  • Increased customer engagement through social media.
  • Created and facilitated interactive online contests to retain members and attract new members.
  • Planned regular posting schedule to maximize online interaction Communicate and collaborate with Marketing Department during social media campaigns with the goal of reaching and creating more customers.
  • Used Excel to track consumer engagement and draw conclusions about user data.

Education

Master of Science - Data Science And Analytics

Grand Valley State University
Allendale, MI
01.2019 - 08.2021

Bachelor of Science - Information Science

Visvesvaraya Technological University(VTU)
Belgaum, India
07.2012 - 07.2016

Skills

    R Studio

Python

Microsoft SQL Server

Power BI

Tableau

SPSS

Problem-Solving

Flexible and Adaptable

Timeline

Business Data Analyst

Health One Alliance
10.2021 - Current

Business Intelligence Intern

Priority Health
05.2021 - 08.2021

Graduate Assistant

Seidman College Of Business
08.2019 - 04.2021

Master of Science - Data Science And Analytics

Grand Valley State University
01.2019 - 08.2021

Social Media Officer

Sastodeal.com
11.2016 - 06.2018

Bachelor of Science - Information Science

Visvesvaraya Technological University(VTU)
07.2012 - 07.2016
Pranita KarkiBusiness Data Analyst