I am a Data Analyst with 5 years of experience across the retail, education, and payments sectors. I specialize in Python, SQL, and Tableau, with strong skills in data cleaning, preprocessing, web scraping, and creating dynamic visualizations. I am passionate about leveraging data to drive business strategies and improve decision-making processes.
- Programming Languages: Python, SQL
- Libraries: Pandas, Numpy, matplotlib, BeautifulSoup, Scrapy
- Visualization Tools: Tableau, MS Excel
- Data Analysis Techniques: Data Cleaning & Transformation, Web Scraping, Visualization
- Tools & IDEs: Git, PowerPoint, Visual Studio Code, Jupyter Notebook
- Web Technologies: HTML5, CSS, JSON, Moodle(LMS)
- Executed complex SQL queries, optimizing 15 scripts to enhance performance by 40%.
- Developed Tableau dashboards for trending product insights and regional KPIs.
- Utilized Python and Seaborn to visualize customer segmentation for personalized marketing.
- Analyzed payment terminal logs, detecting discrepancies in transaction processing.
- Conducted manual firmware testing, reducing software bugs by 30%.
- Employed Agile methodologies to improve product stability and bug resolution time.
- Automated data migration in Moodle (LMS) using Python, enhancing data accuracy by 90%.
- Managed bulk learner account operations, reducing processing time by 30%.
- Developed a transaction module with JavaScript and MySQL, increasing efficiency by 90%.
- Master of Science in Information Systems | Northeastern University, Boston, USA (Jan 2021 – Dec 2022)
- Bachelor of Technology in Computer Science | Kurukshetra University, Haryana, India (Aug 2014 - May 2018)
- Audible Web Scraping & Analytics: Developed scalable web scraping scripts and interactive dashboards for audiobook performance analysis.
- Coronavirus Tracking Database: Built a SQL Server database with Tableau visualizations to track and analyze COVID-19 data.
- 📍 Detroit Metropolitan Area, MI
- 📧 jaspreet.k.tech@gmail.com
- ✍️ Blogging