summary business analyst experienced supporting analytical needs organizations prior projectproduct management experience result oriented individual recognized effectively resolving challenging issues aspiring become analytics expert work experience business analyst extracted data sabre duetto google analytics ms excel implemented advanced functionalities like pivot tables vlookup macros perform data analysis business impacting insights making recommendations used predictive analysis predict number guests given night maximize occupancy increase revenue documented monthly ecommerce performance reports ms word created ms powerpoint presentations higher management defined kpi metrics measure businesss success part diverse crossfunctional teams working towards fulfillment corporate goals productivity implemented sql queries using joins sub queries retrieve data database project managerintern managed project requirements using jira confluence collected cleaned analyzed data using ifttt wewiredweb ms excel using functions like pivot tables graphs created mockups wireframes documented use cases activity diagrams sequence diagrams workflow analyzed reviewed developer python html codes prepared executed test plans including documenting resolving issues documented business requirement documents brds functional requirement documents frds product managerintern implemented advanced ms excel functionalities like vlookup pivot tables forecast revenue based historical data analyzed old detection cases using jira tickets salesforce determine products maximum falsetrue positives falsetrue negatives conducted market analysis research threat intelligence companies see differ created innovation games help engineers decide product features coordinated product manager gather requirements make modifications corrections product specific documents certifications scrum fundamentals certified april 2016 microsoft project 2016 essential training february 2016 hootsuite certificate courseware october 2015 ibm db2 database application fundamentals october 2013 technical skills database oracle 9i mysql softwaretools vb ms visio tableau ms project professional salesforce sharepoint education ms information systemsbusiness analytics august 2013 information technology academic projects analytics project 2016 may 2016 used regression analysis tableau forecasting conclude states us stop production ge crops soil damage crops excluded produced genetically data warehousing 2015 offered system design solution startup based requirements data provided company proposed data warehouse management plan manage inventory sales customer data order help daytoday operations plan included gathering requirements choosing kpi data quality data sources analysis dimensional modeling etl system requirements budgeting supply chain management constructions pvt ltd 2015 analyzed operations data propose business plan using advanced ms excel functions like vlookup pivot tables linear regression aimed improving overhead costs improved profit margin company 15 per project