SUMMARY:

• Holds a Master’s Degree in Computer Science with 18 years of experience with Oracle Applications / E - Business Suite - Performing technical, functional, administration and project management work. Worked on Several financial implementation projects
• Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User and Supporting for Oracle Financials R12/11i in Confidential, AP, AR, PO,FA,I Expenses and I supplier modules. Extensive experience with System Administration functions, Setups in Confidential, AP, AR, PO,FA,I-Exp, Workflow and AME
• Participated in multiple Oracle apps R12/11i implementations in multi org/ multi-currency scenarios. Hands on experience with setting up CRP, Co-ordinating with project sponsors, key stake holders, fit-gap analysis, requirement mapping, project planning, UAT and production rollouts.
• 15+ years techno-functional experience with General Ledger, Oracle Projects, Oracle Purchasing, Accounts Payables, Receivables, Fixed Assets, Order Management and Inventory modules doing configurations, User support and .
• 5 years of functional R12 implementation experience with payables, I expenses, I Supplier, Receivables, eBtax, Cash Management, Purchasing and Payments modules. Implementation experience as a technical lead with HRMS, Contracts, Self Service, Incentive Compensation. Good techno-functional knowledge in Procure-to-Pay and Order-to-Cash cycles
• Proficient in PL/SQL, UNIX, Oracle Forms/Reports, Discoverer development and Administration, BI Publisher, Workflow builder, Open Interfaces, API’s and performance tuning. Proven background in developing interfaces, customizations, reconciliation scripts using PL/SQL, Oracle API’s and Open Interfaces where available and the ability to create Custom API’s where required.
• Very strong in Customization and Integration of third party systems with Oracle Applications. Proven knowledge in Data Migration Strategy. Good Knowledge on Data models and table structures of all modules including TCA, SLA. Worked on Numerous Interfaces: Customer, Auto Invoice, Order Import, AP Invoice Import & Vendor Import, Journal Import, Revenue Interfacing, BAI Import, HR Employee Data from SAP e.t.c
• Hands on experience in customizing and maintaining core workflows. Worked in defining AME Rules, Approval Groups based on requirements, implemented Sub Ledger Accounting Methods where ever possible replacing workflows. Experience with Production Support activities, working with Oracle On Demand, Instance management, TAR management, Bouncing servers, instance monitoring, planning and resolving support tickets
• Superior communication, organizational, and interpersonal skills.
• Extensive experience using Oracle AIM Methodology to produce Technical/Functional Specifications, Test Plans and Release Documentation as well as reviewing and generating Functional Specification and Setup documentation

TECHNICAL SKILLS:

Oracle E: Business Suite (EBS) / Applications: R12 (12.0.6, 12.1.2), 11i, R11, R10.7, R10.6 (15 yrs)

Modules: Confidential, AP, AR ( 16 yrs ), PA, FA, PO ( 9 yrs ), OM, HRMS, INV, TCA, CM (3 yrs), eBtax, I-proc, I-exp, I-supplier ( 2 yrs)

Oracle: 11g, 10g, 9i, 8i, 8, 7.x, SQL, PL/SQL (17 yrs)

Oracle Tools: SQL*Plus, SQL*Loader, PL/SQL, PRO*C 2.1/ 2.0 /OCI, TOAD, SQL*Navigator, Developer 2000(Forms 6i/4.5/3.0, Reports 6i/2.5), Discoverer 6i/10g, Discoverer Administration

Other Components: Oracle BI Publisher, XML Publisher, Workflow Builder 2.6.3, OA Framework, BPEL / SOA,Application Object Library (AOL/FND), Concurrent Manager (CM), Flexfields, AME &SLA

BlackLine, MS: Office, Rollstream, IWM, IPM / COFAX, Ironside Power Works

Source Code Control: Sablime, Clear Case, PVCS, Remedy, AltrisIBM Optim, Mercury Quality Center ( QTP )UNIX (SVR4.2, HP-UX, SUN Solaris), Korn/C/Bourne UNIX shell scripts, LINUXWindows 95/NT/98/2000/XP, Languages: C/C++, Java, Pascal/Basic/COBOL

Hardware: SUN Ultra Enterprise Series Servers E 10000/6000/4500 , HP 9000 / E55, DELL Servers, SUN SPARC

PROFESSIONAL EXPERIENCE:

Oracle EBS Consultant

Confidential, NY

Responsibilities:

• Implemented I-Expenses, Receivables, eBtax, I-Supplier and Purchasing. Partially worked on Oracle Projects
• Requirement gathering for all the above modules by interacting with the users and getting the information on the scope of the system, accounts, options, templates e.t.c
• Configuring the system for the above modules which starts from defining new responsibilities, custom menus, accounting, lookups, setups, system options and workflow related activities, transaction types, receipt classes, profile options, organizations, locations, purchasing options, payables options, financial options, categories, audit rules, expense templates, policy schedules, approval hierarchies, tax regimes, taxes, tax codes, terms, document sequences
• Creation of responsibilities to control access for users based on the user functions.
• Preparation of BP-090, BR-100, MD-070, MD-050, TE-040 for all the above modules
• Worked with Oracle to resolve issues due to patching issues, roll-up patches e.t.c
• Setting up POC, UAT and Production systems
• Conducted integration testing and user sessions
• Production roll-out
• BlackLine implementation for Accounts & CIM modules. This is account attestation system and configured Users, Accounts, Assignments, Data Feeds and mapping.
• Stream Line FA Mass additions process and automated the process
• Modified SLA (Subledger Accounting Methods) for deriving Asset Cost and Depreciation accounts by modifying the Accounting Method definitions and creating new rules.
• Designed reports for SRS system
• Good understanding of book close process for all modules in Oracle and supported book close process
• Implemented Payment Process Profiles (PPR) and reconciliation in Cash Management modules based on the Bank messages
• Implemented AME rules for Requisition workflow based on requisition amounts and routing the approval path to different departments for checking and approving
• Implemented Approval Groups based on Job hierarchy for PO Approval workflow
• Implemented the controlling of Account derivation in Requisition Account Generator based on categories
• Customized Requisition and PO Account generators to derive the charge account based on lookup sets in Project Accounting.
• Created Invoice Interface between FITS and Oracle
• Implemented DFF to capture additional information Confidential Invoice line and distribution level
• Deriving accounting based on the location and department passed in the DFF’s for FA Mass Additions process
• Created a process to update Mass Additions tables to merge assets, update location and depreciation expense account.
• Created reports to get Fixed Assets information including accounting entries, depreciation projections for all the assets in the systems which ties up with Oracle trial balance and fa category reports.
• Created reports for audit details from payables, expense reports, receivables reports.
• Created data feeds from Oracle Confidential and external systems that feeds into BlackLine system for attestation
• Created Invoice XML template for Receivables invoice printing. This is a single template which prints invoices, credit memos, debit memos and multiple signatures based on transaction types.
• Created XML Template for PO Document printing
• Supported book close process which include resolving issues with Oracle Confidential, Payables, Receivables, Sharepoing reporting e,t,c
• I-Expenses, Receivables, eBtax, I-Supplier, Purchasing Modules.

Project Lead

Confidential, NJ

Responsibilities:

• Responsible for Gap Analysis, R12 Planning & Assessment. Also identifying and accessing the technical architecture.
• Activities include CEMLI Analysis, Preparing Documentation, Involving Business Users, Mapping Business flows with new features
• Involved in the Assessment and Gap Analysis for all Financial modules, Order Management, I Procurement, Projects, Fixed Assets currently used by PRG.
• Completed all the setups
• Worked with Oracle on BUG resolution and Patches
• Prepared Setup and User manuals
• Trained Internal Users on the new functionality
• Completed the Initial supplier adoption process

Oracle EBS Consultant

Confidential, NY

Responsibilities:

• Requirement gathering for Vendor Interface, Payables open invoice import, Banks import, journal import and Exchange Rates import
• Functional and Technical documentation for all the above interfaces
• Development of interface programs for vendor interface, Open invoice import, journal import, BAI Import using oracle standard interfaces
• Development of Banks import using Oracle API’s. Updating Supplier information using Oracle API’s.
• FTP scripts to move data between different servers using SFTP and encryption
• Creation of custom views required by Gilt enterprise applications to access data from Oracle EBS
• Coordinating with different business units on the file structures required, moving mechanism between servers
• Developed reports required by Payables department to get payments, invoices and SLA Transactions information.

Lead System Analyst

Confidential, Philadelphia PA

Responsibilities:

• Employee interface: SAP HRMS à Shared Oracle HRMS . Employee creation / updation, termination / APPS user and assigning responsibilities and roles.
• Invoice interface: GXS / IWM system (External) à Oracle Payables, IPM / COFAX (Internal) ß Oracle Payables.
• Supplier / Bank interface: GXS / Rollstream (External) à Oracle PO / AP. Suppliers, Sites, Contacts, Bank Branches, Bank Accounts, Index file creation in IPM, Outbound file generation to GXS.
• Revenue Interface: External billing systems à Confidential module.
• Confidential Accrual Entry Transfer between Accrual and Cable books.
• Pre-Notes generation process to the banks for verification
• Payment file Generation based on the payment batch and send to the bank which will be processed by wellsfargo payment manager.
• IExpense implementation / Support. IProcurement Implementation
• Involved in System Administration, Performance tuning, Production support, Workflow Administration. Created Oracle EPM / BI Publisher reports. Customized Invoice workflow process, requisition workflow process. Monitoring synchronization with directory services, workflow background process. Forms Personalization
• Modifications of Supplier, Bank, Invoice interfaces to be compatible with Rel 12

Project Lead

Confidential, Parsippany, NJ

Responsibilities:

• Create extensions using Oracle recommended frameworks. Report against Applications data model.
• Write technical design documents for conversions, extensions, interfaces, and reports.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.
• Excellent knowledge on Setups related to customers, vendors, payments, orders, transactions, ledgers, projects, billing and iexpenses.
• Developed numerous Discoverer Reports for the Orbitz Business Unit, Confidential & Galileo Business Units in AP, Confidential Modules. Improved the performance of lot of existing Discoverer reports by tuning the SQL, using Hints e.t.c
• Designed and Developed multiple interfaces for the Business to manage data that come across different systems. Given below are the interfaces worked. All these are developed using PL/SQL and UNIX
• As a project lead, coordinated and worked in LE Merge projects to merge the legal entireties of different business units and all the related transaction data. Worked on the Project to migrate all the transaction data related to WorldSpan business unit in to the current Confidential Oracle Financial System. Developed lot of UNIX Shell Scripts to move data files between different internal systems as well as push data files to the vendors and customers. Also to automate jobs using CRON. Developed scripts and assisted the Conversion team to convert data from 10.7 to 11i and in the Set of Books separation Project. Developed Discoverer reports as well as Invoice Interface for Ebookers. Modified lot of Shell scripts which runs different interfaces as part of RAC implementation. Developed scripts to load / convert contract information from external system to Oracle Contracts module.
• Used IBM Optim tool to downsize development and test instances by archiving and removing old data.
• Used Oracle API’s in supplier updates, Oracle Pricing, Oracle HRMS, Oracle Receivables.
• Developed programs to convert price list and qualifier information.
• Defined DFF’s and captured pricing attribute information.
• Created data feeds using PL/SQL for the COGNOS reporting tool
• Involved in the implementation of HRMS, Incentive Compensation, Procurement and Contracts modules. Worked on data feeds from these systems to outside vendors that involves extraction processes as well as automation scripts.
• Developed scripts to reconcile data between FCH and GCS ( Confidential ) modules as part of FCH Implementation. Has good knowledge on all the data models in FCH Module.
• Performed DBA activities like bouncing Apache servers, resolving conflicts and dead lock situations in RAC enabled environment. Worked closely with Oracle On Demand to resolve any issues the users face while maintaining the Production Instance. Created and actioned numerous Service Requests, TAR’s with OOD. Maintained different instances, patch maintenance e.t.c
• Customized PO forms using custom.pll to control access based on different responsibilities. Modified Oracle Reports to make changes in XML templates.
• Modified / Customized the following workflow
• Involved in many day to day activities to maintain the fixing the problems with the Instances.
• Personalized Contracts forms using OA Framework to remove some buttons.
• Used BI Publisher and BI Discoverer to convert some existing discover reports and templates for more data presentation using charts for comparison.
• In-depth knowledge of performance tuning in PL/SQL using Hints and indexes.
• Created Orders on Credit Check Hold Report / Outstanding Holds Report to include additional columns regarding the customer based on the business requirements. These reports are created using Discoverer.

System Analyst / DBA

Confidential, Piscataway, NJ

Responsibilities:

• Worked with ADBA Tech Team. Mainly responsible for all the activities related to Data base administration, Instance Management, TAR Management, Emergency Bug Fixes, Production support activities e.t.c. Day to day activities include supporting the production databases of Domestic as well as International. Has done lot of performance tuning in different applications.
• Also re-designed and modified all the code related to PA Archive / Purge process from 10.7 to 11.5.9. Tested the code on test platforms. Working on the Slim Down Instance process. Used the code to Purge data.
• Actively involved in the GACCR Upgrade project from 10.7 to 11.5.10. This includes writing migration scripts, setting up the test environments, modifying the custom code, running the scripts on the test instances, verifying the data, migrating the feeders and interfaces e.t.c. This project is mainly to migrate the Domestic general ledger to 11i.

Senior Application Analyst

Confidential, New Jersey

Responsibilities:

• Involved in the extraction, conversion and reconciliation of Accounts Payables and Fixed Assets modules.
• Developed scripts to extract data from the 10.7 system. Wrote scripts to extract data for Invoices, vendors, Payments and Checks. These data files are used to load the data into the 11i system. Developed scripts to load this data into staging tables and then to the Oracle Interface tables for Payables Open Interface. Designed and Developed scripts to load the data from the extraction files into the 11i system for Vendors & Payments. Did all the required set-ups before doing the conversion on the 11i platform. Did the reconciliation of the data that was loaded using some custom developed scripts and by running the Standard Oracle Reports such as Payables Accounting Process.
• Developed scripts to extract Invoice Data & PO Data which will be loaded into the Ariba System.
• Involved in the testing of all the conversion scripts on UAT, Systems Test and Conversion platforms.
• Helped in developing scripts for the FA Module. Developed extraction & conversion scripts to convert assets related to the CORPORATE, FEDERAL, STATE, ACE, AMT Books. Also developed scripts to convert CIP Assets. This includes capturing information from the PA Modules also.
• Successfully converted and validated all the invoice, payment, check, vendor and Assets related information on the 11i platform.
• Involved in the day-to-day processing of the data feeds for the AP Module in the current 10.7 environment.

Senior Oracle Applications Analyst

Confidential, Newark, New Jersey

Responsibilities:

• Worked in the Conversion of SVP, ILD & PPS Customers into Oracle Financials AR Module. The customers from the other systems are migrated to Oracle Financials using the Customers interface. This involves lot of validations and finally getting the data into the platform
• Developed a Transaction Audit Process, which gives report of all the transactions, which will come to Order Management module and eventually to the AR Module. This involves identifying the transaction based on the CLID Ranges Confidential the Warehouse, then match the transactions with the DTL Platform, match them with the Order Management staging & Order Management modules and finally matching them with AR Module. This includes lot of validations as well as getting data Confidential every stage. This report helps IDT Financial team to see the revenue generated in the given period, revenue billed and any missed transactions e.t.c. This helps the team in billing the customers properly.
• Developed reports using Discoverer. Reports development includes Summary, Details of Errors, Details of Processed transactions.
• Worked in the Order Import & Auto Invoice Interfaces to load orders which are coming from Different Source Systems. This involves Validation, loading into interface tables as well as running the import process.
• Done some work on PO Approval & PO Requisition Account Generator workflows. This involves Setups as well as modifying the PL/SQL Code for the workflow process.
• Involved in the performance improvements for the Order Import Process. This process has 9 steps, which includes the Order Import Process. The Order Import process was taking 4 hours to process around 3000 transactions per day. The performance was improved to complete the job in 1 hour.
• Developed Check File generation process & Check file Reset Process. This process creates a CSV file based on the checks process in a particular period and based on type like CHECK, EFT e.t.c. Also gives the user to reset the check back to ‘VOIDED’ .

Technical Lead / Application Developer

Confidential, Piscataway, NJ

Responsibilities:

• Designed and Developed Purge Process system for Oracle Projects Module. This system is based on the Oracle Financials purge Process, but customized a lot to in corporate the changes required by the PA process controllers. The purge code available in 10.7 Patch set K has been taken, Customized a lot to include the custom tables and to change the criteria based on the requirements and ported back to 10.7 Patch set G. The purge process was executed successfully many times in Production and cleaned up a lot of data and transactions, which are no longer, required. This process will be run once every year. Also this process was used to slim down the instance to prepare for the upgrade from 10.7 to 11i.
• Designed and developed Conversion scripts to convert data from 10.7 to 11i systems for AR Module. For the Customer related data, Scripts were developed to use the standard Customer Interface program and includes converting Customers, Addresses, Sites, Contacts, Phones,Profiles, Profile Amounts e.t.c. For the transaction data and other tables, scripts were developed to convert data from 10.7 to 11i. About 30 tables were mapped.
• Designed and developed conversion / migration scripts to convert data from 10.7 to 11i system for PA module. This is the biggest module, which has about 54 tables. Also PO/ Confidential /AP modules including code combinations tables were mapped. In Purchasing, OPEN PO Documents, PO Requisition Import interfaces were used to migrate the Open PO’s, Requisition data.
• These scripts were used to convert around 100 Set of Books into 3 consolidated single instances Confidential &T. (That is one instance for each region. Eg: one for Asia Pasific which has around 40 books, one for Europe which has around 38 books and one for Latin America). Have excellent knowledge of the data models, new tables, and relationships between tables in all the above-mentioned modules. Has very good understanding of the new Customer table model, which was completely redesigned for AR.
• Extensively used the Customer Interface, Open PO Documents interface, Journal Import Interface e.t.c. Worked on AP Invoice Import & PO Vendor Import interfaces to load vendors as well as Invoices from legacy systems while converting to 11i. Modified lot of Customizations to migrate the data from 10.7 to 11i in PA, AP & AR Modules. Coded & Modified lot of reports related to the PA module.
• Customized workflow processes such as Journal Approval Workflow, PO Approval workflow and AR Inter Company accounting workflow. Good knowledge of the workflow process and workflow builder.
• Apart from the above activities, prepared technical design documents and gave seminars on the new data base changes for PA / AR modules. Developed reports for supporting the Solutions division with Domestic Confidential . Activity included, development of custom reports for the International regions as well as modifying the standard Oracle reports such as Journals - General Report, Account Analysis report.
• Has good knowledge Confidential the data base level on all modules in 11i. Actively involved in all the balances in Confidential, AR, FA & AP modules, which will devaluate according to the Currency devaluation required for the Turkey currency. Consolidating 3 11i instances into a single instance. This involves consolidating all the books from Europe, Asia Pacific, Canada & Latin America into a single 11i platform.
• Working on DBA activities related to the domestic platform regarding performance improvements, working on TAR’s to fix the bugs in FA module.

Oracle Applications Developer

Confidential, California

Responsibilities:

• As a member of OCOE (Oracle Center of Excellence - Confidential &T’s division having expertise in Design and Development of modules having cross cluster impact and providing support for the entire suite of Oracle Financials) Team, Involved in the following activities:
• Implementations of Oracle Applications, integration among development teams (clusters like FA, PA, AP, PO, AR), developing and supporting new customizations & extensions and also project Management. Integrating the Custom Modules with Oracle Financials Modules e.t.c. Support to the Super Cluster Production System, International Production Systems.
• Developed a good understanding of the Confidential &T’s accounting system, architecture and structure of Super-Cluster Oracle implementation. Developed and Supported core Confidential &T’s modules like FCE Caller, SWEEP, CCPR, CIF, Collector etc, Developed good understanding of Sablime (Source Code Control System) and Release Management processes, Month-end & Year-end Book-Close issues, FRL processes and Inter-cluster dependencies.
• In this project, I was extensively involved in Confidential and FA modules. Activities include validating the segments from the custom tables and load the data in to Oracle Application tables, validating and creating new code combinations with the help of batch processes using the segment data, Converting and integrating third party systems with Oracle Assets module of Oracle Applications, Performance improvement for the Mass Additions and Depreciation processes.
• Implementation and support of Standard Oracle Applications i.e. Confidential, FA and AP. Also involved in the System administration, performance tuning and patch maintenance.
• As part of Confidential &T Security Policy, developed a routine to encrypt/decrypt system passwords (apps, ar, Confidential ). This routine was developed using C programming, and was standardized and used to retrieve the required passwords by processes across all the modules for all Confidential &T Oracle Financial Implementations.
• Design and development of Confidential &T’s custom modules CCPR, Sweep, Collector, FCE Caller and CIF (Common Interface Framework) .
• Worked with Oracle Assets core development team for the new setups and the changes in requirements coming in for existing Set-ups in Oracle Assets, Responsibilities include Integrating other systems with Oracle Assets, Writing scripts for the performance improvement, testing patches provided by Oracle, Writing scripts for the purging of Assets tables periodically, Correcting Invalid Code Combinations before running Mass Additions, Depreciation e.t.c.
• Involved in the design and development of a Closed Code Projection Reports, which identifies the combinations, which are going to be replaced in the next month, and the combinations in other cluster tables, which are going to be affected by them. Involved in the performance improvements and modifications required for the SWEEP process which creates new combinations Confidential the end of each month.
• Involved in the Development and maintenance of FCE Caller Programs, which validate the combinations before creating them. Validate and end date the combinations periodically. This module is to maintain accounting segments and the key flexfield setups and code combinations.
• Involved in the Maintenance of CIF module, which runs all the Oracle Interfaces from one place. This is common module from which we can run all the standard Oracle interfaces. Using this module we can change, validate the data, which will be going to the final Oracle Applications tables. Responsibility included development of numerous Forms for Set-Ups.
• Supported Production system throughout the assignment and monitored the production activities as and when required.

Oracle Developer

Confidential, Valhalla,NY

Responsibilities:

• Technical analysis of IC/SY forms,
• Development / Conversion of forms in System Module from JAM / JPL to Forms 4.5
• Development of Reports in System Module using reports 2.5
• Unit testing of forms developed as per AOL 10SC coding standards
• Bug fixing in GEMMS 4.1/3.2 . Re-synch of 5.0 in the System and Inventory modules

Senior Software Engineer

Confidential, Santa Clara, CA

Responsibilities:

• Performed analysis, design, development, and testing.
• Participated in a feasibility study and system design.
• Participated in project discussions with the client.
• Developed the main program which controls the entire system using parent/child concepts of C and Unix. Participated in developing programs in C, Pro*C, and PL/SQL.
• Wrote installation scripts for the smooth installation of the system Confidential the client site.
• Prepared test plans and participated in testing the entire interface with Oracle Concurrent Manager. Ported the software from HP-UX to Sun Solaris.
• Prepared a design document and integration strategy analysis document according to CAI standards ( AIM methodology ).