Trevor W.
Solutions Architect at Sinclair Broadcast Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Lean Six Sigma - Greenbelt
Caesars Entertainment CorporationMay, 2017- Nov, 2024 -
Alteryx Designer Core Certification
AlteryxMay, 2021- Nov, 2024
Experience
-
Sinclair Broadcast Group
-
United States
-
Broadcast Media Production and Distribution
-
700 & Above Employee
-
Solutions Architect
-
Jan 2023 - Present
Responsibilities -Lead the design, development, and implementation of data focused solutions for the Enterprise Data & Insights Team-Develop and maintain technical documentation and architecture diagrams-Collaborate with key stakeholders to understand their needs and develop appropriate solutions-Work closely with engineers, data scientists, and other technical teams to ensure solutions are implemented correctly and effectively-Facilitate the development of data governance policies, procedures, and standardsSkills/Tools-Azure-AWS-Boomi-Informatica-Snowflake-Visio-Python-SQL
-
-
Sr. Data Engineer
-
Jul 2021 - Jan 2023
Responsibilities -Designed, implemented, and maintained scalable data architecture to meet business requirements-Built and maintained data storage solutions using SQL and NoSQL databases-Ensured data accuracy, completeness, and reliability through quality control processes-Collaborated with Data Scientists, Analysts, and business users to support their data needsSkills/Tools-Azure Data Factory-Azure Data Lake Gen 2-Azure Synapse Analytics-Azure SQL Server-PowerShell-Python-T-SQLKey Projects:Customer Data Management - Was a key member of the CDM/MDM project team which mastered the company’s customer data. Integrations were created via Boomi and the data was synchronized via Informatica. Mastering customer data has saved over 25,000 labor-hours per year since it was launched.KnowBe4 Data Pipeline - Developed and implemented a data solution to retrieve security data from KnowBe4 and store it in a Azure SQL Database for our BI and Data Science teams. This pipeline uses Python to call the KnowBe4 API and store the results in Azure Blob Storage before being loaded via a stored procedure to the SQL Database. This pipeline is orchestrated via an Azure Data Factory.
-
-
-
T. Rowe Price
-
United States
-
Financial Services
-
700 & Above Employee
-
Sr. Data Analyst
-
Aug 2017 - Jul 2021
Responsibilities -Developed and maintained data pipelines via tools such as Alteryx, SQL Server, and Python to collect, process, and manage large data sets from various sources -Collaborated with stakeholders to understand their data needs and provide customized data solutions -Created enterprise data dashboards with tools such as Tableau and Power BI -Monitored data quality to ensure data was accurate, complete, and consistent Skills/Tools -Alteryx -SQL -Python -Tableau -Power BI -Oracle PBC -Oracle EDM -Excel Key Projects AUM Reconciliation - Created an Alteryx pipeline to automate our quarterly AUM reconciliation process which reduced the time to perform this task from three days to thirty seconds. Effective Fee Rate Reporting - Designed a Tableau dashboard to work as a flexible report builder for our accounting team. An Alteryx pipeline is used to clean and combine multiple Excel workbooks which are then loaded to Tableau. This process saved 10+ hours per month for the accounting team. Compliance Tracking Report - Produced an Alteryx reporting solution utilizing fuzzy matching functionality to reduce monthly gift compliance reporting by over 8 hours. ServiceNow Dashboard - Constructed a Tableau dashboard to provide summary and detail level data of all ongoing projects entered into ServiceNow for the Finance Systems Team.
-
-
-
Caesars Entertainment, Inc.
-
United States
-
Hospitality
-
700 & Above Employee
-
Lead Analyst - FP&A
-
Aug 2016 - Aug 2017
Responsibilities -Analyzed data using statistical techniques to provide insights to support business decisions -Developed and maintained complex data models and financial reports -Conducted financial analysis and modeling for various business initiatives and projects -Worked directly with executive leadership to provide data driven answers to their questions Skills/Tools -Excel -Tableau -Python / Pandas -MicroStrategy -Oracle Hyperion / SmartView -SQL Key Projects: 2017 Budget - Lead a team of department managers and property leadership through building the $300M operating budget across 35 departments for 2017 using Oracle Hyperion Planning Weekly Forecast Model – Built a ground-up model via Excel and SmartView to create Month/Quarter end projections in line level detail to be reported to Senior management Restaurant Rebranding DCF Model – Constructed DCF models to justify the rebranding of the two flagship restaurants on property: Gordan Ramsay Steak and GDL Italian
-
-
-
Nasdaq
-
United States
-
Financial Services
-
700 & Above Employee
-
Data Analyst
-
Dec 2014 - Aug 2016
Responsibilities -Researched and analyzed financial data to ensure proper index calculations -Collected, processed, and managed large financial data sets from various sources -Created models, reports, and visualizations to communicate data insights to stakeholders -Developed and maintained data workflows ensuring data accuracy and integrity Skills/Tools -Excel -SQL -Bloomberg -FactSet -Oracle -Tableau Key Projects: Automated Global Index Review – Enhanced index review process of over 3,000 indexes via improvements to Excel models and SQL Queries resulting in a reduction in evaluation time of 2 days Global Corporate Actions Database - Created an Access database for global corporate actions to assist with corporate transitions during the merger of the Stockholm and Bangalore offices ISE Migration - Reviewed and evaluated all ISE indexes and proposed changes to existing methodologies in order to allow for a smoother transition to Nasdaq’s GIC platform. Pro-forma models and back testing via Excel and SQL queries were done for any major changes in order to insure continuity within the existing methodology
-
-
-
Northwestern Mutual
-
United States
-
Financial Services
-
700 & Above Employee
-
Financial Representative
-
Jul 2014 - Dec 2014
Responsibilities -Collected and analyzed raw data in order to create in-depth financial analysis for individual clients -Worked closely with senior specialists to provide comprehensive financial support to clients in the areas of risk management, wealth accumulation and wealth preservation through personal financial modeling. Responsibilities -Collected and analyzed raw data in order to create in-depth financial analysis for individual clients -Worked closely with senior specialists to provide comprehensive financial support to clients in the areas of risk management, wealth accumulation and wealth preservation through personal financial modeling.
-
-
-
Walt Disney World
-
United States
-
Entertainment Providers
-
700 & Above Employee
-
Merchandising Intern
-
Aug 2009 - Jan 2010
Responsibilities -Maintained visual displays while servicing over one thousand daily transactions. -Ensured guest satisfaction by giving prompt, friendly and knowledgeable service. -Provided daily guest service in Fortune 100 company. Responsibilities -Maintained visual displays while servicing over one thousand daily transactions. -Ensured guest satisfaction by giving prompt, friendly and knowledgeable service. -Provided daily guest service in Fortune 100 company.
-
-
Education
-
2013 - 2014
WVU John Chambers College of Business and Economics
Master of Business Administration (MBA) -
2010 - 2012
West Virginia University
Bachelor of Arts (B.A.), Criminology
Community
