jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary 3 years experience primary skills analysis design development support clientserver application using microsoft sql server 2016 2014 2012 bi suite good experience developing business intelligence solutions sql server reporting services ssrs sql server integration services ssis exposer sql server analysis service experienced building data integration workflow solutions extract transform load etl solutions using sql server integration service ssis good knowledge performance tuning query optimization clientserver connectivity database consistency checks using dbcc utilities good knowledge writing modifying implementing tables stored procedures functions views indexes triggers cursors joins user defined data types good creating different types ssrs reports crosstab conditional drilldown drillup drillthrough top n summary form lists sub reports matrix reports formatting good writing mdx queries extensive experience creating customizing cubes using sql server analysis services ssas 201220142016 good migration data excel flat file oracle ms sql server using ms sql server dts ssis good familiarity logical data modeling data warehouse design concepts dimensional modeling using star snowflake schemas normalized denormalized schemas respect query analysis requirements excellent communication interpersonal skills strong ability skills windows linux tsql plsql c enterprise manager sql profiler ssms ssrs ssis ssas tableau desktop tableau server power bi crystal reports sql server 201220142016 oracle ms access sql sql microsoft visio uml git jira tfs work history sql server developer 022020 122020 addus homecare corporation dewitt mi involved gathering business requirement interacting manager development team build solution implement sql server 2014 filtered cleansed dirty data legacy system using complex tsql statements staging area implemented various constraints triggers data consistency developed complex stored procedures process prospective customer information balanced processing load front end back end extensively used joins sub queries simplify complex queries involving multiple tables developed deployed monitored ssis packages new etl processes upgraded existing dts packages ssis ongoing etl processes used various ssis transformations conditional split derived column used data scrubbing data validation checks staging loading data production tables involved dimensional modeling star schema data warehouse used erwin design business process dimensions measured facts extracted data flat files rdbms databases staging area populated onto data warehouse executed maintained timely accurate report delivery ssrs subscription designed deployed ssrs reports drill drill dropdown menu option parameterized linked reports environment microsoft sql server 2014 ms sql server reporting services ssrs ms sql server integration services ssis team foundation server tfs github ms visio sql server developer 082018 102019 addus homecare corporation dutton mt involved agile methodology analyzing business requirements understanding functional workflow information source systems destination systems completed work sprints responsible stylish design layout like pie charts graphs linked reports created parameterized linked snapshot cached ad hoc click drill drill sub reports top selling equipment company top sales based region sales based season involved development stored procedures functions triggers views implementation complex business logic backend designed high level etl architecture overall data transfer oltp olap help ssis involved writing complex mdx queries per user requirements developed complex stored procedures using tsql generate reports using ssrs 2012 involved creating reports matrix reports parameterized reports using sql server reporting services 2014 2012 analyzed complex queries tune optimize application system performance set sql server configuration settings environment sql server 2012 tsql sql profiler erwin sql server reporting services sql server integration services performance point server 2007 sql server developer 112016 062018 elwyn aston pa documented data flow relationships various entities actively participated gathering user requirement system specification created ssis packages load data oracle sql server successfully migrated data multiple heterogeneoushomogeneous environments sql server 2012 using bcp bulk copy program bulk insert ssis packages built efficient ssis packages processing fact dimension tables complex transforms involved extracting data using ssis oltp olap used etl data flow source files like xml excel databases like ms access oracle created event handlers ssis package error post execute developed custom interface executing managing ssis packages analyzed source data handled efficiently modifying data types used lookup transformation ssis get data reference data sets generated subreports crosstab conditional drill reports drill reports parameterized reports using ssrs 2013 created complex stored procedures triggers cursors tables views sql joins statements applications using sql environment sql server 2012 enterprise edition ssrs 2013 net framework tsql visual studionet ide xml ms excel ms access visual studio education certified sql server tsql microsoft id 4338151 2016 sql school india bachelor commerce 2009 kalimpong college west bengal india