EPIC Certifications: Cogito Project Manager - Version 2014 Clarity ETL Administrator - Version 2009 - 20014 Radar Administrator - Version 2012 - 2014 Clarity Reporting Workbench - Completed Training - Certification Pending Clarity Data Model Hospital Billing - Completed Training - Certification Pending Clarity Data Model Professional Billing - Completed Training - Certification Pending Epic Infrastructure Planning (Hardware, Software and Third-Party Licenses Acquisition) Clarity Tools (Hyperspace, Clarity Console, ECI) installation, configuration and maintenance Cogito Data Warehouse Installation, configuration and maintenance SQL Server installation, configuration, upgrade, and maintenance, SQL Server BI suite (SSIS, SSAS, SSRS) Database Security, Implementing High Availability and Disaster Recovery Configuring & administering Reporting Server with Business Object Enterprise essential tools Epic Reports testing, development and validation Writing system and technical documents, and end user training materials reference manuals Radar Dashboards implantation, troubleshooting and maintenance Meaningful Use / Go-Live Implementation & Support

Reporting Infrastructure Cordinator / Lead Clarity ETL / BOE / MS SQL Administrator @ Key Responsibilities: • Analyzed infrastructure and provided Epic and industry recommended hardware and software tailored to meet budget • Cogito Data warehouse setup, support and maintenance • Coordinating Epic Reports testing, development and validation • Developed a Clarity Monitoring process that notify end-users about reports data validity at run-time • Designed and created SSIS packages to Import / Export Clarity data; troubleshoot and resolved data load errors • Worked with vendors and third party resellers to procure necessary software licenses • Installed and maintaining Clarity Compass, Console, and Hyperspace version 2012  2014 • Monitored Clarity daily, weekly, and monthly extracts; troubleshooting and resolving all data load failures and causes • Implemented full cycle of the Epic ERM System Clarity Tools deployment; from POC  TST PRD • Collaborated with App team analysts and Epic TS to configure our Environment for Meaningful Use • Implemented Go-Live strategies and provided crucial support • Configured Reporting system server; Installed Business Objects Enterprise XI 3.1 SP5, 4.0 SP6, 4.1 SP2 • Enabled and configured BOE Windows AD Authentication / Single Server Sign-On with Kerberos and Load Balancing • Created user groups, access levels and managed application security; managed servers and troubleshoot BOE • Configured Epic Crystal Integration; create, troubleshoot and resolved issues Myreports Dashboard • Designed and Implemented High Availability / Disaster Recovery Strategies for Clarity and entire reporting environment • Installed, upgraded, and maintained SQL Server 2008 R2 & 2012; managed user access and troubleshoot performance • Optimized SQL environment via Virtualization and Consolidation saving thousands in SQL Enterprise Licenses From February 2013 to Present (2 years 10 months) Rockford, Illinois AreaLead Clarity ETL Administrator / BOE Administrator / MS SQL DBA @ Key Responsibilities: Installed and maintaining Clarity Compass, Console, and Hyperspace version 2012 Monitored Clarity daily, weekly, and monthly extracts; troubleshooting and resolving all data load failures and causes Implemented full cycle of the Epic ERM System Clarity Tools deployment; from POC TST PRD Collaborated with App team analysts and Epic TS to configure our Environment for Meaningful Use Ensured integrity of Reporting database via Data Link etc. while maintaining HIPPA patient’s data regulation Configured Reporting system server; Installed Business Objects Enterprise XI 3.1 SP5 Enabled and configured BOE Windows AD Authentication and Single Server Sign on with Kerberos Created user groups, access levels and managed application security; managed servers and troubleshoot BOE Configured Epic Crystal Integration; troubleshoot and resolved issues Myreports dashboard Performed Reporting Workbench and Radar administration functions Designed and Implemented High Availability / Disaster Recovery Strategies for Clarity and entire reporting environment Installed, upgraded, and maintained SQL Server 2008, 2008 R2; managed user access and troubleshoot performance Optimized SQL environment via Virtualization and Consolidation saving thousands in SQL Enterprise Licenses Imported / exported data using SSIS packages Environment: SQL Server 2008, 2008 R2, TSQL, XML, IIS, BOE XI 3.1, Citrix, Tomcat Windows Servers (Physical & Virtual) 2008, 2008 R2 Microsoft Visual Studio 2008, SCOM From April 2012 to December 2012 (9 months) Lead Clarity ETL Administrator / MS SQL DBA @ Key Responsibilities: Installed and maintained Clarity Compass, Console, and Clarity Data Model; Upgrading from version 2009 to 2010 Monitored Clarity daily, weekly, and monthly extracts; troubleshoot and resolved all data load failures and causes Implemented full cycle of the Epic ERM System Clarity Tools deployment; from POC TST PRD Collaborated with App team analysts and Epic TS to configure our Environment for Meaningful Use Ensured integrity of Reporting database and associated load processes, maintaining HIPPA patient’s data regulation Provided 2nd / 3rd tier support to Reporting team and other IT Operations that rely on Clarity data and other databases installed and configured IIS Application Servers to support Clarity Compass and Console and other ftp services Configured Reporting System Server, and Installing Business Object Enterprise XI 3.1 SP3 Designed and Implemented High Availability and Disaster Recovery Strategies for Clarity and entire SQL environment Installed, upgraded, and maintained SQL Server 2005, 2008, 2008 R2 Monitored the database’s and server's health via (System Center Operation Manager) and tuned accordingly Optimized SQL environment via Virtualization and Consolidation saving thousands in SQL Enterprise Licenses Imported / exported data using SSIS packages Environment: SQL Server 2000, 2005, 2008, 2008 R2, TSQL, XML, IIS, BOE XI 3.1, Citrix Windows Servers (Physical & Virtual) 2003, 2008, 2008 R2 Microsoft Visual Studio 2008, SCOM From May 2010 to May 2012 (2 years 1 month) Consultant DBA/Developer @ Key Responsibilities: Analyzed business requirements, designed, developed, troubleshoot, debugged, and deployed software; all aspects of Software Development Lifecycle Installed and upgraded SQL Server 2005; monitored the database server's health and tuned accordingly; ensured proper storage usage; performed periodical backup and restoration duties; managed database user and security Designed and developed database Installed, and configured Windows Server 2003; updated servers with latest service packs and hot fixes Worked with TSQL, created, analyzed, debugged, upgraded and executed stored procedures and triggers installed and configured IIS Application Servers to support web and ftp services Used SSRS to create, deploy and manage reports for organization Imported / exported data using SSIS packages Environment: SQL Server 2005, TSQL, XML, IIS, COM+, ADO, ADO.NET Java Script, Windows Server 2003, Microsoft Visual Studio 2008, .NET Framework 3.5 From November 2008 to April 2010 (1 year 6 months) Software Developer / MS SQL DBA @ Key Responsibilities: Installed and upgraded SQL Server 2005; monitored the database server's health and tuned accordingly; ensured proper storage usage; performed periodical backup and restoration duties; managed database user and security Installed, and configured Windows Server 2003; updated servers with latest service packs and hot fixes Worked with TSQL; created, analyzed, debugged, upgraded and executed Stored Procedures Used SSAS to design, create, and manage structures that contain data aggregated from other data sources Reviewed code and made sure they comply with current company standards; created and tested patches before they were deployed on production servers Moved objects and replicated data between development and production servers Analyzed and troubleshoot application runtime performance; debugged components and generated tested data and application to meet the functionalities/deliverables in the project documentation and specifications. Logged and communicated changes to management installed and configured IIS Application Servers to support web and ftp services Environment: SQL Server 2005, SQL, TSQL, XML, IIS, COM+, ADO, ADO.NET Java Script, VB Script, Windows Server 2003, Microsoft Visual Studio 2005, .NET Framework 2.0, Visual Source Safe From May 2007 to August 2008 (1 year 4 months) SQL DBA / Domain Administrator @ Key Responsibilities: Installed and upgraded SQL Server 2005; aid in the migration from SQL Server 2000 to 2005 Installed, and configured Windows Server 2003; updated servers with latest service packs and hot fixes Implemented RAID 1 and RAID 5 on mission critical servers such as domain controllers and file servers From February 2006 to November 2006 (10 months)

Bachelor of Arts, Computer Science and Philosophy @ University of the West Indies / Michigan State University Renbert Mclean is skilled in: Microsoft SQL Server, SQL, Visual Studio, IIS, VBScript, JavaScript, Visual Basic, VB.NET, ASP.NET, ASP, CSS, HTML, Powershell, Software Documentation, Strategic Planning