EXPERIENCE SUMMARY:

• An Oracle Techno Functional Consultant, with 13+ years of experience with Oracle E - Business Suite.
• Sound functional and technical knowledge and expertise in Oracle Financials and Supply Chain Management.
• Expertise areas include; application development and designing custom solutions, deployment, job scheduling and system administration. Proficient in Customizations and Extensions using Forms, Personalizations, Oracle Reports, Workflow, Discoverer and BI Publisher.
• He has excellent oral, written, analytical, and communication skills. He can manage and lead teams as well as deliver projects independently.
• Oracle Applications Release12, 11i (11.5.9, 11.5.10.2). Modules include Financials ( PO, GL, AR, FA, PA,CE, AP & CM)
• Data Conversion, Data Migration and developing interfaces within Supply Chain, P2P and O2C cycles.
• Oracle Developer Suite( Forms 10g, Reports 10g), Workflow builder 2.6, Discoverer 11g, Oracle 8i/9i, PL/SQL, SQL Trace, TKProf, Explain Plan, Oracle Import and Export Utilities (Imp & exp) and Unix Shell scripts
• Thorough understanding and experience supporting Oracle-3rd party systems integration
• Very good understanding of AOL, process flow and table structures in application modules
• Well versed with SDLC, AIM Methodology and documentation standards.
• PL/SQL Stored Procedures, Functions, Stored packages, Recursive PL/SQL routines, database triggers, Knowledge of various PL/SQL packages
• Expertise developing complex reports using Oracle Discoverer, Oracle Report Builder, Oracle BI Publisher and SQL-plus reporting tools
• Understanding of ADF and Fusion middleware and OBIEE Physical, Business and Presentation Layers

TECHNICAL SKILLS:

ERP: Oracle Applications R12/11i (XLA, P2P, GL, PA, FA, AR, O2C, WIP, WSH, INV)

Languages: SQL, PL/SQL, Pro*C, C, UNIX C Shell

Oracle Tools: SQL*Plus, SQL*Loader, PVCS, Issue Tracker, Kintana/ Mercury ITG Version 5.0

RAD Tools: Developer 10g (Forms 10g, Reports 10g), Workflow 2.6, Discoverer 11g, SQL Navigator, Toad

Databases: Oracle 10g, 9i, 8i and 7.x, MS-Access

Operating Sys: Windows NT/2000/98/95, UNIX, HP UX, Sun Solaris 2.6

WORK EXPERIENCE:

Confidential, San Diego, CA

Oracle Financials Consultant

Responsibilities:

• Participated in multiple business meetings to gather R12 upgrade requirements and to identify objects for remediation.
• Resolve issues logged in ITG in 11i production system
• Identify performance issues in Oracle reports and tune SQL queries
• Setup auto accounting rules, assigned rules to functions, defined date based SLA rules and sub-ledger accounting methods. Tested seeded Standard Accrual SLAM
• Setup Profile options to Setup SLA for GL application.
• Modify existing 11i programs, reports to include R12 changes and test in multiple environments
• Proposed testing approach and migrate objects through ITG package
• Helped business in configuring application, defining Flex fields, pre-requisites, value sets.
• Helped in design planning, document preparation and design review sessions for Financial modules.
• Generating SLA r eporting and Customizing FSG Financial Reports and other non seeded reports, and other financial reports and analytics
• Coding, code retrofit, migration scripts, integrations, unit testing in Cost Management, AP, and GL processes
• Involved in month end processes for journals, SLA, Recurring and Reports with subsequent accounting
• Participated in data validation, functional testing, and issue review/resolution
• Reviewed and validated Pre/Post upgrade tasks required before and after the upgrade process for P2P process
• Worked on SLA (Sub-Ledger Accounting) rules to replace traditional transaction codes to generate multiple accounting representations for one business transaction. Used Accounting methods builder to create and assign SLAM to Ledger
• Modified Custom Auto Cost reconciliation program to automate Create Accounting and transfer to GL process in R12

Environment: Oracle 12.2.4 (EBTax, GL,AP,CE,SLA)

Confidential, Irvine, CA

Oracle Consultant

Responsibilities:

• Participated in multiple business meetings for Fit-Gap Analysis and Solution approach.
• Designed Sales order conversion process for importing Open sales orders from 11i.
• Developed Discoverer Service contract reports as per RICEW requirements.
• Modified SLA definition per client's requirement and resolved problems with SLA
• Designed PO conversion process for importing 11i data into R12.
• Prepared System Test Scripts TE.040 for UAT sessions and Training Documents with screenshots for end users
• Created Customized responsibilities, customized menus, customized request groups
• Worked with the business to come up with the future business process
• Preparing Visio Process diagrams for AS IS / TO BE scenarios.
• Writing TE.040 Test Scripts for Functional Testing for AP and PO processes and developing navigation details
• Create and follow up on Service Request (SR) with Oracle support, and get recommended patches applied.
• Prepare documentation for change management process along with impact analysis on the proposed solution
• Conduct user meetings from different departments to understand pain points and suggest solutions
• Developed supplier and supplier site conversion programs.
• Custom service contract report with all orders and Service Contract Authoring information per user request.
• Developed Shop floor yield report listing scrap variance and yield variance
• Combined Manufacturing backlog and sales order acknowledgements attached in an email to the user per specific requirement.
• Customize outfacing documents as per client needs
• Modfied RMA XML templates for Germany and Mexico implementation. Modified Shipment alerts to Customers and Shipment alert to Salesreps programs specific to Mexico and Germany OU
• Developed custom BI Reports per user specifications, tested and deployed in applications. Leveraged existing folders in Discoverer to create Custom Discoverer reports for GL, PO and OE users. Modified PL/SQL packages and functions to improve performance, fix erroneous data retrieval, consolidate requirements and to provide efficient and accurate data.
• Implemented custom logic using db functions in Item calculations in discoverer reports.
• Enabled optional parameters and dependent parameters based on prior parameter selection in Discoverer plus.Warehouse parameter for OE Priority orders report displayed values specific to chosen org. If year parameter was left blank, data for all years was displayed.
• Designed custom discoverer view/report GL Details by Account using XLA data for all sub ledgers to reconcile with financial reports
• Registered new Discoverer report link for AP payments by GL account report with account and other parameters
• Redesigned HID Purchase Price variance report template (XML) to remove override formatting, so that users could copy paste Item number without unwanted special characters like '?'
• Modified XML Template and definition for HID Sales order acknowledgement report and HID Receipt Travellers. Sorted serial numbers so that users could easily cross match.
• Introduced conditional logic by checking language code in Sales order acknowledgement report to print text in different languages dynamically.
• XML report HID Purchase Price variance incorrect totals, GL account missing, data formatting issues were fixed, tested and moved to Production environment.
• Monitor and grant access to custom reports to avoid report functionality is not available errors.
• Granted access to Business areas in Discoverer Administrator to users and responsibilities.
• Shared workbook with responsibilities and users in Discoverer Desktop.
• Review errors and propose tax area assignment issues in Vertex AR Tax Reconciliation process
• Modified Custom.pll in event procedure to disallow users other than specified to save, update, delete from application. Allow everyone submit request.
• Created new Collection element under existing Collection plan to automatically populate shipment number so that RMA line and shipment number can be matched at Quality Inspection step. Defined SQL action details to populate shipment number element using previous block’s order number and line number
• Modified RMA based on Disposition program to Autocreate Sales orders using the line, shipment number info. This new process fixed duplicate Order lines issue.
• Modified Sales order headers trigger package to eliminate Automated RMA email alert to customers for Credit only orders of Return category.
• Added dynamic logic based on language code to display footer notes in corresponding language in HID Sales order acknowledgement report template.

Environment: Oracle Applications R12.1.1, Solaris, Oracle 10g, SQL*Plus 10.1, PL/SQL 8.x, Toad7, Workflow builder 2.6, Reports 10g, Discoverer 11g

Confidential, El Segundo, CA

Techno functional lead

Responsibilities:

• Deliver custom reports for clients Intelius, Mitsui, TIG and LiDestri Foods
• R12 Upgrade lead for Financials track.
• Documented BR.100 application setup and MD.50 Application Extensions Functional Design
• Involved in configuration of CRP1, UAT and test instance for User testing.
• Trained Super Users and troubleshooting during UAT, helped log issues in Issue tracker
• Set-ups and maintenance, converted the headers, lines and line locations from the legacy system to Oracle Payables .
• Clarification tracker for list of open issues related to business clarification.
• Setup suppliers, locations, and purchasing quick codes as per business scope and requirement.
• Setup payment terms, invoice distribution, matching of invoices against PO.
• Created BR.100 Application setup and CV.040 Conversion data mapping documentation for GL, AP, AR, SLA (Sub ledger Accounting)
• Provided post-production support for GL, AP and AR modules and resolved month end close issues.
• Trained end users using Oracle UPK (User productivity Kit)
• Assisted users in uploading journals using Web ADI into GL application.
• Prepared System Test Scripts TE.040 for UAT sessions and Training Documents with screenshots for end users
• Develop XML publisher reports, Customer Price Review report etc,
• Customize Debit Memo workflow to send Debit Memo failure notification to additional recipeients
• Forms personalization to remove Order holds for CRM Mixed Orders
• Forms personalization to display error message and not allow Booking if PO Box address in Ship to field for Order Capture, Copy or Biztalkb2b orders
• Personalization to uncheck Copy existing holds when copying Sales orders
• Barcode formatting within XML template TIG Shipping Template changed to taller font using IDAutomation 128M style, and checksum calculation. Defined new font mapping under TIGFONTS font mapping set.
• Customer master level DFF attribute10 defined so that hold will be automatically applied. Personalization on Custom Sales order form to check Attribute10 and apply hold
• Personalized form to not allow change of Payment term, if Credit card already authorized
• Sales order form personalization to check required fields, display message that PO Number, shipping method or ship from fields cannot be null and are required
• Customized E-Business Tax Missing Location Values Report
• Change price in vendor rebate process (TIG Update Lines Rebates) from Selling price to Cost Adjustment stored on the Unit Cost field

Environment: Oracle Applications R12.1.1 (Order Management, Quoting, A/R), Solaris, Oracle 10g, SQL*Plus, PL/SQL 8.x, Toad7, Workflow builder 2.6, Reports 10g

Confidential, Irvine, CA

Sr. Programmer Analyst

Responsibilities:

• Research and evaluate new project requirements during vendor acquisitions
• Propose new development, enhancement or migration strategies
• Manage technical resources and design Technical and Functional docs for Customer, Invoice, Item and Vendor conversions.
• Write custom procedures and PL/SQL packages to validate and load legacy data into Oracle
• Develop Access database and forms to facilitate legacy data cleanup
• Export legacy data into MS Access for cleanup, and import Access data into Oracle for conversion
• Tested custom processes to maintain quality and adhere to standards and guidelines
• Develop and maintain outbound Customer and Sites interfaces
• Receivables Tax Report by Ledger/Operating Unit and Payables Tax Report by Ledger/Operating Unit modified as per business requirement.
• Design simple conversion script to read spreadsheet data and load vendors, sites and contacts into Oracle
• Plan strategy to exclude inactive vendors based on Invoice activity and suffix site name to avoid duplication
• Wrote custom code to process On hand quantities transfer from one inventory org (80S) to another (45A) and reused the same Table design for Receipt in transactions by reversing the quantities sign.
• Proposed and implemented a unique design approach to automatically create a Project based Sales Order using spreadsheet data. Budget creation program then creates Approved cost budget based on similar spreadsheet with Project and task information (with hours and raw cost information) and then Baselines it.
• Developed custom Inbound and Outbound interface packages to extract Customer contacts information to ESKER and then receive updated contact with new communication (email/fax) info, to facilitate paperless invoicing for customers.
• Wrote package to read/process Customer Item and Inventory Item data into interface table and Process Import Customer Item cross references program.
• Wrote custom data extraction scripts for creation of Noetix views
• Created custom reports using Business Objects.
• Setup face to face meetings with Project Manager and partners to communicate progress and roadblocks.
• Wrote shell scripts to automate the file transfer to and from remote ftp server, and parse data for Concurrent processing
• Analyze existing custom interfaces and reports to be migrated for Release 12.

Confidential, Carlsbad, CA

Oracle Technical Consultant

Responsibilities:

• Support and maintain Getpaid app (credit management) and cash application activities.
• Implemented B2C project, successfully completed AR/GL integration with Hybris systems.
• Designed shell scripts to pull daily transactions files into Oracle AR.
• Deployed simple XML report, B2C Transaction Recon report to reconcile invoices and payments.
• Design, test, and deploy custom payment format solution (Lloyd’s bank) for UK subsidiary
• Work closely with users and Lloyd’s bank personnel to determine file format and validate extraction
• Tested invoice batches and payment batches created as part of testing custom payment format
• Gathered requirements from Golf Europe team for GRAPE project
• Wrote pseudo code for several processes in design documents for off shore developer.
• Documented technical analysis for development to re-design Pro*c extraction logic per specifications
• Documented custom form changes to allow users enter new mapping segments
• Download latest 1099 patches and plan application and testing to complete 1099 Forms report as per IRS specifications
• Replaced existing BO reports for Expense Status, GL Details, and Remittance Advices with integrated XML Publisher reports.
• Client Liaison for communicating requirements to offshore team and fulfill action items related to system accesses, deployment and UAT planning and support.
• Planned and completed upgrade of JDK version 1.3 to J2SE 1.4.2, and install of root certificates for Paypal API authentication. Credit card processing errors were resolved.
• Re-process Confidential CC files so that AP could import and process payments.
• Work with Confidential auditors to provide extracts, screenshots and users listing from Oracle database.
• Fix and re-process employee interface (shared HR) to sync employee info with external HRIS system
• Resolve AR invoice interface errors before month end close
• Evaluated business cases, and prepared analysis/functional documentation for GRAPE, EFT modification, RGA, SOA, Customer Balances re-engineering, and other projects.
• Direct interaction with GL, AP, AR, I-expense, & I-procurement users in gathering requirements for enhancements, issues and support activities.
• Performed Sysadmin functions onsite. Performed user maintenance requests and audit related tasks. Fix I-procurement & I-expense issues, regularly monitor and re-route stuck workflow notifications, retry failed activities due to database errors such as ‘too many cursors open’, ‘role does not exist’ in case of terminated employees etc.,
• Managed quarterly catalog updates from vendors, as Catalog administrator in Oracle. Authoring catalogs, checking latest wholesale and promo pricing for procurement.
• RGA and SOA: designed new automated sales orders approval and return goods workflow processes, that perform several complex activities based on workflow notification responses
• Designed unique strategy with help from offshore Java team to implement approval notification responses via Blackberry device until TM plans to upgrade to 11.5.10.2
• Deployed timeout strategy to route RGA notifications to next approver upon timeout of 3 business days, added innovative resubmit option as reminder to take action
• Setup new DFF for storing approval limits on Oracle employee form.
• Supplier, site and contract PO defined for new vendor, Staples Business Services
• Coded e-commerce gateway mappings for UOM’s, UNSPC codes and Vendor site
• Test and configure punch-out definition, create new catalog and associate it with new I-procurement Staples store
• Modified purchasing and requisition workflow attributes to enable non-catalog requests to Autocreate PO

Environment: Oracle Applications R11.5.9 (AR, AP, GL, i-expense, i-proc), Solaris, Oracle 9i, SQL*Plus, PL/SQL 8.x, Toad7, Workflow builder 2.6, Reports 6i, Forms 9i

Confidential, Plymouth, MN

Oracle Conversions lead

Responsibilities:

• Point of contact for offshore development team (TCS). Helped manage, prioritize and deploy conversion scripts for testing; Asset keywords conversion, GL mapping conversion, and Project Budgets conversion
• Used Ship Confirm Open Interface (Shipping) to load and validate picking line details, and freight charges and Ship Confirms the delivery.
• Monitoring off shore team members, to ensure all forms and reports meet requirements and performance standards via Teleconference and net meeting.
• Rewrite Customer conversion programs to improve performance and flexibility, rewrite Item Categories (Product class/subclass), build EDI Trading Partner data conversion programs, Build Item Cross reference conversion programs
• Developed automated process to convert Cost and Revenue Budgets from legacy systems: BUILD, TPBS, TRAK, Spreadsheet (M&E), Oracle10.7 GL (M&E). For the 11i contract projects with no revenue budget, the budget conversion program will automatically create $1 budget
• Oracle EDI Gateway design, mapping and implementation to handle the Inbound Purchase Order (850), Outbound Purchase Order Acknowledgment (855) and Outbound Invoice (810) transactions.
• Designed Projects Budget (Both Revenue and Cost Budgets) using AMG APIs. This included creation of Draft Approved Cost Budgets and Approved Cost and Revenue Budgets required for Contract Projects. This module was also responsible for Baselining budgets after Agreements creation.
• Designed Agreements and Funding Conversion. Based upon the budget amount, this conversion was used to create appropriate Funding and Agreements
• In Expenditure and Events Conversion, legacy expense and fixed charges were converted to 11i Expenditures and Events using standard APIs.
• Designed 10.7 to 11i Customer data conversion
• Designed 10.7 to 11i mapping load process based on pre- defined mapping rules, accessible via custom forms. Mapping load populates future mapping values based on segment combination.
• Designed and maintained 10.7 to 11i COA mapping conversion. Process converts provided legacy COA string and writes to an output file (UTL FILE utility) corresponding 7 segment 11i COA string
• Involved in promoting code objects from DEV1 to SIT3 (go-live) instances using ITG.
• Created test plans and added test scripts in Quality Center for testing custom applications. Resolved and closed user-logged defects to improve quality of delivered solutions.

Environment: Oracle Applications R11.5.10 (GL, PA, FA, AR), Solaris, Oracle 8i, SQL*Plus, PL/SQL 8.x, ITG (Kintana) version control, Mercury Quality Center 8.2

Confidential, New Kensington, PA

Oracle Manufacturing Technical Consultant

Responsibilities:

• Customized AEP Applications (US Specific customizations) to convert into Global (Multi Language, Metrics, Org structure) and EUR-Specific
• Analyzed, issues with hard coded values, custom database objects and profiles in programs. Introduced global variables, added extra UOM logic, adding lookups
• Tested and implemented packages, reports, and forms for Dutch and Portuguese
• Logged TAR to resolve incorrect over-completion move quantities. Generated Form trace (WIPTXSFM) and database trace files (WIP Move Transaction Manager- WICTMS)
• Incorporated new logical requirements in Shop floor move program, includes call to WIP Mass Load seeded process and that updates scheduled flag
• Set up Sales order DFF defaulting/validation logic to derive customer rebate information from customer.
• Customized Item Inventory Detail report, removed operating unit check and changed formula to handle KG/MTR conversions
• Some Shop floor custom applications enhanced include Lot release history report, Lot traceability report, & Pick confirm form, Trip Planning form, Coding common utility package
• Global package to get all environment values was called from Trip planning and Pick Confirm forms. Changed field prompts and record groups to get rid of FT, AEP and organization values
• Developed Global Common Package to initialize all the environment variables for AEP and EEP
• Backordered remove packages form was customized to meet new requirements
• Form button text, labels, prompt text was translated and modified for consistent appearance
• Altered form, block, item level triggers, program units and record groups to run applications for AEP and EEP.
• Migrated Tables, Views, Sequences, Synonyms to Prod, Migrated Common Utility Packages in ITG
• Migrated global and local forms into Production for UAT
• Documented test cases and scenarios for all Shop floor transactions, and MFG custom applications
• Designed language translation approach presentation for Dutch Users
• Facilitated UAT and knowledge transition for several successful projects.

Environment: Oracle Applications R11.5.10 (OM, WIP, OSFM, QA, BOM, INV), Solaris,Oracle 8i, Forms6i, Reports 6i, SQL*Plus, PL/SQL 8.x, Toad7, ITG (Kintana) version control