Tushar P.

• Over 16 years of progressive experience in the areas of Oracle PL/SQL development, Environment Configuration Management & Technical Integration. • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. • As a Database Team Lead involved in building a cohesive team structure to drive the company’s vision to viable realizable goals. • Functional experience includes Payments Applications, Telecommunications, HR/Payroll Applications and Insurance Applications. • Strong skills include SQL, PL/SQL in Oracle 11g/12c; SQL, T-SQL in Sybase and MS SQL Server 2000, UNIX, LINUX. • Developing complex Stored Procedures, Functions, Packages and Triggers using PL/SQL. • Developing materialized views for data replication in distributed environments. • Loading Data into Oracle Tables using SQL Loader. • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. • Performing periodic maintenance tasks like Table Partitioning, Index rebuilds, Statistics Collection and data purge to ensure efficiency and reliability of the applications and databases. • Shell scripts and SQL updates for reference data based on High Level Design/Low Level Design. • Query Performance Tuning for Oracle RDBMS using Explain Plan and HINTS. • Creating and scheduling jobs using DBMS_JOB and DBMS_SCHEDULER. • Problem determination and Trouble shooting in Development, Test and Production Environments. • Environment Configuration Management by Integration of the Patches, Installation and Configuration of HR Design Client/HRD Studio, DDL deployment, Execution of Jobs and Bug fixing. • Analysis and development of Batch Programs using the Business Rules/Code of the existing system.