Summary

• 6 years of IT Experience as Oracle PL/SQL Developer for System Analysis, Designing, Testing, Development Support of Business Applications using the Oracle Relational Database Management System RDBMS .
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i.
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL Loader.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using PL/SQL in UNIX and Windows environment.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Nested tables and Dynamic SQL.
• Experience in Tuning the application using Explain plan and SQL Trace to optimize the cost and for higher efficiency.
• Good knowledge in front end development using Oracle Forms 10g/9g/6i
• Experience in financial, healthcare and telecom domain.
• Good Experience in Scheduling Jobs in CRON tab and Control-M Jobs.
• Documentation of projects for Functional Requirement Spec FRS , Use case Spec, ER Diagram, Test Plan and Test Script Test Cases.
• Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables.
• Have worked in fast paced AGILE environment attended daily scrum meeting.
• Expertise in handling errors using Exception handling.
• Transferred data using data transfer tools like FTP File Transfer Protocol and SFTP Smart FTP
• Excellent problem solving skills with a strong technical background, Creative, adaptive and result-oriented professional with avidness to learn. Proficient at working as a team player with an aim of contributing towards the team's success.

Technical Skills

Professional Experience

Confidential

Database Developer

Responsibilities:

• Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
• Participated in designing databases schemas and document solutions using FLEXCUBE extensibility framework.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Developed Oracle PL/SQL modules and packages to support extended functions in FLEXCUBE.
• Filtered and Loaded data from different formats of data sources into Database Tables
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Managed functional modules independently and merge work as required per release schedule
• Developed data entry forms, complex and template forms in Oracle Forms 11g.
• Performed and documented unit and integration testing of developed modules and regression testing for subsequent releases.

Environment: Oracle 11g/10g, Oracle Forms 11g/10g, PL/SQL, UNIX, Shell scripting, JIRA, SQL Plus, SQL Loader and PL/SQL developer.

Confidential

Database Engineer

Responsibilities:

• Developed and Modified the PL/SQL Packages, Procedures, Functions and Database Triggers using the oracle advanced techniques Bulk Processing, En-queue and De-queue, Collections
• Validate the source data being processed through DI Jobs to ensure accuracy using a set of SQL queries..
• Optimizing PL/SQL code and SQL queries Using Explain Plan, Analyze, Indexes and Hints .
• Provide timely Production Support by quickly analyzing the root cause and by providing work around to resolve issues.
• Developed ER Diagrams, Data flow diagrams based on the requirement.
• Developed SQL scripts to create database objects like tables, views and sequences.

Environment: Oracle 10g/9i, PL/SQL, UNIX, Shell scripting, XML, Bugzilla, Rational clear case,TOAD and PL/SQL developer.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Prepared the functional document to design business flow using PL/SQL.
• Created/modified various Packages, Stored procedure and functions.
• Creating and executing External tables, error tables, views and stored procedures.
• Creating and executing new package which in turn call all the processes.
• Conducted data analysis on various subsystems.
• Worked on various backend packages with Procedures and Functions using PL/SQL.
• Created packages to be called by Java.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Develop Oracle PL/SQL procedures. Set up Espresso scheduler for all the jobs.
• Created database objects, tables, indexes, writing procedures, SQL scripts
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Perform the application level testing and place the code in UAT to check for any defects due to the code changes.
• Migration of code into production.
• Involved in production support by efficiently debugging the production issues.

Environment: Oracle 10g/9i, PL/SQL, UNIX, Shell scripting, XML, TOAD and PL/SQL developer.

Confidential

Database Developer

Responsibilities:

• Performed exception handling for data that did not conform to the required format.
• Developed Database triggers for making history of insertion, updating, deletion and all kind of audit routines.
• Created and manage to import customer information, product details from organization sales initiatives using the PL/SQL Packages, Procedures and Functions.
• Performed and documented the maintenance, code review and automation

Environment: Oracle9i/8i, PL/SQL, UNIX and PL/SQL developer.

Confidential

Software Engineer

Responsibilities:

• Involved in the development of various enhancements, testing the software, demonstrating the software to clients.
• Support for implemented modules and in development of multilingual utilities.
• Development of forms using Oracle Forms 6i
• Created packages for interfaces with Procedures and Functions using PL/SQL

Environment: Oracle9i/8i, PL/SQL, Oracle Forms 6i, Windows and PL/SQL developer.