Project Oracle

Sushma Mandava

Mobile: +1-647-***-****

E-Mail: *****.*******@*****.***

CAREER GOAL

To secure a position in the field of Information Technology where my Education Certification, experience and skills can be used to support and enhance the efficiency and productivity of the company, I will thrive in a position that not only challenges my current skill set, but also provides an opportunity to increase my value to the company through skill building and advancement within the corporation

Abilities:

Possesses strong, intuitive problem solving skills.

Extremely quick learner when presented with an unfamiliar product or scenario.

Shares knowledge and experience with team members to advance the team.

Keeps up with current technology via online forums, industry magazines, and news

Experience:

Worked as Oracle Apps Technical Consultant in Oracle Corporation SSI, Hyderabad, through Plannit from Mar 2011 to Feb 2012.

Worked as Oracle Apps Technical Consultant in Sierra Atlantic Software Services Ltd, Hyderabad, through Propath Systems from Sep 2008 to Feb 2011.

SUMMARY:

Having 3.5 years of experience in the IT industry on Oracle Applications 11i.

Experienced in development and customization of RICE components in modules like INV, PO, OM, AP

Strong knowledge in PL/SQL, Reports 6i and XML Reports.

Experience in Forms Customization, Personalization & Registration.

Experience in Reports development and Customization.

Strong Experience in developing Inbound and Outbound Interfaces using PL/SQL, SQL* LOADER and UTL FILE.

Knowledge in AOL like registering Forms, Concurrent programs and Request Set, Value Set creationExposure of AOL, Sysadmin conceptsGood Knowledge in P2 P and O2C cycle.

Technical Profile:

ERP

(Oracle 11i)

SCM (Purchasing, Order Management and Inventory )

Oracle Technology

SQL,PL/SQL, Reports 6i and XML publisher

Operating Systems/

Hardware

Windows 95/98/2000, Windows NT

Tools

SQL *Loader and Toad

Project#1

Project : Core Product Support

Client : Oracle SSI (Global AP Support)

Duration : Mar ‘11 to Feb ‘12.

Modules Involved : AP

Responsibilities:Involved in analyzing and understanding of the Service Requests clearly.Involved in answering clients convincingly to meet the client satisfaction.Involved efficiently in resolving the issues concerned to the SR’s which are raised through Metalink with in a given time period.

Project#2

Project : Regionalization Of Sg, Jpn, Kor

Client : Form Factor Inc., Livermore, USA

Company : Sierra Atlantic Software Services Ltd.

Duration : Apr ‘10 to Feb’ 11

Role : Technical

Description:

Form Factor Inc is a global leader in advanced wafer probe card technology, design and providing wafer test solutions for established and emerging semiconductor test applications. This regionalization project is extension of the existing Oracle Applications for their Korea and Singapore operating unit. It includes manufacturing, distribution and finance module for regionalization.

Responsibilities:

Converted legacy items into oracle.Developed an inbound interface for Purchase Order Import.The steps involved getting the data file from the legacy system.Loading the data in to staging table. Validation of the records.Converted Standard Sales Order Acknowledgement report into XML Report Developed Inventory Report for Identifying Items that don’t have Specified Sales Account.Developed Inter Division Transfer ReportInvolved in the Creation Report Layouts.Involved in the Building of Data Model Queries.Involved in Creation of database object

Project#3

Project : QLogic Order to Cash

Client : QLogic Corporation, USA

Company : Sierra Atlantic Software Services Ltd.

Duration : Jul ‘09 to Mar’10

Role : Team Member

Description:

QLogic is a global leader and technology innovator in high performance networking, delivering adapters, switches and ASICs that power today’s data, storage and server networks for leading Global 2000 corporations. The company delivers a broad and diverse portfolio of networking products that include Converged Network Adapters (CAN’s) for FCoE, Ethernet adapters, Fibre Channel adapters and switches and iSCSI adapters and routers. QLogic is also a leading provider of InfiniBand switches and adapters for the high performance computing market. Leading OEMs and channel partners worldwide rely on QLogic products for their networking solutions.

Responsibilities:

Developed Order Import program.Item Category Assignments ImportNon-Translatable Items with On-Hand Quantity ReportInvolved in the Creation Report Layouts.Involved in the Building of Data Model Queries.Prepared MD70 Technical documents and MD120 Installation Documents.

Project#4

Project : Hindustan Lever Limited

Client : Hindustan Lever Limited

Company : Sierra Atlantic Software Services Ltd.

Duration : Nov ‘08 to Jun ’09

Role : Team Member

Description: The project is a new development project. Client wants to track the amount that it has spent on the employees who are working away from their home land. The project is about how much money is being spent on an employee on a monthly basis. Oracle 10g is used as the backend and Java is used as the front end.

Contributions: Designed database (Tables)Preparing Technical design document and understanding document.Designing the flow of data (functional flow) how it is being stored in the tables.Developing the reports using PLSQL.Developing PLSQL procedures and packages for the Java screens where ever necessary

ACADEMICS

Masters of Computer Applications (MCA), Rishi UBR College, 2008, 74%.

Bachelors of Science (B.Sc), VSR Govt Degree College, 2005, 70%.

Intermediate from Inter Board, 2002, 84%

SSC from SSC board, 2000, 71%

Contact this candidate