Business Analytics Data

Simranjeet Kaur

**********.*****@*****.*** 669-***-****

MS in Business Analytics May 2025, GPA: 3.87

California State University, Sacramento CA

Professional Summary

Detail-oriented and analytical-minded Business Analytics graduate with a strong background in data analytics, programming, and business strategy. Experienced in using Python, Tableau, and Excel to create actionable insights. Proficient in data modeling to structure complex information and support accurate, scalable analysis. Passionate about leveraging data to solve complex business problems and drive strategic decisions. An active listener and a problem solver with strong attention to detail and analysis. Technical Skills

Languages & Tools: Python, R, SQL, Tableau, Excel, HTML, CSS, JavaScript, PHP, MySQL Analytics & BI: Pivot Tables, Data Cleaning & Wrangling, Data Visualization, KPI Dashboards Software & Platforms: Visual Studio Code, QuickBooks, Rapid Log, ERP, PowerPoint, Pro Miles Recent Grad School Project (Business Analytics)

● Sales Data Dashboard (Tableau): Designed an interactive dashboard to monitor sales KPIs across regions and product categories, enabling data-driven performance insights.

● Electric Vehicle Dashboard (Tableau): Designed and developed an interactive Tableau dashboard to analyze electric vehicle population data across states, counties, and cities. Integrated multi-level filters (e.g., model year, vehicle type, electric range, CAFV eligibility) and geospatial maps to enable user-driven insights. Applied data modeling, preprocessing, and user-centered design to support decision-making for EV policy, infrastructure, and market strategies.

● Bank Teller App (Python): Developed a command-line based banking system simulating teller operations including account management, deposits, withdrawals, and transaction history.

● Supermarket Sales Data Analysis (Python): Refined and structured complex datasets, conducted in-depth analysis and dashboard view of sales data to identify sales trends and customer purchasing behavior. Work Experience

NSC Compliance Services Ltd - Regulatory firm specializing in compliance and certification services for logistics services. Tax Administrator & Project Coordinator (BC, Canada) Jan 2019 – Dec 2023

● Partnered with management to identify compliance gaps, define audit needs, and build dashboards for government auditors and performance tracking.

● Monitored software workflows and provided data-driven solutions during team meetings.

● Triaged and prioritized cases for assignment, streamlined processes to improve efficiency, and consistently met monthly deadlines.

● Analyzed numeric data during audit processes, identified discrepancies, and performed mismatch remediation to ensure accurate financial and compliance reporting.

● Resolved technical queries to support compliance processes by leveraging deep knowledge of regulatory systems and maintaining clear communication with clients and team members. Simranjeet Kaur

**********.*****@*****.*** 669-***-****

MS in Business Analytics May 2025, GPA: 3.87

California State University, Sacramento CA

● Conducted compliance checks for monthly online tax filings, ensuring accuracy and timely submissions for 100+ companies. Managed and maintained database hygiene improving reporting efficiency and data accuracy across compliance operations.

● Responsible for leading team training workshops to onboard new staff and ensure consistent understanding of compliance procedures and workflow tools.

● Trained commercial staff on industry compliance standards such as dangerous goods handling, and logbook requirements and regulations.

Jasiel Creations - A design and technology firm specializing in event management digital technology solutions. Programming Analyst (Gurgaon, India) Sept 2015 – Dec 2016

● Created and maintained internal web applications using PHP, HTML, CSS, and MySQL to improve inventory tracking and order management efficiency.

● Designed and implemented SQL queries to extract, analyze, and validate sales and inventory data for strategic planning and reporting.

● Performed data cleaning and consistency checks to ensure accurate product listings across internal databases and customer-facing systems.

● Collaborated with cross-functional teams to ensure seamless integration of design, production, and logistics workflows through data-driven systems.

● Built custom dashboards and data interfaces to support sales and operations teams, improving visibility into real-time product and supply metrics.

Undergrad Project (Computer Science Engineering)

● Explore Punjab: Developed a responsive tourism web application using PHP, MySQL, and Google Maps API to promote Punjab's cultural sites and streamline trip planning for visitors.

● E-Noticeboard: Designed and developed an Android-based E-Noticeboard app to streamline digital communication, enabling real-time posting and viewing of announcements. Education

Post Degree Diploma in Business Administration, Vancouver, BC April 2019 Bachelor’s in Computer Science Engineering, Punjab Technical University, India June 2015 Certifications & Honors

React Web Development (Coursera) – 2023

Dean's Honor Roll – 2018

Web Design & PHP Development – 2015

Core Java, Android Certifications – 2013, 2014

Leadership & Volunteering

Treasurer, MSBAA Club, California State University, Sacramento, CA Aug 2024 – Apr 2025 Student Union Coordinator, Langara College, Vancouver BC, Canada May 2018 – Apr 2019

Contact this candidate