Hector Garcia
Senior Business Process Analyst
Summary
Experienced data-driven business process analyst with a strong understanding of underwriting operations, process improvement, and advanced data analysis. Proficient in utilizing SQL, Snowflake, Excel, Power Automate, SAS EG, and Power BI to extract valuable insights and drive informed decision-making. Skilled in developing reporting solutions and automating workflows to streamline operations. Committed to applying data-driven strategies that optimize business performance and contribute to overall success.
Overview
15
15
years of professional experience
4030
4030
years of post-secondary education
4
4
Certifications
1
1
Language
Work History
Senior Business Process Analyst
CSAA
05.2021 - Current
- Used historical and current data analysis and root cause techniques in Snowflake and SAS EG to identify areas for system and process improvements.
- Built advanced reports and dashboards using a variety of tools, including SQL, Snowflake, Excel, and Power BI to deliver actionable insights on business trends.
- Created success metrics to track and evaluate the impact of process changes.
- Automated workflows and reporting tasks using Power BI and Power Automate to improve team efficiency and reduce manual work.
- Supported analysts by sharing knowledge of SQL, SAS EG, Snowflake, and product by helping improve evaluation of complex scenarios.
- Provided guidance on the use of Power Apps/Automate and enterprise systems to support process improvement initiatives.
- Worked closely with cross-functional teams and leadership to ensure data solutions aligned with business and process goals.
- Encouraged continuous improvement and employee engagement through active participation in Employee Resource Groups.
Consultant
CSAA Insurance Group
01.2018 - 05.2021
- Analyzed underwriting risks and coached agents to proactively resolve issues using internal software tools and best practices.
- Collaborated with service teams, product, and claims departments to identify pain points and recommend process improvements.
- Responded to diverse agent and member inquiries related to endorsements, products, upcoming changes, and procedures.
- Introduced a custom Excel spreadsheet that improved billing transparency and reduced billing escalation calls.
- Identified, tracked, and reviewed potential system defects by comparing issues across field agents and cohorts, escalating when necessary.
- Supported Field Product Consultants and Site Managers by assisting with underwriting and systems issues.
Product Analyst Rotation
CSAA
01.2020 - 12.2020
- Tracked key metrics for assigned states and developed Excel-based tools adopted by analysts to streamline workflows.
- Automated data reporting using Excel formulas and SAS EG macros to improve reporting accuracy and efficiency.
- Built Choice Auto and Evalue reporting metrics from raw company data to measure and track agent productivity improvements.
- Conducted market intelligence reviews to identify competitor rate and product changes, providing insights to product leadership.
- Collaborated on state rate change initiatives across departments, supporting pricing and product update strategies.
- Reviewed large loss data and used AON Impact to monitor policies near active wildfire zones.
- Prepared customized monthly PowerPoint decks summarizing key market data for senior management and club agents.
- Mapped new hire and intern processes, recommending improvements to streamline onboarding and file/code sharing.
Team Leader
State Farm Insurance | Insurance
06.2010 - 12.2017
- Coordinated a team of four agents to set and achieve personal lines, auto, home, and life new business acquisition goals.
- Organized monthly strategy meetings with senior agents to review trends and guide marketing focus areas.
- Consulted with other State Farm agencies to analyze business performance and recommend custom operational improvements.
- Achieved Top Officer Performer recognition for five consecutive years by aligning customer financial needs with appropriate policy offerings.
Education
Bachelor Of Business Administration -
University of Nevada, Las Vegas
Las Vegas, NV12-2026
Accelerators -
CSAA
Las Vegas, NV12.2023
CSAA Aspiring Leadership Development Program -
Leadership Institute
Henderson, NV May 2019 - 12.2019
Developing Service Leaders Program -
Service Leadership
01.2019 - 05.2019
Advanced Honors Diploma -
Chaparral High School
Las Vegas, NV August 2004 - 08.2008
Skills
- SQL Snowflake Excel Power BI SAS EG Power Automate Power Apps VBA
- Data reporting and visualization
- Process automation
- Underwriting Risk Analysis
- Business Process Improvement
- Cross-Functional Collaboration
- Root Cause Analysis
- Insurance policy knowledge
Business analysis
Risk Assessment
Client acquisition
Cross-functional collaboration
SAS & Power BI proficiency
Accomplishments
- California Wildfire Team- Collaborated on a specialized team to ensure members have adequate coverage of wildfire risk
- California Coverage A Initiative and Capping Team- Assisted agents and members to hold challenging conversations around cost to insure home policies are completed correctly
- Underwriting Team- Analyze reports that impact company underwriting quality and provide feedback to improve.
- Agency Operations- Cross Collaboration with Agent Administration, IT, and Agent Service in providing new existing sales agent access and support to IG applications.
- Agent Experience- Reviewing sentiment that sales agents may have while identifying solutions to provide a positive and productive experience.
Certification
Prosci
Affiliations
ERG, SOMOS Co-lead
Toastmasters, Treasurer
Association of Latino Professionals for America (ALPFA)
Accelerators Alumni
ERG, Making the Ask for WPN(Presenter)
Timeline
Prosci
12-2023
CSAA Snowflake Training
07-2023
Senior Business Process Analyst
CSAA
05.2021 - Current
Product Analyst Rotation
CSAA
01.2020 - 12.2020
Developing Service Leaders Program -
Service Leadership
01.2019 - 05.2019
Consultant
CSAA Insurance Group
01.2018 - 05.2021
Health and Life License
12-2010
Property and Casualty license
06-2010
Team Leader
State Farm Insurance | Insurance
06.2010 - 12.2017
Bachelor Of Business Administration -
University of Nevada, Las Vegas
Accelerators -
CSAA
CSAA Aspiring Leadership Development Program -
Leadership Institute
May 2019 - 12.2019
Advanced Honors Diploma -
Chaparral High School
August 2004 - 08.2008