Results-driven Marketing Analytics, Data Management and BI professional with a background in developing innovative solutions relating to data integration, reporting, web analytics, advanced analytics and database management. I am currently Director of Marketing Analytics driving data integration, dashboard development and advanced analytics projects. We use a variety of tools: SQL Server and Amazon RedShift (database); SSIS (ETL); QlikView and PowerPivot (Dashboards); SAS Campaign Automation (Direct Marketing); SAS Enterprise Miner (Advanced Anaytics). Over the last 15+ years I have managed and directed small IT based teams to leverage people, process and technology to solve the business issues of the day. My experience is rooted in all aspects of data including: BI, database design and modeling, project management, data integration/ETL, web-analytics, reporting and analysis. I have worked in various roles touching business intelligence, database marketing, web-analytics, operational reporting and advanced analytics. I have experience mentoring and managing teams as small as four to as many as twelve. My experience includes working in small dynamic companies (5-25) and larger organizations (5,000+). I have been able to facilitate and translate the business need to the proper technology solution. I have a proven track record of being able to understand the business goals and work with technology and data to help the company achieve its goals. My career goals are to continue helping connect the business users with the data, reporting, technology and predictive analytics they need to make better and more accurate decisions. I want to help companies find solutions to complicated business challenges by leveraging my database management, web analytics, reporting and analytics background.

Director, Marketing Analytics @ Direct a five person Central Services Marketing Analytics team delivering Integrated Marketing Management solutions around data integration, dashboard development and advanced analytics project using internal and external resources. • Managed the business requirements and data integration for new Campaign Automation Project using Amazon RedShift and SAS Campaign Automation • Managing the development of new lead management project using Amazon RedShift and Neustar Decision Navigator • Responsible for development of predictive modeling projects using internal and external resources • Maintained and enhanced 20+ QlikView Dashboards, 50+ excel reports and 100+ SSIS ETL jobs • Integrating Digital Data (DoubleClick Logs and BigQuery) into the marketing database and Dashboards • Designed and automated Pay-Per-Lead Credit process saving the company $500,000 per year From January 2015 to Present (1 year) Greater Pittsburgh AreaSr. Manager Marketing Analytics @ Manager of four person data team responsible for facilitating data access for analytics and reporting. • Managed four person team responsible for standardizing, automating and designing the Marketing database solutions using SQL Server, Amazon RedShift and our Enterprise Data Warehouse • Responsible for data integration of Agency and 3rd party solution providers • Served as part of an Enterprise Data Governance and Data Warehouse Data Steward for Marketing and Admissions • Partnered with Enterprise Data Warehouse team to build enterprise ODL ETL and Analytics layer via SSIS and Tidal Enterprise scheduler From August 2010 to December 2014 (4 years 5 months) Greater Pittsburgh AreaSenior SQL Server Developer and Web Analytics Consultant @ • Consulted on creation of SQL Server database to responsively handle complex queries (T-SQL, DTS, SSIS, triggers, stored procedures, functions, optimization) • Implemented Google Analytics tracking on websites and provided Standard Operating Procedures on daily maintenance • Proven ability to translate back and forth between technical and non-technical audiences From February 2009 to August 2010 (1 year 7 months) Director, Data Insights & Business Analysis @ Worked with four person Analysis and Decision Support Team responsible for database analysis, reporting and business intelligence, predictive modeling and forecasting. • Member of twelve person Senior Management Team and four person Operations Team responsible for setting company-wide goals for service delivery and execution • Created, maintained and enhanced SAS advanced analytics programs that forecast search activity and bid/budget scenarios, including the use of dynamic coding, macros • Accounted for forecasting quality control, including alerts associated with data outliers, program failures, and forecast accuracy and developed and maintain a strict programming environment • Prepared and delivered presentations to internal staff, external clients and prospective clients Key Accomplishments: • Streamlined SQL Server to SAS processes to reduce run-time by 80%, moved data extract and manipulation from SAS to a SQL Server based de-normalized data mart • Automated daily routines allowing for run-times to occur during non-peak hours • Created process to run SAS baseline update only if changes occurred to SQL server data by utilizing SQL schedule jobs to access summary data • Helped initiate change of company wide conversion reporting Best Practices by detailing flexibility of various web analytics reporting options From April 2008 to February 2009 (11 months) Director, Data Management @ Directed Data Management team for leading Search Engine Marketing firm servicing Fortune 1000 Clients with complex search data needs • Worked with four person Analysis and Decision Support Team responsible for database analysis, reporting and business intelligence, predictive modeling and forecasting • Member of twelve person Senior Management Team and four person Operations Team responsible for setting company-wide goals for service delivery and execution • Created, maintained and enhanced SAS advanced analytics programs that forecast search activity and bid/budget scenarios, including the use of dynamic coding, macros • Accounted for forecasting quality control, including alerts associated with data outliers, program failures, and forecast accuracy and developed and maintain a strict programming environment • Prepared and delivered presentations to internal staff, external clients and prospective clients Key Accomplishments: • Established an IT Project Management position to improve ability to meet timelines, budgets and objectives • Established a Quality Assurance position reducing error help tickets by 80% • Increased usage of our proprietary Exstonet decision support tool from 30% to 95% by delivering data alerts via email and providing web-based quality control reports • Reduced daily search engine data errors from 50% to under 1 % by adding a quality control administrator, creating summary data pulls, adding web-based audit screens, and streamlining our API • Achieved goal of providing audited production ready search engine and client conversion data from previous day by 10 AM, down from 3 PM average previously • Reduced Search Engine API data processing time to allow for 9AM data availability (down from 3 PM) for the previous day’s data From February 2007 to April 2008 (1 year 3 months) Manager, Data Acquisition & Web Analytics @ Managed team responsible for planning and implementing all data acquisition and integration projects including client, search industry (Neilsen, Google, Yahoo, MSN), various 3rd party (Claritas, HitWise), and proprietary data. • Responsible for planning and implementing various Paid Search data acquisition and analysis projects • Designed & executed analysis of Search Engine industry data including Nielson Data, published Meta Engine and Search Engine data and internal client data to identify key trends & implications of link/ad visibility (reach, impressions) on click through and conversion rates • Developed web based tool to identify and track solicitation of link share using ColdFusion and HTML • WebTrends administrator responsible for implementation, key metric identification and report creation • Transformed and integrated client web-analytics and off-line conversion data • Created and maintained over 25 spiders using ColdFusion to track paid/organic web ranking Key Achievements: • Selected to three person '30 Day Initiative' team tasked with reviewing company wide work-flow processes to identify areas where technology could streamline processing • Reduced Bid Management Application processing time from 2 to 5 minutes to under 5 seconds by fine tuning queries and indexes • Created automated ETL processing of over 50 client conversion reports via use of SQL Server and ColdFusion scheduled tasks From May 2003 to February 2007 (3 years 10 months) Manager Database Solutions @ Managed $3 million a year database management services for GNC’s US and Canadian Gold Card member database from 1997 to 2009 • Managed and pulled all customer mailings based on demographic and/or purchase history, created source coding based on client provided segmentation requirements, created detailed reporting on segments, and delivered mail files to multiple printers on over 10 monthly mailings (120 mailings and over 30 million records per year) • Maintained customer database from 30-60 million members (3 million new/renewing members per year) from application/coupon receipt, batching, data entry, postal cleansing, data validation/cleansing and insert within a 2 day window from receipt to entry into database • Designed, created and managed ETL data integration from over 15 different sources (paper applications, POS data, coupons, surveys, customer service edits, NCOA, etc) via Visual FoxPro then SQL Server Supported, maintained and improved existing database design and development making best use of resources • Implemented new SQL Server database projects including development, programming, application development, technical documentation, quality control and deployment From May 2000 to May 2003 (3 years 1 month) IT Services Representative @ Provided IT services for Database Management clients and supported fulfillment services for customer loyalty programs • Converted existing Visual FoxPro database to SQL Server 7 then to SQL Server 2000 • Provided code inspections and proactive input on design changes or code modifications to enhance existing processes • Consulted with client on design, work flow and requirements documentation of new marketing and IT initiatives • Supervised and trained IT Services Representatives (5 individuals) • Supervised Shipping Department (5 individuals) responsible for shipping 52,000 + packages a year • Developed and maintained customer service, shipping and data entry application in Visual FoxPro 5.0 From June 1997 to May 2000 (3 years)

MBA, MIS @ University of Pittsburgh - Joseph M. Katz Graduate School of Business From 1996 to 1998 BA, Business Administration, Psychology @ Washington and Jefferson College From 1988 to 1991 Kenneth Baker is skilled in: Google Analytics, SSIS, SAS, Microsoft SQL Server, T-SQL, IBM Websphere Commerce, Hitbox, Omniture, Web Analytics, WebTrends Analytics, Analytics, Business Intelligence, Data Warehousing, SEM, Tableau