summary jessica claire montgomery street san francisco ca 94105555 4321000 resumesampleexamplecom experienced ms business intelligence developer 7 years experience working bl applications ssms ssis ssrs ssas development test production environments wide experience working different industry domains service insurance finance sqletl developer 7 years experience requirement gathering analysis design development implementation enterprise solutions experience information technology strong background database development data warehousing using ms ssisssasssrs hands experience installing configuring managing upgrading migrating monitoring troubleshooting sql server 2016201420122008r22008 strong knowledge entityrelationship concept facts dimensions tables slowly changing dimensions scd dimensional modeling kimballinmon methodologies star schema snow flake schema experience report development using ssrs creating various types reports like dashboard drill downthrough parameterized cascading conditional table matrix chart sub reports experience sql server mds 2012 features including hierarchies granular security transactions data versioning business rules experience developing monitoring extracting transforming data using dtsssis import export wizard bulk insert excellent high level design etl packages ssis packages integrating data using ole db connection heterogeneous sources like excel csv flat files ms access sas oracle db2 salesforce crm using multiple transformations provided ssis data conversion conditional split bulk insert derived column merge merge join union experience working web services handle sql connections strong skills deploying operating large scale cloud infrastructure application services aws azure sap oracle cloud google cloud ibm software cloud providers strong knowledge host scripting automate routine tasks excellent knowledge creating databases tables stored procedures ddldml triggers views user defined data types functions cursors indexes using tsql experience data conversion data migration using ssis dts services across different databases like oracle ms access flat files experience performance tuning query optimization well versed performance point server 2007 designed dashboards scorecards reports using multiple kpis olap charts ssrs reports pps experience maintenance administration ssis creating jobs alerts sql mail agent schedule dtsssis packages generated data support sap business objects interface users access data data warehouse expert creating parameterized reports hands experience creating star schemas snow flake schemas excellent analytical communication interpersonal skills proficient writing presenting complex technical concepts comfortable working independently different size teams proficient designing data marts data warehousing operational data store ods olap data modeling like dimensional data modeling star schema modeling snowflake modeling fact dimensions tables using analysis services involved designing populating data data warehouse cubes olap using ssas ssis data modeler strong conceptual logical physical data modeling skills experience jad sessions requirements gathering creating data mapping documents queries migrated onpremise sql server schemas cloud azure sql server db azure vm developed maintained databases across onpremise cloud deployments skills strong ms office abilities ms sql server 2016201420122008 sql server integration services ssis power bi dax security rules experience ms sql bi tsqlssisssrs developer gep detroit mi sql server reporting services ssrs sql server analysis services ssas sql relational database data warehouse ability test systems 092018 current sompo international international operation wholly owned subsidiary sompo trades tokyo stock exchange operating subsidiaries sompo international underwrites agriculture professional lines property marine energy casualty specialty lines insurance catastrophe property casualty professional lines weather risk specialty lines reinsurance created complex tsql queries stored procedures functions indexes ctes views joins triggers wrote tsql queries store procedures used build packages reports developing several behavioral reports data points creating complex sql queries stored procedures using ssrs excel created ssis sql server integration service packages extract data oltp olap systems sql server scheduled jobs call packages stored procedures improved stored procedures sql queries performance analyzing execution plans creating proper indexes using sql profiler database tuning advisor designed various ssrs reports requested client developed several ssis packages data flow tasks using ssis extracted data different sources stored sql staging tables bi staging database created different data points pulling using ssis package applied various data transformations like aggregate sort merge multicasting conditional split derived column developed ssis packages stored procedures loadtransformcleanse data sql server oracle excel files facts dimension tables data warehouse created ssrs reports tabular matrix charts dashboard subreports using ssrs 2012 designed various ssrs reports requested client used ssis create maintain troubleshoot etl packages validate extract transform load data data warehouse databases wrote complex stored procedures ctes functions ssrs reports etl projects implemented different slowly changing dimension methodologies maintain update historical data sco bi developerssisssrsssas capital bank financial corp city state 072017 102018 capital one financial corporation bank holding company specializing credit cards auto loans banking savings account headquartered mclean virginia capital one ranked 10th list largest banks united states assets bank 755 branches 2000 atms ranked 98th fortune 500 conducts business united states canada united kingdom 2016 5th largest credit card issuer purchase volume responsibilities actively participated jad sessions different departments managers end users capture document system requirements verified business requirements functional specifications involved dimensional modeling data warehouse using erwin tool gathered analyzed documented business requirements business rules directly working end usersclients created maintained documents like documentation roadmap data models etl execution plan configuration management procedures project plan developed complex database objects like stored procedures functions packages triggers using sql plsql created appropriate triggers assist efficient data manipulation data consistency developed database objects like tables stored procedures triggers user defined data types functions created updated clustered nonclustered indexes keep sql server performance implemented error handling trycatch method used ctes responsibilities included fine tuning sql server achieve best performance used performance monitor sql profiler optimize queries enhance performance designed developed various ssis packages etl extract transform data involved scheduling ssis packages published ssrs reports report manager sharepoint web pages custom made aspnet web applications performed ssis development support developed etl solutions integrating data multiple sources like flat files delimited fixed width excel sql server raw file db2 central oltp database created complex stored procedures triggers functions udf indexes tables views tsql code sql joins ssis packages ssrs reports developed c console applications manipulate databases perform calculations created application tracking system surveys manual data entry web applications using aspnet framework extracted loaded sharepoint lists surveys data sql server database sql server integration services worked extensively system analysis design development testing implementation projects extended ssis capabilities creating custom ssis components sharepoint configured ssis packages xml configuration file environment variable registry entry parent package variable sql server table pulled data ms sql server database different dbms databases like oracle teradata etl packages created ssrs powerbi reports sourcing ssass multidimensional olap tabular model cubes mdx dax developed maintained crystal reports created scheduled various sql jobs using sql server agent perform various administrative tasks designed star schema data warehouse including facts dimensions implemented dw applications based requirements involved building dimensional cubes sql server analysis services ssas querying data mdx script defined mdx scripts querying data olap cubes ssas build reports top cubes sco bi developer agroinvestbank city state 012012 052017 ojsc agroinvestbank established 1992 one leading banks tajikistan strong branch network across country capital stock bank formed individuals legal entities residents republic tajikistan european bank reconstruction development high level reliability agroinvestbank proved international awards october 2002 geneva conference business initiative directions bank awarded gold international star award quality nomination achievements using practical activity modern bank technologies based upon international standards march 2003 frankfurt conference business initiative directions bank awarded platinum arch europe nomination high quality bank services use modern technologies manage daily operations including database backups restores maintenance jobs developers requests develop reports sql queries including formatting analyzing reconciling summarizing information complete andor resolve elements timely manner adhering company policies procedures created tsql scripts generated tables relationships based customers request identified source destination staging area per etl strategy performed data cleansing data profiling creating ssis sql server integration service packages extract data oltp olap systems sql server scheduled jobs call packages stored procedures created new database objects procedures functions indexes views utilized tsql used system well userdefined functions enhance functionality tsql code utilized dynamic sql user customizable queries answered sql server designed ssis packages extract transfer load etl existing data sql server different environment implemented data cleansing incremental data loading logging event handling error handling created ssis packages using fuzzy lookup derived columns condition split execute sql task data flow task execute package task created dynamic ssis packages using complex expressions variables control flow components loop container loop directory load inbound files coming daily scheduling jobs alerts using sql server agent configured database mail job failure hands experience creating several ssis schedule tasks monitor tasks regularly pulled data ms sql server database different dbms databases like oracle teradata etl packages created ssrs powerbi reports sourcing ssass multidimensional olap tabular model cubes mdx dax developed maintained crystal reports created scheduled various sql jobs using sql server agent perform various administrative tasks designed star schema data warehouse including facts dimensions implemented dw applications based requirements involved building dimensional cubes sql server analysis services ssas querying data mdx script defined mdx scripts querying data olap cubes ssas build reports top cubes education training master engineering faculty computer control systems automatics vinnytsia national technical university vinnitsa ukraine certifications completed practical sqlqalight ukraine 2011 062011