Default profile banner
NP

Nikhil Pal

@nikhilpal

Data Engineer

Hyderabad, India

MedTourEasyPunjab Technical University

Highly skilled Data Engineer with experience in ETL development, data wrangling, and advanced data analysis. Proficient in Python, SQL, SAS, and cloud platforms like GCP/BigQuery. Proven ability to analyze complex datasets, develop robust data models, and provide actionable insights to drive business improvement and support data-driven decision-making.

Experience

Data Analyst

MedTourEasy

•Jan 2021 - Jan 2021

Using SAS, Python, SQL Performed Data collection and preprocessing on appropriate data to prepare data necessary for analysis. Aggregating applicable data from all sources and devices, managing external data, programming in ETL stage, trend analysis, data review, data transfers, data validation. Maintained data integrity through diligent database design and development, eliminating error and risk. Applied analysis skills, leveraging insights, developing and deploying data models and evaluating and improving existing models to create solutions. Managed lifecycle elements of ETL development, from robust testing to final deployment. Key responsibilities: Used SQL, Python to Analyze complex healthcare data sets and create detailed reports for stakeholders. Provide analysis and recommendations to internal stakeholders in order to improve decision-making. Collaborate with cross-functional teams to identify opportunities for process improvement. Interpret data and provide insights into business performance and trends and maintain dashboards that provide insights into key business metrics.

Trainee Engineer

CDI

•Jan 2019 - Jan 2019

Data Engineer

Parexel International

Carried out regular penetration tests on ICT products to ensure systems stayed free from security threats and breaches. Built firewalls and encrypted data to secure confidential information from potential intrusion. Analysed security procedure violations and developed plans to reduce long-term damage and prevent recurrence.

Education

Punjab Technical University

Bachelors In Computer Science Engineering

Data Analytics, Statistical Programming, Data Visualization and validation, Data Preparation and Cleaning, Database Structure and Algorithm, Pattern Recognition, Prediction systems, Data warehousing,

Jan 2021

Licenses & Certifications

Google Data Analytics Professional Certified

Coursera

• No expiration

Tableau Certified

Coursera

• No expiration

Data Analyst & Data Scientist Certified

Datacamp

• No expiration

Skills

Python
SAS
C++
MySQL
PostgreSQL
MongoDB
Proc SQL
Unix
Linux
Shell Scripting
Putty
Git
Version Control
Tableau
Spreadsheet
Excel
Data visualization
Data Wrangling
Data Cleaning
Data Manipulation
GCP
Google BigQuery
Probability/statistics
ETL development
Agile methodology (Jira)