jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary 8 years experience industry experience data analysis design implementation administration business intelligence oltp olap etl data warehousing data mining dbms data modeling msbi tools sql server 20122008r220082005 ssis ssrsssassdlc experience software development life cycle analysis design development testing maintenance using waterfall agile methodologies skillful etl operations data store concepts olap architecture good knowledge power bi power bi pro power bi mobile power bi reporting visualizations power bi dashboards rich look good hands azure data factory moving data kusto db azure sql db help confidential flowsused azure downloadupdated tasks knowledge microsoft azure azure data factory storage azure ml azure data lake analytics expert writing complex tsql ddl dml new features like cte ranking functions topn pivot xml path sql physical logical database design performance tuning creating views constraints triggers joins cursors temp table table variable functions batch scripts numerous stored procedure consumed various stages migration cleansing process reports data validation expert creating packages dtsssis transfer data oracle ms access flat files sql server using tools like bulk insert task bcp ssis developing reports ssas understanding ssas experience report writing using ssrs creating various types reports like drill drill parameterized cascading conditional table matrix chart sub reports experience maintain report manager report server ssrs good knowledge data modelling oltp systems star schema snowflake multidimensional modelling expert developing dashboard report parameterized reports linked reports sub reports region year quarter month week strengths commitment work position excel innovate flexibility selfdetermination excellent communicator good listener planner adorable team player skills databases confidential sql server 200520082008 r22012 oracle 8i9i oracle 10g91 db2 postgre ms access nosql databaseshbase database tools ms sql server 200520082008 r22012 ms access sql server integration services ssis data transformation servicesdts sql server reporting servicesssrs development skills tsql plsql ssisssrs sql plus power bi languages vbnet pythonlinux unix java etl tools dts ssis sql server integration services informatica comos kettle work history 022020 current senior bi developer reporting packages sql server reporting services ms excel toolsmethodologies ms project sql profiler toad tfs 2010 agile jira waterfall cloud technologies aws azure adf v1 adf v2 operating systems windows xp windows 7 windows 8 win 200320082008 r2 american medical association newport beach ca developed power bi model used financial reporting p l headcount designed documented entire architecture power bi poc expertise writing complex dax functions power bi power pivot automated power query refresh using power shell script windows task scheduler used various sources pull data power bi sql server sap bw oracle sql azure etc installed configured enterprise gateway personal gateway power bi service created workspace content packs business users view developed reports scheduled automatic refresh scheduling refresh power bi service wrote calculated columns measures querys power bi desktop show good data analysis techniques weekly presentation business users reports changes required worked kind reports yearly quarterly monthly daily worked types transformations available power bi query editor created stored procedures sql queries pull data power pivot model participated project planning sessions project managers business analysts team members analyze business requirements outline proposed solution database creation ddl dml dcl database tuning sql tuning performance planning extensively used joins subqueries simplify complex queries involving multiple tables developed tabular queries efficient analysis report using pivotun pivot tsql transformed complex business logic database design maintaining using sql objects like stored procedures user defined functions views tsql scripting jobs creating modifying tables stored procedures views indexes userdefined functions triggers required created jobs performance report queries system tables track duration job weeklyaverage duration using ssrs designed created data extracts supporting ssrs power bi tableau visualization tools reporting applications creating data blending case merging two different datasets using tableau created datasets tsql stored procedures ssrs developed excel powerview powerquery powerpivot dashboards data analysis developed confidential proprietary analytical tools reports confidential excel power pivot power point performed index analysis tables came efficient solutions use clustered non clustered indexes significant performance boost using index tuning wizard created ssis packages import data access excel xml ole db source flat files filtered bad data using derived column lookups fuzzy lookups conditional split designed ssis packages import transform data databases external data sources using various transformations like data conversion file system task row counts ole db source ole db destination ole db command merge join look sort data flow task designed created data extracts supporting ssrs power bi tableau visualization tools reporting applications debugging ssis packages performance tuning slowly running ssis packages configure maintain using report manager report server ssrs deployed scheduled reports report manager created reports using charts gauges tables matrix created parameterized report dashboard report linked report sub report year quarter month week created drill reports drill report region 032016 122019 bi developer expeditors international washington inc el paso tx gathered business requirements definition design data sourcing data flows data quality analysis working conjunction data warehouse architect development logical data models designed created data extracts supporting ssrs power bi tableau visualization tools reporting applications expertise creating visualizations reports using power bi dashboards created logical physical data models using erwin new requirements discussion technical team application users designed implemented complex ssis package migrate data multiple data sources data analyzing deploying dynamic configuring ssis packages created olap cubes dimensions analysis specific areas using ssas developed maintained combined data store reporting purposes generated reports using global variables expressions functions using ms sql server reporting services 2008 identified database tables defining queries defined datasets report generation defined report layouts including report parameters wrote queries drill reports using ssrs 2008 generated daily weekly monthly reports managers administered interface organize reports data sources schedule report execution delivery track reporting history using ssrs 2008 designed high level etl architecture overall data transfer oltpolap help ssis extensively used performance monitor sql profiler solve dead lockslong running queries tested reports fixed bugs stored procedures responsible performance tuning sql commands troubleshooting technical problems ms sql server 2008 use query analyzer database engine tuning wizard established backup recovery ms sql server 2005 using sql server agent jobs periodic backups backup devices database maintenance plans recovery environment ms sql server 2008 ssas 2008 ssrs 2008 ssis 2008 tsql visual studio 2008 dts data analyzer ms access word excel sql profiler windows xp erwin v42 version one 012014 022016 etl developer abt associates new york ny highly responsible data transformation various formats companys format weekly basis managed external client project contracts technical consultation delivery projects involved planning defining designing database based business requirements provided documentation developed logical physical data models schemas using erwin installed ms sql server 2008r2 management tools using sql server setup program coordinated dba creating managing tables indexes triggers db links privileges designed created reviewed primary objects views indexes based logical design models user requirements physical constraints helped designed kind production sales reports sales procurement departments using ssrs responsible optimizing indexes sql queries stored procedures improve quality software designed ssis packages transfer data flat files sql server using business intelligence development studio generated periodic reports based statistical analysis data using sql server reporting service ssrs extensively used ssis transformations lookup merge derived column data conversion conditional split aggregate creating ssis etl solution responsible creating cubes dimensions using ms sql server analysis services ssas created business critical kpis using ms sql server analysis services ssas representing aggregations several different ways hierarchically using custom groupings company use analyze performance calculated measures dimension members using mdx mathematical formulas user defined functions used transformations union merge breakpoints ssis generated etl packages tasks daily using sql server agent jobs scheduling also manually configured used types container tasks loop loop sequence container ssis designed developed deployed reports ms sql server environment using ssrs 2008r2 generated subreports drill reports drill reports parameterized reports using ssrs different regional sales head monthly quarterly report created reports retrieve data using stored procedures accept parameters used sql server profiler auditing analyzing events occurred particular time horizon stored script education 092011 052009 certifications certificates master science gaziantep university gaziantep turkey bachelor science inonu university malatya turkey microsoft analyzing data microsoft power bi certificate oracle certified associate oca java se 8 programmer