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:

• Oracle, MySql, MS Access
• SQL, PLSQL, Core Java
• Oracle Forms & Reports 10g
• Core JAVA
• MS Office, Open Office
• Data Warehousing
• Toad, PLSQL developer

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.