SUMMARY

• Developer with 7+ yrs experience on Tableau, Power BI, data discovery, data visualization, data analysis, report development, MS SQL Server Developer/ ETL Developer in analysis, design, implementation & administration of Business intelligence solutions (SSIS/SSRS/SSAS) with Microsoft SQL server 2017,2016, 2014/2012/2008 - R2/2008, Azure SQL DB, in and OBIEE in development, testing & production environment.
• Experienced in designing and developing ETL workflows and datasets in Alteryx to be used for Reporting (ETL tool specific for creating datasets) Tableau Data Extract for BI.
• Worked with users and stakeholders to analyze and validate requirements .
• Assessed and interpreted company data and conducted a statistical analysis to discern procedural efficiency.
• Analyzed and assessed client’s requests to create professional, presentation-quality deliverables in the form of dashboards and reports to provide additional insights to any critical indicators.
• Collocated with client and technical solutions groups to document, analyze and validate processes and business requirements
• Experience in establishing ETL pipelines, SQL queries in Snowflake.
• Experienced in Cloud Data environments AWS, Azure to integrate data to Tableau for data visualization.
• Deployed Tableau Connect with Azure SQL Synapse Analytics and SQL Database to set up the data source.
• Experienced in using Tableau Prep to combine, shape, and clean your data for analysis in Tableau.
• Build, published, Combined views and reports into interactive dashboards, report scheduling using Tableau Server that was presented to Business Users, Program Managers, and End Users.
• Strong Data modeling experience using ER diagram, Dimensional data modeling with concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact, and Dimension tables.
• Working knowledge of ODBC, OLEDB, T-SQL, SQL, PL/SQL, Teradata, Stored Procedures, Functions, Packages, Triggers, and scripting languages.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and sequel server reporting services (SSRS).
• Experienced in executing MDX queries for the multidimensional model and DAX queries in Tabular modes in SSAS.
• Experienced in Integrating Tableau to ServiceNow to create a database and connect to the data source using Snow Mirror to perform data analysis.
• Experienced working on Informatica and Talend ETL tools to perform data integration and data management.
• Extensive Tableau Experience in Enterprise Environment 10.5/10.3/10.1/9. x/8.x/7.x and design and development of Tableau visualization and dashboard solutions using Tableau Desktop.
• Involve in the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets, and hierarchies.
• Extensive Experience in various Tableau Desktop reporting features like Measures, dimensions, Folder, Hierarchies, Extract, filters, Table Calculation, Calculated fields, Sets, Groups, Parameters, Forecasting, blending, and Trend lines.
• Responsible for developing interactive data visualizations.
• Installation, Configuration, and administration of Tableau Server in a multi-server and multi-tier environment.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design, and monitoring of system usage.
• Knowledge of Big Data Analytics Hadoop, connecting with Hadoop clusters to analyses big data and Hadoop ecosystems Hive, HBase, Sqoop, and Oozie
• Involved in upgrading Tableau platforms in a clustered environment and performing content upgrades.
• Extensive experience in Tableau Administration Tool for web Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Responsible for writing SQL Queries, Dynamic-queries, sub-queries, and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views, and Cursors.
• Involved with Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison.
• Extensive knowledge in Web Analytics using Google Analytics for implementation, validation, reporting, review, and prepare custom reports for key metrics.
• Experienced in Google Data Studio to generate insightful reports and dashboards
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, TreeMaps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization, and other making use of actions, other local and global filters according to the business/client requirement.
• Experienced in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling, and reporting tools, worked with high volume databases with partitioned data.
• Experienced in working on OLAP SSAS cube using MS SQL Server for data model creation and analysis.
• 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.
• Well-versed with Microsoft Office Suite including Office365, Lync, MS Visio, MS Access, Project, Power BI, Power Query, Power Pivot, DAX, SharePoint, and SharePoint Design.

TECHNICAL SKILLS

Business Intelligence: Tableau Desktop 6/7/8/9/10, Tableau Server 5/6/7/8/9/10, Tableau Prep, Tableau Online, Tableau Public, Power BI, Tableau Reader, Tableau Prep, MS SQL Server Integration Services (SSIS), SAS, MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), OBIEE, Google Data Studio, Alteryx, QlikView

Database Technology: Microsoft SQL Server 2012/2008-R2/2008/2005, OLAP, OLTP, Oracle 9g, Teradata, Microsoft Excel, Microsoft Access, Oracle Hyperion

Programming Language: T-SQL, PL-SQL, Javascript, HTML, XML, C++, C#, Python, R

Data Modelling: Erwin Data Modeler v7.0/v4.x, Microsoft Visual Studio 2010/2008/2005 , Microsoft Office Visio

Other Skills: Microsoft Office (MS Word/ Excel/PowerPoint), MS Project, Visual Basic 6.0, Windows 2008/2003/2000 Advanced Server, Windows NT/95/98/2000/XP/7, Ultra Edit Text Editor, Visual Safe Source 2005 (VSS)

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer

Responsibilities:

• Meeting with the business users and product owners for the requirement gathering and building the prototype based on the requirements.
• Managed visualization projects from development to production, collaborated with stakeholders and team members by following Agile methods.
• Designed technology roadmap for Tableau, product installation, and implementation development of insightful dashboards with ad-hoc and canned reporting.
• Experienced in Hadoop ecosystems- Data bricks, Azure Data Lake Store (ADLS), Azure Data Factory(ADF), HDInsight, Spark, Scala, and Pig
• Experienced ins using SQL, Spark SQL, and HIVE.
• Gathering business requirements and preparing analyses based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency supporting projects and change requests
• Experienced using ETL technologies and Big Data technologies (Hadoop, Hana, Oracle.)
• Advance analysis of the data and building advance chart types for the visualization such as donut charts, YTD calculation, Pareto charts.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts, etc. using show me functionality.
• Perform combine, shape, and clean operations in Tableau Prep using the filter, split, rename, pivot, join, union to clean and shape the data.
• Established integration with ServiceNow API to tableau by creating connections, data sources and create da shboards using Dashboard starters.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements
• Developing, implementing, and maintaining report development devoted to developing standardized reports using Business Objects.
• Deployed Tableau Connect with Azure SQL Synapse Analytics and SQL Database to set up the data source.
• Experience in extracting, transforming, and loading (ETL) data from spreadsheets, database tables, and other sources using Microsoft SSIS.
• Imported Data from a relational database into SAS files per detailed specifications
• Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Created complex dashboard using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Designed and created weekly, monthly, and quarterly analytics dashboards, reports, and meaningful KPI’s using Google Data Studio.
• Performing and collaborating in modeling, designing, and implementation of data warehouse data marts delivering reporting and data analytics using PL/SQL, SAP Business Objects, and Teradata tools.
• Creating and maintaining metadata Tableau framework/views/data marts
• Data blending of the different data sources as SQL Server, Oracle, and IBM DB2 for developing the data sources to build the reports.
• Using tableau 10 for the data blending of the different data sources and developing an interactive report.
• Embed Google maps API in the tableau dashboards for more user interaction of the reports and tracking the claims for clusters
• Publishing the reports for the on-tableau development server and tableau testing server for the user acceptance of the report.
• Using worksheet actions and dashboard actions to drill down of the different reports and URL actions for connecting the different reports through URL.
• Using the level of details calculation for the percent of total and KPI dashboards.
• Developing the dashboards with the complex calculation, parameters, and filters.
• Modifying or updating the dashboards based on the business user.
• Creating a web data connector for extracting the data from the URL for building the dashboards.
• Refreshing the tableau data extracts and running the schedules for the refresh schedules on the tableau server.
• Adding the users, and user groups of users on the tableau server and maintain the dl for the developers and the testers.
• Analyzing the store procedures and the view tables and building the complex calculation on the tableau for the development of the report.
• Unit testing and the regression testing of the reports and the data formats for the discrepancies of the data.
• Creating the different project folders on the tableau server for the publishing dashboards for the different departments.
• Managing the sites and projects on the tableau server.
• Writing custom SQL queries on the tableau desktop.
• Managing reports and solving the UI/UX defects on the reports.
• Used commands in Tabcmd and Tabadmin utility tool for Tableau Server maintains and configurations

Tools: & Technologies: Tableau Desktop 10.x, Tableau Server 10, Snowflake, SSIS, SAP Business Objects, metadata, Google Data Studio, Tableau Server 9, SAS, Python, TabCmd, IDM DB2, Data Studio 2010, JIRA, JavaScript, Java, NetBeans, Oracle, SharePoint, Microsoft Excel, SQL Server Management Studio, JavaScript API.

Confidential, Houston TX

Tableau Developer

Responsibilities:

• Agile methodology was used throughout the project and had daily scrum meetings and bi-weekly sprint planning and backlog meeting.
• Build and developed reports based on the user stories given by the product manager and product owner and worked closely with the Business Analyst.
• Built Strategic, Analytical, and operational dashboards using Power BI.
• Created complex dashboard using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Responsible for the creation of Tableau workbooks, dashboards using stack bars, Pie charts, bar graphs, scattered plots, geographical maps, Gantt charts.
• Integration of Tableau to Snow Mirror, create database, synchronizing data from ServiceNow to the database, and connecting tableau to the data to perform analysis.
• Experienced in Amazon Cloud Environment AWS (S3, EMR, AWS Glue, Databricks, Amazon Redshift, Data Lake, etc.)
• Responsible to Deliver Proof of Concepts using, understanding customer business requirements.
• 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 a certain format as required in Excel.
• Maintained consistency of SAS variables formats and sorted various datasets using PROC SORT and merged them using MERGE.
• Used regression techniques ANOVA, CORR, PROC MEANS, and PROC FREQ to analyze data
• Implemented Tableau standard operational process for granting user access and for publishing workbooks, data sources & migration between Tableau Server environments.
• Disaster Recovery setup, including Backup Primary setup and configuration.
• Installation of RStudio and Reconnect and maintaining the specifications.
• Designed and developed Data Visualizations utilizing R.
• Extensive experience in configuration, implementation, and maintenance for disaster recovery solutions using log shipping, transactional & merge replication in SQL server.
• Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau.
• Implemented row-level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Hands-on development, assisting users in creating and modifying worksheets and data visualization dashboards.
• 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 an 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 to provide integrated views and navigation inside Salesforce for the users.
• Developed various dashboards for the non-Salesforce group of users for their specific goals of understanding data.
• Created daily, weekly, and monthly reports in Cognos for 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.
• Power BI administration and development roles and helping the client with the issues of data connections, extraction, and maintenance.

Tools: and Technologies: Power BI, Tableau Desktop 9.x/10.x Tableau Server, SAS, Cognos 10.2, MS Office Suite, SQL Server, PL/SQL, R Programming, Teradata, MS Excel.

Confidential

BI Developer

Responsibilities:

• As a part of the BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing, and Implementation of BI Analytics and Reports.
• Involved in creating dashboards by extracting data from different sources.
• Designed and developed ETL workflows and datasets in Alteryx to be used for Reporting (ETL tool specific for creating datasets) Tableau Data Extract for BI.
• Involved in creating data blending in case of merging different sources, used Alteryx for Data blending for Tableau.
• Used the ETL (Alteryx) process to Extract, Transform, and Load the data into the stage area and data warehouse.
• Experienced in Amazon Cloud Environment AWS (S3, EMR, AWS Glue, Databricks, Amazon Redshift, Data Lake, etc.)
• Used Tableau Desktop Data Visualization tool for reports, integrated tableau with Alteryx for Data & Analytics.
• Involved in creating data blending in case of merging different sources, used Alteryx for Data blending for Tableau.
• Created dashboard using parameters, sets, groups, and calculations.
• Involved in creating an interactive dashboard and applied actions (filter, highlight, and URL) to the dashboard.
• Involved in creating calculated fields, mapping, and hierarchies, created drill through reports in the dashboard.
• Used Alteryx for Integration and Power BI and tableau for Business Reports.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation, and loading of data directly from different source systems like flat files, Salesforce, Oracle, Teradata, and SQL Server.
• Developed LOD reports on various KPI’s.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on the Tableau server.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Used Alteryx for data and analytics.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in the creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers, and appropriate User-defined functions.
• Used Agile/Scrum methodology for software development.
• Connected Tableau Server to Publish dashboard to a central location for portal integration.
• Worked in dimensional modeling with Star & Snowflake schemas and created the Data Source Views (DSV) and SSAS Cubes using the identified Fact and dimension tables.
• Developed robust analytical systems using MS Power BI (Excel 2013), Power Pivot (DAX), Power Query (M), and Power Map.
• Development and Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Manages platform admin functionalities including installations/configuration, upgrades, patches, change management, performance tuning, standards/ best practices, mentoring, metadata management, cluster/distributed management, cache/ history management, user management, scheduling.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Desktop 9.x/10.x, Tableau Server, Alteryx, MS Office Suite, Alteryx, Oracle, SQL Server, SQL Server Analysis Services (SSAS), POWER BI, CSV, MS Excel.