| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLE Mobile: PHONE NUMBER AVAILABLETableau Public Portfolio:https://public.tableau.com/app/profile/usha7244Certifications: Tableau Desktop SpecialistProfile Summary:Skilled Technologist over 10+ years of progressively responsible experience in all phases of Tableau developer and power BI tools. Involved in creating and publishing dashboards using Tableau Desktop & Tableau server.Experience in creating highly interactive visualizations with Tableau Desktop, Tableau Server, Tableau Public and Tableau Reader in various versions (2020.x/2019.x/2018.x/10.x/9.x/8.x/7.x) of Tableau Software using features such as Data Joining & Data Blending.Expertise in Requirements gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Business Intelligence Analysis projects and writing detailed business requirements and translating them into technical specifications and identify critical KPIs.Created 500+ worksheets and 100+ Dashboards in large Business Intelligence environments using Tableau Software.Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.Experience on LOD expressions, Comparative Sales Analysis, Customer Acquisitions, etc.Designed various types of charts like Gauge chart, & Heat maps, Tree maps, Line area charts, Stacked-bar chart, Bubble chart.(Custom charts like Butterfly chart, Lollipop Chart, Sun burst Chart)Expertise knowledge on Gantt charts, Histograms, Bullets, Box and Whisker Plots, Highlight tables, and Expertise in using Trend Lines, Statistics, and Log Axes, Groups, Hierarchies, Sets to create detail level summary report and Dashboard using KPI's.Expert in creating Calculations (Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.Performed Unit Testing across Multiple Reports, user level security and row level security.Worked on different Administration tasks such as data loading, batch jobs, data uploading, backup &recovery, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/transaction logs.Experience in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.Proficient in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).Expertise of SQL queries, SSRS, and SQL Server Integration Services (SSIS) including DAX.Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2016, 2012.Used tools like MS SQL Profiler, Index Tuning Wizard, and Pervasive and Windows performance for monitoring and tuning SQL Server performance.Excellent experience in writing SQL Queries using various objects like views, tables, Joins, Sub Queries, stored procedures, functions, and other advanced SQL conceptsStrong experience in Trouble Shooting, Performance tuning of reports and resolving issues within source data and reports.Experience in taking back ups and restoration of Tableau repository.Applied Python and R programming languages, machine learning algorithms, and advanced analytics techniques to enable the predictive modeling of large data setsOutstanding data analysis skills including Data mapping from source to target database schemas, Data Cleansing, and processing, writing data extract scripts/programming of data conversion and researching complex data problems and generating analytical reports/dashboards.Used Python libraries for data cleansing and manipulation.Used Python to import data and perform data cleaning and integrated it with Tableau to build visualizations.Good Knowledge on database management systems, Data warehousing concepts, online analytical processing (OLAP) and ETL framework.Implemented various ETL logics for data transformation and data movement activities using Azure Data Factory and Azure Synapse Analytics.Created different Power BI reports utilizing the desktop and the online service and schedule refresh.Created different visualizations in the reports using custom visuals like Also, using different transformation inside edit query into clean-up the data.Migrated reports from Tableau, worked on data from OBIEEWorked on event-based triggers, automating data flows. Good knowledge on all activities, mapping and wrangling data flows.Strong experience in Data Modelling of relational normalized/denormalized table structures.Good experience in performance tuning of DAX queries.Proficient in designing/building complex stunning reports/dashboards using Filters (Slicers), Drill-down Reports, Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Sub reports and Ad Hoc reports in Power BI Desktop.Experience in creating fact and dimensional model in MS SQL server and Snowflake Database utilizing Cloud base Matillion ETL tool.Worked with Teradata database and extracted data using Alteryx and developed POCs by building reports and dashboards using Tableau to demonstrate quick wins.Worked on scheduling the extracts and setting up the permissions.Sound knowledge and understanding of Primary and Foreign key relationship in RDBMS.Extensive usage of Tableau Version 10.5 Hyper feature for faster data ingests and analytical query processing on large or complex data sets.Strong experience in Trouble Shooting, Advanced knowledge of performance optimization and perform Upgrades, Create comprehensive documentation of data lineage for various datasets.Understanding of Software Development Life Cycle (SDLC) methodologies including Waterfall and Agile.Stayed up-to-date with Tableau software updates and new features to continuously improve data visualization capabilities, resulting in improvement of dashboard design and user experience.Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation skills, and Leadership Qualities. Demonstrated ability to self-motivate and be flexible within a fast-paced environment.TECHNICAL SKILLSOLAP and Reporting ToolsTableau Desktop (2021.x/2020.x/2019.x/2018.x/10.x/9.x/8.x/7.x), Tableau server, Tableau Cloud, Tableau advanced Management system, Tableau Prep, Tableau Online, UX,Microsoft Power BI, SAP Business Objects(SAP BO), SAS, Quick sight.SSIS, DataikuServerTableau server, SQL server(2010,2016,2017),AWSETL ToolsMatillion ETL, Alteryx., Tableau Prep, SSISProgramming Languages/LanguagesT-SQL, SQL, Postgres SQL DAX, Python,R, Python, HTML, XML.Databases/ DWSQL SERVER, Teradata, Snowflake, Oracle, Microsoft SQL, Microsoft Access, Snowflake, InformaticaTools/ Tracking ToolsSSMS, Azure Data Studio, Teradata SQL Assistant, JIRAOthersKnowledge on PowerShell Scripting, Agile/Scrum methodologies. Excel (pivot,Macros),BPSEducation: Bachelor Degree -2010-JNTUProject 1Duration: March 2022 Till DateEnd Client: Cook MedicalRole: BI DeveloperEnvironment: Tableau Desktop, Tableau Server, ( Tableau 2022.3 / 2021.2, Tableau Server 2022.3 / 2021.2, Microsoft SQL(Server 2016) Informatica ETL, Snowflake Database.Roles & Responsibilities:Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.Created LOD expressions, Comparative Sales Analysis, Customer AcquisitionsWorked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.Created Dashboards on Sales Analysis which include YOY growth, YTD sales, PYTD Sales and Customer acquisition Dashboard which included cohort charts giving insights on retention, acquisition of customersTested reports and uploaded tableau dashboards on to server and provided production support for tableau users.Upgraded tableau versions and gathered requirements, analysed from raw data.Worked on ECIDS by providing stakeholders with dashboards to leverage data effectively for improving early childhood education policies.Visualize and analyze data with snowflake, creating stories giving insights for the annual analysis of policies.Have a good knowledge about Improved workbook version compatibility.Good knowledge on Tableau Metadata tables postgre SQL and created custom admin views to monitor the Tableau server Usage metrics.Experience with Advanced SQL for extracting data, normalisation and datamodellingWorked with the database designer in data modelling through ER diagrams to identify tables, attributes, and relationships between tables.Created mapping and test case Documents for ensuring Proper compliance with the BRDCreated reports and implemented latest features like Viz in Tooltip, Nested projects.Collaboration with business stakeholders to comprehend their data requirements and offer solutions that meet them.Plan and implement the overall analytics and business intelligence strategy.Installed and configured Tableau Server environment to meet organizational needs, ensuring optimal performance, scalability, and securityManaged user access and permissions on Tableau Server, including creating user accounts, assigning roles and permissions, and ensuring data security and compliance with organizational policies.Automation of process has been done using python.Created and documented Standard Operating Procedures (SOP) for Capping Calculator.Design and Develop ETL (informatica) workflows and datasets, worked closely with apps engineers and analysts. . Coordinate with ETL teams to Cleanse Data and minimized risk of manual data manipulation.Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and Data Stage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.Project 2Duration: February 2020 2022End Client: Altria Group INCRole: BI DeveloperEnvironment: Tableau 2020.3 / 2020.2, Tableau Server 2020.3 / 2020.2, Microsoft SQL Server 2013, Toad 13.2, SQL Server, Power BI, SSIS, Altyrex, Tableau prepRoles & Responsibilities:Designed Dashboards by using Quick Filters, Calculations and Parameters.Created dashboards with insights like Trendlines, Time series analysis, Forcasting of growth and sales in the business.Generated reports weekly and monthly basis as per client requirement.Created conditional filters and Action links to filter the data on dashboard.Created Filter Actions to navigate from one Dashboard Visual to another Dashboard.Worked closely with business users to identify various KPIs and designed solutions to enhance business decision-making.Developed Tableau dashboards, providing insights that allowed management to focus on loyal customers, raising revenue.Worked with Client different teams of finance, risk, and others to gather key requirements for designing a data warehouse model, which successfully raised efficiency.Involved in creating and developing reports and dashboards using Tableau Desktop 10.5Involved in creating data visualizations like Bar charts, cross tab, Tree Maps, Line charts, Scatter plot, Mapping Visualization etc with Tableau desktop 2022.3 / 2021.2.Analysed large volumes of data and developed medium to complex reports/dashboards, insights for clients. Has an in-depth understanding of the tools used for analysis, reporting, and developing business insights. Involved in creating reports and dashboards using various charts with Tableau.Led the migration process of Tableau reports and dashboards to AWS cloud infrastructure, ensuring seamless transition and optimal performance for end users.Design and develop ETL workflows and datasets in Alteryx to be used by the BI reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)Implemented data refresh scheduling using AWS automation tools, ensuring that Tableau data extracts are updated at the appropriate intervals.Collaborated with the AWS team to implement backup and disaster recovery strategies for Tableau workbooks and data in the cloud.Worked on cost optimization strategies, ensuring efficient resource utilization and managing AWS billing for the Tableau environment.Project 3Duration: March 2018 - January 2020End Client: PrudentialEnvironment:Tableau 2017.x, 2017.x (Desktop Server), Snowflake, Teradata, Metric Insights, Microsoft Office Suite (Word, Excel, PowerPoint).SSIS,Power BI 2013, SharePoint 2010, XML, T SQL, MS Excel.Role: Tableau DeveloperRoles & Responsibilities:Applied advanced Tableau functionalities including Level of Detail calculations, Table Calculations, and Calculation fields to visualise complex supply chain data effectively.Validated and optimised supply chain data using SQL queries, ensuring accuracy and performance efficiency across different environments.Leveraged statistical functions, advanced analytical techniques, trend analysis, and forecasting within Tableau to provide actionable insights into SCM processes.Provided technical support and troubleshooting assistance for related reports and dashboards, addressing issues within both source data and visualisation components.Collaborated closely with business stakeholders to gather specific requirements and translate them into effective Tableau visualisations.Interacted extensively with analysts, data engineers, and stakeholders to analyse and report key performance indicators (KPIs).Created geographical dashboards, different histograms, bar charts which gave useful insights in different sectors like sales, research and development.Created Dashboards and Stories with different analytics like forecasting, trend lines which compelled important insights.Developed different KPI which helped the clients to optimise the operation and productivity and risk management.Extensively involved in User Acceptance Testing (UAT).Project 4Duration: March 2015 - January 2018End Client: KPMGEnvironment: Tableau 7.x/6.x (Desktop/ Server), Oracle DB, Microsoft SQL Server, SQL, Microsoft Excel 2007, MS Access, Windows 07/08 server, Microsoft office 2007MS SQL Server, MS Office 360, Excel 2016, Microsoft Office SharePoint Server, XML, MS Visual, Power BI, Tableau Desktop.Role: BI AnalystRoles & Responsibilities:Analysed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Centre.Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.Used Tableau Version 7 for easier date manipulation.Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.Responsible for analysing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.Resolve the batch monitoring related issues with respect to the purchasing module.Followed company code standardization rule.Responsible for creating test cases to make sure the data originating from the source is making into target properly in the right format.Performance and tuning of SQL servers and application issues related to migration.Testing of applications for performance, data integrity and validation issues.Developed and maintained a complex data model for a financial services client, ensuring accuracy and consistency of data and enabling the client to make data-driven decisions with confidence.Created multiple kinds of Power BI Reports and Dashboards.Designed and developed SSIS packages for Tableau dashboards.Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. |
