Samarth eGov Foundation
|Junior Software Developer
India
Summary
Led the development and maintenance of analytical dashboards and optimized SQL queries, ensuring data integrity and delivering critical business insights for higher education admission systems.
Highlights
Developed and maintained a suite of analytical dashboards using Apache Superset, enhancing data accessibility and reporting efficiency for higher education stakeholders.
Optimized complex SQL queries in ClickHouse and MySQL, improving data retrieval performance by an estimated 20% for large-scale admission and payment datasets.
Validated and reconciled critical admission, payment, and reporting data across multiple sources, ensuring data accuracy and integrity for over 100,000 records monthly.
Investigated and resolved data quality, ETL, and reporting issues using DataGrip, reducing data discrepancies and improving report reliability by 15%.
Collaborated with cross-functional teams to translate complex business requirements into actionable dashboards, directly supporting strategic decision-making for senior management.