junior sql bi developer robert smith phone 123 456 78 99 email infoqwikresumecom website wwwqwikresumecom linkedin linkedincomqwikresume address 1737 marshville road alabama objective junior sql bi developer two years experience endtoend implementation data warehousing projects including modeling database design development administration applications microsoft sql server handson experience complex stored procedures effective functions constraints querying joins keys indexes appropriate triggers assist efficient data manipulation data consistency skills tsql sql plsql ssis ssas ssrs power bi excel testing requirements gathering work experience junior sql bi developer abc corporation july 2010 december 2011 designed developed ssis packages import export data ms excel sql server flat files create joins subqueries complex queries involving multiple tables responsible creating modifying tsql stored procedurestriggers validating integrity data created indexed views appropriate indexes reduce running time complex queries involved installation configuration sql server 2005 sql server 2008 sql server 2012 latest service packs enhancing performance using optimization techniquesnormalization2nf indexing transaction isolation levels monitoring logs ensure completeness batch processes scripts processes created linked servers connect ole db data sources providers participated designing data warehouse store information oltp staging staging enterprise data warehouse better analysis used basic script task renaming file names storing row count values user variables sql bi developer abc corporation november 2008 june 2010 installed configured sql server 2008 performance monitor track size sql server database transaction logs set alerts notify server transaction log files thus averting problems might otherwise seriously affect users applications created stored procedures triggers functions clientspecific views application extensive testing performance stored procedures optimized sql queries efficiency provided queries procedures frontend application imported exported data various heterogeneous sources using various techniques like bcp dts dummy description data replace job description relevant current role free resume template copyright qwikresumecom usage guidelines