SUMMARY

• A Certified Tableau Developer with 10+ years of experience in software design, development, integration, implementation and maintenance of Business Intelligence and database platforms.
• Experienced in Software Development Life Cycle (SDLC) model using waterfall and agile modeling, which includes design, development, analysis, coding, testing and implementation.
• Extensive Tableau experience in enterprise environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Extensive experience working as a Business Intelligence consultant with specialization in SSRS.
• Extensive experience working in Windows, UNIX, LINUX environments.
• Experience in dealing with OLTP/OLAP Systems.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Worked on creating Reports by using Oracle E-business Suite.
• Worked on Cognos and generated reports by using Cognos report Studio.
• Extensively Participated on moving Reports from Cognos to Tableau.
• Worked extensively with the major functionality of SSRS, ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.
• Professional in writing complex Formulas, Sub Reports, Summary Reports.
• Involved in troubleshooting, performance tuning of reports and resolving issues with in SSRS.
• Installation, configuration and administration of SSRS.
• Deployed the reports and scheduled reports for the use of end users and customers.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Experience in developing, configuring and deploying SSIS packages and providing security for the packages.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files and loading into SQL Server.
• Experienced in query optimization (SQL tuning) SQL Profiler, Database Tuning Adviser (DTA), Index tuning.
• Expertise in managing project versions
• Worked extensively with creating reports as per user requirements using MS Reporting Services 2005/2008R2
• Extensive working experience in packages, procedures, cursors and triggers.
• Experienced in tuning long running SQL queries for better performance.
• Expertise in using version controllers like Clear Quest, Clear Case, SVN and PVCS.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.
• Created Dashboards and other virtualization reports using Power BI.
• Worked on all types of transformations that are available in Power bi query editor.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Integrating Jasypt with Tableau for hiding of the sensitive data.

TECHNICAL SKILLS

Languages: HTML, PL/SQL, SQL, XML, and Java/J2EE

Applications: Oracle SQL Developer, Teradata SQL Developer

Reporting tool: SQL server 2005/2008 R2/2016, SSAS/SSRS/SSIS, Cognos

Oracle: E-business Suite, Tableau Desktop, Tableau Server:

Databases: Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2000/2005/2008 R2

RDBMS: MS Access, Teradata, and Oracle.

Operating Systems: Windows XP/7/8, MS-DOS, Sun Solaris, Linux

Web/App Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0, JBoss.

Packages / Tools: MS Office, Toad, Front Page 2000 and Putty.

PROFESSIONAL EXPERIENCE

Confidential

Sr BI Consultant

Responsibilities:

• Collaborated with senior management, subject matter experts, and IT teams to define business requirements
• Transformed business requirements into functional and nonfunctional requirements.
• As Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
• Developed Tableau Reports by using excel sheet, CSV files and SQL server.
• Generated context filters and used performance actions while handling huge volume of data.
• Created effective data models to enhance the performance of tableau dashboards.
• Trained business users to create multiple Ad hoc reports using the certified data sources to find out immediate trends in data.
• Created Tableau Standard design document to provide specific formatting options across agency level.
• Created different kinds of Visualizations based on requirement like Map, year over year (Trend) and KPI.
• Actively participated in Standardization of Tableau Visualizations and color fronts.
• Involved in creating database objects like views, procedures, and functions using SQL to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated fields for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Closely worked with business user in creating Proof of concepts.
• Involved in testing Single Sign for Tableau server.
• Used Map box shape files like census tracks, senate districts, house districts and school districts to generate map bases visualizations.
• Extensively used Tableau prep and Tableau Prep builder for data cleansing and data massaging to improve the Tableau performance.
• Actively participated in standardization requirement gathering document and documenting of developed Tableau Dashboards.
• Involved in enhancement of existing Tableau Dashboard.
• Integrated R with Tableau for predictive analysis.
• Tableau server upgrade installations, testing and performance tuning
• Extensively worked as tableau site Admin by granting access to tableau dashboards and adding users, creating groups and scheduling the data refresh and maintenance of the Tableau visualizations.
• Using Tabcmds and batch commands toautomated png and pdf files generation from tableau server.
• Widely tested Tableau desktop during upgrade of Desktop from v9.4 to 2018.2.3 and then to 2019.3.1 not to break the existing reports.
• Developed tableau reports for user specific for data redaction to hide the PHI data.
• Assisted users in developing Tableau Reports.
• Integrated Tableau Dashboard into Moxie server to display on TV monitors.
• Created layouts and playlists in Moxie Studio.
• Actively involved in POC’s for connecting EDW from tableau using Static IP and thru VDI.
• Modified and created joins to improve the database and execution speed.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Expert in data visualization using Tableau to create complex, intuitive and innovative dashboards.
• Involved in performance tuning using SQL Server Profiler and SQL server hints.
• Created SSIS packages using SSIS Designer for exporting heterogeneous data from OLE DB Source and Excel spreadsheet to SQL Server 2016 .
• Designed ETL packages dealing with different data sources (SQL Server, flat files, and XMLs, etc.) and loaded the data into target data sources by performing various kinds of transformations using SSIS.
• Used various SSIS tasks such as Conditional Split, Script Component Task, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data Warehouse.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Created Dax Queries to generated computed columns in Power BI.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis.
• Published the Power BI reports to my space server and granted access to users as per request.
• Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.
• Actively involved in Oracle redaction process to mask the data as per user security role.

Environment: s: Tableau Desktop v9.4, v10.2, v10.5, v2018.2, v20182.3, v2019.3.1 Tableau Server v10.2, v10.5, v2018.2, v20182.3, v2019.3.1, Tableau prep v2018.2, v2019.3, Power BI SSIS, Omnivex, Moxie studio, Map box, Impala, Oracle, CSV files, Excel, SAS, SQL server, ServiceNow, VBscript Macros.

Confidential

Sr BI Consultant

Responsibilities:

• Developed Tableau reports using SSAS Cubes
• Worked on creating advanced Tableau dashboard, using Intermediate MSBI Tabular models.
• Created calculated members for dashboard development.
• Written MDX queries to create new measure with rebuilding cubes.
• Used MDX queries to create the filters and parameters according to the requirement.
• Actively participated in moving Tableau dashboard under tabular model in to impala.
• Focused on creating dashboards in such away end user can understand by just looking at it in 10 sec.
• Closely with Business Analyst for gathering requirements and educating in using tableau.
• Closely worked with PM, other developers, architects, QAs for software design, estimation, development and testing.
• Actively participated with Architect in decision and moving to Cloudera from Tabular models.
• Used SAS Dataset and store procedure for development of tableau reports.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
• Actively worked on testing reports and improving performance tuning of SQL and tableau dashboards.
• Deployed Workbooks to testing and production environments and presented to end-users.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in the Migration of to SSRS Reports into Tableau.
• Designed and developed Crystal Reports, the Crosstab Reports, and Top N Reports for displaying vital data and summary reports with drill-down capabilities.
• Created Custom functions, formulae, cross tabs, graphs and charts.

Environment: s: Tableau Desktop v8, v9, Tableau Server v9, Tableau online, Crystal Reports 10/2008, Crystal Enterprise 10, SQL Server, SSIS, SSRS, MDX, Hadoop (Cloudera, Impala), SAS, Agile, R and Python.

Confidential

BI Consultant/Analyst

Responsibilities:

• Created Tableau reports using complex custom SQL queries.
• Involved in designing new projects and execute them with minimal human resources.
• Created dashboards using multiple data sources.
• Administered Tableau server and helped in tuning of server.
• Worked Closely with End User/ clients for gathering requirements.
• Worked with MySQL and optimization of SQL Queries.
• Created semantic/metadata layer in Tableau
• Created executive dashboard with KPI visualization (1-2 dashboards, 4-8 KPIs)
• Created underlying drill through detailed reports
• Created Wide variety of dashboards.
• Created aggregated tables using OLAP data source (DW)
• Worked with customers, internal and external, to define and document the scope and functional requirements for data and reporting needs.
• Involved in backup of Tableau server and optimization of server performance.
• Closely worked with manager for designing the workflow.
• Integrated SAS reports with tableau reports
• Integrated Jasypt encrypted data into Tableau and integrated special passwords for viewer to look the sensitive data.
• Worked in integrating the Tableau into mobile applications.
• Modified Existing Framework Model for Open Air.
• Created and modified various reports using report studio like Backlog, Audit, Outstanding liability Etc.
• Created prompts, Calculations, Conditions, Filters using Report Studio.
• Created various types of reports like List and Crosstab etc.
• Used Query studio for Ad-Hoc reporting & trained users in using it extensively.
• Involved in testing and validation all reports of the migration-based projects.
• Performed unit testing of the reports and the framework mode.
• Worked on moving reports from Cognos to Tableau.

Environment: s: Tableau Desktop v8, Tableau Server v8, cognos, MySQL, SAS, Oracle, Jasypt, Sql server, Careinsync (Patent App), Java, Excel, CSV files Worked with stakeholders.

Confidential

Tableau Developer

Responsibilities:

• Involved in requirements gathering and technical discussion of the reporting data model.
• Worked on different Ad-hoc scenarios to come up with various functional specs / Demo’s for User acceptance.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle and Redshift& Google big query.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Involved in importing data from Aster ODBC connections for applications.
• Involved in Analyzing Aster SQL MR Functions in Aster data.
• Involved in using Amazon Redshift & Google Analytics for creating data extracts for workbooks & Dashboards.
• Created custom API’s to interact with Java framework in order to display the dashboards.
• Created dynamic parameters on the dashboard, which user has an option to display various views and selection of different columns & rows as per requirements.
• Involved in UAT & Stress test of the workbooks and also data integrity.
• Extensively involved in documentation of Functional requirements.

Environment: s: Tableau Desktop v8, Tableau Server, Tableau Online, Reader, Oracle, Teradata, Redshift, SAS, Google Analytics, Excel, JAVA, J2EETelligenTech INC

Confidential, Mountain View, CA

Tableau/Cognos Developer

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Extensively used data blending in Tableau.
• Performed Tableau type conversion functions when connected to relational data sources.
• Created incremental refreshes for data sources on Tableau server.
• Ability to authoring on Tableau online by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau online.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating reports as per user requirements using MS Reporting Services 2005/2008R2.
• Involved in creating complex stored procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, views, complex stored procedures, triggers and appropriate user defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and online related issues.
• Migrated reports from Cognos 8.4.1 to Tableau 8.
• Developed Reports by using Cognos.
• Built Framework Manager Models Relational DMR for Standard Reporting and Adhoc Analysis
• Built Framework Manager Models and Published IQD s which are used as Data sources in Cognos Transformer to build a cube
• Implemented Cognos independent row level security based on the Geography and Business units
• Enhanced the Framework Models and Transformer Model to suit the user requirements
• Validated the Data Loads in the Cube using Analysis Studio
• Developed numerous multi tab multi page dashboard reports based on the existing remedy database incident management system with drill through functionality to the detail reports.

Environment: s: Tableau online, Tableau Desktop v7/v8, Windows Server Standard R2, Cognos, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, MongoDB, Oracle, UNIX, Linux RHEL 5.4.