jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary seasoned datadriven architect engineer possessing indepth knowledge rdbsm environments etl techniques integration disparate systems offering 10 years background managing various aspects development design delivery database solutions analytical passionate aspiring leader bringing proven communication organizational abilities seeking fulltime remote position skills expertise microsoft sql server management studio 20052019 microsoft certified professional designation microsoft database fundamentals designation temporary tables dll statements loops schema creations common table expressions view dynamic sql scripts merge statements indices performance tuning triggers functions store procedures joins parametrization cross apply outer apply automation job creation scheduling environment variable deployment variables store procedures pivots performance tuning expertise bidsvisual studio extraction various sources eg flat files dbs xml etc dynamic sql automation deployment parameterization looping programprocess executions custom coding using script tasking flat filexml file creation utf8 conversion merge scd implementation adept excel user pivots use macros formulas charts tabular data ssas cubes data architecture modeling use star snowflake schema utilizing tools like visio create flow charts using data modeling tools like sqldb create denormalized structures creating business specific entities create balance efficiency use case oracle familiarity use plsql corroborated financial reports using oracle transaction business intelligence otbi ucm well familiarity presentation layer tools salesforce tableau qlikview ssrs otbi subject matter expert deep derived knowledge business operations including finance accounting marketing underwriting compliance specialty risk programs pertinent skills agile hybridkananwaterfalls methodology familiarity azuredevops github tfs skilled design documentation personal skills diligent adaptive organized methodical analytical honest blunt experience data engineer iii 072016 current crown castle usa inc pompano beach fl development utilized various ides including visual studio sql server management studio astera centerprise build etl solutions created dynamic sql droprecreate objects utilized activity monitortype tools foglight solarwinds dpa tool bottlenecks created technical operational audits within process better catch issues performance tuned process cutting 8 hour process 5 minutes created ingested delimited files created pivot structures within sql taking data transposing direction eg horizontal data vertical utilized vb c languages create custom script task components use etl solutions integration integrated claims personal commercial lines products extensively developed piloted implemented integration solution oltp data salesforce created api pipeline delivering quote details business thereby allowing make key decisions agents created data consumption delivery solutions claims including though limited sending flat files vendors containing company data receiving decompressing unpacking ingesting data creating wrapper shell program called ssis solution dynamically recreating dll parameterized inputs analytics researched financial disparities oracle tsql restructured format sequenced data dictionary oracle extrapolate originate data sources better deliver solutions created pivoted olaptabulated ssas structures help display intersection trends data reporting created canned subscription ad hoc reports business stakeholders sectors including finance claims actuary legal statistical statutory marketing underwriting substantiated differences expected actual results control reports allowing business see disparities architecture architected scd type 1 2 3 denormalized normalized structures created conceptual logical physical data models utilizing tools visio sysdiagram sqldbm leadership led organized scrumstatus meetings provided guidance focused delivery tasks colleagues whilst assessing gaps provided instructional informational background projects new comers detailing thoroughly historical current sdlc processes lessons learned etc piloted groups create best practices code vettingreview within organization organizational incorporated various methodology including though limited waterfall agile kanban hybrid created several detailed design documents serving standard template developers coordinated project management updates determine project scopes limitations managed performance monitoring tuning identifying repairing issues within database realm part swat delivery service team designed tackle high velocity profile requests company managed solution implementation several highprofile projects start finish application developer 122014 072016 honeywell columbia md development created etl solutions using visual studio sql studio management studio parsed massaged data guidewire specific formats following tight edits promoted automated etl processes performance tuned existing queries cut time reducing overall process 2 hours 8 minutes integration integrated commercial personal lines farm ranch insurance products guidewire claims center worked closely business stakeholders understand data whilst also pushing systemoriginated corrections fixes could done via etl leadership mentored colleagues fellow testers tsql scripting organizational utilized agile methodology tfs check inout code repository created design documents detailing process flow worked closely business stakeholders understand requirements provide deliverables per specifications educational actively sought areas increase insurance domain knowledge enrolled successfully completed ains 24 offered institutes informed trained guidewire sap hana software became farm ranch sme data etl developer 032013 102014 american homes 4 rent murray ut development created complex integration solution ingest parse rowdelimited flat files using fiserv data model ingested outputted files fnma fhlmc refined data using etl based businessend user requirements participated code review sessions colleague assess bottlenecks strategize resource consumption kill deadlocks tailor code become io efficient created sdlc lifecycle process flow including environments development testing production installed upgraded sql server studio integration delivered outputs using webservice calls fetching unique systemoriginated keys oltp system use within tsql leadership trained mentored users utilize tsql create simple ssis packages crosstrained colleagues etl solution organizational created several design documents detailing pipeline etl solution caveatslimitations future development requirements associate arts 122011 education training collin college frisco tx summa cum laude honors graduate phi theta kappa international honor society member sigma kappa delta national english honor society member student leadership academy graduate activities honors