We provide IT Staff Augmentation Services!

Tableau Developer Resume

NC

SUMMARY

  • Over 6+ years of extensive IT Experience in Data Warehousing and Business Intelligence applications in Retail, Financial, Health Care and Manufacturing industries.
  • Proficient in Tableau 6.x/7.x/8.x (Desktop, Server),OBIEE 11g,Micro Strategy 9.x/8.x (Desktop, Intelligence Server, Narrow cast Server) and SS RS.
  • 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.
  • Experience in creating and implementing interactive charts, graphs, and other user interface elements.
  • Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
  • Outstanding Data analysis skills including Data mapping from source to target database schema's, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
  • Expertise in Teradata 13.10, Oracle, SQL Server, Informatica, SSIS, SSRS, SSAS, UNIX, Toad, Microsoft Office Suite.
  • Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
  • Possess strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
  • Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing (UAT).
  • Adept in analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post - Production support.
  • Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
  • Strong understanding of project life cycle and SD LC methodologies including RUP, RAD, Waterfall and Agile.
  • Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities
  • Good knowledge of Business Intelligence/Data Warehousing BIDW Fundamental architecture concepts, dimensional modeling, requirement gathering.
  • Strong experience in various top ranked vendor BI specific tools such as Tableau & MS BI.
  • Strong skills with Business Intelligence application stack including Tableau Desktop/Tableau Server/Tableau Public/SSIS/SSAS/SSRS, Performance Point Server, multi-dimensional cube building, OLAP/MOLAP and have the solid experience in data warehousing/BI environments.
  • Proven myself as a dedicated, worth full and energetic well-rounded Business Intelligence/DWH background professional in growth oriented reputed organizations that gives me scope to apply my knowledge and skills and be a member of a team that dynamically works towards success and growth of the organization.
  • Good Communication and interpersonal skills.
  • Self-motivated high-energy person who enjoys challenging assignments and good at working on multiple engagements.
  • Versatile team player with excellent analytical and presentation skills.

TECHNICAL SKILLS

BI Tools: Tableau BI Products, Business Objects.

ETL Tools: Informatica, Data Stage, Talend, Microsoft SQL Server Integrated Services(SS IS),Tableau Desktop

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

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

Databases: MS Access, Google big-query, Teradata 13.10, Oracle, SQL Server, DB2, Sybase, etc

Document management: Visual Source Safe 6.0, Share point, Ultra Edit, Document-um

Defect management tool: HP Quality center 10.0

Programming Languages: C, C++, HTML, SQL, PL/SQL, XML, Python, C#,T-SQL

Data modeling: Power Designer, Erwin, ER Studio, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, NC

Tableau Developer

Responsibilities:

  • Understanding of the tableau dashboard business requirements of various source systems.
  • Responsibility, ownership and accountable for the tableau desktop dashboards building and tableau server administration.
  • Understanding of the whole system integration project including the 3 layers of the project such as source (applications), data (composite virtualization) and presentation layer (tableau visualization).
  • Translation of business requirements to dashboard technical requirements.
  • Creation of FSD for tableau dashboards with the help of BA.
  • Creation of mock ups\proto types dashboards in PPT and Excel\Visio for business users.
  • Design, development and publishment of various tableau visualization dashboards.
  • Design and implementation of tableau dashboards layout.
  • Publishing and authoring the dashboards from tableau desktop to tableau server.
  • Generation of Tableau extracts and implementation of different calculations, visualizations in the tableau lay out design.

Environment: BI solutions, BI environment, BI Applications, Tableau 7x BI toolkit\Product stack (Desktop\Server (Suite), Windows, Accolade, SQL Server, Excel and other internal source applications

Confidential

Tableau Developer\Admin

Responsibilities:

  • Converts business requirements and specifications into Tableau presentation and data layer application solutions through effective design, coding and testing to enable and support managing operating systems related to inventory, cycle time, quality, and productivity visualizations.
  • Designs and creates data views in SQL and influences decisions regarding infrastructure and back-end data solutions in order to enable evolving analytical needs.
  • Designs and develops Teradata data structures based on reporting requirements.
  • Utilizes presentation layer mock-up software to effectively visualize and demonstrate proposed user interface dashboard and scorecard solutions in order to gain buy-in on requirements.
  • Utilizes Business Intelligence applications and products to develop executive dashboards and operational scorecards.
  • Actively participates in and influences discussions around reporting requirements, infrastructure needs, and design with matrix partners.
  • Increases organizational and personal capacity by mentoring and enabling team members to complete coding and testing assignments in coordination with Cigna and Global Service Partner on-shore delivery leads.

Environment: CA Clarity solutions,11 Source System Applications (Clarity, MeMs(Service Metrics), and ETL tool - Composite Software, Data Visualization Tableau 8x Desktop and Server, MS Excel, MS Visio and, Clarity Business Power Users.

Confidential, Chicago, IL

Tableau Developer/Data Analyst

Responsibilities:

  • Gathered Business Requirements, Interacted with the Users, Project Manager and SME to get a better understanding of the Business Processes.
  • Worked with DBA to design and implement Conceptual data model, Physical Data Model, SS IS mappings and work-flows to meet business requirements.
  • Responsible for creating ETL mapping documents to define data flow from source system to target database.
  • Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped..
  • Worked on the back-end SS AS cube development which was the source data for the tableau.
  • Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling.
  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
  • Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. in a single dashboard by using parameters.
  • Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes..
  • Extensively used calculated fields for different logic's for Trend, Extended price calculations for the different cost types.
  • Foundefficientways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
  • Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems, and was responsible for replacing the connection to Google Big-query later.
  • Used Sql Queries at the custom Sql level to pull the data in tableau desktop and validated the results in Tableau by running Sql queries in Sql developer and Google Big-Query.
  • Attended daily stand-up 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.
  • Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created tableau functional design document.
  • Participated in the retrospective meetings and next sprint planning meetings.
  • Involved in On-site & 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, Google Big-Query, SS IS, SSAS, Salesforce, Talend.

Confidential, Eden Prairie, MN

BI Analyst/ Data Analyst

Responsibilities:

  • Oversee the performance of Design to develop technical solutions from Analysis documents.
  • Possess and applied a broad knowledge of principles, practices and procedures of Marketing, Merchandizing subject area to the completion of various difficult assignments.
  • Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
  • Translate business requirements into conceptual, logical data models and integration data models, model databases for integration applications in a highly available and performance configuration using ER/Studio.
  • Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
  • Performed GAP analysis with Teradata MDM and Drive (SQL) data models to get clear understanding of requirements.
  • Experience in understanding user requirements around technical data, interaction of data between systems and system dependencies.
  • Worked to ensure high levels of data consistency between systems.
  • Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
  • Developed and maintained data dictionary to create metadata reports for technical and business purpose.
  • Created action plans to track identified open issues and action items related to the project.
  • Designed complex risk reports, Score Cards, and Dash Boards using MicroStrategy.
  • Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc.
  • Designed filters, power prompts, and complex financial calculations for various analytical reports.
  • Arranged walkthrough sessions with the user group and QA teams to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
  • Implemented security in reports according to employee groups and roles according to the requirement. and Involved deployment process.

Environment: MicroStrategy (Desktop/ Server), Teradata 13.10, Oracle, SSIS, SSRS, Teradata SQL Assistant, Teradata Administrator, SQL Developer, Power Designer, MS Office Suite (Word, Excel, PowerPoint).

Confidential, Santa Clara, CA

Tableau Developer \Administrator

Responsibilities:

  • Experience using Tableau tool to handle the various data feeds from the different data sources using Tableau Desktop tool.
  • Creating customized and interactive dashboards using multiple data sources, data extraction and custom objects.
  • Migrating some of the existing excel - based dashboards of Tableau.
  • Experience in creating and implementing interactive charts, graphs, and other user interface elements.
  • Understanding of relational database structures and ability to create SQL views.
  • Designing, developing, maintaining and supporting multiple Tableau dashboards and apps using Tableau 7x and understanding of new features of Tableau 8x.
  • Good experience in Tableau development, analysis and Tableau Desktop, Server &Public support implementations.
  • Develop Tableau module deliverables such as workbooks, package workbooks, building data views manually and automatically using different charts, graphs.
  • Deploy and administer complex Tableau server environments involving multiple server setups in controlled and secure environments.
  • Involved in Tableau server upgraded from single node to distributed environment, making tableau services more scalable and stable.
  • Added multiple additional processes (VizQL, Application server, data server and background processes) for performance improvement.
  • Helped Tableau power users in optimizing their tableau reports with proper use of filter, optimized SQL queries etc.
  • Created Data extracts for better performance and accessing data offline.
  • Implementation of incremental data extracts updated on timely basis as database updates, Refreshing extracts, optimization and tuning applications for maximum memory management, scheduling .

Environment: BI solutions, BI environment, BI Applications, Tableau 7x BI toolkit\Product stack (Desktop\Server (Suite), Windows, Accolade, SQL Server, Excel and other internal source applications

Confidential

DWH Developer

Responsibilities:

  • Team member of the BI module and involved in analysis of business requirements template, decomposition matrix, dimensionality modeling and ETL strategy.
  • Understanding the Erwin ER diagrams.
  • Utilizing the Kimball- Star/Snowflake schema's and slowly changing dimensions.
  • Worked on Microsoft SQL Server 2005 Tools-SQL Server Integration services (SS IS), SQL Server analysis services (SS AS) and SQL Server reporting services (SS RS).
  • Responsible for extracting the data from different source feeds like Flat file, XML, OLE DB, and Excel.
  • Created packages by using sources, destinations and transformations using SS IS designer.
  • Connected to different types of sources to extract data and destinations to load the data using Connection manager.
  • Defined the data Sources, data Source views, dimensions, cubes within the Business Intelligence Development Studio (BIDS) Using SS AS.
  • Administration and development of data warehouse\data marts and OLAP cubes
  • Used Business Intelligence Development Studio, Management Studio for developing SS IS, SS AS, and SS RS.
  • Involved in the creation of SS RS reports using with\without wizards.
  • Performed parameterized reports, reports bursting, and scorecards.
  • Involved in performing drill down the data, calculations, sort the data, add groups, subtotals, and color code the business data exceptions.
  • Troubleshooting ETL, OLAP analysis and reporting process failures.

Environment: MS SQL Server 2005(SS IS/SS AS/SS RS), Windows.

Hire Now