Jayant Bangia (He/Him/His)

ad4bai@r.postjobfree.com h*ps://www.linkedin.com/in/jayantb34/ Por@olio Jersey City,07307 +1-201-***-**** EDUCATION

Stevens Ins)tute of Technology Hoboken, NJ September 2023 - December 2024 Master of Science in Data Science GPA:3.5

(Relevant Coursework : Applied Machine Learning, OpXmizaXon for Data Science, StaXsXcal Methods, CommunicaXon, Python) Chitkara University Rajpura, India August 2018 - July 2022 Bachelor of Engineering in Computer Science GPA:3.5

(Relevant Coursework: Database Management (SQL, NoSQL), Data AnalyXcs, Java, Advanced Web Development, Cloud CompuXng) TECHNICAL SKILLS

Coding Language: Python, SQL, R, HTML, C, Java, JavaScript Database Management Tools: MySQL, MongoDB, AWS S3, Firebase, Microsob Azure Python Libraries: NumPy, TensorFlow, Pandas, Matplotlib, PyTorch, Seaborn Transforma)on & Visualiza)on: PowerBI, Tableau, Microsob Excel, Kibana, Grafana, LateX, PowerPoint, Github Industry Level Cer)fica)on: Google Cloud on Gen Al for Developers, Cisco Data Analysis, JP Morgan CerXficaXon for Agile Scrum, IBM Python 101 for Data Science, Udemy SQL from Beginner to Expects, LinkedIn CerXficaXon in Excel and Power BI PROFESSIONAL EXPERIENCE

TechOps Engineer Paytm Payments Bank Noida, India January 2022 - August 2023

• UXlized tools like SQL to extract data from various databases, idenXfied transacXon discrepancies and then used backend Linux commands to assist in processing or cancelling payments based on the data found in database.

• Significantly reduced failure rates of registered banks/merchants from 10% to 2% by implemenXng strategic measures, all accomplished through proficient use of a database management system (SQL) and collaboraXve problem-solving.

• Resolved assigned JIRA )ckets promptly, maintaining an average resoluXon Xme of 24 hours. Collaborated with the internal team and partner banks to prevent penal)es and ensure merchant saXsfacXon.

• Regularly studied and documented the updated guidelines established by the central bank (Reserve Bank of India) to ensure the prevenXon of fund losses caused by the oversight of new updates.

• Created Excel sheet reports uXlizing tools like pivot tables and VLOOKUP for weekly internal team reviews to idenXfy key performance indicators (KPIs) in the process, which contributed to decrease in cost of operaXons and resources by 2-3%

• Generated dashboards from Excel data using Power BI and delivered presentaXons to the product team. ACADEMIC PROJECTS

Unemployed Rate in US Sta)s)cal Analysis February 2024 - Present

• Employing a variety of Sta)s)cal methodologies to examine unemployment rates across different racial idenXXes such as Asian, Black, White, and Hispanic, as well as gender idenXXes such as male and female by analysing trends from 2003 to 2024.

• Developing and implemenXng predic)ve models to esXmate future unemployment rates for various demographic group. Stock Predictor Price September 2023 - December 2023

• Selected a dataset comprising 3181 days of Tesla stock data from the trained dataset using Pandas commands.

• UXlized Matplotlib and Plotly to visually explore closing Xme data from different Xmestamps in the stock dataset, revealing pa1erns and trends that guided investment decisions and resulted in increased por@olio performance.

• Created a linear regression model and applied pre-processing techniques using sklearn library.

• Achieved closely matched R2 scores and Mean Squared Error (MSE) between the actual data and the predicted data, with 2% error. Breast Cancer Pa)ent Probability Analysis November 2023 - December 2023

• Selected breast cancer dataset containing 4000 paXents from Kaggle and uXlized the factor_analyzer library for factor analysis.

• Determined the probabiliXes of various numerical factors, such as tumor size and age, by establishing a high relaXonship between age and regional node size, reaching 0.68 in the dataset.

• Cleaned the data by removing outliers with the use of pandas library and conducted adequacy tests like KMO and Bartlec’s test to assess data fitness for analysis. Visualized the results using seaborn library's heatmap. Instagram Database Clone By SQL Queries June 2023 - August 2023

• Database Management: Designed and implemented a relaXonal database for an Instagram-like applicaXon.

• Query Op)miza)on: Demonstrated proficiency in wriXng complex SQL queries, including examples like retrieving the latest users.

• Analy)cs and Repor)ng: Developed analyXcal queries to extract meaningful insights, such as idenXfying users who have liked all photos and generaXng a list of usernames along with the corresponding count of likes they have received. Deep Eye Consul)ng Project November 2023 - December 2023

• Crabed presentaXon on AI plagiarism detecXon, spolng student AI tool usage, market analysis, and product-market fit.

• The presentaXon emphasizes comple)on analysis, target audience benefits, and product development strategies.