Data Entry Development Consultant

Karen M. Gatz Page *

Karen M. Gatz

****@*********.*** 631-***-****

SUMMARY OF QUALIFICATIONS

An experienced data and statistical analysis professional with background in software development and data analysis. Excellent communicator, both written and verbal, enhanced by teaching college level mathematics and statistics as an adjunct professor. Outstanding business analytics skills for understanding and interpreting customer requirements in conjunction with assessing and promoting my project team members’ strengths and abilities. CORE COMPETENCIES

• Leadership Skills • Communication Skills • Innovative Vision

• Team Motivator • Process Improvement • Data Analytics

• Story Telling • Organizational Skills • Statistical Analysis

• Training/Mentoring • Technical Writing • Data Visualization

• Collaborative • Project Management • Strategic Thinking PROFESSIONAL EXPERIENCE

Sea Tow Services International, Southold, NY October 2021 – current Data Entry, Integrity and Analysis Supervisor

• Oversee daily operations of data department team and all data entry and integrity efforts using data analysis tools such as SOQL, Excel and R.

• Create written user documentation and training videos for more complex processes in the Salesforce system.

• Create reports and dashboards in Salesforce to gain business insights and assist in membership growth.

• Collaborate with accounting team to ensure data accuracy for reconciliation and close. Greystone Property Management, Southampton, NY July 2019 – October 2021 Data and Marketing Analyst/Operations Manager

• Conducted data analytics and segmentation projects for geotargeting and marketing research with data from CoStar data combined with local market data using Tableau and R/RStudio.

• Processed daily business data for invoicing, vendor payments and tenant communications.

• Streamlined processes by creating work-flow documents to enable tasks performed regularly to be done consistently and accurately.

SUNY Suffolk County Community College, Riverhead, NY Aug 2005 – October 2021 Adjunct Mathematics & Statistics Professor

• Designed curriculum and delivered instruction to a class-size of 35 students for: Pre-algebra, Algebra, Survey of Mathematical Reasoning, Survey of Contemporary Mathematics, Statistics, and MathLab.

• Developed and taught the online college level math courses: Survey of Contemporary Mathematics and Statistics. Lockheed Martin May 2018 – July 2019

Senior Data Scientist Analyst, Shelton, CT

• Primary project was to measure performance to contract by creating Supply Chain Tableau dashboards identifying actionable items.

• Performed other data analysis work using SQL, Excel and R to identify data anomalies and identify data sources. Oct 2016 – May 2018

Senior Mathematician, Melville, NY and Rockville, MD

• Supported energy efficiency contracts by employing statistical analysis, including data analytics, visualizations and predictive analytics for targeted marketing and demographic studies using Tableau and R/RStudio.

• Created statistical analysis for survey data through the open source tool, R/RStudio. The analysis was converted from various sources (Microsoft Access, Excel, and SAS) and created in such a way that new survey data sets can be ingested without updates to the core analysis.

• Conducted research for data acquisition to supplement program data both private and open source. Used various open source data to supplement program, such as data found from US Census and Open PV Project. Karen M. Gatz Page 2

PROFESSIONAL EXPERIENCE (CONTINUED)

Northwestern University, Evanston, IL Sept 2018 – May 2019 Adjunct Faculty in Masters in Data Science Program

• Taught Applied Statistics using R

US Department of Transportation, Washington, DC Jul 2013 – Nov 2015 Senior Software Development Consultant (via Engineering & Software Consultants, Inc.)

• Improved Cost and Schedule Risk Template for Federal Highway projects $500 million or higher by analyzing the statistical modeling. Developed graphical user interface to assist in the process of gathering the project based cost and schedule data using Excel VBA; eliminated excess manual steps and streamlined user process.

• Served as expert advisor for redesigning Superpave software. Previously served as lead software developer on the Superpave program. Provided written and verbal specifications of formulas and processes including regression analysis for best asphalt blend using test data captured from the mobile asphalt labs.

• Created and consolidated content and design of the user manual for Superpave software assisting end user on proper usage.

• Ensured formulas and mathematical processes were achieved by managing and performing extensive software testing, including creating test cases and developed test result log.

• Created testing results log by capturing Superpave software functional specifications in need of modification and provided clear written descriptions to programmers.

• Verified data structure compatibility and created a data conversion process and implementation from older version of Superpave software to updated version in MS Access. Long Island National Golf Club, Riverhead, NY Jan 2010 – Jul 2013 Senior Information Technology Consultant

• Formulated and implemented strategic plan for new information technology platform to integrate various business functionality which incorporated over sixty employees.

• Directed Point-of-Sales software conversion project, including vendor research and evaluation, reconciling business needs and software, full implementation and employee training.

• Integrated the company’s first online reservation system with Point-of-Sales software allowing business to be fully integrated technically and functionally which increased monthly revenue by 15%.

• Developed web content for website redesign project to create a user centric interface which integrated with the business’ social media.

• Managed inventory controls and cataloging for ProShop and Restaurant with Point-of-Sales software. Implemented inventory receiving procedures and monthly inventory controls to reconcile physical inventory. US Departments of Transportation, Defense and Labor, Washington, DC Jun 1992 – Jun 2004 Software Development Consultant, Senior Software Engineer, Senior Management Analyst EDUCATION

• Northwestern University at Evanston, IL: Masters in Predictive Analytics Capstone Project: Improving Airline Operational Efficiency, Profitability, and Customer Satisfaction

• University of Vermont at Burlington, VT: Masters in Mathematics and Education Received full assistantship and Graduate Teaching Fellowship

• LeMoyne College at Syracuse, NY: Bachelor of Science in Computer Science, minor math & physics CERTIFICATIONS

• Project Management Professional Certification; PMP Number 1953859; August 2016 – present

• Certified Scrum Master, CSM Number 000787785, May 2018 – present TECHNICAL SKILLS

• Salesforce, R/RStudio, Tableau, Microsoft SQL, Visual Basic for Applications for Access and Excel, Microsoft Word, Excel, PowerPoint, Access, Project, Visio, Visual FoxPro, OneNote, QuickBooks

Contact this candidate