Livecareer-Resume

Bi Data Analytics Consultant Resume Example

Love this resume?

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Jessica Claire
, , 100 Montgomery St. 10th Floor
Home: (555) 432-1000 - Cell: - resumesample@example.com - -
Summary
  • Around 6+ years’ experience working in IT Industry with SQL/BI developer and Tableau report services document delivery.
  • Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Involved in full life cycle implementation, which includes Gap Analysis, Requirements Gathering, Development, Testing, Reporting, Go-live and Reconciliation.
  • Experience gathering client requirements, writing test cases and collaborating with developers to guarantee full understanding of internal/external client needs and delivering training to others on the utilization of Tableau.
  • Designed, developed, and maintained reports and multi-level dashboards in Tableau.
  • Experienced as a Data Analyst and in transforming client requirement documents into business requirement documents.
  • Developed Tableau workbooks to perform Year over Year, YTD, QTD and MTD type of analysis.
  • Working knowledge on optimizing the overall performance of dashboards with the aid of the usage of Tableau Performance Recording feature.
  • Proficient in data visualization, Reporting and Analysis using Bar Charts, Line Charts, Tree Maps, Pie Charts, Heat Maps, Scatter Plots, Dual Axes, Geographical Maps in Tableau Desktop.
  • Using Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, SQL Assistant, Data mover).
  • Created Tableau Scorecards, Dashboards, Heat maps using show me functionality.
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
  • Extensive knowledge in Dimensional Data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling.
  • Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 7.x ,8.x,9.x,10.x
  • Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps. Effectively used Data blending feature in Tableau.
  • Expertise in technologies like Data Warehouse (DWH), Data Visualization and Business Intelligence Concepts and BI Tools.
  • Highly proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
  • Experienced in all aspects of Software Development Life-Cycle (SDLC) from inception to delivery including requirements gathering, use cases, functional specification, design, estimation, implementation and debugging, documentation and maintenance.
  • Expertise in Business Intelligence (BI)/ data warehouse (DWH) concepts, designs, SSRS/SSAS, and project implementations.
  • Good knowledge of data warehouse (DWH) Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
  • Hands on installing, using and troubleshooting various software applications.
  • Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR
  • Good knowledge on C, C++ programming language, DBMS, RDBMS and Visual basic concepts.
  • Worked with Different Databases like DB2, Teradata, Oracle, Microsoft SQL Server, Microsoft Access databases, Excel Spreadsheet etc.
  • Hands on experience on Tableau Server administration.
  • Able to work independently has a good interaction with team members.
  • Good at understanding the client requirements and giving best solutions.
Skills

Databases: MS-SQL Server 2012/2008R2/2008, Oracle 12c/11g/10g/9i

Tools : SQL Server integration Services (SSIS), Microsoft SQL Server, SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS), SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Enterprise Manager, Data Transformation Services (DTS), DTSX, Team Foundation Server (TFS), Power Pivot (2013), Toad 9.0, Tableau 9.0/8.x, SAS 11.0, Rally, Version One.

Languages :T-SQL, SQL, HTML, C#, .Net, P-SQL, C, C++

Data modeling Tools :ERWIN r7/r4, MS Visio 2007

Operating System :Windows 7.0/ Vista/ Xp /2003/2000/NT/9

Experience
11/2019 to Current
BI/Data Analytics Consultant Amsted Industries Incorporated Kansas City, KS,
  • Actively participate in initial and review meetings with business users to ensure that the development of projects meets business and system requirements for design development testing and production rollover of reporting and analysis projects within Tableau Desktop.
  • Involved in testing the SQL Scripts for report development, Tableau Dashboards, Scorecards and handled the performance issues effectively.
  • Tested dashboards to ensure data matched as per the business requirements and if there were any changes in underlying data.
  • Worked with business stakeholders and participated in requirement gathering sessions to understand the business needs.
  • Responsible for creating dashboards and overall creation of data visualizations.
  • Communicate with internal clients to develop and translate a business requirement into a practical and insightful interactive analytical dashboard.
  • Quickly and effectively diagnose and respond to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards.
  • Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL Server, oracle, spreadsheets, etc.).
  • Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, and Density Chart.
  • Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets, and hierarchies, etc.
  • It is used Oracle, SQL server as data sources for designing Tableau Reports and Dashboards.
  • Generating tables employing various SAS data steps and procedures with Statistical SAS procedures, graphs, and plots.
  • Provided customer support to Tableau users and Wrote Custom SQL to support business requirements.
  • Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI), and Measure.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
  • Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Published Workbooks by creating user filters so that only appropriate teams can view it.
  • Developed various dashboards, used context filters, sets while dealing with huge volume of data.
  • Generated dashboard for Finance team, provided security by using user filters.
  • Created adhoc reports to users in Tableau by connecting various data sources.
  • Building, publishing customized interactive reports and dashboards and report scheduling using Tableau server.
  • Expert level capability in Tableau calculations and applied complex, compound calculations to large, complex data sets.
  • Involved in Planning, Defining, and Designing data based on business requirements and provide documentation.
  • Performed Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server, including weekly data dump.
  • Created Schedules and extracting the data into Tableau Data Engine.
  • Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.
  • Created and implemented Tableau best-practices on migrating and governing the dashboards in multiple environments.

Environment: Tableau Desktop (2020.3, 10.3 & 9.3), Tableau Server, SQL Server 2012, IBM DB2, MS office 2007, MS Access.

09/2017 to 10/2019
Sr Tableau Developer/Administrator Booz Allen Hamilton Inc. Tampa, FL,
  • Worked on creating dashboards in Tableau by querying various ODBC connections such as Oracle and SQL Server.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality and publishing them to tableau server and tableau Online.
  • Involved in full project lifecycle of SDLC and coordinated with all project teams.
  • Worked on setup and configuration of Tableau Server and used Tableau CMD and Tableau Admin tools for server configuration.
  • Used Tabjolt for performance testing in Tableau Server.
  • Documented all statistical findings and presented insights to management in the structure of Tableau stories.
  • Involved in Agile Scrum Meetings and Tableau Development with internal and external clients.
  • Analyzed large and multidimensional datasets for data analytics using SAS and Excel.
  • Developed systematic solutions for data clean-up using data mining techniques.
  • Created users, groups, projects, Data connections, settings as a tableau administrator.
  • Worked with R functions and R models in Tableau.
  • Manage the application's users, groups, and integration with Active Directory.
  • Experience in writing SQL reporting skills with the ability to create SQL views and write SQL queries.
  • Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
  • Integrated R with Tableau and utilized RServe package to perform deep statistical analysis.
  • Extensive use of advanced filters, groups, actions, complex calculations in Tableau Desktop.
  • Created presentations to communicate findings and offer recommendations to management and external audiences using Tableau.
07/2016 to 08/2017
Tableau Developer K12 Inc City, STATE,
  • Work with end users to gather requirements, overlaying an analytics perspective
  • Create sustainable and efficient visualizations, emphasizing usability and good design practices
  • Test and monitor the underlying data, assuring quality and optimizing the data view that dashboards use
  • Understand the techniques used in visual reporting.
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS
  • Involved in writing T-SQL stored procedures, functions for generating various customer review SSRS reports.
  • Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
  • Involved in using TFS to check in and check out SSRS reports.
  • Fine Tuned Data Warehouses including the creation of materialized views, bitmap indexes and partitions
  • Performed Query optimization & Performance Tuning.
  • Optimize queries using SQL profiler and Database engine tuning advisor.

Environment: SQL Server 2012/2008 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (BIDS), SSIS, SSRS, TSQL, Tableau 10.2, SQL Server 2106, SAS 11.0, C++, Teradata 12.

10/2013 to 11/2014
Data Analyst IGATE Global Solutions City, STATE,
  • Experienced in creating SQL queries and optimizing the queries in SQL Server.
  • Generated Reports on Weekly, Monthly, Quarterly Basis.
  • Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP
  • Responsible for tuning and Optimizing Queries for the reports.
  • Expert in SQL Server Management Studio interface for writing queries and stored procedures.
  • Created database objects like views, indexes, user defined functions, triggers and stored procedures.
  • Responsible for trouble shooting the reports.

Environment: Visual Source Safe, Windows 2000 operating system, Microsoft SQL Server 2000 server, Microsoft Excel, Microsoft word, C, C++.

Education and Training
Expected in 06/2016
Master of Science: information system technology
California University of Managements And Sciences - Arlington, Va,
GPA:
Expected in 05/2013
Bachelor of Science: Electronics And Communication Engineering
Prathyusha Institute of Technology And Managements - Thiruvallur, Aranvoyalkuppam, Tamilnadu,
GPA:

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Disclaimer
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

75Average

Resume Strength

  • Length
  • Measurable Results
  • Personalization
  • Target Job

Resume Overview

School Attended
  • California University of Managements And Sciences
  • Prathyusha Institute of Technology And Managements
Job Titles Held:
  • BI/Data Analytics Consultant
  • Sr Tableau Developer/Administrator
  • Tableau Developer
  • Data Analyst
Degrees
  • Master of Science
  • Bachelor of Science

Similar Resume

View All
Sr BI Data and Analytics Manager
Data Analytics Consultant
Data and Analytics Consultant