Business Intelligence Analyst
Resume:
Shruti Dabas
Columbia 65202, Missouri
https://www.linkedin.com/in/shruti-dabas-05566664/ ***********@****.********.***
Professional Experience
Shelter Insurance – Columbia, Missouri
Business Intelligence Intern and Part Time June 2020 to Present
Building and analyzing models using statistical tools, programming language R, KPI Analysis, predicting business trends and improve efficiencies and performance through SQL and visualizing reports through AWS quicksight, Good Data, JIRA, Genius AI and Google Analytics to understand customer journey, budgeting, policy performance and increase efficiency and profits.
University of Missouri
Graduate Research Assistant August 2019 to Present
Support Dr. Roger Reger with data analysis.
Icons Advertising - Gurgaon, India January 2019 to June 2019
Assistant Sales Manager
Analyzed reports over last years to predict changes in different seasons with respect to sales and accessed targets for sales teams. Pitched and closed one-year deal with Air India (India’s only government airlines) for outdoor branding on Airbus 320 ‘s external body as wraps. First ever airline advertising in India.
Capital Marketing FZ LLC - Dubai, UAE June 2015 to January 2019
Key Accounts Manager and Procurement Executive
Analyzed their existent and past campaigns and proposed in same fashion to each client for upcoming period. Initiated proposals for new media sites and renewals for existing with Landlords or government. Monitored contracts and the Lease Agreements clauses, Payment terms, price negotiation, vendor management, tender procedure and government approvals.
Studied markets in Nigeria and Norway, by collecting data, rules of countries for foreign investors and reaching out to competitors and vendors for expansion opportunities to open branches.
Sona Commercial LLC - Dubai, UAE June 2015 to January 2019
Brand and Marketing Executive
Worked with corporate clients and government departments all over UAE for bringing awareness of special paper / eco-friendly paper consumption.
Education
University of Missouri – Crosby MBA Program May 2021
Master of Business Administration, Graduate Certificate in Marketing Analytics
Database Analytics, Business Analytics, Data Visualisation, Descriptive Statistics, Machine Learning and Artificial Intelligence Applications
Experience with Microsoft SQL Server
Proficiency in SAS, SPSS, Python and R
Database Management, Marketing Engineering, Predictive Modelling
Analysed a project to create Performance Lawn Equipment’s competitive advantage and to enhance stakeholder satisfaction from the unstructured database provided. Established key business objectives and success metrics. Evaluated KPIs, quality, depth, uniqueness and potential value of analysis. Recommended opportunities for business improvement with the help of regression model and excel.
Manav Bharti University - Economics, Masters May 2013
Delhi University - Geography, Bachelors May 2010
Contact this candidate