SUMMARY:

• Over 10+ years of extensive experience in Business Requirements Analysis, Data Analytics, Business Intelligence, Dashboard Design, Predictive and Marketing Analytics Solutions, Story Points Analysis,Database Design, Development, Testing, Implementation and Maintenance of Business Intelligence, Data Warehousing, Tableau Desktop and Tableau Server.
• 7+ years experience in creating highly interactive visualizations with Tableau Desktop, Tableau Server, Tableau Public and Tableau Reader in various versions
• (2018.x/10.x/9.x/8.x/7.x) of Tableau Software using features such as Data Joining & Data Blending,
• Extracts, Live Connection, Calculations, LOD Expressions, Filters, Parameters, Actions, Context Filters, Groups and Sets.
• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2016, 2012, 2008, 2005 and 2000.
• Expertise in Requirements gathering/analysis, Design, Development, Testing and Production rolloverof Reporting and Business Intelligence Analysis projects.
• Experience in gathering and writing detailed business requirements and translating them into technical specifications and design.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Created 800+ worksheets and 150+ Dashboards in large Business Intelligence environments using Tableau Software.
• Extensive usage of Tableau Version 10.5 Hyper feature for faster data ingests and analytical queryprocessing on large or complex data sets. Also, Viz in Tooltip, and Power Trendlines.
• Used Python to manipulate the data and connect it with Tableau to build analytical dashboards and story points.
• Used Python libraries for data cleansing and manipulation.
• Used Python to import data and perform data cleaning and integrated it with Tableau to build visualizations.
• Utilized all Tableau tools including Tableau Desktop, Tableau Reader and Tableau Public. Strong understanding of Software Development Life Cycle(SDLC) methodologies including Waterfall and Agile.
• Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions.
• Extensive experience in Tableau data visualization tool to analyze and obtain insights into largedatasets, create visually compelling and actionable interactive reports and dashboards.Integrated Python dataset with Tableau to build visual analytics solutions.
• Connected Tableau with Python to provide fast visual analytics solutions with data mapping. Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Experience in installing Tableau Server on both on - Premise as well as the Cloud, using Amazon EC2 instances in Amazon Web Services (AWS) .
• Extensive usage of AWS for connecting to data sources on cloud using Amazon Redshift.
• Experience in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Proficient in creating different visualizations using Bars, Area, Lines and Pies, Maps, Scatter plots,
• Gantt charts, Bubbles, Histograms, Bullets, Heat maps, Geo Maps, Box and Whisker Plots, Highlight tables, and other making use of Calculated fields, Actions,
• Parameters, Sets, Quick, and Context filter according to the end user requirement.
• Outstanding data analysis skills including Data mapping from source to target database schemas, DataCleansing and processing, writing data extract scripts/programming of data conversion andresearching complex data problems and generating analytical reports/dashboards.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations
• Expertise in using Trend Lines, Statistics, and Log Axes, Groups, Hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Expert in creating Calculations (Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Experience on LOD expressions, Comparative Sales Analysis, Customer Acquisitions, etc.
• Hands on experience in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Worked on different Administration tasks such as data loading, batch jobs, data uploading, backup &recovery, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/transaction logs.
• Used tools like MS SQL Profiler, Index Tuning Wizard, and Pervasive and Windows performance for monitoring and tuning SQL Server performance.
• Strong experience in Trouble Shooting, Performance tuning of reports and resolving issues within source data and reports.
• Expert in writing SQL Queries using joins, derived tables, sub-queries, and correlated sub queries for validating data on reports and also for generating data extracts to suffice source datarequirements in Tableau.
• Manage the application’s users, groups, and integration with Active Directory.
• Automated monitoring & server job processes.
• Experience in taking back ups and restoration of Tableau repository.
• Experience on Tableau Metadata tables and Postgre SQL.
• Experience in working as a Tableau Server administrator on a windows platform.
• Install, configure and maintain Tableau Server in a distributed environment.
• Advanced knowledge of performance optimization and perform Upgrades whenever needed.
• Develop and document any needed standards/best practices for development and administration of the platform and communicate to developers as needed.
• Set up Monitoring of Tableau server utilization and capacity planning.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation
• Skills, and Leadership Qualities. Demonstrated ability to self-motivate and be flexible within a fast-paced environment.

SKILL:

BI/Reporting Tools: Desktop, Tableau ServerTableau Public, Tableau Online, Tableau Reader and Tableau Mobile) 10.510.4, 10.3, 10.2, 10.110.0, 9.3, 9.2, 9.1, 9.08.3, 8.2, 8.1, 8.0, 7.0

Databases: SQL Server 2016/2014/2012/2008 /2005/2000 , MS AccessOracle 11g/10gPostgreSQL, MySQLDB2, Mongo DBTeradata, Cloud Computing/ AWSAmazon Red ShiftNetezza

Front End Tools Document Management: Microsoft Project, Visual Source Safe 6.0Microsoft Office, Visible Share point, Ultra Edit Analyst, Lotus Notes

Defect management tool Relational Databases: HP Quality center/ALM, MS SQL Server, OracleJira Teradata, NetezzaKognitio.

Languages Operating systems: SQL, PL/SQL, T-SQL, Windows 7/XP, Windows HTML, XML, XSL. Server 2012/2008UNIX/Linux.

WORK EXPERIENCE:

Sr. Tableau Developer (SME)

Confidential, Cambridge, MA

Responsibilities:

• Designed, developed, maintained Tableau functional reports based on the requirements of the user.
• Experience in design and development of Tableau visualization solutions.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop (10.5, 10.4/10.3/10.2/10.1/9.3/9.2 ). and Tableau
• Experienced in creating the groups, users, workbooks and also permission sets for the tableau server logons and checks
• Hands on development in assisting the users in creating the worksheets and also modifying them and data visualization dashboards.
• Designed, developed and tested various Tableau/Tableau visualization for dashboard and ad-hoc reporting solutions.
• Preparing Dashboards using the calculations, parameters in the Tableau and creating SQL datasets for Tableau and Ad-hoc reports .
• Expert on creating the report schedules on Tableau server.
• Developed story telling boards in desktop and published in to the server which allowed users to understand the data with the filters when they needed certain information.
• Perform data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes) using Tableau
• Extensive experienced in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Proficient in developing Entity- relationship diagrams, star/smow flake schema designs and expert in modelling the transactional databases and data ware house.
• Provided production support to Tableau users and written custom SQL to support business requirements.
• Blended the data from the different databases in to one report by selecting the primary keys from each database for the data validation.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, transformation and load ETL routines for migrating data from non - relational or source relational to target relational.
• Involved in creating the ad hoc analysis and reporting requests in a timely manner for BML Risk related to the fraud approvals,yearly, monthly and daily.
• Mastered the ability to design,develop and deploy effective dashboards and also rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters, actions using Tableau.
• Installing Tableau Server in an enterprise level for substantial number of Global users with a Governance principle.
• Assisting users with questions and issues using the Tableau, working with various infrastructures teams and Tableau team to help the response time of dashboard.
• Performance monitored and tuned the Tableau reports.
• Involved in reviewing the requirements and data sources from the MS Excel for the design, development, production of reporting and the analysis projects with in Tableau Desktop.
• Worked extensively with Advance Analysis Actions,LODs (FIXED, INCLUDE, EXCLUDE) Calculations, Parameters, Background images, Maps.
• Evaluated bug fixes and identified the changes from 10.3 to 10.4 and digested the customer accordingly.
• Involved in Trouble Shooting, Performance tuning of reports with the huge queries using query execution for better performance and resolving issues within Tableau/Tableau Desktop/Server Reports.
• Tested dashboards to ensure data matching per the business requirements and any changes in the underlying data.
• Perform complex T-SQL scripting on MS SQL server 2015/2016
• Excellent rapport with developers, testers in all the projects and worked in close collaboration with team members to ensure enhancement of software quality

Sr. Tableau Developer/ Administrator

Confidential, Framingham, MA

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Apache Hive, Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting andanalysis projects within Tableau Desktop.
• Analyzed local JSON data directly in Tableau and other popular JSON data sources right into Tableau Version 10.5 with a few clicks.
• Revert to older version workbooks in Tableau Version 10.5 with improved workbook versioncompatibility.
• Exported Data using two new JavaScript API (getSummaryDataAsyc and getUnderlyingDataAsync) that enables programmatic access to data in the visualization.
• Created views in Tableau Desktop that were published to internal team for review and further dataanalysis and customization using filters and actions.
• Customized the Tableau Server Home page and designed own Reporting landing Page to give the user feel of a web portal.
• Created Heat Map showing current service subscribers by colors that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created dashboard using parameters, sets, groups and calculations.
• Assisting users in creating and modifying worksheets and data visualization dashboards.
• Created several types of visualizations using Sets, dynamic sorting etc.
• Used Alteryx to provide analysts the unique ability to easily prep, blend, and analyze all of their data using a repeatable workflow.
• Used Python to manipulate the data and connect it with Tableau to build analytical dashboards and story points.
• Used Alteryx to wrangle or blend data (on need basis) and Tableau to develop the dashboard and finally publishing via Tableau Server.
• Utilized Alteryx to integrate data from multiple databases into a DW data model.
• Converted charts into Crosstabs for further underlying data analysis in Tableau.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Apache Hive, Oracle SQL Server and MS Excel.
• Actively involved in testing new/upgraded features like new analysis tab, Level of Detail expressions, Data Interpreter, Split function, smart Geo maps, etc.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• 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 User Groups based on the user role in the Project and provided the Access to the Groups. Created Different Schedules based on the requirement and used to create tasks to refresh and Subscriptions to the reports.

• S cheduled 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 in Development Environment to make sure data was accurate as per the business requirements before moving the Reports to Production.
• Worked on Tableau Server Customization to make user comfortable with look and feel of the portal by using Tableau Database.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau 10.x (Desktop/ Server), Oracle, SQL server, SQL, SQL developer, Microsoft Office Suite (Word,Excel, PowerPoint)

Tableau Developer/Administrator

Confidential, Irving

• Designing, developing, testing, and maintaining Tableau reports and dashboards based on userrequirements.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively developed different types of visualizations in Tableau like Dual Axis, bar charts, WaterFall charts, Bullet graphs, box and whisker plots.
• Utilized advance features of Tableau software like to link data from different connections together onone dashboard and to filter data in multiple views at once.
• Implemented Grand Totals, Sub-totals, and Changing Aggregation for Customizing the Data.
• Created Hierarchies, sets, combined sets and Groups in Tableau.
• Generated adhoc Tableau reports on demand for providers.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trendlines, forecasting etc. in many Tableau reports.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Deployment of work books from one environment to the other environment through SFTP.
• Experience on Tableau Server Administration and Install in a distributed environment.
• Connected to messy spreadsheets using Tableau Version 9 which made the process faster and better performance and increased speed across workbooks.
• Used new connectors like Google Analytics, and Salesforce.com with Tableau Version 8.
• Worked on Tableau Server internal repository and Metadata tables.
• Experience with content administration and manage user’s access via Active Directory (AD) groups.
• Ability to provide technical support to all team members during project execution.
• Advanced knowledge of performance optimization.
• Monitor the schedules and tasks on regular basis and also create schedule job based on the user request
• Worked on the incident tickets raised by the user based their requirement
• Applied row level security to the dashboard based on user specific groups
• Involved in trouble shooting of performance issues which was associated with Tableau reports.
• Trained the users and helped them to improve and maintain their reports.
• Managing Testing cycle regarding the reports and dashboard utilizing onsite and in inshore resources.
• Designing the Reports as per client Requirement and created the reports using database.
• Working closely with the business users to gather requirements
• Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.
• Created Parameters to achieve desired functionality.
• Implemented Binning & Blending concepts in my Tableau Reports.
• Worked on Dual Axis concept while working with reports.
• Created Filters, Groups, Sets on Tableau Reports.
• Created and modified some of the existing reports and dashboards.
• Publishing sheets and dashboards on server Using Tableau Desktop.

Environment: 9.x/8.x (Desktop/ Server), Oracle, Teradata, Excel, Windows Server 2003.

Tableau Analyst

Confidential, Plano

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical& functional specifications.
• Analyzed requirements for various reports, dashboards and created proof of concept / prototype of the same using Tableau desktop.
• Mastered the ability to design and deploy rich Graphic visualizations with and Parameterizedusing Tableau.
• Created Heat Map showing current service subscribers by colors that were broken into regions allowing business user to understand.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards and handledthe performance issues effectively.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further dataanalysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual - axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Involved in gathering, analyzing, distilling and clearly conveying complex information to business and project team members through JAD sessions
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements using RUP methodology
• Conducted interviews and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions
• Performed extensive Requirement Analysis including data analysis and gap analysis. Designed anddeveloped project document templates based on SDLC methodology.
• Analyzed the Business and System Requirements of the application. Interacted with user groups to derive the functional requirements
• Extensively involved in Analysis, Design and development of Data conversion, Data migration andIntegration process and procedures
• Worked with the database designer in data modeling through ER diagrams to identify tables, attributes and relationships between tables.
• Actively participated in clarification meeting with the Clients.
• Involved in handling Source to Target Data Mapping, Technical Specs documentation, and ETL documentations such as Early Data Inventory, Data Profiling, Data Mapping, and Programmer Specsconforming to internal guidelines.
• Managed data validation procedures, and identify/resolve data issues
• Analyze the potential impact on users of automation of current data and processes, the movement towards standard data collection and reporting, and the implementation of data validation/verification practices to ensure data integrity.
• A ssisted Test Lead,Testers understanding business process and helped them for successfulcompletion of Unit Testing, Integration Testing and Requirements Testing.
• Supported the production database in terms of facilitating the implementation of defect resolutions and minor functionality enhancements.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Participate in testing of procedures and data, utilizing PL/SQL, to ensure integrity and quality of data in data warehouse.
• Created and Maintained Supporting documents (technical, business, project level and sops) to meet SDLC standards
• Supported for executing data requests, custom reports, test scenarios, data migration, data analysisand quality assurance testing.
• Ensured current testing practices met legal compliancy standards. Performed data integrity testing by executing SQL statements.

Environment: Tableau 7.x/6.x (Desktop/ Server), Oracle DB, Microsoft SQL Server, SQL, Microsoft Excel 2007, MSAccess, Windows 07/08 server, Microsoft office 2007.

BI Developer

Confidential

Responsibilities:

• Worked with multiple clients in BI space supporting reporting and analytics development andsupport.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle,MS SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Designed, Developed and modify Interactive Dashboards and Creating guided navigation links withinInteractive Dashboards.
• Working with Business Analysts to streamline any data issue, which involves Unit Testing of all the worksheets.

Environment: Oracle DB, Microsoft SQL Server, Microsoft Excel 2007, MS Access, Windows 07/08 server, Microsoft office 2007, Business objects 4.0.