Pvt Ltd Software Engineer
Resume:
Apurav Kaushik
Mobile: +91-810*******; Mail-ID: ******.*******@*****.***
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