Megan Dotson Email & Phone Number

New York, New York, Us

- Conversion from contract at Worldlink to Full Time Employment in the same role- Work with SQL, Amazon Redshift, Snowflake, and AWS tools daily to provide pre-campaign and post-campaign ad hoc reporting to clients relating to Samsung Smart TV advertising campaigns- Build automated reports for standard requests using SQL and Python- Utilize JIRA, Confluence, and Git for ticket and project tracking, documentation, and code sharing/version control respectively- Supported a data warehouse migration from Amazon Redshift to Snowflake which included data validation and SQL query updates

Frisco, Tx, Us

- Support the Samsung Ads Analytics team- Work with PostgreSQL, Redshift, and AWS tools daily to provide pre-campaign and post-campaign ad hoc reporting to clients relating to Samsung Smart TV advertising campaigns- Build automated reports for standard requests using SQL and Python to assist the team with creation of a web application to enable clients and Sales to create their own reporting- Utilize JIRA, Confluence, and Git for ticket and project tracking, documentation, and code sharing/version control respectively

Orlando, Florida, Us

- Utilize SAS, SQL, and Excel daily to extract and transform data to provide visibility to resort reservations and arrivals to the Inventory Management team- Create automated reporting to replace time consuming daily tasks- Maintain previously built SAS code and Excel macros- Built process to audit the amount of inventory we should have available versus the amount of inventory in the online booking/front desk booking system to provide visibility of any errors to Inventory Management team, preventing overbooking resorts- Provide data to regional teams regularly so they are able to set monthly arrivals goals to aid resort sales teams, as well as optimize resorts to obtain maximum arrivals- Work closely with Finance team to communicate forecasts and budgets to ensure we meet annual financial goals- Provide weekly reporting of maintenance occurring at resorts to ensure Resort Operations team is aware of affected rooms

- Work directly with media networks to determine common trends and patterns in television program ratings- Use SAS to implement trends and historical data in predictive models in order to forecast future television ratings- Work with web developers to ensure functionality of major product

Orlando, Fl, Us

- Tutor students in an upper-level business-focused Statistics course- Use strong communication skills to efficiently explain topics and concepts to students in the class, as well as respond to emails from students quickly to resolve issues

Reston, Virginia, Us

- Work with data scientists to train machine learning models to solve real-world problems for Electric Utility customers- Write Python scripts to create machine learning models and automate some frequent tasks for engineers

Wawa, Pa, Us

- Work closely in a group setting with coworkers and managers to provide quick and efficient customer service- Use strong interpersonal skills while interacting with customers to provide great customer service- Frequently train new employees in all areas of the store

Master Of Science, Statistical Computing, Data Mining Track

Bachelor Of Science, Statistics