SUMMARY

• 7+ years of experience in Data Visualization, Analytics, Data Management, Data Integration, Implementation and Maintenance of Business Intelligence, Data Reporting and Database Design.
• Excellent Knowledge of Tableau Desktop and Tableau server and have experience in delivering Business Intelligence solutions.
• Developed many interactive dashboard using MicroStrategy BI Tool.
• Developed many interactive dashboard using Qlik View BI Tool.
• Use the Microsoft Power BI to create many interactive dashboards for the end users.
• Experience in gathering and writing detailed business requirement and translating them into reporting needs or technical specifications.
• Extract large volumes of data from proprietary data sources to develop Tableau interactive high performance business dashboards using effective visualizations.
• Extensive Knowledge about features of Tableau like parameters, sets, groups, actions, filters (local and global), table calculations (percentage of total, moving calculations, running total, percentage difference from, difference from, rank etc)
• Calculated fields, date calculations, number calculations, string calculations, logical calculations and type conversions etc.
• Experience in Data Blending for getting the data from multiple data sources.
• Published various dashboards on to the Tableau Server. So that end user can view the data
• Used dual axis for analyzing different measures and used guided analysis in the worksheets
• Experience of Trend Analysis for showing trend of different measures.
• Experience using Big Data technologies, Hadoop, HIVE, No - SQL databases ( like Hbase, Mongo db), SQL databases ( like Oracle, SQL server etc) for dashboard creation.
• Proficient in design and development of various dashboards by utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, page, geographic visualization etc 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.
• Worked on existing reports to add features and functionality as requested by Clients/Users.
• Delivered reports to Business team on timely manner. Resolved the issues with Tableau dashboards or reports.
• Experience of business intelligence principles with business owners, application owners, data analysts and DBAs
• Excellent SQL, PLSQL knowledge on Queries, Stored Procedures, Triggers, Cursors, User Defined Functions (UDF), Views, and Indexes
• Support the development of Data Warehousing and BI solutions in support of the cross-functional teams
• Strong technical background with an understanding of relational databases, data warehouse modeling, architectures, data migration, data marts, OLAP, OLTP etc.
• Knowledge of ETL tools (Informatica, Data Integrator, Data Transformation Services, etc.)
• Experience in Shell Scripting, Partitioning, Dimensional Data modeling, Star Schema, Snowflake Schema, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in loading data from flat files using external tables, SQL*LOADER.
• Extensive knowledge of all phases of the Software development life cycle (SDLC), Agile, Scrum model.
• Experience to work with senior management to identify strategic goals and give presentations at client side.
• Flexible, enthusiastic, logical, efficient, proactive, self motivated and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.
• Excellent interpersonal and presentation skills with a customer service oriented attitude.
• Ability to be a self-starter that can provide leadership.
• Flexible; readily accepts new changes; open to new ideas and maintains positive attitude.
• Self-motivated and ability to apply good judgment and decision-making skills.

TECHNICAL SKILLS

Operating Systems: Linux, UNIX, MAC OS, Windows XP/Vista/7/8/10

Software Packages: MS Office (Word, Excel, PowerPoint, Visio, Project), Rational Rose.

Programming Languages: SQL, PL/SQL, Java, C#(.Net),HTML,PHP

Database Servers: MySQL, MS Access, Oracle, SQL Server, Teradata,DB2.

Processes/Technologies: SSIS, SSRS, SSAS, Agile, RUP, UR&D, Clear case, Change Management, Use Cases, Workflow, UML

BI Tools: Tableau, Cognos, Power BI,Qlik View,MicroStrategy, SAS

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton, FL

Sr Business Intelligence Analyst/Tableau developer

Responsibilities:

• Interact with business users for requirement gathering and Functional Requirement Document preparation.
• Developed many interactive dashboard using MicroStrategy BI Tool.
• Developed complex dashboard by connecting to various data sources like Sql Server, Data Transformation Services (DTS), Oracle, DB2, Teradata, Access, Excel etc.
• Developed many reports and dashboards for Metrics which measures the Critical KPIs (Key Performance Indictors) of the Organization.
• Advanced set analysis, action filter, custom SQL writing, set, parameter and Data Blending in Tableau dashboard.
• Creation of advanced chart (e.g. Pareto chart) to show different Metrics performances across customers or distribution of sales by order type (shipping urgency, shipping method, order method etc.) by using table calculation (e.g. running total).
• Provide support and resolve design and data issues in Tableau documents and views based on tickets raised by users.
• Coordinate with upstream teams to get the data source criteria and calculations information for developing and designing the Tableau dashboards.
• Developed business oriented high performance dashboard for Transportation, Distribution, Order Management, Finance and other departments of Supply Chain.
• Created the many SSIS packages to import the data from external source into sql server production database.
• Given Interactive Tableau Training to other team members
• Developed many reports and landing pages in Cognos and did testing of these reports and landing pages before move to production.
• Created Documentation of all the report and dashboards which are developed in Tableau
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Fine \tuned SQL Queries for maximum efficiency and performance.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and reference lines.
• Interacted with the existing database developers and DBA to understand the existing schema.
• Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard
• Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool
• Participated in daily stand-ups with clients on daily design and development effort
• Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Automate monthly excel reports into Tableau Workbooks and Dashboards.
• Produce standard monthly reports using Tableau.
• Work on generating various dashboards in Tableau server using various data source
• Install upgrade Tableau server and server performance tuning for optimization.
• Administer user, user groups, and scheduled instances for reports in Tableau Server.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Worked with Business Analysts and the Business users to understand the user requirements, layout, and look and feel of the dashboard to be developed.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated context filters and used performance actions while handling huge volume of data.
• Created Customized and interactive dashboards using multiple data sources.
• Experience in creating Users, Groups and Projects on Tableau Server.
• Use of Appropriate Formatting Headers, Worksheets with different Visualization Color Coding for showing the Complex Data in Dashboards to View easily.
• Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• 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. worked on the sku rationalization project and its documentation.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Distributed Tableau reports using techniques like Packaged Workbooks, Tableau Reader, PDF to different user community.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• Use dual axis feature of Tableau to show the data in two axes at the same time.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle),sql server,teradata,db2.
• Extensive experience in working with Tableau Desktop, Tableau Server and Tableau Online in various versions of Tableau 8.0,8.1,8.2,9,9.1,9.2,9.3,10 and 10.1
• Extensive experience in Data Analysis

Environment: Microsoft Power BI, Tableau (8,8.1,8.2,9,9.1,9.2), Cognos, SQL, PL/SQL, Oracle, SQL Server, SQL Loader, MS Office (Word, Excel, Power Point), Teradata,DB2, Windows XP, Oracle SQL Developer, MS Access, Java, HTML, PHP, SSIS,SSRS,SSAS.

Confidential

Business Intelligence and Data Analyst (Tableau)

Responsibilities:

• Interact with business users for requirement gathering and Functional Requirement Document preparation.
• Developed many interactive dashboard using Qlik View BI Tool.
• Installation of Tableau server in windows machine, set up worker nodes, AD authentication in Tableau server, manage Project, User and Group using TabCMD utility, publish and maintain tableau documents in Tableau connection, schedule and monitor refresh of data extracts.
• Developed complex dashboard by connecting to various data sources like Hadoop, HIVE, No-SQL databases ( like Hbase, Mongo db), SQL databases ( like Oracle, SQL server etc)
• Conceptualization, Design and development of Tableau dashboard for sales and marketing team by working in conjunction with the business users.
• Advanced set analysis, action filter, custom SQL writing, set, parameter and Data Blending in Tableau dashboard.
• Creation of advanced chart (e.g. Pareto chart) to show distribution of sales across customers or distribution of sales by order type (shipping urgency, shipping method, order type etc.) by using table calculation.
• Tableau dashboard optimization following reporting best practices (Tableau Data Extract, Materialized View etc.).
• Provide support and resolve design and data issues in Tableau documents and views based on tickets raised by users.
• Tableau dashboard and Share Point integration POC.
• Optimization of underlying database objects in SQL Server and MS Access database.
• Coordinate with upstream teams like SAP, MF for data files.

Environment: Tableau 8, SQL Server 2005, VB Script, Windows, ODBC, MS Access 2007, Hadoop, HIVE, Hbase, Mongo db, Oracle.

Confidential

Business Intelligence and Data Analyst (Tableau)

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Developed many interactive dashboard using Qlik View BI Tool.
• Analyzed various reports, dashboards, scorecards in MicroStrategy and created the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• 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 connections together on one dashboard and to filter data in multiple views at once.
• 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.
• Dashboard Visualization through Tableau BI application.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, Hierarchies, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Working extensively using Excel to validate the data and use as the source data files.
• Analyzing the data using Statistical features in Tableau to develop trend analysis.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the dashboards or reports.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads, iPhones, and other smart mobile phones.

Environment: Tableau (Desktop, Server), Teradata, Teradata SQL Assistant, SQL, PL/SQL, MS Project, MS Office Suite (Word, Excel, PowerPoint)

Confidential

Business Intelligence and Data Analyst (Cognos/Tableau)

Responsibilities:

• Interacted with all relevant stakeholders to gather functional requirements, and identify reporting needs. Make presentations regarding the project status and requirement gathering purpose.
• Documented requirement specifications addressing deliverables such as business rules, use-cases, and requirements traceability matrices.
• Participated in Agile Scrum meetings, reviews, created user stories, and helped team meet the sprint goals
• Interacted withDataArchitect and Solution Architect in support of the design and development of conceptual/logical/physicaldatamodels and reporting ofbusinessdata
• Worked with functional team to understand and translate business requirements into appropriate reports and dashboards
• Provided recommendations for report/dashboard layout best practices, creating reports, dashboards and working with users to validate them
• Worked with the Program Manager and other team members to plan business analysis activities and manage requirements management plan
• Participated in ETL Processes, Data Analysis and Unit Testing of the reports
• Worked with the developers and stakeholders in the development of test cases and success-criteria that re-enforce the understanding of the requirements as well as validatedatawarehousedesign. Perform UAT (User Acceptance Test) with Stakeholders using UAT Scripts
• Understood various data sources such as SFDC (SalesForce.com) CRM (Customer Relationship Management), Siebel, PeopleSoft, POS (Point-of-Sale) via InfoNow, etc to generate adhoc/scheduled reports

Environment: Cognos, Tableau 8, SalesForce.com (SFDC) CRM (Customer Relationship Management), Informatica, PeopleSoft, Siebel, TOAD, MS Visio, Ms Office, MS SharePoint