John Lisa

• Migrate reports from older systems; (IDX, Oracle) to Snowflake Cloud Data Warehouse.
• Completed new data extraction projects start to finish.
• Create Informatica ETL delivery packages for FTP to 3rd party vendors.
• Resolve Service Now tickets and new requests for EPIC data.

Sr. Data Migration Analyst

(Current client: Yale New Haven Health, Connecticut)

• Data migration of Sunquest Blood Bank (Intersystems Cache) into Softlab application
• SQL server Extractions of Blood bank: Unit detail, Patient level detail, Transfusion history, Administrative Inquiry
• Work with team to define new data dictionary and create SSIS packages for integration to SQL Server database.

Sr. Consulting Business Analyst (Previous client: University of South Alabama Hospital)

· 4 hospital ETL project for long term archiving. Financials and Pharmacy from Siemens/Cerner INVISION ICO database Created Business Requirement Documents to determine data dictionary based on hospital requirements for extraction.

· Create ad-hoc reports for full data migration of complete Master Patient Index, 10 Years Accounts receivable and charges.

Account detail, Comments, etc.. Both Waterfall and Agile methodologies turned over to project manager

Original SOW: Waterfall project, Additional SOW for general ledger request: Agile for additional statement of work.

· Code, test, debug, implement, document file names and processes for 3rd party vendor ‘Harmony HIT’

• · Work with Application analysts and End Users to design and deploy reports.
• · Train users on Workbench and Epic Crystal Integration reports.
• · SQL server, Crystal reports, Business Objects Enterprise scheduling
• · Monitor and correct ETL issues from Chronicles to Clarity databases via Clarity Console. Report application issues to EPIC.
• · Resolve user issues for Epic Reports (via Service Now management tool)
• · Assist in upgrade activities for Clarity and Caboodle. Configure test environment for upgrade
• · Monitor FTP processes to 3rd party vendors.
• Active part in periodic System Updates.

• Business Requirement Documentation and workflow for new ticketing system (Service Now)
• Web Portal testing for member’s new functionality
• Liaison between IT (development) and Claims dept for changes and issues
• Performed Document imaging function for FIDA plan
• Assisted IT dept in restructuring Sharepoint groups

• SAS Enterprise and Crystal reporting and automation
• Data Warehouse reporting
• CRM Application testing for upgrades and go live support
• (Regression testing, changes)
• IVR phone and workflow support
• Portal Testing for Member services registration

• Performed 3 hospital data migration project (MPI and 10 years A/R)
• Created data dictionary for 3rd party HMS (Health management systems)
• Used SQL server SSMS to create database for demographics data for additional facility usage.)

• Created 20 clinical Emergency Dept reports. Some regulatory
• Trained new staff to be able to write reports

• Implemented Allscripts Sunrise Record Manager for H.I.M
• Application, including data collection and migration off prior systems, upgrades, interfaces from financial system, testing of all scenarios, documentation, staff training and post live support of the system
• Includes budget planning
• UX for Esignature
• Use cases, Agile methodology for the eSignature piece
• SQL server, Crystal reports, Business Objects Enterprise scheduling
• Developed and maintained various H.I.M systems.
• Worked extensively on NY SPARCS, provider maintenance, error correction and logging in order to meet Dept
• Of Health compliance via HPN
• Also spearheaded regulatory changes in financial system
• Installed upgrades, patches, and problem solutions in order to maintain application quality and adherence to standards and regulations
• Report writing for clinical systems Allscripts HMED (EDIS), Datamart II ‘Peribirth’ (Labor and delivery), Sunrise Record Manager (H.I.M) and Siemens Invision for compliance, decision support and revenue cycle
• Customized, ad hoc and routine scheduled Crystal reporting for diverse hospital functions
• Streamlined work-flow process for deficiency management, chart tracking, demographic (business office) document imaging and Electronic chart completion
• Monitored and corrected daily error reports.