SUMMARY:

• Over 6 yearsof progressive expertise in design, configuration, development, testing and implementation of Data warehousing and Business Intelligence Tools TABLEAU DESKTOP 10.0x, 9.x, 8.x, TABLEAU SERVER, INFORMATICA.
• 4+ years of experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 9.x/8.x/7.x.
• Experience in information technology as SQL BI developer involving in all phases of SDLC, using Agile and Waterfall methodologies.
• Extensive knowledge in T - SQL queries DDL and DML.
• Extensively worked on Business Intelligence technologies like SSIS, SSRS, and SSAS of MS SQL server 2005/2008/2012.
• Good understanding in Normalization and Relational Database Management Systems.
• Worked on different phases of data visualization development lifecycle, from gathering requirements to testing and implementation
• Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• 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.
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Experience in development of user defined reports to provide on demand data analysis using excel and created charts and pivot tables in Excel.
• Strong knowledge on software development life cycle (SDLC).
• Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.
• Created Derived Columns to fulfil the User Requirements and created Parameters to reports be more User friendly to End Users.
• 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
• Formatting the Data by using Legends, Marks, Colours, Sizes, and Shapes.
• Good knowledge of Data Warehousing Concepts.
• Gathering data sources like Excel, Oracle & Teradata DW s, and Inline & txt files in developing the Data Models.
• Performance tuning by analysing and comparing the turnaround times between SQL and Tableau.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Windows 7, Windows Server 2005/2008

Domain Knowledge: Business Intelligence, Manufacturing, Pharmacy, HealthCare

Databases: Oracle10g, SQL Server2005,2008R2,IBMDB2, Teradata, MS Access 2000

Languages: IBM DB2, HTML, SQL, PL/SQL, XML, C, C++, VB 6, VBA, VB.NET, C .NET, TML, SQL

ETL Tools: Informatica Power Center, Power Exchange, Data Modeling, IDQ.

Business Intelligence Software Tools: TABLEAU DESKTOP 10.0x, 9.x, 8.x, TABLEAU SERVER, Business Objects 4.0, 4.1 and SAP BI 7

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Tableau Developer/ Data Analyst

Responsibilities:

• Responsible to provide data insights for Confidential product management and Confidential animal nutrition division.
• Using Confidential data platform like the Flat file, Impala, Teradata, I am responsible to gather data from a different source and create Tableau dashboards as per the requirements.
• Attend scrum meetings, gather the requirements and deployed the datasheets based on the business requirement.
• Created Trading desk summary of commodity for various positions of month with net premium and future obligations of values
• Created columnar dataset, bar graphs, Tree map, Geo maps, tabular data presentation, Highlight tables, dual axis graphs, Geographical Data and multiple worksheets.
• Worked closely with product teams with requirement calls and do data validation and enhancements.
• Responsible for Tableau confluence in the team.
• Maintained site admin by creating projects, adding users, publishing workbooks, creating schedules for the dashboard and optimizing Tableau dashboard performance.
• Maintain Data backups, Involved in Scale up and Scale out of a server
• Installation and configuration of Single, Multi-Node configuration.
• Generated high detail-oriented views using multiple measures, Individual Axis, Dual Axis and Custom Geo-coding.
• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Effectively used bar chart, bubble chart, maps, and heat maps to answer business questions.
• Work with product management to determine, validate and implement a long-term strategy for Tableau

Environment: Tableau Desktop, Tableau Server 10x, Teradata, Impala

Confidential, New York, NY

Senior Tableau Developer/Analyst

Responsibilities:

• Involved in reviewing business requirements and analyzing data form Excel/Oracle SQL Server for design, development, testing and production rollout of reporting and analysis projects with Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that was broken into regions allowing business user to understand the customer distribution and density.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, MS SQL Server and MS Excel.
• Blended data from multiple data bases into one report by selecting primary keys from each database for data validation.
• CombinedviewsandreportsintointeractivedashboardsinTableauDesktopthatwerepresentedtoBusinessUsers, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right join sin Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with quick filters to filter needed information.
• Understand the Requirements and Functionality of the application from specifications.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
• 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.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Tested dashboards to ensure data was matching as per the business requirements and if the rewire any changes in underlying data.

Environment: Tableau Desktop 9.0x, 8.1 xs, Tableau Server, MS Office Suite, Oracle, SQL Server, MS Excel

Confidential, Irving, TX

Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Upgraded Workbooks and Dashboards from Tableau 7 to 8
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
• 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 data sources together on one dashboard to filter data in multiple views.
• Involved in new KPI generation for Scorecards. 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.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, quick filters, actions, hierarchy features in tableau.
• Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled frequency and time to refresh data for the data sources are publishes or extracted to server.
• Involved in gathering the requirements and analyzing the requirements,
• Regularly interacting with customer to resolve issues.
• Responsible for Preparing the Report Design specifications based on the User’s requirement.
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Experience with the design and development of Tableau visualization solutions.
• Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.

Environment: Tableau software 8.3 xs, Tableau Desktop, Tableau Server, Oracle, Informatica, Windows.

Confidential, Washington, D.C

Tableau Consultant

Responsibilities:

• Worked on Database design and reporting. Experience working with Tableau development of dashboards and publishing the reports. Working on Data warehousing and reporting.
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
• Experience in using SQL Server 2005 Integration Services (SSIS) to extract, Transform and Load data from any OLEDB Provider like DB2, MS Access, Flat File, Excel, Oracle, Lotus notes and Sybase and DTS (i.e. Import and Export) and Automate the ETL operations. (Automate SSIS Packages and Import, Export).
• 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.
• Built diverse types of chart reports using SQL Server Reporting Service for the business requirement like column chart, Pie Charts.
• Creating dataflow diagram and documenting the whole data movement process.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
• Migrating data based on the confirmed Customer's, Technician's and Service Provider's.
• Creating report models and deploying on report server.

Environment: Tableau Server 6.0, Tableau Desktop 6.0, MS SQL Server 2008, Informatica 8.6, Windows

Confidential

Data Warehouse / Informatica Developer

Responsibilities:

• Involved and Designed the System Development Life Cycle, i.e. such as conducting the preliminary investigation and technical specs.
• Involved in creation of tables, writing stored procedures, Triggers.
• Created facts and dimensions according to the business requirements.
• Performed Normalization and Logical Database Design Unit Testing of the modules.
• Developed user-friendly forms for easy data entry.
• Developed SQL procedures for database updates and to create the necessary indexes in the target tables.
• Created UNIX shell scripts to invoke the SQL scripts which are run daily.

Environment: Informatica7.1, Flat Files, Oracle 8i, SQL, Windows 2003, Toad.