Summary
Overview
Work History
Education
Skills
Favourite Tasks
Client Testimonials
Timeline
Generic

Harpreet Kaur

Patiala

Summary

I hold a master’s degree in Computer Science with more than 3.5 years of IT experience in data engineering, migration, BI report development and ERP systems like NetSuite. Proficient in SQL, PL/SQL, ETL tools (Kettle, SSIS), and databases like PostgreSQL, Oracle, and Redshift. I specialize in designing efficient data pipelines, automating testing, and generating insights using BI tools like Tableau.

My experience includes working with NetSuite to streamline business processes, integrate data seamlessly, and customize workflows to meet organizational needs. I excel in optimizing database strategies, analyzing business logic, and delivering robust support across development, QA, and production environments, ensuring seamless collaboration and high-quality outcomes.

Overview

4
4
years of professional experience

Work History

Data Analyst/Data Engineer

Customer Information System
08.2024 - 12.2025
  • In this project, I worked as a Data Analyst/Data Engineer on a data migration initiative for a printing company transitioning to NetSuite
  • My main responsibility was to facilitate the seamless transfer of critical business data from various formats (CSV and XLSX) into NetSuite's ERP system
  • This involved data extraction, transformation, and loading (ETL), ensuring accurate data mapping and migration from the client's existing files to NetSuite’s database
  • I also worked on optimizing workflows and ensuring that all data was clean, structured, and ready for use in NetSuite
  • Extracted data from various file formats (CSV, XLSX) provided by the client and Led the migration of the data into NetSuite, ensuring all entries were correctly mapped to the corresponding fields within the system
  • Utilized Excel’s lookup functions (VLOOKUP, INDEX-MATCH, etc.) to clean and validate large datasets before migration
  • Ensured that data from different sheets was properly matched and verified, reducing errors during the migration process
  • Conducted extensive data validation checks to ensure the integrity and accuracy of migrated data
  • Worked closely with the client's IT team to address any discrepancies and improve data quality
  • Managed and organized large datasets in NetSuite’s system post-migration
  • Ensured that all records were correctly stored and accessible for business processes in the client’s printing company
  • Developed scripts and automated processes to streamline the import of new data into NetSuite on an ongoing basis
  • Improved efficiency and reduced manual efforts by setting up automation pipelines for recurring data loads
  • Worked with cross-functional teams (such as business analysts, IT, and project managers) to define data requirements and align the migration plan
  • Provided regular updates and status reports on data migration progress, highlighting challenges and solutions implemented
  • Identified and resolved data discrepancies and issues during the migration process
  • Provided support and training to client staff to ensure a smooth transition to the new NetSuite system

Data Engineer

Student Information System
06.2023 - 07.2024
  • The project revolves around the implementation of a university’s student record management, specifically focusing on the transition of data from an unstructured database (Unify) to PostgreSQL (RDBMS)
  • The objective includes data cleansing, transformation and validation utilizing a blend of manual procedures and automated processes via Pentaho Kettle and PL/SQL scripts
  • Engaging in requirement gathering sessions with subject matter experts (SMEs) to comprehensively grasp business rules and validation criteria
  • Analyze data from the source database (Unify) to manage data mapping to the target database (PostgreSQL)
  • Actively participating in technical design sessions and contributing to various phases of the data migration release plan
  • Developing intricate transformations and data mapping techniques (utilizing SQL & ETL) from the source to the target database
  • Creating automated frameworks for maintaining data quality, ensuring data cleanliness, and enhancing data enrichment
  • Optimize SQL performance to improve the productivity of existing scripts, utilizing tools such as execution plans, tracing, indexing, and tuning techniques
  • Writing Functions, triggers and queries for implementing business logic at the backend using PostgreSQL
  • Create and maintain data pipelines and integration processes between source and target

Data Engineer

Hospital Information System
08.2021 - 12.2022
  • This project revolves around ensuring the accuracy and reliability of data within a Hospital Information System (HIS) through development and validation processes
  • Leveraging Oracle/MySQL databases, the project aims to uphold data integrity across various modules within the HIS, such as patient records, medical procedures, and inventory management
  • Build database complex Stored Procedure and Functions to meet business requirements and data workflows
  • Designed and developed aggregation scripts for reporting
  • Design and optimize data models and schemas to support efficient data storage, retrieval, and analysis, ensuring scalability and performance
  • Utilize advanced SQL techniques, including complex and dynamic SQL scripts to design and implement robust solutions
  • Performed database import and export on dev and stage environment
  • Employ advanced data profiling techniques to identify anomalies, duplicates, and data quality issues within the hospital's datasets
  • Proactively identify and resolve any data-related issues encountered during data validation

Data Analyst

Banking Analytics
01.2023 - 06.2023
  • The Banking Analytics Project is dedicated to enhancing the accuracy, reliability, and effectiveness of tableau reports within the banking system
  • This involves developing and optimizing BI Reports and analyses in tableau dashboards to support informed decision-making and strategic planning within the banking domain
  • Involved in business requirements meetings to gather business KPI's and requirement document
  • Transformed complex business logic into database design and maintaining it by using SQL objects like stored procedures, user defined functions, views and triggers
  • Involved in creating complex dashboards on tableau and performed advanced analytics to analyze data
  • Extensively used the concepts of aggregation, blending, parameters, hierarchies, charts, filters, table calculations, trend Lines and calculated measures
  • Development and deployments of dashboards to tableau server
  • Testing and validating the generated reports in collaboration with the users

Education

M.Tech -

Punjabi University
11-2016

B.Tech -

Punjabi University
06-2014

Class XII (CBSE) - Science

K.V. NO.2, PATIALA
01-2010

Skills

Programming Languages

  • SQL
  • PL/SQL
  • TSQL
  • Python

ETL Tools

  • Pentho Kettle
  • SSIS

Business Intelligence Tool

  • Tableau
  • Power BI
  • SSRS

Database

  • PostgreSQL
  • MS SQL Server
  • MySQL
  • Oracle

Sprint Management Tool

  • Jira
  • Taiga

Operating System

  • Windows XP Vista, 7, 8, 10

Version Control Systems

  • SVN
  • GIT

Data Quality

  • Talend Data Quality & TOAD suite


Database Tool

  • SQL Developer
  • SSMS
  • DBeaver

Favourite Tasks

  • Delivered critical root cause analysis on many production issues.
  • Automated repetitive tasks to get the best performance.

Client Testimonials

  • Client appreciated for meeting the deadlines with the quality of work.
  • Owns assigned tasks from start to finish, exhibiting dedication and accountability to ensure successful completion.

Timeline

Data Analyst/Data Engineer

Customer Information System
08.2024 - 12.2025

Data Engineer

Student Information System
06.2023 - 07.2024

Data Analyst

Banking Analytics
01.2023 - 06.2023

Data Engineer

Hospital Information System
08.2021 - 12.2022

M.Tech -

Punjabi University

B.Tech -

Punjabi University

Class XII (CBSE) - Science

K.V. NO.2, PATIALA

Similar Profiles

CREATE PROFILE
Harpreet Kaur