PLSQL Developer Resume

SUMMARY:

Around 5 years of Experience in software application development using Oracle SQL, Java and Oracle Forms and Reports.
Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
Excellent conceptual knowledge of Oracle 10g/11g, PL/SQL and SQL.
Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System cursor, Dynamic SQL.
Experience in developing External Tables, Joins, Indexes and sequences.
Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning
Experience in using DBMS SCHEDULER to run jobs in parallel to improve time - constrained performance.
Good knowledge in front end development using oracle forms /reports 10g.
Experience in developing forms based on views, tables and procedures in tabular and form layouts.
Experience in Client handling, Application Maintenance and developing unit test documents.
Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

PLSQL Developer

Responsibilities:

Aim of this application is to provide an investigation system, which will filter out the unaccounted money from every individual in a country in order to help the government or Public authorities for their investigations.
It also maintains tax calculations, tariffs followed by the government.
Government and Non-Government sectors are providing plenty of options for people to save their lives and properties from accidental damage, natural loss, etc... through insurance system.
This application helps the user to find optimistic insurance option for their lives by providing problems and solutions for the selected systems.
And also various performances of the productions are running in each theatre over a week period.
Hence I have designed data mart to get intelligence information from available data to improve their business on sales.