jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary sqlbi developer ssis ssas ssrs power bi 7 years extensive experience querying designing maintaining databases well developing business intelligence solutions ms sql server possess strong knowledge wide range working experience implementing robust scalable bi solutions creating etl packages using ssis automate data migrations various sources sql server onpremises cloud vice versa skilled developing reports dashboards using different reporting visualization tools power bi ssrs tableau highly experienced azure cloud services adf synapse azure sql etc strong programming skills sql python data analysis demonstrated success utilizing diverse range technologies tools drive datadriven decisionmaking optimize business performance adept collaborating crossfunctional teams managing multiple projects simultaneously delivering highquality results within tight deadlines skills experience database design development ms sql 2008201220142016 bi solutions using microsoft components various business domains experience creating various sql server objects like tables views constraints indexes joins experience use tsql developing complex queries stored procedures triggers user defined functions good knowledge fine tuning long running tsql scripts breaking complex scripts simple creating indexes updating statistics experience creating backend validations using insert update delete triggers created views generating reports operating systems windows 1087xp linux etl tools sql server business development studio bids dts sql server management studio ssms sql server integration services ssis experience 042020 current bi developer panjiva virtual wv analysis reporting services ssas ssrs ssas microsoft power bi ms excel cloud technology azure data lake azure data factory azure data warehouse azure sql database azure synapse azure logic apps sql server tools sql server management studio database engine import export wizard architecture relational dbms clientserver architecture oltp olap version control git tools autosys ca workload automation tool languages tsql oracle pl sql mysql vb powershell dax mdx python gathered functional requirements business requirements written technical specifications building enterprise integrated data warehouse worked closely developers end users designing creating enterprise integrated data warehouse designed implemented etl processes using ssis sql collect clean transform data multiple sources resulting 25 improvement data accuracy developed maintained scalable data pipelines ssis allowing efficient processing analysis large datasets designed implemented data pipelines using azure data factory extract data various data sources transform load azure sql database analytical reporting create fully automated azure data factory pipelines configured appropriate error handling azure logic apps collaborated crossfunctional teams including data analysts data scientists ensure data integrity improve quality business insights actively participated gathering business requirements system specification participated implementing logical design physical design creating tables strong experience sql server tsql implementing maintaining developing stored procedures triggers nested queries joins views user defined functions indexes user profiles relational databases models creating updating tables checking database consistency executing dbcc commands sql performance monitoring tuning reporting data optimizing indexes stored procedures created implemented triggers tsql facilitate consistent data entry database created alerts notifications emails system errors insufficient resources fatal database errors hardware errors security violation designed ssis packages extract transfer load etl existing data sql server different environments implemented data cleansing incremental data loading logging event handling error handling created ssis packages using pivot transformation fuzzy lookup derived columns condition split term extraction aggregate execute sql task data flow task execute package task created database objects like tables view store procedures functions triggers using sql server created various types reports sub reports tablix matrix using sql server reporting services created parameterized reports consist report criteria various reports make minimize report execution time limit records required created reports cascading standard parameters designed reports account information research reports using adhoc reporting used clients advisors worked power bi creating dashboards reports visualizing data used microsoft power bi power query extract data external sources modify data certain format required excel created ssis packages load excel sheets pc database used power query acquire data developed calculated columns measures using dax power bi desktop designing rich visuals using visualizations bar chart clustered column chart waterfall chart gauge pie chart tree map shared user groups scheduled maintained power bi reports published power bi service sourced data sql azure database sql azure data warehouse aws rds solutions mysql aurora redshift power bi reports created ssis packages using advance transformations ie pivot transformation fuzzy lookup derived columns condition split aggregate used custom components audit preexecute audit postexecute statistics logging component successfully extracted data flat filesexcel files applied complex transformation finally loading sql server data warehouse monthly basis created dynamic ssis packages using complex expressions variables control flow components loop container loop directory load inbound files coming daily prepared migration document showing paths input output files configuration files table scripts stored procedures ssis packages 032018 032020 senior etl developer epam systems inc pa state manage daily operations including database backups restores maintenance jobs developers requests optimizing data pipelines applications performance tuning spark configurations optimizing sql queries implementing caching strategies designed developed maintained data pipelines using adf azure sql large ecommerce organization 100tb data designed developed data ingestion pipelines using ssis azure data factory processing largescale datasets various sources formats including structured semistructured unstructured data enabling realtime batch processing workflows utilized azure data factory mapping data flows advanced data transformations integration azure databricks advanced data processing developed data storage solutions using azure blob storage azure data lake storage enabling scalable distributed data storage retrieval advanced features azure data lake storage gen2 tiering azure blob storage lifecycle management designed implemented data models using azure synapse analytics enabling efficient querying analysis large datasets optimized performance queries tuning partitioning indexing strategies implementing azure synapse analytics sql pool provide highperformance analytics capabilities large datasets 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 optimization queries looking execution plan better tuning database 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 moving data premise azure storage accounts blob data lake staging purposes transforming data moving destination tables azure sql dw dedicated sql pool azure sql hands experience creating several ssis schedule tasks monitor tasks regularly developed numerous adhoc reports using ssrs daytoday financial reporting generated custom parameterized reports using ssrs used sql server agent scheduling jobs alerts extensively used ssis transformations lookup fuzzy look ups derived column data conversion aggregate conditional split sql task script task send mail task etc 032017 032018 bi developer panjiva boulder co 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 deployed database objects stored procedures triggers indexes views udfs sql server modified temporary tables indexes lookup techniques optimize stored procedures 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 created ssis packages data loading utilizing various task transformations execute sql task script task execute package task data flow task fuzzy lookup lookup oledb command derived column etc extracted loaded data multiple sources excel flat files sql server oracle staging area wrote complex sql queries using joins sub queries correlated sub queries retrieve data different sql server databases excel files apply business logic load table create view end users worked index tuning wizard sql profiler sql trace performance tuning repaired ssis packages checkpoints breakpoints data viewers created ssis packages utilizing different transformations ssis toolbox aggregate merge merge join incorporated package configurations xml files environment variables improve compatibility designed ad hoc ssrs reports test environment data validation utilized sql server 2012 optimized reports optimizing embedded queries improved stored procedures generate formatted reports applying parameters assigned parameter defaults data types extended reports 022016 022017 power bi developer first international bank trust gilbert az utilized power bis mapping capabilities create geographic visualizations perform locationbased analysis developed drillthrough drilldown capabilities reports enable endusers explore data detail used conditional formatting data bars highlight important data points trends reports created visually appealing interactive dashboards reports using various chart types column charts line charts scatter charts funnel charts ensure data security compliance company policies regulations optimize data models performance scalability provide training support endusers use power bi reports dashboards effectively work closely business stakeholders understand data requirements develop solutions meet needs develop maintain interactive dashboards reports using power bi desktop power bi service collaborated data engineering teams integrate data sources power bi reports dashboards used dax crea timeintelligence calculations calcula periodoverperiod growth yeartodate values optimized dax queries performance efficiency using techniques table partitioning query folding utilized dax create dynamic visualizations drilldown hierarchies reports dashboards developed custom measures calculated columns support complex business logic calculations created complex dax expressions calculate kpis perform data analysis calculating running totals yeartodate values moving averages designed implemented data models queries using power query dax developed maintained power bi reports dashboards various business units built recommendation engine ecommerce platform using collaborative filtering matrix factorization techniques resulting 20 increase clickthrough rates sales wrote tsql queries store procedures used build packages reports developing several behavioral reports data points creating complex sql queries stored procedures using ssrs excel 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 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 generated subreports drill reports drill reports parameterized reports using ssrs education training bachelor science computer science university technology ganja azerbaijan