summary jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary microsoft certified professional six years experience database design development implementation microsoft sql server 200520082008r2 development test production environments experience working full software development life cycle sdlc experience developing optimized sql using best practices expertise writing dynamicsql complex stored procedures functions views hands experience performance tuning using execution plans sql profilerand dmvs incorporated complex business logic stored procedures functions reusability experience creating packages jobs sending alerts using sql mail extended stored procedures experience configuring managing linked servers data transfer sql server heterogeneous relational database oracle db2 strong debugging skills ability solve complex problems experience creating updating clustered nonclustered indexes keep sql server performance experience creating updating statistics improve sql server performance indepth knowledge tsql ssrs ssis reporting analytics experience extracting transforming loading etl data excel flat file oracle ms sql server using bcp utility dts ssis services experience creating ssis packages using error handling experience enhancing deploying ssis packages development server production server adept capturing execution errors ssis analysis purposes experience sync processes two databases using ssis experience importingexporting data different sources like oraclexmlexcel etc using ssisdts utility created stored procedure generating reports using sql server reporting services ssrs experienced creating various ssrs reports involving variety features like charts filters subreports multivalued parameters experience administrating created reports assigning permission valid users executing reports experience deploying created reports report server experience developing cubes using sql server analysis services ssas skill summary databases ms sql server 20122008r22008 tsql sql server management studio business intelligence development studio bids sql server agent data transformation services dts sql server integration services ssis sql server reporting services ssrs sql server analysis services ssas plsql programming language c python plsql work experience 102020 current sql developer louisiana state university baton rouge la documentation tools ms office including ms project visio operation systems windows mac unix linux worked requirements analysis physical logical design development using erwin normalization sql server enterprise manager used tools performance monitor query execution plans increase efficiency queries managed scheduled daily jobs relating data transfers backup restore migrated dts packages converted ssis packages sql server 2008 used etl transformations copy columns load data source like oracle db2 flat files destination databases implemented different types replication models including snapshot transactional replications created reports using cascading parameters drillthrough reports sub reports parameterized reports report models ad hoc reports experience generating report models refining enhancing report models deploying report model creating reports report models designed reports using sql server reporting services ssrs excel pivot table based olap cubes make use multiple value selection parameters pick list cascading prompts matrix dynamics reports modified tuned stored procedures triggers views indexes provide best performance analyzed identified implemented user roles assigned relative database access privileges securing access reports authorizing users home level project level managing reporting services roles environment ms sql server 20082012 erwin db2 er studio ms sql integration services ms sql reporting services 2008 ms excel windows server 2007 052019 082021 sql developer louisiana state university baton rouge la gathered business requirement end users involved creating complex stored procedures according business logic also creation rdl reporting worked nested stored procedures functions involved performance tuning existing sql code coded complex customer data related events delinquency bankruptcy collections etc created objects like tables views developed ssis packages load data implemented incremental loading target tablesviews ssis created ssis packages moving data databases involved maintaining errorlogging ssis packages data moved onetomany relationships tables many one relationship tables created jobs alerts using sql server mail agent ssis developed ssis packages stored procedures retrieve accounts various systems like settlements foreclosures transactions mortgage name created mockup data testing reports involved performance tuning table valued functions responsible creating reports using ssrs created drill drill cascaded parameterized reports according customer requirement environment microsoft sql server 2008 tsql sql server integration services sql server reporting services microsoft team foundation server 022017 042019 sql developer louisiana state university baton rouge la designed normalized database created different objects like tables views stored procedures udfs indexes rules defaults ms sql server involved installing migrating legacy database ms sql server 2008r2 research team members came high level design impact analysis document several solutions problem implementation proposed new system created several ssis package import flat files csv data tables packages scheduled regular time interval extensively used ssis importexport wizard performing etl operations created sql server reports using ssrs exported excel format managers qa team easy validation applied various data transformations like lookup sort multitasking conditional split derived column perform data validation checks filtered bad data used sequence container execute sql task send mail task precedence constraint script task achieve business requirement control flow responsible adhoc reporting modification regenerating request building scorecards dashboards using performance point services 2010 bi application schedule reports run daily weekly monthly also automatically emailed reports department directors analyst review environment ms sql server 2008r2 ssrsssasssis point services 2010 microsoft office 2010 tsql windows 7 education bachelor science cs university washington