John Ward

Freelance Database Expert & Programmer

Location:Cleveland, Ohio, United States
2 Skills
John W. Ward
5659 Shandle Blvd
Mentor, Ohio 44060
Phone: 440-257-0909

Summary of Qualifications

• Exceptional skills in data analysis & reporting through the use of a variety of tools and technologies
• Experience in MS Access development using both MS Access and MS SQL server databases
• Advanced interpersonal communication skills to all levels of management and in a training atmosphere
• Various levels of technical support obtained and mastered in roles ranging from analyst to manager to administrator
• Extensive understanding of medical imaging technology and terminology including ICD9, CPT/HCPCS, medical billing, HL7 and hospital admit/discharge processes
• Extensive customer service including management of people and projects

Information Technology Skills

Crystal Reports, Business Objects Enterprise, Microsoft Access, OLAP, Data Warehouse Technologies
Microsoft SQL Server, Microsoft SQL Integrated Services, Microsoft SQL Analysis Server, Oracle DBMS
Microsoft Office, Microsoft Project
TCP/IP, 802.11 Wireless
PC Systems, Modems

Professional Experience

Cleveland Clinic (2008 – Current)
Cleveland, OH

System Analyst

Clinical Decision Support lead in providing various enterprise reporting of Epic Health System data to hospital and administrative staff.

General Job Duties:
• Development and support of Business Objects Enterprise Universes and Web Intelligence
• Lead for other developers in providing Crystal Reports technical expertise including product upgrades and working with vendor support
• Complex Crystal Report development against medical Oracle database system including data exports to Excel and PDF
• Instrumental in increased department efficiency through process improvements
• Creation to SSIS packages to move data from Oracle to MS SQL

John W. Ward - Page 2

GE Healthcare (2007 – 2008)
Burlington, VT (Working Remotely)

Crystal Reporting Specialist

RIS (Radiology Information System) implementation project team member. Responsible for determining reporting and data specifications on various projects for hospital radiology departments and imaging centers. Implementation and corresponding project work included a great deal of direct contact with project client.

General Job Duties:
• Knowledge and understanding of radiology information system functionality and how it utilizes radiology work flow
• Complex Crystal Report development against medical MS SQL database system including numerous sub reports and sub queries.
• Successfully and efficiently managed simultaneous development projects for a variety of hospital and imaging center clients
• Continuous internal process improvements to reduce development time and improve efficiency and implementation turnaround

University Hospitals {Contractor} (2006 – 2007)
Cleveland, Ohio

Data Analyst

General Job Duties:
• Complex Crystal Report development against medical MS SQL database system
• Development of MS SQL views to be used for data extracts into other IT systems
• Administration of Business Objects Enterprise Systems to automate report delivery
• Utilization of data warehouse technologies for reporting purposes

Merge Technologies (2002 – 2006)
Hudson, Ohio

Data Reporting Engineer

General Job Duties:
• Lead Crystal Reports developer for client application including numerous custom work to meet client specific needs including additional revenue opportunities
• Conducted monthly online training classes for Crystal Reports, SQL database table structures for reporting, and Practice Analysis, a tool utilizing SQL Analysis Services
• Administration of OLAP database including the creation and modification of cubes and dimensions

Service & Support Manager

General Job Duties:
• Management of highly technical support team located at 3 locations in Cleveland, Milwaukee & Toronto in a high volume environment
• Instrumental in restructuring processes and systems to improve a 50% call abandon rate to less than 5% in 3 months
• Contributed to the development and implementation of support environment for newly established software company
Skills (2) Rating