PROFESSIONAL SUMMARY:

• 6+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau.
• IT Experience in Banking, Financial, Healthcare, Sales and Telecommunications domains.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7 and Tableau 8, 9.0, 10.0.
• Experienced in Agile and Scrum methodologies.
• Good understanding of Tableau in anenterprise environment, Tableau Desktop, Tableau Reader and Tableau Server.
• Monitor server activity/usage statistics to identify possible performance issues/enhancements.
• Administered user, user groups and scheduled instances for reports in Tableau.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• Extensively used Tabadmin and Tabcmd commands in creating backups and Restoring backups of Tableau repository.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure the views and dashboards were displaying the changed data accurately.
• Performed scheduling and authentication while publishing workbooks for extracts to be refreshed automatically varying with time.
• Published data sources to Tableau server to effectively manage and store data sources.
• 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 10.0.
• Experience in migrating all the reports, dashboards from Tableau 8.0 to Tableau 10.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, usingCross 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 lifecycle) involving Requirement Analysis, Software design, development, implementation, testing, maintenance, and Object Oriented Design (UML). Experience in Database modeling using data modeling tool.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements
• Quick learner and good performer both in theteam and independent job environments.

TECHNICAL PROFICIENCY:

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

BI Tools: Tableau, Qlikview, Business objects, Confidential, Micro Strategy, Spotfire

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

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, Powerpoint,VISIO 2007

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk, Virginia

Sr Tableau Developer/ Admin

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.).
• Created ETL meta-data reports using Confidential, reports including execution times for the SSIS packages and failure reports with error description.
• 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.
• Provide Tableau support to users.
• Involved into installations and system setup and configurations.
• Excellent Knowledge in analyzing Datawarehouse by building cubes using SQL Server Analysis Services (SSAS)
• 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, Crosstabs, Histograms etc.
• Developed effective and interactive Dashboards using Parameters and Actions.
• Developed donut charts for analyzing sales planning data.
• Responsible for debugging the project monitored on JIRA (Agile).
• 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.
• Also involved in administrative 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: MS SQL Server 2014/2016, SSIS, Confidential, SSAS,Tableau Desktop 8/9/10, Tableau Server 8/9/10, Tableau Public, Spotfire, Oracle 11g, Sharepoint, Python, Microsoft SQL Server 2012, Microsoft Visio, Windows 7/8/10, MongoDB, Teradata

Confidential, Dallas, TX

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 TableauServer administration.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on abusiness 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 Salesforce for the continuous data experience for the users.
• Administered user, user groups and scheduled instances for reports in Tableau.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability
• Effectively used tabcmd for the maintenance of theserver. 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 JavaScript 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 10.0.

Environment: Tableau Desktop 8.0/9.0/10.0, R Progamming, Python, Microsoft office, Microsoft Visio, Oracle10g/9i, Crystal Reports,Spot fire, SQL Server 2008/2012, Spotfire,Teradata and MongoDB.

Confidential, Fremont, CA

Tableau Developer/ Admin

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 theerror.
• 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 stakeholders, gathering requirements andmanaging the delivery, covering the entire Tableau development life cycle.
• 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/8.0/9.0, Informatica 9.1, SQL Server 2012, Teradata,Netezza, crystal reports Windows, Managemrnt Studio, T-sql, and MongoDB.

Confidential

SQL Developer

Responsibilities:

• Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management
• 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
• 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 databases 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 ( Confidential ) following the business requirements.
• Created reports by dragging data from thecube and wrote MDX scripts.
• Created reports by extracting data from thecube.
• 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.
• 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.

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