PROFESSIONAL SUMMARY:

• 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 3+ years of extensive experience working with Business Intelligence data visualization tools with specialization on Tableau.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7 and Tableau 8, 9.0.
• Experienced in Agile and Scrum methodologies.
• Good understanding of Tableau in enterprise environment, Tableau Desktop, Tableau Reader and Tableau Server.
• Strong knowledge in various reporting objects like Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated fields, Sets, Groups, Parameters etc.
• Strong expertise on delivering Tableau based Dashboards using Tableau 9.
• Experience in migrating all the reports, dashboards from Tableau 8.0 to Tableau 9.0.
• Experienced Working with different enterprise data sources like Teradata, SQL, Oracle.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Effective Ability to create Custom Tableau reports using SQL and advanced Tableau mapping.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Expertise in Data Analysis, Data Extraction, Data Marts. Perform Grant, Revoke table access to Database Analysts, Business Analyst, Operational Analysts and Project Manager
• Experience in TABCMD & TABADMIN, Email alerts, scheduling, data backup, SAML and drivers setup activities.
• Have good experience on System Administration in Windows Environments
• Highly skilled in Tableau Desktop for data visualization, using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, Heat Map and Density Chart.
• Expertise in dealing with Relational Database Management Systems Including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Worked extensively on multiple data connections using blending, worked on Data Extracts and managing queries.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Experienced in handling on - going support & enhancements to reports and dashboards.
• Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance and Object Oriented Design (UML). Experience in Database modeling using data modelling tool.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS:

Data Modeling Tools: Star Schema Modeling, Snow Flake Modeling

Data Warehousing ETL Tools: Informatica Power Center 8 .X,7.X, Talend 4.2.x/5.1.2, Data Cleaner 2.2

Databases: MS SQL Server 2012/2008R 2/2008/2005/2000/7.0, SYBASE, MYSQL, ORACLE, Hadoop

Database Tools: Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Crystal Reports 9.0 / 10

Languages: PL/SQL, SQL, Java, C

Web Tools: HTML, DHTML, XML, JAVA SCRIPT

Operating Systems: Linux, Microsoft 2003/2000/ NT/98/95

Others: MS Word, Excel, VISIO 2007

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr Tableau Admin/Developer

Responsibilities:

• Involved in analyzing the user requirements and transform them into Tableau Dashboards and Reports.
• Effectively used data blending feature in tableau to connect different databases like Oracle, MS SQL Server.
• Administrating tableau server infrastructure (DEV/QA and PROD),
• Developed tableau server audit reports to view and analyze tableau server insights (health, tableau server usage, tableau server data extract failures etc.)
• Tableau server status reporting and data extract management.
• Worked with Stakeholders and business users for mentoring and training.
• Creating and maintaining new data extracts as per the new requirements,
• Resolving ODBC driver issues with the data extracts,
• Tableau desktop and server tickets resolution (primary contact for support)
• Resolving tableau dashboards development and performance issues
• Developed Tableau data visualization using Pareto’s, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Developed effective and interactive Dashboards using Parameters and Actions
• Developed donut charts for analyzing sales planning data.
• Created different KPI’s using Table calculations and calculated key figures(Manipulating strings, arithmetic calculations, aggregation options and Logical functions)
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
• Expertise in working with data building Groups, Hierarchies and sets.
• Mastered in different Formatting techniques, using Annotations and Mark labels.
• Defined appropriate Hierarchies, measure groups and KPIs & deployed cubes.
• Created different reports like tabular, matrix, ad-hoc, drill down and drill through reports.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Using the Shiny UI with lower level code of HTML tags and JavaScript.
• Also involved in administration tasks such as creating and managing Sites, setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.

Environment: Tableau Desktop 8/9, Tableau Server 8/9, Tableau Public, Oracle 11g, Microsoft SQL Server 2012, Microsoft Visio, Shiny, Windows 7/8/10.

Confidential, Fremont, CA

Sr. Tableau Admin/Developer

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Extensive work on tabcmd utility for the custom scheduling and tableau server administration.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Tableau dashboards embedding into Sales force for the continuous data experience for the users,
• Effectively used tabcmd for the maintenance of server. Scheduled tasks, imported user list, restarted server and performed various other roles through tabcmd
• Connecting and extraction to different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on the tableau server machines.
• Implemented row level security for the tableau dashboards.
• Integrated Tableau dashboards into internal web portal using Java Script API.
• Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.
• Migrated all the reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0.

Environment: Tableau Desktop 8.0/ 7.0, Oracle10g/9i, Crystal Reports, Spot fire, Shiny, SQL Server 2008/2012.

Confidential, NY

Tableau - BI Developer

Responsibilities:

• Interacted and worked with ETL team for improving performance on data from multiple data sources.
• Setting up default file directory to host the Tableau software and data files appropriately.
• Fine-tuning the Tableau server to be at its best performance.
• Provide regular server backup and housekeeping work and Oversee the Tableau data import/export.
• Import or export various data files (excel, web data, text file. Dbase/ETL connection etc.) Tableau to maintain the data source efficiently.
• Writing scripts or set up configuration to automate the data import process into Tableau.
• Experience in basic Tableau data options to facilitate the best route and detect error.
• Proficient in creating Tableau reports and views to combine them in a dashboard to share with other developers and viewers.
• 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 with Sorting, Building Groups and using in visualizations.
• Worked on Global, local and Context filters.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Configuration of Clarity portlets to meet the business reporting needs
• Driving the definition, establishment and acceptance of best practices and common processes utilizing CA Clarity
• Experience with Tableau for Data Acquisition and data visualizations
• Used parameters to make dashboards dynamic.
• Worked extensively with Date, String and Logical Functions.
• Created Inventory trends, sales integration and forecast accuracy related dashboards
• Worked with ETL team for performance improvement using custom SQLs.

Environment: Tableau 7.0, Informatica 9.1, SQL Server 2012, Teradata’s, Windows

Confidential, Cranston, R

Tableau Developer

Responsibilities:

• Responsible for Tableau Environment, Security, Architecture setup.
• Interacted with business users in gathering, analyzing and documenting the business requirements and translate them into technical specifications.
• Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.
• Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
• Created technical specification documents related to Tableau design and architecture.
• Created several Tableau data extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own workbooks.
• Created various highly interactive dashboards and data visualizations reports for Ad Sales and Program Finance departments.
• Developed multiple reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Created Server Monitoring workbook views and a custom workbook to see 'My activity' on Tableau Server using Tableau Server Repository Database (Postgresql).
• Actively involved in creating a custom portal design hosting Tableau workbooks using JavaScript API.
• Worked with end users in creating complex dashboards in an iterative process.
• Created several automated scripts to backup, restore and auto sync Windows AD users.
• Extensively used Tabcmd and Tabadmin for various Tableau server maintenance activities.
• Performed tuning of tableau workbooks and extracts to make them functional with large sets of data.
• Conducted training sessions for Tableau Power users to use it as a Self-service BI tool

Environment: Tableau 7x, Tableau server 7x, Crystal Reports, Web Intelligence 4.1/4.0/3.1, MS Excel, SQL Server, HANA DB, shiny, JavaScript API.

Confidential

SQL Developer

Responsibilities:

• Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management.
• Work with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
• Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit
• Database for investigating User activity and narrowing down issues.
• Assist Team in Optimizing system architecture.
• Monitoring Scheduling Reports
• Designed and implemented Adhoc Reports, Extracting Data from an SQL Server database.

Environment: Business Objects 3.1, Universe Designer, Web Intelligence. Oracle 10g

Confidential

Jr. SQL Analyst

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Created ad-hoc reports for the upper level management using Stored Procedures and MS SQL Server 2005 Reporting Services (SSRS) following the business requirements.
• Created reports by dragging data from cube and wrote mdx scripts.
• Created reports by extracting data from cube.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Provide database coding to support business applications using Sybase T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, Enterprise manager, VBS.