Jiajun Lu Email & Phone Number

Auckland, NZ

-Producing adhoc reports and data analysis to various business departments for decision making. -Supporting the Workday implementation with data extraction. -Designing test cases and methodologies for integration testing. -Interpreting payroll and business requirements and translate them into system requirements and configurations. -Led implementation of.

Auckland, New Zealand

-Supported the People Experience Transformation project by preparing data for migration to a new payroll system. -Built complex SQL queries and created reports to provide data summaries for analysis or decision-making. -Worked with software vendors on data models and extracts, methodologies, and mapping. -Set up payroll monitoring, alerting report.

Auckland, New Zealand

-Translated remediation requirements into modelling solutions. -Designed, built, and reviewed large payroll remediation models impacting over 150,000 employees using analytical and technical tools including Excel, SQL, and Alteryx. -Developed test plans, executed, and analysed tests, and documented results. -Communicated regularly with stakeholders.

Auckland, New Zealand

-Helped clients with payroll transaction calculations in DataPay. -Gathered client's requirements to build adhoc reports. -Assisted clients with reconciliations and come up with solutions if needed. -Documented system issues that clients encountered for the dev team to resolve. -Communicated with clients about changes in legislation to help mitigate risks.