Branden Farmer
Fernley
Summary
Detail-oriented and analytical business intelligence professional with extensive experience in SQL, Power BI, and Python, seeking a role where I can leverage my skills in data analysis and automated report generation to drive data-driven decisions and contribute to organizational success . Eager to apply my expertise in optimizing business processes and leading innovative projects in a dynamic and forward-thinking environment.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Business Intelligence Developer III
Sierra Nevada Corporation
Sparks, NV
05.2022 - Current
- Increased decision-making efficiency by 10%, resulting in annual savings of $30,000, by deploying data analytics solutions using Power BI, SQL, and Python.
- Created sophisticated data visualizations and dashboards in Power BI, providing actionable insights and enhancing business intelligence capabilities.
- Developed and implemented over 10 custom Power Apps and Power Automate workflows, automating tasks and reducing manual workload by 25%.
- Leveraged Python for advanced data manipulation and integration, further streamlining workflow efficiency.
- Provided crucial support for high-profile projects with intricate SQL queries, views, and stored procedures, particularly for ETL processes.
- Demonstrated expertise in SQL server management and query optimization, ensuring high performance and reliability.
- Conducted comprehensive cost analysis and data quality validation using Python and SQL, leading to optimized resource allocation and process enhancements.
- Employed advanced analytical techniques in Python to identify and implement process improvements, contributing to long-term operational excellence.
Planning Supervisor
Sierra Nevada Corporation
Sparks, NV
10.2021 - 05.2022
- Oversaw production schedules and directed a team of planners to guarantee on-time delivery.
- Employed advanced data analysis techniques in SQL, Power BI, and Excel to optimize planning and forecasting accuracy.
- Spearheaded process enhancements, leading to a 20% reduction in lead times and increased operational accuracy.
- Developed and integrated custom automation tools using Python, streamlining workflows and enhancing productivity.
- Conducted rigorous monitoring of key performance indicators (KPIs) and executed business process mapping to pinpoint areas for improvement.
- Leveraged SQL queries and Power BI reports to analyze operational data, enabling more informed decision-making.
- Expertly utilized SQL scripts to extract and analyze data from the Data Warehouse, contributing to significant cost savings and operational efficiencies.
- Identified material shortages and mitigated potential delays, saving an estimated $20,000 in expediting fees through proactive measures and data-driven strategies.
Production Planner
Sierra Nevada Corporation
Sparks, NV
01.2019 - 10.2022
- Successfully achieved a 95% on-time delivery rate by meticulously developing and maintaining production schedules.
- Leveraged Power BI to create dynamic and insightful reports, significantly enhancing operational visibility and decision-making processes.
- Boosted overall production efficiency by 10% through strategic planning and process optimization.
- Utilized SQL for in-depth data analysis and querying, providing accurate and timely information to support efficient production planning.
- Designed and implemented custom reports and applications in Excel using VBA, automating routine tasks and providing tailored analytical insights to meet operational needs.
Lead Production Technician
Sierra Nevada Corporation
Sparks, NV
01.2018 - 01.2019
- Guided a team of technicians to consistently meet production goals while upholding high quality standards.
- Developed and implemented custom Excel reports using VBA to enhance production planning and track material through the manufacturing process.
- Conducted comprehensive training for team members, resulting in a 25% improvement in skills and performance.
- Utilized SQL within Access databases to gather and analyze production data, enabling more effective training modules and resource allocation.
- Innovated in data management and reporting by integrating SQL queries with Access databases to streamline production-related data retrieval and analysis.
- Designed user-friendly interfaces and automated report generation tools in Excel, significantly improving the tracking and management of manufacturing processes.
Production Technician
Sierra Nevada Corporation
Sparks, NV
08.2016 - 01.2018
- Precisely assembled and tested products in line with specified requirements and stringent quality standards.
- Utilized Excel to create comprehensive reports and macros, enhancing the accuracy and efficiency of quality tracking.
- Actively collaborated with team members to achieve production targets and adhere to strict deadlines.
- Developed and implemented custom Excel VBA scripts and utilized Access databases for efficient data management and reporting, contributing significantly to the team's ability to meet production goals.
- Excelled in creating detailed reports and analytical tools using Excel VBA, providing critical insights into production processes.
- Leveraged Access databases for effective data storage and retrieval, facilitating improved data-driven decision-making in production activities.
Assembly Technician
Server Technology
Reno, NV
01.2014 - 08.2016
- Spearheaded automated report generation for production processing using advanced Excel functions, significantly enhancing reporting efficiency and accuracy.
- Provided detailed and timely reports to management, offering insights into production metrics and trends through skillful data analysis.
- Excelled in creating comprehensive Excel reports for tracking production progress and data entry, facilitating informed decision-making.
- Implemented and maintained a robust system for production tracking, ensuring accurate and up-to-date information was readily available for stakeholders.
- Precisely assembled server Power Distribution Units (PDUs), adhering to technical specifications and quality standards.
- Collaborated with team members in the assembly process, contributing to efficient operations and timely completion of projects.
Assistant Manager
7-eleven
Reno, NV
01.2012 - 01.2014
- Pioneered the creation of custom reports using Excel to track and analyze store performance, enhancing operational efficiency and decision-making.
- Proficient in utilizing custom 7-Eleven software for various administrative and reporting purposes.
- Skilfully generated staff schedules, balancing employee availability with store needs to ensure optimal staffing levels.
- Managed product ordering and forecasting, effectively maintaining inventory levels and ensuring product availability to meet customer demand.
- Supervised and trained a team of up to 4 employees, fostering a collaborative and efficient work environment.
- Conducted cash counts and bank drops, ensuring accuracy in financial transactions and adherence to store policies.
- Oversaw the stocking of merchandise, maintaining an organized and appealing store layout to enhance the customer shopping experience.
Education
MicroBachelors / Certificate - Full Stack Application Development
EdX / IBM
Online12-2025
High School Diploma -
Sacramento Academic And Vocational Academy
Sacramento, CA06.2009
Skills
- SQL (Advanced Queries, Data Manipulation)
- Power BI (Data Visualization, Dashboard Creation)
- Python (Data Analysis, Automation Scripts)
- Microsoft Power Platform (Power Apps, Power Automate)
- Excel VBA
- Robotic Process Automation (RPA)
- Data Analysis Techniques (Cost Analysis, Data Quality Validation, Business Process Mapping)
- HTML/CSS (Basic Web Development)
- APIs
Accomplishments
- 2018 STAR Award Recipient: Recognized for outstanding innovation and efficiency in business processes.
- 2021, 2022, 2023 DTU Award Finalist: Consistently shortlisted for demonstrating exceptional technical expertise and leadership.
- Significant Cost Savings: Developed in-house email and workflow automations using Python, SQL, and Microsoft Power Platform, leading to annual savings of $15,000. This solution enhanced operational efficiency and reduced reliance on external software.
Certification
- Supervisory Management Certification - UNR Extended Studies, 2021-01
- Lean Six Sigma Green Belt Certification - UNR Extended Studies, 2019-01
- Lean Manufacturing 101 Certification - UNR Extended Studies, 2017-01
Timeline
Business Intelligence Developer III
Sierra Nevada Corporation
05.2022 - Current
Planning Supervisor
Sierra Nevada Corporation
10.2021 - 05.2022
Production Planner
Sierra Nevada Corporation
01.2019 - 10.2022
Lead Production Technician
Sierra Nevada Corporation
01.2018 - 01.2019
Production Technician
Sierra Nevada Corporation
08.2016 - 01.2018
Assembly Technician
Server Technology
01.2014 - 08.2016
Assistant Manager
7-eleven
01.2012 - 01.2014
MicroBachelors / Certificate - Full Stack Application Development
EdX / IBM
High School Diploma -
Sacramento Academic And Vocational Academy