EXPERIENCE SUMMARY:

• Around 8 years of extensive experience in IT as BI Developer with Tableau and Business Intelligence Tools and SQL with expertise in data warehousing concepts.
• 5+ years of experience in Tableau Development and 2+ years of experience in SQL.
• Experience in Tableau 10.5/10.4/10.3 / 10.2/10.1/10.0/9.3/9.2 /9.1/8.0 /7.0 as a BI Developer, Analyst and Admin.
• In - depth knowledge on Tableau Desktop, Tableau Server, Tableau reader and Tableau Cloud and designed several business dashboards.
• Expertise in Installation, configuration, upgrading and administration of Tableau Desktop/Server.
• Proficient in data visualization, Reporting, Analysis, Bar Charts, Pie Charts, Heat Maps, Scatter Plots, Page Trails, Geographic Map and Density Charts in Tableau Desktop.
• Created actions, customized relationships, data blending, filters, calculated fields, parameters, hierarchies, groupings, sorting, live and extract connections, drill down analysis and in-memory in tableau.
• Performed extensively with Calculations, Parameters, Background images, Advance analysis Actions and Maps.
• Working pastime on recent versions of Tableau 10 and 10.1/10.2 to understand the differences and features for creating innovative dashboards on data sources procured from Superdatascience, Kaggle and Github.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Used parameters, action filters and sets for preparing dashboards and worksheets in Tableau.
• Performed extensively with Calculations, Parameters, Background images, Advance analysis Actions and Maps.
• Worked on reference lines, trend Lines, statistical concepts. Used groups, sets, hierarchies to create detail level summary report and dashboards using KPI's.
• Worked on the improvement of dashboard reports bycreating KPI (key performance indicators) for the top administration.
• Expertise in configuration of Tableau server 10.0/9.2 in various environments and Used Tableau admin tools and Tableau CMD to configure the server following best practices and setting up security profiles for various User groups and Users.
• Built Operational Dashboards strictly focused on tracking operational and financial performance.
• Used SAS in the area of Analytics and ‘Analytical Data Preparation’ and Tableau in the area of data discovery, visualization and intuitive, interactive dashboarding.
• Worked on configuring various data sources using Data Blending.
• Requested data from Google Analytics from Tableau, and overcome the sampling limits that would typically apply in the interface and the Core Reporting API.
• Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
• Proficient in Tableau server commandsto migrate workbooks from environment to another environment and also carried out Tableau server backup, monitoring and debugging tasks.
• Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.
• Created automated scripts for tableau workbook refresh when not using live connections
• Setup of Distributed Server environments for optimum load balancing.
• Utilized efficient load balancing techniques to manage the load on the server for concurrent user logins.
• Held responsibility in setting up security profiles for various user groups and users using Tab admin and Tabcmd Tools.
• Worked on setting permissions on content for specific users or group on a per site basis.
• Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems.
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.
• Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR.
• Used SAML for configuration of Tableau Server SSO supplementing Kerberos authentication on the side.
• Experience in publishing and sharing workbooks, data sources with user filter to tableau server, setting schedules, subscriptions, authorization and permissions, incremental refresh extracts and updating serverdata that are using extracts.
• Experience in working on different data warehousing methodologies including star schema and snowflake schema, ETL processes, dimensional modeling, reporting tools.
• Experience in using Custom SQL for tableau and in writing queries for generating tabular reports, formatting report layout and expressions.
• Involved in complete Software Development Lifecycle (SDLC) by identifying the business requirements and converting them to tableau design.
• End to end involvement in designing, testing, deploying and support of data visualizations using Tableau Desktop.

TECHNI TECHNICAL SKILLS:

Tableau: Desktop 10.5/10.4/10.3 / 10.2/10.1/10.0/9.3/9.2 /9.1/8.0, Used various tableau versions to create visualizations appealing to end users and customers, Tableau Server 10.5/10.4/10.3 / 10.2/10.1/10.0/9.3/9.2, Installation and configuration of Tableau server on various versions, Service pack upgrades, Version upgrades and end to end architecture design, Tableau Cloud, Tableau Reader, Tableau Public, Tableau Mobile, Well versed with other products of Tableau on what to use as per the requirements

Platforms: UNIX, Win, LINUX, Web Sphere, Apache/Tomcat, Oracle, MS SQL Server, Access, DB2, Teradata, AWS Redshift

Analytical Skills: SAS Enterprise Guide, SAS Enterprise Miner, Micro Strategy, IBM Modeler, R Programming

Additional Skills: SAP BOBJ 4.0/3.1, HANA, Qlikview, C, C+ +, Visual Basic, ASP.NET, SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk, VA

Senior Tableau Developer

Responsibilities:

• Deep experience with the design and development of Tableau visualization solutions.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• 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 data connectors that are already available in Tableau, to create web data connector (WDC) that reads data from virtually any site that publishes data in JSON, XML, or HTML.
• Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
• Used the Tableau Web Data Connector JavaScript library to connect to the GoogleAnalytics data without having pitfalls going directly with the GA connector
• Used Tableau web data connector to create gets stock price data from the Yahoo site.
• Used the Yahoo provided REST API that send queries for financial data.
• The connector then gets the closing price for the specified company for one year back from today's date.
• Used the Web Data Connector JavaScript library for enabling the app to interface with the Tableau API
• 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.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Implemented new features in Tableau 10.5 to the existing Workbooks and Dashboards.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.
• Involved in installation and upgrade of Tableau Server and Server performance tuning for Optimization.
• Involved in building Dashboards using parameters, sets, groups and calculations.
• Designed Views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Environment: Tableau Desktop 10.x,Tableau Server 10.x, SSRS, Oracle 11g, Microsoft Excel 2010, MS Access, Microsoft office 2010, Teradata.

Confidential, Sacramento, CA

Tableau Developer/Admin

Responsibilities:

• Designed and developed Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Created and presented weekly status update reports for the ongoing project and identified the roadblocks.
• Published many dashboards on Tableau Server and embedded them into web portal.
• Setup and configuration of Tableau server 10.2 in various environments and used Tableau CMD.
• Used Tableau admin tools to configure the server according to best practices.
• Building publishing customized interactive reports and dashboards report scheduling using Tableau server Creating New Schedules and checking the tasks daily on the server.
• Involved in creating dashboards and reports in Tableau 10.0 and Monitored server activities, user activity and also customized views.
• Connected to RSoftware for Hierarchy check of the given business requirement.
• Involved in upgrade of Tableau Server and also created Users Groups, Projects Workbooks and assigned Access levels in Server.
• Configuration of AWS in built SNS/SQS setup for job scheduling
• Create required shell or python scripts for data push from Tableau/Teradata to S3
• Provide the user access to team for AWS console and SSH connectivity to the Edge node.
• Created users groups projects Data connections settings as a tableau administrator.
• Created connections to Hadoop Hive and work with data/time data.
• Worked with Tableau scorecards dashboards using stack bars bar graphs scattered plots geographical maps Gantt charts using show me functionality.
• Created action filters parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Used Trend Lines, log axes, groups, hierarchies and sets to create detailed level summary report and dashboard using KPIs.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Conducted Training sessions for Tableau Power users and created the documents for end user support.
• Writing SQL queries for data validation of the reports and dashboards as necessary.
• Involved in Performance tuning the reports and dashboards for optimization.
• Exported the universes to the Repository for making resources available to the users.
• Experience in configuring reports from different data sources using data blending.
• Build organized customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Involved in creating database objects like tables views procedures triggers and functions using T SQL to provide definition structure and to maintain data efficiently.

Environment: Tableau 10.x and 9.x, Tableau server, Python, Web data connector, Alteryx, Teradata, Oracle, Informatica, SQL, MySQL, Python, Teradata Sql, Windows 2003/ XP, UNIX.

Confidential, New York, NY

Senior Tableau Developer

Responsibilities:

• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Deep involvement with the design and advancement of Tableau visualization solutions.
• Understanding of Tableau features like calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons.
• Connected to different appliances like Oracle, MySQL etc.
• Used data base filters and context filters.
• Preparing Dashboards using calculations, parameters in Tableau and Developing Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Access and change extremely large datasets through filtering, grouping, aggregation, and statistical calculation
• Involved in supporting other Tableau applications which includes creation and cosmetic changes of different
• Migrated existing reports from share-point/excel to Tableau Server by recreating them in batches.
• Interacted with business analyst to gather ad hoc business requirements and designed functional and technical requirements documentation.
• Provide master counsel to the Business Team on Best Practice design and visualization with Tableau.

Environment: Tableau 9.x, Tableau Server, SQL Server, WinSQL, SSRS Google Big Query - Google cloud, MS Office Suite, HP Service Manager, HPALM. Sharepoint, Windows 7/10.

Confidential, New York, NY

Tableau Developer

Responsibilities:

• Collaborated with senior management, subject matter experts, and Participated in JAD meetings to ensure a common understanding with business IT teams to define business requirements and Transformed business requirements into functional and nonfunctional requirements.
• Designed, developed, and tested the ETL strategy to populate data from multiple source systems and Implemented SSIS packages to perform ETL data messaging operations (data profiling, cleansing, and verification).
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Designed and developed a business intelligence dashboard using Tableau Desktop and PowerBI, allowing executive management to view past, current and forecast sales data.
• Designed expressions to calculate, group, filter, parameterize, and format report contents.
• Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau Desktop and Delivered on - demand reports in multiple rendering formats with standard and data driven subscriptions.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, and Power Maps) and integrated them to share point.
• Used Power BI (power Pivot) to develop data analysis prototype and used power view and power Map to visualize reports.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel PowerPivot and sheared them using PowerBI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging and Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources

Environment: Tableau 7.x,8.x,9.x, SQL Server, T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, SharePoint, Tableau server, Power BI DTA, SQL Profiler, MS Azure, Visual Studio

Confidential, New York, NY

Sr. SQL Server Developer/SSIS Developer/SSRS Developer

Responsibilities:

• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Created Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Create and edit alerts on Reports, as per User request
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV
• Generate reports with parameters, sub reports, cross tabs, charts using SSRS
• Created Business - Crucial stored procedures and functions to support efficient data storage and manipulation.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Worked with MDX to query cube's data.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Implemented Complex business logic with User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.
• Used some data conversion tasks in SSIS to load the data from flat file to SQL Server database.
• MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created document for Self-Service Deployment and Execution process for SSIS packages
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Provided critical Production support when needed.
• Developed and implemented the application code in Oracle PL/SQL and T-SQL
• Completed revamping on a slow performing workflow to greater than 5 times faster and thus processing larger volume of data/reports and meeting the current SLA.
• Developed stored procedures using Oracle 9i and 10g.

Environment: SQL Server 2008 R2 Enterprise Edition, SSIS, SSRS, MS Project, MS Access 2003, Oracle, SharePoint, PL/SQL, C#, Visual Studio 2008 & 2005, MS Visio 2007.