SUMMARY:

• Over 13 Years of IT experience in Oracle Financial Applications with expertise in Oracle EBS R12 and R11i.
• Over 4 years of experience in Team Lead, Solution Architect and Project Manager positions.
• Four full life cycle Implementations, One Upgrade and couple of support/enhancement projects in Oracle EBS R12 and 11i.
• Developing proposals and preparing project plans.
• Strong experience in GL, AP, AR, CM, e - BTax and PA modules and supporting Order Management, Inventory and PO modules of Oracle Applications.
• Multiple project life cycles experience with Planning, Business Analysis, Requirements Gathering, Functional Design Development, Integration & User Acceptance Testing, Training, Go-live and Post-Implementation Support.
• Managed all phases of the Software Development Life Cycle (SDLC) for multiple custom solutions.
• Developed Functional Specification Documents (MD50), Business Requirement Documents (BRDs), GAP Analysis, Solutions for the GAPs, Dealing with Business Users on Training and Testing of the application.
• Develops and implements Methodologies, Policies and Procedures to ensure systems and applications are in compliance with company standards.
• Working knowledge in SQL, PL/SQL - to identify data corruptions and developing data-fixes for functional issues.

TECHNICAL SKILLS:

Languages: SQL, PL / SQL

Oracle Applications: E - Business Suite- R12.x/11.x

Oracle Apps Modules: General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Cash Management (CM), Fixed Assets (FA), Advance Global Intercompany System (AGIS), E-Business Tax (EB-Tax), Subledger Accounting (SLA), Purchasing (PO), Order Management (OM), Inventory (Inv), Project Costing, Project Billing.

Configuration Tools: ConfigSnapshot

Testing Tools: HP Quality Center

Oracle Tools: SQL*Loader, Toad

Other Tools: MS Word, MS Office, MS Excel, MS Power Point, MS Project, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential,Charlotte,NC

Project Manager

Responsibilities:

• Managing a team of 3 members
• Supporting business partners across multiple ledgers (SAP/Oracle) to ensure the completeness, accuracy, and integrity of the financial data.
• Ensuring the completeness, accuracy, and integrity of the financial data.
• Preparing detail analysis repot to summarize the resolution of incidents in a meaningful manner to support management decisions during all key phases of the projects.
• Preparing knowledge based documents and assisting the management team in taking the decision to upgrade the current Oracle system.

Confidential,Novato,CA

Project Manager and Solution Architect

• Preparing Project Plans.
• Overseeing the EB Tax solution and provided necessary guidance.
• Managing the work of third party vendors who are working on EB Tax Implementation.
• Provide weekly status update to client management.
• Producing stage plans, highlight reports, risk logs, requests for change etc.
• Handling offshore technical team and making sure the technical objects are delivered as per the time lines.
• Perform risk assessments, Initiate change management process for enhancements.
• Ensure system setups for planned mile stones as part of Implementation.
• Coordinate CRP / UAT sessions.
• Perform periodic measures on project progress.
• Draft comprehensive status reports.
• Designing Auto Reconciliation solution for Lockbox Receipts created for Check, ACH and WIRE Transactions.
• Designing Lockbox File format for ACH and WIRE payments.

Confidential,Buffalo,NY

Project Manager

• Preparing Project Plans.
• Manage & Assign work objects to team members.
• Producing stage plans, highlight reports, risk logs, requests for change etc.
• Providing strategic direction during the implementation stages.
• Providing project status to Stakeholders, PMO and Steering Committee.
• Managing client expectations by ensuring the delivery of the highest quality service.
• Coordinate communication between client users and internal team.
• Plan objects development and perform effort estimation.
• Ensure objects are delivered as planned/agreed.
• Perform risk assessments and Initiate change management process for enhancements.
• Ensure system setups for planned mile stones as part of Implementation.
• Coordinate CRP / UAT sessions.
• Perform periodic measures on project progress.
• Draft comprehensive status reports.
• Initiate training activities for team members.

Confidential,Buffalo,NY

Solution Architect

• Understanding the existing business processes in the areas of AR, AP, GL, E-Biz Tax, Purchasing, Order Management, i-Expenses and INV.
• Customized invoice print report using Oracle BPA.
• Designed custom solution to hold sales orders for not creating invoices without Customer PO Number.
• Designed a custom interface to import AP invoices from third party system and custom programs to provide details of invoices imported, rejected and validated.
• Preparing MD050, BP070, BP080 documents.
• Implemented Vertex Tax engine to calculate sales tax based on specific Item Categories.

Confidential,Scranton,PA

Finance Lead

• Solution design in the areas of Finance and Order Management.
• Co-ordination with Client Process Leads & Project Managers in identifying gaps and building the solution for the same.
• Preparation of business flow, functional specification, test case, data migration plan documents. Analyzing and approving the final technical specification documents.
• Responsible for user test planning and execution by defining UAT test strategy, scenarios and framework to guide SMEs through effective UAT script writing, test execution
• Designed Inbound and Outbound Interfaces.
• Designed various custom Trial Balance, Account analysis reports.
• Designed custom Positive Pay File and Check formats.
• Designed custom AR Invoice and Credit Memo formats.
• Post go-Live support activities - month, quarter and year close activities, GL interface Issues, Posting issues etc
• Highlighting and performing root cause analysis for the issues and then doing risk analysis for the same.

Confidential

Finance Lead

• Implemented Oracle Financials R12 General Ledger, Accounts Payables, Accounts Receivables, Cash Management, EB-Tax and Project Costing and Billing.
• Designed custom Billing Data Store engines to store the data came different subledgers.
• Designed custom interfaces to import data in AR interface tables based on the data in custom Billing Data Stores.
• Customized SLA functionality in Receivables, Payables, Project Accounting and Cost Management to derive the Accounting Entries based on Item Category.
• Customized Tax engine to calculate VAT based on Item category and Customer Bill to Address specific to UK, EU with and without VAT Numbers and Rest of the World.
• Customized invoice print report to produce custom output using BPA
• Proactively interacted with client to understand their business practices and configure the system accordingly.
• Analyzed various business functions to derive benefits that would be obtained in terms of cost rationalization and management control as a result of the implementation.
• Performed fit/gap analysis, pre-production business testing, conference room pilot support, interface/conversion mapping, and related documentation/deliverables.
• Doing process flow testing to see how the data will flow in the customized forms and tables
• Developed a custom design to calculate VAT on Deposit transactions and record correct account entries.

Confidential

Finance Consultant

• Resolved functional issues in finance modules i.e., General Ledger, Oracle Payables, iExpenses, Oracle Receivables, Cash Management
• Working on a queue of current customer issues in a variety of statuses
• Provided resolutions and/or workarounds (to minimize the impact of the issues till issue get permanently fixed)
• Involved in root-cause analysis and in provided suggestions/options to avoid re-occurrence of the issues in future.
• Closely worked with Oracle support for issues like Data corruption, Bugs, etc.
• Experienced in interacting with users across globe, performing Live-meeting sessions (similar to OWC/Net-meeting) to understand the issues as well as to guide the users towards resolution.
• Coordinated between clients and other internal teams effectively in critical times such as Production Down, Network problems etc.

Confidential

Finance Consultant

• Implemented Oracle Financials 11i General Ledger, Accounts Payables, Accounts Receivables and Cash Management.
• Setups included Multi Reporting Currency, Multi Organization
• Defined calendars, Distribution sets, Tolerances, bank accounts payable documents, payment terms, approval groups and approval assignments.
• Setup Receipt Classes, Receipts Sources and Payment Methods.
• Defined Recurring and Allocations Formulas.
• Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes
• Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defining distribution sets and advanced collections.
• Defined receipt class, specifying creation method, Payment method, clearing method, defining collectors, defining aging buckets

Confidential

Finance Consultant

• Worked on Production Support for AP, GL, AR modules.
• Tested functionality after patches or configuration changes and conducted Tests.
• Interacted with users in resolving Production issues and fixed necessary application requirements like changes in values, setups or any other processes including System-Admin works etc, followed Change Control Request system from concerned authority to do the jobs.
• Built and run FSGs Trial Balance and Profit and Loss other Reports.
• Run and provided FSGs and Standard reports to users on request for Auditing by PWC.
• Prepared and run Consolidations.
• Supporting user in UK, Europe and India.
• Worked on Users training and thorough testing on upgrade instances.
• Worked extensively with Oracle Meta link to resolve Production issues

Confidential

Finance Consultant

• Implemented Oracle Financials 11i Accounts Payables and Accounts Receivables.
• Gathering business requirements, identifying gaps, design solutions to resolve gaps in the standard Oracle system Configuration in the application.
• Observed the Dependency among the Application Modules and resolved the issues
• Identifying the technical gaps and designing the custom solutions, estimating work and providing the production support.

Confidential

Finance Consultant

• Implemented Oracle Applications 11i (11.5.x)
• Worked on configuration and testing of Payables module.
• Performed fit/gap analysis, pre-production business testing, conference room pilot support, interface/conversion mapping, and related documentation/deliverables.
• Performed post production support for enterprise-wide General Ledger, Payables and Receivables and related documentation/deliverables.
• Addressed operational problems, concerns, and questions posed by users