Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Projects
Languages
Timeline
Generic

ANKIT ROY

Summary

I am a dedicated and resourceful Data Enthusiast with a strong foundation in electrical engineering and data analysis. With experience in optimizing data pipelines, maintaining database integrity, and utilizing analytical tools like Python and SQL, I effectively transform complex datasets into actionable insights. My passion for technology drives me to continuously improve and contribute to data-driven solutions.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Data Engineer Intern

MADETOUR EASY
NEW DELHI
10.2022 - 11.2022
  • Company Overview: Data engineering company focused on optimizing data processes
  • Assisted in designing and implementing optimized data pipelines for efficient data flow into a central database
  • Supported maintenance and optimization of relational databases to ensure data integrity and accessibility
  • Wrote complex SQL queries for data retrieval and manipulation for analysis
  • Collaborated with cross-functional teams to troubleshoot data-related issues and develop data-driven solutions
  • Documented processes and workflows, creating a knowledge base for future reference
  • Provided detailed reports to senior management with key insights and recommendations
  • Data engineering company focused on optimizing data processes

Freelance Data Analyst

Freelance
Remote
03.2019 - 12.2021
  • Company Overview: Independent data analysis services
  • Gathered and cleaned large datasets from various sources, ensuring data accuracy, completeness, and consistency
  • Applied data cleaning techniques to remove inconsistencies and errors
  • Analyzed complex datasets using Python (Pandas, NumPy) and SQL to extract insights
  • Developed visual reports and dashboards in Tableau to present data trends and patterns
  • Collaborated with clients to understand their business needs and provide actionable insights
  • Delivered regular updates and reports to keep clients informed and aligned with project goals
  • Managed multiple projects simultaneously, meeting deadlines and ensuring high-quality results
  • Utilized project management tools to track progress and ensure timely task completion
  • Independent data analysis services

Education

Bachelor of Technology - Electrical Engineering

DR B C ROY ENGINEERING COLLEGE
Asansol, West Bengal
08.2016

Skills

  • Data integrity
  • DBMS
  • Electrical Engineering
  • Microsoft Access
  • Numpy
  • Pandas
  • Linux
  • PLSQL
  • Project Management Tools
  • Python
  • Relational databases
  • SQL
  • Tableau

Certification

  • Data Scientist Certification ,CODING NINJAS
  • LINUX Certification,UDEMY
  • SQL Certification,CODING NINJAS
  • PLSQL Certification UDEMY

Accomplishments

  • Secured 2nd place in the Robotryst regional competition, IIT Delhi 2015, with a unique idea on UAVs, leading a team successfully.
  • Cleared the Graduate Aptitude Test in Engineering (GATE 2021), proud to be in the top 7% of electrical engineers

Projects

Electrical Engineering Project,

01/01/16 - 06/30/16

Academic project focused on railway communication systems. Implementation of ACD and Optical Fiber communication in Indian Railways.

Damodar Valley Corporation Project,2015

 Project detailing workflows in hydro power generation. Reports on the workflow of the first underground hydel power generation station in Southeast Asia

Languages

Hindi
First Language
English
Proficient (C2)
C2

Timeline

Data Engineer Intern

MADETOUR EASY
10.2022 - 11.2022

Freelance Data Analyst

Freelance
03.2019 - 12.2021

Bachelor of Technology - Electrical Engineering

DR B C ROY ENGINEERING COLLEGE

Similar Profiles

CREATE PROFILE
ANKIT ROY