Sean Ayotte Email & Phone Number

Waxhaw, Nc, Us

Austin (Remote) , Texas, Us

Chicago, Illinois, Us

• 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

Austin, Tx, Us

• 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

Stamford , Ct, Us

• 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

• 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)

Englewood, Co, Us

• 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

• 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)

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

Flagler Beach, Fl, Us

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

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

Bachelors Degree, Communication

Education record