- 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.
- Oracle, MySql, MS Access
- SQL, PLSQL, Core Java
- Oracle Forms & Reports 10g
- Core JAVA
- MS Office, Open Office
- Data Warehousing
- Toad, PLSQL developer
- 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.