SUMMARY

• 7 years of diversified experience in analysis, design, development, testing and implementation in Oracle Development.
• Good experience with Oracle RDMS (9i, 10g and 11g) and Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, Indexes, AOL concepts of Oracle Applications.
• Good working experience in Reports 6i/9i & Forms 6i for both development and customization of several Reports as per client specifications.
• Working Knowledge on Unix Shell Scripting with sh, bashes csh and ksh shells.
• Working in performance oriented environment dealing with Oracle E - Business Suite Applications R11i/R12 in doing technical work within its various modules such as the Accounts Receivable (AR), Accounts Payable (AP), Order Management (OM/OE/ONT), General Ledger (GL) & Service Contracts.
• Worked on RICE Components like Interfaces, Conversions and Extensions.
• Strong in using tools such as TOAD, SQL Navigator, SQL*Loader, and SQL*Plus.
• Good experience with version control systems such as CVS, PVCS and tools like Quality Center, Kintana and Client specified custom tools.
• Thorough understanding of Rational Unified Process (RUP).
• Involved in supporting the modules from P2P cycle and O2C cycle
• Good experience in advanced PL/SQL concepts like build in packages DBMS SYSTEM, DBMS OUTPUT etc to achieve commendable improvement in performance.
• Good experience in web technologies like HTML/DHTML, XML.
• Expertise in all phases of the Software Development Life Cycle (SDLC) including Analysis, Physical and Logical design, Resource Planning, Code development, Testing, Implementation and Maintenance.
• Involved into Data Migration from Oracle 8i to 9i & 9i to 10g and extensive hands on Data Extraction and Data Comparison.
• Extensive development experience with Oracle 10g and 11g database.
• Have acquired basic knowledge on Oracle Applications Framework (OAF).
• In addition to excellent technical abilities possesses strong oral and written communication skills, analytical and interpersonal skills.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, C, C++

ERP Systems: Oracle E-Business Suite R11i, R12

Database Systems: Oracle 8i/9i/10g/11g, SQL Server 2000/2005, MS access 2005/2008

Developer Tools: SQL Loader, TOAD, Oracle SQL Developer, Oracle JDeveloper, MS VISIO 2007

Operating Systems: Windows 95/98/2000/XP/NT/7, UNIX, RH Linux, Windows Vista, Windows server 2000/2003.

Source control: CVS, PVCS

Scripting/Web technologies: Unix Shell Scripting, XML, HTML/DHTML

GUL Tools and Frameworks: Oracle Reports Builder 10g/9i/6i, Oracle Forms Builder 10g/9i/6i, Crystal reports, Developer 2000 and Oracle Applications Framework.

OS Tools: Putty, FTP/SFTP, WinSCP

Project Management Tools: Adobe works, MS Office Suite 2003/2007

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr Oracle Developer

RESPONSIBILITIES:

• Improved the performance of the application by rewriting the SQL queries.
• Used Bulk Collect feature to improve performance in stored procedure.
• Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.
• Extracted data from oracle database and spreadsheets and staged into staging tables and applied business logic to load them in the central oracle database.
• Hands on experience in writing PL/SQL packages and well versed with using Oracle Apps standard API’s
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL.
• Created procedures to truncate data in the target before the session run.
• TroubleshootedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, TKPROFandAUTOTRACE and Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesanddeveloped procedures using Dynamic SQL.
• Test case/data preparation, execution and verification of the test results.
• Involved in end to end testing and defect fixing.
• Good understanding of database objects and ability to triage issues
• Used Git for version control and flyways for deploying code into environments.

Environment: Oracle 11g, TOAD, SQL*Plus, Windows 7, PL/SQL developer, Oracle Applications 11i

Confidential, San Jose, CA

Oracle PL/SQL Developer

RESPONSIBILITIES:

• Developed custom API’s, Stored Procedures, Functions and complex Packages and Triggers extensively using PL/SQL to meet business requirements.
• Designed and developed DB objects such as tables, views, synonyms, partitioned tables, indexes, sequences, database links, cursors, functions, procedures and packages and data loading using SQL Loader utility for new/enhance requirements.
• Developed some of the basic customized OAF pages.
• Involved in various stages of testing - Code testing, Unit Testing, System Integration Testing (SIT) and User Acceptance Testing (UAT) also involved in Go-Live activities and provided instant support for client testing.
• Maintained the code as per clients coding standards, involved in presenting the code review to client and modification for the development of new requirements
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL).
• Involved in fine-tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
• Extensively worked on Format Triggers, Formula Columns, Summary Columns and Placeholder Columns for developing the reports using Oracle Reports Builder 10g.
• Extended few reports from Reports 6i to Report 10g.
• Generated report outputs in the PDF, XML etc. formats using Reports 10g.
• Developed custom reports using Bind parameters in Reports 10g
• Designed and developed reports by using lexical parameters in before, after parameters and before report triggers by using Report Builder 9i/10g
• Customized the existing forms with descriptive flex fields.
• Modifying Forms to accommodate new functionality like adding Buttons and Texts.
• Frequently involved in registering custom forms, custom reports with oracle applications using system administrator/Application Developer responsibilities and involved in administering concurrent manager’s/transaction managers (activate/deactivate, request priorities).
• Created Request Groups and Value sets for reports.
• Implemented black box testing on reports.
• Created Snapshots and Materialized Views.
• Developed PL/SQL to process input files and generate output files using UTL FILE utility.
• Developed and tested UNIX shell scripts to call the PL/SQL packages.
• Involved in writing automated data loading Shell Scripts which will watch the incoming files and load them automatically and emailif the data load is successful or failure
• Monitored defect tracking activities using Quality Center.
• Unit Test the module and deliver to the QA team.
• Maintained version control of the code in PVC’s.
• Migrated setups and code from dev. env to test and from test to production through Kintana.
• Provided KT to fresher’s and mentored junior team-members.

Environment: Oracle 9i/10g/11g/R12, PL/SQL, SQL developer, TOAD, SQL*Plus, Reports 9i/10g, Windows XP/7, UNIX Shell Scripting, MS Office, JDeveloper 10g, Oracle Applications 11i/R12

Confidential

Oracle PL/SQL Developer

RESPONSIBILITIES:

• Prepared technical specifications document (MD 70) based on the functional requirement specifications (MD 50).
• Participated in the design, development and creation of custom reports based on the customer requirements and interacting with the customer for requirement analysis.
• Ensure that all deliverables are thoroughly documented and Prepared source to target Data mapping documents, Unit Test case, Unit Test Plan documents
• Used FND REQUEST API to submit concurrent Programs from PL/SQL program
• Created Users and added responsibilities to those Users using System Administrator Responsibility.
• In Oracle Applications, created AOL objects such as Program registering i.e., defining Executable & Concurrent programs and assigning the Concurrent program to request group, defining responsibilities, users, request group, Value set, flex-fields, profile options.
• Developed the Request sets that are scheduled to submit concurrent programs in a desired sequence as per the functional document.
• Used Bulk Collect, parallel processing, bulk insert feature to improve performance.
• Developed the Ad-hoc Reports as per the Business Requirements
• Facilitated easy user interface implementation and consistent data entry into the database by creating Views with Triggers.
• Utilized TOAD 9.2 for developing all back end database interfaces and objects.
• Created and compiled DDL scripts and see the output errors when executing stored DDL.
• Developed batch programs to load various types of feeds from external sources into the Oracle database using SQL*Loader and PL/SQL procedures.
• Handled errors using Exceptions like DUP VAL ON INDEX, INVALID NUMBER and CASE NOT FOUND.
• Used SQL Loader in Oracle for bulk Data Loading

Environment: Oracle 9i/10g/11g, PL/SQL, SQL developer, TOAD, SQL*Plus, Reports 9i/10g, Windows XP, MS Office, SQL*Loader, Oracle Applications 11i

Confidential

Oracle PL/SQL Developer

RESPONSIBILITIES:

• Provide timely Production Support by quickly analyzing the root cause and by providing alternatives to resolve issues.
• Involved in month-end and quarter-end activities and generate reports using sql queries.
• Worked on automating process for weekly and daily jobs using UNIX Shell Scripts
• Worked on Performance tuning of SQL & PL/SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN, HINTS and TKPROF.
• Ensured that weekend data loads, month-end & quarter-end processing ran successfully and completely, transparent to user community.
• Worked with DBAs for performance problems, fix the problem and make recommendations to technical staff to improve performance.
• Written complex SQL Scripts in SQL*Plus for data reporting to business and write ad-hoc queries for various customer-reporting requirements.
• Providing the data as requested by SOX.

Environment: Oracle 9i, PL/SQL, SQL developer, TOAD, SQL*Plus, Windows XP, MS Office, Oracle Applications 11i

Confidential

PL/SQL Developer

RESPONSIBILITIES:

• Involved in migration of code and data pertaining to Order Management modules from Oracle Applications 11.5.9 to 11.5.10
• Created database objects such as tables, indexes, synonyms, sequences and views
• Developed PL/SQL stored procedure, functions and packages for migrating the data from staging instance to repository database
• Developed SQL scripts to test and validate the information
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables (OE HEADERS IFACE ALL and OE LINES IFACE ALL).
• Worked on AOL objects i.e., creating Executable, Concurrent programs and assigning the concurrent programs to the request group.
• Customized standard oracle reports like “Packing Slip Report” as per the business requirement.
• Worked with migration of forms.
• Involved in validations to the customized forms using CUSTOM.PLL
• Customized existing forms in the OM module according to the client’s requirements.
• Registered custom reports with oracle applications using system administrator and Application Developer responsibility
• Involved in creating request sets to run multiple concurrent programs at a time
• Implemented complex business rules with the use of integrity constraints and Database Triggers.
• Responsible for optimizing queries and query tuning using Explain plan and auto trace.
• Used TOAD to extract and test the data in the database.
• Modified the code as per standards.
• Prepared Unit Test Cases and Unit Test Plan documents.
• Worked on the RFC’s provided by client by delivering them on time.

ENVIRONMENT: Oracle Applications 11i, Oracle 10g/11g, PLSQL, TOAD, SQL developer, Windows XP, SQL *Plus, Reports 9i/10g, MS Office.