Nisha John

Oracle Application Developer

Phone: +974-******** / +974-********, Email: adhda3@r.postjobfree.com Professional Summary

A logical, analytical thinker with exceptional database skills possesses rich experience of 2 years as Oracle PL/SQL developer

Expertise in Database designing and creation and excellent exposure to Oracle Applications 10g & support with Oracle Forms and Reports

Expertise in Software Development Life Cycle, systems development methodologies and Oracle Applications Implementation Life Cycle

Expertise in requirement analysis, designing, developing, implementing and executing a project support with Strong technical and business problem solving capabilities

Good functional knowledge in Oracle E-Business Suite EBS Oracle SCM and EAM Modules

Area of Focus

Technical

Experience developing with TOAD, SQL, PL/SQL, load scripts

Experience in a production support environment

Specialized experience in developing within the Oracle applications

Strong Oracle workflow, SQL Loader, Oracle Forms, and Oracle Reports skills

Strong technical and business problem solving capabilities

Comprehensive experience in testing and implementation of business systems involving Oracle Applications 10g & Ability to trouble shoot issues; work with the client and oracle support in resolving/addressing issues

Proficient in writing stored procedures, Packages and functions, views, cursors Exceptions, Joins, Sub Queries and Set Operators using SQL & PL/SQL

Translate business needs into technical deliverable solutions

Exceptionally good and experienced in handling the problem and troubleshooting.

Done junior level DBA activities like Table space creation, Schema creation, assigning roles, privileges and grants to users, backup, restore, Import and Export activities

Good knowledge in Performance Tuning of PLSQL using Bulk collect, Nested Table and Exception Handling extensively for the ease of debugging and displaying the error messages in the application

Worked with Pipelined function and Ref cursor to improve performance using PLSQL tables

Functional – Oracle EBS

Excellent knowledge & experience with Oracle E-Business Suite Supply Chain and Enterprise Asset Management/Tracking with good communication skills to interact with business users

Facilitate and actively participate in all phases of the Implementation cycle, to include Requirements Gathering & Analysis, System Design & Development, Testing, and Implementation

Suggest & execute solutions for the problem in hand and help mapping Oracle's best practices to business flows and requirements by implementing new modules and new system features

Guide technical consultant for any required customization, Report Generation and data upload

Consultancy and support of EAM modules by resolving user issues, collecting and managing business requirements and update the system based on them

Show initiative and creativity in developing innovative work-around solutions or new processes

Participate in Reports, Forms, Dashboards, & KPI customization

Trained Key users and End users and prepare the documentation and user guides for the implemented solution

Actively participate in the troubleshooting phase up to UAT Skills Summary

Assembly Languages : 8085, 8086

Databases : Oracle 10g, My SQL

Oracle Tools : Toad, SQL * Plus, Forms Developer, Report Developer

Languages : SQL, PL/SQL, C, C++, HTML, JavaScript, Aj ax, j Query, PHP

Operating Systems : Windows, Linux

Work Experience

Regency Group Holding, Doha, Qatar - Aug 2017 - Dec 2018 Client : Regency Travels, Alasmakh Real Estate.

Role : Oracle Application Developer

Back-end : Oracle Database 10g, Oracle forms & reports 10g Regency Travels is airline travel agency, as a developer my work will start once agents issue the ticket using ticketing tools like Amadeus and Galileo. This tool will generate one file which will have all the ticket information. We will process those files and store information in database. We have provision to invoice and post it finances...etc. created reports like destination wise, country wise ... etc. Real-estate is renting property company. In system we maintain all the properties, properties which are vacant, occupied and leased. Posting data to finance. Created reports like vacant properties list, property list.etc. Modules:

Finance: Accounts payable, accounts receivable, fixed assets, and general ledger, cash management, and billing (contract/service), financial reports, reconciliation

Human Resource: Recruitment, benefits, compensations, training, payroll, time and attendance, labor rules, people management

Air Travel: Invoice Creation - Air travel and Tours, Credit note preparation, Finalization, Merging, FPN & PPN Preparations

Real Estate: Unit Masters, Enquiries & Bookings, Renting, Marketing, Contact Masters, Tenants List, Assets, Maintenance, Receipts, Invoicing, Expenses, Income Entry, BI Query

Orisys India, Trivandrum, Kerala, India Dec 2013 - July 2014 Role : PHP Programmer

Back-end : PHP, MySQL

Responsibilities:

design and development of web applications using front-end technologies, such as PHP, JQUERY, HTML and CSS front end design to provide product info and customer services and back-end technologies such as PHP, Codeigniter framework

Used JavaScript for validation in different web pages

Debugged and tested the codes & Maintained documentation

Created Queries and Tables using MySQL

Education Summary

M-TECH (2011-2013) (Computer Science & Engineering) [CALICUT UNIVERSITY]

B-TECH (2006-2010) (Computer Science & Engineering) [KERALA UNIVERSITY]

Academic Projects:

Main Project (M-Tech): A New Approach For The Detection Of Black Hole Nodes In AODV Based Mobile Ad-Hoc Networks

Technology : Ns2

Main Project (B-Tech): Virtual University

Technology : Asp.Net, Sql Server 2005, Visual C#, Xml, Visual Studio .Net 2005 Mini Project (B-Tech): Graphical Implementation Of Data Structures Language: C++

Publications:

“A New Approach for the Detection of Black hole nodes in AODV based Mobile ad-hoc Networks'' in Proceedings of International Conference on Computer science & Information Technology (CSIT), pp. 16-21, Kanyakumari, January 2013

" Prevention and Detection of Black Hole Attack in AODV based Mobile Ad-hoc Networks - A Review” International Journal of Scientific and Research Publications, Volume 2, Issue 9, September 2012, ISSN 2250-3153.

"A New Approach for the Detection of Black hole Nodes in AODV Based Mobile Ad- Hoc Networks" in International Journal of Engineering Research & Technology

(IJERT), Vol. 2 Issue 1, January- 2013, ISSN: 2278-0181 Trainings & Certifications:

Microsoft Certified Professional (2010)

NIIT Certification in Developing Web Applications Using ASP.NET 2.0

Participated in professional training program on Research Methodologies by MES College of Engineering, Kuttippuram

Participated in International Conference on Computer Science & Information Technology (ICCSIT - 2013) organized by IOAJ, Kanyakumari

Attended in the Workshop on Fundamentals of Linux & Python Programming by MES College of Engineering, Kuttippuram

Personal Information

Date of Birth : 11-10-1988

Sex : Female

Nationality : Indian

Marital status : Married

Visa status : Resident visa

Driving License : Valid Qatar Driving License

Languages known : English, Malayalam

References:

MANESH KUMAR

Senior Oracle Developer at Regency Group Holding, Doha, Qatar Email : adhda3@r.postjobfree.com / adhda3@r.postjobfree.com Mobile no: +974-****-****

BIJU KN

Finance Manager at Regency Group Holding, Doha, Qatar Email : adhda3@r.postjobfree.com / adhda3@r.postjobfree.com Mobile no: +974-****-**** / 444 03815

Contact this candidate