summary skills jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom 6 years experience designing developing maintaining business intelligence bi database applications using ms sql server 2019 2016 2014 2012 development test production environments experience installation configuration sql server database engine bi components necessary security considerations experience creating maintaining stored procedures functions cte indexes tables views triggers database objects using tsql experience performing tsql tuning optimization queries etl packages ssrs reports take longer execution time using ms sql profiler index tuning wizard sql query analyzer ms sql server reporting services power bi ssrs report gathered translated business requirements built insightful reporting solutions using power bi created power bi reports dashboards using different types slicers visualizations like bar charts line charts graphs pie charts etc make attractive explore data variety ways across multiple visualizations used dax function compute calculated columns measures implemented row level security rls role restrict users report datasets troubleshoot power bi reports identifying poorly performing measures relationships visuals proficient microsoft sql server ability write complex queries generate stored procedures develop complex ssrs reports modified existing reports per requirements per end users requests needed designed maintained supported operational reports dashboards charts kpibased scorecards using microsoft bi tools like ssrs report builder proficient designing developing drilldown drillthrough subreport using different data regions like tabular matrix charts using visual studio andor report builder experience deploying reports report server using report manager sql server data tools ssdt created configured standard datadriven report subscriptions render reports end users troubleshot maintained ssrs reports modified existing reports per requirements per end users requests needed data integration services etlssis proficient sql server integration services ssis design etl packages extract data various data sources csv excel xml databases sql server database transform load data staging database data warehouse experience creating packages variety transformations slowly changing dimensions lookup aggregate derived column fuzzy lookup data conversion experience providing logging error handling using event handler custom logging ssis packages created configured sql agent jobs alerts scheduled ssis packages prepared documentation etl processes involved maintaining database future reference experience designing building star schema enterprise data warehouse data marts using kimball data warehouse methodology handson experience designing developing populating dimension fact tables data warehouse designed develop ssis packages extracting data different sources csv excel txt databases transferring loading enterprise data warehouse experienced designing building different types dimensions roleplaying slowly changing confirmed etc jessica wellorganized highly motivated goaloriented creative contributor team environment excellent analytical troubleshooting problemsolving skills delivering projects prior due dates taking advantage knowledge smes achieve project expectations motivation get detailed understanding organizations business business intelligence solutions fit worked agile system development life cycle sdlc methodology project environments good ability quickly grasp master new concepts technologies willing learn new things technical skills databases ms sql server 2019201620142012 bi tools sql server integration services ssis sql server reporting services ssrs sql server management studio ssms sql server data tools ssdt sql profiler operating systems windows xp2007 server 2010server 2012 programming language tsql c reporting tools sql server reporting services ssrs power bi server services data modeling tools er assistant ms sql server database diagram project management tool jira servicenow version control svn tfs git interpersonal skills experience business intelligence ssrspower bi developer education training 122018 current dentaquest city state design develop power bi report dashboard explore data variety ways across multiple visualizations installed configured personal enterprise gateways power bi service created views joining multiple database tables pulling create power bi report resolved inconsistency unexpected null values data quality issues power query editor implemented time intelligence functions power bi report using dax used various data sources sql server db excel etc pull data power bi desktop developed power bi reports provide clear visualizations various marketspecific kpis developed new reports maintained existing reports modified different types reports claim reports enrollment reports others design develop parameterized cascaded ad hoc drill drill summary reports using ssrs modified existing stored procedures embedded report dataset developed stored procedures generate various drilldown drillthrough reports using different data regions tabular matrix bar graph pie chart reports using ssrs worked closely offshore team finding solutions arising problems identify associated store procedures parameters used reports order fix bug smoke created ssis package extract transform load data source systems staging edw created error handling ssis package order handle runtime error used various data transformations conditional split data conversion derived column lookup fuzzy lookup merge oledb command multicast deployed ssis packages msdb scheduled ssis packages incremental load datamart daca integration engineer etlssisssrspower bi developer nih city state 102017 112018 designed developed etl packages extract transform load data various sources data warehouse using sql server integration services created complex ssis packages using various data transformation components conditional split derived column data conversions lookup row count etc maintained log information sql server database track errors record package execution status troubleshoot package failed prepared documentation etl packages better reference make easy troubleshoot modified stored procedure returning incomplete records investigated solved missing data leading etl process fail investigated enhanced performance issues stored procedure took several minutes couple seconds update stored procedure nourish maintain historical data data warehouse wrote complex sql queries stored procedures develop ssrs reports design develop parameterized reports subreports drilldownreports drill summary reports ssrs created dataset using complex sql query tabular chart matrix reports per user requirements modified existing reports per requirements end users requests needed created multiparameterized cascade reports using different kinds data regions matrix created subreports present detailed information summary report developed rendered monthly weekly daily reports per requirement make user access reports quickly respect security report manager design develop power bi report dashboard address business objectives meet report requirements design develop various power bi reports using different types visualizations instance tabular matrix dona chart bar charts line charts graphs pie charts etc created calculated tables summarize data using dax applied hierarchies report visuals based report requirements implemented row level security role restrict dataset users see data pertaining based report requirements jucior etlssis developer ahmed elephant insurance city state 112016 092017 used sql server integration services ssis extract transform load etl data data warehouse different sources like csv excel txt database sources sql server database gathered business requirements actuarial claims accounting database marketing departments new projects designed develop etlssis packages stored procedures load dimension fact tables created master etl package call child etl packages deployed msdb integration services server worked failures performance issues jobs assigned team lead used etl implement slowly changing dimension transformation maintain historical data data warehouse designed new dimensions facts worked redesign existing dimensions enterprise data warehouse environment designed developed etl packages extract transform load data olap database using sql server integration services created etl packages used analysis services processing task process cube ssdt designed develop fact dimension tables olap system using tsql created ssis package file transfer one location using ftp task created etl packages ssis error handling worked different methods logging ssis used sql server agent schedule etl package executions troubleshot job failures prepared documentation etl packages future reference ba degree business management jimma university activities sqlpass honors 012007