Trevor Ferris Email & Phone Number

Brookfield, Wi, Us

Milwaukee, Wisconsin, Us

•Translate existing Tableau reporting requirements into new Looker dashboards•Use Postgres and Snowflake SQL to create stored procedures for complex reporting tables•Work with stakeholders to help outline data needs and build more than 200 functional dashboards/reports in Looker for data exploration•Recreate all Postgres code in Snowflake database (~100 tables) and shift all Looker reporting to utilize Snowflake tables•Provide ad-hoc analytical support for one-off data requests

Pleasant Prairie, Wi, Us

•Developed tools/dashboards for various departmental reporting needs using Microsoft Power Platform products•Helped transition existing reporting to generate reports from new data warehouse•Built variety of PowerBI models to assist in facilitating more self-service data acquisition•Worked with stakeholders to identify reporting bottlenecks and rebuild current tools to enhance speed and functionality

Pleasant Prairie, Wi, Us

•Developed Business Intelligence reporting tools for Sales Department using SQL, Power BI, and SSRS•Rebuilt Sales Admin dashboard in Power BI and translated SSRS reports into new data structure•Collaborated with IT department to modernize Sales/Quotes greenbar reporting (EDW)•Operated as SME for Quotes Engine, facilitated quarterly executive meetings, and managed technical engine components•Worked with business users and BI team to establish new quotes reporting metrics in EDW •New table design reduced procedure run-time from 8 hours in SQL2 to 8 minutes in EDW

Pleasant Prairie, Wi, Us

•Conducted statistical analyses/modeling and built out departmental reporting capabilities (SQL, R, and Python)•Provided internal strategy and data consulting for C-suite executives (Inventory, Internet Search, Logistics, etc.)•Operated as SME for revenue management engine and facilitated quarterly executive meetings

Los Angeles, California, Us

•Design and test high-level dashboards of varying complexities in Power BI using DAX coding•Assist in the development of effective visualization techniques to help improve fiscal efficiency and departmental funding•Utilize Oracle SQL Developer to write queries and retrieve data from Oracle databases for analysis

Boston, Massachusetts, Us

Education Pioneers recruits, develops, and connects professionals from diverse backgrounds to solve problems from outside of the classroom so students and teachers succeed inside the classroom. I was selected from thousands of top students and professionals for the Education Pioneers leadership development program. Completed high-impact project for Educate Texas and participated in leadership, networking, and education industry professional development.•Co-managed the organization’s internal Impact Measurement Cycle that emphasized increased clarity of outcomes between staff and management while also allowing for improved goal progress reporting •Designed and facilitated Mid-Year Data Summit for entire organization to enhance each program’s effective use of data and disseminate best practices•Constructed a Data Collection Tool, currently utilized by Early College High Schools across the state of Texas, and collaborated as part of a consulting team to provide effective data training for 30+ school administrators•Analyzed and synthesized education data using longitudinal trend analysis to identify bright spots and highlight areas for improvement•Member of data team responsible for 5-12% improvement of organizational outcomes in one year, based on employee surveys

London, England, Gb

Willis Towers Watson is a leading global advisory, broking and solutions company that helps clients around the world turn risk into a path for growth. WTW creates a variety of solutions for clients based on their individual needs and insights from the market in order to improve organizations from the inside out. •Performed complex (QDRO, Disability, etc.) and standard benefit calculations for individual participants of multiple companies, based on specified plan provisions and methodology •Compiled monthly funding reports, reconciled payment systems, managed payment set-up process, and acted as the 2nd level reviewer for a large client with yearly total pension benefit payments exceeding $100M •Reviewed pension calculations done by 1st level analyst and ensured accuracy/quality of work product being communicated to client

New York, Ny, Us

Teach For America recruits remarkable and diverse individuals to become teachers in low-income communities. These recruits commit to a two year service agreements, receive ongoing professional development, and strive to close the educational gaps in their placement communities. I was selected from approximately 45,000 applicants to serve in this highly acclaimed national service corps: committed to teach for 2 years in an under-resourced rural region to close educational achievement gap•Instructed students in all levels of mathematics education, from Pre-Algebra to Calculus, successfully supporting an average of 75% material mastery •Guided students to an average of 1.75 years’ mathematical growth in one school year, as measured by nationally standardized Northwest Evaluation Association’s Measure of Academic Progress assessment•Co-founder of Little Wound School Buddies Program: Peer mentorship program designed to develop leadership skills of high school students

Wilmington, Ma, Us

• Developed licensing proposals for corporate clients with contractual revenues exceeding $400K • Analyzed potential clients and evaluated anticipated cohesion with target audiences• Created original program concepts for corporate marketers and college football sponsors • Monitored and enforced copyright infringement violations• Utilized content management systems such as American Eagle and Castfire for data archiving

Master Of Science (M.S.), Business Analytics

Bachelor Of Science (B.S.), Finance; Sport Management