jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom career overview know takes elevate institution next level sql skills learnt helped accomplish completion important projects different companies worked addition creative passion sql developer professional since started career assure organization glad allow form part professional team skills databases ms sql server 20122008r220082005 sql server tools sql server management studio ssrs operating systems unix red hat linux enterprise 5 windows tools utilities languages ms visual studio 2005200810 ms office ms ms sql plsql object oriented sql ms access netezza aginity benchwork ssisetl ssas windows active directory 2003xp7881 mac os x visio agile methodology programming java python accomplishments presented thesis report efficiency multi query optimization advance database systems graduate project designed agent based intrusion detection system using signature method automatically detect intrusion data transfer one network another developed online shopping website relevance c language course work work experience sql developer 052016 072016 servicetitan glendale az project name traffic kpi key performance indicators worked business analysts clients gathering requirements translating technical specifications documentation created tables views indexes based requirements created data mart reporting solution basing various fact dimension tables analysis purposes using sql server integration services ssis 20122008 created jobs procedure run monthly reports newly developed datamart solution weekly basis according business requirements wrote complex sql queries retrieve information databases depending requirement created ssis packages maintaining existing code running ssis batch jobs meet daily requirements using ssis ms sql server 2008 developing technical specifications like solutions able leverage cross multiple platforms extracted data oracle flat files transformed implemented required business logic loaded target data warehouse using ssis sql server 2012 created error performance reports ssis packages stored procedures triggers created ssis packages get data different sources consolidate merge one single source created package configuration using environment variables involved setting implementation ms sql 2012 reporting server project environment ms sql server 20122008r2 dts mdx sql server management studio ssis ssrs sql server business intelligence development studiobids tsqlmsaccess sql server query analyzer sql developer 112015 052016 servicetitan columbus oh project name information delivery platform idp ccar comprehensive capital analysis review bmo harris bank financial online application reporting backbone platform financials online provides single location storing calculating analyzing reporting global equity compensation system follows regulations issued financial accounting standards board fasb whose primary purpose develop generally accepted accounting principles gaap within united states reporting platform another backbone using ms sql server ssrs corporate clients bmo business team plan administrators use reporting platform daytoday reporting requirements designing databases developing business intelligence analysis implementation reporting microsoft sql server 200520082008r22012 use extract transform load etl using sql server integration services ssis packages integrating data using oledb connection varied sources using multiple transformation secluding data conversion conditional split bulk insert merge union creating simple parameterized dynamic reports complex reports including tabular reports matrix reports charts graphs subreports using ssrs business intelligence development studio bidsdata tools creating ssis packages uploading different formats files databases sql server data warehouse using sql server integration services create data flow diagrams data mapping source stage stage target mapping documents indicating source tables columns data types transformations required business rules applied plan define design data based business requirements provide documentation create new database objects like procedures functions packages triggers indexes using tsql development production environment sql server migrating data one environment another use sql server integration services ssis reporting services ssrs performance tuning sql programming troubleshooting ssisdts package configuration ssrs project environment ms sql server 20122008 mdx ssrs 20122008 ssis 20122008 ssas 20122008ssms team foundation server tsql plsql oracle 11g access excel shell scripting hp alm netezza codegen programmer analyst intern 022015 112015 pge corporation morgan hill ca use sql server integration services ssis reporting services ssrs use extract transform load etl using sql server integration services ssis packages integrating data using oledb connection varied sources using multiple transformation secluding data conversion conditional split bulk insert merge union create data flow diagrams data mapping source stage stage target mapping documents indicating source tables columns data types transformations required business rules applied create tables views indexes based requirements performance tuning sql programming troubleshooting ssisdts package configuration ssrs creating ssis packages uploading different formats files databases sql server data warehouse using sql server integration services migrating data one environment another masters computer science dec 2014 southern illinois university carbondale il education training computer science 334 bachelor technology computer science may 2012 aryabhata institute technology science hyderabad computer science