Summary:

Around * years of experience in Information Technology.

* ***** ** ********** ** Reports Development of Oracle Applications.

Having good knowledge about AOL, System administrator in Oracle Application.

Has Experience in Development and Support of Enterprise Applications in Health Care and Banking & Insurance Functionalities.

Have Developed and Documented PL/SQL Procedures, Functions, Packages and Cursors and Exceptions, Reports

Carried out UNIT TESTING for all components developed.

Have worked on both 9i and 10g Oracle databases, utilized Advanced Features such as BULK BINDS and COLLECTIONS.

Developed Data Extraction Programs using PL/SQL UTL_FILE Package.

Have Utilized SQL*Loader, Bulk Load Facility in Client’s Legacy Data Conversion Activities.

Able to work independently and as team member adapt at motivating staff to ensure smooth workflow and increased productivity

Quick learner and strong desire to master new technologies in the areas of Database

Exceptionally good and experienced in handling the problem.

Extensive experience in SQL, PL/SQL Programming concepts and PL/SQL Developer

Have Handled Business User Queries and resolved critical issues during Production Support.

An Efficient Team Player with Good Communication & Customer Interaction Skills.

Profile:

Name : Imran Mohammed Kalsekar.

Age : 37yrs.

Passport No : J9058447

Date of Issue : 09-jun-2011

Date of Expiry : 08-jun-2021

Qualification : BCom from University of Bombay (March-2003).

Certification

: Certificate Course in Web Design APTECH. (2003)

: C-DAC Advanced Dip in IT (Oct-2003 To Mar-2004)

: OCP Training in SQL STAR (Oct-2006 To June-2007)

: OCP (Develop Track) SQL, PL/SQL, Reports 9i, Forms 9i. (Jun-2007)

Skills Set:

ERP Applications : Oracle applications 11i (AR, GL, AOL Objects).

Language : SQL, Pl/SQL.

Databases : Oracle 9i and 10g.

GUI : Forms 6i, Reports 6i.

Tools : PL/SQL Developer, Toad, FTP, SQL*loader, SQL*plus.

Operating System : Windows 98/NT/2000/XP.

Professional Experience:

Working In 3i-Infotech CSL as a Sr.Software Engineer Since May-14.

Project Details :

Client Site : ICICI Lombard General Insurance Banking.

Designation : Sr.Software Engineer

Technology : Oracle

Module : UMS is developed for Management of Cash/Payments and automation of

Reconciliation and accounting of transactions performed by ICICI Lombard for

both retail and corporate customers. This system is integrated with Pathfinder,

Online Manager, and Premia. Payment mode is Cash, Cheque/Demand Draft,

Fund transfer, Internet Banking and POS-GPRS. Policies are issued only after

proper reconciliation process between different Policy Admin System. Synergy is

used by Banking Team these are operational users and their team size is of 40

members. The accounting entries are then posted in EBS ERP system. Both

systems are integrated with other system through SQL/Oracle

jobs, schedulers,database link servers batch modes.

Responsibility :

1.To take Functional requirements from Business team.

2.And then provide timeline for the particular CR raised by the Business.

3.Discussion with developer Of CR’s and guide developers during development.

4.Recently Handled Recon Performance Issue.Using query tuning.

5.Developed and Customized Reports as per Business requirement.

6.Look after Interface Related Issues (Inbound / Outbound).

7.Involve in writing Packages & Procedures.

8.Involved in Table Partioning for Improve Performance (Using Range & List Partion)

Project Details :

Client Site : ICICI Lombard General Insurance Banking.

Designation : Sr.Software Engineer

Technology : Oracle

New Module : Payment Recon is under development application to handle Expenses of CLIENT,

In these module we are going process of recon between SAP and Bank entries .

Responsibility :

1.Taken Functional requirements from Business team.

2.And then provide timeline for the particular CR raised by the Business as Phase wise.

3.Discussion with developer for the new module and guide developers during development.

4.Also worked as a solution architecture for the incoming payment recon module.

5.And also worked in database design and database architecture.

6.Involve in writing Packages & Procedures.

Worked In TechProcess Payment Service as a Software Eng From Oct-10 To Apr-2014.

Project Details :

Client Site : ICICI Bank

Designation : Software Engineer

Technology : Oracle

Module : SYNERGY is a application that automates and centralizes the reconciliation process for the client. Synergy enables you to execute all reconciliation processes that tracks payment entries right from the beginning till the payment is realized or dishonor.This package has several modules such as Cms,Return,Zpo,Bnkstmnt.

Responsibilities:

Involved in Development of RECONCILATION MODULES and Involved in Production Work.

Created Complex Queries for Views for reporting purposes.

Developed/Debugging PL/SQL Procedures, Functions, Packages and Schedulers to satisfy Requirement

Participated in Status Meetings and sent the Daily & Weekly Status Reports.

Developed the CR and solve the Live issues as per Business specification

Supporting the production type issues And Involved the Developed production issues.

Successfully created and debugged many PL/SQL procedures, functions, packages for the application.

Creation Data Structures i.e. Tables & Views and applying the referential integrity.

Query Tuning.

Worked in Blink Consulting as a “Trainee Tech Consultant” from ‘Oct 09 – Jul 10’

Technical Skills:

Tools : Forms 6i, Reports 6i.

RDBMS : Oracle 9i.

Languages : SQL, PL/SQL.

Worked on R11i debugging on modules

AR Modules (Customer Interface Tables, Auto Invoice Tables)

Creating Sample data and insert data into staging through SQL*LOADER

Creating procedure do the validation in staging table

Use the Concurrent program to load data into interface table

And use the standard program to load data into base tables.

Able to create :

User, Responsibility, Forms Registration, Report Registration.

Able to do forms Customization.

Worked on Test Cases on HRMS module.

Worked In Cellent Technology as Technical Support Mumbai from May08 - May09

Role : Technical Support

Platform : Win XP

Technologies : .NET FRAMEWORK

Framework : Cellent framework

Web Server : Apache Tomcat 5.0

Database : SQL SERVER

Responsibilities:

Involved in handling client queries.

Involved in creating Stored Procedures and Data Management.

Involved in common queries and technical difficulties faced by customer and escalating same to concerned authorities.

Worked mPower Labs Pvt. Ltd as Software Trainee, Bangalore From Apr 2006-Mar 2006

Project Details:

Project Name : Computer Aided Test Simulator

Platform : Win 2000

Technologies : ORACLE 9i,JSP,SERVLET

Framework : mPireTM

Web Server : Apache Tomcat 5.0

Database : Oracle

Description : This is a Web-enabled Computer Aided Test Simulator developed for conducting online tests. This product is aimed at solving the difficulties faced by the organization itself and the people who take tests by making the entire process of test online The main objective of developing this product is to make the entire process of test a transparent one and which gives entire details of the people who give tests called the ‘testees’ and the people who take tests called the ‘testers’. The system consists of the administrator, testers’ subsystem and testee. The administrator has the over all control of testers and testee. This software will be developed used open-source technologies which will have greater flexibility, reliability, robustness & durability.

Contact this candidate