Charles Erickson
** ***** ** *********, ** *****
adbnde@r.postjobfree.com
Experience
Manager, Marketing Database Operations at Fresenius Medical Care from May 2016 – present
Developed and automated process to publish dialysis facility data & clinic listings display on Search Engine Media & FreseniusKidneyCare.com. Architected and developed a single consolidated agile enterprise HCP database, spanning across 13 business units, allowing unprecedented segmentation and communication opportunities. Developed back-end for Marketing Tableau Dashboards incl. Lead Funnel, segmented Email Response reports. Automated survey response key matching, built real-time reporting dashboards, and scorecard generation for enterprise wide surveys; mapped and delivered reports for each level of the corporate hierarchy. Managed, designed, and executed campaigns in IBM Campaign (i.e. Patient Education, HCP CRM, Employee Engagement, Patient Experience surveys, etc.). Managed and documented Veeva Vault marketing-agency creative collaboration process re-design and Digital Asset Library development. Designed and executed back-end update cycles for all internal marketing databases including HCP, Employee, & Facilities.
Database Manager at LEK Consulting from June 2015 – May 2016
Managed day-to day operations of global Market Research DBMS and created workflow processes and standard forms for receiving and fulfilling requests from staff. Developed and performed routine maintenance and updates to ensure the hygiene and integrity of the database. Designed & developed enhancements to the DBMS and its UI to facilitate its usefulness to staff. Established and redesigned processes with Accounting for the remittance and tracking of payments to research experts as well as the collection of information needed for tax reporting. Provided assistance and guidance to staff requiring service support for expert contact requests. Supported consulting staff in big data client projects.
Business Systems Analyst at Merkle Inc. from June 2013 – June 2015
Elicited and documented requirements and acceptance criteria at multiple levels of detail for Merkle’s database solutions; both new solutions, and extensions to existing solutions. Reversed engineered SAS nodes from legacy solution to create documentation for replatform.
Operations Analyst - Intern at Merkle Inc. from June 2012 – August 2012
Executed client database updates and compiled analysis for operations team leadership regarding stored procedure runtime performance, based on time of day and day of week.
Skills
SQL: developing, ETL, testing, and querying/analyzing databases; MS SQL Server, Oracle, MySQL, & Netezza.
Data Visualization: Tableau, Power BI
Python: Built and extracted dataframes from flat files, websites (HTML, JSON, etc.), and pushed to databases. Developed and tested algorithms and calculated fields.
Campaign/Data Management: IBM Campaign (Unica), Alteryx, RedPoint Interaction & Data Management, and SAS
Excel & VBA
Requirement Gathering & Documentation
Public Speaking & Powerpoint: completed Toastmaster’s
Education
Rensselaer Polytechnic Institute
B.S. in Business Management - Management Information Systems; Graduation: May 2013
GPA: 3.44
Activities: Varsity Baseball Team Captain, 2x Academic All American Nominee, 2x Academic All Conference, 3x All Conference