Aswany Balachandran
Bengaluru
Summary
Detail-oriented ORACLE PL/SQL Developer with 4 years of experience in analyzing, designing, and implementing business applications using Oracle RDBMS. Expertise spans all phases of SDLC and includes advanced PL/SQL skills in DML, DDL, and performance tuning. Background in Pharmacovigilance, Healthcare, and E-retail, with proven ability to troubleshoot and resolve technical issues while delivering L2 and L3 application support in Agile settings.
Overview
4
4
years of professional experience
Work History
Consultant
SymphonyAI
07.2024 - Current
- Developed and optimized Oracle SQL and PL/SQL queries for high-volume transactional systems.
- Automated data extraction requests and monitoring activities, improving operational efficiency.
- Monitored application health with Centreon, proactively addressing issues to minimize downtime.
- Delivered L2/L3 production support for enterprise e-Retail platforms, optimizing sales and inventory data management.
- Handled incidents and changes while ensuring compliance with SLA requirements.
- Supported CI/CD processes and release activities utilizing Azure DevOps and secure access via PAM.
- Investigated data discrepancies in product, supplier, store, and transaction data, implementing necessary fixes.
- Managed batch jobs using Control-M, Cron, and Cronicle for efficient processing.
Associate
Cognizant Technology Solutions India Private Limited
11.2021 - 06.2024
Project #1 : PL/SQL Developer
AstraZeneca
12.2022 - 06.2024
- Crafted PL/SQL stored procedures, functions, packages, cursors, and triggers to enforce business logic.
- Executed complex subqueries, unions, intersections, and aliases to enhance SQL performance.
- Applied analytic and aggregate functions alongside case statements in intricate SQL queries.
- Created indexes on tables to accelerate data retrieval and improve database performance.
- Developed database objects—tables, views, synonyms, indexes, sequences—to align with business requirements.
- Implemented table-level constraints to ensure data integrity across multiple datasets.
- Utilized inner joins, outer joins, cross joins to construct effective complex SQL queries.
- Established records, tables, and collections including nested tables and arrays to enhance query efficiency.
- Loaded Data into Oracle Tables using SQL Loader.
- Good Knowledge of error handling using Exception Handling
- for the ease of debugging and displaying the error messages
- in the application.
Project #2: PL/SQL Developer
CVS Health
05.2022 - 12.2022
- Created PL/SQL stored procedures, functions, and packages, enhancing execution of business logic.
- Developed packages to efficiently retrieve complex data from remote databases through joins and subqueries.
- Utilized collection objects and bulk collect methods while writing SQL queries.
- Conducted unit testing and performance testing for optimal functionality.
- Managed user-level permissions by granting and revoking access to ensure data security and compliance.
Project #3: PL/SQL Developer
Express Scripts Canada
11.2021 - 05.2022
- Provided technical support for database troubleshooting, resolving issues to enhance system reliability.
- Developed test cases for unit testing of new and existing PL/SQL code.
- Debugged existing PL/SQL code, effectively fixing bugs to improve application performance.
- Documented processes and technical specifications, creating resources for reference and training.
Education
B Tech - Computer Science and Engineering
CUSAT
Skills
- Oracle
- Windows
- UNIX
- SQLDeveloper
- Visual Studio
- Centreon
- Control-M
- Azure DevOps
- Cronicle Job Schedular
- ServiceNow
- PuTTY
- CloudBerry Explorer for Amazone S3
- Oracle BIP
- GitHub
- Bitbucket
- FileZilla
- WinSCP
- Azure IAM
- AWS Console EC2
- Oracle SQL
- PL/SQL
- Shell scripts
- LINUX
Accomplishments
Won Associate of Quarter award for excellent and dedicated performance, two times.
Disclaimer
I ASWANY BALACHANDRAN hereby declare that the information furnished above is true up to the best of my knowledge.
Personal Information
Date of Birth: 05/05/1994
Timeline
Consultant
SymphonyAI
07.2024 - Current
Project #1 : PL/SQL Developer
AstraZeneca
12.2022 - 06.2024
Project #2: PL/SQL Developer
CVS Health
05.2022 - 12.2022
Associate
Cognizant Technology Solutions India Private Limited
11.2021 - 06.2024
Project #3: PL/SQL Developer
Express Scripts Canada
11.2021 - 05.2022
B Tech - Computer Science and Engineering
CUSAT