Manager - System, Data and Transformation

• Nov 2022 - Present

Senior Data Analyst - CEE Performance and Analytics Consumer Finance

• Oct 2021 - Nov 2022

Analyst - Quality and Control Analytics

• Mar 2020 - Oct 2021

Working in the Risk Insights & Analytics team, John has managed and mitigated risk for the business unit on a day-to-day basis by developing and uplifting key business controls and assurance activities. These include:BAU Activities - With a keen eye for details, John produced weekly/monthly reports for teams across the CSN (Customer Service Network). He handled ad-hoc data requests and performed analysis using tools like tableau, SSIS and Teradata SQL Developer. Uplifting/automating assurance activities - John played an important role in standardising and uplifting 15 scenarios to support the automation of key assurance activities performed by the risk team and the frontline. He worked closely with various stakeholders, contributing to the development of the BRD (Business Rule Document), through documenting key business rules and trigger points. He made sure the data was complete, consistent and accurate to ensure smooth transition. Developed & maintained excellent relationships with stakeholders in order to ensure positive working interactions at all times and achievement of goals.Designing key controls - John built and implemented 4 end-to-end controls for the broader team across the bank. He wrote and executed SQL queries to fetch data from different database, working with the business to capture requirements and streamlined the process into batch. The controls have contributed to decrease potential risks across the bank and sharpen internal controls.

Management Consultant

• Aug 2017 - Aug 2019

- Data ReconciliationWorking with a large investment bank, John has created an automated ETL process to reconcile source and target data. The process involved, data mapping, analysis and creating reports via SQL/Power BI to provide interactive visualisation which increased the business intelligence capabilities by 30%. John worked closely with SMEs to understand the business and the business rules for data transformation as well as the scope of data to be migrated.- Data MigrationWorking with one of the top Australian universities, John has migrated financial data from LegacySystem to Workday Platform via Clover ETL. This involved creating an automated ETL process to generate templates to load the data, creating validation checks and generating necessary reports for reporting and reconciliation purposes. He has also tested and configured the prototype tenant with functionality that was presented to the target SMEs.- Data Conversion Working with a large bank, John created a data conversion for Workday HCM projects. Working closely with client's data team to prepare data and load into the Workday cloud using iLoads. He also, reverse engineered legacy systems to create legacy data dictionary for migration analysis and mapping to target.- Vendor Selection RFPWorking with a large sovereign wealth fund, John has created and assisted various documents involving the identification of suitable vendors, RFP, Requirements matrix and evaluation framework to assess suitability. He was also responsible for liaising with clients to communicate proposed actions and decisions made.

Finance Trainee

• Nov 2013 - Feb 2014

John was proactive in sorting and checking all invoices for incorrect postings and direct billing charges, receiving daily payments, reconciling and applying to correct account through cash payment, processing and maintaining debtor’s accounts to ensure that invoices are forwarded in a timely manner. Additionally, John performed answering queries in a prompt and efficient manner, preparing all necessary reports to assist month end procedures, and other responsibilities including a variety of tasks aimed at assisting the department in providing accurate financial information to management.