Scribd
Upload
268 views5 pages

SR Oracle PLSQL Developer

Senior PLSQL RESUME

Uploaded by

manjunath
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
268 views5 pages

SR Oracle PLSQL Developer

Senior PLSQL RESUME

Uploaded by

manjunath
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

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

Common questions

Powered by AI

Data modeling plays a crucial role in the software development life cycle by providing a way to visually represent and plan the structure of data within a system. The document sources highlight the use of data modeling in logical and physical database design, identifying fact tables, transaction tables, and designing schemas using tools like Oracle Designer, which aid in the analysis, design, and communication of data requirements . Effective data modeling ensures accurate data representation, supports the creation of efficient databases, and aids in performance tuning, leading to significant improvements in system response time and efficiency .

Effective management of production support and resolution of critical business issues are achieved through strategies like continuous monitoring, proactive debugging, and regular communication with stakeholders. The document sources highlight providing production support by closely monitoring system performance and addressing issues promptly with code fixes and modifications to existing scripts. Conducting code reviews and participating in daily meetings with SMEs are also emphasized as key practices for ensuring that business needs are consistently met, while training end-users and creating user-friendly interfaces improve user satisfaction and minimize downtime . These strategies collectively ensure that production environments remain stable, efficient, and responsive to dynamic business demands .

Data migrations in Oracle databases present challenges such as data integrity, compatibility issues between old and new systems, and ensuring minimal downtime during the migration process. The document sources describe strategies to address these challenges, including using SQL*Loader for bulk data loading from legacy systems and writing PL/SQL scripts for data validation and pre-import processing. Additionally, careful data staging, processing, and job monitoring are emphasized to ensure smooth transitions . Ensuring the correctness of data imports by replacing sensitive data with dummy data and performing rigorous testing, such as system integration testing, are crucial steps undertaken to maintain data integrity and system reliability .

Unit and integration testing are crucial components of PL/SQL development as they ensure that individual components and their interactions work correctly. The document sources emphasize the importance of developing scenarios for unit testing to validate each module's functionality separately. Integration testing is then conducted to verify that the components function together as expected when integrated into a complete system. This process helps identify defects early, improving software reliability and reducing the risk of errors in production . It also supports continuous improvement and enhances the overall quality of software development projects .

The document sources describe several tuning techniques aimed at optimizing SQL query performance. Using Explain Plan helps developers understand the execution strategy of a query, allowing them to make informed adjustments to reduce execution time. SQL Trace provides detailed information on query execution, which is crucial for identifying bottlenecks. TKPROF translates the raw trace files from SQL Trace into a readable format, highlighting slow-running queries for further optimization . These techniques collectively aid in refining SQL queries for better performance by providing insights into the execution paths and resource usage, supporting improved database efficiency and application response times .

Custom PL/SQL development and Oracle ERP integrations streamline business processes by allowing developers to tailor solutions that meet specific business needs. The document sources reflect on creating custom code to automate repetitive tasks such as label printing and generating notifications, which improve operational efficiency. Additionally, custom PL/SQL packages facilitate complex data processing tasks, enabling better business logic implementation within Oracle ERP environments like Warehouse Management System (WMS). These customizations also ensure that reports and workflows are aligned with business objectives, enhancing productivity and decision-making processes .

UNIX shell scripting complements PL/SQL development by automating various data processing tasks. According to the document sources, shell scripts are used to automate data load processes, save Oracle program outputs, send email attachments, and manage ETL workflows. These scripts facilitate efficient execution of repetitive tasks, enhance data integration, and ensure timely communication of results . They act as a bridge between the database environment and the broader operating system, enabling seamless interaction with file systems and external data sources, which enhances the overall efficiency and automation of database management tasks .

Materialized views significantly enhance application performance by storing precomputed results of queries, allowing for quicker access to complex aggregations and join operations. The document sources indicate that materialized views are refreshed as per customer requirements and used by applications such as Customer Web User Interfaces to enter transactions swiftly, without re-executing integration or aggregation logic on each query. This reduces the computational load on the database and improves response times for end-users, making applications faster and more efficient . The use of materialized views in Oracle Developer environments exemplifies their ability to optimize complex queries, leading to improved application performance .

The document sources illustrate the importance of leveraging new Oracle database features by showcasing how they enhance performance and functionality. Features like Analytical Functions allow developers to perform complex calculations over result sets directly in SQL queries, which simplifies report generation and improves processing efficiency. Flashback Query supports data recovery and historical data analysis by enabling queries on past states of the database, thus ensuring data integrity and supporting compliance requirements . These features reduce the complexity of database operations and provide powerful tools for developers to optimize and extend database applications, reflecting the evolving capabilities of Oracle databases .

Exception handling is integral to PL/SQL application development, providing a mechanism for managing errors gracefully and ensuring application stability. The developer experiences in the document sources highlight the extensive use of exception handling to ease debugging, ensure accurate error reporting, and maintain application flow. By capturing exceptions, developers can provide meaningful error messages, log unexpected behaviors for future analysis, and implement recovery actions, thus improving overall application robustness and user experience . This approach minimizes the impact of errors on end-users and helps maintain the application's reliability and performance .

You might also like