Data Processor or Data Analyst

DOUGLAS MCGALLIARD

614-***-**** *********@*******.***

Accomplished data management professional offering a strong background in operations support, analysis,

report development, system support and process improvement, Combines proven success in integrating

technology, organizing and streamlining business processes and identifying customer-based solutions. Self-

motivated with the ability to set effective priorities to achieve both immediate and long-term goals.

Data Processing • System Support • Process Improvement • Report Development

Database Analysis • Business Process Analysis • Process Automation • Data Entry

Requirements Analysis • Test Development • Department Training

COMPUTER PROFICIENCIES

Microsoft Excel, Access, Word, PowerPoint, Outlook, SharePoint, Smartsheet, SQL,

SAP (ECC/HANA), ServiceNow, Salesforce, Adobe, Power BI, Power Query, Tableau, VBA

PROFESSIONAL EXPERIENCE

Freelance Data Processor March 2025 – December 2025

• Collected and maintained account specific information in a claims management system(Auto and P&C) allowing for easier reporting

• Resolved 95% of customer service issues by resolving data integration errors on their policy and providing amendments to policies

• Met 100% of the quality and productivity goals by processing coverage, premium, carrier, broker and client/insured data

• Created a database for documentation for open claims allowing for 100% quicker access to documents

• Utilized Microsoft Excel to organize and clean data providing greater visibility and accurate reporting

• Processed data requests through ServiceNow ticketing system and developing reports within 24-hour turnaround

• Maintained production SLA’s by utilizing Tableau and SQL to create a daily production dashboard

American Electric Power – Functional System Analyst November 2024 – March 2025

• Resolved 90% of meter outages, network issues and other related malfunctions using my strong analytical and system support experience

• Maintained weekly meter reporting data utilizing Microsoft Excel, Word and SQL resulting in easily accessible data and work documentation by management

• Utilized internal electric utility applications to resolve issues including Operation Optimizer, QMF, MDM, AIQ, MACSS, Smartsheet, Visio, Sparkhub, AWS-Athena

• Utilized Power BI to define trends and discrepancies in meter data allowing for 90% increase in targeting correct meters and determining failures

• Maintained Access database of production data for entire department, allowing for quick review by management and removal of 7 other reports no longer needed

• Removed potential errors in analysis by 90% by creating process documentation for daily production activities

American Honda Motor Company – Data Entry Analyst March 2023 – July 2024

• Performed new hire entry into SuccessFactors with a focus on accuracy and completeness, utilized Microsoft Excel to create and maintain tracking sheets for all production work

• Analyzed data for pay related issues, collaborated with payroll, compensation, recruitment and other analysts to resolve issues, performed updates and generally maintain the data in an organized and clear manner

• Responded to tickets in a timely manner to resolve associate issues, proactively analyzed and made corrections to pay so as to reduce the number of tickets, this resulted in a 60% decrease in the amount of tickets

• Modified employee records to correctly capture step progression and employee movement data, replicated employee salary changes from EC to ECP, ensured replications succeeded correctly

Wright State University – Database and Project Analyst August 2019 – March 2023

• Streamlined quarterly budget reports and financial reports by 90% by eliminating data spread across multiple Excel workbooks and databases and creating a central location for all data

• Developed comprehensive project tracking templates that improved visibility into progress by 80% and reduced required status update meetings by 2

• Implemented a centralized knowledge management system that was 100% more efficient than the current system for locating documentation and training materials

• Maintained department SharePoint site by integrating Word and Excel as well as web-based forms which improved document tracking by 70%

• Utilized Salesforce to maintain all activity and accounts, performed extensive data entry and utilized Microsoft Excel to perform analysis

• Automated 50% of the reporting being done which eliminated 60% of the paperwork and streamlined processing through multiple systems

• Created a unified system to store data by integrating from Excel, Access and internal university systems (Ellucian) which saved the department $1500 in additional cost to store the data

• Developed department ad hoc reporting utilizing SQL and Power BI which saved management 2-4 hours per day performing research

Chemical Abstracts Service – Sales Support Associate April 2018 – August 2019

• Supported and managed territories for 4 sales representatives, maintained access to CAS’s products for commercial and academic customers by troubleshooting login ID and passwords and network access

• Created contracts for all new customers and ensured any contract changes were reconciled with billing and notifications sent to client

• Created invoices, maintained pricing, created quotes, utilized SAP and Salesforce heavily for processing

• Performed complex contract setup for large academic consortium, Maintained SAP hierarchies for academic and commercial customers

• Automated client service order processing that led to a 70% decrease in processing errors

• Developed SOP’s and documentation supporting master data initiatives, documentation provided roadmap to efficient data management and quality control over data

• Improved visibility into Salesforce accounts and cases by 100% by integrating related Outlook emails into the application, allowed for easier follow up and project tracking

Red Roof Inn – IT Operations Administrative Analyst August 2014 – April 2018

• Resolved 100% of internal reservation and call center application issues by applying fixes and performing software updates

• Analyzed and updated data in the HRIS application, Maintained data after upload from previous system, resolved reporting errors through analysis and developed macros for processes frequently used, ensured data was 100% correct within the system

• Trained individuals and groups on application updates and system enhancements ensuring all 50 users were successful in their positions, Utilized PowerPoint as additional information to provide group participants

• Maintained security and reports within SharePoint site ensuring continuity of data and integration of over 30 workflows

EDUCATION

Bachelor of Science Degree in Management Information Systems

Wright State University Dayton Ohio

Contact this candidate