SUMMARY:

• Around 8 years of experience in IT with complete SDLC involved in various aspects of Gather Requirements, Analysis, Design, Development, Testing and Extensive Experience on Data Visualization, Data Analysis, Data Warehouse and ETL across manufacturing, Healthcare and Financial industries.
• Extensive experience in working with Tableau Desktop, Tableau Server , and Tableau Reader in various versions of Tableau 8.0,8.3, 9.0,9.1, 9.3, 10.3 as a Developer and Admin.
• Experience in the Development, Implementation of Database, BI Analytics and Dashboards applications using Data Profiling, Data Extraction, Data Transformation, Data Loading, Data Visualization using Tableau, SSRS technologies.
• Experience in designing various Data Visualization Dashboards, gathering customer requirements, writing test cases, preparing analytical reports to help users to identify critical KPI's and partnering with developers to ensure full understanding of internal/external customer needs.
• Extensive experience as Tableau Admin in installation, Migration, configuration, Patching and upgrading of Tableau tool across all environments.
• Secured Tableau Server by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Proficient in analysis, preparing Business specifications, implementation, designing, developing reports and performance tuning.
• Experience in creating extracts in Tableau from various source files including flat files, excel sheets, Access files and different databases.
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices.
• Hands - on with creating solution driven views and dashboards by developing different chart types including Heat/Tree/Geo Maps, Line/Bar/Pie Charts, Scatter Plots, and Bullet Graphs in all Tableau Desktop versions.
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters .
• Strong expertise in data analysis using Power BI (Power View, Power Query, Power Pivot, and Power Maps).
• Experience in Power BI for developing interactive drill down reports using slicers and dicers in Power BI and Power Pivot.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau desktop/Server.
• Expert in creating SQL objects like Tables, Complex Stored Procedures, Triggers, Views, Indexes , and User Defined Functions to facilitate efficient data manipulation and consistent data storage.
• Solid understanding of database management systems and working knowledge on SQL server 2008/Oracle 10g , Microsoft Access databases, and Excel Spreadsheet.
• Experience in query optimization (SQL Tuning) using SQL Profiler, Database Tuning Advisor (DTA); Index tuning wizard and Performance recording for performance tuning .
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS) and performing End-to-End ETL validations.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel files, XML files etc.,) and then loaded the data into destination tables by performing various kinds of transformations using SSIS/DTS packages.
• Excellent understanding of Data modelling OLAP &OLTP on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases.
• Good knowledge of Software Development Life Cycle (SDLC) and Agile methodologies.

TECHNICAL SKILLS:

Business Intelligence: Tableau Desktop 10/9/8, Tableau Server 10/9/8, Tableau Public, Reader, Power BI.

Databases: SQL Server, Oracle, OLTP, OLAP, MS SQL Server 2000 Enterprise, Manager, SQL Query Analyzer, Web Services

Tools: SQL Server Business Intelligence Development Studio (BIDS) SSIS/SSRS, SQL Server Management studio (SSMS), Visual Studio, Power BI.

Operating Systems: Microsoft Windows, UNIX, Linux, Dos 6.2

RDBMS/DBMS: MS-SQL Server 2014/2012//2008, MYSQL, Oracle 8i/9i/10g, MS Access.

Data modeling Tools: MS Visio, Rational Rose.

SDLC: Waterfall, AGILE, Prototype and Iterative Model

Performance Analyzer: Interworks - Tableau Performance Analyzer

Web Analytics Tools: Adobe Analytics, Yahoo Web Analytics

PROFESSIONAL EXPERIENCE:

Confidential, Coshocton, OH

Sr. BI Developer/Data Analyst

Responsibilities:

• Interacted with Business partners, gathered requirements and presented POC’s as per complex requirements and needs.
• Involved in upgrading Tableau Desktop and Server Environments to Tableau10.3 from 9.0.
• Managed a team of three and been the point of contact to ensure standards and best practices are established and met for consistent and accurate use of Tableau across the company.
• Worked as a Single Point of Contact for end-to-end development of dashboards.
• Performed data/systems analysis to provide solutions (reports, dashboards, scorecards etc.) using Tableau.
• Experience in working with cross-functional teams to assist with gathering and evaluating detailed project requirements
• Helped Business partners to set up sites in the Tableau server as per the taxonomy structure of the organization.
• Published worksheets using manual and automated process on Tableau development server.
• Developed various reports using best practices and different visualizations such as Tornado Charts, Donut Charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.
• Used LOD functions like fixed, Include and Exclude to show revenue shrink and financial debts to the business at different granularities.
• Developed budgets, variance reports, and other financial analysis.
• Worked using all types of aggregations like Sum, Average, Count, Count (distinct), Median, Minimum, Maximum, Percentile and St. Deviation etc.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Created External filter, internal filter and Context filter to improve performance. Quick filters to display as per user requirement.
• 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 and Power BI.
• 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 Power Pivot and sheared them using Power BI 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 Server 10.3. Tableau Desktop 10.3, Power BI, Adobe Analytics, MS SQL Server 2008R2/2005, PL/SQL, T-SQL, SSIS, MSOffice, Management Studio.

Confidential, Dallas, TX

Tableau Consultant

Responsibilities:

• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.
• Published various types of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
• Worked on loading the data from several flat files sources to Staging using Teradata Multi-load, Fast load.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata
• Developed Teradata BTEQ scripts to implement the business logic.
• Performed data and systems analysis and developed reports, dashboards, scorecards, data cubes, Semantic Layer using Tableau.
• Develop load scripts to extract, transform and load data (ETL) into Tableau applications
• Design and develop new interface elements and objects as required, developed Macros, SET ANALYSIS to provide custom functionality using Tableau
• Developed JavaScript API to create a customized portal for the Online Healthcare Data
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc. and published them to the web.
• Developed various data connections from data source to Tableau Desktop for report and dashboard development
• Worked on using multiple OOTB workflows for notifications, reminders and approvals of project documents and tasks related to projects.
• Used Cognos Report Studio (10.1) to develop reports for managed reporting and scheduling
• Transferred data from Oracle database as well as MS Excel into SAS for analysis and used filters based on the analysis.
• Developed List Crosstab reports, Charts, master-detail reports etc.
• Thorough knowledge on Cognos Framework Manager modelling tool to import and establish cardinality and publish packages to develop Cognos Reports.
• Worked using Parallel load utilities such as Multi-Load, Fast Load, BTEQ for applications which we load data on daily basis, weekly basis and monthly basis.

Environment: Tableau 8.2/8.4 Desktop, COGNOS 10.1, JavaScript, Teradata, MS SQL Server 2008, SSIS, SSRS, SSAS, Hadoop, SAP HANA, Windows 7/XP, Management Studio.

Confidential, Moines, IA

Tableau Consultant

Responsibilities:

• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Conducting training to the user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Translated business needs into BI reporting solutions by ensuring the appropriate selection of tools available across the Tableau BI suite.
• Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
• Working with User for requirements and part of the team developing the software.
• Extensively worked on recommendations for best use and/or exit strategy for every asset.
• Experience in assist Property Management in the evaluation of the condition of and necessary improvements for real assets.
• Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
• Designed Tableau Workbooks, Tableau Reports, Dashboards and Tableau Administration.
• Scheduled reports debugged issues and provided resolutions for Tableau.
• Done performance tuning to optimize the runtime.
• Changed stored procedures according to the new hierarchy.
• Designed and created Report templates, bar graphs and pie charts based on the financial data using Tableau.
• Involved in designing Parameterized Reports and Report Models for generating Ad-hoc reports as per the client requirements.

Environment: Tableau developer 7.0, Admin, SQL Server SAP HANA, SQL (SSAS, SSIS, SSRS), MS Access 2000 & Windows Server 2000.

Confidential

SQL Developer

Responsibilities:

• Involved in analysis, documentation and testing
• Extensively used SQL and SQL Server Integration Services tool to transfer the data, and used SSRS to generate reports as per the requirement of the business analyst.
• Developed test plans, test cases, test conditions, test designs, test templates and test reports
• Identified software defects and interfaced with developers to resolve them and provided full support to the Test team. Experience in designing and implementing black/white box tests
• Involved in functional requirement analysis, effort estimation, identifying test conditions, creating test cases, reviewing test cases and executing test cases
• Reporting on progress and risk to management, worked on defect management system
• Extensively involved in database testing and checking the migrated data quality
• Extensively tested with SQL Query and Stored Procedures for data validation purposes
• Extensively tested reports module which is in Crystal Reports
• Extensively working on regression testing, executing test cases

Environment: MS SQL Server, Application Development, SAP BO, SSIS, SSRS