Mark Goesmann Resume 042716
- 1. MARK GOESMANN 256 Savannah Preserve Loop Davenport, FL 33837 (217) 502-2561 | mgoesma@gmail.com PROFESSIONAL SUMMARY Highly motivated individual with 5 years of experience in campaign execution, business analysis,project management, and data management. Strong technical skills in SQL, ETL, and data analysis. Worksextremely well with technical and business partners along with vendors. Motivated to find efficiencies, streamline processes, educate partners, and resolve problems. Believes in driving businessthrough continuous improvement. Experienced in defining creative solutions and leveraging innovative ideas that yield improvements to the bottomline. EDUCATION Masters ofBusiness Administration March 2014 WebsterUniversity, Orlando, FL Bachelor ofArts in Computer Science, Business Administration Minor Dec 2009 Southern Illinois University Edwardsville (SIUE), Edwardsville, IL SKILLS Software: MS FrontPage Toad HP Service Manager Reflections FTP Client Teradata SQL assistant SAS Enterprise Guide NetBeans Interfaces Design Backlot FileZilla DataFlux UltraEdit UltraCompare Tableau Programming Languages: C++ VB Java MIPS MySQL TSQL Interactive C SAS Teradata SQL Oracle SQL Soft Skills:Goal oriented Focused Organized Achiever Inquisitive Persistent Multi-tasker Team player Flexible Strong aspirations towards gaining knowledge Achieving results and exceeding expectations EXPERIENCE Disney Destinations,The Walt Disney Company April 2015 Present Technical Solutions Manager Campaign Work o Responsible for the development of over 100 targeted email and direct mail campaigns annually for multiple lines of business (Adventures by Disney, Aulani, WDW & DLR Newsletters and CMR Relationship Teams) o Crafted new methodologies to allow for precise audience selection where statistical models were not available. o Collaborated with Program Managers on audience selection, segmentation and made recommendations for future data enhancements to increase audience universe size. Process Improvement and Efficiencies o I worked with my peers to create and build a standardized Indicator table provided standardization of indicators across business units, as well as improving the processing time for each campaign by 20 minutes. o Simplified campaign coding that improved run times from 2 hours to 20 minutes by using a top to bottom approach, adding waterfalls and making the code reader-friendly. o Documented the Guest Concern process outlining the steps required to efficiently manage and address concerns. o Coordinated effort to centralize all AdHoc Seeds into a table, allowing Program managers the ability to update their seeds. This reduced overhead of TSM and minimized programming errors for all AdHoc Teams. o Collaborated with TSMs to standardize and document suppressions to insure proper people are suppressed for each type of campaign and that all TSM are in-sync with the new process. Sizing and Data Expansion o Successfully integrated and tested affiliate data fromcorporate data environment providing a significant impact on Guests Response Rate (1.1%) and an increase in conversion compared to controls. o Consistently evaluated available data, investigated obscure sources and provided recommendations and ideas that may identify potential audience improvements or new data sources. o Engaged with Business Affairs to evaluate suppressed data that would be of a benefit to Past Guests. Lifting this suppression provided communication to 100% more Past Guests that would have otherwise missed new news. o Worked with other TSMs along with ISP and Program Managers to determine the best strategy to handle a Gmail/Hotmail bulking issue with the least overhead while retaining a flexible solution. Education Partner o Educated several Technical Interns and Program Managers about data processes and availability. o Built reputation as a Subject Matter expert from Leaders, Partners and Peers on data and processes. Disney Destinations,The Walt Disney Company July 2012 April 2015 Core Business Integration Analyst - Customer Managed Relationships Problem solving o Designed solution for spamlaw implementation across the department enabling a seamless transition.
- 2. o Served as Subject Matter Expert and SystemAdministrator of new software to modernize campaign creation across all Teams (Partners, Program Managers, Vendors) reducing campaign costs and development time by 25% Project Management o Managed the design and implementation of an automated feed of facility data from IT to populate internally utilized campaign tables. This improved accuracies and reduced workload by 150 hours annually. o Oversaw the creation of an automated process to pull travel agent information from sales and exclude it from campaigns. This removed over 420,000 travel agent emails from our contactable list. o Facilitated upgrades to a guest search tool to incorporate valuable indicators utilized in guest research. Programming o Created file layout, ETL, DDL, and automated the running of jobs to facilitate loading from vendor - making campaigns more effective by only presenting offers to eligible customers. o Created reporting to detect invalid or NULL locator data returned from vendors in response data, thus notifying responsible parties immediately receding correction costs and holding accountability. o Designed reporting to indicate missing or incorrect loading of contact history and response data allowing better reconciliation of data and allowing more ease to research issues. Process Improvement o Simplified and enhanced critical load process of campaign data into call center system by removing redundant actions and automating assignment. o Engineered new process to nullify indicators in contact history based on hard fail data rules. o Enhanced process in target tables that identified and removed offensive names/ vulgarities (in several different languages), improving data quantity, while ensuring no offensive names were ever sent to Guests. o Enriched the hygiene check process for email, address and names removing over 500,000 bad locators from the contactable mailing list, reducing campaign costs by eliminating errant records. Vendor / Partner Relations o Worked with 35 different direct mail vendors to facilitate the creation and loading of a CASS write back file removing 250,000 bad addresses. This improved the accuracy of our mailing list saving the department $125,000 annually in returned mail. o Identified and worked with different email vendors to correct inconsistencies in email hard fail data. This corrected over 250,000 incorrectly marked emails. o Represented Core Teams to corporate and other partnering lines of business to obtain indicators, suppression files, and response data utilized by the department. o Worked with IT on large cross discipline projects such as Guest Recognition and Permissions. This improves our customer data by developing auditing and understanding of the cross department data. Analytics o Pulled multi-million row sample files for data testing of external vendors then analyzed the results of their tests, providing visibility into external vendor match-rate before purchasing. . o Analyzing guest permissions for communications and identifying more than a million over-suppressed guests allowing growth in audience size and improved Guest communication opportunity. Documentation o Designed a communication template that was adopted by the Core Teams that provides all pertinent information about a Project Launch in a consistent, user-friendly format. o Translated complex programs and processes used in code for non-technical partners to reference and be educated. o Standardized the vendor file layout across the department to reduce errors and streamline process. Disney Destinations,The Walt Disney Company Jan 2012 - July 2012 Professional Internship - Customer Managed Relationships, Global Data Management Analytics o Efficiently joined multi-million record tables and analyzed the results to determine problems and/or inefficiencies o Determined the cause of 150,000 missing leads by analyzing trends, frequency, counts and past activities, and then alerted the Business Owner to facilitate solution. Documentation / Communication skills o Co-Authored the documentation of a process that creates approximately 150,000 to 300,000 leads a month o Created a process flow diagram illustrating file processing time-delays in vendors and internal systems o Created a 100 field input database mapping for a third party processing vendor into multiple databases o Organized, facilitated and summarized minutes for meetings with Disney and external Partners Streamlined processes o Automated a complex billing invoice process using SAS reducing resource time from one hour to 15 seconds o Created automated and manual ad-hoc reports in SAS to easily identify problems in data loads by summarizing and analyzing the marketing data o Automated a process to clean and format weekly load data using Visual Basic ACTIVITIES/CONFERENCES SAS basic and advanced programming training 2012 Park Ridge HOA President 2016 - Current