SUMMARY:

• 8+years of experience in Data warehousing and Business Intelligence technologies along with around 5 years of data visualization using Tableau.
• Extensive experience in Tableau Desktop, Server, Reader, Public and Mobile in various versions of Tableau 8.1/8.2 and Tableau 9 and Cognos 10.x/11.x.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• 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 troubleshooting of performance issues which were associated with Tableau reports.
• Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Worked in all phases of BW/BI full life cycle including analysis, design, development, testing, deployment, post - production support/maintenance, documentation and end-user training.
• Involved in administration tasks such as publishing workbooks, managing ownerships, providing access to the users, and adding them to the specific group in Tableau Server.
• Proficient in design and development of various dashboards, reports utilizing Tableau visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement
• Experience in creating dashboards with relational and multidimensional databases including SQL, MS Access at gathering and manipulating data from various sources.
• Strong understanding of project life cycle, SDLC methodologies including Agile.
• Excellent analytical, problem solving and Tableau and SQL debugging skills
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Good understanding of business environment, excellent communication skill and ability to work proactively in a fast paced environment.
• Communicate effectively with colleagues and business users.

TECHNICAL SKILLS:

Business Intelligence Tools: Tableau 9.x/8.x,: Cognos 11.x/10.x, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Dashboards,MS Office,Business Objects XI Release 2, Hyperion

Databases: Oracle 11g/10g/9i/8i, TOAD, DB2 9.5/8.5, SQL Server 2008/2005/2000 , MS Access

SQL Tools: Teradata SQL Assistant, Teradata Administrator, Toad, SQL Developer, SQL Plus

ETL Tools: Informatica 8.x/6.x, Data Stage 8.x/7.x

Data Modeling: Power Designer, Framework manager, Cognos Analytical Application

Operating Systems: Windows NT/XP/2000/98, HP: UX, AIX, Solaris, Linux

Programming Languages: C, SQL, Java, C++, HTML, Microsoft Access, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Greensboro, NC

Tableau Developer

Responsibilities:

• Worked with users and coordinated to understand and capture data/reporting requirements.
• Strong skills in visualizing the data and knowledge on ETL tools like Informatica & Data Stage.
• Created complex dashboard using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into a tableau reports.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for dashboards.
• Embedded the dashboards to Sharepoint, Salesforce environments.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel.
• Involved in reviewing business requirements and analyzing data sources from Flat file, Excel, SQL Server for design, development and analysis projects within Tableau Desktop.
• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Developer Dashboard reports in Cognos for Tax Department and provided Ad-hoc training.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Used Tableau prep to transform the data and build the reports.
• Developed the Tableau Dashboard standard template based on user requirements.
• Developed Tableau Data Visualizations using Cross Map, Scatter Plots, Geographic Map, worked on different chart types based on the requirements including Pie Charts, Bar Charts, Combination Charts, Page Trails, and Density Chart.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
• Created and managed Sites, Users, Groups and Projects in Dev/QA/PROD environments.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and the production rollover of reporting and analysis projects within Tableau Desktop.

Environment: Tableau 2019.x/2018.x, DB2, Windows 7, SQLServer, MSOffice. Tableau Prep, Cognos 10.x/ 11.x, Sharepoint

Confidential, Tacoma, WA

Tableau BI Consultant

Responsibilities:

• Worked with users and coordinated to understand and capture data/reporting requirements.
• Gathered Business Requirements, interacted with the Users and Project Manager to get a better understanding of the Business Processes. Experience in using Tableau functionalities for creating different Requests, Filters, Chart, Interactive dashboards with Page and Dashboard Prompts.
• Created Tableau Scorecards, Dashboards, Heat maps using show me functionality.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Prepared dashboards using calculated fields for different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau.
• Ensured the user security for the views using User filters and shared with business users.
• Published the developed dashboards into production and refreshed the scheduled extract, tuned the performance of the dashboard and created tableau functional design document.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advanced features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• By using Alteryx as a source, reports have been build using Tableau.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in 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.
• Developing Standard and Create reports using Tableau Desktop.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements

Environment: BI Applications, Tableau 8.1/8.2/9.0, Windows 7, SQL Server 2012, Oracle 11g/12c, Excel, MS Access 2010, Oracle 11g, PL/SQL Developer, Toad, Windows 7, MS Office. Alteryx, Salesforce

Confidential, Torrance, CA

Tableau BI Consultant

Responsibilities:

• Worked with Business Users and co-ordinate with them to understand and capture data/reporting requirements.
• Provided cardinality, check data usage, identifiers in the database view.
• Developed reports for the rolling time period and match back sales report.
• Planned an approach for documenting, categorizing and packaging the requirements.
• Involved in data analysis and data modeling to manage the data.
• Involved in management of ticket handling related to data issues and report enhancement.
• Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision-making.
• Tested and validated the report output against the database to measure performance of reports.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau. Between the files for the report development.
• Importing/exporting the data
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Created action filters, Donut chart, Pareto chart, Bar graphs and Histograms, parameters, LOD expressions and calculated sets for preparing dashboards and worksheets in Tableau.
• Created customized and interactive dashboards using multiple data sources.
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.
• Used Oracle, SQL server as data sources for designing Tableau Reports and Dashboards.
• Publishing the reports to the server and granting privileges and adding new user groups to the server.
• Performed unit testing on dashboards
• Developed Complex dashboard reports for various reporting requirements.
• Performed Troubleshoot on various existing reports that had issues and fixed Remedy tickets from production system.
• Build reports around financial data and insurance data.
• Validated reports using TOAD and performance tuning.
• Trained business users on how to build a simple ad-hoc reports and the functionality of built reports.
• Ability to write high level complex queries at the front end to build the reports.
• Deployed the reports from Development to Testing and then Testing to Production environments.

Environment: Tableau8.1.x/9.x, Alteryx, Transformers, OLAP Cubes, Oracle 11g, MS Office, SQL Developer/Toad, Windows 7, IBM UNICA Campaign 8.5.0.027 and marketing Platform 8.5.0.0.13

Confidential, Mansfield, MA

Tableau BI Consultant

Responsibilities:

• Worked with users and coordinated with Business Objects developers to understand and capture data/reporting requirements.
• Responsible for creating dashboards and overall creation of data visualizations.
• Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL server, oracle, spreadsheets etc).
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.
• Used Oracle, SQL server as data sources for designing Tableau Reports and Dashboards.
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements.
• Expert level capability in Tableau calculations and applied complex, compound calculations to large, complex data sets.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in writing Test Cases, procedures, reports and approval of a software release.
• Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.
• Designed and Developed Complex Active reports and Dashboards with different data visualizations using Tableau desktop on customer data.
• Developed Technical requirements, design requirements and user acceptance documentation by placing Screen shots of actual Report and tested the report in documentation.
• Deployment of defect free code while managing the timeline set for the project.
• Validated reports using TOAD by writing queries and performance tuning.
• Created different reports for YTD and MTD comparisons.
• Proficient with UNIX and shell scripting.
• Created complex reports in Tableau while replicating the reports from Business Objects.
• Created Technical requirements for developers to build their reports on Tableau.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of the report.

Environment: Tableau 7.0/8.0, Teradata, Oracle 11g, SQL Server 2008, TOAD, PLSQL Developer, SQL Developer, SAS, Informatica, MS VISIO, Microsoft (Word, Access, Excel, Outlook), Business Objects XI Release 2, Hyperion, SQL Developer/Toad, Windows 7

Confidential, Irvine, CA

Cognos Developer

Responsibilities:

• Worked with users and coordinated with actuate developers to understand and capture data/reporting requirements.
• Developed Dashboards using Business Insight and business insight advance.
• Created Active reports for YTD and MTD comparisons.
• Wrote complex SQL queries to understand the actuate code and implement the changes.
• Created Technical requirements for developers to build their reports on COGNOS.
• Worked along with developers to create some of the high-level reports for POC to the users.
• Developed models and published in Framework manager.
• Created Ad hoc and batch reports with complex functionality to replicate the actuate reports.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Validated reports using TOAD and performance tuning.
• Build reports in Workspace.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements.

Environment: IBM Cognos 10.1/ 10.2, Cognos 8.3/8.4 (Framework Manager, Analysis Studio, Report Studio, Query Studio, Metric Studio, Workspace), Teradata 13, Oracle 10g, Teradata SQL Assistant, Teradata Administrator, PLSQL Developer, SQL Developer/TOAD, Windows 7, QlikView.

Confidential, San Antonio, TX

Cognos Developer

Responsibilities:

• Actively involved in Requirement Gathering from Business Users and Developed Technical Documentations for the Business and IT Team.
• Worked extensively on Cognos 10.1 with Report Studio, Analysis Studio.
• Created Prototypes for the business showcasing them the Models and future report samples and Dashboards.
• Build reports using Property and Casualty Insurance data like drill through, list, Cross table charts
• Worked on-shore/off-shore model. Experience guiding a team of 3 off-shore developers.
• Validated reports using TOAD and performance tuning.
• Prepared User Documentation to train users and to explain the functionality of each report.

Environment: Cognos 10.1/8.4 suite (Query Studio, Report Studio, Analysis studio), Cognos Power Play Transformer, IBM Cognos Administration, IBM Cognos Express, Cognos Go Office, Teradata 12, Teradata SQL Assistant, Oracle 11g, SQL Server 2005,TOAD, Process Explorer, Wireshark, Win NT/XP/2003/Vista, Citrix.