Highlights

OBJECTIVES

SQL and PL/SQL Developer with 5 years of programming experience as SQL and PL/SQL Developer in Analysis, Design and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS) and looking for challenging role to contribute my skills to a dynamic organization.

PROFESSIONAL SUMMARY

• Strong technical expertise in creating and maintaining database objects like tables, views, mviews, sequences, synonyms, indexes using Oracle tools like SQL developer & toad.


• Proficient in updating procedures, functions, triggers based on business requirements.


• Good in migrating data from flat files to tables using SQL*Loader.


• Built complex queries using SQL and wrote stored procedures using PL/SQL.


• Used cursors and collections for accessing complex data resulted from joining many tables.


• Proficient in advance features of Oracle 11g for PL/SQL programming using records and collections, bulk bind, Cursors, nested tables, and dynamic SQL.


• Good hands-on experience with performance tuning for Oracle RDBMS using explain plan.


• Ability to work as team player towards successful delivery of the project.


• Good client facing skills, interpersonal skills, self-motivated and consistent learner.

Skills

Primary Skills

SQL

SQL Queries

Secondary Skills

Data Migration

PSQL

Projects

Project 1. - IT Industry (34 months)

Responsibilities:






• Worked on transactions control system which involves fund transfer between various accounts.


• Worked on self-service daily transactional limit change, withdrawal limit control based on account types.


• Audit control of user/account creation workflow and user actions using triggers.


• Worked on design, architecture, and development in real-time within bank fund transfer.


• Communicated issues and progress to project manager and excellent interpersonal, analytical skills and strong ability to perform as part of a team.






 

Project 2. - IT Industry (28 months)

Responsibilities:






• Collaborated with a team to develop and maintain database procedures for patient and healthcare facility management.


• Designed and executed complex SQL joins to retrieve patient and facility details, delivering accurate and timely reports to end-users.


• Implemented patient identifiers and facility combination validation to prevent duplication, ensuringdata quality and consistency.


• Worked closely with end-users to gather requirements and provide technical support for database-related issues.


• Conducted regular code audits and performed troubleshooting to resolve issues promptly and maintain data integrity.