Software Engineer & Data Science| SQL, Analytics, and AI Solutions

Nuwan Hettiarachchi

About Me

businessconsultant@divi.com

(255) 352-6259

I bring strong experience in data analytics and data engineering, with a focus on SQL-driven data preparation, data quality, and scalable processing pipelines. My background includes working with large, complex datasets, supporting business intelligence, and applying data governance principles such as profiling, lineage, and documentation. I am known for collaborating effectively across teams to design clear, reliable data solutions that support informed decision-making.

Work Experience

2018 - Present

Data Analyst / Programmer

Hemlock Connect (Hemlock Group)

  • Designed, maintained, and enhanced large‑scale data processing pipelines for demographic and address‑based datasets thousands of belonging to large and medium scale clients
  • Performed advanced data cleaning, validation, and transformation to improve data quality and usability
  • Built automated summaries, reports, and distribution workflows
  • Documented end‑to‑end processes and introduced efficiency and accuracy improvements
  • Collaborated with stakeholders to test, deploy, and refine new features
  • ERP System – Veracore, PrintVis, Docket System, In house Database Application Development and maintainance

2011 - 2018

Data Analyst

Kirk Integrated Marketing Services

  • Analyzed and processed demographic datasets including names and address data

  • Delivered cleaned datasets, analytical summaries, and operational reports

  • Improved existing processing workflows through documentation and redesign

  • Supported distribution and reporting operations with a focus on reliability and accuracy

2010 - 2011

Web Developer

HSBC Bank – Global Publishing Services

  • Customized Voltage SecureMail branding for HSBC

  • Developed Phase‑I Hong Kong Exchange Traded Funds website with AJAX‑driven dynamic content

  • Implemented multilingual content toggling under SiaB CMS

  • Built and customized jQuery‑based widgets for the Global Fund Center project

2009 - 2010

Business Development Research Manager

ORB Systems

  • Conducted client meetings and business analysis to translate requirements into software solutions

  • Mapped customer needs to enterprise systems including Accounting, Payroll, Inventory, and HRM

  • Produced UML‑based documentation to guide development teams

2003 - 2009

Team Leader Programmer

ATP Asia, Sri Lanka

  • Led development teams through task allocation, monitoring, and daily reporting

  • Trained staff and authored system configuration and operational documentation

  • Implemented quality controls and statistical performance reporting

  • Designed and maintained an internal job‑tracking system

1999 - 2003

Software Engineer

DPMCE Motor Company / TSG / Next2nd Solutions

  • Developed a 360‑degree feedback system for HRM aligned with Swedish and Norwegian standards

  • Built a rich HTML editor for the DigiMaker Content Management System

  • Worked with VB, ActiveX, COM, and Java technologies

Education

2023 - 2025

Associate Data Scientist in Python (2024-205)
Data Scientist in Python (2022-2025)
Data Analyst in Power BI (2025-Current)
SQL Server Developer (2025-Current)

DataCamp

  • Python programming for data analytics, data science, and data engineering workflows

  • Data ingestion, preparation, transformation, and analysis using Pandas and NumPy

  • Data cleaning, validation, standardization, and data quality management techniques

  • Exploratory Data Analysis (EDA) to support business intelligence and decision-support

  • Statistical analysis concepts for trend analysis, hypothesis testing, and insight generation

  • Feature engineering and dataset preparation for analytical and predictive use cases

  • Data visualization and reporting using Matplotlib and Seaborn

  • Working with large, structured datasets and applying data profiling techniques

  • Implementation of data consistency checks, error handling, and reproducible workflows

  • Documentation of analytical logic, assumptions, and data definitions to support governance

  • Introduction to machine learning concepts and model evaluation (supervised learning)

  • Ethical data usage, responsible analytics practices, and governance-aligned workflows

2000 - 2002

Bachelor of Science – Computer & Information Systems (First Class Honours)

NCC (UK) & London Guildhall University

  • Computer information systems architecture and enterprise application design

  • Database design, relational data modeling, normalization, and SQL fundamentals

  • Systems analysis and design using structured and object-oriented methodologies

  • Software development principles across desktop and web-based applications

  • Data structures, algorithms, and logical problem-solving techniques

  • Information systems security concepts and access control fundamentals

  • Systems documentation, requirements analysis, and technical specification writing

  • Data integrity, validation, and consistency principles supporting data quality

  • Introduction to network fundamentals and distributed systems concepts

  • Applied project work emphasizing structured development, testing, and maintainability

2000 - 2001

International Advanced Diploma in Computer‑Based Information Systems (Distinction)

NCC (UK) & London Guildhall University

  • Fundamentals of computer-based information systems and business applications

  • Relational database concepts, data structures, and SQL fundamentals

  • Systems analysis and requirements gathering for business solutions

  • Data entry validation, accuracy controls, and consistency checking

  • Application development concepts for desktop and information systems

  • Information systems documentation and structured process design

  • Introduction to data security, access controls, and system integrity

  • Problem-solving using logical, analytical, and structured methodologies

  • Practical project work applying standards, documentation, and testing

1998 - 2000

Diploma in Computer Systems Design (Distinction)

National Institute of Business Management, Sri Lanka

  • Fundamentals of computer systems design and structured programming concepts

  • Introduction to database systems, data structures, and data organization principles (Clipper, DBase, SQL Server)

  • Human resource management system (Capstone project – 360 Degree Appraisals system)
  • Systems analysis and logical design for business and technical requirements

  • Application development fundamentals and software lifecycle concepts

  • Data validation, integrity, and accuracy controls in system design

  • Technical documentation, flowcharts, and structured process modeling

  • Problem-solving using analytical and algorithmic approaches

  • Introduction to operating systems and basic networking concepts

  • Applied project work emphasizing structured design, testing, and reliability

Skills & Expertise

System Analysis, Design & Project Management

Led systems analysis and logical design for enterprise and operational software solutions

Designed and supported 360-degree appraisal systems for Human Resource Management

Developed and maintained inventory management systems for aircraft parts and motor company operations

Operational Process Design & Optimization

Designed quantity confirmation and reconciliation processes to improve accuracy and traceability

Developed distribution and kitting systems including package collating and multi-carrier shipping workflows

Documented end-to-end processes to support scalability, auditability, and operational efficiency

Data Analysis & Analytics

Performed advanced data analysis using SQL, Python, MS Access, Excel, and Power BI

Automated data processing and reporting using VB, VBA, and Python-based workflows

Leveraged AI tools and ChatGPT to enhance data exploration, documentation, and productivity

AI & Computer Science Applications

Designed fuzzy comparison algorithms for demographic data matching and deduplication

Built store name variation matching and reconciliation systems to improve data consistency

Applied analytical and algorithmic approaches to resolve complex real-world data quality challenges

ERP & Content Management Systems

Supported and integrated ERP platforms including VeraCore and PrintVis

Worked with structured data flows between ERP systems and operational applications

Ensured data accuracy, consistency, and documentation across enterprise platforms

Web Technologies (HTML & CSS)

Member of HSBC Bank website backend maintenance team, supporting enterprise web platforms

Maintained and updated HTML and CSS-based content within governed CMS environments

Supported structured content updates aligned with security and organizational standards

Package Distribution & Logistics Systems

Implemented and supported ProShip and ProShip Loader for enterprise shipping workflows

Applied data governance principles in customs documentation and border clearance processes

Ensured compliant, auditable data movement across logistics and distribution systems

Marketing & Desktop Publishing

Designed variable-data, customized print materials driven by structured datasets

Developed InDesign-based page layouts integrated with data-driven publishing workflows

Supported marketing operations through accurate data mapping and layout automation

Technology Stacks

Data & Analytics: Python, Pandas, Matplotlib, Seaborn, FuzzyWuzzy, SQL

Databases: Microsoft SQL Server, Oracle, PostgreSQL

Programming & Automation: VB, VBA, ActiveX, COM, Crystal Reports

Web & Content Technologies: Java, JavaScript, HTML, CSS, jQuery, WordPress

Certifications and Achievements

Life Long Learner

I am a life long learner. With lot of self studies and following available resources I am keeping my knowledge updated constantly. For a detailed description of Certifications and Achievements, follow this link to achievements page.

Products I’ve Worked With

Phone

(604) 256-2432

Surrey BC, Canada

Copyright © 2026 Nuwan Hettiarachchi