jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary 7 years experience database design development business intelligence ssms ssis ssrs ssas tableaupower bi development test production environments various business domains like health care finance insurance expertise microsoft business intelligence msbi oltp olap using sql server integration services ssis sql server reporting services ssrs etl data warehouse sql server analysis services ssas ms sql server 20082012201420162019 experience creating parameterized reports profound knowledge experience dealing relational database management systems including normalization stored procedures constraints querying joins keys indexes complex views dynamic sql triggers cursors er diagrams working experience creating database objects like tables constraints primary key foreign key unique default views indexes experience developing applications using tsql programming ddl dml dcl experience data analysis sql server database development maintenance data modeling support day day business operations auditing databases user transactions login database actions removing orphan users expertise writing tsql queries complex stored procedures creating triggers cursors userdefined functions joins common table expressions cte expertise extracting transformation loading etl using various tools like exportimport data sql server integration services created developed tested deployed packages production servers creating package configurations advanced creating etl process data warehousing operations data store concepts data marts olap technologies including star snowflake schema expertise writing expressions ssrs expert fine tuning reports created many drill drill reports using ssrs good knowledge fine tuning long running tsql scripts simple ones creating indexes updating statistics experience transforming data using data flow tasks like derived column audit slowly changing dimension data conversion row count merge join lookups union etc experience implementing various ssis features like event handling precedence constraints breakpoints checkpoints logging complex ssis packages experience migration onpremise sql server schemas cloud azure sql server db azure vm developed maintained databases across onpremise cloud deployments experience advanced excel like power view power bi power pivot excel data connection adequate creating changing data visualizations power bi reports dashboards client requests experience use c visual basics net script tasks script components variables ssis excellent analytical interpersonal communication skills fast learner hardworking versatile team player skills technical skills operating systems windows 20122008 r220032000 server windows nt 4035 unixlinux database tools sql enterprise manager query analyzer sql server management studio business intelligence development studio sql profiler sql server analysis service ssas microsoft azure languages tsql plsql mdx dax c vbnet xml aspnet net framework web tools cnet aspnet vbnet visual studionet etl reporting ssdt 2017161412 bids 2008r208 sql server integration services ssis 201716201420122008r2 sql server reporting services ssrs 2016201420122008r2 powerbi sql server analysis services ssas experience 082019 current sqlssisssrs power bi developer blue shield california city state others ms office crystal reports xi visio sql server notification services visual web developer ms frontpage windows scripting host ms visual sasaccess crystal reports sap business objects micro strategy erstudio microsoft tfs microsoft git ms vss hp quality center jira tfspython developed ssis packages using fuzzy lookup fuzzy grouping data cleansing purposes used ssis variables storing values used various components data flow task developed unit test plans ssis packages checking functionality component modified existing ssis packages meet changes specified users extensively used ssis transformations lookup derived column data conversion aggregate conditional split sql task script task send mail task etc developed aggregations partitions calculated members cube per business requirements designed developed deployed reports ms sql server environment using ssrs 2008 worked formatting ssrs reports using global variables expressions created parameterized reports drill drill reports using ssrs scheduled monthlyweeklydaily reports run automatically onto dashboard responsible monitoring tuning report performance configured report viewing security various users various levels using report manager 122016 072019 etlssis developer amerigroup city state created subreports drilldownreports summary reports parameterized reports ssrs performed documentation kinds reports ssis packages developed data standards data exchange xml data standard data sharing model developed ssis packages using lookup transformations merge joins fuzzy lookups derived columns multiple data flow tasks generated daily weekly monthly subscriptions dashboard reports analysis managers end users using ssrs worked redirecting outputs different formats including xml files various data sources involved automating ssis packages using sql server agent jobs windows scheduler thirdparty tools worked several transformations data flow including derivedcolumn script slowly changing dimension lookup data conversion conditionalsplit many worked xml web services control flow task read xml source designed developed various ssis packages etl extract transform data involved scheduling ssis packages developed etl solutions integrating data multiple sources like flat files delimited fixed width excel sql server raw file db2 data warehouse created maintained updated etl packages loading fromto oltp olap database tables created complex etl packages using ssis extract data staging tables partitioned tables incremental load identify analyze interpret trends patterns complex data sets involved planning defining designing data based business requirements provided documentation converted old etl packages new version optimization applying stored procedures instead using control flow tasks 092014 112016 etlsql bi developer keybank city state designed ssis packages andor enhanced existing ssis packages using pivot transformation fuzzy lookup derived columns conditional split aggregate execute sql task data flow task etc extract data disparate sources sql server oracle teradata access excel generate underlying data reports developed tsql query stored procedures functions retrieve data reporting validated daily weekly monthly grain transformed data comparing source system worked internal customers gather analyze business requirements order identify solve problems responsible building report solution like drilldown drillthrough linked reports using ssrs testing quality finally reviewing customer ensure solution meets requirements supported efficient delivery standard adhoc reports emphasis automating possible generated weekly monthly quarterly reports management using different techniques like data filtering adding interactivity deploying reports report server ssrs education training 012012 bachelor accounting audit fergana polytechnic institute