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• Created a clean and simple pipeline that does 900,000+ API calls per day to pull internal product data that went from taking 15 hours down to 2 hours. • Developed product utilization and churn risk dashboards for weekly leadership business reviews

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• Led the architectural design of a new analytical reporting database that encompasses historical lodging data (LMS) and new IQware source data• Created dynamic ETL load process that that can integrate a new resort within 10 minutes• Developed a dynamic load process that migrates historical LMS data into the analytical reporting database that can be executed on a resort by resort basis

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