Rutuja Ramesh Sonawane

Data Analyst

San Diego State University•  July 2024 - Present•  San Diego, CA

Engineered and maintained a custom Grafana instance to monitor CPU, GPU, and Memory usage, emphasizing utilization percentages from existing 50K+ metrics and leveraged PromQL, SQL, and JSON to tailor metrics for departmental needs. Developed a comprehensive Grafana dashboard and exported CSV files for monthly analysis and utilized Pandas, JupyterHub, Python, and Matplotlib to generate insights by specific namespaces, enhancing data visibility and performance tracking. Streamlined data analysis workflows by implementing CI/CD pipelines with Docker, Kubernetes, GitLab, and Postman, ensured efficient deployment, updates, and automation. Automated data extraction, transformation, and visualization by namespaces, delivering actionable insights that align with SDSU’s TIDE project goals for advanced research and high-performance computing.

Data Analyst

San Diego State University•  March 2024 - May 2024•  San Diego, CA

Conducted an in-depth 10-year analysis of student enrollment trends by gender and ethnicity, using Google Sheets for data cleaning and organization to ensure precision. Leveraged Pivot Tables and DAX for advanced calculations, identifying key growth patterns and demographic shifts to enhance user experience by providing clearer, actionable insights. Designed and embedded interactive dashboards in Tableau and Highcharts on WordPress, allowing users to intuitively explore enrollment trends and make data-informed decisions to optimize future enrollment strategies.

Volunteer Research Analyst

San Diego State University•  October 2023 - December 2023•  San Diego, CA

Developed an advanced spatial regionalization system integrating a query parser, planner, and executor, streamlining user-friendly query input. The system actively orchestrates data preparation, initiates region seeding, expands dynamically, and optimizes performance.

Business Analyst

Kate Food Industries Private Limited•  May 2020 - July 2022•  Pune, India

Designed a scalable data warehousing system using AWS Redshift and NoSQL databases to manage sales and inventory data, reducing data retrieval time by 30%. Built automated ETL pipelines with AWS Glue, Lambda, and S3, increasing process efficiency by 50% and eliminating manual data consolidation tasks. Created real-time dashboards in Tableau and AWS QuickSight for monitoring sales, inventory, and demand forecasts, leading to improved decision-making and a 15% decrease in stockouts. Collaborated with cross-functional teams to optimize inventory management, sales strategies, and replenishment schedules, setting KPIs that enhanced forecast accuracy, reduced excess inventory by 20%, and increased salesforce productivity by 10%.

Data Quality Analyst

Riverus Technology Solutions•  December 2019 - May 2020•  Pune, India

Designed data quality protocols for Named Entity Recognition (NER) AI models, ensuring accuracy in extraction, transformation, and loading (ETL) workflows. Utilized NER AI models to extract legal information from government websites, ensuring high data reliability through testing and discrepancy resolution. Performed exploratory data analysis and developed advanced visualizations, while assessing business workflows to provide recommendations and implement data-driven solutions for key product and business decisions.