Accounting Customer Service
Resume:
Audrey Lynn
TECHNICAL SKILLS
Computers: AS/400, PC, Compaq Servers, Digital VAX II, Scanning (imaging) System
Software: Windows NT, Windows 98/2000/XP/Vista/7, VTA, SQL, Viewpoint, Microsoft Office Pro, Great Plains, Dynamics, eEnterprise, C/S+, FRx, Paychex, MetaFrame (Citrix), Terminal Server, Platinum, GroupWise, Crystal Report Writer, Outlook, Excel, Internet Explorer, AcuPrint, Visio, Project, cc:Mail, Monarch, Timesheet Pros, Scheduler, Quattro Pro, Word, Access, PowerPoint, PowerBuilder, File Magic, Software 2000, Diskeeper, Seagate Backup Exec, PC Tools, Timbuktu, McAfee Anti-Virus, ACCPAC Plus, CMS, InfoPro, SharePoint, QuickBooks. G/L, A/P, A/R, Fixed Assets, Ad Hoc Reports, Financials, SQL, Excel VB, Payroll, P/O
PROFESSIONAL EXPERIENCE
Forge USA, Houston, TX 9/2011 – 12/2011
Accounting Supervisor/Data Analyst
• Supervise AP, AR and HR. Work with excel, SQL, Great Plains Dynamics, Paychex, TImeForce and MS Access.
• Created macros (VB) to automate paychex data upload into Dynamics.
• Reconciliation of accounts and daily bank balances; created cash forecasts; accrued purchases/steel.
• Created smart lists for use in analysis and other users.
• Special projects included inventory analysis, vendor research, collections review, Dynamics reports and others assignments.
BP America, Houston, TX 11/2010 – 9/2011
Data Analyst
• Maintain learning system. Work with excel, SQL, access, crystal reports, VTA system.
• Analyze data from SAP system and other learning systems to update VTA system.
• Created macros (VB) to automate the updates of data and analyze cross referenced data.
• Work with international users of the VTA system.
• Coordinate with the regional administrators of the VTA system for setup/maintain of users and reports.
• Assist other administrators with funcationality of VTA system.
Access Mediquip, Houston, TX 09/2008 – 03/2010
Data Analyst
• Worked on special projects to improve processes; created Excel macros for payroll upload; setup payables credit card remittance to automatically e-mail to vendors, created budgets, formatted reports, and completed departmental financials formatting
• Created pivot tables of department budget data and purchase orders; wrote reports through FrX financials; modified smart lists and native reports; created SQL queries to update COA, reviewed batches, and deleted batches; used SQL to extract data for excel manipulation; completed various projects with Access database
• Performed accounting support of accounts payable, accounts receivable, purchasing, fixed assets, general ledger, receivables, and other special projects
Enterlogix, Houston, TX 02/2008 – 08/2008
Consultant
• Served as a Consultant for a Microsoft partner to support Great Plains ERP software; trained on accounting software, performed implementations and software configurations, and created FrX financial reports
• Provided on-site training of users for various modules including general ledger, payroll, receivables, payables, purchasing, fixed assets, project accounting, inventory, and multicurrency; performed SQL queries, updates, and phone support
A Byte of Accounting, Houston, TX 11/2007 – 02/2008
Consultant
• Assisted clients on streamlining business processes; provided Excel training, managed the access databases, and performed VB macros and bank reconciliations
Allied Waste/BFI National Accounts, Houston, TX 04/2002 – 11/2007
Data analyst
• Analyzed data from AS400; created and generated data warehouse reports; downloaded/formatted data into Excel files
• Created and maintained Access databases, created front-end databases for users and SQL queries with AS400 data; created and maintained Excel VBA macros
• Taught Excel classes from basic to advance and worked with personnel within division; departments included billing, payables, sales, support, customer service, implementation, management, and executives
Accountemps, Houston, TX 11/2001 – 04/2002
Consultant
• Trained on accounting software; setup and configured Crystal Reports and ODBC, performed bank reconciliations of lockbox/disbursement accounts, and created spreadsheet macros
Preferred Management Services, Houston, TX 03/2000 – 10/2001
Consultant
• Served as a Consultant for accounting software including Great Plains Dynamics, eEnterprise, Platinum for Windows, Platinum SQL, FrX, Siebel, and Crystal
• Performed training, installations, ad hoc reports, ODBC setup/configurations, and upgrades
• Reports included FrX financial reports and access databases; modified reports within Crystal report writer
• Performed SQL installation, upgrades, and telephone support
Schlumberger Omnes, Houston, TX 08/1996 – 12/1999
Accounting Systems Administrator
• Worked with Windows 95/NT, SQL, Citrix Servers, and PCs
• Maintained accounting systems and six servers; assisted users locally and globally and supported international regions
• Performed monthly financial reporting, maintained and created accounting reports and ad hoc reporting, and trained on accounting applications
• Performed special tasks including received and transferred data into Access database and billing system, performed project tracking, and created a Visio flowchart
• Monitored servers, created and maintain SQL databases, corrected license issues, and ensured security
• Assisted users with application issues and PC issues, installed and updated accounting software, and wrote procedures; provided McAfee virus protection and updates, maintained backup for servers, and monitor servers through Timbuktu
MAXXAM Inc. Holding Company, Houston, TX 01/1992 – 07/1996
Accounting Systems Coordinator
• Served as the liaison between accounting and MIS department; maintained accounting systems on AS 400 and PCs Windows 3.11; provided software training on accounting applications
• Created and maintained models including Lotus 1-2-3 macros, Paradox, and Monarch for rebills, familiar with marketable securities and wire transfers
• Troubleshot software and hardware issues, assisted users with computer issues, and researched computer software and products; installed and upgraded PC software and hardware as needed
• Served as the company standards representative, tested products, wrote standards and procedures, and researched and implemented File Magic document/imaging management system
Steffen, Robertson & Kirsten/Consulting Engineers & Scientists, Lakewood, CO 05/1989 – 09/1991
Financial Systems Administrator/Accountant
• Maintained accounting computer systems (DOS base)
• Familiar with ACCPAC Plus financials
• Created and maintained general ledger for branches plus the holding company; performed accounting for three branches located in various states including payroll; supervised A/P, audited and reviewed computer entry for all phases of accounting, assisted controller, reviewed monthly financials, installed and upgraded software as needed
• Provided conversion setup, and implemented and trained on the ACCPAC accounting system
• Software included Smart, Quattro Pro, Lotus 1-2-3, Word Perfect, and ADP
Martin & Martin/Consulting Engineers, Wheat Ridge, CO 07/1987 – 04/1989
Systems Administrator
• Maintained computer system, installed and performed backups, trained on accounting system and Lotus 1-2-3;
• Worked with bank rec's, JE's, G/L, and fixed assets
• Assisted controller with special projects, year-end audits, and scheduling tax & year-end accounting personnel; prepared schedules, answered questions, and completed reviews
QGGH, Houston, TX 1/2010 -12/2010
Treasurer – Quilt Guild of Greater Houston
• Served on board as treasurer, created budgets, and worked with President on financials and rules of the guild. Accounting kept records on QuickBooks
EDUCATION
AA Business, Front Range Community College, Westminster, CO
University of Colorado @ Denver, CO
Houston Community College, Houston, TX
Penn Valley Community College, Kansas City, MO
CERTIFICATIONS
ITIL Certification
SQL Certificate
Outlook Certificate
Crystal Reports Certificate
MS Access Certificates
Excel Certificates
Contact this candidate