Andrew Foreman

Creates customized operational and project-related reports, which include functional areas of analysis, design, documentation, testing, implementation and support of EPIC Clarity and Chronicles reports. Designs and implements complex data extracts and data marts related to departmental needs for transaction level information and operational reporting. Reviews requested enhancements; works with project leads to prioritize and implement requested changes to Hospital Billing reports and extracts.

DBA: Multi-farm, large client SQL Server and Oracle, Automation: Backup, DTS, SSIS/SSRS, Jobs, powershell Development and Programming: t-sql, pl/sql.Net SSIS Server applications Designed reports in Asp.net, Crystal Reports, Custom Analytics, Excel, Filldoc, Merge, Yardi Scripts, YSL and, YSL.NET. Create innovative solutions to data management hurdles using C#, VB.NET, VB, Powershell, advanced t-sql. Develop and deploy customized t-sql and ssrs/ssis procedures and reports.

Maintain & access campus Oracle databases for ad-hoc & annual reports; Develop & administer appropriate data collection, analysis & presentation methodology for studies & projects; Develop methods for end-user reporting, access & retrieval of information; Perform a wide range of research & analysis, including statistical & empirical studies to assist in evaluation of institutional planning issues, accreditation, assessment, student success, retention & other measures of institutional effectiveness