jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary senior data architect bi engineer 11 plus years professional experience data wrangling techniques supporting complex business intelligence projects team lead 4 plus years managerial experience providing endend solutions several business intelligence data analytics initiatives top skills database design extract transform load etl sql server integration services ssis sql server report services ssrs dashboard tsql experience senior etl developer 072018 current forward airsandy springs ga vbnet xml data architecture date modeling marketing cloud customer experience success lead engineer multiple projects worked senior executive directors provide bi dw solutions provided roadmap bi dw team achieve project goals timely manner guided enterprise data warehouse team achieve project goals serving primarily ssis etl sql development lead initiatives within mgpo physician analytics business intelligence team lead developer providing end end data warehouse solutions including data ingestion creation databases reporting staging environments etl design development building complex agg fact tables highly successful projects telehealth rco pos sam coding rco hb denials pb denials patient referrals created best practices etl design development responsible reducing processing time 70 complex etl jobs responsible mentoring training new hires team shown ability work many disparate data sources crossing multiple hospitalbased initiatives developed best practices solutions help end users access analyze data data warehouse data marts operational systems developed data extracts dashboards revenue cycle operations team included denials data claims data balance score card data perform regular etl deployments ssis catalogs powershell scripts iport team weekly sprints provide database administration support shrinking database moving file groups create index views loading backfilling big data efficient manner using bcp bulk insert powershell scripts working creating dashboard using power bi monitor daily production jobs provide timely resolution production issues optimize run time jobs running slow work bi cognos team optimize query performance automated data extracts clarity load data iport senior data warehouse developer consultant 042013 072018 alchemy systems austin tx client cvs health lead developer cvs health epic reporting supervised team developers help migrate existing reporting database use clarity database build data warehouse worked team acquired cvs health transition epic clarity database design develop solutions map existing epic data data warehouse client northwestern medicine developed extracts northwestern medicine clarity ids inhouse data warehouse northwestern medicine epic golive built reports using ssrs tableau dashboards client partners health lead developer epic clarity reports extracts revenue cycle clinical departments developed large complex data extracts automate using ssis developed packages data warehouses across partners entities client cvs health created data models developed database structures managed administered large scale data warehouse databases designed developed custom etl packages cogito data warehouse using ssis analyzed nonepic datasets identify required data elements moved caboodle excellent understanding dimensional data modelling star schema fact tables dimension tables developed extracts using ssms automated data extract jobs using ssis developed reports using ssrs dashboards using tableau client providence health responsible build test report configuration clarity reporting workbench implementation epic system extensive experience creating large daily extracts different clarity data models phs community connect clients automate using informatica experience developing complex aggregated datasets load data warehouse used informatica automate data extracts senior consultant 012012 042013 aon corporation virtual wi lead business analyst endeca search implementation project gathered translated requirements variety interviewing methods analysis facilitation techniques created coherent report design documents led successful bi solutions acted liaison company business owners technical associates within ensure data collected processed actionable relevant business needs owned managed complete projects included understanding business processes application supported way rollout support business analyst 042010 122011 manpowergroup city state lead business analyst manpowergroup iphone application gathered business requirements various departments via interviews surveys worked directly teams different countries understand integration issues provide resolutions querying source target databases unit testing produced adhoc queries developed reports support business needs education mba executive mba 2022 kent state university kent oh master science electrical engineering telecommunication 2008 university maine orono master science software engineering ai robotics 2006 sharif university technology tehran iran bachelor science computer engineering 2001 university culture science tehran iran