SUMMARY

• Oracle Certified Associate with 9+ years of Oracle EBS experience as a Lead System Analyst and Techno - Functional Consultant developing, configuring and managing Oracle R12 and 11i ERP Applications.
• Strong domain knowledge in Finance, Purchasing, Inventory and Logistics management modules.
• Functional and Technical expertise in Oracle Applications modules GL, AP, PO, FA, AR, OM, INV and AOL, and in Virtual Trader application.
• Extensive knowledge of R12 SLA/FAH (Sub Ledger Accounting) Architecture, AGIS (Advanced Global Intercompany System), MOAC (Multi Org Access Control), Oracle Workflow design and customizations.
• Expertise in Oracle Business Intelligence Discoverer 10g/4i, with knowledge of design and development of End User Layer
• Extensive working experience in Custom.pll and Forms Personalization.
• Extensive working experience on RICEW objects (Reports, Interfaces, Conversions, Extensions and Workflow)
• Expertise in Oracle 9i, 10g, 11g, SQL, PL/SQL, Unix and Linux shell scripting, SQL*Loader, FNDLOAD, JDeveloper, Discoverer, XML Publisher/BI Publisher, WebADI, Forms & Reports 6i, Forms & Reports 10g.
• Excellent communication and interpretation skills in requirement gathering and documentation in compliance with Oracle AIM standards.
• Knowledgeable in Application problem analysis with strong logic and debugging expertise.

TECHNICAL SKILLS

Business Areas: Finance, Purchasing, Inventory and Logistics

Programming lang.: Unix and Linux Shell scripting, SQL and PL/SQL

Databases: Oracle 11g/10g/9i/8i

Other Tools/Special Software: Developer Suite 10g (Oracle 10g Forms and Reports), Developer 2000(Oracle 6i Forms and Reports), JDeveloper, XML Publisher, Oracle BI Discoverer 10g/4i, PLSQL Developer, Data Loader, Toad, SQL Loader, SQL Developer, FNDLOAD, Clarify CRM, MS Office, MS Excel, MS Visio, Team Tracker, PVCS, SQL* Plus 10g and 11g

Operating Systems: Unix/Linux, Windows 95/98/2000/NT/XP

Applications: Oracle Applications R12 and 11i Oracle General Ledger (GL), Oracle Fixed Assets (FA), Oracle Account Payables (AP), Oracle Purchasing (PO), Oracle Sub Ledger Accounting (SLA), Oracle Integrated Receiving (RI), Oracle Order Management (OM), Oracle Inventory (INV), Oracle Account Receivables (AR), Oracle System Administrator, Oracle Application Developer

PROFESSIONAL EXPERIENCE

Confidential, Ramsey, NJ

Lead System Analyst

Responsibilities:

• Analyze information processing and/or computation needs
• Participate in the development of software through planning, design, programming/coding, testing, debugging, monitoring and maintaining computer systems, tools and software.
• As a Team Lead worked on coordinating and delivering the business needs within the Service Level Agreements (SLA) and provide product and specialized IT support.
• Impact analysis on upgrading the OS from Unix to Linux as part of R12 upgrade.
• Developed and executed presentation sessions of R12 enhanced functionalities for business users on SLA/FAH, AGIS, GL, FA, AP and MOAC (Multi Org Access Control).
• In-depth analysis of R12 AGIS enhanced functionality to accommodate the business processing needs that are currently performed on 11i GIS.
• Developed scripts to automate the AGIS Intercompany Organizations to User assignment.
• Customized AGIS workflow to in corporate the Approval process as per the business needs.
• Involved in setting up R12 GL accounting setup manager and defining accounting rules.
• Customized the SLA setup for Fixed Assets, Payables and Cost Management, creating custom AAD’s, JLD’s, JLT’s, ADR’s, sources etc. as per the business accounting rules. Customized the FNDLOAD to import export the custom SLA sources across multiple instances.
• Created R12 GL to Sub Ledger drilldown extracts using SLA (GL to AP, PO, FA and Integrated Receiving).
• Extensive knowledge of Account reconciliation between AP and GL. Expertise in resolving the monthly reconciliation issues between AP Trial Balance and General Ledger.
• Involved in providing business solutions by setting up the GL Sets Of Books, Chart of Accounts, Cross Validation Rules and designing the consolidation process as per the needs.
• Extensive knowledge of 11i MRC and Reporting Ledgers in R12
• Expertise in resolving the MRC issues due to upgrade from 11i to R12.
• Extensively involved in Functional and Technical support for monthly/yearly close of GL and FA processes.
• Involved in supporting FA processes like Mass Additions, Adjustments, Transfers, Reclassifications, Retirements, Depreciation, Transfer to GL etc.
• Involved in support and maintenance of GL processes like Open/Close Periods, Journal Import, Daily Rates Import, Posting, Mass Allocation, Revaluation, Translation, Consolidation etc.
• Provided extensive support for the conversion of WebADI templates from 11i to R12.
• Performed analysis and setups for country specific implementation of GL and FA for China, Poland, Taiwan and Mexico. Performed Globalization setup for Mexican Inflation by enabling the Oracle localization for Mexico.
• Developed Russian GL Accounting Ledger report in compliance with Russian Local Correspondence Accounting rules.
• Developed custom GL forms, reports, and developed conversion interfaces to import accounting journals from legacy systems.
• Designed the Oracle FA Location KFF definition as per the business needs. Developed interface to load FA locations using external tables.
• Involved in preparing test plan, coordinating, testing and planning of major upgrades for Oracle FA system.
• Developed conversion interfaces to convert the Assets from the GEAC legacy system to Oracle Fixed Assets system.
• Customized the AP Create Mass Additions to transfer the AP Invoice distributions limiting to certain business accounts. Also made changes to ignore the Asset Book and Asset Category if anything populated on the Invoice to keep in compliance to 11i processing.
• Extensively developed shell scripts using Unix/Linux scripting.
• Created business audit reports enabling Oracle Audit Trail.
• Developed SOX compliance extracts for system audit
• Developed scripts to RKM encrypt the sensitive information and store into Oracle database.
• Involved in support and maintenance of Oracle GL, FA, AP and PO systems.
• Created interfaces to load GL Currency conversion rates (Daily rates) and Translation rates (Period-Average and End-of-Period).
• Created GL Mass Allocation templates.
• Involved in support and maintenance of custom Global Intercompany Journal approval workflow and custom Intercompany Transfer to GL.
• Created extracts to export balances from Oracle GL to legacy business accounting systems using secure ftp and database links.
• Developed shell scripts to monitor and alert on long running jobs in the system.
• Extensively involved in tuning the performance sql’s.
• Developed custom account reconciliation reports within, and across the instances using database links.
• Developed custom 11i drilldown extracts from GL to sub ledgers (GL to AP, PO, RI and FA)
• Worked on Oracle Mass Retirement process, plugging in the custom code to in corporate business retirement rules using Oracle custom extension and form personalization. Customized the Oracle Post Mass Additions to perform business validations using custom menu.
• Customized the FA Account Generator workflow, to generate the NBV, REVAL RSV, COR and POS gain and loss accounts at Category level. Customized the Depreciation Expense Account generation to be different between Corporate and Tax books.
• Customized the Oracle Invoice validation process to generate multiple Liability accounts within a single Operating unit, and to apply custom holds upon business validations, using Oracle custom extension and Custom.pll.
• Customized the PO and PO Requisition Account Generator workflow to generate multiple Accrual accounts within a single Operating unit.
• Customized Oracle GL, FA, AP and PO forms through Form Personalization and CUSTOM.pll.
• Involved in develop ent of business processes on Virtual Trader accounting system.
• Created custom inbound interfaces to Virtual Trader application from Oracle GL systems using Linux scripting.

Confidential

Asst. Systems Engineer

Responsibilities:

• Developed Business Intelligence packages using database languages such as SQL, PL/SQL.
• Developed Unix and Linux shell scripts on the server.
• Supporting Back end relational databases
• Developing reports using BI tools such as Oracle BI publisher and Discoverer
• Programming with /on relational databases such as Oracle Or SQL, Forms 6i, Reports 6i, Workflow builder, etc.
• Support and Maintenance of Oracle Applications modules GL, AP, PO, AR, OM, INV and AOL
• Worked on setup and configuration of General Ledger and Account Payables Modules
• Extensively worked on inbound and outbound interfaces to Oracle General Ledger.
• Customized the journal import to bypass the load on GL interface from external feeders apart from the Oracle sub ledgers, using a custom interface table.
• Worked on design and developed various collection views to collect sub-ledger data to GL
• Developed Discoverer reports and worked as Discoverer Administrator managing EULs and access privileges to users and developers.
• Involved in requirement gathering and testing of Reports, Interfaces, Conversion and Form Extension.
• Developed conversion interfaces using Oracle API’s to import Purchase Orders, Purchase Requisitions, Suppliers/Vendors, and Sales orders, etc.