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

Programming Environment             Vim

 

 

EXTRA CURRICULAR ACTIVITIES

 

 

 

Certified Data Scientist from One Fourth Labs (incubated by IIT Madras Research Park).

Certified  Data Science Expert from IIT Jodhpur.

Won bronze medal in Kaggle.

Hack to ber fest (presented by Digital Ocean) 2020 Swag Winner for contributing in Open Source Community.

Advanced  Google Analytics Certification.

Once recommended by the Naval Selection Board (Visakhapatnam) as Commissioned Officer (Indian Navy).

Got  All India rank 3242 in IIT JEE 2014.