Learn Data Skills
Rachel Kim

Rachel Kim

Data Analyst



My Portfolio Highlights

My New Course

Introduction to Python

Data gardener, nurturing insights to bloom and thrive in the data ecosystem.

My Work

Take a look at my latest work.


Data Manipulation with pandas


Introduction to Python


Intermediate Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

ALTRES | Apr 2019 - Present

Data Analyst

• Perform exploratory data analysis on Salesforce, Microsoft Dynamics GP, PrismHR data to build visualizations using ggplot2/tidyverse/plotly. Feature Engineering over 100+ variables in Salesforce, present final findings using Tableau or SSRS • Maintain and transform raw data in SQL with end-to-end ETL methodology using landing/staging/production compartments. Managing over 75+ jobs and feeds – improving data quality and sustaining one centralized Data Warehouse • Create and maintain Tableau dashboards. Used to visualize new clients, employee count, salesperson gains/losses, salesforce counts, SUI, WC domains, displaying YoY margins that provided insight and improved ranking of clients from most to least profitable • Complete weekly ad hoc reports for department managers to assist in payroll, benefit plan renewals and accounting profit loss reconciliation reports using SSRS and SQL • Executed a company-wide internal time-tracking system by organizing demo sales calls, researching potential vendors, and orchestrating sandbox environments. Initiated an automated method to track active work time within Salesforce – creating new KPI metrics to improve duration measures which resulted in achieving better client report cards and assessment to find our top gainers. • Lead monthly status meetings and update executives on monthly progress, deadlines, ad-hoc requests follow-ups, and future projects. • Organize and conduct routine server updates and contract renewals for Tableau. Coordinate with managers and seniors to discuss potential licensing upgrades and negotiations. • Implement Python script using the win32, datetime and os library that automates grabbing attachments of flat csv files from outlook and run data schedules using .bat commands for automating 15% of ETL feeds.
Show More

ALTRES | Dec 2018 - Mar 2020

Payroll Coordinator

• Enforced SOC-1 certification by implementing audit procedures through internal records via the Salesforce platform • Sustained and expedited office productivity by controlling the traffic of emails, PrismHR, and Salesforce notifications which boots department efficiency • Facilitated client/employee service requests with unmatched customer service, which increase client retention and overall customer satisfaction • Resolved technical conflicts by providing end-user support when navigating in SimplictyHR, counseled over 100+ clients weekly in familiarizing clients with our product's payroll and human resource capabilities. • Authored and revised custom reporting per client request, arranged over 20+ scheduled reports which pioneered easy accessability of electronic documents for quarterlytax packets and audits

University of San Francisco | Jan 2015 - Jun 2018

Student Office Assistant

• Administers department's main email and telephone line, encountering over 400 calls daily • Represent the University and the Department of Public Safety and coordinates parking assistance for the Board of Trustees annual meeting • Manage parking files and budgeting transactions • Organizes confidential financial documentations • Recommend better organizational skills for the Department of Public Safety’s lost and found system which improved communication and record tracking methods • Assist over 100 students, staff, and faculty daily with account verification, lost and found items and parking permits • Manipulated a large amount of data and compiled a document that lists all faculty and staff that utilized Public Safety’s Shuttle & Safety Escort Services

Mission Economic Development Agency | Dec 2017 - May 2018

Practicum Student Intern

• Formulated questions for organization’s coordinators to better grasp the agency’s main goals and initialized a product idea • Clean and modified empty values of MEDA datasets into more workable data for explanatory data analysis by incorporating updated data from other credible resources • Presented results of data summaries and described findings in layman’s terms • Marketed our findings to the MEDA team by proposing which SFUSD elementary schools are most ideal. Formulated our findings through an end-of- year final presentation • Cohosted biweekly meeting with MEDA client and reoriented projects outcomes if there was a change in agenda • Collaborate on a d3 data visualization map of the SF Unified School elementary schools displaying the summary, performance and demographic of each school

AmeriCorps | May 2015 - Aug 2015

VISTA Summer Bridge Enrichment Program Intern

I was privileged enough to work under the AmeriCorps Summer Bridge program again for the summer of 2016. I served as a VISTA from May 2016 to August 2016 • Coordinated a self-budgeting lesson plan for high school freshmen • Integrated a Mock Career Fair and Mock Interview for high school freshmen • Arranged individual meetings with over 30 students with their academic progress • Tutored and assisted the Summer Bridge Algebra course • Taught students basic concepts of Mathematics • Supervised after-school community service campus clean up programs

My Education

Take a look at my formal education

Bachelor of Science (B.S.), MathematicsUniversity of San Francisco | 2018
High School Diploma Waipahu High School | 2014

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free