Apurav Kaushik

Mobile: +91-810*******; Mail-ID: acfspp@r.postjobfree.com

Summary

* ***** ** ********** ** Development/Customization of Software Application/Products using Oracle 10g/9i/8i/7.x,

•

SQL, PL/SQL, D2K (Forms/Reports) 6i/9i/10g.

• Good Understanding of writing SQL, PL/SQL Stored Procedures, Functions, Packages.

• Proficient in developing and customizing Forms and Reports using D2K tools.

• Expertise in using tools like Toad, PLSQL developer, SQL developer, SQL*Plus, Edit plus.

• Conversant with all phases of Software development cycles involving Analysis, Requirements, Design

Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation

Support and Maintenance.

• Expertise in reviewing Test plans, Test cases and Test case execution. Understanding business requirement

documents and functional specifications. Also played an active role in User Acceptance Testing (UAT) and

unit, system & integration testing. Documentation, Training end-users, Enhancements and Support of the

Application in a live production environment.

Career Profile

Dates Organization

SEPTEMBER 2011 Till Date. NOVARTIS Pvt Ltd.

APRIL 2010 Till AUG 2011 LNT INFOTECH Pvt Ltd.

DEC 2007 Till APRIL 2010 3i-INFOTECH Pvt Ltd.

APRIL 2007 Till NOV 2007 4C PLUS DELHI Pvt Ltd.

•

•

Qualifications Details

Education & Credentials Professional Affiliations

M.C.A. Oracle certified Associate.

Project Details:

The details of the various Projects that I have handled are listed here, in chronological order.

HR & Payroll(4C PLUS)

Project # 1

Period APR 2007-NOV 2007

HR & Payroll is a module of "CIO 365" an ERP solution from 4C PLUS .This

Description

module handles employee information & history, loan & advance management,

employee intranet, appraisals.

Trainee

Role & Contribution

Primarily responsible for development and design of major functionalities in

payroll module.

Detailed Candidate Profile

Involved in study and analysis of customization requirement

•

requested by the customer.

Development and design of new interfaces like employee

•

information & history forms, appraisal form using forms 10g supported by

stored procedures, functions and packages.

Providing support to handle and resolve UAT calls and issues.

•

Providing support to handle and resolve Customer support

•

calls and issues.

Further responsible to prepare Analysis Report, Planning, maintaining status

report.

Premia Insurance(3i Infotech)

Project # 2

Period DEC 2007-MAR 2010

Description

The PREMIA insurance management solutions suite is designed to proficiently

perform all the functions of an insurance company such as underwriting / policy

administration, claims management, reinsurance and accounting.

Software Engineer

Role & Contribution

Led the customization team of three members. Responsible for development and

design of major functionalities in billing module.

Involved in study and analysis of customization requirement

•

requested by the customer.

Development and design of new interfaces like Job scheduler

•

for scheduling the processes, new billing form.

Development and design of proposed accounting entries by

•

writing stored procedures and packages in the backend using oracle.

Development of common receipting and common billing on life

•

and general insurance by making new interface using D2K forms and

writing required functions and procedures at the backend.

Providing support to handle and resolve UAT calls and issues.

•

Providing support to handle and resolve Customer support

•

calls and issues at the customer site (onsite).

Supply chain planning(L&T Infotech LTD)

Project # 3

Period APR 2010 – AUG 2011

Description

The project involves the enhancements and customizations development

requested by the customer and the support activities.

Software Engineer

Role & Contribution

Responsible for writing business logic at the backend using oracle.

Involved in study and analysis of functional specific

•

documents.

Preparations of test cases for the requirements.

•

Development and design of new procedures like production

•

demand and supply planning.

Involved in the UAT calls and issues.

•

Providing support to handle and resolve Customer support calls.

Alcon R&D LIMS (Novartis).

Project # 4

Period

OCT 2011 Till Date.

Description

The Alcon R&D LIMS

Role & Contribution

Analyst, IT Applications.

Providing services from the India Service Centre single handedly for Alcon R&D

LIMS. Responsible for development and design of major functionalities in

different modules of LIMS.

Involved in study and analysis of customization requirement

•

requested by the customer.

Development and design of new interfaces using D2K Forms.

•

Development and design of new reports using D2K Reports.

•

Development and design of proposed stored procedures and

•

packages in the backend using oracle.

Providing support to handle and resolve UAT calls and issues.

•

Single handedly communicate with the US colleagues and

•

keep them appraised with all possible issues and solutions in the project.

Personal information

Passport no. DOB Gender

G1824474 24th July 1981 Male

Valid B1 Visa

Contact this candidate