| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateJeyanthi Thangavelu E-mail: EMAIL AVAILABLEBI Developer/Tableau Consultant Contact: PHONE NUMBER AVAILABLESUMMARY:Highly motivated Tableau developer with around 8+ years of extensive experience with design and development of Tableau visualization solutions with expertise in SQL Server Development.Experience in Tableau Desktop, Tableau Server, and Tableau online in various versions of Tableau and SQL.Design, develop, and implement end-to-end data integration solutions using Informatica Intelligent Cloud Services (IICS).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.Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.Good knowledge on Data Analysis Expressions (DAX) for accessing data directly from tabular database.Proficient in design, development, implementation & administration of database systems using MSSQL for batch processing using DDL, DML, DCL commands for various business application and data ware-housing systems.Experience in database programming in writing SQL Server Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) indexes and Batch Scripts using various DDL and DML commands.Efficient in identifying and analyzing Business requirements from documents and end-user discussions.Experienced in designing rich interactive reports and dashboards integrating various reporting components from multiple sources.Proficient in design and development of various dashboards, reports utilizing Tableau, Qlik Sense and Power BI.Visualizations like bar graphs, scatter plots, pie-charts, maps, funnel charts, donuts, bubbles, etc. and other making use of actions, other local and global filters according to the end user requirement.Extensive knowledge in various reporting objects like Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Parameters etc.Good knowledge on Embedded views of Tableau with web applications to integrate reports.Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort, and Derived Column.Experienced in all facets of SDLC (Analysis, Design, Development, Testing and Maintenance) using Waterfall and Agile methodologies.Excellent analytical, problem solving, communication and time management skills.TECHNICAL SKILLS:Business Intelligence ToolsTableau Desktop/Server, Qlik Sense, Power BI, LookerRDBMS ServersOracle, MS SQL ServerOperating SystemWindowsProgramming LanguagesHTML, XML, SQLDatabasesSQL Server, Marketo,Salesforce, TeradataETL & other ToolsInformatica intelligent cloud services (IICS), Share point, Copy Storm, WinSCP, Jira, MS officeMethodologiesWaterfall, AgileEDUCATION: Masters Degree in Mathematics CERTIFICATION: Tableau Desktop Specialisthttps://www.credly.com/users/jeyanthi-thangavelu/badges?sort=most_popular&page=1PROFESSIONAL EXPERIENCE:Client: Verizon Aug2023-CurrentRole - Tableau Developer/BI DeveloperResponsibilities:Involved in gathering requirements from the Business users and producing technical, functional specifications for the reporting system. Understanding the business scenarios of the existing systems, understanding the data, and validating the data by applying the current business rules.Analyzed data sources from Excel/ SQL Server for Design, Development, Testing, and Production rollover of reporting and analysis projects within Tableau Desktop.Effectively used data blending feature in Tableau to connect different databases like Oracle, MS SQL Server and Excel. Created data blending in case of merging two different datasets using Tableau.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.Extracted data from different data sources like SQL Server, MySQL and Tableau Server and created queries based on the requirement to provide data visually.Designed, developed and established KPIs and success metrics for new systems and processes to track and measure.Analyzed the data on MS SQL Server and developed Tableau visualizations and dashboards using Tableau Desktop.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.Worked closely with the Risk Management, Finance Team regarding Requirements Gathering and provided the layouts of the dashboards to reconfirm.Built functionalities by writing condition to incorporate with various metrics and hands on experience in Level-of-Detail (LOD) expressions such as daily profit Key Performance Indicators (KPI), Percent of total, Yearly trending analysis and Root cause behavior.Created Relationships, Actions, Data Blending, Filters, Parameters, Hierarchies, Calculated fields, Sorting, Grouping, Live connections and in-memory in both Tableau and Excel.Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker Plot, Scatter Plots, Geographic Map, Cross tabs, Histogram, Pie charts, etc.Used various sources to pull data into Tableau such as SQL Server. Used SQL queries to develop Tableau reports.Weekly presentation to the business users about the Tableau reports and their changes as required.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.Explored data in a variety of ways and across multiple visualizations using Tableau.Scheduled Automatic refresh and scheduling refresh in Tableau service.Worked extensively with Advance analysis, Drill down, Drop down, Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes in Tableau.Created SQL stored procedures, triggers, cursors, tables and views, and other SQL joins and statements for applications. Written Custom SQL to support Business requirements.Worked with team actively for the migration of data from one environment to another.Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.Experience with Tableau reporting/data visualization tool and integration between SQL and Tableau.Forecast based on the historical records and the total spend in the coming quarters/years.Created groups and managed group access on Tableau server, managed refresh fail log on Server.Trained the team on Tableau Desktop as well as Server regarding report scheduling.Automated the monthly scorecards and reduced the internal effort by 90%.Managed multiple projects from initiation to post go-live support including project plan creation, leadership of the project resources, managing the timeline, milestones, deliverables, and ensuring an overall successful implement.A 12% reduction in man work resulting in saving time and improving other areas of work due to the scheduled dashboards.Environment: Tableau Desktop/Server, MS SQL Server, Informatica Cloud( IICS), Qlik Sense Enterprise, Share Point, SFDC, Microsoft Office (MS Word, MS Excel, MS PowerPoint, MS Outlook), Agile, Scrum, JIRA, SQL Server Management Studio.Client: Porzio Life Sciences LLC Jan2020-July2023 Role - Tableau DeveloperResponsibilities: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. Responsible for recreating reports and dashboards.Used advanced data visualization tools to provide an easy-to-understand interface for end users to quickly identify key themes within their data.Identify key business metrics measurements and develop methods to represent data in support of the measurements. Created reports for Metrics.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 andhierarchies in Tableau.Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.Stretched Tableau limits to create unconventional Tableau charts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Bullets, Tree maps, Box and Whisker Plot, Heat maps and logical calculations to create groups.Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations, and complex calculations to manipulate the data and exported data from different data sources.Used excel sheet, flat files, CSV files to generate Tableau ad hoc reports.Generated context filters and used performance actions while handling huge volumes of data.Embedded Tableau reports/dashboards on to the external web pages.Provide innovative solutions and deliver improved methods of data presentation by focusing on the Business need and the Business Value of the solution.Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development.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 sub queries.Co-ordinated 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)Client: G&M Health LLC Feb16Dec19Role - Tableau DeveloperResponsibilities:Gathered business requirements from end users, analyzed and documented the same for various reporting needs.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 DBA to extract API data into SQL Server and connected to the same from Tableau for various reporting requirements.Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.Developed various dashboards, used Context filters, sets while dealing with huge volume of data.Used parameters and input controls to give users control over certain values.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.Blended data from multiple databases into one report by selecting primary keys from each database for data validation.Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.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). |
