jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary 7 years experience full life cycle bi design building supporting extensive experience ms sql server 20082005 suite products like ssis ssrs ssas participated phases sdlc starting analysis delivery application development projects also supported enhancements maintenance existing applications worked extensively tsql creating database database objects like tables stored procedures views triggers rules defaults user defined data types functions managed multiple projects simultaneously high efficiency proactive team player capability handling responsibilities independently skills software sql server 20082012 integration services sql server 20082012 reporting servicessql server 20082012 analysis services microsoft office 2010ms visioer studio tools sql server management studio business intelligence development studio source control subversion svn team foundation services tfs pvcs version manager work history 022014 current sr sql serverms bi developer servicetitan atlanta ga project responsibilities worked subject matter experts project team identify define collate document communicate data migration requirements finalized requirements document sign business users performed source system data analysis order manage source target data mapping created numerous simple complex queries using joins correlated sub queries common table expressions ctes business requirements created ssis packages dealing different data sources sql server flat files excel loaded data target data sources performing different kinds transformations using business intelligence development studio scheduled jobs execute ssis packages developed update database objects daily maintained nightly loads data creating corresponding tasks enabled package configuration package parameters ensure package execution another server developed ssis templates shall used develop ssis packages dynamically deployed dev test production environments designed developed reconciliation exception reports using ssrs resolved record count reconciliation issues quickly experience deploying scheduling reports using ssrs generate daily weekly monthly quarterly reports including current status tracked resolved critical ticket request made business users provided 247 production support production database also code deployed production environment 062013 112013 sr sql serverms bi developer first care health plans city state project responsibilities involved gathering requirements business users team lead dbas technical manager fully understand requirements system sql scripting using microsoft sql server management studio 2008 research update add delete information records within tables using select update insert delete statements join group order clauses implemented indexes clustered index nonclustered index covering index appropriately data structures achieve faster data retrieval experience creating ssis packages using execute sql task execute package task various tasks error handling log particular event logging worked package configuration applied various data transformations like merge aggregate sort multicasting conditional split derived column designed developed different type reports including drill reports sub reports drill reports based business requirement using ssrs 082011 052013 sql server ms bi developer blue cross blue shield city state project responsibilities captured business information needs stakeholders translated requirements functional specifications worked dbcc dcl ddl dml scripts established relationships tables using primary keys foreign keys created database objects like tables indexed views indexes storedprocedures triggers cursors using ddl dml statements developed stored procedures generate various drillthrough reports parameterized reports tabular reports matrix reports using ssrs used making current future business decisions involved scheduling jobs address batch process issues debug code maintenance bug fixes created ssis package extract transform load etl data different sources destination target like data warehouse flat file excel ole db using sql server integration services 092010 072011 sql developer herguan university city project responsibilities involved requirement gathering creating requirement technical document created database objects tables views stored procedures using tsql university application developed ssis packages etl load data excel flat files sql server tables created user requested reports using ssrs 062008 022010 sql servermsbi developer education 2011 sashi infotech city state india project responsibilities analyzed business requirements build logical data models describe data relationships data designed implemented stored procedures triggers automating tasks created ssis packages gathering integrating data several sources application database created ssrs reports call sql stored procedures initiate database updates job calls based actions taken report user enabling ssrs reports function interface sql database modified created existing ssis packages meet changes specified users provided backend support functional testing performance tests master science computer science herguan university calfornia 2008 bachelor science computer science jntu hyderabad