jessica claire resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 profile masters science degree management information systems business intelligence concentration 5 years experience working sql server developer sql dba data analyst excellent analytical problemsolving skills work minimal supervision strong knowledge experience rdbms like ms sql server 2008 r22012 ms access mysql tsql queries stored procedures strong knowledge experience business intelligence ssis ssrs ssas power bi power pivot power query power view power map pivot table experience windows server 20082012 active directory administration users computers dns dhcp experience data analysis visualization tools like excel tableau core qualifications business intelligence data analytics database development administration windows server administration windows azure data warehousedata mining microsoft office web design amazon web services education nova southeastern university fort lauderdale fl 2015 master science management information systems concentration business intelligence miami dade college miami fl 2003 associate science computer programming analysis haremaya university agriculture haremaya harer 1988 bachelor science agriculture plant science technical skills sql server ms access ms excel mysql ssis ssas ssrs power bi tsql vba ms access excel macros tableau rapidminer xlminer data mining html css wordpress dreamweaver photoshop javascript professional experience market footwear fred lurie associate inc sql devloperdbadata analyst city state 092012 032015 responsibilities created etl packages involving various data sources sql server flat files excel source files etc using ms ssis developed data quality solution using sql server data services dqs part etl analyzed data using using ssas excel tableau power bi tools decision making process built self f service business intelligence dashboards using power bi tools excel wrote tsql queries data analysis reporting developed reports using ms sql server reporting services ssrs excel helped decision makers understand data reports dashboards gain insights installed administered maintained ms sql server 20082012 including upgrades security configuration service packs designed implemented maintained sql server databases designed implemented tables views functions stored procedures triggers sql server planned implemented sql server security database permissions performed database performance analysis tuning using database engine tuning advisor sql server profiler sql server extended events setup highavailability part disaster recovery strategy sql server 2012 databases failover clustering database mirroring log shipping replication cifra systems sql server developerdba city state 072009 082012 responsibilities midlevel dba installed configured administered secured sql servers 20082008 r2 created optimize database objects eg tables views indexes cursors stored procedures functions triggers scheduled automated maintenance plans using sql server job agent scheduled automated fulldifferentialtransactional backups implemented recovery strategies configured monitored database mirroring replication log shipping hadr strategy planned implemented sql server security database permissions extensively used joins subqueries complex queries involving multiple tables created indexes clustered nonclustered speed query performance designed excel dashboard tabular chart reports drill functionality miami christians fellowship web designersql dbadevelopermedia specialist city state 022005 042009 designed desktop database application ms access using vba developed financial report using ms access excel created website organization utilizing html wordpress css php msssql mysql performed regular website maintenance update also designing graphics banners flyers posters recorded edited videos distributed dvd cd format upload organizations website trained staff members utilize computers use software maintain website media support services hotsilhouette inc web developer database support city state 072003 2005 responsibilities developed maintained companys websites using dreamweaver html css aspnet javascript designed managed backend sql server databases web applications wrote complex tsql queries manipulate data designed edited graphics photos websites using photoshop installed configured managed sql server access databases analyzed sales data different sources created dashboards using ms excel provided technical computer support end users