jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 professional summary highly motivated business intelligence professional 7 years experience business intelligence data warehouse solutions thorough understanding bi applications ssms ssis ssrs ssas like challenge learning new things problem solver workplace part enjoy skills expertise sql server integration services ssis sql server reporting services ssrs good knowledge sql server analysis services issasi ssas experience creating parameterized reports profound knowledge experience dealing relational database relational management systems including normalization stored procedures constraints querying joins keys indexes complex views dynamic sql triggers cursors er diagrams working experience creating database objects like tables constraints primary key foreign key unique default views indexes experience developing applications using tsql programming ddl dml dcl expertise writing tsql queries complex stored procedures creating triggers cursors userdefined functions joins common table expression cte expertise extracting transformation loading using various tools like etl using exportimport data sql server integration services created developed tested deployed packages production servers creating package configurations experience writing expressions ssrs expert expressions fine tuning reports created many drill drill reports using ssrs good knowledge fine tuning long running tsql scripts breaking complex scripts simple creating indexes updating statistics experience transforming data using data flow tasks like derived column data umn data conversion row count merge conversion row coun join union etc experience implementing various ssis features like event handling precedence constraints breakpoints checkpoints logging complex ssis packages experience migration remise sql server schemas cloud azure sql server db azure vm developed maintained databases across premise cloud deployments education fatih university istanbul turkey bachelor science marketing 2010 2012 berkeley college little falls nj bachelor science marketing communications 2012 2013 work history furniture mart sql bi developer sioux falls sd 032018 current created new database objects procedures functions indexes views utilized tsql used system well userdefined functions enhance functionality tsql code designed ssis packages extract transfer load etl existing data sql server different environment 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 developed deployed database objects stored procedures triggers indexes views udfs sql server implemented error handling trycatch method used ctes extracted loaded data multiple sources excel flat files sql server oracle staging areas repaired ssis packages checkpoints breakpoints data viewers created ssis created ssis sql server integration service packages extract data oltp olap systems sql server scheduled jobs call packages stored procedures 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 migrated onpremise sql server schemas cloud azure sql server db azure vm developed maintained databases across onpremise cloud deployments coordinated project management staff database development timelines project scope modified existing databases meet unique needs goals determined initial evaluation planning process delivered complex business requirements without issues leveraging strong troubleshooting skills extensive oversight managed workload independently collaborated colleagues complete larger scale tasks distributed team environment supported multiple concurrent projects enabling delivery efficiencies technical resolution created optimal technical solutions user needs research indepth system analysis tested programs databases identify issues make necessary modifications followed standard practices migrating changes test production environments provided technology support meet business requirements produced highstandard database solutions meet stability reliability performance metrics reviewed interpreted business report requirements address user needs analyzed existing sql queries identify opportunities improvements generated debugged enhanced existing reports introduction new system features alight sql developer state 062016 102017 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 used system well userdefined functions enhance functionality tsql code designed ssis packages extract transfer load etl existing data sql server different environment developed deploy udfs deployed database objects stored procedures triggers indexes views sql server implemented error handling trycatch method used ctes migrated onpremise sql server schemas cloud azure sql server db azure vm developed maintained databases across onpremise cloud deployments supported multiple concurrent projects enabling delivery efficiencies technical resolution documented analyzed business reports prompt communication followup ongoing support produced highstandard database solutions meet stability reliability performance metrics reviewed interpreted business report requirements address user needs analyzed existing sql queries identify opportunities improvements followed standard practices migrating changes test production environments provided technology support meet business requirements community transit project assistant everett wa 122012 022016 prepared documents reports presentations executives board members using advanced software proficiencies purchased new products oversaw inventory stocking availability created purchase orders planned arranged meetings external organizations individuals enabling parties meet discuss project progress gathered requirements ongoing projects organized details management use created workflow diagrams clearly demonstrate processes timelines mapped current business operational processes recommended areas improvement hired freelancer programmer worked together companys business intelligence project directed implementation new business intelligence tools selecting appropriate solutions aiding corresponding onboarding processes derived conceptual designs business objectives deliver software applications according specifications usability performance functionality applied honed problemsolving skills analyze resolve issues impacting business operations goal achievement designed implemented tsql queries reporting complex solution development developed implemented optimized stored procedures functions using tsql reviewed interpreted business report requirements address user needs provided assistance preparation projectrelated reports manuscripts presentations worked senior leadership complete complex projects time underbudget belay bookkeeper atlanta ga 102011 072012 monitored verified approved invoices reviewed balances using financial software assess balance sheet variances applied proper codes invoices files receipts keep records organized easily searchable reviewed processed employee expense reports vendor invoices payment maintained account accuracy reviewing reconciling checks monthly maintained processed invoices deposits money logs