Joemon P John

Working as part of a team developing an ERP named “Flotilla” for the freight forwarding Industry, serving customers all over Middle East, Africa and Asia. Modules included are Operations, Accounting, HR, CRM, NVOCC and Logistics.

• Expertise as an Oracle Forms & Reports Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System 19c and Oracle Application Express(APEX 21.2) with PL/SQL, JavaScript, JQuery, HTML & CSS
• Assigned to study customer requirements and helping the development team by implementing the data model required by the application with the help of SQL*Plus, SQLNavigator, SQLDeveloper & Toad.
• Creating schema objects and implementing rules for data integrity, which includes jobs like create, edit, and delete Tables, Views, Constraints, and Indexes.
• Writing server-side PL/SQL subprograms, client-side procedural code that use SQL statements, editing and debugging PL/SQL program units, Manipulating and exporting data, Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in Oracle supplied packages, Loading Data into Oracle Tables using SQL Loader, Collections and Exception handling, Creating database USER, ROLE and assigning Privileges, Hands on experience in EXPDP, IMPDP to export and import schemas and databases.
• Administer product implementation by creating schemas, table spaces, roles and other database objects required for the software
• Worked in Production Support Environment as well as QA/TEST environments for projects
• Created Interfacing modules to exchange data between other ERP software in file formats using REST API with payload formats in JSON, XML, TXT, XLS and CSV

• Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.
• Analyzed data to coordinate installation of new systems or modification of existing systems.
• Analyzed proposed technical solutions based on customer requirements.
• Collaborated with clients to define solution requirements.

▪ Supporting the management by generating customized tools for various reports using Microsoft Excel and VBA.

▪ This was done for a reputed insurance company based in UK whose back office is in India.

▪ Helped customers of a leading job portal to load their data into the website and also helping corporate companies to find candidates with required skillset.