GURPREET BADRAIN
Ridgecrest, California 818-***-**** ********@*****.*** [LinkedIn] [GitHub] [Tableau]
PROFESSIONAL SUMMARY
Results-driven Data Analyst and Educator with expertise in transforming complex datasets into actionable insights while implementing data-driven teaching methodologies. Combines technical proficiency with strong communication skills to enhance decision-making, operational efficiency, and educational outcomes.
TECHNICAL EXPERTISE
●Data Analysis & Visualization: Pandas, NumPy, Tableau, Matplotlib, Seaborn; Advanced data cleaning, transformation, and statistical analysis
●Programming & Databases: Python (proficient), SQL (advanced), JavaScript (intermediate); MySQL, PostgreSQL, NoSQL; ETL pipeline development
●Machine Learning & Tools: Scikit-learn, TensorFlow implementations; Jupyter Notebooks, GitHub, Flask; Excel (advanced functions, pivot tables, VBA)
PROFESSIONAL EXPERIENCE
Math Teacher
Burroughs High School - Ridgecrest, CA August 2022-Present
●Designed and delivered differentiated math instruction for Algebra I and Geometry courses, fostering critical thinking and problem-solving skills.
●Collaborated with cross-disciplinary teams to align curriculum with state standards and student learning objectives.
●Mentored students through individualized support programs, improving academic confidence and participation.
●Nominated for Best Teacher in High School (2024).
Market Research Analyst
Royal Concepts, Inc - Los Angeles, CA July 2022-July 2023 & May 2014-2019 & Dec 2009-June 2011
●Enhanced annual turnover from $2M to $5M through strategic business development initiatives
●Launched 2 new stores in New York & Miami with average 10% ROI
●Led negotiations to secure contracts with Macy's, Nordstrom & Marshalls
●Established market presence for new product lines including Home Furnishings and Accessories
●Improved supply chain efficiency, reducing lead times from 12 weeks to 8 weeks
DATA PROJECTS
●Electric Vehicle Global Impact Analysis: Collected and transformed diverse EV adoption datasets into Pandas DataFrames for comprehensive analysis. Compared EV sales and charging infrastructure development across China, Europe, USA, and global markets. Applied linear regression modeling to quantify the correlation between EV sales volume and charging station deployment, identifying key market development patterns and infrastructure needs.
●ETL Mini Project: Data Pipeline Development Designed an ETL pipeline using Python, Pandas, and PostgreSQL to extract, transform, and load structured crowdfunding and contact datasets. Processed raw Excel data into optimized CSV files, defined an Entity-Relationship Diagram (ERD), and implemented a relational database schema for efficient storage and analysis. The project showcases expertise in data cleansing, ETL workflows, and SQL queries for actionable insights into campaign trends and donor demographics.
●Crop Yield Analysis & Visualization Developed an interactive dashboard and mapping system to analyze global crop yield trends using Python, Folium, Dash, and GeoJSON. Processed environmental and agricultural datasets, applying statistical methods such as correlation analysis and regression modeling. The project enhances data-driven decision-making for policymakers, researchers, and farmers by visualizing yield efficiency, climate impacts, and regional agricultural performance.
Please visit my GitHub profile for more information as I am in the process of developing additional projects by the end of this certification program.
EDUCATION
University of Oregon Continuing and Professional Education
Data Analytics Boot Camp Certification Expected June 2025
●Advanced training: Python, SQL, JavaScript, Tableau, Machine Learning, Big Data analytics
Indira Gandhi National Open University
Master of Business Administration (MBA) - Human Resource Management New Delhi, India
North Eastern Hill University
Bachelor of Science - Mathematics, Physics & Chemistry Shillong, India
CERTIFICATIONS
●Post Graduate Diploma in Computer Applications Regional Computer Centre, Chandigarh, India
●Diploma in Business Management National Council for Labor Management, Chennai, India
ADDITIONAL INFORMATION
●Languages: English, Hindi, Punjabi, Urdu
●Community: Council Member, Measure 'V' Advisory Committee - City of Ridgecrest