SUMMARY

• 7 years of experience in analysis, designing, developing and implementing database applications and solutions as Oracle PL/SQL Developer.
• Excellent skills in designing and development of applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL, Oracle Forms 11g/10g/9i/6i, Oracle Reports 11g/10g/9i/6i, Oracle APEX3.0/4.0, BI Publisher.
• Expert in Oracle tools like SQL * PLUS, SQL Developer.
• Highly proficient with Oracle applications development tools within a client/server environment.
• Excellent SQL skills, expertise in writing Complex SQL queries, PL/SQL Stored Procedures, Functions and Packages for business needs.
• Expertise in creating Oracle objects like Tables, Synonyms, Triggers, Indexes, Views, Materialized Views and Table Partitions.
• Proficient in advance features of Oracle for PL/SQL programming like using cursor variables, Ref. cursors, Varrays, nested tables and Dynamic SQL.
• Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, FORALL statements, and Troubleshooting Oracle database issues.
• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader.
• Good knowledge of Data Modeling, Data Warehousing concepts, OLAP Concepts, Star Schema, Snowflake Schema, and Entity - Relationship Diagrams.
• Excellent Database modeling/designing skills using Erwin, ER Studio, SQL Developer Data modeler.
• Experience in designing and development of Oracle Forms and Reports.
• Worked in various levels of SDLC (System Development Life Cycle) which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Ability to perform well as a Team Member to blend well in any situation and environment.

TECHNICAL SKILLS

Database Tools: SQL*Plus, SQL Developer, SQL Navigator, Toad, APEX, Erwin Data Modeler, EXCEED

Databases: Oracle 11g/10g/9i

Operating System: Windows 7/XP/VISTA/2000/98, Unix, Linux

Languages: SQL, PL/SQL, C, C++, Python, Unix Shell Scripting

GUI: Oracle Forms 6i/9i/10g/11g, Oracle Reports 6i/9i/10g/11g, BI Publisher

ETL Tools: SQL*Loader, Informatica Power Center

Applications: MS Office, Adobe Photoshop

PROFESSIONAL EXPERIENCE:

Confidential, Harrisburg, PA

Senior Oracle Developer

Responsibilities:

• Developed new Forms and reports using Oracle Forms builder 11g and Reports Builder 11g.
• Worked on numerous problem logs which where accumulated over the years and fixed them
• Converted Oracle reports into BI Publisher.
• Create reports for batch processing.
• Spoke to the users directly to gather the required information and specifications of how each and every form should be like.
• Modified and created UNIX shell scripts.
• Worked on different modules at the same time.
• Worked on Application level Performance tuning.
• Solved the issues on various modules that were already in production.
• Extensively Developed database triggers, packages, functions, and stored procedures using PL/SQL.
• Used Validation Controls and Custom validation control to validate Web forms.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.

Environment: Oracle11g, Toad, Exceed 14, SQL*LOADER, Oracle Forms 11g, Oracle Reports 11g, BI Publisher 11g.

Confidential, Fort Worth, TX

Oracle Developer

Responsibilities:

• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the Database.
• Designed and developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
• Generated Reports as per the business requirements.
• Developed forms using Oracle Form Builder 10g, created item/form/block level triggers used in Oracle Forms.
• Used forward engineering in Data modeler to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Used Reverse Engineering in Erwin Data modeler and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Used Informatica Power center 8.6 for loading flat files into the database.
• Expert in creating UML diagrams including Use Case Diagrams, Class Diagrams, Sequence Diagrams and Activity Diagrams.
• Responsible for the detail design documentation, development, unit testing and maintenance of internally developed applications.
• Worked with built in Oracle Packages (DBMS SQL, DBMS OUTPUT, DBMS XML and others).
• Created and maintained different constraints on database and developed triggers to maintain database integrity.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Experienced in tracking Project Status, Publishing Status Reports, Managing Scope, Time and Cost.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Used DBMS SCHEDULER for jobs scheduling.

Environment: Oracle11g, Informatica Power Center 8.6, Erwin Data Modeler 8, PL-SQL, SQL*Loader, SQL Navigator, Oracle Forms, Oracle Reports, TOAD.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Creating and managing schema objects such as tables, views, synonyms, packages.
• Maintaining Referential Integrity.
• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on Oracle Application.
• Developed SQL scripts to Insert/Update and Delete data in Oracle database tables.
• Analyzing the existing reports and modifying the reports specific to new requirements.
• Interacting with the business users and application owners on their requirements on Merchant data.
• Modified several existing reports and also developed new Merchant reports using BI publisher.
• Developed and modified forms using oracle Forms 10g.
• Wrote complex SQL queries using Joins, Sub queries and Group functions.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Created shell scripts in UNIX for job scheduling and batch processing.
• Created number of database Triggers according to business rules using PL/SQL.
• Preparation of Stored Procedures and User Defined functions.
• Created Indexes to speed up the queries.
• Improved the performance of the system by tuning queries using using Explain Plan, Tkprof, Hints and indexes
• Migration of data from different data sources using SQL* LOADER.

Environment: Oracle forms 10g, Oracle Reports 10g, BI Publisher, SQL*LOADER, PL/SQL, SQL*PLUS, Unix Shell Scripting, TOAD.

Confidential, Edison, NJ

Oracle Developer

Responsibilities:

• Involved in the design of Database Schemas.
• Developed SQL loader scripts.
• Involved in Migration of data from MS SQL into Oracle.
• Created PL/SQL code to upload data as XML files.
• Responsible for creating the database triggers to enforce several business roles.
• Mentored the team on tuning.
• Mentored for best PL/SQL practices.
• Developed several PL/SQL packages.
• Performed SQL Tuning using SQL Trace Explain Plan for better performance.
• Involved in migrating data testing.
• Used external tables.
• Used UTL FILE packages.

Environment: PL SQL, Oracle 10g, MS Word, MS Excel, Oracle Reports, Oracle Forms.

Confidential

Oracle PL/SQL consultant

Responsibilities:

• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts.
• Worked with users and application developers to identify business needs and provide solutions.
• Created Database Objects, such as Tables, Indexes, Views, and Constraints.
• Enforced database integrity using primary keys and foreign keys.
• Tuned pre-existing PL/ SQL programs for better performance.
• Created many complex SQL queries and used them in Oracle Reports to generate reports.
• Implemented data validations using Database Triggers.
• Used import export utilities such as UTL FILE for data transfer between tables and flat files
• Performed SQL tuning using Explain Plan.
• Provided support in the implementation of the project.
• Worked with built-in Oracle standard Packages like DBMS SQL, DBMS JOBS and DBMS OUTPUT.
• Created and implement report modules into database from client system using Oracle Reports as per the business requirements.
• Used PL/SQL Dynamic procedures during Package creation.

Environment: Oracle 9i, Oracle Reports, SQL, PL/SQL, SQL*Plus, SQL*Loader, Windows XP.