jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary 5 years experience database development administration knowledge relational database sql server particularly ssms ssrs ssis transactsql sql server agent extensive exposure creation database objects stored procedures triggers views user defined functions cursors core qualifications sql server tools sql server management studio ssms data warehouse tools ms sql server 200520082012 integration services business intelligence tools sql server 200520082012 business intelligence development studio programming languages tsql reporting tools sql server 200520082012 reporting services development environment visual studio 200520082012 operating systems windows xp20032008 server win 3x 9598 vista win 7 advanced excel vlookup subtotal pivot table chart experience 112014 current data analyst liberty healthcare corporation ok experience constraints rules default setting primary foreign unique default key developed joins subqueries simplify complex queries involving multiple tables experienced using temporary tables table variables common table expression cte enhance optimized sql queries form improved performance queries experience crating updating clustered nonclustered indexes keep sql server performance well versed normalization denormalization techniques oltp olap system experienced using try catch block introduced sql server 2005 error handling great deal experience authoring managing deploying ad hoc enterprise advance interactive reports using sql server reporting servers expert data extraction transforming loading etl using various tools ssis dts bulk insert data cleansing profiling well experienced using different transformations tools like aggregate cache transformation conditional split copy columns sort column data conversion derived column merge merge join union import export columns ole db command data extraction form ole db server encrypt compressed tf pgp tf compression task remote server location ftp server csv format implementation point time backup recovery databases executing package scheduling managing jobs sql server agent maintain good documentation managed maintained users security permissions migration database objects form one server another server database another database exposure business analysis requirements gathering business health care domains mainly knowledge complete software development life cycle work experience agile environment strong research analytical coordination interaction skills team player able quickly grasp new technologies products 092012 102014 data analyst sql server developerssisssrs ebs ebsethiopian broad casting service aims promote ethiopian african countries values cultures traditions global scale muchneeded information provided ebs would help bridge cultural divide narrow communication gap ethiopians residing north america around world involved gathering business requirements installation configuration sql server created database tables wrote stored procedures developers users created sql scripts defined functions check constraints indexes views created triggers enforce data referential integrity create new ssis package 2008r2 extract date legacy sql server objects extensively used ssms ssis importexport system performing etl operations performed data conversion fat file excel normalized database structure configured server sending automatic mails developed monitored deployed ssis packages 2008r2 installation configuration reporting server generated snapshot drill parameterized reports using ssrs prepared adhoc reports report builders published report manager design created different types reports like sub reports drillthrough cascading drill adhoc reports visual studio deploy manage microsoft sql server reporting services configuration manager ethiopian magical farm plc jessica ababa ethiopia 022010 072012 sql etl developerssisssrs responsibility designed developed databases created store procedures views tables generated tsql script application business intelligence development studio bids create edit deploy ssrs ssis designed deployed maintained various ssrs reports sql server 2008r2 created etl packages using ssis extract data relational database transform load database developed deployed monitored ssis packages including upgrades dts ssis developed executed documented maintained appropriate bi procedures collaborated network operators application developers dbas enhance end user experience scheduling jobs alerting using sql server agent education bsc degree information science admas university information science professional affiliations skills ad agile aims automate backup business analysis bi business intelligence business management hardware data collection data conversion data migration data modeling dts data warehouse databases database delivery documentation edit etl fat ftp logic managing access ms excel excel excel v microsoft sql win 7 win 3x 9598 windows xp migration enterprise network olap ole operating systems db pivot table plc programming quality relational database reporting requirement requirements gathering research scheduling servers scripts script software development sorting ms sql server microsoft sql server sql sql server sql server tables team player tsql tsql translating unique upgrades vista visual studio