sample resume OF

SUMMARY:

· Over 7 years of IT experience with more than 6 years of experience in Oracle Applications - Performing functional and technical work within the Financial, Manufacturing, and Self-Service modules of Oracle Applications (Oracle Financials/Oracle E-Business Suite (EBS) for Enterprise Resource Planning (ERP)).

· Experience in implementation, localization, enhancement, customization and production support for Application modules including Oracle Advance Pricing, Order Management, Oracle Inventory, General Ledger, Accounts Receivable, Accounts Payable, Purchasing, and Cash Management.

· Full life cycle experience in implementation of Order Management and Advanced Pricing including hands on configuration of these applications.

· Two full life cycle implementation of General Ledger, Accounts Receivable, Accounts Payable, Cash Management, including hands on configuration of these applications.

· Experience in customization and testing of Oracle Financials 11i with Multi-Org and Multi Reporting Currency (MRC).

· Experience in supporting/enhancing the Oracle E-Business Suite, Release 11i for both Oracle Financials, OM & Advance pricing.

· Providing application requirements gathering, designing, development, functional and technical documentation, and debugging.

· Assisting team members in defining Cleansing, Aggregating, and other Transformation rules.

· Working knowledge of Application Implementation Methodology (AIM) templates.

· Performed business process mapping, Gap analysis and user training.

· Able to interact effectively with other members of the Business Engineering, Quality Assurance, Users and other teams involved with the System Development Life cycle.

· Working with business users & process owners, helped them define system profiles, responsibilities and technical requirements.

· Knowledge of financial accounting and financial business processes, not limited to, but including: basic financial accounting process through financial closing; revenue and expense cash/accrual concepts; adjustments and financial statements

· Strong problem solving and analytical skills with good written and verbal communication skills.

TOOLS:

· Application - Oracle Application release 11.0.3, 11.5.8, 11.5.9, 11.5.10

(OM, Advance Pricing, AR, GL, AP, PO, INV, CM).

· Self Service Apps - iExpense, iReceivables

· Operating System - Unix/Windows

· Language - SQL, PL/SQL

· Front End - Developer 2000 (Forms 6i, Reports 6i), Discoverer

· Other Tools - Toad, FTP-CRT and Absolute FTP, SQL Loader

· Database - Oracle 8i/9, Microsoft Access

· Documentation tools - MS Office

hyui Aug 2007 to till date

Role: Oracle Financial Functional Consultant

Apps Modules: General Ledger, Purchasing, Order Management, Advance Pricing (Blood Pricing)

The American Red Cross maintains a complex information technology (IT) and communications infrastructure that supports the organization’s lines of service and corporate business systems. Project included Implementation of Advanced Pricing, Enhancement of Oracle Financials.

Order Management Responsibility

· Carrying out requirement gathering, module configuration, solution design, and process analysis of Advance Pricing.

· Resolved functional issues related to importing Sales Orders, incorrect pricing of the lines and the Configuration issues

· Customized Sales Order Header and Sales Order Line Workflows in Order Management based on the understanding and Analysis of the Existing Business process

· Worked closely with the development team on all application enhancement requests and bug fixes

· Worked on implementation issues and, if required opened a TAR with Oracle for critical issues

· Coordinated with Oracle Support on various TARs on a daily basis through Metalink

Advanced Pricing Responsibility:

· Carrying out requirement gathering, module configuration, solution design, and process analysis of Advance Pricing.

· Developed Functional Design Documents (MD.050) using the Oracle AIM Methodology.

· Involved in the Conference Room Pilot (CRP) to install, evaluate, configure the functionality of the applications, identified gaps, determined solutions and tested modifications

· Created Advanced Pricing, modifiers & qualifiers for overrides and discounts.

· Designed & Tested process flow manual orders, returns.

· Defined release rules to pick release for diff. orgs.

· Designed & documented process flow to close daily, weekly billing cycles.

· Created new agreement pricelists, pricing formulas, modifiers for price discounts, overrides & surcharges.

· Created Customer, Order Qty, Order type and various complex qualifiers.

· Created automatic surcharge, agreements & discount modifiers.

· Created Primary & Secondary Pricelists for each agreement.

General Ledger Responsibility:

· Carrying out requirement gathering, module configuration, solution design, and process analysis of Blood Pricing.

· Involvement in Budgeting exercise of the company, including preparation and phasing of budget.

· Creating the ARC Budget for fiscal year 2008 using Oracle GL Budgeting.

· Corrected misclassified accounts in GL.

· Worked on development of new FSG reports and customized various standard FSG reports.

· Developed ad-hoc journal reports using FSG as well as standard General Ledger reports and Oracle Payables reports such as Trial Balance, Payment Register and Invoice Register.

· Studying the current accounting structure and suggesting changes to improve financial reporting and analysis.

· Developed and implemented new workflows from scratch using workflow builde

·

Int Baltimore, MD Aug 2005 to Aug 2007

Role: Oracle Financial Functional Consultant

Apps Modules: General Ledger, Accounts Receivable, Accounts Payable, Cash Management, Fixed Assets.

Int is a global provider of professional technical and management support services to a broad range of markets, including transportation, facilities and environmental. The aim of the project is to rollout Oracle Applications 11.5.9 and retire the various legacy systems used across the company. The project implementation consisted of implementing Financials Modules of Oracle Applications.

Responsibilities:

· Carried out module configuration, solution design, process analysis, and implementation of Oracle Financials General Ledger, Accounts Receivable, and Accounts Payable including setups stated below.

· Responsible for the documentation (BP.080 -Future Process Model, BR.030 -Business Requirements Mapping, BR.100 -Application Setup and TE.040 -System Test Script) and setups of the General Ledger, Accounts Receivable, and Cash Management Modules.

· Business communications for the system updates and meeting the deadlines for the implementation.

· Leading an eight member team, building their skills and facilitating their development.

· Supervised the period close and quarter close processes by ensuring that all financial transactions have been accounted for accurately and on a timely basis in Oracle GL.

· Developed Custom reports, Standard Interfaces, Custom Interfaces linked to different modules of Oracle Applications from third party.

· Supported the implemented Receivable and Payables modules which involved daily issues and new customizations and enhancements based on the changing requirements in the system.

· Created an interface to load Prime Vendors as Customers, match Vendor Invoices to Credit Memos from Accounts Payable, AP, to Accounts Receivable, AR, to reduce vendor payments in AP and generate Customer Invoices to vendors in AR to interface with GetPaid.

· Created Auto Invoicing and Auto lockbox (Source of Auto Invoice was Project Billing) processes.

· Took active participation in SOX compliance.

· Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies, Set of Books, Assigning Set of Books to a Responsibility, Setting up Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, Defining Financial Statement Generator, Creating Ad-hoc Reports, and Open and Close Accounting Periods.

· Set-up Oracle Receivables and Oracle Payables including System Options.

· Defined Payment Terms, Accounting Rules, Accounting Periods, Invoice Sources, Bank Information, Receivables Quick Codes, Auto Invoice Grouping Rules, Transaction Types, Sales Tax Location Flexfield, Tax Codes and Rates, Customer Profile Classes, Customers, Customer Banks, Lock Boxes, UOM.

· Defined Invoice attributes- Payment Terms, Approve, Hold & Release and Distribution Set, Special Calendar for Recurring Invoice, Payment Terms and Payable Quick Codes, Entering Supplier and Site Information, Payment Attributes- Payment Formats, Bank Account, Payable Documents, Tax Code, Rates, Groups and Withholding Tax, Open/Close of payable Accounting periods, and Payable Transfer to GL

·

· stt & Gas, MA Sep 2004 to Jul 2005

Role: Oracle Financial Functional Consultant

Apps Modules- General Ledger, Accounts Receivable, Accounts Payable, and Cash Management

STt is the largest Massachusetts-based investor-owned electric and gas utility, with headquartered in Boston, Massachusetts. It provides regulated electric and gas utility services and is also engaged in telecommunications and other non-regulated activities. Scope of Project included implementation of Oracle Financials 11i.

Responsibilities:

· Carried out implementation of Oracle Financials (GL, AP, and AR) across the organization.

· Studying the requirements, performing risk analysis and mapping the business processes.

· Analyzing the gaps and recommending the necessary customizations.

· Configuring the modules, designing reports and add-ons and coordinating with the technical team to monitor development and implementation progress.

· Facilitating end-user training and developing the various user manuals.

· Created general settings and completed specific configuration related to Company Code, Bank transaction codes, Bank accounts and bank reconciliations.

· Matched the AP Invoices (2-way) & (3-way) to the Purchase Order in Payable modules.

· Initiated rewrite of requisition and PO encumbrance code to take advantage of improved funds check functionality in Oracle General Ledger.

· Ran the payable open interface import program to create invoices automatically in payable module.

· Made basic implementation decisions involved in launching the Procure-to-Pay process.

· Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable AR in Oracle cash management modules.

· Integrated invoices and payments data from AP/AR to General Ledger.

· Providing production support for approving and correcting Accounting entries from Payables to cover receipt accruals, invoice distributions (expense, inventory and work in process), payables liability & disbursements as well as from Receivables to cover receivables, receipts, and invoice distributions (revenue, unbilled receivables, unearned revenue, tax, and freight).

· Developed ad-hoc journal reports using FSG as well as standard General Ledger reports and Oracle Payables reports such as Trial Balance, Payment Register and Invoice Register.

mnopo, Boston, MA Jan 2003 to Jul 2004

Job Role: Oracle Functional Consultant

Apps Modules- General Ledger, Accounts Receivable, Inventory, Order Management, and Advanced Pricing

mnop is a world leader in developing surgical instruments and innovative devices and products for use in neurosurgery, reconstructive surgery, general surgery, soft tissue repairs. The company uses Oracle Financials, Manufacturing and Distribution with operations in USA, EMEA and Asia Pacific. Project included Implementation and Enhancement of Oracle Advanced Pricing, Order Management, Accounts Receivable, and Inventory Pricing and also creation of the global Oracle Application support center based in Boston USA.

Responsibilities:

· Implemented Oracle Financials 11i General Ledger, Accounts Receivable, and Oracle Order Management, and Cash Management

· Studying the complete Business Process Flows, Descriptive Flex fields, Form & Other Customizations (like custom tables), Custom Reports in Oracle 11i, Areas like workflow and business customizations in the standard workflows.

· Analyzed the detailed business requirements and mapped them to General Ledger.

· Implemented Cash Management for AR Cash Receipts and AP Payments reconciliation.

· Create Auto Invoice and Auto Lockbox processes.

· Created clearing and reconciling bank statement with Payables and Receivables.

Order Management Responsibility:

· Consulting on a project to move GSI's customer product install base and service contracts from an Onyx legacy system into Oracle Applications.

· Designing a complete re-architecture of inventory items and bill of materials (BOM) to support all product and service sales, billing, and renewal from the Oracle system.

· New processes in Order Management (OM) so customer licensed software ends up in the Installed Base (CSI) and Maintenance ends up in Service Contracts (OKS/OKC).

· Documenting business requirements; Data design and process re-engineering to fit with the Oracle system; Prototype new business processes; Design legacy data conversion; Configure applications; Create test scenarios.

· Gather requirements, write functional (MD050) and technical (MD070) specifications, provide recommendations for user challenges, and implement process and system modifications. (Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using AIM guidelines.

Advance Pricing Responsibility

· Carried out configuration, solution design, process analysis, and implementation of new pricing formula, price lists, contract pricing, and freight rules.

· Created pricing formula for Spinal Specialties freight charges.

· Created contract pricing formula, modifier, and qualifier for GPO customers.

· Created new formula to charge flat $20 freight charge.

· Created new pricelists, attached specified items to pricelist & attached the pricelists to transaction type.

· Designed new pricing formula, modifier to handle back order charges.

· Defined new rule for Hazmat pricing & defied new flex field to identify hazmat items.

· Changed pricing formula to charge new up charge.

· Created & designed rules for NSI items, defined new pricing formula & modifier & qualifiers.

· Created pricing formula, Qualifiers for shipment channels.

· Documented all pricing changes & met all reporting requirements.

· Setting up Oracle Receivables including System Options and Receivables Options.

· Defining Payment Terms, Invoice Sources, Bank Information, Receivables Quick Codes, Auto Invoice Grouping Rules, Transaction Types, Sales Tax Location Flexfield, Customer Profile Classes, Customers, Customer Banks.

· Created training documents for creating receipts by defining bank, receipt class, receipt source, and Auto Cash rule set.

XYZ Ltd, Pune, India Jul 2001 to Dec 2002

Apps Modules: General Ledger, Accounts Receivable, Accounts Payable, Account Hierarchy Editor (AHE), Financial Statement Generator (FSG).

Responsibilities:

· GL Audit Schedules, Alerts (Event / Periodic) got developed through Oracle Financials for Exceptions reporting.

· Month end and Year end reconciliations for closure of subsidiary modules – AR and AP.

· Period closure procedures for Oracle GL, AR and AP modules.

· 11i Migration Testing - GL purification done, Prepared Migration functional UAT plans and tested for GL, AR, AP modules.

· Setting Accounting flexfields, Defining Journal Sources, Journal categories, Document Sequences and their assignment, Chart of Accounts maintenance. Lead User role involved performing whole GL accounting cycle, AR and AP transactions accounting and support.

· Financial reporting –Oracle Standard reports (GL) developed using Financial Statement Generator (FSG), Account Analysis reports development , Trial balance reports development . Generation and analysis of Consolidation reports like Consolidation Exception reports, Journals report, Consolidation rules report, Summary Trial balance reports, etc.

EDUCATION:

Bachelor of Engineering, Madras University, Chennai, India