jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary experience expertise database design etl data warehousing dwh reporting development using ms sql server 2017 2012 ssrs power bi worked phases software development life cycle sdlc collaborated worked business users development staff like business analysts data architects backend solutions developers testers dba application developers understanddetermine requirements time delivering scalability worked extensively tsql building oltpolap databases conceptual logical physical design levels normalizing denormalizing database tables efficient relationships operation analytic er diagrams erwin strong rdbms concepts experience creating maintaining database objects views stored procedures triggers functions indexes constraints wide experience building static dynamic interactive reports dashboards story report templates formatting using bids report builder experienced data cleansing accuracy completeness validation analysis modeling relationship experienced full development cycle dwh including requirements gathering design implementing maintenance experienced etl solutions extract data heterogeneous sources like access excel csv flat files using connectors tasks transformations provided ssis proficient creating dynamic ssis packages incremental loads used change data capture cdc control task makes efficient data loading experienced configuring batch logging error logging event handlers connection managers ssis developed configured deployed monitored ssis packages development testing production parameter environment variables scheduled job sql server agent experienced designing enterprise starschema snowflakes olap cubes experienced database server performance tuning optimization complex sql queries excellent team player technically strong person capability work business users project managers team leads architects thus maintaining healthy environment project diligence helping business unleashing technological power decision making flexible versatile adapt new environment team player flexible work project skills tools technology rdbms sql server 20082008r2201220142016 databaseetl tools ssis reporting sql server reporting services ssrs report builder power bi languages tsql msoffice microsoft office tools operating systems windows server 20122016 experience sqldashboard developer 012021 022022 neogenomics laboratories fresno ca involved creating functional technical specification documents tkd involved requirement gathering client various vendors perform ssrs power bi dashboard data load environments perform data validation production dashboard data troubleshoot etl error production data load designed developed etl pull data source flat files load destination database using multiple transformations unit tested ssis package natively master package deploy ssis package server modified enhanced existing ssrs reports worked olap data warehouse application star schema dimensions developed tsql queries sql scripts data migrationschema change extracted data various sources like sql server excel file perform extensive data analysis created modified database objects like tables dml ddl views stored procedures functions triggers indexes sql based upon functional specifications involved data analysis design session kpi reporting collaborating developers navigate healthcare financial data environment ms sql server 2012 microsoft visual studio 2010 ms excel sqlbi developer 082018 112020 vanderbilt medical centerntt data service city state involved creating functional technical specification documents gathering requirements business created database objects like tables dml ddl views stored procedures functions joins indexes tsql based upon functional specifications developed complex tsql queries sql scripts efficient data load based complex business rules designed complex etl strategies pull data different sources like sql server flat files load destination database using multiple transformations extracted data various sources like sql server flat files xml web services client servers ftp extensively worked developing database objects like stored procedures views indexes triggers functions using tsql performance tuning sql queries developed sql queries using stored procedures common table expressions ctes temporary table support power bi ssrs reports wrote tsql procedures generate dml scripts modified database objects dynamically based inputs scheduling ssis packages using sql server agent services worked oltp olap data warehouse application star schema dimensions extract dataset different data source including sql server excel flat file prepare datasets power bi designed developed reports using report builder easily generate reports user set etl jobs using ssis run daily sql server agent configuring ssis packages using package configuration wizard allow packages run different environments created plsql stored procedures functions packages moving data staging area data mart used sql profiler query analyzer optimize dts package queries stored procedures created ssrs parameterized drill drill sub chart dashboard scheduled reports expressions calculate group filter data xml data sources generated multiple reports sql server database oltp multidimensional data model olap environment ms sql server 2016201420122008 microsoft visual studio 20152010 ms access ms excel ms visio sql server profiler windows server 2008 ms sqletl developer 022016 072018 ford credit city state worked closely smes end usersinternal customers understand projectrequirement scope involved providing solution implement support production issues involved logical physical data models databases prepared test cases existing solution new solutions validate solution met requirements created stored procedures triggers functions indexes tables views sql joins tsql code implement business rules used cte temporary tables user defined table types performed tsql tuning optimization queries reports take longer execution time using ms sql profiler index tuning wizard sql query analyzer extracted data heterogeneous sources transformed processed data using ssis scheduled jobs ssis packages run monthlyweeklydaily feeds created ssis packages load data data warehouse using various ssis tasks like execute sql task bulk insert task data flow task file system task send mail task active script task xml task various transformations deployed various types ssis transforms packages including slowly changing dimension aggregate fuzzy lookup conditional split row count derived column etc used tfs source code management developed codesversion control migrated ssis 2012 version 2014 used custom created dll transfer files using sftp connection debug c net code troubleshoot production issues created unit test methods validation codes developed created alertslog entries successfully completed failed jobs environment sql server 2008r220122014 bids visual studio 20102013 tsql ms access ms excel ssis ssrs ssas windows server 2008r2 education training bachelor science bba computer information system 122015 middle tennessee state university murfreesboro tn