Marcus Heilers Email & Phone Number

Sydney, Australia

Sydney, Australia

Responsibilities:• working as a data analyst with a KPMG client in the superannuation administration space to investigate and resolve data related issues on their Acurity superannuation system • using SQL to identify the scope of issues and categorise the results based on root cause and applicable fix• development of SQL scripts to generate Electronic Processing (EP) files and Acurity report files (U2AD general ledger fix report)• particular areas of focus have been Acurity general ledger fixes and insurance related fixesKey Achievements:• identification and resolution of a migration cutover fee calculation issue impacting a substantial number of members• ongoing work to resolve complex insurance data quality issues

Sydney

Responsibilities:• managing the wind down and resolution of outstanding data migration issues post go-live• developing PL/SQL data fix scripts • analysing PL/SQL to identify ETL issues and working with onshore and offshore resources to resolve these issues• data analysis and reconciliation for unit registry data migration project – Talisman (Sybase) to Sonata (Oracle).• working with onshore and offshore resources to fix and improve the reconciliation reportsKey Achievements:• managing the resolution of outstanding data migration issues and reconciliations• development of data fixes to resolve complex migration issues with the potential to have financial impacts on account holders• working successfully with the offshore team to resolve complex reporting requirements• high throughput of work leading to the early establishment of stable and accurate reconciliation reports

Sydney

Responsibilities:• development of APRA reporting solution to provide data to an external client• performance tuning SSIS packages to support the Data Warehouse loads• performance tuning stored procedures, and implementing indexing strategies to support OLTP applications• general SSIS and SSRS development• providing guidance, functional knowledge and solution design to support the implementation of fee-for-service work and BAU work• supporting the transition to a new off-shore IT service provider and participating in the formal knowledge transfer process, as well as ongoing ad-hoc knowledge transfer• peer review of SSIS and SSRS developmentKey Achievements:• successful development and implementation of APRA reporting solution to provide data to external client. This involved incorporating client data into an existing data model, and generating flat files in a client specific format. The key skills required included data analysis and interpretation, TSQL (functions, stored procedures, database design), and SSRS• working with on-shore and off-shore resources from the IT service provider to pass on knowledge, skills and improve development and testing standards

Sydney, Australia

Responsibilities:• workflow management of a small team of on-shore and off-shore SQL Server developers• involvement in all stages of the SDLC including costing fee-for-service work, business analysis, solution design, development, peer review and testing, and ongoing support and maintenance• ongoing development and provision of data to support APRA regulatory reporting requirements• creation, monitoring, and general management of SQL Server Agent jobs• using SQL Server Profiler to troubleshoot problems• ad hoc database backups and restores• acting as SQL Server SME• development of new SSIS packages and maintenance / process improvement of existing packages• development of new SSRS reports and maintenance of existing reports• production deployment of SSIS packages, SSRS reports and SQL server objects• providing support for various OLTP SQL Server databasesKey Achievements:• development of SuperMatch functionality that included triggering the generation of member correspondence, and provision of data to member websites• increased Data Warehouse integration with client facing websites• development and supervision of APRA reporting solution

Sydney, Australia

Responsibilities:• workflow management of a small team of on-shore and off-shore SQL Server developers• involvement in all stages of the SDLC including costing fee-for-service work, business analysis, solution design, development, peer review and testing, and ongoing support and maintenance• development of new SSIS packages and maintenance / process improvement of existing packages• development of new SSRS reports and maintenance of existing reports• production deployment of SSIS packages, SSRS reports and SQL server objects• creation, monitoring, and general management of SQL Server Agent jobs• acting as SQL Server SME• providing support for various OLTP SQL Server databases• registry system (SuperB) data fixesKey Achievements:• implementation of two new clients into the data warehouse where each client required new data structures and new data sources• development of reporting solution that allowed client access to data warehouse reports• development of solution for the auto-generation of member correspondence based on certain member events identified from the data• bedding down of the relationship with off-shore IT service provider

Sydney, Australia

Key Responsibilities:• SSRS report development• Crystal report development• MS Access data extracts• registry system (SuperB) configuration, query writing and data fixes• Jetform and Report Writer developmentKey Achievements:• development of Policy Committee reporting solution. SSRS based report that is typically 30 to 40 pages depending on the employer. Data is sourced from the data warehouse and covers a number of different source systems. • successful delivery of Crystal based annual member statements across 3 years for a major client.

Sydney, Australia

Responsibilities:• covered all aspects of superannuation administration including benefit payments, processing of payroll files, regular pension payments, and reconciliations. The role also included resolving member complaints, working with and understanding defined benefit design, and resolving member enquiries.• workflow supervision• conducting internal audits across various business processes

Master Of Information Technology, Gpa 3.71

Bachelor Of Economics Honours, Economics, Honours Second Class Division 1