summary skills jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom 7 years experience database design development sql server 2016201420122008r2 large scale databases strong experience using microsoft sql server management studio ssms sql server integration service ssis sql server reporting service ssrs technical expert design handson programming diverse technology platforms including rdbms etl extract transform load engines bi dashboards kpi scorecards experience logical modeling using dimensional modeling techniques star schema snowflake schema experienced working agile environment scrum development framework complete understanding software development life cycle sdlc including requirement analysis requirement gathering design development imp implementation testing deployment experience professional extensive work experience developing biedw applications using microsoft sql server versions 20142019 experience designing implementing maintaining database schema entity relationship diagrams data modeling constraints rules defaults complex tsql statements expertise creating tables views indexes sql joins complex stored procedures userdefined functions udf common table expressions ctes providing efficient data retrieval triggers facilitate efficient data manipulation maintain data consistency experience table normalization query optimization performance tuning using sql profiler estimated query plans integration migration unstructured data various types sources excel xml flat filecsv ole db json ssis good experience creating complex ssis etl packages using various tasks transformations control flow data flow implemented various error handling event handling techniques ensure efficient package execution proficient developing dashboards including drill drill reports using expressions functions parameterized reports sub reports ad hoc reports table matrix reports interactive reports various chart reports using ssrs deployed configured reports report server experience report server report manager experience microsoft power bi desktop gather information multiple sources sql server azure sql database excel csv json deliver information end user experience building statistical kpi reporting dashboards predictive analysis experienced standard sdlc methodology agilescrum waterfall training development azure sql business intelligence ssis ssas power bi ssrs report manager report builder data modeling microsoft visual studio planning organizing flexible schedule sql server reporting services ssrs sql server integration services ssis dbms rdbms mssql server oracle ibm db2 sql plsql ms access critical thinking office tools ms word excel powerpoint visio onenote microsoft project sharepoint portal server active directory ad methodology agile waterfall etl sql server integration services ssis reporting service ssrs data warehouse star schema snowflake schema requirements gathering analysis modeling agile methodologies experience sql data warehouse developer 122021 112022 apex systems sunnyvale ca design develop complex etl packages using ssis according needs requirements client maintained ssis packages production test environment incoming source application files deployment ssis packages sql entities various environments github engaged offering production support related ssis sql trivial insurance billing related issues resolving closing assigned incidents time avoid sla breaches troubleshoot issues related packaging debugging performance configuration sql query optimization performance tuning optimizing stored procedures longrunning queries using indexing strategies queryoptimization techniques understand functional side business requirements work offshore team accomplish development tasks required experienced building cubes dimensions different architectures data sources business intelligence writing mdx scripting experienced creating complex ssis packages using proper control data flow elements error handling provided wide range valueadded services including implementation training operational management services health care data analysis transaction processing employer health centers thirdparty administrator services employerbased health plans designed developed ssis packages move data various sources destination flat files databases troubleshoot previous ssis packages solve issues performance tuning existing scripts processes coordinate qa team testing support get deliverables completed time knowledge management sharing new teams board create troubleshoot manage deploy ssrs reports create subscriptions customers required designed entity relationship er models logical data ldm physical data pdm models based design documents extensively worked full software development life cycle sdlc project database design modeling implementation maintenance scossisetl data warehouse developer ihs markit us remote mn 062018 122021 created ssis packages using various control flow dataflow tasks extract data multiple sources like excel xml json oltp consolidate staging tables maintained ssis packages production test environment incoming source application files debugged systems fixed program malfunctions quickly designed implemented maintained database schema er diagrams data modeling tables stored procedures functions triggers constraints indexes schemas implemented different slowly changing dimension methodologies merge statements maintain update data corresponding dimension tables data warehouse generated reports maintained dimensional well relational data structures managed operational data store data warehouse monitored ssis package validation error handling optimization deployment scheduling jobs alerting using sql server agent worked multidimensional modelling development using ssdt gather requirements business stakeholders inform design database solutions develop maintain tsql stored procedures performancetune problem queries aid analysts optimization techniques reading execution plans adding indexes rearchitecting poorly designed queries work directly data analysts assess needs build data warehousing models service users deliver data products using agile workflow methodologies documented data warehouse architecture guarantee capacity met current forecasted needs prepared functional technical documentation data warehouses designed implemented maintained database schemas entity relationship diagrams data modeling tables store procedures functions triggers constraints indexes schemas functions views complex sql statements sql query optimization performance tuning optimizing stored procedures longrunning queries using indexing strategies queryoptimization techniques create parameterized reports drill drill reports using ssrs held accountable creating dashboards tabular matrix reports crosstab pivot charts graphs per customer requirements using ssrs troubleshoot data integrity issues tsql code defects ssis ssrs errors varying complexity address required partner business analysts developers assigned line business project requirements definition documentation new customer reportsdashboards oversee maintenance development existing reports served collaborative team member within project management software development life cycles sdlc including analysis business functions design development testing documentation required endusers scossis developer commercial bank ethiopia gondar city state 102014 122017 created new database objects like procedures functions packages triggers indexes views using tsql development production environment sql server 2000 actively participated gathering requirements system specifications developed sql queries fetch complex data different tables remote databases using joins database links formatted results reports kept logs worked complex tsql statements implemented various codes functions installed authored managed reports using sql server 2005 reporting services wrote transact sql utilities generate table insert update statements developed optimized database structures stored procedures ddl triggers userdefined functions implemented new tsql features added sql server 2005 error handling try catch statement common table expression cte created stored procedures transform data worked extensively tsql various needs transformations loading data environment sql server tsql net extensively involved gathering requirements holding meetings users constructed context diagrams dataflow diagrams based description business process analyzing data model identification heterogeneous data sources constructed extended entityrelationship diagram based narrative description business scenario created transformations using sql script modify data loading tables migrated sql server 2005 databases sql server 2008 performed daily tasks including backup restore using sql server 2005 tools like sql server management studio sql server profiler sql server agent database engine tuning advisor sco developer 092013 102014 ethiopian revenue customs authority city state revenue customs authority addis abeba ethiopia used tsql develop ddl dml dynamic sql daily used ssdt develop ssis packages maintaining code version repository tfsvsts tortoise svn git created complex etl packages using ssis extract data staging tables partitioned tables incremental load performed tsql ssis ssdt package workflows performance tuning optimization queries reports take longer execution time designed complex database data warehouse system architecture create schemas designed components perform complex codingprogramming debugging testing within data warehouse system documents data warehouse system reviewed data extraction loading cleansing data modeling data warehouses developed deployed monitored ssis packages defined unit testing system integration best practices enhancing developing deploying ssis packages across different environments experience agile software development paradigm eg scrum kanban used ssis create etl packages validate extract transform load data data warehouse data mart databases performed tsql tuning optimization queries reports take longer execution time using ms sql profiler index tuning wizard sql query analyzer ms sql extracted data heterogeneous sources oltp flat files microsoft excel transferred olap using sql server integration services ssis used ssdt develop ssis packages identified data sources created sources target mapping documents used packages sql server integration services ssis maintaining code version repository tfsvsts used various transformations etl packages transferring data oltp source destination using ssis 20082016 developed complex stored procedures used ssis 2008 packages audit information data flow one stage involved full development cycle data warehouse including requirements gathering design implementation maintenance deployed managed reports report manager using ssrs 2012 wrote complex stored procedures views using tsql management studio education training data analytics certification colaberry school data analytics data science bachelor art economics university gondar gondarethiopia 072021 072013