EXPERIENCE & SKILLSSUMMARY:

• An OracleEBS financials systems analyst with 10+years of experienceworking on the implementation and support of core financial modules of the Oracle EBS application namely General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), Cash Management (CE), E - Business Tax (EBTax), Purchasing (PO) and Order Management (OM).
• Solution architect in Oracle EBS Implementation, production support, Integration, and upgradation projects.
• Deep understanding of the AS-IS and TO-BE processes as part of the (AIM)and OUMwith experience in related documentation
• Involved in Post-production (Go-Live) and related month-end end-user support and training.
• Experience in development of RICE/CEMLI objects, RICE life cycle during project implementation, and related functional responsibilities.
• Working knowledge of FSG,XML publisher,Discoverer Viewer, among other reporting tools.
• Excellentcommunication, interpersonal, analytical, and problem-solving skills and can perform independently or as part of a project team.
• Determined to perform well under pressure and committed to exceed client expectations while managing multiple task assignments.
• Confident to face challenges and willing to seek opportunities for professional and personal growth

TECHNICAL SKILLS BACKGROUND:

Platforms: Windows, Linux

Languages: Python, SQL

Tools: SQL Loader, Data Loader,Quick TestPro 9.0

Database: MySQL, Oracle RDBMS, MS Access

ERP: Oracle EBS Financials Release 11i & R12

Reporting: FSG reports, XML Publisher, Discoverer viewer

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, Pennsylvania

Responsibilities:

• Reviewed and analyzed current business processes for Account Receivable, Accounts Payable, Fixed Assets, General Ledger, and Cash Management.
• Supported end-users with Accounts Receivable and Accounts Payable month-end procedures.
• Closely coordinated with off-shore team in Implementation, User Acceptance Testing (UAT) and user training efforts.
• Performed FIT-GAP analysis and Conference Room Pilots (CRP) for demo setups.
• Prepared Issues list, change request forms, and client status reports and prioritized tasks based on client’s feedback and project progress.
• Ensured conversion was completed on a timely basis and balances reconciled between Oracle and Legacy system by working collaboratively with the Technical Implementation team.
• Assisted with customization and data migration using SQL loader
• Supported documentation of Go-Live production check list steps and procedures for readiness during Go-live
• Co-ordinated onboarding of large volume supplier data into AP module
• Provided solutions and setups of secondary Ledger functionalities as well as setting up Multiple Reporting Currency (MRC) in General Ledger
• Supported the design and set up of Prorate Conventions, Asset Books, and other core fixed Assets configurations.

Confidential, Philadelphia, Pennsylvania

Responsibilities:

• Reviewed current business processes for Accounts Receivable, Fixed Assets, General Ledger, Sub-Ledger Accounting, Cash Management, and i-Expense.
• Involved in month-end data clean up and Trial Balance-Sub Ledger account reconciliations.
• Coordinated setting up of bank accounts and payment formats for manual checks and Electronic Funds Transfer (EFT) in functional and multiple currencies.
• Accounts Payable - improved current business process and replaced third party procurement system by supporting the implementation of PO and AP.
• Gathered business requirements and supported completion ofAIMand updating AS-IS and TO-BE documentation; BR100, BP040, BP080, BR010, MD050.
• Following up with Oracle Support ( Confidential ) to resolve Service Request issues raised.
• Assisted in definition of systems strategy and business process enhancement.
• Led Conference Room Pilots (CRP) sessions for GL and AP modules and clarified functionalities while documenting client feedback and open issues.
• Developed test cases for User Acceptance Testing (UAT)& Client Sign-off
• Worked in partnership with Technical Team and Functional Teamthroughout the project to ensure deadlines and client expectations are met.
• Assisted in resolving functional issues, closing gaps in Oracle Applications, mapping solutions, and identifying workaround solutions.
• Acted as a liaison between the global development team and finance department in designing custom reports.
• Supported configuration of reports, interface testing, and resultant customization, and reconciliations of balances and converted transactions.
• Followed up Service Requests (SR)issues noted in the Issue Tracker to ensure project milestones are achieved as planned.

Confidential, Princeton, New Jersey

Responsibilities:

• Prepared implementation AIMdocumentation such BR.100,BR.030&MD.050.
• Participated in Conference Room Pilots (CRP), End-User Training, and client feedback documentation and follow-up.
• Created FSG reports and implemented functional and Multiple Reporting Currency (MRC) features.
• Accounts Receivable - supported customization of revenue recognition processes with respect to deferred revenue.
• Supported implementation of Currency Translation Adjustment (CTA) features and Customer Master Conversion.
• Implemented Operating Units using multi-organizational structure and multi-currency financial reporting.
• Accounts Payable - supported implementation of Positive Pay interfaces
• Supported configuration of Sub Ledger Accounting (SLA).
• Performed Business Requirement Analysis including conducting client meetings, impact analysis, and related documentation.
• Responsible for integrating Fixed Assets including data cleaning and validation, conversion and migration of asset financial information.
• Attended high level design meetings and supported documentation of detailed designs.

Confidential, San Jose, California

Responsibilities:

• Responsible for implementing Accounts Payable, Accounts Receivable, and Cash Management
• Conducted Conference Room Pilots (CRP) and tested customized functionalities.
• Configured Sub-ledger Accounting (SLA).
• Prepared test cases for use in testing the instance as well as facilitatingend-user training and developing end-user training manuals.
• Performed pre-upgrade and post-upgrade steps as required including data validation and cleaning to ensure completeness and accuracy.
• Performed impact analysis of critical issues, helped resolve post-production issues and obtained client sign-off.
• Worked with business managers to update business policies according to updated business processes.
• Participated in trouble shooting various issues including missing payments, auto lock box, and auto invoicing.
• Interacted well with Oracle Support ( Confidential ) to resolve system bugs by creating and following up on Service Requests (SR).
• Participated actively in status update meetings and following up outstanding issues so as to accomplish critical path milestones.

Confidential, Jeffersonville, Indiana

Responsibilities:

• Providedpost production support for AP,AR,GL,CE, modules by resolving and closing out all issues as they occurred in the production environment
• Diagnosed and fixed problems with Oracle Applications configurations and setups that had been done in the implementation
• Raised Service Requests (SRs) and follow up with Oracle support team for resolution
• Addressed operational problems, concerns and questions raised by business users
• Trained end users and super user and implemented the operational process documents (user guide) for use on a day to day basis.

Confidential, Foster City, California

Responsibilities:

• Involved in Requirements Gathering, FIT-GAP analysis, application design, configuration, and testing.
• Provided concise training guides and trained end users in key functionalities.
• Developed credit, debit memo, and purchase order approval workflow.
• Developed Mass Allocation process and formulae
• Configured Security Rules, Cross Validation Rules, and training on Data Access Set security options.
• Configured Pay Groups, Vendor setup, Operating Unit setup, and Legal entity setup.
• Created Employee Expense Reports and performed account inquiry and customization of standard reports
• Supported design of dunning letters, age buckets, and recurring journal templates.
• Prepared AIM documentation; MD050, BR100, BP040, RD010, and BP080
• Supported work on RICE components throughout the project.
• Performed Accounts Receivable and Payable data cleaning before conversion and post conversion.
• Escalated system issues through Confidential and followed resolution with the Technical Team