SR. BUSINESS ANALYST
Holbrook Asphalt, LLC – 06|2017 to PRESENT
• Programmed ETL processes that retrieve data from cloud HR software REST API, transform and load into a dimensional model and OLAP cube to be presented in PowerBI.
• Created reports and dashboards in PowerBi for HR, Sales, Accounting and Operations departments.
• Worked as project manager for HRIS, Payroll and Benefit software implementations to replace legacy and paper-based systems; Eliminated $100k+ in yearly HR expenses by identifying an opportunity to restructure department and payroll processes and incorporate new payroll software to automate business processes.
• PHP/Laravel-based SaaS Product Owner for ProjectEngineerPro project management software.
• Evaluated and selected data integration software, Dell Boomi, to connect NetSuite, Hubspot, DocuSign, Paylocity and MS SQL Server databases.
• Ad-Hoc SQL reporting for Accounting and Operations departments.
HR TECHNOLOGY ANALYST
SkyWest Airlines – 08|2016 to 06|2017
• Lead the successful implementation of Salesforce CRM and Pardot marketing software for pilot pathway program.
• Designed internal application to automate employee terminations and managed development team throughout the development life-cycle.
• SQL reporting and IBM Cognos dashboard creation for VP of Human Resources and corporate executives/board of directors.
• Reporting and analysis of sensitive employee information Ultimate Software UltiPro HRIS.
• Supported administration of SumTotal LMS, provided reports and analysis of e-learning programs.
FINANCIAL SYSTEMS ANALYST
Liahona Children’s Foundation – 01|2016 to 09|2016
• Delivered new financial reporting process using GSuite products and Microsoft Access database
• Trained country supervisors throughout 16 countries in Central and South America on new reporting processes
• Created policies, programs, and procedures to establish an internal reporting structure and maintain regulatory compliance.