CARRICULUM VITAE

CHANDRA SHEKHAR JHA

E-Mail:jigiv1@r.postjobfree.com jigiv1@r.postjobfree.com

Mobile: 956*******,971*******

OBJECTIVE:

To work within an organization offering dynamic professional environment which will help me to achieve the goals of the organization and simultaneously enhance my skills and knowledge.

Work Experience:

Apr’2010 – To 31st January 2012

IGATE PATNI India (Pvt.) Ltd. Noida, U.P.

MIS – Executive (Key Skill – MS-Excel, Function, Formulas, VBA (Macro), MS-Access, SQL Server)

JOB PROFILE:

MIS reporting by using MS Excel & VBA (Macro) at Operational and Client level.

Generate timely and accurate reports for analysis. Creating MIS/ Dashboard report and presenting it to the concern Department.

Implement and analysis data to create daily, weekly, monthly, and quarterly reports

Design/develop the agreed upon solution in MS Excel/ MS Access with VBA Programming.

Deliver end products maintaining quick turn around times and highest quality standards execute quick turn around work in MS Excel/MS Access which involves VBA

Managing the Monthly, Weekly & Daily Report Creating in MS-Excel and MS-Access through in depth analysis and producing the actionable information.

Implement practices and metrics to improve operational efficiencies

Roll out different reports i.e. Efficiency, Collated Trackers, OPS Report, Work Flow Report,

Generating & maintaining day to day MIS Data and updating the management.

Determined required data by analyzing MS-Access databases and created customized reports.

Handling SQL queries for data manipulation and retrieve on SQL server.

Extensive usage of MS Excel (Aggegate function, Vlookup, Pivot table, UDF Macros

Work Experience:

Mar’2007 – April 2010

EXL Service.com (I) Pvt. Ltd.

US Process (Health and Annuity) as an Insurance Associate, backend operation.

JOB PROFILE:

Canceling policies as per request by end user & scrutinizing relevant documents before making refund of premiums, ensuring compliance with organizational policies.

Processing financial transaction like – Cancellation, Death Cancellation.

Processing non-financial transaction like SSN Change, POA Updating

Managing incoming volume and make it sure to complete it by end of day.

Handling escalated cases and providing assistance in the form of troubleshooting to the team.

Maintaining an update tracker of process.

Receiving the legal documents of insured person through online software.

Underwriting and processing the customer requested documents.

Verify the original documents of customer through Be-flow on line software and requested documents in ISRA.

Updating the main records like Master Record & History of the policy and providing check amount to the insured/ Estate in case of Death Claim and Cash Surrender on the Net Asset Value of the contract.

Reinstatement /Reactivation of cancelled or lapsed insurance policies.

Sending Duplicate copy of insurance copy as per instruction of client’s

Clearing suspense accounts, created by India team during processing.

Preparing the Schedule adherence sheet.

OPERATING SYSTEMS:

MS-DOS, Windows-98, 2000, XP

PACKAGES:

MS-Office, Internet, VB 6.0, SQL 7.0

Technical Qualification:

Three year’s Software Diploma in Software Engineering from APTECH

Pursuing MCA (Vth) From Sikkim Manipal University

EDUCATIONAL QUALIFICATION:

Bsc. (Chem.)

PERSONAL DETAILS

Name : CHANDRA SHEKHAR JHA

Father’s Name : Shri Ganpati Jha

Address : Gali No-2, Sector-49

Barola, Near S.D. Public School

Noida 201301

Language Known : English, Hindi

Date:

Place: (CHANDRA SHEKHAR JHA)

Contact this candidate