SUMMARY

• Oracle Expert Professional 8+ years of experience working as Lead Oracle Applications Techno - Functional consultant in IT industry. Key responsibilities include business requirements gathering, designing, developing, mapping, configuring, testing and support financial.
• Have managed multiple ERP implementations and upgrade projects. Extensively working on 11i and R12 environments supported business process and implemented extensions. Have done multi country and/or organization rollouts.
• Experience in Procure to Pay (PTP) modules, Order to Cash (OTC) modules Business Processes functionality.
• Experienced in Oracle Applications 11i, R12 financial modules GL, AP, PO, FA, CM, AR, iExpenses, iSupplier, EBTax and iProc.
• Worked in all the phases of projects like requirement gather, CRP, UAT and post production support.
• Expertise in various Application Extensions, Conversions, and Process Re-engineering (RICE) and preparing Functional Document Design and Testing Documents developed through Oracle User Productivity Kit Professional (UPK) tool.
• Designed and developed Oracle Web ADI, financial modules Interfaces for the legacy system data transfer.
• Experience in implementing oracle E-Business Tax (eBTax) module at various configuration levels such as Global Configuration level and at Operation unit level
• Successfully completed 4 Full life cycles projects with Oracle E-Business Applications 11i (11.5.8 & 11.5.10) and recent experience in R12 (12.0.4 & 12.1.3).
• Experience in configuring Sub Ledger Accounting Method (SLA) for the business requirements.
• Experience in Implementing Oracle Application Implementation Methodology (AIM).
• Experience in Oracle Workflow, Approval Management Engine (AME), System Admin, Alerts and Form Personalization.
• Expertise in Patch Analysis, analyzing Release Content Documents (RCD) and Release Update Pack (RUP) for the complicated patches and advice the regression testing plan.
• Expertise in conducting product demo and training users on the production. Conducted CRP session all by myself.
• Expertise in handling high volume data loading through Data load and using SQL Loader and pl/sql packages for the validation.
• Expertise in documentation using AIM methodology like RD020, BP020, BP040, BR100, MD050, CV040, BR030 and TE020, TE040 documents.
• Expertise in implementing Financial System Generator (FSG) and Global Consolidating System (GCS).
• Experience in Financials Month End Close process (MEC).
• Expert in Interface design, development and testing.
• Experience in writing PL/SQL Queries, Packages, Stored Procedures, Functions, Triggers and Developer 6i (Forms and Reports).
• Manage offshore/onsite teams to make sure client requirements/issues understanding correct and to deliver the requirements as expected.
• Excellent communications, Interpersonal and leadership skills, Target oriented and Team oriented.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite 11i, R12

Functional Modules: GL, AP, AR, FA, CM, PO, iProc, OM, iExpenses, Inventory, Isupplier

Technical Modules: Sys Admin, AOL, Web ADI, Workflow Builder, AME, Form Personalization

Database: Oracle 9i/10g/11g/12c, SQL Server, MS Access

Languages: SQL, PL/SQL, SQL*Loader

Tools: MS Office, TOAD, SQL Developer, SQL Navigator, JIRA, Putty, Win SCP, FTP Server, Dataload, UPK, Microsoft Sharepoint, Lotus Notes, Tortoise SVN

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle Techno-Functional Consultant

Responsibilities:

• Developed a high level implementation plan and rollout strategy based on the findings of the Gap Analysis study.
• Managed day to day business issues for AP, PO, iProc, Workflow, GL modules. Handle critical and show stopper PROD issues.
• Provided Continual Service Improvements (CSI) for various areas to improve after analyzing the gaps or difficulties of the business process
• Worked and supported mock close in stage environments and Month End Process (MEC) for PROD financial and AP module.
• Developed Custom inbound interface for creating Invoice, creating Recurring Journal Batches and Outbound interface for sending Payment information. Components include Host program for FTP, SQL dataloader for loading file and PL/SQL procedures and packages for validation.
• Implemented CRON jobs for automating interfaces schedules.
• Form Personalization in Logical Apps, Java Forms.
• Involved in defining E-Business Tax (eB Tax) Setups.
• Customized Tax finance reporting process.
• Debugging Oracle custom report using Oracle report builder.
• Directly Involved in project plan, gathering business requirements, design, build and implement EBS Financial Suite including General Ledger, Payables, Receivables, eBTax, Vertex 'O' series, Credit Management, Advance Collections and Funds Disbursement/Capturing solutions
• Performed upgrade analysis required upgrade from R12.1.2 to R12.1.3 and provided impact analysis. Analyze existing functionality and advice business or CEMLI for any changes required.
• Schedule resources for the critical issues, MEC plan, and Monthly Releases Deployment into PROD.
• Coordinate Offshore/Onsite team for the different issues, schedules, meetings, client requirements to get good understanding between teams and client requirements/issues.
• Prepare business process document, support document, user manuals, test cases for the enhancements and extensions
• Prepare Whitepapers for the ongoing chronic issues to help other teams in the organization.
• Lead and provide the status in client meetings for various issues on weekly basis, organize conferences, meetings for the regular issues
• Provide KTs to the super users, presentation new changes/process required.
• Prepare different types of status reports for project activities and report to management.
• Coordinate with client, DBA, functional and technical team for the helpdesk issues, performance issues, and CEMLI issues.

Confidential, NY

Oracle Techno-Functional Consultant

Responsibilities:

• Support and implementation for iExpenses, iProc, iSupplier, PO, AP, GL, FA modules.
• Assisted in managing and validating implementations of new systems enhancements, systems patches and upgrades Document and implement federal accounting standards, policies, and procedures.
• Advised or assisted clients on federal accounting and financial systems implementation and operational matters.
• Conducted quality assurance for ERP implementations
• Helpdesk support through the tool BMC Service Desk tool and assist users in resolving day to day business issues.
• Gather business requirements and design and build the solution with the coordination of CEMLI team.
• Perform Roll outs and Multi-Org setups and for new operating units and deactivate any existing operating units per prepared BR100 document.
• Support super users in setting up COA values in addition or disabling of the new changes in business.
• Developed excel sheet for the AP Open Interface program for large volume of invoices entered on regular basis.
• System Administration Setups for Users, Responsibilities, Menus and Request Groups for the new user groups added in new roll outs.
• Used dataloader tool to create script for creating users and responsibilities.
• Implemented Supplier approval using isupplier. Utilized AME for the same. Implemented Custom approval Matrix.
• Assist Clients in Global E-Business Tax (eBTax) Implementations, P2P Tax integration with Vertex O Series, Project Accounting & Service Contracts Tax Integration, Sub-Ledger Accounting, Fixed Assets Conversions, Process Re-engineering, Tax Management Consulting and Advisory Services.
• Created custom inbound Interface program to import payroll journal entries in GL module. Custom objects developed where host program for FTP, PL/SQL package to load the data in to GL IMPORT table and run the journal import program. Separate PL/SQL package was developed to email output and log the program.
• Helped ADP Taxware enterprise get validated for their US P2P and International adapter for Oracle eBTax.
• Implementation of withholding tax in the payable module.
• Configure new Ledgers, COA, Calendar and OU’s for the new businesses added those cannot be not aligned to the existing applications configuration.
• Support employees in iExpenses and provide clarifications, workarounds immediately at their desks, mails, phone and WebEx web conferences
• Support iExpenses Credit Card functionality implemented and coordinated Chase bank for the frequent issues.
• Assisted the OBIEE team with custom view or report generation.
• Facilitated multiple legacy teams with providing data in SQL view format or text file output of an outbound interface.
• Worked with implementation team to cleaning data from various sources to be loaded into our proprietary software
• Work with Oracle Support for the issues and coordinating with DBA to close the issues.
• Perform Patch Analysis for the patches, Generic Data Fixes GDF and deploy the Master Diagnostics Scripts (MGDF) in PROD to find any data corruption on the transactions.
• Write SQL queries to provide data to the client on any emergency one-time need.
• Attend daily conference calls to coordinate with on-site team on support and prepare status reports.

Confidential, Philadelphia, PA

Oracle Techno-Functional Consultant

Responsibilities:

• High volume application setups per day to day business need HR Positions, Jobs, and Organization Hierarchy setup through Dataload.
• GL, AP, iExpenses, AR, AOL, PO, HR, OM, PA, Form Personalization and related application Setups for new rollouts added.
• Extracting application setups data through SQL queries and validate them through excel sheet.
• Support month end close for the financial modules.
• Prepare weekly and monthly estimation on time schedule and efforts/resources required for the bulk volume setups.
• Designed & Executed SIT/UAT Integration Testing by running test cases for Oracle 11i Financials (O2C- AR/Tax/GL/AP)
• Configuring customized form which will be applied for automatic Generic Datafix (GDF) for non issues
• Proactively developed and test custom HR interface program to load daily high volume data required to setup.
• Enabled VAT for Intercompany transactions in EU using Sabrix and E-Business Tax.
• Build supplier conversion programs in PL/SQL.
• Used BI publisher to design payment template based on the check gauge provided by Bank of America.
• Used BI publisher to convert text output of some for the standard programs into excel format.
• Converted custom 11i reports outputs into r12 technical architecture using report builder.
• Performed oracle form personalization to hide to pop alert message, disable standard button on the toolbar and hide fields and button.
• Write financial modules, system administrator SQL Queries to extract and validate the setups for bulk data.
• Interacting with client on clarifications of setups
• Setup changes and validating the same to ensure the deliverables quality

Confidential, NY

Oracle Techno-Functional Consultant

Responsibilities:

• Update BR100 as per change in Business requirement
• Review BR030, BP080, MD050 and prepare Test Scripts for Shakedown and Regression testing
• Execute Test Scripts as per Shakedown and Regression test documents
• Setup changes and validating the same to ensure the deliverables quality
• Validate different instances application configuration to make them in sync with the BR100 by extracting the data from the backend
• Work on Advanced utilities (Synchronizer) to compare the high volume data extracted after Instance t Instance Setups completed.
• Create custom view for discover reports. Most of these views are materialized views.
• Designed and build a custom tax engine for Intercompany transactions.
• Configured Sabrix and EBTAX for European and US entities.
• Load the large volume setups by SQL Data Load tool for and validate them to ensure the quality.
• Worked on Supplier conversion from the legacy system. Developed the program to load the vendor and create vendor sites based on the flat file.
• Gatheird local business/legal/tax requirements to generate GAP and configuration log for Oracle Latin Tax Engine and IR modules.
• Developed a program to spit out the flat file with the accounting information for other legacy systems. dis flat file is tan loaded into their system. Program is schedule to run nightly.
• Importing bank statement from a flat file and using auto reconciliation program to load the bank statement in to oracle for recon
• Attend scheduled conferences daily to interact with Onsite team and Client manager about work, issues, clarifications and deliverables.