APOORVA JAIN

469-***-**** adgoro@r.postjobfree.com linkedin.com/in/apoorvajain7 apoorvajain7.myportfolio.com github.com/apoorvajain7 EDUCATION

Southern Methodist University Dallas, TX Aug 2020

• Masters in Engineering Management Specializing in Information System

• Masters in Network Engineering

Rajiv Gandhi Prodyogiki Vishwavidyalaya Bhopal, India June 2017

• Bachelors in Electrical and Electronics Engineering SKILLS

Soft Skills: Communication, Observant, Analytical Thinking, Self- Driven, Problem-Solving Courses: Engineering Economics, Management Information, Statistics and Probability, Analytics for Decision Support, Python for Data Analysis, System Quality Analysis, System Engineering Concepts: Cluster Analysis, Regression Analysis, Decision Tree, Naïve-bayes, CART, Hypothesis Testing, Descriptive Analytics, Predictive Analytics, Exploratory Analytics, Economic Decision Making, (Certainty, Uncertainty, Risk), Financial Analysis (Stock Trading, Monte Carlo Simulation, Portfolio Optimization) Data Tools: R, Python, Minitab, SPSS, Statal, MS Excel (Macros, Pivot), MS Power BI, Tableau, MySQL, JIRA. Google Analytics EXPERIENCE

Vidushi Infotech, Data Analyst Pune, India Aug. 16 – Jul. 17

• Performed data wrangling and data aggregation using R, validated, and deduced anomalies in the operations by 9%

• Modelled reports by tabulating and analyzing data to increase the scalability by 12% and perform root cause analysis by developing regression models on complex data

• Developed Tableau dashboards to interpret the key metrics for cost-effective solutions across various teams and clients Supr Techlab Pvt. Ltd., Data Analyst Intern Mumbai, India Jul. 16 – Aug. 16

• Developed MS Excel reports with higher consistency and validity to increase the data quality to target high valued customers based on demands of consumer product, which led to increase sales by 18% developing business strategies

• Automated real time cash-flow reports using Macros which summarized various operations across the departments

• Designed the visualization reports to interpret the key metrics, increase the usability by 50% to ease the communication PROJECTS

Financial Analysis: (Python, Tableau) Aug. 20 - Present

• Asset Allocation and Statistical Analysis; to perform portfolio analysis (calculating portfolio returns, risk) depending on client’s risk, targeted returns, and investment time span. Used plotly, matplotlib for data visualization in python

• Performed Bank Market segmentation using unsupervised learning (cluster analysis, PCA) The Battle of Neighborhood: (Python) Jun. 20 – Aug. 20

• Utilized Foursquare API to do exploratory analysis of the restaurants in NYC, based upon features

• Recommended the best neighborhood to open a new restaurant using a machine learning algorithm, Cluster Analysis

(8) and visualized the venue, neighborhood, clusters using Folium, Seaborn library in Python Sentiment Analysis: Content analysis (R, SQL) Dec. 19 – Jan. 20

• Analyzed the tweets by text mining, performed data categorization, and queried the tweets of GOP debate using SQL

• Evaluated the model performance with an accuracy of 98.67% and 68.3%, visualized the frequency of candidate that was mentioned the most and the sentiment of the tweet a

Ilumexico: Model for Solar Plant Company (R, Tableau) Apr. 19 – May 19

• Preprocessed 1.8M dataset associated with product, built machine learning models using Cluster Analysis (14) and Decision Tree to enhance payment portfolio of the product, determined good indicator for customer compliance

• Predicted reliability of credit score and evaluated the performance using confusion matrix, ROC and AUC curve and achieved accuracy of 72% that represented the reliability of credit score rating and payment compliances Election Security System: (MS Excel, SQL) Sep. 18 – Dec. 18

• Developed a solution by creating sets of question to clarify the requirement needed for the system, assumed to interview the Secretary of Homeland Security for stake holder analysis, high level requirements, design and testing and validating the plan for fraud or security breach

EXTRA • CURRICULAR

• AWS Certified Cloud Practitioner (EVJRFM8CHJBE1CGS)

• Grace Hopper Conference Attendee (2019 and 2020)

• Goldman Sachs Engineering Virtual Program – Insidesherpa

• Gyan Prem Foundation (NGO) – Volunteer

Contact this candidate