Business Intelligence Analyst Resume

SUMMARY:

Designed interactive dashboards to show hotel trends, created workbook based on Excel data files and performed data visualizations on aggregated data, performed data pre - processing and data blending, explicating various KPIs using various charts and graphics and utilized Tableau to understand relationships between various entities and make future predictions using trend
Leveraged predictive analytics to forecast the revenue of a company by creating a linear regression model in Excel. Improved decision-making by visually representing the data using MicroStrategy.
Assessed and compared the performance of a toy company across states by utilizing SAS Visual Analytics to create dashboards, generate reports, and visualize KPIs data .

TECHNICAL SKILLS:

WORK EXPERIENCE:

Business Intelligence Analyst

Confidential

Responsibilities:

Enhanced marketing strategies to bolster up the company transition from private sector to public sector resulting in ~$1M deal within 6 months using insights from Tableau reports and KPIs.
Collaborated to implement A/B testing for an e-commerce website and created effective call-to-actions to improve CTR and Conversion Rate by 10%
Designed automated Tableau dashboards to monitor and evaluate RFP’s and RFI’s on public sector market resulting in increased client targeting by 55%.
Gathered and analyzed large datasets consisting of organizational, finance and public sector data and develop insightful data analytics and reporting to improve ROI, strategies and operations.
Designed data marts, created views and stored procedures to use enterprise data for reporting and technical decision making.
Improved operational efficiency by 35% by designing questionnaires, discussion guides, observations on scope of work to gather meaningful feedback from clients.
Improved task allocation by tracking organizational data and revenue generated using gap analysis.
Engaged in hypothesis testing estimation and forecasting to make decisions about company systems and processes.

Intern - Business Analysis

Confidential

Responsibilities:

Analyzed business model and identified issues. Generated buy-in from CIO and project manager by developing a business case.
Pitched and developed a learning analytics platform to capture students’ performance KPIs while leading a team of interns ; collected and fetched data using Hadoop. Defined business objectives and designed a business strategy to gather and analyze requirements, perform data analysis , and develop reports and dashboards using Confidential Cognos Analytics .
Developed a manual implementation guide for future project reference and replication.
Sought assistance with the analytics platform development and implementation from Confidential 50 companies like Confidential and Confidential by preparing the scope of work as part of the RFP .

Business Intelligence Intern

Confidential

Responsibilities:

Increased targeted product sales by 20% using automated Tableau reports and real-time dashboard.
Reduced query execution time from 1 min 30 seconds to 45 seconds by streamlining SQL queries using indexes.
Used advanced MS Excel features like pivot tables, VLOOKUP and created defect metrics after product release.