Sushila Manchanda

(Software Executive – Application Development)

Objective

Seeking to Grow as – Apps functional consultant/Oracle Apps R12)

Sushila Worked as Software Executive (Application Developer)for 5 Years in

The IT industry.

Aspiring to Learn and strengthen development skills especially achieve ‘System Requirement

Professional Summary

Having 5 years of professional experience in IT industry. 2 years’ experience in Oracle App Functional.

Worked on Application Development and maintenance on Oracle Apps R12 and Apps Functional.

Worked on Airline domain + oracle financials like ERP systems.

Currently involved in the project with ‘Airline Reservation System’ [Airline Ticketing].

Professional Profile

Recently done Oracle Apps.Financials R12(GL, AP, AR),Oracle Inventory

Oracle HRMS,Oracle Purchasing,System Administrator,Multi ORG,Bussiness Cycle in Oracle Application in 2014 from Applied labs,New Delhi.

Done Oracle 9i – Application Developer Course’ in 2008 from New Horizons, lodhi road.New Delhi

Academic Profile

Bachelor in Computer Application [B.C.A.] – IGNOU Rajghat, New Delhi in 2003 with 64%.

Intermediate [12th] – C.B.S.E. Ramjas Public School, Pusa Road, New Delhi in 1999 with 73.5%.

High School [10th] - C.B.S.E. Ramjas Public School, Pusa Road, New Delhi in 1999 with 68.6%.

Master in Computer Application [B.C.A.] – IGNOU Rajghat, New Delhi in 2003 with 64%.

Diploma in Computer Science – IIS InfoTech LTD Punjabi Bagh, New Delhi in

Skill Set

Hardware Platforms

Pentium Based PC’s

Environments worked on

Windows XP

Languages / Technologies

C, Visual Basic [VB]

Databases

Oracle9i, Ms Access

Projects Done:

Project Period: April 2008 - June2013

TII InfoTech

Designation: Software Developer

Client(s): ARP Group, Kenya, Tanzania & UK, TUI China, Beijing, China

Le Passage to India, Go India Journeys, HausKhaz, New Delhi, India

Software-Travel Assist:

Travel assist is complete tour management software that enables an organization to efficiently manage the complete tour cycle from enquiry to tour operations

This Application enables a tour company to manage operations of all business segments; FIT, GIT, Series Adhoc, Charters and Excursion management. It also has an inbuilt accounting system and also it can be integrated to standard ERP like Oracle Financials, Accpac or any other accounting backend application

Guides & monuments Tariff. Further incorporating the Inquires from Agents/ Direct Clients, Preparing Quotation for them with different combinations, Issuing Exchange Order to Suppliers, Bill Passing, raises invoicing on the Agents, Capturing Feedback of Customers, and various Management Informative Reports

Responsibilities

1.Develope Oracle forms and report.

2.Understand project requirements and develop design specifications.

3.Design code and maintain coding standards.

Projects Undertaken for Oracle Certified Professional Course

- Oracle Forms

Project Name : Airline Reservation System (Air Ticketing)

Team Size : Individual Online Project and Mentoring done online by

Institute faculty

Duration : 1 year

My profile : Creating database tables, all forms, modules, interactions.

Project Description:

It is a software application to assist an airline with transactions related to making ticket reservations which includes blocking, reserving, canceling and rescheduling tickets. Also includes maintaining consistency among different access modes. It is a use of desk reservation systems. Maintaining customer info in case of emergency, maximizing revenue adopting a flexible pricing policy and much more is needed for smooth and time effective functioning of Air Ticket Reservation System.

Responsibilities

1.Write clear codes and prepare coding documents.

2.Perform design and development of Oracle application according to project requirements

3.Testing and perform bug fixes.

Oracle Apps.Financials Contents:

Functional

Oracle General Ledger

Oracle Apps.Financials Contents

Components included

Introduction

Charts Of Accounts

Calendar

Currency &Define Conversion Rates.

Set OF Books

Periods

Journals Advance journal enteries and posting

Suspense journal,Statistical journal & Reverse journal

Translation

Revaluation

Budgets

Mass Allocation

Consolidation

MRC

Intercomany Accounts,Security Rules,CVR

Summary Accounts, Rollup Groups

FSG

Overview Of Journal Import

Oracle Payables

Payables Options

Payment Terms,Payment Groups

Types Of Invoices in Payables

Distribution Sets In Payables

Holds in Payables

Bank,Bank Accounts

Multiple Currencies Payments

Payment Format

Payment Manual/Quick

Batch Payments,automatic Pay batch

Calculate vendors balance

Void or Stopping Payments

Payables Data Transfer to G.L

Oracle Receivables

System Options

Transaction Types, Sources

Payment Terms,Approval Limit

Profile Classes

Customer Defination

Transactions

Receipt Classes,Sources

Bank Receivable option in bank

Receivables Activities

Collection,aging Analysis and account overview

Oracle Inventory

Defining Items

Defining Sub-Inventory

Categories(Overview)

Item Template(Overview)

Define Organiztions

Defining Locations

Overview Of Item Attributes

Oracle HRMS

Defining Job

Defining Position

Enter/Maintain Employee

Position Hierarchy/Employee Supervisior

Oracle Purchasing

Purchasing Options

Financials Options

Receiving Options

Document Types

Requisitions

AutoCreate

Types Of Purchase Order

G.R.N Types

Invoice matching method

Define Suppliers

Prepare list of Suppliers

P.O Releases

System Administrator

Define Responsibilities

Setting Of Profile Options

Define Users

Muti-ORG

Desigining Organization Structure

Creating Organization Structures

Location,LE OU,inv org responibilities

Profile options

Bussiness Cycle in Oracle Application

Order to Cash life cycle

Procure to pay Process

Honours and Achievements

Certificate of appreciation as best student of the year from Help age India.

Participated in training camps for Sports and Mountaineering and Scouts and Guides organised by Ramjas School.

Personal Details:

Date of Birth: 9-April-1982

Age: 32 Years

Marital Status: Un-Married

Nationality: Indian

Contact Information:

Current Address: P-24, 2nd Floor West Patel Nagar, New Delhi – 110008

Residence No. : N/A

Mobile No.: 913-***-****

Email Id: actgxu@r.postjobfree.com

Permanent address and Tel. No. :

Emergency Contact details (Phones Nos.): 25872418

Contact this candidate