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
Products I’ve Worked With
Phone
(604) 256-2432
Surrey BC, Canada