Daniel P. Email & Phone Number

Harrisburg, Pennsylvania, United States

• Develop new reports in, SAS-TSQL, and Tableau, Microsoft Access & Office, and SQL Management Studio 2008 and 2014.• Maintenance, alteration, and revamping of existing reports to better suit changing business and financial needs as contracts with our health partners evolve and change.• Communication of data status, unique data points, business concerns, and points of contention with internal partners, including quality business analysts and contracting, as well as external partners be they business, administrative, or functional – including medical and pharmacological professionals.• Work closely with subject matter experts, partner contractors, and partnering health systems to provide overarching report packages that offer actionable, prescient insight on current business and market trends.• Produce ad hoc reports to answer specific questions regarding shifts in member activity, cash flow, and shared savings on a case-by-case basis.• Responsible for the presentation of data in easily digestible packages with health partners and internal subject matter experts and health system-specific managers and the fielding of questions raised from the data presented.• Management and control of procedures utilized by business analysts and BI developers for monthly and quarterly reports and interacts with our partners.

Mechanicsburg, Pa

• Develop new reports in Crystal Reports, TSQL, Reporting Workbench and Radar Dashboards (EPIC Hyperspace proprietary software.) Proficiency in Crystal Reports, Microsoft Access & Office, and SQL Management Studio 2008 and 2014.• Development of reports in MicroStrategy VI including development of dashboards, documents, and data cubes in SQL.• Work closely with business analysts, and internal end users to clarify requirements for report updates or build. Gathering requirements, obtaining feedback, and presenting the project as it develops.• Coordinate with server management team, data warehouse team, and ETL team in order to make available all necessary tables from Epic-maintained and MedHost sources and maintain them when necessary.• Maintain existing report repository. This includes identifying errors, remedying conflicts, and improving its uses to better suit end-user needs.• Tweak, repair, or otherwise modify all currently utilized reports as requests develop, whether Epic-built or internally-built, as new iterations are debuted.

Elizabethtown, Pa

• Negotiate Union contracts upon renewal years.• Balance yearly budgets and prepare financial reports for public viewing.• Hold public hearings to receive and answer public opinions and questions.• Handle disciplinary matters involving administration and local law enforcement.• Work in committees to decide school-wide policy.• Liaison to other public boards and organizations.

Bachelor'S Degree, Business Administration, Management And Operations, 3.65

Education record