Please enter the password you have been provided to view this resume
Email
Richard Valdes
Valdes Resume
Richard Valdes
4810 W. Darrel Rd. Laveen, AZ 85339
valdesrl@cox 602-297-8870 602-327-7244 (cell)
Accountant
Results oriented accountant with bachelors in accounting and over 16 years of diverse experience. Proven results in applying continuous process improvement. Outstanding problem solving abilities. Excellent data mining and data testing skills.
Core competencies include:
Month End Close; Financial Analysis; Journal Entry
Report Writing; Quarterly Statements; G /L Reconciliation
Intercompany Receivables; Database Queries; Software Conversation
Education / Credentials
University of Maryland, University College, College Park MD Bachelors in Business Management, Accounting Concentration, June 1993
Professional Experience
Affiliated Computer Services, Tempe, AZ
August 2010 - present Invoices & Receivables for General Motors
Accountant August 2010 - present
Maintain invoicing database for individuals related to overseas expenses.
Key Achievements:
Generate monthly invoices to overseas customers for General Motors NA.
Generate daily registers for overseas invoices.
Republic Western Insurance Company, Phoenix, AZ
December 2000 - July 2009 Insurance provider for U-Haul Inc.
Business Analyst August 2007 - July 2009
Analysis of user requirements, outlining business rules for processes, and data testing.
Key Achievements:
Create business intelligence reporting using Business Objects
Develop ETL data transfer mappings using Informatica.
Maintain and modify company BBS website knowledge base
Senior Financial Analyst June 2003 - July 2007
Responsible for the monthly and annual ceded reinsurance calculations. Posts journal entries for ceded accruals. Prepares wire transfers for ceded reinsurance.
Key Achievements:
Continue to assist other departmental members with software application support as well as Premium Accountant functions
Premium Accountant December 2000 - May 2003
Responsible for the maintenance and monthly implementation of data translation programs (bridge) between the primary data source (AS-400/WINS) and the general ledger (AS-400/WINSFIS). Posts journal entries and any manual adjustments into the general ledger. Prepares monthly billing for U-Haul receivables of premiums and reconciles those ledger accounts.
Key Achievements:
Assist other departmental members with software application support including; large scale data downloads, file imports, ODBC links, macros, and data manipulation issues utilizing the AS-400, Excel, or Access.
Jasper's Restaurants, Beltsville, MD
January 1991 March 1994 and April 1996 June 2000 Restaurant Chain
Accountant April 1996 - June 2000
Reconciled select general ledger accounts, including the cash account. Reconciled special checking, payroll, and overall operating (A/P) bank accounts for each location. Reconciled inter-company receivables between the three restaurants. Prepared and entered end of period standard and adjusting journal ledger entries. Prepared on-going estimate and actual payroll analysis reports.
Key Achievements:
Created and provided on-going modifications to financial statements, reports, budgets, and templates in the Solomon IV accounting system; to reports in the ABRA payroll system; to spreadsheets and macros in Excel; and to data bases in Access.
Provided staff with MS Office and Windows95 solutions, as well as automated many functions.
Payroll Clerk January 1991 - March 1994
Processed complete cycle of separate biweekly payrolls for three restaurants, approximately 110 paychecks per location, consisted of salaried, hourly, and hourly-tipped employees. Prepared federal and multi-state payroll tax submissions. Administered health benefit package.
Technology Skills
MS Excel: In addition to standard spreadsheet use - Link spreadsheets, link external data sources, create and edit macros and macro buttons within a spreadsheet, create spreadsheet templates in order to automate routine tasks, delimit text files
MS Access: Import & export data, create external data links, queries, forms, macros, menus, and reports
MS SQL Server: create and do modifications of databases.
Business Objects: Client based and WebBO - analysis for report requirements from tracing source data to requests for adding objects into specific universes, and including testing, report creation and scheduling.
Informatica: analysis for user requirements including ETL mapping for data transfers.
AS/400: Create data queries both within the system as well as ODBC links to both Excel and Access. Maintain Data tranfer table for conversion from WINS to WINSFIS for journal entries.
Solomon IV: In addition to full knowledge of the Setup, General Ledger, and Accounts Payable Modules. Setup a new Database (company), do customizations of the Menu, create complex financial statements in FRx Module, create reports with R&R Report Writer (similar to Crystal Report Writer)
ABRA: In addition to full knowledge of Payroll processing functions of the program - Created reports with the Report Writer
PhpBBS: add modifications to phpBBS based company website
4810 W. Darrel Rd. Laveen, AZ 85339
valdesrl@cox 602-297-8870 602-327-7244 (cell)
Accountant
Results oriented accountant with bachelors in accounting and over 16 years of diverse experience. Proven results in applying continuous process improvement. Outstanding problem solving abilities. Excellent data mining and data testing skills.
Core competencies include:
Month End Close; Financial Analysis; Journal Entry
Report Writing; Quarterly Statements; G /L Reconciliation
Intercompany Receivables; Database Queries; Software Conversation
Education / Credentials
University of Maryland, University College, College Park MD Bachelors in Business Management, Accounting Concentration, June 1993
Professional Experience
Affiliated Computer Services, Tempe, AZ
August 2010 - present Invoices & Receivables for General Motors
Accountant August 2010 - present
Maintain invoicing database for individuals related to overseas expenses.
Key Achievements:
Generate monthly invoices to overseas customers for General Motors NA.
Generate daily registers for overseas invoices.
Republic Western Insurance Company, Phoenix, AZ
December 2000 - July 2009 Insurance provider for U-Haul Inc.
Business Analyst August 2007 - July 2009
Analysis of user requirements, outlining business rules for processes, and data testing.
Key Achievements:
Create business intelligence reporting using Business Objects
Develop ETL data transfer mappings using Informatica.
Maintain and modify company BBS website knowledge base
Senior Financial Analyst June 2003 - July 2007
Responsible for the monthly and annual ceded reinsurance calculations. Posts journal entries for ceded accruals. Prepares wire transfers for ceded reinsurance.
Key Achievements:
Continue to assist other departmental members with software application support as well as Premium Accountant functions
Premium Accountant December 2000 - May 2003
Responsible for the maintenance and monthly implementation of data translation programs (bridge) between the primary data source (AS-400/WINS) and the general ledger (AS-400/WINSFIS). Posts journal entries and any manual adjustments into the general ledger. Prepares monthly billing for U-Haul receivables of premiums and reconciles those ledger accounts.
Key Achievements:
Assist other departmental members with software application support including; large scale data downloads, file imports, ODBC links, macros, and data manipulation issues utilizing the AS-400, Excel, or Access.
Jasper's Restaurants, Beltsville, MD
January 1991 March 1994 and April 1996 June 2000 Restaurant Chain
Accountant April 1996 - June 2000
Reconciled select general ledger accounts, including the cash account. Reconciled special checking, payroll, and overall operating (A/P) bank accounts for each location. Reconciled inter-company receivables between the three restaurants. Prepared and entered end of period standard and adjusting journal ledger entries. Prepared on-going estimate and actual payroll analysis reports.
Key Achievements:
Created and provided on-going modifications to financial statements, reports, budgets, and templates in the Solomon IV accounting system; to reports in the ABRA payroll system; to spreadsheets and macros in Excel; and to data bases in Access.
Provided staff with MS Office and Windows95 solutions, as well as automated many functions.
Payroll Clerk January 1991 - March 1994
Processed complete cycle of separate biweekly payrolls for three restaurants, approximately 110 paychecks per location, consisted of salaried, hourly, and hourly-tipped employees. Prepared federal and multi-state payroll tax submissions. Administered health benefit package.
Technology Skills
MS Excel: In addition to standard spreadsheet use - Link spreadsheets, link external data sources, create and edit macros and macro buttons within a spreadsheet, create spreadsheet templates in order to automate routine tasks, delimit text files
MS Access: Import & export data, create external data links, queries, forms, macros, menus, and reports
MS SQL Server: create and do modifications of databases.
Business Objects: Client based and WebBO - analysis for report requirements from tracing source data to requests for adding objects into specific universes, and including testing, report creation and scheduling.
Informatica: analysis for user requirements including ETL mapping for data transfers.
AS/400: Create data queries both within the system as well as ODBC links to both Excel and Access. Maintain Data tranfer table for conversion from WINS to WINSFIS for journal entries.
Solomon IV: In addition to full knowledge of the Setup, General Ledger, and Accounts Payable Modules. Setup a new Database (company), do customizations of the Menu, create complex financial statements in FRx Module, create reports with R&R Report Writer (similar to Crystal Report Writer)
ABRA: In addition to full knowledge of Payroll processing functions of the program - Created reports with the Report Writer
PhpBBS: add modifications to phpBBS based company website