Shivansh Kansal

ABOUT

A highly motivated and detail-oriented Computer Science graduate with strong analytical skills and a passion for software development. Proficient in Python and JavaScript, with experience in data science and building web applications. Looking for an opportunity to apply technical and problem-solving skills in a dynamic work environment.

SKILLS

Technical Skills: Python, SQL, Django, JavaScript, Git, AWS
Soft Skills: Teamwork, Problem-Solving, Communication, Time Management

PROJECTS

TRADENET

Platform made in Django that helps in choosing stocks to invest with tools for Fundamental and Technical Analysis and provides AI insights.

AI-Driven Analysis: Engineered and deployed AI solutions that synthesized real-time market data and historical financial statements to give insights, enhancing decision accuracy for technical and fundamental analysis.
Integrated Financial Platform: Developed a comprehensive investment analysis platform providing users with integrated tools for in-depth fundamental valuation, technical indicator visualization, and actionable stock screening.
Performance and Optimization: Reduced loading time by 75% through batch processing and page caching, enabling near-instantaneous page loads.

REAL-TIME CLICKSTREAM ELT PIPELINE FOR E-COMMERCE ANALYTICS

Streaming Architecture & Ingestion: Designed and implemented a scalable, fault-tolerant ELT pipeline to ingest and process 10,000+ events/second of user clickstream data. Utilized Apache Kafka for message queuing and Python/PySpark to manage data flow from source to staging in a Data Lake (e.g., AWS S3).
Data Modeling & Governance: Established a robust ELT (Extract, Load, Transform) process where raw data was loaded into Snowflake, then utilized dbt to define, manage, and deploy complex analytical data models.
Performance and Business Impact: Reduced end-to-end data processing latency by 60% through cluster tuning and optimized SQL queries within Snowflake. This enabled near-real-time business intelligence reporting on key metrics like conversion rates and cart abandonment.

CERTIFICATES

Intermediate SQL by Datacamp
Career Essentials in Software Development by Microsoft and LinkedIn
Introduction to Machine Learning by NPTEL

EDUCATION

UTTRAKHAND TECHNICAL UNIVERSITY — Dehradun, Uttarakhand
Bachelor of Engineering, Major in Computer Science (2022–2026)
Relevant Coursework: DSA, OOPS, DBMS, Computer Networks, Operating Systems, Computer Architecture

ST. MARY’S SR. SEC. SCHOOL, JWALAPUR — Haridwar, Uttarakhand
Higher Secondary Class XII (2021–2022)

HOBBIES & INTERESTS

Playing guitar and other instruments
Solving puzzles, coding challenges, and participating in online competitions
Exploring new programming frameworks and open-source contributions

SHIVANSH KANSAL