SUMMARY

• Over 10 years of experience in the IT Industry and worked on Tableau Desktop, Tableau Server and efficient in connecting various data sources.
• 8 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, PowerPivot, 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, Cloudera Hadoop and Hive, Apache SOLR, MapReduce, Amazon Redshift.

TECHNICAL SKILLS

Reporting Tools: Tableau, Business Object suite Business Objects BI 4.0, SAP BW, Web I XI/6i/2.6, Designer, Reporter/Desktop Intelligence/Web Intelligence Rich Client (3.1), Supervisor, Broadcast Agent, Info view, Crystal Reports Crystal Enterprise, Central Management Console, Xcelsius, QaawS, Live Office, Xcelsius, Methodologies Waterfall, SCRUM and Agile, Complete Software Development Life Cycle, Iterative, Scrum.

ETL tools: SQL Loader, Informatica Power Center 8.1, 7.1, 6.2.

Databases: Oracle SQL Server Sybase, Teradata, MS Assess, DB2.

Data Modeling Tools: ER Studio, VISIO, Dimensional Data Modeling (Star Schema, Snow-Flake, FACT Dimensions), ERWIN iGrafx

Languages: SQL, PL/SQL, C, C++, JAVA, J2EE, HTML, XHTML

Operating systems: UNIX, LINUX, Windows 98, XP, 2008/NT.

Application Servers: Web Logic, Web Sphere, Tomcat.

Software Packages: MS OFFICE, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin.

PROFESSIONAL EXPERIENCE

Sr. Tableau developer/Admin

Confidential

Responsibilities:

• Involved in installation of Tableau desktop 9.3, Tableau server 9.3. Worked on latest versions of Tableau 10.5/10.3, 10.4,10.5
• Use complex SQL join statements to represent relationship between facts and dimensions.
• Convert and clean the hard scripts into readable tables for creating Executive Level Dashboards using Tableau.
• Develop, load scripts for extracting, transforming and loading data into Tableau.
• Automated all the manual reports using Tableau refresh methods for all dashboards.
• Developing crosstabs, heatmaps, scatterplots. Spatial graphs, pie charts and density charts using high volumes of financial data.
• Dynamically using reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters.
• Utilize integration options using Tableau Desktop, Tableau Server and Tableau Reader to minimize overall end user licensing requirements.
• Work in database systems like Oracle, DB2, MYSQL and SQL 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.
• Maintained detailed documentation simultaneously for future reference.
• Working with the Enterprise Tableau Infrastructure team to Migrate and upgrade the server from 10.3 to 10.4.
• Implement row-level security to different Business Managers based on their respective field of work; Example - Premiums, Death Claims of a certain Broker-Dealer of Nationwide.
• Working as a Site Admin and responsible for all the dashboards, maintain the user traffic, schedule timely data refresh to avoid performance issues.

Environment: Tableau Desktop (9.0, 9.1, 10.0, 10.2, 10.3, 10.4,10.5), Tableau Server, Oracle SQL Server R2, MS Office Suite, MS-Excel

Sr. Tableau Developer

Confidential - Detroit, MI

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.
• 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.

Tableau Developer and Administrator

Confidential

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.
• 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 - Hoboken, NJ

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.
• 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 Administrator

Confidential - Great Neck, NY

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.

SQL Developer

Confidential

Responsibilities:

• Interacted with the Business Users and Supervisors to gather business requirements.
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents.
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2005, and MS Access databases.
• Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
• Extracted data from xml and flat files using SSIS.
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
• Designed, programmed, deployed and tested the requested Reports.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application Database Tables, along with checkpoints for testing verification.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Analyzed long running queries and tuned the complex queries to optimize application and system performance.
• Developed user test cases and validated test results during user acceptance testing.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment: MS SQL Server 2000/2005/2008 , Erwin, MS Access, SQL Server Integration Services (SSIS), SSRS Import & Export Data, SQL Reporting Services, XML.

SQL Developer

Confidential

Responsibilities:

• Managing of database objects like Tables, views, indexes.
• Performed regular Database Maintenance task, checking the disk Defrag procedures in Development environment.
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005.
• Implementing Load Balancing Replication across the Databases.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
• Used Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities.
• Performed Database consistency checks with DBCC, Index tuning and monitored SQL Server error logs.
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.

Environment: SQL Server 2000, SQL Server 2005. T-SQL, Windows Server, HTML, VBScript, JavaScript, Access