jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 professional summary vk 9 years extensive work experience sql server developer depth proficient experience microsoft business intelligence stack oltp operational data source ods tabular multidimensional modeling performance tuning data warehouse olap database technologies demonstrated expertise designing developing deploying business intelligence solutions using ssis ssrs ssas bids experience installation upgrade configuration microsoft sql server databases 5 years extensive experience tsql programming developing stored procedures views triggers user defined functions cursors derived tables common table expressions ctes xml complex queries sql server 2005200820122014 broad experience query optimization performance tuning tsql stored procedures functions ssis packages ssrs reports etc 3 years strong experience ssrs development skills experience including tablix matrix chart graphic scorecard reports performance summary dashboards subre reports experience creating adhoc reporting ready universes using ready universes using business objects universe designer good understanding tableau architecture development end user experience application clusters specializing tuning monitoring high availability oracle sql server 4 years experience utilizing etl tools including ssis dts etl package design experience maintenance administration ssis creating jobs alerts sql mail agent schedule dts ssis packages scheduler autosys sql server agent 3 years experience ssas sql server analysis services 2005200820122014 good experience designing implementing mdx queries olap architecture molap rolap holap experience development coding vbnet c working ssis interaction users business analysts better understanding business reporting requirements education jntu india bachelor science computer science skills sql server tools enterprise manager sql profiler query analyzer sql server management studio dts ssis ssrs ssas database ms sql server2014 2012 2008r2 2008 2005 oracle sap siebel microsoft office 20072003 msaccess language c xml tsql vbnet c mdx dax amil operating system windows xpnt 200020032008 dos tools applications erwin data modeler ms visio business objects xi 3130 cognos crystal reports 10 microsoft office 20032007 tableau server 82 power pivot 2010 sharepoint 2010 excel services 2010 landesk architecture relational dbms clientserver architecture olap molap rolap holap oltp work history transamerica ssissql server developer city state 2015 current transamerica multinational life insurance pensions asset management company transamericas businesses focus life insurance pensions savings asset management products group also active accident supplemental health insurance general insurance limited banking activities transamerica major operations united states responsibilities working data migration project called ecb environmental control board migrate ticket finder data adabase db2 ms access sql server assisted database design extensive data analysis 3 source systems implemented etl architecture support migration created etl extraction strategy architecture part development plan extract load data source systems staging ecb destination servers used etl ssis develop jobs extracting cleaning transforming loading data target tables worked extensively complete data mapping source systems part data analysis extensively used ssis transformations script component pivotunpivot multicast derived column data conversion row count send mail task etc experience ssis script task look transformations data flow tasks using tsql visual basic basic vb scripts experience ssis performance tuning using counters error handling event handling running failed ssis packages using checkpoints scripting vbnet ssis improved performance packages configuring component properties like maxconcurrentexecutables default buffer size engine threads delay validation etc worked data archival process transferring data crossing different platforms validating data transferring archived data files different dbms creating dynamic ssis packages worked application developers provide necessary sql scripts using tsql involved production support tlc application generated reports based case counts hearing decisions etc per users requirements used execution plan sql profiler database engine tuning advisor optimize queries enhance performance databases interfaced business analysts developers technical support determine best requirement specifications siemens healthcare ssisssrs lead developer city state 2014 102014 siemens healthcare provides sustainable healthcare technology solutions engineered improve patient outcomes reducing costs across complete portfolio imaging therapy systems laboratory diagnostics healthcare responsibilities stored retrieved manipulated data close analysis system capabilities pricewaterhouse coopers sql serverbi technical lead developer city state 2013 112013 pwc focuses audit assurance tax consulting services additionally us pwc concentrates 16 key industries provides targeted services include limited human resources deals forensics consulting services help resolve complex issues identify opportunities responsibilities interfaced business analysts developers technical support determine best requirement specifications frontier communications sql server developer ssis developer city state 062010 112012 worked different types source systems like sap clarity siebel efrontoffice matched measures edw stored sql server database using ssis prepared technical documentation every stored procedure updated stored procedures new data elements designed developed type 2 slowly changing dimensions inorder maintain historical changes business purposes worked existing legacy ssis packages modified packages match different sources integration created ssis reusable packages extract data multi formatted flat files excel xml files ul database db2 billing systems used 3rd party tools like upsert task modified replaced complex legacy system package structure newer elements used onpostexecute error event handlers update task logging ssis log table used script task component established iterative load faster retrieval improve performance used different transformations like lookup condition split row count transformation derived column data conversion etc created stored procedures package initialization end package information update package log table created package configuration file connection information source staging destination databases send mail task connection information log directory path value verizon sql server developerssisssrs city state 2007 052010 verizon built operates nations reliable wireless network verizon largest number retail customers industry profitable wireless company us company joint venture verizon communications vodafone responsibilities