OBJECTIVE:

• Dedicated and motivated experienced IT Professional seeking for oracle PL/SQL developer position.

SUMMARY

• 8+ Years of IT experience as anOracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) and in providing business intelligence solutions in data warehousing using Informatica Powercenter (9.x versions) as ETL tool.
• Expertise in Software Development Life Cycle from Requirement Gathering, Analysis, Design, Conversion of business requirements into high level Functional Specification, Coding, Testing, Deployment to Production Support.
• Strong work experience in Oracle Database (11g) Stored Procedures, Packages, Functions, Tables, Ref Cursors, Constraints, Triggers, Indexes - B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Dynamic SQL, Table functions, Collections, analytical functions.
• Undergone internal training on Oracle Fusion Forms in Confidential .
• Expertise in Dynamic SQL, Collections and Exception handling.
• Hands on experience in SQL Query fine tuning and utilizing SQL Loader utility.
• Exposure in using tools like TOAD, SQL Developer for writing PL/SQL programs.
• Hands on Data Modelling using Toad.
• Efficient team member with excellent work/time management skills, excellent leadership, communication and interpersonal skills and ability to work under strict deadlines.
• Experience in working with Waterfall and Agile methodologies.

TECHNICAL SKILLS

Skills: Spreadsheet Management, Time Management, Ordering Process, Customer service Oriented

Programming Languages: MySQL, XML, TOAD Oracle, Oracle 11g,12c,9i, UNIX, J2EE, LINUX shell scripting

Business Intelligence tools: Tableau, Business Intelligence Development Studio (SSIS/SSRS), Informatica Power Center 7.1/8.6/9.1.

Data Base: Server 2000/2005/2008/2008 R2/2012, MS Access

Operating Systems: XP, Windows NT / 2000. Windows Server 2003/2008/2008 R2, Linux

Reporting Tools: Tableau 8.x, Excel, Qlik view, Crystal Reports

Scripting language: JavaScript, HTML, CSS

PROFESSIONAL EXPERIENCE

Confidential - Arizona

PL/SQL Developer

Responsibilities:

• Designed and developed database packages, procedures, functions and triggers on Oracle databases.
• Usedbulk collectionin PL/SQL objects for improving the performance.
• Performed Data Modelling for schema design for the new tables using TOAD.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• UsedPragma Autonomous Transactionto commit the child transactions without affecting the parent transaction commit status.
• Creating Stored Procedures to delete existing data from the tables before loading in Staging area.
• Part of the PL/SQL team to perform the ETL tasks.
• Designed and developed mappings using transformations such as Joiner, Expression, Aggregate, Rank, Lookup, Update Strategy, Union, SQL, Filter and Router to in corporate business requirements.
• Completing the unit, system, user acceptance testing, and implementing the changes in production.
• Documented the process and the problem resolution RPS (Rapid Problem Solving) using fish bone process.
• Involved in conducting knowledge transfer sessions with other counterparts who will also be supporting the applications.
• Worked on support requests/tickets regarding the applications. This involved investigation and enhancements/modifications to the code.
• Served as a coach and mentor to help more junior team members develop their technical skills.
• Received a special appreciation certificate from the client for the excellent work done by me at the client location.

Environment: Oracle SQL, Oracle PLSQL, UNIX and Informatica Data Quality

Confidential - Pleasanton, CA

Senior Oracle Developer

Responsibilities:

• Involved in assisting the team members in understanding the business flow.
• Enables the team members in bug fixing.
• Provided production support all the way.
• Implementation/Go-Live support & Knowledge Transfer.
• Worked on Complex forms migration.
• Worked on Performance and tuning of SQL and PL/SQL.
• Documenting the resolution steps to the issues.
• Responsible for Unit Testing, User Acceptance Testing.
• Reviewing the code developed by Team members.
• Involved in daily Scrum meetings.
• Testing and debugging the functional flow and made the necessary modifications to meet the end user requirements.

Environment: Oracle Forms, Oracle Reports, Oracle SQL, Oracle PLSQL and UNIX.

Confidential, CA

PL/SQL Developer

Responsibilities:

• Design and Development of data validation, load processes, test cases usingPL/SQL, Stored Procedures, Data manipulation, Functions, Triggers, Cursors using Oracle 11g.
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
• Used SQL*Loaders to download the data into warehouse database from the flat files and other data files across different platforms.
• Developed Ref Cursors to accommodate the business rules.
• CreatedTables, Views, Materialized views, and constraints.
• Create Oracle Stored Procedures to implement the ETL Process control logic.
• Created Oracle Stored Procedures for Segment Dimension which holds all the dimension keys.
• Designed Oracle views that generate these extracts for upstream applications and created ETLs to read these views and drop them in a file.
• Documented all the ETL and Oracle Procedures developed.
• Designed and developed the Forms and Reports for the user Interface.

Environment: Oracle Database 11g, Windows XP, SQL Loader, Crystal Reports, UNIX, SQL Developer, PL/SQL Developer Oracle 11g, XML, SQL.

Confidential

Oracle Developer

Responsibilities:

• Involved in Database Design and Analysis.
• Design and Developed data validation, load processes usingStored Procedures, Functions, and Triggers using Oracle 9i
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Involved in Logical and Physical Database design.
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• 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: Toad Oracle, Excel, MS SQL Server 2005, UNIX, LINUX