PROFESSIONAL SUMMARY:

• Over 8 yearsof programming experience as anOracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Extensive experience as Oracle Developer in developing and utilizing PL/SQL procedures, functions, packages, triggers incorporating advanced PLSQL techniques like analytical functions, Dynamic SQL, BULK techniques, Collections, regular expressions etc.,
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL * PLUS, TOADand SQL*LOADER.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Extensive experience in Oracle Database design, development of Stored Procedures, Functions, Triggers, Packages, Cursors using SQL and PL/SQL.
• Experience in query optimization, performance and tuning (PL/SQL) usingSQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tablesandtable partitioning.
• Developedmaterialized viewsfor data replication in distributed environments.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Experience in writingTechnical design documents and developing unit test documents.
• Expertise in Oracle Forms 11g/10g, Oracle Forms 6i & Oracle Reports 10g/9i &6i.
• Experience in requirement gathering, Analysis, Design, Development, Testing and Implementation.
• Experience in performance tuning and SQL optimization using (Hints, Explain Plan, Auto Trace, and TKPROF), restructuring tables, de-normalization tables.
• Proficient in shell scripting, unit testing, code migration/deployment, Pre and post production support, extensions, customizations and Maintenance.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i/7.x (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008, DB2, Teradata, SAP Tables and MS Access.

Developer Tools: PL/SQL Developer, SQL Navigator, TOAD, SQL plus, PUTTY, WINSCP

GUI: Oracle Forms 11g/10g/9i/6i and Reports 10g/9i/6i

Languages/Utilities: SQL, PL/SQL, UNIX shell scripts,Java, XML

Operating Systems: Windows 2008/2003, Win 7/Vista, Red Hat Linux 6/5, AIX

PROFESSIONAL EXPERIENCE:

Confidential, El Segundo, CA

Sr. Oracle Developer (PL/SQL, Forms & Reports)

Responsibilities:

• Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created/developed/ModifiedProcedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Optimized lot ofSQL statementsandPL/SQL blocksby analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Developed various backend application programs, such asViews, Functions, Triggers, ProceduresandPackagesusingSQLandPL/SQLlanguage for the top management for decision making.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX shell scriptsaccording to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensive testing was done on the programs for achieving accuracy, timely processing of data.
• Involved in the development of backend procedures by using PL/SQL for ledger posting and for reversing the journal ledgers.
• Used Oracle Forms 10g to design and develop the interface for the system.
• Used Forms 10g to create various screens for business users to create new totals definitions, carve-outs, submit totals, submit reports and submit batch job queues.
• Created Reports like totals customers, carve-outs, caps, invoices of new customers, existing customers.
• Created front-end procedures and functions with Forms 10g to calculate reorder level and reorder quantity.

Environment: Oracle 10g, Forms10g, Reports10g, PL/SQL, SQL * Plus, TOAD, SQL*Loader, Shell Scripts Windows 2008/Win 7

Confidential, Englewood, CO

Sr. PL/SQL Oracle Developer

Responsibilities:

• Responsible for interacting with Business Users and other development teams for gathering requirements.
• Developed Functional and Technical Specifications.
• Involved in creating SQL loader scripts to load the data from the flat file received from 3rd party vendors into oracle tables.
• Involved in writing PL/SQL program using UTL FILE package.
• Involved in Unit testing, System testing and UAT.
• Worked as production support specialist and resolved production related issues.
• Developed Functions and Procedures to manipulate the data and to load to the tables.
• Used Oracle Advanced concepts like types, PL/SQL tables and V-Arrays and dynamic SQL in generating the complex extracts from database.
• Developed Conceptual, Logical and physical data model and scripts to create users, roles and schema objects
• Developed SQL*Loader control files to extract data from flat files, create error, result log files and load data into temporary table to do validations
• Customized and developed several forms using CUSTOM.PLL and TEMPLATE.FMB to meet client’s requirement.
• Designed and developed forms using Oracle Forms 10g to allow the end users to manage the customer relation effectively and efficiently.
• Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
• Successfully designed and developed standard and custom reports using Oracle Reports and Pro*C.
• Developed validation programs to validate the data before importing into the payables table.
• Designed, developed, tested and implemented using Oracle Forms.
• Involved in tuning using EXPLAIN PLAN and used hints to tune the queries.
• Involved in the creation of database objects like tables, views, stored procedures, functions, Indexes for new requirements.
• Involved in creating users and requests, schedules in Oracle Apps for all interfaces.
• Responsible for Analysis, Design, Development/Customization and Testing/debugging of the reports.
• Involved in Code Reviews and test Reviews.
• Participating in Quality Audits.

Environment: Oracle10g/11g, SQL, PL/SQL, PLSQL Forms / Reports 10g, Oracle Apps SYS Admin, SQL*LOADER, UNIX shell scripting, TOAD.

Confidential, Piscataway, NJ

Sr. Oracle Developer

Responsibilities:

• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Validated & loaded data into Oracle Database using DB links and external tables.
• Used various Optimizer Hints to speed up the SQL queries.
• Performed various activities like creating, debugging and modifying Stored Procedures, Functions, Packages, Triggers, Tables, Views and User defined functions etc.
• Designed and created tables generating the ER diagrams, enlightening foreign key and primary key constraints.
• Used SQL*Loaders to download the data into warehouse database from the flat files and other data files across different platforms.
• Developed SQL and Shell scripts to create temporary tables and developed SQL*Loader scripts to load data into the temporary staging tables.
• Gathering Static information for the test data then Testing and preparing the Test cases based on the business.
• Designed and developed forms using Oracle Forms 10g to allow the end users to manage the customer relation effectively and efficiently.
• Designed, developed, tested and implemented User Interface or forms using Oracle Forms 10g.
• Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
• Responsible for Designing, development, testing and deployment of Oracle Alerts, Triggers and debugging for Oracle Forms.
• Good command, experience and knowledge in RICE (Reports, Interfaces, Conversions, Enhancements) Components.
• Mostly involved in code reviewing and performance tuning in PL/SQL.
• Worked on creating Materialized Views to maintain copy of the remote data Confidential local node.
• Solving the complicated run time errors collaborating with DBA team members.
• Used ETL tools to extract and load data from SQL Server and flat files to Oracle database.
• Created Test Scripts, Test Plans and Perform the testing for data conversion process.
• Involved in the development of database objects in both OLTP and OLAP databases.
• Created documentation for migration and performed extensive testing during the various phases of product implementation.

Environment: Oracle Database 10g/11g, Windows XP, UNIX, SQL Loader, TOAD, Oracle Forms 10 g, Oracle Reports 10 g, XML, SQL, PLSQL, UNIX.

Confidential, Appleton, WI

Sr. PL/SQL Developer

Responsibilities:

• Developed Packages to validate raw data from Flat Files and insert into tables.
• Involved in the data transfer creating tables from various tables, coding using PL/SQL, Stored Procedures and Packages.
• Customized the Reports in Cross Tab Layout and Tabular Layout Formats.
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Designed and developed conversions to sustain Business Rules and Flow.
• Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers.
• Created the integrity constraints and Database Triggers for the data validations.
• Used PL/SQL Tables and Records in payroll generation process.
• Developed Forms (like invoicing, Delivery order) and Reports using Oracle Reports and PL/SQL.
• Involved in database development by creating PL/SQL Functions, Procedures, and Packages, Cursors, Error handling and views.
• Customized Customer Transaction Analysis Report to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the Report. Writing after Parameters Triggers for the Validation of the data.
• Created various custom reports like Transaction Aging Report, Credit Card Transaction Report, Active Invoice Register Report, Account Balance Consolidation reports and others using Reports Builder 9i.
• Coordinated with DBA in improving database performance.
• Written Test Plans and Involved in Unit testing.
• Used the FTP commands efficiently to migrate the files and logs have been created successfully in proper directories on completion of the transfer process.
• Designed and developed user test scripts for the UAT and migration of the developed codes. Scheduled the jobs with heavy dependencies.
• Involved in 24/7 production support as per the need basis.

Environment: Oracle 9i, SQL*Plus, SQL, PL/SQL, Forms 9i, Reports 9i, Ms Access, UNIX, TOAD.

Confidential, Arlington, VA

Sr. Oracle Developer

Responsibilities:

• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Created materialized views & normal views where business requirements needed.
• Tuned the SQL queries and complex procedures to improve performance. Used EXPLAIN PLAN and Toad/SQL Navigator for tuning the queries.
• Created database triggers for data security & consistency.
• Developed various database objects like tables, schemas, views, packages, stored procedures, triggers, functions etc using TOAD.
• Developed SQL*Loader scripts to load the data from external flat files that are exported from SQL Server.
• Debugged existing code for business logic issues.
• Developed reports as per the requirements collected from the users using Oracle Reports Builder 10g.
• Migrated forms from 6i to 11g, by recompiling and modifying the code as needed to support the complex functionality embedded.
• Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Modified and optimized complex queries for data retrieval and modification.
• Developed SQL*loader scripts to load data from various forms of flat files into staging tables in Oracle database.
• Involved in XML parsing and loading XML files into the database.
• Involved in using of new features of Oracle 11g like Analytical functions, Flash back Query, regular expressions etc.,
• Involved in the restructuring and fine tuning of the existing SQL Queries according to the new requirement using TKPROF, AWR.
• Responsible for performing Code Reviews.
• Used UTL FILE package for writing DBMS OUTPUT messages to file.
• Used an in house defect tracking tool and Clear Case for defect tracking.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Uploading the Test cases, Manual Test Scripts, Codes and Specification Documents on Visual Source Safe (VSS) for version controlling.
• Worked on UNIX environment and shell scripting for creating Batch Jobs using UNIX KORN, AWK UNIX Shell Scripts and API’s Using PEARL Scripts.
• Involved in providing 24/7 database production support and troubleshooting data quality and integrity issues.

Environment: Oracle Database 9i/11g, Oracle Forms 6i/11g, SQL, PL/SQL, SQL*Plus, SQL*Loader, .Net, DTS, TOAD, Clear Case, VSS, UNIX.

Confidential, TX

Oracle PL/SQL Developer

Responsibilities:

• Created Stored Procedures and tuning SQL for maximum performance.
• Created new Tables, Indexes and Sequences where needed.
• Wrote procedures to calculate calendar year returns & trailing year returns both Annualized & Compounded.
• Created normal views and materialized views where business requirements needed.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL.
• Documented changes and enhancements in code.
• Communicated issues and progress to project manager.
• Data migration and conversion done utilizing Oracle Export & Import utility.
• Developed packages for processing data in the staging tables according to the Clients requirements.
• Used SQL*Loader to load data into different tables.
• Verified the data in addition to re-designing the database, front end using Forms 4.5 and Reports 2.5.
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
• Involved in solving day-to-day problems, giving support to the users.
• Involved in production support and maintenance.

Environment: Oracle 9i, Forms 9i, Reports 9i, PL/SQL, SQL*Plus, Exp/Imp, UNIX, Quality Center, Windows 2003/XP.

Confidential

Oracle Developer

Responsibilities:

• Created complex stored procedures for financial transaction by using procedural parameters & working with packages, blocks & exception handling.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance.
• Developed PLSQL packages for generating various feeds from oracle database using UTL FILE utility in the client’s secure data transmission server.
• Used SQL*Loaders to download the data into database from the text files and spread sheets.
• Developed UNIX scripts for sending mails to the bank and the business team, when the external feeds to the bank are received.
• Worked on creating Materialized Views to maintain copy of the remote data Confidential local node.
• Solving the complicated run time errors while running the process along with DBA team members.
• Involved in supporting/fixing production defects and day to day business transaction issues.
• Used SQL Navigator, a popular tool which increases user productivity and application code quality with rich features to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries.
• Developed various new reports from scratch utilizing Oracle Reports Builder for day to day validations.
• Created various adhoc reports as of when required for the production analysis and issue fixing.

Environment: Oracle Database 9i, Toad, SQL*Plus, SQL* Navigator, SQL*LOADER, UNIX, Forms6i, Reports 6i.