PROFESSIONAL SUMMARY

• Over 11 years of Industry experience including 10 years of experience in Oracle applications E-business Suite R12, 11i, Oracle 8i, 9i, 10g, 11g
• Experience in R12 AR, AP, PO, INV, OM, Service Contracts, GL, Install Base, iReceivables, Projects and Oracle HR modules
• Involved in Full Life cycle Implementations, Roll Outs, Upgrades, GAP analysis, Production Support, Testing, Data Migration from legacy system to Oracle.
• Experience in the entire Software Development Life Cycle SDLC .
• Experience in Business Analysis, Requirement Analysis and documentation.
• Experience in Business Intelligence tools such as Cognos, Business Objects etc.
• Conducted and facilitated Conference Room Pilot CRP and User Acceptance Testing UAT for various business processes.
• Involved in the End to End process of design and implementation of Customizations
• Involved in various types of testing Unit Testing, Functional testing, E2E Testing, System Integration testing and User Acceptance testing.
• Extensive experience in preparation and Review of BRDs, Gap Documents, FDs, Test Strategy and Test Plan Documents.
• Extensive experience in INVENTORY, PURCHASING, ORDER MANAGEMENT, AP, AR, GL, FA, Service Contracts, Install Base, Projects, OTL, iReceivables, Advanced Collections, AME, CRM and Oracle Marketing, HR modules.
• Experience in Third party Integration using Trading Community Architecture TCA
• Extensive experience in design and development of Business events, Oracle alerts.
• Experience in design and build of Oracle forms, reports using d2k, BI Publisher, Discoverer.
• Experience in design and build of Business objects reporting
• Experience in design and build of interfaces between external applications with Oracle EBS.
• Working experience in Application Developer, System Administrator.
• Well experienced in Functional Skills: requirements gathering, functional gap analysis, application design, configuration, module setup, writing training guides, training and production support.
• Experience in database programming using PL/SQL, SQL Server and Oracle.
• Extensive experience in all areas of Project Life Cycle.
• Extensive experience in leading team of developers and consultants in implementation and maintenance of Oracle EBS application
• Experience in Oracle Workflow
• Experience in Forms personalization, Stored Procedures, Triggers
• Extensive experience in Tuning, optimization of PL/SQL programs.
• Hands on experience in various tools - Mercury Test Director, Kintana, Data Loader, SVN and PVCS.
• Involved in End User training, preparation of user manuals, user guides and Desktop procedures for various projects.
• Ability to work with Cross-functional teams including Users, Financial Analyst, Business Analyst and Technical Consultants
• Follow up of TAR and Applications of Patches as and when required.

Skillset Summary

• Oracle Applications Oracle apps 11.5.9, 11.5.10, R12
• Oracle Financials Purchasing, Inventory, Advanced Pricing, Order Management, Accounts Payable, Accounts Receivable, General Ledger, iReceivables, Projects, OTL, Service Contracts, Install Base, Oracle Marketing, Advanced Collections, AME
• Oracle Products Oracle 8i, Developer 6i, Forms 6.0, Reports 6.0, PL/SQL, SQL, SQL Loader
• Database Oracle 9i, 10g, 11g
• Tools Visual Source Safe, PVCS, SQL Loader,
• HP-PPM, Harvest, P4 diff

ED Experience summary

• Senior Business Systems Analyst, Oracle Financials, Akamai Technologies.
• Project Manager / Senior Systems Analyst, Oracle Financials and HR Systems, GXS Inc, Gaithersburg, MD
• Lead Oracle Financials Systems Analyst, Kaplan Inc, New York, NY
• Techno Functional consultant in Oracle Apps 11.5.9 Implementation and Maintenance Toshiba America Consumer Products, Wayne, NJ
• Techno Functional consultant in Oracle Apps 11.5.9 Implementation for Toshiba Corp
• Techno Functional consultant in Oracle Apps 11.5.10 Implementation for Toshiba Of Canada Ltd, Toronto, Canada
• Conversion Team Lead in Oracle Apps 11.5.9 for Dunkin Brands, USA
• Developer at Infosys Technologies Limited

PROFESSIO PROFESSIONAL EXPERIENCE NAL EXPERIENCE

Confidential

Role: Senior Business Systems Analyst / Project Manager, Oracle Financial Systems

Description:

Oracle EBS R12 Implementation

• Confidential is in the process of implementation of Oracle R12 system.
• Some of the modules that are used:
• Inventory, OM, Fixed Assets, Receivables, Payables, Purchasing, General Ledger.

Responsibilities include but not limited to:

• Act as a senior liaison between Business and IT communities for all systems needs.
• Establish and maintain a Software Development Life Cycle framework.
• Facilitate sessions with the business community to define and plan projects.
• Facilitate cross-functional teams through business process and application initiatives from requirements definition to prototyping, testing, training, and deployment.
• Review technical designs to confirm they support business reporting requirements.
• Mentor business representatives through the software development activities.
• Communicate project status and escalate issues to management.
• Develop and execute system test plans and scenarios.
• Prepare training materials for deployment of applications, modules, enhancements and bug fixes.
• Develop baseline datasets and reports to support business requirements.
• Implement Business and IT processes to ensure data integrity/accuracy.
• Conduct training classes as needed.
• Facilitate end user communications.
• Assist with application and reporting system support and operations.
• Manages and tracks the progress of development projects to include user communication, administration, and work planning.
• Preparation of Business Requirement Documents, Functional Specification Doc and Unit Testing
• Work with vendors to get the integrations working inbound / outbound
• Researches and troubleshoots functional / technical issues including working with Oracle Support.

Confidential

Role: Senior Systems Analyst / Project Manager, Oracle Financial and HR Systems

Description:

• Confidential HR systems to 12.1.3 in 2013. Some of the modules that are used:
• Inventory, OM, Install Base, Service Contracts, iReceivables, Receivables, Payables, Oracle Time and Labor, Projects, AME, Purchasing, General Ledger.

Responsibilities include but not limited to:

• Manages and tracks the progress of development projects to include user communication, administration, and work planning.
• Communicates status of activities with the team, peers, management and end-users.
• Works closely with local and remote business leaders and Oracle team to understand and develop requirements, priorities, and processes for required solutions.
• Design and craft end to end solutions which integrate and leverage the Oracle e-Business suite core functionality.
• Involved in Implementation and Support of R12 modules such as OM, Inventory, AR, AP, Service Contracts, Install Base, OTL, Projects, iReceivables
• Preparation of Business Requirement Documents, Technical Specification Doc and Unit Testing
• Conducted and facilitated Conference Room Pilot CRP , UAT sessions.
• Design, develop and Implement Advanced Collections functionality in R12 for all the Operating Units, utilized Oracle seeded features such as XML Bursting for email / transmission of the files to the customers / 3rd party printing vendors etc.
• Implemented Project Costing Capital expenditure for employees time sheets OTL
• Design, develop and Implement Service contracts conversion from legacy systems to Oracle R12
• Setup AME rules for Credit Memo approval chain
• Design, Develop and support enhancements to the Oracle eBusiness Suite.
• Design, Develop and support integrations to other GXS systems.
• Design, Develop and support extensions to the Oracle eBusiness Suite.
• Provides level two functional and technical support for the Oracle eBusiness Suite.
• Researches and troubleshoots technical issues including working with Oracle Support.
• Work closely with the GXS Finance and HR department.

Confidential

Role: Sr. Lead Oracle Financials Systems Analyst / Lead Developer

• Confidential Oracle financial modules such as Payables, Receivables, Purchasing, Inventory, and General Ledger.

Responsibilities:

Responsibilities: Involved in setups related to AR Invoice grouping.

• Involved in production support, worked on issues related to PO, INV, OM, AP, AR, GL, Oracle Marketing
• Involved in month end activities such as period closing, reconciliation of all sub ledgers with GL and reporting to accounting users.
• Involved in Setting up Defaulting rules, Payment Terms, Holds, Customer Items, Document Sets for Picking, Shipping, Processing Constraints in Order Management
• Developed Stored procedures, triggers, Packages using PL/SQL.
• Involved in setups related to Payment Terms, Holds, Items, Item Cross references, Transaction types, Defaulting Rules, Processing constraints
• Involved in setups related to Inventory such as Organizations, Locations, Sub inventories, Locators, Shipping networks.
• Worked with different vendors like Oracle metalink for resolution of standard Oracle issues.

Environment: Oracle Apps 11i, Oracle 8i, 10g, PL/SQL, SQL Plus, Forms 6i, Reports 6i

Role: Techno Functional Consultant

• bugs adhering to SLA's and development of new interfaces and extensions for the proposed new warehouse to be used by our client. Client will use this warehouse for all the operations once it has gone live to Oracle.

Responsibilities:

• Implemented new Defense warehouse into Oracle as per the requirements.
• Analyzed existing system, mapping requirements with Applications and customized system to meet client requirements
• Development Custom Reports for Purchasing, OM modules.
• Testing the application in performance and data integrity perspective during postproduction period.
• Involved in Inventory, OM, AR setups
• Liaising with client key users and technical team, conducting CRP/testing
• Resolving issues related to all setups within PO, and OM
• Documented Processes and User Training Manuals for Maintenance Purposes

Environment: Oracle Apps 11i, Oracle 8i, PL/SQL, SQL Plus, Forms 6i, Reports 6i, workflow builder

Role: Reports Team Lead

Description:

Client is in the process of implementing ERP modules of the Oracle E-Business Suite of Products in their business. This project will help in the development of custom reports which will be utilized by users after Go-Live.

Responsibilities:

• Preparation of Business Requirement Documents, Technical Specification Documents.
• Prepared User Training Manuals which were used during UAT phase
• Addressed operational problems, concerns, and questions posed by users
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training and documentation and implementation of reports
• Interacting with upper management to identify the business process and needs and with end users to identify their requirements
• Setting up profile options values standard and custom , set up for OM, AR and PO.
• Configured profile options and security rules
• Build custom reports for Bill of Lading, Pick Slip, Invoice printing.
• Build custom reports for month end reconciliation purposes like Aging report, net sales reports.
• Developed custom reports in all major modules such as Order Management, Purchasing, Inventory, AP, AR.
• Performed system testing on different modules after the patches and customization releases are applied

Environment: Oracle Apps 11i, Oracle 8i, PL/SQL, SQL Plus, Forms 6i, Reports 6i, workflow builder

Role: Programmer Analyst

Description:

• Dunkin Brands re-defined their fiscal calendar from Sept - Aug to Jan - Dec to match the reporting cycle of the retail industry in America.
• Re-structure their chart of accounts by adding new segments to it including the Inter company segment.
• As part of this project, a re-implementation of all the Oracle Modules is being carried out. Played key role in smooth conversion of Fixed Assets, AP, AR.

Responsibilities:

• Analyzed the Business requirement and System requirements.
• Involved in re-structuring of Chart of Accounts, added new segments
• Prepare technical design document based on the functional requirement documents.
• Design and development of conversion programs for fixed assets, AP, AR.
• Involved in code review, testing and documentation
• Performed the role of knowledge management anchor, Defect Prevention analyst, configuration controller.

Environment: Oracle Apps 11i, Oracle 8i, PL/SQL, SQL Plus, Forms 6i, Reports 6i.

Role: Developer

Description:

Implementation and support of Oracle E-business suite of products. Herbalife implemented Oracle for their major modules Distribution management and Order management

Responsibilities:

• Involved in developing custom reports, forms using 6i
• Responsibilities include design, development, code review, implementation and documentation
• Developed interfaces and data conversion programs for applications.
• Involved in day to day production support activities like fixing bugs, working on minor as well as major enhancements
• Responsible for creating packages, stored procedures, Functions, database triggers, Alerts
• Involved in building custom interfaces from EDI to Oracle, FTP'ing data from different partners to Oracle
• Involved in building custom extensions in OM, PO modules
• System Administration functionality performed including end user set up, responsibility definition and menu definition

Environment: Oracle Apps 11i, R12, Oracle 8i, 91, 10g, 11g, PL/SQL, SQL Plus, Forms 6i, Reports 6i.