SUMMARY

• 7 Years Hands on Experience as Data Analyst, Database Designer, Reports Developer, and Data Visualization Expert in Business Intelligence
• 7 Years of Experience with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Service (SSRS)
• 6 Years of Experience with Tableau Desktop, Tableau Server, and Tableau Online, versions ranging from Tableau 8.x and Tableau 9.x
• Great experience with large scale databases across different industries
• Great experience with data warehousing, data architecture, data quality processes, table structure, fact and dimension tables, logical and physical database design, data modeling, and reporting
• Great experience with troubleshooting and resolving issues within Tableau Server, Tableau dashboards, and data extracts
• Extensive experience as Server Administrator: server installation, server configuration, server upgrade, server backup, and set up different group permissions on Tableau Server
• Proficient in both Tableau Server interface and Tabadmin Commands
• Experience working various data sources: MS - SQL Server, MySQL, Excel, Access, and Text file
• Excellent experience and performance with Ad-hoc reports based on the client requirements and development of dashboards for the Key Performance Indicators (KPI)
• Have trained business users, junior Tableau developers, and data analysts in using Tableau as primary data analysis tool
• Quick learner person with highly self-motivation and able to work under pressure
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationship with all levels of personnel

TECHNICAL SKILLS

• Tableau Desktop
• Tableau Server
• 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 the senior management as part of the PoC
• Designed and Created 10 stored procedures, 5 views, and serveral tables in MySQL for the specific requirements of 2 projects
• Performed as Server Administrator, I am responsible for:
• Maintained 3 Tableau Servers
• Installed and configured Tableau Server 9.2
• Upgraded Tableau Server from 9.2 to 9.3 and created server backup
• Changed Tableau Server logo to client logo
• Managed user permissions
• Provided end user support 24/7
• Trained client report developers to take over the admin role
• Created context filters to limit the data seen by the worksheets in order to optimize dashboards performance and reduce report rendering time
• Widely used various features like measure, dimension, folder, hierarchy, extract, filter, action, calculation, set, group, parameter, forecasting, data blending, trend lines, and so on
• 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 imporved dashboards performance significantly by optimizing data sources, filters, and extracts
• Developed story telling dashboards in Tableau Desktop and published them onto Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
• Cooprerated with test team to verify dashboards accuracy and performed strong troubleshooting ability to find root causes
• Conducted multiple Tableau Training Sessions to train both high end reporting analysts and low end business users about how to use Tableau
• Worked closely with the client team with excellent communication skills and outstanding execution
• 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 coordination with the entire team and managing the time estimation for the entire project

Confidential — Fort Worth, TX

Sr. Tableau Developer / Server Administrator

Responsibilities:

• Developed strong understanding of loan servicing and default reporting
• Performed data extraction, analysis, and reporting for over a hundred of tables and millions of records in each table
• Analyzed user and business requirements, attended periodic meetings for changes in application requirements and documents
• Used multiple data sources, MS Excel, CSV files, and MS-SQL Server, for design, development, testing, and production
• Introduced and implemented Tableau Desktop and Tableau Server as a primary analysis tool and reporting system
• Added users to Tableau Server and gave them different permissions 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 are 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 serveral dashboards with special charts based on client requests which are not default options in Tableau. For example: donut pie chart and waterfall chart
• Widely used calculation field, action filter, parameters, group, set, hierarchy, table calculation, dual axis, bin
• Designed and developed by using various chart types like: geographic map, pie charts, bar chart, stacked bar, line chart, area chart, histogram chart, gantt chart, and etc
• Provided Tableau Training Sessions to business users and data analysts in using Tableau
• Created extensive 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
• Efficiently maintain positive and productive working relationships with internal and external team

Confidential — Irving, TX

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

Responsibilities:

• Analysis of business requirements and developing logical design of database objects based on business rules
• Provide 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 the data from multiple sources like Excel and XML systems to put in staging database
• Created tables, views, and stored procedures for Tableau dashboards need
• Created interacitve 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 better 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
• Worked in Tableau environment to create dashboards for weekly, monthly, daily reports by using Tableau Desktop and publish them 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 displayed the changed data accurately
• Executed and tested required queries to verfiry dashboards before publishing
• Performed Server Administrator duties that includes: installation, configuration, adding users, managing licenses, scheduling tasks, embedding views on Tableau Server
• Dealt with 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

Confidential — Oxford, OH

SQL Server Developer / Report Developer

Responsibilities:

• Created reports in Crystal Report to ensure excellence in efficency of information updates
• Created serveral automatically-updating version of reports in Crystal Reports that require less maintenance time
• Hands on Experience in multiple different reporting tools. For example: Crystal Report, Tableau, and MS Excel
• Developed SSIS packages to transform data extensively between MS-SQL Server and other source systems
• Created views and stored procedures by joining different tables in MS-SQL Server in order to get accurate information 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 mutiple dashboards by 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