SUMMARY

• Having around 8 years of IT experience as an Oracle E - Business Suite Financials TechnoFunctional Consultant using Oracle Applications (11i and R12) with Strong analytical skills in Financial Modules.
• Experience in Client Management, Users, Guiding Technical team and Strong Oracle Applications Gap Analysis, fresh implementation, up gradation, Customizations and support experience in Finance modules.
• Experience in understanding business requirements for analysis, and mapping applications as per the client requirement.
• Extensive experience in four full life cycle implementation and upgrades 11i & R12.
• Successfully completed Four full life cycle (FLC) implementations of Oracle Applications release 11i and R12.
• Experience in implementing full life cycle, scoping and supporting Oracle Applications 11i and R12. Areas of expertise include: General Ledger(GL), Sub ledger Accounting(SLA), Accounts Receivables(AR), Fixed Assets(FA), Accounts Payables(AP), Purchasing, Order Management, Oracle iExpense, Cash management, Financial Statement generator and Ebtax .
• Experience in implementing both P2P and O2C cycles.
• Active participation in Application evaluation, Process flow reviews and Requirements definitions .
• Expertise in Preparation of Process Documentations, Training Materials & User Trainings like BR100, MD50, etc using AIM Methodology.
• Expertise in business process analysis, requirement analysis, Gap Analysis, system mapping, CRP testing, system configuration, data conversions, master data loading and production go-live support.
• Extensive experience identifying product gaps coordinated with development team by creating TAR/SR and obtained one-off fixes. Managed and monitored Tar’s for several P1 issues.
• Extensive experience in using SQL, PL/SQL, Developer 2000/6i, Oracle Reports 6i/9i,Discoverer3i/4i,XML Publisher Reports, Workflow, Procedures, Functions and SQL Loader, Oracle 10g/9i, Unix, Linux and Oracle Applications RICE Components .
• Expert in System Administration (AOL) in defining users, menus, responsibilities, printer set-ups and maintaining concurrent programs. Defined Custom Applications, which includes new Menus, Request Groups and Responsibilities using Application Developer and System Administrator responsibilities and Financial Statement generator
• Responsible for maintaining and improving the Finance, Oracle Configuration and data reporting while ensuring regulatory compliance.
• Highly organized. Ability to work under pressure in fast-paced environment. Excellent interpersonal skills with an ability to interact with individuals at all levels and to mobilize and lead a team.
• Experience working in Production and Development support.
• The Deployment cycle involved Item Mapping, cut over activities, training the users, helping the pilot divisions go-live, providing post-production support.

TECHNICAL SKILLS

Databases: Oracle Database Version 10g/9i

Languages: SQL,PL SQL

Oracle Applications: E - Business Suite- 11i(11.5.10.2) & R12(12.1.3)

Oracle Apps Modules: GL, AP, AR, FA, CE, Iexpenses, Ebtax, PO,INV and OM

Oracle Tools: SQL*Loader, Toad, SQL Developer, Developer 2000 (Reports Builder), Application Object Library

Operating Systems: HP UNIX, Sun Solaris, Red hat Linux, Windows XP, Windows 7, Windows 8

Other Tools: Kintana & Unix Script SCCS

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

Financial Techno-Functional Consultant

Responsibilities:

• Involving in requirement gathering, analysis and design of the existing and future application for Oracle EBS General Ledger and sub ledger modules.
• Assisting in defining and reviewing the functional requirements for the RICEW objects, for instance, existing interface specifications
• Performing preventive and scheduled maintenance activities pro-actively to ensure high availability.
• Working with the business architect and other planners to assess current capabilities and identify high-level requirements.
• Configured Oracle EBS General Ledger and subledger modules.
• Involving in configuring the GL set of Books for new Companies and performing the unit testing to make sure the customizations works for the new companies.
• Involving in developing a new custom tool for GL Chart of Accounts.
• Working in Markview Upgradation and performed the unit testing.
• Configuring new AP Tax codes and Tax Groups for ITALY Project.
• Involving in developing new custom AP VAT reports for ITALY projects.
• Configuring new banks for Canada Organisation.
• Involving in developing my MY BILLING for AR for Auto receipt process.
• Recommend solutions and document findings.
• Client and business interactions.
• Developing new utility application, workflow, interfaces and support tools using SQL and PL/SQL tools.
• System Testing and Regression Testing.
• Production and UAT support.
• Helping the business in the month end closing process.
• Helping the business to close the periods and open the new periods
• Preparation of user manual and user training materials.

Confidential, Atlanta, GA

Oracle Techno-Financial Functional Consultant

Environment: Oracle Applications 11.5.10.2 & R12.1.3, Reports6i, XML Publisher, Oracle 10g, TOADSQL Developer, PL/SQL, AOL, FTP using WINSCP and PUTTY with Unix environment.

Responsibilities:

• Analyzed which of the components supports in R12 which were not supported.
• Helped the GenOn Financial team in the Post production support in all the financial modules.
• Also involved in Troubleshooting with the issues in Financial Modules while supporting Finance Folks.
• Worked on UNIX shell scripting to customize some existing shell script programs
• Defining Executable, program and adding it to a standard Request group.
• Developed Reports (Sql*plus and Oracle Reports) related PO, AP, OM, INV, AR.
• Created New Reports and registered with Oracle Application.
• Worked on Interfaces for various modules.
• Developed pl/sql, sql Codes for Customizations.
• Worked on Form customization through Personalization and conversions, interfaces.
• Registering the Reports(Sql*Plus & RDF reports).
• Define concurrent programs.
• Developed SQL* Loader for data transfer from flat files to staging table.
• Developed PL/SQL Programs to validate and transfer data from staging tables to base tables.

Confidential, Baltimore, MD

Oracle Techno-Functional Consultant

Environment: Oracle Applications R12.1.3, Reports6i, Discoverer, XML Publisher, Oracle 10g, TOADSQL Developer, PL/SQL, AOL, FTP using WINSCP and PUTTY with Unix environment.

Responsibilities:

• Analyze design, customize, configure and test implement detailed Oracle applications and modules including P2P, AR, AP, GL, Ebtax, CE, PO, etc.; Gather, manage and document functional requirements for technical customization including reports, forms, workflows and scripting;
• Perform system analysis, requirement studies, specifications generation, implementing R12 (12.1.1) and system integrations; Develop creative solutions to support business needs, and help determine opportunities for exercising additional application capabilities;
• Assist with functional configurations, implementations, and production support activities; Perform system configuration required to satisfy requests from end-users for fixes, changes, and enhancements to financial/accounting management functionality. iExpense Setups: Expense Report Templates, Expense Types, Payment Terms, Pay Group, Payment priority
• Validate DFF Setups for iExpense in AP, GL reports and AP reports in prod and other instances
• FA (Fixed Assets): Setups for Asset Category, Location Flex fields and Values, Asset Keys, Additional Fiscal Years, Profile Options, Creating Mass Additions, Posting Mass Additions, Full Asset Retirement Setup, Partial Asset Retirement Setup, Depreciation Setup, etc. and successfully created the Journal Entries, and posted Journal Entries in GL.
• Involved in creating Responsibilities with appropriate menus and functions for specific job roles in GL, AP, AR
• Involved in Regression testing for AR, AP, GL, Pay Terms in AP
• Designed and prepared MD50 for customization of interface to load Journals for Reconciliation.
• Define, analyze, document business and systems user requirements; Configure dimension rules, datasets, balance rules, data sources, loading metadata; Perform data extracts to and from Oracle modules such as GL, FA, AP and AR; Write detailed descriptions of project needs, program functions, and steps required to develop or modify computer programs;
• Design of Accounting Flex Field Structure: Helped in arriving to an appropriate Chart of Accounts structure, which was simple to grasp and yet captured all reporting requirements.
• Implemented AGIS: GL Intra-Company setup: Setup Intra-company Balancing rules, Define balancing API to pick the correct balancing rule, Define Journal Mode(One-to-one, One-to-many, Many-to-many), Define Journal Entry Sources and Categories.
• GL Inter-company setup: Define Inter-company accounts at Legal Entity Level (One-to-one, One-to-many, Many-to-many), Define Inter-company accounts at Balancing Segment Level (One-to-one, One-to-many, Many-to-many), Setup Intercompany Balancing rules, Define balancing API to pick the correct balancing rule, Define Journal Mode(One-to-one, One-to-many, Many-to-many), Define Journal Entry Sources and Categories.
• Security and Cross Validation Rules: Created security and cross validation rules for restricting the use of account code combinations by company and department
• Ebtax Setups: Define Geography Hierarchy Structure, define Tax and Geography Validation, Defining Tax And TCA profile Options, define TCA geography hierarchy, Setting up TCA classification, define tax content services, define tax determination service and analyzing tax requirements. Define Tax Setups (Tax Regime, Taxes, Tax Statuses, Tax Jurisdictions, Tax Recovery Rates, Tax Rates and default tax rules), Define the party tax profile for Legal Entity and Operating Unit and Make tax available for Transactions in AP, AR, PO etc. Define tax accounts and accounting information. Setup lookup codes and tax classification codes, Implemented Ebtax for US as well as Other countries for tax calculations.

Confidential

Oracle Developer

Environment: Oracle Applications 11.5.10.2, Reports6i, Discoverer, XML Publisher, Oracle 9i, TOADPL/SQL, AOL, Kintana.

Responsibilities:

• Analyzed the business processes, requirements, mapped with Oracle features, done the Gap Analysis.
• General Ledger (GL): Did GL Setups Chart of Account Structure, Accounting Flex Field, Cross Validation Rules, Value Sets, Security Rules, SOB, Profile Options, Journal Sources, Consolidation Setups, Calendar.
• Accounts Payable (AP) Functional analysis and setup of AP in 11i (11.5.10.2). Defined Financial and Payable options, Defined descriptive flex fields for additional information for vendors details and invoice transactions and provided solutions for invoice matching. Defined Vendors Banks, sites, quick codes and Interest invoices. Defined payment terms, distribution sets and scheduled payment lines. Set up and schedule recurring payables for invoices paid on a regular basis and automatically remind staff to process recurring payables. Defined prepayments, Expense detail report formats, Invoice structure with taxes, invoice distributions, invoice validations and holds, Recurring Invoices, invoice aging report formats. Set the profile options for AP.
• Account Receivables(AR): Setups for TCA Architecture, DQM, Customer Profiles, System Options, TAX Codes, Sales Tax rates, Transaction Types, Sources, Accounting Rules, Auto Accounting Rules, Auto Invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Collectors, Aging Buckets. Define Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Salespersons, Customer & Sites, Remit to Address, Tax Codes, System profiles etc.
• Cash Management (CE): Cash forecasting & Cash positioning with bank wise details. Define System Parameters, Bank Transaction Codes, Forecast Templates, Bank Statement mapping.
• Fixed Assets (FA): Setups for Asset Category, Location Flex fields and Values, Asset Keys, Additional Fiscal Years, Profile Options, Creating Mass Additions, Posting Mass Additions, Full Asset Retirement Setup, Partial Asset Retirement Setup, Depreciation Setup, etc. and successfully created the Journal Entries, and posted Journal Entries in GL., Define Asset Categories, Location & Key Flexfields,Depreciation Methods, Corporate books, Tax Books, Security By Book feature etc.,
• Defined the Functional specifications for set ups and reports and transformed the specifications to the Technical Team.
• Perform Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution.
• Was responsible for functional setups in a complete Procure-to-Pay cycle for some worldwide instances.
• Maintained the regular interaction with the Client, End users, Technical team, participated in the meetings on regular basis and followed up the progress of work.
• Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR’s on daily basis through Metalink.
• Tested the interfaces, reports, and processes to ensure that all the functionalities are working correctly.
• Worked with the users and businesspersons in designing and defining the new Reports and Customizing the existing Reports.
• Training to super users and users
• Working on production support issues (24x7) for AP, AR, GL and PO.
• Coordinated Set up activities in UAT and Production Environment of all the modules
• Supported the Team as Subject Matter Specialist in Financial Modules and business Process