SUMMARY:

• Over 8 years of experience in designing, developing and implementing database applications and solutions as Oracle PL/SQL Developer.
• Experience in interacting with Business/Technology groups and analyzing business needs.
• Expert in PL/SQL programming involved in creating of stored procedures, functions, packages and triggers using the latest features to optimize performance (Bulk Binds, Inline views, Ref. cursors, dynamic SQL).
• Experience in generating forms using Oracle Forms 6i/9i, fixing the bugs, and Customization of forms according to the changing client’s requirements that were already developed.
• Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD in many development projects.
• Expert in Tuning Queries for better performance to achieve maximum speed, minimum cost using Explain Plan.
• Experience in conducting Requirements and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys.
• Proficient in advance features of Oracle 9i for PL/SQL programming like using cursor variables, Ref. cursors, varrays, nested tables and Dynamic SQL.
• Good knowledge on Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Good knowledge on working with DBLinks and also creating materialized views like Read Only, Updatable, and Writeable.
• Worked on different data transfer utilities such as FTP (File Transfer Protocol), SFTP (Smart FTP).
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.
• Extensive experience in developing reports using XML/BI publisher 5.6.3/5.6.2 , Reports 10g/6i/2.5 and Discoverer 10g/4i.
• Knowledge on Oracle Support processes for technical requests with Metalink.
• Excellent communication (Verbal / Written) and presentation skills, Quick in grasping client’s business requirements and good at adapting to new work environment.
• In Addition to this I have worked on ERP system and very good understating on Order to cash flow. Building Oracle Reports, Interfaces, Conversions and Extensions.

TECHNICAL SKILLS:

Lang & Scripting: JAVA, SQL, PL/SQL, HTML, XML, C, C++, E - Text.

Database Tools: Import/Export, Data Pump, TKPROF

RDBMS: ORACLE 11g/10g/9i/8i.

Development Tools: TOAD, ECLIPSE, JDEVELOPER, Reports, XML Publisher, Workflow builder 2.6/2.5

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

Senior Oracle PL/SQL and Apps Developer

Responsibilities:

• Being a Senior developer always had a small team to maintain and guide them in designing developing projects and actively performed many SITs and UATs for the team.
• Performed and participated in SCRUM meeting for most of the projects to have a check on daily activities and deadline achievement.
• Single handedly designed and Developed on Integrating POS (Point of Sales) data between 2 systems to analyze and record daily transactions, new and existing customer, inventory and price changes on product.
• Worked on complicated PLSQL reports to present the Point of Sales data to Management and relevant users for validation.
• Performed Data Migration activities to move the data from Siebel Applications to Oracle Applications.
• Developed conversion packages to migrate Return Material Authorization logistics from SFDC to Oracle Applications.
• Activity participated in company acquisitions where duties were to develop, design new objects and necessary changes to existing objects in Datawarehouse. Objects included Procedures, Triggers, Packages and Functions.
• Worked in the support team and expertise in logging daily issues and communicating to user about the status and resolutions.
• Designed, developed and maintaining PLSQL objects to send feedouts and receive feedins from 3rd party systems on daily basis.
• Automated support SQL queries to identify daily issues and make manual intervention to the minimal. Has good knowledge on Supply Chain and Financial modules in Oracle eBusiness Suite (R12). Oracle apps being the primary data source, worked widely in Oracle team for enhancements and bug fixes.
• Developed PL/SQL Packages, procedures and functions that are used in custom reports and registered them as concurrent programs in Oracle EBS R12.
• Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into AP INVOICE INTERFACE tables in Oracle EBS R12.
• Challenging complex queries and tuning them to achieve maximum speed, minimum cost using tuning techniques for better performance using Explain Plan.
• Developing and maintaining Materialized view for OBIEE reporting.
• Design and developed Oracle Reports and Forms as per the end user requirement using.
• Review existing ERP systems to determine compatibility with projected or identified client needs, research and select appropriate system, including ensuring forward compatibility of existing systems.
• Commended for my ability to easily and effectively transition between the role of a software developer and that of test engineer whenever need arises.
• Collaborated with clients and end-users to develop a requirement gathering template which reduced the effort for that phase by 50 percent and ensured exact requirement capture.
• Review, repair and modify software programs/Code to ensure technical accuracy and reliability of programs.
• Performing various tasks as System Administrator (registering concurrent programs, value sets, and flex fields).
• Good knowledge on version control tools like VSS, PVCS which helps multiple users to access the source code of the PL/SQL programs.
• Creating LDT files for Menus, Functions, and Concurrent programs.
• Creating Migration scripts for Oracle RICE components.

Environment: Oracle E-Business Suite R12, XML/BI Publisher, Reports 10g, SQL*Loader, TOAD.

Confidential, North Carolina

Oracle PL/SQL Developer

Responsibilities:

• Conducted performance tuning of the database for optimal performance.
• Involved in the database design and prepared the detail design document (DDD).
• Created procedures, triggers, functions and packages using PL/SQL
• Load the data from Excel file to oracle database.
• Conducted database and code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
• Analyzed and computed statistics to improve response time for queries.
• Performed Unit Testing, Integration Testing and Performance Testing.
• Developed complex reports using multiple data providers and report level variables.
• Developed materialized views and other database objects to optimize reports.
• Implemented different level hierarchies for drill down reports.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Worked on Fact and dimension table of data warehouse.
• Developed Advance Pricing(QP) XML publisher report for viewing product final price for all the pricelist defined.
• Involved in migrating objects between instances.
• Customized forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
• Creating LDT files for Menus, Functions, and Concurrent programs.
• Designed and developed complex Procedures, Functions & Packages to handle errors and exceptions at database level using PL/SQL
• Creating LDT files for Menus, Functions, and Concurrent programs.
• Creating Migration scripts for RICE components.

Environment: Oracle E-Business Suite R12, XML/BI Publisher, Reports 10g, SQL*Loader, TOAD.

Confidential, Atlanta, GA

Oracle PL/SQL Developer

Responsibilities:

• Involved in resolving issues present in the product by analyzing the cause of the issue and solving the same.
• Involved in allocation of work and verification of program specifications done by fellow team members.
• Handled modifications in stored procedures, functions, packages, tables, views at the backend and also in PL/SQL coding both at backend and front end.
• Involved in unit testing for all the self-made changes made respectively in our team.
• Involved in preparing documents for program change specification and program specification for the various changes that need to be done in the existing ERP Product.
• Created many database structures like tables, sequences and procedures as per the requirement for solving the issues and also for new enhancements.
• Was leading a team of two members and made a code review for their coding and documented.
• Documented all the details discussed in team meetings and circulated amongst the team members through email.
• Made use of TOAD as an editor to handle with backend database.
• Used MS-Project to maintain the schedule of deliverables
• Responsible for using dynamic SQL in PL/SQL which is an advanced programming technique that makes the applications more flexible and versatile.

Environment: Oracle E-Business Suite R12, XML/BI Publisher, Reports 10g, Discoverer 10g, Forms 10g/4.5, SQL*Loader, TOAD.

Confidential, New York City

Oracle Applications Technical Consultant

Responsibilities:

• Involved in installation and configuration of Oracle BI Publisher.
• Customized existing custom oracle reports to replace plain text output to PDF format using BI Publisher.
• Developed/Converted most of the existing text reports to excel format using BI Publisher.
• Used Conditional formatting for highlighting the records based on conditions in XML/BI Publisher.
• Used the Totals/Subtotals/Group/Sort features of XML/BI Publisher to make data intense operations happen at the template level.
• Created an RTF template with XSL equivalents to group data as of date placed in service and registered to Template definition
• Developed Project Actual to Budget Detail Report for PA using XML/BI Publisher.
• Customized standard reports using XML/BI Publisher and registering necessary concurrent programs which includes Journal Entries Report in General Ledger (GL).
• Creating LDT files for Menus, Functions, Concurrent programs.
• Used SQL Loader in loading data into staging table and then to interface tables.
• Configuration and Setups for Oracle Project accounting Billing.
• Customized Intercompany Billing process in project accounting billing.
• Worked on Form Personalization in Oracle Receivables (AR), where the user can’t update the last and first name of customer, bank account number, when that record is validated.
• Customized Purchase Order (PO) Form using Custom.pll for comparing the unit price entered with the component prices entered in the descriptive flex fields.
• Used Form Personalization to zoom out sales order form from AR Transactions screen using Oracle Forms 10g.
• Involved in writing UNIX Shell Scripts for moving and copying files from server to client and from client to server.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Documented functional features and behavior of required customizations using AIM methodology. Prepared and involved in analyzing conversion documents CV 40, CV 60 and MD70.
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
• Worked on PO Requisition Interface to load PO Requisitions from the legacy System into Purchasing Interface Tables.
• Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into AP INVOICE INTERFACE tables and Calling Payable Import Program.
• Developed interfaces between Receivables and Order Management. Designed and developed Interface for import of vendor information and Vendor site information into the system.
• Created alerts on PO, AR, and AP based on client requirements.
• Involved in Training the end users on the functionality of Procure to Pay modules.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes using Oracle Reports 6i.
• Involved in designing various reports like Inactive items report, GL detail report using Oracle Reports 6i.
• Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in AR
• Designed and developed interface program to capture shop floor data through a custom API process.
• Developed Discoverer Reports in Purchasing(PO) Module like, Purchase Price Variance(PPV) and Invoice Price Variance Reports(IPV)
• Developed PL/SQL Packages, procedures and functions that are used in custom reports and registered them as concurrent programs.
• Used AOL features and Reports extensively while working on Invoice aging reports, stopped payment report, invoice audit report. Registered these reports as concurrent program in AOL and modified request group to add the programs

Environment: Oracle Applications11i (11.5.8) PL/SQL, Oracle 10g, SQL*Loader, Forms 6i, Reports 6i, Oracle BI Publisher, Discoverer, SQL*Loader, TOAD, UNIX Shell Scripting, Shell Scripting, Windows NT.