SUMMARY

• Over 5 years of experience as Tableau Developer / Data Analyst which includes Tableau Server/ Tableau Desktop/ Tableau Reader, Business Intelligence, Development, Data Modelling and Implementation in all phases of Datawarehouse development.
• Expertise in Tableau BI reporting tools such as Tableau Dashboards Developments & Server Administration and Data Modeling.
• Mastered in creating solution driven dashboards by developing different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Bar Graphs, Bubble charts, Funnel Charts, Box plots, Waterfall Charts, Geographic Visualization, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms and other making use of actions, other local and global filters according to the end user requirement.
• Experience in configuring reports from different data sources using data blending.
• Expertise in Tableau advanced analysis features like Actions, Calculations, Forecasting, Parameters and Trend lines.
• Proficient in building models such as Logistics, Regression, Neural Network, Classification Tree, and K Nearest Neighbor .
• Worked on model building, data extraction, transformations and loading, Mappings & Workflows, customized and Ad - hoc analytics reports.
• Organized numerous Joint Application Development (JAD), Joint Requirement Planning (JRP)) sessions, interviews, and user stories meetings with the end user/clients/stakeholders and the technical team members.
• Proficient Star Schema dimensional modeling understanding business processes, modeling dimensions, hierarchies and facts.
• Experience in developing reports with complex sub reports using Drill down/Drill through, Cross Tabs, Formulas, Functions, Parameters, Tree, Multiple Grouping, Running Totals, Charts, Graphs, Mapping, and Multiple Sections.
• Developed storytelling 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.
• 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.
• Experience in writing SQL queries involving multiple tables inner, outer joins and stored procedures
• Experienced in writing Parameterized Queries for generating Tabular reports.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Waterfall, Scrum, Test Driven Development (TDD), SQL Server Migrations, change control rules, problem management and escalation procedure

TECHNICAL SKILLS

• Tableau Desktop || Tableau Server || MS SQL Server ||MS Visio || Python || R studio || Data & Business Analytics || Microsoft Office Suite || SSIS (Microsoft SQL Server Integration Service) || SSRS (Microsoft SQL server Reporting Service) || HTML || || XML || Share Point || Minitab || MS Access || My SQL || Oracle ||

PROFESSIONAL EXPERIENCE

Confidential, Maumee, OH

Tableau Developer/ Data Analyst

Responsibilities:

• Designed, tested, and maintained Tableau functional reports based on requirements.
• Developed Tableau Dashboards provide insights of automobile industry consumer interests and preference using scatterplots and bar charts .
• Developed donut charts for better representation and using table calculations to calculate key figures, manipulating strings, arithmetic calculations, aggregation options and logical functions.
• Created executive weekly view dashboards presenting leads, sales, competition, and forecast for the sales & marketing team bar charts, line charts, and pie charts.
• Designed standardized DataMart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL developers, DBAs, Data Modelers in implementation.
• Collaborated in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Designed and Modified Materialized Views, Views with preferred granularity of the data and aggregating data needed for Tableau Reports and producing executive level tableau dashboard visualizations for senior management
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right) in Tableau desktop to validate and reconcile data.
• Generated various dashboards in Tableau server using various data sources like SQL Server, Oracle, Excel, Text, and Salesforce using data blending feature in tableau.
• Worked extensively with advance analytics like implement logistics regression model and checks validations, outliers, and overfitting issues to find out potential customers of electric vehicles.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Worked and generating various workbooks and dashboards extracting data from various sources such as Oracle, SQL Server and data files using data blending and joins.
• Generated dashboards with quick filters, parameter and sets to handle views more efficiently.

Environment: MS SQL Server, MS Access, Oracle, MY SQL, Teradata, HTML, SQL Server Management Studio, Microsoft Office Suite (Word, Excel, PowerPoint, Visio).

Confidential, Detroit, MI

Tableau Developer/ Data Analyst

Responsibilities:

• Worked with different departments and participated in requirement gathering sessions to understand the business needs and then translate them into technical specifications.
• Developed the functional specification documentation for the modules to be developed.
• Improved usability of credit card data through cleaning, combining like terms, and performing model assumptions checking.
• Worked with credit card product specialists reviewing credit card program and roadmap development on a regular basis.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
• Responsible for tuning T-SQL procedures, triggers and other database objects.
• 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.
• Create analytical reports with visually rich and interactive dashboards at each stage of loan approval using Tableau Desktop.
• Created Row Level Security and shared the reports with Functional/Business users.
• Worked on groups, sets, different advanced calculation functions including table calculations and window calculation.
• Used Tableau Desktop to create various analysis worksheets, including customer analysis and equipment analysis.
• Worked with credit card risk specialists by understanding the underlying risks, fraud trend, and detection of suspicious and fraudulent card activity.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting.
• Expert in implementing an extra level of security by creating views and creating stored procedures to query the confidential data

Environment: Tableau (Desktop/Server), Erwin, Teradata, Oracle, VISIO, JIRA, MS Office Suite

Confidential, Traverse City, MI

Tableau Developer/ Data Analyst

Responsibilities:

• Collaborating with financial management department to deliver clear and well-thought out dashboards and data visualizations and to develop new reports and updated/ enhanced the existing reports.
• Ensure Tableau reports are functioning at the highest efficiency possible and created reports and Dashboards using Tableau to help executives to analyze financial data.
• Extract data from Teradata and ensure reports follow best practices for visualization and usability.
• Created customized reports using various chart types like text tables, bar, pie, Heat maps, line charts, Area charts, scatter plot, dual combinations charts in Tableau.
• Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
• Document report requirements and methodology used to prepare reports.
• Worked deeply in Calculations, Parameters, Maps, Trend Lines, Statistics, Groups, Hierarchies, Sets to create detail level summary report and Dashboard using KPI's on the domestic cost, inventory, new setup dimension.
• Assess and resolve any issues that arise when developing reports.
• Upload new and updated reports to Tableau Server.
• Ensured reports issued to the government passed system tests by identifying and solving ongoing compliance issues and promptly responding to error messages.
• Inspected various financial documents and reports for accuracy and compliance.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Developed dashboards to show reconciled claims data over different time periods.
• Created filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Published customized interactive reports and dashboards to Tableau server.
• Outlined and created different analytical reports from various information sources by blending data on a single worksheet in Tableau Desktop.
• Experienced in writing Parameterized Queries for generating Tabular reports.
• Involved in testing and executing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards before publishing.
• Maintained server activities, user activity, and customized views on Server Analysis.
• Created Business requirement documents and plans for creating dashboards.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Verified and tested Dashboards to ensure data matching as per the business requirements.

Environment: Tableau, Tableau Server, Oracle, PL/SQL, Teradata, Microsoft Team Foundation Server (TFS), Microsoft Office (MS Excel, MS Access, MS Visio), Windows, Agile Methodology, Scrum

Confidential

Tableau Developer / Data Analyst

Responsibilities:

• Elicited product owners to solicit visualization requirements, recommending changes, creating prototypes, giving demos to the users.
• Visualized the production funnel report by using bar graphs, area charts, and calculated fields reflecting all the stages of powder processing area to assist continuous improvement team in identifying major product loss spots.
• Assisted the predictive maintenance team by analyzing the vibration trends of machines over a daily basis (time series analysis)
• Worked in Migration project Tableau 7.0 to Tableau 8.3.1 Worked with the Tableau desktop users in migrating their local desktop workbooks to Tableau 8.3.1
• Publish the developed dashboard, reports on the Tableau Server so the end users having access to the server can view the data.
• Created advanced metrics (simple, nested & compound), advanced filters, advanced prompts, report designs and drill maps.
• Creating complicated calculation based LOD (Level of detail) feature.
• Creating and documenting Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF etc.
• Combined multiple dashboards into a single story to enhance the visual appeal of the report.
• Reconciled the report data with the source systems and reviewed it to find data anomalies.

Environment: Windows, Tableau Desktop, Tableau Server, MS Office Suite, Oracle, SQL Server, MS Excel, Microsoft Visual Studio, MS Excel.