Kanchana Bollipalle
Senior SQL Developer with 8+ years of experience in SQL development, database design, performance tuning, data migration, and BI reporting across HCM, HRMS, and Hospitality domains. Expert in MS SQL Server (2012–2019) and T-SQL, including stored procedures, views, triggers, functions, CTEs, window functions, indexing, and execution-plan tuning.
Led a 5-member team migrating 2,000+ reports from IBM Cognos to JasperReports using Amazon Kiro AI automation, cutting manual effort by 60% with on-time, defect-free delivery. Skilled in Agile/SDLC delivery, stakeholder management, and translating business requirements into scalable reporting solutions.
Experience
Senior SQL Developer / Database Developer — Report Migration Team Lead
Infor India Pvt Ltd
Bangalore, India
Environment: MS SQL Server 2019, IBM Cognos BI, JasperReports, Jasper Soft, T-SQL, SSMS, Amazon Kiro AI
•Led a 5-member team and served as primary point of contact for an enterprise migration of 2,000+ reports from IBM Cognos to
JasperReports, ensuring on-time, defect-free delivery through structured release management.
•Leveraged Amazon Kiro AI to automate code generation and documentation, reducing manual migration effort by 60% while mentoring
team members on migration standards and best practices.
•Developed and maintained 100+ production reports in IBM Cognos BI and Jasper Soft, authoring complex T-SQL queries, views, stored
procedures, and user-defined functions for the Hotel Management System (HMS) platform.
•Performed query optimization and performance tuning using execution plans, indexing strategies, and SQL Server Profiler, reducing
long-running query runtimes and improving reporting reliability.
•Owned code reviews, deployment planning, and release management; configured JasperReports output pipelines for PDF, Excel, and
CSV formats integrated with MS SQL Server data sources.
SQL Production Support Engineer — HRMS (Human Resource Management System)
ADP India Pvt Ltd
Bangalore, India
Environment: Microsoft SQL Server, T-SQL, SSMS
•Gathered requirements and prepared functional specifications, guiding enterprise clients through Payroll and LMS module
configuration.
•Developed GL, Bank File, Net Pay to Payment, and Accounting Statement reports, and designed custom client-specific reporting
solutions.
•Delivered L1 & L2 production support using SQL diagnostics, resolving client-critical tickets within SLA commitments while maintaining
live database integrity.
SQL Developer — Malaysia Statutory Clients (HCM) | HCM – Magna
Ramco Systems
Chennai, India
Environment: MS SQL Server, T-SQL, iReport, SQL Server Profiler
•Engineered stored procedures, user-defined functions, and business-rule logic for HCM modules spanning Payroll, Tax, Contribution,
Health Insurance, Loan Deductions, and Termination Payments, optimizing performance through targeted indexing.
•Built and maintained core database objects (tables, procedures, views, triggers, functions) and provided production support through
execution-plan analysis and SQL Server Profiler diagnostics.
Education
JNTU, Anantapuram, India
B.Tech