jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 summary 5 years experience database design development business intelligence microsoft sql server 200020052008 development test production environments various business domains like financial insurance hands experience installing configuring managing upgrading migrating monitoring troubleshooting sql server 200020052008 r2 expertise sql server integration services ssis sql server reporting services ssrs experience report writing using sql server reporting services ssrs creating various types reports like drill parameterized cascading conditional table matrix chart sub reports experience e developing monitoring extracting transforming data using dtsssis import export wizard bulk insert experience writing expressions ssrs expert fine tuning reports created many drill drill reports using ssrs excellent knowledge creating databases tables stored procedures ddldml triggers views user defined data types functions cursors indexes using tsql great ability create manage various database objects like tables views experience data conversion data migration using ssis dts services across different databases like oracle ms access flat files experience performance tuning query optimization experience maintenance administration ssis creating jobs alerts sql mail agent schedule dtsssis packages hands experience creating star schema snowflake schemas excellent analytical communication interpersonal skills proficient technical writing presentations good team player ability work independently part team accomplish critical business objectives make decisions pressure skills database sql server 2019 sql server 2014 2012 2008r22008 etl tools ssis dts bcp reporting ssrs sql server reporting servicesserver programming sql tsql powershell vbscript operating system windows server 201620102008r22008 tools software ms office power bi visual basic education training georgia piedmont technical college atlanta ga associate applied science database certificate sql server database experience neogenomics laboratories sqlbi developer nashville tn 082021 current involved planning defining designing data provided documentation worked closely business analyze consolidate request requirements improve decision planning process defined data data requirements report layouts business review created user stories scripts based requirements created use 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 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 basic60vbnet vb script windows 2008 server geico insurance power bi developer cleveland oh 112019 072021 developed power bi model used used creating reporting designed documented entire architecture power bi 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 worked types transformations available power bi query editor worked kind reports yearly quarterly monthly daily created stored procedures sql queries pull data power pivot model environment ms sql server 20122008 sql server integration services ssis sql server analysis services ssas sql server migration assistant ssma oracle 11g sql profiler tsql power bi desktop power bi pro visual studio 2010 html5 java script geico insurance power bi developer college station tx 052018 102019 import data different data sources create power bi reports dashboards developing reports charts dashboards using power bi desktop manage security based requirements transform define navigate data data source performed merge append queries using power query performed transformations like pivoting unpivoting splitting columns using power query created different chart types drill reports using power bi desktop ssrs published reports visualizations power bi service thereby created dashboards created hierarchies power bi reports using visualizations like bar chart line chart worked live import data power bi creating reports managed relationship tables power bi using star schema used different type slicers available power bi creating reports creating many dashboards pinning many visualizations workspace per insights provided used power bi gateways keep dashboards reports date developing several details summary reports including line pie charts trend analysis reports subreports per business requirements responsible creating changing visualizations power bi reports dashboards client requests shared created workspace across organization using power bi apps responsible creating rowlevel security rls based business requirements environment power bi dax power bi gateway power bi apps mdx ms sql server 2016201420122008 r2 ms excel json windows 810 jiira ssrs ssas