Sofia Ng Email & Phone Number

Richmond, NZ

Richmond, Tasman, New Zealand

Dunedin, Otago, New Zealand

Dunedin, Otago, New Zealand

Otago & Southland, New Zealand

As the BI lead, I am responsible for turning the mass of data we have at the port into information that can be used to optimize performance, lower safety incidents, and increase profitability.When I started in the role there was no Business Intelligence environment and the company was very early in the stages of understanding the data they had. As it was a.

Nelson, Marlborough & Tasman, New Zealand

As the manager of the DB & BI team I am responsible for ensuring industry standards are followed across our internal SQL Servers as well as a number of other core functions.* Report Design and Development (SQL Server Reporting Services (SSRS), Excel and Qlik Sense)* SQL Development (internally developed database design and consulting)* Data transformation.

Nelson, Marlborough & Tasman, New Zealand

Nelson, Marlborough & Tasman, New Zealand

As the founding member of the Performance Tuning team, I set up the methodology and process for locating bottlenecks to performance. Worked closely with external clients in maintaining their databases, setting up and maintaining Disaster Recovery as well as improving performance.Working closely with clients to understand their requirements with regards to.

Wellington & Wairarapa, New Zealand

• As a part of the Analytics Team at Trade Me
• Web Analysis using Google Analytics, Flurry, Splunk and Nielsen
• Adhoc reporting across a range of business units; motors, jobs, marketplace and Holiday Houses
• Working closely with the Finance team in improving the month end reporting
• Building SSRS reports
• Working closely with business departments in order to build close relationships and understand requirements

First NZ Capital

In my capacity of Production Support, I have responsibility for ensuring that all First NZ Capital Production Systems are operational, and to resolve any production issues as they arise. This includes trouble-shooting, development of resolutions as required and relationship management of our key stakeholders and the users of our systems.I am also tasked.

Wellington

• Key responsibilities included:
• Management of all databases associated with Microsoft Licencing. This includes databases for most Microsoft subsidiaries around the world.
• Creation of reporting services reports when required and bug fixing, development as required.
• Development of SQL queries, including joins, unions and temporary tables to facilitate data analysis.
• Provision of services to Microsoft internal clients for all queries related to licencing.
• Provision of services to internal clients at Accordo, related to licencing and data manipulation / reporting.

Wellington

• In the role of Technical Support Analyst I provided helpdesk services to law firms and surveyors who needed to perform title searches or who had other technical title related enquiries.Responsibilities included:
• Providing legal firms with technical support to enable them to complete land transfers, using the Land on Line application.
• Providing technical – login assistance where required.
• Advising law firms of the paperwork and other requirements to complete a land transfer.
• Providing technical land transfer advise, where required.

Hamilton

The workforce planning analyst role was responsible for forecasting resource / staffing requirements, helping senior management to optimise staff hiring on a one year rolling basis and helping to optimise service level management.