jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary dedicated business intelligence developer 7 years experience identifying problem areas within business data streams designing managing bi analytical solutions turn raw data meaningful data handy experience receiving monitoring data multiple data streams including mssql ssis ssrs data sources profound knowledge industryspecific data transportation retail telecommunication experienced working different environments development uat production technical skills databases tools sql enterprise manager query analyzer sql server management studio business intelligence development studio sql profiler sql server analysis service ssas microsoft azure data warehousing bi sql server business intelligence studio ssis ssrs ssas dts cloud computing services microsoft azure reportingvisualization tools powerbi tableau microsoft visio etl reporting data transformation services export import ssis informatica power center 9x8x ssrs 2017201620122008 crystal reports xix98 excel power bi tableau operating systems windows xpvista windows 781011 vm unix solaris sunos linux others ms office adobe products uiux tools web frameworks version control microsoft tfs git github professional experience sql bi developer 052020 current gep clark nj lehi ut develop complex database objects stored procedures triggers functions udf indexes tables views tsql code sql joins ssis packages ssrs reports gather analyze document business requirements business rules directly working end usersclients create maintain documents documentation roadmaps data models etl execution plans configuration management procedures project plans 10 working pms clarifying business requirements 20 misc work ad hoc work sprints projects extract load sharepoint lists surveys data sql server database sql server integration services create execute scheduled administrative tasks using sql server agent create execute scheduled administrative tasks using sql server agent created ssis packages clean load data data warehouse created packages ssis error handling using event handlers developed tsql scripts validate data loading process modified tested tsql stored procedures sql bi developer sql ssis ssas ssrs power bi 052018 052020 stl truckers city state charles usa created designed database inventory application maintenance safety department saved company 700week labor cost vanishing like company expanse developed measured winloss analysis template identify financial status risks responsible installations configurations operation systems servers connect workers overseas country created database applications utilizing multitier ideas utilization sql statement store procedures fetch update control databases sql server 2012 oracle 11g wrote complex subqueries like correlated nested subqueries aggregate window functions find monthly running total freights products transported frequently year indepth knowledge normalization denormalization database design methodology sql query performance tuning creating modifying clustered nonclustered indexes setting transaction isolation levels well changing complex query structures expert checking rebuilding reorganizing internal external fragmentation sql structured created plenty ssis packages using data flow task execute sql task script task etl projects designed several loop containers loop sequence containers ssis profound knowledge understanding erds database models skilled using synchronous data conversion derived column multicast row count etc asynchronous transformation including sort fuzzy lookup etc perform various transformations ssis package utilized complex udf store procedures views triggers solving different business requirements used dml triggers afterinstead update delete insert maintain referential integrity data assisted data architects building data warehouse entities like fact tables dimensions involved snowflake schemas used breakpoint checkpoints debugtroubleshoot package loading data warehouse performed continuously incremental loads load data oltp environment olap environment built many olap cubes ssas created perspectives finance operational management accounting sales departments using olap cubes wrote complex dax queries ssas generate computed columns according business requirements pushing github deployed many ssis packages ssis catalog scheduled several jobs run ssis packages ssis catalog helped business analysis team preparing documentation data mapping files data analysis forms worked departments management hiring accounting dispatching maintenance safety teams implement rowlevel security policies handson experience creating summary reports adhoc reports using sql server reporting services created ssrs power bi reports sourcing ssas multidimensional olap tabular model cubes mdx dax worked various dax expressions power pivot based business requirements deployed lots custom reports parameterized reports drill drill reports well created numerous subscriptions management sqlssismsbi developer 092015 042018 merchant chimp city state tarzana usa wrote clear well organized efficient transactions sql widely used upperlevel backend sql server programming including various databases relational databases utilized tsql plsql scripts create drop database objects involving tables indexes views primary foreign keys constraints check default null constraints developed tables built relationship parent child tables using primary foreign keys responsible design creating indexes including clustered nonclustered indexes covering filtering complex indexes developed actualized multipletable connections user defined functions using complex joins like cross apply outer apply inner join outer join self join modified properties sql server database performance tuning used event handler troubleshoot errors failures ssis packages different tasks performed extracting transforming load etl pull modify data different sources flat files excel files csv files sql server database implemented various aggregate functions conditional split merge join lookup derived column fuzzy lookup fuzzy grouping dqs data quality services cleansing transformations data cleansing removing empty spaces eliminate data redundancy handson experience azure data factory azure data lakes liaise internal groups customers comprehend product changes affect related reports visualizations highly skilled creating dimensions facts schemas including star schemas snowflake schemas build rocksolid reports userfriendly data visualizations using sql server reporting services powerbi loaded data using analytics engine power pivot skilled building pivot tables charts using power pivot creating calculated columns measures using formulas understanding various types data viewers column chart histogram grid profound experience creating dashboards editing reports using power bi services pinned plenty reports multiple dashboards power bi services skilled generating drilldown reports fixed headers reports using power bi report builder created reports using parameters configured would switch uat production environment power bi added bookmarks slicers report order filter data using power bi created different visualization cards multirow cards kpis order show total revenue total costs total profits managers companies created templates frequently reporting requests improve productivity 70 working tasks given focus work business needs record needed format bachelor science computer science 052014 institute information technology samarkand uzbekistan education