SUMMARY:

• Above 15 years of IT with emphasis in Oracle Applications R12/11i/11.0.3 planning and Implementation.
• Extensive experience in the functional aspects of Oracle Applications R12/11i/11.0. x. Worked across the different modules of Oracle Applications including General Ledger(GL), Account Payables(AP), Account Receivables(AR), Cash Management(CE), IExpense, Fixed Assets(FA),Project Accounting(PA),Financial Accounting Hub FAH,Application Object Library (AOL), Order Management(OM) and Service Contracts.
• 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, SCM and CRM Applications module configuration.
• Extensive experience in Oracle Project Accounting (Costing, Billing, Project Management, Project Contracts) and integration of Oracle Projects with other modules.
• Experience in R12 Financial Applications concepts like Accounting Setup Manager, Sub Ledger Accounting (SLA), Multi-org Access Control (MOAC), Global Intercompany Systems (AGIS) and Revenue Management.
• Expert in implementing (Architect) OBIEE packaged analytics applications such as Financial Analytics, Project Analytics, HR Analytics, Supply Chain and Order Management Analytics, Procurement and Spend Analytics, Sales Analytics, Service Analytics, and custom development using OBIEE platform. OBIEE Upgrade and Administration.
• Used Data Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Experience in working with different levels of stake holders viz. Program Management Team, Subject Matter Experts etc.,
• Experience in leading the team with primary focus on Systems Integration. Principal responsibilities include advising clients on ERP Strategy, appropriate system design and deployment of ERP solutions.
• Experience in Requirements Gathering, Analysis, Solution Design, Configuration, Training, Data Conversion and Support of Oracle E-Business Suite
• Good Exposure in Oracle Applications Implementation Methodology viz. AIM
• Good Experience in Interfaces Design, data validations, Customizing the Modules, Data Conversion from legacy systems into Oracle Applications. .
• Excellent implementation skills in RICE components i.e., Reports, Interfaces, Conversions and Extensions in the domain of Oracle E-Business Suite and strong skills in AOL, Sys Admin and workflow.
• Experience in mapping the objects from 11i to Release12
• Experience in managing offshore functional and technical teams
• Highly motivated, working well independent, troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
• Strong 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

SKILLS SUMMARY

Oracle Applications: R12.2, R12.1.3,11.5.3, 11.5.7, 11.5.8, 11.5.9, 11.5.10 and 11.0.3.

Applications: GL, AP, AR, PA, FA,FAH,PO,INV,OM,QP,WSH

Databases: Oracle 11g, Microsoft Access

Other Tools: TOAD, SQL Developer, OBIEE, Erwin Data modeler

Confidential

Architect Oracle Financials SME/Sr Analyst

Responsibilities:

• Worked as a functional consultant for the implementation of Oracle Financials and Order Management.
• Excellent knowledge in Oracle Business Flows (Procure to Pay, Order To Cash and Asset to Depreciate etc.,) and integration with General Ledger.
• Root Cause Analysis of various problematic issues, provided support for Reconciliation of Finance & Accounts & other Statutory Reports, helping technical team with the functionality and Involved in various Sub ledgers & GL Reconciliation activity.
• Ongoing technical and functional support for oracle application modules like AR, GL, OM, AP, PO, iProcurement, iExpenses and creating concurrent programs and make the report as executable.
• Participated and demonstrated the Functionality of FAH during the CRP Sessions
• Worked on fetching data from Non-Oracle database via FAH to Oracle by defining Sub ledger Accounting setups using Accounting Method Builder
• Worked on Setting Up Accounts Receivables Revenue Recognition rules.
• Responsible for the reconciling and period end close by month to all Financials modules. Techno-Functional support to all end users on Oracle Financials modules.
• Proficient with Order to Cash (O2C)and Procure to Pay (P2P) cycles, covering modules Inventory Order Management (OM), Payables (AP), Purchasing (PO), Receivables (AR) Cash Mgt. and GL.
• Conducted requirements gathering, gap analysis, testing, documentation.
• Configured standard Project related setup Implementation options, burdening details related setup, and Project related workflow and profiles.
• Drafted project implementation documents like BR-100, BR035 (Gap Analysis).
• Prepared and laid out the Auto Accounting rules based on the segments configured and Project number was also considered as one of the segment values.
• Performed the standard configuration and setups for project accounting.
• Implemented silent features of Project Accounting such as rate schedule, transaction control and auto-accounting rules, Implementation of labor cost rate schedules.
• Designed and configured Setup of Flex fields.
• Conducted Demo of Financials for Project Documentation, Deliverables, Billing Initiation etc.,
• Drafted the testing document (TE-050) for the project accounting (PA) module and participated in SIT and UAT testing.
• Conducted CRP testing, developed test scripts carried out integration testing.

Confidential

ERP Advisor

Responsibilities:

• Defined Business requirements for Oracle GL and AP, AR, PA, FA, CE, OM and Service Contracts involved in identifying GAPS
• Played Key Role while Implementing the Financial Accounting HUB(FAH)
• Worked on integrating non-oracle external application integration with FAH
• Defined Request Set and Interfaced the data to oracle via FAH by scheduling Interface Jobs from Legacy Systems
• Create Events Models, Accounting Rules in FAH as per the client requirements.
• Worked on designing the requirements for a custom form that presents the actual transaction information which is integrated through FAH.
• Worked on developing the reports for business users to reconcile the data between FAH transactional data and GL.
• Enhanced the custom drill down functionality in FAH.
• Prepared Documentation of BR 100 and Functional Extension and design Document MD 50
• Involved in all the business meetings and communicated with the business for system updates and the meeting of implementation deadlines
• Involved in the implementation of Oracle Service Contracts and Install base
• Involved in the setup of Order-to-Cash (O2C) Receivables processes including Revenue Recognition, Collections, Invoicing; understanding of integration with Order Management, Inventory, GL, Cash Management
• Worked on Projects Integration with Accounts Receivable..
• Used Contracts for Project Tracking,Billing Initiation,Version Tracking, Funding etc.,
• Responsible for Oracle Service Contract module requirements gathering, fit/gap analysis, functional design, system integration and user acceptance testing, user training and production support
• Was involved in finding effective solutions that consisted of both work around and customizations to the forms and reports
• Identified RICE components according to the client needs
• Collaborate with data architects for data model management and version control.
• Involved in conducting data model reviews with project team members.
• Captured technical metadata through data modeling tools (Erwin)
• Enforced standards and best practices around data modeling efforts.
• Ensured data warehouse and data mart designs efficiently support BI and end user
• Conducted SIT,CRP, and UAT and tested all the setups.

Confidential

Oracle Senior Analyst

Responsibilities:

• Gathered & analyzed requirements, current business processes and mapped requirements to Oracle Release 12.
• Defined FAH setups like Event Model, JLT’s, JED’s, Sources, Application Accounting Definition, Mapping Sets, Sub ledger Lookups based on Business Requirements
• Tested end to end upload of GL Journals using Web ADI and staging them onto FAH and then running Request Set to populate data along with approval controls built around it.
• Prepared configuration document (BR100) and functional specification (MD50) for various custom components.
• W orked on project costing and project billing setups and implementation integration with oracle team and labor (OTL) fixed assets (FA) along with project Foundation.
• Prepared and laid out the Project Auto Accounting rules based on the segments configured.
• Functional Support for Oracle R12 E-Business Suite for US and Mexico
• Review and Prioritize severity of Service Requests Pertaining to Oracle GL, AP, AR, SLA, Projects, FA,Cash,Service contracts and Install base
• Involved in post-production support and maintenance of the Applications and resolving user queries and to gather new requirements analysis, Knowledge Management, Test Planning and Test Design activities.
• Developed Test strategy, Test Plan and Test cases for the functionalities developed as per the client requirements.
• Analyze and Provide solutions for issues related to all Financial modules within Service Level Agreements
• Coordinate and communicate with Cross-functional business teams, PMO, Project team spread across US and India
• Coordinate with technical teams to resolve issues pertaining to inbound and outbound interfaces to various Oracle modules. Example: Hyperion Extracts from Oracle, Outbound extracts for Customer Statements, Inbound interfaces for Oracle Receivables such as Autoinvoice and Lockbox
• Extracted data from Oracle and using Informatica to load it into a single data warehouse repository.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
• Developed and implemented measurements for various marketing campaigns.
• Created a net loss model which analyzes the impact of loan defaults and recoveries.
• Created a relational model and dimensional model for online services such as online banking and automated bill pay.
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Developed logical data models and physical data models using ER-Studio.
• Work with Oracle Support for Product related issues, perform QA before application of patches and data fixes in test instance
• Prioritize, delegate and manage support team based in India

Confidential, TX

Senior Oracle Functional Consultant

Responsibilities:

• Payables lead for Oracle Release 12 implementation
• Involved in configuration for Account Receivables, Payables, Banks and Cash Management
• Documented current and future processes and baseline requirements, document existing business process, define future Oracle R12 processes and capture these data in RD20, BP40 and BP80 documents
• Prepared/reviewed setup document and configured Oracle R12 instances for Conference Room Pilots and other testing workshops for all financial modules viz., GL, AP, AR, CE, PO & FA,PA,Service Contracts and Install base
• Setup of AR Transaction types, customers, System Options, Tax Codes, Tax Groups, Key and Descriptive Flex fields
• Setup of AP system options, Finance options, Tax codes. Register and define Descriptive Flex fields
• Gathered and analyzed business requirements. Documented functional requirements pertaining to financial modules and security features in Project Accounting and OTL.
• Worked on Project Billing events, Project costing, Budgeting and Project Management.
• Worked on Project Billing Extensions to Create Event Holds.
• Prepared functional specification (MD50) for Customizations, Extensions, Reports & Interfaces and CV40 for converting data from Oracle legacy systems
• Prepared and delivered end user training documents using Oracle UPK
• Defined setups for Oracle AR like Auto Cash Rule Set, Grouping Rules, transaction sources, Transaction types, payment methods, payment terms, Sales tax flex fields Structure, System Options, collections, receipt class, receipt sources. Defined Centralized Tax Setups in E-Business Tax module.
• Log, track, fix issues that arise from CRPs and other business validation workshops
• Mentored technical team to develop, test and deploy custom objects
• Prepare test scripts for testing various business processes
• Printing and electronic delivery of customer invoices automatically using XML Publisher. Developed custom solution for XML bursting to be able to email individual AR invoices to sutomers

Confidential, Chicago, IL

Functional Analyst

Responsibilities:

• Mapped the future process requirement into oracle AP Module and identified the gaps. Analyzed the identified gaps. Customized client's expose authorization form, carried out the set up the accounts payable module.
• Defined Accounts Receivables Customer profile classes, bank accounts, payment terms, distribution sets and Credit
• Involved in the implementation of Financial Modules and Project Accounts Billing and Costing, Involved in designing the accounting flex field structure and set of books.
• Setting up of cross validation rules between flex field segments, setting up of security rules and assigning to different responsibilities, defining aliases etc. in GL.
• Responsible to perform process analysis, integration, testing implementation and documentation based on AIM Methodology
• Involved in creation of projects and project status. Created various projects, tasks and sublevel tasks with in those projects.
• Did all the setups in Projects like Project Class, project types and project templates etc
• Defining Multi Org. Choosing setup of books and setting up profile options for the responsibilities defined in GL
• Defined payment terms and recurring invoice templates. Setup employee expense templates and distributions sets.
• Defined value sets, key flex fields segments and Defined multiple setup of books, accounting periods, automatic processing, journal sources, journal categories and summary accounts
• Responsible to reconcile the financials modules and period end close by month to all financials modules
• Creation of corporate tax books, creating of calendar, prorate conventions and depreciation methods
• Imported assets invoice into accounts payables and integrated to different modules for further processing of mass additions.

Confidential, Austin, TX

Implementation Analyst

Responsibilities:

• Functional support to all end users on financial modules, Order to cash, Procure to pay cycles.
• Implementation of setups and configuration of Oracle Financials R12 AR Treasury, Cash management for AR lockbox, inter-agency funds transfer, cash/funds position and forecasting process
• Authorized some AIM documents for AP Module including business requirement mapping document, security profile document, conversion strategy, and setup document.
• Responsible for define different types of standard and financial statement and drill down through application development integration
• Involved in Configuration of Oracle Project Costing Auto Accounting to standardize and streamline the account generation for material, labor and miscellaneous transactions .
• Experience with SR handling in order to provide bug support in Oracle Projects Module.
• Setup of AR Transaction types, customers, System Options, Tax Codes, Tax Groups, Key and Descriptive Flexfields
• Setup of AP system options, Finance options, Tax codes. Register and define Descriptive Flexfields
• Defining Users, assigning responsibilities, creating Menu and Profile options
• Involved in testing of Order to cash, P2P and Projects cycle
• Created the General Accounting functionality by setting up Chart of Accounts and Fiscal Calendars.
• Conversant with Oracle Applications-Technical areas with SQL Toad
• Defined the Multiple set of Books, Accounting Periods, Automatic Posting, Journal Sources
• Coordination with Onsite Consultants for resolving the issues and for on call support
• Co-ordinate with Oracle ERP Development Team on all SRS, Oracle Reports customizations and identifying the complete problems

Confidential, Virginia

Production Support Consultant

Responsibilities:

• Responsible for CE, AP, AR and eBTax modules from UAT through to Go-Live in the Upgrade project.
• Involved with Super User Training and resolving post UAT issues.
• Re-defined system parameters and Bank Statement Mapping in CE
• Performed additional Setup for Customer and Address Relations in TCA Architecture
• Corrected the system configuration to take care multi-currency invoice entry and payments
• Worked on Trading Community Architecture (TCA) and customizing customer import program for site/contact information
• Defined the 1099 suppliers and testing the tax payment extractions for reporting purpose
• Developed AP, AR and CE user Training Guides
• Performed Setups for the Auto Cash rule set according to client requirements
• Prepared Static and dynamic data template for collecting all the information about the Banks, Vendors, Customers, Tax Codes etc.
• Developed/Updated BI Reports for Month End Reports
• Supported Business Users in Month End Close Process
• Resolved Reconciliation issues with Sub ledgers to GL
• Prepared documentation at various phases.

Confidential

Oracle Apps Support Analyst

Responsibilities:

• Trained the business users on Global Translations, Revaluations and Consolidation of Multiple Ledgers.
• Developed TE.040 Test Scripts for Functional Testing of GL, AP, FA and developed Guided Navigations
• Developed Training Material for AP, FA modules
• Conducted end user training sessions and User manuals.
• Post implementation support and maintenance - performed successful three month end to end period close activities in the newly implemented modules
• Design and Configure Financial Statements Using FSG
• Maintain issue tracker using Bugzilla and issue resolution.
• Conducted business meeting whenever required based on issues and new functional requirements.
• Prepared documentation for change management process along with impact analysis on the proposed solution.
• Created and followed up on Service Request (SR) with Oracle support.