jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 professional summary 11 years programming experience oracle plsql developer analysis design implementation business applications using oracle relational database management system rdbms knowledgeable oracle developer skilled data collection analysis management works well pressure consistently meets deadlines targets delivering high quality work highlyskilled software development professional bringing 11 years software design development integration advanced knowledge oracle sql plsql ms tsql involved phases sdlc software development life cycle analysis design development testing implementation maintenance timely delivery aggressive deadlines experience data flow diagrams data dictionary database normalization theory techniques entity relation modeling design techniques expertise clientserver application development sing oracle 12c11g10g9181 plsql sql plus toad sqlloader effectively made use table functions indexes table partitioning collections analytical functions materialized views query rewrite transportable table spaces strong experience data warehouse concepts etl good knowledge logical physical data modeling using normalizing techniques created tables views constraints index b tree bitmap function based developed complex database objects like stored procedures functions packages triggers using sql plsql developed materialized views data replication distributed environments excellent technical analytical skills clear understanding design goals er modeling oltp dimension modeling olap experience oracle supplied packages dynamic sql records plsql tablesloaded data oracle tables using sql loader partitioned large tables using range partition technique experience oracle supplied packages dbms sql dbms job utl file created packages procedures automatically drop table indexes create indexes tables worked extensively ref cursor external tables collections expertise dynamic sql collections exception handling experience sql performance tuning using costbased optimization cbo good knowledge key oracle performance related features query optimizer execution plans indexes experience performance tuning oracle rdbms using explain plan hints experience etl techniques analysis reporting including hands experience reporting tools cognos created shell scripts invoking sql scripts scheduled using crontab excellent communication interpersonal analytical skills strong ability perform part team skills software products tools oracle sql plsql performance tuning data modelling sql plus sql loader unix shell scripting hp quality center toad oracle sql developer erwin 4073 qlikview analytical tool shell scripting education mca madras university chennai 2004 master computer applications computers sri venkateswara university 2001 bsc computers work history fleetcor sr oracle plsql developer bloomington usa 072016 current coordinated eis enterprise information system team provide necessary stored procedures packages necessary insight data worked sqlloader load data flat files obtained various facilities every daycreated modified several unix shell scripts according changing needs project client requirements wrote unix shell scripts process files daily basis like renaming file extracting date file unzipping file remove junk characters file loading base tables involved continuous enhancements fixing production problemsgenerated server side plsql scripts data manipulation validation materialized views remote instances developed plsql triggers master tables automatic creation primary keys created pl sql stored procedures functions packages moving data staging area data mart mar created scripts create new tables views queries new enhancement application using toadcreated indexes tables faster retrieval data enhance database performance involved data loading using plsql sqlloader calling unix scripts download manipulate files performed sql plsql tuning application tuning using various tools like explain plan sqltrace tkprof autotrace extensively involved using hints direct optimizer choose optimum query execution plan plan used bulk collections better performance easy retrieval data reducing context switching sql plsql engines created plsql scripts extract data operational database simple flat text files using utl filepackage creation database objects like tables views materialized views procedures packages using oracle tools like toad plsql developer sql plus partitioned fact tables materialized views enhance performanceextensively used bulk collection plsql objects improving performing created records tables collections nested tables arrays improving query performance reducing context switching used pragma autonomous transaction avoid mutating problem database trigger extensively used advanced features plsql like records tables object types dynamic sql handled errors using exception handling extensively ease debugging displaying error messages application collaborated product management design build test systems collaborated developers performance engineers enhance supportability identify performance bottlenecks developed code fixes enhancements inclusion future code releases patches fleetcor senior oracle developer covington usa 042011 072016 developed advance plsql packages procedures triggers functions indexes collections implement business logic using sql navigator generated server side plsql scripts data manipulation validation materialized views remote instances created management analysis reporting using parallel queries java stored procedure htpp package webshow document partic ep sho participated change code reviews understand testing needs change components worked troubleshooting defects timely manner involved creating unix shell scripting defragmentation tables partitioning compressing indexes improved performance efficiency involved table pro table redesigning implementation partitions table partition indexes make database faster easier maintain asier mantan make dala experience database application development query optimization performance tuning dba solutions implementation experience complete system development life cycle used sql server ssis tool build high performance data integration solutions including extraction transformation load packages data warehousing extracted data xml file loaded databasedesigned developed oracle forms reports generating 60 reports performed modifications existing form per change request maintained itused crystal reports track logins mouse overs clickthrough session duration demo graphical comparisons sql database customer information worked sqlloader load data flat files obtained various facilities every day used standard stand packages like utl file dmbs sql plsql collections used bulk binding involved writing database procedures functions packages front end module used principles normalization improve performance involved etl code using pl sql order meet requirements extract transformation cleansing loading data target data structures source involved continuous enhancements fixing production problems designed implemented tuned interfaces batch jobs using plsql involved data replication high availability design scenarios oracle streams developed unix shell scripts automate repetitive database processes built databases table structures following ntier architecture methodology web applications analyzed designed relational databases using er studio erwin data model tool cox automotive senior oracle developer utica india 062009 042011 involved full development cycle planning analysis design development testing implementation designed logical physical data models star snowflake schemas using erwin wrote sequences automatic generation unique keys support primary foreign key constraints data conversions created modified sqlplus plsql sqlloader scripts data conversions upgraded also tested databases oracle 9i 10g software different environments latest features developed modified triggers packages functions stored procedures data conversions plsql procedures create database objects dynamically based user inputs wrote sql plsql sqlplus programs required retrieve data using cursors exception handling worked xml along plsql develop modify web forms designed data modeling design specifications analyze dependencies creating indexes tables improve performance eliminating full table scans views hiding actual tables eliminate complexity large queries finetuned proceduressql queries maximum efficiency various databases using oracle hints rule based optimization created custom reports forms end users check details errors worked closely clients establish problem specifications system designs worked closely clients establish problem specifications system designs nelnet sr software engineer sidney ne india 022007 052009 wrote conversion scripts using sql plsql stored procedures functions packages migrate data sql server database oracle database performed database administration database objects including tables clusters indexes views sequences packages procedures implemented 11g upgraded existing database oracle 9i oracle 11g involved logical physical database layout designsetup design backup recovery strategy various databases performance tuning oracle databases user applications used sqlloader etl tool load data staging tables used dts packages etl tool migrating data sql server 2000 oracle 10g provided user training production support improved performance application rewriting sql queries wrote packages fetch complex data different tables remote databases using joins sub queries database links zylog systems software engineer city state india 072005 022007 responsible designing schema using erwin data modeler generate db scripts using tool worked sqlloader import export data flat files legacy database participated development new plsql procedures functions triggers also updating old ones based change requests created various dml ddl statements using oracle plsql sql tuned existing queries using hints improve execution time queries worked sql trace tkprof generating statistics queries performing badly participated creation database objects like tables views materialized views cursors implicit explicit ref procedures packages cursors using oracle tools like toad plsql sql plus sqlloader handled exceptions prepared test scenarios performed unit regression tests plsql programs assist java development team writing sql queries application designed developed transactional analytical data structures