Sean Ayotte

Experience

• 

  Employer's Unity, Inc.

  Jan 1998 - Jan 2000

  Data Entry Supervisor

  sorting and filing, data-entry, supervising of three employees, and troubleshooting on computers, fax and copy machines

• 

  Tee Times USA

  Aug 2002 - Dec 2006

  Webmaster/Technical Support/Reservation Agent

  Produced effective web pages for numerous websites and solely responsible for website maintenance. Reviewed and revised all information on the local system, websites and for all published materials. Exercised exceptional customer service skills and suggestive selling methods to ensure customer and company satisfaction. Executed computer and technical knowledge and troubleshooting techniques to achieve uninterrupted service for employees and customers. Handled invoice reconciliation and accounts payable functions.Created web pages featured in several national magazinesDesigned point-of-purchase displays and brochuresAnalyzed business trends and statistics for presentations Show less

• 

  Soci3ty Independent Media

  May 2004 - Nov 2008

  Web Developer/Designer

  • Developed numerous e-commerce and content-based websites using HTML, CSS, ASP, SQL, JavaScript and PHP• Utilized graphic design skills to build logos and ensure graphically-pleasing images and layouts• Generated clientele and recruited additional Developers/DesignersWeb Developer of the Year (2005, 2006, 2007)Top Web Design (2004, 2005, 2007)

• 

  Trip2Earth (now Rooms101)

  Feb 2007 - Oct 2007

  Content Writer/Manager

  Utilized creative writing techniques to produce press releases and internet content. Prioritized and organized all content within the department to guarantee deadlines and goals were met. Employed online and publication research techniques to minimize wasted time. Communicated progress reports to organization. Reviewed and revised all content ensuring accuracy and standards were being met. Assisted web development team when requested.Increased content output by over 500%Managed and trained ten Content Writers Show less

• 

  Pulte Group, Inc

  Nov 2007 - Aug 2012

  Web Developer

  • Designed, developed and maintained multiple web applications (using HTML, CSS, SQL, JavaScript, ASP, Access and SharePoint) from end-to-end (including soliciting and recording user requirements, testing and training)• Generated dashboards and reports for application users• Spearheaded Web Process Improvement Committee to ensure functionality and content were meeting the highest standard• Prepared business analyses and created solutions to ensure problem resolution• Installed, configured and managed call center telephony tool and programmed IVR/call flow for 3,000+ national phone numbers including general and advertising effectiveness reporting• Created new ETL tool for company-wide Customer Satisfaction Surveys saving the company over $400,000 annually• Instrumental in process improvement for various departments Show less

• 

  City of Glendale Police Department

  Aug 2012 - Jul 2018

  Business Analyst/Management Analyst

  • Utilized advanced SQL techniques to create essential queries, functions, triggers and jobs against SQL Server and Oracle (and to a much lesser extent, MS Access and Db2) databases• Gathered user requirements to produce (from end-to-end) over 200 qualitative/quantitative reports and parameterized forms in SSRS• Managed SQL Server Reporting Services (SSRS) access/subscriptions for the department and provided training to users• Created critical functionality and QA/debugged vendor-provided software (with regression testing) for public safety software• Employed MS Excel advanced functions, PivotTables, 3D Maps and more• Provided functional support to analyze business processes and technology requirements for the Police department• Operated as a liaison among business and IT stakeholders to elicit, analyze, communicate and validate features and requirements for changes to business processes, policies, information and information systems• Participated as department-stakeholder of city-wide Business Intelligence Procurement Committee (hands-on testing over a dozen BI Tools including Tableau, Alteryx, Power BI, Qlik, SiSense, Birst, and Logi Analytics) Show less

• 

  Spectrum

  Jul 2018 - Sept 2019

  Senior Data Analytics and Reporting Analyst

  • Administered team’s internal SQL Server database• Developed, documented and distributed many reports via Excel and Tableau• Improved efficiency on General Ledger reporting through optimization of stored procedures and process improvement• Performed data analytics for various audits utilizing Teradata, SQL Server, Oracle, Db2 and other database sources

• 

  Mood Media

  Sept 2019 - Jun 2022

  Director of Marketing Analytics

  • Implemented API tool to allow for simplified cross-system analysis across the company’s entire suite of data products including Magento, Google Analytics, Google Ads, Oracle Sales Cloud, Salesforce, Eloqua and many others• Created SQL Server database for SQL Server Reporting Services (SSRS) reports and streamlined reporting for multiple departments• Advised business partners with regards to data patterns and projections• Performed as global thought leader while collaborating with members from all functional teams to further bolster future business and/or marketing initiatives Show less

• 

  Tegus

  Jun 2022 - Nov 2022

  Senior Data Analyst

  • Spearheaded data efforts related to Amplitude Product Analytics instrumentation, testing, and reporting• Prepared several vital datasets, dataflows, reports and dashboards in Domo• Updated existing queries for higher accuracy and efficiency

• 

  MNTN

  Jan 2023 - now

  Senior Data Analyst