Administrative Support, Data Analysis, Strong Computer Skills

DOUGLAS McGALLIARD

**** ********

Oaks Blvd

Hilliard,

OH 43026

Phone: (614)

***-****

Email:

*******@*********.***

Accomplished administrative professional offering a strong background

in office administration, clerical support, computers and customer

service. Combines proven success 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.

Strong Work Ethic ( Deadline Oriented ( Strong Organization (

Multitasking Skills

Quick Learner ( Analytical ( Problem Solver ( Technical (

Quality Oriented

Customer Service Oriented ( Dedicated Team Player ( Adaptable To

Change

PROFESSIONAL EXPERIENCE

Church Of Christ - Administrative Coordinator Columbus Ohio

2012 - Current

. Performed extensive data entry, payroll, accounts receivable and

billing, handled all customer service responsibilities, created

reports in Microsoft Word, maintained Access database, performed

scheduling and handling travel arrangements

. Received daily batches of checks/invoices to key, performed keying of

invoices directly into SAP FI, Utilized Microsoft Excel to manipulate

and format the largest accounts and then export the account

information into SAP

. Mentored others in the use of the church database (Microsoft Access)

as well as performing a lead role in overseeing the office in the

manager's absence

JP Morgan Chase - Reporting Analyst Columbus Ohio

2012

. Reviewed loan modifications, foreclosures and bankruptcies for

outstanding corporate advance balances

. Performed quality audits on loans assigned to an analyst to determine

if correct decision had been made, approved or rejected loans based on

thorough research of analysts decision, utilized several tools in the

research process including MSP, LPS Desktop, Agent Desktop, Invoice

Manager, Iclear and LenderLive

. Analyzed transactions to determine what fees (i.e. attorney fees,

inspections, processing fees) were incorrectly assessed to the

borrower, making appropriate adjustments to those transactions

. Performed role of Year End Reporting Analyst responsible for

completing daily workflow routes, researching and resolving customer

issues regarding year end changes, (i.e. SSN, name changes, primary

borrower switches), performed research to resolve TIN related issues

as it pertains to 1099-INT

. Utilized Microsoft Access and Excel, MSP, CCW, CA (Customer Assist),

Ivault and TaxPort in the research process, maintained data integrity

to ensure that reportable information is accurate

Fiserv - Returns Clerk Columbus Ohio

2011

Performed credit/debit analysis on returned checks, researched

return checks for invalid address and account number

Utilized Microsoft Word and Excel to create reports to be sent to

the sponsor when correct verification of the address or account

number occurs

. Performed account reconciliation and statement processing, separated

deposits, withdrawals and cashed checks and corrected errors when

totals did not prove

Church Of Christ - Administrative Coordinator Columbus Ohio

2005 -2011

. Utilized all aspects of Microsoft Office to develop comprehensive

reports and spreadsheets, set up and maintain databases (Microsoft

Access), perform project management and maintain scheduling

. Processed payroll, accounts receivable and billing, maintained office

calendar and set up travel arrangements

. Established a courses SharePoint site that provided a central

location for all course information, integrated data from outside

sources, created all site components ( lists, columns, views etc.)

Chemical Abstracts Service - Document Management Associate

2004 - 2005

. Provided document services support in collating, scanning and indexing

documents as well as maintaining quality control (through Open Image)

on all scanned information

. Updated and maintained database of all documents sent offsite for

storage, utilized data mining techniques to retrieve documents

requested by vendors and internal employees

Reconstructed and converted a filing system of corporate accounts to more

accurately reflect corporate account information and archiving those

accounts which were inactive or canceled

. Utilized SAP MM, SD, PLM modules to maintain and update customer

master data including customer and vendor data management

. Performed extensive data entry, utilized Microsoft Excel including

pivot tables, lookup functions, formulas and macros to produce reports

Blue Cross & Blue Shield of Florida - Claims Analyst Jacksonville Florida

2001 - 2002

. Performed production support for EDI Gateway system which included

monitoring new claims processes, making modifications and edits to

incoming data files so they conform to the ANSI X12 format.

. Processed subrogation packages to be sent to the various parties

involved including attorneys, processed initial claims (took first

notice of loss claims reports), set up and maintained installment

agreements

COMPUTER SKILLS

Microsoft Access, Microsoft Excel, Microsoft Word,

Microsoft Outlook,

Microsoft PowerPoint, Microsoft SharePoint, MSP, ADP

Payroll, UNIX, AS400,

SAP MM

EDUCATION

Bachelor of Science Degree in Management

Information Systems

Wright State University,

Dayton Ohio

Contact this candidate