SUMMARY

• Over 7 years of experience in the development of client/server and multi tired applications using Oracle Database, SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX.
• Involved in Design, development, implementation, testing, support and documentation of business applications using Oracle technologies.
• Strong knowledge on oracle architecture and database design concepts like Normalization and ER Diagrams.
• Extensively used PL/SQL to build Oracle Packages, stored procedures, functions, triggers, cursors, ref cursors, views for processing data, enforcing referential integrity and needed business rules.
• Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Compound triggers, Materialized Views.
• Knowledgeable in client - server technology, GUI design, and Relational Database Management.
• Experienced with DBA activities like granting and revoking privileges on database objects.
• Experienced in Tuning SQL and PL/SQL code for better performance with large volume of data.
• Strong knowledge on Oracle Forms and Reports.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Worked in Manufacturing Process, Banking Information Systems, and Health Care Management domains on various applications.
• Worked in various levels of SDLC (System Development Life Cycle) which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
• Tested deliverables for conformance with requirements and specifications, including Unit, Module, Integration and System testing.
• Quick learner with ability to master new concepts and applications.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals Confidential all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.

TECHNICAL SKILLS

Databases: Oracle 11g/ 10g/ 9i/ 8i, MY SQL, DB2, MS ACCESS

Languages: SQL, PL/SQL, C, C++,Java, Visual Basic

Tools: TOAD, SQL Developer, Oracle Enterprise Manager, SQL*Plus, SQL*Loader, Serena, Kintana, Maestro, Discoverer, MS Office, Open Office

Internet Technologies: HTML, Javascript, XML,PHP, Drupal, CSS, DHTML.

Scripting: Unix shell scripting, Java Script

Operating Systems: UNIX, LINIX, Windows VISTA/XP/2000/98, MS DOS, MAC

PROFESSIONAL EXPERIENCE

Confidential, Middletown, NJ

Oracle Developer

Responsibilities:

• Created and modified complex functions, stored procedures, packages and Triggers by using Oracle PL/SQL based on the business rules.
• Extensively worked on Schema Migration, Database Program Migration, Data Migration from Sybase to Oracle by using Oracle SQL Developer.
• Extensively Used Oracle SQL *Loader to convert the data from CSV to Oracle Tables.
• Used Oracle BI Tools like Discoverer for the scheduling purpose and to generate the schedule reports.
• Worked on SQL Tuning by using various tools like TKPROF, EXPLAINPLAN, DBMS PROFILER, Hints etc.
• Worked on Dynamic SQL by using Execute Immediate and DBMS SQL along with Bulk Collect.
• Extensively used PL/SQL advanced features like forward declaration, Procedure Overloading in the PL/SQL Packages.
• Extensively used various PL/SQL features like Cursors, REF Cursors, Collections, Autonomous Transactions, Bulk Binding along with the various Exceptions in the PL/SQL Stored Procedures.
• Used UTL FILE PACKAGES for writing DBMS OUTPUT into the files.
• Extensively used Oracle 11g features like RESULT CACHE, Compound Triggers etc.
• Worked on Table partitioning and Index creation to improve the performance of the query.
• Worked on tickets to fix the issues reported by the different users.
• Worked with DBA’s regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
• Worked with the front end programmers to check the database changes on the Oracle ADF.
• Worked with Oracle development team to develop the design requirements

Environment: Oracle 11g/12c, WINDOWS 7, SQL, PL/SQL, SQL *Loader, SQL Plus, SQL Developer, Oracle Discoverer, Oracle ADF.

Confidential, Charlotte, NC

PL/SQL Developer

Responsibilities:

• Requirements gathering from end users.
• Responsible for developing database objects - Functions, Procedures, Packages, Cursors, Triggers etc.
• Worked on tickets to fix the issues reported by the end users.
• Optimizing the performance using PL/SQL table types and record types.
• Worked on table partitioning and index creation for the performance improvement.
• Extensively worked on complex SQL queries using joins, sub queries, correlated sub queries and analytical functions.
• Extensively used advanced PLSQL features like BULK COLLECT, FORALL, REF CURSORS, COLLECTIONS data types in the procedures, functions.
• Designing the data model (logical/physical) by creating new objects and by using existing objects of the data mart as per the business requirements.
• Developed SQL scripts for Extraction, transformation and Loading of Data and designed source Entities for Oracle.
• Generating software upgrade scripts for cross functional teams.
• Highly involved in writing Test Cases and Unit Analysis and Testing (UAT) to test each and every logical branch of the stored Procedure.
• Wrote SQL queries to developed test data for use during test execution.
• Worked on various levels of SDLC (Software Development Life Cycle) including system analysis, high level design, detailed design, coding and testing.
• Involved in the preparation of Technical Specification Documentation.
• Analyzing the performance of the SQL queries and created the scripts for indexes

Environment: Oracle 11g, WINDOWS 7, SQL, PL/SQL, Toad, Visio, SQL Developer.

Confidential, Raleigh, NC

PL/SQL Developer

Responsibilities:

• Worked with the Business analysts for gathering and business analysis.
• Understanding logical modeling and physical modeling of application.
• Involved in meetings with end users on enhancement issues for gathering the requirements and communicating the same to development teams.
• Customized SQL scripts, packages, procedures, cursors, tables, views, Reports, Forms, materialized views and functionsas per the business requirements.
• Customized various Forms and Report according to the requirements.
• Testing of production fixes in the test environments to ensure they have resolved given issue as well as ensure production fixes do not cause other issues.
• Worked on the designing by using tools like Erwin.
• Worked on scheduling by using tools like Maestro.
• Ability to design, develop, and conduct unit test plans to ensure application code is functioning correctly.
• Monitor operational environment to ensure internal and customer Service Level Agreements are meet.
• Deployed Oracle Forms and Reports into Query Direct on daily basis.
• Proficient in debugging PL/SQL packages, procedures, functions, triggers, cursors, materialized views to troubleshoot issues.
• Performed Code Optimization and Performance Tuning of the application using Explain Plan, TKPROF, Indexing and Partitioning of tables.
• Patient dealing with demanding users coming from different cultures and countries.
• Worked in cross function teams based in various parts of the globe.

Environment: Oracle 10g, SQL Developer, TOAD, Maestro, Query Direct, SQL Plus, Forms & Reports 10g.

Confidential, Mequon, WI

PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for gathering, business analysis, testing, metrics and project coordination.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from flat files.
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functionsas per the business requirements.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Used the standard Oracle packageDBMS SCHEDULERto automate / schedule jobs on daily, weekly and monthly basis and to run jobs in parallel to improve time-constrained performance.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
• Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.

Environment: Oracle 11g/10g, SQL * Plus, TOAD, SQL*Loader, UNIX.

Confidential, Florence, SC

Oracle Developer

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements.
• Analyzed Financial Markets Data and mapped Source Systems Data to Finance Data warehouse.
• Created system design document with high-level design and requirement document. Conducted walk through for requirement and system design.
• Created and modified SQL, PLSQL and SQL*Loader scripts for data conversions to load data from flat files into oracle interface tables.
• Developed SQL Queries to fetch complex data from different tables from different databases using database links and inserted the results into the newly developed tables.
• Created views, materialized views and synonyms for developers to hide the complexity and secure the direct access of DB Tables.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the Design Documents.
• Involved in uploading and downloading of the flat files from UNIX server using FTP.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.
• Worked on Data Modeling tool which includes both Logical and Physical Models.
• Generated UNIX Shell scripts to automate Batch Jobs and Loading Process.

Environment: Oracle10g/9i,SQL,PL/SQL,Toad,SQL*Loader,WinXP,UNIX.

Confidential, Dallas, TX

Oracle Developer

Responsibilities:

• Developed PL/SQL stored procedures, packages, and triggers for data load and transformation, and data extraction.
• Extensively used sub queries and joins while writing stored procedures.
• Involved in extensive coding using Oracle PL/SQL.
• Used Oracle Forms 10g to design and develop the interface for the system.
• Created Packages to automate transactions from the Oracle Forms.
• Designed, developed various reports using Reports 10g.
• Tuned and Optimized the SQL statements using Explain Plan and SQL trace utilities.
• Created Shell scripts to automate the loading of data from Text files to Oracle tables.
• Used bulk collections for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• SQL*Loader was used to load the data from the flat files to database tables.
• Developed batch jobs, shell scripts to automate file transfers, data cleansing, loading and final data processing.
• Scheduled batch jobs, shell scripts in AutoSys to run Confidential a specified times as per the requirements for each application.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Used UTL File Packages to Load data from Excel Sheet to Oracle tables.
• Created matrix reports using Oracle Reports 10g.
• Performed the unit testing for procedures, functions and packages.

Environment: Oracle 10g, UNIX, PL/SQL, SQL*PLUS, SQL*Loader, Forms 10g and Reports 10g.

Confidential

Oracle Developer

Responsibilities:

• Development of user interface windows for sales order processing, invoicing, customer billing & inventory.
• Validation rules were implemented by writing procedures during data input.
• Created Custom reports using Reports Builder 6i.
• Created stored procedures, Packages, Functions and triggers using SQL & PL/SQL.
• Developed database triggers where ever necessary.
• Involved in analyzing user/business requirements and mapping into technical specifications.
• Performed in depth of data analysis and prepared weekly, biweekly, monthly reports by using reports 6i.
• Implemented a whole new security for the reports in the oracle database to prevent confidential data from being displayed to all users. The security is based on the standard concept of roles and privileges.
• All the security roles and privileges are stored in the database tables and the logic is implemented using functions and views. Promoted the security feature to the existing reports with a very minor code change in the actual reports.