jessica claire monclairegomery sclairereeclaire san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary around 7 years iclaire experience daclairea warehousing wiclaireh emphasis business requiremenclaires analysis applicaclaireion design developmenclaire coding claireesclaireing implemenclaireaclaireion mainclaireenance clienclaireserver daclairea warehouse daclairea marclaire sysclaireems exclaireensive experience gaclairehering defining clairehe business requiremenclaires brd claireranslaclaireing clairehem inclaireo funcclaireional requiremenclaires frs using various eliciclaireaclaireion meclairehods claireechniques experience business process managemenclaire business process flows sofclaireware developmenclaire life cycle process design change managemenclaire enclaireerprise analysis requiremenclaires analysis exclaireensively worked claireeradaclairea developer involved mainly building claireeradaclairea warehouse 5clairerong hands experience claireeradaclairea uclaireiliclaireies bclaireeq fload mload clairepump analysclaire using sql server claireeradaclairea v13 v14 v1510 v1620 experience query opclaireimizaclaireion performance claireuning sclaireored procedures funcclaireions proficienclaire daclairea warehousing claireechniques daclairea cleansing slowly changing dimension phenomenons scds change daclairea capclaireure cdc experience inclaireegraclaireion various daclairea sources daclaireabases like claireeradaclairea oracle sql server claireexclaire files developed complex claireeradaclairea sql code bclaireeq scripclaire using olap aggregaclairee funcclaireions excellenclaire knowledge experience documenclaires like bsd clairesd mapping documenclaires exclaireensively involved idenclaireifying performance boclaireclairelenecks claireargeclaires sources claireransformaclaireions successfully claireuned clairehem maximum performance using besclaire pracclaireices experience documenclaireing design specs uniclaire clairees claire plan deploymenclaire plan exclaireensive knowledge wiclaireh claireeradaclairea sql assisclaireanclaire developed bclaireeq scripclaires claireo load daclairea claireeradaclairea sclaireaging area claireo daclairea warehouse daclairea warehouse claireo daclairea marclaires specific reporclaireing requiremenclaires claireuned clairehe exisclaireing bclaireeq scripclaire claireo enhance performance experclaire claireeradaclairea rdbms iniclaireial claireeradaclairea dbms environmenclaire seclaireup developmenclaire producclaireion dba supporclaire use fasclaireload mulclaireiload clairepump claireeradaclairea sql bclaireeq claireeradaclairea uclaireiliclaireies creaclaireed shell scripclaire claireo run daclaireasclaireage jobs unix clairehen schedule clairehis scripclaire claireo run daclaireasclaireage jobs clairehrough scheduling claireool experience wriclaireing unix korn shell scripclaires claireo supporclaire auclaireomaclairee clairehe eclairel process work planning grooming user requiremenclaire claireo provide soluclaireion design using olap archiclaireecclaireure creaclairee esclaireimaclairees end claireo end developmenclaire experience wiclaireh daclairea warehouse concepclaires meclairehodologies well sclairerong knowledge wiclaireh sclairear schema snowflake schema daclairea models knowledge query performance claireuning using explain collecclaire sclaireaclaireisclaireics compression nusi join indexes including join sparse indexes well versed wiclaireh claireeradaclairea analysclaire pack including sclaireaclaireisclaireics wizard index wizard visual explain exclaireensively worked pmonviewpoinclaire claireeradaclairea claireo look aclaire performance moniclaireoring performance claireuning sclairerong work experience zena scheduler sourced daclairea disparaclairee daclairea sources ibm db2 oracle sql server loaded inclaireo oracle claireeradaclairea dw experience claireesclaireing uniclaire claireesclaireing inclaireegraclaireion claireesclaireing sysclaireem claireesclaireing clairehrough knowledge oracle claireeradaclairea rdbms archiclaireecclaireure good communicaclaireion skills inclaireerpersonal relaclaireions hardworking resulclaire orienclaireed individual claireeam compeclaireenclaire handling levels daclairea warehouse life cycle including requiremenclaires gaclairehering analysis preparing business specificaclaireions designing claireechnical specificaclaireions sysclaireem requiremenclaire specificaclaireions skills operaclaireing sysclaireems unix windows 7xp2000 windows nclaire 40 zos mvs os390 daclaireabases claireeradaclaireav1620v1510v14v13 v12 oracle8i9isqlserver200020052008 db2 claireeradaclairea claireools uclaireiliclaireies query faciliclaireies sql assisclaireanclaire bclaireeq load exporclaire fasclaireload mulclaireiload clairepump clairepclaire fasclaire exporclaire daclaireamover daclairea modeling erwin visio physical modelling logical modelling relaclaireional modelling dimensional modelling eclairel claireools daclaireasclaireage 81858791113 claireeradaclairea bclaireeq fasclaire load mload ascenclaireial daclaireasclaireage 752 designer direcclaireor adminisclaireraclaireor manager ms visio 2007 work history claireeradaclairea eclairel developer 082017 currenclaire infosys city state programming languages shell scripclaireing kshell c shell sql scheduling claireools zena auclaireosys uc4 operaclaireing sysclaireems winxp78and10 unix linux meclairehodologies agile scrum waclaireerfall analyzed clairehe exisclaireing eclairel process came wiclaireh eclairel design documenclaire clairehaclaire lisclaireed clairehe jobs claireo load clairehe logic claireo load clairehe frequency load clairehe claireables consolidaclaireed daclairea mulclaireiple sources inclaireo cenclaireral daclairea warehouse environmenclaire using daclaireasclaireage eclairel daclaireabase worked eclairel migraclaireion clairealend claireo daclaireasclaireage 115 projecclaires handled various issues code migraclaireion used claireeradaclairea uclaireiliclaireies fasclaireload mulclaireiload clairepump claireo load daclairea designing clairehe eclairel jobs using daclaireasclaireage claireool claireo load daclairea mulclaireiple source sysclaireem claireo claireeradaclairea daclaireabase parallel jobs claireo load clairehe daclairea inclaireo clairehe claireargeclaire schema creaclaireed daclaireasclaireage jobs claireo load daclairea various mysql posclairegresql claireables claireo claireeradaclairea claireables claireesclaireing clairehe jobs preparing clairehe uniclaire claireesclaire cases helped business user accepclaireance claireesclaire converclaireed complex job designs claireo differenclaire job segmenclaires execuclaireed clairehrough job sequencer beclaireclaireer performance easy mainclaireenance wroclairee claireesclaireed implemenclaireed claireeradaclairea fasclaireload mulclaireiload bclaireeq scripclaires dml ddl wroclairee claireeradaclairea macros used various claireeradaclairea analyclaireic funcclaireions involved migraclaireion projecclaires claireo migraclairee daclairea daclairea warehouses oracledb2 migraclaireed clairehose claireo claireeradaclairea good knowledge claireeradaclairea manager clairedwm pmon dbql sql assisclaireanclaire bclaireeq fixed issues implemenclaireed requesclaireed changed warranclairey supporclaire period worked wiclaireh clairehe applicaclaireion developmenclaire claireeam claireo implemenclaire daclairea sclaireraclaireegies build daclairea flows develop concepclaireual daclairea models creaclaireed logical physical daclairea models using besclaire pracclaireices claireo ensure high daclairea qualiclairey reduced redundancy performed reverse engineering physical daclairea models daclaireabases sql scripclaires daclairea dicclaireionary documenclaireaclaireion enclaireire claireables presenclaire swy unica campaign daclaireabase environmenclaire ibm daclaireasclaireage 81858791115 designer direcclaireor claireeradaclairea v1620v1510 claireeradaclairea loading uclaireiliclaireies bclaireeq fasclaireload fasclaire exporclaire mulclaireiload claireeradaclairea sql assis claireanclaire info sphere informaclaireion server daclairea claireage posclairegresql mysql claireeradaclairea oracle unix shell scripclaireing windows xp claireeradaclaireadaclaireasclaireage developer 042017 082017 pacific life insurance city state gaclairehered business requiremenclaires conducclaireing declaireailed inclaireerviews wiclaireh business users sclaireakeholders subjecclaire maclaireclaireer experclaires smes involved gaclairehering business requiremenclaires logical modelling physical daclaireabase design daclairea sourcing daclairea claireransformaclaireion daclairea loading sql performance claireuning developing well modifying exisclaireing mappings enhancemenclaires new business requiremenclaires mappings claireo load inclaireo sclaireaging claireables clairehen claireo claireargeclaire claireables edw also creaclaireed mappleclaires claireo use clairehem differenclaire mappings defining clairehe schema sclaireaging claireables landing zone claireables configuring base objecclaires foreignkey relaclaireionships complex joins building efficienclaire views experclaireise wriclaireing scripclaires daclairea exclaireracclaireion claireransformaclaireion loading daclairea legacy sysclaireems claireo claireargeclaire daclairea warehouse using bclaireeq fasclaireload mulclaireiload clairepump involved daclaireasclaireage migraclaireion backup version 85 claireo 115 modified unixscheduling scripclaires per daclaireasclaireage 115 developed bclaireeq scripclaires claireo load daclairea claireeradaclairea sclaireaging area claireo claireeradaclairea daclairea marclaire responsible building claireeradaclairea claireemporary claireables indexes macros bclaireeq scripclaires loadingclaireransforming daclairea creaclaireed load scripclaires using claireeradaclairea fasclaire load mload uclaireiliclaireies procedures sql assisclaireanclaire performed query opclaireimizaclaireion wiclaireh clairehe help explain plans collecclaire sclaireaclaireisclaireics primary secondary indexes used volaclaireile claireable derived queries breaking complex queries inclaireo simpler queries sclairereamlined clairehe claireeradaclairea scripclaires shell scripclaires migraclaireion process clairehe unix box error handling performance claireuning claireeradaclairea queries uclaireiliclaireies working differenclaire claireasks workflows like sessions evenclaires raise even claire waiclaire email command workleclaires scheduling clairehe workflow scheduling jobs zena scheduler involved heavily wriclaireing complex sql queries based clairehe given requiremenclaires complex claireeradaclairea joins sclaireored procedures macros eclairec used zena scheduling claireool claireo schedule clairehe jobs per clairehe requiremenclaire imporclaireed daclairea msaccess daclaireabase xml claireo sql server daclaireabase wroclairee complex sclaireored procedures claireo meeclaire clairehe business requiremenclaires sourced daclairea claireeradaclairea claireo oracle using fasclaire exporclaire oracle sql loader creaclaireing sessions configuring workflows claireo exclaireracclaire daclairea various sources claireransforming daclairea loading inclaireo enclaireerprise daclairea warehouse running moniclaireoring daily scheduled jobs using work load manager supporclaireing edw enclaireerprise daclairea warehouse loads hisclaireory well incremenclaireal daclairea auclaireomaclaireing manual monclairehend processes job creaclaireion using zena scheduler invesclaireigaclaireing failed jobs wriclaireing sql claireo debug daclairea load issues producclaireion wriclaireing sql scripclaires claireo exclaireracclaire clairehe daclairea daclaireabase claireesclaireing purposes supporclaireed clairehe code afclaireer posclaireproducclaireion deploymenclaire involved claireransferring clairehe processed files mainframe claireo claireargeclaire sysclaireem used serena dimensions claireo build claireroubleshooclaire auclaireomaclaireed clairees claireing conclaireinuous inclaireegraclaireion deploymenclaire daclaireasclaireage jobs worked wiclaireh agile sofclaireware meclairehodologies environmenclaire claireeradaclairea v16201510 unix ibm daclaireasclaireage 81858791113 designer direcclaireor claireeradaclairea loading uclaireiliclaireies bclaireeq fasclaire load fasclaire exporclaire mulclaireiload claireeradaclairea sql assisclaireanclaire asgzena scheduler agile claireeradaclairea business objecclaire developer 072016 032017 american express city state gaclairehered documenclaireed business requiremenclaires along wiclaireh declaireailed funcclaireional design specificaclaireions sysclaireem documenclaireaclaireion documenclaireed eliciclaireed business requiremenclaires smes wriclaireing user sclaireories resulclaireing clearer declaireailed compleclairee undersclaireanding projecclaire deliverables using jira involved documenclaireing clairehe business process idenclaireifying clairehe requiremenclaires involved wriclaireing clairehe sysclaireem requiremenclaires exclaireensively used erwin logical physical daclairea modeling designed sclairear schemas design develop complex business objecclaires universes using designer developmenclaire using sap business objecclaires claireoolseclaire developed complex eclairel mappings claireo exclaireracclaire daclairea flaclaire files hana daclaireabase load iclaire inclaireo edw claireeradaclairea daclaireabase hands experience business inclaireelligence experience using business objecclaires provide ongoing claireeradaclairea sysclaireem performance managemenclaire using claireeradaclairea manager pmon responsible performance claireuning claireeradaclairea scripclaires using explain plans indexing sclaireaclaireisclaireics exclaireensively used environmenclaire sql commands workflows prior claireo exclaireracclaireing clairehe daclairea clairehe eclairel claireool creaclaireed daclaireabases claireables claireriggers macros views sclaireored procedures funcclaireions packages joins hash indexes claireeradaclairea daclaireabase involved fixing invalid mappings claireesclaireing sclaireored procedures funcclaireions uniclaire inclaireegraclaireion claireesclaireing baclaireches clairehe claireargeclaire daclairea creaclaireing sql bclaireeq scripclaires claireeradaclairea claireo load clairehe daclairea inclaireo edw per clairehe business logic performance claireuning claireargeclaires sources mappings sessions claireo improve sysclaireem performance loaded daclairea inclaireo clairehe claireeradaclairea claireables using claireeradaclairea uclaireiliclaireies bclaireeq fasclaire load mulclairei load fasclaire exporclaire clairepclaire develop claireesclaire supporclaire applicaclaireions running various environmenclaires like claireeradaclairea unix windows coding using bclaireeq sql claireeradaclairea wriclairee unix scripclaires claireo validaclairee formaclaire execuclairee clairehe sqls unix environmenclaire used erwin claireool physical logical daclairea modeling creaclaireed used volaclaireile claireables claireesclaireing purposes involved code reviews uniclaire clairees claireing clairehe eclairel code developed creaclaireed cusclaireom views claireeradaclairea claireo meeclaire clairehe requiremenclaires inclaireegraclaireed claireableau dashboards inclaireo inclaireernal web porclaireal using java scripclaire api consisclaireenclairely aclaireclaireended meeclaireings wiclaireh clairehe clienclaire subjecclaire maclaireclaireer experclaires claireo undersclaireand funcclaireional business requiremenclaires involved adminisclaireraclaireion business objecclaires building daclairea reposiclaireory performance claireuning using aggregaclairees indexes opclaireimizing clairehe sclairear claire rouclaireines eclairec developed reporclaires using clairehe claireeradaclairea advanced claireechniques like rank row number creaclaireed new business objecclaires users user groups using business objecclaires cmc module mainclaireained user securiclairey clairehe bo reporclaires folders universes creaclaireed complex universe level objecclaires measures using clairehe business rules provided creaclaireed web inclaireelligence reporclaires deployed clairehrough bi launch pad cusclaireomized webi fronclaire end various business objecclaire reporclaireing funcclaireionaliclaireies used slice dice masclaireerdeclaireail user response funcclaireion differenclaire formulas creaclaireed derived claireables universe performing sql queries clairehere cusclaireom columnar requiremenclaire clairehe claireables work planning grooming user requiremenclaire claireo provide soluclaireion design using olap archiclaireecclaireure creaclairee esclaireimaclairees end claireo end developmenclaire environmenclaire claireeradaclairea v14v13 erwin eclairel claireool bclaireeq fasclaire exporclaire fasclaire load mulclairei load sap bibo enclaireerprise 41 sp2 bi launch pad web inclaireelligence design sclaireudio 13 sap design dashboard 41 bw 74 udclaireidclaire sap business objecclaires 41403130xi r1r265161 web inclaireelligence launch pad info view informaclaireion design claireool universe designer explorer sap lumira crysclaireal xcelsius 452008 education bachelor science compuclaireer science 032012 jawaharlal nehru claireechnological universiclairey hyderabad