jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary 5 years experience database development administration data analysis system analysis design development support ms sql server 2014 2012 2008 production testing development experience software development life cycle sdlc agilescrum project management methodologies extensively involved software development life cycle sdlc initial planning implementation projects proficient writing complex tsql stored procedure constructing tables triggers user functions views indexes relational data models data integrity sql joins writing sub queries well versed data modeling data mapping table normalization performance tuning optimization sql scripts sql queries expertise creating managing package configurations logging system package deployment userdefined variables ssis packages experience error handling debugging packages using checkpoints data viewers breakpoints event handlers loggings ssis custom loggings expertise merging data various heterogeneous sources populating dimension fact tables data warehouses data marts cleaning standardizing data loaded oltp olap databases using ssis hands experience performing various ssis data transformation tasks like lookup fuzzy lookup conditional splits event handlers strong knowledge designing extraction transforming loading etl data flows using creating mappingsworkflows extract data sql server data migration transformation oracleaccessexcel sheets using sql server ssis experience dts migration metadata management migrating dts packages package migration wizard storage management using ssis sql server integration services expert creating various types reports like complex drill reports drill reports matrix reports sub reports charts using sql server reporting services ssrs based relational olap databases solid experience working offshoreonshore model good knowledge ssas create cubes using data data martsdata warehouse deeper faster data analysis experience cubes construction based data volumes mostly adhering star schema using strong knowledge data warehousing star schema fact dimension tables hands experience publishing power bi reports dashboards power bi server scheduling dataset refresh upcoming data power bi server excellent communication skills capability form maintain positive productive working environment individual team player skills operating systems windows 20082000200398 advanced server windows xp10 databases ms sql server 20172016 2014 2008 r2 2008 oracle mysql msaccess reporting tools sql server reporting services ssrs power bi crystal reports sql server analysis services ssas etldatabase tools tsql sql server management studio ssms sql server integration services ssis web technologies html xml javascript vbscript css software tools sql profiler ms officeexcel ms project sharepoint ms visio c microsoft team foundation server ad ms access sdlc agile c selfmotivated analytical skills msexcel servers approach excel scripts automate mail script bi ms office software development business objects msoffice sorting change management ms project ms sql server crystal reports sharepoint sql css windows sql server data conversion 2000 tables data entry 98 team player dts windows xp tsql data warehouse mysql tsql databases enterprise user interface database navigation validation designing olap vbscript documentation operating systems view etl optimization visio xml oracle microsoft visual studio features developer visual studio html oracle sql db2 problem solving javascript coding logging realtime meetings reporting access requirements gathering msaccess scrum work history msbi developer 102018 current cognizant technology solutions corinth ms optimized performance queries removing unnecessary columns eliminated redundant inconsistent data normalized tables established joins created clusterednonclustered indexes wherever necessary created triggers functions indexes tables views sql joins tsql code implement business rules involved performance tuning query optimization using sql profiler resolved deadlocks issues databases servers realtime basis worked business analysts identify design implement solutions extraction integration data databases data marts purposes data extraction reporting using ssrs migrated sql server databases latest version 2014 sql server 2005 integrated data homogeneous heterogeneous sources legacy systems sql db2 excel sources sql server database generated performancebased reports using ssrs managers show holdings various measures like time area price range created triggers functions indexes tables views sql joins tsql code implement business rules used ssis tsql stored procedures transfer data oltp databases staging area finally transfer data warehouse created scripts components write customer functions dataflow used data grids display data customized way created sql server integration service ssis packages enterprise databases thirdparty data source transfer data migrated data heterogeneous data sources legacy system db2 access excel centralized sql server databases designed developed modified enhanced database structures database objects worked point contact offshore team india updated existing business objects universes requested users new requirements add new universe classes objects new database entities attributes environment sql server 2014 sql server integration services ssis sql server reporting services ssrs sql server analysis services ssas power bi microsoft visual studio 2010 sharepoint c ssis developer 022017 102018 cognizant technology solutions cumming ga involved complete software development life cycle sdlc including system study interaction users management designing coding testing deployment system worked sql developer write complex queries like stored procedures triggers functions indexes tables views sql code sql joins applications creating table indexes constraints ensure data integrity enhance query processing actively involved requirements gatheringanalysis meetings business provide description analysis approach created request change rfc change management request cmr moving database tech changes development testing production sprints created developed sql server jobs sql server integration services ssis packages automate execution packages time depending requirements also used ssis move data text files sql server created logging etl load package level task level log number records processed package task package using ssis designed etl packages dealing different data sources sql server flat files xmls etc loaded data target data sources performing different kinds transformations using sql server integration services ssis exclusively used ssis control flow items loop execute packagesql tasks script task send mail task ssis data flow items conditional split data conversion fuzzy lookup fuzzy grouping pivot worked extensively ssis etl process ensuring proper implementation event handlers loggings checkpoints transactions package configurations created ssis packages transforming data warehouse mart import data source systems transfer data one server another designed dailyweeklymonthly ssrs reports utilizing multiple types reports including sub reports drill throughdrill cascading parameterized reports created cube structure analysis business condition creation report using ssas generated drill drill reports drop menu option sorting data defining subtotals power bi used power view power map visualize reports power bi used microsoft power bi extract data external sources modify data certain format required excel created ssis packages load excel sheets pc database coordinated attended every day standupsscrumagile meetings weekly sprint meetings evaluate completed work worked efficiently agile methodology microsoft team foundation server tfs environment sql server 2014 visual studio2010 ssas ssis sql power bi tfs ms sql server 20052008 msoffice ms excel sqletl developer 052015 012017 apex systems elgin il involved preparation documentation requirements enhancements reports design develop ssis packages store procedures configuration files tables views functions implement best practices maintain optimal performance successfully migrated data heterogeneous sources like flat file excel source oracle sql server using ssis hands experience working extraction transformation loading etl process pulling large volume data various data sources using ssis build efficient ssis packages processing fact dimension tables complex transforms developed ssis templates used develop ssis packages way dynamically deployed test production environments extensively used ssis transformations lookup derived column data conversion aggregate conditional split sql task script task send mail task etc created ssis packages copy tables schemas views extract data excel oracle created cross validation rules ensure mapping accuracy created packages ssis error handling worked different methods logging ssis created maintained scheduled various reports ssrs like adhoc reports canned reports master reports parameterized reports using sql server reporting services ssrs generated multiple enterprise reports using ssrs sql server database oltp sql server analysis services database olap included various reporting features group drilldowns drill subreports navigation reports hyperlink etc implemented triggers checking complex business conditions providing security tables created views facilitate easy user interface implementation triggers facilitate consistent data entry database ability handle multiple tasks initiative adaptable selfmotivated organized team player strong problem solving analytical skills total commitment organization goals environment sql server 2008r22012 ssis etl ssrs ssas dts olap ms access trello windows sharepoint ms visio education mba 2008 tribhuvan university