Hands-on, experienced Epic Certified ADT/Prelude and Identity builder with five years of Epic implementation experience. Fully trained and experienced in all aspects of Epic build through post go-live optimization in the ADT/Prelude and Identity modules. In addition to Epic experience, my qualifications include a bachelor's degree in computer science and 11 years of IT project management and IT experience including, but not limited to SQLServer and Oracle relational databases, including reporting using SSRS, Crystal reports and Business Objects, database programming, server build and maintenance and networking experience.

Work Experience:

Confidential

Consultant

• Epic ADT/Prelude and Cadence build for Auburn Medical Center and support of existing four hospitals and multiple clinics as well as 2012 Upgrade build.
• Build Patient Workqueues.
• Build Referrals Workqueues.
• Build EVS.
• Build paging.
• Build all new labels and wristbands.
• Interactive facesheet.
• Support for existing hospitals and clinics including, but not limited to ADT, Prelude and Cadence. These duties include workqueue maintenance, EVS maintenance, batch job maintenance, provider /resource maintenance, templates, modifiers maintain wristbands, labels, printing, LWS records, DEP records, forms, workflows, confirmation records, etc.

Confidential

Consultant

• Epic ADT/Prelude sole builder for Exempla for St. Francis Hospital
• Build Departments, Rooms and Beds
• Build Bed Charge Billing and test with Resolute Team.
• Build Patient Temporary Location Tracking- PLF.
• Build Facility EAF.
• Build Census Reports for all units and Spiritual Care, Case Management, Bed Planning.
• Build Census Logs
• Build Bed Planning.
• Build Rules, Events and Registries for paging for Bed planning, House Sup, and in basket messages
• Build all workqueues and associated rules.
• Build Item profiles and Defaults.
• Build Confirmation Records.
• Build EVS.
• Build Cash Drawers.
• Build Printing.
• Build documents.
• Build forms.
• Build clients.
• Build Batch jobs.
• Support Cutover.
• Support Go-live
• Optimize WQs.

Confidential

Consultant

• Epic ADT/Prelude build UCLA.
• Build 300 Workqueues both inpatient and outpatient.
• Build Batch Jobs.
• Build Real Time Eligibility.
• Build Forms and workflows.
• Build BCA.
• Build Item profiles and defaults.
• Build documents for printing including facesheet and forms for signatures COA, IM from Medicare, HIPPA notice, etc. .
• Build confirmation records.
• Build multiple master files and category lists.
• Design workflows and perform build for UR, case management, auth-cert, transplant, prereg, etc.
• Build paging for EVS and housekeeping.

Confidential

Consultant

• Epic ADT/Prelude and Cadence Post go-live Support Iowa Health. Train full time employees recently certified in Epic. Cover support tickets while new hires obtain their certifications.
• Fix issues with workqueues.
• Fix issues with batch jobs.
• Fix issues with Forms and workflows.
• Fix issues with RTE.
• Fix issues with bed planning, case management and UR.
• Fix issues with confirmation records.

Confidential

Consultant

• Epic ADT/Prelude Implementation for Legacy Health in Portland Oregon. Part of build team for 9 hospital healthcare system. Performed build for all hospitals simultaneously based on a standardized model. Responsible for building workqueues, workflows, category lists, census reports, setting up printing, building DEP records, building Bed Time and Housekeeping and BCA. Supported go live. And post go-live optimization.
• Epic ADT/Prelude implementation for Fairview Health Systems in Minneapolis MN. Performed build for five hospitals through go-live including post go-live optimization. Responsible for building workqueues, bed planning, workflows, paging for pharmacy and bed planning, category lists, census reports, utilization review, confirmation records, etc.

Confidential

Consultant

• McKesson Paragon Database Administration including Paragon Upgrade, Data Extracts for California State and Federal Reporting, data extracts for outside vendors to conduct quality of service/customer satisfaction surveys, Reporting using SSRS and Crystal for Infection Control, Nursing, Discharge Planning, Case Management, Utilization Review, pharmacy, etc. Financial Reporting out of Paragon for Patient Financial Services, Reports for Payroll out of Kronos and Abra, Pathways reports for Financial Services/Accounting and Materials Management.
• Epic ADT/Prelude Implementation Lead AC position. Requirements gathering, system build, etc. Identity including MPI duplicate cleanup process prior to MPI import into Epic.
• Report programming from Crystal Reports/Business Objects and SSRS out of various database systems.
• Technologies used in this position SQL server, Cisco, Windows, IIS, Visual Studio .NET, MS Office including Excel and Access, Kronos, Abra, Crystal Reports, T-SQL, Visio, Project, Exchange, Active Directory, Epic ADT/Prelude certified through Summer 2009 version and some Cadence not certified in Cadence .

Confidential

Sr. Business Systems Analyst

Brought on as a Senior Analyst to work on various database projects, was moved to Epic project after person in that position left the organization.

• Responsible for McKesson Centramax for Telephone Triage.
• Project managed and implemented High Risk Infant Clinic EMR.
• Project managed and implemented Cochlear implant systems.
• Project managed and implemented Sage FAS.
• Project managed and implemented Sage CIP.
• Performed Business process analysis and Visio diagrams/documentation of all registration areas, UR/UM and billing/collection departments.
• SQL server DBA duties for projects table creation, user creation, database creation, view creation, etc.
• Moved to Epic project when Epic Application Analyst left Rady's. Was responsible for project management and Epic Lead AC duties including, creating and updating WBS/project plans in MS Project, scheduling/leading meetings, programming workflows and masterfiles, defining requirements, etc.

Confidential

Senior Programmer/Analyst Contract to Hire Position

Brought in to Lead the implementation of an Oracle-based warehouse management/ERP/Manufacturing and Supply chain systems including EDI functionality, WMS functionality, Shipping and Receiving functionality, Inventory Control functionality, RFID functionality, Business Objects Enterprise reporting and carton labeling systems and programming. Lead the implementation of SQL server-based parcel shipping system ConnectShip in their Fontana, California, Neosho, MO and Milford, CT distribution centers to interface with SAP, Oracle and AS400 JD Edwards .

• Gather end user requirements, conduct JAD sessions with SMEs, key stakeholders, end users and project champion, document this information for submission to vendors for bidding process and use during the course of the project.
• Gather hardware and software requirements from software vendors.
• Gather pricing information from software vendor.
• Initiate RFP process, obtain bids from vendors for selection process and lead selection process.
• Monitor and manage payments to vendors.
• Conduct User Acceptance Testing.
• Specify interface requirements and build between JDE, SAP and Oracle.
• Specify and program printing and reporting requirements out of systems via SSRS and Crystal Reports Enterprise.
• Create training materials and perform training sessions of end users.
• Specify, design and install and configure web server for distribution of Oracle printing and reports and SQL server reports to all users in the organization which require report functions without need for Client software.
• Interface with outside vendors during the course of the implementation through go-live for issue identification/resolution as well as managing budget and vendor payment at milestones.
• Specify and develop/oversee modifications to both Oracle and Connectship applications, databases and interfaces, test and obtain approval from department managers.
• Managed development team, specification phase, testing, hardware, software, infrastructure, training, end-user/management signoff and post go-live support.
• Implemented web interface for customers to enter orders into the system, other than via EDI to enhance customer ordering experience and enable smaller non EDI customers to enter their own orders without calling customer service thereby reducing operating expenses.
• Design EDI carrier specific RFID/non-RFID labels using Loftware labeling system.
• Perform data analysis to identify root cause for issues and make appropriate adjustments/recommendations as required.
• Server Build and Administration Unix/Windows .
• Database Administration in Oracle and SQL server.
• Report Programming in Crystal Enterprise.
• Design, set-up and maintainance of all Unix and Windows based servers, wireless access points 802.11g as well as print servers and printers for reporting and RFID and non-RFID label as well as report generation in distribution center.
• Post go-live program owner of Connectship SQL server performing DBA duties, reporting, end user support and VB.NET, PL/SQL and T/SQL programming .
• Monitoring EDI transaction logs and maintain compliance with vendors for Fontana location, review of vendor guides to maintain compliance with trading partners, reporting, data analysis and identification of root cause and performing corrective measures when vendor requirements changed or issues identified for all departments.
• Agile/Scrum methodologies used on these projects.
• Technologies used in this position: Oracle 9i, SQL server 2000/2005, SSIS, SSRS, SSAS, VB Scripting, VB.NET, Windows 2000/2003, Unix, Crystal Reports/Business Objects 8-11 350 reports programmed and implemented web intelligence/Enterprise , PL/SQL, T-SQL, Loftware, Oracle 11 ASCP WMS, Catalyst, Sato, Printronix, Oracle Forms, Oracle Reports, JD Edwards AS400 , EDI, ERP, ASCP, SOX, GMP. Build and maintain all servers and perform maintenance as needed using W2K, W2003 and HP-UX. ITIL, RCA, Business Intelligence, Data Analysis, Cisco networking equipment.

Confidential

Project Manager Contract Position

Brought in to complete conversion of corporate data processing system parent and five subsidiary companies including Minka Lavery, Minka Aire, Metropolitan Lighting, George Kovacs and Ambiance Lighting from Cobol to Oracle 9i and 10g databases running on Sun Solaris 9. Prior to bringing me on as the project manager, the project had been in progress for 5 years and was only approximately 20 percent complete. Completed project within 9 months with successful conversion to Oracle and Logistic Labeling System web labeling .

• Selection via RFP and management of 3 outside service providers C3, AOC USA and Allen Group .
• Managed 7 internal programmers.
• Gathered end-user requirements via one-on-one meetings with SMEs and JAD sessions.
• Manage all project meetings.
• Specification/design, hardware and software requirements.
• Manage User Acceptance Testing process.
• Manage change management process.
• Served as lead programmer role delegating work to programmers and overseeing programming and testing.
• Managed implementation and go-live of custom programmed e-commerce, EDI transaction processing, CRM, ERP, WMS, manufacturing, accounts payable, accounts receivable, general ledger, purchasing department, logistic warehouse inventory control system, customer service system, sales department functionality including commission system, sales analysis reports and order processing system. Managed keeping the project on time and on budget.
• Managed Project for Web interface carton labeling system for suppliers/vendors in China Logistic Labeling System thus saving the corporation several hundred thousands of dollars per year in labeling costs.
• Managed web ordering system programming.
• Managed requirements gathering and programming Business Intelligence reporting systems for Sales, Purchasing, Finance, Senior Management, Accounting, Manufacturing, Quality Control, Sales and Warehousing.
• Responsible for maintaining communication between team managers, end-users, programmers and outside service providers.
• Programmed using PL/SQL, TCL, Oracle Forms and Reports.
• Responsible for testing programs with end-users/department managers, performing data analysis to identify root cause, identifying necessary modifications/bug fixes and assigning duties to programmers, interacting with outside service providers and specifying interface requirements and testing for proper functionality, keeping project moving, on-time and on budget.
• Converted projects from Waterfall to Agile methodology.
• Technologies used in this position: Java, SQL, PL/SQL, Oracle 9i, Oracle WMS, Oracle Forms and Reports, Crystal Reports, TCL, RMAN, OEM, Business Analysis, Visio, Project Management, Process Improvement, EDI, SOX, GMP, Business Intelligence, Data Analysis, Agile methodology.