jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 experience summary three years progressive work experience specifically designing developing bi solutions data visualizations sql etl packages business analyst proven experience developing tableau power bi dashboards scorecards bi solutions provided visibility senior leadership business achieving better service quality workforce management business process optimizations ficient constructing tables normalization de normalization techniques database tables creating using stored procedures views user defined functions subqueries joins complex queries involving several tables triggers experience sql server installation configuration creating logins database users experience creating managing fragmentation indexes achieve better query performance performance tuning query optimization working knowledge reporting services ssrs integration services ssis analysis services ssas good understanding sdlc software development life cycle processes principles excellent work ethic ability learn new skills fast able adapt change fast self motivated able handle multiple priorities excellent time management skills excellent communication facilitation skills ability gain consensus across multiple teams proven team players hands experience sql server management studio ssms great knowledge data marts data warehousing operational data store ods dimensional data modeling star schema modeling snowflake modeling hands experience ssis package development deployment scheduling expert creating data visualizations dashboards parameterized reports drill reports interactive reports using sql server reporting service experienced working agile projects multiple sprints cycles scrum meetings skills ability multitask attention detail proactive results oriented tsql coding c programming language microsoft excel microsoft powerpoint microsoft word ssrs ssis tableau power bi relational database management system etl ssisssrs deploying interpersonal communication skills troubleshooting performance tuning education university california riverside riverside ca 062019 bachelor arts political science experience neogenomics laboratories sqlbi developer fort myers fl 092018 current troubleshooting resolving complex production performance issues performance tuning long running queries code reviewing creating managing stored procedures indexed views user defined functions triggers database constraints meet business requirements policies restoring recovering corrupted databases configure manage database links data sources performing database refresh production staging servers regular ondemand basis performing standard db security administrations creating logins users roles assigning permanent also temporary permission reviewing sql codes ssis packages providing recommendations better query performance restoring recovering corrupted databases deployment ssis packages conversion server create schedule sql server agent jobs automate run ssis packages weekly basis environment windows server 2012r2 2008r2 2003r2 sql server 2016201420122008r2 ssrs ssis tsql visual studio powerbi postgresq sql azure internet brands inc database developer intern new york ny 062018 082018 administered supported monitored databases proactively resolving database issues maintaining servers provided data support seiu local unions campaigns programs utilized tableau software create visualizations annual reports composed data different regions modified existing databases meet unique needs goals determined initial evaluation planning process planned implemented security measures safeguard vital business data generated tableau dashboards quick filters parameters handle views efficiently worked managers prepare requirements gathering quality documents work environment ssis 201220142016 sql server 20142016 tsql xml microsoft project ssrs microsoft excel servicenow tableau riverside downtown partnership rdp bidatabase developer intern city state 012018 062018 facilitated meetings board directors business owners plan events mission rdp implemented bi solution framework endtoend business intelligence projects monitored social media online sources industry trends loaded data mssql database tables excel mysql access databases sql server 20142016 staging dbs using ssis importexport ssis etl packages wrote optimized sql statements assist business intelligence practices wrote tsql scripts validate correct inconsistent data staging database loading data database converted various sql statements stored procedures thereby reducing number database accesses created indexes constraints rules database objects designed developed ms sql server stored procedures using tsql statements scratch developed triggers views populate base tables environment ms sql serve 201220142016 tsql query analyzer sql profiler ssrs ssis windows server 2012 ms visio ms bi district office dbasql developer intern city state 102017 012018 improved performance ssrs reports tuning stored procedures tsql queries using various join conditions performed performance esting stored procedures indexes triggers developed reports constituent events different purposes using ssrs report builder created databases database objects like tables stored procedures views triggers rules defaults user defined data types functions use custom scripts help automate routine tasks maintain operators alerts notifications jobs job steps schedules developed database backup scripts automated processtasks using sql server agent service composed correspondence assisted administrative tasks environment ms sql server 201220142016 tsql query analyzer sql profiler windows server 2012 ms visio ms bissrs ssis visual studio powerbi