Michael Yimer

• Configuring and testing Epic released and Foundation System content for all applications in Cogito SQL and Caboodle.
• Epic on Azure Migration Lead for Cogito System Applications.
• Creating content to display Epic data from Chronicles, Clarity, and Caboodle.
• Writing SQL and configuring extracts.
• Modifying existing reports, as necessary.
• Distributing analytics content to data consumers.
• Working with subject matter experts to understand the needs of data consumers.
• Reviewing upgrade documentation related to Cogito features and determining how to implement the changes.
• Developed and Maintained Caboodle custom DMCs from Epic data and non-Epic data sources.
• Designed and Developed Data models for Caboodle DMCs/ Epic Data warehouse using SSIS packages.
• Developed and wrote and refined from Crystal reports and other sources (Clarity) of reports from simple to complex SQL queries used for reports and extracts.
• Designed, developed, tested, tuned, and maintained Extract, Transform, and Load (ETL) processes within the Epic Clarity and Caboodle database environment.
• Developed Cogito SQL Templates for extracts moving from Non-Prd to PRD environments using content management tickets (Data Courier).
• Performed modifications, full upgrades, patches, and SU's on all Epic Clarity and Caboodle environments.
• Performed production support and maintenance operations, participated in on-call support rotation, and actively resolved incidents and restored services in a continuous improvement environment.
• Assisted with Epic upgrades/updates by serving as a subject matter expert for the Epic Clarity/Caboodle data models.
• Served as a primary participant in a collaborative relationship with leadership and peers to develop and implement processes to promote an integrated delivery system, to assist end users and to provide a positive patient experience.
• Implement, maintain and support Epic Data Analytics suite of products - Clarity, Caboodle, Slicer Dicer, Business Objects, Cognitive Computing and other related tools.
• Participate in architecture, design and integration aspects of the relevant tools and associated development and enhancement lifecycle.
• Collaborated with infrastructure teams, downstream consumers and the vendor to ensure smooth upgrades and patch deployments.
• Perform enhancements to Caboodle data models to meet Clinical/business needs.
• Developed and enhanced SSIS packages/ETL jobs.
• Identify opportunities to automate various mundane functions and ensure that health of the automated functions are working as per the fitness needs.
• Monitored and coordinated installation and upgrades of hardware and software as necessary to enhance database performance.
• Researched various hardware and software products; recommended solution and implements approved products.
• Monitored production systems for issues and resolved issues or escalated them for resolution when necessary.
• Performed database backups, Understanding of monitoring best practices for database size and health while leading Epic Technical implementations.
• Installed and configured Epic Clarity & Caboodle console/datasets and maintained Cubes servers.
• Configured Epic Clarity and Caboodle ETL jobs, processes, and troubleshooting.
• Mentored client project teams as necessary in project and system build strategy.
• Led meetings regarding project status and ongoing work-product coordination.

Install Clarity and Caboodle Datasets on Cloud platform - Epic on Azure Implementation Consultant
• Installation and setup of Microsoft SQL server to support the Cogito databases
• Monitor Clarity and Caboodle data extraction (ETL) jobs
• Correct Clarity and Caboodle data extraction (ETL) errors
• Troubleshoot, research, and resolve Clarity and Caboodle data errors
• Maintain Epic Cogito console servers
• Apply Epic SU's and full upgrades to the Clarity and Caboodle environments
• Configure and expand Caboodle Data Model Components to meet enterprise analytical needs
• Configure SlicerDicer related access and security
• Make technical recommendations related to application upgrades
• System Administration of EDW maintained applications.

Participate in architecture, design and integration aspects of the relevant tools and associated development and enhancement
lifecycle.

Collaborated with infrastructure teams, downstream consumers and the vendor to ensure smooth upgrades and patch
deployments.

• Configuring and testing Epic released and Foundation System content for all applications in Cogito SQL and Caboodle.
• Creating content to display Epic data from Chronicles, Clarity, and Caboodle Writing SQL and configuring extracts.
• Modifying existing reports, as necessary. Distributing analytics content to data consumers.
• Testing analytics build in a specified testing environment and volume testing in live environments.
• Reviewing upgrade documentation related to Cogito features and determining how to implement the changes.
• Developed and Maintained Caboodle custom DMCs from Epic data and non-Epic data sources.
• Designed and Developed Data models for Caboodle DMCs/ Epic Data warehouse using SSIS packages.
• Developed and wrote and refined from Crystal reports and other sources (Clarity) of reports from simple to complex SQL queries used for reports and extracts.
• Designed, developed, tested, tuned, and maintained Extract, Transform, and Load (ETL) processes within the Epic Clarity and Caboodle database environment.
• Performed modifications, full upgrades, patches, and SU's on all Epic Clarity and Caboodle environments.
• Took lead with Epic upgrades/updates by serving as a subject matter expert for the Epic Clarity/Caboodle data models.
• Monitored and coordinated installation and upgrades of hardware and software as necessary to enhance database performance.
• Researched various hardware and software products; recommended solution and implements approved products.
• Monitored production systems for issues and resolved issues or escalated them for resolution when necessary.
• Performed database backups, Understanding of monitoring best practices for database size and health while leading Epic Technical implementations.
• Installed and configured Epic Clarity & Caboodle console/datasets and maintained Cubes servers Configured Epic Clarity and Caboodle ETL jobs, processes, and troubleshooting.
• Mentored client project teams as necessary in project and system build strategy.
• Led meetings regarding project status and ongoing work-product coordination.

• Developed and Maintained Caboodle custom DMCs from Epic data and non-Epic data sources.
• Designed and Developed Data models for Caboodle DMCs/ Epic Data warehouse using SSIS packages.
• Developed and wrote and refined from Crystal reports and other sources (Clarity) of reports from simple to complex SQL queries used for reports and extracts.
• Designed, developed, tested, tuned, and maintained Extract, Transform, and Load (ETL) processes within the Epic Clarity and Caboodle database environment.
• Developed Cogito SQL Templates for extracts moving from Non-Prd to PRD environments using content management tickets (Data Courier).
• Performed modifications, full upgrades, patches, and SU's on all Epic Clarity and Caboodle environments.
• Performed production support and maintenance operations, participated in on-call support rotation, and actively resolved incidents and restored services in a continuous improvement environment.
• Assisted with Epic upgrades/updates by serving as a subject matter expert for the Epic Clarity/Caboodle data models.
• Served as a primary participant in a collaborative relationship with leadership and peers to develop and implement processes to promote an integrated delivery system, to assist end users and to provide a positive patient experience.
• Defined and managed user roles, access and permissions to access database and other system resources.
• Installs, implements and supports complex systems within user base; creates and updates database installation instructions and design changes for client use.
• Monitored and coordinated installation and upgrades of hardware and software as necessary to enhance database performance.
• Researched various hardware and software products; recommended solution and implements approved products.
• Monitored production systems for issues and resolved issues or escalated them for resolution when necessary.
• Highly experienced with installation and configuration of MS SQL server to support Epic databases.
• Maintained Linux servers, Updated Linux Certificates.
• Performed database backups, Understanding of monitoring best practices for database size and health while leading Epic Technical implementations.
• Installed and configured Epic Clarity & Caboodle console/datasets and maintained Cubes servers.
• Configured Epic Clarity and Caboodle ETL jobs, processes, and troubleshooting.
• Applied technical expertise to individual client system build in order to identify, troubleshoot, and resolve problems.
• Mentored client project teams as necessary in project and system build strategy.
• Led meetings regarding project status and ongoing work-product coordination.

• Implemented, maintained, and supported Epic Data Analytics suite of products - Clarity, Caboodle, Slicer Dicer, Cubes.
• Developed and Maintained Caboodle custom DMCs from Epic data and non-Epic data sources.
• Designed and Developed Data models for Caboodle DMCs/ Epic Data warehouse using SSIS packages.
• Developed and wrote and refined from Crystal reports and other sources (Clarity) of reports from simple to complex SQL queries used for reports and extracts.
• Participated in architecture, design, and integration aspects of the relevant tools and associated development and enhancement lifecycle.
• Established automated solutions to monitor and act to ensure optimal user experience and performance of the various workloads.
• Collaborated with infrastructure teams, downstream consumers, and the vendor to ensure smooth upgrades and patch deployments.
• Kuiper: Configured & deployed clarity console, BI-Restful, SlicerDicer, and Reporting content using Kuiper.
• Deployed special updates & upgrades to cogito applications using Kuiper.
• Performed enhancements to Caboodle data models to meet Clinical/business needs. Developed and enhanced SSIS packages/ETL jobs.
• Identify opportunities to automate various mundane functions and ensure that the health of the automated functions is working as per the fitness needs.
• Maintain all relevant functional and technical documentation.
• Installed and configured SQL server on production and development servers. Reviewed security, performance, and disk space and recommended corrective actions where needed.
• Implemented spotlight essentials data collection in order to analyze performance and troubleshoot ongoing issues.
• Implemented several data collection jobs in order to analyze database issues, such as missing and unused indexes, deadlocks, disk space, scheduled jobs/durations, and plan cache optimization.
• Responsible for installing, configuring, managing, monitoring, and troubleshooting SQL Server. Dedicated support on rotation to all Production and DR servers.
• Participates in the development, documentation, and solution design of logical and physical data models. Additionally, technical expertise is applied to the design, development, and support of processing data of multiple databases and formats involving both internal and external sources and targets.
• Designs develop, and tests ETL processes for error handling, operations logging and alerting, scheduling, and job control.
• Actively resolves incidents and restores services in a continuous improvement environment. A strong proactive posture minimizes user outages and helps desk incidents.
• Troubleshoot incidents surrounding supported solutions, including after-hours escalations of major incidents. Troubleshoot, perform root cause analysis, provide solution production support incidents, and apply permanent improvements.

• Outstanding interpersonal and relationship management skills with the ability to effectively collaborate with varying levels of the organization and Stakeholders.
• Experience in MS SQL Server Installation, Configuration, Upgrading, Performance Tuning, Query Optimization, and running Database Consistency checks Using DBCC.
• Database design, development, and support of MS SQL Servers from 2008 up to 2016 in production and development environments.
• Created the SSIS packages to import and export data from various CSV files, flat files, Excel spreadsheets, and SQL Server.
• Involved in Migration on SQL Server database to SQL Server 2012-2016.
• Designs develop, and tests ETL processes for error handling, operations logging and alerting, scheduling, and job control.
• Develops, tests, and deploys quality ETL processes with minimal post-production incidents and performance and tuning excellence.
• Scheduled Jobs for SSIS packages, Backups, and Restore databases in Dev environment for debugging purposes. Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Maintained positive communication and working relationships with all business levels. Coordinating with all business levels. Coordinating with Onshore / Offshore and stakeholders team for task clarification, fixes, and Review. Reviewed, analyzed, and implemented necessary changes in appropriate areas to enhance and improve existing systems.