Jake Terpstra Email & Phone Number

Saint Paul, MN, US

Santa Barbara, CA, US

Englewood, CO, US

• Managed IT enterprise resources and planning for the entire organization, including data collection and warehousing, customer relationship management (CRM) customization (Microsoft Dynamics 365), reporting, backend.
• Shifted team management to agile/scrum methodology utilizing Jira and Microsoft Planner to illuminate team’s projects, tasks, and priorities
• Established governance for Power Platform, Power Apps, and CRM customization by implementing a Center of Excellence for monitoring and reporting on created assets
• Contributed to the design, development, analysis, and maintenance of comprehensive system architecture, encompassing Azure Synapse and on-premises SQL database environments.
• Led technical planning, architecture development, and specification modifications to ensure systems met performance, scalability, reliability, security, and other requirements.
• Leveraged engineering knowledge to test, deploy, and support systems in production, actively participating in the documentation and development of processes and assessment of MGMA’s Azure architecture.

Denver, CO, US

• Recruit, retain, and grow a team of 15 full-time and temporary employees performing HR Data entry and integrity, reporting and analytics, and learning development
• Define and execute a roadmap for an overhaul of existing catalog of 150+ paginated SSRS reports into Power BI dashboards to provide enhanced analysis and insights to the HR and District leadership teams
• Act as a data steward for HR and advocate for data governance, integrity, and security. Ensure HR teams adhere to data infrastructures, including ETL, cubes, interfaces, and data exchange methods
• Utilize a variety of technologies (Microsoft and Oracle SQL, SSRS, Power BI, OTBI, Oracle BI Publisher, Splash BI) to create and maintain daily audit reporting and adhoc queries across Infor HR, Lawson S3, and Oracle.

Denver, CO, US

• Collaborated, mentored, and directly supervised a team of 11 business intelligence developers, analysts, data engineers, and data modelers
• Served as technical lead on interface creation and migration, data conversion, and reporting solutions (using SSRS and Power BI) for ERP implementation project moving all Finance, HCM, Talent Acquisition, Benefits, and.
• Implemented Splash BI third party application to pull down data from Oracle Fusion to on-prem Microsoft SQL server database for usage in creation of SSRS and PowerBI reports
• Led and executed data modeling of new Oracle HR raw data into a dimensional star schema model for optimized use in reporting, analysis, and tactical applications

Denver, CO, US

• Evaluated HR and Finance business needs and worked with end users to build SSRS and Power BI reporting products and solutions
• Led creation of new reports and maintenance of over 300 finance and HR custom reporting solutions, synergizing data from Lawson and Infor ERP systems, as well as other third-party applications
• Created SSIS ETL flat files to provide third-party applications HR data needed for user creation and access

Loveland, CO, US

• Orchestrated maintenance of multiple reporting focused websites and development of new web products using knowledge of SQL Server queries, views, stored procedures, interactive data visualization,.Net/C# programming.
• Coordinated development, design, and data cleaning/conversion directly with external customers to create customized web reporting solutions and presentations
• Standardized nationwide scan data and created monthly and annual reporting for use by NCBA and National Pork Board, as well as other industry clients

Broomfield, Colorado, US

• Trusted with sensitive and private financial information for integration synergy with acquiring company
• Executed daily reporting, analysis, and visualization using programs such as PowerBI, Microsoft SQL Server, Oracle SQL Server, Microsoft Access, ArcGIS, Salesforce, and Excel to prepare regular presentations and ad-hoc.
• Maintained data integrity and inventory accuracy across four legacy inventory systems, while ensuring availability and completeness of data among new installs and archived inventory

Austin, TX, US

• Supervised a meat department of 12 personnel in conducting retail operations
• Managed various business processes including recruitment and staff supervision, procurement, forecasting and inventory management, and implementation of merchandising strategy within the department
• Introduced time-saving best practices and procedures, winning the team two consecutive All-Star awards for best executed team out of 30 in the region

Bachelor Of Arts (B.A.), Mathematics

High School Diploma