SUMMARY

• Over 7 years of experience in IT Software design, development, implementing, testing, reporting and production support.
• Experience analyzing large data and creating visually compelling and actionable interactive reports and Dashboards using Tableau
• Experience in Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle/SqlServer), MS Access and client/server applications.
• In-depth knowledge on Tableau Desktop, Tableau Viewer and Tableau Server.
• End to end experience in designing and deploying data visualizations using Tableau
• Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations inTableau.
• Extensive experience in creating Calculations (Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) usingTableauDesktop.
• Experience in publishing Dashboards toTableauServer
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau Server and Reports
• Strong experience inDatawarehouse concepts, ETL.
• Experience in creating Transformations and Mappings usingInformaticaDesigner and processing tasks using Workflow Manager to move data from multiple sources into targets
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers
• Good understanding of Oracle data dictionary and normalization techniques.
• Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL*Loader.
• Extensively worked with database tools like Sql Developer, Toad.
• Exposure to Amazon Web services cloud platform to use data of different types.
• Familiar with programming language such as C and JAVA.
• Extensively worked with large databases in Production environments, UAT and migrations.
• Prepared technical documents for different components during the implementation
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

Reporting Tools: Tableau 7.x/8.x, Excel, SSRS

Databases: ORACLE 10g/11g, MySql, DB2, Sql server.

Database Access: TOAD 9.5, SQL Developer, SQL*Plus, ODBC, JDBC, OLEDB.

ETL Tool: Informatica Power center8.6.1

Languages: C, C++, Java, Pl/Sql

Operating Systems: UNIX, Windows 95/98/2000/NT/XP,DOS

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer

Responsibilities:

• Created reports to users in Tableau by connecting various data sources (MS SQL Server, Oracle, MS Excel, Flat files, CSV).
• Generated adhoc Tableau reports on based on user requirements.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements
• Gathering/ analysis, Design, Development, Testing and Production rollover.
• Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
• Experience in Marks, Publisher, Security concepts, creating Worksheets and Dashboard using Tableau.
• Combined multiple data sources by joining tables using Data Blending.
• Worked on multiple Complex tables through custom SQL.
• Generated several drill down and drill up reports.
• Generated Tableau reports with Trend lines, reference lines and bands.
• Worked on groups, sets and different calculation functions including Table calculations.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.various data and queries to execute it.
• Used the Amazon Web Services platform to handle v
• Created dashboards for the clients to measure cost saving.
• Generated dashboard with security by using user filters.
• Performed end-to-end Data Analysis and ensure the data quality gaps are identified.
• Designed and developed Business Intelligence end to end solutions using Tableau.
• Published Workbooks by creating user filters and security, so intended teams can view it.
• Developed tableau dashboards with combination charts for clear understanding.
• Build complex calculations using advanced functions (ATTR, DATEDIFF, STR, IFs, nested IFs, OR, NOT, AND, SUMIF, COUNTIF, LOOKUPs and QUICK TABLE calculations).
• Created visualizations inTableauusing Excel data extract source, wrote Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development,Tableaureports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau 7.x/8.x, Sql Server, Oracle, MS Access, Microsoft Office Suite (Word, PowerPoint, Excel).

Confidential, Richmond, VA

Tableau Developer

Responsibilities:

• Involved in analyzing the user requirements and transform them into Tableau Dashboards and Reports.
• Involved in designing and creating Dimensional Data model (Star schema) for Dodge Global Network application and ENR Survey reports.
• Worked with CIO of the organization in gathering the requirements to create Project/User Usage
• Executive Dashboards, International DR's Usage reports for Sales Executives.
• Developed complex data visualization reports and dashboards related to User Activities
• Trends on DGN application and Dodge Market Share, Build Share and Spec Share using multiple large volume data sources.
• Created various Data migration monitoring and Mark Logic feed reports to help customer support teams.
• Created Project planning and Defect tracking reports which help Management to keep track of budgets and Project releases.
• Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, Maps etc.
• Conducted Training sessions for Tableau Power users and created the documents for end-user support.
• Writing SQL queries for data validation of the reports and dashboards as necessary.
• Involved in Performance tuning the reports and dashboards for optimization.
• Exported the universes to the Repository for making resources available to the users.
• Experience in configuring reports from different data sources using data blending.
• Worked on creating multiple data connections and created run book designs.
• Experience in Requirement Analysis, Gap Analysis, Change Management and Impact Analysis, Capacity.

Environment: Oracle9i/10G, Pl/SQL, SQL, SQL Developer, Unix (Putty), Tableau 7.x

Confidential, Painesville, Ohio

Tableau Consultant

Responsibilities:

• Designed competent pl/sql programs using pl/sql Collections, Records, Object types.
• Attended meetings for status updates
• Reviewed Test Strategy, Test Plan documents and Test scenarios
• Developed Test Cases and Test scripts
• Involved and managed defect management process. scenarios and test steps Quality Center
• Created and executed test cases for functional testing.
• Executed tests, analyzing and interpreting the results, to identify variances and possible defects
• Interface with development teams to clarify issues and resolve any conflicts.
• Used Automation for regression testing
• Gantt charts using show me functionality.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Defined best practices for Tableau report development.
• Worked on SQL Tuning and Optimization of the reports.

Environment: Oracle 9i/10G, PL/SQL, SQL, SQL Developer, Import Wizard, Microsoft Excel 2007, Tableau. UNIX (Putty).

Confidential

Data Analyst

Responsibilities:

• Created and managed tables in Teradata. Wrote SQL queries and validated data in tables for reporting. Enhanced the performance of queries.
• Wrote Proc SQL queries and SAS commands to fetch and analyses data from excel files and pushed it in Teradata after cleansing operations.
• Gathered requirements, objectives and features for reports. Led a small team to create rich graphic dashboard.
• Created and maintained dashboards using calculations, parameters in Tableau 8.2 for financing and Home loans.
• Extensive experience in using various reporting objects like facts, attributes, hierarchies, filters, parameters and calculated fields etc.
• Created Dashboard reports for the key performance indicators for senior managers and business units.
• Designed & deployed rich graphic visualization with drill down, drop down menu option & parameterized using Tableau.
• Wrote UNIX shell scripts and used putty to automate the execution of SQL scripts, manage them on server.
• Used Ultra edit to review the scripts of group and modify the already existing scripts as per requirements in bulk.

Confidential

Senior Programmer and Business Intelligence Analyst

Responsibilities:

• Interacted with the clients, garnered requirements, analyzed complexities, acuminated them to solution.
• Worked with sales management and marketing analysis team.
• Used Hoovers and OneSource to create profiles of potential clients (companies) and marketing & business analysis documents.
• Created requirement documents, technical design documents and knowledge sharing documents.
• Involved in complete Software Development Life Cycle including system study, interaction with users & management, designing, coding, testing and deployment of the system.
• Developed chart reports, parameterized reports, drill down report, drill through report, matrix reports, master detail reports.
• Accountable for data quality & analysis using & excel data parsing using macros, lookup functions and pivot tables.
• Developed SQL server 2008 R2 stored procedures, data mappings for data importing, exporting and parsing etc.
• Extracted, masked, cleaned and validated. Wrote MDX queries.
• Used Microsoft SharePoint to create and design pages for SSRS reports for specific requirements given by clients.
• Sourced data from various types of relational databases, flat files, excel files.
• Experienced in working on dimensional data warehouse, dimensions, facts, slowly changing dimensions.
• Shared knowledge transfer to new joiners in project, support team and testing team.
• Created blue prints for development team. Gave presentations on MSBI as a part of people development in company.
• Worked in complete SDLC for web application in .net. Followed 3 layer architecture. Ensured quality of code.
• Done Assembly testing/ Product testing and prepared test scripts. Handled production support and bug fixing.