jessica claire resumesampleexamplecom 555 4321000 100 montgomery st 10th floor summary 12 years programming experience oracle plsql developer analysis design implementation business applications using oracle relational database management system rdbms 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 using oracle 12c11g10g918i plsql sql plus toad sql loader effectively made use table functions indexes table made use table 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 tables loaded 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 ensively 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 technical skills databases oracle 7x819110g11g12c 19csql plsql stored procedures triggers ms sql server 200020052008 db2 udb teradata sap tables ms access oracle tools oracle apex 22121 18 etc ftl tools informatica power center 96 sql loader datastage reporting tools operating systems unix sun solaris linux hp unia unix aix windows nt 989520 98952000 windows xp data modeling erwin 35240 languagesutilities sql plsql unix shell scripts xml tools autosys controlm pvcs win cvs informatica data quality b2b data transformation informatica power exchange informatica 910 developer analyst tpump fast load bteq performance improvements perfor data warehousing design development technical analysis rdms development sql agile development methodologies testing deployment database development documentation management education training sv university tirupathi india 062005 bachelor science mathematics statistics computer science experience state street bank sr plsql developer 112022 current responsibilities coordinated frontend design team provide necessary stored procedures packages necessary insight data worked sql loader load data flat files obtained various facilities every day created 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 problems generated serverside plsql scripts data manipulation validation materialized views remote instances developed plsql triggers master tables automatic creation primary keys created plsql stored procedures functions packages moving data staging area data mart created scripts create new tables views queries new enhancement application using toad created indexes tables faster retrieval data enhance database performance involved data loading using plsql sql loader calling unix scripts download manipulate files performed sql plsql tuning application tuning using various tools like explain plan sql trace 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 file package creation database objects like tables views materialized views procedures packages using oracle tools like toad plsql developer sql plus plus partitioned fact tables materialized views enhance performance extensively 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 sol handled errors using exception handling extensively ease debugging displaying error messages application analyze understand system requirements business rules functional nonfunctional requirements design develop informatica etl mappings sessions workflows per system requirement document create sql plsql scripts oracle teradata databases per system requirement document develop unix shell scripts teradata bteq scripts configuration files parameter files environment oracle 19c sql plus toad sql loader sql developer shell scripts unix windows xp bny mellon specialist db developer state 122018 112022 coordinated frontend design team provide necessary stored procedures packages necessary insight data worked sql loader load data flat files obtained various facilities every day created 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 problems generated serverside plsql scripts data manipulation validation materialized views remote instances developed plsql triggers master tables automatic creation primary keys created plsql stored procedures functions packages moving data staging area data mart created scripts create new tables views queries new enhancement application using toad created indexes tables faster retrieval data enhance database performance involved data loading using plsql sql loader calling unix scripts download manipulate files performed sql plsql tuning application tuning using various tools like explain plan sql trace tkprof autotrace extensively involved using hints direct optimizer choose optimum query execution plan used bulk collections better performance easy retrieval data reducing context switching sql plsql engines analyze understand system requirements business rules functional nonfunctional requirements design develop informatica etl mappings sessions workflows per system requirement document document create sql plsql scripts oracle teradata databases per system requirement document develop unix shell scripts teradata bteq scripts configuration files parameter files created plsql scripts extract data operational database simple flat text files using utl file package 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 performance extensively 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 plus toad sql environment oracle 19c sql loader sql developer shell scripts unix windows xp bny mellon private limitedmar project lead developer 032011 122018 developed advance plsql packages procedures triggers functions indexes collections implement business logic using sql navigator generated serverside plsql scripts data manipulation validation materialized views remote instances created management analysis reporting using parallel queries java stored procedure htp package webshow document 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 redesigning implementation partitions table partition indexes make database faster easier maintain 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 database extracted designed developed oracle forms reports generating 60 reports performed modifications existing form per change request maintained used crystal reports track logins mouse overs clickthrough session durations demographical comparisons sql database customer information worked sql loader load data flat files obtained various facilities every day used standard 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 plsql order meet requirements extract transformation cleansing loading data source target data structures 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 shellscripts automate repetitive database processes environment java oracle 10g11g plsql sql loader oracle streams 10g replication sql plus html sql server ssis toad xml hp unix shell scripting ught sought recruited valuable engineering staff improve update solution actively soug performance integrating new viewpoints untapped talent prepared training manuals product users following technical writing guidelines delivered code meet functional technical specifications participated contributed best practices drive software development lifecycle utilized unit testing methods enhance quality documented technical specifications project testing methods future reference implemented quality ontime technical solutions align business requirements analyzed tested applications prior launch remedy last minute issues