PROFESSIONAL SUMMARY:

• 9+ years of experience in Analysis, Design, Development and Implementation of Business Intelligence Projects and 8+ years of experience in data visualization as a Tableau Developer and Tableau Administrator.
• Expertise in Tableau ( 2018.1/2019.1/10.5/10.4/10.3.1/10.2/10.1/10.0/9.2/9.1/8. x/7.x, Tableau Desktop, Tableau Server, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader, SQL, PL SQL and Unix Shell Scripting.
• In depth knowledge of SAS Visual Analytics, SAS Programming, data processing, data collection, qualitative and quantitative data analysis.
• Acquired excellent knowledge of statistical software’s like SAS STAT, SAS GRAPH, SAS SQL.
• Good programming experience with SAS programming, data processing, data manipulation.
• Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Online.
• Used Level of Detail techniques to show details of data at various levels.
• Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.
• Experienced in creating calculated fields using various functions to pull out data over periods of time like months/years.
• 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
• 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.
• Worked on connecting tableau to various other data sources like Oracle, Teradata, SAP Hana, Microsoft Access, SQL Server and had experience in establishing respective driver connections.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Gant Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop
• Created highly interactive Data Visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets and Aggregate measures.
• Experienced with Machine learning algorithms. Python 3.5(NumPy, Pandas, Matplotlib and Sci-kit-learn), Decision Tree, Random Forest, Naïve Bayes, Logistic Regression, Linear Regression, Multiple regression, Cluster Analysis, Neural Networks, KNN, SVM, k-means from Mathematical perspective.
• Experience in implementing data analysis with various analytic tools, such as Anaconda 4.0, Jupiter Notebook 4.X, R RShinny, (ggplot2, Caret, dplyr) and Excel.
• Involved in the entire data science project life cycle and actively involved in all the phases including data extraction, data cleaning, statistical modelling, and data visualization with large data sets of structured and unstructured data.
• Skilled in Advanced Regression Modelling, Correlation, Multivariate Analysis, Model Building, Business Intelligence tools and application of Statistical Concepts.
• Ability to write and optimize diverse SQL queries, working knowledge of RDBMS like SQL server 2008, NoSQL databases like MongoDB 3.2.
• Proficient in database Design, Modeling, Creating Stored Procedures, Indexes, Functions, Triggers, Views using SQL Server
• Played an active role during the requirements gathering and developed Entity Relationship Diagrams using Data Modeler tool
• Written complex SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules
• Extensive experience in mitigating the database redundancy using Normalization techniques.
• Well versed in integrating Tableau with ETL tools like SSIS, SSRS and, Big Data Technologies like Hadoop, Amazon Redshift, Spark SQL and AWS.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure the views and dashboards were displaying the changed data accurately
• Experienced in building highly interactive dashboards using sheet swapping techniques and Action filters
• Designed the architecture of Tableau security 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.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Published Tableau dashboards based on datasets from Kaggle on Tableau public profile
• Utilized techniques such as cutting down the size of extracts, creating materialized view, using custom SQL for joins to optimize the dashboard performance.
• Expertise in Tableau security systems and controlling the levels of access for various user groups by assigning row level security using user filters at workbook and folder levels.
• Expertise in Tableau server installation, Configuration, Upgrade, and enforcing security in Tableau.
• Deployed tableau server in clustered environment by adding worker machines.

TECHNICAL SKILLS:

Tableau: 2018.1/2019.1/10.5/10.4/10.3.1/10.2/10.1/10.0/9.2/9.1/8. x/7.x, Tableau Server, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader C, C+ +, C#, JavaScript, SQL, PL SQL

Platform: UNIX, Win 98/XP/2000/NT, DOS, Windows 7/8/10

Data Warehousing: BW 3.5, 3.1c, 3.0b, BI 7.0, Oracle 9i/ 8i/7.3, MS SQL Server 2012/10, Access, Teradata, AWS

EXPERIENCE:

Confidential, Miami, FL

Tableau Developer

Responsibilities:

• Designing, developing, testing, and maintaining Tableau reports and dashboards based on user requirements.
• 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 on one 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 ad-hoc 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.

Confidential, Parsippany, NJ

Tableau Developer

Responsibilities .

• Involved 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 and Tableau
• Experienced in creating the groups, users, workbooks and, also permission sets for the tableau server logons and checks
• Ran SQL queries in Oracle database to analyze and manipulate data.
• 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 into 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/snowflake schema designs and expert in modelling the transactional databases and data warehouse.
• 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.
• Partnered with ETL lead and supports ETL Lead and developers through the development of complex ETL routines to load a dimensional star schema.
• 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.
• Working with Data Architecture, Security Architecture, SSO team, AD team and Infrastructure SME’s to ensure that all aspects of the solution architecture are defined and elaborated.
• 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 within Tableau Desktop.
• Worked extensively with Advance Analysis Actions, LODs ( FIXED, INCLUDE, EXCLUDE ) Calculations, Parameters, Background images, Maps.
• 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.

Confidential, Phoenix, AZ

Tableau Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards , report scheduling using Tableau server.
• Setup and configuration of Tableau server in various environments and used Tableau CMD and Tableau admin tools to configure the server per best practices.
• Scheduled 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.
• Related views in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
• Setup trusted authentication in Tableau server and pass requests from Web server.
• Gathered Business Requirements by interacting with Business Users, Project Manager and SMEs.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Word clouds, Bubble Charts, Pareto Charts ) based on client’s need.
• Used Alteryx to provide analysts the unique ability to easily prep, blend, and analyze all their data using a repeatable workflow.
• 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.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Converted existing Cognos Reports into Tableau Dashboards.
• Connected to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Extensively worked on micro strategy administration that includes intelligence server administration, configuration of memory settings and performance monitoring.
• Setup trusted authentication in Tableau server and pass requests from Web server
• Setup user security for the entire landscape to facilitate Windows AD login.
• Worked heavily using Tab-admin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• Worked on Setting up Tableau Server on AWS.
• Actively involved in the Server migration and the Tableau Server Installation process.
• Implemented pivot/un-pivot, transpose features of Power BI to load data into excel Power Pivot.
• Used Elastic Load Balancing to distribute requests across multiple gateways in a Tableau Server cluster.
• Creating users, groups, projects, Data Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Worked in the conversion of SQL server functions into the Teradata Store procedure for confirming the data.

Confidential, Tyson’s Corner, VA

BI Developer

Responsibilities :

• Used calculated fields substantially for exceptional logics for Trend, Extended price calculations for the distinctive cost types.
• Performed Tableau Admin work such as granting permission to users, scheduling extracts and managing installations.
• Created charts such as Line charts, Donut Charts, Pie Charts, Tree Maps, Funnel Charts based on client requirements.
• Utilized several WMS Servers for configuring Tableau field Maps with different geographical locations.
• Analyzed data by using distinct set of Filters and Dynamic Measures.
• Worked on Data Analysis by utilizing trend lines, forecasting techniques on Tableau
• 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 read 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 dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Creating New Schedule's and checking the task's daily on the server
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.
• Analyzed data using Filter Shelf, Conditional filters (by using formula), and Dynamic measure filters.
• Created worksheets using parameters and used features like sorting, grouping, sets.

Confidential, Minneapolis, Minnesota

BI Developer

Responsibilities :

• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Defined best practices for Tableau report development and effectively used data blending feature in Tableau.
• Experience in Tableau Server Installation, Configuration, Maintenance, Security, creating users, groups, projects, assigning access levels. Production support for monitoring server health.
• Provided ad-hoc analysis of compensation outcomes, investigate data discrepancies, and respond to field support calls concerning incentive compensation data.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created business driven dashboards using different chart types like Crosstab's, Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Gantt charts, Bubble charts, Scatter Plots, Trend lines, Bullets, Bullet Graphs, Highlight tables and Histograms in Tableau Desktop.
• Design, analyze, and present incentive compensation plans to motivate selling efforts of 500+ senior account managers and their supervisors.
• Designed the architecture of Tableau security 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.
• Developed Business Requirement Specs as a Business Intelligence developer.
• Published Tableau dashboard on Tableau Server and embedded them into portal.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Expert in generating complex, dashboard reports, ad hoc, business views along with user acceptance test and data accuracy test .
• Worked in the agile methodology using Scrum , which has its primary focus on the management part of the software development in small iterations of four weeks sprint.
• Handled user licenses for projects
• Involved in creating database objects like tables, views, procedures triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Executed and tested required queries and data before publishing Dashboard.
• Mentored business power users to create reports/dashboards using Tableau dashboard.
• Understand the requirements and functionality of the application from specifications.
• Planned and implemented the overall analytics and Business Intelligence strategy.
• Provided production support to Tableau users and wrote Custom SQL to support business requirements.