We provide IT Staff Augmentation Services!

Sr. Tableau Developer /data Analyst Resume

Westborough, MA

SUMMARY:

  • 8+ years of IT experience in Business Analysis, System Analysis, Data Analysis, Software design, development, testing and maintenance of Business Intelligence/Data Warehousing environment across Entertainment,Financial, Insurance, Healthcare, Transportation and Technologyindustries.
  • Certified Tableau Desktop 9 Qualified Associate with 5+ years extensive experience in working with Tableau 7.x/8.x/9.x/10 product suite (Desktop, Server, Public, Reader, Mobile) and other BI technologies like MicroStrategy, Alteryx, Informatica etc.
  • Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups.
  • Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
  • Interviewed SMEs and Stakeholders to get a better understanding of client business processes, KPI'sand gather business requirements as per project milestones.
  • Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
  • Strong understanding of Data warehouse concepts like Kimball/Inmon methodologies, Star Schema, Snowflake Schema, Dimensional data modeling, Factsand Dimensions tables, physical and logical data modeling.
  • Proficient in designing the Design Documents for loading data into Data Warehouse and Data Mart tables.
  • Extensive experience in presenting Tableau visual analytics and best practices like Story Points, Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
  • Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
  • Experience in developing rich interactive Tableau reports and Dashboards using various visualizations like Chart - Box (Drill Down, Drill up & Cyclic Grouping), Heat Maps, Tree Maps, Bubble Charts, Reference Lines, Dual Axes, Line diagrams, Bar Graphs, Geographic Visualizations ( Detailed and filled in maps), etc.
  • Experience using new/advance features like Cluster analysis, Cross Database Joins, Cross Data Source filters, Custom Territories,Level of Detail (LOD) expressions, Groups is LOD expressions, etc. in Tableau
  • Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
  • Experience with JavaScript API to customize the views, selects, filters, date and time.
  • Extensive knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating/ adding users, sites and projects, managing licenses and data connections, scheduling tasks.
  • Extensively worked with various database systems like Oracle, Teradata, DB2, MS Access, Flat files, XML and SQL Server.
  • Expert in Unit, System and User Acceptance Testing and Performed Data Validations for all the reports and dashboards generated from various database sources.
  • Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
  • Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solutionsin challenging environments.

TECHNICAL SKILLS:

Analytical Tools: Tableau10/9.X/8.X/7.X (Desktop, Server, Reader), MicroStrategy, Cognos, SSRS

Modeling Tools: Power Designer, ERwin, ER Studio, MS Visio

Data Integration Tools: Alteryx, Informatica Power Center, SQL Server DTS

SQL Tools: Rapid SQL, Toad, Teradata SQL Assistant, PL/SQL Developer. Amazon Redshift

RDBMS: Teradata, Oracle, SQL Server, DB2, Access, Presto, PostgreSQL

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Documentation: SharePoint, HP Quality Center

Scripting/Lang.: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML

Scheduling Tools: AutoSys, Control M

Operating Systems: UNIX /Linux, Windows 7/XP/2000

PROFESSIONAL EXPERIENCE:

Confidential, Westborough, MA

Sr. Tableau Developer /Data Analyst

Responsibilities:

  • Interacted with business to collect and understand Requirements.
  • Created Patterns of Care physician report into Tableau, working with Clinical Innovation Analytics team
  • Created self-service report in Tableau for internal users to access
  • Document process so that existing resources can make future enhancements or resolve production issues
  • Work with team members to train them on Tableau
  • Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
  • Tested Tableau desktop 10.5
  • Designed & developed various departmental Tableau reports by using Netezza and SAS
  • Building drill down dashboards, detailed tabs, line trends for weekly, monthly and creating KPI charts like bar chart, Crosstabs, Geo Maps, Donut Chart etc. and using powerful visualizations in tableau, meeting the business needs.
  • Developed effective and interactive Dashboards and Swapping of sheets using Parameters, Actions and URL Actions on dashboards.
  • Created complex LODs and Table calculations for the reports. Used Cross database join to connect different data-sources on Tableau 10.2
  • Working jointly with business analysts and product owners to solicit visualization requirements, recommending changes, creating prototypes, giving demos to the users.
  • Aggregating data, calculating metrics to report across the dashboards in the database to improve the performance.
  • Added Active Directory Users, Groups. Provided permissions based on activity label.
  • Embedded Dashboard in the Clinical website.
  • Involved in integration of Tableau JavaScript API Filters in web application
  • Help build out additional products that work with Tableau for existing team members
  • Utilize PBM Claims data, and Healthcare experience to meet client goals.
  • Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
  • Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
  • Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.

Environment: Tableau (Desktop/ Server), SAS, MS SQL Server, My SQL, Netezza, SharePoint Microsoft Suite (Excel, Word, and Visio) and Windows 2007 server

Confidential, Dallas, TX

Sr. Tableau Developer / Sr. Data Analyst

Responsibilities:

  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Provided multiple demonstrations of Tableau functionalities and efficient data visualization approaches using Tableau to the senior management at the client as part of the BRD.
  • Analyzed and created stored procedures on SQL Server to extract, transform and load staged tables from raw data.
  • Developed highly polished executive level dashboard prototype for the Theatrical and Marketing group which provides BI for different departments to implement their decision support systems for comparing Global box office USD and GBO LC daily and ITD earnings.
  • Designed Rally dashboard and Service Now Dashboard for the leaderships to visualize Planned vs Accepted Points and Velocity and to showcase the Open/Closed Tickets by Iteration and Project.
  • Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
  • Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilitiesfor the dashboards, and to provide drill down features for thedetailed reports.
  • Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
  • Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
  • Worked on building queries to retrieve data into Tableau from SQL Server, Teradata, Oracle, Presto cluster for loading data into target database.
  • Served as a liaison between the business and the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed
  • Implemented metrics, filters, reports, dashboards and created advanced chart types, using calculations to manipulate the data and enable user driven parameters for visualizations and drilled down level of detail using sets.
  • Created calculations including string manipulation, custom aggregations, date math, logic statements, parameters and represented data using different charts.
  • Combining data sources by joining multiple tables and using data blending
  • Designed and created aggregate tables for large datasets to optimize the data and increase performance of the dashboard.
  • Developed relational tables, coded SQL queries, created macros in MS Access to produce financial data sets.
  • Designed data mart components like metadata, facts and dimensions using star and snow flake schemas.
  • Designed custom SQL queries for various Tableau reports for the business users to enhance the report and show the granularity of the data.
  • Scheduled data refreshes on Tableau Server for daily/weekly/monthly increments depending on the dashboard cadence.
  • Worked with Teradata database and Presto cluster to extract data and developed POCs by building reports and dashboards using Tableau 9.2.
  • Worked on integrating Tableau with SPARTA application for the users to interact with the Tableau reports.
  • Provided multiple demonstrations of Tableau functionalities and efficient data visualization approaches using Tableau to the senior management at the client as part of the BRD.
  • Develop, organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
  • Worked with Teradata database and extracted data using Alteryx and developed POCs by building reports and dashboards using Tableau 9.2 to demonstrate quick wins.
  • Incorporating weekly changes of the data source files by integration into Tableau data sources for timely leadership reporting.
  • Creating reports and infrastructure to show migration activities by monthly release, business functions and IT projects.

Environment: Tableau Desktop 10/9.1/9.2, Tableau Server 9.1/9.2, OBIEE 11g, SQL Workbench, Teradata, Presto, PostgreSQL, Spark SQL,Alteryx, Toad, Microsoft SQL Server, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, San Francisco, CA

Sr. Tableau Developer / Sr. Data Analyst

Responsibilities:

  • Gathered Business Requirements, Interacted with Strategic Development Team, Business analyst to analyze business needs and developed technical specifications.
  • Installed,configured and setup Tableau environment in the organization.
  • Develop, organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
  • Worked with Teradata database and extracted data using Alteryx and developed POCs by building reports and dashboards using Tableau 9.2 to demonstrate quick wins.
  • Incorporating weekly changes of the data source files by integration into Tableau data sources for timely leadership reporting.
  • Creating reports and infrastructure to show migration activities by monthly release, business functions and IT projects.
  • Created Visuals for PayPal team workflow optimization using different Tableau charts such as KPIs and sparklines in a single view.
  • Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard.
  • Worked on converting map shape files to tableau readable CSV format using R software
  • Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool.
  • Participated and coordinated daily stand-ups with clients on daily design and development effort.
  • Extensively used LOD expressions for cohort analysis and aggregation.
  • Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control
  • Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types
  • Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel
  • Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Generated the test plans specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
  • Prepared test scripts and documented user training modules.
  • Maintained Test log and created Test Evaluations, Summary Reports.
  • Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
  • Provided Ongoing support to BI applications running in production & troubleshoot any issues.

Environment: Tableau Desktop 9.1/9.2, TableauServer 9.1/9.2, OBIEE 11g, Axure,Alteryx, Toad, Microsoft SQL Server, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, Monroe, MI

Sr. Tableau Developer / Sr. Data Analyst

Responsibilities:

  • Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
  • Mentored other Tableau users, provided training and novice in Tableau.
  • Developing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
  • Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
  • Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
  • Created visualizations for logistics calculations and departmental spend analysis.
  • 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
  • Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
  • Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
  • Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
  • Created tableau functional design document.
  • Performed performance tuning of the dashboard in Tableau desktop.
  • Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes.
  • 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.
  • Participated in the retrospective meetings and next sprint planning meetings.
  • Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Desktop 8.1/8.2, Tableau server 8.1,8.2, OBIEE 11g, Microsoft SQL Server, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, Minneapolis, MN

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

  • Gathering the clients, Suppliers and internal resource data from all the Vendor Management Systems.
  • Actively involved in new KPI generation for Scorecards.
  • Data collection and leveraging on data manipulation teams for required data.
  • Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
  • Identify new metrics and enhance the existing KPI's.
  • Working extensively with Tableau Business Intelligence tool to develop various dashboards.
  • Working extensively using Excel to validate the data and use as the source data files.
  • Dashboard Visualization through Tableau BI application.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
  • Effectively used data blending, filters, actions, Hierarchies feature in tableau.
  • Defined best practices for Tableau report development.
  • Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Executed and tested required queries and reports before publishing.
  • Converted metric insight reports to tableau reports.
  • Analyzing the data using Statistical features in Tableau to develop trend analysis.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Worked with Teradata database and pull data to work on BI requirement.
  • Provided Ongoing support to BI application running in production & troubleshoot.

Environment: Tableau (Desktop, Server)7.x/8.x, Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential

Business Systems Analyst/ Data Analyst

Responsibilities:

  • Requirement gathering for various users, interviewing them, and satisfying their exact needs.
  • Involved in the complete Life cycle of the Project and in the data analysis process
  • Gather the various requirement matrices from the business analysts.
  • Worked with Master Data Management.
  • Assisted the DBA in converting the logical models to physical.
  • Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
  • Designs for the various reporting requirements.
  • Conduct Design reviews with the business analysts, content developers and DBAs to ensure the feasibility of the designs.
  • Used Erwin for developing data model and forward engineer the data model.
  • Reverse engineer the data base in to physical data model by using Erwin.
  • Developed entities and relationships using Sybase Power Designer.
  • Developed Data Migration and cleansing rules for the integration architecture.
  • Developed data mapping documents between legacy, production and user interface systems.
  • Designed different type of STAR schemas like detailed data marts, Plan data marts,
  • Used Erwin for monthly summary data marts and inventory data marts.
  • Designed ER Diagrams, star schema and snow flake schema.
  • Importing source definitions. Creating and importing target definitions. Creating the table targets.
  • Created and modified of Attributes, Facts, Metrics, Filters and other report objects.
  • Conducted data validation testing to ensure data quality.
  • Active Participation in checking the data at database level and at SSRS level in case of displaying wrong data.
  • Tested all the business application rules with test & live data and automated.
  • Involved in testing and fixing bugs on test and On-line data.
  • Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Informatica, Cognos, Power Designer, PL/SQL, Oracle9i, TOAD, UML, Microsoft Office Suite (Word, Excel, Power Point, Visio).

Hire Now