jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary 6 years experience bi solutions using tsql ssrs ssis ssas data modeling database design programming using ddl dml dcl commands various business applications interacted technical team business users perform analysis business requirements transformed technical requirements etl reporting needs experienced installing upgrading configuring microsoft sql server databases experience creating tables views complex stored procedures facilitate efficient data manipulation data integrity sql statements various applications optimized tsql query performance modifications tsql queries removing unnecessary columns establishing necessary joins experience coding tsql using temp tables table variables analyzing business logics generated complex transact sqltsql queries sub queries corelated sub queries dynamic sql queries programming sql server using stored procedures triggers userdefined functions views common table expressions ctes proficient performance tuningquery optimization using indexes tuning performance stored procedures large tsql queries using clustered indexes efficient coding standards excellent experience creating indexes indexed views observing business rules creating effective functions appropriate triggers assist efficient data manipulation data consistency expertise migrating dts packages ssis ssdt well experience data extraction transforming loading etl using sql server integration services ssis 20082008 r220122014 2016 proficient creating dynamic packages incremental loads data cleaning data warehouse using ssis excellent experience maintaining batch logging error logging event handlers configuring various connection managers using ssis extracted transformed loaded data various heterogeneous data sources destinations like access excel csv oracle flat files using connectors tasks transformations provided ssis involved usage various ssis components loop foreach loop fuzzy lookup hands experience event handlers error handlers etc experienced creating master child packages package configurations logging using ssis excellent knowledge using variables expressions packages ssis experience creating jobs alerts sql mail agent scheduling ssis packages excellent experience developing stylish drill cascading parameterized drill sub reports charts using global variables expressions functions business users experience different type reports including tabular forms matrix form conditional drill list items charts sub reports good knowledge design implementation processes deploying upgrading managing archiving extracting data reporting using sql reporting services ssrs 2008 r220122014 involved handling enterprise wide reporting needs using sql reporting services crystal reports good knowledge data marts operational data store ods olap dimensional data modeling fact dimension tables using sql server analysis services worked dimensional modeling star snowflake schemas created data source views dsv ssas cubes using identified fact dimensional tables experienced writing queries using sql server analysis services ssas created configured data source data source views dimensions cubes measures partitions selfmotivated possess ability critical thinking analysis good interpersonal communication skills teamoriented technically motivated creative user oriented desire learn clients business requirements strong inclination finishing job project deadline flexible versatile adapt new environment work project skills languages c c tsql vbnet rdbms ms sql server 2014201220082008 r2 2005 70 oracle teradata msaccess web technologies htmlxml productivity applications ms word ms excel ms access ms frontpage sql server tools enterprise manager sql profiler query analyzer sql server management studio ssis ssrs ssas data modeling tool erwin visio operating system windows 95982000xpntms dos unix work history 052016 current sql bi developer reporting tools ssrs sql server reporting services crystal reports tools microsoft visual studio 201420122008 ms office teradata sql assistance oracle sql developer etl tools ssis sql server integration services dts furniture mart baxter mn united states america office depot incis americanoffice supplyretailing company headquartered inboca raton florida united states america company combined annual sales approximately 14 billion employs 66000 associates serves consumers businesses 59 countries 2200 retail stores ecommerce sites abusinessto businesssales organization responsibilities developed stored procedures user defined functions views triggers tsql scripting complex business logic extensively used joins correlated noncorrelated subqueries complex business queries involving multiple tables different databases implemented triggers stored procedures enforced business rules via checks constraints optimized database creating various clustered nonclustered indexes indexed views involved creating maintaining tables performance tuning long running stored procedures queries worked rewriting old oracle stored procedures tsql deep understanding business logic worked creating complex queries pull data various tables using loops creating variables extracted large volumes data various data sources loaded data target data destinations performing different kinds transformations using sql server integration services ssis created ssisssdt packages uploading different formats files excel access dbf databases sql server flat files oracle teradata etc sql server data warehouse using sql server integration services ssis involved migrating data sql server oracle teradata worked scripting teradata load utilitiesfast load multi load used run ssis using execute process task scheduling jobs using esp jobs scheduler mainframes extensively worked migrating dts packages ssis 2008 ssdt2014 deployed packages different servers using project deployment ssis 20122014 using project package parameters created xml sql server package configuration make package dynamic using ssis package configuration wizard deploy packages production server created complex ssis packages using proper control data flow elements extensively worked variables complex expressions packages ssis documented processes involved maintaining database ssdt packages future reference environment microsoft windows 2008 advanced server microsoft sql server 201420122008r2 visual studio 20082012 2013sql assistance sql developer main frames oracle teradata ssis ssrs olap tortoise 052015 052016 senior sql ssisssrs developer aigamerican international group inc city state american international group inc aig leading international insurance organization serving customers 100 countries jurisdictions aig companies serve commercial institutional individual customers one extensive worldwide propertycasualty networks insure addition aig companies leading providers life insurance retirement services united states responsibilities interacted business users analyzed user requirements built reporting solutions relational database reports olap reporting dashboards scorecards involved dimensional modeling data warehouse using erwin tool created complex tsql queries stored procedures indexes functions views support efficient data storage manipulation used different string date time functions manipulate data using tsql extensively worked views cursors ctes schemas permissions performance issues clientserver database design created many database objects like tables views indexes functions advanced queries database development production environments using sql server management studios database engine migrated ssis packages sql server 2008 sql server 2012 per business requirement responsible etl operation extracts transforms data data warehouse using sql server integration services ssis developed dynamic packages using ssis implemented incremental data loading implemented error logging using event handlers also implemented logging ssis packages created etl process using ssis transfer data heterogeneous data sources deployed packages different servers using project deployment ssis 2012 using project package parameters created different type reports including crosstab conditional drilldown olap sub reports good understanding microsoft reporting services ssrs report authoring report management report delivery report security experience integrating share point server ssrs deploying ssrs reports share point server experience creating tabular reports matrix reports list reports parameterized reports sub reports ad hoc reports ssrsdesigned formatted ssrs reports using parameters expressions reports automated execution ssrs reports using subscriptions datadriven subscriptions environment microsoft windows 2008 advanced server microsoft sql server 201420122008r2 ssis ssrs sql server reporting services olap oracle sql developer tfs erwin 092010 102014 senior analyst sql developer global logic city state globallogic offshore software rd services company founded 2000 headquarters san jose california privately held company founded apax partners global logic provides fulllifecycle product development services including experience design product engineering content engineering labs company specializes big data analytics cloud design devops embedded internet things mobile security practices globallogic works startups mature product services companies automotive finance media communications hitech medical technology retail industries responsibilities written complex tsql queries created stored procedures triggers functions views involved performance tuning code using execution plan sql profiler added indexes improve performance tables worked creating complex queries pull data various tables using loops creating variables developed stored procedures sql server 20122014 modified existing stored procedures needed extensively designed packages data mapping using data flow task loop container execute sql task file system task script task ssis designer involved source data analysis design creation data mappings extraction bulk data heterogeneous sources like flat files excel oledb odbc data sources developed dynamic packages using ssis implemented incremental data loading created ssis packages dynamic etlssis flow validate extract transform load data database using lookup fuzzy lookup derived column conditional split slowly changing dimension scd perform data scrubbing including data validation checks staging loading data data warehouse experienced creating jobs alerts alertssql mail agent scheduling ssis packages using sql server agent job created shared dimension tables measures hierarchies levels cubes aggregations ms olap analysis server ssas involved analyzing designing building olap cubes ssas 2008r2 identified defined fact relationships ssas defined kpis actions calculations ssas using mdx developed query generating drill drill reports ssrs 2012 2008 designed formatted ssrs reports using parameters expressions reports automated execution ssrs reports using subscriptions datadriven subscriptions involved troubleshooting system issues monitored scheduled jobs set maintenance plans proactively monitoring performance sql server databases environment sql server 20122008r2 ms server integration services ssrs ms server reporting services ssas window 20072008 server crystal reports share point server 2010 vbnet