HARIPRASATH. R
*********@*****.***
Objective
To be a part of professional managed company with a scope of challenging career, opportunity for learning, excellence and continuous improvement. To work and grow in an environment where performance is rewarded with new responsibilities and challenges. Professional Summary
Around 2+ years of experience in Application Development using Oracle SQL, PL/SQL and Oracle Application Express (APEX).
Proficiency in Analysis, Design, Development,Testing and Maintenance of applications in Oracle Application Express (APEX).
Experience on writing Stored Procedures, Packages, Functions, Cursors, Triggers, Views and Indexes, Anonymous blocks, Sequences.
Creation of database objects like tables and Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Experience in creating Oracle Apex Collections.
Worked with Oracle Apex cards, interactive and classic reports.
Experience in creating APEX Forms and Tabular forms.
Experience in developing forms based on views, tables and procedures in form layouts.
Working with APEX Page/Application level items, Page Processing and Dynamic actions.
Extensive working knowledge related to Complex SQL Queries.
Developed Flash and HTML charts using APEX 19.1/ 20.
Experience in IONIC 3 framework, Type script, HTML, CSS Technical Skills
Work Experience
Worked as a Software programmer at Roadmap IT Solution Pvt. Ltd., from DEC 2017- JUL 2020 Roadmap ERP is a fully integrated business solution that gives organization in a complete control over the planning and management of all faces of their operations including modules Purchase Order Management,Sales & Distribution,Planning & Manufacturing,Human Resource Management, Inventory Control Management,Finance Management,Costing. Language Oracle SQL, PL/SQL,Apex,CSS, HTML,Typescript Operating System Windows 8,Windows 10
GUI Tools Oracle APEX 18.1/19.1/20,IONIC 3
Back-end Tools SQL*Plus, Toad for Oracle.
Database Oracle 11g /12c
Projects Details
Project # 1 :
Client : Top Anil Marketing Company, Dindigul
Responsibilities:
Developed necessary PLSQL functions, stored procedures, triggers .
Involved in Development of Dashboard using charts and reports as per the client requirement.
Created Scripts to create tables, views, queries for new enhancement in the application using TOAD,SQL* Plus.
Foods (
Project # 2 :
Client : Clarion Cosmetics Pvt. Ltd., Chennai
Responsibilities:
Developed necessary PLSQL functions, stored procedures, triggers.
Create form and validate the form in oracle apex.
Created Scripts to create tables, views, queries for new enhancement in the application using TOAD,SQL* Plus.
Project # 3:
Client : Kenbiolinks Pvt. Ltd., Vellore
Responsibilities:
Developed necessary PLSQL functions, stored procedures, triggers.
Create form and validate the form in oracle apex.
Create tabular form to insert,update and delete the multiple rows.
Created Scripts to create tables, views, queries for new enhancement in the application using TOAD,SQL* Plus.
Project # 4 :
Client : Manatec Electronics Pvt. Ltd., Pondicherry Responsibilities:
Developed necessary PLSQL functions, stored procedures, triggers.
Create form and validate the form in oracle apex.
Create tabular form to insert,update and delete the multiple rows.
Created Scripts to create tables, views, queries for new enhancement in the application using TOAD,SQL* Plus.
Roles &Responsibilities
Developed Procedures and Functions and written complex SQL queries using joins, sub queries.
Responsible for developing interactive Reports, data entry forms, hypertext linked reports using Oracle APEX 19.1 / 20.
Created Oracle Apex Application from Scratch for few applications
Formulated SQL queries, functions and processes as per customization requirement for APEX.
Export and then import an Oracle apex application.
Created region type, item type and dynamic action plugins using the APEX Plugin functionality.
Created Developed Dynamic Actions to enrich the user experience, minimize user interaction and reduce key strokes.
Developed and implemented different item types re-sizable text area, data picker, number field, and new rich-text editor using Oracle APEX 19.1 / 20.
Developed Template design for particular reports.
Developed various types of regions ( Report, Form, Chart, List) using Oracle APEX 19.1 / 20 depending upon the requirements, which is a part of page rendering process of the Application.
Involved in the solving the tickets that are raised by the end users. Education Qualifications
Completed M.C.A from Sri ManakulaVinayagar Engineering College, Puducherry in year 2017 with 70%.
Personal Details
Name : HARIPRASATH. R
Father’s Name : RAJENDIRAN. S
Mother’s Name : SUGANTHI. R
Date of Birth : 19.07.1994
Gender : Male
Nationality : Indian
Contact Details : No. 21,Saraswathi Nagar, Panruti - 607 106 Languages Known : Tamil, English (Read, Write and Speak), Kanadam (Speak only). Declaration
I hereby declare that all the information mentioned above is true to the best of my knowledge. Date: Yours Faithfully
Place: (HARIPRASATH. R)