Portfolio

About Me

Data Analyst with 3.8+ years of experience leveraging 𝗦𝗤𝗟, 𝗣𝘆𝘁𝗵𝗼𝗻, 𝗮𝗻𝗱 𝗕𝗜 𝘁𝗼𝗼𝗹𝘀 (𝗟𝗼𝗼𝗸𝗲𝗿, 𝗧𝗮𝗯𝗹𝗲𝗮𝘂, 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜) to 𝘁𝗿𝗮𝗻𝘀𝗳𝗼𝗿𝗺 𝗿𝗮𝘄 𝗱𝗮𝘁𝗮 𝗶𝗻𝘁𝗼 𝗮𝗰𝘁𝗶𝗼𝗻𝗮𝗯𝗹𝗲 𝗶𝗻𝘀𝗶𝗴𝗵𝘁𝘀. Built 𝟭𝟱+ 𝗱𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱𝘀 𝗶𝗻 𝗰𝗼𝗹𝗹𝗮𝗯𝗼𝗿𝗮𝘁𝗶𝗼𝗻 𝘄𝗶𝘁𝗵 𝗽𝗿𝗼𝗱𝘂𝗰𝘁 𝗮𝗻𝗱 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝘁𝗲𝗮𝗺𝘀, 𝗲𝗻𝗮𝗯𝗹𝗶𝗻𝗴 $𝟮𝗠 𝗰𝗼𝘀𝘁 𝘀𝗮𝘃𝗶𝗻𝗴𝘀 𝗮𝗻𝗱 𝗹𝗲𝗮𝗱𝗶𝗻𝗴 𝘁𝗵𝗲 𝗮𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝘁𝗲𝗮𝗺.

𝗣𝗿𝗼𝘃𝗲𝗻 𝗮𝗯𝗶𝗹𝗶𝘁𝘆 𝘁𝗼 𝗯𝘂𝗶𝗹𝗱 𝗿𝗼𝗯𝘂𝘀𝘁 𝗘𝗧𝗟 𝗽𝗶𝗽𝗲𝗹𝗶𝗻𝗲𝘀, design impactful dashboards, and drive data-informed decision-making across diverse industries (𝗙𝗶𝗻𝘁𝗲𝗰𝗵, 𝗦𝗮𝗮𝗦, 𝗜𝗺𝗺𝗶𝗴𝗿𝗮𝘁𝗶𝗼𝗻 𝗧𝗲𝗰𝗵).

Focused on 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗶𝗻𝗴 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗽𝗿𝗼𝗰𝗲𝘀𝘀𝗲𝘀 𝗮𝗻𝗱 𝗱𝗲𝗹𝗶𝘃𝗲𝗿𝗶𝗻𝗴 𝗺𝗲𝗮𝘀𝘂𝗿𝗮𝗯𝗹𝗲 𝗶𝗺𝗽𝗿𝗼𝘃𝗲𝗺𝗲𝗻𝘁𝘀 through 𝘀𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗰 𝗮𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗮𝗻𝗱 𝘀𝗰𝗮𝗹𝗮𝗯𝗹𝗲 𝘀𝗼𝗹𝘂𝘁𝗶𝗼𝗻𝘀. 𝗣𝗮𝘀𝘀𝗶𝗼𝗻𝗮𝘁𝗲 𝗮𝗯𝗼𝘂𝘁 𝗯𝘂𝗶𝗹𝗱𝗶𝗻𝗴 𝗲𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝘁 𝗱𝗮𝘁𝗮 𝘄𝗼𝗿𝗸𝗳𝗹𝗼𝘄𝘀 and 𝗰𝗼𝗻𝘁𝗿𝗶𝗯𝘂𝘁𝗶𝗻𝗴 to data-centric cultures.

Tech Stack

Bing API Analytics

Built an ETL pipeline integrating Bing API with Azure & Microsoft Fabric.

View Report

Walmart Sales Analysis

Performed EDA using SQL & Python. Built Tableau dashboard.

View Project

Spotify Playlist Analysis

Built a recommendation model using Python & AI.

View Project

Netflix Content Analytics Dashboard

Developed an interactive Tableau dashboard analyzing Netflix content trends and viewer insights.

View Dashboard

Web Authentication Security Insights

Built machine learning models to detect anomalies in authentication logs, identifying unauthorized access patterns and mitigating security risks.

View Project

HR Data Analytics Dashboard

Developed an interactive dashboard to visualize workforce trends, reducing employee turnover by 15% through actionable insights.

View Project

Stakeholder Insights and Performance Dashboard

Built a data-driven stakeholder insights dashboard to enhance decision-making and business strategy.

View Dashboard

Instagram SQL Analytics

Developed SQL queries and dashboards to analyze user engagement and content performance on Instagram.

View Project

Airbnb Streamlit Dashboard

Developed an interactive Streamlit dashboard for Airbnb data analysis with visualizations, filters, and geospatial mapping.

View Live Project

FraudShield: Anomaly Detection

Built a real-time fraud detection system using XGBoost, Decision Trees, and anomaly detection (Isolation Forest & LOF), achieving 98.89% accuracy.

View Project

Customer Churn Prediction

Developed a machine learning model using Logistic Regression, Random Forest, and XGBoost to predict customer churn and improve retention strategies.

View Project

Tech Sales Analysis: Trends, Products, and Customer Behavior

Analyzed retail sales data to uncover insights into product performance, customer behavior, and sales trends.

View Project

Work Experience

Aliro Immigration Services | Toronto, Canada

Data Analyst | Jan 2023 - Mar 2025

Million Minds Infotech | Hyderabad, India

Data Analyst | January 2021 - December 2021

ClearTax | Bangalore, India

Financial Data Analyst | July 2020 - December 2020

Education

Post Graduation in Global Business Management

Jan 2022 - Dec 2023

Seneca College of Arts & Technology | Toronto, Canada | GPA: 3.20/4.00

Graduated with a focus on global business strategy, project management, and data analytics. This program enhanced my ability to manage international projects, lead global teams, and develop strategies that drive business success in diverse markets.

Professional Certifications

Python for Data Engineering

Issued by DataVidhya

SQL for Data Engineering

Issued by LinkedIn

Tableau Essential Training

Issued by LinkedIn

Data Warehouse with Snowflake

Issued by DataVidhya

Apache Airflow for Data Engineering

Issued by DataVidhya

Apache Spark with Databricks

Issued by DataVidhya

Internship Highlights

Sales and Marketing Intern

The Climber | Industry - EdTech / Career Guidance Startup | Jun 2018 - Sep 2018

As a Sales and Marketing Intern at The Climber, an online educational platform, I contributed to driving growth and expanding the platform's reach in the EdTech space:

Revenue Growth: Spearheaded sales and marketing efforts, achieving a 35% increase in revenue within the first year.
Strategic Partnerships: Established partnerships with educational institutions, expanding course offerings by 25%.
Digital Marketing Campaigns: Led targeted campaigns, resulting in a 50% growth in user registrations and increased brand visibility.

This internship sharpened my sales and marketing skills and fueled my passion for using technology to make education accessible to young learners.

Core Competencies

Problem-Solving

Innovative thinker who loves tackling complex challenges and finding creative, data-driven solutions.

Leadership & Collaboration

Strong leadership skills with a focus on teamwork, collaboration, and driving shared success.

Analytical Thinking

Turning complex data into actionable insights that drive impactful business decisions.

Communication Skills

Effective at storytelling with data, delivering clear insights to stakeholders, and facilitating strategic discussions.

Adaptability & Learning

Continuously evolving with emerging trends, adapting quickly to new challenges and technologies.

Creativity & Innovation

Passionate about bringing fresh ideas and innovative solutions to projects and problem-solving scenarios.

Awards & Achievements

Top Employee Award

Aliro Immigration | 2024

Aliro Immigration – Employee of the Year (2024) for delivering high-impact data strategies that increased revenue by 20%

Best Research Contribution

Seneca College | 2022

Awarded for outstanding contributions as a Research Assistant on the "Valuation of Land in Southwestern Ontario" project, delivering impactful insights through data analysis and market research.

Excellence in Data Analytics

ClearTax | 2020

Recognized for facilitating over 1 million tax filings and contributing to over $12.5M in revenue through data-driven financial solutions and optimized compliance processes.

Green Belt in Shaolin Kung Fu (Martial Arts)

Mansuria Kung Fu International

Earned the Green Belt in Shaolin Kung Fu, symbolizing proficiency in foundational martial arts techniques and discipline, reflecting dedication to physical fitness, mental focus, and self-defense mastery.

Beyond Work

Running🏃‍♀️

Journaling & a good brew ☕

Hiking Trails ⛰️

Cooking 🍳

Plant Parenting 🌱

Badminton 🏸.

Giving Back to the Community

Education Outreach Volunteer - Door Step School

Door Step School is dedicated to providing primary education to children from underserved communities, especially those who lack access to formal schooling.

Educational Access: Assisted in learning programs for 1000+ students, helping them transition into formal schooling.
Workshops: Led interactive sessions on life skills like confidence, communication, and problem-solving.
Community Engagement: Collaborated with parents and local communities to drive higher enrollment and participation.

By working with Door Step School, I helped create meaningful change by empowering children with knowledge and skills for a brighter future.

Summer Intern – Enabling Leadership

Enabling Leadership is a global nonprofit dedicated to empowering children through experiential learning programs that foster leadership, critical thinking, and life skills.

High-Impact Programs: Collaborated with partners like Tata Trusts, Axis Bank, and JP Morgan to facilitate programs impacting 620 children.
Sports & Music Events: Organized 12 football matches and 2 music sessions every weekend, ensuring engagement and smooth execution.
Leadership & Teamwork: Designed activities promoting collaboration, discipline, and creative expression for holistic development.

Through this experience, I contributed to creating a dynamic, inclusive learning environment where children could develop holistically.

Student Volunteer – iVolunteer

iVolunteer is a leading nonprofit that connects volunteers with organizations across India, driving social change in education, health, environment, and more.

Environmental Sustainability: Engaged in Plogging (running + litter picking) to protect oceans from plastic pollution.
Clean Communities: Raised environmental awareness through clean-up efforts and community engagement.
Global Change: Contributed to the global Plogging movement, promoting sustainable living and cleaner cities.

Through my involvement with iVolunteer, I supported the organization’s mission to engage people in social development and environmental sustainability.

Hi There,

I'm Sonia Ranvir

About Me

Tech Stack

Portfolio

Bing API Analytics

Walmart Sales Analysis

Spotify Playlist Analysis

Netflix Content Analytics Dashboard

Web Authentication Security Insights

HR Data Analytics Dashboard

Stakeholder Insights and Performance Dashboard

Instagram SQL Analytics

Airbnb Streamlit Dashboard

FraudShield: Anomaly Detection

Customer Churn Prediction

Tech Sales Analysis: Trends, Products, and Customer Behavior

Work Experience

Aliro Immigration Services | Toronto, Canada

Million Minds Infotech | Hyderabad, India

ClearTax | Bangalore, India

Education

Post Graduation in Global Business Management

Bachelor of Business in Information Technology

Higher Secondary Education - MPC

Professional Certifications

Python for Data Engineering

SQL for Data Engineering

Tableau Essential Training

Data Warehouse with Snowflake

Apache Airflow for Data Engineering

Apache Spark with Databricks

Internship Highlights

Sales and Marketing Intern

Backend Development Intern

Operations and Marketing Head Intern

Core Competencies

Problem-Solving

Leadership & Collaboration

Analytical Thinking

Communication Skills

Adaptability & Learning

Creativity & Innovation

Awards & Achievements

Top Employee Award

Best Research Contribution

Excellence in Data Analytics

Green Belt in Shaolin Kung Fu (Martial Arts)

Beyond Work

Giving Back to the Community

Education Outreach Volunteer - Door Step School

Summer Intern – Enabling Leadership

Student Volunteer – iVolunteer

Let's Connect

Get in Touch