Deepak Navale Email & Phone Number

Pune

Sofware Engineer at IBM-Vodafone project on Netconnect's payroll.

Designing of Database.Development of ETL program to Extract, Transform and Load data into Oracle database.Writing complex SQL queries and PL/SQL procedure to extract data from various source table for loading into data warehouse. Implementation of Proper Indexing Strategy improves performance of SQL queries.Functions, Procedures and packages in PL/SQL used to implement business logic.Loading data from flat file into oracle database table using SQL loader.Loaded large… Show more Designing of Database.Development of ETL program to Extract, Transform and Load data into Oracle database.Writing complex SQL queries and PL/SQL procedure to extract data from various source table for loading into data warehouse. Implementation of Proper Indexing Strategy improves performance of SQL queries.Functions, Procedures and packages in PL/SQL used to implement business logic.Loading data from flat file into oracle database table using SQL loader.Loaded large amount of data (up to 20lack row) into oracle table using Cursor and utl fileResolved data quality issues during data extraction and loading process (Exception handling SQL Loader bad file).Implementation of functionality using Database Insert, update and Delete triggers. Show less

Netconnect (IBM-VODAFONE); Responsible for creating shell script , function , procedure used to implement business logic.Interacting with Business users, gathering and analyzing requirements.Involved in data migration from Excel Sheets (CSV files) into the respective Oracle Database tables using SQL* Loader scripts.Performance tuning of SQL queries consisting of many tables with large amount of data.Created PL/SQL packages, procedures and functions that extensively… Show more Netconnect (IBM-VODAFONE); Responsible for creating shell script , function , procedure used to implement business logic.Interacting with Business users, gathering and analyzing requirements.Involved in data migration from Excel Sheets (CSV files) into the respective Oracle Database tables using SQL* Loader scripts.Performance tuning of SQL queries consisting of many tables with large amount of data.Created PL/SQL packages, procedures and functions that extensively used PL/SQL cursors, user defined object types, exception handling.Loading data from flat files into to database tables using SQL* loader.Automating data loading, extraction, report generation using UNIX shell scripting.Responsible for the production support and bug fixing.Performance monitoring and tuning of SQL developed by various developers.Developed various UNIX Shell Scripts to automate the routine tasksActive involvement in Optimization Process through database capacity planning, creation of materialized views, partitions, tables, views, indexes etc as. Tuned and optimized SQL statements. Environment: - Oracle 9i/10g, SQL, PLSQL, UNIX, SQL loader, Shell Script, TOAD, Windows XP, HP-UX. COMPANY:- Focus Info techProject Title : Extract Transfer Load (ETL). Show less

Managing Database of Vodafone.

Hsc

Ssc