John W. Ward
5659 Shandle Blvd
Mentor, Ohio 44060
Phone: 440-257-0909
resume@jwward.com
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
Development:
Crystal Reports, Business Objects Enterprise, Microsoft Access, OLAP, Data Warehouse Technologies
Systems:
Microsoft SQL Server, Microsoft SQL Integrated Services, Microsoft SQL Analysis Server, Oracle DBMS
Productivity:
Microsoft Office, Microsoft Project
Networking:
TCP/IP, 802.11 Wireless
Hardware:
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