jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom summary 2 years experience sql server database developer education retail environments primary skills analysis design development implementing testing client server application using microsoft sql server suite experience software development life cycle involved waterfall agile projects analysing execution plan managing indexes troubleshooting deadlocks experienced normalization stored procedures constraints querying joins keys indexes data import ddldml triggers hints views user defined data types cursors using sqlplsql tsql 2 years experience design development essbase application maintained supported planning applications versions 11x 9x implemented application security process created usergroups security profiles application access different groups using filters provided support work version 11x9x developed calc scripts business rules using business rules calculation manage according customer business needs strong database development business intelligence modeling capabilities essbase calculation script experience strong understanding dense sparse settings performed dynamic calculations developed reviewed optimized report queries microsoft excel loaded data various database cubes meet clients understand business processes gather system requirements subsequent application design implementation using best practice implementation techniques strong communication organizational interpersonal competencies along detailoriented problem solving skills technology arena experience 072012 current data analystsql developer usa vein clinics northbrook il environment ms sql server 20082012 oracle hyperion essbase 11x 9x essbase administration services hyperion planning excel addin smartview web analysis project 2 aaa institute develop complex stored procedures functions triggers views queries support application development review optimize existing stored procedures functions triggers queries develop custom scripts automate various database management processes occasionally write singletime reports demand diagnoses isolation debugging software hardware problems performs problem resolution ensures adherence standards best practices backup restore database define maintenance plans troubleshooting blocking create sql jobs handle errors sql server using trycatch function writing advanced tsql querying using joins subqueries manage index statistics tables views cursors optimize queries using execution plan tuning databases project 1 new york auto giant developed essbase cubes sales marketing group loaded data using sql interface wrote calculation scripts member formulas calculate essbase database wrote maxl automate essbase daily weekly cube refresh supported planning application includes web forms business rules smart list also provided access users based upon role worked directly forecasters planners helped analysis loaded actuals planning application consolidated actuals forecast budget numbers provide complete financial view used best practices optimize calculation time 042008 072012 multiunit manager education 2013 otg saint paul mn led aspects operations including development people sales profit assigned areas comprised 6 restaurants 75 employees 2235 million annual revenue managed restaurants profit loss centers including food supply labor costs meet annual operating budgets performed monthly financial analysis evaluate financial position clearly communicate expectations actions maximize restaurants financial performance operated managed following units uptown brasserie marcus samuelson fine dinning 69 mil la brea bakery qsr 58 mil pizza vino casual dinning 43 mil full bar casual dinning 112 mil jet box qsr 22 mil cake tin qsr 18 mil hired supervisor promoted assistant manager 1 year promoted general manager 1 month increase sales 30k week 55k la brea bakery promotional advertisements throughout terminal increased sales year 41 three locations decrease food labor costs 10 cake tin zpizza decreased labor cost 3000 food cost 12 zpizza increased sale 20 adding additional seating area marketing new promotional ideas adding new grab n go workstation expedite speed service customer service ratings 96 market force surveys consistently obtained rating nyc health department 5 locations credible knowledge quick serve full service fine dinning restaurants bachelor science business management suny farmingdale state college farmingdale ny minor finance coursework business management communications coursework business communications management information systems strategic leadership course operations quality management coursework 2008 high school diploma sewanhaka high school floral park ny