SUMMARY:

• Having Enriched experience as an ERP Analyst, Software Designing, Analyzing, Configuring, Setups, Testing, Gap Analysis, Design, Delivery and Development in Financial, HRMS, Supply chain, Logistics and Distribution modules.
• Provided strategic and operational leadership in building e - business applications in Financial, Distribution and Supply Chain areas for many companies.
• More than 12 years’ experience as an ORACLE Applications Consultant. Out of which eight years form Confidential s as a Senior Principal Consultant.
• Worked with Accenture, Bearing Point Through Confidential . Responsible for Designing, Developing, Deploying various RICE Elements.
• Worked in Federal Financials and attended Oracle for Federal Financials when working with Confidential .
• Participated in all aspects of Software Development Life Cycle and Production troubleshooting, Software Testing. Excellent communication and interpersonal skills.
• Worked with Business users while performing functional setups in Accounts Receivables, TCA, Accounts Payables, General Ledger, Project Accounting, Fixed Assets, Inventory, Purchasing, Order Management and Advanced Pricing modules.
• Effective communicator and energetic team player with excellent business and interpersonal skills.
• Extensive exposure in ERP implementation and upgrades using Oracle Applications 12i (12.1.1, 12.1.3), 11i(11.5.10,11.5.9) comprising Functional and Technical areas in Oracle Purchasing, Oracle Inventory, Order Management, and Oracle General Ledger, Oracle Account Payables, Oracle Receivables, Oracle HRMS, Fixed Assets, Project Accounting, XML Publisher.
• Developed Several MD070s, MD 050s, TE.20, TE.40, TE120, MD120s, and BR.100s using AIM methodology.
• More than 10 Years of experience in Oracle eBusiness Suite particularly the Oracle financial modules. Some of the Financials Clients include GE Capital, Credit Lyonsis.
• Responsible for Implementing the First MRC (Multi Reporting currency) Project in Comvese Network Systems. Deployed several Global systems.

TECHNICAL SKILLS:

ORACLE Financials: Accounts Receivables (TCA Architecture), Accounts Payables, General Ledger, Cash Management, Fixed Assets and Project Accounting.

ORACLE Supply Chain: Oracle Purchasing.

ORACLE Manufacturing: Order Management, Shipping, Advanced Pricing, Inventory, and Costing, Bill of Materials, MRP and Work in Progress.

ORACLE CRM: Oracle Contracts, Oracle Lease Management, Oracle Collections, Oracle I-Store, Oracle Sales online, Oracle Tele Sales and Customers Online, Oracle Collections and Install Base.

Oracle Application Tools: Oracle Work Flow, XML Publisher, Oracle XML Gateway, BPEL (Oracle Fusion Middle Tier).

Database: Oracle 10G, Oracle 9i, Oracle 8i (8.1.7.1.0/8.1.6 ), 8.0.5 / 7.0xDevelopment Tools: Oracle Designer 2000, Oracle Developer/2000 (Forms6i, Reports 6i) for C/S and Web (Forms 6.0/5.0/4.5, Reports 6.0/3.0/2.5), PL/SQL, Pro* C.

ORACLE Utility Tools: SQL * Trace 8.0x (tkprof), Explain Plan, SQL * Loader 8.0/7.0x, Oracle Workflow, Oracle Applications TRS, PVCS

O/S: Oracle Web Application Server 3.x, HP-UX 9.0/10.0x/11.0, Sun Solaris 5.6 /2.2/2.4/2.5 , SCO-UNIX 5.0, and Windows 3.11/95/98/NT 3.51/4.0/2000.

Hardware: HP 9000 Series, Dell 4000 Servers with Raid Technology, Compaq Pentium, and IBM Compatibles.

3rd Party Tools: Embarcadero s DBArtisan 4.02/5.0x,Quest s SQL Navigator 2.2/3.0d2,TOAD 7.0.4.26/6.1.3/7.0.4.26 , Clearquest, Harvest.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Responsibilities:

• Developed various benefits extracts like UHC medical and Delta Dental Files.
• Developed the 401k file transfers to the vendor Fidelity.
• Involved in Pay methods and W4 conversion.
• Designed and developed various core HR reports like Roster report, new Hire report. Terminated employees.
• Developed various XML Publisher reports like Roster, New Hire, and Termination Reports.
• Involved in Grade Structure changes completely.
• Work involves in Financials, Supply chain and HCM Modules.
• Involved in setting up the new Business Group.
• Involved in setting up the New Ledger for Ireland Business group.
• Involved in changing the COA as per the new requirements. This involves including a new segment for Intercompany transaction, Changing the length of the segment as required.
• Work involves setting up a new operating unit for Ireland Division.
• Did the major customization in suppliers 1099 that involves sending the 1099s as per the business requirements.
• Did the Supplier, Supplier sites conversion.
• Converting the customers using the HZ PUB APIs
• Set up the new invoice custom types.
• Developed invoice and payments custom register reports as per the Business requirements.
• Involves testing the custom reports and standard functionality reports for the two operating units.
• Did the Invoice aging analysis reports as per the Business requirements.
• Developed the Unix Shell scripts to transfer the data for bank server.
• Developed various custom reports in Purchase, Inventory modules.
• Involved in closing the purchase orders that are old using the standard APIs.

Confidential, NY

Responsibilities:

• Work involves upgrading the system from 11i to Release 12.1.
• Identifying the existing customizations and replacing them using the new functionality that exists in R12.
• Identify the Gaps between their existing process and to-be process. Prepare MD.50, MD.70s using AIM Methodology and get the approval from the Key Business users and the Program management.
• Documentation of all custom process. Created SQL scripts to speed up and assist in business flow testing.
• Document the Interfaces, Report requirements and obtain the approval from the Global change.
• Preparing MD70s for the Technical Design documents using AIM Methodology.
• Preparing Test Documents (TE.020) for Unit and Integration testing and Install documents MD.120s.
• Extensively worked in AP, AR, GL, FA and HRMS Modules.
• Converting the customers using the HZ PUB APIs.
• Involved the process in customer merge, When they current client acquired many companies.
• Defined and created custom materialized views for the customer relationships. These relationships allow the customers to be eligible for various discounts based on the relationship.
• Extensively used the Cash Receipts APIs that is more flexible for the current business needs than the traditional LOCK box.
• Developed the UNIX shell scripts to ftp the positive pay files to bank server.
• Developed custom reports business users use to see the checks that are sending to suppliers before sending the file to Bank.
• Converted the suppliers, supplier sites and contacts.
• Converted the Open Invoices and developed a process to load the invoices every month from the feeder systems.
• Responsible for the supplier merge process in Payables after the company acquired new companies.
• Employees
• Address
• Phones
• Assignments
• Salary Details.
• EIT (Extra Information Types)
• SIT (Secure Information Types)
• Developed Absence Analysis, Negative Balances, Missing time card reports.
• Developed the Time card Import process to import time cards on regular basis.
• Developed several inbound and outbound interfaces. Some of them are JPM Outbound interface, Delta Dental outbound interface.
• Sending the automatic notifications about the direct deposits by Emails using workflow.
• Transferring the journals automatically into General Ledger.
• Developed several XML Reports as per the Business requirements.
• Designed and developed various Discover reports for Business users

Confidential, NEW YORK, NJ

Responsibilities:

• Implemented the Oracle Sourcing system.
• Involved in Release 12 Upgrade.

Confidential, Fairfield, NJ

Responsibilities:

• Identify the Gaps between their existing process and to-be process. Prepare MD.50, MD.70s using AIM Methodology and get the approval from the Key Business users and the Program management.
• Preparing Test Documents (TE.020) for Unit and Integration testing and Install documents MD.120s.
• Converting the customers using the HZ PUB APIs.
• Involved the process in customer merge, When they current client acquired many companies.
• Defined and created custom materialized views for the customer relationships. These relationships allow the customers to be eligible for various discounts based on the relationship.
• Extensively used the Cash Receipts APIs that is more flexible for the current business needs than the traditional LOCK box.
• Migrated employees and all related details into Oracle HRMS and Payroll.
• Developed various custom functions which are used in the payroll calculation.
• Developed various customizations as per the business needs that are embedded using APIs user hooks.
• Resolved various HR security issues
• Migrated data into Oracle HRMS SIT’s, qualifications, EITs, Previous Employments etc.
• Implemented Java Concurrent Program to parse the CSV files. This was implemented using string tokenizer in Java.
• Designed and developed various Discover reports for Business users.
• Creating the events in Oracle Projects to produce appropriate accounting using standard billing extensions.
• Developed a new form to enter the month end balances in PA adjustments
• Developed a process to distribute the total Debit in Inventory to various (ODC, Overhead...) cost elements. This process involves transferring the balances to GL Accounts.
• Designed and developed various Discover reports for Business users.
• Developed the UNIX shell scripts to ftp the positive pay files to bank server.
• Developed custom reports business users use to see the checks that are sending to suppliers before sending the file to Bank.
• Converted the suppliers, supplier sites and contacts.
• Converted the Open Invoices and developed a process to load the invoices every month from the feeder systems.
• Responsible for the supplier merge process in Payables after the company acquired new companies.
• Responsible for converting the Standard Purchase Orders from BAAN to Oracle.
• Responsible for converting the Blanket Purchase Orders.
• Identified the need for the new flexfields for storing the data like Government contract, Government priority, manufacturing .
• Extensively used the oracle purchase standard interface tables (PO headers interface, po lines interface and requisition interface tables).
• Did the receipts for the last six months as part of the purchase orders conversion.
• Customized the PO Account generator workflow to change the department segment as per the Business needs.
• Customized the iprocurement purchase order xml info as per the requirements.
• Responsible for Converting the preprinted stationary reports into to the BI Publisher (XML Publisher) reports using the Oracle BI Publisher tool.
• Extensively used the OA Frame work using the J developer in customizing the forms.
• Developed a custom form that allows entering the free supply items for a corresponding machine. These supplies will be added automatically to the order when order is booked.
• Extensively used the Oracle workflow to customize the Order header and order line level workflows.
• Designed and developed the price list upload that includes custom forms to correct the errors, profile options for key business users to ignore error records and upload price lists. Automatically send the emails using the Workflow notifications after upload.
• Research the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR’s on daily basis through Metalink.

Confidential, Hartford, CT

Techno Functional Consultant

Responsibilities:

• Involved in Design and development of custom Workflows for Order Management (Doing Adjudication, TCA Validation, I-Payments Processing through APIs, Shipping Interface, Calling the Drug Substitution).
• Involved in providing the complete solution for getting the Orders from the Captiva and File Net.
• (Client gets the Orders in mail and the mail orders will be scanned and stored in File Net and Captiva. Design involves creating tasks to create orders, retrieving the Images automatically to enter the order information).
• Involved in providing the XML Publisher solutions for reporting purpose.
• Developed the customization in Purchasing to update the Blanker Purchase Orders Price.
• Designed the Logic to automatically canceling the Order Line in refill too soon situation depending on the predefined criteria.
• Extensive experience with JDeveloper creating Web Services, J2EE (MDBs, EJBs, etc). Calling PL/SQL Procedures and Functions from JDBC and Web Services generated from PL/SQL packages.
• Extensive experience using Oracle Types in JAVA code.
• All of the PL/SQL code will need to be written to use the following components of the Oracle E-Business suite: Order Management, Inventory, iPayments, AP, AR, GL, Shipping, task management, JTF API experience, Oe order pub API experience, Hz APIs, In depth HZ (TCA).
• Involved in Items Update based on the Legacy system Ex: Fixed Lot Multiplier, Min Max OR Max min Qty.
• Preparing BR.100, MD.50, MD.70 AND TE.020, TE.040 FOR the above documents.

Confidential, Quincy, MA

Technical Lead / Programmer / Analyst

Responsibilities:

• Work involves Setting up the Payables, Purchasing modules.
• Involved in Designing and developing the process to automatically create the Quotes and Opportunities using the standard APIs. Mapping the Legacy systems workflow to the Oracle Tasks. Setting up the task information in DFF’s. Creating the tasks and assigning them to the sales people as per business rules using the standard APIs.
• Involved in creation the virtual private database using the policies for Oracle Receivables.
• Extensively used the Business events and customized the Workflows (Approval Management Engine) to
• Used J Developer to customize Objects in Quotes module.
• Preparing MD.50, MD.70 AND TE.020, TE.040 FOR the above documents using AIM.

Confidential, Long Island, NY

Technical/Functional Lead

Responsibilities:

• Work involves identifying the legacy systems of Canon. Mapping them with relevant oracle modules. Identifying any major gaps. Identify the no of resources on shore/ off shore for each module.

Confidential, NJ

Functional/Technical Lead / Programmer

Responsibilities:

• Assets Additions Based on The Project And Category
• Assets Additions Based on the PO And Category
• Depreciation Activity detail by Category and Department.
• Cost Activity detail by Department and Category.
• Preparing MD.50, MD.70 AND TE.020, TE.040 FOR the above documents using AIM.

Confidential, DANBURY, CT

Techno/Functional Lead

Responsibilities:

• Designing of Interface’s Implementation Strategy for all Financial and OLM modules.
• Developed a User-friendly QA Check process for all interfaces.
• Developing Initial Process flow design of Contracts Import.
• Design the Property Tax Management System inbound and outbound interface from OLM to PTMS.
• Involved in setting up and testing the consolidated invoice printing with respect to GE Business needs.
• Designing and developing Prototype Data Migration Process to test load legacy sample data.Oracle Lease Management Integration with SIEBEL:
• Involved in various data mappings for various interfaces from SIEBEL to Oracle and Oracle to SIEBEL.
• Coordinating with Client IT Team and user groups to meet and get the Functional Specifications approved for each task.
• Involved in sending the delinquent account details to the Siebel system on a real time basis. The service requests from Siebel will be sent to Oracle on a real time or batch process based on the requirements.
• The comments from OLM will be sent back to SEIBEL as an outbound.
• Developed PL/SQL Packages to Validate the Legacy Data and derive the data as required before loading into the Interface tables.
• Developing SQL Loader control scripts to process the legacy data and to load into Temp Staging Area.
• Used PVCS software for version control. Used the J developer to develop the Customizations. Involved in designing the customizations using Java Objects.
• Preparing BR.100, MD.50, MD.70 AND TE.020, TE.040 FOR the above documents using AIM.

Confidential, PLANO, TX

Techno/Functional Lead/ Analyst

Responsibilities:

• Identify the client customization and fit them into the oracle applications 11i Functionality if applicable.
• Involved in setting up the multi org, which is part of consolidation the instances.
• Designing the Strategy for the Upgrade for the existing custom systems, Report, Forms and all other custom Objects.
• Eliminated the customizations by bringing the Item, Cost Adjustments in OPM By using the Standard API’s.
• Developed the Strategy to upgrade, Test the PHL (Purchase Hedge Ledger System) from 11.0.3 to 11i.
• Coordinating with Client IT Team and user groups get the Functional Specifications approved for each task.
• Researching and analyzing the QP and OM legacy volume transactions and possible impact on one time Conversion Process under existing data transport mechanism.
• Developed Generic Packages using PL/SQL to build flat files to manage transmissions across Legacy and Oracle Systems.
• Developed Flexible PL/SQL Scripts/Packages for Registering the Forms, Reports, Value Sets, and Flexfields. This methodology ensures no manual error while registering the custom reports, forms, value sets, and Flex fields across the Instances (Development, Test, QA Test Instance).
• Developing Documentation Templates such as Data Mapping, Functional, Technical and Testing.
• Involved in Post Production support after 11i upgrade.
• Involved in Developing the Custom Forms (EX: Expense Approvals with various search criteria).
• Involved in developing the Custom Reports (Ex: If the API fails in validating the data the report will run automatically based on the status).
• Responsible for Implementing the Credit Card Transactions and Payments in Payables Module.
• Preparing BR.100, MD.50, MD.70 AND TE.020, TE.040 FOR the above documents using AIM.

Confidential, Buffalo, NY

Technical/Functional Lead / Analyst

Responsibilities:

• ORF Implementation of Oracle Financials Release 11: This project was done for Carleton Technologies. Carleton Technologies involved in the Business of Commercial Aircraft, Military Aircraft Life Support and Pneumatic Systems, Space, Guided Weapons, Marine Products, Diving Systems and Package Testing. They converted from CODA And CINCOM To Oracle Applications. Client went live with 16 modules of Oracle Applications.
• Did major customizations to oracle time and labor entry form.
• Involved in the data extract from Oracle Time and labor to ADP. Responsible for transferring the data from OTL to PA.
• Responsible in design and development of in bounds, out bounds and setting up the lock box as per the business needs.
• Customer data, invoices are the out bounds and receipts are the inbounds for the client.
• Standard lock box will apply the receipts to the corresponding invoices in the system.
• Positive Pay Customization In AP (Accounts Payables): The standard positive pay won’t satisfy the client business needs. So a new report has been developed as per the client requirements. This report gives the total checks issued in a given date range. Generally client runs this report every week usually on Fridays. After running the report client will run the extract file. All columns have been formatted the way bank has requested. When ever user runs the extract the other concurrent program will get run automatically and the output file will be moved in the requested directory with the corresponding name. User will send this flat file to the bank.
• Responsible for creating the events in Oracle Projects to produce appropriate accounting using standard billing extensions.
• Developed a sales gross margin analysis report that gives item sold price and manufacturing cost for that item at that transaction level.
• Developed the new Customer collection Summary report.
• Developed the Purchase summary report for Projects.
• Developed a new form to enter and update the Government parts that corresponds to the Carleton inventory parts.
• Developed a new form to enter the month end balances in PA adjustments.
• Customized the WIP TRANSACTIONS form to meet the quality requirements.
• Developed several adhoc reports as per the business needs using the Discoverer tool.
• Did the Average cost update in Inventory for certain cost elements.
• Responsible customizing the following work flows.
• PO Notification workflow.
• Based on the order type workflow will function differently.
• Based on project type the Accounting will use different value sets in the expense approval process.
• Involved in preparing various materials and giving for the end users.
• Involved in user in shipping for Trip and Delivery planning, Pick Release and Ship confirm.
• Involved in IT in Oracle PL/SQL, Unix shell Scripting, Forms and reports.
• Preparing BR.100, MD.50, MD.70 AND TE.020, TE.040 FOR the above documents.

Environment: Sun Solaris V5.6, UNIX, Oracle Financials 11.0.3, Oracle 8i, PL/SQL, Developer/2000, Star Team

Confidential, NYC

Functional/Technical / Analyst

Responsibilities:

• Performed Functional setups for GL Module.
• Dynamically generate the Code Combinations by setting up the valid validation rules.
• Did the performance tuning for the GL Import as needed.
• Did the whole module testing from end to end with the Business users.
• Preparing BR.100, MD.50, MD.70 AND TE.020, TE.040 FOR the above documents using AIM.

Confidential, MA

Functional/Technical / Analyst

Responsibilities:

• Set up the AR Module with new TCA Architecture model.
• Converting the customers using the TCA Architecture using the HZ PUB APIs.

Confidential, Westborough, MA

Team Lead/ Programmer / Analyst

Responsibilities:

• Designed and Developed Interface program to extract data for ABC Collection agency. This includes building the custom reports, custom tables and retrieving the data based on the late payments and based on the amount due.
• Developed new forms and reports for Inventory and Order Entry modules and modified them as per the user request.
• Involved in the whole cycle of testing, fixing the QA Problems for the order entry module.
• Developed the complex MRP reports that are critical to go live.
• Responsible for the extracts that need to be created for Data ware house (BRM Application) from the Order Entry module.
• Prepared corresponding MD70s and MD50s (Functional, Technical design Documents) for the above tasks using AIM (Application Implementation Methodology) .

Confidential, Boston, MA

Responsibilities:

• Involved in the Oracle I-Store implementation. Setting up the Order Entry, Purchase, Receivable modules and preparing the BR100s for the setups.
• Work involves optimizing the queries to find the products with various search criteria.
• Worked closely with the Oracle development team to fix the bugs.
• Total integration test between Oracle Applications (Receivables, Order Entry) and the client Web Store.

Confidential, Syracuse, NY

Responsibilities:

• Involved in the Oracle I-Store implementation. Setting up the Order Entry, Purchase, Receivable modules and preparing the BR100s for the setups.
• Work involves optimizing the queries to find the products with various search criteria.
• Worked closely with the Oracle development team to fix the bugs.
• Total integration test between Oracle Applications (Receivables, Order Entry) and the client Web Store.

Confidential: Waltham, MA

Responsibilities:

• Client has a major issue unable to merge the customer. Since the nature of business is to acquire companies and to merge the customers, this is critical to do before 11i upgrade.
• Worked with client IT people. Build some indexes on table RA CUSTOMER TRX ALL. Worked with Oracle support raising this as a Priority one TAR. Resolved the issues. Documented the above process and gave it to the client for .
• Client business needs to do over shipments if required. Prior to 11i OE allows only under shipments but not over shipments.
• Designed and developed a solution to allow the over shipments in Order Entry module Customized the standard oracle shipping form to do this.

Confidential

Responsibilities:

• Set up of Inventory Organizations, Sub inventories, Item Sub inventory relation ships, Transaction Sources, shipping networks to enable Inter Organization Transfers.
• Did the Daily rates conversion in General Ledger. Reuter’s transfers for rates every night at 12:10 AM and the rates will be loaded into the Oracle Conversion rates table accordingly. Any error will be sent to the business users immediately.
• Client uses a separate agency (Click Travel) to employee travel. Responsible for bringing the click travel system invoices into Oracle Payables.
• Responsible for Integration of their external payroll system to oracle Financial applications. This involves bringing the data into GL and AP. Developed the corresponding custom reports to view the data before transferring into Financial modules.
• Developed the entire customization for Budgeting. This includes developing two custom forms. The form will validate the various budget rules and generates custom report if the validation fails from the form. If all the validations will pass then the data will be loaded into interface tables and the interface program can be run from the custom form upon user request.
• Responsible for go live support and post production support.
• Defined the several Descriptive Flexfields as required for the customizations.
• Responsible for bringing the WEB Requisitions into Oracle Purchasing module.
• Developed the custom reports that give the values both in US dollars and Israel shekels.
• Performed functional system testing on the Accounts Payable (AP), General Ledger (GL), and Accounts Receivables modules of Oracle Financials application, due to Comverse Technologies customizations to ensure system integrity prior to Y2K testing.
• Responsible for the Comverse IT team in Oracle Applications both Functinally and Technically that includes sql*plus, Forms, PL/SQL and Reports.
• Did the data mapping for WANG (COBOL) legacy system to Oracle Interface tables.
• Loaded the legacy data into staging tables, using the sql*loader tool. Did the validations of the data using PL/SQL packages and the valid data has been loaded into oracle interface tables.
• Customized existing forms and reports. Developed several custom reports as per the business needs.
• Designed, Developed and Implemented the custom forecasting system in Oracle Financials in Version 10.4.6 in Confidential Ltd., Singapore .

Confidential

Responsibilities:

• Cement Marketing System
• Materials Management System
• Payroll System
• Leave Maintenance System