Candidates About

SUMMARY:

·         10+ years of progressive industry experience in requirement gathering, analysis, design, implementation, testing, documentation, production support and upgrade of Oracle based business applications.

·         Good understanding of E-Business Suite Modules (Loans (LNS), Accounts Receivables (AR), Accounts Payables (AP),  General Ledger (GL), Sub Ledger Accounting (SLA), Budget Execution(BE), Federal Financials (FV)), Discrete Manufacturing (Inventory (INV), Purchasing (PO), Order Management (OM), Bill Of Materials (BOM) , Work In Process (WIP) Project Accounting (PA)).

·         Strong skills in Oracle Applications R12 (12.0.4, 12.1.3, 12.2.5)/11i and Oracle databases 11g/10g/9i/8i.

·         Experience in Implementation, Upgrade and Support of Supply Chain and Finance modules.

·         Proven efficiency in developing RICEW (Reports, Interfaces, Conversions, Enhancements (or Extensions) and Workflow), OAF components and Oracle Alerts.

·         Extensive Experience in SYSADMIN (user creation, adding menus, registering concurrent programs, assigning responsibilities,) and AOL tasks.

·         Expertise in AIM methodology to enrich project management and documentation processes.

·         Experience in code reviews, integration and end-user support.

·         Excellent analytical, problem solving, work ethics, communication, inter-personal and presentation skills.

PROFESSIONAL EXPERIENCE:

A Government Agency                                                                                  Mar ’17 – Till Date

Role: Senior Oracle EBS Federal Financial Consultant

Environment:

Oracle Applications 12.2.5, UNIX, pl/sql, Forms 10g, BI Publisher, Workflow , OAF, PO, LNS, GL, AP, AR.

Responsibilities:

Agency’s Chart Of Accounts are being redesigned to exclude GAAP Accounting.

• Analyzed effect on all the technical components and provided estimates for all Interfaces.
• Developed and Unit tested all the Interfaces.
• Updated MD 070 documents for these Interfaces.
• Organized demos to explain the changes as part of these Interface changes.

XO Communications

Role: Senior Oracle EBS Techno Functional Consultant                            Mar ’15 – Feb ‘17

Environment:

Oracle Applications  12.1.3, AOL, UNIX, pl/sql, reports 10g, Forms 10g, BI Publisher, INV, OM, PO, GL, AP, AR, Oracle Project Accounting.

Responsibilities:

XO’s Inventory maintenance system was integrated with Fulcrum’s Asset Tracking System (CATS) for better traceability. Oracle processes inventory transactions from CATS for financial reconciliation.

• Handled entire conversion efforts:
  • Vendors
  • Items
  • Purchase Orders(Open Purchase Orders)
  • Requisitions(Open PR’s)
  • Projects and Tasks
  • HR Locations
  • Manufacturers
• Implemented COSTING solution that suits XO needs.  
• Customized cost calculations.
• Developed Interfaces to push changes from Oracle to CATS in a timely manner.
• Developed Interfaces in Oracle to consume Inventory transactions originated from CATS.
  • Install Transactions
  • InterOrg Transactions
  • Unships/Audits
  • PO Receipts
  • PO Returns
  • Site Returns
• Active participant in cut-off /shut down activities.
• Developed reconciliation reports for CATS and ORACLE.

Export-Import Bank of the United States (A Government Agency)

Role: Oracle EBS Federal Financial Technical Consultant                          Nov ’13 – Mar ‘15

Environment:

Oracle Applications  12.1.3, UNIX, pl/sql, Forms 10g, BI Publisher, Workflow , OAF, PO, LNS, GL, AP, AR.

Responsibilities:

• One of the key resources in conversion team (Supplier conversion, Purchase Order, Bank, Employees )
• Responsible for the implementation of the Treasury’s CIR Inbound interface to completely automate EXIM’s receipt collection mechanism. Played a key role in gathering requirements by constant interaction with Treasury POC, Cash Control and On-Site DBA to ensure that the interface covers all the business needs of EXIM bank.

o   Key player for Interface/Conversion Design and Development.

·         XML based Collection Interface Repository Interface (Treasury Interface)

·         Fee Accrual Process (Dividing the fee income recognized across the life of (Fee) Loan).

·         Supplier Interface/Conversion.

·         Supplier Bank Interface/Conversion.

·         Purchase Order Interface/Conversion.

·         Annual Exposure Fee Calculation

·         Customized various programs as per functional team’s requirements during the implementation phase.

·         Month-End Accrual Programs.

o   Developed XML Publisher reports (BOC Activity, Pending Exposure Fee, AR Receipt Details etc.).

o   Modified standard AP Invoice Workflow to suit customer needs.

o   Consistent right on-time delivery of the objects with great accuracy and with proper documentation.

o   Ability to explain the team and the users with Proof of Concept Strategy for any issue/requirement/observance/development.

o   Experience in Performance Tuning objects.

Art.com, Emeryville, CA                               

Role: Sr. Oracle Apps Developer                                                      Oct ’08 – May ‘13

Environment:

Oracle Applications 12.0.4 and 12.1.3, AOL, UNIX, pl/sql, reports 6i, Discoverer, BI Publisher, Workflow (PO Approval Workflow is completely customized), PO, OM, BOM, WIP, INV, GL, AP, AR.

Responsibilities:

o   Upgrade Project (Apps from R12.0.4 to 12.1.3 and database 10g to 11g)

·         Upgrade activities of current business processes (12.0.4) to 12.1.3 (BOM, WIP, INV, AP and PO).

·         Mapping, assessing the performance impact (adding index, table partition) of the custom code with database upgrade and Extensive Testing.

o   Adding B2B partners to business (Museums, Kohl’s, JCPenney, CondeNast, Lowes, etc.)

·         Custom upload templates were created to upload items, price for the items, cross references and item categories.

·         Handled proper flow of data through SOA to outside systems (feeder system being Oracle).

·         Worked on interfaces to feed data to EDI (Electronic Data Interchange) templates like 846 (Inventory Feed) to B2B partners like Amazon, Target, Kohls, etc.

o   Drop Ship Implementation

o   RTV (Return To Vendor)

·         Created custom program, triggers to cancel the purchase order shipments in case of RTV and send the list of cancellations to business users which might cascade sales order line cancellation.

o   Workflow Purge

o   Oracle Apps Implementation

·         Member of the Oracle Application (12.0.4) implementation project.

·         Worked on Conversions, Interfaces(Outbound and Inbound) and Reports (PL/SQL, rdf, (XML) BI Publisher and Discoverer)

·         Prepared MD 070, CV 070, CV 060, MD 120 AIM documents.

o   Production Support

·         Support for Month-End Close/Quarter Close/Year End Activities.

·         Handled Back-To-Back Order, Drop Ship, In-stock, OSP (Out Side Processing) fulfillment scenarios.

·         Modified PO Approval Workflow for business requirements (modifying email format).

·         Worked with highly customized code for sales order progression (Work Order Release, requisition creation, consolidating multiple requisitions to purchase orders, sending purchased orders to vendors and acknowledgement), Importing AR Receipt.

·         Lead offshore team in development, bug fix and enhancements projects by providing technical guidance as SME and driving all the tasks to completion.

·         Provided extensive operations support to maintain the uptime and availability of production applications using AWR (Automatic Workload Repository) report.

Shutterfly, Redwood city, CA                                                                                Mar ’08 – Oct ‘08

Role: Oracle Apps Techno-functional Consultant

Responsibilities:

o   Involved in requirements gathering from business users for GL Conversion, FA Conversion, AP Invoices Interface and Supplier Interface.

o   Developed Conversion and Interface Programs.

o   Created new reports in PO, AP, INV modules.

o   Worked with Oracle support team to troubleshoot and fix bugs.

New Vine Logistics, San Leandro, CA                                                       Oct ’07 – Mar ‘08

Role: Oracle Finance Reports Developer

Responsibilities:

·         Developed Direct Shipper Tax reports in PL/SQL and RDF for different counties and states.

·         Created value sets, concurrent programs, lookups.

·         Modified existing reports and tuned SQL queries.

Network Appliances, Sunnyvale, CA                                                                    Jun ‘05 - Mar ‘07

Role: Technical Consultant                                                           

Responsibilities:

·         Developed packages, reports, valuesets, triggers, tables, indexes, synonyms, sequences, views, lookups and concurrent programs.

·         Written PL/SQL code for generation of B2B messages (3A6 and 3B2), error messages (BAM), exception handling and relevant messages in the log files.

·         Created and modified wrapper program to call the custom Pre-Order Import, Order Import, Post Order Import, Order Validation and Auto Booking programs with necessary validations.

·         Replaced XML gateways with Advanced Queuing.

·         Involved in customization of forms using CUSTOM.pll.

Educational Qualification:

Master Of Computer Applications, (M.C.A) From Osmania University, India.