We provide IT Staff Augmentation Services!

Sr. Tableau Developer Resume

Edison, NJ

SUMMARY:

  • Over 8 years of IT experience which includes analysis, design, development, implementation, deployment and maintenance of Business Intelligence, Data Warehouses and Data Mining applications in Financial, Healthcare, Utility, and Manufacturing industries.
  • Proficient in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8.2 8.1, 8.0, Tableau 7 and Tableau 6.
  • A highly motivated and excellent team player with technical expertise in software engineering processes and outstanding knowledge on life cycle of the software design process (SDLC).
  • Extensive knowledge of all phases of the Software development life cycle (SDLC), Agile, Scrum and the iterative Rational Unified Process (RUP).
  • Experience in gathering and writing detailed business requirement and translating them into technical specifications/ System Requirement Specifications (SRS) and design identifying interface and business process specifications. Extensive Experience working with business users/SMEs as well as senior management.
  • Outstanding knowledge in relational Data modeling, Dimensional data modeling, logical/Physical Design, ER Diagrams, forward and reverse engineering, Publishing ERWIN diagram, documents etc.
  • Strong understanding of the principles of Data warehousing using Fact Tables, Dimension Tables, StarSchema and Snowflake Schema modeling.
  • Expertise in Teradata, Oracle, SQL Server, Informatica, SSIS, SSRS, UNIX, Microsoft Office Suite.
  • Outstanding knowledge in writing complex SQL queries, Stored Procedures, database tuning, query optimization and resolving key performance issues.
  • Extensive experience in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
  • Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
  • Expert in Unit System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
  • Outstanding 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.
  • Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
  • Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
  • Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
  • Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Reporting Tools: Tableau8.2 8.1 8.0, Business Objects 5.x/4.1, Crystal Reports, Cognos

ETL Tools: IBM Info sphere DataStage, Informatica, Microsoft SQL Server Integrated Services

Databases: Teradata, Oracle 118i/9i, DB2 UDB, MS-SQL Server, Sybase

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes

Document Management: Documentum,Visual Source Safe 6.0, Share point, Ultra Edit

Defect Management tool: HP Quality Center

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle, CMMI Compliance, Waterfall, Agile, Iterative

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

Languages: C, C++, C#,.NET, SQL, PL/SQL and Java

Operating System: Windows NT/2000, UNIX (HP UX, Solaris 2.7/8, AIX), AS/400, OS/390.

Web Applications: HTML, Perl, XML and JavaScript

Scheduling Tools: Control M, Autosys, ESP Scheduler

PROFESSIONAL EXPERIENCE:

Confidential, Edison, NJ

Sr. Tableau Developer

Responsibilities:

  • Gathered requirements from end users, involved in modifying various technical & functional specifications
  • Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • Involved in new KPI generation for Scorecards.
  • Installed and upgraded of Tableau server and server performance tuning for optimization.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Defined best practices for Tableau report development.
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • 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.
  • Preparing Dashboards using calculations, parameters in Tableau.
  • Understanding of relational database structures, theories, principles, and practices.
  • The ability to interact professionally with a diverse group, including executives, managers, and LOB.
  • Working on generating various dashboards in Tableau server using various sources such as Teradata.
  • 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
  • Involved in license management SLA’s with Tableau support.
  • Defined and created procedures to install Tableau desktop in silent mode.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Published developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
  • Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
  • Proof-read all documents and maintain accuracy of information and preparing SOP.
  • Responsible for Developing a Dashboard and preparing ad-Hock Reporting.

Environment: Tableau Desktop 8.1-8.2, Tableau server / Administrator, SQL developer, SQL 2008, Oracle 10g, PL/SQL, T-SQL Microsoft Excel 2007,MS Access, Windows 2007 server, java 1.5 platform, Teradata, Microsoft office 2007, Business objects 4.0.

Confidential, Cleveland, OH

Tableau Developer/ Data Analyst

Responsibilities:

  • Interacted with business user group for domain requirements gathering.
  • Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
  • Involved in defining the whole project life cycle, following agile methodology. Analyse business requirements and segregated them into high level and low level
  • Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
  • Interact professionally with diverse group of professionals in the organization including managers and executives.
  • Developed Standard Operating Procedures (SOP) for Monitoring.
  • Extensively used data blending, embed functionalities in Tableau.
  • 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. Creating New Schedule's and checking the task's daily on the server.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
  • Gathered user requirements, analysed 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.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
  • Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
  • Creating users, groups, projects, Data connections, settings as a tableau administrator.
  • Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
  • Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
  • Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.

Environment: Tableau Desktop/Server 6.x-7.x, SQL Server 2008, HPQC, Oracle 11g, Business objects, SQL, PL/SQL, T-SQL, Microsoft office 2007.

Confidential, Schaumburg, IL

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).

Confidential, Irvine, California

ETL - Data Warehouse Developer/ Data Analyst

Responsibilities:

  • Worked on the project that involved development and implementation of a data warehouse.
  • Interacted with business users and performed Gap Analysis of Client requirements
  • Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
  • Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
  • Worked extensively with MS Visio and Rational tools to document requirements.
  • Created the AS-IS and TO-BE process flow diagrams.
  • Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
  • Defined functional business requirements, analyzed client requirements, and generated workflow processes
  • Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
  • Assisted in project management activities like planning, development, task allocation, project execution
  • Provided full project life cycle flowcharting, analysis and documentation.
  • Responsible for extracting, transforming, and loading data from oracle, flat files and placing it into data warehouse.
  • Designed, developed, and tested the Jobs, Job Sequences using DataStage 8.1
  • Involved in the some part of performance tuning.
  • Developed simple and complex mappings using Informatica to load dimensions and fact tables as per STAR schema techniques.
  • Defined project milestones, schedules, monitoring progress and updating plans using MS Project
  • Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.

Environment: Oracle, Teradata, Toad, DataStage 8.1, Cognos, Autosys, UNIX, Microsoft (Word, Access, Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Confidential

ETL/Data Warehouse Tester

Responsibilities:

  • Worked on the project that involved testing and implementation of a data warehouse.
  • Responsible for testing process of extracting, transforming, and loading data from oracle, flat files and placing it into data warehouse.
  • Analysed and tested the mappings, using Informatica 7.1
  • Interacted with management to gather sources and their requirements
  • Involved in the some part of performance tuning.
  • Tested simple and complex mappings using Informatica to load dimensions and fact tables as per STAR schema techniques.

Environment: Informatica PowerCenter 6.x/7.1, BO 6.5,Microsoft Visio, Oracle 9i.

Hire Now