summary jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom 5 years experience database design development business intelligence microsoft sql server 200020052008 development test production environments various business domains like financial insurance manufacturing hands experience installing configuring managing upgrading migrating monitoring troubleshooting sql server 200020052008 r2 expertise sql server integration services ssis sql server reporting services ssrs good knowledge sql server analysis services ssas experience report writing using sql server reporting services ssrs creating various types reports like drill parameterized cascading conditional table matrix chart sub reports experience developing monitoring extracting transforming data using dtsssis import export wizard bulk insert excellent high level design etl dts packages ssis packages integrating data using ole db connection heterogeneous sources like excel csv oracle flat file text format data using multiple transformations provided ssis data conversion conditional split bulk insert merge union developing reports ssrs sql server 200020052008 sound experience understanding ssas olap cube architecture 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 worked extensively etl process using ssis package experience data conversion data migration using ssis dts services across different databases like oracle ms access flat files experience using tsql sql server 20002005 2008 platforms experience performance tuning query optimization well versed performance point server 2007 designed dashboards scorecards reports using multiple kpis olap charts ssrs reports pps experience maintenance administration ssis creating jobs alerts sql mail agent schedule dtsssis packages experience sql server dts ssis integration service package design constructing deployment transformed data one server servers using tools like bulk copy program bcp data transformation services dts sql server integration services ssis experience creating packages transfer data oracle ms access flat files sql server using dtsssis expert creating parameterized reports hands experience creating star schema snow flake 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 programming sql tsql powershell vbscript skills technical skills database sql server 2019 sql server 2014 2012 2008r22008 operating system windows server 201620102008r22008 etl tools ssis dts bcp reporting ssrs sql server reporting servicesserver tools software ms office power bi visual basic experience sqlbi developer 082021 current neogenomics laboratories carlsbad ca 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 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 basic60vbnet vb script windows 2008 server pcover bi developer geico insurance chicago il developed power bi model used used creating reporting designed documented entire architecture power bi expertise writing complex dax functions power bi power pivot automated power query refresh using power using parameter used various sources pull data power bi sql server 022019 072021 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 kind reports yearly quarterly monthly daily worked types transformations available power bi query editor 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 pcover bi developer geico insurance citrus heights ca import data different data sources create power bi reports dashboards 082017 012019 experience 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 implemented complex query techniques passing multivalued parameters cascading parameters mdx performed transformations like pivoting unpivoting splitting columns using power query created different chart types drill reports using power bi desktop ssrs involved defining report layout ssrs created measures calculated columns relationships performed time series analysis using dax power bi published reports visualizations power bi service thereby created dashboards created hierarchies power bi reports using visualizations like bar chart line chart etc 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 experienced creating many dashboards pinning many visualizations workspace per insights provided experienced data modeling used define analyze data requirements needed support business processes within scope corresponding information systems organizations used power bi gateways keep dashboards reports date experience developing several details summary reports including line pie charts trend analysis reports subreports per business requirements experience generating ondemand scheduled reports business analysis management decision used recently introduced power bi create selfservice bi capabilities use tabular models responsible creating changing visualizations power bi reports dashboards client requests shared created workspace across organization using powerbi 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 education training associate applied science database georgia piedmont technical college atlanta ga cectificate sql server database