Andrew Spokes's Email Addresses & Phone Numbers

📖 Summary

Developer; Economic Healthcare Cosultant @ UnitedHealth Group • Developed and maintained existing Oracle SQL Server database environments on systems for Production level support including statistical and predictive modeling, planned reporting, analysis and data warehousing for both members and providers• Developed automated tools and front end GUI support to create viable, real-world solutions in a complex health care landscape• Developed, maintained and updated automated processes within client databases and analyze reporting tools utilized by internal customer groups• Developed and maintained data analytics and large data sets of healthcare claims and encounters to measure progress towards key performance indicators and to investigate key business problems through quantitative analysis of health care data• Designed and maintained UNIX scripting used to automate data flows, report production and distribution of planned reporting and interdepartmental collaboration From December 2015 to November 2016 (1 year) Business Process Analyst @ Carrington College • Developed and maintained new and existing Microsoft SQL Server Database on systems for Production level support• Developed automated tools and front-end SharePoint interfaces to assist staff with generating customer facing documentation• Architected databases in MS SQL to be used for planned reporting, analysis, predictive modeling and data warehousing• Developed and maintained MS SQL Integration Services to manage and execute ETL jobs and packages• Developed and maintained MS SQL Reporting Services to provide on-demand reporting to colleagues• Designed and maintained all SSIS packages used to automate data flows and report production• Built planned on-demand SSRS reports and deployed them to our internal reporting server• Developed internal request interface to allow colleagues to submit requests and view the status and progress of their request• Developed automated reporting processes• Developed new SharePoint environment for the purpose of new request/report submissions and distribution of planned reporting and interdepartmental collaboration From July 2014 to November 2015 (1 year 5 months) Phoenix, ArizonaBusiness Intelligence Developer @ Apollo Education Group • Installed and configured Microsoft SQL Server and Oracle Database on systems for Development, QA and Production level support• Developed CRM application for student management• Assisted in the migration of MS SQL Databases to a secure production environment• Architected databases in MS SQL to be used for planned reporting, analysis, predictive modeling and data warehousing• Installed and configured MS SQL Integration Services to manage and execute ETL jobs and packages• Installed and configured MS SQL Reporting Services to provide on-demand reporting to operations, advisement and executive staff• Designed and maintained all SSIS packages used to automate data flows and report production• Built planned on-demand SSRS reports and deployed them to our internal reporting server• Programmed various stored procedures and table valued functions for the purpose of process and report automation• Developed internal policies and procedures relating to database and report usage as well as internal IT requests• Designed, built and replaced legacy processes relating to financial aid processing to improve customer experience• Developed automated reporting processes• Maintained department SharePoint services for the purpose of distributing planned reporting and interdepartmental collaboration• Developed, implemented, and managed complex projects From October 2008 to February 2014 (5 years 5 months) Phoenix, Arizona AreaBusiness Analyst @ Apollo Education Group • Developed processes to automate the production of performance reporting for advisement staff• Built automated data collection processes to extract data from various systems• Built planned reporting for advisement and accounting level staff• Consolidated and standardized several legacy processes• Built and maintained several GUI tools to automate continued reporting, improve performance and reduce manual intervention From January 2007 to October 2008 (1 year 10 months) Phoenix, Arizona AreaFinancial Services Manager @ Apollo Education Group • Managed a team of approximately 10 Finance Advisors and their student accounts to ensure quality performance and maintenance of students financial accounts and financial aid processing• Coached and trained counselors including new training and continuing education in relation to job skills• Created coaching and training materials and presenting at the regional level• Developed, trained and distributed new tools and reports to improve management of new student financial aid files From January 2006 to January 2007 (1 year 1 month) Phoenix, Arizona AreaFinancial Advisor @ Apollo Education Group • Managed students financial accounts to reduce bad debt and ensure continued student success• Audited documentation relating to student financial aid to ensure accurate and timely processing• Compiled reports to verify financial clearance for new and continuing students• Invoiced employers for students receiving tuition assistance and managed payments received• Continued student correspondence and occasional collection efforts for past due accounts From October 2003 to January 2006 (2 years 4 months) Phoenix, Arizona AreaSystem and Network Administrator @ Phc Mechanical Inc • Built, configured and maintained a local server with Microsoft Windows Small Business Server 2005• Architected and configured local area network (LAN) to enable file and print sharing for office employees• Configured Active Directory services within Windows SBS 2005 for existing and potential future employees• Configured and maintained local SharePoint services for office collaboration• Built, configured and maintained all office hardware including 10 end-user PC’s and server• Configured and remotely maintained local network security using Windows SBS 2005 services From October 2006 to October 2008 (2 years 1 month) Phoenix, Arizona Area