Senior Oracle Application Technical Consultant with over 10 years of experience in software development, database development administration, and operational IT. Excellent communication skills including strong writing skills, Strong analytical and problem-solving skills, proven history of successful problem solving with a sense of urgency.
Hands-on Experience in developing RICEW components using SQL, PL/SQL, Oracle Reports (RDF), XML Publisher (RTF), Oracle Forms, Oracle Application Framework OAF, Oracle Workflows, SQLLoader, Data Conversion, Data Migration, Oracle standard API's and Developing Interfaces within several modules in Oracle Applications EBS R12. Proficient experience in Oracle Financials, SCM Modules - General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, Purchasing, Inventory, HRMS.
Strong knowledge of Application Object Library (AOL) implementation standards, Application Implementation Methodology (AIM), Trading Community Architecture (TCA), and software Development Life Cycle (SDLC). Expertise in designing and implementing Oracle Alerts, Lookups, Personalization, Customization, and extension. Extensively worked on Oracle PL/SQL Development - Packages, Stored Procedures, Functions, Anonymous Procedures, and Triggers, effectively used Indexes, Collections, Materialized views, Analytical Functions, Database tables, and Schemas. Expert in Oracle Performance Tuning using Gather Stats, TK Prof, Explain Plan, Hints, SQL Trace. Expertise in Oracle Application Express Apex. Hands-on Experience in database cloning, patching, maintenance, administration, and technical support. Experience in customization, upgrade of Oracle E-Business Suite.
Key Deliverables:
· Closely worked with Functional Consultant to understand business needs and objectives.
· Worked on the development of interfaces, data Conversions, developing new Custom Forms, Reports, Form customization in various EBS modules such as Financial, HRMS, and SCM.
· Worked on GL interface to load journal entries from flat files to GL interface table.
· Developed various Customized GL reports like PNL and Account Analysis, extension and enhancement of standard Trial Balance report
· Design and Development of Custom Solution in EBS R12 for LPS (Ledger Posting Summary), in LPS project includes the creation of several custom schema objects tables, views, Package, procedures, function, Custom form for Data Entry, RDF Reports, and Profiling.
· HRMS data cleansing designed and developed API PLSQL code for Employee data uploads and updating existing data, locations, and addresses.
· Developed Custom Material Management Process of items reservation for Purchase Requisitions from multiple Sub-Inventories and GTN process of Sub Inventory Transfer, this project includes several custom forms, reports, database schema objects like Tables, Views, Package (procedures and functions) Oracle Standard APIs, and the use of several DFF.
· Developed Custom OAF project for finance Department Demand & Release of funds which includes OAF pages for data Entry and Approval notifications.
· Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
Key Deliverables:
• Closely worked with users and business analyst to understand business needs and objectives.
• Worked on the development of interfaces, Data Conversions, Developing new Forms, Reports, Customizing existing Reports In various modules such as AR, FA, PO and AP, GL.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Involved in Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs
• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.
• Customer invoicing in AR module Automation, developed software package in C# to import customers invoices from MIS MSSQL server to oracle AR interface, customized form development for AR interface imports from flat files and external database.
• Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
• Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
• Developed various Custom reports in AR, AP, FA and GL module, Customized existing reports according to the functional specifications using Reports 10g and XML publisher.
• Worked on SQL*Loader Scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.
• Developed Customized Application in Oracle Application Express APEX, Management Dashboard for Profit & Loss, Balance Sheet, Revenue and Receivables.
• Performed DBA duties occasionally like Applying Patches to EBS oracle Database and Application Tiers, Cloning EBS Production instance to Test/Development environment.
• Follow up on SR with Oracle online support
Key Deliverables:
• Developed customized Practice Management System (PMS) in Oracle Forms & Reports 10g.
• Installation and Troubleshooting of oracle 10g and 11g databases.
• Creating new users and assigning roles/privileges as directed by management in PMS.
• Providing support and guidelines to end users for using, accessing database from client interface and troubleshooting connectivity issues with clients.
• Installation, configuration and administration of network devices Routers and switches.
• Troubleshooting and solving problems with LAN/WAN connections
• Configuration and troubleshooting VPN connection to KPMG global intranet.
• Monitoring users’ actives to insure full compliance with the IT policy of organization.
• Active directory management.
• Configuration of DHCP, DNS, WINS and File Server on windows server 2003/2008/2012
• Managing and creating email accounts on Exchange Server.
• Providing orientation and training to staff members on Information Risk Management.
• Assisting IRM team in IT internal Audit.