SUMMARY:

• Oracle Applications Business System Analyst
• Excellent Functional and Technical experience for 17 years with a deep understanding of the Oracle e - Business Suite products and Oracle Solution Offerings.
• Solid Finance, Distributions and Manufacturing domain expertise.
• Specialization in Order to Cash, Procure to Pay, Record to Report, Fulfillment to Service , Demand to Build Business flows.
• Brings extensive Implementation experience working on large global deployments with subject matter expertise and industry specialization across multiple industries including Industrial, High Tech, Retail, Media, Banking, Financial and Discrete Manufacturing.
• Proficient in Functional Technical aspects crafting solid end to end Solutions.
• Possesses extensive industry experience working on wide range of Oracle Applications Legacy Systems with progressive experience in 11i, R12.

TECHNICAL SKILLS:

• Oracle Financial Modules: General Ledger, Accounts Receivable, Order Management, Accounts Payable, E-Business Tax, Vertex Tax Engine, Purchasing, Inventory, Service Contracts, Cash Management, iExpenses, Fixed Asset, EDI Order Processing, Oracle Quoting, Treasury, and Trading Community Architecture (TCA).
• Project Experience Implementations/Rollouts in R11i R12, Financial, Manufacturing, Global Multi-Org/Multi Country, Multi Currency Language, Multi Phase, Upgrades from 11.5.9 to 11.5.10 to R12, Integration with Legacy Financial Systems (Wallstreet TWS, Banks@24), Payment Automation, Bank Statement Import and Recon, Lockbox Automation, EDI Order Import Integration, RevPro Revenue Recognition Integration, Data Conversions, AIM Methodology Best Practices, Post Implementation Functional Support and Process Management..
• Functional R12 Upgrade SME’s, Integration Lead, Lead Functional Architect, Functional Track Lead, Systems Integration, Software Development Life Cycle, Revision Control and Change Management, Project Management, Visual Analytics with Tableau, Recognition of Revenue from Contract with Customers (Standard ASC 606) .
• Expertise in design and configuration of Chart of Accounts, Ledger, Multi-Org Structure, Multi-Org Access Control (MOAC), Sub Ledger Accounting (SLA), Revenue Accounting Rules, AGIS, Auto-Accounting, Payments, Bank Statement Mapping, E-Business Tax.
• Technical Design and developments of RICEW Components using Oracle SQL, PL/SQL, Forms 6i, Reports 6i, Workflow 2.6, AOL Objects, Custom.pll, Forms Personalization, XML Publisher, Discoverer 4, Unix Shell Scripting, Perl, XML, VB Script, Java Script, SQL Loader Control Script, Integrated SOA Gateway (ISG), Financial Statement Generator (FSG), Dataloader 5.4.1.0, Vertex O Series 6.0/7.0.

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Business System Analyst

Responsibilities:

• Functioning as an Upgrade Lead for R12 Project under Procure to Pay Track.
• Worked closely with the technical team to retrofit Confidential 's inline with R12 Architecture.
• Lead cross functional discussion with business users to address critical upgrade issues with Invoicing and Payments.
• Performed Post-Upgrade Setups for Payment Formats, Payment Templates, Disbursement System Options to control Payment Process, Invoicing, MO Security Profiles for Open/Close periods, Bank Account Type lookup, SLA Accounting Rules to reclass accrual account with expense account, and E-Business Tax Configuration to upgrade Tax information.
• End to End integration testing of Procure to Pay business flow processes touching integration points and customization related with Citbank, Wells Fargo Payements and Invoicing from different sources.
• Upgraded Vertex O series from 6.0 to 7.0 and implemented Vertex Tax Links to replace the existing Nascent Tax Links ( NTL) solution used to integrate Vertex O Series 6.0 with Oracle EBS 11i.
• Reviewed Payments, Invoicing and Accounting Customization and performed Map/Gap Analysis with R12 Features to bring down the Customization.
• Worked with business users to test customization during CRP test cycles including UAT and SIT. Drafted Integration Test scripts and Unit Test scripts for Confidential 's in Procure to Pay functional area.
• Facilitated issue resolution meeting with the users to successfully resolve and close issues.
• Worked with tech team to migrate customizations including personalization, workflow, lookups, concurrent programs and OA framework java pages etc.
• Worked with business users to train them with new functionality in R12.
• Conducted training sessions for users to review R12 changes. Worked on performance issues related to Payment Automation, Invoice Validation and Accounting.
• Worked on preparing cutover activities for upgrading data, planning and execution.
• Worked on analyzing and cleansing up the specific known data corruptions in AP Accounting Tables, Charge Allocations, Reversal Distributions, Orphans Reversals, and involved in iProcurement Catalog Upgrade.
• Involved in Production Support for Month End Close Activities and resolving the issues incurred with Month End and Day-to-Day activities.
• Currently involved in designing Romania VAT Split Payment mechanism.
• Manages Oracle Support interactions to resolve Service Requests as needed.

Confidential, Sunnyvale, CA

Business System Analyst

Responsibilities:

• Organized and facilitated meetings to discuss/review functional specifications in Payments Automation.
• Prepared functional design documents and create detailed test plans related to new enhancements in Payments Batch Creation and Automated Payment Criterion setup.
• Worked with development team to ensure functional requirements are developed according to specifications. Perform review of technical requirements.
• Create Test Script, perform Unit Testing. Involved in Project meeting during Design and Build, Support System Integration Testing and User Acceptance Testing.
• Worked with cross-functional teams during Analysis-Design phase, Integration Testing, Performance Testing and User Acceptance testing phase of project.
• Worked with System Administrator and Release Management teams to migrate production changes during required deployment periods.
• Manages Rollout across different regions and multiple banks within time frame.
• Used Google Documents, Spreadsheet, Presentation & Drawing to document and diagram business process flows.

Confidential, Sunnyvale, CA

Business System Analyst

Responsibilities:

• Assisted in business requirement document review.
• Prepared functional design documents for data extraction from Oracle AR Tables into RevPro staging Tables.
• Reviewed use cases and assist with unit testing for projects
• Prepared test cases and participate in product functionality testing.
• Worked closely with product development team to request and test new product functionality based on accounting needs.
• Identified and assist with testing and implementation of system enhancements.
• Being subject matter expert of RevPro and proactively provide training to project team on the new product functionality and technical accounting concept.
• Resolving the month-end issues with reconciliation between Oracle GL, RevPro, and Oracle OM/AR
• Streamlined the month-end close activities related with RevPro.
• Troubleshoot the issues with transferring of individual Orders/Invoices data to RevPro from Oracle AR, journal entries from RevPro to Oracle GL.

Confidential, San Jose, CA

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Designed and developed the Inbound Interface program to load AP Invoices file received from HQ.
• Designed and implemented technical process for AR Invoice Import interface to Oracle Receivables for different sources.
• Designed and extended Oracle seeded AR Lockbox Import process to import Customer Receipts.
• Troubleshoot business critical Sales Order Shipment issues caused due to Pick Release failures, Ship Confirmation failures, Trip Stop failures, Remove/Purge Exceptions, Pricing Issues, Credit Checking, and Shipment Documents printing.
• Effectively communicate resolutions for Auto-Invoice Import, Auto-Accounting errors, Lockbox Receipts Import & Cash Application issues, Bank Statement Import & Reconciliation issues, Vertex/ Taxware Sales Tax Rates File Upload Issues.
• Involved in supporting and extending the functionality of customized Post sales (RMA) Application module used for managing Customer Returns and Credits.
• Resolved the issue with Revenue - Confidential matching caused due to Sales Order were not invoiced to AR.
• Monitor and resolved the Payables Open Invoice Import issues, PO matching issues, Employee Expense Report Import issues, Credit Card Transaction Load and Import issues, Supplier Payments and check printing issues.
• Worked on designing and developing custom interfaces for Vendor Managed Inventory (VMI) hubs to perform the receiving and shipment transactions.
• Worked with third party translator service provider for EDI File Transmission related Issues.
• Fixed issues with B2B processes like Bill Trust Invoices, M K Denial.
• On periodic basis performed the month end period closure activities as well as provide extended hours support on weekends/holidays for month end issues.
• Modified Customer facing documents for Company Address related changes.
• Interchanged the XML data between Post Sales Applications and Warranty System using Web Service API’s calls.
• Involved in Code Review Process to make sure that code is in compliance with AIM methodology.
• Involved in Business User training and manual preparation.
• Involved in analyzing the performance issues with RICE components and take appropriate actions to tune it.
• Involved in successfully implementing the changes happened due to data center movement.

Confidential, San Jose, CA

Finance Techno-Functional Consultant

Responsibilities:

• Main key responsibilities involved in doing the impact analysis of GAIA rollout on the existing financial key processes running on existing Oracle Applications (such as Lock Box, Bank Statement Loading and Reconciliation, GL Transfer, Gross Margin etc.) and presented it to the business.
• Identified the list of RICEW components impacted due to GAIA rollout.
• Analyzed the requirement to make Customer/Supplier and Bill-To Location as a unique among Toshiba Group using Torico Standardized Customer/Supplier Codes supplied by Global Code Center ( Confidential ).
• Analyzed the data to be pulled off from 11.5.9 compare it with the migration templates prepared for GAIA rollout.
• Prepared Functional and Technical Specification documents for each of the impacted processes.
• Core responsibilities involved in writing data migration script to convert Customer, Supplier, Open Invoices, and GL Balances data from 11.5.9 to 12.1.3.
• Developed custom program to update Torico Standardize Customer/Supplier Codes using Oracle Standard API’s.
• Define new mapping solution to map 5 segment chart of accounts structure running on Oracle Apps 11i into 11 segment structure of Oracle R12 Instance.
• Prepared the solution design documents and developed the custom code components required for interfacing the data like Customers, Suppliers, Customer and Supplier Invoices, and GL Journals on day-to-day basis after GAIA rollout.
• Involved in Master data clean-ups activities for Customer/Supplier, Payment Terms, Journal Sources, Journal Categories, and Receipt Classes.
• Liaise between TEAC and GAIA Implementation team for knowledge transitioning of the existing business critical processes such as Lockbox, Bank Statement Loading etc. running in 11.5.9.

Confidential, Baltimore, MD

Finance Techno-Functional Lead Consultant

Responsibilities

• Troubleshoot in-house check printing related issues with Confidential Applications.
• Provided support for workflow notification related issues with expense reports approvals.
• Responsible for resolving the Tibco Middleware integration related issues with relevance to Expense Reports Import Receipts, Cash/Bank Transaction retrieval from the various banks like Citi, M&T, Wells Fargo, Bank of America etc in Treasury Work Stations.
• Help out user for resolving integration related issues with Payables Invoices Scanned Images retrieval from EMC Documentum.
• Responsible for period end closing activities and resolving the accounting/reconciliation related issues with GL to Sub-ledger.
• Responsible for resolving the issues with 1099 Internal Revenue Service Reporting by reviewing the invoice distribution with inaccurate or missing income tax information for 1099/non-1099 Suppliers in 1099 Invoice Exception Report.
• Responsible for monitoring/testing/deploying the patch provided by Oracle to correct the year printed on the W9 form and the other 1099 report format issues discovered during the year.
• Depend on the business requirement, responsible for add/update any Business Unit locations as well as reporting entities for 1099 reporting.

Confidential, Portland, OR

Finance Techno-Functional Lead Consultant

Responsibilities

• A main key responsibility involved is to gather the requirement for integrating EMC Documentum Solutions with Oracle Accounts Payable.
• Prepared and delivered the solution design document comprises of System Requirement Specifications and AP Integration with Documentum details.
• Developed prototype solution by exposing DFS API’s as Web Services to retrieve the invoices scanned images (stored in Documentum Repository as Optical Character Recognition Format using Captiva) URL and resolved the HTTP call using UTL HTTP package/Integrated SOA Gateway to show it on Invoice Inquiry Screen by way of Form Personalization.
• Prepared and delivered the test data (like invoice scanned image stored, export image to Documentum, Invoice Inquiry data to show the invoice image link) and specifications required to test the integration.
• Presented final estimates and project plan for Imaging Solution.

Confidential, Miami, FL

Finance Techno-Functional Lead Consultant

Responsibilities:

• Interacted with business users to perform change request analysis, define intended system behavior and document requirements to communicate change to management and technical team.
• Involved in configuring and writing complex program logic for Global Payment Pipeline Process to send the Wire/ACH payments information to JPMC in Global Flat File (GFF) and to Bank of America in EDI 820 EFT format to the bank and in turns received the ACH payment confirmation from JPMC bank.
• Developed program to automatically deliver the remittance advices to the supplier using email/fax.
• Developed the funding report using PL/SQL to predict the forecast of disbursement of fund across multiple Operating Companies.
• Involved in resolving the issues with Supplier Invoices/Payment processes, BAI files data loading issues into Bank Statement Interface, Bank Statement reconciliation.
• Troubleshoot issues related with FSG reports, GL Journal Interface, GL Daily Rates, Budget Upload, and GL Journal Reconciliation issues.
• Developed test scripts, communicated/guided business users/stakeholders, test application and proactively resolve issues through effective cross-functional interactions.
• Provide Management reporting for progress and status for all Business related Work Products / Deliverables.
• As part of data centre migration activities, involved in replacing the touch point of the existing FTP server with new Enterprise FTP Server. Involved in mock testing of the application to ensure all the custom components migrated (from AIX Instance into new Linux Environments) were working as per expectation.
• Involved in analyzing the performance issues and provided inputs to DBA team to take actions.

Confidential

Finance Techno-Functional Lead Consultant

Responsibilities:

• Main key responsibilities involved in design and configured the Organization structure and Ledger along with associated profile options.
• Core responsibilities involved in data migration and custom code RICE components movement from KOEL Instance to EISPL Instance.
• Developed test scripts and cases to test application features/functionality and conducted conference room pilots based upon testing plans.
• Migrated the Confidential global chart of accounts structure running on Oracle Apps 11i into new Oracle R12 Instance.
• Analyzed the data to be pulled and define the migration templates accordingly required for masters setup like Customers, Customer India Localization Information, Suppliers, Supplier India Localization Information, and Employee as a Suppliers, Item, and India Localization Item Attributes as well as transactional data like Supplier Open Invoices, Customer Open Invoices and Open Sales Order.
• Prepared the solution design documents and developed the custom code components required for data migration activities like customers, suppliers, inventory items, open customer and supplier invoices, and open sales orders using Standard Oracle Interface/API.
• Defined the pre-requisite set-ups required for data migration like Payment Terms, Sales Persons, Order Types, Freight Terms, FOB, Pay Group, Vendor Type lookup code, Warehouse, UOM, UOM Conversions, Order Sources etc.
• Defined the Line Transaction flex field required to display the attribute values of Customer Invoices relevant to KOEL Instance, and also defined the AR Transaction Types and AR/AP Transaction Sources to migrate Credit Memo’s, Debit Memo’s and Standard Invoices pertaining to Operating Unit.
• Changed the existing KOEL custom reports for financials to fit it into Confidential Global Chart of Accounts (7 segments).
• Technically guides the team members for data migration related activities relevant to Bill of Materials (BOM), Item Costs roll-up, Standard Cost Update, also for customizing the report to fit it into Confidential Instance.
• Involved in cut-over activity, data migrations and reconciliation activities for migrating open transactional data from KOEL Instance to EISPL Instance.
• Involved in post production support activities.

Confidential

Finance Techno-Functional Lead Consultant

Responsibilities:

• Main key responsibility involved in Due Diligence phase to understood the current system architecture, current organization architecture, key focus areas/pain areas in each process.
• Understand the scope of existing interfaces and their interaction with PeopleSoft. Understand the current reporting systems for Statutory and management reporting purpose.
• Developed future state, contemplate high level solution; obtain concurrence on Business Requirement Document (BRD).
• Transferred knowledge and system functional design to overseas technical team for development and reviewed code to validate.
• Core responsibility involved in design and configuring the GL, AP and CE module using Oracle R12 enhanced future.
• Responsible for migrating GL Balances, Fixed Asset data from PeopleSoft system into Oracle R12.
• Design and developed the GL interfaces for integration of different legacy system with Oracle Applications.
• Design and enhanced the Bank Statement Loader interface with the help of custom mapping to fit it into NatWest Bank File Format, which is helpful for bank statement reconciliation activities with different kind of payments and receipts received from vendors and customers respectively.

Confidential

Finance Techno-Functional Lead Consultant

Responsibilities:

• Main key responsibility involved in reviewed the documents prepared during different phases of the project to ensure what are all processes, standards and methodology followed during project execution were in adherence with AIMS Standards, GSM Standards and Guidelines.
• Reviewed the logical and physical database design to ensure the database referential integrity and data consistency.
• Reviewed the DBA processes like Patch Application, Database Backup and Recovery, Disaster Plan, Audit Tracking and Monitoring activities.
• Reviewed the source code of customized objects to ensure whether the source code was developed using the Design and Build Standard of Oracle as well as the agreed GSM Standards and Guidelines.
• Reviewed the application in aspects of GUI Design, Accessibility, Usability, Training Materials and Performance.
• Reviewed the Configuration Change Management Process to ensure the Version/Change History Controllability and Accountability of each component.
• Developed and presented the Functional and Technical Assessment Report based on findings of all different areas and the appropriate recommendations given on the findings.

Confidential

Finance Techno-Functional Consultant

Responsibilities:

• Main responsibility involved in day to day production support activity, root cause analysis for the issue raised, provided solution against the same within service level agreement (SLA) timeline set.
• Involved in discussion with the client on requirement gathering of the new discretionary change requests (CR’s).
• Involved in preparation of the Solution Design Document (SDD) for discretionary CR’s. Follow up with the client for Approval of SDD.
• Provide functional support to the technical team members for the customization of new objects.
• Involved in setup creation for new Configuration CR’s.
• Involved in preparation of the unit test cases for CR’s testing and update it in SDD.
• Testing of the new CR’s on development environments.
• Involved in co-ordination with on-site team member for successful sign of the CR’s raised
• Maintain the defect-tracking sheet; update it regularly with proper justification about the defects.
• Involved in maintaining version control activity and knowledge database.

Confidential

Finance Techno-Functional Lead Consultant

Responsibilities:

• Main responsibility involved in business modeling, business requirements and system test planning and support of Oracle Applications 11i product.
• Analyzed solution proposed to the customer, help influence client design decisions and imparted domain training to project teams
• Freeze out the Chart of Account Segment Structure, Calendar, Currency, Currency rate conversion, revaluation process requirements.
• Successfully implemented the GL Module with pre-requisite set up. Follow the AIMS methodology to implement it.
• Design & Developed the GL Interface programs to import the data from B@ncs24 system with required field’s validation into Oracle Applications.
• Analyze, Design & Generated the new FSG (Financial Statement Generator) Reports like Adjusted Trial Balance Report, Profit &Loss Account Details Statement, Profit & Loss Comparative Balance Statement, Balance Sheet, General Ledger Balance Statement, GL Annexure, Fortnightly Statement and some other reports developed for audit point of view and for their daily routine activities, as per the client specified formats.
• Design & Developed the new standard reports to show the individual account balance (outstanding + breakup) as on date in the client specified formats.
• Analyze & designed the new programs to cross-check the incremental GL account balances of Oracle Apps 11i with B@ncs24 system. This is helpful for reconciliation process on day to day basis.
• Involved in reconciliation process of Oracle Apps 11i GL Account Balances with GL Account Balances of B@ncs24 system. Help out in identifying the root cause for mismatch in both sides of the account balances.
• Consulted with customers on issue resolution, test planning and execution.

Confidential

Finance Techno-Functional Lead Consultant

Responsibilities:

• Main responsibility involved in Chart of Account Segment analysis used across the Organization and proposed a solution to fit it into Global Chart of Accounts.
• Analyzed the impact of the segment structure change on the custom code components.
• Defined the mapping solution to map the segment structure of each organization into Global Chart of Accounts.
• Defined the data conversion scripts to convert the Chart of Account Segment Structure hierarchies and flex values.

Confidential

Finance Techno-Functional Consultant

Responsibilities:

• Main responsibility involved in understanding the business processes for all 7 charts used in 7 different operating units across the globe. Mapped all those 7 Charts segment structures with the global segment structures.
• Core responsibility involved in designed and developed the mapping application to do the mapping for all 7 charts with global segment structure.
• Defined the data conversion scripts to convert the Chart of Account Segment hierarchies and flex values.
• Responsible for doing the IQA of all the custom migrated objects delivered to the onsite.
• Prepared the list of the impacted objects with proper root cause. Prepared and execute the project plan for migration activities.
• Prepared shell scripts utility for porting activity of all the custom migrated objects on different instances.
• Prepared functional specifications for all the new reports relevant to GL, as per the client requirements.