jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom summary seasoned enterprise data warehouse architect 14 years experience system design development highlights edwbi development supervisor 6 years technical lead managerial experience enterprise data warehouse business intelligence system design development using agilescrumplanning poker methodology highlights dimensional model design erwinvisio logicalphysical model design informatica powercenterdata qualitydata explorer etl architecture design obiee repositoryrpd design inmon kimball architecture hyperion interactive reporting agile methodology sql server oracle accomplishments experience 122012 current enterprise data warehouse architect edwbi development supervisor madison metropolitan sewerage district madison wi established edw enterprise data integration hub source single truth direct operations accounting relies edw report opening closing revenue investor relationship relies edw quarterly earnings release reduced available jessicae key reports agency operation executives rely weeks one day designing implementing underwriter data mart designed change data capture framework support near realjessicae reporting data 800 source databases reduced 70 effort working day related dashboard report development designing abstract working calendar dimension meet business reporting requirements working day reduced staffing cost smart staffing busyslow season integrating staffing working jessicae information hr data warehouse software development supervisor overseeing ongoing maintenance enhancement stewart data warehouse manage team etl developers bi developers member stewart enterprise architecture team responsible data architecture data integration enhancedredesigned dimensional model created mapping specs order analysis data mart support migration reportsdashboards hyperion interactive reporting obiee created initial draft obiee repositoryrpd design involved ongoing enhancementmaintenance rpd implemented process quarterly annual data warehouse design operation review proactively fix enhance design plan growth 112009 112012 etl architectteam lead covance hartford ct technical lead data modeling etl design development lead requirement gathering analysis underwriter data mart designed dimensional model underwriter data mart designed dimensional model customer analysis mart developed customer cleansing matching data quality plans improved performance several etl mappings dealing large data sets 70 manual query push designed etl operation data quality monitoring framework 052008 102009 etl architectdeveloper stewart professional solutions city state lead dimensional model design etl designdevelopment created stewart etl development standard created first release stewart enterprise data warehouse business continuance plan operation monitoring procedures enhanced order analysis mart support reporting lock view current view 112006 042008 senior programmeranalyst stewart transaction solutions city state participated etlbi tool selection dimensional model design creating first data warehouse stewart designed highlevel workflows developed mappings sessions workflows type 2 change data capture essbase export etl assisted development data warehouse architecture policies processes created deployment document template hyperion interactive reporting reportsdashboards informatica powercenter etl objects 042005 102006 applications developer landata inc california city state developed twoway electronic policy generating delivery reporting system stewart countrywide earned lead technology contact designation stewart countrywide application integration designed developed series accounting management reports stewart title california using crystal reports 112001 042005 senior software engineerdba cmax inc city state designed database schemas prepared backup plan set maintenance jobs lead effort creating offsite disaster recovery strategy migration oracle sql server developed web service based application j2ee platform supporting hundreds payday loan stores education master science computer science maharishi university management fairfield ia computer science bachelor science computer science civil aviation university china tianjin computer science certifications data warehousebusiness intelligence lifecycle depth certificate completion kimball group 2014 dimensional modeling depth certificate completion kimball group 2012 informatica powercenter8 level ii developer certificate completion informatica 2007 hyperion system 9 bi interactive reporting certificate completion hyperionoracle 2007 microsoft certified database administrator sql server microsoft 2005 oracle certified database administrator oracle 2003 sun certified java developer sun microsystems 2002 microsoft certified solutions developer c microsoft 2005 skills accounting agile agency backup bi business intelligence closing crystal reports data modeling data warehouse data warehouse databases database delivery designing disaster recovery erwin essbase etl hub hr hyperion informatica explorer j2ee java managerial c microsoft certified database administrator microsoft certified migration modeling enterprise oracle developer policies processes quality realjessicae reporting requirement software development sql server staffing strategy sun sun microsystems supervisor system design type 2 view visio