Michael Mariposa
Analyst
Project Name: DCFM
Role: A/R Data Entry Analyst
June 2024 – Present
Role Description:
Monitoring and reviewing deposits, receivables, and corrections.
Researching open receivables greater than 30 days.
Create progress reports to resolve assigned responsibilities.
Other duties as assigned.
Creating Reports for Accounts Receivable
Previous Experience
Company Name: Tri-Starr Talent
Client Name: Bandera Electric Cooperative
Project Name: Apolloware Data Fixes and Firmware Upgrade Role: Data Analyst
April 2024 – June 2024
Role Description:
Ran analyses on the data provided to customers that subscribed to the Apolloware power usage tracking system and made notes about the graphs that were produced.
Corrected the inversion on Current Transducers remotely when the analyses deem that the power being used didn’t make sense.
Recommended site visits when analyses deemed that current transducers weren’t clamped properly.
Upgraded firmware on egauges that track power usage for apolloware before they shipped out to another cooperative in Oklahoma.
Company Name: Robert Half
Client Name: Jubilee Academies
Project Name: Jubilee Excellence Initiative and Substitute Spending Reduction Role: IT Data Analyst
November 2023 – December 2023
Role Description:
Ran the Jubilee Excellence Initiative to pay teachers bonuses. Ran Machine Learning algorithms to find the best predictor of STAAR test scores for a teacher’s students to give greater weight to the better predictors and give less weight to lower correlating predictors.
Ran Analyses on the various Jubilee Academies campuses to determine when and which teacher were taking the most days off to determine how to reduce the amount of money spent on substitute teachers.
2 P a g e
Used Qualtrics to create dashboards to monitor Student attendance data and various other data created on a regular basis by the school system.
Used R to format data for Data Engineering purposes. Company Name: Robert Half
Client Name: RSM US
Project Name: Workday Transition and Integration
Role: Data Specialist
June 2023 – October 2023
Role Description:
Worked on the Master Data Management (MDM) program for RSM and the transition from peoplesoft to workday. Pulled reports from MDM SQL to upload into Workday. Pulled reports from Workday to validate it with the data in the MDM database and upload the corrections that were required.
Created an ERD for the entirety of RSM’s MDM database for future use.
Ran daily reports to ensure the progress on the workday integration and transition was going well and errors were being reduced.
Ran the service desk for MDM.
Created an Access database for client data in Workday. Company Name: Linebarger Goggan Blair and Sampson LLP Role: Production Analyst
April 2023 – May 2023
Role Description:
Ran SQL reports to ensure that the delinquent tax data was correct in our Oracle Fusion Middleware system.
Uploaded delinquent tax data into Oracle Fusion Middleware.
Prepared data files using Microsoft Access before they were uploaded. Professional highlights
Data Analysis – General analysis of data, and reporting. 1 year throughout all jobs.
Data Entry – Inputting data, making notes, or manually editing data. 1 year throughout all jobs. System Experience
General Tools:
MS SQL – Advanced
3 P a g e
Python – Intermediate
Pandas (python library) – Intermediate
Numpy (python library) – Advanced
Scikit (python library) – Intermediate
R (Programming Language) – Advanced
ggplot (R library)– Advanced
Microsoft Excel – Advanced
Microsoft Word – Advanced
Microsoft Outlook – Intermediate
Git/Github – Intermediate
Machine Learning Algorithms – Intermediate
Power BI – Intermediate
Tableu – Intermediate
Qualtrics Dashboarding – Intermediate
Education
Bachelors of Science, Mathematics
University of Texas at Austin, Austin, TX
Master’s of Science, Data Science (Ongoing)
University of Texas at Austin, City, State
Foreign Languages Skill
Japanese