We provide IT Staff Augmentation Services!

Senior Director Of Data & Analytics Resume

0/5 (Submit Your Rating)

Auburn Hills, MI

SUMMARY:

  • Database and marketing professional with 13 years of diverse market experience consisting of 6+ years of manufacturing and IT solutions experience within the automotive industry and 7+ years of marketing, database and IT solutions within the entertainment industry. Excellent customer and communication skills backed with advanced, s, and technology knowledge. Willingness to travel and provide a professional work ethic at all times will assure my addition to your company is a success

TECHNICAL SKILLS:

Computer Languages: Visual Basic, VBA, VBScript, HTML, JAVA, SQL, COBOL

Databases: Microsoft SQL Server, Sybase, Interbase, Firebird, MYSQL, Microsoft Access

Data Integration: Informatica, Cast Iron, DBAmp, SSIS, DTS

Software: Microsoft Office, Cimplicity, Visual InterDev, Visual Studio, Visual SourceSafe, Satellite Forms, Symantec Ghost, Microsoft Sharepoint, Salesforce.com, Symon, ServiceCenter, AssetCenter, Crystal Report Server, Crystal Reports, Microsoft Front Page, Aqua Studio, Quest Capacity Manager, Quest SQL Watch, AdventNet ManageEngine

Marketing Tools: Salesforce.com, Radian6, ExactTarget, Eloqua, Click2, OnDialogue, ClickTools

PROFESSIONAL EXPERIENCE:

Confidential, Auburn Hills, MI

Senior Director of Data & Analytics

Responsibilities:

  • Responsible for the design, functionality and maintenance of PS&E’s CRM system, Salesforce.com.
  • Management of the ticketing and corporate partnerships Salesforce.com instances.
  • Responsible for the strategy of our organizations sports and entertainment operational database model and application.
  • Management of numerous cold call, e - mail, and direct mail campaigns in support of ticket sales and corporate partnerships.
  • Responsible for data hygiene and data cleanliness of consumer data in PS&E’s operational and transactional data systems.
  • Department head and the company’s go to source for sophisticated reporting. Including, but not limited to, ticketing analytics, market research, sales rep measurement, and executive dashboards.
  • Responsible for profiling PS&E’s consumers based on the company’s various product lines.
  • Management of the delivery of reports via e-mail, web dashboards, workstation pop-ups, intranet dashboards and on-demand reporting.
  • Directed the development of an arena mapping and graphing tool to be used for evaluating purchasing patterns and behaviors, seasonal price setting, assisting variable and dynamic pricing exercises, and ticketing analytics.
  • Drive the company’s sales and marketing efforts based upon the research and development of consumer profiles.
  • Oversee the creation and interpretation of the company’s various survey initiatives.
  • Direct the research and gathering of prospects to supplement numerous sales acquisition campaigns.
  • Responsible for analysis of consumer behavior in the market place as it relates to ticket, radio and television consumption of PS&E’s brands.
  • Responsible for the collection and consistency of consumer data via web forms.
  • Responsible for the maintenance and implementation of the integration of disparate data sources within the PS&E environment.
  • Spearheading the development of a ticketing analytics and consumer data warehouse.
  • Support for the various integration tools available at PS&E including SSIS, DTS, DBamp, Informatica, and FTP.
  • Successfully manage over 16 vendor relationships for the D&A department.
  • Lead a company-wide, weekly executive and department head analytics meeting.
  • Participate in numerous sales acquisition and retention strategy meetings.

Confidential, Auburn Hills, MI

Database Administrator

Responsibilities:

  • Responsible for the health and maintenance of all databases at Confidential & Entertainment.
  • Developed and implemented a disaster recovery solution for all databases.
  • Implemented notification systems for health and monitoring of all production critical systems.
  • Created daily surveillance procedures for all databases.
  • Designed a database monitoring solution utilizing Quest’s Capacity Manager, Quest’s SQL Watch, and ManageEngine’s Application Manager.
  • Optimized existing stored procedures to process and successfully complete in a more timely matter.
  • Created database documentation and change control procedures for our SQL Server database servers.
  • Created a process for de-duplication, merge/purge, CASS, NCOA checks and address verification within the ticketing operational database, in conjunction with Ticketmaster and Pitney Bowes, to assure data quality and cleanliness.
  • Created and maintain numerous SQL server integration processes interfacing with our Sybase (transactional and call log), DB2, and SQL Server databases utilizing DTS packages.
  • Responsible for design, implementation, and support of an extensive ETL process for our Salesforce.com implementation utilizing DTS and Boomi/Informatica/Cast Iron/DBAmp.
  • Created and maintain our CRM data warehouse.
  • Successfully migrated SQL Server 2000 database servers to new physical servers.
  • Successfully upgraded existing SQL Server 2000 database servers to SQL Server 2005.
  • Responsible for the design, creation, and maintenance of any new database solutions.
  • Responsible for day to day trouble shooting of SQL Server connectivity, responsiveness, and availability issues.Installed and Configured the Crystal Report Server.
  • Created, configured, designed, and managed numerous crystal reports for our Sales, MCO Sales, CRM, Accounting, and IT departments to be delivered and managed on the Crystal Report Server.
  • Point of contact for any access requirements or site development within the Microsoft Sharepoint environment.
  • Developed numerous dashboards that have been deployed in sharepoint to accomplish the goals of many of our business intelligence initiatives.
  • Point of contact for new user creation and modification within the Archtics application environment.
  • Responsible for property configuration within the Archtics application environment.
  • Participated in application and system upgrades for the entire organization.
  • Created a disaster recovery solution for the Symon Call Center application.
  • Created and maintained a distributed reporting solution for reporting sales call information during regular intervals for all sales departments company wide.
  • Responsible for creation of database objects within the salesforce.com environment.
  • Created process and strategy for synchronization and verification between the ticketing operational database and the salesforce.com marketing database.
  • Worked with business professors at Oakland University to complete a regression analysis of event costs for Confidential & Entertainments outdoor venues.
  • Suggested numerous changes to Ticketmaster regarding their Archtics application and database schema that have been implemented in their system nation wide.
  • Suggested an enterprise reporting solution utilizing Crystal Reports that was implemented and utilized by numerous departments within the organization.
  • Assisted Basketball Operations with statistical analysis of player performance.
  • Responsible, for the past three years, for accumulating, aggregating, and composing information for use in an extensive, 60 page, year end sales report and ticket analysis that gets delivered to the NBA.
  • Successfully managed relationships with numerous vendors including, but not limited to, Ticketmaster, Micros, Stratbridge, Salesforce.com, Business Objects, Symon, VDS, TM Group, and Model Metrics.
  • Named Confidential & Entertainment’s 2006 Information Technology Employee of the Year.

Confidential, Flint, MI

Information Analyst

Responsibilities:

  • Member of the Plant Monitoring & Control support team at the FMC. Working extensively with the GM customer to support systems using Cimplicity, SQL Server, Windows NT and IBM servers.
  • Responsible for the development and support of Crystal Reports and the reporting server (RAS) for the PM&C system.
  • Functioned as the DBA for the PM&C support team. Responsibilities included ensuring system availability of database cluster, development of the disaster recovery plan for the database servers, validating system response times, and developing database backup and maintenance plans.
  • Member of the Reporting Team for Digital Workflow. Developed and modified Crystal Reports and SQL stored procedures. Performed and participated in conformance reviews for any modifications or new development.
  • Reports were developed in Peregrine’s ServiceCenter and AssetCenter Sybase environment.
  • Project leader for EDS, Delphi, and numerous vendors to prepare Plant 1's systems. This included disaster recovery plans, virus protection strategies, creating images of software profiles, preparing the plant for wireless communication, and configuring the factory floor servers.
  • Member of the Plant Monitoring & Control implementation team at the FMC working in cooperation with the GM customer to implement changes and trouble shoot system concerns.
  • The scope of the implementation included the PM&C system written in Cimplicity and utilizing the MS SQL database environment for data logging, reporting and notification.
  • Assumed DBA responsibilities for the all databases related to new and existing PM&C implementations. This included setting up the RAID configuration for database servers, installing and configuring all software for database servers, ensuring that database servers met system requirements and that performance fell within an acceptable threshold, and the development of disaster recovery plans.
  • Member of ADHOC implementation and support team at the FMC. Worked closely with the customer to provide an elaborate database and reporting system for the line supervisors at the FMC.
  • Member of the PM&C implementation team. Worked with the customer to prepare for the expansion of two assembly lines. The scope of work included installing CQis stations and PM&C viewers, developing Cimplicity screens, and testing.
  • Worked with the customer to develop a 24-Hour Clock reporting tool for line supervisors using the Palm OS. The software package implemented on the Palm was Satellite Forms, a Microsoft VB compliant language.

We'd love your feedback!