SUMMARY

• Having 9 years of experience in Tableau Developer/Admin interpreting and analyzing the data to drive successful business solutions.
• Expert level of knowledge in Data warehousing and business intelligence space.
• Possess the ability to understand any complex business processes and leverage the BI tool to construe the data into meaningful visualization.
• Expertise the data modelling, and relationship build in SQL,Tableauprep and Tableaudata sources.
• Involved in creating groups, adding users, and defining roles to the users on the tableau server.
• Extensively worked on various Tableau desktops 9.x/10.x, 2018.3, 2019.2 versions, Tableau Server, Tableau Online, Tableau reader.
• Experience in creating rich interactive visualization reports and dashboards in Tableau Desktop and server utilizing LOD, Filters, Actions, Parameters, sets, Groups, Extracts, Data Blending, and Page Trails.
• Extensively involved in the development of various interactive dashboards and reports such as Dual Axis, Pie - charts, Heat Maps, Waterfall Charts, Bar Graphs, Bubble charts, Box plots, and Tree Maps.
• Experience in Performance TuningTableaureports.
• Experience in using all the Data Virtualization tools and integrating them with the applications and services.
• Developed business critical Interactive dashboards.
• Worked closely with UX and Business teams to deliver the desired functionalities for the reports.
• Experience in Tableau server installation, configuration, and enforcing security in Tableau.
• Involved in the deployment activities supporting the software backup and providing extract failure alerts to support teams.
• Experience in report development, testing, and publishing on Tableau Server.
• Used SQL Queries at the custom SQL level to pull the data in the tableau desktop.
• Involved in reviewing business requirements and analyzing data sources from Excel, Oracle, and SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Experience in Creating Users, Groups, and Projects on Tableau Server, Involved in Tableau server upgradation activities.
• Experience in creating different types of Complex Reports using SSRS.
• Extensive experience in working with Relational databases such as Oracle, SQL Server, DB2, Teradata and MS Access.
• Used ETL Effectively for complex joins of various Scenarios.
• Good Knowledge in R open-source programming language tools.
• Used R Programming in Tableau for developing statistical software and data analysis, Tableau to visualize the results in a simple way.
• Integrated the dashboards onto the portal by working closely with the UI team.
• Good understanding ofData modeling(Dimensional & Relational) on conceptslike Star-schema, and Snowflake schema usingfact and dimension tablesand relational databases (Oracle), Teradata, Netezza, AWS Redshift and Hive.
• Highly Proficient in Agile, Waterfall, and Scrum software development life cycles.
• Experience in ETL design, development and maintenance usingSQL, PL/SQL, and SQL Loader.
• Well-versed in query optimization for performance tuning and monitoring of processes.
• Experience working as a BI Consultant with a specialization inBusiness Objects and Web Intelligence.
• Knowledge in building/maintainingRepositories, Universes and creating ad-hoc reports.
• Experience in resolving universe issues like Loops and Traps using Aliases and context.
• Highly motivated to take independent responsibility as well as the ability to contribute and be a productive team member.

TECHNICAL SKILLS

Data Visualization: Tableau9/10/2019.1, POWER BI, SRSS, IBM Cognos Analytics

Databases: MS Access, SQL Server, Azure, Oracle 11g/12C, IBMDB2, IBM Netezza, Hadoop, PostgreSQL, Snowflake

ETL: SSIS, Informatica, Alteryx,TableauPre

Languages/Tools: Python, Java, C, HTML, JavaScript, PHP E-Commerce

ERP: Microsoft Dynamics (GP), Order wise, Davis, Inventoria

OS: Windows 7/8/10, Server 2005/8/8R2/2012, RedHat, CentOS

Other Tools: TOAD, MS OFFICE, MS Visio, Jira, HP ALM, BMC Remedy.

Familiarity: Active Directory, VPN, MS Exchange Server, Outlook Management, Mobile Active Sync, Network Hardware Firewalls, Sharepoint

Methodologies: Agile & Waterfall

Knowledge: SAP, Salesforce, Data warehousing, Tabular and Multi-Dimensional Data Models

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr.Tableau Developer/Admin

Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.0, 8.2and 8.1.
• Large datasets were handled in Google BigQuery to manage the data.
• Coordinated Client to understand and analyze business requirements.
• Worked on custom SQLs creations and helped the database teams in coordinate with tableau reports by creating data models and metadata layers.
• Extensively worked with pivot tables, v-lookup, graphs and charts to analyze large sets of data using Excel.
• Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production.
• Created KPIs across channel presence, digital media reach and engagement into a single Digital IQ scorecard.
• Evaluated the score for each member, zone, region and nationally to gauge system performance using theTableau.
• Created dashboards to enable a fast read on claims and key business drivers and to direct attention to key area
• Mastered the ability to design and deploy rich visualizations with Drill Down and Drop-down menu option and Parameterized usingTableau.
• Created Complex calculated fields in getting Turn Around Time and Aging of the devices as per business requirement for the given time frame.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Filled Maps and Symbol Maps according to deliverable specifications.
• Extensively usedtableauParameters, Data blending, Action filters, joins and Drilldowns
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Extensive experience in Tableau Administration Tool,TableauInteractive Dashboards,Tableausuite.
• Created Expression, Lookup, Filter, Router, Aggregator Transformations were implemented to load the data from source to Target using Designer.
• Developed Custom SQL scripts to view required claim data in developed dashboards.
• Optimized SQL scripts to improve the efficiency on the database.
• Involved in performance tuning fortableauDashboards.
• Developed transformation logic and designed various Mappings using the Designer
• Extensively used SQL to analyze the data. Experienced in handling large volumes of data.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.
• Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI’s.

Environment: TableauDesktop 8.3/9.2,10.3Tableauserver / Administrator, Informatica PowerCenter 9.1, SQL, Unix Shell Scripting, Google BigQuery.

Confidential, CA

Tableau Developer

Responsibilities:

• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Created Business requirement documents and plans for creating dashboards by designing and developingTableauvisualization solutions.
• DevelopedTableaureports and effectively used data blending feature in theTableauusing calculated fields.
• Created different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, and Highlight tables.
• Used ETL tools such as Tableau Prep, Power Query, and Alteryx to combine multiple data sources from SQL databases, Salesforce, Excel, Snowflakes, CSV, and web applications with Python scripting.
• Built interactive dashboards with filters and highlighters, with the ability to combine multiple data sources, and worked with Agile campaign planning teams to determine KPIs and objectives.
• Experienced in data visualization, data blending, and reporting automation with products such as Tableau Prep, Tableau Desktop, Power BI, SQL, Alteryx, Snowflake, AWS cloud Database, Google Analytics, CRM database, Excel, SharePoint, etc.
• Implementedmetrics, filters, reports, and dashboards and also created advanced chart types, using calculationsto manipulate the data and enable user driven parameters for visualizations and drilled down level of detail using sets. Createdinteractive data visualizations inTableau, using relational and aggregate data sources.
• Createdcomplex dashboard using parameters, sets, groups and calculations and drill down
• Developedproceduresandfunctionsfor the validation ofinput data and to implementbusiness rules.
• Developedinteractive views with action/highlight filtersto track-manage-correct system entry errors which provided strategic insights to Finance leaders, that helped decrease the faulty inputs into their projects software.
• Implementcomplex formulas, calculations & Level of detail (LOD) withinTableauto meet the needs of complex business logic.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• ConnectedTableauto various databases and performed live data connections, query auto updates on data refresh.

Environment: TableauDesktop 2018.2/2018.1/10.5/10.3 , TableauServer 10.3, MS Office Suite, SQL Server, PL/SQ, Teradata, MS Excel.

Confidential, Chicago, IL

Tableau Developer/Admin

Responsibilities:

• Responsible for developing dashboards and Ad-Hock reporting.
• Mastered the ability to design and deploy rich Graphic visualizations and Drill-down and Drop-down menu options and parameters usingtableau.
• Extracted data from multiple sources such as SQL database, Salesforce, Excel, Snowflakes, CSV, and web applications using ETL tools like Tableau Prep, Power Query, and Alteryx.
• Managed BI releases and BI Solution development to ensure the success of the BI projects, as measured by on-time delivery, quality in meeting business user needs, as well as stability and performance of the BI Platform.
• Developed custom Salesforce solutions using Visualforce pages, Apex classes, Triggers, SOQL, SOSL, Custom Tabs, and Custom Objectives.
• Extensively involved in creating graphs by using measures and dimensions data from various databases by using blending concept.
• Created different KPI’s using calculated key figures and parameters.
• Developed Sankey Charts.
• Worked on Actions, Calculations, Parameters, background Images, Maps, Trend Lines, Statistics and Table Calculations.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems to effectively develop technical solutions to their requirement.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Publishing the dashboards onto the server and giving required access to associated groups as Interactors or Viewers.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various sources and targets.

Environment: TableauDesktop 10.4,Tableauserver / Administrator, Postgres.

Confidential, Austin, TX

Tableau Developer

Responsibilities:

• Experience in designing and development ofTableauvisualization solutions and Created Business requirement documents and plans for creating dashboards.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver. Creating New Schedule's and checking the task's daily on the server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices forTableaureport development andeffectively used data blending feature intableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Creating users, groups, projects, Data connections, settings as atableauadministrator.
• Involved in creating dashboards and reports inTableau8.1 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

Environment: TableauDesktop 7.2, 8.1,Tableauserver / Administrator, SQL.

Confidential, NJ

Tableau Developer

Responsibilities:

• Participated in the daily stand-up SCRUM agile meetings as part of AGILE process for reporting the day-to-day developments of the work done.
• Created visually appealing and interactive dashboards using Tableau Desktop, Tableau Server, incorporating filtering, highlighting, and the ability to combine multiple data sources.
• Developed reporting solutions in Tableau using best practices and proficient in performance optimization.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Effectively used data blending feature intableau.
• Defined best practices forTableaureport development.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized usingTableau.
• Work closely with business partners to understand their needs and to design / implement appropriate solutions.
• Design and implement database schema, including table and view creation.
• Maintain an existing code base and develop new code including complex SQL queries, stored procedures.
• Installed, configured, and Administered SQL Server instances on both clustered and standalone machines.
• Scheduled jobs to automate different database related activities including backups and index optimizer.
• Managed user access and created new security accounts. Assisted in developing business intelligence reports, dashboards, and visualizations performed backup and restore of databases.
• Deployed SSIS packages on production servers and troubleshoot SSIS job related issues.
• Experience in Development, software Design, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Experience in creating technical specifications and manages test case development.
• Experience in data modelling design and analysis. Managed user access and created new security accounts.
• Experience in troubleshooting, technical support, and report design.
• Ability to design and deploy Graphic Visualizations.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Provided support forTableaudeveloped objects and understand tool administration.
• Worked inTableauenvironment to create dashboards like weekly, monthly, daily reports usingTableauDesktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement inTableau.
• Created Workbooks and dashboards for analyzing statistical billing data usingTableau.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports inTableau.

Environment: Agile,Tableau,TableauServer,TableauDesktop, Desktop Publish, SQL Server, Windows Enterprise Server, Windows, MS Access, Excel, SQL profiler, SSIS, SSRS, SSAS.