Harpin Ng

Data Analyst - SQL, VB Macro automation specialist

Technology / Internet

Sydney Olympic Park, Parramatta

Services provided

A data specialist with extensive expertise spanning the entire data lifecycle, including master data development and governance, reference data ingestion and quality control, data mining and cleansing, reporting and analytics, and process optimization through automation and streamlining.

Adaptable and resourceful, with a proven ability to quickly master new tasks and complete them with minimal supervision. Highly proficient in advanced Excel functions, VBA macro creation, Microsoft Access development, SQL scripting, Cognos, and Power BI, with a strong track record of delivering impactful automation solutions.

Demonstrates exceptional capability in root-cause investigation, troubleshooting, and implementing innovative strategies to achieve measurable business outcomes. Creative and innovative in designing and automating processes to enhance efficiency and accuracy. Experienced in developing dashboards, generating actionable insights, and executing ETL processes to ensure data accuracy, accessibility, and consistency.

Recognized for proactively identifying data anomalies, resolving complex challenges with root-cause fixes, and upholding high standards of data integrity and quality across all projects.

Analytics

Data specialist

Sql specialist

Data mining

Data governance

Automation specialist

Data analyst

Reporting

Approximate rate: AUD$ 50 per hour

Experience

I have extensive experience spanning multiple functions including benchmark and master data management, data stewardship, and quality assurance, with a proven ability to develop and maintain complex data systems across platforms such as Aladdin, JDE, Charles River, and various CRM systems. I have successfully set up benchmarks, onboarded market data and indexes, and supported ad hoc queries while continuously improving processes through detailed SOPs, audits, and data reconciliations using advanced tools like SQL, VBA, and MS Access. My background also includes creating compelling dashboards and reports with COGNOS, Power BI, and custom reporting tools to drive actionable insights, alongside providing end-to-end support in trade operations, administrative functions, and sales analysis. Additionally, I have contributed to business development, marketing initiatives, and inventory logistics, consistently enhancing operational efficiency and fostering a culture of informed decision-making.

Microsoft Excel: Expertise in building complex formulas, constructing pivot tables, linking multiple worksheets, and developing VBA macros to automate recurring tasks.
Microsoft Access: Skilled in designing and building databases with a thorough understanding of relational database management systems (RDBMS) and extensive experience in creating both standard and ad-hoc reports and templates.
Microsoft SQL Server: Proficient in writing scripts and queries for data mining, as well as extracting, managing, cleansing, and merging large datasets. Regularly develop views and stored procedures to support analytical reporting.
Data Management Tools: Extensive experience with Charles River, CADIS, Bloomberg terminal and API, Aladdin, Refinitiv, Oracle JDE MDM, Cognos, Power BI, StayInFront, and TouchCG (COMPASS) CRM.

Education

Graduated from Universitas Tarumanagara, Jakarta - Indonesia. Earned a Bachelor’s Degree in Economics (Honors) with a major in Business Management, completing a thesis in Financial Studies, and achieved a GPA of 3.2 on a 4.0 scale.