MAYANK, DATA ENGINEER | Bench Resource on Contract

MAYANK (RID : pp3lnm4z1og)

DATA ENGINEER

Location : Pune, India

Experience : 5 Year

Rate: $16 / Hourly

Availability : Immediate

Work From : Offsite

Category : Information Technology & Services

Shortlisted : 1

Total Views : 66

Key Skills

Data Engineer ETL Data Migration AWS S3 Power BI GCP Python MongoDB MySQL

Discription

MAYANK

OBJECTIVE

To work for an organization which provides me the opportunity to improve my skills and knowledge to growth along with the organization objective.

EDUCATION

Bachelor of Engineering in Computer Science and Engineering

Rajasthan Technical University, Rajasthan.

2014-2018

CGPA: 7.12/10.00

Class 12th

2013-2014

CBSE Board, Percentage: 72.20%

Class X

CBSE Board, CGPA: 9.6/10.00

2011-2012

EXPERIENCE

Confidential (Data Engineer) (Nov’22-Mar’23)

Build end to end data pipeline using Google Cloud Platform. Sync all the tables from production (Elastic Search) to Big query. Set up data warehouse and create data models by using various schemas. Cater all the Ad-hoc request related to data and also build dashboards using Apache Kibana. Write complex stored procedures and functions in order to maintain consistency in the Oracle DB. Use python scripts in order to generate monthly and weekly reports for the investors. Worked on AWS, Big query, Docker, AWS S3, AWS Lambda

Tech Stack – Big Query, AWS, Oracle DB, Elastic Search, Kibana, MongoDB, Rancher

Confidential (Data Engineer) (Jun’22-Oct’22)

Developed End-to-End ETL pipeline which is used for designing the crop dashboard using GCP Big query.

Roles & Responsibilities- Write python scripts for ETL pipeline as well as designing api’s for Crop Dashboard deployed Google Compute Engine (GCE).

Perform Data Migration of (last 1 Year data) into GCP Bigquery using the custom built ETL pipeline which loads the data from various sources into required Bigquery tables and also handles the incremental loading.

Tools Used: GCP, Python, Flask, Postgresql, AWS S3, Power BI

Confidential (AI & Data Engineer) (Feb’21-May’22)

Implementation of Recommendation Engine on the whole platform for post curation.

Roles & Responsibilities- Automating the whole notification process of the platform along with the report generation on daily basis using python script.

Implemented Recommender System on the Updates A-Z page in order to increase the customer retention ratio on the platform. Building End-to-End ETL pipeline for analyzing the large data on AWS.

Tools Used: Python, MongoDB, MySQL, AWS Lambda, Glue, S3, RDS, Athena, Power BI, Sagemaker.

Confidential (Senior Data Analyst) (Jun’18-Jan’21)

Market Pulse :

It’s a stationary company based out of Canada their database contains huge data so report rendering time would be more in PowerBI.

Roles & Responsibilities- Converted data into actionable insights by predicting and modelling future outcomes.

Tools Used: PowerBI, MySQL, Power Query

Vancouver Parking Tickets :

It’s a Canadian based government project in this we need to figure out based on historical population data whether that particular area need Parking space or not.

Roles & Responsibilities- Performed complete ETL to fetch data from various data sources clean the data and load the data into AWS Athena and later used that data in PowerBI for finding meaningful insights for theData Scientists.

Tools Used: Python, Seaborn, Matplotlib, PowerBI, MySQL, AWS Athena.

INTERNSHIPS/CONTRACTUAL

Confidential , Data Analyst Intern (Oct 2020 – Nov 2020)

Confidential , Data Analyst (Jan 2019 – Feb 2019)

TECHNICAL SKILLS

Programming Languages Java, Python

Tools and Platforms Git, Windows, Linux, Visual Studio , Pycharm, Jupyter Notebook,

Database Systems NoSQL, MySql, Postgres SQL

Statistical Libraries Matplotlib, Numpy, Scikit-learn, Pandas

Deep Learning Libraries Tensor flow, Keras

Cloud AWS (Athena, Redshift, Glue, S3, Lambda), GCP (Cloud Storage, Bigquery, GCE)

Relevant Courses Algorithms, Data Structures, Operating Systems