DATABASE PROGRAMMER/SYSTEMS ANALYST
Oracle Microsoft SQL Microsoft Access Visual Basic Crystal Reports
A well respected experienced SQL Programmer, that is fluent in many database technologies; database design; data warehousing; data modeling; management reporting and data problem solving with experience working within the medical, financial, and insurance, and retail industries. Initial experience as a BSN, this unique combination of two careers and skill sets has created a synergy that has subsequently credited this Analyst as a subject matter expert in regard to clinical reporting. A proven track record of excelling in both fast paced clinical and entrepreneurial environments and well established corporate cultures.
Epic: Certified in Clarity Data Model Inpatient, Clarity Data Model Optime, currently completing certification Clarity Data Model ASAP, and extensive experience (last six yrs) with Clarity Data Models Ambulatory, GrandCentral, Cadence, Willow, and Beaker.
Advanced Computer and Technology Skills include:
MS SQL SQL Server 2000, 2008, 2012, T-SQL
SAP Crystal Reports 8.5, 11.0
Oracle 8i/9i SQL, Oracle Forms and Reports, PL/SQL
Epic Clarity Database
Visio, Erwin Data Modeler
Epic Hyperspace EMR
Microsoft Access & Access Project & VBA
Dentrix Dental Practice Mgt. System
SAP Business Objects BI Platform: Central Management Console (CMC), Web Intelligence (Webi)
Microsoft Visual Basic
Goldmine, SalesLogix GA Agency Management System
A versatile effective programmer who has built a reputation of reliability, professionalism, dedication and integrity throughout a successful 15 year career.
New York University:
Completed 1 year toward MA in Health Administration/Marketing, including requisite graduate research statistics courses.
Camden County Community College:
Oracle I, II, and III - SQL, PL/SQL, Oracle Developer, Oracle Forms and Reports, DBA I, Visual Basic, Systems Analysis and Design, Advanced Networking, and Advanced Windows NT and 2000 and Crystal Reports.
Epic Training and Certifications:
Epic Certified and all NVTs up to date: Clarity Data Model Inpatient, Clarity Data Model Optime. Currently completing certification- Clarity Data Model ASAP.
Atrium Staff/Summit Health Management Client –Summit, NJ (Remote) Apr 2017 – Jan 2018
A consulting company providing a variety of Healthcare consulting
Senior Database Developer
Consulted for client (Summit Health Management) regarding future possible Epic design options. Additionally for an Athena SQL Reporting Database, working with client’s MDs - Director of Informatics and CIO, analyzed client’s Athena implementation in order to develop, design, and implement a coding interface for the purpose of reporting on Quality Measures for HEDIS.
Hosted meetings weekly with SMEs to communicate progress, set expectations, raise questions, explore alternatives, and set timelines.
The code design leveraged parameterized reporting, data mapping, and reusable code. Developed multiple complex stored procedures, functions, and views as well as creating multiple custom tables requiring indexing.
Coding design included ETL of detail data to a foundation table, used for detail and summary reporting.
Utilized SQL Server Query Optimizer to analyze Execution Plans, indexing was created on both Athena and custom tables in order to achieve database performance optimization.
Using Software Development Life Cycle (SDLC) methodologies, documented projected schedule and achieving according milestones.
Adhoc Reporting, tools such as Crystal, SSRS, Tableau
Encore Health Systems/MLH Client - Bala Cynwyd, PA Sept 2016 – Mar 2017
A consulting company providing Healthcare Information Technology consulting.
Senior Database Developer
Consulted for client (MLH) during multiple module Epic implementations.
Designed and implemented custom code modifications to Epic’s foundation reports:
oInpatient Module - Nursing Operational Trending, Quality Measures including (NDNQI, SPS, IV Lines, Sepsis, Sedation, Restraints, Infectious Control), Case Management, Long Term Care, Physician Orders
oRespiratory Therapy, and Willow.
Met weekly with SMEs to communicate progress, set expectations, raise questions, explore alternatives, and set timelines.
Teksystems/NHRMC Client (Remote) - NC May 2016 – July 2016
A consulting company providing Healthcare Information Technology consulting.
Manager Clarity Development/Clarity Senior Developer
Consulted for client (NHRMC) regarding evaluation of BI Standards of Practice – people, process and tools as well as Clarity Report Development.
Agile Methodologies utilized.
Created SQL Scripts for adhoc reporting
Atos/Xerox Healthcare Provider Solutions/Cooper Medical Center Client - Camden NJ (Remote) Aug 2011 – Mar 2016
A consulting company providing Healthcare Information Technology consulting, resources and IT services.
Manager/Developer Data Analytics
Dual careers resulted in comprehensive qualification for this role by achieving a Bachelor Of Science in Nursing, then attained extensive experience as a Programmer developing SQL stored procedures, functions, and views for Analytical Reporting.
The unique combination of two careers and skill sets, created a synergy that has subsequently credited this Manager/Developer as a subject matter expert in regard to clinical reporting and can provide explanation of the clinical information (Healthcare Work Flow), definitions of Clinical Terminology (Medicine), relating any Clinical issues to the database.
An experienced programmer, takes an active role in creating complex code as well as assisting Informatics with redesign and re-write a product that may be complicated, in order to meet the needs of the SME or client.
Working as the Senior Developer, at times functioned as the ARL and also managed a team at client (Cooper Medical Center) hospital that was a combination of both stateside and international resources that participates in implementations and upgrades, as well as design and develop reports, extracts, and interfaces using MS SQL databases.
All projects include: creation of report design, data mapping, creation of code design, creation of code, unit testing, and client acceptance testing.
Gathered and analyzed state requirements (custom core measures) for the New Jersey Delivery System Reform Incentive Payment (DSRIP) working with both the Director and Manager of Informatics:
Atos/Xerox - Manager Data Analytics Development (cont)
oCustom designed and developed a multi database MS SQL interface to enable (DSRIP) ‘Self Serve Execution Management’.
o(DSRIP) ‘Self Serve’ design enables the user to dynamically create both parameterized reports and parameterized selection criteria from the multi-database environments of EpicCare Ambulatory, EpicCare Inpatient, Hospital Billing (HealthQuest), and Professional Billing (IDX) systems.
oDeveloped multiple complex stored procedures, functions, and views as well as created multiple custom tables requiring indexing, in order to achieve database performance optimization. Authored Webi Reports.
o(DSRIP) design included the creation of string parsing code to load custom tables and an SSIS to transport data across domains, and a web app designed for users to directly input the dynamic reports and parameters, as well as maintain an ‘Execution History’ in order for users to view and compare reports.
oIn 2015, this sophisticated programming and subsequent reporting resulted in Cooper University Hospital successfully receiving a state grant of 12 million dollars.
Managed projects as the Report Coordinator/ARL and participated all phases of SDLC, and created code for Projects: DSRIP, GrandCentral - ADT Bedboard Interface as a SAP Dashboard to be refreshed hourly.
Designed and created Code for Quality Measures including (NDNQI, SPS, IV Lines, Sepsis, Sedation, Restraints, Infectious Control), Lab History (Beaker), ORCheckIn - utilizing EpicCare Optime (including OR Log, OR Events, OR Resources, OR Case, and OR Smartforms), Pediatrics, Controlled Substance Prescription Audit - utilizing EpicCare Willow, HHI - utilizing EpicCare Inpatient and EpicCare Ambulatory (including Epic Flowsheets), Crimson and Theradoc - utilizing EpicCare Inpatient, Cadence and Referrals, Careware – utilizing EpicCare Ambulatory, ETL Validation Trace - utilizing Epic ETL Admin tables, and the ICD10 upgrade.
Authored Webi Reports as well as adhoc reporting in Beaker, Grand Central, Willow, Ambulatory, Inpatient, Optime, ASAP.
Regularly meet with the Requestors of larger projects, vendors of larger projects, as well as coordinating reporting priorities with Medical Informatics regarding Meaningful Use Core Measures and KPI.
Hosted meetings weekly with SMEs to communicate progress, set expectations, raise questions, explore alternatives, and set timelines.
Developed on going working relationship working with Medical Informatics and was relied on to translate the medical needs and requirements to the Reporting Team.
Met regularly with the ETL Admin and the Epic TS and works together to achieve reciprocal support and also coordinates priorities – all to meet required goals. The Coordinator also develops and manages her own coding projects.
Established programming standards as per industry standard - created a custom Cooper reporting schema within the Clarity database to create custom complex projects, utilized programming standards in incorporating common table expressions, table variables, variables in stored procedures and functions and PK and indexing on custom tables thereby limiting the number of generations of nested selects as well as creating standards for formatting and comments.
Developed the reporting request tracking and team development process– an online request form including the development stages of SDLC to accurately track development progress of report and project requests, utilized by development team and Medical Informatics.
Involved in Upgrade Assessment of Epic Hyperspace Version 12.1; Impact Analysis and Version Upgrade Plan; Work with the Clarity team on Upgrading Clarity to 14.0. Analyze the current customized reports and recommend which reports to upgrade and what reports are standard in new version.
Superior Mortgage Corp, Hammonton, NJ May 2011 – Aug2011
Contractor Database Programmer
Using MS SQL databases, Using MS SQL databases developed reporting solutions.
Electronic Health Records – Newtown Square, Pennsylvania Oct 2010 – May 2011
A provider of medical necessity compliance solutions to hospitals and health systems across the country.
Using MS SQL databases, developed interfaces to support the data exchange needs for both internal and external clients:
Database Development. Analyzed business requirements to create data models, designed new warehouse structures.
Coded new interfaces mapping and importing data using ETL processes and developed DTS or SSIS packages.
Using T-SQL, created Views and Stored Procedures for processes and datamining and created professional reports. Code supported data requirements and technical standards to ensure optimal performance and scalability.
Grayhair Software Inc - Mt Laurel, New Jersey Aug 2009 – April 2010
A computer software company providing direct mail services – Intelligent Mail Barcode management, address hygiene, and mail tracking to business mailers.
Sr. Database Analyst
Using MS SQL databases developed reporting systems, DTS/SSIS Packages to support proprietary mail tracking applications and automate report creation.
Created Metadata Documentation, Data Mapping, and automated DTS/SSIS data export to report .xls files (Excel).
Designed, coded, and tested back end stored procedures and processes in MS SQL and provided work estimates.
Developed drilldown and cross tab reports using the web based reporting tool Intellicus to support the mail tracking application.
Developed the trademarked Address Score™ that checks a job’s address quality and identifies problems to prevent USPS office penalties. Using backend MS SQL (and front end Crystal Reports), created backend process to support percentages for individual job and summary job reports. Additionally developed adhoc reports.
Roster Financial LLC - Voorhees, New Jersey Mar 2007 – Aug 2008
A Field Marketing Organization for independent insurance agents and agencies.
Database Developer/ Database Analyst
Using Software Development Life Cycle (SDLC) methodologies, systems planning, research, and development, including the development of data flow diagrams, logical and physical data modeling, defined data integrity/quality methods and protocols, responsible for monitoring and maintaining MS SQL databases that support ad-hoc reporting, Goldmine CRM (Customer Relationship Management), GA - an Agency Management System, and rf_Reporter and Convert – two Proprietary Production Reporting Systems. Currently reporting to the V.P. of Information Technology.
Designed, Coded, and Tested an ETL data interface between two mission critical applications using newly created import tables, views, TSQL procedures, and functions. The interface ensured up-to-date Carrier Contract data existing in both the Goldmine CRM and GA - Agency Management System.
Designed, Coded, and Tested an MS SQL database infrastructure (data warehouse) to support Goldmine CRM and two MS Access front end applications. (In addition to the SQL infrastructure, this project included within one of the existing Proprietary Systems – Convert, the creation of an additional Access Screen, capable of real time user interaction and complete with edit checking in VBA). The applications provide management with accurate, timely reporting for marketing campaign initiatives and Roster’s elite agent service program.
Created an MS SQL database trigger infrastructure to ensure data consistency and data quality assurance between the company’s Goldmine CRM and the existing Proprietary Premium Production Reporting systems – Convert and rf_Reporter.
Provided timely automated reporting using disparate sources of data including the CRM, Agency Management and Production Reporting systems and external Carrier data imported from source .xls files. Designed and implemented a reporting database and a repository of reusable management and operational reports using Query Analyzer, Crystal Reports, and SSRS. Leveraged previous work to satisfy new reporting requirements, saving time and effort to meet Business/Financial Management needs.
Successfully dissected a previous programmer’s system in order to make major coding changes.
Clearly documented metadata, all programming code, and reports and provided work estimates.
Worked closely with business users to clearly understand, design and code reports to support their requirements.
Assisted with the identification of new technologies, cost estimates and analysis to streamline the management reporting process.
Corporate Synergies – Mount Laurel, New Jersey Jun 2006 – Feb 2007
Independent benefits consulting and brokerage firm with more than 1000 corporate clients nationwide.
Database Modeler/Database Analyst
Using Software Development Life Cycle (SDLC) methodologies, systems planning, research, and development associated business requirements, rules and data flow diagrams, collaborated with the vendor and made recommendations regarding the design/structure of a new SQL Server Database. Created detailed data loading scripts including data transformation for the new database. Designed bidirectional triggers including data transformation between two disparate databases required during front end transition. Created Stored Procedures and Jobs as well as managing existing Jobs and DTS/SSIS Packages.
Created metadata documentation, performed data analysis using SQL and Business Intelligence Applications – Crystal Reports 11.0, and established processes for maintaining data analysis, elimination of duplicate records, data validity and standardization from multiple sources, multiple databases and the data warehouse.
Liaised with the vendor, designed dataflow diagrams, database mapping, created metadata documentation, and implemented enhancements to SQL Database design based on relational database standards including Views, Stored Procedures and Jobs, and Triggers that included data transformation.
Translated business requirements and operational procedures received from internal users/clients into developer-level technical specifications identifying process improvements, objectives, and various cases required for Data Transformation.
Designed, tested, and executed SQL Server Data Migration Scripts including detailed Data Transformation and Data Cleansing.
Participated in planning meetings with the vendor and internal development team to develop an integration plan.
Developed and implemented Test Plans for successful integration of Stored Procedures and Triggers with two databases and three applications, in a team development environment.
Monitored the Production Database and front end application after implementation to validate a successful transition in the production environment.
Designed, tested for quality control assurance, and implemented adhoc queries for Department Directors as needed using Query Analyzer and Crystal Reports.
Charming Shoppes Inc – Ben Salem, Pennsylvania Oct 2005 – Jun 2006
Multichannel specialty apparel retailer operating over 2,400 stores in 48 states.
Database Modeler/MS Access Application Designer/Programmer
Using Software Development Life Cycle (SDLC) methodologies, designed SQL Server Database with an Access front end application to provide a central warehouse to manage and track User ID's, Security Templates, and Application Ownership and allow for the creation, modification and disabling of ‘User Accounts’ and associated information that replaced a variety of Excel spreadsheets and a stand alone database table.
Designed and implemented enhancements to SQL Database design. Additionally, created Views, Stored Procedures, and Triggers.
Designed Access Application to include forms specifically designed to maintain data integrity - complete with Combo Boxes, VBA/SQL record edit checking and Message Boxes, VBA ‘save confirmation’ Message Boxes, as well as VBA automated Text Box or table column assignments, update queries to child SQL tables, Navigation Bars. The Screens/Forms represent tables with ‘one to many’ and ‘many to many’ relationships. Reports designed for data mining.
Designed ability to add and change prefixes of an auto generated User Id and transaction Operator Id tracking.
Security includes Access User Account Screen Security as well as Map Active Directory Groups to gain access to SQL Server and to limit Table Level Security.
Prepared work estimates and a formal Change Control Implementation Plan and presented it to the IS Change Control Committee.
Used PVCS (project tracking software) and departmental standards regarding change control process including the following documents: Pre-Implementation, Verification, Business Requirements, and created metadata documentation - a Detail Document of 69 pages documenting the Access Application and its relationship to the SQL Server Database.
Identified Table/Field requirements for data import and provided detail documentation to client to implement process.
Accomplished successful Data Migration (data import) with attention to detailed Data Transformation and Data Cleansing using Excel formulas for Data type conversion followed by SQL Server import.
Monitored and tested for quality control assurance after implementation, the Production Database and Access Application to validate a successful transition in the production environment
University of Pennsylvania Dental School – Philadelphia, Pennsylvania Oct 2001 – July 2005
Prestigious Ivy League dental school.
Using Software Development Life Cycle (SDLC) methodologies, designed application and RDBMS enhancements in response to operational requirements initially illustrated with data flow, entity relationship diagrams, data models, and detailed QA tests of new builds.
Design and manage RDBMS with logical and physical data modeling, Data Flow charts, designing datasets for data mining, extraction and analysis by data mapping-merging and linking information from different sources using Access, Business Objects - Crystal Reports using SQL, and an Oracle 8i /9i database.
Performed as Project Manager in systems planning, research, and development using Software Development Life Cycle (SDLC) methodologies. Executing deployment of a clinical system, Electronic Patient Record, a module of the Dentrix Practice Management System. Member of EPR team, working closely with department Directors. Surpassed Directors’ expectations.
Monitor data quality, chart auditing, and recommend process changes to improve data integrity.
Liaised with third party software vendor, successfully designed application enhancement allowing faculty to cosign student charting - essential for school wide deployment of chair-side Electronic Patient Charting. Review enhancement specs/contracts. Debug - test and evaluate application builds. Cost Estimating managed within a predetermined time frame and budget the purchase of chair-side computer hardware needs.
Based on observation of Penn’s clinical operational needs, evaluate application ergonomics to facilitate efficiency. Design plan to streamline usage, as well as accommodate the schools environment IE: designed various custom electronic exam history templates, preventing the need for additional costly enhancements.
Developed and implemented three phase training course to introduce new technology to dental students and faculty.
Designed, tested for quality control assurance, and implemented Crystal Reports and Access Queries/Reports that are providing the dental school the tools to document, analyze, and evaluate student, faculty, operator, and clinic production: Business/Financial Management - identify cash discrepancies in clinics resulting in elimination of any continuing losses.
Network Administration and help desk – supported the migration to Active Directory.
Received honorable mention in ‘The Penn Dental Journal, Fall 2004, ‘Riding the Wave of the Future’ for having successfully written a 52 PG illustrated technical training manual for faculty and students, implemented training, and received faculty commendation.
MediaCraft - Mount Laurel, New Jersey Sept 1997 – Oct 2001
A website development and multimedia company.
Designed custom Access, SQL Server and Oracle databases including; design strategy based on dataflow diagrams, mapping, and relational database standards.
Documented - created and defined data integrity/quality methods and protocols. Performed database modeling with ERwin Tools illustrating logical and physical data modeling (which includes field typing and defining one to one, one to many, or many to many relationships), as well as data mapping, SQL metadata management (data dictionary), and data cleansing using PL/SQL and Transact-SQL for diverse industry clients and data warehouse design.
Successfully wrote business proposals and business plans.
Increased efficacy of orders processed, decreased errors, and enhanced data flow. Eliminated redundant procedures.
Genesis Eldercare - Marlton, New Jersey Jun 1998 – Jun 2000
Nursing rehabilitation center with more than 200 centers across 13 eastern states..
Nursing Supervisor, Staff Development
Responsible for 190 - 250 bed facility, including supervision of the entire facility as well as patient triage, admission, patient and family counseling, and teaching CNA course.
Computer Support developing database management program (Access) for the staff development office, data analysis required to ensure meeting state In-Service staff development requirements, as well as health facility utilization analysis.
(Previously worked NYU Hospital and St Francis Hospital in L&D, Newborn Nursery, and occasionally OR. Additionally formerly worked as a Pharmaceutical Sales Rep.)