Tableau /power Bi Developer Resume
WI
SUMMARY
- 5+ years of Experience in PowerBI, Tableau (Desktop, Server). End to end involvement in designing and deploying data visualizations and creating Calculations, Formatting using Tableau Desktop.
- Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
- Proficient in data visualization, Reporting, Analysis, Pie Charts Bar Charts, Cross Map, Scatter Plots, Geographic Map, Page Trails, Density Chart and other making use of actions, other local and global filters according to the end user requirement.
- Integrated Custom Visuals based on business requirements using Power BI desktop.
- Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
- Knowledge in Tableau server commands to migrate workbooks and Tableau server backup, Debugging and monitoring.
- Used SQL Queries at the custom SQL level to pull the data in tableau desktop.
- Validated the results in Tableau by running SQL queries in Oracle SQL developer.
- Extensive knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, transformations, filters, Sets, Groups, prompts, Para meters etc in Tableau.
- Possess strong knowledge of database management in writing complex SQL queries, Joins, query optimization and resolving key performance issues.
- Expertise in Business Intelligence, Data warehousing technologies, ETL and Big Data technologies.
- Involved in reviewing business requirements and analyzing data sources from Excel, Oracle, SAS, Teradata, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
- Expert on maintaining and managing Tableau and POWER BI driven reports and dashboards.
- Highly motivated team player and a Quick Learner with good communication, strong problem - solving skills and excellent in presentation and interpersonal skills.
- Extremely well organized, meticulous, and highly self - motivated.
TECHNICAL SKILLS
Reporting Tools: Tableau, Tableau Reader, Tableau Server, Tableau Public, Power BI, SSRS
ETL Tools: SSIS, SSAS, Informatica
Databases: Teradata, Oracle, MS-SQL Server
Tools: SDLC, Requisite Pro, MS Office, GIT, OLAP, TOAD, Waterfall, Agile
Languages: SQL, PL/SQL, T-SQL, HTML5, CSS3
Operating System: Windows 7/8/10, Linux
PROFESSIONAL EXPERIENCE
Confidential, WI
Tableau /Power BI Developer
Responsibilities:
- Generated Dashboards with Quick/context/global filters, Parameters, calculated fields and sets on Tableau to handle views more efficiently.
- Generated context filters and data source filters while handling huge volume of data.
- Built dashboards for measures with forecast, trend line and reference lines.
- Published Workbooks by creating user filters so that only appropriate teams can view it.
- Participated in daily stand-ups with clients on daily design and development effort.
- Create detail level summary report and Dashboard using KPI's.
- Created reports using Tableau functionality is like Queries, Drill Down, Prompts Functions to meet the requirements using SQL Server.
- Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts and Tabular reports using Tableau Desktop.
- Created Tableau scorecards, dashboards, Heat maps using show me functionality.
- Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
- Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau.
- Worked on the data provider that forms the basis of the ad-hoc analysis.
- Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
- Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
- Developer Power BI Dashboards from multiple data source using data blending.
Environment: Tableau Desktop 2019.2.1, 2020.2.1, Tableau Server, MS Office Suite, SQL Server, MS Excel, SQL Server Management Studio 17, PowerBI.
Confidential, IL
Power BI Developer
Responsibilities:
- Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Power BI Desktop to servers.
- Implemented row level security on data and understand application security layer models in Power BI.
- Designed Power BI data visualization using crosstabs, maps, scatter plots, pie, bar, and density charts.
- Utilizing Power Query in Power BI to pivot and un-pivot the data model for data cleansing
- Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
- Integrated Custom Visuals based on business requirements using Power BI desktop.
- Developed complex calculated measures using Data Analysis Expression language (DAX).
- Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
- Participated in the design, development of hierarchies, dimensions, attributes, properties, calculation, and allocation routines for delivering the desired KPI’s in the Cubes.
Environment: SQL Server Management Studio, Power BI Desktop, Power BI Service, MS Office
Confidential, OH
Tableau Developer
Responsibilities:
- Worked with Business Analyst to understand the user requirements, layout, and look and feel of the application to be developed.
- Created ad-hoc reports to users in Tableau by connecting various data sources.
- Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
- Coordinate with the Team Manager & the team for various complex business requirements through SCRUM Agile process.
- Technically hands-on commercially experience mainly with full range of Tableau, Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server, SSIS, SSRS, MS Performance Point Server and Informatica.
- Worked with team of developers on Python applications for RISK management.
- Developed Python/Django application for Google Analytics aggregation and reporting
- Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
- Used SQL tools like Toad, Pl/SQL to run SQL queries and validate the data in the warehouse and Datamart.
- Created Tabular Matrix reports, Charts, and graphs as per customer requirements Using SSRS.
- Made complex chart like Spider chart and funnel chart to better visualize the data.
- Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
- Analyzed the source data and handled efficiently by modifying the data types. Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports.
- Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
- Generated tableau dashboards with combination charts for clear understanding.
- Created the reports using charts like Pie, Bar, Line etc. Charts are used in making reports user-friendly in analysis purposes.
Environment: Tableau Desktop 8.0/7.0, Tableau server, SQL developer, SSRS, SSIS, Informatica, Microsoft Excel, MS Access, Microsoft office.
Confidential, WV
Tableau Developer
Responsibilities:
- Experience in design and development of Tableau visualization solutions.
- Hands on development assisting users in creating and modifying worksheets and data visualization dashboards
- Designed and development Data modeling, database design, and ETL in an Agile development environment
- Involved in creating a dual-axis bar chart with multiple measures.
- Created report schedules on Tableau server.
- Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
- Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
- Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems to effectively develop technical solutions to their requirement.
Environment: Tableau 8.2, Microsoft SQL Server, MS Excel, MS Access.
Confidential
Tableau Developer
Responsibilities:
- Designed automated scripts in PL/ SQL, DTS and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
- Exposed to data conversion from different data sources to SQL Server using SSIS.
- Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server.
- Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS).
- Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Hands on experience in Big Data architecture (Cloudera Hadoop distributions) and various components like HDFS, Map Reducer, Pig, Hive, Python, Spark, HBASE, Impala, Sqoop.
- Transforming data and tables through Spark SQL.
- Created different KPI using calculated key figures and parameters.
- Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
- Gathered user requirements, analyzed, and designed software solution based on the requirements.
- Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
- Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau desktop/Server.
- Involved in the full systems life cycle and responsible for coding, testing, implementing, maintaining, and supporting applications software.
- Defined best practices for Tableau report development and effectively used data blending feature in tableau Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
Environment: Tableau Desktop 8.0/7.0, Tableau server, SQL developer, SSRS, SSIS, Microsoft Excel, MS Access, Microsoft office, spark,