Professional summary:

• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Having 7 plus years of experience in programming as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS .
• Implementation and technical expertise in Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Good Knowledge on Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL PLUS, TOAD and SQL LOADER.
• Good exposure to all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Strong knowledge in Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Experience in Tables, Views, Constraints, Index B Tree, Bitmap and Function Based .Extensive experience in SQL, PL/SQL, Developer 2000 Forms 6i/9i/10g, Reports6i/10g , UNIX Shell Scripts, SQL Loader, XML Publisher and Oracle 8.x/9.x/10g.
• Having good Experience materialized views for data replication in distributed environments.
• Expertise in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables and Dynamic SQL, Collections and Exception handling.
• Experienced in Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• On-site coordination experience and worked with offshore team during knowledge transfer and development support.

Technical skills:

• Languages: - SQL, PL/SQL, JAVA, HTML, UNIX Shell Scripting, XML.
• Tools: - SQL Plus, SQL Loader, Toad, SQL Developer.
• RDMS: - Oracle 10g/9i/8i, MS Access.
• Operating systems: - SUN Solaris, HP-UX, UNIX, Windows.
• Fusion Middleware: - Oracle SOA 10/11g, BPEL, OWSM, OSB 10g.
• Reporting Tools: - Oracle Discoverer 10g/4i, XML Publisher, Oracle Reports6i/10g.
• Professional Experience:-
• Professional Experience:-
• SRA International INC. Windsor Mill, MD
• Oracle PL/SQL Developer

Responsibilities:

• Developed Customer and Supplier Conversion Program by using oracle standard Public APIs.
• Designed and remediated payables and cash management reports using report builder 10g to meet the requirements of the clients.
• Extensively used triggers like Report triggers, Layout triggers, Data triggers in reports.
• Performed Unit Testing and Performance Testing for reports.
• Designed reports using XML Publisher BI Publisher
• Built custom forms using TEMPLATE.FMB to fulfill the business requirements and also implemented the calendar feature, WHO columns, defining DFFs etc.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
• Designed /developed /modified tables, views, materialized view, stored procedures, packages and functions.
• Extensively worked on Cursors, PL/SQL Tables on TOAD in the interface development and used exceptions where ever necessary to improve the performance.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Good understanding of database objects and ability to triage issues.
• Customized the standard forms in application modules using CUSTOM.PLL for hiding the fields, changing the visual attributes prompts of the fields
• Development Includes analysis of functional Spec MD50 and writing technical Spec MD70 for all the objects I developed.
• Developed good understanding of HIGLAS for CMS custom business flows and high level overview of the Medicare and Insurance system.

Environment: Oracle 10g, Pl/SQL, SQL Plus, TOAD, Oracle Forms 10g, Oracle Reports 10g, SQL Navigator, EBS R12, Power Builder, Shell scripting.

Confidential

Oracle Senior PL/SQL Developer

Responsibilities:

• Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
• Designed Web-based Internet applications linked to firm-wide SQL databases.
• Creating and debugging of packages and procedures and functions and troubleshoot jobs using the debugging tool.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Involved in analysis, coding, testing and Implementation of various modules and reverse engineering of the application using Erwin. Used Erwin to transform data requirements into data models.
• Automated data loading, extraction, reports generation using UNIX Shell scripting and loading data by using SQL Loader to custom tables.
• Worked on materialized views, DBMS SCHEDULER for scheduling jobs and UTL MAIL to send mails using oracle 10g.
• Implemented shell scripts for trouble shooting Oracle Errors with the help of trace files and scheduled them.
• Involved in writing the UNIX shell scripts.
• Analyzed tables and indexes for performance tuning.
• Configured database performance tools such as Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.
• Used Oracle Enterprise Manager, TOAD for developing and managing PL/SQL scripts.

Environment: Oracle 10g, Pl/SQL, SQL Plus, TOAD, Oracle Forms 6i, Oracle Reports 6i, MS Excel, SQL Navigator, Power Builder, Shell scripting.

Confidential

Oracle Senior PL/SQL Developer

Responsibilities:

• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on table partitioning Range and List and deploying local indexing on portioned tables.
• Involved in the design, data modeling and development and testing phases of various projects and enhancements.
• Extensively worked in writing SQL Queries Sub queries and Join conditions, correlated sub queries .
• Wrote Stored Procedures, Functions, Packages in SQL Plus.
• Written many database triggers for automatically updating the tables.
• Worked in creation of Sequences for automatic generation of voucher numbers.
• Used UNIX Shell scripts KORN for Extracting and Parsing data from the files.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Ensured that weekend data loads, end-of-month end-of-quarter processing ran successfully and completely, transparent to user community.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code PL/SQL
• Creating Test scripts for the generated final Reports.
• Involved in data migration from SQL Server to Oracle 9i.
• Good working knowledge of PL/SQL and UNIX in Production Support.
• Post production support, Performance tuning and Query optimization for Reports and Interfaces using Explain plan.

Environment: Oracle 10g, SQL, PL/SQL, SQL Loader, Windows XP, TOAD 9.7.2, Oracle Forms 10g, Oracle

Reports 10g.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users. Participated in system analysis and data modeling.
• Participated in code walkthroughs and review sessions with the development team.
• Co-ordinated with off-shore team by providing knowledge transfer, walkthrough development documents with off-shore team.
• Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using functions and cursors for common utilities. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD. Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Automated scripts by scheduling control-M jobs, by using Unix Shell scripts and windows scripting for improvement in performance of reporting.
• Used advanced Bulk techniques FOR ALL, BULK COLLECT to improve performance. Developed Installation scripts for all the deliverables.
• Designed/developed tables, views, materialized view, stored procedures, packages and functions
• Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade.
• Experience in working with IMPLICIT CURSORS, EXPLICIT CURSORS, REF CURSORS.
• Worked on oracle pl/sql collections VARRAYS, NESTED TABLE, and ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2.
• Encapsulated error handling and use of autonomous transaction for logging. Used UTL FILE for exporting data and UTL MAIL to generate E-mails.

Environment: Oracle 10g, PL/SQL, SQL Plus, Toad 9.7.2, Erwin 4.0, UNIX Shell Scripts, SQL Loader, Oracle reports 10g, Oracle Forms 10g.

Confidential

PL/SQL Developer

Responsibilities:

• Designed/developed tables, views, materialized view, stored procedures, packages and functions
• Automated routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically UTL MAIL .
• Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF to tune SQL queries.
• Automated the processing of Banking functions like Creation of New Accounts, Deletion of Accounts, Daily transactions like deposit and withdrawal on money using various means like cash or check using Oracle Forms 4.5 and Reports 2.5 and generated various reports like the monthly account statement, daily transaction report etc.
• Took responsibility of maintaining rate change calculations and updating database queries to reflect the changes
• Involved in Registration/Migration of concurrent programs, executables, Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration AOL.
• Created lexical parameters, bind parameters, formula columns, summary columns and place holder columns in reports.
• Extensively used triggers like Report triggers, Layout triggers, Data triggers in reports.
• Worked on Report Triggers Before Parameter Form Report, After Parameter Form Report, Before Report Trigger, Between Pages Trigger, After Report Trigger .
• Created Value sets for report parameters and registered in application
• Writing several PL/SQL subprograms stored procedures, functions and packages using PL/SQL records, PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.
• Experience in customization of XML Publisher reports for Oracle Purchasing
• Registered user defined tables into applications using Exec.ad dd.register table
• Prepared test cases helped and QA team in running various test cases during Integration and System testing

Environment: Oracle 10g, PL/SQL, SQL Plus, Toad 9.7.2, Erwin 4.0, UNIX Shell Scripts, SQL Loader, Oracle reports 10g, Oracle Forms 10g.

Confidential

PL/SQL Developer

Responsibilities:

• Used PL/SQL tables, array structures as a part of oracle collections
• Used Oracle PL/SQL for implementing business rules and do performance tuning procedures
• Created new database objects like tables, views, indexes and database links.
• Generated SQL scripts to install, create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created the materialized views and also created the partitioning tables.
• Created several PL/SQL packages, stored procedures and functions.
• Developed several Procedures and Database Triggers as per Business requirement.
• Imported Items from legacy system into Oracle Inventory INV base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.
• Used Oracle Forms 9i for GUI development and Oracle Report 9i for report generation with inline view and lexical parameters
• Responsible for tasks including enhancing, adding new behavior, fixing bugs and rewriting some of the business functionality
• Developed UNIX shell scripts to spawn the Loader job for daily load of data
• Creation of new custom reports using Oracle XML Publisher.
• Defined and developed system test plans. Aided test groups' execution of the plans

Environment: Oracle 10g, SQL, PL/SQL, SQL Loader, Windows XP, TOAD 9.7.2, Oracle Forms 10g, Oracle

Reports 10g.

Confidential

PL/SQL Developer

Responsibilities:

• Incorporated complex business logics by using stored procedures/triggers.
• Designed and wrote test cases for QA.
• Wrote APIs using PL/SQL procedures and functions
• Used DB export/import and SQL Loader utilities to transfer data from the main database to the reporting database.
• Performed validation, extraction of multi field values and populating it in application tables.
• Developed complex queries using inline views, correlated sub queries, complex joins, merge, cursors, Ref Cursors and grouping/ aggregation functionality.
• Wrote shell scripts to automate the process to identify the records to reconcile and their migration using the interfaces
• Wrote unit test programs to verify interface functionalities.
• Gap analysis, Impact Analysis, Requirements gathering by consulting users for enhancements.

Environment: Oracle 9i, SQL, PL/SQL, SQL Loader, Windows XP, UNIX shell scripts, TOAD 7.6, Erwin 4.0, Oracle Reports 6i.