Business Intelligence

• Facilitated Scrum framework – sprint planning, backlog grooming, daily scrums, sprint reviews, and sprint retrospectives.
• Explained data results and discussed how best to use data to support project objectives.
• Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
• Designed advanced analytics ranging from descriptive to predictive models to machine learning techniques through R, SQL/SSMS, Tableau, and Alteryx.

• Collaborated on stages of the systems development lifecycle from requirements gathering to production releases with Azure DevOps.
• Built parameterized reports involving Sub Reports, Matrices, Expressions, and Graphs using SSRS and Crystal Reports.
• Converted 300 Crystal Reports to SSRS.
• Migrated, revised, and produced 93 stored procedures and 37 functions to a new database in SSMS.
• Collaborated with system architects, design analysts, and others to understand business and industry requirements.
• Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.

• Established effective workflows and best practices, mentored team members, and facilitated training for internal staff and customers.
• Collaborated with clients to develop analytical solutions through SSMS, Crystal Reports, Data Extracts, AWS, and Excel dashboards using DAX and Power Pivot.
• Implemented an agile environment using Jira and Git with Source Tree and Bitbucket.
• Developed and implemented performance improvement strategies and plans to promote continuous improvement.
• Designed and implemented effective database solutions and models to store and retrieve data.
• Updated old code bases to modern development standards, improving functionality.

• Analyzed data in enterprise-wide systems in Healthcare for Epic DataModules, Ambulatory, EpicCare Inpatient, and ASAP.
• Built and deployed data visualizations, ad-hoc reports, and report schedules/subscriptions using SSMS, SSRS, Tableau, EPIC, CrystalReports, and SAP BusinessObjects InfoView.
• Extracted data from internal data warehouses and source systems to develop comprehensive operational and clinical performance measures, leading to 10 – 20% efficiency improvement.
• Built HCC tables to map HCC codes in SSMS and provided analytical solutions on HCC data.
• Analyzed financial data to identify trends and patterns that could increase the organization’s revenue.

• Developed operational and analytical reports, dashboards, security classes, and dashboard components through SQL/SSMS, Crystal Reports, and EPIC.
• Collaborated and implemented two EPIC upgrades.
• Implemented business intelligence solutions to increase operational efficiency.
• Use statistical methods to analyze data and generate useful business reports.
• Identified, analyzed, and interpreted trends or patterns in complex datasets.
• Built and reported the annual Uniform Data System (UDS) and MeaningfulUse data.