JAIMON

SOJAN

ERP SPECIALIST

A bright, talented, ambitious and self-motivated Oracle developer with a strong technical background who possesses self-discipline and the ability to work with the minimum of supervision. Able to play a key role throughout the system development / support life cycle of a project to ensure that quality solutions meet business objectives. Possessing a good team spirit, deadline orientated and having the ability to produce detailed technical specifications from client requirements. A quick learner who can absorb new ideas and can communicate clearly and effectively. Currently looking for a opportunity to join a dynamic, ambitious, growing company and forge a career as a first class Software Engineer.

Phone: +974 - 31295330

E-mail: addm46@r.postjobfree.com

Doha-Qatar

Over 4 years of experience in the information technology services industry Expertise in Software Development life Cycle (SDLC) methodologies of ERP software (Customized ERP as per Company policy or ISO standard).

Strong experience in working with Oracle 6i/8i/9i/10g/llg forms and reports,oracle apex 5/18/19 including Pl/SQL programming. Effectively made use of Table Functions, Indexes,Table Partitioning, Collections,and Analytical functions,and lV!aterialized Views, Query Re-Write and Transportable table spaces.

Very strong in Oracle programming Well experience in web designing using HTML,JavaScript,CSS Good experience in creating complex functions, stored procedures and packages, triggers by using Oracle Pl/SQL.

Experience in analysis,design and development and maintenance of financial applications Experience in SQL and Pl/SQL tuning and query optimization tools like SQLTrace, Explain Plan,and RDBMS_PROFILER.

Experienced in providing application and user support Strong experience in meta-data about the ORACLE data base.

Expertise in ERP implementation, full business analysis for the current business processes in order to re-implement the ERP System.

Manage and provide leadership to teams of staff level professionals and becomes actively involved in staff development and practice management.

Strong communication,interpersonal skills, team player and contribute towards the team goals. Experience with Flutter, Dart, Firebase, Mysql, PHP. JAVA SCRIPT, CSS, HTML. Experience in authoring, testing, and deploying mobile applications. Oracle apex 5,18,19

Oracle forms and reports 6i,8i,9i,10g,llg

XML,SQL, Pl/SQL

web development : HTML, PHP, JavaScript, CSS/SASS, etc. Jasper Reports, i reports

RDBMS : Oracle, MYSQL

Operating System : Windows xp,7,8,10, windows server 2012,2012 R2,2016 and Linux Web Servers : Apache

Tools : Toad,SQL & Pl/SQL Developer,Visual studio,adroid studio,XAMPP PROFILE

SUMMARY

HIGHLIGHTS

EDUCATION

MSc Software Engineering (5 years integrated)

PSN College of Engineering and Technology Tirunelveli (2011-2016) EXPERIENCE Cortana Innovative Technologies (March 2016 - present) Participation in a medium-size Customized ERP system implementation through the full project life cycle. Responsible for the Demo, Requirement Collection, design, construction, unit test, code review and bug fix of allocated modules, DB Configuration, Implementation, Training, support to agreed time, quality and cost.

Participation in Mobile Application - BLUE TRUCK, Website -www.allinqatar.com Expertise in ERP modules - Accounts (Audit level experience),Purchase, Sales, Inventory, Work Order, HRMS, Project management, CRM, Distribution. Coupon Module, Fleet Management, Real Estate. Developed data model,PL/SQL stored procedures and functions to control access Developed HTML screens using JavaScript and CSS.

Maintained,trouble-shooted and enhanced the existing Oracle PL/SQL code to provide a user interface to Oracle forms and reports.

Involved in data and process modeling, standards development as per ISO Standards, meta-data management, SDLC & methodology.

Developed and fine tuned complex PL/SQL queries Worked with the Accounts Audit team to implementing new accounts policy into ERP.

Upgraded the existing oracle forms 6i to 10g using patch. Designed, developed Extraction, Transformation, SQL,PL/SQL utilities and provide solutions to critical issues enhancing performance and productivity to the project. Developed database triggers and stored procedures using PL/SQL cursors, tables, view, packages, procedures, functions, DB link and Materialized view SQL Maintained and enhancement of Oracle database,including complex business logic written in PL/SQL. Developed applications with PL/SQL,Database design and data modeling Worked on Performance tuning of SQL using Joins and data distribution.

Used SQL*Loader can be loaded from any text file and inserted into the database Utilized Oracle application express 4.0 (Apex) for user interface and Oracle database for consolidating the databases. Analyzed Oracle PL/SQL code and troubleshot to look for optimizations possible. Defining and generating screen formats and report designs. Conducted Oracle database and SQL tuning to improve performance of the application Developed Various Complex SQL queries, stored procedures, functions,Packages and Database triggers. Used SQL*Plus to execute PL/SQL programs,procedures and packages. Providing suitably tested fixes to defects within the sanctioned delivery process. Producing and updating relevant documentation.

Developing in accordance with policies regarding secure coding & standards. Meeting clients face to face and on site to ascertain requirements. Develop software in accordance with agreed design with consideration for usability, software quality and future maintenance.

Supported the application during production hours Responsible for vendor selection, requirements gathering, process analysis,project.

Monitored the performance tuning in oracle PL/SQL application. Created responsive website and mobile application using database oracle 11g. Configured windows server Mirror type, DYN vpn, NOIP configuration, Basic network connections. SOFTWARE ENGINEER

Certified Information System Auditor (CISA)

ISACA registerd member,not completed

Higher Secondary School - Commerce

St: De Paul Higher Secondary School Ankamaly (2009 - 2010) PERSONAL

DETAILS

Gender : Male

Nationality : Indian

Marital Status : Single

Date of Birth : 03-Jun-1993

Passport No : J4057615

Visa Type : Work Visa ( NOC or Transferable )

Joining Timing : Immediately - 2 Weeks

Contact this candidate