Oracle Applications Consultant - PL/SQL

Namita Khandelwal E-Mail: *********@*****.***

****, ****** ***** ** *****: +1-240-***-****

Apartment F

Roanoke Va - 24018

________________________________________

Objective: Seeking assignments as a Techno Functional Consultant in Oracle Applications with a technology-driven organization.

Professional Profile

 Over 9 years of experience in software development and technical consultancy exposure for 7 years in AP, AR, GL, PO, INV, OM modules of Oracle Applications.

 Functional knowledge of Procure to pay modules in Oracle Applications.

 Developed Interfaces for a third party tools and Oracle Applications versions 10.7, 11.0.3, 11i.

 Customized Product Development for Oracle Applications 11i.

 Well versed in product implementation, offshore supports for Oracle Applications 11i.

 Effectively handled the development of Web Applications in HTML, JSP, and Java for 18 months.

 Recipient of the Performance in Excellence award from Wipro on the Marsh Upgrade Project and from Deloitte on the PBGC project.

 Adept in analyzing information system needs, evaluating end-user requirements, custom designing solutions, and troubleshooting any problems in the process.

 An effective communicator with excellent relationship management skills with the ability to relate to people at any level of business and management.

Skills Set

Technical

Programming Languages : PL/SQL, C, C++, Java 1.1.6/1.2, UNIX (shell programming)

Operating Environments : MS- DOS, Windows 95/98/2000, UNIX

Database : Oracle 8i/9i/10g, Microsoft SQL Server, MS Access, FoxPro

Application Server : JRun, PWS, Apache Web Server

ERP : Oracle Applications 11i/12i (AP, AR, OM, GL, Purchasing, Inventory, XML Publisher)

Tools : SQL * PLUS, Oracle Reports 6i, Oracle Forms 6i, Workflows, Discoverer, Toad, Kawa (Java editor), JDeveloper, Together Soft, Version Control Visual Source Safe, PVCS, Kintana, Test Director

Web Technology : XML, HTML, JavaScript, ASP (basics), JSP, and Oracle Portals

Functional

 Client interaction for requirement gathering, system analysis and finalisation / preparation of technical and functional specifications.

 Conducting TO-BE process analysis, requirement gathering meetings, generating Blue Prints and validating same from the company/customer.

 Data assimilation and freezing business process strategy discussion to decide the configuration.

 Customizing the modules to suit the company’s business.

 Design, development, testing, troubleshooting and debugging of the application.

 Oversee smooth implementation, testing and running of the application at client end/location.

 Extend post implementation, application maintenance and enhancement support to the client and train end users in the new environment.

Organisational Experience

Since Nov’04 with Deloitte Consulting India Pvt. Ltd., as Assistant Manager

 Techno Functional consultant for Federal Financials in Oracle Applications 11i in Procure to pay modules.

 Development of RICE Components, XML Publisher Reports and Discoverer Reports.

 Coordinator for the Knowledge Management Initiative for the Oracle Apps Practice

Nov’03 –Oct’04 with Wipro Technologies as Associate Consultant

Sept’00 –Oct’03 with IVL India Pvt. Ltd., as Application Developer

Key Projects Handled

Title: PBGC (Custom Reports, XML Publisher and Functional Support) Duration: 44 months

Client: Pension Benefit Guaranty Corporation

Environment: Reports Builder, PL/SQL, XML Publisher, Oracle Apps 11.5.10.2, AP, AR, GL, Fed Admin, MS project, Test Director

Roles - Designer and Developer – Techno Functional Lead – Functional consultant:

• Prepare Technical and Functional specification documents for the custom reports

• Providing technical and functional support for the Financials modules

• Conducted requirement-gathering sessions with clients

• Prepare Impact analysis and Recommendation documents

• Prepared MS-Visio process flow diagrams

• Conduct status meetings with clients

•

Details: PBGC has implemented Federal Financials modules Fed Admin, GL, AP and PO in Oracle 11.5.10. Our team was involved in Reports design and development. Also, we are providing support for technical or functional issues in Federal Financials modules or 180 customized reports developed and deployed, and any new enhancements coming up.

Title: Project Maui (Reports, XML Publisher) Duration: 3 months

Client: Agilent Technologies USA Team Size: 15

Environment: Reports Builder, PL/SQL, Oracle Apps 11.5.10, XML Publisher, Java Concurrent Program, Unix shell scripts

Role - Designer and Developer:

Details: Agilent Technologies got converted to Verigy and re-implemented Oracle 11.5.10. The team was involved in Customer Facing Documents, design and development based on onsite / offshore methodology.

Designed a Java program to get XML Output and merge to Word Template based on XML Values, Merging various output Documents and then producing the final PDF Output.

Title: Project Vivendi Universal Games (Reports, XML Publisher) Duration: 3 months

Client: Vivendi Universal Games USA

Environment: Reports Builder, PL/SQL, Oracle Apps 11.5.10, AP, AR, SQL Loader

Role – Designer and Developer:

Details: Vivendi Games is a global developer, publisher and distributor of interactive entertainment. The project is an Oracle ERP global implementation with multiple countries across North America, Europe and Asia-Pacific regions. The Oracle modules implemented are Financials - General Ledger, iProcurement, Accounts Payables, Accounts Receivables, Global Accounting Engine (AX). Order Management & Supply Chain modules - OM, Inventory, BOM, WIP. Our team was involved in technical development for Operations and Finance modules with over 100 objects delivered.

Title: Illy Café (Reports) Duration: 4 months

Client: Relizon Inc. USA Team Size: 15

Environment: Reports Builder, PL/SQL, Oracle Apps 11.5.9, AP, AR, OM

Role - Designer and Developer:

Details: Various Order Management and Inventory Reports were designed and developed during the 11.5.10 implementation in Illy Café. The team was also involved in designing Discoverer reports for the clients.

Title: Relizon (Interfaces) Duration: 4 months

Client: Relizon Inc. USA Team Size: 15

Environment: Reports Builder, PL/SQL, Oracle Apps 11.5.9, AP, AR

Role - Developer:

Details: Relizon went for the implementation of Oracle 11.5.10. The team was involved in Interface design and development based on onsite / offshore methodology. Our team was involved in the development of interfaces and custom reports for the Receivables and Payables and General Ledger modules.

Title: Stryker (RICE Components) Duration: 5 months

Client: Stryker Inc. USA Team Size: 15

Environment: Reports Builder, PL/SQL, Oracle Apps 11.5.9, Inventory, Purchasing

Role – Designer and Developer:

Details: The project was developed for the world leader in orthopedic markets which uses different legacy systems at different locations and this was a fresh implementation of Oracle APPS 11.5.9. Our team was involved in design and development of all the Reports, Interfaces, Conversions and extensions (RICE) components at offshore and functional design at onsite.

Title: One System Cancellation (Interfaces) Duration: 3 months

Client: Sony Inc. USA Team Size: 15

Environment: SQL*Plus, PL/SQL, Oracle Apps 11.0.3, Order Entry, UNIX (Shell Script), SQL Loaders

Role – Developer:

• Developed the interface for the Order Entry module using SQl * Plus.

Details: The project deals with an inbound interface development for the Oracle Shipping process in Order Management module. The modification was done to the existing ship confirm package to get the data from 3rd party tool called DMPLUS into Oracle Shipping tables and then calling the Holds API for the backordered lines. An email notification program is also included in the same program.

Title: SONY STE SMARTRACK Interfaces Duration: 2 months

Client: Sony Inc. USA Team Size: 15

Environment: SQL*Plus, PL/SQL, Oracle Apps 11.0.3, Order Entry

Role - Developer:

• Developed the interface for the Order Entry module using SQl * Plus.

Details: The Sony STE Order Line Split and Pick Release Interface involved the splitting of the Orders based on the Pick Release information received from Smartrack(a third party tool) and do the Pick Release after the Subinventory assignment. The Sony STE Smartrack Extract Process involved outbound data flow for the Export and SOMEX(third party tool) Sales Orders. The extract needs to be done after the shipment process in Oracle.

Title: Upgrade Project (to 11.5.9) Duration: 2 months

Client: Marsh Inc. Team Size: 15

Environment: Oracle Apps 11i (11.5.9), Developer 6I, SQL, PL/SQL

Role - Developer:

• Verified all the standard and custom reports after the upgrade.

• Debugged and deployed the reports that were found with defects.

Details: The project aimed at providing services to upgrade the Oracle Applications environment of Marsh Inc. from 11.5.5 to 11.5.9. The Upgrade of Oracle Applications environment from 11.5.5 to 11.5.9 involved testing the applications, database and customized reports. This project is to take advantage of the latest capabilities and functions available in 11i and drive the business enhancements which provide efficiency, productivity and scalability.

Title: Antara Duration: 15 days

Client: Marsh Inc. Team Size: 15

Environment: Developer 6I, SQL, PL/SQL

Role - Developer:

• Developed a form and a report for this application using Oracle D2K

Details: Antara is tool for project management which logs calls and maintains the calls history for any poject. This is developed using Forms 6i and Reports 6i. This application can be easily plugged into Oracle Applications suite as well.

Title: KWE- SG Localization Duration: 3 months

Client: Wipro Technologies Team Size: 15

Environment: Oracle Apps 11i (11.5.8), Developer 6I, SQL, PL/SQL, AP, AR, GL

Role – Onsite Developer:

• Prepared technical specification documents

• Developed custom reports for the clients.

• Onsite testing and debugging of the custom reports deployed.

Details: Kintetsu World Express (KWE), is a world leader in providing complete logistics and freight forwarding services. KWE has developed its Unified Accounting Systems in Oracle Applications. We provided customized reports on AP, AR and GL modules for clients which includes reports like Invoices, Accounting reports, Aging reports and Profit and loss analysis, Budget Analysis etc. The testing and debugging was done onsite.

Title: INSUR- Add on product for Oracle Applications Duration: 18 months

Client: Hindalco Industries Limited & Oracle India Consulting Team Size: 15

Environment: Oracle Apps 11i (11.5.5), Developer 6I, SQL, PL/SQL, AP, GL, Fixed Assets

Roles – Developer – Project Lead:

• Designed and developed database for the add-on product.

• Designed and developed the product using Oracle Forms and Reports builder.

• Prepared the user-manual of the product.

• Prepared the functional and technical documents for the various processes involved in the product.

• Provided demo to various clients over the web.

• Developed custom reports for the clients.

• Prepared quality documents for auditing purposes of the product development.

Details: The product is an add-on Module, integrated with Oracle Apps, catering the requirement of insurance transactions the company. Our team Handled installation and implementation of base product, INSUR, and integrated INSUR with Oracle Apps. We conducted user demos at various levels and completed the Gap Analysis. The product handles the overall life cycling of an insurance process involving processing claims processing. It is a custom module built for Oracle Applications using Oracle Forms builder and Oracle Reports Builder with Oracle 8i as database.

Title: Web Time Sheet Management System Duration: 8 months

Client: IVL India Pvt. Ltd.

Environment: Java, Html, JavaScript, JSP, Ms-Access

Role - Developer:

• Provided application support.

• Developed enhancements for the application using HTML, JSP program.

Details: This Web-based tool is designed to enter and verify the time sheet entries from Intranet and Internet. This tool is successfully implemented and running on Intranet in IVL India Pvt. Ltd.

Title: Helpdesk @IVL India Duration: 2 months

Client: IVL India Pvt. Ltd.

Environment: Java, JSP, Java Scripts, Html, WAP, MS-Access as Database

Role - Developer:

• Designed and Developed the application using JSP, WAP and Nokia toolkit

Details: This Project aims at providing Help Desk facility for the customers and users across the net and through mobile phones through WAP technology. There are JSP programs for submission of feedback and query forms and a WAP application running live to accept the queries through mobile devices.

Title: Clix Components Duration: 8 months

Client: Imc, Gmbh

Environment: Java, Html, Windows NT, PC-Pentium, Oracle 8.i as database

Role – Developer:

• Developed code in HTML, Java and JSP for different components.

Details: CLIX (Corporate Learning and Information Exchange) is a platform for web based distributed learning. It includes customizable software packages suitable for variety of products. This was just the continuation of the work done by us in India on CLIX. Developed Calendar system, for maintaining the important dates for various courses and with administrative features like posting deleting and editing. Application includes virtual corporate universities virtual rooms for group-oriented exchange of knowledge (the communities of practice) etc.

Trainings Attended

 Oracle Portals, Performance Tuning, ISO 9001 Standards, Oracle Forms, Reports and Overview on Oracle Financials.

 Advance Business Consulting for Technologists (ABCT) training from Deloitte Consulting LLP

 Oracle University Trainings for OCP Certification on Oracle E-business Suite 11i Financials Consultant.

Academic Credentials

 Masters of Commerce from Ravishankar University Raipur, 2001.

 Bachelors of Commerce from Ravishankar University Raipur, 1999.

 Higher Secondary School Certificate Examination from M.P.Board, Bhopal, 1996.

Professional Qualification

 Harvard Management and Leadership Certificate program.

 Diploma in Advanced Computer Programming from Tata InfoTech Ltd.

 Advanced Diploma in Web Application and Java Programming from Net GSC, Hyderabad.

 Brain Bench Certified C Programmer

 Brain Bench Certified Java Programmer.

Contact this candidate