Toad
Swarna Kamal Dutta
Oracle Techno-Functional Analyst
Kolkata
Summary
Results-driven Product Support Analyst with 5+ years of experience in Oracle application support and maintenance within a Client/Server environment. Strong expertise in complex SQL and PL/SQL, including troubleshooting using cursors, views, procedures, triggers, and packages, along with robust error-handling techniques. Adept at analyzing production issues, ensuring timely resolution, and supporting end-to-end SDLC processes. Known for a detail-oriented, collaborative approach and consistently delivering high-quality solutions under tight deadlines.
Overview
6
6
years of professional experience
9
9
Certifications
Work History
Production Support Analyst / Associate
Cognizant Technology Solutions India Pvt. Ltd.
10.2022 - Current
- Provide L2/L3 production support for Oracle customized applications across Finance, Payroll, and eCommerce modules — resolving incidents swiftly to minimize business impact.
- Investigate, triage, and resolve production issues raised via ServiceNow, ensuring adherence to SLA response and resolution targets.
- Lead process optimization initiatives to streamline customer service workflows, reducing manual effort, and improving operational efficiency.
- Automate process flows and modify existing PL/SQL code logic to address recurring issues, and reduce incident frequency.
- Schedule and monitor batch jobs using Appworx and Autosys; validate fixes, and perform root-cause analysis in the event of job failures.
- Conduct weekly data-loading activities for pricing and billing rates, ensuring data integrity across production systems.
- Automate sanity testing processes for the support team, significantly reducing post-deployment validation time.
- Build and maintain Power BI dashboards for activity tracking, operational reporting, and stakeholder visibility — receiving direct client appreciation for dashboard quality.
- Prepare and maintain rulebooks, post-incident reports, and technical support documentation for knowledge transfer.
- Act as a key escalation point during production incidents, and consistently be recognized for rapid and accurate resolution.
- Provided daily support with escalated ticket resolution and liaised with business and technical leads.
- Identified root causes of recurring problems to implement effective solutions.
Programmer Analyst (Development & Support)
Cognizant Technology Solutions India Pvt. Ltd.
09.2021 - 09.2022
- Developed and maintained PL/SQL stored procedures using dynamic SQL to populate data from fact and dimensional tables into temp tables for reporting purposes.
- Participated in application design discussions, translated functional requirements into back-end PL/SQL code, and delivered functionality within project timelines.
- Wrote technical design documents aligned to functional requirement documents, carried out development, unit testing, and transition tasks.
- Supported deployments across Oracle EBS modules, including WO, Payroll, eCommerce, AP, AR, and GL, provided post-release production monitoring.
- Identified and resolved production instance issues promptly, providing instant solutions to reported defects and modules.
- Proficient in rewriting and optimizing existing code logic to improve performance and maintainability.
Programmer Analyst Trainee
Cognizant Technology Solutions India Pvt. Ltd.
08.2020 - 08.2021
- Wrote complex SQL queries to meet customer reporting and data extraction requirements.
- Tested web services, Oracle Applications, and Oracle Reports; completed unit and integration testing for Financials modules.
- Analyzed functional process flows, and proposed upgrades to improve client-side efficiency.
- Involved in designing and developing technical and functional documentation across project phases.
- Debugged errors in scheduled jobs using PuTTY, performing log analysis, and applying targeted fixes.
Intern
Cognizant Technology Solutions India Pvt. Ltd.
01.2020 - 08.2020
- Trained on Oracle E-Business Suite (R12) and RICE (Reports, Interfaces, Conversions, Extensions) concepts.
- Gained hands-on experience with Oracle SQL, PL/SQL, and Python in a live Oracle EBS environment.
Education
B. Tech - Electronics & Communication Engineering
University of Engineering & Management
Kolkata01-2020
Higher Secondary - Computer Science
Patha Bhavan School
Kolkata01-2016
Secondary - General
Patha Bhavan School
Kolkata01-2014
Skills
Experience with database procedures and functions
ERP / EBS: Oracle E-Business Suite R12 — WO, Payroll, eCommerce, AP, AR, GL Modules; Oracle Forms; RICE Concepts
Languages: PL/SQL, SQL (Dynamic SQL, Complex Queries), Python, C, Unix Shell Scripting
Reporting: Service Now and Power BI (Dashboard Creation)
Accomplishments
- Named one of the Best Employees of 2021 at Cognizant, featured in the organizational newsletter.
- Received direct client appreciation for designing and delivering a Power BI activity tracker dashboard.
- Won second prize in the Cognizant organizational hackathon.
- Received multiple recognitions for rapid escalation resolution and production incident management.
- Published a research paper with IEEE: 'Skin Disease Detection based on Different Segmentation Techniques.'
- Ranked First in SQL challenges on Hacker Rank.
- Secured a top rank in NPTEL on Technical English for Engineers — awarded Elite Certificate.
Software
Power Automate
SQL Developer
Oracle Forms
Oracle Apex
Gemini, Co-Pilot
Oracle OCI
Certification
Oracle Data Platform 2025 Foundations Associate
Timeline
Oracle Cloud Infrastructure 2025 Certified AI Foundations Associate
07-2025
Oracle Data Platform 2025 Foundations Associate
06-2025
Oracle Fusion AI Agent Studio Foundations Associate - Rel 1
06-2025
Oracle Cloud Infrastructure 2024 AI Foundations Associate
08-2024
Oracle Financials Business Process Foundations Associate Rel 2
06-2024
Oracle Database SQL Certified Associate
06-2023
Production Support Analyst / Associate
Cognizant Technology Solutions India Pvt. Ltd.
10.2022 - Current
Oracle Cloud Data Management 2022 Foundation Certified Associate
06-2022
Programmer Analyst (Development & Support)
Cognizant Technology Solutions India Pvt. Ltd.
09.2021 - 09.2022
Oracle Autonomous Database 2021 Specialist
02-2021
Oracle Cloud Infrastructure 2020 Foundations Associate
10-2020
Programmer Analyst Trainee
Cognizant Technology Solutions India Pvt. Ltd.
08.2020 - 08.2021
Intern
Cognizant Technology Solutions India Pvt. Ltd.
01.2020 - 08.2020
B. Tech - Electronics & Communication Engineering
University of Engineering & Management
Higher Secondary - Computer Science
Patha Bhavan School
Secondary - General
Patha Bhavan School
CORE COMPETENCIES
- Production Incident Support
- Oracle EBS (R12)
- PL/SQL Development
- Job Scheduling & Monitoring
- Process Automation
- Dashboard & BI Reporting
- SQL Performance Tuning
- SDLC (End-to-End)
- ServiceNow ITSM