Qualification Highlights

• Over 10 years of IT experience in which 7 years in Developing, Customizing Oracle E Business Suite modules that include Accounts Receivables (AR), General Ledger (GL), Accounts Payable (AP) , Oracle Purchasing (PO), Trading Community Architecture(TCA), Fixed Assets (FA), iExpenses, Cash Management (CM) and Application Object Library (AOL)
• Experience in Development and Support of General Ledger Management and Procure to Pay Cycle
• Expert in Oracle Discoverer Administration and User Edition for generating number of complex reports in various modules.
• Proficient in designing and developing applications using Developer 6i (Forms 10g, 6i, 6.0, 5.0, 4.5, Reports 10g, 6i, 6.0, 3.0, 2.5) for Oracle 7.x, 8 and 8i/9i databases.
• Proficient at writing PL/SQL (2.x/8.x/9.0) and UNIX shell Scripts and other related tools and techniques on Oracle Database in UNIX on Sun Solaris, HP/UX and Windows NT/2000 environments.
• Experience in customization by extension and modification of the standard application suite using Application Object Library.
• Sound Knowledge of SQL and Application Tuning, Data Conversion from legacy system to Oracle.
• Exposure to Workflow 2.6 customizations and XML publisher.
• Experience in Oracle AIM Methodology
• Proficient in Microsoft tools (Word, Excel, PowerPoint, Outlook)

EDUCATION & CERTIFICATION

• Master of Computer Applications.

Technical Expertise

ERP APPLICATIONS

Oracle Financials 11i,R12.1.3 Accounts Receivables, Accounts Payables, General Ledger, Application Object Library , System administration, Purchasing, Assets, Cash Management.

LANGUAGES

SQL, PL/SQL, C, C++, MUMPS

RDBMS

Oracle 7.3/8/8i,10g,11g, M-Database, MS Access

GUI

Discoverer (4i,10g), Developer 2000 (Forms 4.5/6i/10g and Reports 2.5/6i/10g), Web ADI 7.2, SQL* Loader, TOAD, SQL Navigator, VB, Workflow 2.6, XML publisher

FRAMEWORKS/API/ OTHERS

HTML, MS Excel/Word/PowerPoint

Testing Tool

Win Runner Testing Tool

OPERATING SYSTEMS

Windows 95/98, Windows NT/2000, UNIX, Solaris, MS-DOS

Professional Experience

Oracle Financial Techno-Functional Analyst Apr ‘08 – Nov ‘11
Confidential,Cranford NJ

Project: Lead and Support 11i, R12 Financials.

Responsibilities:

• Supported, Maintained and Enhanced the Oracle e-Business Suite Applications for Financial Modules.
• Lead role in Upgrade of 11.5.10.2 to R 12.1.3
• Partnered with DBA and Business Users to identify and remedy key issues introduced by upgrade
• Test integrity of customizations to ensure no overrides due to R12 upgrade
• Proactively identify and fix issues in the system that have critical business impact
• Performed required setups for R12 (GL,AP,AR)
• Created test scripts and test plan for User Acceptance testing
• Created End User Documentation and trained users on new functionality of R12
• Customized XML Publisher and Oracle Reports for R12
• Provided end users support for 43 locations.
• Setup 3rd party ad hoc reporting tool, GL Wand
• Created Several ad hoc reports and trained end users on GL Wand
• Post go-live Support
• Performed system admin tasks.
• Collecting, Documenting, designing and implementing enhancements in financial modules ( GL,AP,AR, AOL,FA,CM)
• Developed ad hoc queries on AP,GL,AR for audit purposes, end user reporting
• Actively participated in day to day, month end, quarter end and year end closing activities for the financials and auditing.
• Setup Payment Document Templates,
• Fixed issues with Sub Ledger Accounting, Payment Process Requests, GL interface, Payable Open interface Import, Auto invoice, Lockbox interface.
• Developed several financial reports using FSG in General Ledger.
• Documenting, designing and implementing report enhancements and change requests.
• Designed functional (MD 50) and technical documentation (MD 70) using AIM.

Environment: Sun Solaris 5.2, 11.5.10.2, R12 Oracle Applications (AOL, GL, AP, AR, FA, CM), Oracle 11g, Oracle Reports, Oracle Forms, Toad, XML Publisher, Web ADI

Oracle Financial Techno-Functional consultant Dec ‘05 – Apr ‘08
Confidential,
Project: Discoverer Reporting, Enhancement and Support 11i Financials.

Responsibilities:

• Collecting, Documenting, designing and implementing enhancements in financial modules ( GL,AP,AR,PO, AOL)
• Setup and implementation of Budgets, Consolidation in GL for different set of books.
• Setup and implemented banks, accounts, employee expense reports and recurring invoices in Accounts Payable.
• Setup and implemented Accounts Receivables process for invoices, receipts.
• Actively participated in day to day, month end, quarter end and year end closing activities for the financials and auditing.
• Helped in reconciliation of data between oracle and coface web system
• Fixed issues with GL interface, Payable Open interface Import, Customer Interface, Auto invoice Master Program, Lockbox interface, Requisitions Open Interface.
• Developed several financial reports using FSG in General Ledger, Income Statement for Actuals and Budget, Trial Balance, Balance sheet and other consolidated reports as per the business requirement.
• Developed and customized Account analysis, AP Prepayment Status Report, AR invoice print reports.
• Documenting, designing and implementing report enhancements and change requests.
• Customized Oracle AP Invoice form to validate on the data entered.
• Expertise in Administration and User Edition of Oracle Discoverer. In Administration Edition, Created various business areas, user views, custom folders, item classes, hierarchies and joins for reporting.
• Developed business areas and several work books using Discoverer 4i with required calculations to meet business requirements.
• Created EUL’s using Discoverer 4i Administrator.
• Developed status of periods workbook and integrated into SSWA.
• Assigned securities and privileges to different users using Discover 4i Administrator.
• Developed Oracle Alerts to notify users on failed Journal imports.
• Trained business users in FSG reports, ADI and Discoverer.
• Training users for better handling of errors.
• Designed functional (MD 50) and technical documentation (MD 70) using AIM.

Environment: Sun Solaris 5.2, 11.5.9 Oracle Applications (AOL, GL, AP, AR, PO), Oracle 8.1.7, Oracle Reports 6i, Oracle Forms 6i, Toad, SQL Plus 8.0.6, Oracle Discoverer 4i, ADI 7.2

Oracle Technical consultant Jan ‘05 – Nov’05
Confidential,
Project: Discoverer and Oracle 6i Reporting

Responsibilities:

• Created End User Layer Using Discoverer Administrator.
• Expertise in Administration and User Edition of Oracle Discoverer. In Administration Edition, Created various business areas, user views, custom folders, item classes, hierarchies and joins for reporting.
• Worked on oracle discoverer to develop several complex workbooks.
• Developed daily time and labor, Order back log, Sales Commission, Open Sales Order Forecasting Discover reports
• Developed and Customized AR Invoice Print, Check print, Account Analysis, Commercial Invoice, Packing slip , Pick Slip, Bill of lading and Printed purchase order report
• Resolved printer issues.

Environment: Sun Solaris 5.2, 11.5.9 Oracle Applications (OM, WSH, GL, AR, AP, PO), Oracle 8.1.7, Oracle Reports 6i, Toad, SQL Plus 8.0.6, Oracle Discoverer 4i

Technical Developer Jan’ 04 - Dec’04
Confidential,Atlanta

Project: 11.5.8 Enhancements and Supporting

Responsibilities:

• Customized several seeded Oracle Reports (GL Account Analysis, AR Invoice, AR Statement, AR 7 Bucket, AR Aged Trial Balance etc.,)
• Created Material Order Confirmation custom Oracle 6i form.
• Modified the standard RFQ and Quotes Oracle 6i Form as per requirement.
• Developed custom reports for the business requirement and registered with Oracle applications.
• Created tars for resolving issues related to AR, OM.
• Created and upgraded SQL, PL/SQL Reports.
• Worked on Customizing & check printing system, which receives data from AP module and updates AP check information based on check Printing Systems.
• Created customers for online orders using the Customer API.
• Created AR Credit Memo Interface for Imported Order Invoices.
• Performed Discoverer Administration using 4.1.47.
• Migrated Discoverer EUL from Standard Mode to Application Mode.
• Mentored the Developers with Discoverer and Multi Org Reports.
• Trained Users with use of Web based Discoverer Plus End User Edition and Viewer.
• Developed several Discoverer workbooks as per requirement.
• Modified Business Intelligence Workbooks to suite their business needs.
• Integrate the Discoverer workbooks into Self Service Web Applications (SSWA)

Environment: Sun Solaris 5.2, 11.5.8 Oracle Applications (GL, AP, AR, PO, OM, TCA), Oracle 8.1.7, Oracle Forms 6i, Oracle Reports 6i, Toad, SQL Plus 8.0.6, Oracle Discoverer 4i
Systems Analyst Jan ‘01 – May’03
Confidential,INDIA
Client: GMR Group

Project: Interfacing, Reports and Support to Users - Oracle Financials Release 11.5.5

Responsibilities:

• Configured SQL*Net
• Performed Security Management - Created Users, Roles, Profiles
• Performed system administration
• Developed database procedures, packages and triggers for creating rules of the application
• Customized standard Oracle Reports in AR, OM, AP, PO Modules
• Tuning of SQL Queries for CBO in 8.1.7
• Created new Oracle 6i Reports and Forms and integrated into the applications
• Maintained and created conversions from OM to AR.
• End Users training on working on GUI forms.
• Enhancement and Application tuning of Application Programs
• Production Technical Support
• Developed the PL/SQL package to implement the validation and loading of data from flat file to interface table.
• Enhancement and Bug fixing of existing forms
• Created new tars to resolve issues.
• Upgraded custom 4i Reports to 6i: Account Analysis Report, Cost Summary Report, Aged Trial Balance Reports, E&Y Cost Summary, Positive Pay, Reserve Summary Report, and PRC Distribute Cost Labor.
• Upgraded custom 4.5 forms to Oracle Forms 6i.
• Developed several Discoverer workbooks in Oracle Discoverer 3.1.7 and Discover administration.

Environment: HP UX, 11.5.5(AP, AR, OM, PO) Oracle Applications, 8.1.7, Developer Forms 4.5, 6i and Reports 2.5, 6i, Oracle Discoverer 3.1.37.

Programmer Analyst Jan 2000- Dec 2000
Confidential,Project :

VysAmulya – Customization and implementation of Profile/anywhere (ING Vysya Bank, Bangalore)
VysAmulya is the Centralised Banking System that Idea Space Solutions Ltd is implementing for ING Vysya Bank in around 120 centers throughout India. This is the first Sanchez implementation in India. The system includes at the core of its software backbone, a centralized banking package Profile/Anyware. This system has a 3-tier architecture with Developer 6i Forms as the front-end, Oracle V8 in the middle tier at every individual branch and M-Database, Message Transport Manager as the Back end.

Responsibilities:

• System Associate and Developer.
• Activities include Core system analysis, design and coding.
• Customization and Development of Modules (ATM, Internet Banking, Clearing), Enhancements, Bug Fixing and online support for Branches. Involved in development and customization of following.
• Customized and Maintained ATM interface Message Handler to include functionalities for SPNS and Master Card.
• Developed Oracle Reports for SPNS and Master Card.
• Approved transactions for Issuer
• Questionable transactions for Issuer
• Approved transactions for Acquirer
• Questionable transactions for Acquirer
• Created several SQL Queries for retrieving data.
• Created Database triggers for ATM interface module
• Developed two user interface utilities, which are written in Procedure Scripting Language (PSL) in MUMPS to inquire about the status of check and to update the status of check.
• Developed a PL/SQL program, as user interface for changing foreign exchange rate whenever user requires.
• Developed a M-routine for reconciliation of SWITCH transactions and PROFILE transactions.
• Developed Oracle Reports for issuer transactions for settlement purpose.
• Generation of customized and developed reports for ATM Module, using Data-Qwik and PSL Programming Techniques.
• Generation of Statement of Accounts using Report definition and PSL techniques.
• Design and development of new triggers for Internet Banking module and part of Vysyamulya customization.
• Handling DD Posting programs in M-language
• Developed Oracle Reports for Outward clearing and Inward Clearing
• Developed a report to display Daily NRE transactions.
• Developed Oracle report to display the account details of a particular customer.
• Modified the Day end report of Acquirer transactions to include reversal transactions and to change the source for the report from DTJ to TTX.
• Developed a routine to update card term and expiry date.
• Developed a report to display address details of news cards that are issued in specified period using Oracle Reports.
• Modified several ATM flat file extractions as per requirements.