MICHAEL LEE
Brea
Summary
Detail-oriented Data Analyst with experience in data visualization, statistical analysis, and predictive modeling. Skilled in translating complex datasets into actionable insights to support business decisions. Additionally experienced in IT support with hands-on expertise in network systems, data security, and technical troubleshooting.
Overview
3
3
years of professional experience
Work History
IT Support Specialist
TW Services, Inc.
Anaheim
08.2024 - Current
- Implemented a SQL-based mapping system to audit 30,000+ vendor invoices monthly, helping the Accounts Receivable team to identify and recover thousands of dollars in billing discrepancies
- Developed a Python script to automate the transfer of 1,500+ weekly badge activity records to SQL database
- Reorganized IT server room with 100+ devices, mapping all wired connections and physically labeling equipment to streamline troubleshooting and reduce downtime in case of outages
Internal Audit | Data Analyst
LPL Financial
San Diego
05.2023 - 05.2024
- Performed analytical work using SQL Server and Python during risk-based audits and operational reporting
- Automated the distribution of weekly email reports to 20+ control owners using Python, reducing manual reporting time by 80% and improving delivery consistency
- Authored detailed work papers and deliverables for 10+ audit projects, documenting code, findings, and outcomes to ensure transparency, traceability, and compliance with audit standards
IT Intern
TW Services, Inc.
Anaheim
06.2022 - 08.2022
- Integrated the company's new website onto their server by working on backend development using a WAMP stack (Windows, Apache, MySQL, PHP) and ensured full functionality of the site
- Accelerated work efficiency by implementing the use of GitHub within the company's IT department for easier collaboration between team members working on a project and quicker access to company files
- Devised a C# program to read a CSV file and parse the text for fields to be uploaded to MySQL database
Education
Bachelor of Science - Statistics, Emphasis in Data Science
San Diego State University
San Diego, CA08.2023
Skills
Python, SQL, BigQuery, R Studio, IT Networking, Tableau, Power BI, Java, HTML, SAS
Accomplishments
Global IT Academy - GITA Graduate
Brea, CA | 09/2015- 06/2019
- Completed a 4-year coding program, gaining proficiency in languages such as C#, HTML, JavaScript, and Java
- Coded 15 projects per year in each language, including interactive web applications, animations, and games
- Designed a personal website with HTML and JavaScript to showcase coding projects and assignments, demonstrating growth in technical skills and proficiency in web development
STEMpowerment Club - Founder & President
Brea, CA | 09/2016 - 06/2019
- Aligned a team of 20+ members to foster passion for science in youth community by conducting weekly STEM activities and lessons for K - 6th children at local Boys & Girls Club
- Created 50 project decks and presented to 30+ students each week, introducing them to the world of STEM
- Coordinated weekly meetings with board members to prepare for upcoming activities and discuss future goals
Boy Scouts of America - Life Scout
Placentia, CA | 08/2012 - 03/2019
- Awarded Life Scout rank by completing prerequisites, volunteering 500+ hours, and displaying a concrete understanding of the indispensable life skills and survival practices taught throughout Scouting career
- Mentored 10-15 Cub Scouts at annual Day Camp by educating them on wilderness awareness and survival skills
- Oversaw troop activities as patrol leader and collaborated weekly with the Scoutmaster and other patrol leaders to organize future meetings, merit badge days, and camping trips
Affiliations
Astronomy, Weightlifting, Music, PCs, Gaming, Snowboarding, Web Development, Fashion
Timeline
IT Support Specialist
TW Services, Inc.
08.2024 - Current
Internal Audit | Data Analyst
LPL Financial
05.2023 - 05.2024
IT Intern
TW Services, Inc.
06.2022 - 08.2022
Bachelor of Science - Statistics, Emphasis in Data Science
San Diego State University
Similar Profiles
Bennie Dominick BrownBennie Dominick Brown
EPJ Order Selector at TW ServicesEPJ Order Selector at TW Services
Denice SerranoDenice Serrano
CSR, Sales at Tw ServicesCSR, Sales at Tw Services
Amoz MontantesAmoz Montantes
Lumper at TW ServicesLumper at TW Services
Destiny Angel GarciaDestiny Angel Garcia
Police Service Officer at Brea Police DepartmentPolice Service Officer at Brea Police Department
Chase PreasmyerChase Preasmyer
Host at The Dugout Sports GrillHost at The Dugout Sports Grill