Sofiyan Bagwan
Detail-oriented Computer Engineering graduate with strong hands-on expertise in SQL, relational database design, and data reporting
About
Detail-oriented Computer Engineering graduate with strong hands-on expertise in SQL, relational database design, and data reporting. Proficient in writing complex SQL queries — including joins, subqueries, aggregations, stored procedures, views, and triggers — to extract, transform, and report structured data for business use. Experienced in database performance tuning through indexing and query optimization, achieving measurable improvements in execution speed.
Skilled in Python for data analysis and automation, with exposure to ETL concepts, data modelling, and DBMS principles. Eager to contribute as a SQL Developer to data-driven teams by delivering accurate, optimized, and well-documented database solutions.
Experience
Python Full Stack Developer Trainee - Kiran Academy, IT Training Institute
(2025-11 - 2026-04)
- Designed and managed MySQL relational databases throughout an industrial-level full-stack project — wrote complex SQL queries, stored procedures, and data retrieval logic to support application backend operations end-to-end.
- Performed data modelling and schema design aligned with business requirements; applied normalization principles (1NF–3NF) to eliminate redundancy and ensure data integrity across multiple relational tables.
- Analyzed and optimized slow-running SQL queries by implementing indexing strategies and reviewing execution plans, directly improving database performance and reducing response times during application testing cycles.
- Documented database schemas, query logic, and data workflows in structured technical reports; collaborated with the development team using Git and Agile-aligned delivery practices across the SDLC.
Web Development Trainee - Disha Institute Pvt. Ltd
(2024-01 - 2024-02)
- Supported MySQL backend database operations — contributed to data storage, retrieval, and query-based reporting workflows for web application features, ensuring accurate and consistent data handling.
- Assisted in debugging data-related application issues, identifying root causes in SQL queries and backend logic; maintained version-controlled code repositories using Git for collaborative development.
Education
B.E. - Computer Engineering - Savitribai Phule Pune University (2022 - 2025)
HSC - 12th Grade - Shri Narayandas Ramdas Highschool & Jr. College (2020 - 2021)
SSC - 10th Grade - Shri Narayandas Ramdas Highschool (2018 - 2019)
