VHKB
Resume 12/25/2006
admin at peppermesa dot com
www.peppermesa.com
Albuquerque, NM USA
Skills
A detail-oriented professional with seven years of experience working with SQL databases, including data analysis, programming, administration, and reporting. Good history of nurturing strong working relationships with customers and staff. Concise communication and problem-solving skills provide improved efficiency and reduce error rates.
Experience
2002 - Present NM Retiree Health Care Authority
Albuquerque, NM
Began my tenure as a contractor for POD Assoc., and was hired to the agency on September 2006.
- Programming, administration, maintenance, and optimization of the Eligibility, Billing, and Employer databases, which reside on SQL Server with an MS Access interface.
- Upgrading database user-interfaces with an ASP.NET front-end using VB.NET.
- Upgrading and maintaining EDI processes using SQL Server, BizTalk, and C#. NET.
- Managing monthly billing cycles, ACH file transfers, posting payments, and reconciliation of eligibility.
- Maintenance and updates to the agency’s website.
- Maintaining the document imaging database, OTG Application Xtender scanning software and scanning stations.
- Performed gap analyses of the systems for upgrade to HIPAA 837 and 834 transactions.
- Improving processes and communications with the health plans and pensions regarding EDI transactions to reduce EDI file error rates.
- Maintaining Windows 2000/2003 based servers, including backups, updates and optimization.
- Desktop and network support as necessary for end-users and staff.
2002 - 2003 Burge Consulting
Albuquerque, NM
Owner
- Worked on a per hour basis performing maintenance and optimization of SQL Server databases and MS Access applications.
2001 - 2001 Kemtah
Albuquerque, NM
Staff Accountant
- Accounts receivable through invoice and collection methods.
- Managed accounting for fixed assets.
- Financial reporting using Great Plains, MS Access, and MS Excel.
- Compiled and analyzed transactions to general ledger using Great Plains.
- Assisted in preparing supporting schedules for company audits.
Career Academy Coordinator
- Registered students, developed course schedules, and coordinated student billing.
- Certified to administer exams for MOUS Certification and VUE Testing Center.
- Development and maintenance of monthly revenue reporting, book inventory, online enrollment and course evaluation analysis using MS Access and Excel.
1996 - 2000 Sunsoft Corporation
Albuquerque, NM
Market Research Analyst
- Developed standardized and ad hoc reports with MS Access and Oracle.
- Developed Access databases for use as survey instruments.
- Data analysis and competitive analysis review of industry publications.
Administrative Assistant
- Supported the Executive Officer of Sales and nine sales professionals.
- Maintained communications to customers and managed all administrative tasks.
- Developed sales reports used for analysis of sales efforts with MS Access and Oracle.
Education
2000 - 2001 Masters of Business in Administration, GPA 3.76
University of Phoenix, Albuquerque, NM
1993 - 1995 Bachelor of Science in Business Administration
University of Phoenix, Albuquerque