OBJECTIVE:

To work in a competitive and professional environment where I would be able to suggest and implement solutions for resolving challenges faced by Businesses using Enterprise Applications Solutions.

SUMMARY:

Confidential is an Oracle Apps Techno - functional Consultant with excellent techno functional knowledge and 5+ years of work experience in Oracle Applications. Her work experience encompasses Implementation, Enhancements, Support and maintenance and Upgrade projects on Oracle9i, 10g database and OracleApps11i (11.0.3, 11.5.9, 11.5.10). She has worked on the following functional modules Procure to Pay (iProcurement, PO, AP, iSupplier Portal), Order to Cash (Inventory, Order Management, AR), Service Contracts, HRMS and Key application modules such as AOL, System Administrator, Workflows and Interfaces and TCA Architecture. She has worked on all RICE components (Reports, Interfaces, Conversions & Enhancements) and all phases of the SDLC. She has technical expertise in the areas of PL/SQL, Workflows, Forms, Reports and interfaces. She is Six Sigma-Green Belt certified (Quality certification) with sound process knowledge and excellent communication skills.

SKILLS:

RDBMS: Oracle 8i, Oracle 9i, Oracle 10g

Languages: PL/SQL

GUI: Developer 2000 Forms and reports, Forms (6i, 4.5), Reports 6i

Others: Oracle Workflow 2.6, LoadRunner, XML, Oracle A.I.M. Methodology

ERP: Oracle Applications 11.0.3, 11.5.9, 11.5.10

Modules: Purchasing, Accounts Payables (AP), AR, Order Management, Service Contracts, Inventory, HRMS, GL, System Administrator, AOL, Application developer, Workflow, Interfaces, TCA Architecture.

OS/Environment: UNIX, Windows 95/98/2k/XP, Windows NT

Tools: PL/SQL Developer, TOAD, SQL* Plus, Workflow 2.6, Oracle Developer 2000, Kintana, WSFTP, PVCSLoadRunner

Technical Areas: PL/SQL, SQL Loader, Forms, Reports, Workflows, Interfaces, API, Enhancements, Customizations, Load Runner, Unix Shell scripts, XML (cXML)

Software: Microsoft Office( Word, Powerpoint, Excel), Open Office

PROFESSIONAL EXPERIENCE:

Confidential

Functional Modules: Sys Admin, AOL, AR, Order Management, Service Contracts, PO, TCA

Technical Areas: PL/SQL(triggers, packages, procedures), Reports, Interfaces, Application Object library (AOL), Oracle 10g, XML

Techno- functional Consultant

Responsibilities:

• 5+ years of IT experience in Oracle Applications 11i (11.0.3, 11.5.9, 11.5.10) in the modules Order Management, AR, Oracle Purchasing PO, Oracle iProcurement, iSupplier Portal, AP, System Administrator, AOL, Workflows, Service Contracts and other related modules like Human Resources, General Ledger, Inventory and Projects
• Experience working on TCA and good knowledge of TCA architecture.
• Worked on the world's largest Purchasing multi org implementation.
• Hands-on experience of Oracle Applications implementation lifecycle
• Worked on Oracle Applications upgrade from 11.5.9 to 11.5.10
• Excellent experience in Designing and Developing customized solutions such as custom interfaces, reports, workflows, forms etc working in both windows and Unix environment.
• Experience as Technical/functional Architect, Onsite Coordinator and Group Lead.
• Strong technical, functional and process knowledge.
• Experience in Implementation, Maintenance and supportand upgrade projects.
• Goodknowledgeof Oracle Apps Sys Admin.
• Trained from Oracle on Oracle WorkFlow 2.6
• Good knowledge and experience of AIM methodology.
• Six Sigma - Green Belt certified.
• Acquainted with Lean Principles for Quality Processes.
• Well versed with Software development life cycle and other CMM L5 quality procedures.
• Excellent Communication skills.

Confidential

Oracle Applications Techo-functional consultant

Functional Modules: Sys Admin, AOL, AR, Order Management, Service Contracts, PO, TCA

Technical Areas: PL/SQL(triggers, packages, procedures), Reports, Interfaces, Application Object library (AOL), Oracle 10g

Responsibilities:

• Working with business users for requirements gathering
• Requirement analysis and Creation of detailed technical design
• Functional Setups like lookup codes, DFF, Concurrent Programs, System Admin Setups
• Creation of AR interface and Report to pull data from AR, OM, Service Contracts and TCA and create cXML files containing AR transaction data and send to external system.
• Unit testing, Link testing and Integration Testing

Confidential

Oracle Applications Architect

Functional Modules: Sys Admin, AOL, PO,Services and Contracts, Order Entry, Oracle Time and Labour

Technical Areas: PL/SQL(triggers, packages, procedures), Forms, Custom.pll, Reports, Workflows, Interfaces, Enhancements, Customizations, Load Runner

Responsibilities:

• Requirement Gathering, Analysis and Estimations.
• Preparation of technical and functional designs.
• Implementation of customized solutions such as custom interfaces, forms etc.
• System Admin Setups
• Looking into technical and functional issues.
• Creation of integration and unit test plans.
• Working on SQL tuning.
• Creation of Load Runner scripts for data loading.
• Presentations to client IT for approval of designs.
• Provide training and guidance to the developers.

Confidential, NY

Techno-functional consultant/Group Lead

Functional Modules: Sys Admin, AOL, iProcurement, Purchasing (PO),iSupplier, AP, HRMS

Technical Areas: PL/SQL, XML, Forms, Reports, Workflows, Interfaces, Enhancements, Customizations

Responsibilities:

• Handling critical production related issues both functional and technical having severe business implications in accounts payables and purchasing.
• Interfacing and providing support to users and business IT helpdesks for business live on buy to pay for any issues being faced with the production system and any assistance required in implementing custom solutions.
• System Admin and Purchasing Setups.
• Requirement gathering, Analysis and estimations.
• Implementing new enhancements into the main application: -Designing and Developing customized solutions such as custom interfaces, reports, workflows, forms etc.
• End to End Testing for P2P(Procure to Pay) Cycle.
• Worked on SQL tuning, trace etc
• Writing complex pl/sql queries to provide data to client.
• Debugging issues in interfaces, workflows, forms and functional issues.
• Reviews and Presentations of the customized solutions.
• Carrying out knowledge transfers.
• Code Reviews.
• Coordination with Oracle on Tar's and ER's.
• Also the following tasks as an onsite coordinator:
• Handling of 10 member offshore team and 2 member onshore team and coordination work.
• Task management and assignment
• Status reporting and presentations to the Client.
• Worked extensively on creating (Designing, Coding and Testing) of a number of interfaces such as purchasing inbound, receipt inbound etc.
• System Admin Setups like creation of new menu’s, responsibilities, report group, users, concurrent programs and request sets.
• Purchasing and AP setups like suppliers, buyers, document types
• Debugging functional issues faced by clients.
• End to End testing for the entire P2P(procure to pay) cycle.
• Worked on analysis, coding and testing of enhancements on reports and workflows.
• Extensively worked on debugging and carrying out bug fixes to existing production Workflows, Reports and interfaces.
• Coordination with Oracle on TAR's and ER’s, weekly calls to discuss the status and escalating whenever required.
• Detailed analysis of all the user accounts in the system and development of custom ‘csv’ report to provide comprehensive employee/user and the related information. This required a set of complex queries to fetch the data and present it in a proper format.
• Coordinating the disaster recovery test: A test for carried out to ensure that the system worked properly in event of a disaster in coordination with the DBA's.
• Conceptualizing and establishing of a code review team, which would functionally and technically review any code going live in production.
• The sheer size and magnitude of the task can be estimated from the fact that the codes developed by any of the 275 businesses or by SSS itself were under the scope of this team.

Confidential

Oracle Apps Developer

Functional Modules: Sys Admin, AOL, iProcurement, Purchasing (PO),iSupplier, HRMS

Technical Areas: PL/SQL(triggers, packages, procedures),XML, Forms, Reports, Workflows, Interfaces, Enhancements, Customizations

Responsibilities:

• Technical and Functional analysis of client requirements.
• Setups and Data migration.
• Development of custom Interfaces.
• Design and modification of Reports.
• Creation of system cookbooks and technical design documents
• Preparation of unit and integration test cases.
• Perform Unit & Integration testing.