Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic

Kapil Andhale

Associate Support Engineer
Pune

Summary

  • Over 2.5 years of diversified experience working in the Information Technology industry.
  • Skilled at Analysis, Design, Development, Support, and Performance tuning of applications using Oracle SQL, and PL/SQL. Worked with a financial client, and implemented business driven functionality using Oracle 11g/10g for development, data conversion, and migration projects.
  • Excellent skills in writing PL/SQL Stored Procedures, Functions and Packages using Oracle 11g/10g.
  • Expertise on Ref Cursor, External Tables , Dynamic SQL, Collections and records and Exception handling .
  • Strong experience in Cursor management, Exception Handling, performance tuning (PL/SQL), and optimization of SQL statements using SQL Trace, Explain Plan, Indexing, and Hints.
  • Expertise in creating and maintaining Table Partitioning, Collections and records, Analytical functions, Materialized Views, Query Re - Write , and Transportable table spaces.
  • Experience in Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Datastage as ETL tool on Oracle.
  • Expertise skills in using the tools TOAD, SQL *Loader, Oracle SQL Developer and Oracle utilities like DBMS PIPE, UTL FILE, Exp, Imp and Data pump.
  • Experience with Agile practices such as Backlog Grooming, Sprint planning, Story sizing, Story Prioritizing, Standup meetings, and User Story Demos on Agile Project implementation.
  • Having Good understanding and experience of Object Oriented Concepts.
  • Wrote Queries to retrieve data in XML format from the tables.
  • Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP , and Exp/Import .
  • Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.

Overview

3
3
years of professional experience

Work History

Associate Support Engineer

Codify Software Services
06.2021 - Current
  • Broke down and evaluated user problems, using test scripts, personal expertise, and probing questions.
  • Documented technical issues and solutions to enable tracking history and maintain accurate logs.
  • Implemented technical solutions to solve customer issues and increase satisfaction.
  • Suggested software and hardware modifications to reduce lag time and improve overall speed.
  • Communicated with clients to verify roots and causes of computer problems.
  • Responded to customer inquiries and provided technical assistance over phone and in person.

Education

Bachelor of Engineering - Electronics And Telecommunications

Smt.Kashibai Navale College of Engineering
Vadgaon Bk Pune
04.2001 -

Skills

Application Support

undefined

Additional Information

  • PROFESSIONAL EXPERIENCE:
  • Project 01:
  • Title: Smart Banking System (Apna Bank)
  • Client: Hexaware Technologies
  • Duration- Sept 2021 to Nov 2022
  • Oracle PL/SQL Developer
  • Environment: Oracle 10g/11g, SQL, PL/SQL, SQL *Loader, UNIX Shell scripts, SCCS, Clearcase, Agile and Waterfall methodologies, Windows XP, JIRA, MS Excel, Putty, notepad++ etc.
  • Description:
    Internet banking system is an online Banking System, which helps the Customers to make online transactions. This banking system contains two types of transactions. They are customer Transactions and bank transactions. In this banking system when user enter his customer id and password. Then it will display the list of transactions like balance enquiry, transaction enquiry, Transferring money from one account to another account, fixed deposit position, fixed deposit renewal, cheque status. Involved in the testing of all the six modules
  • Responsibilities:
  • Written PL/SQL Procedures, Functions, Packages, and SQL Scripts using Oracle SQL and PL/SQL.
  • Developed data model, PL/SQL Queries, SQL Query tuning process, and Schemas.
  • Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.
  • Experience working with Oracle CLOB, BLOB, Materialized Views, Ref Cursors, Index Organized Tables, Partitions, Objects/Collections, Execute Immediate etc.
  • Formulated SQL queries, functions and processes as per requirement.
  • Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages.
  • Worked with developers to repair and enhance current base of PL/SQL packages to fix testing issues.
  • Built new functionality and improve processing time through code optimizations and indexes.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like Oracle Hints, EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
  • Written packages, triggers, stored procedure and functions for Solvency project which involved retrieving data using FTP, scheduling through AUTOSYS, extracting and loading using ETL (DataStage) and PL/SQL.
  • Responsible for Unit Testing of Database PL/SQL Packages, Procedures, Functions and Database Triggers.
  • Defect tracking through JIRA and defect summary reporting.
  • Proficiency with SCCS and Clearcase version control systems.
  • Worked on agile and test driven environment, participated on daily scrum meeting, and discussions.


  • Project 02:
  • Title: Insurance Transaction CMS.
  • Client : Syntel/Atos
  • Duration- Dec 2022 to till date
  • Oracle PL/SQL Developer
  • Environment: Oracle 10g/11g, SQL, PL/SQL, SQL *Loader, UNIX Shell scripts, SCCS, Clearcase, Agile and Waterfall methodologies, Windows XP, JIRA, MS Excel, Putty, notepad++ etc.
  • Description:
    This application is developed for Insurance Company usage. It provides information regarding the services and its policies. It also provides options like available policies and their benefits, terms and conditions and new schemes etc., It provides the information for different types of policies like Vehicle Insurance, Life Insurance, Home Insurance and Health Insurance, Children Insurance.
  • Responsibilities:
  • Involved in the complete life cycle of the product from requirements gathering to end of system testing.
  • Worked on developing a financial application system to handle all the bank transactions usingSQL,PL/SQL,Developer 2018(Forms4.5 and Reports2.5) on Windows environment.
  • Worked as a librarian to maintain the system application design using Designer2000 tools.
  • Used SQL*Loader to load the database from flat files.
  • Created new Tables, Indexes, and Sequences where needed.
  • Created database triggers for data security & Consistency.


Timeline

Associate Support Engineer

Codify Software Services
06.2021 - Current

Bachelor of Engineering - Electronics And Telecommunications

Smt.Kashibai Navale College of Engineering
04.2001 -

Similar Profiles

CREATE PROFILE
Kapil AndhaleAssociate Support Engineer