Kevin Prout Email and Phone Number

Three Month Contract ended 04 November 2011

ACHIEVEMENTS- Developed a reporting process using SAS enterprise guide application- Developed revenue reporting for the MBF Aust group not previously achieved- Developed a monthly reporting dashboard for senior management- Produced annual budget and regular quarterly forecasts- Created a sales incentive reporting processRESPONSIBILITIES- Reporting specialist for membership and revenue reporting- Produce monthly reports for the sales team and senior management- Monitor actual to budget variances and report major variances- Produce and recommend full year forecasting to senior leadership- Produce a monthly set of incentive sales reports

ACHIEVEMENTS- Delivered weekly and monthly membership reporting on time and with data integrity- Delivered theoretical income calculations not previously achieved to the finance and actuarial teams- Recognised and the reliable single source of truth for membership related information- Developed metadata definitions for most elements of membership reportingRESPONSIBILITIES- Produce detailed analysis on membership trends to target poor performance and reward exceptional performance- Produce regular weekly and monthly membership reporting- Produce a monthly theoretical income report to confirm accuracy of actual revenue- Reconcile the group management information portal on the SAS enterprise platform- Maintain business relationships with all areas of the business related to membership reporting

ACHIEVEMENTS- Produced the first set of metadata definitions for membership reporting- Produced documentation detailing all dimensions and measures with data definitions underlying each key performance indicator used- Developed user acceptance testing methodologies which confirmed data integrity of each key performance indicator- Produced operating proceduresRESPONSIBILITIES- The business analyst for the production of automated key performance measures- Coordinate data sourcing activities with data providers and functional managers- Assist in the production of the initial business case- Maintain ongoing data integrity

ACHIEVEMENTS- Developed tested and implemented an end user tool using the newly developed data warehouse- Provided technical expertise to information technology programmers- Developed standard automated reporting enabling managers to view daily, weekly and monthly, via the web- Developed training courses and technical manuals - Created user authority profiles RESPONSIBILITIES- Production and management of reporting and analysis from the new data warehouse- Business owner of membership, gross margin, sales and claims datamarts- Conduct data warehouse training for the business- Maintain User Profiles