Sql Oracle
Resume:
Ajit Adhyaru
Des plaines
IL – 60016
***********@*****.***
Summary:
More than 8 years’ experience with proven ability in the area of Mainframe , Client/Server and Distributed Multi-tier Application Development, Database Design, Data processing and Support mainly using Oracle technology on different platforms.
More than 8 years’ proven experience in Oracle Forms, Reports, SQL and PL/SQL that includes Cursors, Ref-cursors, Procedures, Functions and Packages, Triggers, Materialized Views, Table Indexing, , SQL*Loader etc.
Expertise in Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER , External table and Calling Appropriate Interface tables and API’s.
Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
Expert in Query Optimization, Debugging and Tuning for improving performance.
Knowledge of command in UNIX/LINUX.
Strong interpersonal skills, ability to interact with people. Good presentation skills.
Before Oracle I was working On Basic language and then Foxpro language.
Total 29 years work experience of progressive IT development and support.
Technical Proficiency:
Languages SQL, PL/SQL, SQLPLUS, Developer 2000 Forms and Reports
RDBMS Oracle 10g/9i/6i/5.0 , MS Access
ETL SQL, PL/SQL
Other Tools TOAD 8.0/8.5/9.0, SQL Loader, Export, Import ,MS Office , Basic and FoxPro Language
Operating Systems Unix, Linux, Windows
Professional Experience:
Client: Indian Farmers Fertilizers co-operative ltd .(Kalol Unit - India) [MAY 1988 - MAY 2011]
Role : Forms and Reports , SQL, PL/SQL Developer
Designed and created complex PL/SQL code for the Migrating data from Mainframe, Flat files into Oracle database tables for BI purpose.
Developing and Modifying Oracle Forms and Reports (10g,9i,6i).
Extensively Works on project like Financial Accounting System, Technical Reporting System , Inventory Accounting System, Personal Information System.
Developing and Modifying Packages, Stored Procedures, Functions, triggers, grants and Developing and modifying PL/SQL packages , SQL Scripts to load data from different sources clean and transform data to provide quality information, and manage corporate metadata.
Developed Database Triggers for the integrity and security purpose.
Extract data into Oracle table using SQL LOADER.
Knowledge of using TOAD 9.0 (quest Soft)
Prepare Proper Documentation and Decode Mapping for further upgrade of code.
Created Complex SQL script, Dynamic SQL, Analytical function.
Client: Rohit Textile Mills , Ahmedabad, India [May1981 - May 1988]
Role: Computer Operator
Task:
Collect Data from all section. Confirm that all data are entered in System, Create a checklist / Error List through program and Confirm that all correction have been made. Then run reports and print all analytical reports. Make file of all report and then present it to top management.
EDUCATION :
Bachelor of Science
Post Graduate Diploma in Computer Application
Certifications:
• Business Programming Through COBOL from Computer Society Of India, Ahmedabad Chapter
• Participation training on LOTUS NOTES (R4.5) on system administration.
• Participation training MS-Windows, MS-word, MS-excel.
Contact this candidate