john smith johnsmithgmailcom linkedin johnsmith21 xxx xxxxxxx austin tx core competencies project dev life cycle agile scrum excel advanced reporting sql databases data visualization business analysis sprint planning review use case diagrams project management work experience company 1 business analyst ii february 2017 present st louis mo generated 75 million revenue leading largescale projects scrum lead crossdepartment liaison eliminated 30 developer rework effectively overseeing requirements gathering meetings stakeholders scope definition reduced average project completion time 20 via detailed sprint planning story mapping swim lane development backlog management uat recovered 96 million risk completing 33 automation projects utilizing agile waterfall project management methodologies tripled speed sql queries used data extraction implementing efficiencies indexes temporary tables normalization boosted revenue 25 via actionable excel reporting including pivot tables data visualization advanced formulas data modeling company 2 management trainee business associate june 2016 january 2017 st louis mo facilitated management three 1000000 dental practices respective support staffs including 19 team members total produced 15 higher revenue via implementing restructured set procedures payment collection decreased insurance verification turnaround time 60 creating executing new webbased process increased office production 10 via efficiently scheduling high production patients education university missouri columbia bs business administration founder president mizzou student united way founding father alpha tau omega fraternity interests custom computer builds fantasy football analytics selftaught computer coding december 2015 columbia mo