jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 professional summary 7 years experience industry coupled extensive experience data warehousing teradata v2r61201314 unix environment decision support systems extensive experience teradatadatabase design implementation maintenance mainly large scale data warehouse environments extensive experience administration maintenance dev stage prod standby databases dss data warehousing environments strong background healthcareand clinical insurance projects experienced working healthcare data comfortable technical functional applications rdbms data mapping data management data transportation data staging hands experience teradata rdbms using fastload multiload tpump fastexport teradata sql bteq teradata utilities expertise resource management using tdqm expert coding teradata sql teradata stored procedures macros triggers involved full il lifecycle various projects including requirement gathering system designing application development enhancement deployment maintenance support expertise query analyzing performance tuning testing hands experience ein monitoring managing varying mixed workload active data warehouse using various tools like teradata workload analyzer teradata dynamic workload manager teradata manager ager experience writing unixshell scripts support automate etl process scheduled shell scripts maestro jobs kick batches experience different database architectures like shared nothing shared everything architectures agile methodology extensive experience good understanding smp smp mpp architectures experience oracle rdbms architecture worked agile met logical physical modeling using erwin hands experience 3nf star snowflakeschema design denormalization techniques involved unit testing integration testing preparing test cases proficient converting logical data models physical database designs data warehousing environment indepth understanding database hierarchy data integrity concepts data analysis developed power bi reports using power query sharepoint different data sources ssh tunnel allow compressed log transportation experience etl tools like informatica abinitio experience teradata unity system environment good understanding reporting tools like cognos business objects involved production support activities 247 call resolved database issues skills operating systems sun solaris 25 26 8 9 10 aix 51 52 mainframes mvs red hat linux rhel 21 3x windows 9598nt 4x 2000xp 2000xp rdbms bdrms teradatal teradatav2r5x6x 120130v140 oracle 11g 10g918x7x oracle 10g real application clusters rac sqlserver2005 languages sql plsql c c c xml unix shell scripting softwareapplications tools teradata sql assistant viewpoint bteq fastload multiload fastexport tpumporacle 7x8x9i10g real applications cluster rac statspack erwin teradata clusters emc storage trillium 7665developer 2000 sql loader toad 7675 oracle enterprise manager informatica ab initio cooperating system 30215 gde 30115 business objects suite web toolshtml xml java script vb script jcl java asp cgi perl java servlets visual age visual cafe jbuilder apache iis 40 work history infosys teradatainformatica developer irvine ca 2016 current environment teradata v13v14 teradata sql assistant informatica powercenter 96 sql server responsibilities created tables shell views healthspring teradata environment staging currentload ids layers created views top final edw tables order generate reports worked claims provider drug patient eligibility dimensions build structures process data created bteq script pre population work tables prior main load process involved heavily writing complex sql queries based given requirements used fastload loading empty tables created reports using bteq scripts reporting functionalities fastexport end user used volatile table derived queries breaking complex queries simpler queries responsible loading data warehouse different sources using multiload fastload load millions records developed mload scripts load data load ready files teradata warehouse performed tuning optimization complex sql queries using teradata explain created series macros various applications teradata sql assistant worked protocol protocol roster manner level2 support solve sde tickets job failures per created importedexported various sources targets transformations using informatica power center 96 implemented concept slowly changing dimensions scd type 1 type 2 used active batch schedule jobs teradata informatica using windows task scheduler infosys teradata developer jersey city nj 2015 112015 environment infosys teradata developer saint louis mo 042013 112014 environment education jntu hyderabad 2009 bachelors technology computer science computer science university central missouri 2012 masters computer science computer science infosys teradata developer hillsboro environment 012012 032013 infosys teradata developer johnston ri environment 072011 2012 kroger teradata developer city state 052010 112010 ab initio gde 113 coop sys 213 teradata v2r6 unix plsql oracle 8i ibm db2 unix windows 2000 responsibilities ge healthcare cs etlteradata developer city state india 072009 022010 environment