Oracle Project

MOHSIN KHAN

Oracle Apps Technical

Thane ******.********@*****.*** +91-828*******

Objective

To secure a challenging position in an organization where I can effectively contribute and increase my skill as an IT professional.

EDUCATION

Year

Degree

University/Board

Institute

Percentage

2011-14

Bachelor of Science (IT).

Mumbai University.

A.E. Kalsekar Degree College,Thane.

70.625

2010-11

Higher Secondary School Certificate (H.S.C).

Maharashtra Board.

Drt’s Junior College,

Thane.

71.00

2008-09

Secondary School Certificate (S.S.C).

Maharashtra Board.

Abdullah Patel English High School, Thane.

68.76

Skills

ERP Applications: Oracle Applications R12

ERP Modules: Account Payables, Inventory, Account Receivables, General Ledger and Purchase Order, Property Module.

Languages: SQL, PL/SQL.

AOL Objects: System Administrator and Application Developer.

Tools: TOAD, Reports 6i/10g, XML BI publisher, Form Builder 6i/10g, SQL plus, SQL Developer, Workflow Builder.

Oracle Apps : Understanding of Whole Process and Database table structure.

Operating Systems : Windows 7,Vista,XP,8.

SUMMARY

Over +10 Months of IT Experience in Oracle Applications as a Technical consultant.

Experience in Development, Implementation, and Migration, and Support projects for Oracle Applications Financials (GL, AP, AR and FA)

Working in Oracle Applications 11i/R12 Interfaces and Customizations as Technical Consultant.

Experience includes Development and Customization of Forms using template.fmb and custom.pll, Reports and Interfaces.

Expertise in Oracle, Reports 6i/10g, Forms 6i/10g, SQL and PL/SQL database programming.

Extensively worked at SYSADMIN and AOL activities including creation of users, responsibilities, menus, concurrent programs, request sets, request groups, value sets.

Having Good Knowledge on Development skills in developing RICE Components in the domain of Oracle Applications E-Business Suite.

Exposure to Oracle E-Business Suite in PO, AP, AR, GL,FA And Property Modules.

Having good knowledge in Other Utilities like TOAD, SQL LOADER, SQL*PLUS.

Good understanding of the entire P2P and O2C Process.

Good Exposure to Development of New Forms, Reports and Customizations of Reports.

Having good Knowledge in developing XML Publisher Reports.

Worked on development of SQL Queries, procedures, functions and packages as per business requirement.

Expertise in the Creation of value sets and registering the concurrent programs in AOL.

Involved in personalization of forms using Form Personalization feature in Apps.

Involved in uploading the Data through API in System.

Customization of the Packages for API (Application Program Interface’s).

Expertise in Developing a new Form from Scratch.

Developing a Workflow from Scratch.

Having good knowledge in Customizing a Workflow for a Customized module.

Customization of standard Stored Procedure, Package or Functions created for performing specific activities in the Oracle Apps E-Business Suite.

Good Understanding of Oracle BI.

PROFESSIONAL EXPERIENCE

Company : Apps Guru

Currently working as Technical Consultant for Oracle Apps from 1st August 2014 for offshore support project.

Project: #1

Duration - Aug 2014 to till date

Environment – Oracle Apps R12

Client Name - Al Maabar International Investment, UAE

Role: Apps Technical Consultant

Responsibilities:

Part of the supporting team to the offshore company.

Developed Multi Types of Report in different Modules like PO, GL, AP, AR and Property.

Developed Reports like Customer Statement Report, Supplier Statement Report, etc.

Developed and Customized Forms, Reports as per the client requirement.

Created a custom form using TEMPLATE. fmb and CUSTOM. pll for Property Reservation Details Form and Property Reservation Summary Form based on transactions for business requirements.

Worked on XML Publisher reports using RDF and Data Template.

Defined Concurrent Programs, Executables and Value sets.

Creating PL/SQL Packages, Procedures, Functions as per project requirements.

Worked On Packages, Procedures, Functions, Triggers On Form Developed From Scratch.

Worked on Uploading Data into system through API.

Involved in Implementation of Fixed Assets And Support.

Uploaded Fixed Assets Data into the system.

Developed outbound interface to transfer the data from base tables to external System.

Worked On Uploading The Data into Staging Table through SQL Loader.

Worked on Attaching a New Menu, New Form to the attached New Responsibility.

Personalization on New Attached Form.

Good Understanding of Oracle BI.

Registered Concurrent Programs, Forms, Form Functions, Menus and Reports in Oracle Applications using Application Object Library. Also created various Profile Options, DFF, Value Sets, Attachment Setups, Request Groups, and Request Sets.

Developed various new custom reports in AR and Property Modules.

Developed Fixed Asset report based on Depreciation Period.

Involved in customizing various Reports in Property and AR Module related to Transactions and Sales.

ACADEMIC PROJECT

Title: Classes Management System. Technologies :Asp.net, SQL server.

Description:

CMS is an application which is used to manage the attendance of students and teachers. It keeps track of daily schedule and holiday list.

PERSONAL DETAILS

Date Of Birth : 07-July-1993

Languages Known : English, Marathi, Hindi, Urdu

Address: D-3, Dhoom Chawl Devripada Shrilanka, Hashmat Chowk, Kausa, Mumbra. Dist :- Thane–400612.

Contact this candidate