Data Analyst Power Bi
Resume:
John Bedoya
**********@*****.** • **** N College Avenue, Indianapolis, Indiana 46205
Objectives
To be in a leadership position where I can be a source of knowledge and seen as an authority to be able assist the organization realize current and future corporate goals and objectives. Education
Master of Business Administration (MBA) - Healthcare Administration Focus - Indiana Wesleyan University
Bachelor of Science (BSc) – Management - Indiana Wesleyan University Health Information Management - George Brown College - Toronto, Ontario Experience
Titan Health Management Solutions – Data Analyst – Data and Analytic - July 2022 to December 2024 (Organization Restructuring casualty) Data Analyst – Data Analytics and Programming
Responsible for developing dashboards and visualizations from raw data and internal sequel databases using Power BI,
Responsible for analyzing data and providing auditors areas of potential revenue, Responsible for providing leadership with high level dashboards to support evidence- based decisions, volumes, and projections,
Responsible for working with client representatives providing them with data, dashboards, and analysis,
Responsible for ensuring that all dashboards were complete, relevant, accurate and timely.
State of Indiana - Department of Revenue - June 2021 to April 2022 (Contract Position ended)
Operations Metrics Data Analyst – Department of Revenue John Bedoya
• • •
Responsible for developing dashboards from previous visualizations done in excel and internal databases using Power BI,
Responsible for analyzing data using excel to ensure the data being used was valid, accurate, timely and relevant,
Responsible for extraction of data using SQL from Indiana Tax System (ITS), Responsible for working with operations leaders to establish relevant key performance indicators (KPIs).
Responsible for ensuring that all deliverables were completed on time and delivered to management with the required specifications
Community Health Network – Indianapolis, Indiana – Decision Support - June 2018 – May 2021.
Analyst – Quality - Analytics and Decision Support Responsible for setting up, visualization, and execution of our executive dashboards using excel and Power BI.
Responsible for analyzing data using other analytical tools such as EPIC, Qlikview, Midas, Vigilanz and our internal financial system to ensure accurateness, Responsible for validation of key surgical data used by CMS for our Surgical Infection Ratios (SIRs).
Responsible for setting up procedures for validation of data to ensure correctness, completeness and accuracy.
Responsible for submitting network data to third party health agencies like Indiana Department of Health and the Indiana Hospital Association. Responsible for training super users, key users as well as the Senior Leadership Team on utilization and navigation of Power BI dashboards. Responsible for providing other adhoc analysis as requested Eskenazi Health – Indianapolis Indiana – Information Technology Services - July 2011 – March 2018.
Senior Analyst – DBA - Information Technology, Finance and Decision Support Responsible for ensuring the seamless implementation of McKeson HPM and HBI as the chosen business intelligence tool for the organization. Responsible for setting up and executing a working plan of HBI as the selected source of
“truth” for the organization.
John Bedoya
• • •
Responsible for analyzing data using other analytical tools such as Excel, Surgical Information Systems (SIS) and SAP to validate the accuracy of the information transferred to HPM and HBI.
Responsible for recruiting a data quality working group to solicit feedback from a large variety of data quality issues.
Responsible for co-chairing monthly data quality working group meetings. Responsible for training super users, key users as well as the Senior Leadership Team on utilization and navigation of HBI.
Responsible for maintaining current data from STAR in HBI server as well as exploring new datasets that can be reported through HBI.
Responsible for providing analytical support to the Aging Brain Program as part of a condition of an 8 million dollar grant from CMS
Responsible for providing other adhoc analysis as requested York Central Hospital, Richmond Hill, Ontario – Feb. 2007 – May 2011 Project Manager & Senior Analyst, Planning and Decision Support Responsible for the planning, implementation, facility-wide roll – out, training, future development, administration and continuous quality improvement of HBI Responsible for maintaining all projects relating to HBI. Coordination of personnel from McKesson project team, Finance, IT, Decision Support, Health Records, Rehab, Complex Continuing Care and Mental Health.
Ensuring that the corporation’s goals and objectives are met. Tracking delays, targets, and milestones using Eclipse project management tool. Planning, coordination and chairing of meetings with the project team. Setting agendas and coordination of duties and responsibilities of the project team. Responsible for the uploading of inpatient, outpatient, emergency, Mental Health, Complex Continuing Care, Rehab and external data sources into HBI. Responsible for the upkeep, general maintenance, data quality and overall functionality of HBI.
Responsible for all administrative rights to HBI. Settings up profiles for users, access to data and other administrative privileges to users and groups. Responsible for developing new data sets, creating new scorecards, and working with Senior Management to develop key performance indicators that are within the strategic goals of the corporation
Southlake Regional Health Care – Newmarket, Ontario – Dec. 2002 – March 2007. Manager, Health Information and Decision Support
Provided leadership to a staff of 35 full-time and part-time employees. Project lead for Medworxx Concurrent Clinical Review Project in a lead role for one physician adviser and two clinical nurse reviewers. Responsible for managing a modern Health Information and Decision Support Department with a budget of $1.2 million dollars.
Responsible for the day to day operations of a busy health information and decision support department.
John Bedoya
• • •
Responsible for processing employees worked hours. Responsible for providing decision support data to the Chief Operating Officer. Responsible for monthly submissions to CIHI
Developing and running regular automated internal data quality checks using Winrecs, Crystal 11 report writer and HBI.
Ensuring staff met all internal guidelines for coding and abstracting as well as release of information and patient confidentiality.
Further Education Goals
I would like to achieve a PhD in Population Health.
Contact this candidate