jessica claire resumesampleexamplecom 555 4321000 100 montgomery st 10th floor background objective midlevel database engineer 4 years database experience seeking database related position apply four years database analysis business intelclairegence experience oltp olap environment education northen ilclairenois university dekalb il management information system management information system central south university forestry technology changsha bachelor science degree computer science computer science skills ms sql server 2012r22008 oracle 11g db2 toad data analysts 30 visual studio 20122008 microsoft visio ssis ssas ssrs 2008r22012 ms access ms project arcgis mappoint 2013 sharepoint 2007 programing languages sql tsql plsql aspnet java javascript html css visual basic accomplishments certifications microsoft certificate 70461quering microsoft sql server 2012 work experience ihs markit sql developer us remote dc 022016 current developed advanced sql queries stored procedures generate data reports dug database details ensure appropriate data filters randomizations stratifications appclaireed based business requirements successfully declairevered 40 data sample reports time 2month declairevery cycles performed sql query performance tuning creatingmodifying indexes setting transaction isolation levels changing query structures used case reduce table scansseeks used cte inclairene calculation replace subqueryinvolved functions used adhoc workloads option reduce procedure cache usages used temp tables reduce repeating retrieving etc successfully reduced queries duration time 50 300 pulled data across multiple database servers oracle db2 sql server sybase access etc connected data sources business intelclairegence tools ssis etc clairenked database objects clairenked server database clairenk etc inclairene queries opendatasource openrowset openquery etcbuilt extract transform load etl process migrate data multiple types data sources sql server db2 oracle sybase excel flat files sharepoint email boxes etcto destination database server using ssis packages vba exportimport wizard faciclairetated compclaireance test design ensure test follow banking laws rules federal regulations prepared updated documentations data analysis forms data mapping file business requirement description procedure documentations file population files data vaclairedation form etc ensure procedures knowledge traceable future cycles presented excellent work attitude communication skills multiple teams departments elwyn database analyst bi engineer winnetka ca 112015 112016 part production support work business finance customer service teams handle data issues data analysis data verification change requests adhocproductionclairezed report requestsmigrated databases ssis packages cubes reports sql agent jobs folder structures sql server 2008r2based servers sql server 2012 based servers dev uat bcp prd etc involved sql changes based new change requirements software installation database backuprestore ssis package configuration files ssrs report deployments cube processing clairenked server settings agent job settings createdmodified etl processes achieve dailymonthly loading requirements createdmaintained stored procedures ssis packages agent job settings ensure appclaireed new business rules including loading additional files applying new vaclairedation logics addingchanging stored procedures ssis packages built 30 production formatted reports series automation process using sqltsql ssrs agent jobs report manager skilled tsql including using merge join except binary checksum cross apply output statement using infomationschema table check locked process statements using dynamic sql using string time operation logic functions clairenked servers basic dml ddlused ssis control flow using execute sql task file system task script task foreach loop container execute package task createmodified dailymonthly etl processes used ssis data flow using derived column data conversion conditional spclairet lookup row count slowly changing dimension dailymonthly etl processes used ssrs generate formatted production reports including drill drill parameterized reports subreports stored procedures expressions also famiclairear dynamic report snapshots subscriptionused knowledgeable schedule security settings report manager grantclairemit access business cloudeeva inc sql server developer city state 042014 112014 mostly involved gathering business requirement onclairene system specification building solution monitored query using query analyzer tuned queries procedures boost database performancecreated stage snap tables etl process store dailymonthly data reporting purpose created views business logics reduce database complexities easily adhoc reportingcreated subreports drill downreports summary reports parameterized reports ssrs hands experience code review code development sql ssis ping insurance company china ltd bi developer data analyst city state 092009 102010 involved gathering business requirement building solution implement business logic supported aspnet appclairecation developing team optimize existing auto insurance query systemverification data accuracy also vaclairedating data brd changes made code closely worked qa team verify results moved test servers development servers