SUMMARY:

• 8 years of dedicated, driven professional experience Data warehousing and Business Intelligence, Data analytics and reporting.
• Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau Desktop 7.0/8.x/9.x/10.0 and Tableau Server.
• Expertise in performing development activities from gathering requirements and designing solutions, through developing code/ reports to testing, release/ deployments.
• Worked extensively on Joining Tables, multiple data connections using Data blending, worked on data extracts managing custom queries.
• Mastered in using Filters, Sorting, groups and sets, reference lines in different kinds of Graphs in Tableau.
• In depth knowledge in Tableau Advanced Analysis features like Actions, Calculated fields, Parameters, Forecasting and Trend lines. And hands on experience on working with LOD(Level Of Detail) Expressions on Tableau 9.X and 10.0 versions.
• Built Interactive Dashboards using techniques like guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Worked on Tableau Administration tasks such as publishing Workbooks, Setting Site Role and Permissions to users and groups, Managing Ownership, working with Sites, providing access to users and adding them to specific Groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Practical Understanding of the Data Modelling Dimensional relational concepts like Star - Schema Modelling, Snowflake Schema Modelling, Fact and Dimension Tables Using Erwin 4.0/4.2.
• Experience in requirement gathering/analysis, design, development, testing, and production support of reporting and analysis projects.
• Worked extensively with ETL(Extraction, Transformation, Load) tool Informatica Powercenter 9.1/9.0.1/8.6 to integrate the data from heterogenous data sources and load into Data warehouse by applying various transformational and business logics.
• Experience in working with Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms
• Strong experience in writing SQL queries.
• Proficient in Oracle Database, Unix Shell Scripting.
• Involvement in Full Life Cycle Development of Reporting Projects, includes requirements.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.

PROFESSIONAL EXPERIENCE:

Tableau Developer/ Data Analyst

Confidential - Woonsocket, RI

Responsibilities:

• Created dashboards for analyzing POS data using Tableau Desktop based on the user requirements.
• Developed dashboards for POS use cases to understand new product launch, Promotion effectiveness, trend detections, Seasonal forecasting.
• Used industry standard design templets for POS use case analysis.
• Mastered the ability to design and deploy Rich Graphic Visualizations using Tableau.
• Developed Tableau Data Visualization using Pareto's, Combo charts, Heat Maps, Box and Whisker plots, Scatter plots, Geographic Map, Cross tabs, Histograms etc.
• Developed donut charts for analyzing sales planning data.
• Created different KPI's using Calculated fields for Manipulating strings, arithmetic calculations, aggregation options and Logical functions.
• Worked extensively with Advanced analytics like Reference Lines and Bands, Trend Lines.
• Expertise in working with data building Group, 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 the best practices around visualization and design.
• Provided Production support to Tableau users and wrote Custom SQL to support business requirements.
• Published and shared dashboards and views on Tableau server.
• Scheduled extract refresh and subscriptions.
• Also, involved in Administrative works to create Sites, adding Users and Groups to specific sites and providing them site roles and setting Permissions.
• 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 Quality Assurance Teams.
• Ability to work effectively in team environment and interact with all levels of management.

Environment: Tableau Desktop 8.2,9.X,10.0, Tableau Server, Oracle, MS SQL Server, Amazon Redshift, SQL, PL-SQL

Tableau Developer

Confidential - Washington, DC

Responsibilities:

• Designed, Developed, Tested and Maintained Tableau Functional Reports based on user requirements.
• Created Scatter plots, Stacked Bars, Box and whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps, Pareto Charts according to the 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.
• Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
• 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.
• Interacted with the existing database developers and DBA to understand the existing schema.
• Provided user training on the key dashboards.
• Provided detailed documentation on the Analytical Deliverables.

Environment: Tableau Desktop 7.0 / 8.x, Tableau Server/ Admin, SAP HANA, SQL Server 2008, Windows, Oracle.

Business Intelligence Consultant

Confidential - Dublin, OH

Responsibilities:

• Responsible for interaction with business stakeholders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Experience with creating Worksheets and Dashboards.
• Experience with Tableau for Data Acquisition and Data visualization.
• 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 visualization.
• Worked on Global, Local, and Context filters.
• Used Parameters to make dashboard 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 the various Data Source 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 Desktop 7.0, Informatica PC 9.1, Oracle 10g, SQL, Teradata, Windows/Unix.

ETL Developer

Confidential

Responsibilities:

• Analyzed customer requirements and prepared design/mapping documents.
• Creating SQL queries based on source to target mappings for Target tables.
• Created various mappings by using different kinds of transformations like Source Qualifiers, Expression, Join, Lookup, Filter, Rank, Sequence Generator, Stored Procedure, Router, Normalizer.
• Worked on SQL for Source Overwrite Queries to improve performance.
• Worked with modelling team for source issues.
• Created multiple mappings and workflows.
• Prepared technical design documents and coding specification documents.
• Prepared Unit Test Cases for the modified existing ETL routines.
• Worked closely with the reporting team (Cognos 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 team for performance improvement issues.
• Experienced in handling large volumes of data.
• Code developed based on the business requirements.
• Developed 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 PC 8.6/Cognos BI, Oracle, Windows/Unix.

ETL Developer

Confidential

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 targets.
• ETL performance optimizations with SQL.
• Worked with Modelers and Architects for table issues.
• Worked on building mappings and 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 environment to ensure defect free code
• Provided Development support for System Testing/ User acceptance testing.
• Migration of workbook creation and tracking the code versions.

Environment: Informatica PC 8.6, SQL, Oracle, Windows/Unix.