Seth Hoftyzer Email & Phone Number

Denver, Colorado, United States

Full stack Business Intelligence specialist within the FP&A department of a SaaS.Solo, I implemented all PowerBI efforts for our Finance, SalesOps, and Creative teams. I engineered the entire backend of SalesForce/FinancialForce (Certinia) within BigQuery. I created all Production ready tables/views using SQL, which joins data from various amounts of sources. I created all the data pipelines. Developed robust SQL queries for seamless reporting after monthly close to identify revenue/COGS trends. Improved financial transparency by migrating eyes from Excel to PowerBI solutions for cross department functionality.Experience listening to executives for requirement gathering, fetching the data within the database I built, developing the solution, maintaining stakeholder confidence, and implementing the product. My solutions lead to improved financial health and literacy, as well as optimization across various departments to free time for everyone.

Reporting specialist for all projects within a multi client mortgage servicing company. Responsible for all intake and invoicing operations. This also includes creation of monthly executive decks for presentation to stakeholders, and updating of master finance models. Implimented PowerBI solutions across all projects. Experience listening to business problems from project VP's and producing visually effective monitoring dashboards to improve daily mortage operations. Created SQL queries to pull from years of data and create insights to problems not previously recognized. Extensive experience PowerQuery in PBI and Excel to automate invoice/incentive/intake documentation processes.

Managed a team of loan processors on the NewRez project to effectively fund an expected number of files per month. This included building training skills, interpersonal relationships with my team, making the work environment inclusive, and creative thinking for the complex situations that can arise when working with different clients/departments in the mortgage industry. Refined my knowledge of the mortgage industry and processing operations.

Denver, Colorado, United States

Worked on NewRez ProjectManaged pipeline of 100 loans Advanced knowledge of underwriting conditions required for CTC status Credit/title/legal documentation knowledgeFHA, Conventional loan experienceAUS, LP/DU experience

Denver, Colorado, United States

Work with business directors of the Division of Student Affairs on department reconciliation. Creating and filling out budget template models.

Boulder

Data analytics internship that consisted usage of Excel for a business development company. Created robust spreadsheets to assist data analysts in understandings sales data from a waste management company to increase overall intrinsic value. Also, further improved knowledge of basic marketing skills such as google analytics and other metric measuring software such as Grow.

Boulder

-Communicate with scientist during their travel-Create reimbursements for travel-Point of contact for travel related questions