SUMMARY:

• About 4 years of IT industry experience in Business Intelligence technologies along with data visualization using Tableau.
• Experience include analysis, modeling, design, and development of Tableau reports and dashboards for analysis and reporting applications.
• Hands on experience on Tableau Desktop versions 10, Tableau Reader and Tableau Server.
• Extensive knowledge in various reporting objects like Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of dashboard reports for the key performance indicators for the top management.
• Experience in creating different visualizations using bars, lines and Pies, Maps, Scattered plots, Gantts, bubbles, Histograms, Bullets, Heat maps and Highlight tables,
• Created Reports with complex formulas and to query the database for Business Intelligence.
• Expertise in Pareto charting, advanced calculations, work with demographical and geographical fields.
• Excellent analytical and problem solving using Qlikview, tableau, crystal reports and SQL debugging Skills.
• Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports
• Very proficient in working with large Databases in oracle. SQL Server and Big Data.
• Experience in developing rich interactive reports and dashboards integrating various reporting components from multiple sources.
• Team player and self - starter with good communication skills and ability to work independently and as a part of the team.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical skills

TECHNICAL SKILLS:

DBW Tools: Tableau Desktop 10.1-10.4, Tableau Server, Tableau Online.

Other Reporting Tools: Crystal Reports, Qlikview.

Environment: windows 10, Windows 2008, windows 2003, XP, Linux.

Database: Oracle 9i/11g, SQL Server 2008/2012/2015, Alteryx.

Language: C# .NET, HTML, CSS, SQL, JavaScript.

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, MN

Tableau Analyst/Developer

Roles and Responsibilities:

• Involve in reviewing business requirements and analyzing data sources form Database for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Create dashboards for analyzing data using Tableau 10.0.
• Develop scripts to load data into tableau and work with multiple data connections including Hadoop/hive and by data blending.
• Develop case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting.
• Create views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Create Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blend data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combine views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Create Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets
• Create custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• Publish the reports and scheduled the reports in different formats Email, Public, folder
• Schedule the reports on capacity levels of different servers to run on daily/weekly monthly basis and email the results to the business users in the required format.
• Create workbook Permissions, Ownerships and User filters.

Environment: MS SQL Server 2008/2012/2015, SSMS, Tableau Reporting tool admin/developer, Tableau Desktop 10, Hadoop/Hive, JavaScript, HTML.

Tableau Developer

Roles and Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-Down menu option and Parameters using Tableau.
• Converted existing BO reports to tableau dashboards.
• Used Alteryx to blend data and to do advanced analytics.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Created different KPI using calculated key figures and parameters.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: Visual Studio 2015, SSIS, SSMS Tableau 10.3/10.4, T-SQL, SQL Server 2015

Data Strategist

Roles and Responsibilities:

• Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
• Designed and developed standard reports, cross-tab reports.
• Prepared test cases for Unit testing created various test cases to validate the data, performance and look feel of the reports.
• Involved in developing finances KPI reporting
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Used Script task for Data Flow and Error Handling in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages,
• Designed and developed monthly, quarterly and yearly reports.
• Used SQL Server Profiler to trace the slow running queries and the server activity.

Environment: Visual Studio 2015, SSIS, SSMS Tableau 10.3/10.4, T-SQL, SQL Server 2015