SUMMARY:

• Over 6 years of Data warehousing experience and creating reports using Tableau Business Intelligence. OLTP and OLAP, Microsoft SQL Server and Oracle.

TECHNICAL SKILLS:

• Tableau, Microsoft SQL Server, T - SQL, PL-SQL, OLAP, OLTP, Erwin Data Modeler, Microsoft Visual Studio, Microsoft Office, MS Project, HTML, CSS, Java Script, XML, Java, data mapping, BRD, Documentation, Prototypes, Sankey, Waterfall, Pareto charts.

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Senior Tableau Consultant

Responsibilities:

• Spearheaded the development and adoption of a one source data management tool.
• Develop and design Tableau dashboards and interactive data visualizations and develop automated processes for updating content used in standardized dashboards.
• Audit datasets and data analyzed as required ensuring their continuity, accuracy and consistency while directing administrative and support activities across a multi-environmentTableauinfrastructure as it pertains to security administration, release management, troubleshooting and general systems maintenance.
• Lead development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.
• Oversee the creation of groups, assignedroles and permissionsforTableauUsers ensuring integration points and the order in which these must be executed.
• Review, assess and promote the adoption and standardization ofTableausupport solutions through teams, with insights out of voluminous and complex datasets and built story lines through the production of complex table calculations, use parameters, actions, filters and other advanced options inTableau.
• Develop, manage and implement reporting processes to improve efficiency, collaboration and innovation.
• Led in the development and maintenance of RADAR reporting and data management for regulatory and internal risk reporting, implement reporting processes to improve efficiency.

Environment: Tableau (Desktop), Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook)

Confidential

Sr. Tableau Consultant

Responsibilities:

• Effectively used data blending, filters, actions, Hierarchies feature inTableau.
• Designed Tableau Dashboards, wrote writing complex SQL Queries, conducted Data Analysis, Requirement Analysis, Functional Specifications, Data Cleansing, Data Modeling, Data Architecture, Gap Analysis, Data Transformations, Data Relationships and Reporting Analysis and converting existing Excel reports in toTableaureports.
• Created multiple scorecards and dashboardsproviding ongoing support to BI application running in production & troubleshoot on a daily, weekly and monthly basis to ensure that the developed dashboards are up to date live and sent those into production
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security while defining best practices forTableaureport development.
• Developed efficient & custom SQL statements for report and analyzed data to identify data inconsistencies and fixes through testing required queries and reports before publishing.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked with Teradata database and pull data to work on BI requirements.

Confidential, Austin TX

Sr. Tableau Consulta nt

Responsibilities:

• Performed data analysis on daily, weekly and monthly basis to ensure that the developed dashboards are up to date live and sent those into production
• Used TableauDesktop for blending databases and create interactive views and designing multiple scorecards and dashboards.
• Actively involved in new KPI generation forTableau Scorecards for data collection and leveraging on data manipulation teams for required data.
• Worked extensively using SQL and Excel to validate the data and use as the source data files while migrating existing Alteryx and Excel reports in toTableaureports
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets usingTableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked with Teradata database and pull data to work on BI requirement.
• Provided support for BI application running in production & troubleshoot.

Confidential

Tableau Developer

Responsibilities:

• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation, ETL processes and performance tuning of applications issues with the PL/SQL stored procedures.
• Designed, developed and deployed SSIS Packages while creating database objects such as tables, views, stored procedures, Triggers etc.
• Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Created functions to provide custom functionality as per the requirements with acute awareness of potential blocking, deadlocking and written code to avoid those situations.
• Ensured that the code is written keeping in mind any security issues such as SQL Injection.
• Identified and written best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
• Participated in development and creation of Data warehouses.