jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 professional summary tuning 5 year experience database design bi development ms sql server 2014 20122008 versions various development test production environments various business domains experience data extraction transforming loading etl using various tools sql server integration services ssis data transformation services dts proficient writing complex sql queries stored procedures triggers views cursors joins constraints ddl dml user defined functions implement business logic also created clustered nonclustered indexes created various complex formula reports query database business intelligence strong dba development skills writing tsql scripts worked extensively etl process using dts ssis packages handling data quality issues generating various types sof reports using ssrs olap databases demonstrated expertise ms 5 sql server 201220082005 microsoft business intelligence msbi tools like ssis ms sql server integration services ssrs ms sql server reporting services ssas ms sql server analysis services tsql scripts experience optimization performance tuning using sql profiler wizard performance monitor execution plan evaluates refine business intelligence business objectives decision support needs data performance requirements meet departmentalproject level objectives provides design support development business intelligence solutions works multiple tasksprojects team member extract data databases data warehouses reporting facilitate sharing multiple data systems proficient use query reporting analysis tools standardize data collection developing methods database database design validation reports evaluates validate quality performance completeness business intelligence models solutions strong understanding application systems business intelligence methods ability quickly learn new software solutions experience deploying created reports various sources like web browser xml pdf teamoriented technically motivated creative user oriented desire learn clients business requirements strong inclination finishing job project deadline flexible versatile adapt new environment work project skills languages sql html xml mysql oracle 11g10g9i ms sql server 2016141208 db2 v81 database tools sql query analyzer sql enterprise manager management studio sql server 2005 query editor solution explorer analysis manager reporting server operating system windows 080705ntxp linux mac etl tools informatica power center 96186 designer workflow mar workflow manager workflow monitor repository manager informatica server data manager10x ssisssrs developments tools microsoft visual studio 201513121008 2005 powershell tools ms visual studio ms office word excel powerpoint access education san francisco state university san francisco ca 2013 bachelor arts business administration work history wells fargo sql developer great falls mt 2016032017 involved software development life cycle sdlc process analyzing business requirements understanding functional work flow information source systems destination systems designed developed ssis packages import export data ms excel sql server 2012 flat files installed sql server 2014 management tools using sql server setup program designed ssis packages extract transfer load etl data flat files sql server using business intelligence development studio analyzed business requirements built logical data models describe data relationships data perform dml ddl operations per business requirement creating views ares business reports prepares resolved production issues modifying backend code required used different joins sub queries nested query sql query documented data entity relationships attributes file descriptions definitions created database objects like tables views sequences synonyms stored procedures functions packages cursors ref cursor designed developed deployed reports ms sql server environment using ssrs testing code functionality using testing environment neogenomics laboratories sqlbi developer 052014 112015 created sql server reports using ssrs management tasks included defining requirements design develop test implement maintain reports using ssrs reports documented data entity relationships attributes file descriptions definitions designed reviewed created primary objects views indexes based logical design models user requirements physical requirements participated developing logical model implementing requirements sql server 2012 created created database reporting team created configuration tables stored procedure user defined function sql server management studio support whole ssis process workflow ensured data recovery maintenance data integrity space requirements physical database monitored performance optimized sql queries maximum efficiency responsible creating modifying tsql stored procedures triggers validating integrity data created indexed views appropriate indexes reduce running time complex queries keep track data manipulations using audit functionalities generated custom parameterized reports using ssrs reorganized database structures needed automated procedures regular intervals optimized long running stored procedures queries effective data retrieval optimized sql queries improved performance availability monitored strategies processes procedures ensure data integrity optimized reduced data redundancy maintained required level security production test databases wells fargo sql developer tester greenwich 032013 042014 participated developing logical model implementing requirements sql server 2008 created database reporting team solved various tsql issues using query analyzer created managed schema objects tables views indexes procedures triggers created ad hoc tsql queries created backup restore operations created database triggers implement business requirements created complex stored procedures functions support frontend application optimized sql queries improved performance availability monitored strategies processes procedures ensure data integrity optimized reduced data redundancy maintained required level security production test database databases ensured data recovery maintenance data integrity space requirements physical database reorganized database structures needed automated procedures regular intervals optimized long running stored procedures queries effective data retrieval created configuration tables stored procedure user defined function sql server management studio support whole ssis process workflow worked dba maintain referential integrity defining table column level options primaryforeign keys cascade delete column constraints applicable datamart tables excellent tsql development skills write complex queries involving multiple tables great ability develop maintain stored procedures triggers user defined functions cognizant sql developer city state 042012 022013 participated developing logical model implementing requirements sql server 2008 created database reporting team optimized sql queries improved performance availability monitored strategies processes procedures ensure data integrity optimized reduced data redundancy maintained required level security production test databases designed developed database based requirements carried developers role ms sql server 2008 ms access databases using dts data transformation service transactsql stored procedures views involved migration sql server 7 sql server 2008 using upgrade advisor installed configured sql server 2008 created logins users maintenance plans managing use disk space memory connections database involved assisting qa team deploying testing application uses sql server database involved creation stored procedures triggers using tsql according requirement projects involved performance tuning optimizing sql server application using performance monitor