Renold Regan
Trichy
Summary
- Around 8 years of experience with expertise as Oracle PL/SQL in areas of application software development and maintenance in Oracle environment using Client/Server. Good understanding of Business Functionality in the Banking Domain. Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing. Created Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in Windows environment. Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms. Granted resources, privileges and roles to users. Tuned SQL queries using EXPLAIN PLAN, Hints and SQL
- Plus Auto trace report for query optimization. Used SQL
- Loader, Import/Export, UTL_FILE, DBMS_XMLQUERY, DBMS_PIPE and other Oracle built-in packages. Automated SQL
- Loader to load the data from the flat files. Wrote Shell Scripts for scheduling jobs in Windows, regular backups, instance start/shutdown and migrating data into tables. Good experience in Trouble shoots the issues (SQL, PL/SQL). Used ref cursors and collections for accessing complex data resulted from joining of a large number of tables.
Overview
5
5
years of professional experience
Work History
PLSQL Developer and Support Engineer
Capgemini (Patel Soft Technologies)
Chennai
01.2019 - 08.2022
PL/SQL Developer and Support
DESJARDINS
01.2019 - 08.2022
- Work closely with development teams to ensure successful implementation.
- Support refactoring of existing database schemas to support consolidation roadmap.
- Provide post implementation and on-going production support.
- Manage reference data stored in Oracle DBs.
- All should be part of PL SQL Developers for writing stored procedures in Oracle Platform.
- Develop PL/SQL code Data Access Layers for use by client applications.
- Design and implement Extract, Transformation and Load processes, programs and scripts.
- Worked on SQL
- Loader to load data from flat files obtained from various facilities every day.
- Requirement Gathering from Business Analysts and cross-functional teams for application enhancements.
- Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
- Involved in Disaster recovery, Patching activities and Pro-active maintenance for windows servers.
- Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
- Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
- Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
- Created materialized view to increase the performance in data warehousing environment.
- Responsible for identifying any bugs occurring in the application as well as fixing them.
- Worked on enhancements and bug fixes.
- Develops innovative and creative output based on interpretation and analysis.
- Participates and may lead critical projects, customer engagements or business processes.
- Provides design and documentation at an application or function capability level.
- Participates in establishing and maintaining application standards and processes.
- Effectively communicates application and technical direction to the business and within the customers IT organization.
- Advises on issues of systems integration, compatibility, scalability and multiple platforms.
PLSQL Developer
JEONBUK BANK
12.2017 - 01.2019
- Designing and creating database tables, indexes, views, synonyms, packages, procedures, functions, DB triggers and other schema objects in oracle.
- SQL queries, Triggers and stored procedures development.
- Defining the requirement and Preparing technical specifications.
- Daily Jobs analysis and constructions.
- PL/SQL Scripts for the backfill and yearly database maintenance.
- Writing SQL queries to manipulate, retrieve, search and extract information on solution in the oracle database.
- Written batch scripts needed for the project.
- Written control files for SQL loader to load the input data to interface tables.
- Prepared dependency diagrams for the legacy and new databases.
- Compared legacy and new databases and find out the columns and table names and added to the new database to fulfill the requirements.
- Mapping of columns between legacy and new databases.
- Preparing the scripts for new database.
- Created tables in the new database.
- Performed code debugging and verification.
Education
Master of Information Technology -
Bharathidasan University
TrichyProjects
DESJARDINS, 01/01/19, 08/31/22, Oracle 10g, 11g, SQL Developer, Toad, PL/SQL Developer and Support, Work closely with development teams to ensure successful implementation., Support refactoring of existing database schemas to support consolidation roadmap., Provide post implementation and on-going production support., Manage reference data stored in Oracle DBs., Develop PL/SQL code Data Access Layers for use by client applications., Design and implement Extract, Transformation and Load processes, programs and scripts., Worked on SQL Loader to load data from flat files obtained from various facilities every day., Requirement Gathering from Business Analysts and cross-functional teams for application enhancements., Used Bulk Collections for better performance and easy retrieval of data., Involved in Disaster recovery, Patching activities and Pro-active maintenance for windows servers., Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart., Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package., Created records, tables, collections for improving Query performance., Created materialized view to increase the performance in data warehousing environment., Responsible for identifying any bugs occurring in the application as well as fixing them., Worked on enhancements and bug fixes., Develops innovative and creative output based on interpretation and analysis., Participates and may lead critical projects, customer engagements or business processes., Provides design and documentation at an application or function capability level., Participates in establishing and maintaining application standards and processes., Effectively communicates application and technical direction to the business and within the customers IT organization., Advises on issues of systems integration, compatibility, scalability and multiple platforms. JEONBUK BANK, 12/01/17, 01/31/19, Oracle 10g, SQL Developer, PLSQL Developer, Designing and creating database tables, indexes, views, synonyms, packages, procedures, functions, DB triggers and other schema objects in oracle., SQL queries, Triggers and stored procedures development., Defining the requirement and Preparing technical specifications., Daily Jobs analysis and constructions., PL/SQL Scripts for the backfill and yearly database maintenance., Writing SQL queries to manipulate, retrieve, search and extract information on solution in the oracle database., Written batch scripts needed for the project., Written control files for SQL loader to load the input data to interface tables., Prepared dependency diagrams for the legacy and new databases., Compared legacy and new databases and find out the columns and table names and added to the new database to fulfill the requirements., Mapping of columns between legacy and new databases., Preparing the scripts for new database., Created tables in the new database., Performed code debugging and verification.
Disclaimer
I hereby declare that the information and details provided in this resume are correct and inclusive to the best of my knowledge and belief.
Technical Exposure
- Oracle 10G, 11G, 12C, Windows Environment, Oracle SQL
- Plus, SQL Developer, TOAD, SQL
- Loader, Database Export & Import, SQL, PL/SQL, Shell Scripting, .Net
Personal Information
- Father's Name: Antony Samy
- Date of Birth: 12/03/90
Timeline
PLSQL Developer and Support Engineer
Capgemini (Patel Soft Technologies)
01.2019 - 08.2022
PL/SQL Developer and Support
DESJARDINS
01.2019 - 08.2022
PLSQL Developer
JEONBUK BANK
12.2017 - 01.2019
Master of Information Technology -
Bharathidasan University