dana bare

Worked closely with end users to design, write and support custom reports for the Wisdom System using MS-SQL Server and Crystal Reports. - Developed programming standards and naming conventions.

* Developed web based applications with ASP, JavaScript and MS-SQL server. * Created Palm Pilot applications using GNU C. * Wrote custom reports for hospital staff using the following tools: * o MS-SQL server * o Crystal Reports * o Medical Manager * o Powerhouse 4GL

Worked with external customers to develop custom data conversions for both new and existing installations of Medical Manager. Installed, supported and trained end users on BridgeIt, a Windows based report writer for the Medical Manager system. Performed on site upgrades of the Medical Manager software. Completed Y2K upgrades and preparedness of source code for Y2K compliance.

* Support SQL Server for NextGen EPM, EHR, and ICS environment for over 100 providers in 22 different specialties. * Setup and monitor database maintenance plans for all SQL Server instances. * Automate business processes utilizing SQL Server and SSIS packages. * Perform SQL Server upgrades and database maintenance tasks. * Troubleshoot and resolve database performance issues. * Create and optimize stored procedures using SQL Server Profiler and Execution Plans. * Migrate NextGen environments between servers. * Create and configure HL7 interfaces using NextGen Rosetta and Mirth interface engines. * Create and maintain custom Crystal Reports. * Perform NextGen upgrades. * Customize EHR templates using NextGen Template Editor * Customize EHR documents using NextGen Document Builder

* Coordinated the reporting effort for the University’s Development department. * Supervised the reporting team and acted as technical lead. * Prioritized and delegated tasks as required. * Developed programming standards and naming conventions. * Worked hands on as required to assist creating reports with Oracle SQL and InfoMaker.

* Maintain all responsibilities of Senior SQL Developer/Interface Specialist in addition to the following job functions: * o Prioritize Applications team tickets and projects. * o Lead IS Applications Support Team projects. * o Weekly one-on-one meetings with each member of the IS Applications Support team. * o Act as technical lead for the IS Applications team. * o Further assist IS Manager of Application Support and Development as required.

* Support SQL Server for NextGen EPM, EHR, and ICS environment for over 140 providers in 26 different specialties. * Handle all SQL Server and interface development responsibilities for The South Bend Clinic. * Troubleshoot and resolve database performance issues. * Optimize stored procedures using native SQL Server tools as well as Solarwinds DPA. * Setup and support all internal and external interfaces. * Configure HL7 interfaces using NextGen Rosetta and Mirth Connect interface engines. * Create and maintain custom Crystal Reports.

* Responsible for administering over 140 production, Dev, QA, and high availability SQL Server instances. * Install and configure SQL Server data services and reporting services. * Setup and manage database maintenance plans for all instances. * Utilize Central Management Server to administer multiple servers across the farm. * Troubleshoot and resolve database performance issues. * Manage SQL Server security. * Optimize stored procedures using native SQL Server tools as well as Solarwinds DPA. * Responsible for maintaining high availability of all production instances.

Graduated with highest distinction"]