PROFESSIONAL SUMMARY:

• Having 9+ years of extensive IT experience in design, development, implementation and Production Support of Oracle Applications R12, 11i (Oracle e - Business) modules like Purchasing (PO), Inventory (INV), Account Payables (AP), Account Receivable (AR), General Ledger (GL), Order Management (OM), HRMS and i-Procurement.
• Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.
• Strong Technical and program solving skills related to APPS.
• Experience in other modules like I-Procurement, I-Expenses, Project Accounting (PA), Bills of Material (BOM), Work in Progress (WIP), Oracle Shipping (WSH).
• Proficient in Oracle Database 8i/9i/10g, Oracle Applications 11i, R12, Developer 2000 (Reports 6i).
• Good Experience in RICE Components (Reports, Interfaces, Conversions and Extensions) and AOL.
• Extensive experience in Financials, Procure to Pay (P2P) and Order to Cash (O2C) life cycles.
• Extensive experience in Customizing and Developing Oracle Reports 6i/10g.
• Prepared Technical Design Documents using AIM documentation methodology.
• Proficient in writing stored Procedures, Packages and Functions using SQL and PL/SQL
• Extensive experience in using SQL, PL/SQL, SQL*Loader, UNIX, and Shell Scripts.
• Developed Inbound Interfaces and Outbound Interfaces using API.
• Worked on developing the punchout catalogue for Confidential vendors. Specialization in purchasing domain in I-procurement.
• Worked on XML Publisher Reports, Creating Data Templates and complex XML Publisher Templates.
• Excellent problem solving, communication, analytical, interpersonal & leadership skills
• Trouble-shooting user problems during the go-live phase
• Extensive experience identifying product gaps coordinated with development team by creating Technical Assistance Request (TAR)/SR and obtained one-off fixes.
• OpenedService Requests with Oracle Supportin different scenarios, for providing Solutions to the Bugs identified during Production Support. Resolved various bugs, working in collaboration with Oracle Support.
• Experience in customizing and personalizing approvals using Oracle Approval Management (AME) steps.
• Extensive experience in developing Interface and Conversion Programs to import data from various Legacy source files into Oracle Applications using PL/SQL, SQL*Loader, UTL File, Unix Shell script’s, and API’s.
• Knowledge in OA Framework and customization and Personalization of JSP pages.
• Knowledge in developing OBIEE/Siebel Analytics Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, OBIEE/Siebel Security Setup (users/groups, access / query privileges), configured OBIEE/Analytics Metadata objects (Subject Area, Table, Column), Presentation Services/Web Catalog Objects (Dashboard, Pages, Folders, Reports), scheduling iBots.
• Worked on Discoverer Reports
• Extensive experience with AOL to develop Flex fields, Lookups, Validation sets, Concurrent programs, Profile Values, Request Sets registration, and Responsibilities.
• Proficient in writing Stored Procedures, Packages, Functions, Triggers using PL/SQL.
• Well versed with client server environment and tools like Developer/2000, SQL* Loader, SQL Developer, JDeveloper, and TOAD.
• Involved in performance tuning in oracle using Explain plan, Auto Trace, and Tkprof.
• Upgraded shell scripts, which calls reports, control files and sql files which are in the production.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite R12, 11i

ERP Modules: PO, INV, AP, AR, GL, OM, PA, P2P, O2C, and System Administration.

Programming Languages: SQL, PL/SQL

Operating Systems: Windows NT/XP/Unix

RDBMS: Oracle 9i/10g/11g

Development Tools: Forms6i, Reports6i, XML Publisher, OBIEE 10g, 11g 11.1.1.7Reports,SQL*Loader, Discoverer Reports.

Database Tools: Toad, PL/SQL Developer, SQL *Loader, Win SCP, FileZilla, SVN, Stash

PROFESSIONAL EXPERIENCE:

Confidential, FL (Florida)

Oracle Apps Technical Consultant

Environment: Oracle Applications 11i, R12 (PO, INV, AP, AR, GL and HRMS)

Responsibilities:

• DevelopedPL/SQLPackages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using thePayables Open Interface Import program and populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Worked on daily basis Production issues based on the priority, Like Manual data changes, bug fixing...etc.
• Developed Supplier conversion and Customer conversion using API’s.
• Developed Employee Salary Conversion to upload the data from Legacy to Oracle Apps.
• Developed Cash Receipts Conversion and apply them against to Open AR invoices Using API’s.
• Worked on various conversions activity as a part of implementation conversions developed are PO Locations, GL conversion and PO Conversion, Open AR Conversion.
• As per the requirement created and implementedXML/BI Publisherreports for Supplier Creation, AP Invoice Creation.
• DevelopedPL/SQLPackages, Procedures, and Functions for Creation of Suppliers, Supplier Sites, and Bank Accounts from the legacy system and imported into Oracle Application using theSupplier Open Interface Import, Supplier Sites Open Interface Import program and populated into the Base Tables.
• Worked withP2P(Procure to pay) business flow including modulesPO(purchase order),AP(accounts payable) andGL (general ledger).
• ImplementedAuto Lock Boxby importing data into staging table by writing control file according to bank transmission format
• Developed technical design and test documents complying with OracleAIMstandards.
• Responsible for converting the Purchase Orders (PO) in P2P cycle using Import standard Purchase Orders.
• Worked on Version control software GIT/Stash for migrating code to higher instances.
• Involved to discuss with the business people to explain the technical feasibility for their custom process.
• Developed new reports and customization of existing reports as per the business requirement.
• Creation of Concurrent Programs, Executable and Creation of Values Sets.
• Developed XML Publisher reports and Discoverer reports in various modules.
• Coordinating weekly and daily status call with the client and businesses.
• Developed SQL*Loader control file and PL/SQL package (with Validations) for GL conversion
• Worked on GL Interface to load legacy data into oracle application systems
• Developed AR Statement Report as per custom requirement

Confidential, Emeryville, CA

Oracle Apps Technical Consultant

Environment: Oracle Applications R12 (PO, INV, OM)

Responsibilities:

• Imported Items from legacy system intoOracle Inventory(INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories
• Developed new reports and customization of existing reports as per the business requirement.
• Defining Concurrent Programs, Executable and Creation of Values Sets.
• Coordinating weekly status call with the client and businesses for the module
• DevelopedPL/SQLPackages, Procedures, and Functions for Creation of Suppliers, Supplier Sites, and Bank Accounts from the legacy system and imported into Oracle Application using theSupplier Open Interface Import, Supplier Sites Open Interface Import program and populated into the Base Tables. Imported Legacy Journals data intoGLusingJournal import interface.
• Developed XML/BI publisher reports in various modules like PO,INV.AP
• Involved in production support Issues, bug fixing..etc.
• Responsible for preparing procedures, functions, packages as per requirements
• Developed Auto lockbox Receipt Interface program to automate the receipt processing. Loaded the data into AR PAYMENTS INTERFACE ALL. Validated and imported the data into AR base tables.
• Prepared technical documents (MD070) for reports, interfaces and concurrent programs as per business logic.
• Developed Discoverer reports in Purchasing (PO) Module.
• Worked as team member for designing the data migration plan from the legacy system to Oracle Applications, and coordinated with the other developers for preparing test plans, reconciliation reports and detailed design.

Confidential, Denver,CO

Oracle Apps Technical Consultant

Environment: Oracle Applications 11i,R12(PO, INV, AP,HRMS)

Responsibilities:

• Handled the production support environment, working with oracle teams raising SR's and handled severity1 issues
• Developed new reports and customization of existing reports as per the business requirement.
• Worked on LPN’s, Serial numbers in WMS module.
• Developed a custom program Named “Mass Unpack”, used while unpacking the LPN’s.
• Developing new reports and registered with Oracle Application (EBS).
• Customized various transactions inAccounts Receivables (Invoices, Receipts, and Credit Memos and Debit Memos etc).
• Development of Documents like MD 70’s based on functional documents.
• Worked On LPN, Serial numbers, WMS, INV, GL, AP modules and handled all the tickets for production support.
• Defining Concurrent Programs, Executables and Creation of Values Sets.
• Coordinating weekly status call with the client and businesses for the module
• Developed SQL*Loader control file and PL/SQL package (with Validations) for GL conversion
• Involved in unit testing and reviewing of interfaces and reports
• Wrote SQL*Loader script to migrate the data from the legacy system flat file to GL Staging table
• Was involved in developing interface program for AP Invoice Interface and also report to show the imported and rejected data.
• Developed AP Payables Interface program to load legacy payable invoices into Oracle Payables.
• Designed and Developed PL/SQL process with validations to convert all legacy suppliers into AP
• Worked on design and development interface and conversion programs to integrate to import data from various sources using Oracle applications, SQL, PL/SQL and SQL*Loader and TOAD

Confidential

Environment: SQL, PL\SQL and Reports 6iEnvironment: Oracle Apps R12 (AP, PO, GL and HRMS)

Oracle Apps Technical Consultant

Responsibilities:

• Developed Employee Address Conversion to upload the data from Legacy to Oracle Apps.
• Developed Employee Salary Conversion to upload the data from Legacy to Oracle Apps.
• Developed Employee Contacts Conversion to upload the data from Legacy to Oracle Apps.
• Developed Inbound Interfaces and Outbound Interfaces.
• Worked on BI Publisher reports.
• Worked on various conversions activity as apart of implementation conversions developed are PO Locations, Employer Conversion, Customer Conversion, GL conversion and PO Conversion, Open AR Conversion.
• Defined and created new Descriptive Flex fields, Lookups and Value sets to support new Business Requirements.
• Developed test scripts for Unit testing, System Testing, and Integration Testing.
• Developed custom responsibilities for Application End Users.
• Developed many Technical Design documents for the RICE objects
• Developed XML publisher reports in various modules like PO,INV,AP.
• Develop UNIX SHELL SCRIPTS to move code from one instance to the other and perform unit testing.
• As a technical consultant, responsible for Communicating to the end users, Requirements analysis, Functional Specification Documents, Designing Specifications, Coding, Testing, Change Management and support of the Customizations and application extension.
• Created cross s for legacy data to new oracle data and created a profile cross translation which is useful for all modules.
• Prepared technical specifications document (MD 70), test scripts (TE40), Conversion Document (CV40) and deployment documents (MD120) based on the functional requirement specifications (MD 50).
• Involved in post-production support, bug fixing and enhancements of RICE objects.

Confidential

Environment: SQL, PL\SQL and Reports 6iEnvironment: Oracle Apps11i (PO, INV, AP, AR and GL)

Oracle Apps Developer

Responsibilities:

• Analyzed the user requirements.
• Developed new reports and customization of existing reports as per the business requirement.
• Developing AdHoc queries.
• Customized the standard reports in Purchase module like vendor reports, purchase order reports
• Developing new reports and registered with Oracle Application.
• Developing Procedures, Functions and Packages using SQL and PL/SQL.
• Development of Documents like MD 200’s.
• Development and enhancements of custom reports.
• Registering PL/SQL Stored Procedures in Front End using Concurrent Program.
• Defining Concurrent Programs, Executables and Creation of Values Sets.
• Developing SQL scripts as per business requirements.
• Worked extensively in Database Development like developing procedures, packages, triggers, functions, Reports.
• Coordinating weekly status call with the client and businesses for the module

Confidential

Analyst Programmer

Environment: Oracle Applications 11i(PO, INV, AP,GL)

Responsibilities:

• Analyzed the user requirements.
• Created New Reports and registered with Oracle Application.
• Developed Inbound Interfaces and Outbound Interfaces.
• Developed Defined value sets, concurrent programs, registering reports and PL/SQL Procedures, and Packages.
• Creating Packages, Procedures, Functions, Triggers and other database objects using SQL and PL/SQL.
• Developed Inbound Interfaces and Outbound Interfaces.
• Creating staging table with the help of SQL*Loader transfer data from Flat file to Temporary table and Registered SQL*Loader.
• Developed XML/BI Publisher and Reports