ROFESSIONAL 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, FA, CM, 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, Cash Management, 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, FA, Cash Management
• 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
• Major Strengths
• Excellent working knowledge in all major Oracle EBS modules such as SYSADMIN, PO, INV, OM, FA, CM, AP, AR, GL, Oracle Marketing, Advanced Collections, AME, Projects, Install Base, HR
• Expertise in Reports 6i, Forms 6i, Business events, Oracle Alerts, BI Publisher, Business Objects, Cognos
• Good Project management and Business analyst skills.
• Good testing skills, debugging skills, communication skills and critical thinking skills.
• Excellent communication and interpersonal skills.

PROFESSIO PROFESSIONAL EXPERIENCE NAL EXPERIENCE

Confidential

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

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

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

Responsibilities:

Designed and developed new business events for the 3rd party system to send relevant information. In process of identifying the GAPS in all RICE objects for R12 upgrade Evaluate the new 11g database and to make optimal use of the new features to the existing programs. Involved in automating AR refund process in R12, Supplier conversions Involved in developing eText templates for EFT files Involved in Check Printing in R12. Working on regular production support issues related to Payables, Inventory, Purchasing modules

Confidential

Role: Techno Functional Consultant / Project Manager

Responsibilities:

• Involved in Implementation and Support of modules in OM, Inventory, PO, AR, AP Conducted and facilitated Conference Room Pilot CRP Preparation of Business Requirement Documents, Technical Specification Doc and Unit Testing Lead a team of 4 Onsite and 5 offshore resources, co-ordinate with different teams to meet the end objective Project delivery.
• Involved in setups related to AR Invoice grouping.
• Involved in setups related to Inventory such as Organizations, Locations, Sub inventories, Locators, Shipping networks.
• Involved in setups related to Payment Terms, Holds, Items, Item Cross references, Transaction types, Defaulting Rules, Processing constraints
• Developed customized reports in PO, INV, OM, AR, AP modules including Pick Slip, Bill of Lading, Invoice Printing, PO printing. Implement EDI Interfaces such as EDI 850, 856, 810, 820, 855. Implement new Interfaces between Oracle and other partners Involved in Conversion of all open transactions from PO, INV, OM, AP, AR Involved in build and testing of several forms including custom Pick Slip, Bill of Lading, Ship Confirmation, Shipping Advice Notification etc catering to business needs. Involved in design and setups of shipping document sets, picking document sets, Picking rules. Involved in Setups related to Price lists, qualifiers, formulas. Using Modifiers to setup price adjustments like discounts, surcharges , benefits, freight, special charges. Involved in Third party data integration for Trading Community Architecture TCA
• Developed Stored procedures, triggers, Packages using PL/SQL.
• Involved in Setting up Defaulting rules, Payment Terms, Holds, Customer Items, Document Sets for Picking, Shipping, Processing Constraints in Order Management
• Involved in month end activities such as period closing, reconciliation of all sub ledgers with GL and reporting to accounting users.
• Involved in production support, worked on issues related to PO, INV, OM, AP, AR, GL, Oracle Marketing
• 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

Confidential

Role: Techno Functional Consultant

Responsibilities:

• Preparation of Business Requirement Documents, Technical Specification Doc and Unit Testing. Analysis of customizations and enhancements: evaluate design, quality, stability and maintainability of custom code developed to fill gaps between standard Oracle Applications functionality and business requirements. Recommend and implement solutions as needed.
• 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

Confidential

Role: Reports Team Lead

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

Confidential

Role: Programmer Analyst

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.

Confidential

Role: Developer

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 building custom extensions in OM, PO modules
• Involved in building custom interfaces from EDI to Oracle, FTP'ing data from different partners to Oracle
• Responsible for creating packages, stored procedures, Functions, database triggers, Alerts
• Involved in day to day production support activities like fixing bugs, working on minor as well as major enhancements
• 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.