Data Accounts Payable
Resume:
Adam C. Dyas
Denver, CO ***05
********@*****.***
Professional Profile
Results-oriented financial services professional exemplified by a steady
increase of responsibility. Five years of experience in time-sensitive,
fast-paced environments. Highly developed skills in oral and written
communications, multitasking, attention to detail and perseverance to
completion. Extremely proficient with accounting concepts and the
technical aspects of financial analysis and reporting.
Education
Capital University, Columbus, OH, MBA candidate, 2010
The Ohio State University, Columbus, OH, BS Business Administration, 2007
Professional Courses
Advanced Excel Hyperion Essbase
Advanced Access Hyperion Explorer
Intermediate SQL PeopleSoft
Professional Experience
Nationwide Insurance/Nationwide Financial June 2005 -
October 2009
Sr. Statistical Data Analyst March 2009 -
October 2009
. Review and analysis of external statistical materials and determination
of reporting requirements.
. Analysis and elimination of statistical errors for all reporting agencies
as required.
. Development of statistical and financial data modeling reports for
specific companies and lines of business as required by both internal and
external entities.
. Formulation and execution of audit practices to ensure data integrity and
elimination of variances in multiple mainframe environments.
. Processing and monitoring of accounts payable and receivable in terms of
assessment and reinsurance fees.
. Construction of budget forecasts to determine viability of new products
and areas of operation.
. Transfer of Access and IBM AS400 data into Excel spreadsheets for
manipulation and data extrapolation.
Financial Analyst March 2007 - March
2009
. Analysis of database errors in various process flows and application of
corrective procedures to reverse and correctly reapply erroneous
transactions.
. Reconciliation of various books of business against independently
generated financial reports and the corporate general ledger.
. Formulation and implementation of new process standards designed to
increase efficiency while decreasing the likelihood of errors in a given
procedural flow.
. Development and facilitation of process automation utilizing various
platforms and secure file transfer protocols.
. Database development and maintenance.
. Securing incoming deferred compensation statements in CSV format,
transferring said data into Excel and uploading information into various
internal platforms.
. Development of several Excel spreadsheets using advanced functions such
as Vlookups, Macros and Pivot Tables in order to facilitate database
corrections.
Sr. Financial Services Technical Representative March 2006 - March
2007
. Facilitation of exchanges, deferrals, loans and distributions into and
out of participant accounts via an AS400 database.
. Processing of daily financial activity and compilation of various trade
instructions to internal and external purchasing entities.
. Analysis of trade matrices for customized plans and resolution of data
discrepancies or problem issues.
. Service as auxiliary Team Lead and participation in multiple high volume
fund mapping projects.
. Manual entry of deferred compensation amounts with a high degree of
accuracy.
Claims Support Representative June 2005 - March
2006
. Provided first line customer support contact for claims reporting
activity.
. Creation of loss reports by securing information from various parties and
establishment of the claim master record.
. Verified coverage under various policy provisions based on variances of
line of state, jurisdiction and regulatory requirement.
. Direct assignment of duties to inside and field claims adjustment
personnel.
. Inputting claims information into internal systems in a quick and
accurate manner.
Software Proficiency
AS400, Crystal Reports, Business Objects, FRX, Google Analytics, Omniture,
SQL, Access, Word, Excel, Visio, Microsoft Project, Quicken, Quickbooks,
Essbase, PeopleSoft, Bloomberg Terminal and Hyperion Explorer.
References
Available upon request.
Contact this candidate