Summary

14 years of experience with last 8 years working as Oracle Financial Techno/Functional in Oracle Applications E-Business Suite Financials modules Release R12 (12.1.3), 11i(11.5.10.2) can work independently as well as in a Team Environments.

Excellent Techno/Functional knowledge in Account Payables (AP), General Ledger (GL), Account Receivables (AR), Cash Management (CE), Fixed Assets (FA), Order Management (OM), Purchasing (PO), Inventory Management, Warehouse Management Systems (WMS), Application Object Library (AOL) in R12, 11i(11.5.10.2).

Responsible for Requirements gathering, Systems and Gap Analysis, Designing, Development, Implementation, Customization, Enhancements, Testing and Implementation of Oracle Financials R12, 11i (11.5.10.2) Standard Applications Modules and Customized Applications in Oracle Financial Environment. Complete understanding of Software Development Life Cycle Processes.

Certification

Oracle 11i Financials Certified Professional Consultant, Payables (2007-08)
Oracle 11i Financials Certified Professional Consultant, Receivables (2007-08)
ORACLE Certified Professional Release 2.0, Internet Application Developer Oracle 8i, Forms Release 6/6i, REPORTS Release 6/6i in 2001-2002

Technical Skills

Hardware

IBM Power 750 Express Server, HP9000, RS6000

Operating System

IBM AIX 6.1, IBM AIX 5.3, UNIX, HP-UNIX, WINDOWS, WINDOWS NT

Databases and
Applications

ORACLE Applications Releases R12, 11i(11.5.10.2), 11.5.9, 11.5.8, ORACLE 11g, 10g, ORACLE 9i, ORACLE 8i/ORACLE 8, ORACLE 7.3

Software, Tools, Utilities

Oracle Forms 10g/9i/6i, Oracle Reports 10g/9i/6i, OA Framework(OAF), JDevelper, Oracle Discoverer 10g, Oracle BI Publisher, Oracle Workflow, Web Services, Unix Shell Scripting, Shell Programming, PL/SQL, SQL, SQL*Plus, TOAD, SQL*Loader, SQL Navigator.

Packages

MKS Integrity, CLEARCASE, PVCS, HARVEST, CHANGEMAN, VISIO, Quality Center

Immigration Status

US Citizen

Work History

June 2010 – Presently Working
Confidential,Plymouth, MN

Sr. Oracle EBS Techno/Functional

• Designing, Development, Implementation, and Production support for Oracle R12 (12.1.3) Oracle Financial Applications General Ledger (GL), Accounts Payable (AP), Accounts Receivables (AR), Order Management (OM), Cash Management, Fixed Assets (FA), Warehouse Management and Purchasing Systems.
• Working in a Team Environment including Business Users, Business Analysts, Technical Developers, Oracle Applications DBA, Systems Administrators while working on various New Projects, Enhancement of existing Applications and Production Support.
• Designed, Developed and Implemented ASPEN Accounts Payable Invoice Process to receive all Vendors’ Invoices electronically from Third Party and process in Oracle Applications Accounts Payable system.
• Designed, Developed, Implemented 800 Stores Sales Deposits Bank Reconciliation Custom Designed Applications using OA Framework, BI Publisher, AOL(Application Object Library) integrating with Oracle R12 AR/GL Applications.
• Designing, Development and Production Support for Purchase Order Creation, to process through EDI Process and to send Vendors Electronically. Processing Advance Shipping Notes (ASN) through the EDI Process.
• Designed, Developed, Implementation of Short Fiscal Year for Oracle R12 Applications Modules GL (General ledger), FA (Fixed Assets). System was customized, reconfigured to implement 11 months in Fiscal Year for Company was moving its Fiscal year from March to February to February to January.
• Designed, Developed and Implemented custom Sales Tax Audit Reporting System in Oracle R12 Applications environment using Oracle BI Publisher.
• Designed, Developed and Customized Vendor, Vendor’s Site Maintenance and Purchase Order Interfaces with systems running on AS400 to process Purchase Orders through EDI. Systems were integrated with EDI Purchase Orders and PO Receipts.
• Developed new programs to process XML data files, to load in Oracle Database tables and to create an XML files from Oracle database tables for ACCRUENT, Stores Lease Applications, which are integrated with Oracle R12 Accounts Payables (AP) and General Ledger (GL) Modules. Calling SOAP Web Services Methods including SOAP Encoding/Literal Types through Oracle Financial Packages.
• Designed, Developed, Implemented customized GL Interfaces Programs supporting various Stores Transactions including Markdowns, Sales Events, processed through IBM Mainframe System to Oracle Financial General Ledger.
• Working as a Systems Administrator, supporting end-users including Creating, Maintaining Users, Roles, Responsibility, Concurrent Request Manager, FNDLOAD, XDOLoader utilities to migrate Standard Oracle Financial and Custom Designed Objects across various instances in SDLC Process.
• Creating TAR (Technical Assistance Request) on Metalink for Technical/Functional Support with Oracle while finding issues in existing Oracle Applications Standard Applications Functions during Implementation, Production Support or while customizing existing Oracle Financial Standard Modules for Company’s new or enhanced business requirements.
• Designed and Developed various new Descriptive Flexfields (DFF) for Standard Oracle R12 Applications Modules.
• Systems are designed using Oracle Applications R12 (12.1.3), Oracle 11g/10g/9i, Oracle Application Framework(OAF), JDeveloper, Oracle Forms 10g/9i, Oracle Reports 10g/9i, Oracle BI Publisher, Oracle Workflow, Oracle Discoverer 10g, Oracle PL/SQL, HP-UNIX, SQL*LOADER, TOAD.

December 2009 – May 2010
Confidential,Hyattsville, MD Employer: M-Cubed Information Systems Inc.

Sr. Oracle E-Business Techno/Functional

• RICE (Reporting, Implementation, Customization, Enhancement) for Oracle Financial Release R12, Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Integrating (Governmentwide Financial Reporting Systems(GFRS), Governmentwide Treasury Account Symbol Adjusted Trial Balance System (GTAS) with Oracle R12 Financial Modules.
• Gathered functional and technical requirements from the end-users and analyzed existing legacy system.
• Working on Software Development Life Cycle (SDLC) for implementation of Custom Designed Applications in Oracle R12 Environment for GTAS, GFRS Applications using Oracle R12 Standard Objects including TEMPLATE.FMB, CUSTOM.PLL, PERSONALIZATION and Application Object Library (AOL) for Development, Implementation of Custom Designed Forms and Oracle R12 Standard Forms for A/R, A/P and G/L Modules.
• Designing and Development of new Custom Reports for GTAS, GFRS Financial Systems based on custom requirement.
• Supporting Standard Oracle R12 A/R, A/P, G/L modules in production environment including working on daily production issues, discussing business requirements with the end users, creating design documents including Business Requirements, Conceptual Design Document, Technical Design documents including Unit Test Plan, System Integration Test Plan.
• Systems are designed using Oracle Applications R12 (12.1.3), OA Framework, JDeveloper, Oracle 10g/9i, Oracle Forms 10g/9i, Oracle Reports 10g/9i, Oracle Discoverer 10g, Oracle Workflow, Oracle PL/SQL, HP-UNIX, SQL*LOADER, TOAD.

November 2008 – September 2009
Confidential,Minnesota

Sr. Oracle E-Business Techno/Functional

• RICE (Reporting, Implementation, Customization, Enhancement) for Oracle Financial Release R12, Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL) for integrating FPS (Foreign Post Settlement) System with Oracle R12 Standard Applications Module.
• Designed, Developed, Implemented and Supported Interface programs and data conversion packages for FPS Custom modules for GL data import and batch processing.
• Designed and Developed new data transmission, conversion and data validation reports for FPS and Oracle R12 General ledger Module.
• Designing, Development, Maintenance and Support of Custom Oracle Financial R12 Application for FPS (Foreign Post Settlement Projects) including Mail Log, Task Tracker, Account Reconciliation, Billing Modules.
• Discussing with end-users functional requirements and providing solutions for the proposed system to implement the new custom designed application.
• Designed Database Tables for custom applications, Designed and developed new forms for custom forms using Oracle Forms 10g, Oracle Application Object Libraries (AOL) using TEMPLATE.fmb and CUSTOM.pll library objects.
• Implementation and expansion of Flexfields with Cross-Referencing extensively to capture additional information in various Standard Oracle R12 Applications Modules.
• Designed and Developed forms using Oracle ATTACHMENTS Standard Functionality to share information across various customized and standard oracle Release R12 Application forms.
• Used personalization to customize Oracle Applications standard Attachment Functionality as well as calling multiple forms from single form through Form personalization.
• Designed and developed customized Oracle Applications form to view data with Oracle Standard FOLDERS functionality.
• Designed and developed new Forms in Forms 10g/9i and Reports in Report 10g/9i for Custom Application through Concurrent Request from Oracle Forms Custom Applications, which is implemented with Oracle Financial Release R12 Modules.
• Used Oracle R12 AOL Custom Objects and Libraries to develop new forms to implement Attachment Functionality, Forms Personalization and Creating Descriptive Flexfield Features in Oracle R12 Custom Forms Applications.
• Created Dependant, Independent, Table Types Values Sets to validate Descriptive Flexfield Input in Custom and Standard Forms, Parameter Values for Reports and Concurrent Programs.
• Systems are designed using Oracle Applications R12 (12.1.3), OA Framework (OAF), JDeveloper, Oracle 10g/9i, Oracle Forms 10g/9i, Oracle Reports 10g/9i, Oracle Discoverer, Oracle XML Publisher 5.6.2, Oracle PL/SQL, HP-UNIX, SQL*LOADER, TOAD.

May 2007 – October 2008
Confidential,Minnesota, USA

Sr. Oracle EBS Techno/Functional

• Supporting Oracle Applications 11i (11.5.10.2), Oracle Applications 11.5.9 including A/R, A/P, G/L and PO, Order Management, Purchasing, Procurement, Supplier Chain Management (SCM) modules including Production Support, Enhancement, Customization of existing Oracle 11i Standard Forms, Reports and Oracle PL/SQL Packages using Oracle Standard TEMPLATE.fmb form and CUSTOM.pll Object Library.
• Designed and Developed Data Conversion process for Oracle 11i (11.5.10.2) A/P, GL and A/R modules to populate Standard API Tables from the Custom Staging tables.
• Wrote Data conversion scripts, data load, data validation scripts for data conversion from 11.5.9 to 11.5.10.2 (11i) Releases.
• Creating New Forms, Menu Items, and Defining Concurrent executables, Concurrent Request for Customized Oracle Forms Applications, Oracle Reports, Oracle PL/SQL procedures and packages for Oracle 11i Application extensions.
• Creating and Maintaining Users and their responsibilities, creating new responsibility, Assigning Customized Forms, Reports and Oracle PL/SQL batch jobs to Responsibilities and Request Groups.
• Designing, Development and Customization of Consumer Lending Financial Applications.
• Providing Customer Supports including System Requirement Study, Customization of Standard Functions, Product Development, and Enhancement based on customer requirements, Supporting Post-Implementation of such applications for various Clients.
• Creating Functional, Technical Design Document, Test Plan for Custom Application designed and developed in integration with Oracle 11i Financial Applications including A/R, A/P and GL Modules.
• Customization of various API (Application Program Interface) Modules for Data Conversion Process and providing full customer support during Designing, Development and Implementation of such Data Conversion Process.
• Systems are designed using Oracle Applications 11i, Oracle Applications 11.5.9, Oracle 9i/10g, Oracle Forms 6i/10g/Reports 6i/10g, Oracle Discover 10g, Oracle XML Publisher, Oracle PL/SQL, HP-UNIX, SQL*LOADER, TOAD.

September 2004 – April 2007
Confidential,USA
Michigan

Sr. Oracle Financial EBS Techno/Functional

• Supporting Oracle 11i (11.5.10.2), Oracle Applications 11.5.8 including A/R. A/P,GL, Purchasing, Procurement, Supplier Chain Management (SCM) Modules including Customization of existing Oracle 11i Forms, Reports and Oracle PL/SQL Procedure and Packages for system upgrade.
• Designed, Developed and Implemented data conversion process while system upgrade from Oracle 11.5.8 to Oracle 11i (11.5.10.2).
• Designed, developed and implemented data import, validation and load programs for non-standard data source interfacing with standard Oracle 11i Applications modules including Purchasing(PO), Accounts payable(A/P) and General Ledger (GL).
• Designed data validation reports for custom data load and validation process for data conversion for system upgrade from 11.5.8 to 11i (11.5.10.2).
• Designing and Development of new Forms and Reports, Defining executables, Concurrent Request, Users, Responsibilities and to Maintain Request Groups for Oracle Forms, Reports and PL/SQL Procedures and Packages.
• Designing and Development of various New Commercial Application including Customer Express Pay Project, Automate Theft Investigation Process, Electrical Outage Project, Implementation of Data Security and Data Quality Projects for Customer Services & Billing Department, Field Service Automation Group and CSO (Customer Service Online).
• Migrated application modules including Oracle Forms 6i and Reports 6i to Oracle Forms 10g and Oracle Reports 10g with customization based of specific requirements which were developed, tested and having supported during pre-implementation and post-implementation process as well as providing production support.
• Writing Batch Programs for various Back-end, Day end Process and Other Interface Requirements for Stand alone and Interface Applications.
• Providing Technical Supports to Quality Assurance Team and Other Business People during Testing, Pre-Implementation, Post-Implementation and User Training of new and enhanced applications.
• Systems are designed using Oracle Applications 11i, Oracle Applications 11.5.8, Oracle 10g, Oracle 10g Forms/Reports, Oracle Discoverer 10g, Oracle 9i, Oracle Forms 6i, and Oracle Report 6i, Oracle PL/SQL, HP-UNIX, SQL*LOADER, TUXEDO.