SUMMARY

• Over 7+ years of experience in Business Intelligence, Consulting, Data analytics and Reporting.
• Extensive experience in working withTableauDesktop,TableauServer in various versions of Tableau9.0.3, 8.1.6, 8.0,Tableau7 and Tableau6.
• Expertise inTableauAdminactivities andTableauserver maintenance for a high number of projects/ users and content.
• In - depth knowledge onTableauDesktop,TableauReader andTableauServer.
• Experience in Installation, Configuration and administration ofTableauServer in multi-server and multi-tier environment
• Expertise in Automation of backup and logs maintenance onTableauserver
• Installed and configured Tableau Server on AWS, integration with active directory for Single Sign-On, SAML, SSL and Kerberos
• Hands-on experience in Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies inTableau.
• Experience in Administering user, user groups, and scheduled instances for reports inTableau
• Worked asTableauServer Administrator andTableaudesktopdeveloper
• ExtensiveTableauExperience in Enterprise Environment andTableauAdministrator Experience including technical support, troubleshooting, report design and monitoring of system usage
• Working knowledge in Windows Servers, API, Network technologies withActiveDirectory, SAML for authentication
• Hands-on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop versions 8.0, 8.1 and 8.2.
• Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Experienced in troubleshooting and performance tuning of reports and resolving issues within Tableau Server.
• Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
• Restricted data for particular users using Row levelsecurityand User filters
• CreatedTableauDashboards with interactive views, trends and drill downs along with user level security
• Data Visualization expert on technologies like Tableau, MicroStrategy, Spotfire and has gained expertise in these years in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth.
• Involved in several Visualization projects and led the development of projects and gathered several accolades from the client.
• Sound knowledge of the entire SDLC.
• Fast paced learner, quick solution provider and have worked under tight timelines and always deliver to the delight of the client.
• Reach continuous delivery and Build clouds with Openstack, AZURE and AWS
• Develop suitable AZURE & AWS-based and Hybrid solutions based on customer requirements knowledge onHadoopand Cloud
• Established Best Practices for Enterprise Tableau Environment and application intake and Development processes.
• Built and expanded reports available for both internal support and external customer reports, which included increasing the scope of data extracted and better utilization of reporting.
• Successful as a team player to work in conjunction with other DBA's, testers,developersand other team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects especially with various Test suites.
• Ability to manage multiple and varied tasks with enthusiasm, deal with tough and demanding work priorities, prioritize workload with attention to details
• Flexible to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

BI Tools: Tableau, Business Objects, SSRS, CognosRelational Databases MS SQL Server 2005/08/10/12, Oracle 8i/9i/10g/11g, Teradata, Vertica, MS Access.

Tools: and Packages: SQL Server Management studio, SSIS Toad, Profiler, Microsoft Visual Studio.

Languages: SQL, PL/SQL, C, HTML, XML

Operating Systems: Windows 9x/XP/2000/Vista/7, Unix

Hadoop/Big Data: HDFS, Mapreduce, HBase, Pig, Hive, Sqoop, Flume, MongoDB, Cassandra

Configuration Management Tools: Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Tableau Admin

Responsibilities:

• Installed and configured Tableau Server and Tableau Desktop.
• Upgraded Tableau Server from Tableau 8.1.6 to Tableau 9.0.3 version.
• Installed and configured Tableau Server on AWS, integration with active directory for Single Sign-On, SAML, SSL and Kerberos
• Created a multilingual report for different region users with a workaround on the same sheet (for both server and reader), tableau software was impressed with the robust workaround and are now saving the workaround in their knowledge base.
• Involved in POC's with memsql Database, Kognitio Database to get the better performance on the workbooks.
• Implemented security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication
• Secured Tableau server to protect the Tableau environment, security group and AWS Direct Connect
• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement
• Implemented Data LevelSecurityfor different Groups and Users
• Implemented Automation of Tableau Backup on weekly basis and Automation of Tableau Logs on Daily Basis and stored them in separate folder automatically.
• Created batch scripts for scheduling the refresh/ dataextracts using Task scheduler.
• Extensively Used Data Blending to Join Multiple Data Sources.
• Connect to a variety of databases like SAP HANA, Hive, Vertica, Teradata, etc
• Experience in creating complex Dashboards using Parameters, Filters, Sets and Groups.
• Created Custom Admin Views for the server Using Postgre SQL Database to track detailed view of usage, user activity, server activity etc.
• Best practices in order to save onIDPservice provider and data security
• CreationIDPmetadata files, snapshot logs, scheduling tasks, enabling SMTP alerts etc.,
• Provided production and admin support of Tableau BI reporting solutions
• Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation
• Analyzed, troubleshoot and / or tune product performance or deployment issues when required
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks as Tableau Administrator
• Administered user, user groups, roles, permission setup, Management etc
• Did performance turning in tableau to improve report response time.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Created ODBC connection, DSN to connect to Kognitio database since the native drivers doesn't support
• Created Forecasted Reports For the Upcoming Year to Observe Trends in Tableau
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Used Vertica as a datastage for all end-client data to be processed/pre-aggregated to be Qlikview/Tableau ready
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Conducted Performance Testing and solved potential Bottlenecks.

Environment: TableauDesktop 7.0, 8.1.6Tableauserver 7.0, 8.1.6, 8.3, 9.0 MapR Hadoop Hiveql, IBM Netezza, Kognitio ODBC, AWS, Oracle DB, Teradata, Vertica, Hadoop, Active Directory, Microsoft SQL Server, SQL, PL/SQL, T-SQL Microsoft Excel 2007, MS Access, Windows 07/08 server, Microsoft office 2007, Business objects 4.0.

Confidential, Austin, TX

Tableau Admin

Responsibilities:

• DevelopedTableaudashboards according to user specifications
• Worked on tableau server for AWS.
• Created report on Cloud Based Environment using Amazon Web Services(AWS) and published on Tableau Online
• Installed and configured Tableau on Cloud (Amazon AWS).
• Secured Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and AWS Direct Connect.
• Extensively used Data Blending techniques in dashboard development
• Supported different user groups and business domains
• Good knowledge oftableauserver, administrative functions, installation, configuration, back up of servers and load balancing techniques
• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement
• Implemented Data LevelSecurityfor different Groups and Users
• Defined architecture forTableau- establish Dev/QA/Prod environments
• Responsible for security configuration including user/ group setup, permissions, security roles, configuration of trusted ticket authentication
• Setup new projects, security groups, roles and administer users for all supported platforms
• Administered user, user groups, and scheduled instances for reports inTableau
• Monitoring ofTableauServers for its high availability to users
• Worked onTableauServer upgrades for new versions
• ProvidingTableauDemo's to new on boarding users
• Developed worksheets and data visualization dashboards with graphs and filters
• Created report schedules onTableauserver
• Develop monthly reports and dashboards
• Created calculated fields as per business requirement
• Defined best practices forTableaureport development
• Used Tabadmin and Tabcmd commands in creating and restoring backups ofTableaurepository
• Involved in Production support forTableau.

Environment: Tableau Desktop, AWS, Oracle, Hadoop, Teradata, SQL, Active Directory, Windows, Linux, UNIX, Tableau server / Administrator, SQL server 2008.

Tableau Admin/Developer

Responsibilities:

• Involved in defining the project life cycle, following RUP methodology.
• Developed a vision plan that defined the primary goals and objectives of the project. Analyze business requirements and segregated them into high level and low level.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Assisted Project Manager in developing design and specification, according to the requirement and information gathered during JAD sessions and other forms of information gathering methods.
• Used Data Warehouse Architecture and Design - Star Schema, Fact and Dimensional Tables, Physical/Logical Data Modeling and data flow diagrams.
• Worked on Developing a Data mart for dealer sales connect and developed SQL views on the mart to facilitate BI reporting on the same.
• Worked on Tableau Dashboards in Tableau 8.1.
• Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Extensively worked on creating calculated fields and Analysis depending on the user requirements.
• Extensively used advanced filtering capabilities for creating Dashboards.
• Extensively worked with Teradata SQL Assistant, Teradata Administrator for running different queries.
• Find ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau, Tableau Server/Administrator, Active Directory, Linux, Windows, Teradata, SQL, PL/SQL, Teradata SQL Assistant, SQL Developer, DB2, Oracle, SQL Server, MS Project, Control-M.

Confidential, Minneapolis, MN

BI Developer

Responsibilities:

• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Strong performance, diagnostic, and query tuning skills.
• Involved in creating ER Diagram, Data Architecture design, Data modeling.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2008.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008).
• Designing SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel, and Access to MS SQL Server.
• Handled slowly changing dimensions to maintain the history of the data.
• Optimized indexes, SQL queries and stored procedures to improve the quality of the software.
• Design, review, and create primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Developed Ad hoc reports for the clients as per their requirements using SSRS.
• Variance reports using Reporting Services (SSRS).
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Responsible for taking data objects across different databases: Development -Test - Production.
• Created trace in SQL Profiler and used Data-base engine tuning advisor for Performance tuning on stored procedures and script.

Environment: MS SQL Server 2005, Windows Server 2003, Active Directory, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), Team Foundation Server, MS-Visual Studio, VSS