SUMMARY

• Extensive experience in Data warehousing and Business Intelligence technologies across various domain.
• Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising with data origination teams.
• Maintained and Installed Tableau Server in on AWS
• Continuous monitoring of server status by automated scripts.
• Automation of extract refresh on Tableau server.
• Multiple Tableau server upgrades
• Performance test by using TABMON.
• Load test critical reports before release using TABJOLT.
• Performed Site export import using tabcmd and also using TABMIGERATE
• Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Tableau tools include Tableau Desktop versions 8/8.1/9.x/10.x, Tableau Reader, Tableau Public, and Tableau Server versions 8/8.1/9.x/10.x.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Have been working with various data sources such asOracle, Amazon Redshift SQL Server, Cloudera Hadoop, ODBCand flat file sources.
• Involved inTroubleshooting, Performance tuning of reportsand resolving issues within Tableau Server andReports.
• Designed and deployed reports with Drill Down drill up and Drop down menu option and Parameterized and Linked reports.
• Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn fast.
• Excellent communication skills in both written, oral along with ability to tell a story through data.
• Strong analytical, logical, Communication and problem solving skills and abilityto quickly adapt to new technologies by self - learning.

TECHNICAL SKILLS

Operating System: Windows 98 / 2000, Windows

XPBI/Visualization Tools: Tableau Desktop 6/7/8.x/9, Tableau Public 8.1/9.x, Tableau Reader 8.x/9.x, Tableau Server 8.x/9.x, Qlikview 11

Programming Languages: SQL, PL/SQL

RDBMS: Oracle, MS Access

Application Software: MS Excel, MS Word, MS Power Point, Microsoft Visual Studio

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Part of testing team for Tableau 10.3 Beta.
• Architecting and building Analytics Rapid Deployment Solutions
• Responsible for Client Delivery and Solution Design
• Maintained and Installed Tableau Server in all the environments on AWS.
• Added cores to the server and integrated extra nodes.
• Worked extensively with Tableau support for several product issues.
• Automated backup by integrating tabcmd with powershell.
• Keeping a continuous watch of Tableau server inbound outbound connectivity by automated scripts.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Automated backup process and storing then in S3
• Automated user management by integrating it with AD groups.
• Handled smooth Tableau server upgrades
• Performance test by using TABMON.
• Load test critical reports before release using TABJOLT.
• Performed Site export import using tabcmd and using TABMIGERATE.
• Automated email push notification using METRIC INSIGHT
• 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.
• Intergrating Row level security for Scoreboard to show up in different Confidential stores.
• Integrating username function calculation to achieve geo specific security.
• Created 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 likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft 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.
• Created report schedules, data connections, projects, groups in Tableau server.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: s: Tableau Server V9/V10.x, Tableau Desktop v9/v8/v10.x, Metric Insights, Windows Server 2012 R2

Confidential

Analytics Consultant

Responsibilities:

• Architecting and building Analytics Rapid Deployment Solutions
• Responsible for Client Delivery and Solution Design
• Involved in creating dashboards by extracting data from different sources.
• Handled smooth Tableau server upgrades
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Created calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Kerberos authentication for Hadoop env.
• 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 likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server
• Extensively used data blending in Tableau.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Used ETL especially Talend 5.5 process to Extract, Transform and Load the data into data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: s: Tableau Server v8/V9, Tableau Desktop v9/v8, Talend 5.5, Oracle

Confidential

System Analyst

Responsibilities:

• Requirement Analysis and Data-extraction from Heterogeneous data sources.
• Metadata modeling. Development of Reports and Dashboards using Tableau 8.3
• Integrating the web-based application with Tableau 8.3 server
• Created Tableau extract files for improving the performance.
• Providing insights on the Dashboards.
• Participation in Quarterly Business Reviews.
• Development of Sales, Marketing, Finance, Operations and Infrastructure Reports in Qlikview 11.0
• Propose workflows and data structures & Design mock-ups and templates
• Evaluate customer needs effectively and evidence of using good judgment.
• Worked with a dynamic and demanding environment where expectations for performance and productivity are high.
• Integrating trusted authentication services to enable single sign-on using LDAP credentials
• Load testing using Qlikview Scalability and Tableau Server Testing Environment
• Used different Mark types and Mark properties in views to provide better insights into datasets.
• Created various types of charts to provide better visualization
• 5 weeks of hyper-care sustain post production release.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Published views and dashboards in Tableau Server for auditor review.
• Documenting Technical and Functional specifications.
• Completion and certification of modules from Compliancewire.

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, Qlikview11, MS Excel, MS Access, Windows Server 2008 R2