Kalyani Kulat
Mumbai
Summary
Production Technical Support Analyst at Accelya Solutions India Ltd. with expertise in PL/SQL, SQL, Java, and Linux. Ensures high application availability and system stability through effective production support. Skilled in diagnosing complex technical issues and collaborating with cross-functional teams to implement solutions. Committed to delivering impactful results while continuously enhancing technical capabilities.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Technical Analyst II - Production Support
Accelya Solutions India Limited
08.2024 - Current
- Promoted
1. Senior Technical Analyst with 4 years of experience in client facing environment with high availability applications which involves complex architecture, high volume data and large databases.
2. Involved in Production/Application - Support, Transition and Migration, Automation, Release and Deployments, Configuration, Testing.
3. Identify the root cause, propose solutions, and assist in resolution and fixing production Bugs.
4. Hands-on experience with Debugging PL-SQL packages, procedure, functions and server log analysis.
5. Ability to work in JIRA and Service Desk ticket management.
6. Well versed with Shell scripting, Linux and Windows platform.
7. Good client relationship, Escalation management, Training and Mentoring skills.
8. Excellent analytical, communication, interpersonal, problem solving skills and strong ability to perform as a part of the team and adaptable in different types of work requirements.
9. Ability to work in rotational shifts with teams in multiple geographic locations (APAC & EUR - Middle East) and time zones.
Technical Analyst l - Production Support
Accelya Solutions India Limited
02.2022 - 08.2024
- I received an appreciation letter from the APAC-EUR client for my outstanding contribution, issue resolution, and meeting critical deadlines.
Education
B.E - Information Technology
Sipna College of Engineering and Technology
01.2020
HSC - Comp. Science
Jagruti Mahavidyalaya
01.2016
SSC -
Saint Anne's English Highschool
01.2014
Skills
- PL/SQL programming/Debugging (Packages, Procedures, Functions)
- Advanced SQL techniques
- Performance tuning strategies
- Oracle SQL Developer expertise
- Unix/Linux shell scripting
- Version control systems
- Airline and finance experience
- Business rules comprehension
- Collaboration with analysts
- Problem-solving skills
- Effective communication
- Strong Problem-Solving & Analytical Thinking
- Excellent Verbal & Written Communication
- Client Handling & Stakeholder Management
- Team Collaboration & Ownership Mindset
Languages
- English
- Marathi
- Hindi
Certification
Project Name: Enterprise Data Processing & Reporting Platform
Tech Stack: Oracle 11g/12c, PL/SQL, SQL, UNIX, Shell Scripting
Project Overview:
Worked on a scalable enterprise data platform used by internal teams and external clients for reporting, reconciliation, and transaction processing. The system handled high-volume data loads with strict performance and data-quality requirements.
Key Contributions:
1. Designed, developed, and maintained high-performance PL/SQL packages, procedures, and functions supporting core product features.
2. Built robust data validation, reconciliation, and error-handling frameworks to ensure data accuracy for client-facing reports.
3. Optimized complex SQL queries using execution plan analysis, indexing strategies, and query refactoring, improving overall system performance.
4. Developed and supported batch processing workflows for daily and monthly data loads using PL/SQL and shell scripts.
5. Collaborated directly with clients, product owners, and business stakeholders to understand requirements and deliver enhancements.
6. Provided production support, including root-cause analysis, permanent fixes, and preventive improvements.
7. Ensured adherence to coding standards, release processes, and documentation practices in a product environment.
Impact & Results:
1. Reduced data processing time by 25–30% through SQL and PL/SQL optimization.
2. Supported multiple client releases with zero critical post-production defects.
3. Helped minimize manual intervention by automating validation and reconciliation processes.
Technical Skills
Database: Oracle 11g, 12c
Programming: SQL, PL/SQL
PL/SQL Expertise: Packages, Procedures, Functions, Triggers, Cursors
Tools: PL-SQL Developer, SQL*Loader
Tech Stack: Oracle 11g/12c, PL/SQL, SQL, UNIX, Shell Scripting
Project Overview:
Worked on a scalable enterprise data platform used by internal teams and external clients for reporting, reconciliation, and transaction processing. The system handled high-volume data loads with strict performance and data-quality requirements.
Key Contributions:
1. Designed, developed, and maintained high-performance PL/SQL packages, procedures, and functions supporting core product features.
2. Built robust data validation, reconciliation, and error-handling frameworks to ensure data accuracy for client-facing reports.
3. Optimized complex SQL queries using execution plan analysis, indexing strategies, and query refactoring, improving overall system performance.
4. Developed and supported batch processing workflows for daily and monthly data loads using PL/SQL and shell scripts.
5. Collaborated directly with clients, product owners, and business stakeholders to understand requirements and deliver enhancements.
6. Provided production support, including root-cause analysis, permanent fixes, and preventive improvements.
7. Ensured adherence to coding standards, release processes, and documentation practices in a product environment.
Impact & Results:
1. Reduced data processing time by 25–30% through SQL and PL/SQL optimization.
2. Supported multiple client releases with zero critical post-production defects.
3. Helped minimize manual intervention by automating validation and reconciliation processes.
Technical Skills
Database: Oracle 11g, 12c
Programming: SQL, PL/SQL
PL/SQL Expertise: Packages, Procedures, Functions, Triggers, Cursors
Tools: PL-SQL Developer, SQL*Loader
Timeline
Technical Analyst II - Production Support
Accelya Solutions India Limited
08.2024 - Current
Technical Analyst l - Production Support
Accelya Solutions India Limited
02.2022 - 08.2024
B.E - Information Technology
Sipna College of Engineering and Technology
HSC - Comp. Science
Jagruti Mahavidyalaya
SSC -
Saint Anne's English Highschool