SUMMARY

• Having over 13 years of IT experience with 10 years in Implementation of Oracle EBS projects and its Initiatives, Customization, Testing, Go to Live, End user training, UAT and production support which includes General Ledger (GL), Accounts Payable (AP), Payments, Accounts Receivable (AR), Cash Management (CE), Fixed Assets(FA), Purchasing Cycle, I - Procurement(I-Proc), I-Expense, Inventory, Project Billing, Project Cost.
• Expertise in Oracle E-Business Suite CRM and SCM modules - Order Management, Service Contracts, Inventory, Install Base, Field Service, Depot Repair, CRM Foundation, Sales & Marketing.
• Competent in full understanding of the functionality of core Oracle Financial Modules (GL, AP, AR, CE, FA, I-Proc, I-Exp) and their interplay in the application set-ups and overall accounting structure of an organization with its sub organizations.
• Extensively working experience on the full life cycle implementation of Procure to Pay cycle (P2P) and Order to Cash cycle (O2C).
• Generating SLA reporting and Customizing FSG Financial Reports and other non seeded reports, and other financial reports and analytics
• Conducted requirement gathering analysis, documentation with help of Application Implementation Methodology (AIM).
• Involved in whole life cycle of Oracle implementation, starting from System and Business analysis, design, coding, testing and support.
• Participated in full life cycle projects in financial implementation and also as a post implementation support consultant.
• Queried SQL/PLSQL codes for testing and verification of data into the database and for other related investigations
• Domain knowledge of Hi-Tech, Manufacturing, Financial, Healthcare and Entertainment industry verticals. Valuable cross-functional resource with expertise in interactions and business flows between the ERP and CRM business processes.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite R12, 11i

ERP Modules: GL (General Ledger), AP (Account Payables), AR (Account Receivables), PO (Purchasing), OM (Order Management), INV (Inventory), Project Accounting (PA), AOL (Application Object Library), P2P, O2C, and System Administration.

RDBMS: Oracle 8i/9i/10g.

Development Tools: X Workflow Builder, Reports &Forms 6i/10g

Languages: SQL, PL/SQL, C, Java, HTML, UNIX Scripting, XML

Reporting Tools: Reports 6i/10g, XML/BI Publisher.

Operating Systems: Windows 7/XP/NT/ 2000/98/95/2007 , UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Oracle EBS Functional Analyst/Lead

Responsibilities:

• Involved in Oracle EBS Implementations and it’s Initiatives and customizations for General Ledger, Payables, I-Procurement, Accounts Payable, Receivables, Fixed Assets, PTP, Inventory, IExpense, Project Costing and Billing, Cash Management
• Performed Oracle Business ERP and Quality Analyst role throughout 2011 Roadmap and implemented and upgraded releases successfully
• Performed meeting within Business stack holders, Developers, DBAs, Quality Assurances and End users of Business high level requirements and its updates
• Recommended best solutions and methods per requirements and functionalities of Oracle EBS
• Used IR Tools and OBIEE for customized reports and Reconciliation Reports and Prepared Data sheets for Reports for updates and to present in Meetings
• Recommended necessary Financial Reconciliations reports and assisted to design reports and tested
• Placed meetings for Requirements, Implementation, QA, Go to Live for Implementation and Upgrade
• Performed Oracle EBS Functionality Testing of business requirements for Quality Assurances.
• Developing PL/SQL (Stored Procedure, Functions & Packages) implementing business logic.
• Responsible for writing of SQL queries as procedures/functions at the back end which are called from front end form.
• Registering Reports, PL/SQL Procedures, and Packages and creating executable.
• Assisted to Business users for new implementations and Initiatives for testing and Designed, Created Use cases, Test Cases, Test Scripts, Test Plans and uploaded to the Quality Center and ran manual testing for Implementation on each releases.
• Involved in RICE data conversion, developing, customizing reports and interfaces.

Confidential, Boston, MA

Oracle EBS Business Analyst

Responsibilities:

• Responsible for end to end implementation of Oracle R12 EBS Financial Modules General Ledger, Accounts Payable and Internet Expenses (I Exp)
• Carried out functional requirements gathering, requirements analysis, gap analysis, functional setups and customizations and testing.
• Proposed solutions on business improvements and process enhancement
• Act as a liaison between business and IT. Work with IT Department to gather and convert history data from legacy systems
• Interacted with client team to understand the existing business practices and prepared the business requirement definition documents and designed business requirement definition document and Functional Specification documents for Business Apps
• Create Process flows to address business requirements, Use Cases, & Test Cases.
• Identified bugs & resolved issues impacting Suppliers profiles, Banks setups, Taxes issues, Payment Manager (PPR), AMEX integration, i-Expenses, and HR Users.
• Involved with study of existing system, preparing the BRD100/ Functional (MD50), Technical (MD70) design document and Conversion Data Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables and for implementation of GL, AP and I-Expense.
• Customized I expense using Oracle Accounts Payable, Project, HRM, Work flow and System Administrator for implementation
• Set up Suppliers, created Purchase requisitions, Purchase orders in Oracle Purchasing for Accounts Payable.

Confidential, Boston, MA

Oracle Applications (ERP) Consultant

Responsibilities:

• Worked as a Techno-Functional Resource at Client site to develop and implement various customization of Financial & Manufacturing modules
• Preparation of functional and technical documents based on AIM (Application Implementation Methodology), discussions with the client regarding the proposed solution, PL/SQL programs scripts, related Reports, Forms, Interfaces, Conversions, unit level and user acceptance testing.
• Worked for Procure to Pay Process and Order to Cash Processes and module integrations with AR, GL, AP, OM, WMS and INV with in EBS System.
• Developed AP invoice import Interface to import invoices to Accounts Payables
• Developed Customer API in Oracle Receivables.
• Developed inbound interface to upload the Shipping Instruction details from the legacy to Oracle Applications base tables
• Developed item Import conversion and On-hand Quantity Conversion.
• Developed Outbound interface to upload the Shipping Instruction details from the Base Tables to Excel files
• Developed New Reports and Customizations in standard reports using Oracle Reports, APEX &XML Publisher in Distribution, Finance, Manufacturing and CRM (Services, Contract, and Field Service) Modules.
• Worked in Form Personalization's in Distribution, manufacturing Modules.
• Developed extensive modifications to PO Account Generator using work flow builder.
• Developed New Forms and customizations in standard forms based on user requirements using Oracle Form Builder and OA Frame work in Manufacturing and distribution Modules.
• Customization of Self-Service Web Applications Using OA Frame Work.
• PL/SQL program scripts, related reports and forms, unit level and user acceptance testing.
• Registering/defining of custom applications, tables, forms, reports, concurrent requests standard report submission, profile options, defining of application users and responsibilities.

Confidential, Marlborough, MA

Oracle Applications (ERP) Consultant

Responsibilities:

• Lead multiple projects performing various technical and functional tasks related to the Oracle e-Business suite.
• Was the first point of contact for Production issues, 11i projects, development, customization, testing, debugging and support of Oracle applications.
• Developed/Customized Reports, Forms, Interfaces, Conversions and Enhancements.
• Worked with Open Interfaces and was involved with Application Programming Interfaces (API) related to Oracle Receivables and HRMS.
• Involved in development of shell scripts & PL/SQL stored procedures, functions, packages and Oracle Reports with different output formats like PDF.
• Addressed operational problems, concerns, and questions posed by users.
• Involved in Day-to-Day production support and month end Book Close assistance to the users.
• Participated in year end 1099 reporting process, auditing projects and developed a thorough understanding of Sarbanes Oxley (SOX) controls, standards & policies to ensure oracle applications are compliant and remain in compliance.
• Worked as an App Works Scheduler Support Lead, Oracle Applications Sysadmin with the ongoing production support. Monitored Concurrent Managers/Programs and performed various System Administration and database activities.
• Participated in systems integration between Oracle APPS, PeopleSoft Application and third party Applications. Resolved various issues related to Oracle APPS and data flow between other legacy systems.
• Supported the organization’s configuration management and systems engineering procedures.

Confidential, New York, NY

Oracle EBS Developer

Responsibilities:

• Customization and enhancement for existing reports and interfaces in the modules of Inventory, Oracle Receivables, Purchasing and Order Management.
• Prepared the SQL scripts for creating the concurrent programs, executable and parameters in Oracle applications.
• Imported the customers into Oracle Receivables using the Customer Import Program with in
• Oracle applications.
• Used SQL*Loader to load the data from flat file into staging tables, finally into Customer
• Interface Tables, and then into Base Tables.
• Creation of Value sets in various Modules of the application.
• Worked on various Financial and manufacturing modules (GL, AP, AR, PO, FA, OM, INV, SCM, and CRM).
• Configuration of General Ledger for multiple sets of books and integration with AP & AR.
• Hands on experience on Oracle EBS R12 P2P (iProcurement, AP, PO, iSupplier) modules.
• Hands on experience on Oracle EBS R12 SCM, BOM and WIP modules.
• Performed data conversion from legacy system to oracle modules using SQL*Loader.
• HRMS integration with other Oracle Applications, including Shared and Full installation considerations.
• Implemented Oracle Demantra applications like demand management, sales & operations planning, and trade promotions management solutions.
• Worked on integration interface, workflow, methods, and series and system parameters of Demantra.
• Customize/ Maintain Oracle Application Framework (OAF) Application.

Confidential

Senior System Analyst

Responsibilities:

• Actively Involved in Multiple Projects like Multi org, 11i upgrade, patch upgrades, modules implementation and participated in customizing, testing, debugging, maintenance and support of oracle applications.
• Involved in the Implementation of Order Management, Inventory and Purchasing modules. Posses both technical and functional knowledge related to data flows and back group processes.
• Supported the Workflow in Order Management and helped users in resolving various related issues.
• Involved in most of the stages of project development including requirement analysis, design, code development, enhancement, implementation and documentation.
• Developed/Modified interfaces and data conversion programs for various applications.
• Wrote database triggers, Stored Procedure/function and packages using PL/SQL.
• Involved in Development/Customization of forms, reports and UNIX shell scripts.
• Developed Workflow in Purchasing for approval hierarchy level.
• Coded the EFT, Positive Pay programs and was the owner of the transmission process to the bank.
• Maintained and customized the Pay base, Performance check printing software.
• Involved in using ADI for front end to perform General Ledger full cycle accounting.
• Performed Data Validation code to clean data before transferring into Interface tables.
• Worked with Application Programming Interface’s related to Oracle Assets.
• Used AMG (Activity Management Gateway) in Project Accounting and developed a script to load Projects data into Oracle Projects
• Defined value sets, menus, concurrent programs, report sets, registering custom build forms, reports and PL/SQL Procedures, Triggers and Packages and creating executables using Application Object Library (AOL).

Confidential

Application Developer

Responsibilities:

• Developed supplier/Customer interface using different API’s to bring those master data into Oracle as part of cut over process.
• Designed technical specification (MD070) and Installation Docs and Unit test Plans.
• Prepared scripts to move objects from one environment to another environment and did set up in testing environment.
• Post Conversion of Data with respect to technical doc
• Extensively worked on Sales Order conversion and understood each entity in it functionally and technically. Used the Oracle seed PL/SQL API to convert/update sales order header, lines and sales credit.
• Extensively involved in the verification and validation of converted Customers, suppliers, Sales Orders by executing the program in various CRP environments.
• Participated in Functional Testing of converted data.