Business Intelligence Analyst Resume
4.00/5 (Submit Your Rating)
SUMMARY
- Software professional with more than 2 years of experience especially in the areas of Data warehousing and having expertise in Business Intelligence tools like Tableau.
- Worked on creating various dashboards based on business requirements.
- Created solution driven dashboards using different chart types like Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, Donut chart and Histograms in Tableau Desktop.
- Experienced in technical support, troubleshooting, report design and monitoring of system usage.
- Expert in design and deploying rich Graphic visualizations with Drill Down feature and Parameter.
- End to End experience in designing and deploying data visualizations using Tableau
- Produced attractive visuals/dashboards to convey the Story points of the data.
- Participated in business discussions with the users and created requirement documents from which the dashboards are created.
- Expert in analysis, design, development, testing, and production rollover of reporting and analysis projects.
- Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
- Experienced in Administering user, user groups, and scheduled updates for reports in Tableau Server.
- Experienced in granting permissions and other admin activities on Tableau server.
- Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.
- Excellent communication skills in facing the end users and training them in using the tool.
TECHNICAL SKILLS
BI/Visualization Tools: Tableau Desktop 10.3/2018.1/2019.1 Tableau Server, SSRS, Power BI
Utilities: MS Office Suite, MS Project
Databases: Oracle 10g/11g, SQL Server 2008 R2, MS Access, MS Excel
Platforms: Windows7/8/2003/NT, MS Server 2008 R2, Mac OS, DOS
Language: SQL/PLSQL
Tools: Toad, SQL Developer, SQL Plus
PROFESSIONAL EXPERIENCE
Confidential
BUSINESS INTELLIGENCE ANALYST
Responsibilities:
- Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
- Converted charts into Crosstabs for further underlying data analysis in MS Excel.
- Created Bullet graphs to determine recruiting efforts by using measures and dimensions data from SQL Server and MS Excel.
- Combined views and reports to show progressive recruitment data which includes applicants’ location, Demographics, number of interviews conducted and hired monthly over the course of the year into interactive dashboards in Tableau Desktop that were presented to Recruitment Managers, Executive board and End Users. Data was used to improve efforts to stay competitive in the casino market by recruiting efforts.
- Worked with the training team to build interactive dashboards for a team member opinion survey for the company to highlight engagement opportunities in the company. The survey included Team members Department, Employment Status and position, Ratings on a number of questions pertaining to the level of engagement, policies and procedures.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color - coded tabs etc. in Tableau 10.0 desktop/Server.
- Administered user, user groups, and scheduled instances for reports in Tableau
- Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
- Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
- Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
ENVIRONMENT: Tableau Desktop 2019.1.0, Tableau Server, Oracle, MS Excel
Confidential, DUBLIN, OH
BUSINESS INTELLIGENCE ANALYST
Responsibilities:
- Proactively involved in business meetings with the customers for understanding the as-is process flow and new business requirements or enhancement activities.
- Defined join conditions, table aliases and views for the user requirement.
- Developed a Framework Manager model by importing Meta data, preparing business logic, setting up object level security and developing and publishing package.
- Created standard filters, prompts, calculations and conditions in Catalog.
- Created various impromptu reports List, Cross-Tab and Drill through and power play Reports.
- Updated impromptu catalog by adding tables and creating new joins.
- Created various report studio reports using calculations, filters, prompts conditional formatting and drill through.
- Converted char fields to varchar fields and date functions.
- Migrated reports from Microsoft Excel and re-created them in Tableau Environment.
- Validated report results with the source data and authorized the reports to production environment.
ENVIRONMENT: Oracle 11g, Tableau desktop, Microsoft Excel, Power BI