PROFESSIONAL SUMMARY:

• Over 14 years of progressive Oracle Techno functional experience in implementing Oracle applications 10.7NCA - - 11.5.7--11.5.10.2 and R 12.0.6./12.1.3 Database 8i-9i, 10G & 11G. 4 Full life cycles global Implementation and concurrently supporting the following modules: GL, AP, Oracle Payments Manager, FA, AR, PO, CE, Discoverer, Iexpense, OM . HRMS/Payroll/OTL, O2C, P2P, i-expenses, Alerts, OFA ADI/WebADI, XML, AME, Multi Currency, Multi Operating units, Forms Personalization, Vertex, ADP and Ceridian Payroll Process. Very Strong Functional design, Business process, Documentation and performing Setups/Configuration, GAP analysis, Well-versed with Business Analysis, Risk Analysis, AIM Documentation methodology. Experience with client-server architecture, SOA, structured SDLC methodology analytical, problem solving, and troubleshooting skills ability to multi-task, and manage priorities. Proficient in corporate finance/resource planning, design, implementation, technical, and analytical, team player with excellent communication skills.
• General Ledger: Implemented General Ledgers. Setup KFF, Segment values, Cross validation rules, Security Rules Hierarchy’s, Budgets, FSG, P&L Reports, Financial Calendar, Translation, Retained earnings, CTA, Consolidation, ADI, WebADI, Legacy system JE uploads. Actively involved in FSG reports, month end, Quarter end and Year-end closing process and reconciliation general ledger accounts and monitoring clearing account balances.
• Accounts Payables/Payment Module: Implemented Payables and Payments, Defining Payment options, Distribution set. Automate Vendor /Vendor sites, invoice upload process. Monthly closing and reconciliation of accounts, validation accounts, setup and XML Publisher and Evergreen check print . Support accounts payable department on day-to-day basis, Supplier Master, Invoicing/Vouchering, Rapid payment, 1099 process, Check Run Maintenance. Saved more than 500K on check print for de-supported gift cards.
• Cash Management: Implemented Oracle Cash management, Implemented Wellsfargo’s Receivables Manager, Reconciliation, Monthly reports, Maintenance and day-to-day support, BIA files, NSF. Extensively involved in Bank file load, automation process, automation Auto-Reconciliation process of Payables and Receivables in Cash Management.
• Order Management: Including Assessment of Business Requirements, Customer TCA Management, Sales Orders, Pricing, Scheduling, Service Contract Support, Drop Shipments, Intercompany Sales Order/Billing Process, Pick Release, Shipping, Install Base Management, Container Management, EDI Transactions, Interface to Third Party Compliance Systems
• Accounts Receivable: Implemented Oracle Accounts Receivables, Accounting rules, Auto invoice, Maintenance and day-to-day support, TCA, Auto Receipt and apply Process, Lock box and issues, Prepayments, Collections Management, and Cash Applications. Bills Presentment (BPA): XML Custom Invoice Print Design. Inventory ITEMS.
• Fixed Assets: Implemented FA Asset categories, Asset keys, Asset locations, Maintaining calendars, Reports, Supporting FA department on month end closing issues, Depreciation issues, etc.
• Oracle Purchasing: Implemented PO, Drafted the initial design for Global Purchase Agreement functionality in Purchasing. Purchasing setups, iProcurement Setup Payment Terms, PO Lookups, Purchasing Options, Buyers, Financial Options, Transaction Reasons, Receiving Options, Suppliers, Sourcing Rule, XML gateway designer, XML Gateway Responsibility.
• Inventory: Implemented inventory modules, Building the enterprise structure, Creating items, Monitoring inventory on an ongoing basis, Maintaining accurate on-hand balances with real and virtual inventory standard cost, decrement, drop shipment.
• HRMS/Payroll/OTL/I-expenses Setup: Business Group(BG), Compensation Plan, Performance plan, Create update Earning/Deduction elements, Costing, fast formulas, Workflow, Self-service, OTL, Compensation Workbench Vertex, Mass update Assignments, Flexfiles, PTO, Benefits Administration enrollment process, Forms Personalization, Task Flow Nodes/Definitions, Profile options, Form Configuration, Lookups, BEE, FLSA, EEO, Organization, Job, Payroll, PYUPIP, Payroll calendars, Pay method, state/federal minimum wages, Costing, Year end W2 process, ad-hoc report for HR and third party (e.g. BCBS, State new hire-term etc). ADP time saver and payroll process, OTL and Ceridian payroll process
• Iexpenses - Developed expense report templates, expense report processes (AP & OIE), and modified excel templates. Configured key profile options and setups to invoke manager (spending) approval workflow process
• Discoverer: Implement Discoverer/Discoverer plus in terminal server, Developed GL/AP/AR/CM/PO/INV Reports using Standard views, Custom views and Scripts10G/11.1.1.4
• AIM: Used Oracle Implementation Methodology all phases of the Project including Business Requirements Mapping (BR:30/100), Business Requirements Definition, Data Conversion(CV:40) Business System Testing(TE:70), Production Migration(PM: 010,020,050,100,120).
• SYSADMIN: Create/update KFF/DFF’s, Value sets Security Rules, System Profile, Define Concurrent Programs, Create/update Reports, Setup Printers, Functions, Menus,. Responsibilities, Customized Menus, Menu Path Security Oracle Support Diagnostic tool. Create users, Bulk Compile, Gather Schema/Table Statistics.
• E-commerce Gateway: Knowledge of the eCommerce gateway (EDI) Transaction related to AR, AP, PO, and OM

TECHNICAL SKILLS:

TECHNICAL: Experience with Oracle Applications API's, Application Object Library (AOL), Oracle Application Manager (OAM). Oracle applications frame work (OAF), concurrent manager configuration, and underlying table structure of the modules, XML Publisher and express server. Custom tables, interface Programs, Stored Procedures, Functions, Packages & Triggers using SQL*Plus and PL/SQ. XML Publisher and Oracle Discoverer. R12/11i APPS,11G/10G/9i/8i, XML Publisher, Oracle Forms and Reports, Workflow SQL, SQL Plus, SQL Loader. Custome.pll, API s, Forms Personalization and Packages. CM: Perforce, Tortoise SVN. Tools: SQL Navigator, TOAD,SQL loader, UPK, Perl, Dreamweaver MX, Flash MX, Fireworks, Swish. FNDLOAD. Server: Apache/Tomcat Application and Web Server. PUTTY, WinSCP, Cygwin, UNIX, SSH, FTP,SFTP, Windows NT, Microsoft Office.

PROFESSIONAL EXPERIENCE:

Confidential

Sr Lead Oracle Consultant

Responsibilities:

• Setup HR/GL/AP/AR/INV/CE/PO/OM/iexpenses
• Support go-live support and Streamline month-end closing process.
• After go-live support Production support and User .
• Work with cross-functional teams to design and implement business process improvement strategies.
• Provide subject matter expertise in designing optimal & low cost solutions, using core standard Oracle functionality, to avoid future system risks.
• Define/maintain standards, best practices, configuration, compliance, integration standards

Environment: R12.1.1 Oracle Enterprise Linux 5,OM/GL/AP/FA/AR/CM/PO/ INV and HR Workflow, TOAD. Sql loader, PUTTY, Win SCP.DATALOADER.

Confidential

Lead Oracle Techno Functional Analyst

Responsibilities:

• Implement/Setup GL,AP,FA, AR CE, PO and INV in 11i and R12, XML Temple for AP/AR invoices and check print. e-commerce gateway.
• Performed hands-on configuration and setup of the Oracle Financial Accounting Hub (FAH).
• Implemented Wachovia’s Receivables Manager
• Implement/Setup Budget system as per business requirement. Change financial year calendar. Change Account segment values and update all FSG reports, Setup GL consolidation. Translation and Retained earning issues. Report manager, ADI / WebADI Reports and issues. Isetups.
• AR accounting by Salespersons. Update Receipt Classes and new lockboxes. Collection, Dunning Setup and user .
• Processed 46,000 refund checks with FIS related to discontinued “Rapid” product. Duplicate payments audit report. 1099 process. Month-end and year end issues. Setup distribution sets for AP Vendors.
• Automate AR cash process: Oracle API’s for apply and unapply receipts, AR invoice import issues, replace AR accounting structure. XML publisher for AR invoices print. Create Credit pay method.
• Allocation procedures for corporate overheads, project costs, and production & fulfillment costs have been designed, tested and/or implemented.
• Eliminated excel-based consolidation process and more recently integrated new companies into the Oracle consolidated financial statements
• Automated employee and payables process from third-party Advocate for employee/contractor wireless bill.
• Leading the 11i Support/Development and R12 Design/Development/Implementation. Support 11i users for application set-ups, functional definition and design, coordinating problem resolution and identifying and coordinating inefficient programs, forms and reports.
• Automate daily GL rates from OANDA Design/Development/Testing.
• Extensively used FNDLOAD utility for migrating the concurrent programs, value sets, functions, menus, DFF’s, KFF’s, Lookups, responsibilities etc from one environment to another
• Created BRD and BR100s for R12 implementation GL/AP/AR/CM/INV/AME workflow modules
• 11i for R12 Migration.

Environment: 11i.5.10.2 and R12.1.3, Oracle Enterprise Linux 5, GL/AP/FA/AR/CM/EDI/XML/ INV/ Oracle discoverer/AME, TOAD. Sql loader, PUTTY, Win SCP.DATALOADER.

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Provide Oracle Application support in the following modules: HRMS, Self Service, PTO, Performance management, Compensation Workbench, Oracle Time and labor, Ceridian Payroll.
• Test scripts for UAT. Sarbanes-Oxley compliance and Systems Life Cycle Methodology.
• Design and develop custom reports using SQL, Forms and Reports 6i.
• Work with end users and functional analysts to perform unit testing, migrating code changes to Production.

Environment: 11i, Oracle Enterprise Linux 4, HRMS, TOAD Self Service, Performance management, Compensation Workbench, OTL, Discoverer, Tortoise SVN.

Confidential

Sr Oracle Techno Functional Analyst

Responsibilities:

• Install R12, Implement/Setup GL, AP and limited HR/PO/INV and E-commerce gateway with IBM team. Post production support 24/7 and data migration. Analysis with end users to identify current operating procedures, outline required changes and carry out tasks to implement changes. Follow appropriate change management and implementation procedures
• Flow diagrams, Functional requirements specification/documentation & gap solutions as per Oracle AIM advantage, Performed GAP analysis based on the Client’s requirements. Prepared functional design documents such as BP-80, BP-85, MD-50, CV40, and BR100.Designed process flowcharts using Microsoft Visio.

Environment: R12.0.5, 10g database, Oracle Enterprise Linux 5, Oracle SYSADMIN, GL, AP, ecommerce gateway, EDI Transmissions, AIM 3.1.0, MS Visio. SQL Developer, Cygwin.

Confidential

Senior Oracle Techno/Functional Analyst

Responsibilities:

• Technical and Functional resource for multiple upgrades of Oracle Applications (10.7 to 11.5.7 to 11.5.10.2) e-Business Suite. EOY/ Quarterly/Monthly/Mandatory patches. Custom Time clocks, Year send W2 process, Payroll costing, Only resource for outsourcing ADP: Time-Saver, Payroll Check Printing, Payroll Tax and Garnishment Process.
• Develop PL/SQL programs for data loads and reports.
• In-house developed Revenue Management System, In-house developed legacy system for system for Invoice process, Journal entry system and WebADI.
• Utilize SAS and SQL loader for data uploads.
• Function as the General Ledger Super user with setup responsibilities, as well as defining and creating FSG reports used for SEC reporting.
• Integrated Vertex Q series for Oracle Payroll, Set up Vertex software to support Payroll tax.
• Sarbanes-Oxley compliance and Systems Life Cycle Methodology

Environment: Oracle HR/Payroll/OCW/ Payroll/OTL/SSH, SYSADMIN, GL, AP, FA, Alerts, PO, Cash management, OFA 6.3.2 and WebADI, SAS,SQL, Custom and Oracle API’s, SQL Loader, Perforce, Unix, SQL, Perl, Tomcat, Apache server, Oracle express Server, FrontPage, Dreamweaver MX, Macromedia MX, Fireworks MX, Swish.