20/09/2016 Sr.OraclePL/SQLDeveloperSr.OraclePL/SQL...

Nashville,TN|Indeed

Tohelpensurejobseekerprivacy,someinformationhasbeenhidden.
Toseefullresumedetails,logintoyourIndeedaccountorcreateanaccountforfree.
SigninCreateanaccount

Sr.OraclePL/SQLDeveloperOHL
Nashville,TN
Around7.5yearsofprogrammingexperienceasanOracleDeveloperinAnalysis,Design,DataModeling(Logicaland
Physical),andImplementationofBusinessApplicationsusingtheOracleRelationalDatabaseManagementSystem
(RDBMS)
ExperienceinDataExtraction,TransformationandLoading(ETL)processes.
ExperienceinClientServerapplicationdevelopmentusingOracle[]PL/SQL,SQL*PLUS,Designer2000,Developer
2000.
ExtensiveexperienceinOracleRDBMSdesignanddevelopingstoredprocedures,packages,triggers,cursorsusing
SQLandPL/SQL.
ExtensivelyworkedondevelopingForms,MenusandReports.
ProficientindevelopingandcustomizingreportsusingOracleReportsversions6i&9iandDiscoverer9i/10g[]BI
Publisher.
Expertiseintuningofprocedures,packagesandSQLstatements.
Expertiseindatamodeling,normalization,databasedesign,dataloading,dataretrieval,modification,andarchival
techniques.
ExperiencecreatingSQL*LoadercontrolprogramsandPL/SQLvalidationscriptsforvalidatingdataandpreimport
processinglegacydatafromfeedersystemstoOracle.
UsedSQL*LoaderandUTL_FILEPackagesfordataconversionandinterfaces.
IndepthexperienceindevelopingcomplexDatabaseTriggers,StoredProcedures,FunctionsandPackages.
ExperienceinusingSQL,PL/SQLstoredprocedures,indexes,materializedviews,shellscripting,partitionedandnon
portionedtables,packagesandtriggersforimprovedperformance.
InvolvedinallphasesofSoftwareDevelopmentLifeCycle(SDLC)fromAnalysis,Design,Development,Test,
Implementation,DocumentationandSupport.
Involvedinprogramming,debugging,andunitandsystemintegrationtestingofmodules.
GoodknowledgeonExceptionHandlingextensivelyfortheeaseofdebugginganddisplayingtheerrormessagesin
theapplication.
ExperienceonOracleERPApplications(OracleEBS)withWMS(WarehouseManagementSystem)module.
HavegoodknowledgeonstandardWMSscreensandreports.
WorkedcloselywithWarehousebusinessusersregardinglogisticsandmaintenance.
Workedontweakingdifferentworkflows,formpersonalization,reportsonWMS.
HavegoodknowledgeonWMSInboundLogistics,Inventorycontrol,Replenishment,TaskManagementsubmodules.
Monitoringdatastaging,processingandloadingjobs.
WritingUNIXShellScriptstoautomateloadprocess.
Involvedinanalyzingandvalidatingdatamigrationsfromtheoldsystemtohighlyrelationaldatabasesystem.
Workedinteams,involvedinrequirementsstudyanddesignanddevelopmentofdatabasefororacleapplications.
Strongtechnicalandfunctionalcompetenceandwillingnesstodowhateverittakestogetthejobdone.Adaptableto
differentclientsituationsandaquickstudyinthelearningofnewskillsandmethods.

WorkExperience

Sr.OraclePL/SQLDeveloper
OHLNashville,TN
April2014toPresent(2years,5months)

Responsibilities:
Developedvariousdatabaseobjectsliketables,schemas,views,packages,storedprocedures,triggers,functions
etc.,usingTOAD.
DevelopedSQL*LoaderscriptstoloadthedatafromexternalflatfilesthatareexportedfromSQLServer.
Debuggedexistingcodeforbusinesslogicissues.
InvolvedindevelopingscenariosforUnit,Integrationtestingtoensurethatallthecomponentsworkcorrectlywhen
integrated.
CreatedseveralMaterializedviewsandrefreshedthemasperthecustomerrequirements.
DevelopedUNIXscriptstosaveOracleconcurrentprogramoutputsandsendingthemasemailattachments.

WorkedonWarehouseManagementSystemanddevelopedacustomcodeinProCtoautomatethelabelprintingafter
thepickdropprocess.
Created&modifiedFunctionslikeInvoiceorders,InventoryControl,Retailsales,RevenuePull,DailyTransaction
http://www.indeed.com/r/ced43085b8f0cba8?sp=0 1/5
20/09/2016 Sr.OraclePL/SQLDeveloperSr.OraclePL/SQL...Nashville,TN|Indeed
Created&modifiedFunctionslikeInvoiceorders,InventoryControl,Retailsales,RevenuePull,DailyTransaction
JournalandvariousReceiptsetc.
ParticipatingindailymeetingsandcoordinationwithSMEsfromclientlocationandimplementingbusinesslogicfor
creatingViews,ProceduresandFunctions
PerformancetuningusingExplainPlan,SQLTraceandalsousingTKPROF
DevelopedmaterializedviewswhichareusedbytheCustomerWebUserInterfacetoentertheirtransactions.
Workedontweakingdifferentworkflows,formpersonalization,reportsonWMS.
DevelopedvariousCustomPLSQLreports,Customizedexistingreportsaccordingtothefunctionalspecifications.
DevelopedseveralXMLPublisherreportsanddevelopedcustomshellscriptstoemailthereportoutputs.
InvolvedinXMLparsingandloadingXMLfilesintothedatabase.
InvolvedinusingofnewfeaturesofOracle11glikeAnalyticalfunctions,flashbackQuery,regularexpressionsetc.
InvolvedintherestructuringandfinetuningoftheexistingSQLQueriesaccordingtothenewrequirementusing
TKPROF,AWR.
UsedUTL_FILEpackageforwritingDBMS_OUTPUTmessagestofile.
Developedacustomcodetosendtimesensitivenotificationsastextmessagestothecustomer'smobiledevice.
CreatedcomplexStoredProceduresandPL/SQLblockswithoptimumperformanceusingBulkBinds(BULK
COLLECT&FORALL),Inlineviews,Referencecursors,cursorvariables,dynamicSQL,varrays,externaltables,
nestedtables,etc.
CreateTriggers,FunctionsandPackagestoprovidebackendsecurityanddataconsistency.
Createtables,indexes,sequences,otherconstraintsaspertheClientStandardsintothecorrectSchemaandTable
Spaces.
InvolvedCopyingdatafromProductiontolowerenvironmentsreplacingallcustomersensitiveinformationwithdummy
data.
Coordinationwiththeaccesscontrolteamtograntthecorrectroles/grantstotheuserbelongingtodifferentgroups.
DevelopednewFormsandcustomizedexistingformsasperClientrequirementinCustommodules.
Providedproductionsupportforcriticalbusinessissuesandtrainingtoendusers.
WritingAdhocreportsforthesupportofdaytodayactivitiesinProduction.
WriteDataFixesandMigrateforthefixingoftheissues.
ResponsibleforperformingCodeReviews.
Extensiveknowledgeinperformancetuningthequeriesanddevelopment,builtindexesaspartoftuningand
optimization.
WorkedwithdynamicSQL,developedmanyproceduresandfunctionwithdynamicSQL.
Workedinresolvingtheproductionissues.Developedlotofnewscriptsandchangedfewexistingscriptstosolvethe
issues.
Environment:OracleDatabase9i/11g,OracleForms6i/10g,OracleReports10g,SQL,PL/SQL,SQL*Plus,SQL*Loader,
Discoverer9i,DTS,TOAD,ClearCase,VSS,UNIX,Putty.

OracleDeveloper
HachetteBookGroupNewYork,NY
September2013toMarch2014(6months)

Description:HachetteBookGroup(HBG)isapublishingcompanyownedbyHachetteLivre,thelargestpublishing
companyinFrance,andthesecondlargestpublisherintheworld.HachetteLivreisawhollyownedsubsidiaryof
LagardreGroup.Primaryroleoftheprojectinvolvesparsingrawdatafilesfromthesitelocationsandloadtheminto
oracledatabaseandimplementingthecomplexbusinessrulesusingPL/SQLPackages.
Responsibilities:
CollaboratedwiththeBusinessanalystsandtheDBAforrequirementsgathering,businessanalysis,testingand
projectcoordination
Createdprocessforceanddeployedintoruntimedepositoryusingwarehousebuilder
Involvedinlogicalmodelingandphysicalmodelingofapplication.
Usedmultipleoperators(union,routor)forloadingdatausingowb.
Havingstrongknowledgeincreatingandmaintainingtheowb
DevelopedStoredProcedures,Functions,PackagesandSQLScriptsusingPL/SQL.
InvolvedindevelopingCRONTABtoscheduletheinformationofcronentries.
InvolvedincreationofConceptualModelingcoveringallthebusinessrequirements.
LoadedthedataintodatabasetablesusingSQL*loaderfromtextandexcelfiles.
Developeddatamodel,SQLQueries,SQLQuerytuningprocessandSchemas.
workedwithbulkcollecttoImplementtheperformanceofmultirowqueries
DevelopedSQLscriptsforReferentialIntegritycheck,whichchecksvalidityofincomingdatawithmastertablesin
database.
DevelopedSQLscripts,packagesandproceduresforBusinessruleschecktoimplementbusinessrules.
DevelopedSQLandPL/SQLscriptstotransfertablesacrosstheschemasanddatabases.
DataloadedfromlegacysystemsusingPL/SQLandSQL*Loader.
RemediateOracleapplicationCustomobjectcomponentslikeForms,reportandConcurrentProgram(PLSQLcode)
InvolvedindevelopmentofOracleForms/Reports,NewScreendesigns,Modifications.
UpgradedtoForms10g,Reports10g,maintainedandtroubleshootOracleFormsandReports.

OraclePL/SQLDeveloper
YellowPagesDetroit,MI
http://www.indeed.com/r/ced43085b8f0cba8?sp=0 2/5
20/09/2016 Sr.OraclePL/SQLDeveloperSr.OraclePL/SQL...Nashville,TN|Indeed
YellowPagesDetroit,MI
November2012toAugust2013(9months)

Responsibilities:
InvolvedintheAnalysis,Design,CodingandTestingoftheapplication.
CreatedandmodifiedPL/SQLTriggers,Procedures,Functionsandpackages.
DevelopedERDiagrams,Dataflowdiagramsbasedontherequirement.
DevelopedSQLscriptstocreatedatabaseobjectsliketables,viewsandsequences.
UsedSQL*Loadertoloadbulkdatafromvariousflatfilesandlegacysystems.
DevelopedSQLandPL/SQLscriptsfortransferofdatabetweendatabases.
DesignedanddevelopedcomplexreportstomeetenduserrequirementsanddeployedusingOracleReport10g.
DevelopedcomplexSQLqueries,triggersforbuildingreportsusingForm,formletterandmailinglabelreportstyles.
DesignedanddevelopeduserinterfacesusingOracleForms.
ProactivelytunedSQLqueriesandperformedrefinementofthedatabasedesignleadingtosignificantimprovementof
systemresponsetimeandefficiency.
UsedFORALLandBULKCOLLECTtofetchlargevolumesofdatafromtable.
Performedunittestingandsupportedintegrationtestingandendusertesting.
Involvedinlogicalandphysicaldatabasedesign,IdentifiedFactTables,TransactionTables.
InvolvedinSQLtuning,PL/SQLtuningandApplicationtuningusingvarioustoolslikeTKPROF,EXPLAINPLAN,
DBMS_PROFILERetc.
Performedunittestingandsupportedintegrationtestingandendusertesting.
Extensivelyworkedonproductionissueswitheffectivedefectmanagement.
DevelopedReports,Menus,ObjectLibrariesandPL/SQLLibraryusingOracleReportsDeveloper.
Createdgroup,tabular,andformreports.
Providedtechnicalsupporttotheuserwithregardtooperationalaspects.
Environment:Oracle11g,PL/SQL,SQL,Forms10g&Reports10g,TOAD9.5,ShellScripting,SQL*Loader,PERL,XML
andWindowsXP.

OraclePL/SQLDeveloper
GlobalOnlineServiceHyderabad,AndhraPradesh
August2010toSeptember2012(2years,1month)

Description:Thisisageneralizedsoftwarepackage,whichbasicallycontainsadatabaseoflargenumberofcompanies
classifiedundermanyindustries.Entirefinancialandnonfinancialdetailsofthesecompanieshavebeencompiled
underdifferentmodules,enablingtheusertoanalyzeanycompanyorindustryinallpossibleways.Thedatahasbeen
groupedandpresentedunderfollowingmodules,Company,Finance,Scoreboard,Query,Industry,Notepadand
Projections.TheScoreboardmodulehelpsusertododetailcomparisonbetweenselectedcompanies.
Responsibilities:
Workedwiththeteamtodesign,develop,test&implementsystem.
Creationofdatabaseobjectsliketables,proceduresusingOracletoolslikePL/SQL,ToadandwroteStored
Procedures
Designeddatamodelbynewobjectsusingexistingobjectsasperrequirementsgivenbythefunctionalteam
WrotetheFunctionalSpecificationDocumentaccordingtotheBusinessrequirementswiththeproposedlogicPrepared
theGatheringtoolswithallthefieldlevelandtableleveltransformationlogicsformetadatarepository
ExtracteddatafromflatfilestoOracletables
InvolvedinpreparingTestPlans,UnitTesting,SystemIntegrationTesting,ImplementationandMaintenance
ConvertingalltheCustomReportstoworkonOracleApplications
DevelopedseveralnewPL/SQLpackagesforDatabasepackages,Databaseproceduresandtriggers
Creatinglistofvaluesanddefinedthedescriptiveflexfieldsandkeyflexfields
DevelopedTermWiseAgingreportandMonthlyRollforwardreport
Modifiedseededreportsaspernewfunctionalitiesandbusinessneeds
DevelopedfieldlevelandformlevelvalidationcodeandgeneratedvariousreportsusingDeveloper6iReportsand
involvedinpreparingtestcases&unittesting
Environment:Oracle9i,SQL,PL/SQL,Developer/2000(Forms6i,Reports6i,Graphics6i),Designer,Discoverer,
SQL*PlusReports,SQL*Loader,WindowsXP,Toad

TraineeDeveloper/OraclePL/SQLDeveloper
JagranPrakashanLimitedDelhi,Delhi
March2008toJuly2010(2years,4months)

HaveworkedintheApplicationDevelopmentandDatabaseManagementteamanddevelopvarietyofapplicationsfor
endusers.
Project:CreditNoteGenerationandApprovalSystem
Description:ThismoduleservesauthorizedusersforapprovalofCreditNotesagainstoutstandingofvariousclients.
Hierarchywiseapprovalofcreditnotes.Thissystemalsoprovidesvariousadjustmentandoutstandingreportsfor
clients.
Responsibilities:

DevelopedandmodifiedPL/SQLpackages,procedures,functions,triggers,reportsasperUserrequirementstomake
newenhancements.
DevelopedUserInterfaces.
http://www.indeed.com/r/ced43085b8f0cba8?sp=0 3/5
20/09/2016 Sr.OraclePL/SQLDeveloperSr.OraclePL/SQL...Nashville,TN|Indeed
DevelopedUserInterfaces.
Designed,developedandtestedvariousOutstanding/CN/DN/Adjustmentreports.
InvolvedinPerformancetuningwhichincludedcreatingindexesandmodifyingtablesusingexplainplanutility.
Environment:OracleForms&ReportsDeveloper6i,Oracle10g,PL/SQL,WindowsXP.

BillGenerationandDispatchModule
Description:ThismoduleconsistsofBillGeneration,BillPrinting,Average/MinimumBilling,PendingBillsandBills
Dispatchsubmodules.
Responsibilities:
DevelopedPL/SQLpackages,procedures,functions.
DesignedandDevelopedforms&Reports.
Preparedtestcasesandperformedunittesting.
PerformedUAT.
Environment:OracleForms&ReportsDeveloper6i,Oracle10g,PL/SQL,WindowsXP.

MISReportsModule
Description:ThevariousMISreportsthataregeneratedusingthisapplication
OverallBilling&PerformanceagainstTarget
OverallCollectionagainstTarget
CombinedPublishedSpace
CombinedRealizationBreakupSummary
Party/ClientLedgeretc.
Responsibilities:
DevelopedPL/SQLpackages,procedures.
Designed&DevelopedProcedurebasedforms.
Designed&developedreports.
PreparedSQLscriptstovalidatethedataintheReport
PerformedReportunittestingbyvalidatinglayout,datainthereport.
Creatingandmaintainingprojectdocuments.Ensuringappropriateuseofmethods,toolsandtechniqueswithinthe
team.
Sr.OraclePL/SQLDeveloper
Environment:OracleDeveloperSuite10g,Oracle10g,PL/SQL&SQLplus

AdditionalInformation

TECHNICALSKILLS:
OperatingSystemsWindowsXP/NT/2000,DOS,UNIX,LINUX,AIX,SOLARIS
ProgrammingLanguagesSQL,PL/SQL,Unixscripting,Java,C,C++,Delphi,ProC
WebTechnologiesHTML,DHTML,XML,JSP
Tools
TOAD,PL/SQLDeveloper,SQLNavigator,SQL*Developer,SQLTools,Erwin,DataTransformationServices,
Discoverer[]BIPublisher

UtilitiesSQLLOADER,UTL_FILE,DBMS_SQL,DBMSPackages
DatabaseOracle[]MSSQLServer,MSAccess2000

EmailSr.OraclePL/SQL
Developer

Resumesyoumaybeinterestedin:

OraclePL/SQLDeveloper
OraclePL/SQLDeveloper

PL/SQLDeveloper
PL/SQLDeveloper
TaventTechnologiesIndiaPvt....

PL/SQLDeveloper
PL/SQLDeveloper
3IINFOTECHBANGALORE

Sr.OraclePL/SQLDeveloper
Sr.OraclePL/SQLDeveloper
AARPInc

http://www.indeed.com/r/ced43085b8f0cba8?sp=0 4/5
20/09/2016 Sr.OraclePL/SQLDeveloperSr.OraclePL/SQL...Nashville,TN|Indeed

OracleDeveloper
OracleDeveloper
NitsSolutions,Inc

PL/SQLDeveloper
PL/SQLDeveloper
WiproTechnologies

SQLDeveloper
SQLDeveloper
GallegaSoftwareSolutions

PL/SQLDeveloper
PL/SQLDeveloper
CognizantTechnologySolutions

Reportsdeveloper
PL/SQLDeveloper
Larsen&Tubro(L&T)

SQLDeveloper
Plsqldeveloper
IBM

2016Indeed

Sr.OraclePL/SQLDeveloper

http://www.indeed.com/r/ced43085b8f0cba8?sp=0 5/5