jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary proficient gathering business requirements business stakeholders analyzing documenting system requirement specification functional requirement specifications maintaining requirements expertise writing tsql queries dynamic queries subqueries complex joins generating complex stored procedures triggers user defined functions views cursors involved development implementation full suite data warehouse solutions data warehouses data marts cubes etl processes good understanding designing star snowflake data models schema used relational dimensional multidimensional data modeling experience creating deploying ssis packages highactivity normalized transaction systems oltp highly usable denormalized reporting systems olap well staging areas data marts proficient data transformations tasks containers sources destinations like derived column conditional split union merge lookup merge join transformations load data data warehouse drill drill reports dashboard reports proficient requirements analysis designing coding testing deployment maintenance strong ability defining query generating drill reports handling parameterized reports creating stylish report layouts ssrs good knowledge creating developing power bi dashboards reports rich look stunning visualizations knowledge addressing performance issues involved query tuning index tuning sql profiler database related activities ability work pressure simultaneously multiple projects capability working aggressive deadlines sql analytics data extracting patch management software development proficiency tsql coding sql developer 062019 current skills sql development technical analysis performance scalability optimization data management work history aeroflow healthcare baltimore md coordinating business users analyzing business requirements translating technical specifications designed implemented etl processes using ssis involved collection data sources like sql server 20082014 developed deployed ssis packages configuration files schedules job run packages generate data csv files flat files troubleshooting reports issues etl job failures optimizing query performances automated file transfer processes mail notifications using ftp task send mail task packages implemented event handlers error handling ssis packages notified process results various user communities designed built high performance etl packages migrate manipulate data ms excel sql server using ssis extracted data different sources stored data intermediate staging database using ssis etl tool creating managing schema objects tables views indexes referential integrity depending user requirements developed error handling routines packages using script tasks well error handling tab developed ssis packages extract data sql server tables import data excel files used ssrs report manager assign roles permissions create report schedules transferred data various sources like ms excel flat file sql server using ssis created reports using data using ssrs generated weekly monthly quarterly report using sql server reporting services ssrs managers worked end users ensure reports working per business requirements maintained optimized existing databases monitored database performance growth performance tuning generated reports according business requirements using sql server ms bi developer 042017 062019 usa vein clinics flint mi gathered user requirements analyzed designed software solution based requirements developed ssis packages using derived columns condition split aggregate execute sql task data flow task execute package task etc generate underlying data reports export cleaned data excel spreadsheets text file ms access csv files data warehouse performed tsql tuning optimization queries reports take longer execution time using ms sql profiler index tuning wizard sql query analyzer ms sql server 2008r2 performed ssis tasks conditional split derived column etc data scrubbing including data validation checks staging loading data data warehouse used etl implement slowly changing transformation maintain historical data data warehouse involved preparing development deployment guide used sql profiler monitor server performance debug tsql slow running queries set alerts successful unsuccessful completion scheduled jobs extensively involved ssas storage partitions aggregations calculation queries mdx data mining models developing reports using mdx tsql created stylish reports implemented conditional formatting using ssrs 2008 deployed managed reports report manager using ssrs 2008 created error performance reports ssis packages jobs stored procedures triggers generated subreports drilldownreports summary reports parameterized reports ssrs data analystsql developer 032015032017 abc employment city state collected defined translated user requirements project designs implementation plans designed databases ensured stability reliability developed database objects including tables views materialized views using sql maintained complex tsql queries views stored procedures multidatabase environment little supervision coordinated statistical data analysis design information flow created various excel documents assist pulling metrics data presenting give concise understanding best placement needed resources performed system analysis documentation testing implementation user support platform transitions participated requirements meetings data mapping sessions understand business needs bachelors 022012 tribhuvan university kathmandu nepal education