Reports and Forms 6i/9i/10g/11g


Download 50.41 Kb.
NameReports and Forms 6i/9i/10g/11g
A typeReport

ocp



Praveenraj Rajappan
Contact No: +968 9 5124145

e_mail : praveenraj.rajappan@gmail.com

Certified professional, having 10+ years of onhand experience in IT Project Implementation, Management and Support, seeking challenging position as Lead / Managerial IT (DBA)

Highly motivated and enthusiastic individual having excellent technical knowledge and experience in Oracle Database Administration, PL/SQL, Forms, Reports.
SKILLS SET


  • ORACLE DBA ( 9i / 10g / 11g)

  • Installation, Upgrading, and Patching

  • RDBMS Troubleshooting.

  • Database Backup (using RMAN).

  • Performance Tuning

  • SQL and PL/SQL

  • ASM

  • Reports and Forms 6i/9i/10g/11g

  • Oracle Datavault

  • Good understanding of OOPS concepts and Knowledge of Java

  • Knowledge of Oracle Applications 11i,R12

  • OLAP, OLTP with RAC and non-RAC environment (Production / UAT / Dev / DR)

  • EXP/EXPDB, IMP/IMPDB, RAC, TAR , TOAD, SQL Navigator

  • SQL Query optimization using Bottleneck Analysis, Query/Schema Analyzer, Auditing, TKPROF and Explain plan.

  • Migration and Upgrade in Production, UAT and DisasterRecovery environments

  • Oracle Virtrual Machine

  • Build Entity Relationships Diagrams.

  • Writing Technical Documentaion ( Oracle AIM).

  • Shell scripting.



  • Full knowledge of SDLC

  • Effective communication skills and Team bonding

  • Team management of any size

  • Ability to meet clear objective and working with tight timelines.

  • Challenges sub-ordinates to develop as leaders while serving as a role model and mentor

  • Understands how to communicate difficult/sensitive information tactfully

  • Ability to meet clear objective and working with tight timelines.

  • Inspires co-workers attain goals and pursue excellence

  • Familiar with Change Management, Research and Development

  • Quick learner and possess the ability to deploy projects in line with the business needs

  • Excellent analytical skills and attention to detail with self-motivation



QUALIFICATIONS



  • Oracle Certified Professional(10g DBA)

  • Oracle Certified Professional(9i Forms)

  • Master In Computer Application (MCA)

  • P.G Diploma in Computer Applications

  • Bachelor Degree in Physiscs (BSc)


ACHIEVEMENTS


  • Implementation of Payroll and HRMS Module in Royal Oman Police (ROP).

  • Sucessfully designed and supported 9 Inhouse Projects at OMANTEL.

  • Helped in project closing by successfully fixing all the reported bugs encountered in CAS Project in Mazoon Electiricy company.

  • Installed and configured Oracle Database ASM instance in Bank Sohar.

  • Successfully Completed all the short term Oracle Applications Support assignments in different modules, for replacing BCT consultants on their annual leave .


TRAINNING RECEIVED

  • Oracle Data Vault ( From Oracle in Muscat)

  • Oracle DBA 10g( From Sql star Hyderabad)



EXPERIENCES:

Software Consultant, Bahwan Cybertek LLC , Muscat,Oman – Since 26-mar-2005
BCT is a leading Oracle certified Partner, with rich experience in consulting and implementation of Oracle Solutions. It has to it’s credit the implementation of more than 50 Oracle Solutions.
PROJECTS:
Development , Implementation and Management of various Oracle Projects at prestigious client in Oman like, OMANTEL, BANK SOHAR, ROYAL OMAN POLICE, MAZOON ELECTRICITY COMPANY, MINISTARY OF JUSTICE, NPI .

PROJECT DETAILS:



  1. Omantel  (Oman Telecommunications Company)

Software: Customized in house application based on Forms9i,Reports 9i,  Database 9i& 10g

Role : Database Administration/Developer


  • Designed and Implemented oracle database with Oracle Flexible Architecture for UAT.




  • Helpdesk system(IT Support)

Used to log and track IT support calls . Which will capable of providing different analysis reports. Email/SMS alert for the requestor and support person.

  • Change Management System(IT Support)

Used to record changemangement requests in IT department.

  • Incident Management System ( IT Support)

Apart from helpdesk system IT department requested another application for tracking critical issues like Software crash, virus attack, server and network related issues. The system helped them to reduce the fixing time of most repeating critical issues because it maintainted a comprehensive history of the all issues.

With the helpof provided detailed as well as summary reports the the task become more easy.

  • OPMS (Omantel Employee Performance Management system for HR)

Successfully used for 3 years for OMANTEL employee performance analysis. The system had KPI settings facilities for beginning of year and Mid Year, The supervisor/reporting manager had to review employee KPI put the scores . End of year the screen will give the final review sheet with scores where employees can put their comments.

  • Letter Follow Up system( CEO Office )

Used to record, followup and archive all incoming and out going official letters in CEO Office with letter scanning and attachment provition.

  • ADSL Waiting List(Corporate sales)

For analysisng the enquiry waiting list for ADSL customers .

  • Salalah Kareef Draw Application( Marketing )

This software helped Omantel for conducting the festival promotion draw . The system used for full promotional periods , Marketing department successfully completed all weekly draws and grand draw with out any errors.

  • International Call Analysis System(Wholesale business unit)

The application for analysing the cost of diverted international calls. The system provided necessary analysis reports to know which is the least profitable service provider among the 10 diffferent international service providers in everymonth.

  • Co location Request Processing System(Whole sale Business unit)

To record and analyse the various rented/leased facities which omantel provided of the other telecom or other companies.

  1. Bank Sohar

DBA Task:

Installed and Configured ASM instance(oracle 10g) and Application Server

Oracle Database 10g ASM for UAT and PROD

Oracle iAS 10g R3

Server : Windows 2003 64 bit.

Oracle Applications 11i support

 Modules worked GL,AP,PO & HRMS

2 Months


  1. Omantel

       Oracle Applications 11i support

 Modules worked AP,AR & FA

         1 Month

  1. Mazoon Electricity Company

             CAS Project

                Fixed bugs & redesigned the analysis reports (Reports 10g)

DBA Task : Performace Tuning Of Data Base, Query Optimization.

  1. Royal Oman Police

            Payroll & HRMS system

Working in PAYROLL and HRMS implementation team for developing customized Reports Payroll

reports and HRMS Reports (11g).

DBA Task : Query Optimization, Database tuning.

  1. National Parmasuitical Industries(NPI)

DBA task :

Periodic database health checking , Data Base tuning and bug fixing

Database : Oracle 10g.

Server : Red Hat Linux 5.0

  1. Ministry Of Justice

DBA task :

Installed and configured Production and Testing Database for HRMS And Payroll ( Cuccent BCT product).

Database : Oracle 9i.

Server : Windows 2003 32 bit
Software engineer , SINATRA TECHNOLOGIES PVT LTD MULANTHUTUTHI, ERNAKULAM(Jul 2004 To March 2005)
Worked in project development such as Inventory packages & accounting module using Oracle8 ,Forms6i & Reports6i.

Here my role was in system designing and data base designing

Completed the forms 9i trainning and OCP certification in same period.

Software engineer , Comprehensive Software Solutions & Services ,Cochin (jul-2003 to Jun-2004)

A company dealing in comprehensive software solutions & services. Involved in the development of various logistic management, inventory and accounting software’s for various clients.
Devloped using VB ,Oracle 8 and crystal Reports

Role: Report Developer, Programmer, Issue tracking , customer support
PROJECTS:

Cargo Management system

A complete software solution for tracking cargo management .

Developed for Prominent Cargo,W Island cochin . This application handles all activities of cargo management.

Pharmacy Management System

Developed for a leading Medical Shop in Fort Cochin.

The software handles Medicine sales & inventory for Wholesale as well as retail

Accounting Software

For Nambudiris Pickles, Todupuzha

From Sep- 2002 To Jun 2003

Worked in ZeroOne Technologies, cochin for 4 months as Junior Programmer but didn’t continued for long time due to some personal issues, So This period I am taking as gap which caused by circumstances.
Trainer , Aptech , Computer Education ,cherthala, Kerala( jan-2001 to aug-2002)
Taking Classes for ACCP curriculam, Helped to improve my OOPS,Java, VB and C++ skils.

Assisted Professional College Students in their Projects
Sharma Softwares , Kathri Kadavu, Kaloor, Cochin.

Software Trainee [ March 1997 TO Dec1997 ]

Developed and learned the software designing by working in some real time inventory and production systems using oracle 7.x and Power Builder 5.0. left the firm for joining MCA
Personal Details
Date of Birth : 22nd April 1975.

Languages Known : English, Hindi & Malayalam (Read, Write & Speak)

Marital Status : Married with one child.

Passport Number : F 8006915

Permanent Address : Sai Syam, Pallippuram P.O,

Chertala, Pin. 688541, Kerala.

Contact : GSM: +968 95124145
e-mail : praveenraj.rajappan@gmail.com

| Page

Share in:

Related:

Reports and Forms 6i/9i/10g/11g icon1. Prerequisites for Siebel 1 11 and ohs 11g on Linux Servers

Reports and Forms 6i/9i/10g/11g iconTesting the Oracle Database 10g Client Installation 7

Reports and Forms 6i/9i/10g/11g iconNote: the following forms are generic and are not a substitute for...

Reports and Forms 6i/9i/10g/11g iconOracle Database 11g Express Edition – pl/sql and Database Administration Concepts

Reports and Forms 6i/9i/10g/11g iconAsp net web Forms – Sample Exam – September 2013 Poll System in asp net web Forms

Reports and Forms 6i/9i/10g/11g iconObtaining an Oracle certification gives you that much needed advantage...

Reports and Forms 6i/9i/10g/11g iconMany robust General Ledger reports are included with your Sage 100...

Reports and Forms 6i/9i/10g/11g iconAbstract apex interactive Reports have undergone major changes in...

Reports and Forms 6i/9i/10g/11g iconGuidelines and Forms

Reports and Forms 6i/9i/10g/11g iconReporting Forms




forms and shapes


When copying material provide a link © 2017
contacts
filling-form.info
search