jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary motivated resultsdriven bi developer proven track record business intelligencebi data warehousedwh data analytics related consulting projects proven ability identify business needs develop valuable solutions drive accuracy process efficiency excellent skills data warehouse relational multidimensional databases data migration system data integration reporting analysis software development data management experienced developing implementing documenting monitoring maintain data warehouse extracts transformations etl process various industries like financial health care retail etc extensive professional experience design development implementation support missioncritical business intelligence bi applications experience across entire microsoft bi suite products including sql server ssis ssas ssrs power bi sdlc prototyping deployment delivered bi reporting solutions power bi reporting services ssrs tableau microstrategy experience phases software development life cycle sdlc agile methodologies worked small large scale projects believe team work delivered team member team lead independent consultant excellent communication leadership skills skills databusinesssystems analysis tools ms sql server integration services ssis analysis services ssas development skills tsql dax mdx c bi reporting tools power bi reporting services ssrs tableau microstrategy data quality standards agile methodology work history lead power bi data analystsql developer 102016 current emd millipore urbana il led design development reporting data module sales integration portal built agency corporate customers united airlines gathered documented business requirements analytical reports participated requirements meetings data mapping sessions understand business needs identified documented detailed business rules developed least two three visual options report discussion united stakeholders product owners leadership customers integrated custom visuals based business requirements using power bi desktop developed complex sql queries using stored procedures common table expressions ctes temporary table support power bi ssrs reports developed complex calculated measures using data analysis expression language dax embedded power bi reports salesforce portal page also managed access reports data individual users using roles worked microsoft team product limitations communicate limitations tool capabilities united business stakeholders provided continued maintenance development bug fixes existing new power bi reports sr sql bi data warehouse developer 082015092016 state washington city state project primarily development data mart budget health services department along analysis existing data warehouse performance improvements participated requirements meetings data mapping sessions understand business needs documented requirements business requirement documents brd designed developed schema data models updated maintained logical physical model using erwin modeler worked phases data warehouse development life cycle gathering requirements implementation testing training support interviewed business users dwh business analysts understand troubleshoot existing bottlenecks problem areas developed automated data dictionary enterprise data warehouse using ssrs sql designed developed etl ssis packages facilitate incremental load process created aggregates partitions attribute relationships user defined hierarchies goal reduce cube processing time 2 hours 60 minutes query processing time less 500ms created stored procedures performed index analysis slow performing ssrs reports bring report rendering time 15 mins 30 seconds developed enterprise wide cascading reports ssrs used throughout agency monitor performance cube logging nightly etl loads also monitor active users cube migrated existing self service reports adhoc reports power bi developed custom calculated measures using dax power bi satisfy business needs used team foundation server tfs source control sprint planning development engineer 042010 082015 duke university medical center city state worked ambitious project develop enterprise wide health record system data warehouse connecting 4 hospitals 300 ambulatory clinics worked business intelligence manager plan bi strategies create bi road map budget plans deliver organizations business intelligence needs conducted interviews key business users collect information business processes user requirements documented business processes analyzed procedures see would meet changing business needs assessed impact current business processes users stakeholders developed multiple dashboards analytical reports kpis interactive reports based business requirements using ssrs support executive business needs developed interactive super bill report ssrs support transition icd9 icd10 designed developed fullscale bi reporting solution using ssrs created ssis packages using best practices scratch perform etl process load data destination table performed extraction migration data etl heterogeneous data sources using ssis created managed schema objects tables views cursors indexes stored procedures experienced working star schema snow flake schema develop molap cubes using ms sql server analysis services ssas tsql developer 062006 062007 anuva technologies city state india performed normalization database reduce redundancy achieve maximum system performance involved creating database objects using stored procedures triggers functions views tsql joins using tsql used query analyzer optimize query performance effectively analyzed business needs translate needs deliverables bachelor science 2006 university pune pune maharashtra india master science 2010 old dominion university norfolk va education