summary jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom microsoft certified professional around 6 years total experience design modelling development implementation support sql server 20222019201620142012 expert analyzing designing developing installing configuring deploying ms sql server suite products business intelligence sql server reporting services sql server analysis services sql server integration services represent api support project teams ensure api knowledge provided thus ensuring effective support new products enhancements experience maintaining one many many one relationship moving data two databases experience using recursive ctes cte temp tables effective ddldml triggers facilitate efficient data manipulation data consistency well support existing applications expertise writing tsql queries dynamicqueries subqueries complex joins generating complex stored procedures triggers userdefined functions views cursors skilled error event handling precedence constraints break points check points logging supported team resolving sql reporting services tsql related issues proficiency creating different types reports crosstab conditional drilldown top n summary form olap sub reports formatting experience using ssis tools like import export wizard package installation ssis package designer experience importingexporting data different sources like oracleaccessexcel etc using ssisdts utility skills technical skills creating api system api design create connections different applications devices operating systems win 2000nt20032008 server rdbms ms sql server 200820052000 ms access oracle8i9i database tools sql query analyzer sql enterprise manager management studio sql server 2005 query editor reporting server experience sql serverssisssrs developer education training msaccess etl tools data transformation services dts ms sql server integration services ssis reporting tools crystal reports xix ms sql server reporting services ssrs data modelling erwin 40 ms visio 50 bi tools ms sql business intelligence business objects 022022 current apex systems addison tx involved designing developing deploying reports ms sql server environment using ssrs ssis business intelligence development studio bids involved creating multiple parameterized stored procedures used reports get data deployed uploaded ssrs reports sharepoint server end users involved enhancements modifications used etl ssis develop jobs extracting cleaning transforming loading data data warehouse created databases schema objects including tables indexes applied constraints connected various applications database written functions stored procedures triggers designed ssis packages transfer data flat files sql server using business intelligence development studio extensively used ssis transformations lookup derived column data conversion aggregate conditional split sql task script task send mail task etc used execution plan sql profiler database engine tuning advisor optimize queries enhance performance databases environment windows 20112010 enterprise sql server 2022201920162014 sql integration servicesssis business intelligence development studio visual studio 201820162014 ole db scoetl developer northwest federal credit union city state 102019 012022 created packages testing cleaning standardized data using tools data flow transformations data conversion export column merge join sort union conditional split existingnew packages huge csv file import different data sources ongoing tasks mapping extensively designed packages data mapping using control flow task sequence container task dataflow task execute sql task data conversion task derived column task script task ssis designer scheduled ssis packages running monthly weekly feeds various guarantors multiple servers resources involved enhancing deploying ssis packages development server production server established etl design practices optimization performance packages parameterized ssis successfully tested task staging stored versions data using team foundation server tfs developed complex reports using multiple data providers user defined objects aggregate aware objects charts synchronized queries responsible performance tuning sql commands use sql profiler database engine tuning wizard installed configured sql server activeactive activepassive clusters monitored scheduled jobs alerts tools technologiessqlserver2016 sql server bi development studio bids 2018tfs oracle 9i 10g clear case clear quest sql lite speed visual source safe tsql autosy ms access windows xp2007 server etosqlbi developer 082016 092019 howard bank city state designed ssis packages transfer data flat files sql server using business intelligence development studio used etl ssis develop jobs extracting cleaning transforming loading data data warehouse worked tsql create tables function stored procedures view subquery correlatedsub query adhock tsql statements designed developed data models using erwin also responsible forward reverse engineering data models modified existing ssis packages meet changes specified users defined report layouts including report parameters wrote queries drill report using ssrs developed conceptual logical physical data models creating schema using ms visio created starsnowflake schema data marts designed created managed primary objects tables triggers indexes based logic design model developed required stored procedures user defined functions formulated documented etl ssis process design based business requirements system specifications strong etlssis design skills including source target mappings transformations look ups aggregations expressions developed ssis packages extract transform load etl data data warehouse created ssis packages using ssis designer export heterogeneous data oledb source excel spreadsheet sql server created databases schema objects including tables indexes applied constraints connected various applications database written functions stored procedures triggers extensively used ssis transformations derived column data conversion aggregate conditional split sql task script task send mail task etc analyse different business requirements provide time estimate analysis design coding implementation developed required stored procedures user defined functions triggers using sql environment sql server enterprise edition ssql server management studio ql server business intelligence studio ssas ssis tsql ssrs bachelor additional information experience etl processes involving migrations sync processes two databases transformed data one server servers using tools like bulk copy program bcp sql server integration services ssis 20052008 experience creating configuration files deploy ssis packages across environments expert generating writing parameterized queries drill reports formatted sql server reports ssrs 200520082008 r2 using data etl loads ssas cubes various heterogeneous data sources defining data warehouse star snow flake schema fact table cubes dimensions measures using sql server analysis services expertise using global variables expressions functions reports immense experience handling sub reports ssrs experienced installing configuring reporting services assigning permissions different levels users ssrs ability handle multiple tasks initiative adaptable selfmotivated organized team player strong problem solving analytical skills total commitment organization goals