jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom summary 6 years professional experience information technology field sqlbi developer ms sql server20142016201720122008r22008 environment covering various domains excellent writing tsql queries creating clustered nonclustered index data cleansing data migration using alter build objects ability assign different types keys preferred data types experienced installing upgrading configuring microsoft sql server databases hands experience database normalization denormalization optimization tuning backup migration conversion document processing using data modeling tools experienced creating subqueries joins complex queries involving multiple tables exception handlers confident operators variables wildcards views triggers tsql clear cut idea data warehouse dimensional modeling olap oltp rdbms schemas proficient creating dynamic packages incremental loads data cleansing data warehouse using ssis involve phase sdlc create detail analysisdesign document source target mapping develop datastage jobs etl load collection data multiple source different destination required business transformation experience maintaining batch logging error logging event handlers configuring connection managers using ssis extracted transformed loaded data various heterogeneous data sources destinations like access excel csv flat files using connectors tasks transformations provided ssis accomplished creating packages scheduling job sending alerts using sql mail ability build data marts cube analysis tool ssas easy build deploy analytic solutions decision support systems ability measure edit compare business data different queries good experience kpi key performance indicators areas extensive experience capacity planning disaster recovery troubleshooting backup restore procedures experience application systems understanding data resides source system effectively create olap structures support reporting excellent experience developing drill cascading parameterized drill sub reports charts using global variables expressions functions business users experienced visualization tools like power bi tableau experienced creating ad hoc reports complex design query database business intelligence wellorganized goaloriented highly motivated effective team member skills technical skills tools databases sql server 2019201620142012 language tsql reporting tool sql server reporting services ssrs tableau power bi integration tool sql server integration services ssis azure data factory v2 analysis tool sql server analysis services ssas database tools ms sql server enterprise manager sql profiler query analyzer dta tools microsoft office 200320072010 business skills technical skills ms sql server 20122014r220082010 visual studio 20102008 ssasssisssrs microsoft access 20072003 microsoft excel pivot table olap oltp outlook ms sql profiler sql server query analyzer index tuning wizard cnet vbnet share point crystal reports 8910 adonet aspnet frame work 20 mdm oracle db2 dash board crystal report erwin ms access experience 122021 current sqletl developer apex systems waltham worked business analysts understand report requirements interacted end users understand business logics per need created implemented maintained reporting suite 56 standard reports also customizing many reports meet individual client needs developed various operational drillthrough drilldown parameterized reports based reports requirements using ssrs used cascaded parameters generate report two different data sets involved query optimization increase performance report created complex stored procedures generate reports using ssrs designed reports ssrs using shared data source specified data source identified defined datasets report generation defined report layouts formatted reports using global variables expressions deployed subscribe reports using ssrs generate daily weekly monthly reports developed rendered monthly weekly daily reports per requirement gave roles user access respect security report manager performed data extraction transformation loading etl systems using sql tools ssis created ssis packages export import data csv files text files excel spreadsheets used loop loop sequence container execute sql task send mail task package events precedence constraint achieve business requirement designed configurations loggingauditing package error handling data error logging checkpoint ssis package model prepared required documentation system support end users provide enduser training reports analytical solutions provided technical assistance responding inquiries regarding errors problems technical questions train end users technical support staff required interacted weekly meetings manager give status updates projects tools technologies ms sql server 20142008r22008 sql ms excel 20072003 microsoft sql server integration services ssis microsoft sql server reporting services ssrs sql server business intelligence development studio 012018 112021 sql server ssisssrs developeretl developer gavscity state created etl ssis packages design code process data target databases identify resolve problems encountered development release ssis code debugging troubleshooting technical issues implementing applications created complex etl packages using ssis extract data staging tables partitioned tables incremental load created dts packages extracting data flat files excel ms access oracle ms sql server 20162019 created packages ssis error handling worked different methods logging ssis developed maintained monitored importexport data transformation staging production environments experience providing logging error handling using event handler custom logging ssis packages created etl packages different data sources sql server flat files excel source files xml files etc loaded data destination tables performing complex transformations using ssisdts packages used etl implement slowly changing dimension maintain historical data data warehouse responsible deploying scheduling jobs alerting maintaining ssis packages updating maintaining visual source safe created complex stored procedures triggers functions udf indexes tables views tsql code sql joins applications following sql code standards responsible data analysis loading data data feed data warehouse tables performed efficient tuning sql source queries data load usage stored procedures performance created stored procedures transform data worked extensively tsql various needs transformations loading data created views display required information user interface triggers validate consistent data entry database experience report writing using sql server reporting services ssrs creating various types reports like tabular matrix drill drill web reporting customizing url access designed different kinds reports scratch depending upon requirements markets vendors providers scanners documented work process integration reporting services references worked extensively system analysis design development testing implementation projects complete sdlc environment ms sql server 20122008r2 ssrs ssis sql query analyzer sql profiler iis 60enterprise manager windows server 20032008 dts share point portal server html xml c net aspnet visual studio 20052010 ms access crystal reports ms excel 2007 042015 122017 ms bietl developer booz allen 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 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 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 education training bachelors degree