Jacob Anderson

JakeAnderson

Salt Lake City, UT, United States

Summary
ETL Tools QlikView ETL Tableau Data Warehousing SQL Business Intelligence
Experienced Business Intelligence Developer with a demonstrated history of working with multiple stakeholders across multiple domains. Skilled in SQL, ETL, data warehouse design, data governance and business intelligence.
Experience

Business Intelligence Developer (Contingent) at The Church of Jesus Christ of Latter-day Saints

Apr 2017 - Present

▪ Designed, implemented, maintained, and documented dozens of extract transfer load (ETL) processes using P/L SQL and SAP Data Services ▪ Troubleshot and conducted post mortem analysis on ETL failures ▪ Developed many new tables, views, indexes, packages and functions ▪ Modeled new data and enhancements to existing data utilizing Kimball methodologies to provide easy to understand semantic layer using Business Object Universes ▪ Provided many Tableau extracts from the data warehouse for business user consumption ▪ Lead internal Tableau user group

Business Intelligence Analyst at Allegiant Air

Nov 2014 - Mar 2017

• Gathered requirements with SMEs and non-SMEs for many departments of the business including: Accounting, Crew Services, eCommerce, Engineering, Finance, Marketing, Network Planning, Operations, and Procurement • Provided architecture and supplied advanced queries /stored procedures for core data marts • Developed concise visualizations and excellent UX for wide range of users ranging from gate agents to C-suite • Wrote dozens of ad hoc queries for SMEs and non-SMEs in across the company • Successfully maintained QlikView and Tableau servers by troubleshooting job failures, maintaining sound data governance procedures, and regular job efficiency check ups • Provided regular training for technical and non- technical users in SQL, BI tools, and data cubes

Business Intelligence Intern at North Logan City Library

Apr 2014 - Nov 2017

• Created Python ETL script to transform text-based reports from a legacy system to standardized CSV format Built new 3NF database using legacy system data in MySQL environment • Performed dozens of ad hoc quires using MySQL per the library director's request • Built a dashboard in QlikView to reflect a balance score card • Successfully removed 2,000+ low value items to make room for renovations

Education

Dual B.S. Accounting and Management Information Systems at Jon M. Huntsman School of Business, Utah State University

Aug 2011 - Nov 2014

• Maintained 3.5 GPA in Business College while working two part-time jobs • Awarded Koch Scholarship for intellectual curiosity • Dean's List • Scrum Master certification

image/svg+xml
Push pixels...
Shovel coal into server...
Create mockups...
Defend the wall...
Draft storyboard...
Disrupt an industry...
Achieve profitability...
Become a unicorn...
Become Batman...