Talk to sales Try for Free
Suzanne K.

Suzanne K.

Merchandising Database Administrator

Followers of Suzanne K.246 followers
location of Suzanne K.Glendale, Arizona, United States

Connect with Suzanne K. to Send Message

Connect

Connect with Suzanne K. to Send Message

Connect

  • Timeline

  • About me

    Senior Product Development Analyst at American Express

  • Education

    • Interface Technical Training

      2008 - 2008
      Completion of SQL200 class, Completion of SQL2779 class

      • Completion of SQL200 class (June 2008). Subjects covered: Database Concepts, Transact-SQL Querying Tools, Retrieving Data, Working with Multiple Tables, Grouping and Summarizing Data, working with Subqueries, Modifying Data, and Transact-SQL Procedural Programming.• Completion of SQL2779 class (July 2008). Subjects covered: Creating Databases and Database Files, Creating Data Types and Tables, Using XML, Creating and Tuning Indexes, Implementing Data Integrity by Using Constraints,… Show more • Completion of SQL200 class (June 2008). Subjects covered: Database Concepts, Transact-SQL Querying Tools, Retrieving Data, Working with Multiple Tables, Grouping and Summarizing Data, working with Subqueries, Modifying Data, and Transact-SQL Procedural Programming.• Completion of SQL2779 class (July 2008). Subjects covered: Creating Databases and Database Files, Creating Data Types and Tables, Using XML, Creating and Tuning Indexes, Implementing Data Integrity by Using Constraints, Triggers and XML Schemas, Implementing Views, Implementing Stored Procedures and Functions, Managing Transactions and Locks, Implementing Managed Code in the Database, Using Service Broker. Show less

    • Arizona State University

      1994 - 1997
      Bachelor of Science (B.S.) Marketing

      Activities and Societies: American Marketing Association Spanish MinorGerman Minor

  • Experience

    • Publishers Clearing House

      Jan 2005 - Jan 2007
      Merchandising Database Administrator

      • Maintained entire database of Publishers Clearing House products.• Created charts, formulas, and macros to show categorized items and their performance.• Trained new employees on mainframe system and procedures.• Implemented new procedures to utilize time more effectively.• Assisted co-workers with difficult formulas and formatting of their respective charts.

    • ICrossing

      Oct 2008 - Aug 2019

      • Created and supported client and internal SEO and SEM dashboards using Tableau and Datorama, connecting to data sources such as Google Analytics, Adobe Analytics, and Kenshoo. Formulated workarounds when solutions were not native to the systems. • Collaborated with offshore engineering team to integrate systems and data sources, and to troubleshoot system bugs. • Managed re-coding of materialized views within PL/SQL Developer during systems migration from an internal system to Kenshoo data feeds into a proprietary dashboard.• Supported client dashboard updates and requests on an ad hoc basis through Oracle, providing the Product Development (PD) team with SQL code updates for the Graphic User Interface (GUI) display and integrations of new business intelligence technologies.• Worked with Visual Studio and Report Builder to automate SQL queries and tables for reports through Microsoft SharePoint. Show less • Created and analyzed website traffic and search engine position data reports for several Fortune 100 and 500 clients.• Collaborated with natural search engine optimization (SEO) team and project managers to strategize methods to improve website traffic and search engine position to increase client sales and market exposure.• Led monthly analytics client calls, presenting historical and current data sets via client dashboards and other analytics tools, such as Google Analytics and Adobe Analytics.• Created baseline traffic and position data reports for sales team and built ad hoc reports for existing and potential clients. Researched keyword trends and search engine positioning data. Show less

      • Senior Marketing Systems Analyst

        Oct 2013 - Aug 2019

      • Senior Natural Search Reporting Analyst

        Apr 2012 - Oct 2013

      • Natural Search Reporting Analyst

        Oct 2008 - Apr 2012

    • American Express

      Oct 2019 - now

      • Supported delivery of ASPEN/ASPEN Core projects through collaborative meetings with internal colleagues and external partners, training calls, and documentation.• Created and adapted Agile best practices documentation for ASPEN/ASPEN Core.• Created a migration plan with the team to find the best solution for moving intake requests from JIRA to Rally, improving processes and integrating all actions to the Rally system.• Supported the delivery of several projects leading to a potential combined revenue of over $800MM, and the acquisition of nearly 50K new accounts. Show less

      • Senior Product Development Analyst, ASPEN/ASPEN Core

        Mar 2022 - now

      • Product Development Analyst, ASPEN/ASPEN Core

        Sept 2020 - Mar 2022

      • Product Development Analyst, DARE

        Oct 2019 - Aug 2020

  • Licenses & Certifications

    • Google Tag Manager Fundamentals/Certificate of Completion

      Google Analytics Academy
      Feb 2018
      View certificate certificate

    • Advanced Google Analytics/Certificate of Completion

      Google Analytics Academy
      Jan 2018
      View certificate certificate

    • Ecommerce Analytics/Certificate of Completion

      Google Analytics Academy
      Jan 2018
      View certificate certificate

    • Google Analytics for Beginners/Certificate of Completion

      Google Analytics Academy
      Jan 2018
      View certificate certificate

    • Datorama Admin/Level 1/Certificate of Completion

      Datorama
      Sept 2017
      View certificate certificate

  • Volunteer Experience

    • Animal Caretaker (Feline)

      Issued by Helping Animals Live On (HALO) on Jan 2009
      Helping Animals Live On (HALO)Associated with Suzanne K.