Ankit Ranjan

I'm

About Me

About Me

👋 Hi, I'm Ankit Ranjan!
🚀 Certified Data Engineer | Software Engineer | Problem Solver
💡 Passionate about Big data, scalable systems, and analytics, I thrive on building robust architectures that power data-driven decisions.

  • Name: Ankit Ranjan
  • Website: ankitranjan.netlify.app
  • Phone: +91 6206731576
  • City: Mahua, Bihar, India
  • Age: 23
  • Degree: B.tech
  • Email: ranjanankit1313@gmail.com
  • Freelance: Available

A Highly motivated individual with in-depth knowledge of languages and development tools, seeking a position in a growth-oriented company where I can use my skills to the advantage of the company while having the scope to develop my own skills. I specialize in designing and optimizing data pipelines using ETL, ensuring seamless data flow for high-performance applications. With a strong foundation in algorithms and problem-solving, I craft efficient solutions for complex data challenges.

Leetcode

Databricks

Education

Education

My Education Details Till Now.

B.tech

B.tech

Amritsar College Of Engineering
& Technology , Amritsar

Batch - 2019 - 2023

C.G.P.A - 7.7

Sr. Secondary

St. Xavier's Jr./Sr. School
Muzaffarpur , Bihar

Board - CBSE

Batch - 2016 - 2018

Percentage - 73.2

Sr. Secondary

10 th

10 th

North Point Children's School
Muzaffarpur , Bihar

Board - ICSE

Batch - 2016

Percentage - 78.2

Skills

Skills

C 90%
C++ 95%
Python 95%
SQL 95%
Data Warehouse 95%
AWS 95%
REACT JS 80%
DATABRICKS 100%
Pyspark 90%
ETL 95%
Data Modelling 80%
Azure Data Factory 90%
AZURE 80%
REST API 75%
DSA 80%
My Experience

My Experience

Data Engineer

~ Freelancing

Duration : 09/2023 - present

● Successfully designed and delivered the SmartStream ETL Pipeline Project in Data Engineering domain using AWS.
● Optimized ETL pipelines in AWS Glue for orchestration, leveraging S3 to improve data performance and scalability.
●Transformed data using PySpark and Data Flow, applying Spark configurations for memory management.
●Enhanced big data processing efficiency by implementing bucketization and broadcast joins, achieving an approx 45% reduction in processing time while ensuring seamless data distribution and scalability.


● Technology: Databricks, Pyspark, SQL , AWS , ETL, Data Modelling

Data Engineer

~ R Systems International

Duration : 07/2023 - 08/2024

● Built execution flow of raw data through Lambda and Step Functions and monitored multiple services in AWS .
● Engineered and optimized an efficient ETL pipeline in Databricks Workflow, provides robust data processing.
●​Developed and optimized code in Databricks Workflow to enhance performance, improving job efficiency by 40%
and significantly reducing processing time from 7 hours to 1.5 hours.
●​Collaborated in Dimension Modelling, conducted RCA for pipeline failures, identified root causes and
implemented corrective measures, increasing pipeline accuracy by 35%, ensuring seamless and consistent data delivery.


● Technology: Databricks, Pyspark, SQL , AWS , ETL, Data Warehousing

Internship

Frontend Developer
~ Codencreative

Duration : 07/2022 - 09/2022

● Contributed to an E-Comm app for UI Part.
● Contributed to Convert Frontend Code into React Codebase.
● Dynamic UI Creation for Different Projects.

● Technology: Html, Css, Bootstrap , JavaScript , React Js

Training

Web - Technology
~ VMM Education

Project : E-medicare

06/2021 - 07/2021

● Online Website for Ordering Medicines.
Having CRUD Functionality for dynamic nature.

● Frontend: Html, Css, JavaScript, Bootstrap
● Backend: SQL, PHP

Chapter Lead

Codechef


Event Lead

08/2021 - 01/2022

Have Experience of Hosting More than 10 Coding Contest.

Projects

Projects

Projects Which i have Created Till Now in Different Tech stacks

MoviesX

A Responsive Website having Details of mainy Movies. Movies We Can Search Based On their Category.

F1 Racing

An F1 Racing Data transformation optimizing ETL with Azure Data Factory, Delta Lake, and Unity Catalog for secure, scalable storage and analysis.

IPL Data Analysis

The IPL Data Analysis project efficiently ingest, transform, and store cricket stats, enabling deep analysis across regions and roles.

Inshorts Clone

Inshorts Clone is a Web-App used for Rendring News with Different Category across the Globe & Video News is also Available.

MoviesX

A Responsive Website having Details of mainy Movies. Movies We Can Search Based On their Category.

Mausam

A Weather App which is totally Responsive that Shows Detailed Weather of Different Places across the World.

Achievements

Achievements

Databricks Certified Data Engineer Associate

Hackathon - AutoISV Innovation

Rank 3 in Hackathon.

Codekaze - Global Coding Competition

Rank 1 in College.

Techgig - Coding Competition

AIR - 317 from 10,000+ open coding Round Contest.

HackerRank

5* - Problem Solving , 5* - Cpp 650+ Points , 1700+ Points.

Codechef

3* - 1600+ Points
8th - Global Rank in CODE Gun Contest

CodeForces

949(Highest Rating)

GeeksforGeeks

1000+ Points in DSA.

800+ Question Solved on Different Websites.

Contact Me

Contact Me

You can Contact Me through these ways.

Social Profiles

Call Me

+91 6206731576