Sql Project

K.SARAVANAKUMAR

Emailid:*************.******@*****.***

Mobile:+919*********

ProfessionalSummary

Having5.10yearsofApplicationDevelopment,ProgressiveandDynamicexperienceinOracleSQL, PL/SQLdevelopment

HavinggoodexperienceinITindustryinbroadrangeoffunctions&involvedindevelopmentproject.

HavingbetterunderstandinginJoins,SubQueryandConstraints.

HavinggoodknowledgeinSQLfunctionsandGroupfunctions.

HavinggoodknowledgeinSequence,Synonyms,IndexesandViews.

HavinggoodknowledgeinSQLstatementslikeDDL,DMLandTCL.

Expertiseindebuggingandsolvingtheissues.

ExtensivelycreatedandworkedwithStoredProcedures,Functions&Packages.

UsedCursorandExceptionhandlingwhilewritingtheStoredProcedure.

HavingbetterunderstandingandworkingexperienceinPL/SQLadvancedconceptslikeCollections, BulkCollect&RefCursor.

HavingbasicknowledgeinMaterializedView,DCL.

HavinggoodKnowledgeinTriggerscreation.

StrongunderstandingofDataDictionaryTables.

KnowledgeinoracleformsandReports

ExperienceSummary:

Organization :CognizantTechnologyandSolutions

Location :Chennai

Designation :Associate

Duration :July-2018totilldate

JobProfile :ApplicationdevelopmentofGeneralInsurancedomain. SoftwareProficiency:

ProgrammingLanguages:PL/SQL

Databases :Oracle11g,Oracle12C

GUI :OracleForms11g

OperatingSystems :Windows2000/XP,Linux.

Script :SQL

Tools :SQLNavigator

EducationDetails:

BSC(InformationTechnology)fromAyyaNadarJanakiAmmalCollege,Sivakasi ProjectDetails:

Project#1:

Company : Cognizanttechnologyandsolution

Product : SIS

Client : ZURICH,HONKONG.

Domain : GeneralInsurance.

ModuleName : Generalpolicy,MaintainanceofpolicyInput,Claims Technologies : SQL,PL/SQL,OracleFormsReports(12C). TeamSize : 10members.

ProjectDescription:

SISisapurelyGeneralInsuranceproductwhichisbeingusedinZURICH-Honkgong.ItisanendtoendInsurance productwhichcoversallinsurancerelatednewBusiness,Underwriting,Claimsetc.ItiswelldevelopedERPand workingsince2017-julyonwards.HongLeongBankBerhadisaregionalfinancialservicesisaMalaysiabased company,whichhasbranchesalsoinSingapore,HongKong,Vietnam,CambodiaandChina.TheBankisa technology-focusedandemphasisesthedevelopmentoffinancialcapabilitiestoserveitsclientsacrossfive geographies.HongLeongBankBerhadidlistedonBursaMalaysiaandformspartoftheHongLeongGroup whichheadquarteredinKualaLumpur,Malaysia.IthasastrongMalaysianentrepreneurshipheritage. RoleandResponsibilities

AnalyzethetaskfromBRD(BusinessRequirementanalyzethedata).

WorkingunderNewbusiness,underwriting,policyservicing,Claims.

AspertheRADcreatetables,indexes,sequences,constraints,stored Procedure,triggers,programmingplsql.

AftercompletingdevelopmentcreateRMSandFMS.

Developeduserfriendlyenvironmentforenduserpurposeusingforms.

WorkedwithobjectlibrariesandPL/SQLlibraries.

Project#2:

Company : AswathKumarTechnologySolutions

ProjectTitle : Policyandclaimmaintanence

Client : Zurich,Singapore

Domain : Insurance

ModuleName : Policy,claimmanagementandchequepayment Technologies : SQL,PL/SQL,OracleForms(10g)

TeamSize : 10members.

ProjectDescription:

ThisprojectisusedbyZurichusersdailybasedbusinessforpolicy,claim,chequeentries.Forthiswehave providedmanymoduleslikePolicyInputsubsystem,Reportsubsystem,claiminputsubsystem,Enquiryandsoon. Thesemodulescontainmanyformsandreportsaspertheinsurancedomainneeds.Thedatabaseand applicationserverishostedattheclientsitefortheseclients. RolesandResponsibilities:

FixingtheissuesinOracleFormsandReportsbasedontheclientrequirements.

Providingenhancementsandfinetuningintheexistingformsandreports.

WritingSQLScripts.

CreatingandModifyingProcedures,Functions,Viewsandpackages. PersonalDetails:

Father’sName : SARAVANAKUMAR.K

DateofBirth : 23-02-1993

Gender : Male

Nationality : Indian

MaritalStatus : Single

LanguagesKnown : English,Tamil.

PassportNo : L4127232

Contact this candidate