Sql Server Data

Tableau Consultant with more than *+ years of experience in Tableau Server, Desktop and SSIS,SSRS/SSAS Developer.

Good Knowledge in Tableau administration/ Developer

Good Knowledge in Tableau working with different Enterprise data sources likes SQL Server, SSAS cubes, SAP HANA,Oracle, Google analytics and the Extracts (auto and Incremental.

Good knowledge in creation of dashboards and worksheets of KPI measurements for internal and customers use.

Good Knowledge in MS-SQL SERVER Database administration/ Developer.

Good knowledge in implementing high availability with alwaysOn availability Groups and failover clustering.

Good experience with Tableau APIs(Java script API, Data Extract API, Rest API)

Good Knowledge in installation and configuration of a core licensed and user based licensed Tableau Server (Simple configuration,3-Server and 5 Server cluster) and Desktop.

Good Knowledge in creating 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.

Good Knowledge in A/B Testing for studying website data.

Good knowledge in writing complex Excel Macros with Excel VBA for different Business Environments.

Good experience in detail-oriented financial analyst with hands hands-on experience in quantitative /statistical analysis, budgeting, accounting, and forecasting.

Different sources of web data extract from hadoop.

Technical Summary

Operating System: Windows Server 2008/2012

Visualization Tools : Tableau 7.0/8.0/9.3, R, Excel

Server : Tableau Server 9.1

Scripting Languages: T-SQL/ Power Shell

Internet Technologies: HTML, ASP.Net and XML.SharePoint

RDBMS: SQL Server and MS-Access.

DBA Tools: Idera, TOAD, Red Gate and MS-Team Foundation

A/B Testing

Web/Application Servers: IIS, WebLogic 8.1.

Data Warehouse Technologies: Erwin, SSAS, SSRS,SSIS.Hadoop

Education

Masters in Andhra University .

Project Overview

Luth Research Inc CA Jan 2016 to Dec 2016 Fl

.

Tableau Admin/Developer:

Responsibilities:

.

oImplement on Tableau Server with High Availability and Disaster recovery environment.

oBuilt Dashboards with floating objects and capitalizing the various dashboard actions features like filter actions, URL actions and Highlight actions.

oCreated users and user groups Scheduled instances for Tableau with Rest API.

oCreated action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

oBuilding, publishing customized interactive reports and dashboards, report scheduling using Tableau Server

oWorked on creating donut charts and pie charts.

oInvolved in creating Dual Axes bar charts with multiple Measures.

oCreated extracts published data sources Tableau Server, refreshed extract in Tableau Server from Desktop.

oMastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized using Tableau. Created report schedules, data connections, projects, groups in Tableau server.

oUsed Tabadmin and Tabcmd commands in creating backups and restoring backups to Tableau server.

oWorked on calculations, R functions, custom SQL, groups, bins, sets and other features of Tableau.

oCreated advanced connections, join new tables, create & manage extract and Monitor Queries using SQL assistant.

oExecuted and tested required queries and reports before publishing dashboards.

oConfigured data extraction by schedule to enhance performance.

Hardware: Windows 7, Windows 2008 Server, Linux and IBM Aix

RDBMS/DB: MS-SQL SERVER 2005/2008 R2/2012, Oracle 11g, DB2, MS-Access

Software: Erwin, ER Studio, Business Objects, Tableau, SSRS, SSIS Toad Database Tool

Humana Inc KY Oct 2013 to Dec2015

Project: Tableau Admin/Developer:

Responsibilities:

.

oCreated users and user groups Scheduled instances for Tableau.

oCreated action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

oBuilding, publishing customized interactive reports and dashboards, report scheduling using Tableau Server

oEffectively used data blending feature in tableau.

oInvolved in creating Dual Axes bar charts with multiple Measures.

oCreated extracts published data sources Tableau Server, refreshed extract in Tableau Server from Desktop.

oMastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized using Tableau.

oAdministered user, user groups, and scheduled instances for reports in Tableau.

oCreated report schedules, data connections, projects, groups in Tableau server.

oUsed Tabadmin and Tabcmd commands in creating backups and restoring backups to Tableau server.

oCreated Excel applications(VBA, Macros) to import historical data which multiple databases

oand perform various statistical analyses, charts and graphs.

oWorked on calculations, custom SQL, groups, bins, sets and other features of Tableau.

oCreated advanced connections, join new tables, create & manage extract and Monitor Queries using SQL assistant.

oExecuted and tested required queries and reports before publishing dashboards.

oImplemented SQL Server AlwaysOn with availability Groups and failover clustering.

Hardware: Windows 7, Windows 2008 Server, Linux and IBM Aix

RDBMS/DB: MS-SQL SERVER 2005/2008 R2/2012, Oracle 11g, DB2, MS-Access

Software: Erwin, ER Studio, Business Objects, Tableau, SSRS, SSIS Toad Database Tool

Shriram Group Mar2008 - June2013

SQL SERVER DBA/Developer

Shriram Group is a financial company which provide services like commercial vehicle financing, consumer and enterprise financing, retail stock broking,life insurance,chit funds. I worked in this project end user reporting. It can be analyzed using the different business dimensions. Data was extracted from SQL Server and Flat Files. Cleansed, Transformed & Loaded in a separated data base using SSIS. The Enterprise Data ware house was built to implement a centralized the database that collects and organizes and stores data from different operational systems, integrate historical data..This data is displayed in different reports on client management system reports. These reports are developed using SQL server reporting services.

Responsibilities:

o24/7 Support for MS-SQL Server DBA

oPerform traditional DBA functions with an emphasis on capacity planning, performance tuning, and problem resolution

oInstallation of MS-SQL Server 7/2000/2005/2008 and service pack and Fix bugs.

oT-SQL programming in MS-SQL Server.

oUsed Export, Import using DTS

oInstallation and configuration of MS-SQL Server, SSIS,SSRS and SSAS

oDesign, Development and configuration reports using SS Reporting Service(SSRS)

oWriting the Triggers, stored procedure and functions

oDatabase architecture and data modeling

oLayout data files, tables, indexes, etc., for performance

oDesign and develop the reports

oDesign database

oMonitor database and system performance

oApplication and database security (data access, passwords, network, etc.)

oEnd-user technical support / working with developers.

oBackup/Restore and Disaster Recovery procedures

oTesting. Optimized T-SQL/PL-SQL by analyzing query plans, modifying stored procedures,

indexes and table structures

oHardware: Windows 2008/2012.

oRdbms: SQL Server, MS-Access

Contact this candidate