Summary:

• Over 8 years of Oracle experience in Oracle 11g/10g/9i/8i, SQL, PL/SQL as an Oracle developer/PL/SQL developer in Analysis, Design, Data Modeling, and Implementation of Business Applications using the Oracle Relational Database Management System
• Extensive experience in SQL, PL/SQL, SQL Loader Utilities, Oracle Reports 6i/10g, UNIX Shell Scripts, XML, BI Publisher.
• Worked on setup, configuration, development and support of RICE components in Oracle E-Business Suite Project Accounting and Financial modules
• Technical and Functional expertise in various modules such as Inventory, Account Payables, Order Management, Purchasing, Account Receivables, General Ledger, HRMS, SYSADMIN, ORACLE DISCOVERER 10G, ORACLE BI/XML PUBLISHER
• Worked on Data Migrations, Extractions, Interfaces and customization of Oracle Applications EBS 10.7, 11i and R12
• Good programming experience in creating Functions, Procedures, Packages, APIs, Triggers and also other database objects using SQL and PL/SQL
• Worked on order-to-cash and procure-to-pay life cycles in the modules Inventory, Purchasing, Account Payables, Order Management Account Receivables
• Involved extensively in preparing test scripts and perform simulation, regression testing within Oracle e-Business modules
• Responsibilities include analyzing user requirements, designing technical documents, Onsite- coordination, database designing, development, support and testing
• Proficient in understanding and preparing various AIM documents Business Requirements, Technical, Installation etc... BR100, MD050, MD070, CV040, TE020, TE040.
• Good Knowledge of ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Informatica.
• Used Oracle Metalink extensively to solve technical issues and raise TAR Service Request and also used VSS, WINCVS, Wsftp, Putty and many data transfer tools
• Recognized for problem solving skills, professionalism and a team player

Technical Skill Set:

Professional Experience:

Confidential

Role: Oracle Application Developer

Environment: SQL, Oracle PL/SQL, XML, UNIX, Oracle 11g, Oracle BI Publisher, MS WORD,MS EXCEL,HTML,PDF,TOAD/SQL DEVELOPER.

Responsibilities:

• Developed Oracle BI Publisher reports for a Student Admission System specifically Undergraduates.
• Involved in Production Support maintaining BI Publisher reports in an Oracle 11g database environment.
• Worked on deployment of applications in a heterogeneous environment.
• Gave knowledge sharing sessions to users and other team members.

Confidential

Role: Sr. Oracle Developer

Environment: Oracle EBS - Oracle Apps R12, SQL, PL/SQL, Oracle Reports10g/11g, BI Publisher.

Responsibilities:

• Analyzing the functional specification documents of the client and discuss with Business Analyst to understand client requirement.
• Designed and developed Conversions, Interfaces, Reports and custom tables.
• Creation of Packages, Procedures, Functions and SQL Loader control file.
• Designed and developed an interface program to load the invoices from legacy system to oracle receivables.
• Developed Discoverer Reports like Production Detailed Report, Top - 10 Suppliers, Annual Sales Report using Fiscal Year Concept, Production Detailed Report.
• Developed reports using BI Publisher like Inventory Stocks Report, Goods Receipt Note, Account Analysis Inventory Report, Invoice Tax Details, for Displaying Supplier Details CST No, TAN No, PAN No Etc. , Spend Analysis.
• Defined Responsibilities and assigning it to users.
• Defining Data Groups, Menu and Report security groups.
• Involved in loading of vendor data into oracle applications.
• Written interface program to load Po's into the apps from the feeder system.
• Involved in Customization of Reports and forms in AR, PO, INV and AP modules.
• Creation of concurrent programs and Value sets.
• Registered as concurrent programs and which are run from SRS form.
• Creation of concurrent programs using FNDLOAD from one instance to other.

Confidential

Role: Oracle Developer

Environment: Asset Manager Custom Applications, SQL, PL/SQL, UNIX, Oracle 9i/10g Database, BI Publisher

Responsibilities:

• Understanding the business requirements using the Functional requirement documentations.
• Finalizing the data template layout and mapping document required for the conversions
• Worked on creation and customization of BI Publisher reports.
• Creation of Custom Staging Tables, custom triggers, custom indexes, Db links and synonyms and error log and error code tables needed to perform data conversions.
• Creation of Custom conversion Programs needed to perform data conversions which include data mapping, data validation and loading the validated data into Custom ATC US tower Asset Manager tables.
• Creation of Technical Design Documents and Installation Design Documents

Confidential

Role: Oracle EBS Technical Developer

Environment: Oracle EBS - Oracle Apps 11.5.10.2, SQL, PL/SQL,BI Publisher

Responsibilities:

• Writing conversion packages to upload the data in new instance.
• Creation and binding of Table defaults, Constraints, other validations.
• Created indexes for fine-tuning and maintenance of the database.
• Coding Stored Procedures and Triggers.
• Creation of Control Files.
• Modifying the existing BI Publisher reports.
• Creation of Technical Design Documents.
• Unit and Integration Testing
• UAT Support
• Preparing documents required for the conversion objects including test case documents.

Confidential

Role: Oracle Developer

Environment: Oracle EBS - Oracle Apps 11.5.10.2, SQL, PL/SQL, Reports 10g, forms 10g, Unix, Oracle 9i/10g Database, XML/BI Publisher, Oracle Discoverer, Oracle Workflow.

Responsibilities:

• Understanding the business requirements using the Functional specification documents and other specification documents provided by client
• Developing or modifying the code to fix the user issue/requirement and unit testing of the code.
• Modifying the existing Oracle 6i/10g reports.
• Developing a new XML report's from scratch where we have included code 128 fonts for barcodes.
• Extracting the data from various modules and developing the Discoverer reports.
• Developing control files, staging table scripts, concurrent program creation scripts, indexes, synonyms, sequences and triggers.
• Developing PROG files for loading the data into the staging tables and calling other programs from that file.
• Developing PL/SQL custom program's i.e. Packages to validate the extracted data from INV and ONT module tables which is going to be archived with the actual archived data present in archive schema of these INV and ONT module tables and print the mismatch records/rows in custom programs out file.
• Preparing solution and installation documents for user issue/ requirement.
• Preparing the Technical Specifications documents which explains the process and steps which are done to fix the user issue/ requirement

Confidential

Role: Oracle PLSQL Developer

Environment: Oracle Apps 11.5.10, SQL, PL/SQL, UNIX, Oracle 9i/10g Database.

Responsibilities:

• Developed complex PLSQL packages to implement the business logic adhering to the standards of Oracle HRMS APIs and coding standards.
• Modified various code flows in SALADMIN component in the process of solving Service Requests and implementing Enhancements.
• Enhanced SQL queries involved in APIs of Compensation module for Performance and Optimization.
• Extended and modified various OA Framework components in the process of resolving the customer bugs.
• Actively supported the time critical and high severity issues by resolving them with great quality.
• Consulted with end-users to analyze and understand business requirements and objectives in the process of solving the Service requests raised by them.
• Provided resolution to support issues, and was responsible for escalation procedures while retaining ownership of the issues. Managed Service Requests TARs with Oracle Support.
• Modified functionality of Salary Proposals in the approval process which involved modifications of several Self-service OA pages and APIs of Salary Administration sub-module.
• Involved in Peer reviews and suggested the necessary changes to adhere to the business requirements.
• Developed various Functional and Technical documents as per the Oracle Standards.
• Involved in presenting the prototype of the Enhancement requests to the customers and other teams.
• Gave Knowledge sharing sessions on the functional domain to other teams and was always part of mentoring the new teammates.

Confidential

Role: Oracle Technical Developer

Environment: Oracle Apps 11.5.10.2, UNIX, SQL, PL/SQL, Forms 6i, Reports 6i, Discoverer 10g, TOAD, JDeveloper, SQL Loader

Responsibilities:

• Developed Purchase Order Receiving package, which includes validating the Receiving Data, Inserting data into Receiving Open Interface Tables and calling the Receiving Transaction processor Concurrent program.
• 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 INVOICES INTERFACE, AP INVOICE LINES INTERFACE tables and Calling Payable Import Program.
• Used CUSTOM.pll for Validations and Zoom in Standard Forms in PO Module.
• Developed Various Error Correction forms in the interface process. These forms are used in correcting the error records in staging tables and interface tables.
• Worked on several Report Customizations like Dell Interface Error Report, Dell Custom Invoice Hold Report, and Customized Account Analysis - Payables Detail Report.