SUMMARY

• 5.5 + years of IT experience with expertise in analysis, design, development and implementation of Dashboards and Reports using Tableau visualization tools, excel and SQL.
• Strong Experience in creating dashboard, reports through Tableau.
• Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation.
• Involved in creating dashboards and preparing ad - hoc reporting in Tableau.
• Interacts with business user at various levels and coordinated meetings during the different cycles of the project.
• Having good knowledge in Power BI development skill set including visualization development, use of parameters, and report optimization
• Strong knowledge of data warehousing methodologies and agile methodology.
• Involved in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Tableau.
• Generated context filters and data source filters while handling large volume of data.
• Involved in creating Filters, quick filters, table calculations, calculated measures etc.
• Have good experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need.
• Experience in utilizing tableau functions which includes Aggregation, Counting, Logical, information, Text and date functions.
• Worked with ETL team, helped then on Data Analysis, Data Migration, Data Cleansing, Transformation, Integration using ETL tools such as SSIS.
• Good understanding of the Data modelling (Dimensional & Relational) concepts like Star-Schema Modelling, Snowflake Schema Modelling
• Experience in testing and writing complex SQL statements.
• Part of the end user team where in gathered requirements and organized scrum meetings.
• Prepared projects, dashboards, reports and questions for all JIRA related services.
• Good experience in Migration of Reports & Packages in different environment.
• Proficient in Tableau data visualization tool to analyse and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• Mastered the ability to design and deploy rich Graphic visualizations using Power BI and Tableau.
• In-depth knowledge on SQL queries and working with MS SQL Server databases.
• Well versed in query optimization for performance tuning and monitoring of processes.
• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts. Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
• Worked on data blending and increased the dashboard performance by extracting data.
• Excellent business communication and presentation skills. Adept at creating, editing, and coordinating extensive communication networks keeping executive staff and team members apprised of goals, project status, and resolving issues and conflicts.
• Completed projects successfully with the help of teams to achieve deadlines timely and proficiently.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Tableau Developer

Responsibilities:

• Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the reporting needs.
• Discussed with stakeholder teams to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.
• Prepared STTM (source to target mapping) for report development
• Wrote complex SQL queries to read data from source databases to analyses source system after joining multiple tables.
• Worked with data modeler to understand data model from different source system.
• Worked on the design and development of Tableau visualization solutions and Created Business Requirement documents and plans for creating dashboards.
• Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
• Defined best practices for development and effectively used data blending features in tableau
• Developed different types of visualizations like Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts Waterfall and funnel charts, Gauges and single-number cards, Visual hierarchies and drill-down in the tableau reports.
• Used different functions like number, string, date, Type conversions and Aggregate functions.
• Developed custom SQL queries to minimize the data to improve the performance in Tableau
• Utilized advanced features of Tableau software like link data from different data sources together on one dashboard to filter data in multiple views.
• 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 changes to ensure that the views and dashboards displayed the changed data accurately.
• Used Excel sheet for multiple purposes such as data analysis, data comparison, reporting, data mapping etc.
• Helped users through UAT and uploaded dashboards onto the server and provided production support to users.

Environment: Tableau Desktop 2020.3, MS excel, Power Point, Oracle 12c, SQL Server 2017, SQL, SQL developer,JIRA

Confidential, Irving, TX

Tableau Developer / Data Analyst

Responsibilities:

• Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the business needs.
• Discussed with team to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Participated in building and visualizing dashboards using Tableau Desktop 9.0
• Used Tableau to generate Tableau combination dashboards and wrote SQL Queries for testing the tableau report/dashboard.
• Implemented Extract filters, Calculation Filters, Context filters, Data source filters to exclude certain values or a range of values as well as batter performance.
• Created story using sequence of worksheets to convey information using Tableau.
• In Tableau dashboards used different bars and charts like stack bars, bar graphs, scattered plots, Gantt charts.
• Blended data from multiple sources into one report by selecting primary keys from each database for data validation.
• Have done advance analysis, through field calculation, table calculation as well as also involved in forecast analysis.
• Used different functions like number, string, date, Type conversions, aggregate functions.
• Created performance recording to improve Tableau’s performance.
• Effectively used data blending feature in tableau desktop.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Written complex SQL queries to read data from source databases like Teradata and SQL Server.

Environment: Tableau 9.3 (Tableau Desktop, Tableau Server, Tableau online), MS Office Suite, Oracle 10g, MySQL, SQL Server 2014

Confidential, Dallas TX

Tableau Developer / Business Analyst

Responsibilities:

• Communicated directly with the engineering team, project managers and SMEs to facilitate the conversation around solution design and ability to create scope documentation for all stakeholders of the development cycle
• Worked on business requirements gathering and identified opportunities for process improvement.
• Collected, compiled and interpreted business data and drafting reports.
• Have gone through the Business requirement document as well as dataflow, business logic and Business rules that need to be applied. clarify the doubts with Business user to understand requirement clearly and propose technical solutions to meet the business requirement wherever needed.
• Created dashboards in tableau according to user specifications and prepared stories to provide an understandable and helpful vision.
• Involved in creating dashboards by extracting data from different sources and used data blending to blend two data tables in case of merging data.
• Created data visualizations, applied various actions (URL, Filter, Parameters) in Tableau desktop.
• Develop, Organize, manage and maintain graphs, tables and document templates for the reports.
• Designed standardized data mart with aggregated data, calculated metrics to suffice the source that the data need for various tableau reports and also worked with ETL developers, DBAs to implement the same in Development, Test and Production environment.
• Participated in QlikView and tableau comparison sessions.
• Used SQL, PowerPoint and Excel daily to generate various performance reports for analysis.

Environment: Tableau Desktop 8.2, Tableau Server 8, MS Office Suite, Oracle 10g, T-SQL, Excel, PowerPoint, SQL Server 2012