Education
UNIVERSITY OF CONNECTICUT Stamford, US
Master of Science in Business Analytics and Project Management Expected May ‘23 Data/Business Analytics, Machine Learning, PCA, Logistic and Linear Regression, Decision Trees, Random Forest, Time series forecasting RAJASTHAN TECHNICAL UNIVERSITY Jaipur, India
Master of Business Administration – Specialization in Finance Jun ‘19 Agile Methodology, Statistics, Data Visualization, Accounting, Financial and Risk Management, Supply Chain Management UNIVERSITY OF RAJASTHAN Jaipur, India
Master & Bachelor of Commerce May ‘17
Professional Experience
UNIVERSITY OF CONNECTICUT, US – Pro-Bono Consultant for American Covenant Financial Services Jan ‘23 – Present
• Provide insights to rationalize the creation of a company that offers customize experience to the non-high net worth market, democratizing insurance to provide affordable and tailored insurance services to everyone AALISHAAN STRUCTURE & INTERIORS PVT. LTD., India – Business Analyst Jul ‘18 – Dec ‘20
• Visualized sales and inventory data to create trends charts at SKU level and helped business by recommending inventory planning strategies, resulting in ~12% increase in overall profit
• Conducted in-depth market basket analysis and leveraged insights to develop cross-selling and upselling strategies
• Conducted customer segmentation analysis using variables such as average basket size per order and number of orders. Identified 4 customer segments and provided insights to improve customer retention at segment level, resulting in ~15% increase in sales GARG NARENDRA & ASSOCIATES, India – Data Analyst May ‘17 – Jun ‘18
• Utilized data processing and mining techniques to conduct in-depth risk assessments on credit applications, analyzing various factors resulting in a 15% reduction in credit losses capitalizing on analytical and critical reasoning skills
• Analyzed customer transaction data, identifying patterns and trends in customer behavior and preferences, which led to the development of targeted marketing campaigns, increasing customer engagement
• Collaborated with cross-functional teams and utilized customer segmentation analysis to design and implement personalized product offerings and pricing strategies resulting in a 10% increase in customer retention rates Academic Projects
• Credit card default forecasting, University of Connecticut (Tools: SQL, SAS, JMP) Sep ’22 - Nov ‘22
• Statistical techniques: Logistic Regression, Decision Trees, Bootstrap Forests, K-nearest Neighbors, Neural Network, and Ensemble models
• Outcomes: Reduced default rates & improved customer acquisition planning by predicting the defaults of upcoming credit card payments by leveraging customer credit worthiness data (e.g., history of payments) Airbnb rating prediction, University of Connecticut (Tools: Python, SQL, Tableau) Jul’ 22 - Aug ‘22
• Statistical techniques: Mulivariate analysis, Outlier Treatment, Variable Reduction (e.g., PCA), Feature Engineering, Linear Regression model
• Outcomes: Predicted review ratings for new Airbnb properties in Shanghai, China by assessing a diverse data set including (but not limited to) property size, type, age, location, host details, etc. Fraud detection in travel insurance, Traveler’s Modeling Competition (Kaggle) (Tools: Python, SQL) Jan ’22 - Mar ‘22
• Statistical techniques: Logistic Regression, Random Forest, and XGboost
• Outcomes: Identified instances of first-party physical damage fraudulence and provided an easy-to-understand explanation of the indicators of fraudulent claims. Selected by the organizing committee (among many participants) to present our work to firm representatives Entrepreneurial and Leadership Experience
• 2+ years of experience of teaching in elementary and middle schools
• Mentored incoming graduate students through UCONN buddy program; offered social and academic support. Additional Skills & Certifications
Programming Skills: SQL, Python, R, SAS (Studio, Text miner, JMP) Visualization & Reporting: Tableau, Power BI, QlikView, Python (Seaborn, Matplotlib), Advanced MS Excel predictive model nlp azure problem-solving computer science. Project Management: MS Project, Jira, Scrum, Agile, PMI’s PMBOK, classification big data algorithms a/b test testing quantitative analysis collaboration Splunk hive communication fintech s3 redshift GitHub database data engineer ai Cloud technologies & services: AWS, Google cloud storage (Hadoop, PySpark) Writing stakeholders specification solutions software problem excel data-driven data analysis compliance communicate collaborative.
Shivani Agrawal
adwbc9@r.postjobfree.com +1-203-***-**** LinkedIn Work Authorization Status: Green Card