SUMMARY

• Around 11 years of Experience in Oracle Financial domain.
• Involved in 4 Full Lifecycle ERP Implementation, 3 ERP Upgrades and 4 ERP Support experience.
• Experience in implementation and upgrade of Governance Risk and Compliance (GRC) that is implementation of SOX or financial controls on Oracle EBS Financial Applications. Have knowledge of Tax audit, Statutory and Internal Audit.
• Working closely with internal and external IT/System auditors to identify and evaluate financial controls within Oracle ERP applications for SOX control and compliance mandate. Working on auditors recommendations to implement and/or alter financial controls within ERP applications.
• Continuously reviews opportunities for improvement in how Oracle Financials platform is leveraged, brings best practices to the forefront, and maintains the Oracle Financial strategy and roadmap.
• As an ERP System Analyst provides project coordination, functional expertise, and contributes to improvements and enhancements for mission - critical, enterprise-wide information systems. The ERP Analyst is responsible for project tracking and control for assigned modules or systems, serving as a liaison between functional and technical resources to manage the development of system functionality, upgrades, system modifications, and day-to-day problem analysis, issue tracking, and resolution.
• Liaison across IT domains to deliver ERP functionality including but not limited to infrastructure engineering, database management(DBA), security, operations supports, external vendors like Banks, Credit Card agencies for various corporate and procurements cards etc.
• Working closely with business leaders, business users, operational super users, IT directors, IT infrastructure team to understand and document operational requirements and help to transform business requirements to system requirements through ERP enhancements, implementation or upgrade.
• Interdepartmental collaboration to ensure that ERP solutions complement organizational priorities.
• Experience working with business leaders to communicate ERP implementation plans, progress and various milestones in the ERP implementation project life cycle.
• Able to produce detailed system requirements specifications, complex data flow diagrams, test plans, swim lane and process diagrams using standardized documentation methods
• Working as ERP Integration Specialist and to adopt Service Oriented Architecture (SOA) in all ERP internal and external integration using tools and tech like Oracle Fusion Middleware technology. Have good working knowledge of SOA, BPEL and various ERP adapters.
• Analyzing, Customizing and configuring workflow to facilitate ERP integration with other applications; process improvement and business practices to streamline operations.
• Understanding of Data Models of various ERP applications like Payables, General Ledgers, Receivables, Fixed Assets, Cash Management, Internet Expenses and there integration with each other to ease design and development of Data Import, Data Conversions, third party integrations, report developments, report customizations
• Understanding Data Model of various entities of ERP including supplier, customer, banks, bank account, payables invoices, payable payments, Receivable Invoices, Receivables Receipts etc and using various data modeling technique for External and Internal ERP Integration, Data Extraction from ERP application for various internal enterprise wide application and external parties like Banks, Credit Card company and various credit agencies.
• To provide Functional and Technical support for Oracle EBS financial modules mainly on General Ledger, Assets, Receivables, Payables, Procurement, Inventory, Cash Management and SLA.
• Provide Day to Day support of the Oracle Financials environment including applying periodic patches, reporting requirements, ad-hoc requests from business and production system support.
• Installation and configuration of new feature or functionality through addition of patch to existing Oracle ERP application, through integration with other legacy applications or systems within the enterprise or using customizations within available tools and technologies. And Identifying and troubleshooting issues with ERP systems
• As an ERP System analyst able to work on Development of programs using various tools and technologies. Some of the tools include Oracle Forms, Oracle Reports, XML Publisher Reports, OAF, Workflow, AME, EDI Integrations, FTP/SFTP Integrations, FSG and OBIEE for Financial and HRMS modules, SQL*Loader, SQL* Plus, TOAD, PLSQL etc.
• Conducting Testing by Designing, Developing Test Cases for the configured scenarios of the Projects. Testing includes Unit testing, System Integration, Performance, User Acceptance Testing, Regression Testing to ensure system work as expected.
• Conducting Training sessions for end users for new ERP implementation, addition of feature or functionality to existing ERP application. Conduct Conference Room Pilot (CRP) sessions for end users and stakeholders.
• Preparing Documentation like user manual for new ERP implementation or for new feature or functionality added to ERP.

TECHNICAL SKILLS

• Oracle Forms
• Oracle Reports
• XML Publisher Reports
• OAF
• Workflow
• AME
• EDI Integrations
• FTP/SFTP Integrations
• FSG 
• OBIEE
• SQL*Loader
• SQL* Plus
• TOAD
• PLSQL

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Oracle Applications Functional and Technical Lead

Responsibilities:

• Primary role as an Oracle Applications Functional and Technical Lead on supporting the Oracle R12 Financial application of Confidential .
• Consult with Director of development (IT), CTO (IT), Management Accounting Operational Manager (Business) and Controller (Business) to determine role of IT system within organization.
• Day to Day Functional and Technical support of the Oracle Financials environment including applying periodic patches, reporting requirements, ad-hoc requests from business and production system support for North America, Europe, UK and Luxemburg.
• To analyze corporate requirements as what cloud implementation is more suitable to organization long term business objectives. For example as per organization need choose between Software as Service (SAAS), Platform as Service (PAAS), and Infrastructure as Service (IAAS) for next ERP Implementation.
• Research emerging ERP cloud product to decide if installing them can increase organization efficiency and effectiveness. For example comparing on premises verses cloud ERP product like Oracle E-Business Suite R12.2.6 On Premise Solution, Oracle Fusion Application Financial and HCM Cloud and Workday Financial and HCM product.
• To assist ERP System implementation vendor team to understand enterprise current state and future state roadmap, working on the project plan and making sure organizational achieve its end objective in timely and efficient manner.
• To calculate system software and hardware resources required in conjunction with full or partial cloud ERP implementation.
• Prepare cost and benefit analysis for each ERP application mentioned above so management can decide if computing infrastructure upgrades are financially and requirement wise feasible.
• Devise way to add new functionality to existing Oracle ERP application, few of the example includes Accounts Payables In House Check Printing for JP Morgan Chase Bank and other bank accounts, Bank Statement Import and auto reconciliation of financial transactions, Account Receivable Transaction Upload Automation, Account Receivable Lockbox implementation, Account Receivable Receipt Upload Automation, New Amex Card Setup and Integration with Oracle Internet Expenses for expense report automation. Accounts Payable Payments Positive Pay file automation with various external banks through secure FTP, wire payment configuration for accounts payables, Accounts Payables Invoice Import and Automation etc.
• Functional and Technical Support for period close activities including but not limited to sub ledger reconciliations with GL balances and GL activities for period.

Confidential, Long Island - NY

Oracle Financial Techno Functional Lead

Responsibilities:

• Primary role as an Oracle Financial Techno Functional Lead on supporting the Oracle R12 Financial application of Confidential Inc and single handedly managing technical and functional requirements of Oracle financials across 4 operating unit in North America and UK.
• Implementation of various initiatives in financial modules like Oracle Payables, Purchasing, Oracle Receivables, Oracle Advance Collections, Oracle General Ledger, SLA, EBTax/Taxware, Oracle Fixed Asset etc. Ownership of support activities of Oracle financial modules.
• Oracle Advance Collection implementation along with Universal Work Queue, Scoring Matrices and Configuration of Scoring Engine, Enabling Customer Correspondence using XML Publisher, Revisit Aging Report and Using Bill Presentment Architecture.
• Advanced Collections implementation benefit includes increase in Collectors productivity, Streamlining Collection Process, Automated Work Assignment to collectors using UWQ, Work Prioritization, Customer Satisfaction and increase in revenue.
• Implementation of AR Lockbox, Automated Receipt Processing, Customization for Integrating Sales Order Prepayment with Lockbox Processing. Invoice Matching Rule with Lockbox Payments and exceptions handling.
• Design and develop pl/sql routine for lockbox customization. Development of PERL script for SFTP to CHASE Bank.
• Co-ordination with Chase bank for Lockbox Project Execution and project review. Understanding BAI2 file format. Connectivity analysis and testing.
• EDI Invoice Inbound - Remittance Outbound Implementation For Payables, design and development of PL/SQL Routing for Validation, invoice processing and PERL Script for SFTP File download and SFTP file upload.
• DQM - Data Quality Management Implementation for Customer and Customer Sites wherein Customer, Customer site and Customer Contact duplicate is identified and prevented during data entry.
• Real Time Address Validation - Real-time address validation by integrating with third party address database and TCA - Geography validation and maintenance.
• FSG GL Implementation - Understanding reporting requirement by co-ordinating with key business users, design and development of FSG report using XML publisher. Enabling Report Manager for FSG.
• Development of custom master-detail data entry form using OAF and JAVA technology.
• Oracle EBS Techno Functional Support for all key financial modules along with Taxware tax module. Workings with business for support tickets, if required raise Oracle SR and coordination for SR. Coordination with DBA for implementation and support activities.

Confidential, Jersey City, New Jersey

Senior Oracle Financial Consultant

Responsibilities:

• Primary role as a on supporting the Oracle R12 System of Confidential & Confidential .
• Oracle Apps EBS upgrade from 11i to R12.1.3 across North America, Canada, EMEA, LATAM with Brazil, and Asia Pacific.
• Implementation and support of modules Oracle Payables, Purchasing, Oracle Receivables, Oracle General Ledger, SLA, EBTax, Advanced Global Intercompany System, iExpense& Oracle Fixed Asset etc.
• Carrying out requirement gathering, requirement analysis, high level and granular level mapping, gap analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing, and CRP’s.
• Prepared As-Is, To-Be process flows documentation using AIM Methodology.
• Analyzed the business requirements and provided the fit GAP analysis
• Liasoned between the technical staff and the users (staff and management). Was also responsible for interdepartmental coordination between the various teams involved.
• Coordinating with Offshore development and Functional Team to resolve Issues.
• Conduct conference room pilot (CRP), user training, facilitate the user for successful user acceptance testing (UAT).
• Provide guideline and support for off shore team for various development work, mentioning and support for testing team for bug free system integration testing (SIT) and Regression Testing. Actively involved in SIT, Regression Testing and Defect triage meeting.
• Conduct regular project review and status update meetings, communication of the same to various stake holders. Initiate and facilitate discussion for cut over planning, to ensure successful cut over and upgrade on the project with bug free warranty support.

Confidential

Senior Oracle Financial Techno Functional Consultant

Responsibilities:

• Primary role as a Senior Oracle Financial Techno Functional Consultant on supporting the Oracle R12 System of Confidential .
• Oracle Apps EBS upgrade from 11i to R12.1.3 technical upgrade of EBS Financials (Payables, Purchasing, General Ledger, Receivables).
• Database and Discoverer upgrade from 10g to 11g. Data masking of sensitive information in R12 post upgrade.
• Worked on Cemli retrofitting activity and insured migration of the CEMLI to test and production instance. Custom object retro fitment related analysis and testing.
• On time resolution of high and critical defect resolution.
• Designed, tested and delivered various custom reports as per the Client specific requirement, including Invoice Register, Payment register Summary and Detail reports, Allocation of labor, Timeliness of Payments, Rejected Invoices register, etc.,
• Conduct conference room pilot (CRP), user training, facilitate the user for successful user acceptance testing (UAT).

Confidential, St. Louise, Missouri

Oracle APPS Migration Lead

Responsibilities:

• Primary role as Oracle APPS Migration Lead on supporting the Oracle R12 System of Confidential .
• Oracle Apps EBS R12 Implementation for Magellan private business and EBS R12 Re-Implementation for government business line.
• Responsible for design and develop routine for migrating historical payable Invoices and Payment data of 6 years’ worth volume 300M transactions.
• Responsible and accountable for all the data migration of various entities from 11i to R12.
• Successfully design and build various data migration components like vendor, vendor bank, Invoices, Payments, customer, AR Invoices, Receipts, Bank Reconciliation etc.
• Customer Conversion, Supplier Conversion, data mapping and data validation. Worked and delivered supplier bank interface.
• Worked on Data migration, Customer workbenches, transaction types, Transaction Sources, Auto accounting, SLA, Revenue Recognition policy, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.
• Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable AR in Oracle cash management modules.
• Worked on design and development of Remittance report.
• Setup of Cash Management module, its integration with AR and AP. Definition of Bank statement Loader.
• Setting up Oracle Payables (Payables Setups, Suppliers & Supplier Sites, Invoice Processing, Bank Setups, Payment terms, Payment Scheduling, Remittance Advice, Positive Pay, Payment Process Profile, Tax Withholding, Recoupment, Month end closing and Reconciliation).
• Configured banks, bank accounts and documents for different needs like AP processing.
• Involved in configuration of CRP2, SIT1, SIT2 and test instance.
• Conduct conference room pilot (CRP), user training, facilitate the user for successful user acceptance testing (UAT).
• Created accounting flex field segment values, creating new / updating the existing cross validation rules and security rule
• Prepared BR100 Application setup for Payables, Cash Management, Receivables, Payments.
• Involved in the Up-gradation of the Application for all financial modules like GL, AP, AR, FA, CM, Purchasing and the Self-Service Modules Like iExpenses, iSupplier.
• Concurrent Program definition, Lookups, setting of Flex fields and value set definitions.

Confidential, San Jose, California

Oracle Apps Financial and GRC Track Lead

Responsibilities:

• Primary role as Oracle Apps Financial and GRC Track Lead on supporting the Oracle R12 System of Confidential .
• Upgrade of 33 modules across Fin, SCM, OM, and GRC from 11.5.10.2 to R12.1.3 including rare ones like ASCP, Oracle Shop Floor management, Engineering, Advanced Global Intercompany system, Preventive and Advanced Control Governance etc.
• Most critical project per Agilent to go live in last 10+ years which had 3000 customization/analysis (OM - 500, SC - 1500, Fin - 1100) ; 85 Operating Units, 152 Inventory Orgs, 130 Ledgers
• 2 step GRC upgrade - From Logical Apps to 11i to R12. Worked on PCG and AACG components of the GRC module.
• Up-gradation of the Application for all financial modules like GL, AP, AR, FA, CM, Purchasing and the Self-Service Modules Like iExpenses, iSupplier.
• Configured, Accounting setup manager, COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies.
• Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.
• Extensively worked on Oracle Sub Ledger accounting to analyze and gather information from Payables into GL and reverting back from GL Journal Entries to grab Payables Invoice and Payment Details through XLA.
• Worked on Cemli retrofitting activity and insured migration of the CEMLI to test and production instance. On time resolution of high and critical defect resolution.
• Manage and resolve queries, escalation's, conflicts during the project life cycle to ensure delivery as committed.
• Set-up supplier and supplier sites for suppliers in payables. Set up banks, receipts, transactions, receipts, adjustments, and period close.
• Participate and contribute to project reviews and status updates with the customer.
• Guided and mentor team from a technical perspective to ensure delivery of the components or the defects.

Confidential

Oracle Apps Team Lead

Responsibilities:

• Primary role as Oracle Apps Team Lead on supporting the Oracle R12 System of Confidential .
• Oracle Apps EBS R12 Implementation for from scratch. Implementation and configuration of various financial modules Implementation of Oracle Payables including setup of payment options, payment terms, distribution set, payment format, banks, expense report templates, matching options, tax codes, etc.,
• Implementation of Oracle Fixed Assets module using AIM methodology, which included Asset categories, asset locations, book controls, depriciation methods, security profile, asset calender, fiscal year, quick codes and system controls.
• Worked on setting up of accounting method builder (AMB) for Financial accounting hub for various pass through Journal applications.
• Designed and developed multiple FSG reports on Budget and Actual balances, crossing over fiscal periods as per Business requirement.
• Extensively registered various AOL objects such as Value Sets, Value Set values, Custom Responsibilities, Lookup Values, Request Sets, and Request Set Links.
• Worked on Supplier, Customer, Invoices & Employee Migration Utilites
• Worked on Fixed format Check Printing Module in AP using XML Publisher.
• Configure AME for Invoice Approval Workflow
• Configuration of Report Manager for FSG and other standard reports
• Worked with R12 implementation team, gathering requirements and authoring business requirement documents and functional specifications.
• Supported Procure to pay and FA issues during month end performing additional configurations.
• Provided production support for day to day business issues and worked on SRs with Oracle.
• Provided extensive production support of Oracle financials, including following up SR’s with Oracle Meta link.