Prayas Pandey

443-***-**** adm2a3@r.postjobfree.com linkedin.com/in/prayas-pandey-0695/ github.com/ppandey0695 Summary

Proficient in Python, SQL, Tableau, Microsoft Power BI, Cognos Analytics dashboards with a graduate degree. Experienced in data preprocessing, data visualization and data modelling. Highly proficient in creating reports and providing business decisions.

Education

University Of Maryland Baltimore County Baltimore, MD Master of Science in Information Systems Expected May 2021 Bhilai Institute of Technology (BIT) Durg, India

Bachelor of Engineering in Mechanical Engineering Aug 2013 – May 2017 Experience

CAD Academy May 2017 – Dec 2018

Position: Design Engineer

• Worked on software’s such as AutoCAD, ANSYS14.0, Creo Parametric (Pro E) for 2D 3D drawings, done structural thermal analysis and given blueprints of various projects for Industries and drafted various machine parts on AutoCAD Creo for projects.

Projects

Trends in Black Friday Sales Analysis using Spark Python, Apache Spark Nov 2020 – Dec 2020

• Predicted the purchase of various products by users across categories given historic data of purchase amounts

• Optimized Linear Regression, Ridge Regression, and Lasso Regression, Decision Tree Regression, Random Forest Regression, Gradient Boost Regression using GridsearchCV to reach the best model. Evaluated these models using RMSE (Root Mean Squared Error) and applied hyperparameter accordingly Data Analyst Salary Estimator: Project Overview Python Jul 2020 – Aug 2020

• Scraped over 1000 job descriptions from Glassdoor using python and selenium, Engineered features from the text of each job description to quantify the value companies according to job description. Optimized Linear Regression, Lasso Regression, and Random Forest using GridsearchCV to reach the best model.Evaluated these models using Mean Absolute Error

Big Data Analysis on NYC & LA Parking Ticket Violations Power BI Jan 2020 – Mar 2020

• Recognized the pattern of parking violation issued and its correlation with the weather.Performed exploratory data analysis including cleaning, merging data sets to find correlation with the weather.Created dashboards and KPIs to understand the trends of parking violation ticket issued. Created reports using DAX functions to get insights. Management System for a Cab Rental Service SQL,PL-SQL Feb 2020 – Apr 2020

• Implemented PL-SQL procedures and functions with several operations that cab service uses to perform the day-to-day business with rides and payments. Designed database using ER models, ingested data into SQL server using DML Queries, performed exception handling, created user, defined procedures and functions. User behaviour and Analysis towards Udemy Courses Python May 2020 – July 2020

• Performed pre-processing of data, identified and removed outliers .Visualized data for better understanding of results and evaluated correlation coefficient to determine the relations between the variables Technical Skills

Languages & Libraries: Python(Numpy,Pandas, Seaborn, Scikit-learn),Spark, UNIX Databases & Servers: MySQL, PL-SQL, Oracle SQL Developer, Mongodb, Neo4j Tools & Framework: Jupyter Notebook, Tableau, Microsoft PowerBI, Cognos, MS Office (word, Excel, PowerPoint, Outlook

Certification

• IBM - Data Visualization and Dashboards with Excel and Cognos

• IBM - Excel Basics for Data Analysis

• Python Programming Track by Data Camp

• Improving Query Performance in SQL Server by Data Camp

• Data Visualization with Python by Coursera

• Introduction to R by Data Camp

• Intermediate SQL Server by Data Camp

Contact this candidate