Coordinates and provides data analytic support to the Internal Audit department through the development and deployment of computer assisted audit techniques. Provides specialized data analytic support to the core Internal Audit groups using T-SQL, PL/SQL, and other software.Key Achievements:● Created queries and analytics to provide users data on opioid prescribing by Emergency Room doctors.● Developing queries in Oracle and analytics to periodically monitor payroll activity to identify anomalies such as terminated employees receiving pay and trending of excessive overtime payments.

Developed and modified various operational reports and dashboards based on data stored in SQL Server databases using tools such as SSRS and SSIS. Tasks include developing the initial SQL query working with temp tables, functions, views and stored procedures as well as creating report layouts. Also included working with different EHR systems such as Meditech, Allscripts, and Cerner.Key Achievements:● Built reports to monitor how users utilize the EHR to improve efficiency and patient safety.● Assisted in configuring reports in Allscripts to be used at University Hospitals’ recently acquired hospitals.

Deliver strategic technical analysis and data mining by developing detailed reports and utilizing SQL to write queries to extract data from Meditech’s data repository. Employ Meditech’s proprietary NPR Report Writer tool to extract from older systems and the Report Designer tool to pull data from newer systems. Partner closely with business analysts and hospital end-users including nurses and physicians to gather business requirements to determine specific data needing to be extracted.Key Achievements:● Improved overall productivity by converting old NPR reports to SQL queries.● Develop reports to pull data out of modules including Billing, Radiology, Laboratory, Order Entry, and Scheduling.● Consistently demonstrate solid development skills resulting in senior-level in product development.

Supported complex applications including Magic ITS and Magic Radiology along with Client Server ITS while analyzing, designing, developing code, and testing in a development environment. Manage development activities from start to finish for the software development lifecycle and developed technical specifications for requested enhancements. Key Achievements:● Demonstrated strengths in writing code to enhance and improve software functionality.● Resolved reported bugs and wrote and developed code to fix issues.● Collaborated with Interoperability group to resolve issues in interfaces between ITS and other vendors.

Developed and modified procedures to customize application software defining scope and long-term business objectives. Conducted in-depth analysis of business systems to resolve complex technical issues while supporting product installations and delivering current product releases to clients.Key Achievements:● Played a key role in decreasing costs by implementing process improvement initiatives.● Managed customer accounts which included partnering with consulting staff to address customer issues.