SUMMARY

• 8+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms
• Having 4 years of versatile working experience on Business Intelligence/Business Analytics software also experience in Infrastructure services.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL Model).
• In - depth knowledge on Tableau Desktop and Tableau Server
• End to end experience in designing and deploying data visualizations using Tableau.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Deployed the reports and Scheduled Reports for the use of end users.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Experience in creating ad-hoc reports using Business Objects Web Intelligence tools.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Experience in modelling, architecture, designing, coding, debugging and testing instrument driver/interface and other application in manufacturing, R&D environment across various platforms
• Good Independent / team working skills and experiences, excellent communication skills with very good customer handling capabilities.
• Able to handle different projects concurrently and Lead experience.
• Technical support to the team, reviews of deliverables, communication with offshore team, track all the deliverables and to impart on job training to the team.
• Experience in performing System, Functionality, User Acceptance, Integration and Regression testing.
• Excellent Interpersonal communication, Documentation skills and experience coordinating with project managers, business Analyst, Architects, DBAs and Developers.
• Experience on data warehousing concepts, ETL tool Informatica.

TECHNICAL SKILLS

BI Tools: Tableau Desktop,SAS,MS BI,AWS Redshift,Tableau Server,SAP HANA

ETL Tools: DataStage,Teradata,MicrosoftSQLServerIntegrationServices(SSIS),SSRS, BO Universe Designer, SAP BO, Crystal reports XI/2008

Databases: Microsoft SQL Server,Teradata,Datameer,AWS,HiveSQL,IBMDB2, MySQL

Document management: Visual Source Safe 6.0, Share point

Programming Languages: C, C++, SQL, PL/SQL, C#, ABAP, HTML, JavaScript

Data Modelling: MS VISIO

Applications: Eclipse, NetBeans, Oracle SQL Developer

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

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, Putty, FrontPage 2000.

PROFESSIONAL EXPERIENCE

Confidential, CT

Tableau Architect

Responsibilities:

• Experience with the design and development of Tableau visualization solutions.
• Involved in creating dashboards and reports in Tableau. Created report schedules onTableau server.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand wherewe have most users vs.least users.
• Knowledgeable about AWS data services including S3 and Redshift.
• End-to-End Cloud Data Solutioning and data stream design, experience with tools of the trade: Hadoop, Spark,Storm, Hive, Pig, AWS (EMR, Redshift, S3, etc.)/Azure (HD Insight) and Data Lake Design.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• 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.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Actively participated in clarification meeting with the Clients.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Wrote solid, testable and maintainable code in Hive SQL that meets functional and performance specifications.
• Design and code data schema in a relational database using Javascript.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau 9.x/10.x (Desktop, Server), REST API, SQL, PL/SQL, MS Project.

Confidential, OH

Tableau Developer/Admin

Responsibilities:

• Created and assisted users in Tableau dashboard development
• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Versatile experience as a Tableau Administrator including security and data connections.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Designed and developed reports such as Drill down, Drill through using Microsoft Reporting Services.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
• Has led best practices & guidelines in Tableau.
• Responsible for creating the Datameer links for data Visualization using Datameer.
• Deployed and scheduled the tested Sqoop, Hive and Datameer jobs using Autosys.
• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio

Environment: Tableau Server, Tableau Desktop, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS)/DBA, Oracle 11g, Toad, MS Office, Team Foundation Server, Visual Studio 2010, WCF web service

Confidential, San Fransisco, CA

Tableau Admin/ Data Analyst

Responsibilities:

• Analyzing the Customer Data and interaction with business analysts/users for requirement gathering
• Involved in reviewing business requirements and analyzing data sources and building custom SQL queries to prepare the required data from different data sources such as Excel and IBM DB2
• Created Data Extracts using Filters and Custom SQL queries and Edit the Data source filters as required to extract the data
• Design and Developed Worksheets/views that involve different charts bar graph, scatter plot, Map reports and Detail reports using Tableau Desktop
• Created interactive Dashboards by creating Filter Actions and URL actions using Field and Filter Values in URL actions
• Installed Tableau Server 7.0 in Dev, QA, UAT and Prod environments.
• Installed patches on the server and documented upgrade plan from tableau 8.0 to 8.1
• Created SSIS packages in SQL Server 2008 for sources database for Tableau dashboards.
• Utilized Advance features of Tableau like Calculation fields, Parameters, Reference lines, Understanding the data fields by changing Data types and Field properties
• Building the Data viz. by creating Groups, Sets, Filters, Quick Filters, Compare multiple measures using Blended and Dual axes, Organize the Data Window by creating Hierarchies and Folders.
• Create Dynamic Sorting of Measures in the Viz. by creating Calculated fields and Parameters using Integer and Logical Functions
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports and Dashboard.
• Formatting the Dashboard by following Best Practices for Designing Views and Dashboards using Color legends, Custom tooltips, Highlighting.
• Developed story telling dashboards in Tableau Desktop and Published Dashboard, Worksheets onto Tableau Server which allowed end users access the data views
• Create a "Test" project on Server site to upload dashboards from development and have end users test.

Environment: Tableau 8.2, Microsoft SQL Server, MS Excel, Windows 7, SQL, UNIX, Linux RHEL 5.4

Confidential

Tableau/BO Developer/Data warehouse Developer

Responsibilities:

• Understand the technical requirements, developed simple reports to satisfy the user requirements
• Worked on DeskI and WebI reports in BO 6.5
• Worked on Universe Designer and designed simple Universe by defining Joins, resolving loops and cardinalities.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Resolved Loops in Universe by creating Aliases, Contexts.
• Export the universe into the repository. Initiated migrating universe and reports between environments.
• Created several Classes, Dimension Objects, Measure objects and Conditions.
• Created Web I reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc.
• Developed hierarchies to support drill down reports.
• Features such as breaks, alerter and hide blocks are used in developing reports.
• Exported Business Objects reports to Web Intelligence to be published on the Intranet and created thin client reports through Info View.
• Developed universes and DeskI reports from the Oracle 9i database.
• Written queries to retrieve data from Oracle database for multi-dimensional analysis using slice & Dice and Drill up/down functionality.
• Generated various standard reports and queries based on the existing classes/objects.
• Responsible for Creating Complex and Multi Dimensional reports using Master/Detail, Cross Tab, Slice and Dice and Sub Queries.
• Developed On - Demand Sub Reports, Parameter Reports and Drilldown Sub Reports.
• Created numerous Alerts that are executed based upon certain conditions.

Environment: Business Objects 6.5.1, Desktop Intelligence, Web Intelligence, Crystal reports 9, Oracle 9i, SQL TOAD, Windows NT/2003

Confidential

.NET developer/SQL developer

Responsibilities:

• Worked during analysis and design phase of the project. Involved in requirement gathering
• Translate the business requirements in to technical specification documents. Review the technical specs prepared by development team
• Actively participated in designing the LLD and HLD for different modules
• Designing and developing web based application in programming in C# & ASP.NET
• Actively involved in the design of the database with designing the tables and constraints
• Creating Stored Procedures in MSSQL server with SQL queries
• Creating & Reviewing Unit test cases for individual modules.
• Developing GUI using HTML, java script, CSS
• Developing Business component in C#.
• Use Visual Studio to develop the application.

Environment: .NET Framework (2.0), ASP.Net, C#, HTML/CSS, Win form, JavaScript, SQL server 2005, AJAX, ADO.NET,