robert smith sql server bi developer ii phone 123 456 78 99 email infoqwikresumecom website wwwqwikresumecom linkedin linkedincomqwikresume address 1737 marshville road alabama summary sql server bi developer ii 16 years experience finance domain experience ms sql server sql server 2012 parallel data warehouse worked extensively integration services ssis reporting services ssrs analysis services ssas skills bi business intelligence database ms sql server sql work experience sql server bi developer ii first national bank september 2011 february 2018 involved planning defining designing data based business requirements provided documentation designed data mapping documents ddl scripts data dictionary metadata models maintained developed sql scripts indexes complex queries data analysis extraction writing tsql script dynamic sql complex store procurers function triggers created functions stored procedures database triggers userdefined function used ssis tsql stored procedures transfer data source staging area finally load data warehouse created ssis packages extract data oltp transformed olap systems scheduled jobs call packages stored procedures sql server bi developer abc corp 20022011 used various ssis tasks conditional split derived column used data scrubbing data validation checks staging loading data data warehouse experience creating jobs alerts sql server mail agent schedule ssis packages worked quest sql compare table data compare dev test test prod environment created cubes support specific analysis conducted upper management cube included materialized views well fact arranged topic worked optimizing performance queries modification tsql queries stored procedures functions removed unnecessary columns eliminated redundant inconsistent data normalized tables established joins created indexes extensively performed data processes data mappings data dictionaries data pulls reporting solutions dummy description data replace job description relevant current role case dont need delete education bsc computer science 2002 addis ababa university free resume template copyright qwikresumecom usage guidelines