SUMMARY:

• Overall 9+ years of experience in the IT Industry and worked on Tableau Desktop, Tableau Server and efficient in connecting various data sources.
• 7+ years of extensive data analyst, Tableau Experience in Enterprise Environment, in Tableau 10.5/10.3/10.1/ 9. x/8.x/7.x as a Developer and Admin.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color - coded tabs etc. in Tableau 10 desktop/Server.
• Developed Tableau Data extracts from the above mentioned data sources using Pentaho Data Integration ETL tool.
• Hands on learning with different ETL tools to get data in shape where it could be connected to Tableau through Tableau Data Extract.
• Secured Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and AWS Direct Connect.
• As a Tableau Administrator, specializing in Server Worker Nodes Installation & Configuration. Setting up Tableau Primary and Worker Nodes (drivers, patches, command line utilities, etc.)
• Disaster Recovery setup, including Backup Primary setup and configuration.
• Developed POCs by building reports and dashboards using Tableau 10.1 to demonstrate quick wins.
• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement.
• Experience in the maintenance and scheduling of Tableau Data extracts using Tableau server and the Tableau Command utility.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Working knowledge of ODBC, OLEDB, T-SQL, SQL, PL/SQL, Teradata, Stored Procedures, Functions, Packages, Triggers, and scripting languages.
• Well-versed with Microsoft Office Suite including Office365, Lync, MS Visio, MS Access, Project, Power Query, Power Pivot, DAX, SharePoint, and SharePoint Design.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and sequel server reporting services(SSRS).
• Have an idea on state of Wisconsin privacy regulations while working on the dashboard workbook.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting etc. and Dashboard prompts.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS ORACLE, Teradata tables using LIBNAME and SQL PASSTHRU facility, SQL, Cloud era Hadoop and Hive, Apache SOLR, Map Reduce, Amazon Redshift.
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real - time systems all in one dashboard.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

TECHNICAL SKILLS:

Specialties: Data Visualization, Business Intelligence BI, Software Management and Data Collection

BI Tools: Tableau 7.0, Tableau 8.0/8.1, OBIEE 10g,11g, SSRS

Relational Databases: MS SQL Server 2005/2008/2012 , Oracle 8i/9i/10g/11g, MS Access

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

Languages: SQL, PL/SQL, C, C, ASP.Net, HTML, XML, XSL

Operating Systems: Windows 2000/2003,2008 Server, Windows 95/98/2000/XP, UNIX, LINUX.

WORK EXPERIENCE:

Sr. Tableau Developer/Admin

Confidential - Foster City, CA

Responsibilities:

• Involved in installation of Tableau desktop 9.3, Tableau server 9.3. Worked on latest versions of Tableau 10.5/10.3.
• As Sr. Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Experienced in developing Web Services with Python programming language.
• As a Tableau SME, responsible for the design, development and production support of interactive data visualizations used across the company.
• Solving P1 issues for the users in the production.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Setting up active directory on the tableau server for the effortless password management for the single sign on in the Salesforce and to view the embedded dashboards.
• Developed PL/SQL triggers on master tables for automatic creation of primary key values.
• 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.
• Created extracts and published data sources on tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries.
• Used R functions as Table calculations (aggregated) like Sum, MIN, MAX etc. in Tableau.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Designed and developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau Desktop 10.5/10.3, Tableau Server 9.3, MS Office Suite, SQL Server, PL/SQL, Informatica, Teradata, MS Excel.

Sr. Tableau Developer

Confidential - San Jose, CA

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement.
• Secured Tableau server to protect the Tableau environment, security group and AWS Direct Connect.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Proficient in data integration between different sources to the EMC Greenplum and SQL environment and reporting the same on Tableau environment.
• Setup sites, projects & local user groups as per functional teams of the organization and implemented Tableau standard operational process for granting user access and for publishing workbooks, data sources & migration between Tableau Server environments.
• As a Tableau Administrator, specializing in Server Worker Nodes Installation & Configuration. Setting up Tableau Primary and Worker Nodes (drivers, patches, command line utilities, etc.)
• Disaster Recovery setup, including Backup Primary setup and configuration.
• Designed and developed remarkable Data Visualizations utilizing R
• Experienced in Service Cloud, Sales cloud, Collaboration Cloud and SFDC Customer Community for All partner portal, customer portal.
• Developed Python/Django application for Google Analytics aggregation and reporting.
• Participated in projects involving Data Quality and Data Governance Strategy and Implementation, MDM Assessment and MDM Implementation, Data Quality Assessment, as well Data Integration, Data Migration using ETL.
• Wrote Python routines to log into the websites and fetch data for selected options.
• Extensive experience in configuration, implementation and maintenance for disaster recovery solutions using log shipping, transactional & merge replication in SQL server 2012.
• Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau.
• Extensively involved in writing PL/SQL code for stored Procedures, Functions, Packages, Libraries and other database triggers etc.
• Extensive experience in Salesforce.com Setup, Configuration, Customization, Administration, Data Migration and Integration tools like Apex Data Loader, Work Bench.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Expert in UI/UX design and redesign.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel.
• Proficient in Databases such as Oracle, Microsoft Access, DB2, My-SQL, SQL server and Hadoop Hive.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Hands-on development, assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked on multiple projects by connecting to multiple data sources like SQL Server, SAS (Statistical Analysis System), Hadoop, SSAS (Microsoft Analysis Services) cubes data and Teradata, Hadoop.
• Tableau dashboards embedding into Salesforce for the continuous data experience for the users,
• Built custom tableau dashboards for the Salesforce for accepting the parameters from the Salesforce to show the relevant data for that selected object.
• Setting up active directory on the tableau server for the effortless password management for the single sign on in the Salesforce and to view the embedded dashboards.
• Designed and developed the reports per the requirements using Tableau and Power Map.
• Ensure user login access, server level, and database level access to application users and developers.
• Connecting and extraction to different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on the tableau server machines.
• Developed tableau dashboard landing page for the embedding into Salesforce in order to provide integrated views and navigation inside Salesforce for the users.
• Developed various dashboards for non-Salesforce group of users for their specific goals of understanding data.
• Creating daily, weekly and monthly reports in Cognos for the internal teams and external vendors.
• Addressing the Performance and other Production issues with the Cognos reports.
• Best practices to enhance the response time of tableau dashboards and speed for the embedded dashboards.
• Designed and deployed database, and developed the Pending Transactions feature, to ensure strict data consistency across multiple records in multiple tables.
• Tableau administration and development roles and helping the client with the issues of data connections, extraction and maintenance.
• Tableau server and desktop upgrade from 8.3 to 9.0.

Environment: Desktop 8.3/9.0, Tableau Server, Cognos 10.2, MS Office Suite, SQL Server, PL/SQL, R Programming, Teradata, SAS, Hadoop, MS Excel.

Tableau Developer

Confidential - Fort Scott, KS

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau.
• 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.
• Worked on claims data of the company like the healthcare data.
• Developed Wrapper in Python for instantiating multi-threaded application.
• Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.
• Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
• Worked in ASDW team where solved issues raised by the front-end users and worked on the Tableau reports per the user's requirements.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Tableau integration for enhanced experience for the users.
• Created extracts and published data sources on tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Collaborate with development team on data approach for coding Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Desktop 8.1, Tableau Server, MS Office Suite, SQL Server, SAS, SSRS, SSIS, MS Excel, Sales, Teradata.

Tableau Developer/Data Analyst

Confidential - Detroit, MI

Responsibilities:

• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Created complex data Views using multiple measures, also used sort, Filter, group, Create Set functionality.
• Designed and developed two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Published various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure

Environment: Tableau 7.0, SQL Server 2008 R2, SSRS, SSIS, MS Excel, T-SQL.

MS SQL Developer

Confidential - Indianapolis, IN

Responsibilities:

• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Application by using T-SQL.
• Wrote SQL queries using DML, DDL, Table joins, Group functions, Analytical functions, Partition by clause towards Reports and Application development.
• Performed and fine-tuned Stored procedures, SQL Queries and User defined functions.
• Responsible for implementing Table partitioning, Advanced Error Handling, Common Table Expression (CTE).
• Involved in extensive data validation by writing complex SQL queries and involved in back end testing and worked with data quality issues
• Scheduled reports to run on a daily and weekly basis in report manager and emailed them to director and analysts to review in Excel Sheet.
• Performed extensive use of SQL Server DMV's for Performance Tuning.
• Troubleshooting client issues ranging from improper configuration settings or data corruption to issues in underlying code, working with product management to provide enhancement or other resolution.
• Wrote complex SQL queries using Inner/Outer Joins, UnionAll, Intersect & Minus Set operators
• Created Joins and sub queries for complex queries involving multiple queries
• Developed and Modified functions, Procedures as per the client requirement to make new enhancements and to resolve issues
• Actively involved in normalizing the database using Normalization techniques to reduce data redundancy.
• Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.
• Developed SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
• Involved in writing Complex SQL statements, Database Triggers and stored procedures by using Cursors and indexes in SQL Server 2012.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.