Jeyanthi Thangavelu

• Developed and maintained Tableau dashboards with interactive visualizations.
• Created custom views, charts, graphs, filters, parameters, and data sources to meet specific user requirements.
• Developed complex calculations using Tableau functions such as LOD expressions and table calculations.
• Implemented best practices for optimizing the performance of Tableau reports and dashboards.
• Collaborated with stakeholders to understand business requirements and develop appropriate visualizations.
• Assisted in designing and developing ETL processes to extract data from multiple sources into a single repository for analysis in Tableau.
• Researched new ways to visualize data in Tableau for enhanced presentation of results.
• Deployed Tableau Server security settings including authentication methods, permissions, row-level security settings.
• Analyzed data sources from Excel, SQL Server for Design, Development, Testing, and Production rollover of reporting and analysis projects within Tableau Desktop.
• Utilized scripting languages such as Python, R, SQL within dashboard development process.
• Developed data models and ETL processes to extract, transform, and load data from various sources into the BI platform.
• Created reports, scorecards, and KPIs in Microsoft PowerBI to measure business performance metrics.
• Optimized existing SQL queries for better performance when running against large datasets.
• Developed and maintained ETL processes using Informatica Intelligent Cloud Services (IICS) to extract, transform, and load data from various sources like Salesforce, SQL Server, and Teradata into the data warehouse.
• Worked closely with the Risk Management and Finance Team regarding Requirements Gathering, and provided the layouts of the dashboards to reconfirm.
• Tested, cleaned, and standardized data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Collaborated with stakeholders to identify key performance indicators for reporting purposes.
• Integrated new systems with legacy applications using APIs or web services as needed.
• Maintained documentation on all aspects of the BI environment including data models, ETL processes.
• Built OLAP cubes using SSAS for advanced analytics capabilities.

Environment: Tableau Desktop/Server, MS SQL Server, Informatica Cloud (IICS), Qlik Sense Enterprise, SharePoint, SFDC, Microsoft Office (MS Word, MS Excel, MS PowerPoint, MS Outlook), Agile, Scrum, JIRA, SQL Server Management Studio.

• Developed and maintained Tableau dashboards with interactive visualizations.
• Developed complex calculations using Tableau functions such as LOD expressions and table calculations.
• Interacted with business users in gathering, analyzing, and documenting the business requirements, and translating them into technical specifications. Developed new dashboards from the existing cubes.
• Provide guidance and insight on data visualization and dashboard design best practices in Tableau.
• Creating customized Tableau Dashboards, integrating Custom SQL from SQL Server, and performing data blending in reports.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets, and hierarchies in Tableau.
• Provided technical support on existing dashboards and reports by troubleshooting issues related to data accuracy or report functionality.
• Embed Tableau reports/dashboards onto the external web pages.
• Actively involved in the creation of users, groups, projects, workbooks, and the appropriate permission sets for Tableau server logins.
• Create complex reports using multiple queries and subqueries.
• Coordinated Tableau TWBX files to UAT/Production environments. Provided Tableau desktop training for end users and worked with end users in creating complex dashboards in an iterative process.
• Configuring scheduled updates (Automatic and User notified) for optimal performance.

Environment: Tableau Desktop/Server, Power BI, MS SQL Server, SQL, Microsoft Office (Word, Access, Excel, Outlook)

• Collected end user needs for business requirements, scrutinized and recorded them for manifold reporting requisites.
• Created views and dashboards based on requirements, and published them to Tableau Server for Business and End User teams to be reviewed.
• Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
• Created side-by-side bar chart comparison of vendors who were into retail, along with profit revenue generated.
• Involved in creating new facts, attributes, and attribute form expressions, hierarchies as needed in the project.
• Worked with a DBA to extract API data into SQL Server and connected to the same from Tableau for various reporting requirements.
• Created bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel. Created data extracts for better performance of dashboards and accessing data offline.
• 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.
• Integrated dashboards with live connection in Microsoft PowerPoint.
• Created reports using Custom SQL for complex report views.
  Participated in weekly meetings, reviews, and user group meetings, as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop/Server), Oracle, SQL Server, SQL BI Suite (SSIS, SSRS), MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint)