jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary 8 years experience ms sql server suite products like ssis ssas ssrs ms sql server 2008 2019 experience implementing power bi domo providing companywide training experience implementing business logic using triggers indexes views stored procedure proficient tuning tsql queries improve database performance availability experienced creating reports using sql server reporting services sourcing olap cubes data warehouse database proficient creating designing report layout sorting data defining subtotals generated reports like parameterized reports drill reports using ssrs 2008 2019 expert extracting transforming data etl various heterogeneous sources creating packages using ssis import export data bulk insert bcp utilities expert level experience performing various ssis data transformation tasks like lookups fuzzy lookups conditional splits event handlers error handlers etc experienced formatting sql server reports creating configuration files error handling logging ssis creating jobs alerts sql mail agent strong experience sql database design architecture data modeling using erwin data warehousing analysis skills etl tools dimensional modeling star schema snowflake schema excellent knowledge maintenance existing reports optimizing report performance developed implemented documented ssis packages production server outstanding oral written communication skills skills sql server tools enterprise manager profiler query analyzer ssrs ssis ssas reporting tools ssrs domo power bi crystal reports rdbms ms sql server 2008 2019 ms access programming languages c sql tsql plsql work history 052016 092020 bi developer cognizant technology solutions albany ca automate coding bi project management production deadline management schematics blueprints live nation entertainment global entertainment company formed merger live nations ticketmaster ticketmaster known embracing new technology developing groundbreaking software applications support world renown ticketing platform responsibilities involved planning defining designing data based business requirements provided documentation designed er diagrams mapped data database objects performed normalization database oltp wrote complex stored procedures triggers views constraints rules database objects upgraded ssis 2019 using ssis catalogssisdb created maintained ssrs report scheduler using ssis sql database implemented domo manage entire business single roof connected directly relevant business data place appropriate information users fingertips immediately trained 50 end users across 5 departments use manage domo dataflow datasets developed ssis packages automate different ftps files emailing different clients created ssis packages extract transfer load data data warehouse daily basis generated reports using global expressions functions could used send information different primary vendors clients managers created ssis packages import export data excel spreadsheets text files csv files various direct sources used concepts priority constraints various ssis tasks conditional split derived column look tables validate data dealing ssis createdmodified sql joins subqueries tsql code implement business rules environment ms sql server 20142019 ms sql server reporting service ms sql server analysis services ms sql server integration services tsql ms visio domo 112013 052016 sql server bi developer pep promotions city state pep promotions marketing company handles project management procurement marketing campaigns responsibilities designed er diagrams mapped data database objects performed normalization database oltp created ssis packages extracting data excel mysql transforming loading sql server 2008 implemented power bi provide better reporting dashboard capability responsible extracting data huge database manipulate analyze end users technical analysis functional requirements created tsql queries views stored procedures triggers functions performance optimization designed coding testing new enhanced packages data warehouse developed reports consistent drilldown functionality including drilldown report master detail reports using ssrs developed different kind reports sub reports charts matrix reports linked reports tuned several slow running queries production updated data warehouse continuously existing services created stored procedures complete data scrubbing created views restrict data views reduce complexity used cubes kpis continuously analysis data warehouse performance environment sql server 20082012 ms sql server reporting service 2008 ms sql server integration services 2008 vb c windows server 2008 power bi 122011 102013 ms sql server bi developer state farm city state state farm insurance group insurance financial services companies united stated canada project analysis different accounts services changing time analysis aspects optimizing data warehouse performance monitoring modifying responsibilities designed implemented logical physical data models using visio erwin designed created report templates bar graphs pie charts based financial data developed implemented procedures ensure quality usability accuracy reports upgraded records data warehouse according current analysis checked performance tuning indexing query optimization database performance monitoring tuning analyzed performance foreclosure system help developed database environment ms sql server 2008 ms sql server reporting service 2008 ms sql server analysis services 2008 ms sql server integration services 2008 tsql windows server education bachelors science information system management