Esty Adrian Schmitz Email & Phone Number

Silver Spring, Md, Us

Lanham, Maryland

· Identified business priorities and improvement opportunities to enhance business impact through 75+ custom Tableau resources, 50+ data model enhancements, and extensive stakeholder training.· Pioneered and deployed 30+ reporting models that optimize student engagement and placements across the degree portfolio, saving 150+ monthly hours of manual reporting.· Served as data and reporting lead for Student Success and Placement departments. This includes SQL query construction, Tableau workbook design, data quality assurance, and Atlassian JIRA ticket management all while adhering to regulatory requirements related to educational data (FERPA and GDPR).· Represented Business Analytics & Insights department during two departmental migrations of 46 individual Salesforce organizations into one Salesforce instance. Integrated with Data Science and Engineering to design data models to suit the needs of the new object structure and departmental reporting needs. Examined data for quality assurance and performed data governance. Redeveloped 10 Tableau workbooks and their various custom SQL data sources to adapt to this new data model.

Lanham, Maryland

· Visualized and analyzed datasets (100k+ rows and 50+ columns, each) to gather insights and inform business decisions for various business units using SQL and Tableau.· Built new reliable data streams using SQL functions and Tableau to provide accurate and reliable student data to properly forecast and ultimately support the core business.· Identified risks and opportunities to improve recruitment and retention through qualitative and quantitative analysis typically managed in Atlassian JIRA tickets.· Partnered directly with the executive team to formulate interactive dashboards and report on KPIs across the data web that received 1,000+ visitors using SQL and Google Sheets.· Served as the tenured analytical expert on the Business Analytics & Insights team. Shared best practices with teammates, continuously sought new, improved methods and processes, and independently handled complex analyses, developing new methodologies as needed.· Recognized as a trusted partner, adeptly managing sensitive relationships and demonstrating thought leadership within Business Analytics and across departments.

Silver Spring, Maryland

· Write & run SQL queries & Business Intelligence reports to analyze television deal & program data.· Evaluate & govern deal & program database to ensure high data quality for reliable reporting.· Analyze client feedback & requirements to develop concepts for system enhancements. · Coordinate with project management to determine system solutions & front-end test the database (UAT).· Lead support for client inquiries, troubleshooting, & ad-hoc reporting for the database. · Instruct new & existing clients in 27 offices across the world on database functionality & logic.

Silver Spring, Maryland

· Provided data stewardship for Discovery Communications’ global deal, deliverable, & inventory database “HIVE” with efficient & effective processes.· Evaluated data with SQL & MicroStrategy Business Intelligence (BI) to support Discovery's unfolding business needs.· Participated in UAT with QA team to ensure developments perform as intended & have practical application.· Maintained global content life-cycle management program to foster company strategy & growth.· Trained new & existing clients across the world on system process & enhancements.

Silver Spring, Maryland

· Strategized & designed mid-term & long-term program plans.· Created, implemented, & distributed the strategic programming schedule.· Analyzed Nielsen ratings data & the competitive marketplace to build viewership.· Managed network relationships with production, development, media logistics, broadcast operations groups to ensure maximum efficiency, establish clear lines of communication, & trouble shoot.

Arlington, Virginia

· Programmed the WETA Kids channel & kids programming blocks on WETA TV26. · Analyzed television program performance with Nielsen TV ratings.· Produced promotional & filler spots for the WETA UK & WETA Kids channels.· Developed & integrated WETA local production promotion with social media, print, & broadcast.· Coordinated & completed various short-term department projects.· Assisted in the launch of the WETA UK television channel June 2012.

Washington D.C. Metro Area

Wrote scripts, produced, filmed, & edited educational content for Folger Shakespeare Library.

Bachelor Of Arts, And Sciences; Media Studies, World Religion

2011 Recipient of the Facundo Montenegro Award for Excellence in Production. Created three personal documentaries Enviro Esty, A DCist.

Data Analytics, Sql & Visualization

Data Analysis Circuits is a 10-week, project based, mentor-led, online course that teaches students how to collect, analyze.