Collaborate with developers to design and develop SQL Server databases

Develop new and maintain existing applications with backend in SQL and frontend in MS Access

Create and maintain stored procedures, functions and proficient in working with SQL

Analyze and validate system requirements and processes and information systems for SSRS

Evaluate existing and new system functionality to determine requirements and develop action plan to transfer reports from Crystal Report to SSRS report

Evaluate existing MS Access application functionality to determine requirements and develop action plan to correct deficiencies

Investigate and resolve application functionality-related issues and provide support and troubleshooting of production systems

Responsibilities span from developing and maintaining billing database to office management to staff training. Maintain full authority over accounts receivable and payable in QuickBooks.

Key Accomplishments:

" Revised data storage and transfer during a period when procedures for Medicaid billing underwent a vast transformation. Greatly reduced the impact of the turmoil this change caused by adjusting how the billing information was presented to the scheduler.

" Improve office functionality by providing training to newly staff.

" Conduct root cause analysis to resolve technical and non-technical problems and to improve standard operating practices.

Primary responsibilities included ETL (Extract, Translate, and Load) and reporting, exporting data from vendor files, verification of accuracy, creating and maintaining programs, database development, and data mapping to convert from multiple sources for consistent presentation in a standard format.

Key Accomplishments:

" Most notable achievement was using MS Access to design and construct a program which extracted information from the SQL server, exported to Excel, ran macros in MS Excel to format files, saved copies to permanent storage, accessed Outlook, and generated e-mail notifications. All done either fully automatically, or a user could review the outgoing e-mails, make adjustments to the information, and manually send the notifications. This program eliminated a process which took accountants up to two days to complete, and reduced the time to ten minutes or less.

" Designed and built the programs which governed the Sales, Operations, and Accounting departments.

" Converted inconsistent raw data from multiple different vendor formats into legible and usable reports that were accurate and beneficial for the successful growth of the company.