jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary organized detailed etldata warehouse developer proven history supporting complex business intelligence projects collaborative team player ability partner crossfunctionally deliver solutions offering 4 years experience testing troubleshooting databases skills relational databases data warehousing analysis modeling requirements gathering agile methodologies decisionmaking organizational skills microsoft office experience 092018 122020 etldata warehouse developer android industries arlington tx data management troubleshooting package design extract transform load data modeling data analysis scrum gathered business requirements definition design data source data flows develop technical design specifications code specifications meet business requirementsspecifications building maintaining ssis package package configuration etl process package deployment enabling new packages companies framework highly experienced full life cycle methodology implementing olap online analytical processing data warehouses star snow flake schemas business intelligence reporting systems extracting data excel files flat files ole db source xml files json files loading data different destinations within data flow utilized various sources transformations destination manage packages transformations data using ssis tools multicast conditional split derived column data conversions merge join union pivot transformations unpivot transformations lookup etc within control flow utilized data flow task execute task script task enhance package deployment sequence container foreach loop containers maintained configured packages checkpoints breakpoints package logging error logging event handling redirect error rows fix errors ssis strong proficiency use sql developing complex stored procedures triggers tables userdefined functions relational database models data integrity sql joins query writing converted complex business logic sql stored procedures userdefined functions achieve functionality designed developed deployed ssrs reports include parameterized reports snapshot reports cached reports drill reports drill reports linked reports clickthrough reports sub reports troubleshooting regular monitoring timedata driven subscription based ssrs reports ssis external file transfers developed packages using tasks containers transformations like full load incremental load bulk insert aggregate slowly changing dimensions ssis migrated data heterogeneous data sources sql server databases using ssis overcome transformation constraints generated periodic reports based statistical analysis data various time frame division using ssrs created traces using sql server profiler find long running queries modify queries part performance tuning operations 082017 082018 sql developer colaberry inc city state creating efficient ssis packages extract transform load data target databases reviewing current etl packages suggesting improvements efficiency monitoring error logs correcting etl issues uncovered well building processes prevent recurring issues future participation software design discussions enhance performance solution delivery clients engaging account managers clients conference calls better understand business needs implementing long lasting solutions resolve client data processing issues researching account discrepancies writing corrective tsql queries stored procedures correct import export data one server servers using tools like dts bulk copy periodic monitoring system bottlenecks providing 247 support via rotating responsibility model within data management team using etl failures create job aids training purposes soliciting functional requirements account management implementing etl solutions new clients participating daily scrums brainstorming sessions 072016 072017 bissrs developer colaberry inc city state designed developed ssrs dashboards claims adjustment operations optimizing existing data models including changing load scripts load data optimized way achieve reduction loading time simplifying complex expressions frontend improving layout structure working business document develop kpis calculations ssrs extensive experience using tsql developing complex stored procedures triggers tables views user defined functions experience using kinds constraints managing indexes locks troubleshooting deadlocks handling isolation levels identified worked multivalue parameters parameterized reports ssrs scheduled maintained supported distribution access reports server level configured maintained report manager report server ssrs created subreports drilldownreports drill summary reports parameterized reports ssrs developed proof concepts poc various projects using ssrs expert knowledge deploying ssrs dashboards education training 092017 master business studies business management tribhuvan university kathmandu nepal major finance certifications az900 microsoft azure fundamentals microsoft 70463 implementing data warehouse microsoft sql server 20122014