Dean Shaw Email & Phone Number

Newport Beach, Ca, Us

Seattle, Washington, United States

Optimized SQL queries by replacing sub selects with CTEs for 13 Alteryx batch macro workflows. Utilized ODBC to connect to Snowflake and reduced daily runtime from 1.5 hours to 25 minutesDeveloped and deployed Alteryx workflow which utilized Confluence API, Json, and Python to extract xml metadata and output result to an S3 bucket. Final workflow deployed to production allowed data owners to monitor changes in Parametric data products.Developed automated position and transaction movement reporting for portfolio surveillance teamMaintained and improved legacy Nifi benchmark delivery flows.Conducted gap analysis on data providers utilized by Parametric and Morgan StanleyProposed AI Solutions for the Portfolio Surveillance and presented the proposal to company executives

Seattle, Washington, United States

As the Scholarship Chairman for Beta Theta Pi at UW, my role was to ensure academic excellence within the fraternity. My responsibilities encompass a diverse range of tasks, including:Managing and maintaining the academic performance of the entire house. This involves monitoring grades, tracking progress, and implementing strategies to support members in achieving their academic goals.Projects: Leveraging advanced Excel skills, I spearheaded a project focused on optimizing the analysis of PDF transcripts. I developed a JavaScript script to convert transcripts into HTML files. Parsed the HTML files to extract essential information, including professors' names, course credits, and grades earned. Using Excel, I designed and developed a user-friendly interface that grants members access to a wealth of academic information, empowering them to explore the academic history of both current and past members for specific courses offered by the UW.

Seattle, Washington, United States

Spearheaded instruction in diverse subjects including YouTube Video Production, App Development, Coding with Java, and Minecraft Game Design for camp attendees.Played a pivotal role in the setup, maintenance, optimization, debugging, backup, and cloning of on-site computer systems, enhancing the efficiency and functionality of camp resources.

Newport Beach, California, United States

Pioneered the development of a robust sales tool, leveraging VBA code, to empower the field team with comprehensive insights into current and historical trends across all locations. This tool proved instrumental in conducting effective business reviews with franchise owners, driving informed decision-making.Expanded responsibilities to include critical projects in sales planning, supply chain reporting, and impact forecasting. This included conducting in-depth analysis on menu pricing and its implications on franchise owner profitability, further enhancing the organization's strategic positioning.

Bachelor Of Business Administration - Bba, Finance And Information Systems, Senior

High School Diploma

Activities and Societies: Varsity Soccer TeamVarsity Soccer offensive player of the year, 2nd team all league Senior Artist of The Year.