SUMMARY

• 5+ years of experience in IT Industry. Expertise in the field of Business Intelligence (BI) Analytics, Reporting & Dashboard development using Tableau.
• Experience in gathering Business requirements, Analysis, Design, Implementation and documentation of various functionalities of Data marts and Business Intelligence.
• Hands on experience in following the SDLC methodologies like Waterfall model and Agile model.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameters, calculations and relationships.
• Skilled inTableau Desktop for Data visualization, Reporting and Analysis;
• Experienced working in all the phases of the projects including analyzing, requirement gathering, QA and Deployment.
• Worked extensively on joining tables, multiple data connections using data blending concept, worked on Data Extracts and managing queries.
• Strong Experience in Tableau Administration such as creating extracts, scheduling workbooks, granting access and creating user filters.
• Expertise in Trouble Shooting, Performance tuning of reports and resolving issues in Tableau Server and Reports.
• Strong Expertise in Tableau server commands like synchronization and
• Experienced in writing complex SQL Queries involving various tables using SQL joins and writing Sub Queries. Experienced in writing complex - SQL Stored Procedures and constructingTables, Triggers, user functions, Views, Indexes, Relational data models and data integrity.
• Expertise in designing and creating various analytical Tableau Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experienced in creating different visualization like Cross Map, Scatter Plots, Geographic Map, Gantt charts and Bar Charts, Page Trails and Density Chart.
• Experience in developing Visualizations using various charts like Stacked Bar/Pie, Line/Area, Donut, Dual-axes charts, Geo-Maps, Bubble, Scatter and Heat Maps.
• Proficient in using ETL tools and performing data modeling using Informatica, SISS and Alteryx. Data
• Expert in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating
• Established Best Practices for Enterprise Tableau Environment and application intake and Development processes.
• Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Good independent/team working skills and experiences, excellent communication skills and Self-motivated team player with strong problem-solving skills and thirst to learn the advanced concepts with in the field of interest.

TECHNICAL SKILLS

Reporting Tools: Tableau Desktop, Tableau Server, Tableau Online, Tableau Public, Tableau 10.5/10.4/10.3/10.2/10.1/10.0/9.3/9.1, MS Excel, SSRS

Relational Databases: SQL Server, XML, MySQL

ETL: SSIS

Languages: SQL, PL/SQL, T-SQL, Python

Operating System: Windows

Computer Applications: MS-Word, MS-Excel, MS-Access, MS- Power Point.

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Tableau Developer

Responsibilities:

• Roles and responsibilities include developing, enhancing, re-engineering, maintaining and supporting Tableau applications.
• Involved in full project lifecycle of SDLC and coordinated with all project teams
• Involved in reviewing business requirements and analyzing data sources form Excel/SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop 10.5.
• Actively participated in Business Intelligence standardization to create database layers with user friendly views in SQL Server dat can be used for development of various Tableaureports/ dashboards.
• Designed and developed a business intelligence data visualization dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Used LOD (Level of Details) functions like Fixed, Include and Exclude in Tableau.
• Created Filled maps, actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Experience in creating and scheduling Tableau data extracts for auto refresh.Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Utilized advance features of Tableausoftware 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) for various analytical reports and dashboards.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards. Make use of filters and making them local and global accordingly.
• Generated stories for Finance team and improved the performance by reducing analysis time.
• Resolved performance issues and worked for better scalability and availability of Tableau desktop.

Environment: Tableau(Desktop, Server) 10.5, SQL Server andMicrosoft Office, MS VISO, Profiler, Microsoft Office (Word, Access, Excel, Outlook).

Confidential, Baltimore, MD

Data Analyst /Tableau Developer

Responsibilities:

• Translated business requirements into technical requirements Performed data analysis and data profiling using SQL on various sources systems
• Stretched Tableau limits to create unconventional Tableau charts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Heat maps and logical calculations to create groups.
• Responsible to Deliver Proof of Concepts, understanding customer business requirement.
• Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments.
• Developed TEMPeffective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technol.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Understanding of relational database structures and ability to create SQL views.
• Designing, developing, maintaining and supporting multiple Tableau dashboards and apps using Tableau 10x - 19.1
• Maintained workflows and integrated connectivity to Tableau.
• Transitioned Salesforce dashboards over to Tableau platform and recreated them from scratch.
• Created customized Tableau Dashboards, integrating Custom SQL and performing data blending in reports.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Collaborated with developers and performance engineers to enhance support ability and identify performance bottlenecks.
• Maintained existing applications and designed and delivered new applications.
• Built databases and table structures following architecture methodology for web applications.

Environment: Tableau, SQL, charts, Agile scrum

Confidential, Cincinnati, OH

Tableau Developer

Responsibilities:

• Utilized Tableau 10 new features such as cross data base join and cross data base filter.
• Managed Tableau server subscription and customized view for business users to get their data the way they want at the time they need.
• Make adjustment to existing dashboard, including performance tuning and add more information or filters to the dashboard
• Lead the Tableau server configuration and installation. Upgrade and trouble shoot the upgrade of Tableau server, write a step by step instruction for IT department to perform the upgrade.
• Worked closely with Tableau server log files, trouble shoot the Tableau server and Tableau server monitoring.
• Deep customization of Tableau server, including the logo, color of the header and added ‘watermark’ in Tableau server.
• Worked a great extent with the design and development of Tableau visualizations which includes preparing dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks based on specific requirements.
• Implement user filters in Tableau dashboard and worksheets or the data source to restrict data access at the data row level.
• Created batch scripts forTableauserver backup and cleanup atomizationon daily basis and save the backups in particular folder for emergency usage.
• MaintainingTableaudata source connections and scheduled refreshes and updates.
• Extensively usedTabadminandTabcmdcommands in configuring Tableau server and created batch file for sending email to unlicensed user a pdf format report.
• Involved in end to end implementation and enhancements on trading behavior data starting from requirement gathering and dashboards development in Tableau Desktop.
• Created numerous dashboards in Tableau Desktop based on the data collected from financial reporting System by importing and blending data from MS Excel and CSV files along with MS SQL Server Databases.
• Studied and analyzed similar applications and brainstormed with business team to gather TEMPeffective requirements for the system along with dashboard development.
• Make sure the all the data being used in the reports are correct and make sure the report contain sufficient and efficient information for the end users.
• Worked closely with SQL server and Oracle, creating new view to compose the data needed for create Tableau reports.

Environment: Tableau Desktop 10.1/9.2, Tableau Server 10.1/9.2, Tabcmd, MS SQL Server 2014, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2010, Erwin r8, C#.