EDWARD J. GRAY
*** ******* ***** 412-***-****
North Huntingdon, PA 15642 **********@*******.***
College: Robert Morris B.S.B.A
Proficient in Computer Software
oSoftware: Microsoft SQL Server, McKesson SQL, Focus, Atlas
oSQL Server, SAP Business Objects, Discern Visual Developer
oInbox, Patient Education, Security, Daily Support
oTeletracking, Respondernet, Onestaff, Powerchart, SurgiNet, FirstNet
Instructor - Community College of Allegheny County – January 2001- March 2004
EMPLOYMENT HISTORY / WORK EXPERIENCE
January 2013 – October 2023 UPMC Children’s Hospital of Pittsburgh
Senior Systems Analyst
Created designed, developed, and maintained management, clinical and analytical reports using SAP Business Objects, Discern Visual Developer, Web Intelligence and Universe Designer.
Analyzed reporting needs and discuss with stakeholders
Created complex Webi reports for the calculation of fiscal year, year to date, and month to date.
Involved in day-to-day Business Objects Server maintenance.
Provided support to resolve client technical issues.
Conducted end user training sessions and prepared training material.
Trained users in basic & advanced reporting functionalities, creating Ad-hoc reports for analysis.
Maintained security for users on the system
January 2010 – December 2012 UPMC – Corporate Services
Intermediate Systems Analyst
Evaluates and documents operational performance, diagnoses issues/incidents, completes service requests/problem resolution for complex business systems or processes.
Created reports with reporting tools, such as SQL, and McKesson Star, used query tools such as Crystal Report Writer, and advanced macros in Excel. Drafting detailed technical specifications from which programs will be written.
Participates in joint application development sessions.
Work with the project manager to define tasks and create teamwork plans with moderate supervision.
Controls project costs, communicating any project-related expenses and recommends ways to control costs.
January 2006 – December 2009 Excela Health – Westmoreland
Systems Analyst
Perform functional analysis of customer request and deliver new system functionality, ad hoc reports, databases using McKesson Star SQL
Create customized reports for Horizon Business Insight, a web-based business intelligence solution that distributes scorecards and OLAP capabilities to healthcare managers.
Programmer in McKesson Star, a front end used in Mumps.
Designed and maintain Premier software to do benchmarking calculations
EDUCATION
Robert Morris College, Pittsburgh, PA
Major: Bachelor of Science in Business Administration in
Management Information Systems
MILITARY SERVICE
United States Naval Reserve - Communications
Pittsburgh, PA
March 1989 to January 1994
USS Merrill DD976
San Diego, CA
March 1986 to March 1989
Honorable Discharge, March 1989
Held Top Secret Security Clearance
REFERENCES AVAILABLE UPON REQUEST