SUMMARY:

• Over 9 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Certified Oracle professional with strong knowledge on Oracle Architecture and Database Design.
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Excellent conceptual knowledge of Oracle 12c/ 11g/10g/9i, PL/SQL, SQL *PLUS, SQL Developer, TOAD, PL/SQL Developer.
• Experience in Database design using Normalization .
• Good Knowledge on Anonymous Blocks, Autonomous Transactions, Procedures, Functions, Record Types, Collections, Analytical Functions, Dynamic SQL/PLSQL, Pipelining, Hierarchy Queries, Cursors, Exception Handling and Advanced Queuing.
• E xperience in writing SQL Queries, Sub Queries, Views, Materialized Views, Packages, Triggers, Ref Cursors, Dynamic SQL, Exceptions.
• Experience in designing business requirements and modeling using oracle designer.
• Experience in developing Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning using Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect , Creation of global temporary tables and table partitioning.
• Extreme Use of Exception Handling methods along with Pragma Exception init in order to associate our own created exception names.
• Experience in Migrating from Legacy Mainframe to Oracle.
• Experience in writing Technical Design Documents and Developing Unit Test Documents.
• Experience in working on different applications using UNIX & LINUX Shell Scripting .
• Experience in non - oracle job schedulers like crontab.
• E xperience working in version controlling tools like CVS, SVN, Tortoise to manage project migrations and version controlling.
• Experience in working with Putty Connection Manager.
• Involved in production support activities like batch handling and monitoring.
• Knowledge in data warehousing and dimensional modeling concepts.
• A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

TECHNICAL EXPOSURE:

RDBMS: Oracle Exadata,12c/11i/10g/9i/8i, SQL Server

Oracle: SQL, PL/SQL, Forms & Reports, Apex

Scripting & Scheduling: UNIX Shell, Crontab

Languages: XML, HTML, JavaScript, HTML, C, C++, VB.Net, C#.Net

Tools: PL/SQL Developer, SQL Developer, TOAD, SQL plus, JIRA

Designing Tools: Erwin, Rational Rose

Applications: MS Office tools

Operating System: UNIX, LINUX, Solaris, Windows NT/2000/XP

Methodologies: Agile

EXPERIENCE SUMMARY:

Confidential

Sr. Oracle Developer, Cleveland, OH

Responsibilities:

• Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing in designing business requirements and modeling using oracle designer.
• Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers.
• Developed scripts for Ftp’ing data from Oracle tables to Mainframes.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Collections, Objects for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling.
• Developed DB Links to transfer data across the databases.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Implemented efficient Error Handling process by capturing errors into user managed tables.
• Archived many applications in the existing system and retrieval of necessary data from them.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using Explain Plan.
• Developed UNIX Shell scripts to automate table creation, fetch queries and execute procedures.

Environment: Oracle 11g, SQL Plus, SQL Developer, SQL*Loader, Exadata, UNIX Shell script, MS Access, PLSQL Developer, JIRA, Mainframes, Crontab, Exam diff, JAVA, Windows XP/2000.

Confidential

Sr. Oracle Developer, Tampa, FL

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Used eclipse SVN version control for changing the codes.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Archived many applications in the existing system and retrieval of necessary data from them.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using Explain Plan.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used ORACLE PL/SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PL/SQL, SQL*Loader, UNIX Shell script, MS Access, PLSQL Developer, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, JAVA, Windows XP/2000.

Confidential

Sr. Oracle Developer, Virginia Beach, VA

Responsibilities:

• Involved in analysis, Design, Development phases of the project.
• Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Worked on performance issues and used EXPLAIN PLAN for tuning the queries
• Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.
• Involved in Troubleshooting Performance issues and bugs within packages and stored procedures using dbms output and Explain Plan.
• Performance of the queries is enhanced by executing optimization techniques such as Index Creation, Table Partition and Coding Stored Procedures.
• Involved in developing data conversion programs using SQL *Loader, PL/SQL and UNIX Shell Scripts.
• Development of client side program units and sharing them among multiple applications for processing business logic in the database.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, PL/SQL Developer, Oracle Forms 10g, Reports10g, UNIX, Windows XP/2000.owb 10g.

Confidential

PL/SQL Developer, Grand Rapids, MI

Responsibilities:

• Developed SQL and PL/SQL scripts for problem solving.
• Involved in SDLC including designing, coding and unit testing, Maintained onsite/offshore Coordination between onsite users and offshore project teams.
• Tracking and ensuring timely deliveries as per SLAs committed to the client.
• Interacting with the client and project teams to ensure issue resolution and to provide technological and business solutions to the clients.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Using associative array from Perl programming for indexing and performance issues in UNIX environment.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Used Exception handling extensively for the ease of debugging and displaying the error messages in the application.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX, SQL Developer, Java.

Confidential

Oracle Developer

Responsibilities:

• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Using associative array from Perl programming for indexing and performance issues in UNIX environment.
• Involved in Database Design and Analysis.
• Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing.
• Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 9i.
• Created Control Files and used SQL* Loader to upload bulk data into database from external files.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Involved in Logical and Physical Database design. Identified the tables and relationship between tables.
• Used for all and bulk collect to fetch large volumes of data in PL/SQL objects. Involved in database Performance Tuning and monitoring and involved in Code Standardization and Documentation.
• Developed complex triggers in reports before/after for validation of user input.
• Coordinated between management, users and technical teams for Requirement Gathering.
• Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

Environment: ORACLE 9i, Reports 6i, PL/SQL, SQL* Loader, SQL.