professional summary jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom designing building maintaining metadata models etl packages building ssis packages involving etl process extracting data various heterogeneous sources like flat files excel files sql server strong etl data warehousing operations data store concepts data marts olap oltp system skills technical skills programming sql tsql powershell vbscript database sql server 2019 sql server 2014 2012 2008r22008 operating system windows server 201620102008r22008 tools software ms office power bi visual basic etl tools ssis dts bcp reporting ssrs sql server reporting servicesserver work history 122021 current sqlbi developer neogenomics laboratories tampa fl involved planning defining designing data provided documentation worked closely business analyze consolidate request requirements improve decision planning process defined data requirements report layouts business review created user stories scripts based requirements name jessica zgebre email resumesampleexamplecom phone number 555 4321000 generated parameterized reports adhoc reports sub reports tabular reports using ssrs utilized dataflow multiple transformations incremental loads truncate reloads created modified sql queries like views functions stored procedures maintained table performance following tuning tips like creating index applying best practices worked sql server integration services ssis integrate analyze data multiple information sources experience configuring creating ssis solution etl business intelligence introduced ssrs help existing reporting process designed developed ssrs created parameterized reports linked reports thorough knowledge report server architecture using ssrs performed minor administrative duties creating folders monitoring jobs security related tasks leverage enterprise business intelligence tools sql queries tools develop complex models reports create functionaltechnical specifications document design approach environment ms sql server20052008 sql server integration services ssis sql server reporting services ssrs sql server analysis services ssas ms visual studionet 2008 tfs sharepoint visual basic60 vbnet vb script windows 2008 server 112018 112021 sqlpower bi developer ihs markit centreville va designing building maintaining complex etl package strong etl data warehousing operations data store concepts data marts olap oltp systems extensively designed packages data mapping using control flow task sequence container task dataflow task execute sql task script task ssis designer automated power query refresh using power using parameter used various sources pull data power bi sql server installed configured enterprise gateway personal gateway power bi service created workspace content packs business users view developed reports scheduled automatic refresh scheduling refresh power bi service wrote calculated columns measures queries power bi desktop show good data analysis techniques worked kind reports yearly quarterly monthly daily worked types transformations available power bi query editor created stored procedures sql queries pull data power pivot model participated project planning sessions project managers team members analyze business requirements outline proposed solution environment ms sql server 2008r2 ssrsssasssis point services 2010 microsoft office 2010 tsql windows 7 052016 102018 sql developer target city state involved process upgrading sql server systems sql server 2008 r2 2012 extensively worked tuning stored procedures queries optimum performance designed created databases tables views stored procedures cursors ddl dml triggers used dbcc commands check physical logical consistency databases rebuilt indexes provided levels support including oncall support rotational basis provided full support sql server ssis ssrs services designed implemented maintained provided full support sql server clustering mirroring controlled monitored generated access report process user access database deployed database objects developmenttesting environment production environment worked production team data warehousing handling large databases created logins users required specific roles production server created sql alerts mail linked servers accessing data remote servers using jobs environment ms sql server 2008r22008 visual studio 20082008 ms reporting services ssrs 2008 r22008 ms office 2007 ms access ms excel microsoft integration services ssis erwin education 062001 bachelor arts addis ababa university ethiopia additional information designing building maintaining metadata models etl packages building ssis packages involving etl process extracting data various heterogeneous sources like flat files excel files sql server strong etl data warehousing operations data store concepts data marts olap oltp system writing complex dax functions power bi using various sources pull data power bi sql server migrating onpremises database cloud cloud premise using multiple methods power bi desktop power bi service creating dashboards writing complex dax functions time intelligence power bi creating building automated power bi report creating develop power apps integrate power bi report dashboard power app share user use various sources pull data power bi sql server sql azure etc knowledge creating databases tables stored procedure ddldml triggers views user defined data types cursors indexes using tsql knowledge designing developing deploying various kinds reports using ssrs using relational multidimensional data working microsoft excels lookup pivottables power pivot creating various ssrs reports like charts filters subreports drilldown building ssis packages involving etl process extracting data various heterogeneous sources like flat files excel files sql server