PROFESSIONAL SUMMARY:

• Around 13 years of Experience in Oracle Financial domain. Involved in 4 Full Lifecycle ERP Implementation which include 2 Cloud Financial Implementation(1 OTC, 1 P2P including FAH/SLA), 3 ERP Upgrades and 4 ERP Support experience.
• Working closely with Controllers, Accounting Managers (General Ledgers) and various super users for Payables, Receivables, Fixed Assets, Cash Management, Employee Expense and RMB functional area and supporting them for their daily operations, reporting requirements and key initiatives in their respective functional area.
• 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 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 support, 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 their 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, RMB, RMCS, SLA & FAH.
• Provide Day to Day support of the Oracle Financials environment including applying periodic patches.
• 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.

PROFESSIONAL EXPERIENCE:

Confidential, Florham Park, New Jersey

Business System Analyst

Responsibilities:

• Participated in global system design and performed key role in finalizing global system architecture for global OTC implementation project.
• Worked as Project Manager for Global Oracle Order to Cash implementation project. Successfully coordinated with various track leads, system administrator, DBA team, vendors including system implementation partners, various cross functional ERP team’s such as Oracle CRM, Sales Force, EPPM, JDE, Hyperion team and other Cross functional team within and outside the organization.
• As core member of PMO group responsible for providing timely project status updates to various stakeholders and sponsors.
• Ensure successful and timely delivery of RICEW components.
• Planning and execution of SIT and UAT cycles. Defect triaging for SIT and UAT bugs.
• Cut-over planning and cutover execution for successful Go Live.
• Responsible for all end to end integrations and conversions within OTC (Billing and Revenue Management Cloud Service), Oracle AR and GL track using Oracle Integration Cloud(ICS) and Enterprise Data Quality(EDQ) tools.
• Successful conversion of customer master and customer bank account using FBDI.
• Manage system configurations for Oracle Accounts Receivables and Oracle General Ledger module. Hands on experience on rapid implementation.
• Worked on reporting tool like BI Publisher, Financial Reporting Studio and Smartview etc.
• Provided support and guidance for end to end AR lockbox implementation.
• Post Go-Live warranty support for Oracle Accounts Receivable and Oracle General Ledger track.

Confidential, Jersey City, New Jersey

Sr. IT Business Analysis Specialist

Responsibilities:

• Provide solution consulting for implementation and support of Oracle Financials Cloud
• Best practice implementation approach in finance domain
• Drive discussion with key business SME to design to-be processes based on Oracle Financials Cloud architecture
• Configuration of Oracle Financials Cloud modules to support design and implementation
• Experience working on reporting tool like BI Publisher, Financial Reporting Studio and Smartview etc.
• Knowledge of the Data Object structure for Fusion Financials Cloud.
• Support end to end business process impacting finance functions within Oracle Financials Cloud
• Design and document integration solution using Oracle Unified Methodology
• Provide support for issues encountered by end users
• Capture and review user requirements and identify potential solution
• Work on to identify the requirement of creating the various Proof of Concepts (POC).
• Functional and Technical Support for period close activities including but not limited to sub ledger reconciliations with GL balances and GL activities for period.
• Analyze, design and configure SLA/FAH module for maintenance, enhancements or completely a new requirement.
• 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.
• Responsible for post-go live application support and transition to Support group.

Confidential, New York City, NY

Oracle Financial ERP Business System Analyst

Responsibilities:

• Worked as Workday financial conversion lead for various financial conversion items such as Suppliers, Customers, Projects, Supplier Invoice, Customer Invoice, Fixed Assets, Cash Management and General Ledger etc.
• Worked on Workday Financial implementation project along with System Implementation team and business super users.
• Working closely with Controller, Accounting Manager (GL and Consolidation) and various super users for Payables, Receivables, Fixed Assets, Cash Management and Employee Expense functional area and supporting them for their daily operations, reporting requirements and key initiatives in their respective functional area.
• 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.
• Functional and Technical Support for period close activities including but not limited to sub ledger reconciliations with GL balances and GL activities for period.
• Mapping of Oracle EBS entities to Workday Entities and data models to build a common data model for data warehousing for historical and as of day reporting requirements.
• 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.

Confidential, Long Island, NY

Oracle Financial Techno Functional Lead

Responsibilities:

• 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:

• 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, Greenville, South Carolina

Senior Oracle Financial Techno Functional Consultant

Responsibilities:

• 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:

• 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.
• 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.
• 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.