Oracle Project

SRI LAKSHMI PARASA

*** ***** ******* ** ********** va 23320 phone: (917) 514 - 3556

************@*****.***

Experience Summary:

. Having 3+ years of experience in US Coast Guard Finance Center,

Chesapeake, VA in Core Accounting System that is developed in Oracle

Applications

. 10+ Years experience in IT in which more than eight years of

experience in Oracle Applications.

. Strong Knowledge in Forms 4.5, 6i, Reports 2.5, 6i, PL/SQL, SQL *

Loader, Discoverer, Informatica and Database Servers 7.3, 8.0, 8i.

. Working Exposure in Multi Organization related oracle reports / forms

and conversions with different organizations.

. Extensive experience in the technical and functional aspects of Oracle

Applications 11i / 1103 (GL, AP, AR, OM, PO, INV, BOM)

. Worked in Interface / conversions like

. GL Interface,

. Payables Open Interface,

. Inventory Transactions Interface - To load project Account

Transaction into Inventory,

. Having good Knowledge in Oracle AIM Methodology.

. Having Good experience in System Analysis & Design, Development &

Implementation while working with several clients.

Technical Skills:

Software: Oracle Financials 11i (AP, PO, GL, AR, AOL and SysAdmin),

Oracle Manufacturing (INV, BOM, WIP, Order Management), Oracle

CRM, Oracle AIM Methodology, Oracle 8i, Developer 2000, Forms

6i, Reports 6i, PL/SQL, SQL*Loader.

Tools: TOAD, PLSQL Developer, SQL Navigator.

Database: Oracle 9i/8i and 8.0

Significant Projects

Coast Guard Finance Centre

Feb-05 to Jun-09

Chesapeake, VA

Project Description:

Support Coast Guard's Production system that has Oracle and Custom

Applications. Work in various modules like Payables, Receivables,

Purchasing, Vendor System and Custom Procurement Applications. Identify

the system deficiencies and enhancements and create SPR/SCR with functional

overview. Responsible Modifying / trouble shooting oracle forms, oracle

reports and PL/SQL code

Environment: Oracle Federal Financials 11.5.10 (GL, AP, AR, PO, INV),

Oracle9i, reports6i, SQL Navigator.

Responsibilities:

0. Develop PLSQL validation program to clear Suspense Account, by matching

it to a PO coming at later time.

1. Supplier cleanup and transactions corrections in PO tables and

associated AP tables.

2. Worked in FPD integration which integrated FPD to CAS PO system.

3. Trouble shooting of PL / SQL in Oracle modules such as GL, AP and PO.

4. NFC Flat file generation: Sent Third Party Payment Vendors file and TSA

Third Party Pay Collections (Katrina Payments)

5. Prepare enhancement/service change request documentation and modified

Procurement modules, General Ledger module (Funds Status Report, Object

Class Report, and Production Statistics Report) and customised modules.

6. Developed Flat files (fixed length) by using UTL FILE functionality.

7. Did TSA/FAMS reclassification from one Accounting line to other, prepare

document procedures for OPS to do reclassifications.

8. VMS Error Corrections in Error Correction JSP, involved in preparation

of VMS Handbook for Error Corrections and work on action items.

9. Improve performance of queries run on production by tuning using Explain

plan.

10. Gather requirements from users, Prepare documentation and Analyse the

issue with technical team and involve in testing phase.

11. Involve in the implementation of service pack upgrades by testing along

with users.

12. Analyze production issues of different customized technologies, provide

workaround/ temporary solution by co-ordinating with various teams.

13. Prepare requirement document and Business View Data Dictionary for all

the modules for Informatica Reports.

14. Test Service pack upgrades in different modules, prepare test plan with

sequence of steps.

GE Energy Parts - Production Support Jun - 03 to Jul-04

Milwaukee, WI

Project Description:

Worked as a Technical consultant in distribution modules, Role includes

Interface Conversion in Inventory Transactions interface. To support the PO

and AP modules. Mostly in the technical areas like reports, forms and

pl/sql.

Environment: Oracle Applications 11.5.9 (GL, AP, PO, INV,), Oracle8i,

forms 6i reports 6i

Responsibilities:

0. Technical documents preparation by using functional documents.

1. Developed Custom validation scripts for Oracle Payables Interface.

2. Developed Custom Validation program for Inventory Transactions

Interface.

3. SQL * Loader scripts to load data from the flat files.

4. UTL File Preparations for outbound interfaces in OM and Inventory

modules.

5. Bug fixes in forms, reports and PL/SQL during the post production

support.

6. FTP Programs by using UNIX Shell Scripting to load the day to day flat

files from the remote machines.

7. Unit Test Plans preparation.

8. Performance tuning using Explain plan in reports development.

9. Registration of forms, reports, PL SQL programs and Unix Shell

programs using AOL module.

10. Integration testing.

GE Power System Development and Production Support Apr - 02 to May

- 03

Milwaukee, WI

Project Description:

Worked as a Technical consultant in manufacturing and distribution

modules, Role includes Inventory Item Interface, Purchase Order Interface

and reports.

Environment: Oracle Applications 11.5.8 (OM, PO, GL, AP, AR), Oracle8i,

forms 6i reports 6i.

Responsibilities:

11. Working in Technical documents preparation

12. Custom PL/SQL Validation programs for Interface Validations

13. SQL * Loader scripts to load data from the flat files.

14. Development of Inventory Transactions interface.

15. Custom forms Development in Oracle Receivables modules.

16. Journal Imports from legacy systems to Oracle Applications by using GL

Interface.

17. FTP Programs by using UNIX Shell Scripting to load the day to day flat

files from the remote machines.

18. Worked with the Reports related to the Vendors, Customers, Sales

Invoices, Purchasing Invoices, Payments and Receipts.

19. Registration of forms, reports, PL SQL programs and Unix Shell

programs using AOL module.

20. Unit Test Plans preparation.

21. Integration testing.

Field Resource Management Tool 2.0 Jan -01 to Mar -

02

Milwaukee, WI

Project Description:

FRMT is an Oracle CRM project. FRMT system is based on Oracle CRM

Application (Service) viz- CRM foundation, Field Services, Global Install

Base and Advanced Scheduler in addition to core ERP modules for support

like GL, Inventory, AR etc.

Environment: Oracle Applications 11.5.8 (Install Base, CRM Foundation,

Field Service, Advanced Scheduler, HRMS and Inventory), Oracle8i, forms 6i,

reports 6i.

Responsibilities:

22. Forms Customization in Oracle Receivables and Order Management

Modules.

23. Worked on CRM Foundation Modules to maintain the Task management.

24. Worked on HR Employee Conversion API's to load People Soft HRMS

Employees into Oracle Applications.

25. Reports Customization and Development in Payables and Receivables.

26. Developed SQL * Loader scripts to load flat files data into oracle

applications.

27. Worked in Oracle Payables interface to load invoices into Oracle

Payables modules.

28. Unix Shell programming to automate FTP process of the flat file

transfers.

29. Worked with PL/SQL Packages (Tax Calculation of GE Employees in US

geography based on the state wise depends on the task assigned).

30. Registration of forms, reports, PL SQL programs and Unix Shell

programs using AOL module.

31. Post production support and upgradation support.

32. Registration of Concurrent Programs

33. Test Case preparation, Unit Testing.

Fairex Financial Systems Feb - 00 to Dec -01

India

Project Description:

This project is mainly on Reports / Forms customizations/ Development in

Oracle Applications 11i

Responsibilities:

34. Preparing technical docs for the requirements.

35. Development of Payables Interface in AP

36. SQL * Loader Scripts preparation.

37. Validation program for custom tables data.

38. Registration of forms Reports

39. Registration of forms, reports, PL SQL programs and Unix Shell

programs using AOL module.

40. Worked with the Reports related to Sales Invoices, Purchasing

Invoices, Payments and Receipts.

41. Custom form to correct the data.

42. Test Cases documents preparation.

Micro-Works Technologies Apr - 99 to Jan -

00

India

Environment: Oracle Applications 11i (AP AR and GL), Oracle8.1.7, forms 6i

reports 6i

Responsibilities:

43. Working on custom forms in Custom AP Interface Tables.

44. Implemented APPS Standards in forms.

45. Troubleshooting of reports.

46. Test case preparation, Unit Testing

47. Generating Log and Output files using PL/SQL in Interfaces.

48. Worked on interfaces.

49. Involved in customizing the various reports.

Ilogistix, Dec - 98 to Mar - 99

India.

Environment: Oracle Applications 11i (GL, AP, AR, PO and OM), Oracle8i,

forms 6i, reports 6i.

Responsibilities:

50. Technical Documents Preparation

51. Developed / Customized Oracle forms.

52. Worked on PL/SQL for data validations.

53. Preparing Test case Documents.

54. Involved in GL Interface to load journals into Oracle Applications.

55. Registration of forms, reports, PL SQL programs and Unix Shell

programs using AOL module.

56. Users, Responsibilities creations and Adding functions and

registration of forms, reports and pl/sql programs.

57. Involved in Unit and Integration Testing.

58. Forms Reports Registration.

Cost Co Inc. Jan - 98 To Nov -

98

India

Environment: Oracle7.3 forms 4.5 reports 2.5

Responsibilities:

59. Developed Technical Documents.

60. Developed / Customized Oracle forms.

61. Developed / Customized Oracle Reports.

62. Preparing Test case Documents.

63. Involved in Unit and Integration Testing.

Contact this candidate