MariaShobila.A
Mobile: +918*********
Email:**************@*****.***
PROFESSIONALSUMMARY:
• Havingoverall3.2 yearsofexperience&asPLSQLDeveloperaswell asinApplicationSupport.
• ExpertiseinClient-Server applicationdevelopmentusingOracle11g/10g, SQLPLUS,TOADAND SERVICENOW.
• Involved in all phasesoftheSDLC(SoftwareDevelopment Life Cycle) from analysis,design, development,testing,implementationandmaintenancewith timelydelivery against aggressive deadlines.
• Excellent skillsinFunctions,StoredProceduresandPackages.
• ExperienceinOraclecreatingpackages,RecordsandPL/SQLTables.
• Creation/modificationof schemaobjectslikePackages,Procedures,Functions,Triggers, Views, Materialized Views, andSequences.
• StrongProficient in SQLandcreation/modificationofdatabaseobjectslikeSynonyms,Group Functions,Single RowFunctions,Views, Index.
• ExperienceinusingDDL,DML,DCL,TCLcommands.
• Familiar in writingJoins,Subqueries,Singlerowfunctions
• ExperienceinCollectionsandExceptionHandling.
• Excellent skillsinProductionsupport activities.
• HaveexperienceinhandlingChangerequest andIncident request,Problem Tasks, User Requests.
• Experienced in handling Major Incident Management (MIM)like Coordinatingthe bridge,hosting,outagecommunications,updatingissuestatus.
• ExperiencesinCreatingIncidents,Requests,Problem tasksandCR.
• ExperienceinusingbasicUNIXcommends.
TECHNICALSKILLS:
• ProgrammingLanguage : PL/SQL,UNIX
• Databases : Oracle 10g/11g
• OperatingSystem : Windows
• Tools : TOAD, PTS-W,CAWorkload,ServiceNow,SQLDeveloper. EDUCATIONAL QUALIFICATIONS:
• B.SC Mathematicswith 78% of marksfromJayarajAnnapakiamCollegefor Women’s, Periyakulam.
WORKEXPERIENCE:
• Workedas SoftwareEngineer in TATA CONSULTANCYSERVICES, From2016December to2019 September
· WorkingasSoftwareEngineer in 3I INFOTECH fromOctober totill now. PROJECTEXPERIENCESUMMARY:
Project 1:
• Project Title : BankingManagement System
• Client : Dohabank
• Role : SoftwareEngineer
• Domain : Banking
• Environment : Oracle 10g/11g, Unix/Windows/ServiceNow. Project 2:
• Project Title : Orient
• Client : Sarwa
• Role : ProcessAssociate
• Domain : Insurance
Tools&Utilities : SqlPlus,ServiceNow,Putty,Toad,SQLDeveloper. ROLES ANDRESPONSIBILITIES:
Project 1:
• Preparationof Logical and Physical design documentsforthesourcecodeimpact.
• CreatingProcedures,Functions,Packages,Views andMviewsaspergivenrequirements.
• ExtensivelyusedBulkcollect,Bulk Bind & PL/SQLCollections.
• Debuggingthecodeusingtoolsandpreparedtherootcauseanalysisforfix.
• Understandingtheclient Project requirementsandpreparedDetailedDesignDocumentand Impact AnalysisDocument.
• Developed PL/SQLPackages,Procedures,Functions,Indexes and Collectionstoimplement businesslogic.
• Conduct research and find solutionsforcomplextechnicalproblems.
• Implementingseveral triggerstomaintainDatabaseSecuritybyauditinglog tabletotrackinformationabout users.
• WritingcomplexSQLqueriesincludingsubqueriesfor fasterdataretrieval frommultipletables.
• HandlingerrorsusingExceptionHandlingextensively for theeaseofdebugginganddisplaying theerror messagesintheapplication.
• Havinggoodknowledgeinperformancetuningconceptfor improvetheapplicationperformance. Project 2:
• When problemoccursraisingticketsinServiceNow.
• Providingsecondlevelsupport in troubleshootingissueandproblems.
• Collected User RequirementsbyparticipatinginmeetingsandstudyingexistingSystem.
• Wegettingissuebychat/mail/phonecallsfromretail clientsorinstitutionalclients.
• Keep in regular contactwith thecustomer in order tounderstandthecustomerneeds.
• Givingsupport to Developersbyinvolvingwhile theirproductionprocess.
• Provided hot fixes for variousproductionissuesandmonitoredendofdayprocessafter market closetogeneratetransactfileonadailybasis.
• Apart from raising ticket we monitoringtheapplicationlikeCPUusage,memorycapacity, performanceof theapplicationetc.
• Makinggoodconversationandmakingthemtounderstandourproduct better.
• Analysistheproblemsof thememberandfieldexecutiveandresolvingit accordingly.
• Resolvingmember’s quiresthroughmails,customerchat andthroughphone
• Motivatingteamtogivemaximumproductiontotheorganization. Environment : Oracle 10g,ITIL,SQL, UNIX.
PERSONALDETAILS:
• Dateof Birth : 11/03/1996
• FatherName : AntonyJoseph
• Gender : Female
• MaritalStatus : Single
• LanguagesKnown : English, Tamil,
• Nationality : Indian
• Current Location : Chennai
• EmployeeType: Permanent
DECLARATION:
I hereby declare that theabove-mentionedinformationiscorrect up tomyknowledgeandIbear theresponsibilityfor thecorrectnessoftheabove-mentioned.