SUMMARY OF QUALIFICATIONS:
* Report Writer and Data Analyst
* Eleven Years Healthcare Experience
* Proficient in Visual Basic, C# and other programming languages
* Excellent time management skills - consistently meets or beats deadlines
EXPERIENCE:
3/06 - Present: Report Writer
* Enterprise level report writer who translates functional and technical
specifications into clear and concise Clinical, Financial and Administrative
reports
* Converted over 50 legacy reports to SQL Reports during the first 3 months of
employment
* Designs, develops, modifies, tests and supports reporting solutions for a
Community Hospital
* Experienced with SQL Reporting, Crystal Reports, HBI, Business Objects and
other report writing tools utilizing DB2/400, SQL Server, Access, Excel , Flat
files and other datasources
* Fluent with multiple development tools and languages including Visual Studio,
SSIS, VBA, VB.net, C# and T-SQL including Stored Procedures and User Defined
Functions, SQL/400, AS400 Query language, CL, et al.
* Developed applications to allow Nurse Auditor to defend charges to Medicare
Auditor
* Developed application to automate collection phone calls to self-pay patients
meeting collection criteria
* Adept at data analysis , manipulation and building translation routines to
create or update database tables
3/98 - 2/06: MIS Department Manager - West Yavapai Guidance Clinic (WYGC)
* Managed MIS Department Hardware, Software and Network Administration staff as
well as intake/enrollment staff as required to support clinical, administrative,
accounting and billing systems for an Inpatient/Outpatient Mental Health
organization
* Developed and implemented a work order tracking application to manage tasks
and compile statistics related to the replacement of PCs, VOIP Phones, employee
productivity, etc.
* Successfully implemented HIPAA 837 and 834 transactions with no lapse in
billing claims or enrollment submission
* Managed project to move from a UNIX based legacy software system to a more
modern, windows based system
* Developed Unix and TCL scripts
Financial Services Supervisor - West Yavapai Guidance Clinic
* Supervised intake/enrollment staff
* Resolved data submission problems to facilitate collection of claims valued
in excess of $1,000,000 - claims were previously denied because Arizona Medicaid
(AHCCCS) enrollments were rejecting, thereby causing claims to be denied
* Designed and developed reports to isolate data entry errors before data
submission. Increased on-time enrollments by 45% resulting in additional revenue
incentives from the State of AZ
Systems Analyst - West Yavapai Guidance Clinic
* Responsible for learning a Custom Clinical and Financial Unix based software
application (CMHC) and its proprietary DBMS Database Schema
* Used specialized report generation language to design billing specifications
in the format needed to produce electronic billing files for EDI claims
submission
* Developed custom reports to check for claims submission errors (i.e. using
wrong billing codes based on units of service, etc.) resulting in an increase in
the number of claims passing edits on the first attempt.
* Prepared UDS reports as required for submission to the United Health Service
Corp.
* Developed numerous custom reports including Clinical reports, Financial
reports, Productivity reports, Administrative reports and payroll reports.
1/84-1/90 Project Business Manager - Motorola Government Electronics
* Responsible for assisting the Technical Project Leader with managing the
budget and schedule on a $31 Million Dept. of Defense contract.
* Designed a time-phased work-breakdown structure to implement a cost/schedule
database-tracking tool using Microframe Project Management Software.
* Responsible for delivering contract required Monthly Project Status Reports
to the Dept. of Defense - the amount of Award Fee for on-time delivery of these
documents tripled after I assumed responsibility for the preparation and delivery
of these documents.
* Other responsibilities included proposal preparation and Contract
Negotiations for Amendments to the Contract.
Computer Systems Manager - Motorola Government Electronics
* Managed a variety of computer systems including HP1000s used in VLSI computer
labs, VAX 11/750 and HP64000 clusters, MicroVax II and Sun workstations.
* Duties included coding data conversion programs in Fortran and Pascal, and
design, code and unit test of a software configuration management system.
* Supervised software technicians as required.
EDUCATION
Bachelor of Science (BSBA) - Computer Information Systems - Suma Cum Late
Arizona State University, Tempe, AZ
Government Contracts Management - Professional Certificate
University of Phoenix, Phoenix, AZ
Currently Studying ASP.Net Development in order to get MCPD Certification
|