Responsible for the oversight and administration of Lancaster General/Penn Medicine's Epic enterprise data warehouse (Caboodle). This includes the development and implementation of physical data models from both internal and external data sources, systems and database administration, and utilization of SQL Server Integration Services for extract, transform and load (ETL) and to automate processes.

Working as a member of the Business Intelligence Department developer team, responsibilities include the mining of data from all Epic Clarity Data Models using complex SQL queries and Crystal Reports. Additional duties developing the architecture of and implementing data-marts to support the many data sharing initiatives of Lancaster General Health. Clarity Data Model - EpicCare Inpatient Certified.

Streamlined and improved efficiency of data extraction and delivery utilizing SSIS and SQL server automation tools. Coded and implemented software applications that vastly improved management of what were once manual processes. Responsible for training and software support of Inside Sales Representative, Sales, and Shipping departments.Key Accomplishments-Using SQL server and SSIS automation tools, implemented programming to maintain JDE software system data integrity.-Improved sales opportunity identification by creating complex SQL stored procedure that calculates RFM (recency, frequency, and monetary) for customer base.-Improved management software system customer master by coding and deploying software application that automatically merges duplicate customer records.-Regarded as “expert” in utilizing SQL to extract and manipulate data

Forged participation in the system selection and RFP development for community-based electronic medical record. Provided expert oversight and supported the community-wide implementation of eClinicalWorks practice management/EMR software solution. Performed data mining from multiple hospital systems to ensure compliance with audit and regulatory requirements.Key Accomplishments-Led the successful implementation of multi-specialty affiliate practices throughout the Greater Hanover, Pennsylvania area-Directly engaged in planning and rollout of the eClinicalWorks electronic health exchange-Distinguished for expertise in data mining and business intelligence by hospital administration-Developed and mentored less-experienced MIS staff through implementation of comprehensive training programs

Spearheaded the successful implementation of the MEDITECH/LSS medical practice management systems at the hospital-owned multi-specialty physician practices at Hanover Hospital. Played an integral role as principal NPR report writer.Key Accomplishments-Successfully implemented the billing and scheduling modules for multi-specialty hospital-owned physician practices, including physician practice clinical modules for 36 multi-specialty providers by expertly administering the execution of processes and procedures-Honored and invited to serve as guest speaker on EMR implementations and best practices at client forums in multiple locations, such as Philadelphia and Pittsburgh, Pennsylvania-Improved staff efficiencies and patient outcomes through introduction of database and reporting system for Emergency department medical director

Directed data extraction, manipulation, and presentation through the use of T-SQL and Crystal Reports system. Proficiently utilized Microsoft Access, VBA, and T-SQL in supervising client server and JET application development. Carried out comprehensive business process analysis and generated technology-based solutions.Key Accomplishments-Streamlined applications processing and improved response time by 200% for approval in the Maryland Health Insurance Plan by implementing database system-Led the establishment of the corporate standard client server-based grievance and appeals on application’s development and roll-out-Automated reporting processes in all areas of operation, finance, enrollment, utilization, and case management-Received commendation for demonstrating superior skills and customer service by senior level management and awarded as Employee of the Month in May 2003.

Duties included development of LAN and Web based Crystal Reports to support ProTech's VisionSeries association management software system. Provided onsite client training and support in both Crystal Reports and VisionSeries software. Participated and assisted in validation of client data migrations. Additional responsibilities included application development using the Magic Programming language.Notable Accomplishments-Oversaw multiple client data migrations.-Enhanced and improved Web deployment interfaces/performance of Crystal Report integration with VisionSeries-Successfully integrated, tested and deployed Seagate's latest reporting tool, Crystal Enterprise with the VisionSeries product.

Primary responsibilities involved system design, implementation, and project management. Other duties included serving as network administrator, providing end-user support and training.Notable Accomplishments-Served as project manager for implementation of MEDITECH patient management system admissions, medical records, and abstracting modules. -Designed, wrote, and implemented JET database system that handled processing, distribution, and tracking of facility wide maintenance work orders.-Oversaw integration of Novell Netware with Windows NT 4.0 environment.-Using Crystal Reports 7 Web Component Server and Microsoft FrontPage, developed corporate intranet used for Web based execution of Crystal Reports.