jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom summary around 25 years experience including sql server database design implementation testing deployment maintenance experience developing bi solutions enterprise decision support systems using microsoft suite products like ssis ssrs ssas skills sql server 2016sql server 2012 2008 r2 2008 2 years sql server integration services ssis 2 years sql server reporting services ssrs 2 years sql server analysis services ssas 1 year ms access 2 years ms excel 2 years ms word 2 years ms outlook 2 years ms powerpoint 2 years sql server management studio 2 years visual studio 2013 2010 2008 2 years windows 7 2 years windows xp 2 years windows 8 2 yearshtml5 2 years xml 2 years css3 2 years basesas technical skills accomplishments experience 072014 062015 sql bi developer gep experience full software development life cycle sdlc experience buildingoptimizing cubes sql queries experience analysis services ssas reporting services ssrs including database development deployment configuration security troubleshooting skillful analyzing business workflows transforming requirements uml diagrams using visio good knowledge oltp olap data martwarehouse modelling star snowflake schema patterns per normalization rules using erwin exceptional sql scripting debugging skills including ddl dml dcl tcl ssms toad skilled tuning sql server performance using tools like index tuning wizard sql profiler database engine tuning advisor experience creating dynamic etl workflow canvas validating importing exporting data excel xml flat files sql servers ms access using ssis experience installing configuring upgrading sql server versions experience configuring linked servers monitoring troubleshooting migrating sql servers experience performing backup point time restoration fail clusters mirroring replications log shipping hands experience creating scheduling rendering visually rich intuitive data insights using ssrs tableau experience software configuration management using tools like vss tfvc github experience creating integrating technical design documents ms sharepoint application willing put effort improve outcome making sure assigned sprint tasks done timely manner despite time pressure long hours willing relocate anywhere usa authorized work employer usa choice transportation order routing system accessible transportation vendors drivers corporate office built transporting clinicians five boroughs new york project aimed migration sql server 2005 2012 filtering procurement data per destination schema rules migration provide fields support bi reporting lined rrd responsibilities analyze brd documents turn proposed database using erwin ms visio extensively used ddl dml tcl statements defining accessing manipulating transactional systems created file groups stored procedures table valued functions triggers views using base tables indexes constraints joins grouping sets window functions set pivot operators configured linked servers access multiple sql server oracle instances used sql profiler index tuning wizard performance monitor better execution plans sql queries developed ssis packages data validations loadings oltp file systems hive using block unblock transformations developed incremental loading packages using change data capture cdc slowly changing dimension scd scheduled deployed ssis packages using sql server agent event handlers worked isolation levels transactional queries prevent dirty reads nonrepeatable reads phantom reads deadlocks worked isolation levels transactional queries prevent dirty reads nonrepeatable reads phantom reads deadlocks worked toad access oracle databases using plsql procedures created behavior pattern dashboards came effective demographic stories using charts graphs gauge esri maps created paginated reports drilldown drillthrough cascaded parameters analyzing past performance specified business regions created indexes increased performance daily run reports almost 20 responsible technical design documentation tdd schema etl package bi report development closed logged defects using tfs updates ticket owner configured versions sql queries using github involved daily standup meetings knowledge transfer sessions 052013 062014 jr sql bi developer cinergy techmatics pvt ltd city india voterite web application developed create means politicians candidates party leaders establishing campaigns seeking support gaining votes within constituency connects educated social savvy across social networking sites review leaders responsibility used erwin tool understand database design developed database specific file groups extensively worked querying debugging sql scripts including base tables stored procedures table valued functions triggers views generated preformatted excel flat files csv tab pipe delimiters marketing team using ssis worked transactional queries using isolation levels trycatch blocks error notifications extracted transformed loaded data sql server file systems using bcp bulk insert utilities loop containers look conditional split derived column aggregate transformations etc developed scheduled ssis packages incremental data loads using slowly changing dimension scd event handlers troubleshoot debugged performance tuned ssis packages using sql profiler trace log files implemented applicable joins clustered nonclustered indexes better query execution plans created macros pivot tables v h lookups ms excel generated daily roaster files tuned sql server performance using sql profiler index tuning wizard database engine tuning advisor created sql server agent jobs monitored scheduled ssis packages created categorical trend analysis visualizations periodic financial region segments using charts graphs gauge maps ssrs developed ssrs canned reports customer segmentation based size organization gross income parameters filters drill drill table calculations performed database mirroring backups differential full recoveries sql server 2012 tracked closed bug tickets per priority severity using tfs responsible technical design documentation data flows bi reports developed integrated sharepoint server education training may 2016 masters statistical analytics texas university kingsville statistical analytics may 2013 bachelors information technology jawaharlal nehru technological university andhra pradesh information technology skills backup bi canvas charts configuration management css3 databases database database development database design dcl debugging dml documentation drivers erwin esri etl xml financial graphs html5 macros marketing meetings access ms access ms excel excel office ms outlook ms powerpoint sharepoint windows 7 windows 8 window windows xp ms word migration networking olap oracle plsql pivot tables procurement rendering reporting routing sas scheduling sdlc servers scripting scripts shipping software development sql sql server stories tableau tables tcl toad transportation trend troubleshoot troubleshooting uml upgrading utilities visio visual studio workflow additional information additional information authorized work employer willing relocate anywhere us