professional summary jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom dynamic ambitious ms bi developer 7 years experience database generation creation data warehouses etl packages reports presentations using bl applications ssms ssis ssrs power bi wellorganized adaptable varied team data engineer ability work independently extensive professional experience variety companies including sales service finance healthcare insurance skills windows 20122008 r220032000 server query analyzer sql server management studio business intelligence development studio sql profiler microsoft azure extraction transformation loading etl ssrs 201720162012 excel power bi tableau c mysql plsql tsql postgresql javascript nodejs react css html5 mongodb python git github ms word ms excel ms access ms project visio ssms work history sql developer 012021 current fiserv inc houston tx developed implemented optimized stored procedures functions using tsql designed implemented tsql queries reporting complex solution development designed developed various ssis packages etl extract transform data involved scheduling ssis packages worked several transformations data flow including derivedcolumn script slowly changing dimension lookup data conversion conditionalsplit many extracted transformed multisource data incorporating assets unified databases monitoring integration replication performance developed ssis packages using lookup transformations merge joins fuzzy lookups derived columns multiple data flow tasks converted old etl packages new version optimization applying stored procedures instead using control flow tasks bloiness intelligence developer 1800flowerscom inc san jose ca 112018 102020 designed customized data collection models specific visualization tasks developed intelligencesharing dashboards providing companywide access collected data used different methods logging ssis building publishing customized interactive reports dashboards report scheduling using power bi worked etl implement slowly changing transformation maintain historical data data warehouse strong understanding data modeling data warehouse environment star schema snowflake schema generated reports updated spreadsheets presented results tune sql queries database performance improving overall table design indexing query plan analysis refactoring create database design documentation architectural functional level review database objects data integrity quality security recoverability scalability maintenance capacity recommend changes necessary biosis developer general electric boston 042017 092018 managed loading transformation sql server ssis packages sql server data warehouse several migration projects developed ssis packages gave vendors stepbystep instructions run generate files databases utilized ssis extract transform loading etl tool sql server populate data different data sources making packages various data loading tasks application enhancing existing etls creating new etl procedures created etl solutions integrating data many sources including flat files delimited fixed width excel sql server raw file db2 main oltp database performed ssis development support coordinated management teams plan develop align execute strategies would meet clients vision mission purpose configured ssis packages xml configuration file registry entry parent package variable sql server table bioeveloper analyst kpmg professional services tashkent uzbekistan 062015 032017 imported exported data etl packages various control flow choices data flow transformations conditional split multicast union derived column developed etl packages ssis lookup execute sql task sequence container breakpoint checkpoint guarantee data quality consistency using event handler created etl packages sent emails managers package performed error occurred multiple environments including developing testing production environments used build run deliver packages involved creation implementation ssis ssrspowerbi application solutions different organizational business units ssis packages developed prepare load data data warehouse ssis program developed transport data oltp olap databases using incremental load education bachelor science computer science institute information technologies samarkand uzbekistan 052015