kay dean

Wrote computer programs using COBOL, JCL, SQL, JavaScript, Focus, WebFocus, Crystal Reports, SAS, mainframe IBM DB2, VSAM, TSO, and HTML. Lead Analyst for team. Worked with in-house users to determine reporting needs. Worked with outside vendors to assist with system problems. Created batches to be loaded into in-house and outside applications. Worked with departments to update the Siemens database. Working knowledge of Accounting, Finance, and Clinical systems. Extensive adhoc reporting.

Worked with users to determine integration needs. Worked with vendors to create interfaces between the hospital systems/applications and outside systems/applications. Lead phone calls between vendors and applications to facilitate interface creation. Worked with other teams to create the data required for in-house applications. Knowledge of HL7 and Rhapsody interface engine. Created or changed JavaScript code required for custom interfaces. Developed interfaces using SDLC. Created testing scenarios.

Created or changed SQL code in Toad for Finance and Human Resources reports (Oracle). Extensive knowledge of relational database concepts (RDBS). Used Crystal Reports to create Lawson ERP reports. Published and scheduled reports on the Lawson Business Intelligence dashboards. Created applications using Qlik. Covered on-call after hours. Created SSIS packages on SQL Server. Experience with SSMS and SSRS. Working knowledge of Lync, Outlook, and Sharepoint. Knowledge of Healthcare Systems (Invision, Cerner, Meditech) from a programming standpoint. Excel and Access experience.