Edward J Gray - Senior Analyst

412-***-**** North Huntingdon, PA ad3kmu@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/edward-gray-8a142042/

Technical / Software Skills:

Atlas Discern Visual Developer Focus McKesson SQL Microsoft SQL Server Oracle Cerner (Powerchart, SurgiNet, FirstNet) Oracle Microsoft SQL Server SAP Visio

Assets:

Security and timeline prioritization, daily user support for individuals and groups, global travel welcome, delivery of new user trainings, leadership reporting and briefings on statistical, relational, and operational analysis of data sets, stakeholder engagement, analyze data for anomalies and assist with checking data integrity, peer review work of other employees as requested.

EMPLOYMENT HISTORY / WORK EXPERIENCE

Senior Systems Analyst Jan 2013 – Oct 2023

UPMC Children’s Hospital of Pittsburgh

-Created, designed, developed, and maintained management, clinical and analytical reports using SAP Business Objects, Discern Visual Developer, Web Intelligence and Universe Designer for leadership team members to forecast, assess spending, and implement process changes needed.

-Analyzed reporting needs and discuss with internal and external stakeholders. Researched issues to determine source of discrepancies.

-Pull data out of Oracle using CCL which would be the same as pulling data out of Microsoft SQL Studio using SQL. Manipulated scrubbed data for the desired output.

-Created complex Webi reports for the calculation of fiscal year, year to date, and month to date.

- Involved in day-to-day server and security maintenance, trained new users on the system and provided support to resolve client technical issues

- Software instruction, twice yearly delivered to new users across the organization, in addition to basic & advanced reporting functionalities, and creation of Ad-hoc reports for analysis.

- Impactful operating team member alongside other analysts and administrators, serving up to 20 departments weekly for data pulls, analysis, and problem resolution to ensure continuation of care and operational efficiency.

Intermediate Systems Analyst Jan 2010-Dec 2012 UPMC - Corporate Services - Pittsburgh

- 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 between departments to get an understanding of their data and how it relates to the data were pulling. We needed to understand their data for reports that we sent to the state.

- Work with the project manager to define tasks and create teamwork plans with moderate supervision.

- Utilize data to target project goals, project costs, communicate project-related expenses, reduce costs, suggest increased stretch of resources and recommends ways to control costs.

Systems Analyst Jan 2006 – Dec 2009 Excela Health – Westmoreland County, PA

- 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 University

Bachelor of Science in Business Administration in

Management Information Systems 1995

MILITARY SERVICE

United States Naval Reserve – Communications 1986 - 1994

Honorable Discharge (Held Top Secret security clearance)

- March 1989-January 1994, Pittsburgh, PA

- March 1986 to March 1989, USS Merrill in San Diego CA

Contact this candidate