SUMMARY:

• 9+ years of extensive experience in IT as BI Developer with Tableau and Business Intelligence Tools, ETL and SQL with expertise in data warehousing concepts.
• Around 4 years of experience in Tableau Development and 2+ years of experience in SQL and 3+ ETL and .NET.
• 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 Online 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 and embedded them into portal.
• Used parameters, action filters and sets for preparing dashboards and worksheets in Tableau.
• 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 by creating 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 commands in migrating workbooks from one environment to another 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.
• 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.

TECHNICAL SKILLS:

Tableau Desktop 10.5/ 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.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: ETL, C, C+ +, Visual Basic, ASP.NET, SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Sr. 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.
• 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
• 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, NYC, NY

Senior Tableau Developer/Admin

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.
• 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.
• 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, Washington DC

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 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 Google Analytics 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.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• 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
• 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.
• 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.
• 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 8.x,Tableau Server 8.x, SSRS, Oracle 10g, Microsoft Excel 2010, MS Access, Microsoft office 2010, Teradata.

Confidential

SQL Developer

Responsibilities:

• Development and implementation of new business requirement.
• Development and customization of business logic based on customer needs.
• Analyze the client requirement and review the change request, based on priority.
• Prepare the ad hoc reports script using SQL with minimal assistance, based on the Requirements provided by internal stakeholders.
• Writing Complex T-SQL queries and sub-queries using complex Joins.
• Developed Stored Procedures for storing and retrieving data through forms.
• Has good experience in complete ETL cycle including data analysis, data mapping and conversion and data load.
• Experience in importing/exporting data between different sources like SQL/Excel/Flat

Environment : SQL, ETL, Excel, SQL Server, Windows Server

Confidential

ETL Developer

­­­­­­­­­­­­­­­­­­­Responsibilities:

• Understanding the Requirement Specifications and discussion with PO for further drill down and reqs.
• Writing Teradata merge and Bteqs scripts to load and update data in Teradata systems.
• Developing the mappings using needed Transformations in Informaticatool according to technical specifications to populate the data into Target tables from Source systems.
• Developing and implementing the coding of Informatica Mapping for the different stages of ETL (Extraction Transformation and Loading).
• Developing various Mappings to load the data from various sources by using different Transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier, Expression and Sequence Generator to load the feeds data.
• Fixing the invalid Informatica mappings and troubleshoot the technical problems of the database.
• Development of Informatica Mappings to accomplish Auditing and Error handling of Target load.
• Developing Workflows using task, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Participated in coding, code reviewing, testing, time-box delivery and deployment and on-site training.
• Participated in the daily stand up SCRUM agile meetings as part of AGILE process for reporting day to day developments of the work done.
• Developed Workflows and exposed the workflow as WCF service.
• Worked on different models which involves data extraction.
• Debugging the Informatica sessions by utilizing the logs of the sessions.
• Creating UNIX shell script for the start and stop procedures of the sessions.
• Performing unit testing at various levels of the ETL
• Extensively worked on identifying the bottlenecks and fine-tune the mappings.

Environment: Informatica Power Center 7.1, Oracle, PL/SQL, SQL Server 2005, Windows Server, Linux

Confidential

.Net Developer

Responsibilities:

• Developed complex web forms using ASP.NET server-side scripting with C#, .NETFramework 4.0, JQuery, JQGrid, JQuery UI.
• Used JavaScript to enhance the dynamics and interactive features of web page by allowing user to perform calculations, Validate form inputs, add special effects, Customize selections, Confirmation etc.,
• Used DOM for parsing XML document on client side.
• Used Silverlight to display some reports by consuming WCF services .
• Used callback methods for asynchronous operations on the page.
• Created new Grid control to support client side operation like sorting, filtering and searching.
• Created new user controls for using it into the project to support additional properties and client side operations.
• Extensively used ADO.NET for interfacing this application with the Oracle, SQL Server.
• Used output caching to cache the pages or objects on the server for reusing them.
• Worked with Custom Role-based Authentication in which authentication and authorization of the application is done from the database.
• Developed tool in C# Winform to capture traceability from Use case to System Requirement
• Developed user interface screens under Visual Studio .NET 2010, 2005, 2012 using ASP.NET and C#
• Developed the analytics engine.
• Provided support during test and UAT phase of the project.
• Created and updated technical specification documents.
• Scheduled functional review meetings to explain functionality of the developed modules.
• Participated in coding, code reviewing, testing, time-box delivery and deployment and on-site training.
• Participated in the daily stand up SCRUM agile meetings as part of AGILE process for reporting day to day developments of the work done.
• Developed Workflows and exposed the workflow as WCF service.
• Created SSIS package and scheduled them as SQL job to run the periodic intervals.
• Created some RRRS reports for showing reports to the customers depending on input parameters.
• Developed Ajax-driven MVC Partial Views.

Environment : .Net framework 3.5/4.0, C#,VB.NET, ASP.NET/3.5,MVC2, AJAX, ADO.NET, XML, WCF, WWF, Web Services, ASP, OOPS,VB6, HTML, JavaScript, Visual Studio 2008/2010/2012 , Oracle 9i/10g/11i, PL/SQL, HTML, CSS3, JavaScript, ASP, Crystal Reports