SUMMARY:

• 15+ years of total experience as a diligent and team spirited senior software developer.
• Expert Oracle Financials, Oracle Federal Financials Applications, Oracle CRM, Oracle HRMS & Oracle SCM.
• Expert in Oracle Forms/Reports, SQL, PL/SQL, Open Interfaces and APIs.
• Expert in migration and upgrade of Oracle Forms and Reports from 6i, 9i, 10g to 12c.
• Experience in Data Migration & Data Conversion. Expert in development of interfaces and conversion programs to import data from various sources into Oracle Applications using Oracle Tools and Utilities such as PL/ SQL, SQL*Loader, Import/Export and UTL FILE.
• Extensive experience in the following modules - GL, AR, AP, PO, PA, INV, OM, Advanced Pricing, HR, Payroll, Service Contract, Install base, Field Service etc.
• Knowledgeable in Oracle Financial, SCM Cloud & HCM on SaaS (Software as a Service).
• Extensive experience in design and development of various business processes using ADF, Forms, Reports, Designer, Apex, Discoverer, BI Publisher, OBIEE, XML Publisher, OA Framework, Workflows.
• Extensive experience in performance tuning and query optimization using oracle Explain Plan, SQL Trace, TKPROF, Toad, Oracle hints etc.
• Extensive experience in Configuration, Extension, Modification, Localization and Integration (CEMLI), Reports, Interfaces, Conversions and Extensions (RICE), Oracle Application Implementation Methodology (AIM), Software development Life Cycle (SDLC).
• Experienced in AGILE implementation methodology.
• Experience in requirement gathering, Analysis, Design, Development, Testing, Implementation, maintenance and support of projects.
• Experience in gathering business baseline requirements (RD020), preparing future Business scenarios (RD070) as well as performing Fit/Gap Analysis, Solution Design (MD50 & MD070), Test Scripts (TE20 & 40) and preparing the application setup document (BR100).
• Extensive experience as an Effective team member with excellent Verbal and written communication skills. Motivated with an ability to work under pressure and give support to projects irrespective of day and time.

TECHNICAL SKILLS:Operating Systems: Windows, UNIX.

Languages : C, SQL, PL/SQL, HTML, Java Script, Shell script.

Software /GUI Tools : ADF, Oracle Forms & Reports, Oracle Discoverer, BI Publisher, OBIEE, Oracle Designer, Apex, Oracle Workflow, JDeveloper.

Databases : Oracle, SQL Server.

ERP Tools : Oracle Applications- Oracle CRM, Oracle Financials, HRMS, Oracle Federal Financials, Oracle SCM.

Third party tools : WINCVS, KINTANA (HP PPM/ Mercury ITG).

Functional Areas: Financials, CRM, Payables, Receivables, HR, Sales & Marketing

Modules :

• Accounts Payable (AP)
• Accounts Receivables (AR)
• General Ledger (GL)
• Sub Ledger Accounting (SLA)
• EBTax
• Service Contracts
• Install base
• Field Service
• Sales Contracts
• iExpense
• iProcurement
• Fixed Assets (FA)
• PA(Project Accounting)
• Cash Management (CM/CE)
• Advanced Collections
• Advance Benefits
• Purchasing (PO)
• Order Management (OM)
• Advanced Pricing
• Advanced Supply chain Planning (ASCP)
• Shipping (WSH)
• Warehouse management (WHM)
• Depot Repair(DM)
• Inventory (INV)
• Procure to Pay(P2P)
• Order to Cash (OTC)
• Core HR
• Oracle Time and Labor (OTL)
• Payroll
• Oracle Advance Benefits(OAB)
• Service to Contract
• iStore
• iSupplier
• Oracle Trade Management
• Oracle Transport Management(OTM)
• Oracle Credit Management
• Oracle Retail
• Oracle Incentive Management (OIC)

PROFESSIONAL EXPERIENCE:

Confidential

LINTHICUM, MD, USA

Senior Oracle Federal Financials Application Developer

• Responsible for Code Review during this process advised various query modifications and query tunings.
• Fixed performance issues in various reports.
• Responsible for validating TKPROF based on the request ID.
• Responsible for running load runner program and preparing stats.
• Responsible for running quarterly work load program preparing Quarterly System Status Report.
• Fixed issues in reports such as Dunning Letter Summary Report, Dunning letter detail report, CMSAA R250 Report Transactions Load Process etc.
• Responsible for reviewing and fixing the issues in AITOSYS Program.
• Fixed custom AP Program by adding additional values to API due to faulty supplier names.
• Modified Demand Letter address changes for workload customer sites.

ENVIRONMENT: ORACLE FEDERAL FINANCIAL APPLICATIONS R12, ORACLE FORMS & REPORTS, ORACLE 12C, ORACLE DISCOVERER, ADF, SQL, PL/ SQL, JAVA, TOAD, SQL LOADER, WORKFLOW BUILDER, JDEVELOPER, OBIEE, BI PUBLISHER.

WICHITA, KS, USA.

Oracle Project Lead

• Responsible for leading a team of 5-10 developers (onsite and offshore), meeting up with managers and update work statuses, providing technical and functional help to team members, analyzing and troubleshooting complex issues and implementing solutions.
• Interacted with users to gather requirements in various modules and convert them to functional documents and provided assistance to clients and team members in mapping business practices and designing and implementing solutions respectively.
• Applied Agile Scrum methodologies to better adapt to the business requirements changes and quickly designed, coded & implemented Oracle Financial Applications with Scrum teams.
• Responsible for resolving the issues based on incidents created.
• Responsible for developing an interface program that creates payments in AR/AP.
• Modified the hotel search based on the distance in Custom Lodging Screen.
• Fixed the issues in Custom Payments Report.

ENVIRONMENT: ORACLE EBS, ORACLE FORMS & REPORTS, ORACLE 11g, ORACLE FINANCIAL APPLICATIONS R12, SQL, PL/ SQL, JAVA, TOAD, SQL LOADER, AGILE, JDEVELOPER, OBIEE, BI PUBLISHER.

JAMESBURG, NJ, USA

Senior Oracle E-Business Suite Consultant

• Responsible for building a PL/SQL program to display required Counters in Preview billing and terminating machines in Install Base also responsible for conversions in Install base, Service Contracts, Field Service from SQL Server to Oracle Applications.
• Customization in pending meter read report (Aggregate contract number, profile name, consolidate serial number), creating Service Contracts for new orders, Contract renewals, adding a new Column in Aggregate contract number, consolidation billing and status, creating aggregate billing contract and a new QA check in Service Contract. Also developed new field inventory summary report. (Service Contract).
• Responsible for Incorporating a new business logic in Supply fulfillment screen and local fulfillment check fetching third party order line type from value set (Order Management-OM).
• Responsible for reading E-mail data and creating Supply Orders.
• Responsible for new multi meter business logic in interface meter reads in ADS. (Outbound Contract).
• Responsible for added multiplier, aggregate contract number columns to third party contracts integration system. Also worked on adding total number of calls assigned, Number of successful phone fixes, number of phone fixes, % of Phone fixes attempted, % of successful phone fixes new columns to tech productivity report. (Service Contract).
• Responsible for creating a new program to close all open phone fix tasks, creating automatic service calls and sending E-mails to customers based on service request. (Field Service).
• Responsible for building Contract Billing Report, Pending Shell Report, Customer Machine Contract etc. using OBIEE. Also responsible for creating a new program to updated master template attributes values to all dependent machines and for customization of AP Check printing program, sales order acknowledge and packing slip reports in OM, INV and AP and validating Bin Ranges (Master, Visa etc.) in AR. Built GL conversion for Journal Import.
• Developed crucial reports using BI Publisher and Default Notice Supporting Document Report (AR), Collection Stats Report (AR), Balance Reports etc.
• Responsible for building/ customization of Interfaces in Oracle Financial application modules (GL, AR, AP, CM, FA, SLA, EBTax etc.) and for populating Meter reads for customer billings in AR.
• Responsible for Customer Conversions fetching the data from SQL server into Oracle Applications.
• Responsible for creating a new view to OFSI to access invoice created by Canon, Customizations in AP remittance report and EDI Extensions. Also developed a report for customer machine information in Oracle Financials.
• Responsible for creating requisition to procure goods and service with supplier information, delivery instructions, multiple accounting distributions, and notes to buyers, approvers, and receivers.
• Worked with P2P (Procure to pay) business flow including modules PO (purchase order), AP (accounts payable) and GL (general ledger).
• Responsible for code migrations using HP PPM tool.
• Responsible for Analyzing, designing, developing, testing, implementing and supporting computer software programs for various applications using SQL, PL/SQL, TOAD, SQL Loader, HTML, Java Script, Shell Script, Oracle Forms/Reports, Oracle Discoverer, BI Publisher, OBIEE, XML, JDeveloper, OA Framework, Oracle Workflow, Oracle financials, CRM and HRMS.

ENVIRONMENT: ORACLE EBS, ORACLE APPLICATIONS R12, ORACLE FORMS & REPORTS, ORACLE 11g, ORACLE DISCOVERER, ORACLE FINANCIALS, CRM, SCM, HRMS, ADF, SQL, PL/ SQL, JAVA, TOAD, SQL LOADER, WORKFLOW BUILDER, JDEVELOPER, OBIEE, BI PUBLISHER.

PELLA, IA, USA.

 Senior Oracle E-Business Suite Consultant

• Responsible for Customization of Oracle Financials applications and reports like account Analysis Report, Account Reconciliation Reserve Ledger Report in GL.
• Created a new data extract for Concurrent Connected List Extract in AP also Customized Punch Invoice on Hold Extract in AP.
• Responsible for Customization of Cost Summary Report in Oracle Assets, Customization of ME Inventory Extract in Oracle Inventory (INV). Developed 3 new dunning letters for collections. Developed Invoice (INV) Interface from OMS to Oracle Applications, GL Interface from OMS to Oracle Applications and Vendor Interface from Oracle Applications to OMS. Developed new statement generation Report in AR.
• Worked on Customization of US Sales Tax Report in AR Module of Oracle Financial Applications. Created new customer region under updated Service Request Page, restricted message choice list of create tasks using template in update service request page.
• Created new region in updated task service request page based on task type.
• Responsible for restricting note type message choice list in update task service request page.
• Responsible for creating two new columns “City” and “Task Type” which have been added to Field Service Technical Dashboard.
• Created New Custom region under Update task details tab in Field Service Technical Dashboard also helped in the creation of “City” and “Creation Date” columns which have been added under My Customer Event Region in Agent Dashboard. Personalization in Customer Support Specialist and Field Service Technical Portal done. Created All Extensions in Custom Responsibility.

ENVIRONMENT: ORACLE EBS, ORACLE APPLICATIONS R12, ORACLE FINANCIALS, ORACLE FORMS 10g, REPORTS 10g, ORACLE 11g, SQL, PL/ SQL, JAVA, TOAD, ORACLE APPLICATIONS FRAMEWORK, SQL LOADER, WORKFLOW BUILDER, JDEVELOPER, BI PUBLISHER.

Conyers, GA

Senior Oracle E-Business Suite Consultant

• Responsible for Customization of Oracle Financials applications and reports like account Analysis Report, Account Reconciliation Reserve Ledger Report in GL.
• Created a new data extract for Concurrent Connected List Extract in AP also Customized Punch Invoice on Hold Extract in AP. 
• Responsible for Customization of Cost Summary Report in Oracle Assets, Customization of ME Inventory Extract in Oracle Inventory (INV). Developed 3 new dunning letters for collections. Developed Invoice (INV) Interface from OMS to Oracle Applications, GL Interface from OMS to Oracle Applications and Vendor Interface from Oracle Applications to OMS. Developed new statement generation Report in AR. 
• Worked on Customization of US Sales Tax Report in AR Module of Oracle Financial Applications. Created new customer region under updated Service Request Page, restricted message choice list of create tasks using template in update service request page. 
• Created new region in updated task service request page based on task type. 
• Responsible for restricting note type message choice list in update task service request page.
• Responsible for creating two new columns “City” and “Task Type” which have been added to Field Service Technical Dashboard. 
• Created New Custom region under Update task details tab in Field Service Technical Dashboard also helped in the creation of “City” and “Creation Date” columns which have been added under My Customer Event Region in Agent Dashboard. Personalization in Customer Support Specialist and Field Service Technical Portal done. Created All Extensions in Custom Responsibility.

ENVIRONMENT: ORACLE FORMS 10g, REPORTS 10g, ORACLE 11g, ORACLE DISCOVERER, ORACLE APPLICATIONS 11i, R12, ORACLE FINANCIALS, SQL, PL/ SQL, JAVA, TOAD, OA FRAMEWORK, SQL LOADER, WORKFLOW BUILDER, JDEVELOPER, BI PUBLISHER, UNIX, WINDOWS XP.

GA, USA

 Senior Oracle Federal Financials Applications Consultant

Responsibilities:

• Responsible for Customization of Oracle Financials applications and reports like account Analysis Report, Account Reconciliation Reserve Ledger Report in GL.
• Created a new data extract for Concurrent Connected List Extract in AP also Customized Punch Invoice on Hold Extract in AP. 
• Responsible for Customization of Cost Summary Report in Oracle Assets, Customization of ME Inventory Extract in Oracle Inventory (INV). Developed 3 new dunning letters for collections. Developed Invoice (INV) Interface from OMS to Oracle Applications, GL Interface from OMS to Oracle Applications and Vendor Interface from Oracle Applications to OMS. Developed new statement generation Report in AR. 
• Worked on Customization of US Sales Tax Report in AR Module of Oracle Financial Applications. Created new customer region under updated Service Request Page, restricted message choice list of create tasks using template in update service request page. 
• Created new region in updated task service request page based on task type. 
• Responsible for restricting note type message choice list in update task service request page.
• Responsible for creating two new columns “City” and “Task Type” which have been added to Field Service Technical Dashboard. 
• Created New Custom region under Update task details tab in Field Service Technical Dashboard also helped in the creation of “City” and “Creation Date” columns which have been added under My Customer Event Region in Agent Dashboard. Personalization in Customer Support Specialist and Field Service Technical Portal done. Created All Extensions in Custom Responsibility.

ENVIRONMENT: ORACLE FORMS 6i, REPORTS 6i, ORACLE 10g, ORACLE DISCOVERER, ORACLE APPLICATIONS 11i, R12, ORACLE FEDERAL FINANCIALS, ORACLE E BUSINESS SUITE 11.5.10., SQL, PL/ SQL, JAVA, TOAD,, SQL LOADER, WORKFLOW BUILDER, XML PUBLISHER.