jessica claire resumesampleexamplecom 555 4321000 100 montgomery st 10th floor summary 4 years experience database development bi roles results include improved performance atleast 510 stored procedures large running queries per quarter reduce load production servers involved poc migrating postgresql sql server developed python code automate creation databases postgresql part involved evaluating various bi application software vendors proposed solution creating adhoc reporting feature skills tsql sql server integration services sql server analysis services sql server reporting services python jira html css education training southeast missouri state university cape girardeau mo 122017 master science technology industrial management gpa 375 cmr engineering college hyderabad telangana 052015 bachelor science electronics communication engineering experience crowe horwath database developer new york city ny 042019 current focused analyzed systembusiness requirements feasibility participated business meetings communicate team members gather requirements analyze business challenges provide technical specifications regarding code changes enhancements worked different software hardware applications make necessary changes increase productivity organization installed configured sql server management studio 2016 visual studio 2019 gathered organized sorted operational data restaurant clients using qualitative analysis techniques identified slow performing queries objects hinder operational efficiency propose possible solutions using problemsolving skills made code enhancements get data requested frontend developers developed new database exports reports writing sql queries provide data requested de clients participated performance tuning optimizing database objects high cpu reads duration smooth efficient functionality designed developed net console applications create ssas tabular models azure analysis services server provided database user access admins based roles using sql server analysis services performed uat testing prepared test cases new database objects developed code changes participated code review meetings go code changes made developers provided necessary feedback environment sql server 2016 sql server management studio sql server profiler visual studio 2019 sql server analysis services net crowe horwath database developer columbus oh 042018 042019 focused enhancing functionality applications used business operations dayto day basis participated gathering business requirements legacy requirements attending meetings product owners subject matter experts business users worked creating technologydriven automation payroll system make changes existing manual tax calculation process installed configured sql server management studio 2017 visual studio 2017 ssdt created new databases participated integrating existing structure critical thinking abilities comparing outcomes created entity relationship diagrams help developers understand structure database relation data developed database objects stored procedures triggers views indexes ctes etc created dynamic sql queries improve performance database created ssis packages extract data various sources performed necessary transformations like data conversions conditional split derived columns scds etc convert data useful format loaded data database tables performed uat testing deployed ssis packages sql server integration services database catalog configured log different environments like testprod environment sql server 2017 sql server management studio visual studio 2017 sql server integration services sql server profiler excel net infor junior sqlmsbi developer city state 062015 122015 interacted business users attended business meetings gather project requirements legacy requirements installed configured sql server management studio 2014 visual studio 2012 worked ddldml queries along dynamic run time queries created new databases worked tsql joins temporary tables ctes etc created tables stored procedures functions triggers views indexes troubleshoot small issues performing ssis operations created traces using sql server profiler find long running queries modify queries performance tuning part managed fragmentation indexes reorganizing achieve better performance created ssis packages using etl operations extracted data various sources like ole db adonet flat file connection managers performed builtin transformations like data conversion audit derived columns etc loaded data sql server database gained knowledge data modeling dimensional relational concepts like starschema modeling snowflake schema modeling created fact dimension tables generated various monthly quarterly biyearly yearly reports different type reports using ssrs environment sql server 2014 sql server management studio visual studio 2012 sql server integration services sql server reporting services sql server profiler excel