Front End Performance Improvement

RESUME

D. Pavithra Email: *****************@*****.***

Mobile: +91-861*******

CAREER OBJECTIVE:

I would like to work in a creative and competitive environment where there is an opportunity for continuous learning, knowledge exchange, professional growth and time for personal commitment.

EXPERIENCE SUMMARY:

Industry Experience: (4 Years and 0 Months)

Working as Programmer in Information Dynamics India Pvt. Ltd., Taramani, Chennai from June 2021 to till date.

PROFESSIONAL EXPERIENCE:

Proficient in the creation and modification of database objects like stored procedures, Functions and Packages using SQL and PL/SQL.

Experience in PL/SQL collections and Bulk collect and Pragma Autonomous Transaction.

Having experience in creating Views and Materialized Views

Experience in Cursors, Exception Handling and oracle supplied Packages.

Experience in writing SQL Queries and optimizing the queries.

Fine tuning PL/SQL objects for performance improvement.

Experience in interacting with clients at various stages of project.

Ability to be an effective Team player and work under time constraints.

Involved in the support, maintenance and development of critical systems.

Possess good analytical, and problem-solving skills, ability to meet deadlines, and work on multiple projects.

PROJECTS:

Project 1:

Project Title : AFSYS

Technology used : Oracle-SQL, PL/SQL.

Client : TS-Lines

Duration : Jan’2022 to Till Date.

Roles and Responsibilities:

Coordinated with the front end design team to provide them with the necessary stored procedure and packages and necessary insight into the data.

Involved in the support, maintenance and development of critical systems.

Created Database Objects such as Tables, Views and Synonyms.

Developed SQL scripts to transfer tables across the schemas and databases.

Having good experience in interaction with clients and deal with their requirements.

Analyze system metrics and identify potential bottlenecks that may hinder performance.

Project 2:

Technology used : Oracle-SQL, PLSQL.

Client : Axis Financial Limited.

Duration : Jun’2021 to Apr’2022.

Roles and Responsibilities:

Actively involved in production support, resolving post-go-live issues, and implementing enhancements.

Created indexes and optimized queries to improve database performance and ensure fast data retrieval.

Worked on performance issues and used EXPLAIN PLAN for tuning the queries.

Developed and modified packages, stored procedures, functions.

Created Tables, Views, Constraints and Indexes.

Extensively used bulk collection in PL/SQL objects for improving the performing.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching

EDUCATIONAL QUALIFICATION:

●Completed ME-Communication Systems from Bannari amman inst of Technology, Sathyamangalam with 83%.

DECLARATION:

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

Place: Chennai Yours truly

Date: (D. Pavithra)

Contact this candidate