summary skills jessica claire montgomery street san francisco ca 94105555 4321000 resumesampleexamplecom around 4 years experience sql server developer bi developer ssisazure analysis services ssrspower bi worked various business domains like retail banking healthcare experience analysis design development testing implementation data reporting analytic solutions sound knowledge relational multidimensional databases data migration system data integration reporting analytics data management experienced developing implementing documenting maintaining data warehouse extracts transformations etl process various industries like financial health care retail etc extensive professional experience design development implementation support mission critical business intelligence bi applications expert creating using stored procedures views user defined functions good creating subqueries joins complex queries involving multiple tables exception handlers excellent experience creating indexes indexed views observing business rules creating effective functions appropriate triggers assist efficient data manipulation data consistency well experience data extraction transforming loading etl using various tools sql server integration services ssis data transformation services dts used tfs bug tracking bug fixing proficient creating dynamic packages incremental loads data cleaning data warehouse using ssis strong data modeling experience using er diagram dimensional data modeling star schema modeling snowflake modeling using tools like erwin experience providing logging error handling using event handler custom logging ssis packages databases sql server 2012 r22017 oracle 11g azure dw azure analysis services database tools sql server management studio 20122017 sql server data tools development skills tsql plsql ssis ssrs sql plus power bi alteryx tableau microsoft azure languages vbnet c sql plsql html etl tools ssis sql server integration services informatica comos kettle reporting packages sql server reporting services power bi tableau ms excel toolsmethodologies ms project sql profiler toad tfs 2010 agile jira waterfall vbnet logging sql plus microsoft sql server experience sqlssisssrspower bi developer university hospitals city state 012019 current participated full application development lifecycle projects including design development unit testing functional testing deployment ongoing support clinical relationship management business applications running microsoft platform help application store patient data highly confidential encrypted develop requirements specifications coordination database administration team uh university hospitals architects data marts data warehouses support clinical business analytics gather appropriate specifications data collection transformation requirements build report prototypes rapidly accurately writes data retrieval programs import extract transfer load etl data heterogeneous data sources throughout organization support ad hoc reporting designs develops supports selfservice reporting options ie building tabular data models work management strategic planning analysis staff endusers create manage complex workflow rules data validation triggers create automate workflows proactively identifies addresses scalability performance bottlenecks support data volumes create functional technical documentation including asbuilt documents dashboard design specifications operating manuals release notes security requirements reports created maintained update documentation annual basis changes occur utilize ssrs develop various dashboards reports utilize ssis automate report generation configured ssis jobs automate data migration integration create document requirements working together involved development program enhancements changes including program staff programmers strategic planning analysis staff andor outside consultants needed write documentation class designs various architectures used building ssis components assist testing process includes devising test plans establishing protocols configuring appropriate testing environments keep abreast new microsoft features functionality provides recommendations process improvements assist providing technical support end users participate development technical documentation existing future applications perform quality assurance testing reports dashboards facilitate user acceptance testing uat sessions ensure quality reports prior releasing production checking code tfs store procedures views tables schema deployment process production environment designed implemented ssas tabular cube analytic layer used dax scripting access data tabular model support multiple multifaceted development initiatives utilizing microsoft technologies tools microsoft sql server 20122017 tsql sql server integration services 2017ssis sql reporting services 2017 ssrs microsoft azure power bi 2019 alteryx 2019 sql server analysis services 2017 ssas crystals reports 2011 microsoft excel 2016 sscsssrs power bi developer williamssonoma inc city state 082017 122018 installed sql server 2012 development production servers setting databases users roles permissions involved gathering user requirements developed reports using microsoft power bi desktop service mobile developed ssis packages integrating data using ole db connection heterogeneous sources used multiple transformations provided ssis data conversion derived column lookup conditional split bulk insert merge union etc performed error handling ssis using event handling logging developed calculated columns measures using dax power bl improved performance ssis packages using fast load options converting data type source applicable parallel processing using nonblocking semi blocking components blocking components dropping rebuilding indexes ssis package run worked maintenance administration ssis creating jobs alerts sql mail agent schedule ssis packages used tsql queries insert complete file information layout mdf tables experience writing tsql developing complex stored procedures triggers index views user functions sql joins data integrity normalization handson experience working issues relating transactional replication involved designing developing debugging testing reports sql server reporting services ssrs provided visualgraphic analysis based data content developed maintained multiple power bi dashboardsreports content packs monitor database performance analyze issues primarily microsoft sql server 20122014 customized columns tables utilizing named calculations named queries ssas tools microsoft sql server 20122014 tsql agile methodology sql server integration services 2012ssis sql reporting services 2012 ssrs microsoft azure mysql workbench sql server analysis services 2012 ssas crystals reports 2011 microsoft excel 2016 sco server bi developer bank west city state 052016 082017 created ssis package load data flat files sql server 2008r2 sql server 2012 using lookup fuzzy lookup derived columns condition split term extraction aggregate pivot transformation slowly changing dimension used ssis create etl packages validate extract transform load data data warehouse data mart databases modified existing ssis packages meet changes specified users scheduled jobs executing stored ssis packages developed update database daily basis using sql server agent designed developed deployed reports ms sql server environment using ssrs 2012 generated subreports conditional drilldown reports drill reports parameterized reports using ssrs 2012 created reports retrieve data using stored procedures accepts parameters scheduled monthlyweeklydaily reports run automatically onto dashboard responsible monitoring tuning report performance modified numerous reportsstored procedures performing properly slow response time inconsistent results poor format actual report created relationships actions data blending filters parameters hierarchies calculated fields sorting groupings live connections memory tableau excel involved creating views stored procedures custom sql queries import data sql server tableau reviewed sql queries edited inner left right joins tableau desktop connecting livedynamic static datasets analyzing business intelligence reporting requirements translating data sourcing modeling requirements including dimensional normalized data models facts dimensions star schemas snowflake schemas operational data stores etc developed storytelling dashboards tableau desktop published tableau server allowed end users understand data fly usage quick filters demand needed information created various database object like stored procedures functions tables views involved creation extended dimension modeling tables like snowflake obiee configured report viewing security various users various levels using report manager creation database objects like tables views materialized views procedures packages using oracle tools like toad plsql developer sql plus scheduled report exported pdf format finetuned sql queries maximum efficiency performance using sql profiler database engine tuning advisor provided documentation kinds reports ssis packages designed implemented stored procedures triggers automating tasks tools ms sql server 20122008 ssis tsql plsql ssrs bids tableau vss sql profiler database engine tuning advisor dts vb script erwin v73 education master science computer science training northwestern polytechnic university san francisco ca bachelor science electronics communications scsvmv university chennai activities honors additional information websites portfolios profiles 122016 052015 experience configure maintain report manager report server ssrs deployed scheduled reports report manager created relationships actions data blending filters parameters hierarchies calculated fields sorting groupings live connections memory tableau excel integration ssrs reports using various web parts sharepoint various delivery mechanisms experience working version control systems like subversion git extracted transformed loaded data various heterogeneous data sources destinations like access sql server excel csv oracle flat files using connectors tasks transformations provided ssis involved performance tuning tableau dashboards used various sources pull data power bi sql server sap bw oracle sql azure etc created different visualizations stacked bar chart clustered bar chart scatter chart pie chart donut chart line clustered column chart map slicer time brush etc power bi according requirements experience creating jobs sql mail alerts schedule ssis packages using sql server agent involved query optimization performance tuning using execution plans sql profiler index tuning wizard created data source views dimensions measures defined measure group relationships