Summary
Overview
Work History
Education
Skills
Websites
Projects
Timeline
Generic

NANCY SHARMA

Mississauga,ON

Summary

Self-starter and detail-focused Business Insights and Analytics post-graduate student at Humber college with more than five years of hands-on expertise in data analytics. Skilled in utilizing SQL, R, Microsoft Excel, Pythonand Power BI to develop data-driven actionable insights and proficient in presenting recommendations to stakeholders in an impactful way.

Overview

7
7
years of professional experience

Work History

Customer Service Representative

Cascades
07.2023 - Current
  • Proficient in using SAP for effective and efficient real-time data entry, retrieval, and basic analysis
  • Awarded Best CSR for the fourth quarter in the Ontario region, showcasing exceptional communication skills that facilitated smooth order processing and outstanding customer service.
  • Effectively collaborated with peers and cross-functional teams to achieve customer service excellence, leveraging teamwork to address customer needs and deliver exceptional service.
  • Developed rapport with customers through active listening skills, leading to higher retention rates and positive feedback from clients.
  • Applied advanced MS Excel proficiency to enhance data accuracy, contributing to streamlined order processing
  • Excelled in developing reports with precise and comprehensive documentation for efficient stakeholder communication
  • Practiced self-management and time management techniques to efficiently handle customer inquiries, prioritize tasks, and meet service-level agreements, consistently delivering prompt and effective solutions.

Data Science Tutor

Oxford Learning Center
06.2022 - 11.2022
  • Taught fundamentals of languages including SQL, Python, and statistics to students, fostering a dynamic and engaging learning environment
  • Maintained regular communication with parents, scheduling and conducting meetings to discuss their child's progress, resulting in a 90% parent satisfaction rate
  • Conducted regular evaluations of curriculum materials, making recommendations for updates or revisions as needed to maintain relevance in today''s rapidly changing world.
  • Collaborated with fellow tutors to develop effective strategies for addressing diverse student needs and abilities.
  • Maintained detailed records of student progress, using data to inform future instruction and target areas for improvement.

Data Quality Analyst

Think NEXT Technologies Private Limited
01.2020 - 04.2022
  • Translated client requirements into technical specifications and collaborated with cross-functional teams (developers and product managers) to address any potential database-related issues using SQL queries, reducing data-related errors by 15%
  • Implemented methods to detect anomalies and outliers in datasets utilizing tools like Python (Pandas, NumPy) and collaborated with cross-functional teams like developers to integrate data quality checks into the software development lifecycle (SDLC), using tools like Jira
  • Developed comprehensive documentation on data quality procedures, enabling standardized practices across the organization.
  • Reduced errors in critical business decisions by proactively identifying data inconsistencies and ensuring their rectification.
  • Leveraged SQL extensively to perform data validation, execute data retrieval queries, and verify data accuracy, ensuring that software testing processes were based on accurate and reliable data.
  • Enhanced data accuracy through meticulous review and cleansing of large datasets.

Information and Business Analyst

Dev Samaj College for Women
09.2016 - 12.2019
  • Analyzed historical enrollment trends to provide yield rates for future admissions cycles
  • Utilized Power BI to aggregate and visualize academic data, identifying patterns influencing student performance
  • Developed a faculty timetable using MS Excel, ensuring conflict-free scheduling of courses and maximizing the availability of technical electives for each program or option
  • Optimized workflow processes to enhance overall productivity and achieve operational excellence.
  • Conducted space utilization analysis and provided recommendations based on changing enrolments, resulting in enhanced resource allocation and improved scheduling efficiency for academic programs.

Education

Ontario Post-Graduate Certificate - Business Insights and Analytics

Humber Institute of Technology And Advanced Learning
Etobicoke, ON
08.2024

Master of Science - Mathematics

Panjab University
Chandigarh, India
08.2015

Bachelor of Science - Mathematics and Computer Science

Panjab University
Chandigarh, India
05.2013

Skills

  • Microsoft Word
  • Microsoft Excel (VBA Programming)
  • Data Analysis using Excel
  • Microsoft PowerPoint
  • Data Acquisition
  • Database Programming and SQL
  • Data warehousing
  • Data Preprocessing
  • Scikit-Learn Mastery
  • R Programming
  • Data Mining
  • Unsupervised Learning
  • Feature Engineering
  • Bayesian Statistics
  • Business Needs Analysis
  • Software Development Life Cycle (SDLC)
  • ETL Processes
  • Data Visualization (Tableau, Power BI) and Presentations
  • Python Programming
  • Analytical Problem Solving
  • Data Wrangling and Profiling
  • Data Analysis
  • Report Preparation
  • Attention to Detail
  • Git
  • Strong Work Ethics
  • Agile Methodologies
  • Requirements Gathering
  • Clear and Concise Communication
  • Team Collaboration
  • Active Listening
  • Time Management
  • Adaptability

Projects


  • Salary Prediction: Executed a Salary Prediction project using Polynomial Regression in Python, specifically, leveraging Scikit-Learn. Implemented a meticulous leveraging train-test spilt to ensure robust model training and testing. Additionally, incorporated data visualization techniques to showcase model accuracy through informative graphs, emphasizing the practical application of machine learning in salary forecasting.
  • Customer Segmentation for Targeted Marketing: Executed a Customer Segmentation project employing K-Means Clustering to categorize customers based on age and salary. Applied the Elbow Method to determine the optimal number of clusters, ensuring accurate and meaningful segmentation. Operated on unsupervised data, showcasing proficiency in unsupervised machine learning techniques. Visualized the clustered data, providing valuable insights into customers demographics, preferences, and aiding strategic decision.
  • Utilized SQL to analyze an extensive music-related dataset and developed innovative data-driven insights like identification of top customers by country, analysis of sales data by artist, ranking customers by spending, determining top-selling artists, and understanding customer spending patterns. These actionable insights empowered the business to make informed decisions, optimize marketing strategies, tailor promotions, and enhance overall customer satisfaction, contributing to improved business performance and profitability.
  • Displayed proficiency in ERD and SQL by leading a comprehensive data analytics project to address declining customer retention at a fictional company. Developed descriptive, diagnostic, predictive, and prescriptive analytics questions, designed an ERD diagram, performed data manipulation, and implemented BI solutions to provide actionable insights for improving customer retention and driving business growth, resulting in a final grade of 92%.
  • Spearheaded a team of six members to discover insights and trends; presented insightful recommendations to improve the sustainability of the business model of a Canadian retail store by conducting strategic analysis and applying a range of data analytic frameworks.
  • Sentiment Classification Model: Build a sentiment classification model using Naïve Bayes and other natural language processing techniques to analyze customer reviews from restaurant surveys and predict their sentiment as positive, or negative. This project aimed to automate the sentiment analysis process, enabling restaurants to gain valuable insights from customer feedback more efficiently.

Timeline

Customer Service Representative

Cascades
07.2023 - Current

Data Science Tutor

Oxford Learning Center
06.2022 - 11.2022

Data Quality Analyst

Think NEXT Technologies Private Limited
01.2020 - 04.2022

Information and Business Analyst

Dev Samaj College for Women
09.2016 - 12.2019

Ontario Post-Graduate Certificate - Business Insights and Analytics

Humber Institute of Technology And Advanced Learning

Master of Science - Mathematics

Panjab University

Bachelor of Science - Mathematics and Computer Science

Panjab University
NANCY SHARMA