DIVYA Email: ad3s0k@r.postjobfree.com

Sr. Tableau Developer/Data Analyst Phone: 512-***-****

Summary

12+ years IT experience including both the functional and technical sides of Data warehouse engagements and Experience with Business Intelligence Tools like Tableau, Power BI, MicroStrategy, Google Cloud, Crystal Reports, Cognos, Business Objects and Xcelsius.

Experience with Tableau, Power BI, Crystal Reports 2008/XIR2 and Cognos10/8 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection), MicroStrategy

Experience in SAS programming and in analysis and implementation of various projects.

Experience in working with Big Query in Google Cloud Process (GCP)

Profound knowledge on Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, Physical and Logical Data Modeling, Fact and Dimension tables

Over 7+ years of IT experience in Data Analyst, Data Warehousing and Business Intelligence applications.

Gather requirements from business users, created technical specifications and estimation documents.

Created different Interactive views in workbook to visually analyze data.

Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

Tableau development skill set including visualization development, use of parameters and report optimization.

Extensive knowledge in various reporting objects like Attributes, Hierarchies, Transformations, filters, calculated fields, Sets, Groups, Parameters etc., in Tableau.

Proficient with Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, Density Chart etc.

Experienced in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources

Experience with creating the Tableau dashboards with relational and multi-dimensional databases including Oracle, MySQL and Teradata, gathering and manipulating data from various sources.

Experience in Administering user, user groups, and scheduled instances for reports in Tableau.

Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.

Experience in to design and deploy rich Graphic visualizations with Drill Down menu option and parameterization using Tableau.

Security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication.

Experience in data extraction and transformation (ETL) using informatica power centre 8.1,8.6,9.1.

Extensive experience working in agile development and waterfall environment.

Extensive experience in dealing with a variety of relational Databases like Teradata, Oracle, DB2, and SQL server.

Experience in creating Stored procedures, Triggers, Functions, including the use of nested table expressions, unions, multi-table joins, scalar functions, outer joins.

Excellent communication and interpersonal skills.

Academic Background

Master of Science – Computer Science, Texas A&M University, Commerce, TX

Bachelor of Engineering – Computer Science, Osmania University, INDIA

Skills

Industry Experience: Finance, Retail, Public Sector, Energy, Telecommunication

Project Type / Discipline Experience: ETL Design/Implementation, Dashboard Development, Requirements Gathering, and Querying using SQL/Teradata/Big query

Technical Experience: Tableau Desktop, Power BI, SQL, Teradata SQL, Google Cloud Big Query, Cognos, Crystal Reports, SAS, SSRS, QlikView, MicroStrategy

Certifications

Tableau 10 desktop Qualified Associate

Scrum Master - SCRUM Alliance

Other

Presented at ATUG (Atlanta Tableau User Group)

White paper on “Tableau and Power BI: A Practical Guide”

Professional Experience

North Highland

Role: Sr.Tableau Developer/Data Analyst August’16– Present

Responsibilities:

Worked with Multiple Business Users to discuss and finalize Requirement.

Experienced in providing LOE for Agile development.

Worked with data modeling team and data Architect on logical data models.

Recognized source table to create views and aggregated tables for tableau dashboards.

Translate Business requirements to technical specifications documents.

Created different views in workbook to visually analyze data.

Designed and developed various analytic reports / dashboards using Tableau.

Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

Using Multiple Measures like Individual Axes, Blended Axes, Dual Axes

Used different Mark types and Mark properties in views to provide better insights into large data sets.

Created External filter, internal filter and Context filter to improve performance.

Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.

Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.

Created parameters and quick filters. Created sets to display top products based on their sale.

Created actions in Worksheets and Dashboards for interactivity and to compare data against different views.

Involved in preparing the estimation documents, design document for new reports that are to be developed and involved in preparing the impact analysis document for a change that is imminent.

I was responsible for designing the architecture and developing solutions for multiple Tableau and Power BI dashboards. This involved leveraging my expertise in data visualization to create effective and meaningful visual representations of data.

Did the wireframes to present to the users before actual development of the dashboards.

Worked diligently individually and as team member to consistently reach client satisfaction levels.

Played critical role in establishing best practices for tableau reporting by conduct meeting with the clients for gathering reporting requirements, identify the KPI’s and developing POC Dashboards.

Developed Complex dashboards and used advance chart visualizations in Tableau like Pareto Chart, Dual Waterfall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to created summary level and detailed Reports.

Worked closely with the ETL Team to set standards on SLA’s for daily and weekly refresh.

Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.

Worked on database migration from internal excel files to SAP BO.

Developed Landing Page for all the reports and authored user guides of Tableau and Power BI reports for the user community.

Translated all the key processes from Teradata to Google Cloud Process (GCP). This will include all SQL processes, reporting, and data science.

Developed a fully automated self-service clustering tool using integration of Tableau and R that groups store with similar patterns and provides meaningful price recommendations that will optimize units, sales, and overall profitability by identifying the optimal number of Clusters for each unique THD Category.

Establish a self-service future state monthly reporting package which allows end users to report key metrics across the organization, filterable at the Enterprise, SVP, MVP levels

Resolved various performance issues and analyzed the best process distribution for different projects.

Assisted power users in Tableau dashboard development.

Handled Migration process and UAT testing coordination with users.

Express thoughts and ideas clearly and effectively with excellent communication skills. I facilitated important client meetings and successfully gained alignment from multiple groups of stakeholders. Working with a cross-functional team with differing priorities and potential conflicts, I utilized my coaching skills to guide the team towards consensus and sound decision-making.

Environment: Tableau (Desktop/Server), Orcale 18c, SAP BO, Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint),Google Cloud, R Server, Power BI.

Advance America Cash Advance Centers, Spartanburg, SC

Role: BI Reporting Analyst April’11 – August’16

Responsibilities:

Interacted with Business users to understand the requirements, layout, and look and feel of the application to be developed.

Involved in installing and upgrading Tableau server and server performance tuning for optimization.

Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.

Worked extensively with advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.

Created Data marts using SAS for tableau dashboards.

Created alerts against tableau dashboards and different data sources using Metric Insights.

Involved in all phases of Data Warehouse development lifecycle and implementation.

Converted various legacy performance reports to Tableau from Cognos/Crystal using newly implemented DWH

Involved in Installation/Configuration/Administration/Troubleshooting/Tuning of Cognos 10 Environment

Developed and Published Packages in Framework Manager.

Created Executive Operational Dashboards and cross tab reports using Cognos Report Studio for various business users.

Worked along with DBA/ETL Datastage Developers to identify the source data and recommend any ETL development

Worked on crystal complex reports that require running totals, sub-totals, sub-reports, hierarchies, crosstab, multiple groups and conditional display of groups, fields, and messages

Experience in transforming complex business logic into Database design and maintaining it by using SQL functionality such as Stored Procedures, User Defined Functions, Views, and ETL.

Document business rules for all report outputs and use those documents as a basis for configuration management

Involved in various stages report testing including Unit testing, Integration testing and User Acceptance Testing

Supervised Intern/Jr. Report developers.

Environment: Tableau 9/8.2/8, Metric Insights, SAS, Crystal Reports XI, Crystal Report viewer, Cognos 10.1/10.2/8.x, Oracle 9i/10g, PL/SQL, SQL Server 2008, TOAD, SQL Developer, IBM Data stage 8.1, Windows 2000/XP.

Greenville County School District, Greenville, SC

Role: BI Report Developer March’10 – March’11

Responsibilities:

Involved in gathering requirements from end Business users and translating these requirements into actual reports

Worked as Business Intelligence Administrator deleing data settings, giving permissions to view/print/export data and created different user groups

Worked on data filtering by maintaining the bursting options, customize selection formulas, maintaining parameters, checked report actions for different users of that report

Involved in conversion/upgrade of Reports from Crystal Reports Version XIR2 to Crystal Report 2008

Developed General Ledger, receivable/payable, trial balance, bank/cash book reconciliation reports and all financial statements

Created various reports like the Combined Queries, Drill Down, Cross Tab, Master Detail to make the reports easier for analysis

Created reports based on stored procedures, base tables, and commands

Created complex Business Objects reports using user defined functions, condition objects and aggregate awareness functions for SQL enhancement

Used Microsoft Visual SourceSafe to Maintain Multiple Versions of a Project

Used Xcelsius to create reports containing complex charts to present the end users with a better graphical representation of the data

Developed Stored Procedures, PL/SQL Packages, Functions, Triggers, Views and Cursors

Involved in Unit testing, System testing and User Acceptance Testing

Environment: Crystal Reports XIR2/2008, Business Object XIR3/XIR2, Xcelsius, SQL Server 2008/2005, Oracle 9i/10g, SQL, PL/SQL, TOAD, Windows 2000/XP.

Texas A&M University, Commerce, TX

Role: Database Developer Jan’08- Dec ‘09

Responsibilities:

Involved in gathering customer requirements and functional requirements and converting them to technical requirements

Implemented all the requirements by writing PL/SQL stored procedures, Packages, and triggers

Involved in fine tuning stored procedures by making use of PL/SQL Collections and its Bulk Fetch and Bulk Insert features

Extensive skills in analyzing data using pivot tables and VLOOKUP.

Involved in design and development of data validation, load process, error control routines

Optimized various SQL and PL/SQL statements using Indexes, Hints and Explain Plan

Used SQL loader and external tables to load data from text files into the database

Participated in the DBA role like creating users, granting, and revoking privileges on database objects and taking backups

Worked on application Testing, Deployment, and Production Support

Compared Production data with Test data for identifying and cleaning corrupted data

Environment: SQL Server 2008 R2/2008/2005, PL/SQL, Flat Files, TOAD, MS Visio, ETL transformations.

ESN Technology, Hyderabad, India

Role: SQL Developer Jan’07- Dec ’07

Responsibilities:

Installing, configuring, tuning, and providing 24X7 support for SQL Server 2000 and 2005 in development environment

Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request

Created Database Diagrams using Erwin Data Modeler

Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Prepare daily report on the job failures, backup failures and disk space

Environment: SQL Server 2005/2000, Windows 2003, Query Analyzer, DTS, ERWIN

Honors

Full Tuition Assistantship, Housing scholarship, Texas A&M University, Commerce, TX

Contact this candidate