MATHEW VARGHESE

* **** **

Syosset, New York ****1

Phone 516-***-**** (home)

516-***-**** (cell)

Email: adi5qx@r.postjobfree.com

SUMMARY

Hands on experience in Oracle ERP Application implementation, custom development and techno functional production support.

SKILLS HIGHLIGHT

Database:

Oracle Database Administration (7.x, 8.x, 9i, 10g, 11g), MYSQL, MS Access Oracle ERP Applications (versions 10.7SC, 11.0.3, 11i and R12): Oracle Financials (Commercial and Encumbrance Accounting), Manufacturing applications and Human Capital Management

System Administration, Application Object Library, AD utility, Oracle General Ledger, Sub Ledger Accounting, Oracle Payables, Payment Manager, Cash Management, Oracle Purchasing, iprocurement, Assets, Oracle Grants, Project Accounting, Oracle Order Entry, Oracle Project Contracts, Oracle Project Billing, Oracle Bills of Materials, Oracle Time and Labor, Oracle Inventory, Oracle Work in Progress, Oracle quality, Oracle Receivables, Core HR Applications, Oracle Benefits, Oracle Payroll Oracle Fusion Cloud Financial Applications (SaaS and PaaS): General Ledger (General Accounting) Fusion Accounting Hub (FAH), Payables, Receivables, Cash Management, Fixed Assets, Procurement, Fusion Tax, Functional setup Manager, IT security Manager, oracle Fusion Integration (ADFDI, FBDI, SOAP, BI Publisher), Oracle Fusion Financial reporting (Oracle Transactional Business Intelligence (OTBI), BI Publisher, FRS, Smart View, Account Inspector and Account Monitor).

Development Languages and Tools:

SQL, PL/SQL, HTML, XHTML, CSS, php, JavaScript, SSI, XML (SAX, DOM, XSLT, Xpath, XQuery, XSL, SOAP, WSDL, java servlet), J2EE, SOA 10g, SOA 12c, BPEL, Python, Developer 2000 (Forms 4.5, 6i, 9i, 10g), Reports 2.5, 6i, 9i, 10g), SQL*Plus, SQL*Loader, TOAD, Oracle Discoverer (4.0, 9i, 10g), XML Publisher, BI Publisher, JDeveloper, ADI, web ADI, 11g OBIEE Administrator, 11g OBIEE Analytics, Oracle Data Integrator

(ODI), Financial Analyzer 6.2, Warehouse Builder 3i, Workflow 2.6, Enterprise Manager, XML gateway, Oracle portal development, MS Access, MS Visio, Erwin, AIMS. Operating Systems: Sun Solaris 2.5, RS6000-AIX UNIX, HP UNIX, Windows 95, Windows NT 4.0, Windows XP, Windows 7, Windows 10 WORK EXPERIENCE

Pearson May-19 to Present

221 River St, Hoboken, NJ 07030

Oracle Project Accounting Application Solutions Manager

Work with offshore team to fix the program for the interfaces and extensions errors from the implementation.

Work with interface team to reprocess the day to day interface errors, data synchronization update failure and data processing error.

Work with business to deliver their day today data processing need and gather requirements for any program extension or enhancement.

Work with business to reconcile the data integration with third party application and other internal applications processed data.

Work with other internal stake holders like HR, OTL, PO, AP, AR and GL to resolve inter module related data processing errors.

Work with business to close month end period for UK set of Books, US set of books, AU set of books and CA set of books and resolve any error in the month end closings. State Street – Global Link 04/2017 to 05/19

1290 Avenue of America, New York, NY 10104

Senior EBS Techno - Functional Consultant (Vice President) – EBS and Billing Applications.

Developed billing fee calculation program based on the contract and loaded the customer fee to the order entry application and created orders, then transferred to AR application and created invoices for customers.

Provided user support for their day to day billing process, daily revenue estimation, ETL extraction and transferred data to the Reporting database.

Developed reports using XML publisher and registered with oracle EBS application.

Developed Programs using PL/SQL to extract trade data on monthly and daily basis, registered as a concurrent program and scheduled in oracle for daily and monthly billing process. Global Application Technology Inc. 09/2014 to 02/2017 Client: City of Yonkers, Yonkers, 87 Nepperhan Ave, Yonkers, NY 10701 Techno-Functional Lead Consultant

Worked with Yonkers MIS team and users to analyze business requirements, design and develop solutions for Oracle Financials Application (Oracle Grant Accounting, Oracle Projects, Oracle Inventory, Oracle Purchasing, Oracle Payables and Oracle General Ledger).

Modified and customized inbound and outbound interfaces. All new custom programs registered with Oracle applications as concurrent programs and assigned to appropriate responsibilities.

Developed reports needed for annual audit, state audit and FOIL requirement

Developed over 25 BI publisher reports for daily user requirement besides audit requirement from GL, AP, PO, projects and Grant modules.

Installed and configured OBIEE 11g reporting tools and created Analytical reports for different user group.

Created OBIEE reports based on business requirement, created different dash boards and assigned those reports to different business group and implemented proper security.

Supported Yonkers Board of Education users and City of Yonkers users for their day to day business data processing techno functional need in a multi-org application environment.

Modified ACH BI publisher template program for JP Morgan & Chase Bank and registered with xml publisher administrator. Completed payment format registration and payment profile setup with Payment Manager. Created organizational specific payment templates for users to use in their ACH Payment processing.

Prepared MD-50 Functional design document, MD-70 Technical design document and TE-120 UAT test document.

Tested ACH file with the bank, conducted UAT test and trained users to run and transmit ACH file to the bank.

Environment/Tools: Oracle Financials R12, Oracle 11g, Forms 10g, Reports 10g, OBIEE 11g, BI publisher, Web ADI, AIMS, Visio, IBM AIX UNIX, TOAD

Telephonics Corporation 04/2012 to 08/2014

815 Broad Hollow Rd, Farmingdale, NY 11735

Principal Business Analyst (Technical Lead) – Oracle ERP R-12 Application

Worked with implementation team to analyze business requirements, designed and developed solutions for Oracle Financials and Manufacturing applications (Oracle Order Entry, Oracle Project Contracts, Oracle Projects, Oracle Project Billing, Oracle Bills of Materials, Oracle Inventory, Oracle Work in Progress, Oracle quality, Oracle Purchasing, Oracle Receivables, Oracle Payables, Oracle General Ledger).

Prepared MD-050, MD-070 and TE -120 documents for all customizations, interfaces and XML publisher reports. All programs are registered with Oracle applications as concurrent programs and assigned to appropriate responsibilities.

Positive pay standard template layout file modified based on the banks specification and evaluated the extracted file with the bank.

Modified ACH template based on the banks specification and tested sample file with the bank.

Designed and developed cost of sale extension to realize the cost based on the percentage of completion.

Designed and developed interface program using API to mass update the asset details in oracle asset application based on scanning detail.

Developed interface program to load and create times details in OTL application.

Developed PL/SQL program to extract data for analytical applications like Hyperion and Cognos

Developed BI publisher reports and OBIEE reports based on the business requirements. Environment/Tools: Oracle Financials and Oracle Manufacturing R12, Oracle 11g, Forms 10g, Reports 10g, OBIEE 10g, BI publisher, Web ADI, Data Load, AIMS, Visio, AIX Unix, TOAD Curtiss Wright Flow Control – Target Rock 11/2010 to 04/2012 1966D Broadhollow Rd, Farmingdale, NY 11735

Oracle Application Sr. Business Analyst

Supported Business Users in their day to day functional and technical requirements for the Oracle Manufacturing and Financial Applications ( Oracle Order Entry, Oracle Project Accounting, Oracle Bills of Materials, Oracle Inventory, Oracle Engineering, Oracle Work in Progress, Oracle Quality Control, Oracle Purchasing, Oracle Receivables, Oracle Payables, Oracle General Ledger)

Developed new programs and reports to meet the business requirements using SQL, PL/SQL, oracle developer and XML Publisher technologies.

Prepared application upgrade plan and lead the R12 upgrade project.

Modified and tested custom reports and forms registered with 11i application for R12 upgrade.

Upgraded 4i Discoverer report to 10g Discover report, tested the reports and trained users to use the 10g report in R12 application.

Environment/Tools: Oracle Financials and Oracle Manufacturing R12, Oracle 11g, Forms 10g, Reports 10g, Discoverer 10g, BI publisher,Web ADI, Data Load, AIMS, Visio, Linux, TOAD. Broadridge Financial Solutions Inc. 04/2007 to 10/2010 51 Mercedes Way, Brentwood, NY 11717

Sr. ERP Software Engineer

Analyzed all custom programs, concurrent registration and modified environment related value in the programs for the newly cloned Broadridge ERP instance from the ADP ERP application.

Completed technical analysis and prepared functional and technical document for Oracle AR data migration from mainframe applications.

Converted Concur expense system to Oracle ERP iExpense module and prepared ACH (EFT) files for Banks.

Prepared positive pay report for Banks against the issue of checks.

Analyzed business flow, prepared functional and technical document and programs for sales order imports.

Environment/Tools: Oracle Financials 11i, Oracle 10g, Forms 6i, Reports 6i, Designer 6i, Discoverer, ADI, Data Load, AIMS, Visio, Unix (HP), Windows NT, TOAD. Oracle Corporation 11/2000 – 01/2002 and 01/2006 to 04/07 Financial Application Technical Architect Designer (Principal Consultant) Clients – (City of Chicago, Chicago and Department of Transportation, Oklahoma City, United states Marine Corps)

Completed technical system analysis for United States Marine Corps ERP implementation project

(block 1), designed the system flow, identified the conversion objects and estimated the cost of implementation for 22 licensed products from Financial Management, supply chain Management, CRM and Warehouse Management product family.

Identified the common data conversion objects from all applications and completed bottom up analysis for cost estimation.

Configured and customized E-business suite XML gateway applications to transfer data from one instance to another instance and integrated with SOA 10g - BPEL process.

Worked on SOA- 10g - BPEL to customize and automate the data extraction, transfer and creation of entries form one instance to another.

Developed customer data conversion program and converted sample data using SOA 10g – BPEL as POC for the project.

Designed and developed data conversion program using SQL*Loader and PL/SQL program to convert legacy system data to Oracle Financials (GL, AP, AR, FA, PO, TCA)

Developed inbound and outbound interface programs using SQL*Loader and PL/SQL Programs for interface development requirements.

Developed custom reports using xml publisher, registered with Oracle financial Application and assigned to the different responsibilities in multi-org environment.

Prepared test plan, unit test script, implementation plan and user documents to the programs developed for conversion, interface and custom developments. Environment/Tools: Oracle Financials 11i, Oracle 8i, Forms 6i, Reports 6i, SOA 10g –BPEL, Oracle Designer 6i, Discoverer, ADI, Data Load, AIMS, Visio, Unix (HP), Windows NT, TOAD., BPEL 10.1.2. New York City Housing Development Corporation, 110 William Street, New York, NY 10038

Oracle Financial Application Developer/DBA 10/04 - 01/06

Modified email notification setup using Oracle Application Manager for sending notifications to the approvers after the creation of PO and PO Requisitions for approval.

Applied over 50 patches in the production application to stabilize and correct the error getting after the upgrade from Oracle Financials 11.0.3 to Oracle Financials 11.5.9.

Ran AD utilities (autoconfig) to configure the application setup and environment files; manually configured http, java and other configuration files to fit our system configurations.

Maintained database, ran database backup and refresh test database with production backup copy.

Worked on AR application restructuring project to correct the error in implementation:- o Analyzed existing Oracle AR data processing and prepared document with implementation error and presented the Upper Management. o Prepared proposed data processing method and dataflow diagram to fit our business need (use both cash basis and accrual accounting method in single set of books) with AR application and presented the proposal to the upper Management. o Worked on custom PL/SQL programming to manipulate the data to fit the business need after the approval of upper Management.

Supported users in their day to day system related requirement in Oracle Financials (AR, AP, GL, and PO) and other custom applications.

Developed PL/SQL programs, reports and forms to meet additional requirements and change in requirement to advance functionality of business.

Environment/Tools: Oracle Financials 11i, Oracle 9i, Forms 6i, Reports 6i, Designer 6i, Discoverer 4i, Crystal Report, ADI, Visio, Windows XP, TOAD.

Liberty Travels, Mahwa, NJ 09/03 – 09/04

Sr. ERP Application Developer

Involved in inbound interface development to upload internal and external data to the ERP Applications (GL, AP, AR, PA, and HRMS) and developed outbound extraction programs to issue data files to the vendors and other internal applications.

Involved in developing reports using Oracle 6i, Discoverer 4i and ADI tools.

Developed custom forms using Developer 6i tools and registered in the Oracle Applications.

Provided post implementation user support and development to GL, AP and PA modules. Environment/Tools: Oracle Financials 11i, Oracle 9i, Forms 6i, Reports 6i, Designer 6i, Discoverer 4i, ADI, Data Load, AIMS, Visio, Unix, Windows XP, TOAD.

Abacus Concepts Inc. 01/03 – 8/03

Consultant

Involved in developing oracle reports 6i from custom SQL*Report to upgrade Oracle Financial applications 10.7(GL, AP, AR, FA, PA) to 11i and prepare functional, technical and user documents for the clients.

Cap Gemini Ernst & Young 6/2002 – 11/2002

Consultant

Worked with implementation team to analyze, map and document the legacy data structure to Oracle HRMS applications (HR, Payroll and Benefits)

Trained and guided mainframe programmers to analyze, document and develop oracle interface programs.

Developed interface programs and conversion programs using SQL*Loader and PL/SQL, registered as concurrent programs with AOL and assigned to the appropriate responsibility. Environment/Tools: Oracle Financials 11i, Oracle 8i, Forms 6i, Reports 6i, Visio, UNIX (RS-6000 AIX), Windows NT, TOAD.

Lechters Inc 11/99 – 10/2000

Sr. Programmer /Analyst

Maintained entire Oracle Financials 11.0.3 (GL, AP, FA, Oracle Purchasing, Oracle Projects) Applications and supported users to resolve their technical problems.

Developed and modified forms, reports, inbound and outbound interface programs for the changing business need.

Supported users in tax preparation, compiling Flex field definitions, updating and modifying application setups, extracting data from Oracle Applications and loading data into Oracle Application.

Worked closely with DBA to resolve temporary space problems, applying patches to the applications and other database related problems.

Developed reports, journal templates using ADI and trained users to use ADI to prepare journals and developing reports.

Developed reports using Oracle Discoverer.

Environment/Tools: Oracle Financials 11.03, Oracle Express, JDA, Oracle 8.05, Forms 4.5, Reports 2.5, ADI, Oracle Discoverer, Unix (RS-6000 AIX), AS 400, Windows NT, TOAD, Peoplesoft HRMS 7.5. RCG Information Technology 7/99 – 10/99

Consultant

Worked on an Oracle Application upgrade project for converting custom SQL*Report (rpt) to report 2.5.

Registered converted reports to the Application object Library and assigned to the appropriate responsibility.

Provided technical guidance to other team members for the report conversion and concurrent registration

Environment/Tools: Oracle Financials 10.7 SC, Oracle 7.3, Forms 4.5, Reports 2.5, UNIX (HP), Windows NT, TOAD

Burlington Coat Factory 5/98 – 7/99

Mid to senior Programmer/Analyst

Worked on a conversion project to migrate oracle applications from 10.6 SC (GL, AP, AR, FA, and PO) to 11.0.3. Converted over 25 custom developed SQL* Report (rpt) to report 2.5, registered custom reports to the Application object Library and attached them to the report group through System Administration.

Customized 1099 Form and Tape for business need, and 1099 Tape electronically transmitted to the IRS.

Prepared Y2K functional test plan and tested entire functionality of entire GL and Fixed assets modules.

Created tables, views, indexes, PL/SQL Packages and SQL*Loader Programs

Developed reports using GLDI and trained users how to use GLDI in daily data entry process to enhance their performance.

Environment/Tools: Oracle Financials 10.7, Oracle 7.3, Forms 4.5, Reports 2.5, Designer 2000, GLDI, Unix

(Sun Solaris), Windows NT, TOAD

Syntectic software 10/97 – 1/98

Consultant

Modified the General Ledger interface programs to import the data into Oracle Financials using SQL*Loader and PL/SQL program from legacy system.

Designed and developed the system requirement for Membership Tracking System with ER diagrams using ERWin 2.5.

Developed prototypes using Oracle Forms 4.5 and Reports 2.5 for front-end development Cushman & Wakefield (client - Chase Bank) 8/96 – 9/97 Project Administrator/Programmer

Designed and developed relational database for capturing Accounting and Budget details for all transaction relating to construction in Chase all over the world.

Designed the database and normalized objects using ERwin Tools.

Developed and customized input form to update database.

Imported data from Excel and other database to the Facilities Management Database.

Prepared analytical report for capital construction projects to give status, budget and its variance.

Accountant & Auditors (client - JP Morgan – Security Administration) 3/96 – 6/96 Consultant

Processed daily security transactions, reconciled custody service loan accounts and resolved related problems

Prepared quarterly loan portfolio reports and analyzed each loan pool's participation in the portfolio.

Chemical Bank (Chemical Bank – Global Banking) 3/92 – 2/96 Consultant

Prepared entries for Derivatives and Money Market daily transactions reconciled Broker's accounts with General Ledger broker's commission accounts and processed for payment. EDUCATION

MS (Business Communications and Accountancy) - 1985 Sri Venkateswara University, Tirupati, India

MBA (Finance) - 1987

Sambalpur University, Sambalpur, India

Certificate in Relational Database Management Systems (28 graduate credit diploma course) -1996 Columbia University, New York, NY.

Courses: SQL, PL/SQL, Database Specification & Design, Oracle Tools (Forms 4.5, Reports 2.5), Oracle Server Technology, Visual Basic 4.0, Oracle Application Development Lab, Oracle Database Administration( 7.3, 8i and 9i), Data warehousing, Unix Administration, Oracle Discoverer, Advanced Database Administration (8i).

Oracle Education

Courses: Oracle Financials 10.7 - General Ledger, Oracle Financial Analyzer for Administrators, R11i Extend Oracle Applications: Forms, 11i Implement and Use Purchasing, 11i Implement and Use of Accounts Payables, Advanced PL/SQL, Oracle iDS Implement Warehouse Builder, Oracle Workflow 2.6, Oracle Discoverer Administration (9i), Oracle Discoverer User (9i), Java Programming, Oracle Portal Development, Oracle BPEL Process Manager: Service Orchestration, 11i installation, maintenance and patching (application DBA course), OracleAS 10g R3 Build J2EE Applications – 1. Apps2Fusion.

Oracle Fusion Functional Training (SaaS)

Oracle Fusion Financial Training (Release 13): General Ledger, Accounts Payables, Accounts Receivables, Cash Management, Fixed Assets.

Fusion Accounting Hub Training (Release 9)

Fusion Tax Training V1.0

Oracle Fusion Technical Training (PaaS)

Oracle Fusion Integration Training

Fusion Financials Security Training (Release 13)

Oracle Fusion Financials Reporting Training FRS, smart view, Account Inspector, Account Monitor) Baruch College, NYC, NY

Developing Applications with C programming.

Awards and Recognition: Oracle’s Quarterly Award for the outstanding contributions to the team success

(2006)

Contact this candidate