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 Jasper Reports 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, Jasper Reports, 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 Jasper Reports, 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 Jasper Reports output pipelines for PDF, Excel, and CSV formats integrated with MS SQL Server data sources.
SQL Production Support Engineer
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
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
Skills
SQLMS ServerT-SQLBI ReportingCognosJasperReportsData MigrationViewsTriggersFunctionsCTEsIndexingPL/SQL fundamentalsUser-Defined FunctionsJoinsSubqueriesDDL/DMLiReportServer Management Studio (SSMS)