jessica claire resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 professional summary 12 years experience role microsoft business intelligence developer microsoft power bi certified data analytics visualization microsoft certified azure security engineer associate business intelligence experience development architecture data quality data integrity data governance datawarehousing client analysis database design reporting presentation using sql server 2008r22012201420162017 excel ssis ssas ssrs sap business objects power bi tableau bl excellent creation support maintenance reports dashboards power bi using dax sql databases ssas tabular model cubes data sources excellent back end skills creating sql objects tables complex stored procedures functions views indexes triggers rules sql performance tuning facilitate efficient data manipulation consistency excellent stake holder management various departments vendors project managers understanding achieving good results based clearly defined goals skills windows 9820002003xpntvista 7810 reporting olap tools ssas ssrs power bi sap business objects tableau sql server management studio ssms sql profiler query analyzer dts designer index tuning wizard sql server business intelligence development studio er studio visual studio 200520082010201220132015201 source control tools visual source safe 2005 team foundation server 2010 ssis dts importexport wizard agile automation business intelligence business objects charts consulting data conversion data modeling dts data warehousing database design data analysis data quality data integrity etl xml indexing loan origination logging word excel powerpoint visio sql data migration olap query optimization performance tuning project management reporting requirement sap power bi sdlc education grambling state university grambling la 2014 bsc biology certifications 1 microsoft power bi certified data analytics visualization 2 microsoft certified professional 3 microsoft certified security engineer associate work history ch robinson worldwide inc bi developer azure iam administrator tucson az 092016 102019 participated development data marts enterprise roll power bi configured conditional access policies azure assess sign risks corporate users participated implementation multifactor authentication newly azure users implemented azure policies keep control types resources could provisioned created alerts action groups azure monitored cpu usage knowledge azure active directory managed service identities obtained power bi certification also trained end users use power bi order reduce dependence department built maintained self service reporting self deployed ssas tabular model cubes leveraged end users built drilldown drill chart graph reports using power bi sap business objects web intelligence tableau identified areas automation could implemented came solutions saved business lots time money participated creation data dictionary used department better understand enterprise data ensure data consistency aided migration etl packages adeptia ssis participated enterprise migration loan origination system implemented security granting users access certain views restricting access certain database tables aided query optimization rewriting complex queries help speed data retrieval process participated projects involved formation joint ventures builders across country work extensively project management office deliver successful roll joint ventures created several data driven subscriptions ran daily send reports end users 50 states premier auto sales report developer city state 072013 092016 performed various data transformations using conditional split data conversion derived columns lookups source data transfer data format per organization needs interacted users extensively gathering requirements analyzing needs end users worked different control flow tasks creating ssis packages especially loop loop containers execute sql script tasks developed maintained microsoft ssis packages including database design etl analysis integrations meet business requirements used ssis create etl packages validate extract transform load data data warehouse databases multiple sources f data created databases tables provide constraints user defined rules defaults involved writing various database objects like user defined functions stored procedures usage indexes accomplishing various tasks created views reduce database complexities optimized performance queries modification tsql queries normalized tables established joins created indexes designed developed data warehouse business intelligence using multidimensional models star schema worked tabular matrix gauges chart reports drill reports well interactive reports according business requirements added parameterized report functionality users drilldown drillthrough features rent loop microsoft business intelligence developer city state 072010 072013 gathered business requirements definition design data source data flows worked managing etl process pulling large volume data oltp staging database using ssis data transformation performed data extraction transformation loading etl systems using sql tools ssis analyzed source data determine data model etl solution meet business requirements designed ssis packages transfer data various sources like text files xml files excel access sql created complex ssis packages using various transformations tasks like sequence containers loop loop containers execute sql package file system conditional split data conversion derived column lookup merge join union flat file source destination ole db source destination excel source destination etc designed complex packages error handling package logging stores logging results sql table flat files error warning task failed event types participated agile iterative development methodology allowed upper management see product sales information frequent delivery product wrote sql queries stored procedures generate data reports generated daily weekly monthly reports managers based product sales reaching certain targeted demographics business goals used ssrs generate subreports drill reports drill reports parameterized reports created dashboards tabular matrix reports crosstab pivot charts graphs per customer requirements using ssrs iping solutions etl developer august city state 052008 072010 formulated documented etl processes based business requirements system specifications including source target mappings transformations lookups aggregations expressions designed ssis packages bring data existing oltp databases new data warehouse peromm performing different kinds transformations like lookup transformations merge joins derived columns merge join conditional split data conversion multiple data flow tasks transferred data various oltp data sources oracle ms access ms excel flat files csv files sql server 2008 r2 created packages ssis error handling well created complex ssis packages using proper control flow data flow elements troubleshooting processes issues errors ssis packages improve performance actively supported business users changed requests designed developed dashboards reports using ssrs weektodate semestertodate yeartodate manage facility reservation requests easier