Shubham Roy

Oracle APEX developer using Pl/sql

 

Experience Summary:

1.6 year of experience as an Oracle Apex Developer and PL/SQL Developer.

 

Proficient in Oracle Apex, Oracle SQL, PL/SQL.

 

Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadline.

 

Experienced in designing Custom objects like Stored Procedure, Packages, Functions, Triggers, custom fields, Field Dependencies, Validation Rules, Workflows according to application/customer requirements.

 

Knowledge in Web Technologies like HTML, CSS, JavaScript. Undergone basic training in ASP.Net, MEAN stack development.

Excellent written and verbal communication and inter-personal skills accustomed to taking client calls regularly.

 

 

 

Work Experience:

August 2021 – Till Date: Working as “Software Engineer”.

July 2020 – July 2021: Worked as “Software Developer” in Sett Consultant, Kolkata.

 

Certifications:

ASP Dot Net from Globsyn Skills.

MEAN stack from Webidea Solutions LLP.

 

Educational Qualification

B.Tech (Computer Science & Engineering) from MAKAUT, 2019 with 7.14 CGPA.

 

Technical Environment:

 

Operating System

 

Windows

 

 

 

Language

PL/SQL, SQL

GUI

Oracle Apex 19.1,20.x,20.1,21.1

Tools

Oracle Data Base

Project Details:

Project: Payroll Management System. Environment: Oracle Apex 21.2 Duration: – Mar’21 - July'21 Responsible for:

• Going through the solution document, task sheet, and impacted components details. Verification of code with respect to functional change and identifying any other impacted components.
• Analysis and estimation of business requirements.
• Making the required changes in the code and daily updating status as per the tasks identified.
• Implemented Workflow.
• Testing software in controlled, real situations before it goes live.
• Customization of Forms and Reports as per user requirement.
• Generate payslip using AOP implementation

 

Project: Learning Management System(LMS).

Environment: Oracle Apex 20.1 Duration: Oct’20 – Mar’21 Responsible for:

• Involved in development of complete Application, Writing backend objects as PL/SQL Procedures, Packages, and Triggers using dynamic SQL
• Take part in UI-UX Development and unit testing.
• Testing software in controlled, real situations before it goes live.
• Use plug-in as per client requirement.

 

Project: Invoice Management System. Environment: Oracle Apex 19.1 Duration: Jan’21 – Apr’21 Responsible for:

• Analysis of the present code, workflow, data flow and impacted components details. Verification of code with respect to functional change and identifying any other impacted components.
• Analysis and estimation of business requirements.
• Making the required changes in the code and daily updating status as per the tasks identified.
• Testing software in controlled, real situations before it goes live.

 

I hereby declare that the information furnished above is true to the best of my knowledge and belief.

 

With Best Regards, Shubham Roy