Nellie Rajarova Email & Phone Number

Hyderabad Area, India

Hyderabad Area, India

Support end to end migration of analytics platform from IBM Netezza and SAS environment with excel reporting to AWS S3 and Databricks (using PySpark) with Tableau visualization which improved analysis time from 48 hours down to 3 hours for 300M transactional rows enabling faster business decisions

Toronto, Canada Area

• Develop the business performance dashboard that was directly reviewed monthly by the CEO and his executive team for a 360 view of business health and determining problems/opportunity areas to act upon
• Performed variable selection, developed k-means segmentation model to establish sub-thresholds within existing gold tier customers (3M) that drove market research to ultimately focus limited marketing dollars on the.
• Analyzed monthly acquisition by partners using time-series forecasting package in R to setup a data-driven realistic target that led to correction of projected annual new enrollment revenue by 25% ($0.5M)
• Analyzed monthly acquisition by partners using time-series forecasting package in R to setup a data-driven realistic target that led to correction of projected annual new acquisition revenue by 25% ($0.5M)
• Development and implementation of A/B Testing modules using Python to determine the statistically favorable option for grooming campaign, and measured both Type I and Type II errors to establish 95% confidence.
• Led the process of variable selection, model building, and regression analysis at collector level data to understand impact of first time redemption. The results were used to pitch cash as a redemption incentive to.

Toronto, Canada Area

• Developing multiple linear regression based predictive model incorporating input variables like heating degree days, humidity and occupancy rates to forecast energy consumption and use it to track energy performance
• Analyzed current and historical readings from 15+ energy meters to detect wastage of 18,000 kWh annually (33% of total energy) and identified root causes resulting in reduction of energy wastage
• Created a Tableau based analytical dashboard to monitor and analyze energy consumption patterns across 12 York Region buildings (potential energy savings of 13M kWh)
• Took initiative to automate data collection from energy meters, post-collection cleanup and processing using python scripts resulting in savings of 336 person hours annually
• Created compelling Tableau based visualizations to convey finding and recommendations to senior executives

Brampton, Ontario

• Manage consulting engagements with client: project kick-off, requirements gathering, expectations setting and scheduling, plan delivery and complete deliverables with team
• Create reports and visualizations with Excel and Tableau
• Develop Data Model, created database tables and develop queries for reports and data extraction
• Research on new technologies and tools for potential inclusion in company portfolioSupport sales team in pre-sales through POCs, initial engagement calls with potential customers

Roanoke, Virginia Area

• Led research for a $4M US Department of Defense project
• Worked with cross functional team across Metallurgical engineers, chemical engineers and Materials/Civil engineers
• Modeled survivability of Multifunctional Laminated Polymeric Composites using LSDyna
• Used LSDyna to simulate impact of a steel sphere on three-layered and five-layered polymeric laminates, without considering the damage induced in the composite
• Communicated findings and reports to the stakeholders including government officials

• Managed laboratory classes for Fluid and Hydraulics Lab
• Instructed a class of 25 undergraduates in Fluid Power Lab, maintained the course website and graded exams
• Set-up experiments and taught the laboratory classes for Mechanical Power Transmission Lab

Master’S Degree, Business Analytics

Extensive courses in Data modeling, Economic Forecasting, Predictive modeling, Advanced Statistical models, forecasting and analysis.

Ms, Mechanical Engineering

Activities and Societies: • Graduate scholarship throughout graduate studies • Playing Racquetball and swimming • Organized blood donation.

Btech, Mechanical Engineering

Activities and Societies: • Editor of college technical magazine • Organized skit during SpringFest in engineering• Simulated.