Prathap A
erode
Summary
SQL Developer with 2+year of experience in designing efficient database queries and building cloud-based ETL workflows on AWS. Proficient in writing optimized SQL code for data manipulation, reporting, and analytics. Experienced in supporting dashboard development in Power BI and Tableau, delivering clean and reliable data solutions.
Overview
3
3
years of professional experience
Work History
SQL Developer
IT Kalka Solution
Noida
01.2025 - 07.2025
- Developed complex SQL queries to extract data from relational databases.
- Collaborated with team members to troubleshoot and resolve database issues.
- Designed and optimized database schemas for improved performance.
- Documented database procedures and standards for team reference.
- Conducted unit testing of all database objects before deployment.
- Optimized database performance through index tuning and query optimization, improving response time by 40%.
- Collaborated with cross-functional teams to analyze business requirements and translate them into technical solutions.
- Implemented data validation processes, and maintained data integrity across multiple database systems.
- Developed stored procedures, functions and triggers to support application requirements.
- Created automated reports and dashboards using SQL and Power BI for stakeholder decision-making.
- Analyzed business requirements and translated them into logical data models.
Programmer
Bishop Heber College
trichy
01.2022 - 04.2024
- Developed and maintained database applications using SQL Server and MySQL
- Developed complex SQL queries for data extraction and reporting tasks.
- Maintained documentation of software processes and user guides.
- Collaborated with cross-functional teams to understand data requirements.
- Documented SQL processes and procedures for team knowledge sharing.
- Conducted training sessions for staff on new software tools and updates.
- Supported database management tasks for educational data systems at the college.
- Designed databases and data storage solutions to manage application data.
- Created data extraction and transformation scripts for academic data management systems.
- Prepared charts and diagrams by using Power BI to illustrate system operation results to staff in other departments.
- Prepared charts and diagrams to illustrate system operation results to staff in other departments.
- Participated in project meetings to discuss database design and improvements.
Education
M.phil - Computer Science
Bishop Heber College
Trichy, India12-2021
Master of Science - Computational Science
Bishop Heber College
Trichy,India08-2020
Bachelor of Science - Computer Science
Bishop Heber College
Trichy, India05-2018
Skills
- Database technologies: SQL Server, MySQL, PL/SQL, PostgreSQL, and AWS RDS
- Programming languages: SQL, C, C, Basic Python
- Business intelligence: Power BI, Tableau
- Cloud platforms: AWS (S3, RDS, Glue, Lambda)
- Data tools: ETL/ELT processes, data warehousing
- Development tools: SQL Server Management Studio, Visual Studio Code
- Soft skills: problem solving, analytical thinking, effective communication, team collaboration, business analysis
Affiliations
Student performance analysis and visualization using SQL, Power BI, and Tableau
- Project overview: The goal of this project was to analyze student academic data and identify performance trends, subject-wise results, attendance correlation, and overall academic performance using SQL queries and interactive dashboards The final outcome supported actionable insights for academic departments to make data-driven decisions.
Key Responsibilities:
- Collected and imported raw student data (marks, attendance, course details) into a relational database using SQL.
- Designed and normalized relational tables for efficient data storage and easy querying.
- Wrote complex SQL queries to extract insights like:
Top-performing students per subject and semester
Correlation between attendance and academic performance
Pass/fail ratio by department and subject
Year-wise and subject-wise average marks - Created stored procedures and views to streamline reporting queries.
- Exported SQL query outputs to Power BI and Tableau for visualization.
- Designed interactive dashboards to display:
Department-wise performance
Subject-wise failure rates
Attendance impact heatmaps
Student ranking system with filters (department, semester, subject) - Presented findings to college faculty, enabling better academic planning and intervention strategies.
Outcome & Impact:
- Enabled faculty to identify at-risk students early based on data patterns.
- Simplified semester report generation with ready-made dashboards.
- Improved performance visibility across departments and helped in targeted mentoring.
Sales Analytics Dashboard (SQL , Power BI ,AWS)
- Objective: Developed comprehensive sales analytics solution for real-time business intelligence
- Data Processing: Cleaned and processed 500K+ sales transaction records from AWS S3 using AWS Glue ETL pipelines
- Database Development: Designed optimized SQL queries to calculate revenue metrics, discount analysis, and category-wise performance indicators
- Visualization: Created interactive Power BI dashboard featuring 15+ KPIs with drill-down capabilities for product sales and regional trend analysis
- Cloud Architecture: Implemented scalable data storage solution using AWS RDS with automated data refresh scheduling via AWS Lambda
- Performance Optimization: Achieved 60% improvement in query execution time through index optimization and partitioning strategies
- Business Impact: Enabled stakeholders to make data-driven decisions resulting in 25% improvement in sales forecasting accuracy
Declaration
I do hereby declare that the particulars of information and facts stated herein above are true, correct, and complete to the best of my knowledge and belief
31-07-2025
Prathap.A
Timeline
SQL Developer
IT Kalka Solution
01.2025 - 07.2025
Programmer
Bishop Heber College
01.2022 - 04.2024
M.phil - Computer Science
Bishop Heber College
Master of Science - Computational Science
Bishop Heber College
Bachelor of Science - Computer Science
Bishop Heber College
Similar Profiles
LAKSHMI SHODHANA KASAMLAKSHMI SHODHANA KASAM
Consultant Psychiatrist at Mind Plus KalkaConsultant Psychiatrist at Mind Plus Kalka
Shauna QuinnShauna Quinn
Bartender at Kalka Palmns HotelBartender at Kalka Palmns Hotel
AARON RASEKNIAAARON RASEKNIA
HVAC INSTALLER at Kalka Plumbing Heating and AirHVAC INSTALLER at Kalka Plumbing Heating and Air
Satheeskumar GSatheeskumar G
Service Engineer at VIVO - Fangs Technology Pvt LtdService Engineer at VIVO - Fangs Technology Pvt Ltd
Janani CVJanani CV
Senior Account Specialist – UK Payroll Implementation at Zellis HR India Pvt. Ltd.Senior Account Specialist – UK Payroll Implementation at Zellis HR India Pvt. Ltd.