Professional Summary
Over 15 years of progressive functional and technical software experience in IT and 12+ years in implementing, modifying, production support, upgrading and user training in Oracle 10.7NCA--11.5.7--11.10.2 and R12.0.6./12.1.3 Database 8i-9i ,10G & 11G. Full 10+ life cycle global Implementation and concurrently implementing and supporting the following modules: GL,
Report Manager, AP, Oracle Payments Manager, FA, AR, PO, CE, Discoverer. HRMS/Payroll/OTL, 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, 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.

FUNCTIONAL SKILLS:
General Ledger: Implemented General Ledgers R12/11i. 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 R12/11i, 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 400K on check print for de-supported gift cards.

Cash Management: Implemented Oracle Cash management R12/11i, 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.

Accounts Receivable: Implemented Oracle Accounts Receivables R12/11i, 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 11i, Asset categories, Asset keys, Asset locations, Maintaining calendars, Reports, Supporting FA department on month end closing issues, Depreciation issues, etc.

Oracle Purchasing: Implemented PO R12/11i, 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/SSH: 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

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

Oracle Financial Analyzer (OFA): Develop Reports, Day-to-Day Actual/Budget uploads, Create new custom models, hierarchy’s, Calendars, Share reports, Mappings, express server.

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:

• 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 2007, XP(MS Project ,Word, Excel, PowerPoint, Front Page, Visio).
• Intranet/ Internet websites Development and Maintenance.

Education: BS

Training & Certifications:

Oracle System Administration
Oracle Purchasing
Oracle Workflow
Oracle Developer Forms & Reports

PROFESSIONAL EXPERIENCE

Confidential,
Lead Oracle Techno Functional Analyst May-2009 to Present
Implemented R12 /11i GL, AR, AP, Funds Capture, MOAC, Wells Fargo Receivables Manager , CE , PO and INV in 11i and R12. Multi Sets of books, Multi Operating unit, AGIS/GIS Multi Currency and Inventory. AP XML Check templates, AR XML Invoices, e-text for AP /AR Bank files, BAI Process, Forms personalization, Discoverer Reports. Re-vamped financial models in11i to better match new chart of accounts structure and financial systems as per new business requirements in GL/AP/AR/INV. Discoverer reports. Application support for day-to-day support. Document existing business process, GAP analysis User training and Documentation. BR 30, 100 documents, MD 70’s

• 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.
• 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 training.
• 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/Implemenation. 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 new R12 implementation for GL/AP/AR/CM/INV/AME workflow modules
• Extract data from 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 Dec- 08 – Mar-2009

• 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 Jul-2008 - Dec-2008
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 Technical/Functional AnalystOct 2005 – Jul-2008
Oracle Business Analyst Dec-1999 – Oct- 2005
Working as technical and functional analyst includes support of oracle modules. Main job duties include review Oracle module setups, map and gap effort, support business users, re-align business processes, implement new module functionality in Oracle modules: GL, AP, FA, AR, PO, CM, HRMS/Payroll/OTL/SSH ,expenses, Alerts, SYSADMIN OFA and WebADI. Duties outside of Oracle scope include development and maintenance of internet/intranet sites, 24/7 Production support, ad hoc report developer for all user departments, SOX compliance. Performed GAP analysis based on the requirements. Prepared functional design documents such as BP-80, BP-85, MD-50, CV40, and BR100,. Prepared test scripts, test plan on all above modules for UAT.

Specific Duties:

• 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.