SUMMARY:

• 7+ years of Experience in IT covering complete SDLC in various positions and responsibilities start from Requirement gathering, Analysis, Design and Development of Business Intelligence solutions
• 5 years' experience in Tableau Dashboards in Design, Development & Testing, and Present & Demonstrate the solutions and KPIs to all stake holders
• Over 2 years of experience in Manual & Automation Testing including Web Applications, ETL and Data integration
• Very good knowledge on Data Warehousing Concepts, Star schema, Snowflake schema, Normalization, Denormalization, Relational and Non - Relational data structures, Multi-dimensional structure (cubes in the form of Dimensions and Facts or Measures)
• Experience in gathering Requirements, Analysis, Design, Development, Testing and Production Support of rich Interactive Dashboards and Workbooks using Tableau Desktop
• Extensively created reports, dashboards, advanced chart types, visualizations and complex calculations to manipulate the data created/used metrics, attributes, filters
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of Dashboard Action, Data Source and Context Filters according to the end user requirement
• Expert in Preparing dashboards using calculated (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) fields and Formatting (Annotations, Layout Containers, Mark Labels, Mark Card Changes, Rich Text Formatting, Shared Encoding parameters, calculations, groups, sets and hierarchies in Tableau
• Good expertise in Debugging, monitoring and troubleshooting issues and document, share & support the team.
• Implemented advanced geographic mapping techniques and use custom images and geocoding to build spatial visualizations of non-geographic data.
• Transformed Tableau into a managed service offering for consumption across Corporate and Managerial level.
• Apply design patterns to develop BI solutions for delivery on web and mobile devices such as tablets and Smartphones
• Worked on several projects in parallel and Build the Dashboards in Agile Approach.
• Experience with R Integration in Tableau to identify patterns, build practical models for a deep statistical analysis and accomplish forecasting of those statistical models
• Extensively used SQLs for data analysis and Data validations
• Excellent communication skills, with strong analytical, troubleshooting and problem-solving abilities

TECHNICAL SKILLS:

BI Reporting Tools: Tableau 8.x, 9.x, 10.x (Desktop/Server), Power BI, MicroStrategy, SSRS

Databases: SQL Server 2005/2010/2008 R2/2014, Oracle 10g/11g, DB2, Teradata, Microsoft Access

Database tools: SQL Developer, TOAD, Teradata SQL Assistant, SQL Server Management Studio

Applications: Microsoft Office Suite (Word, Excel, Visio, PowerPoint

HTML, SQL, PL/SQL, T: SQL, XML, Shell Scripting

Operating Systems: Windows Server 2003, Windows XP, Windows 2008, Windows 7, Windows 8, Linux

Data Modeling: Logical/Physical/Dimensional, Star/Snowflake Schema, OLAP, SDLC (Waterfall, Agile, Iterative)

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

BI/Tableau Developer

Responsibilities:

• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, participated in the design Team and user requirement gathering meetings.
• Designed and developed a BI dashboard Visualizations and using Tableau Desktop, allowing executive management to view past, current and forecast sales data
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Generated Tableau combination charts using Tableau visualization software.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Created Technical Design Document from the functional specification documents.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once
• Identify new metrics and enhance the existing KPI's. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Analyzing the data using Statistical features in Tableau to develop trend analysis.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server

Environment: Tableau Desktop 8, Excel 2013, Outlook 2013, VMS Systems, Microsoft Office Suite (Word, Excel, Power Point, Visio).

Confidential, New York, NY

BI/Tableau Developer

Responsibilities:

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stakeholders, gathering requirements and managing the delivery. Analysis, Development and Customization of the Application and implementing requirements for the project.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Developer.
• Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Created complex data views manually using multiple measures also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats
• Used URLs, Hyperlinks, Filters for developing Complex dashboards.
• Worked creating Aggregations, calculated Fields, Table calculations, window function, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Generate KPI for customer satisfaction survey results.
• Maintained Test log and Wrote Test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in the User Acceptance Warranty Testing. Involved in doing security and negative testing of the application.

Environment: Tableau Desktop, Tableau server, MS-Excel, Oracle 11g, Hadoop Big Data, Toad, Jira, Microsoft office Suite.

Confidential, New York, NY

Tableau Developer

Responsibilities:

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geocoding to build spatial visualizations of non-geographic data.
• Involved in all phases of the application software lifecycle (SDLC) including design development, testing and deployment.
• End-to-end Tableau Designer expertise from dashboard design/development to deployment/maintenance. Hands-on skills with use of action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions.
• Hands-on skills and deep experience working with the latest Tableau Server version, its Administration and the Maintenance.
• Experience working with Extracts, Live datasets, managing access privileges. Familiarity with Tableau SDK architecture.
• Tableau development lifecycle from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment
• Design, develop and support complex performance and capacity charts and reports using Tableau Tool
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.
• Used Custom SQL for joining the tables and selecting the required Data.
• Creating users, groups, projects, Data connections, settings as a tableau site administrator.
• Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with quick filters to filter needed information.
• Worked in Tableau environment to create dashboards weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Scheduled data extracts daily.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.

Environment: Tableau, Tableau Server, SQL Developer, MS-SQL Server 2008 R2, MS-Access, MS Excel and SQL, JavaScript

Confidential, New York, NY

Tableau Developer

Responsibilities:

• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
• Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions and provided an interactive reporting environment of the Revenue Impact Analysis, Inventory Control, Pricing Opportunity Analysis, Markets Overview, Shopping Activity, etc., in the developed dashboards.
• Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change, destinations flown across different geographic markets, time-series statistics for price variance across different vendors, heat maps for shopping activities across business units. Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform being implemented by the client.
• Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Oracle SQL Developer, and developed T-SQL statements for loading data into Target Database.
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
• Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Environment: Tableau Desktop 8.2, Tableau Server, Oracle SQL developer, SQL Server 2012, Oracle 10g, Windows 2007 server, Teradata, MS Office 2007

Confidential, Taylor, NY

ETL Data QA

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Resolve any performance bottlenecks of Informatica mappings using session level or mapping level tuning techniques;
• Responsible for Development Environment Testing for Database/Unix/Tool migration to new version;
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Defined data requirements and elements used in XML transactions.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the reporting objects in the reporter against the design specification document.
• Validating the data files from source to make sure correct data has been captured to be loaded into target tables
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata
• Extensively used IDQ tool to View data and run mappings, checking logs and validate the Target table as expected.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Reporting knowledge using Pivot Table and charts in MS Excel.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008 and Oracle 10g.

Environment: SQL, TOAD 7.0, Test Cases, Test Scripts, Test Plan, Traceability Matrix, Informatica Power Center 8.1, Informatica Developer tool

Confidential, Framingham, MA

Tableau Developer

Responsibilities:

• Interacted with Business users, Business Analysts to understand reporting requirements and transform them into technical specifications.
• Involved in the development of new Tableau Dashboards and publishing them to Tableau Server.
• Maintained reports and addressed data need to provide reporting solutions.\
• Independently worked on owning IT support tasks related to Tableau Reports on Server.
• Built and maintained many dashboards.
• Conducted Knowledge transfer session to the employees on Tableau Software.
• Created dataflow diagram and documented the whole data movement process.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
• Worked on the requirement gathering of the reports.
• Analyzed the database tables and created database views based on the columns needed.
• Created dashboards displaying sales, variance of sales between planned and actual values.
• Implemented calculations and parameters wherever needed.
• Published dashboards to Tableau server.
• Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing & Deleting Users and activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.
• Configured numerous collections in MongoDB for all the user data from various business units.
• Impersonating with a Run as User Account, Impersonating with Embedded SQL Credentials.
• Good Knowledge and Worked on TABCMD & TABADMIN, Database Maintenance and troubleshooting

Environment: Windows, Tableau Desktop 8.3, Tableau Server, MS Office Suite, SQL Server, MS Excel.