SUMMARY

• 9 years of experience in IT industry with 7+ years in Database Development in Oracle APEX and PL/SQL code, SQL, Procedure, Function, Triggers, Package, Views, Create Tables and performance tuning.
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and SQL .

TECHNICAL SKILLS

Databases: Oracle 10g/11g/12c

Database Management: PL/SQL and SQL

Web Technologies: HTML, CSS, and JavaScript

Tools: Oracle APEX 4.0 and 4.2, SQL Developer, Toad and JIRA

PROFESSIONAL EXPERIENCE

Technical Lead

Confidential

Responsibilities:

• Responsible for Development, enhancement and optimization of Oracle APEX applications.
• Interact with the client leadership team to determine acceptable technical solutions to business issues.
• User support, Bug Fixing, and Change Management (processing of service/change requests including communications with users/customers).
• Testing and Quality Assurance.
• Coordinate with other team members to accomplish key development tasks.
• Maintain flexibility in terms of business delivery needs and shift seamlessly to high priority requests.
• Well - organized with proven success in managing assignments to timely completion.

Technical Lead

Confidential

Responsibilities:

• Created SQL queries, functions, packages, materialized views and processes as per requirement for APEX.
• Supported APEX applications and conducted performance tuning for PLSQL.
• Contributed with database designs and assisted in increasing response time for APEX reports.
• Provide training and mentoring to team members in the development and maintenance of the systems.
• Followed agile methodology for the project with regular status reports.

Technical Lead

Confidential

Responsibilities:

• Created SQL queries, functions, packages, materialized views and processes as per requirement for APEX.
• Supported APEX applications and conducted performance tuning for PLSQL.
• Contributed with database designs and assisted in increasing response time for APEX reports.
• Provide training and mentoring to team members in the development and maintenance of the systems.
• Followed agile methodology for the project with regular status reports.

Technical Lead

Confidential

Responsibilities:

• Designed around 100 pages with Interactive reports, Master detail reports, charts, authentication, authorization and dynamic actions.
• Created users, user groups and provided authorization.
• Designed and developed various custom packages triggers and forms.
• Developed SQL queries, functions and processes as per requirement.
• Automated emails sent to CRA, Managers when the visit is due.