Andrew Tran
Milpitas,CA
Summary
A highly motivated and results-driven individual seeking to apply expertise in data analysis, data processing, data governance and reporting to increase the efficiency and accuracy of data processing leading to growth and success.
Overview
4
4
years of professional experience
Work History
Data Analyst
The Surplus Lines Association of California (SLA)
03.2024 - Current
- Review and reconcile source documents against database reports to identify discrepancies, ensuring accuracy, completeness, and compliance with established policies; implement necessary corrections and escalate significant issues to Lead Analysts.
- Analyze broker performance data using Excel to identify trends in filing errors and assess premium volume, supporting targeted outreach and process improvements.
- Collaborate with Lead Analysts to support brokers with electronic filing and surplus lines procedures, providing clear guidance and timely issue resolution.
- Respond promptly to broker inquiries, monitor open issues through resolution, and escalate complex matters to management when appropriate.
- Maintain and apply knowledge of surplus lines laws, regulations, and filing requirements to ensure compliance.
- Contribute to system enhancements by identifying issues, participating in testing, and supporting implementation of fixes.
- Meet established productivity and quality performance metrics.
Data Analyst Intern
OneWorkSolutions
San Francisco, CA
06.2023 - 01.2024
- Collected and cleaned large datasets for analysis.
- Developed and implemented automated data cleaning processes.
- Conducted analysis and reporting, which led to the identification of cost-saving opportunities.
- Communicated findings and recommendations in a clear and concise manner, resulting in an increased adoption rate of suggested improvements.
- Collaborate with team members to develop and implement data-driven solutions to business problems.
IT Analyst
First Republic Bank
San Francisco, CA
04.2022 - 06.2023
- Provide problem determination and technical assistance to users; escalate and coordinate problem resolution activities; perform help desk functions.
- Research, analyze and test application and system software for compatibility and capability to specific job applications and assignments; Image desktops, laptops, and company-provided phones for user deployment.
- Work collaboratively in teams and effectively communicate orally and in writing using logic and analysis to solve computer and system problems.
- Collaborated with other IT departments such as Network, Server, Messaging, and Desktop Engineering to help resolve technical issues.
- Troubleshoot and resolve technical issues related to audio-visual equipment and conference room setups using Zoom and Cisco Telepresence.
- Imaged and deployed over 2300 laptops during the start of the pandemic to ensure colleagues were fully able to work from home during a Win 10 Migration Project.
Education
Bachelor of Science - Management Information Systems
California State University - Chico
Chico, CASkills
- SQL
- SAP
- Java
- Tableau
- Microsoft Office Suite
- Python
- Data Visualization
- ServiceNow
- Microsoft System Center Configuration Manager (SCCM)
- Microsoft Active Directory
Timeline
Data Analyst
The Surplus Lines Association of California (SLA)
03.2024 - Current
Data Analyst Intern
OneWorkSolutions
06.2023 - 01.2024
IT Analyst
First Republic Bank
04.2022 - 06.2023
Bachelor of Science - Management Information Systems
California State University - Chico