PROFESSIONAL SUMMARY:

• 8 years of experience in Data warehousing and Business Intelligence technologies along with strong experience of data visualization using Tableau.
• Hands on experience on Tableau 7/8.0/8.2 and Tableau Reader.
• Good knowledge on Tableau 9.0
• Expertise in performing development activities from gathering requirements and designing solutions, through developing code/ reports to testing, release/deployment.
• Ability to analyze and dissect user requirements and build front-end BI applications according to speciifications.
• Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries.
• Mastered in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts.
• In depth knowledge in Tableau advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines.
• Mastered the ability to design and deploy rich Graphic visualizations Parameters using Tableau.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Been part in writing technical requirement documents and low level design documents.
• Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Interact with Database, Informatica Administrators on environmental issues and work on fixing the issues.
• Experienced in requirement gathering/analysis, design, development, testing, and production support of reporting and analysis projects.
• Worked extensively in Informatica Power Center 8.6 9.1.
• Proficient in Oracle Database and UNIX Shell Scripting.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements
• Involved in Gathering/ analysis, Design, Development, Testing and Production rollover.
• Conversant with Software Development Life cycle and SEI-CMMI level 5 Quality Processes while executing projects

SKILLS AND TOOLS:

Operating Systems: Windows 95/98/2000, Windows XP Professional, Windows NT, UNIX

Languages: C, C , C , SQL, PL/SQL, HTML

Databases: Oracle 8i/9i/10g/11g, SQL Server 2008/2005, DB2, Teradata.

Tools: Tableau Desktop v7/v8, Tableau Server v7/v8, Informatica Power Center 9.1.0/9.0.1,8.6.1,8,Cognos

Related Skills: MS Visio

PROJECTS SUMMARY:

Confidential

Senior Tableau Developer/Analyst

Responsibilities

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Converted existing BO 5x reports into tableau dashboards
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Developed donut charts for analyzing sales planning data.
• Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
• Expertise in working with data building Groups, Hierarchies and sets.
• Mastered in different Formatting techniques, using Annotations and Mark labels.
• Developed effective and interactive Dashboards using Parameters and Actions
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Published and shared views on Tableau server.
• Scheduled extract refresh and subscriptions.
• Also involved in administration tasks such as creating and managing Sites, Setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.
• Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.
• Assisting users with questions and issues using Tableau. Working with various infrastructure teams and Tableau support team to help improve dashboard response time.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Ability to work effectively in team environment and interact with all levels of management

Environment: Tableau 8.2, Business Object 5x, Amazon Redshift, Sage VIP, SWOP

Confidential

Tableau Consultant

Responsibilities

• Created dashboards for analyzing POS data using Tableau 8.0 on top of SAP HANA.
• Developed dashboards for POS use cases to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting and cannibalization.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps, Pareto charts according to deliverable specifications.
• Extensively worked on different types of filters.
• Expert level capability in table calculations and applying complex, compound calculations to large, complex big data sets
• Used trend lines extensively for correlating different KPI's for new product launches.
• Created custom Function's Date range, Time functions, Logical functions in the reports.
• Scheduled extract refresh and subscriptions for weekly and monthly reports.
• Integrated Tableau dashboards into internal web portal using Java Script API.
• Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.
• Consistently attended meetings with the client subject matter experts to understand functional business requirements.
• Provided user trainings on the key dashboards
• Provided detailed documentation on the Analytical deliverables
• Used Industry standard design templets for POS use case analysis.

Environment: Tableau Desktop 8.0, Tableau server / Administrator, SAP HANA, SQL Server 2008, Windows/UNIX, Oracle.

Confidential

Business intelligence Consultant

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Experience with creating Worksheets and Dashboard.
• Experience with Tableau for Data Acquisition and data visualizations.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Worked on Bar charts, line Charts, combo charts, heat maps and incorporated them into dashboards.
• Experience with Sorting, Building Groups and using in visualizations.
• Worked on Global, local and Context filters.
• Used parameters to make dashboards dynamic.
• Worked extensively with Date, String and Logical Functions.
• Created Inventory trends, sales integration and forecast accuracy related dashboards
• Worked closely with ETL team for various Data sources issues
• Interacted and worked with ETL team for improving performance on data from multiple data sources
• Used ETL efficiently for complex joins of various scenarios
• Provided User training for the various dashboards.
• Worked with ETL team for performance improvement using custom SQLs.

Environment: Tableau 7.0, Informatica 9.1, Hyperion Oracle , SQL, Oracle 10g, Teradata's, Windows/UNIX

Confidential

ETL Developer

Responsibilities:

• Analysed Customer requirements and prepared design/mapping documents.
• Creating the SQL queries based on source to target mappings for Target tables.
• Created various Mappings by using different kinds of transformations like Source Qualifier, Expression, Join, Lookup, Filter, Rank, Sequence Generator, Stored Procedure, Router, Normalize, Transformations.
• Worked on SQL for Source overwrite queries to improve performance.
• Worked with modeling team for source issues.
• Created multiple Mappings and Workflows.
• Worked with DBA team for performance improvement issues.
• Prepared technical design documents and coding specification documents.
• Prepared unit test cases for the modified existing ETL routines.
• Worked closely with reporting team for their reporting needs.
• Worked with reporting team on reconciliation issues.
• Worked with Dashboard teams for backend changes for their specific report tables to gain performance.
• Worked with DBA's for performance improvements.
• Worked with DBA's on various issues like table space and table locking issues, long running query analysis and so on.
• Experienced in handling large volumes of data.
• Code developed based on the business requirement
• Develop an ETL mapping as per Business requirement, developing SQL queries to perform audit between source, staging and Target data.
• Created Unit Test cases and captured Test log

Environment: Informatica 8.6/Cognos, Oracle, Windows XP, UNIX

Confidential

ETL Developer

Responsibilities:

• Understanding existing business model and customer's new requirements.
• Prepare ETL technical Design Documentation and coding.
• Used various transformations to achieve business logics.
• Worked on transformations like Expression, Lookup, Filter, Router, Aggregator, Ranking, Normalization, Sequence Transformation were implemented to load the data from source to Target.
• ETL performance optimization with SQL.
• Worked with Modelers and Architects for table issues.
• Worked on building Mappings, Mapplets.
• Prepared detailed documentation for development, Test cases, testing different scenarios and documenting the result, working on defect fixes from System Testing User Testing.
• Tested ETL code in Dev, SIT UAT environments to ensure defect free code.
• Provided Development support for System Testing/User acceptance testing.
• Migration workbook creation and tracking the code versions

Environment: Informatica 8.6, SQL, Oracle, Windows/UNIX

Confidential

ETL Developer

Responsibilities:

• Worked on data migration from legacy systems to MST.
• Based on Technical spec created and used multiple Transformations in Informatica like Expression, Lookup, Filter and Router.
• Worked on SQL to get data efficiently into the system.
• Worked on various logics in transformations.
• Created Mappings and Workflows.
• Prepared UTC UTR after completion of the development and provided results to client.
• Tested ETL code in Dev, SIT UAT environments to ensure defect free code.
• Provided Development support for System Testing/User acceptance testing.
• Worked with testing team for defect fixing during various testing phases.

Environment: Informatica 8.6, SQL, Oracle, Windows/UNIX