jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 summary 9 years experience industry emphasis analysis design development implementation management projects using etloracle sql plsql education bachelor engineering computer science model engineering college skills active member mbia insurance deal analysis system midas database development team investment banking knowledge member credit suisse advanced execution services aes participating algorithmic high frequency trading project insurance domain knowledge claims adjudication pricing provider networks developed ddldml scripts stored procedures required migrating data adp wfn 70 adp wfn 90 proficient oracle plsql extraction transformation loading etl concepts used various tools like informatica datastage proficient reporting concepts used tools like crystal reports oracle reports intermediate level knowledge unix shell scripting perl extensive working experience perience writing various modules likes functions stored procedures cursors implicit explicit ref packages triggers creating tables views materialized views using oracle sql plsql proficient oracle tools utilities toad plsql developer sql developer experience data warehouse design data modeling schema design proficient oracle sql tuning plsql debugging experience performance tuning using various types hints partitioning indexes sql trace tkprof explain plan good knowledge rdbms concepts advanced oracle queuing oracle workflow extensive experience client facing roles working multicultural multigeographic teams ability effective team player work time constraints deep understanding software development cycle sdlc implemented various models like spiral agile xp scrum experience sr oracle plsql developer consultant 092015 current mbia bond insurance purchasegreater new york new york mbia insurance deal analysis system midas empowers largest municipal bond insurer product mbia would provide financial guarantee insurance specialized financial services responsibilities creating new procedures functions triggers materialized views packages simple ref traditional cursors dynamic sql table functions part projectapplication requirements working sqlloader load data flat files obtained various facilities every day expertise 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 involving continuous enhancements fixing production problems generated server side plsql scripts data manipulation validation materialized views remote instances developing plsql triggers master tables automatic creation primary keys creating plsql stored procedures functions packages moving data staging area data mart extensively working create new tables views queries new enhancement application using toad creating indexes tables faster retrieval data enhance database performance involving data loading using plsql sqlloader calling unix scripts download manipulate files extensively performance tuning sql plsql tuning application oltp olap tuning using various tools like explain plan sqltrace tkprof autotrace extensively involving creating hints direct optimizer choose optimum query execution plan expertise bulk collections better performance easy retrieval data reducing context switching sql plsql engines creating plsql scripts extract data operational database simple flat text files using utl file package partitioning fact tables materialized views enhance performance creating collections nested tables arrays improving query performance reducing context switching dynamic sql using pragma autonomous transaction avoid mutating problem database trigger handling errors using exception handling extensively ease debugging displaying error messages application environment oracle 11g database sql plsql toad xml jira plsqldeveloper unix scripting perl windows7 java syllable sr oracle plsql developer consultant city state 042015 082015 workforce wfn adp workforce empowers clients effectively address business challenges flexible secure integrated hcm solution supports full spectrum hr needs recruitment retirement everything responsibilities creating new procedures functions triggers materialized views packages simple ref traditionalcursors dynamic sql table functions part projectapplication requirements working sqlloader load data flat files obtained various facilities every day wrote conversion scripts using sql plsql stored procedures functions packages migrate data wfn 70 database wfn 80 database expertise 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 involving continuous enhancements fixing production problems generated server rver side plsql scripts data manipulation validation materialized views remoteinstances developing plsql triggers master tables automatic creation primary keys creating plsql stored procedures functions packages moving data staging area data martextensively working create new tables views queries new enhancement application using toad creating indexes tables faster retrieval data enhance database performancei nvolving data loading using plsql sqlloader calling unix scripts download mampulate mes manipulate files extensively performance tuning sql plsql tuning application oltp olap tuning using various tools like explain plan sqltrace tkprof autotrace extensively involving creating hints direct optimizer choose optimum query execution plan expertise bulk collections better performance easy retrieval data reducing context switching sql plsql engines creating plsql scripts extract data operational database simple flat text filesusing utl file package partitioning fact tables materialized views enhance performance creating collections nested tables arrays improving query performance reducing context switching dynamic sql using pragma autonomous transaction avoid mutating problem databasetrigger handling errors using exception handling extensively ease debugging displaying errormessages application environment oracle 11g database sql plsql toad xml jira plsqldeveloper unix scripting perl windows7 sr oracle plsql developer consultant 092013 032015 credit suisse equity new york city new york advanced execution services aes aes helps thousand institutions hedge funds reduce market impact improve performance vs benchmarks add consistency trading process aes group provides credit suisses award winning suite algorithmic trading strategies tools analytics global trading single connection desk aes get access liquidity around world algorithmic trading crossfinder dark pool direct market acess smart order routing key engines part aes responsibilities creating new procedures functions triggers materialized views packages simple ref traditional cursors dynamic sql table functions part projectapplication requirements working sqlloader load data flat files obtained various facilities every day expertise unix shellscripts 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 involving continuous enhancements fixing production problems generated server side plsql scripts data manipulation validation materialized views remote instances developing plsql triggers master tables automatic creation primary keys creating plsql stored procedures functionsandpackages moving data staging area data mart extensively working create new tables views queries new enhancement application using toad creating indexes tables faster retrieval data enhance database performance involving data loading using plsql sqlloader calling unix scripts download manipulate files extensively extensively performance tunning sql plsql tuning application oltp olap tuning using various tools like explain plan sqltrace tkprof autotrace extensively involving creating hints direct optimizer choose optimum query execution plan expertise bulk collections better performance easy retrieval data reducing context switching sql plsql engines creating plsql scripts extract data operational database simple flat text files using utl file package partitioning fact tables materialized views enhance performance creating collections nested tables arrays improving query performance reducing context switching dynamic sql using pragma autonomous transaction avoid mutating problem database trigger handling errors using exception handling extensively ease debugging displaying error messages application extensive scripting perl generate regulatory reports deliver business environment oracle 11g database sql plsql toad xml jira plsqldeveloper unix scripting perl windows7 sr oracle plsql developer consultant 052011092013 delta dental virginia insurance roanoke va delta claim system dcs integrates claims eligibility billing functions claims keyed directly dcs2000 one step claims processing feature keeps dcs delivers superior service members providers employer groups subscribergroupsclaims data would loaded using various etl methods necessary strategy would applied system adjudicationpricing enrollments responsibilities involved maintenance enhancement application maintaining logical physical structure database creating table spaces tables views scripts automatic operations database activities coded various stored procedures packages triggers incorporate business logic application used technical document design database tables data conversion flat file intermediate tables using sqlloader data mapping gather database user level statistics analyze overall system performance designeddeveloped tables views various sql queries stored procedures functions monitor monitor database system backups developed oracle stored procedures functions packages triggers pull data reports develop unix shell scripts administer system extensively worked dynamic sql composite data types global temporary tables responsible purging archiving production databases used utl job automate plsql procedures packages involved interacting users error fixing enhancing plsql packages stored procedures functions performed logical backup using export import utilities developed database objects including tables indexes views sequences packages triggers procedures troubleshoot database problems involved unit testing stored procedures functions created sqlloader scripts load data temporary staging tables created custom triggers stored procedures packages sql scripts involved uploading data flat files databases validated data pl sql procedures performance tuned complex stored procedures faster execution developed database structures according requirements environment oracle 10g11g database sql plsql oracle storedproceduresfunctions java 15 mysql toad xml jira sqldeveloper unix scripting java oracle plsql developer consultant 092009 022011 fidelity national information services consumer banking malvern pa electronic deposit account opening edao edao would provide financial institutions ability offer enhanced new account opening workflow via internet customers new account opening includes internal verification external verification using alerts notify applicants outcome application added notes application enhanced application management features providing advance search options ability resubmit applications could completed successfully responsibilities responsible design development backend applications oracle plsql delivery onsite offshore etl development clients performance tuning backend queries used online applications prioritization projects based business needs timely deployment etl code designed etl workflows various tools like informatica datastage ssis software engineer 012007 092009 igate global solutions bangalore india