SUMMARY:

• Certified Oracle Financials Champion with around 13 years of IT consulting experience, ERP implementations in varied industries and verticals - end to end life cycle implementations- involving Procure to Pay(P2P), Order to Cash(O2C), Localizations & Oracle Projects Billing and Costing (PA) business processes
• Extensive experience in all the finance and procurement modules (Accounts Payable, Accounts Receivables, Fixed Asset, General Ledger, Cash Management, Advanced Collections, iExpenses, Order Management, AME, Procurement, Oracle Payments -iPayments and Inventory) in Fusion, Release 12 and 11i.
• Core competency lies in client facing roles, across sectors in and around areas related to Oracle financials (Release 12, 11i & Fusion) and integration of EBS system with various other systems.
• Has experience with Fusion Cloud financials and Worked on 2 Cloud Fusion ERP Implementations
• Hands-on working knowledge of Oracle Fusion Financials and Fusion Accounting Hub(FAH).
• Extensive experience in Oracle Payments iPaymets- Paymentech, Paypal and Alternative Payment Providers Integration- Santander, Cetelem, UKI, GE
• In-depth understanding of AIM methodologies and project management and documentation.
• Experience in implementing and testing of Order-to-Cash (O2C), Procure-to-Pay (P2P) business processes, Advanced Collections, Oracle Payments Credit Card Process and Cash Management Process.
• Excellent knowledge of Oracle EB-Tax/ One Source (Sabrix) and have worked closely with EB-Tax consultants during implementation assignments.
• Strong Experience in financial process analysis; process design, mapping and re-engineering, process/software gap analysis and resolution, troubleshooting and issue resolution with Oracle Financial Applications module configuration.
• Hands-on Oracle E-Business Suite specialist with many full life-cycle implementation engagements, all successfully completed on time. Project Profile in Oracle Applications Including Implementations, Upgrades / Migrations, Production Supports, Testing Projects, Custom Solutions
• Specialties: Oracle Applications Releases - R11i, R12.0.6 & R12.1.3 Strong functional technical expertise to ensure production problems are resolved quickly, resulting in continued accurate system operations and business functions Conversant with Oracle apps - Technical areas with SQL/PLSQL and Toad
• Excellent communication, Leadership abilities, inter-personal and analytical skills
• Experience in testing using tools Win Runner, Quick Test Professional and Test Director, MTM and worked as a TPM for the feature functional team.
• Experience in Oracle Application Testing Suite 9.1

TECHNICAL SKILLS:

Operating System: Windows XP/7/8/10, 2012, UNIX., Linux.

Languages: J2EE, C, C++, Java Script, Java, COBOL.

Build Tools: NANT, MsBuild, Team Foundation Server, Build Request Tool, CruiseControl, VSS

Database: DB2, SQL Server 2008/2012, Oracle 9i/10g/11g, MS-Access 2000

Web/XTechnologies: JSP, JHTML, XML, XSL, ASP

GUI s: JSP, Visual Basic.

Tools: Web Sphere Studio Application Developer, Visual Age for Java, PL/SL Developer, Web ADI, Iloaders and Data loader.

Testing Tools: Quick Test Professional 11.0, Win runner 8.0, Silk, Test Director 9.2,Autopilot 2.5,Test Manager, Clear Quest, Load Runner 9.1,Oracle Application Testing Suite 9.1, Microsoft Test Manager

Web Servers: Microsoft IIS, Apache, Java Web Server, WebLogic 8.1/7.0

PROFESSIONAL EXPERIENCE:

Confidential

Financials Functional Consultant

Responsibilities:

• Implemented fusion financials for 110 hotels on Oracle cloud offerings.
• Designed the solution to generate the daily reports considering the limitations of Oracle cloud using OTBI reporting.
• Implemented security rules to cater the security requirements of applications and smart view reporting.
• As part of the implementation, set up various tools such as the ADFDI, Financial Reporting Studio (FRS) & Smart view.
• Configured entire fusion financials accounting configurations, Ledgers, Legal Entities, Currency, Chart of accounts, Accounting Hierarchies, created and modified Trees and Tree versions & Allocation rules.
• Worked on data migration of Journals, Vendors, Fixed Assets using FBDI for 110 BU’s.
• Configured and maintained Cross validation Rules.
• Worked with business users and gave training on the oracle fusion applications.
• Performed loading conversion data using external data integration functionality by populating spreadsheet templates, loaded suppliers, payables invoices, journals, budgets, cash management external transactions, COA values and hierarchy, code combinations etc. Worked on rapid implementation model.
• Oracle identity manager to create and maintain user accounts, LDAP and sync processes, Roles and Authorization Policy Manager (APM),created custom Job roles, duty roles and data roles.
• Implemented FRS reports, balance sheets and P&L reports, based on the hierarchy such as Assets, Expenses, revenue etc., build dash boards and accessed from the applications personalized screens, enabled objects for oracle social network for easy communications with batch/document information and audit monitoring setups in fusion.
• Worked on privileges and fusion security features, strong understanding of Oracle enterprise repository (OER) to access various fusion templates and processes.
• Worked on financial reporting center and enterprise performance manager (EPM), access to calculation manager, FRS and smart view installation.
• Extensively worked on enterprise structures, users and roles, account inspector and account monitor to inquire balances, STAT accounting and STAT journals, implemented allocation using calculation manager loading COA members, various reporting offerings including FRS and smart view, worked on fusion common functionality and reference data sets.
• Implemented multiple balancing segment features, fusion offer 3 balancing segments, implemented inter-company functionality at various levels, Primary balancing level, COA level, legal entity level, Ledger Level.
• Implemented oracle transactional business intelligence (OTBI), worked on multiple subject areas, various BI tools, BI catalog, worked on My Folders, shared folders, worked on data model to create reports, exported the data into various formats, extensively used enterprise schedule services(ESS) and generated reports in multiple formats.
• Worked on Fusion Accounting hub(FAH), configured FAH to integrate with SLA and non-Oracle applications

Financials Functional Consultant

Responsibilities:

• Functional consultant responsible for implementing GL, AP, FA & procurement.
• Designed the solution for Daily Average Balance functionality.
• Developed the custom OTBI reports.
• Did the data migration for employees, users, assets, suppliers and Journal entries using FBDI & ADF ADI templates.
• Worked with Oracle for release and maintenance issues.

Business System Analysis Advisor

• Studied and documented the business knowledge of the existing applications
• Interacted with the users for AS-IS business process and document the same for validation and approval from the client.
• Interacted extensively with Users for the TO-BE Process and document them for validation and approval.
• Gathered business requirements for various modules of the system, the Business requirement mapping with the Oracle Applications and preparing the BRD documents
• Provide test effort estimates of approved change requests to Program Management organization.
• Analyze requirements during the requirements analysis phase of projects.
• Keep track of the new requirements from the Project.
• Escalate the issues about project requirements (Software Hardware Resources) to Project Manager / Test Manager. Arrange the Hardware and software requirement for the Test Setup.
• Log project related issues in the defect tracking tool identified for the project.
• Prepare the weekly EST scorecard and presentation in the PMO weekly scorecard call of the project
• Tested customized functions, programs under simulated environment and created user manual for the entire customized environment provided support to users during Go-Live by way of problem solving and instructions.
• Responsible for preparing the test strategy and test plan documents, defect life cycle management, review of test cases prepared by team members.
• Identifying the critical tests for Risk Based Testing short SIT timelines
• Identifying the tests for automation for regression
• Allocate resource to projects and assign task to all Testing Team members
• Identify Training requirements and forward it to the Project Manager (Technical and Soft skills).
• Participate in hiring and recruitment process

Financials Functional Consultant

Environment: Oracle E-Business Suite - Oracle Apps Financial R12

Tools: Quality Center 9.2, Toad, Quick Test Professional - 11.0, Loadrunner 9.1

Responsibilities:

• Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Led all stages of the implementation project, right from project kick-off till go-live and post production support. Implemented the entire financial modules single handedly.
• Did the customizations like Automatic prepayment application, automatic credit memo application, Invoice aging as of any date and Vendor credit limit feature.
• Conducted the data migration & cut-off strategy workshops with core team and stake holders from other applications.
• Managing QA team and activities
• Configured scenarios and set up the monitors to capture the performance of the Application servers, Web servers, Oracle workflow servers and Database servers using Loadrunner Controller.
• Monitors the performance of the Application
• Testing of various test scenarios of Order to Cash cycle.
• Setting Up Bank and Bank Account setups, Tax Code and Tax Group setups, configuration of Withholding Tax Setups, Payment Methods, Payment documents, Setting up profiles.
• Creating new responsibilities and defining the required system profile options, creating value set and assigning its values.
• Prepared Test scripts and involved in Application Integration Testing and System Integration Testing at clients place.
• Prepare issue and risk tracker and submit to client weekly basis.
• Worked with technical team to resolve / provide technical issues.
• Writing / executing scripts using SQL Navigator to perform various extracts from database.
• Documentation & training to support people
• Automation of Manual regression test cases into QTP scripts
• Up gradation of existing Oracle E-Business Suite QTP automation scripts to R12 version of Oracle application.
• Defect Reporting

Software Engineer

Environment: J2EE

Responsibilities:

• Deploying the JSPs, Servlets, EJBs in IBM Web Sphere Application Server 5.x
• Developing the front-end for the web application using JSP and HTML and tied the user interface with middle-tier servlets and EJBs
• Automation of manual test cases in PathNet Blood Bank Transfusion into QTP scripts for Web Application.
• Analyse and trouble shoot Test Script failures
• Manual testing of Blood Bank Donor applications.
• Defect Reporting in ClearQuest
• Reporting/Logging test case results in Test Director
• Analyzing the test results for failures
• Review of automated test scripts

Developer

Tools: Quick Test Professional 6.5, Test Director 8.01

Responsibilities:

• Automation of manual test cases in ERP, CRM, SCM, HCM modules into QTP scripts for EnterpriseOne 8.11 Web Application
• Analyze and troubleshoot Test Script failures
• Manual testing of EnterpriseOne 8.9, EnterpriseOne 8.10 Web Applications
• Execution of test cases on various modules like ERP, CRM, SCM, HCM
• Reporting/Logging test case results in Test Director
• Review of automated test scripts