Post Job Free

Resume

Sign in

Data Analyst, SQL, Python, MYSQL, Tableau, R, Excel

Location:
Delhi, India
Salary:
500000
Posted:
November 21, 2020

Contact this candidate

Resume:

Aayush Gupta adh0wk@r.postjobfree.com

+91-807*******

github.com/ag-ayush32

EDUCATION

Bachelor of Technology

Indian Institute of Technology Jammu

**/**** - **/****,

CGPA: 7.56

WORK EXPERIENCE

Sr. Associate Manager

Delhivery Pvt. Ltd.

08/2020,

Process and engineering department. Responsible for consulting and optimizing complete inventory

processes from inbound to outbound as per the

requirements of the client.

Bringing new ideas and features in Delhivery's

Warehouse management system (Godaam) to facilitate the desired workflow as per the client's needs and

provide end to end solution.

Startup-

Head On Solutions Pvt. Ltd.

Tech startup in sanitary ware sector.

Filled

Invented and designed automated sanitizing toilet seat system and build B2B model for the same.

Tasks involved product and business development.

Marketing Research Intern

RAAM GROUP

Hyderabad based automotive dealership company

Used market research analysis to improve Honda's

competitive advantage.

Analysing trends in automotive market.

Built automotive price models for different brands

based on technical parameters.

CFD Intern

Entuple Technologies Pvt. Ltd.

Design and Analysis Solutions for Aerospace, Defence and Business Carried out Fluent simulations covering different

aspects of internal flow and heat transfer.

Two way and one way Fluid-Structure interaction of submarine mast(DRDO project).

SKILLS

Python Tableau

SQL Machine Learning

Statistics MS Excel

VBA Data Analyst

PERSONAL PROJECTS

Loan Investment Strategy for Lending Club Investors

(CAPSTONE)

Exploratory Data Analysis of loans disbursed by Lending Club from 2007-2011 using CRISP-DM model with 50+ variables. Modeled loan investment strategy by increasing repaid precision using random forest and logistic regression and xgboost. Constructed portfolio for maximizing annual returns. Customer Complaint Analysis

Analyzed and ML modeling done for predicting which type of complaints are solved the most by the firm to improve the client's customer services.

Used text mining techniques for qualitative and quantitative analysis of the text with respect to the status of complaint. ML models used xgboost, decision tree, svm, gaussianNB and compared performance of each.

Marketing and Promotional Strategy

Used EDA to develop insight about different product sales distribution region wise and performance of sales reps for a hypothetical store.

Analyzed Seasonality and Trend of the products and devised a marketing strategy. Forecast using ARIMA and PROPHET. Designing and manufacturing Advance Dusty Plasma

Setup(B. TECH Project)

Designed & Fabricated Stainless Steel 304 plasma chamber for plasma physics analysis for plasma experiments in lab. Key features- high vacuum compatible(10^-8 bar), ergonomic & robust design.

reduction :from 4 lac to

POSITION OF RESPONSIBILITY

Former SPIC MACAY IIT JAMMU Event Head

-Organized first chapter of SPIC MACAY Event at IIT Jammu, invited renowned vocalist Mrs Kalapini Komakalli

DIVYA JYOTI JAGRATI SANSTHAN-NGO

Under the mentorship of, volunteered in workshops on social issues like BODH(Drug abuse rehabilitation program), MANTHAN(Holistic education program for children ).

MUSIC SOCIETY HEAD(2017-18)

Responsible for maintaining the society and organizing inter and intra university musical events.Won 3rd prize in SMVDU Inter college Music contest.

ACHIEVEMENTS & CERTIFICATES

IIT BOMBAY TECH FEST CASE STUDY - secured 9 th rank. Mathelogix- 1st Position in Intra-school math contest. Resurgence- 3rd position in inter-college music contest Data Analytics Course- certified by 365 Careers

Department: Mechanical Engineer

Achievements/Tasks

Achievements/Tasks

Achievements/Tasks

Achievements/Tasks



Contact this candidate