• 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.

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

Create Your Data Portfolio for Free