Jake Garrell

Earned Splunk Power User certification and developed exclusion filters and a dashboard for Hayabusa Windows event logs, significantly reducing redundant logs and increasing efficiency in cybersecurity log analysis

Built and configured Grafana dashboards for 26 ERCOT wind sites to enhance data scalability and visibility, while scripting solutions to identify stale tags and monitor site health using SCADA and other data pipelines insights

Developed and implemented automated tests using an RPA Framework to validate data architecture and API endpoints, enabling detection and eviction of duplicate tags (sensory data points) within Nextera’s unique data historian system

• Aided Family Wealth Advisors in “ultra-high-net-worth” client financial planning by monitoring and updating the existing CRM system and accessory databases with accurate data for 400 clients • Created data entry process improvements in the CRM and automated dashboard reports, resulting in a time saving of ~10 hours weekly analyzing client reports and a 30% decrease in the occurrence of errors when exporting client data • Researched Real Estate Multifamily Offering Memorandums ranging from $40 million to $120 million and determined investment opportunities by modeling property financial data in Excel

• Programmed a dynamic data science model in Python to forecast revenue and transition more accurately from short term to long term revenue models, resulting in an increase in model revenue accuracy of 20% • Conducted statistical analysis in models such as regression, exponential smoothing, and Arima techniques and compared the resulting revenue predictions using mean squared error to determine the most accurate model • Identified ~10 indicators, such as CPI, PPI, and domestic building spending, that were highly correlated to revenue within the Building Technologies business, to understand key factors that influence long term revenue models

• Developed an automated Excel-based financial dashboard that summarized key financial metrics including revenue, profit, utilization, and marketing expenses, resulting in a 50% reduction in time spent reporting data. Analyzed metrics versus prior week’s report and shared findings with Marketing VP for subsequent financial planning • Designed and reviewed executive-facing marketing presentations for the Aviation and Transit/Rail business units and prepared materials for meetings with the Marketing VP, CEO, and executives of the parent company • Collaborated with the divisional marketing managers to prioritize proposal lists for transportation projects ranging from $100,000 to $ 20 million and updated the CRM database system to reflect the new proposal prioritization

• Assisted in marketing sports-related products to active, outdoor enthusiasts, approximately three to five days a week, working at least eight hours a day. • Provided exceptional customer service at the largest regional store by helping 50-100 customers each shift. • Maintained a high credit card conversion score (percentage of company credit card sign ups) responsible for enlisting approximately 15% of all new customers to receive company specials and upcoming promotions via a company scorecard.

Coursework: Financial Modeling, Financial and Managerial Accounting, Financial Management, Debt & Money Markets, Equity & Capital Markets, Business Finance

Coursework: Data Mining for Business Intelligence, Business Database Systems, Programming for Business Analytics, Business Intelligence, Business Data Presentation and Visualization, Advanced Business Systems Design & Development Technical Skills: SQL, Python, Tableau, R, Java