Data Analyst

RITU GANGWAL

*** * ******* ***** **** ****A, Chicago, IL 60611 adjvyx@r.postjobfree.com +1-312-***-**** LinkedIn: https://www.linkedin.com/in/ritu22gangwal/ Github: https://github.com/ritu22gangwal SUMMARY

Strategic-minded and goal driven analytics professional with 4+ years of industry experience in companies like JP Morgan. Highly skilled in machine learning algorithms, predictive analytics, statistical modeling, financial analysis, and data mining. Expertise in data visualization and writing advanced SQL queries. Passionate about discovering meaningful insights and successfully communicating data-driven results.

CORE COMPETENCIES AND SKILLS

Specialization Machine Learning, Business Data Mining, Text Analytics, Big Data, Advanced Database Management, Data Visualization, Supply Chain Management, Revenue Management, Portfolio Management, Financial Statement Analysis, Project Management Languages & Tools R, Python, SQL, Tableau, Power BI, Alteryx, SAP FI, Gephi Databases MS-SQL Server, SSIS, SSRS, MySQL, Teradata, Oracle, PostGreSQL Big Data Computing Hive, Spark (SparklyR, PySpark, Spark ML, Spark SQL, Spark Streaming) Modeling

Techniques

Decision Trees, Random Forests, Boosting, Linear & Logistic Regression, Elastic Net, SVM, Naïve Bayes, Gradient Boosting, Xgboost, K-nn, PCA, Regularization, Cross-validation, Clustering, SMOTE EDUCATION

University of Illinois at Chicago, Chicago, IL MS - Business Analytics (GPA 4/4) Jan 2020 – May 2021 Institute of Management and Technology (IMT), Ghaziabad, India PGDM –Finance (GPA 3.6/4)Jun 2012 – Apr 2014 Rajiv Gandhi Institute of Engineering, India BE - Electronics & Communications (GPA 3.8/4) Jul 2008 – Apr 2012 PROFESSIONAL EXPERIENCE

Senior Financial Data Analyst JP Morgan India Services Pvt. Ltd., Mumbai, India Aug 2015 – Mar 2019

• Data modelling: Leveraged k-means clustering to identify LOBs having higher losses from existing Oracle ledgers

• Operational Efficiency: Improved by 68% in execution of corporate ledger migration from MERIT Oracle to real-time SAP

• Cost Reduction and Automation: Saved 108 hours of manual reconciliations by automating IST/UAT processes

• Forecasting: Reviewed statistical information to accomplish Gap and Trend analysis with future prediction of suspense nos.

• Result-oriented Leadership: Slashed down the suspense by 92% in by functioning as Data Quality Workstream lead

• Domain Knowledge: Achieved 60+ hours of training sessions on future state operating models ensuring readiness for post go-live infrastructure

• Process Analysis: Scraped 8200+ reviews to perform sentiment analysis and text modeling to detect post migration issues

• Data Visualization: Presented optimization solutions to senior management using interactive dashboards on Tableau

• Collaboration: Led the development of business requirement documents, functional specific document, production timeline, solution mockup, test cases, and deployment plans

Associate Data Consultant Transweb Educational Services Pvt. Ltd., Noida, India Aug 2014 – Jan 2015

• Consulting: Provided professional solutions for data analytics, big data, and database management problems to clients

• Research Analysis: Compiled 100+ academic and research-based reports of various industrial sectors and companies Summer Research Intern Reliance Capital Asset Management Ltd., Mumbai, India Apr 2013 – Jun 2013

• ETL operations: Refined data highlighting results for Comparison of Indian Mutual Fund Industry with Global Peers

• Financial Analysis: Recommended solutions for Indian Mutual Fund industry incorporated by AMCs to remedy shortcomings RELEVANT PROJECTS

Lending Club: Performing Credit Risk Analysis of Customers (R) Purpose: Analyzed credit worthiness using customer demographics Algorithm: PCA, Random Forests, Boosting, Logistic Regression (Best model: GBM with 70% sensitivity and 0.73 AUC) https://github.com/ritu22gangwal/Lending-Club---Analysis-of-defaulters.git Text Mining: Sentiment Analysis of Yelp Reviews (R) Purpose: Text mining (Tokenization, stop words and Lemmatization/Stemming) of user reviews to predict sentiment polarity Algorithm: Naïve Bayes, Random Forest, Support Vector Machine (Best model: SVM- 92% accuracy and AUC=83.45%) https://github.com/ritu22gangwal/Sentiment-Analysis_Yelp-reviews.git Market Segmentation: Segmenting Customers of Dove’s Products (R) Purpose: Executed clustering techniques to segment customers to provide basis for Dove’s products pricing & promotion Algorithm: k-means, DB-SCAN, k-medoids, hierarchical clustering (Best model: k-mean with k=6 and DB Index=1.78) https://github.com/ritu22gangwal/Market-Segmentation_Clustering.git Bureau of Transportation Statistics: Analyzing & Visualizing Performance of American Airlines (Tableau) Purpose: Compared on-time performance of US airlines based on their Delays, Cancellations, Diversions, Peak hours Algorithm: Used Tableau to create interactive dashboards and visualizations like network graphs and stacked bar charts ACHEIVEMENTS

• Awarded Quarterly GFI award for the best employee–GL Config and Quarterly winner award–Data Quality at JP Morgan

• Successfully completed “GE Virtual Internship” – Digital Technology Data Analytics Program

• NSE Certified Investment Analyst Pro (NCIAP) (2013) Investment Analysis and Portfolio Management module, Technical Analysis module, Financial analysis module

• Runner Up in Women's Badminton at Tech Fest- Varchasva 2013 at IIM Lucknow, India

Contact this candidate