jessica claire resumesampleexamplecom 555 4321000 100 montgomery st 10th floor summary 8 years experience data design development microsoft sql server 2019201620122008r22005 tsql performance tuning troubleshooting ssisdts packages ssrs datawarehousing experience using business intelligence tools ssis ssrs ssas ms sql server 2019 201620122008 extensive experience tsql constructing triggers tables implementing stored procedures functions views user profiles data dictionaries data integrity extensive knowledge normalization relational database management systems good understanding database data warehousing concepts oltp olap hands experience various sql server services like integration services ssis reporting services ssrs analysis services ssas great ability create manage various database objects like tables views excellent tsql development skills write complex queries involving multiple tables great ability develop maintain stored procedures triggers user defined functions experience performance tuning query optimization experienced using etl tools ssis ms sql 2016201220082008 r2 dts ms sql 2000 hands experience create views books using cubes experience extracting ting transforming loading etl data excel flat file oracle ms server using bcp utility dts ssis services sql server developed dynamic packages using ssis implemented incremental data loading data loading experience sql server 2008 using ssis etl experience developing packages ssis dts according task data analysis data migration transferring using ssis packages experience logical physical data modeling database design using erwin experience designing building dimensions cubes star schema using sql server analysis services ssas deployed processed ssas cube weekly update information using sql server agent expert creating simple parameterized reports complex reports involving sub reports matrixtabular reports charts graphs using ssrs business intelligence development studio bids experience writing expressions ssrs expert fine tuning reports created many drill drill reports using ssrs experience optimization tools index tuning wizard sql profiler windows performance monitor monitoring tuning ms sql server performance capable forming maintaining positive productive working relationships internal external team environments solid understanding software development life cycle sdlc worked agile environment expertise using tfs open bugs create task user stories initiate change requests used git part tfs source control deploy solutions skills databases sql server 20192016201220082008 r2 sql server 2005 access oracle 819110g mysql data warehouse databas database tools sql server management studio performance monitor query analyzer query optimizer sql profiler data transformation services dts etl bulk insert bcp odbc business intelligence development studio bids sql cmd languages tsql c c pl sql c 40 uml xml ms sharepoint reporting tools power bi sql server reporting services ssrs crystal reports 9085 olap source control tools visual urce source safe vss team foundation server tfs jira operating system windows server 20002003 2008 2008 r2 2010 windows nt 40 windows 7xp9895 ms dos linux education training fairleigh dickinson university teaneck nj master science computer science jawaharlal nehru technological university hyderabad india bachelor science computer science experience furniture mart senior sql bi developer dba davenport ia 112015 current project healthearizona plus hea plus introducing healthearizona plus ahcccs des collaborated develop new system apply ahcccs health insurance kids care nutrition assistance cash assistance benefits connect federal insurance marketplace federal insurance marketplace provides premium tax credits cost sharing reduction programs help many arizonans cost health insurance responsibilities proactively monitored database systems ensure secure services minimum downtime reviewed code written coderstest tsql code written others maintained audited database level security experience database backup restore disaster recovery procedures daily routines like security administration monitoring automated jobs experience sql server migration 2008r2 2012 2012 2016 provided emergency urgent support required business andor application owner ensure availability integrity application data evaluated performance sql server stored procedures functions triggers made recommendations resolve performance issues developed data import ssis cleans processes data monthly keep two enterprise systems sync experience sql server data migration legacy database servers sql server extensively involved design data extraction transformation loading etl control developed several complex ssis packages several data transformation components created complex stored procedures ssis packages converting data developed dynamic packages using ssis implemented incremental data loading scheduling maintaining ssis packages batch jobs thru sql server agent weekly basis implemented error logging using event handlers implemented logging ssis packages identified areas data denormalization proposed methods f normalizing worked team responsible data modelling approving ddl changes merged code validated correct code moving promotion scripts worked developers increase knowledge increase quality code providing guidance schema design efficient tsql index strategies setbased logic etc performance perspective identified database performance improvement opportunities via monitoring analysis database servers dmvs extended events etc proposed multiple enhancements management diagnosed active performance issues production database environments refactored database objects improve performance collaborated across multiple departments make sure everyone communicating clearly moving forward betterment company hands experience microsoft sql server team foundation server tfs visual studio redgate tools sql server 2019 2016 2012 2008 r2 enterprise edition tsql sql server integration services ssis sql server reporting services ssrs windows server 2005 2010 oracle 9i sybase tfs furniture mart sql bi developer north branch mn 052015 102015 spencer stuart global executive search leadership consulting firm firm offers services expertise executive search board services succession planning executive assessment leadership advisory services spencer stuart justifiably famous introduction new method finding placing managers modus operandi firm combine management talent search management consulting responsibilities actively participated interactions users team lead dbas technical manager fully understand requirements system created managed schema objects tables views indexes stored procedures triggers maintained referential integrity created different kinds reports like tabular reports matrix reports subreports drilldown reports adhoc reports etc deployed report manager using ssrs developed complex ssrs reports using multiple data providers global variables expressions user defined objects aggregate aware objects charts synchronized queries created ssis packages error handling populate data various data sources created packages using ssis data extraction flat files excel files oledb sql server server configured ssis packages using package configuration wizard allow packages run different environments envir worked metadata driven ssis packages pull data various sources load datamart created systems capturing error data flatfile using flatfile destination sending error data flat file attached corresponding mail ids using sent mail task correcting error data error data experienced etl data warehouse environment responsible creating jobs ssis etl job scheduled run daily weekly monthly participated issues associated etl data warehouse failure established checkpoints implement restart ability ssis packages created etl packages ssis conducted data migration processes sql server environment using sql server integration services worked project teams migrating ssis packages sql server 2008 sql server 2012 involved finetuning performance query optimization database required application tools sql server 20122008r2 ms sql server reporting services ssrs ms sql server integration services ssis olap team city tortoise svn visual studio 2010 jira ms excel 2007 alight sql bi developer ia state 122014 042015 deloitte risk management system drms tool participating member firms use completing process documenting approving client engagement acceptancecontinuance decisions system used deloitte functions audit ers consulting tax fas within participating member firm drms 45 component deloitte global risk tools dgrt program suite tools drms introduces deloittestandard reporting platform sql server reporting services ssrs current drms solution offers fullfeatured reporting functionality faster efficient deployment reports adhocselfservice reporting responsibilities managing database objects tables indexes views etc creating complex stored procedures tables views sql joins statements applications handling primary second level support problems encountered production processing including hours support working client resolving different bug fixes data migration writing different queries using joins cursors loops maintaining managing sql server development test production environments starting stopping sql server sql server agent services providing oncall sql database operational support users developing maintaining supporting sql applications supporting net developers created different kinds reports like tabular reports matrix reports subreports drill reports etc deployed report manager using sql server reporting services ssrs developed complex ssrs reports using multiple data providers global variables expressions user defined objects aggregate aware objects charts synchronized queries deployed reports created report schedules subscriptions managing securing reports using ssrs built adhoc reports using sql server reporting services ssrs developing different complex ssis packages data extracting using dft merge joins union executive sql tasks script components different source target systems either flat file excel rdbms rdbms installing upgrading configuring microsoft sql server database creating using stored procedures using defined functions triggers subqueries joins complex queries involving multiple tables exception handlers tools windows server 2008 sql server 2012 tsql visual studio 2010 sql builder adonet cnet sql server integration services sql server reporting services shine kreations sql developer city state 012012 082013 shine kreations ecommerce website handles selling products online updates new products website time time customers also controls online delivery system products providing tracking details help local courier companies responsibilities interacted team analysis design developed database using er diagram normalization relational database concept involved design development testing system developed sql server stored procedures tuned sql queries using indexes execution plan developed userdefined functions created views created triggers maintain referential integrity implemented exceptional ptional handling worked client requirement wrote complex sql queries generate crystal reports creating automating regular jobs tuned optimized sql queries using execution plan sql profiler rebuilding indexes tables part performance tuning exercise involved performing database backup recovery worked documentation using ms word tools windows server 2008 r2 sql server 2012