B.VINOTHINI Email : **********.***@*****.***
Mobile : 897-***-****
CAREER OBJECTIVE:
Seeking a challenging position that offers professional growth opportunities to improve my skills to dedicate myself in challenging technical profession, expanding the business growth and work for the development of the company.
PROFESSIONAL SUMMARY:
Nearly Three years of experience in the Oracle PL/SQL software analysis.
Experience in Oracle Forms and Reports 10g/11g.
Experience in Oracle SQL, PL/SQL. Skilled in Application development using Oracle Forms and Reports with knowledge in master-detail blocks, forms triggers, system variables, multiple form applications, menus, alerts and LOV's.
Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
Good knowledge in SQL queries, Views, PL/SQL procedures, functions, packages, triggers, cursors, collections, cursor variables, System reference cursor.
Bulk data Collecting, Performance tuning of huge data with use of PLSQL collections and records.
Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
Knowledge in query optimization and exposure using Hints, GTT.
Knowledge in loading data using SQL*Loader.
EDUCATION QUALIFICATION:
2016 B.Tech degree in Computer Science Engineering from Periyar Maniammai University, Thanjavur and Secured an Aggregate of 9.6(CGPA).
2012 Higher Secondary from St.theresa’s Girls Higher Secondary School, Nagapattinum (State Board) and secured an aggregate of 75.90%.
2010 SSLC from St.theresa’s Girls Higher Secondary School, Nagapattinum (State Board) and secured an aggregate of 90.60%.
PROFESSIONAL EXPERIENCE:
Oracle Developer
NewAge Software & Solutions June -19 to Present
Client : Freight Systems Logistics.
Domain : International Freight Forwarding.
RESPONSIBILITIES:
Involved in requirement gathering.
Created new PL/SQL Procedures and Functions with given finance requirement.
Modified Packages, Procedures, Functions and Triggers for designing user interface.
Designed Oracle Forms and Reports 10g/11g.
Good expertise in database scripting PL/SQL.
Developed a application using Oracle Forms with master-detail blocks, forms triggers, system variables, menus, and LOV's.
Modified existing Oracle Report with client given requirements. Customer Support Representative
HCL Technologies March – 17 to May – 19
Title : CAQH (Council for Affordable Quality Healthcare)
Client : Aetna
Domain : Health Care
RESPONSIBILITIES:
Monitor the metric alerts, performance related issues like high CPU utilization, Application performance, high Memory utilization, Application tuning and Query tuning.
Designing Tables, Views, Materialized Views, Stored Procedures, Functions, Triggers and Adding Constraints to Columns.
Coded business requirements with PL/SQL Packages, Functions, Procedures to perform data loading, error handling and logging.
Used SQL loader to load data from the flat files provided by the interfacing applications. Used XML and UTL_FILE for improvement of performance.
Prepared Test cases and Unit Testing.
Involved in SQL Query Tuning.
Resolved issues with assigned SLA and Prepared root cause analysis for issues occurred. Highlights:
Recognized for Best performance and have been received “Star Performer award” in June 2018.
Efficiently introduced new ideas for process development. TECHNICAL SKILS:
Languages : Oracle SQL, PLSQL
Database : Oracle 10G,11G
Tools : SQL Developer, Toad,
Operating System : Windows, Linux.
PERSONAL PROFILE:
Father’s Name : T.Balraj
Date of Birth : 01-04-1995
Marital Status : Single
Gender : Female
Languages Known : English, Tamil
Nationality : Indian
Address : 2/240, Sri Renugadevi Amman Kovil Street, Tharangambadi, (PO) (TK),
Nagapattinam (DT).
DECLARATION:
I hereby declare that all the details furnished above are true to the best of my knowledge and belief. DATE :
PLACE :
(B.VINOTHINI)