Business Analyst Sql Server
Resume:
Revati Anagolu
Email: *********@*****.***
Ph#: 864-***-****
Professional Summary:
Over 8+ years of extensive experience in design and develop Workbooks, Reports and interactive Tableau dashboards using Tableau Desktop version and Tableau Server.
Experience in Tableau features - Clustering, Level of Detail expressions, Parameters, Sets, Groups, Forecasting, viz in a Tooltip, Data Blending etc.
Experience in building Calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting) using Tableau Desktop.
Extensive experience on building dashboards using Tableau and involved in requirements gathering/analysis, design (Mock ups, Proto types, frame works), development, testing and production rollover of reporting and Analysis projects.
Experience in solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
Hand on experience in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
Extensive experience creating canned and ad - hoc reports in Tableau Desktop.
Experienced in creating aggregates, hierarchies, charts, filters, quick filters, table calculations, trend lines, calculated measures in Tableau Desktop.
Experience in creating various visualizations in tableau for dashboards using tableau various charts and graphs.
Experienced on Tableau activities, Multidimensional database and writing SQL queries.
Experience in writing SQL reporting skills with the ability to create SQL views and write SQL queries.
Experience in implementing agile methodology (SRCUM) in the projects which involved daily SCRUMS.
Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
Technical Skills:
BI/Visualization Tools
Tableau server 2024.3, Tableau Reader 2024.3.0, Tableau Desktop 2023.1, Micro strategy, Tableau Public 9.2.
Programming
Java,.NET, XML & HTML, SQL, PL/SQL
Utilities
MS Office Suite, MS SharePoint, MS Project, TFS
Databases
Snowflake, DB2, Oracle SQL Server 2012/14/16/17, MS-Excel.
OS Platforms
Windows Server, Windows
Data Modeling tools
Power Designer, Erwin, ER Studio, MS Visio.
Professional Experience:
Client: Confie, Farmers Branch, TX. Mar 2023 – Till date
Role: Business Analyst
Responsibilities:
Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.
Designed and developed interactive dashboards for ADT Security Alarm System, tracking key operational metrics such as Early Open, Late Open, Early Close, Late Close, Store Adherence, Store Conformance, and Operational Status across individual store locations.
Built a comprehensive HR Turnover Dashboard to visualize workforce dynamics, including Active Employees, Terminated Employees, Monthly Turnover, and Year-to-Date Turnover trends.
Extracted, cleaned, and blended data from multiple sources including Excel, SQL databases, and published Tableau data sources to create unified, accurate data models.
Enhanced dashboard functionality and interactivity using filters, parameters, calculated fields, and Level of Detail (LOD) expressions in reports such as HR Turnover and Policy Retention.
Translated complex datasets into clear, actionable insights using a variety of visual techniques including charts, Donut chart, calendar chart, heatmaps, maps, and trend chart(Daily, weekly and monthly trend) and custom charts to support business decisions.
Published and maintained Tableau workbooks on Tableau Server, ensuring secure, role-based access and real-time data visibility.
Scheduled and monitored extract refreshes to maintain timely data updates and accuracy across multiple dashboards.
Set up automated email subscriptions and alert schedules, delivering insights to stakeholders on a recurring basis or based on data-driven triggers.
Optimized dashboard performance, achieving up to a 40–60% reduction in load times, improving usability and increasing adoption across teams.
Developed scalable, visually consistent dashboards supporting domains such as Operations, HR, and Compliance, aligned with key business KPIs.
Experience in writing SQL queries,complex join,views,CTE.
Worked in Agile environment and involved in Conducting scrum meetings
Environment: Tableau Desktop 2023.1, Tableau Server 2024.3, Snowflake.
Client: Synovus, Columbus, GA. Sep 2021 – Feb 2023
Role: Tableau Developer
Responsibilities:
Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.
Designed, developed, and maintained reports and multi - level dashboards in Tableau.
Built interactive dashboards and stories using Tableau Desktop for accuracy in report generation applying advanced tableau functionality: parameters, actions and tooltip changes.
Worked on designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
Involved in building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Developed different strategies for improving the performance of Tableau reports.
Defined best practices for Tableau report development and effectively used data blending feature in tableau.
Developed Tableau reports include highlight tables, stacked bars, side by side bars, symbol maps, filled maps, heat maps.
Optimized current pivot table reports using Tableau and proposed an expanded set of views in the form of interactive dashboards using line graphs, bar charts, heat maps, tree maps, trend analysis, Pareto charts and bubble charts to enhance data analysis.
Worked on editing data connections and changing data sources in Tableau.
Worked with R functions and R models in Tableau.
Worked with multiple data sources joins in Tableau Desktop.
Created calculated fields, action filters and parameters in tableau dashboards and worksheets.
Created SQL queries for data extraction and transformation to make certain that the data is properly extracted for building Tableau dashboards.
Involved in Agile Scrum Meetings and Tableau Development with internal and external clients.
Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.
Environment: Tableau Desktop 2021.2, Tableau Server 2021.2, MySQL, ETL, SharePoint, SQL Server and Windows.
Client: PNC Bank, Pittsburgh, PA. Apr 2020 – Aug 2021
Role: Tableau Developer
Responsibilities:
Interacted with stakeholders to understanding of the business objectives and gather functional requirements.
Defined tableau standards, best practices for design and development performance considerations, do’s and don’ts in collaboration with tableau professional services.
Designed and developed Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently.
Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
Used techniques like data blending which brings data from multiple data sources into a single view in Tableau.
Embedded Tableau Dashboards into web pages.
Created Custom Hierarchies to meet the Business requirement in Tableau.
Converted pre-existing Excel based reports to Tableau dashboards.
Created Backup scripts to take periodic backups for the content on Tableau server.
Created groups and users in Tableau server.
Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions, Table calculations and LODs.
Utilized Tableau server to publish and share the reports with the business users.
Extracting the data tables using custom generated queries from Excel files, SQL database and providing extracted data as an input to Tableau.
Created SQL Queries for testing the tableau Dashboards, created the dimensions, hierarchies, and levels on Tableau.
Worked on Agile methodologies.
Scheduling the monthly/weekly/daily reports to run automatically.
Environment: Tableau Desktop 9/10, Tableau Reader, Tableau server, Oracle, SQL, Flat files, SQL server, MS-Excel, Statistical files, Microsoft access and Extracts.
Client: Emblem Health, New York, NY. Feb 2019 – Mar 2020
Role: Tableau Developer
Responsibilities:
Getting the requirements from business and creating the design documents for Tableau.
Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
Created Rich dashboards using Tableau Dashboard by Building, publishing, scheduling reports and dashboards using Tableau server.
Designing/Build/Integration complex dashboards taking advantage of all tableau functions including data blending, actions, parameters, Filters etc.
Developed, maintained and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
Developed new reports and enhancing existing reports in Tableau environment.
Used data blending, embedded functionalities in Tableau by defining best practices for Tableau report development and effectively used data blending feature in tableau.
Involved in developing Tableau reports dealing with predictive results from analytical trending and modeling
Created users and managed permissions for the content (Projects, Workbooks and Views) on Tableau Server.
Created advanced Tableau dash boarding to present the Box usage on time bases.
Created different visualizations by using Tableau Desktop for analysis using actions.
Involved in creating dashboards and reports in Tableau and Monitored server activities, user activity and also customized views.
Used Tableau Extensions to integrate data with other applications.
Preparing Dashboards using calculations, parameters in Tableau and Developing Tableau reports that provide clear visualizations of various industry-specific KPIs.
Validated the reports before publishing reports to Tableau server, troubleshoot Tableau reports, dashboards, etc.
Writing SQL queries for data validation of the reports and dashboards as necessary.
Worked in Agile environment and involved in Conducting scrum meetings.
Environment: Tableau Desktop 10.x/9.x, Tableau Server 9.x, MySQL, SharePoint, SQL Server.
Client: TJX, Framingham, MA. Aug 2017 – Jan 2019
Role: Tableau Developer
Responsibilities:
Involved in reviewing business requirements and analyzing data sources for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
Involved in developing the reports in Tableau environment.
Involved in creating and developing the Tableau dashboards and publishing to the Tableau Server.
Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
Involved in connecting to various data sources from Tableau Desktop and creating different types of reports, visualizations and dashboards as per the business needs.
Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau.
Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
Complied interactive dashboards in Tableau Desktop and published them to Tableau Server.
Created report schedules on Tableau server.
Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
Environment: Tableau Server, Tableau Desktop, MYSQL Server, MS SQL Server, Oracle.
Contact this candidate