Life Insurance Developer
Resume:
HARISH KUMAR E
***********@*****.***
PROFESSIONAL SUMMARY:
• Having 3.4 years of experience in Development, and Support Environments.
•Excellent SQL skills, working with database objects like tables, views, Materialized View, sequences, synonyms.
•Ability to work independently with the business users and IT team to gather project requirement.
•Experience in using cursor, Pragma Autonomous Transaction and collections.
•Basic understanding in performance tuning.
•Plan and supervise the daily activities of the Application support.
•Experience in using OLTP, OLAP, Data Warehouse Environment and Datamart.
•Basic knowledge in design the Data warehouse and Data migration.
•Developed Database Triggers for audit and validation purpose.
•Export and Import Database level or Schema level by using SQL Loader, External tables and utl_file.
•Experience in Oracle PL/SQL with solid understanding of key concepts, such as packages, triggers, procedures, functions, and cursors.
WORK EXPERIENCE:
Working as PL/SQL Developer in object frontier software, Chennai from December 2016 To till date.
EDUCATIONAL QUALIFICATION:
•BE (MECH) -6.9CGPA From Ranipettai Engineering College
TECHNICAL SKILL:
Databases : Oracle 10g/11g
DB & other Tools : SQL developer, TOAD
Programming : Oracle –SQL, PL/ SQL
Operating Systems : WINDOWS 2000/7/8.
PROJECT DETAILS:
PROJECT#1:
Client : Bank of Hawaii
Domain : Banking
Product Name : Corporate e-banking
Role : PL/SQL Developer
Description:
Corporate e-banking system is a comprehensive corporate and small business banking solution providing a single unified view of the corporate banking relationships across asset and liability products, limits, trade finance and cash management. Corporate customers of the bank gain the flexibility to view details of each account, capability to make Inter-bank and Intra-bank payments, access to trade finance information and transactions, and the ability to perform cash management activities. This also supports comprehensive authorization workflow, Transaction Limits, Electronic Invoice Presentment and Payment (EIPP) and Corporate Administration.
Roles & Responsibilities:
•Collected User Requirements by participating in meetings and studying existing System
•Understanding the business and its requirements carrying out impact analysis.
•Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
•Creating procedures and functions based on the requirements.
•Generated DDL Queries for creation of new database objects like views, sequences, synonyms, indexes, triggers, packages, stored procedures.
•Attend daily status meetings with the onsite coordinators along with Client.
•Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
Environment and Tool: Toad, Oracle 10g, Oracle 11g.
PROJECT#2:
Client : MK Insurance
Domain : Insurance
Product Name : Industrial Loss Insurance
Role : PL/SQL Developer
Description:
Industrial loss insurance This is an non life insurance type web based application which manages Industrialist details and captures Industry details,depending on the type of Industry, the relevant polices that match will be listed automatically and will be allotted for every location,It enables to specify multiple locations for the single industrialist. The policy manipulations module will perform all the necessary calculations and manipulations that will be automatically reflected in the policy module so that every user can view there policy details. It also captures multiple policies for the single location .The industrial policies module maintains all the necessary details of every industrialist such as different locations, different policies for every location etc.
Roles & Responsibilities:
•Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
•Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
•Loading data from flat files into database tables using sql Loader.
•Preparing documentation for requirements, design, install and Unit testing and System Integration.
• Materialized Views, Gtt and partitioning tables for performance reasons.
•Monitoring day-to-day Process for different Data Loads and resolving Issues.
Environment and Tool: Toad, Oracle 10g, Oracle 11g.
PERSONAL DETAILS:
Marital status : Un-Married
Date of Birth : 13/02/1995
Languages Known : English, Tamil, Telugu .
Address : No.20,Sathyavani muthu street, beside infosys
shollinganalur, Chennai -600119.
Pan card number : AYPPH6654L
DECLARATION:
I hereby declare that the information furnished above is true to the best of my knowledge.
DATE:
PLACE: HARISH KUMAR E
Contact this candidate