Data Analyst Aws

PIYUSH SUDHANSHU DWIVEDI

adle65@r.postjobfree.com 1-862-***-**** linkedin.com/in/piyush-dwivedi-/

EDUCATION:

MASTER OF SCIENCE, ENGINEERING MANAGEMENT Expected May 2021 Stevens Institute of Technology, Hoboken, NJ GPA: 3.85/4.00 Related Courses: Informatics for Engineering Management, Decision Making Via Data Analysis, Data Science and Knowledge Discovery Graduate Certificate: Specialization in Data Exploration and Visualization for Risk and Decision-Making BACHELOR OF ENGINEERING, INFORMATION TECHNOLOGY Jun 2019 Ramrao Adik Institute of Technology, Navi Mumbai, India Related Courses: Big Data Analytics, Software Project Management, Computer Networks and Operating systems, DBMS TECHNICAL SKILLS:

Programming Languages: Java, Python, C++, R, Hive

Technologies: SciPy, NumPy, TensorFlow, MySQL, AWS, SAS Databases: AWS DynamoDB, Amazon Aurora, AWS RDS, AWS ElastiCache, AWS Redshift Tools: Tableau, SQL, Advanced Excel, SAP, MS Office 365, RapidMiner, Rattle, MATLAB WORK EXPERIENCE:

Data Analyst, Web Engage Apr 2018 - Aug 2018

• Built customer segmentation framework applying K-means clustering algorithm in python to group customers based on recent activities and behavior. The framework helped increase conversion rate by 22%

• Devised marketing strategies for improving user engagement and revenue for every customer segment

• Gained hands-on experience with OLAP operations while performing comparative qualitative analysis

• Performed channel analysis for understanding engagement pattern of users and optimizing channel mix in order to get best engagement for each channel

• Wrote SQL procedures and queries to integrate data from cross-functional APIs and data extraction for further analysis Customer Service Representative, Paddle Point BPO Services Dec 2017 - Mar 2018

• Found and negotiated with new consumers to sell products and services through referrals, networking, and cold calling

• Contacted approximately 500 individuals per day including 200 potential customers bringing about 15 to 20 leads in a single day, while ensuring the continuation and enhancements of services

• Answered 10 to 15 product and service-related questions daily, suggested information about other products and services and listened to customer complaints or concerns and resolved their issues ACADEMIC PROJECTS:

Data Analysis and Exploration on NYC Airbnb using Python Aug 2021 - Dec 2021

• Performed CRISP-DM Analysis of the NYC Airbnb dataset with 49,000 observations and calculated the top Host with 327 listings

• Plotted graphs utilizing generated results to help hosts understand on how to attract more customers, improve sales and find popular regions and analyzed boroughs and neighborhood listings densities and established most reviewed listings

• Performed Linear regression, Logistic regression and Random forest regressor to evaluate best Hosts in NYC

• Made a qualitative and statistical comparison of models to find the best suited model Data Exploration on COVID-19 pandemic: Safety and Healthcare facilities Jan 2020 - May 2020

• Plotted graphs related to Coronavirus symptoms and its influence in different countries using R

• Developed Tableau dashboards which source data from AWS S3, fulfilling the gathered requirements

• Performed analysis on detection of Coronavirus patients and measures to reduce human interaction Analysis on American Companies Aug 2019 - Dec 2019

• Cleaned dataset of thousands of companies’ balance sheets

• Compared companies’ portfolios and performances to evaluate top and worst 10 companies of each category

• Led Tableau for generating charts and dashboards to get deeper understanding of data

• Developed numerical analysis to grade and rank companies according to margin score, debt score and cash flow count Smart garbage monitoring system July 2018 - May 2019

• Designed and implemented, in a team of 4, IoT based Smart garbage monitoring system aims to keep a city clean by utilizing advanced techniques to automate waste management

• Attached proximity sensors to measure depth of dust bin and Wi-fi module, Router, LCD screen to navigate garbage truck

• Languages and Databases: Embedded C, HTML, Angular JS, Bootstrap, AWS DynamoDB CERTIFICATIONS:

• AWS Certified Solutions Architect-Professional (Jan 2021–Jan 2024), AWS Certified Solutions Architect-Associate (Sept 2020 – Sept 2023), AWS Certified Cloud Practitioner (Jan 2020 – Jan 2023), Certified Tableau Analyst, Udemy Complete Data Science Bootcamp Course (No expiration)

Contact this candidate