SUMMARY:

• 8 years of dedicated professional experience in Data warehousing, Business Intelligence and Reporting.
• Extensive experience working with Business Intelligence data visualization tools with specialization in Tableau Desktop 7.0/8.x/9.x/10.0 and Tableau Server.
• Involved in SDLC of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.
• Worked extensively on Joining Tables, multiple data connections using Data blending, worked on Data Extracts and Managing custom queries.
• Mastered in using Filters, Sorting, Groups, Sets, Hierarchies and Reference lines in different kinds of Graphs/Charts in Tableau.
• In depth knowledge in Tableau Advanced Analysis features like Actions, Calculated fields, Parameters, Forecasting and Trend lines. Hands on experience on working with LOD(Level Of Detail) Expressions in Tableau 9.X and 10.0 versions.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) of the business.
• 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.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Worked on both RDBMS (Oracle, SQL Server, SAP HANA) and Big Data databases (Mongo DB, Hive) to develop the Dashboards/Reports as per client requirements.
• Practical Understanding of the Data Modelling and Dimensional relational concepts like Star - Schema Modelling, Snowflake Schema Modelling, Fact and Dimension Tables.
• Strong working knowledge on Agile (Scrum) Methodology in ETL Environment.
• Worked extensively with ETL(Extraction, Transformation, Load) tool Informatica Powercenter 9.1/9.0.1/8.6 to integrate the data from various data sources and load into Data warehouse/Datamart by applying various transformational and business logics.
• Experience in working with Slowly Changing Dimensions (1,2,3) and setting up Change Data Capture (CDC) mechanisms.
• Strong experience in writing SQL queries.
• Proficient in Oracle Database and Unix Shell Scripting.
• 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.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop7/8.x/9.x/10.0, Tableau Server, Cognos BI.

ETL Tool: Informatica Power Center 9.6.1/ 9.1.0/9.0.1/8.6.1

Databases: Oracle 8i/9i/10g/11g, SQL Server 2008/2005, DB2, Tera Data, Big Data (Mongo DB, Hive).

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

Operating Systems: Windows 9x/XP/2000/Vista/7, Unix.

Tools: and Packages: SQL Server Management Studio, Toad, Erwin.

Scripting: Unix shell scripting.

Methodologies and Concepts: Agile(Scrum),ER Modelling and Dimensional Modelling, Data Warehousing.

PROFESSIONAL EXPERIENCE:

Confidential, Woonsocket, RI

Tableau Developer/ Data Analyst

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 and Seasonal forecasting.
• Used industry standard design templates 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 and Histograms.
• Developed doughnut 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, Bands and 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.
• Performed Administrative tasks to create Sites, adding Users and Groups to specific sites and providing them site roles and setting Permissions.
• Developed dashboards on Relational Databases and NO SQL database (Mongo DB, Hive) as data sources and published into Tableau Server.
• 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.
• Closely interacted with the ETL Developers for our reporting needs and get the required data to build effective reports.
• Worked Closely with Business users, 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, Big Data (Mongo DB, Hive).

Tableau Developer

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 and 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 and complex big data sets.
• Developed 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 and 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

Responsibilities:

• Involved in End to End BI project i.e. Moving data from OLTP databases to Data warehouse by an ETL process using Informatica Powercenter and took the reports using Tableau Desktop.
• Responsible for interaction with business stakeholders, gathering requirements, managing the delivery and covering the entire BI Life Cycle.
• Created various mappings from source to target definitions by using different transformations like Source Qualifier, Joiner, Sorter, Aggregator, Lookup, Update Strategy, Expression, Router, Union, Rank etc.
• Scheduled the workflows using Control- M scheduler.
• Involved in creating Worksheets and Dashboards using Tableau Desktop.
• Experienced 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.
• Proficient with Sorting, building Groups and using them in visualization.
• Worked on Global, Local and Context filters.
• Used Parameters to make dashboards more 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.
• 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

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 and 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

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 and Sequence Transformation were implemented to load the data from source to targets.
• ETL performance optimizations with SQL.
• Worked with Modellers 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 and working on defect fixes from System Testing User Testing.
• Tested ETL code in DEV, SIT and 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.