SUMMARY:

• 10 Years of IT experience with expertise in Oracle Technology. Experience working on different phases of SDLC, from Systems Analysis, Design, Programming, Testing and Debugging to Implementation, Maintenance and Production Support.
• Extensive experience with analysis, design, development, customizations and implementation of software applications including Oracle ERP applications.
• Proficient in writing and Performance Tuning of SQL queries and PL/SQL (Procedures, Functions, Packages & Triggers).
• Experience working on Oracle Forms, Oracle Reports, Oracle Discoverer, Oracle Designer, Oracle BI/XML Publisher, SQL Plus, TOAD, SQL Developer . Able to create from scratch or modify existing modules.
• Strong database skills and development knowledge.
• Detailed understanding of R12 Sub ledger Accounting, R12 Payables & Payments flows, Procure to Pay and Order to Cash .
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Good communication skills, interpersonal skills, self - motivated, quick learner, team player.
• Extensive experience in writing SQL Queries, PL/SQL Programs and integrating legacy applications using Inbound and Outbound interfaces.
• Detailed knowledge of Procure to pay cycle.
• Strong debugging skills in complex programs and applications Industry experience payment, Accounting, and Financials domain.
• Adept in writing Advanced PL/SQL (dynamic SQL, Bulk Binding, Exception Handling).
• Able to perform as a Team Lead, a Self-Starter and can work as an Individual Contributor.
• Strong communication skills (written and oral) and interpersonal skills.
• Excellent problem solving skills.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, LINUX

Languages: Oracle SQL*Plus, PL/SQL

RDBMS: Oracle Database versions 10g, 11g.

Developer Tools: Toad, SQL Developer, Reports 10g,Workflow Builder, SQL * Loader, Putty, Tectia, PL/SQL Developer Tool, XML/BI Publisher, Oracle Workflow

Applications: Oracle E-Business Suite Financials R12 (Amount Payables, Oracle Payments, Oracle Sub ledger Accounting, Oracle General Ledger, Procurement), Oracle Ebiz Tax.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa

Oracle Technical/Functional Consultant

Responsibilities:

• Confidential is organized into three major business groups - Global Consumer, Markets & Banking, and Global Wealth Management - in addition to one stand-alone business, Confidential Alternative Investments. The P2P department of Confidential takes care of the Procure to Pay process and to streamline the Procure to Pay process; Confidential has implemented Oracle EBS Suite in more than 50 countries.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Reviews current system documentations and creates KOPs (Key Operating Procedures) documents, Process Flow/Workflow Diagrams for Data Validations like Exception Allocation and Rule Validations.
• Continued support to Productions issues as Second Level techno/functional production support specialist.
• Supporting day to day Production issues in various modules like Payables, Payments, Sub Ledger accounting and General ledger.
• Proficient in writing Packages, procedures, Functions, Views and Database triggers in PL/SQL with extensive use of Oracle Advanced queries.
• Working closely with the Development team to advise concerning changes on program/code level.
• Having working experience in both Development and Production Support of Oracle Applications.
• Developed several outbound programs in General Ledger to transfer the P2P Journal Entries to the various Legacy systems.
• Customized the functionality of R12 Payments Module to meet the client’s payment requirements.
• Worked on Performance tuning of SQL queries.
• Utilize in-depth knowledge of functional and Technical experience in Oracle ERP in conjunction with industry and business skills to deliver solutions to customer.
• Developed many Discoverer and RDF reports in AP and GL module which will help users to perform their daily day to day reporting activity.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Developed detailed level documents and test plan documents.
• Resolving any production level issues that are raised in the form of Incidents or user Acceptance Testing phase issues that are raised in the form of Battle station (BS) requests.
• Delivered new and complex high quality solutions to the client in response to varying business requirements

Environment: Oracle Database 11g &10g, SQL Developer, PL/SQL Developer, SQL Plus, TOAD, WINSCP, SQL*Loader, UNIX Scripting, Oracle Applications R12, SQL, PL-SQL, UNIX, SQL Developer, Putty, Tectia

Oracle Technical/Functional Consultant

Responsibilities:

• Developed several outbound programs in General Ledger to transfer the P2P Journal Entries to the various Legacy systems.
• Customized the functionality of R12 Payments Module to meet the client’s payment requirements.
• Worked on Performance tuning of SQL queries.
• Utilize in-depth knowledge of functional and Technical experience in Oracle ERP in conjunction with industry and business skills to deliver solutions to customer.
• Developed many Discoverer and RDF reports in AP and GL module which will help users to perform their daily day to day reporting activity.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Developed detailed level documents and test plan documents.
• Resolving any production level issues that are raised in the form of Incidents or user Acceptance Testing phase issues that are raised in the form of Battle station (BS) requests.
• Delivered new and complex high quality solutions to the client in response to varying business requirements

Environment: Oracle Database 11g &10g, SQL Developer, PL/SQL Developer, SQL Plus, TOAD, WINSCP, SQL*Loader, UNIX Scripting, Oracle Applications R12, SQL, PL-SQL, UNIX, SQL Developer, Putty, Tectia

Oracle Application Developer

Responsibilities:

• Work with users in the identification of business requirements, and design application solutions to help meet these requirements.
• Development of Oracle Functions, Procedures and Packages for checking movements and replenishments of items in Warehouse and Stores.
• Designed and developed interfaces to legacy systems
• Provided technical and investigative support for functional users on interfaces, defects, change requests, debugging issues, testing, service pack upgrades and adhoc report requirements
• Responsible of designing new report based on Client requirements.
• Involved in extension team and working on Government Number Load Program extension, which is based on AR module.
• Government Number Load Program: - The Solution is designed to assign the Government Issued Number to the corresponding ROTC Dell Transaction Numbers.
• The following approach was used to load the data and update the transactions:
• Development of Upload Utility.
• Developed a Custom API to update the transactions based on the buisness requirements.
• Devolped a Pl/SQL concurrent program that will display all invoices where government issued number is not assigned.
• Designed and executed test cases for the sameCreation of Oracle Reports to monitor Store and Warehouse orders. These are usually called in created Batch scripts.
• Helps the team trouble-shoot complex errors that results from the Production batch runs and related processes.
• Responsible for SQL Query Tuning and Performance Optimization.
• Developed UNIX shell scripts to create HKMS Oracle database user and grant access privileges.
• Customized Oracle Discoverer reports used for Data Warehousing.
• Helps the team in the Corporate Data Warehouse housekeeping - develops and executes SQL scripts to drop/rebuild table partitions, rebuild indexes.
• Used SQL Loader and TOAD utility to move data in between databases.
• Develop SSRS reports for Legacy systems.
• Serves as System Administrator for setting up new users in Oracle EBS Financials, and managing Concurrent Processing.
• Develops ad-hoc reports using SQL scripts for customers of Oracle Financials 11i/R12.
• Work with the team in providing on-call support to users and meeting SLAs.

Environment: Oracle Forms & Reports, Oracle Discoverer, SQL*Plus, PL/SQL, Oracle 11g/12c RDMS, LINUX, Unix, Oracle E-Business Suite Financials R12, Oracle E-Business Suite Order Management (Supply Chain), Oracle Application Express (APEX) 4.2.5, Putty, WinSCP, SQL Loader

Oracle EBS Application Developer

Responsibilities:

• Worked closely with Financial Times’ accountants to get user requirements for report design and development. Create a variety of outputs (customer ready PDF documents, HTML output for optimum online viewing, Excel spreadsheet).
• Tasked to develop/revise high priority BI Publisher reports for Financial Times. This includes developing report requirements for the Finance Controller (mostly Tax Reporting to the Government Bureau) and various global managers.
• Uses SQL*Plus, SQL Developer, Oracle BI Publisher tool, Unix, Oracle Reports to build or edit reports for Financial Times following Development, Documentation, Testing and Acceptance Standards.
• Acts as XML Publisher Administrator - creates Data Definitions, templates or layouts (.RTF files), and register these Concurrent Programs.
• Write ad hoc SQL scripts to quickly produce extracts or reports needed to expedite some business processes.
• Uses Oracle FNDLOAD built-in to migrate Concurrent Programs/Executables, Value Sets/Values, Responsibilities setups from development to UAT/Production environment.
• Assists team members to determine the root cause of an incident by creating several SQL queries/scripts. Give Functional analysis.
• Creates customized Forms and Reports using Oracle APEX 4.2 (JQuery, HTML, CSS).
• Creation of MD050 (Application Extensions Functional Design) & MD070 (Application Extensions Technical Design) documents.
• Review and revise BR100 documentation for the Oracle Financials R12 application set-up.
• Provides status updates of deliverables to Project Management/Stakeholders.
• Designed and developed interfaces to legacy systems
• Provided technical and investigative support for functional users on interfaces, defects, change requests, debugging issues, testing, service pack upgrades and adhoc report requirements
• Responsible of designing new report based on Client requirements.
• Continued support for production issues as third level production support specialist.
• Performance tuning, SQL query enhancements, code enhancements to achieve performance targets
• Worked on Employee Interface, Supplier Conversion, Customer Conversion in which the employee information is imported with SQL*Loader from flat files into staging tables. Developed PL/SQL program to perform validations with employee details, employee assignment, employee address and phone information and move the data from staging tables to interface tables in Oracle Applications.

Environment: Oracle Forms & Reports, Oracle BI/XML Publisher, SQL Navigator, Oracle RDBMS 11g, Unix, Oracle E-Business Suite R12, Oracle Application 11I, UNIX

Oracle EBS Application Developer

Responsibilities:

• Meets with users to gather requirements, work with project team in designing, coding and testing the applications.
• Creates Oracle packages, functions and procedures for Medical Claims logging.
• Develop and revise Oracle Forms and Reports for Provider Entry, Claims Entry
• Creates and revises UNIX shell scripts programs for Application.
• Develop dynamic SQL scripts for purging of data since only 7 years of data are required to be retained in the database.
• Involved in Performance Tuning using Explain Plan and SQL Statement analysis.
• Manages the team of Oracle & Java developers.
• Provide timely updates on risks, issues and escalations along with an action plan to the stakeholders.
• Adherence to all production support - service operation & transition processes like Problem Management, Incident Management, Change Management, Release & Deployment Management. Participate in war rooms and provide on-call support. Ensure audit compliance with organization and project defined standards and processes.
• Identify and propose application performance & process improvement initiatives using ITIL methodologies.
• Provided technical and investigative support for functional users on interfaces, defects, change requests, debugging issues, testing, service pack upgrades and adhoc report requirements
• Continued support for production issues as third level production support specialist

Environment: Oracle Forms/Reports, Oracle10/11g RDBMS, Unix, SQL*Plus, PL/SQL, Microsoft SSRS, TOAD, LINUX