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