Lan Tran
Highland,CA
Summary
Passionate and dedicated Business Analyst with proven expertise in data analysis, statistical modeling, and business systems optimization. Adept at translating complex data into actionable insights through advanced analytics tools such as SQL, Python, and Power BI. Offering a strong background in requirements gathering, end-user acceptance testing, and process mapping. Seeking to leverage my skills in data-driven decision-making as a Health Systems Analyst at the Department of Behavioral Health (DBH) in San Bernardino County, where I can contribute to program evaluations, research studies, and advanced analytics initiatives. Project management-centered business analyst with three years of experience in the Data Science field. Strongly adept at manipulating pivot tables for advanced reporting, project planning, information analysis, and clear client communication. Highly proficient with administration tasks centered around projects and objectives.
Overview
4
4
years of professional experience
Work History
Management Associate - Business Analyst
Carrington Mortgage Holdings LLC
05.2021 - Current
- Leveraged SQL, Python, and other tools for technical/analytic systems analysis, focusing on data manipulation, transformation, and validation to produce actionable insights
- Conducted requirements gathering, end-user acceptance testing, and process mapping to improve and monitor system functionalities
- Developed and presented reports using data visualization tools like SSRS and Power BI
- Reports included both statistical analysis and business metrics, which were used for decision-making
- Synthesized and integrated data from 16 company-wide data repositories to create a unified customer knowledge database, ensuring data accuracy and adherence to business rules.
- Performed extensive data exploration, data manipulation, and data modeling in SQL and Python to support business decision-making
- Conducted statistical analysis on very large data sets, including financial, accounting, and geographic data to identify patterns and trends
- Employed descriptive, prescriptive, and predictive data analysis methods to offer actionable business insights to executive leaders.
Software & Business Consultant Freelance
Fast Paramedical
02.2020 - 05.2021
- Provided consulting services in software development and business systems analysis to various clients
- Conducted technical/analytic systems analysis to optimize operations and decision-making processes
- Engaged in requirements gathering to develop custom software and website solutions that met specific client needs
- Conducted end-user acceptance training and testing to ensure successful implementation
- Documented business rules and created manuals to support system and software utilization.
Education
Master of Science - Analytics Candidate
Georgia Institute of Technology
Atlanta, CA12.2025
Bachelor of Arts - Business Administration, Information System
California State University - Fullerton
Fullerton, CA05.2021
Associate of Science - Business Administration And Accounting
Chaffey College
Rancho Cucamonga, CA05.2018
Skills
- Data Analysis, manipulation, reporting, and business modeling: Advanced Excel, SQL Server, Python, SSRS, R
- Data Visualization: Power BI
- Project Management: Jira, Monday
- Programming: Python, SQL, R, Bootstrap, Nodejs, ASPNET, HTML, CSS, JavaScript, SAS Language (Self-taught)
- Technologies/Frameworks: Microsoft Power Platform, Power Automate, NET/NET Core, Microsoft SQL Server, Microsoft Azure Clouds platform, SharePoint
- Critical Thinking: Agile, Six Sigma
- Technical/Analytic Systems Analysis: Requirements gathering, end-user acceptance training/testing, process mapping/workflow diagramming, and documenting business rules
- Statistical Analysis: Data exploration and manipulation, data modeling and decision-making, descriptive, prescriptive, and predictive data analysis methods
- Healthcare Data Understanding: Familiar with the integration and organization of large data sets, with an emphasis on healthcare and behavioral health processes
- CRM Systems
- Pivot Tables
- Business Requirements
- Business Process Mapping
- System Integration Testing
- Customer Experience Control
- Business and Technical Analysis
- Information Flow Management
- Business Processes and Procedures
- Data and Analytics
- Industry Trend Analysis
- User Experience
Affiliations
Database Management & Analysis: SQL, Python for Business Analytics
Data Visualization: Power BI, Tableau
Programming: C#, JavaScript, HTML, CSS, Bootstrap, Node.js, ASP.NET
Business Systems Integration: ERP
System Analysis, and Design Business Modeling & Reporting: Advanced Excel skills
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
"Do the little things right to reach the big goals."
Tom Izzo
Timeline
Management Associate - Business Analyst
Carrington Mortgage Holdings LLC
05.2021 - Current
Software & Business Consultant Freelance
Fast Paramedical
02.2020 - 05.2021
Master of Science - Analytics Candidate
Georgia Institute of Technology
Bachelor of Arts - Business Administration, Information System
California State University - Fullerton
Associate of Science - Business Administration And Accounting
Chaffey College
Similar Profiles
Romina Dal Poggetto-KacianRomina Dal Poggetto-Kacian
Vice President – Investor Accounting and Advance Facility Reporting at Carrington Mortgage HoldingsVice President – Investor Accounting and Advance Facility Reporting at Carrington Mortgage Holdings
Rebecca Roberts-WadeRebecca Roberts-Wade
Director, Strategy and Program Management at Carrington Mortgage HoldingsDirector, Strategy and Program Management at Carrington Mortgage Holdings
Shannon Brown, SHRM-CPShannon Brown, SHRM-CP
Employee Relations Manager at Carrington Mortgage HoldingsEmployee Relations Manager at Carrington Mortgage Holdings
JOBBY KOTTARATHIL JAMESJOBBY KOTTARATHIL JAMES
Staff Nurse at Al Salama HospitalStaff Nurse at Al Salama Hospital
Cristian CubillosCristian Cubillos
EMT at Premier AmbulanceEMT at Premier Ambulance