Shanavas Appat
Abu Dhabi Aircraft Technologies
Abu Dhabi, UAE
*****.*******@*****.***
+971-**-******* Functional Consultant – Oracle E Business Suite, SCM
Self Portrait
Optimistic and self starter with 9 years experience in UAE and 3 years experience in India. Profession is
marked up by abilities, skills, simplicity assisted by sincerity, strong and smart work ethics
Summary
® 9 Years IT experience in Aviation Industry
® Functional experience in Oracle EBS SCM : INV, PO, OM, Execution and Install Base
® Techno functional experience in Mainframes – Maxi Merlin Material module
® Exposure in creating various Discoverer reports related to SCM
® Exposure in Creating User Requirement Specifications, Functional Requirement Specifications and
Business Process Flows
® Exposure in developing and writing Test Plans, Test Cases and Test Scripts to perform User Acceptance
Testing (UAT)
® Extensive Support to production environment by interacting with users and establishing the process to
be followed
® Conducted End User training on the transaction entry in Inv, PO, and OM Modules
® knowledge in Software Development Life Cycle SDLC
Qualification
® MCA Master of Computer Applications, Madurai Kamaraj University, India, 2000
® BCom Bachelor of Commerce, Calicut University, Kerala, India, 1997
® AIPP Advanced Internet Power Programming, Pentasoft Technologies, Kerala, India, 1999
® O’Level Diploma in Software Engineering, Ansar Computer College, Kerala, India, 1996
Experience
1. Abu Dhabi Aircraft Technologies – ADAT Functional Consultant: 2010 Present
ADAT is the largest independent third party provider of maintenance, repair & overhaul (MRO) services with
technical solutions for commercial aviation industry in the Middle East. Headquartered in Abu Dhabi, the
capital city of the United Arab Emirates (UAE), Company was launched in 2007 through the transformation of
the former Gulf Aircraft Maintenance Company.
Duties and Responsibilities:
Functional Area in ERP System: Oracle cMRO E Business Suite, SCM Module
® Conducted End User training on the transaction entry in Inv, PO, and OM Modules
® Post implementation Production Support in
® Inventory :
® Item Master and Organization Set up
® Material Issue, Return and other transaction errors
® Clearing pending transactions to process Inventory period closing
*****.*******@*****.*** p a g e 1
Shanavas Appat 971*********
® Item Receiving errors
® Item reclassification process (change of item type due to various reason)
® Well versed with staging tables used for data migration (bulk data)
® PO :
® PO Approval issues – (Retry/ Rewind etc) Item and Approved supplier list issue
® PO Receipt process and pending in interfaces
® Order Management(RMA, OSP, Sales Orders, etc) :
® Receipts, Reservation and Pick release, ship confirm errors
® Execution :
® WIP Issue/ WIP return – Material demanding, issuing and returning errors
® WO closure errors due to Materials
® Install base admin, transaction error processing
® Providing Support to the end User on Daily Issues
® Coordinate with Oracle in raising SR and getting the Solution
® Analyzing and resolving transactions stuck in shipping
® Resolved stuck transaction in Inventory open interface
2. Abu Dhabi Aircraft Technologies – ADAT Oracle Technical Consultant: 2008 2010
® Designing and building extensions and customizations to the existing PL/SQL programs to the
requirement of business users (Supply Chain)
® Designing new program modules as per the business requirements (PL/SQL)
® Developing Concurrent Programs, Reports using XML BI Publisher etc
® Enhancing Discoverer reports / development
3. GAMCO Mainframe, Maxi Merlin Techno Functional Consultant: 2004 2008
Maxi Merlin is aircraft Maintenance and Engineering system in Mainframe Environment.
The job nature is to design and upgrade modules by performing requirement analysis for GAMCO’s internal
departments.
Key Duties and Responsibilities as a team player in Material management module:
® Extensions to the existing programs to the requirement of business users
® Design and development of material and engineering related reports
® Development of new program modules as per the business requirements
® Submitting periodical jobs as batch and export them to Oracle Discoverer
® Data analysis and uploading of OEM Price list
4. Sealan Technologies Ltd, India VB6.0, ASP, SQL Server Software Engineer, 2001 2003
The job profile was analysis and designing software system
System Analysis: The task is to study a system and to specify its requirements by building a working model of
it, which is understood by users.
System Designing: The task is to design a system after feasibility analysis using DFDs and Flow Charts,
Designing include Database design using Normalization concepts.
*****.*******@*****.*** p a g e 2
Shanavas Appat 971*********
5. Good Luck Info systems Programmer, 1999 2000
The job assignments were to develop software programs and to provide training to project
trainees.
Software Knowledge
Oracle
® Knowledge in Concurrent Programs, XML BI Publisher, Alerts, Reports, Organization configuration,
department/ zone setup, lookups etc
® Medium level knowledge in OAF, J2EE, Alerts
® Knowledge in Oracle Discoverer (Business Intelligence)
® PL/SQL, WinSCP, Putty and basic unix shell scripts and applying patches
Mainframe
® Natural/ ADABAS
® Maxi Merlin – Materials and Engineering modules
Microsoft
® Visual Basic 6.0, MSSQL Server, FoxPro, MSAccess
Others
® C’Language, Cobol, Pascal, Dreamweaver, ASP, VBScript etc
Personal profile
Date of Birth 02 May 1976
Sex Male
Citizen Indian
Marital Status Married
Passport K4624377
Contact 009**-**-*******
Residence UAE
Email *****.*******@*****.***
*****.*******@*****.*** p a g e 3