We provide IT Staff Augmentation Services!

Business Intelligence Analyst Resume

Dallas -, TX

SUMMARY

  • Over 10 years of Experience in Designing, Administration, Analysis, Management in the Business Intelligence tools like Tableau, SAP Crystal reports and SQL Server.

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst

Confidential, Dallas - TX

Responsibilities:

  • Performed extensive GAP analysis in the tableau project as there were numerous 'As-Is' and 'To- Be' conditions.
  • Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
  • Great ability to create and manage various database objects like tables, views
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Restricted data for particular users using Row level security and User filters.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Developed Tableau workbooks from multiple data sources using Data Blending.

BI Project Manager - Tableau

Confidential

Responsibilities:

  • Gathered requirements from the stakeholders in various departments who are using MS Access database.
  • Documented each MS Access database functional and technical requirements which needs to migrate to Tableau for reporting purposes.
  • Used Tableau software to build analytical reports and dashboards.
  • Built comprehensive workbooks, views and dashboards using Tableau 10.4x.
  • Maintained adequate communication with project team, explaining progress and potential roadblocks on the development’s effort.
  • Supervising other two BI Developers in team.
  • Responsible for successful delivery of the solution and contributed to continual improvements to reports and dashboards.
  • Used Toad to finetune SQL queries from MS Access to Oracle.
  • Worked with various data sources to extract the data for reporting purposes like MS Access, Oracle.
  • Comparing MS Access to Datawarehouse for missing tables and worked with various teams to extract and loading data into existing Datawarehouse.
  • Trained users on updating and using reports and dashboards.

Environment: BI Applications, Tableau 10.4,10.6 Windows 10, SQL Server 2012, Oracle 11g/12c, Toad Data Point,Excel, MS Access.

Business Analyst - Tableau

Confidential, Birmingham, AL

Responsibilities:

  • Involved in translating the business questions and business requirements to actual and final dashboard technical requirements
  • Used Tableau for the data / business predictive analysis, for trending, for finding the pattern of data over the period of time
  • Building the customized and interactive dashboards using multiple data sources
  • Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created worksheets and dashboards by using custom queries and multiple tables.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Effectively used data blending feature in tableau.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Executed and tested required queries and reports before publishing.
  • Developing Standard and Create reports using Tableau Desktop.
  • Creating DB views for the reporting purpose.
  • Preparing Report Mapping Documents as per Specifications.
  • Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
  • Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
  • Mentored business power users to create reports/dashboards using tableau desktop.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.

Environment: BI Applications, Tableau 8.1/8.2/9.0, Windows 7, SQL Server 2012, Oracle 11g/12c, Excel, MS Access.

Hire Now