Sarah Seils Email & Phone Number

Mclean, VA, US

Denver, CO, US

• Use Databricks delta lake technology to build out Ping Identity’s data lake house in AWS
• Build data pipelines leveraging PySpark and Spark SQL with Databricks notebooks
• Scale data lake house by using Spark clusters for compute resources and S3 buckets for storage
• Manage pipelines from various source systems (Salesforce, Google Analytics, internal systems, etc)
• Include error handling, retry logic, and data quality checks in pipelines to ensure SLAs are met
• Model and develop facts and dimensions for downstream reporting tools and end users

Broomfield, CO, US

• Vail Resorts, Inc
• Developer lead on multiyear project to transition lodging reservation data off Vail’s home-grown Lodging Management System (LMS) to the IQware Property Management System
• Developed new 2019 SSAS tabular cube that saved Vail $180,000 in consulting fees
• Built processes to stream EDW data assets into Snowflake using Qlik Replicate
• Developed Python script to orchestrate refresh schedule of Snowflake and Tableau data assets
• Learned PowerShell on the fly to develop scripts that connect to an API and load source data into a staging area that leverages temporal tables to keep track of history

Broomfield, CO, US

• Developer lead for two new fact tables to store ski and ride school transactions and reservations
• Assisted with the architectural design of the analytical reporting database that stores Inntopia lodging data, which involves storing un-structured JSON in relational columns to help reduce record storage
• Developed ETL processes to pull data from the stage environment to the analytical reporting environment for Inntopia lodging data
• Re-built SSRS reports to point at new Inntopia database
• Processed maintenance requests for the LMS lodging database and SSAS cube
• Developed Tableau dashboards and data sources for the Central Reservation and Revenue Management teams

Aurora, Colorado, US

• Collaborated with team members on data architecture design to implement a sustainable and functional data warehouse
• Built stored procedures and ETL processes in SSIS to load data into the data warehouse
• Utilized Tableau to create insightful data visualizations to monitor KPIs for all departments within the university
• Assisted with bug fixes and the QA of code, ETL or Tableau development done by other team members to ensure quality and accuracy
• Developed new dashboards, supported ad-hoc requests, and provided on-going maintenance for current reporting
• Worked with Business Analysts to gather requirements and understand stakeholder needs

Denver, Colorado, US

• Utilized SQL and Alteryx skills to pull large data sets to be visualized in Tableau dashboards
• Clustered groups of consumers into different segments based on user behavior to assist in targeted marketing initiatives and gain insight into consumer lifetime value
• Supported the product team with reporting, forecast models, and A/B testing efforts
• Built data feeds that incorporated revenue and transactional information for vendors to improve SEM and TV advertising initiatives
• Aided the public relations team with key metrics for research articles and marketing initiatives
• Voluntarily wrote DIY helpful tips and tricks articles for the HomeSource blog

Scottsdale, AZ, US

• Collected, researched, and analyzed technical data (e.g. technical specifications and product data)
• Manipulated, managed, and interpreted company data in the form of numbers, text, or images using SQL, Excel and ESRI ArcView/ArcGIS
• Analyzed and rationalized data from multiple sources within expected deadline
• Evaluated research of other Research/Data Analysts to identify inconsistencies and/or errors, as well as ensuring the data met current ISO 9001 standards
• Performed quality checks on database records through the execution of SQL queries to create discrepancy reports
• Held accountable by project leaders for the quality of products and services delivered to clients

Gilbert, Arizona, US

• Found and researched pricing discrepancies based upon pricelist costs, purchase order costs, and ratio pricing
• Analyzed and condensed data using specialized company software along with MySQL
• Wrote and submitted vendor claims based upon findings to aid in cost recovery for clients

Gouda, Zuid-Holland, NL

• Identified payment discrepancies due to incorrect employee time and expense sheets
• Estimated payment status for vendors by researching previous payment history
• Provided tier one level support for employee benefit inquiries (medical, dental, vision, 401k, vacation/sick time)
• Provided exceptional customer service to employees via phone, email, and chat

New York, NY, US

• Shadowed one of Honolulu’s top wealth management advisors, Milton Kawasaki
• Assisted in scheduling appointments and conducting a client survey

Olean, NY, US

• Directed and advised up to 15 sales representatives at a time
• Tracked weekly sales of representatives and reported to District Manager
• Interviewed and trained new sales representatives
• Sold an average of $4000 per month
• Presented one-on-one demonstrations of products to potential customers
• Provided professional sharpening services

• Designed floral arrangements for weddings and special events
• Met with clients for wedding consultations
• Networked with wedding and special event vendors in the Denver metro area

Bachelor Of Science, Business Administration; Marketing

General Studies