jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary wellorganized goaloriented highly motivated effective team member excellent analytical troubleshooting problem solving skills rdbmsdatabases ms sql server 2017201420122008 msaccess 972007 languages tsql visual basic 60 html c c visual studio 20132012 ms sharepoint ms team foundation server tfs rdbms sql operating systems windows server 2008xp2000nt9895 ms dos 62 modeling tools microsoft visio 2003 erwin 3x skills reporting tools sql server reporting services ssrs crystal reports 810 integration services sql server integration services ssis data transformation services dts database tools ms sql server enterprise manager sql profiler query analyzer oltp olap database engine tuning advisor dta internet tools internet information server iis 5060 ftp tcpip experience sr sqletl developer 032021 current tiaa cref city state created ssis packages migrate data different data sources data warehouse successfully extracted transformed load data data warehouse 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 scheduled ssis packages running monthly weekly feeds various guarantors multiple servers resources involved enhancing deploying ssis packages development server production server responsible performance tuning sql commands use sql profiler database engine tuning advisor installed configured sql server activeactive activepassive clusters monitored scheduled jobs alerts designed developed etl solutions transformation data source transactional systems data feeds dimensional database destinations created scheduled generated optimized etl jobs createdupdated stored procedures triggers functions cursor views indexes extensive use tsql created documented implemented unit test plans scripts test cases created maintained technical documentation using defined technical documentation templates contributed creation solid coding techniques recommended reviewed coding standards evaluated database performance performed maintenance duties tuning backup restoration disaster recovery data wrote documentation data warehouse artifacts data lineage etl tools environment ms sql server 20122008r2200820052000 visual studio 20102008 ssasssisssrs microsoft access 20072003 microsoft excel pivot table olap oltp outlook ms sql profiler sql server query analyzer index tuning wizard c crystal reports 8910 frame work 20 c dash board crystal report erwin87335 windows 20072010 advanced server professional window xp ms access sql ssrsetl developer 072018022021 cigna health benefits city state created etl packages validate extract transform load data data warehouse databases data mart databases developed ssis templates used develop ssis packages worked development implementation support etl processes largescale data warehouses using ssis dts created ssis process design architecting flow data various sources target involved extracting data using ssis oltp olap responsible deploying scheduling jobs alerting maintaining ssis packages developed sql queries fetch complex data different tables remote databases using joins database links formatted results reports kept logs created ssis packages retrieve data legacy sources retrieve user data flat files monthly weekly basis responsible data analysis loading data data feed data warehouse tables used techniques like backups restore replication standby databases ensure higher availability production environment performed database transfers queries tuneup integrity verification data cleansing analysis interpretation developed monitored dynamically deployed ssis packages dev test production environments responsible maintaining cubes using ssas populate cubes data created tabular matrix reports charts graphs per customer requirements using ssrs good understanding ssrs report authoring report management report delivery report security created reports analysis services cube data source using ssrs 20052008 involved designing physical database models sql server rdbms using dmlddl implementing constraints extensively used tsql manipulate architect produce results users filtered inaccurate data legacy system using complex tsql statements implemented various constraints triggers data consistency identified tested resolved database performance issues monitoring tuning ensure database optimization created incremental data load task using sql server integration services involved project status report updates creation issue items reviewsupdates technical transformation files timely basis performed efficient tuning sql source queries data load usage stored procedures performance worked transactional replication replicated thousands tables various databases different production server worked development teams design physical databases modification involved migration sql server 2005 sql server 2008 created quick view files updated timely basis database updates developed quick view functions reports business needs environment ms sql server 20162014 ssrs ssas ssis sql query analyzer sql profiler iis 60 oracle 10g 11g enterprise manager erwin data modeler windows server 20032008 dts share point portal server html xml c net aspnet visual studio 2005 ms access crystal reports ms excel 2007 sql server bi developer 032016 062018 humana healthcare city state designed sql ssis packages business intelligence development studio bids extract data various data sources access database excel spreadsheet flat files sql server data analysis reporting using multiple transformations provided ssis data conversion conditional split bulk insert merge union created complex stored procedures triggers functions indexes tables views sql joins tsql code implement business rules created sql server reports using ssrs 2005 manager brokers involved formatted report layout requirement end users generated reports end user requirements using ssrs deployed developed reports server end users expert cleansing data data consistency whether data source single system multiple disparate sources expert merge join transformation take two different inputs merge together comparing set key columns performs different types joins experience event logging resource management log files file file groups security backup recovery designed sql ssis packages business intelligence development studio bids extract data various data sources access database excel spreadsheet flat files sql server 2008 2005 data analysis reporting using multiple transformations provided ssis data conversion conditional split bulk insert merge union scheduled maintained nightly weekly loads data creating corresponding job tasks visual studio supported application development team database issues updates new releases support included deadlock issues best practices structuring sql queries debugging unexpected sql results etc environment ms sql server 2014 sql server reporting services ssrs ms access ms excel ssis tsql oracle enterprise edition oracle enterprise edition tableau desktop power bi visual sourcesafe win 2003 advanced server power education training bachelors degree additional information 6 years experience business intelligence data warehousessisssrs mssql server 2017201420122008r2 database visual studio 2013 ssrs worked phases data warehouse development lifecycle gathering requirements design implementation testing support data warehouse data mart entities building dw ground demonstrated expertise utilizing etl tools including sql server integration services ssis data transformation services dts data stage etl package design rdbm systems like sql servers 20122014 work developers dbas systems support personnel elevating automating successful code production good financial health care experience previous projects creating chart reports drill drill reports passing parameters sql server reporting services ssrs expertise data extraction transforming loading etl using sql server integration services ssis worked tableau development dashboards publishing reports 90 93 tableau server extensive knowledge tuning sql queries improving query performance proficient creating index views complex stored procedures appropriate functions effective experienced implementation strong referential integrity auditing use triggers sql scripts expert creating traditional well webbased interactive reports using ssrs indepth knowledge transactsql ddl dml experience optimizing database creating various clustered nonclustered indexes expert creating chart reports drill drill reports passing parameters sql server reporting services ssrs experienced converting excel crystal reports ssrs reports migrate crystal reports higher versions expert database normalization optimization tuning backuprestore data importexport troubleshooting database objects authorization experience creating jobs alerts sql mail agent scheduled ssis packages rdbms experience including sql programming data analysis data verification validation knowledgeable planning implementing ms sql server security dba database permissions selfmotivated possess ability critical thinking analysis good interpersonal communication skills