RaghulV
11/88, Bazzar Street
Paundamangalam(PO),
P.Velur(TK),Namakkal - 637208.
Email: Mobile No: +971-544481231
WhatsAPP : +91-9952211789
Career Objective
Continue to develop the potentials in the professional career and to grow to a senior level of responsibility where I can make a significant contribution to the success of the organization.
Professional Summary
- Having 2 years 6 Months ofexperience in the areas of Oracle and PL/SQL based applications using Oracle PL/SQL and SQL Technologies under Windows WP/NT/2k, Linux Environments.
- Proficient in oracle Forms & Reports 6i/10g/11g and PL/ SQL programming.
- Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.
- Expertise in writing advance/complex SQL queries and PL/SQL.
- Having good knowledge of Software Development Life Cycle (SDLC).
- Good in Understanding of Business logic and ability to work well as a part of a team and as an individual.
- Ability to work in 24x7 environments, preparing root cause analysis and ensuring the action points
- Possess good analytical and programming capabilities.
- Looking forward to work as a team for the project based on the Oracle technology.
Academic Credentials
- MCA (Computer Application) inCSI Bishop Appasamy College of Arts and Science, Coimbatore with 73% aggregated during the period of 2011-2014.
- B.Sc,(Computer Technology) in AJK Arts And Science College, Coimbatorewith 60% aggregated during the period of 2008-2011.
- HSC from GOVT.Hrs.School, Paundamangalam with 71% aggregated in 2007-2008.
- SSLC from GOVT.Hrs.School, Paundamangalam with 62% aggregated in 2005-2006.
Technical Proficiency
Programming Environment:SQL, PL/SQL
Front End:Oracle Forms & Reports (6i,11g)
Web Design Language:HTML, CSS
Multimedia Application :Photoshop, Dreamweaver, Macromedia Flash
Database:MS Access,MySQL, Oracle 10g.
Working Experience
Organization / Location / Designation / Period Of WorkPSG Hospitals & IMSR / Coimbatore / Program Analyst / 2016-2017
Al Mulla Group EST / Sharjah (UAE) / Oracle Developer / 2018 - January
Key Technologies: Oracle Forms and Reports 6i, 10g&11g, PL/SQL, SQL.
In addition to my employment I have also gained substantial experience in the following Modules:
- Central Stores and Purchase Order System
- Asset Management System
- Equipment Maintenance
- Medical Records Department
- Ward Maintains System
- ERP For Production, Purchase, Finance, Sales
- Supporting and developing the all Business modules which are under the Al Mull Group. Like Automobile, Manufacturing, Logistics, Tourisms etc.
Project Details
Oracle ERP Developer
All Mulla Group EST. Dec - 2017 Present- Assisted in development and maintenance of Oracle Applications For Production, Purchase, Sales, Finance, Logistics, HRM
- Coordinated with Functional team of each department to understand the business application needs.
- Developed Custom code, Menus, Forms and Reports according to functional specifications.
- Resolved application relates issues by troubleshooting procedures and in collaboration with Manager.
- Provided technical expertise for designing and development of Oracle Applications through Oracle Reports and Forms.
- Communicated with senior management teams regarding project issues and status reports on regular basis.
- Strong knowledge in Flow of Finance, Production, Purchase, Sales, Maintains and Stores.
- Developed ERP for Automobile Business, Logistics, Tourism using with Forms and reports.
- Write, debug, database packages, procedures/ Function / Triggers in RDBMS using Oracle Technologies i.e. (SQL, PL/SQL) as per business requirement.
- Perform Enhancement (CRs), Customization and development of Screens / reports for product, Code Review, Testing and providing Technical Functional ERP Support.
PSG Hospitals & IMSR 2016-2017
Title : Hospital Room Status and Patient Detail View
Language:Oracle
Tool : Oracle Forms & Reports 6i
Role : PL/SQL and Forms, Reports Developer
Description:
This project aims to view the status of the hospital rooms (both special ward and semi-private ward) whether the room is occupied or vacant or pre-booked and also to know the details of current patient details like Patient code, patient name, Consulting Department, Consulting Doctor etc.,
Responsibilities
- Requirement gathering from the User Team.
- Convert the functional requirements into technical document as per the business standards.
- Worked as per the CR Raised from the end user.
- Analyze the Existing code and do the impact analysis.
- Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.
- Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.
- Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.
- Code validation as per client requirement.
Personal Information
Name: RAGHUL V
DOB: 22/MAY/1991
Linguistic Abilities:English, Tamil,Malayalam
Nationality:Indian
Declaration
I hereby declare that the above mentioned information’s are true to the best of my knowledge and belief.
Place :Sharjah (UAE)
Date :RAGHUL.V