SUMMARY

• 7 years hands - on experience as a Data Analyst, Database Designer, Reports Developer, and Data Visualization expert in Business Intelligence, including SQL Server Integration Services (SSIS)
• 6 years of experience with Tableau Desktop, Tableau Server, and Tableau Online (versions 8.x and 9.x)
• Great expreience with creating complex analysical dashboards in various industries like Healthcare, Telecommunication, Loan Servicing
• Experienced working with large scale databases utilizing various data sources such as MS-SQL Server, MySQL, Excel, Access, and Text file in multiple industries
• Assistedpowerusers in getting started consuming data from data warehouse and create their reports using self-service BI tools:PowerPivotand Tableau
• Experience in coachingAgilemethodologies with various teams and converted a few waterfall modelsintoAgilemodels
• Experience creating analytical reporting that includes Dashboards for Executive and Mid-Level shareholders utilizing SharePoint, Access, Excel and Microsoft'sPowerBI tools includingPower Query andPowerPivot.
• In-depth experience with data warehousing, data architecture, data quality processes, table structure, fact and dimension tables, logical and physical database design, data modeling, and reporting
• Developed UI pages using JavaScript and embedded Tableau Dashboard
• Proficient in creating calculated fields and business logic using parameters and formulae to achieve desired results on the visualization.
• Background includes troubleshooting and resolving issues within Tableau Server, Tableau dashboards, and data extracts
• Server Administration expertise includes, but is not limited to, performing server installation, server configuration, server upgrade, server backup, and setting up group permissions/access on Tableau Server
• Proficient in both Tableau Server and Tabadmin Commands
• Prepared Ad-hoc reports based on client requirements and developed dashboards for Key Performance Indicators (KPI)
• Trained Business Users, Junior Tableau Developers, and Data Analysts in using Tableau as a primary data analysis tool
• Self-motivated, quick-learner with the proven aptitude to deliver results in high-pressure environments
• Strong interpersonal and communication skills with the ability to maintain effective relationships with all levels of personnel

TECHNICAL SKILLS

• Tableau Desktop
• Tableau Server
• JavaScript
• MS-SQL Server
• T-SQL
• Oracle
• MySQL
• SAP
• R
• SAS
• MS Office Tools
• Crystal Reports
• Team Foundation Server
• Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential - Richardson, TX

Sr. Tableau Developer / Server Administrator

Responsibilities:

• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches to senior management as part of the Proof of Concept (POC)
• Worked with the following data sources: MySQL, Excel, and Text file
• Exposed to multiple reporting software including Birt and Google Charts
• Designed and created 10 stored procedures, 5 views, and several tables in MySQL for the specific requirements of two projects
• Trained client report developers to take over the admin role
• Developed and improved website using JavaScript and HTML
• Created more than 190 worksheets within 21 dashboards for one project
• Created context filters to limit the data seen by the worksheets in order to optimize dashboards performance and reduce report rendering time
• Frequently used features like measure, dimension, folder, hierarchy, extract, filter, action, calculation, set, group, parameter, forecasting, data blending, trend lines, etc.
• Picked appropriate visualizations by utilizing dual axis, bar chart, scatter plot, pie chart, heat map, tree map, waterfall chart, filled map to best present client requirements
• Designed global filters across different dashboards to make more interactive dashboards
• Used performance recording feature to troubleshoot the reasons of slow dashboards and improved dashboards performance significantly by optimizing data sources, filters, and extract
• Developed story telling dashboards in Tableau Desktop and published to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand information
• Collaborated with test team to verify dashboards accuracy and performed strong troubleshooting ability to find root causes of data integrity
• Conducted multiple Tableau training sessions to educate both high-end reporting analysts and low-end business users on how to use Tableau
• Worked closely with the client team and provided frequent status/execution updates
• Learned Telecommunication knowledge in a very short amount of time and was able to apply the knowledge into real situations.
• Played an important role in team coordination and management of the time estimation for the entire project

Environment: Tableau Desktop, Tableau Server, MySQL Workbench 6.3, MS Excel

Confidential - Fort Worth, TX

Sr. Tableau Developer / Server Administrator

Responsibilities:

• Developed a strong understanding of loan servicing and default reporting
• Performed data extraction, analysis, and reporting on this project
• Worked on about one hundred tables and millions of records in each table
• Analyzed user and business requirements, and attended review meetings to discuss changes in the application requirements and documents
• Create BI reporting for Executive and Mid-Level shareholders utilizing SharePoint. Access, Excel, MicrosoftPowerQuery andPowerPivotto create conventional and interactive reports and Dashboards
• Utilized multiple data sources for design, development, testing, and production (MS Excel, CSV files, and MS-SQL Server)
• Introduced and implemented Tableau Desktop and Tableau Server as a primary analysis tool and reporting system
• Added users to Tableau Server and assigned permission access based on groups
• Scheduled daily extract auto-refresh on Tableau Server
• Collaborated with business users to develop efficient ways to make tables and graphs, which were visually easy to understand while maintaining accuracy of the core information content
• Created multiple visually compelling and actionable interactive dashboards to meet specific business requirements
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Created several dashboards with special charts based on client requests which are not default options in Tableau (i.e. donut pie chart and waterfall chart)
• Frequently used calculation field, action filter, parameters, group, set, hierarchy, table calculation, dual axis, bin, etc.
• Designed and developed various charts including geographic maps, pie, bar, stacked, line, area, histogram, Gantt, etc.
• Provided Tableau training to business users and data analysts in using Tableau
• Created detailed curriculum to teach Tableau, as well as, a Tableau Center of Excellence where business users could find resources to help them succeed in using Tableau to create exemplary dashboards
• Participated in daily meetings, reviews, production support meetings
• Effectively maintained a positive and productive working relationship with internal and external teams

Environment: Tableau Desktop, Tableau Server, MS SQL Server 2012, Team Foundation Server, MS Excel

Confidential - Irving, TX

Sr. Tableau Developer / Jr. Server Administrator / SQL Server Developer

Responsibilities:

• Analyzed business requirements and developed logical design of database objects based on business rules
• Provided guidance and leadership on specific delivery methodologies for projects, such as technical requirements, design patterns, code reviews and testing procedures
• Developed SSIS packages to extract data from multiple sources, like Excel and XML systems, to enter into staging database
• Create reports inPowerBI preview portal utilizing the SSAS Tabular via Analysis connector
• Created tables, views, and stored procedures for Tableau dashboards
• Created interactive dashboards for multiple projects and provided in-depth analysis
• Worked with the report development manager and other team members on report requirements based on exiting reports in business objects, timelines, testing, and technical delivery
• Implemented data blending to blend related data from different data sources
• Created data extracts for enhanced performance and accessing data offline
• Created Tableau dashboards by using stacked bar, bar chart, line chart, scatter plot, geographical map, and Gantt chart in Show Me functionality
• Dashboards for weekly, monthly, daily reports were created by using Tableau Desktop and published to Tableau Server
• Scheduled extract refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards accurately displayed the changed data
• Executed and tested required queries to verify dashboards before publishing
• Performed the following Server Administrator duties: installation, configuration, adding users, managing licenses, scheduling tasks, embedding views on Tableau Server
• Processed large data volumes from various data sources
• Used Tabadmin Commands in creating backups and restoring backups of Tableau repository
• Improved dashboards performance by optimizing data sources and using data extracts and context filters
• Configured cache settings which improved the performance of dashboards
• Participated in meetings with data engineers, user group, as well as stakeholders and business groups

Environment: Tableau Desktop, Tableau Server, MS SQL Server 2012, Team Foundation Server

Confidential - Oxford, OH

SQL Server Developer / Report Developer

Responsibilities:

• Worked withCrystalReport for creating complicatedreportsincluding sub-reports, parameter basedreports, graphicalreports, formula basedreports, drillingreports, analysisreports, datareports
• Created several automated reports in Crystal Reports that reduced maintenance time
• Hands-on experience working with multiple reporting tools (Crystal Report, Tableau, and Excel)
• Developed SSIS packages to transform data extensively between MS-SQL Server and other source systems
• Created views and stored procedures by joining tables in MS-SQL Server ensure accurate information was pulled to create reports
• Managed database in MS-SQL Server to provide the national fraternity with a stronger process to identify changes
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Created multiple dashboards using Tableau Desktop
• Used filters, quick filters, table calculations, parameters in Tableau reports
• Created context filters to improve dashboards performance
• Created Table of Contents (TOC) common navigation page which had links to various reports
• Worked closely with business users to create reports/dashboards on different reporting tools

Environment: Crystal Reports, MS Excel, Tableau Desktop, Tableau Server, MS SQL Server 2012