MERLIN JOSEPH

<p>Developed complex Cerner SQL queries to extract, transform, and analyze clinical and operational data for reporting and decision-making.</p><p> Designed and maintained SAP BusinessObjects (SAP BI) reports and dashboards to monitor Emergency Department KPIs, patient flow, and operational performance.</p><p> Built interactive Power BI dashboards to visualize operational metrics, enabling real-time performance monitoring and data-driven decisions.</p><p> Automated data extraction, validation, and reporting workflows using Python, SQL, and Microsoft Excel, improving efficiency and reducing manual effort.</p><p> Delivered ad hoc analyses and operational reports by integrating data from Cerner, SAP BusinessObjects, Power BI, and Python to support leadership, quality improvement, and research initiatives.</p>

<p>Working closely with Risk management, Quality and patient Safety, created reports and presentations and supported the team during CARF accreditation.</p><p> Supported database tools and dashboards to evaluate data quality and operational functions.</p><p> Developed automated programs, methodologies, and tools to analyze and visualize data.</p><p> Enhanced data profiling, mapping, lineage tracking, and metadata management processes.</p><p> Gained functional exposure to Cerner Millennium workflows, supporting efforts to align data definitions and quality metrics with clinical documentation practices.</p>

<p>Observed and documented Cerner Millennium clinical workflows to identify and extract critical discrete data items essential for system functionality and enterprise architecture.</p><p> Gained hands-on experience with system-specific workflows as an intern, focusing on the extraction of key data elements and functionalities within the Clinical Information System.</p><p> Contributed to the documentation and identification of data elements from process flows, aiding in the development of a system architecture template for optimizing future system designs.</p>

<p>Collected, cleaned, and prepared data from PostgreSQL, APIs, and CSV files using SQL and Python for ETL and analysis.</p><p> Conducted exploratory data analysis (EDA) using Python (pandas, NumPy, matplotlib, seaborn) to identify patterns, trends, and outliers in the data.</p><p> Developed 10+ projects, designed interactive Power BI dashboards with KPIs and trends, using DAX measures and dynamic filters to enhance insights and customize user experience.</p>

<p>Designed SQL queries and Power BI dashboards for projects, improving data visibility.</p><p> Cleaned and prepared datasets using Python and Excel for reporting and insights.</p><p> Delivered actionable data reports and visualization metrics for clients.</p>

<p>Managed accreditation-related data collection, validation, and reporting, ensuring timely submission of accurate compliance reports.</p><p> Managed SQL and Oracle databases to structure and maintain academic data on rubrics, course content, and evaluation metrics with strong data integrity.</p><p> Handled research and institutional datasets, conducted data cleaning, analysis, and visualization using Python (Pandas), Power Bi and SQL.</p><p> Extracted, processed, and visualized engagement and performance data from internal systems (e.g., LMS), supporting data-driven planning, compliance, and continuous improvement efforts.</p>

<p>Managed SQL and Oracle databases and guided database projects using MySQL and PostgreSQL to maintain academic data models and ensure data integrity.</p><p> Developed and automated Python workflows to analyze trends in attendance, performance analysis, and engagement for timely academic reporting.</p><p> Performed data analysis and created visual reports using Python and Excel to support curriculum decisions and institutional improvement.</p>