SUMMARY:

• An experienced ERP consultant with over 10.5 years in Oracle Applications
• Extensive techno - functional experience in various modules includes - Accounts Payable, General Ledger, Sub ledger Accounting, Fixed Assets, Project Accounting, Accounts Receivables, OTL and Payroll
• Expertise with all the phases of a project including Requirement analysis, Customization, Implementation, Design/Development, Testing and Production Support on Oracle E-Business Suite applications
• Involved in various interface design, development, customizations, Error Handling & Support.
• Experienced in various functional setups such as Chart of Accounts (COA) setup, Organization setup (Business group, Operating units, and Inventory organizations), Fixed Assets setup (Book Controls, Asset Additions, and Depreciation Calculations), Purchasing Options, Financial Options, and Receiving Options in various module.
• Extensive experience in System Administration activities like defining Responsibilities, Users, setting profiles, Flexifields, Forms, Reports, managing concurrent programs and providing support to Apps end users.
• Expert in Defining Flexfield segments and value definitions for GL, FA and HRMS.
• Extensive experience in developing Interface/Conversion programs to import data from legacy systems to Oracle Applications using PL/SQL, SQL Loader, UTL File etc
• Participated in CRP’s with Business users from different countries on different modules like GL, AP, FA and Security modules as part of end to end business flows.
• Excellent programming skills in stored procedures and Oracle (PL/SQL including Triggers and Functions) and expertise in database Performance Tuning by implementing parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding indexes.
• Excellent working knowledge in designing Technical and Migration documents using AIM Methodologies (MD50, MD70, MD120, CV40 AND CV70).
• Hands on experience with Toad, PL/SQL developer, Forms 9i, Reports 9i and XML publisher
• Experience working as a mentor and also part of a team, ability to articulate and communicate ideas, problems/ solutions and user .
• Worked in multi-org & multi-lingual environments.
• Worked on various TAR / SR s with Oracle support and follow up the same.
• Proficient in defining, communicating and fulfilling the project’s goal and breaking complex issues into manageable parts.
• Work collaboratively with team members to achieve common goals, while maintaining responsibilities and commitments.

TECHNICAL SKILLS:

Languages/Os/Database/tools: SQL*Plus, Toad, PL/SQL Developer, XML Publisher, SQL*Loader, ORACLE Reports 6i/9i, ORACLE Forms 9i/10g, ORACLE Workflow, Builder 2.6, SQL, PL/SQL, UNIX Shell scripting, C, Core JAVA, Windows 98/XP, Windows NT 4.0/2000 Server/Workstation, UNIX SVR4, Sun Solaris V5.6, AIX, MVS, PVCS Tracker, MS Access, MS Project, MS Word, MS Excel, MS Power point, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Brinckerhoff, NY

Techno-Functional Analyst

Responsibilities:

• Developed Project Accounting to Accounting Payables to General Ledger refresh package, running on Daily and Monthly GL Date basis, which will be used for the Data ware house team.
• Developed Mail notification system to the user and user group, which will trigger for any exception in the package and for any Concurrent program that fails / abort / terminates.
• Updated ADHOC upload package from 11i to R12, which will conduct various Validations on the Invoice data and inserts the successful records into the Staging table.
• Updated various Request sets for the BofA and FEMA Invoice upload process, with Step1 - Run Open Interface Import, Setp2 - Errors Clean up (from AP Interface Rejections table) and Step3 - AP Invoice Batch Reconciliation Report to meet the R12 requirements.
• Developed various adhoc queries in General Ledger like GL Balances with Entered and Accounted Currency, YTD Balances and on Translated Balances with Ledger Info.
• Updated various procedures and functions from 11i to R12 in Project Accounting on Event Revenue, Draft Revenue, and PA Cost Distributions. Also developed reports on the PA Cost Distribution lines to General Ledger thru SLA tables (using XLA Transaction Entities, XLA Events, XLA Headers, XLA Lines and XLA Distribution Links).
• Developed custom package to create AR Invoices (Draft and Retention invoices) thru Project Accounting as part of Converting the legacy invoices data into R12.
• Developed various SQL queries and extracts on Projects, Agreement / Funding, Tasks, Revenue Budget, Cost Budget, Expenditure Items, Draft invoices and Retention Invoices to validate the data against the legacy system data.
• Created Concurrent program to generate Positive pay files on daily basis and sent it to external systems (banks) thru host program.
• Updated the Fixed Assets Packages from 11i to R12 on Asset details and Asset Depreciation to meet the end user needs.
• Involved in Concurrent Program Creation & Registration, Request Set Creation & Registration (these request sets were created for various interfaces & reports).
• Developed adhoc queries on Key Flex fields, Descriptive Flex fields & Value Sets Maintenance & recompilation
• Worked on various SCR’s in different modules - PA, SLA, AP, GL, AR and FA.

Environment: TOAD 11.5, Oracle 10g, Oracle Applications R12 (12.1.3), PL/SQL, Forms/Reports 10g, PVCS (version control software), Workbench, HP PPM Workbench 7.5

Confidential, NJ

Techno-Functional Analyst

Responsibilities:

• Developed Technical specs for various Reports, Interfaces / Conversions based on the Functional Specs and conducted Reviews with the Business Users
• Imported the Journal Entry Transactions into GL INTERFACE table using SQL*Loader and successfully created the Journal Entry's in General Ledger (GL) using Journal import.
• Developed various reports in General Ledger like GL Balances with Entered and Accounted Currency, YTD Balances and on Translated Balances with Ledger Info.
• Involved in various interface design, development, customizations & Support: GL Value set import, GL X-Validation rules import program, GL Code Combinations (Chart Of Accounts) import program.
• Worked on Invoice inbound interface.
• Developed various report in Accounts Payables on Invoices, Invoices lines, Distributions and Payments. Also developed reports on the Invoice and Payment transactions that are posted to General Ledger thru SLA tables (XLA Headers, XLA Lines and XLA Transaction Entities).
• Involved in developing various AP Interface / conversions like Supplier conversion, Payment Conversions, Ariba Invoice Import, Vendor site creation etc.
• Developed various reports in Fixed Assets on FA Asset detail, FA Disposed, FA Depreciation calculation, FA Book Open/Close, FA Transaction History. Also on the Book and Depreciation transactions that are transferred to GL thru XLA tables.
• Involved in developing various Interface / Conversions like FA Asset Detail, FA Asset Retire, FA Currency convertor, FL GL Reconciliation
• Successfully designed and implemented the Purchase Orders Open Interface. Activities involved creation of control file, porting PO HEADERS, PO LINES into the PO HEADERS INTERFACE and PO LINES INTERFACE tables and then used Import Standard Purchase orders concurrent program to import the data into the Oracle base tables.
• Developed Reports on AGIS transactions like AP/AR Netting, AP Aging, AR Aging reports for International users.
• Involved in Concurrent Program Creation & Registration, Request Set Creation & Registration (these request sets were created for various interfaces & reports).
• Key Flex fields, Descriptive Flex fields & Value Sets Maintenance & Recompiling

Environment: TOAD 10.6, Oracle 10g, Oracle Applications R12 (12.1.3), PL/SQL, SQL* Loader, Forms/Reports 10g, SQL*Plus, PVCS (version control software), Workbench, HP PPM Workbench 7.5

Confidential, KY

Techno-Functional Analyst

Responsibilities:

• Gathered the requirements from Business owners and Users group (with both Oracle applications group and Legacy systems group)
• Customized in Requisition Approval workflow, Purchase order approval workflow, Create PO documents, Account Generator workflow, Expenses workflow and made sure that customizations were preserved from Oracle Patches and Oracle upgrades as well.
• Programmed to close stale Standard purchase orders and Blanket releases based on business requirements.
• Customized iprocurement, iExpenses, isupplier, HRMS self-service applications web pages (OA Framework) by using jdeveloper and deploying the same.
• Customizations in Purchase order reports.
• Worked on AP Invoice Upload interface to match to Purchase Orders.
• Designed, developed and supported the AP Invoice Upload Interface (vendors which were not exist will be created also) for the invoices which will be coming from different suppliers.
• Vendor site data conversion from Old Operating unit to New Operating unit as a part of General Ledger Conversion Project.
• Involved in General Ledger conversion project which involved in building of new interfaces as all Legacy systems pointed/redirected to Oracle General Ledger rather than to Mainframes.
• Created custom responsibilities required for General Ledger implementation
• Involved in Converting Assets from One GL Set of Books to other GL Set Of Books as a part of GL Conversion project.
• Customized FA Account Generator workflow to generate accounts based on FA Books
• Implementation of iExpenses Accounting Client Extension in order to meet the Fruit specific accounting requirements as Fruit uses accounting stuff from Mainframes.
• Created Personalizations and migrated personalizations from one instance to another instance.
• Worked on many customizations in Confidential schema in order to get the data from Legacy systems which will be used in various places in Oracle applications.
• Worked on the resolutions of SR’s that are raised as part of critical production issues and follow-up the same until the issue is solved.
• Reported to the Project manager regarding the progress of the production issues.

Environment: Oracle 9i/10g, Oracle Applications R12, Purchasing, procure 2 pay, iProcurement, IExpenses, General Ledger, Payables, Oracle Workflow, PL/SQL, SQL* Loader, Reports 6i, SQL*Plus, jdeveloper

Confidential, CA

Techno-Functional Analyst

Responsibilities:

• Gathering the requirements from Functional owners / Users, Converting them into functional specs and again converting them into Technical specs and develop and document the same.
• Raising TAR/SR s with Oracle and follow up the same.Workflow customizations:
• Designed and developed various workflow customizations: Account Generator, Requisition Approval, Create PO, PO approval workflows were extensively customized to in corporate new business validation rules, process changes, and enhancements.Interface customizations:
• Involved in various interface design, development, customizations & Support: Blanket Inbound (PDOI), PO/PO Change Outbound & Receipts Outbound Interface, Item Import Interface (Created Item templates), Item Outbound interface, Projects Import Interface, Requisitions Import Interface, Suppliers Outbound Interface, Blanket Outbound interface, HR Import interface, GL Value set import, GL X-Validation rules import program, GL Code Combinations( Chart Of Accounts) import program.
• Worked on GL interface, Importing Legacy Journals in General Ledger using SQL Loader and Journal Import.
• Worked on Invoice inbound interface.
• Designed and developed new interfaces:
• Blanket Inbound (PDOI) interface which loads blankets created by users in a web based tool in one of the legacy systems.
• Currency Exchange Rate Interface which loads currency exchange rates from corporate office into Oracle Applications Tables.
• Involved in Concurrent Program Creation & Registration, Request Set Creation & Registration (these request sets were created for various interfaces & reports).
• Key Flex fields, Descriptive Flex fields & Value Sets Maintenance & Recompilation.
• Creation of Profile Options using Application Developer and assigning profile option values using System Administrator and also involved in creation of Alerts and scheduling them. Migration of AOL objects using Chain Link tool.Report Customizations:
• Purchase Order Print Report, Buyer Requisition Action Required Report, Over shipments Report, Purchase Order Detail Report in Purchasing Module
• Developed several custom reports in Purchasing Module

Environment: Sun Solaris V5.6, Oracle 9i/10g, Oracle Applications 11i (11.5.9 / 11.5.10 ), Purchase, procure 2 pay, iProcurement, Inventory, Payables, Oracle Workflow, iSupplier, PL/SQL, SQL* Loader, Reports 6i, SQL*Plus, PVCS (version control software).

Confidential

Functional Analyst / Support

Responsibilities:

• Involved in gathering the new requirements / enhancements for the RL1 and RL2 reports according to the CA government
• Identification of gaps and their work around and customization
• Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, and Detailed Design Documents.
• Developed Business flow document for the RL1 and RL2 reports by analyzing the business requirements.
• Developed the Fast formula in defining the Box W and Box V values for the RL1 and RL2 reports based on the Canadian government requirement
• Responsible for setting up the Canadian localization on Oracle HRMS module.
• Done the setup for the RL1 and RL2 reports on various builds.
• TAR Resolution for Bugs reported
• Interacted with programmers to identify and resolve technical issues.
• Participated in Walkthrough and defect report meetings periodically (CRP’s).

Environment: Oracle Apps 11.5.10.2 (PAY, HR), SQL, Developer 2000, UNIX, TOAD

Confidential

Functional Analyst / Support

Responsibilities:

• Involved in gathering the new requirements / enhancements for the reports according to the US government.
• Developed Business flow document for the OTL with Payroll by analyzing the business requirements.
• Responsible for setting up the entire Business flow for the OTL with Payroll on Oracle HRMS module.
• Involved in defining the Time cards, Approving the Time cards, Elements and attaching them to Employees and finally verifying the SOE.
• Interacted with programmers to identify and resolve technical issues.
• TAR Resolution for Bugs reported
• Participated in Walkthrough and defect report meetings periodically (CRP’s).

Environment: Oracle Apps 11.5.10.2 (OTL, PAY, HR), SQL, Developer 2000, UNIX, TOAD

Confidential

Functional Analyst / Support

Responsibilities:

• Responsible for setting up all the above stated USHR reports on Oracle HRMS module.
• Involved in gathering the new requirements / enhancements for the reports according to the US government
• Identification of gaps and their work around and customization
• Developed Business flow document for the Confidential .
• Done the setup for the EEO reports on various builds to make sure the functionality of the reports should not be broken.
• TAR Resolution for Bugs reported
• Interacted with programmers to identify and resolve technical issues.
• Participated in Walkthrough and defect report meetings periodically (CRP’s).

Environment: Oracle Apps 11.5.10 (PAY, HR), SQL, Developer 2000, UNIX, TOAD

Confidential

Functional Analyst / Support

Responsibilities:

• Responsible for setting up all the above stated USHR reports on Oracle HRMS module.
• Involved in gathering the new requirements / enhancements for the reports according to the US government
• Identification of gaps and their work around and customization
• Developed Business flow document for the Confidential .
• Done the setup for the Vets reports on various builds to make sure the functionality of the reports should not be broken.
• TAR Resolution for Bugs reported
• Interacted with programmers to identify and resolve technical issues.
• Participated in Walkthrough and defect report meetings periodically (CRP’s).

Environment: Oracle Apps 11.5.10(PAY, HR), SQL, Developer 2000, UNIX, TOAD

Confidential

Functional Analyst / Support

Responsibilities:

• Responsible for setting up the Confidential on Oracle HRMS module.
• Involved in gathering the new requirements / enhancements for the report according to the US government
• Developed Business flow document for the EO Survey reports by analyzing the business requirements.
• Done the complete setup in defining the Payroll, Elements, attaching them to Employees and running the Confidential with different scenarios.
• Developed the Fast formula in defining the ‘Promotions’ for an employee when there is a change in Grade / Position for the employee.
• TAR Resolution for Bugs reported.
• Interacted with programmers to identify and resolve technical issues.
• Participated in Walkthrough and defect report meetings periodically (CRP’s).

Environment: Oracle Apps 11.5.10 (PAY, HR), SQL, Developer 2000, UNIX, TOAD

Confidential

Functional Analyst / Support

Responsibilities:

• Responsible for setting up the EVS report on Oracle HRMS module.
• Involved in gathering the new requirements / enhancements for the report according to the US government
• Developed Business flow document for the EVS based on the Functional documents from the US government.
• Ran the EVS request to get the EVS report on various builds to make sure the functionality of the reports should not be broken.
• TAR Resolution for Bugs reported
• Interacted with programmers to identify and resolve technical issues.
• Participated in Walkthrough and defect report meetings periodically (CRP’s).

Environment: Oracle Apps 11.5.10(PAY, HR), SQL, Developer 2000, UNIX, TOAD