Bruce Jenks
E:-• M:- • Reno, NV 89509
www.linkedin.com/in/brucejenks1/
SOFTWARE AND CODING PROFICENCIES
SQL• VBA • SSRS • SSMS • Azure • Visual Studio • Python • Power BI • Tableau • RIMbase • CMP • SpotFire
Kronos • LMS • DataMagine • MS Office Suite • In-house proprietary software • SAP • HTML • Python • •Django
• CSS • QLIK
DATA SCIENCE PROFESSIONAL
Data Analyst with a strong SQL background and extensive experience in utilizing Python for predictive modeling,
data processing, and data mining algorithms to solve challenging business problems. Passionate about deep
reinforcement learning. Involved in optimization of data including data migration,
extraction/transformation/loading(ETL). Developed business applications with VBA and other Object-Oriented
Software Languages, such as Python. Developed executive Dashboards and other reports in SSRS, SpotFire, Tableau,
Power BI, QLIK, and other visualization software.
Ormat • Reno, NV • June 2017 – Present
Data Analyst
Transformed a four-year data entry task into a six-month task utilizing VBA and SQL Server. Development of data
analysis techniques in Python which include predictive modeling and Monte Carlo simulations. Lead in charge of
centralizing the organizations' data in the form of new SQL databases and automated reporting solutions. This includes the utilization of SSRS and other visualization software such as Power BI and SpotFire.
•
•
•
•
All but eliminated manual data input by converting Excel reports into SQL inserts with VBA.
Designed and launched an SQL Reporting Server through the use Visual Studio and SSRS.
Automated several Excel Reports with SQL and Visual Studio and deployed them to the SQL Reporting
Server.
Developing integrated cloud solutions through Microsoft Azure.
Grand Sierra Resort • Reno, NV • November 2015 – June 2017
Major Conventions Data Analyst/Auditor
Thoroughly review final billing to ensure accuracy and correct invoicing. Identify recurring issues and work with
sales, banquets, and support staff to introduce measures to eliminate future mistakes.
•
•
•
Effectively settled 33 past due accounts during first month of employment. Received a letter of
recommendation from the former CFO Mike Garipay for collecting over a million dollars in less than three
months.
Using SQL, VBA, and Python created queries to quickly gather pertinent data and streamline the auditing
process.
Employed the use of VBA to reduce manual Excel manipulation.
VIDA • Reno, NV • October 2014 – November 2015
Data Management Consultant
Designed , built and launched a T-SQL database and reporting server on Microsoft Azure. Designed several reports
in SSRS and deployed to said Azure reporting server.
•
•
•
•
Developed and launched a T-SQL DB and reporting server on Microsoft Azure.
Developed several reports in SSRS and Visual Studio and deployed them to Azure.
Programmed several Excel reports with VBA code to increase efficiency and reduce user errors.
Trained employees to build ad hoc reports in Power BI.
IFCO Systems • Charlotte, NC • September 2012 – October 2014
On-Site Manager
Joined IFCO to gain experience with P&L, budgeting, and to be able to fully utilize my MBA by running my own
business unit. Employed the use of Python for predictive modeling and designed code in VBA that automated several Excel Reports.
•
•
•
•
Developed a Labor versus Revenue report now utilized by every Site Manager in the organization.
Successfully transitioned ten on-site operations across five new customer platforms.
Received “Budget Buster” Award two years in a row.
Developed processes and integration procedures for new sites as well as policies, SOP’s and customer
specific programs.
Alere Health • Reno, NV • June 2009 – Jul 2012
Manager of Operations Reporting
Lead a group of tech-savvy individuals in system migration, report creation, and automation of manual reporting
processes. Oversaw the automation of several hundred Excel Reports to SQL Reporting Server. Designed several
executive dashboards and other high-level executive management reporting solutions.
•
•
•
Oversaw a team of 10 SQL writers and the automation of over 275 Excel reports to SQL in three years.
Oversaw the transition from four software platforms to a single platform over the course of three years.
Developed the Alere Internal Report request process, which resulted in a significant decrease in report
completion time.
Burrows Packaging • Reno, NV • December 2007 – June 2009
Quality Manager
Manage a diverse group of individuals to maximize production, increase quality, and ensure safety while maintaining
outstanding customer relationships.
•
•
•
Designed and implemented a local SQL Reporting Server which held safety and quality data.
Transformed several Excel reports into automated SQL reports.
Employed statistical quality control techniques including Exponentially Weighted Moving Average (EWMA).
EDUCATION
Bachelor of Science in Business Administration (AACSB Certified Business Program)
University of Nevada, Reno • Reno, NV • 2006
Master of Business Administration- Concentration in Business Analytics (MBA)
University of Phoenix • MBA Program • 2010
