Torrie Masters Email & Phone Number

Remote

Remote

- Composed new and enhanced existing technical documentation within Confluence wiki (data dictionaries, how-to articles, onboarding documentation, etc.)- Built and maintained homegrown ETL jobs in Airflow- Consulted with stakeholders to ensure their data needs were met- Created and maintained data pipelines in Fivetran- Served as the data engineer on-call in rotation with colleagues- Assisted teammates through code reviews and peer programming- Interviewed potential candidates and conducted onboarding sessions for new hires

Remote

- Created data dictionary that defined and mapped all data interfaces, standardized canonical definitions, and displayed ERD models- Gathered and interpreted requirements from operations team and defined acceptance criteria in JIRA user stories- Altered stored procedures to populate aggregate tables, reports, and data files for executive leadership, operational staff, as well as clinical staff throughout 550 clinics across 12 states- Assisted in the planning, design, and execution of new data warehouse model using snowflake schema- Managed SSRS reports in Visual Studio and published changes using git version control- Collaborated with teammates on JIRA ticket estimations and backlog prioritization for two-week sprints

Greater St. Louis Area

- Led all data related activity on six B2B WordPress applications supported by an agile development framework- Installed, configured, and architected MySQL databases for new client applications- Constructed SQL queries to generate reports in accordance with technical requirements- Investigated and optimized poorly performing report queries and database structures- Conducted data quality assessments and documented issue discoveries within JIRA tickets- Performed manual table backups and maintained systematic automated hot backups- Configured and maintained asynchronous replication topology - Maintained jobs in Jenkins to handle push-button data migrations to lower environments - Scripted and executed SQL (ETL) queries for initial loads and updates to production - Built stored procedures to automate repetitive manual technical tasks- Code reviewed pull requests containing SQL modifications in order to enforce best practices and ensure data integrity - Mentored and trained junior-level team members on SQL scripting, relational databases, and best practices- Assisted team with requirements gathering, ticket estimation, and testing efforts

Greater St. Louis Area

- Handled negotiations for top tier pricing with preferred vendors- Placed and monitored merchandise orders via the Commonsku platform- Led internal brainstorms for ideas of appropriate low-cost products for onsite giveaways or high end incentives for large-scale travel excursions- Coordinated logistics behind the purchasing, packaging and shipping of three dimensional mailers

Greater St. Louis Area

- Published internal technical documentation about the Project Insight (PI) platform- Conducted individual and group training sessions for 150 FUSION and IMG LIVE employees - Managed the internal PI support help desk email account- Handled backend administrative updates to the PI platform

Greater St. Louis Area

- Helped plan experiential marketing events through the management of vendors, budget, and onsite staff- Communicated, implemented, and maintained organizational efficiencies for senior leadership, program managers, event staff, and mobile tour staff

St. Charles, Mo

- Placed 400+ students per semester into their preferred district and content areas for observation

Plainfield, Il

- Crafted email newsletters using MailChimp- Managed the USA Pool Pros Facebook page- Strategically composed blog articles to drive search engine traffic- Created promotions and North Social campaigns to increase likes and awareness

Mooresville, Nc

- Performed B2B cold sales calls on small business owners- Coordinated design and distribution for advertisement on CommuniTee t-shirts- Managed personal sales territory encompassing 30 - 40 towns within a 120 mile radius of STL- Exceeded sales quota by 70% - 140% every month and received 'Rookie of the Month' award twice

Mba, Marketing

Ba, Spanish

Graduated in three years with Summa Cum Laude honors. Two-year Captain of Division II Pirates Volleyball Team.