Santhiya Perumal

Seeking a challenging and rewarding position as Oracle SQL, PL SQL Lead.

Oracle PL/SQL senior developer with 9 years of experience in Retail, Energy and Utilities & Banking and Finance areas. I have been successful in delivering technical solutions on various assignments both onsite and offshore that needed high competence in understanding requirements, designing, and developing solutions and leadership skills.

CITI – Enterprise Fraud Detection-App Upgrade, Technical Lead, Oracle SQL, PL/SQL, Unix, CyberArk, Oracle Client, Bitbucket, GIT, Jira, Confluence, ServiceNow, Banking and Finance, 10, Coimbatore, Tamil Nadu, India, 12/01/22, 12/31/23, This project is to upgrade the various applications used for Credit card Fraud Detection in a Bank., Lead the team of 5 for upgrade activities of applications to follow the client's standards., Analyze the impact of upgrading applications to higher version., Define the process for upgrade and perform upgrade activities in lower environments., Follow the clients process to avoid any vulnerabilities caused in the system., Implement the change and deliver within the timeline specified in SPRINT., Perform End-to-End testing post upgrade activities for smooth data transitions., Support and provide suggestion for obtaining and setting up the databases for upgrade. CITI – Complaints Communication from Database, Sr. Developer, Oracle SQL, Oracle Advanced PL/SQL, Bitbucket, GIT, Jira, Confluence, ServiceNow, Banking and Finance, 2, Coimbatore, Tamil Nadu, India, 12/01/20, 12/31/22, This project is to manage communications (Email & SMS) to Clients from Database for Complaint tracking application., Responsible for the end-to-end communication activity from DB., Analyze requirements for the release and provide Implementation suggestion., Develop the communication module using Oracle PLSQL to notify the customers upon their complaints Creation/Closure., Enhanced the communication module source by implementing advanced PLSQL concepts., Implement the change and deliver within the timeline specified in SPRINT., Perform End-to-End testing for the implementation in Development and Integrated Environments., Support and provide solution for the PROD Incidents. CITI – Database Migration, Sr. Developer, Oracle SQL, Oracle PL/SQL, Unix, Microsoft SQL Server, Oracle eGate, GIT, SourceTree, Bitbucket, ServiceNow, Energy and Utilities, 3, Bangalore, Karnataka, India, 03/01/18, 03/31/20, This project is to migrate one of the databases from Sybase to Oracle., Responsible for the end-to-end migration activity., Analyze the source and target database objects., Migrating database objects from Sybase to Oracle., Resolving the issues raised during migration of database objects., Creating users, roles on database and granting privileges., Migration of data from synapse to oracle using Unix shell scripting., Verification of migrated database objects and data using Unix shell scripting. NPOWER – SMART METER IMPLEMENTATION, Sr. Developer, Oracle SQL, Advanced PL/SQL, Oracle Forms, Unix, Microsoft SQL Server, Oracle eGate, SVN, HP ALM, Energy and Utilities, 5, Bradford, West Yorkshire, United Kingdom, 08/24/15, 02/28/18, The project aims to implement the SMART meters in domestic and non-domestic premises in Great Britain., Prepared Functional and Technical design documentation., Lead and Managed offshore team to get the code build done., Automated the data load by using dynamic control file generation., Developed code objects for multiple applications., Written Unit test cases for the requirements., Handled production incidents and provided permanent solution. MORRISONS-EVOLVE RELEASE – WAREHOUSE ROLLOUT, Data Analyst, Data warehousing, Oracle SQL, Oracle PL/SQL, Unix, SVN, Retail, 3, Bradford, West Yorkshire, United Kingdom, 06/04/15, 08/21/15, Evolve Release Warehouse Rollout take business initiatives for the future-ready by replacing the legacy applications., Performed rehearsal for the Data Migration of Warehouse data., Providing resolutions and reports for based on the ad-hoc requests., Attending cutover meetings and presenting the status of the tasks., Providing full time support on rollout. MSONS_DATA, Developer, CRM, Oracle SQL, Oracle PL/SQL, Unix, SVN, CRM, 3, Bangalore, Karnataka, India, 04/01/15, 06/03/15, The aim of the project is to deliver the core elements of CRM strategy., Prepared a data mapping to identify the required data element., Extracted data using Oracle SQL and Unix scripts., Applied code changes to increase the performance of data extraction., SFTP the extracted files to respective team. MORRISONS-EVOLVE RELEASE - MANUFACTURING, Data Analyst, Data warehousing, Oracle SQL, Oracle PL/SQL, Unix, SVN, Manufacturing, 7, Bradford, West Yorkshire, United Kingdom, 02/01/14, 03/31/15, Evolve Release Manufacturing involves implementing the Oracle EBS applications., Developed SQL objects to migrate data for all the sites available., Handled large volume of data load., Loaded data for different Entities into Oracle EBS System., Coordinated with different teams for getting the correct data., Developed a framework using Unix script for deploying the code. MSONS_DATAMIGRATION, Developer, Data warehousing, Oracle SQL, Oracle PL/SQL, Unix, SVN, Morrisons, Retail, 4, Bangalore, Karnataka, India, 01/15/13, 01/31/14, This release is engaged to deliver the functionality of Store Operations system., Prepared/Updated the technical design document., Developed SQL objects and shell scripts based on LLD., Developed a framework using Unix shell script to migrate the data., Generated reconciliation report to validate the data migrated., Analyzed and fixed defects identified during test phase.

I hereby declare that all the information furnished above is true to the best of my knowledge and belief.

• Awarded Technical Maestro Award.
• Awarded twice for Inspiring Performance [Extraordinary Commitment].
• Awarded Inspiring Performance [Tremendous Help and Support].
• Received many appreciations from managers for completing various critical tasks.

Retail, Manufacturing, Energy and Utilities, Banking and Finance, Oracle, SQL Server, SVN, BitBucket, GIT, TFS, Jira, Confluence, Unix shell scripting, UNIX, LINUX, Windows, Oracle Forms