Ritika Wadhwa
Boston, MA ad2lop@r.postjobfree.com +1-857-***-**** www.linkedin.com/in/wadhwaritika https://rwritikawadhwa.wixsite.com/ritikawadhwa
Education
Northeastern University, Boston, MA Aug 2023
Master of Science - Engineering Management (Data Analytics), GPA: 3.8 Courses: Computation and Visualization in Analytics, Statistical Methods in Engineering, Data Management and Database Design Data Science Fellowship, DS4A – CorrelationOne Aug 2022 Skills: Data Analytics, Data Visualization, Machine Learning - Python, SQL, Tableau Manipal Institute of Technology, India May 2019
Bachelor’s in technology – Biotechnology Engineering, GPA: 8.87 Skills
• Tools - MS Excel, Python (Pandas, Numpy, Scikit-learn, Matplotlib, Tensorflow, Pytorch), MYSQL, MSSQL Server, Tableau, PowerBI, AWS, Azure Data Studio, Rstudio, Snowflake, SAP Analytics
• Techniques – Data Visualization, Exploratory Analysis, Predictive Analysis, Inferential Statistics, Data Mining, Database Management, Machine Learning (Linear Regression, Logistic Regression, Decision Trees, PCA, Recommender Systems)
• Certifications – Data Analysis with Python – IBM, SQL Essential Training – LinkedIn Learning, Python for Data Science and Machine Learning Bootcamp – Udemy
Experience
IT Operations Services Co-op (Data Science) – Boehringer Ingelheim, GA, USA July 2022 - Dec 2022
• Engineered a predictive Random Forest model in Python, achieving an 84% accuracy in predicting vaccine production contamination, leading to approximately $1 Million savings per year.
• Designed user-friendly live data model dashboards on SAP Analytics Cloud, resulting in a 40% reduction in time spent accessing critical data.
• Supported migration of 24 production databases to AWS by documenting dataflows and triggers from OracleSQL to SIMCA
• Streamlined AWS pipelines with updated SQL code, enhancing operational efficiency and reducing error rates by 30%.
• Led Agile framework and Scrum meetings, using Atlassian JIRA & Confluence contributing to a 15% improvement in project delivery times and fostering a collaborative environment. Marketing Analyst– Auctm Squadstack, India Aug 2020 - June 2021
• Leveraged Python to automate and optimize email marketing campaigns, resulting in a 20% increase in product sales.
• Designed an efficient email cadence, leading to a 10% higher open rate and a 15% increase in click-through rates.
• Utilized data insights and Python for precise segmentation in personalized outreach, expanding Auctm's reach by 30% and contributing to a 25% growth in revenue
Medical Genetics and Patient Engagement Intern – CORE Diagnostics, India Aug 2019 – July 2020
• Managed and analyzed extensive clinical data, leading to the publication of an article in a journal on cancer genetics
• Employed advanced Excel tools including Vlookup and Pivot tables, enabling the identification of 15% more significant insights from intricate clinical datasets, thereby enhancing the research's impact and validity. Projects
E-commerce Database Management System using MS-SQL Server & Tableau, Northeastern University May 2023
• Engineered and deployed an e-commerce database management system that eliminated product duplication and ensured real-time tracking, resulting in a 20% reduction in operational errors and maximizing customer satisfaction
• Designed the ERD and executed the database in MS-SQL Server, employing DDL, DML, views, triggers, check constraints, and stored procedures, expediting ETL processes by 30%
• Utilized Tableau for data visualization and provide insights on sales and profit for data-driven decision-making and growth Exploratory Data Analysis and Visualization for Airbnb globally using Tableau, Northeastern University April 2022
• Orchestrated data integration from 'Inside Airbnb' datasets with 35,000+ global listings, using Excel, SQL, and Tableau Prep
• Analyzed global Airbnb distribution, identifying key factors influencing pricing and reviews, contributing to a 25% improvement in revenue optimization.
• Crafted an interactive Tableau dashboard revealing crucial pricing insights, which led to informed decisions resulting in 12% higher revenue in specific locations.
• Extracted actionable insights, such as amenity offerings and host types, enabling hosts to achieve 20% higher review ratings through strategic pricing adjustments.
Exploratory Data Analysis of Stock prices with Python Aug 2022
• Analyzed timeseries data for stock prices across prominent banks using Python libraries, revealing patterns and insights
• Studied stock returns, gains, and risk levels, enabling the creation of a robust decision support system
• Developed a framework to identify stocks with 15% lower risk for 10% lower gain and those with 20% higher risk for 15% higher gain, providing investors with tailored options