SUMMARY:

• Over 8 years of IT experience in Analysis, Design, Development, Testing and Implementation of various applications in OLTP, Client/Server OLAP environment using BI tools in Information Content and Technology, Health Management, Retail, Financial, and Manufacturing industries.
• 4+ years of extensive experience with design and development of Tableau visualization solutions.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau Public, Tableau Online, Tableau reader in various versions of Tableau (9.x/8.x/7.x) and SQL, and PL SQLscripting.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Proficient in conducting Gap Analysis and in gathering and writing detailed business requirement and translating them into technical specifications/ System Requirement Specifications (SRS) and design identifying interface and business process specifications.
• Hands - on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
• Expertise in Oracle, SQL Server, Informatica, SSIS, SSRS, MicroStrategy, Unica, Google Analytics, UNIX, Toad, Microsoft Office Suite.
• Strong experience in creating analytical reports usingDimensional Hierarchies, Level Based Measures using LOD, Time series data, Statistical / Analytical functions like forecasting, Trend Lines, Reference lines, etc. in Tableau.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, & import/export wizard while developing packages.
• Expertise in aggregating data and configuring reports from different data sources using data blending and tools like Alteryx.
• Experience in configuring reports from different data sources using data blending.
• Extensive experience in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. making use of actionsandotherlocal and global filters according to the end user requirement.
• Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, LOD expressions, Sets, Groups, and Parameters etc.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports
• Experienced in roles such as End-to-End BI and data-warehouse Solution implementation expert, BI Project Concept Scoping, BI Semantic Layer Designer, BI Reports/Dashboards/Scorecards design and development, Project Management, Business Analyst, BI KPIs Modeling.
• Designed the data conversion strategy, development of data mappings, source data profiling and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Expert in Unit, Systemand User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Flexible, enthusiastic, project-orientedteam player with excellent communication skills and leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS:

Analytical Tools: Tableau 9.x, 8.x, 7.x (Desktop/Server/Reader/Public/Online), MicroStrategy (Desktop/Server), UNICA, Google Analytics (Adobe Site Catalyst).

Data Integration (ETL) Tools: Informatica, Alteryx, MS SQL Server Integrated Service (SSIS)

Data Modeling /UML Tools: Power Designer, Erwin, MS Office (Visio, Word, Excel)

RDBMS: Teradata, Oracle, MS SQL Server, DB2, Sybase, Access

SQL Tools: Teradata SQL Assistant, PL/SQL Developer, Toad, SQL Server Management Studio

Service Management: CA Service desk, Lotus Notes

Document Management: Share Point, Documentum

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Defect management tool: Mercury Test Director, HP Quality center

Scripting Languages: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML

Scheduling Tools: Autosys, Control M

Operating Systems: UNIX, Linux, Windows 8/ 7/XP/2000

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Sr. Tableau Developer

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Consistently attended meetings with the client subject matter experts to acquire functional businessrequirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Used appropriate filters, column filters, prompts, dashboard prompts and calculations in tableau reports.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Worked extensively with Advance Analysis actions, Calculations, Parameters, Background images.
• Created ad hoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports.
• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Using Custom SQL for joining the tables, selecting the required Data.
• Developed and reviewed custom SQL queries with use of joins clauses in Tableau desktop to validate reconcile data.
• Created extracts, published data sources to Tableau server, refreshed extract in Tableau server from Tableau Desktop.

Environment: Tableau 10.x/9.x (Desktop/Server), Netezza, Oracle, MS SQL Server, SQL, TOAD, Microsoft (Word, Access, Excel, Outlook).

Confidential, San Jose CA

Tableau Developer

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Deployed the reports and Scheduled Reports for the use of end users and customers Work Experience.
• Worked on ETL tool Alteryx for cleansing and blending different data sources for analyzing the data.
• Integrated Tableau with Alteryx , to transform the data as per business needs, before creating visualizations.
• Analyzing the data of patterns, trends and fashions of various KPIs, Measures using various graphs, charts, pivot tables.
• Created extensive custom joins for blending data from several different data sources.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots using show me functionality.
• Implemented Data Representation using Visualization Techniques in Tableau suing Alteryx (Graphs, charts etc.)
• Created Groups, hierarchies, and Sets to create detail level summary reports and dashboards using KPI's.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• 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.
• Used Table Calculations, Parameters, geographic mapping, Sets, Actions and LOD expressions for solving complex business issues and solved Optimize issues in Dashboards.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop for data validation.

Environment: Tableau 10.x/9.x (Desktop/Server), Alteryx, Oracle, MS SQL Server, Informatica, SQL, TOAD, CA Service Desk, UNIX, MS VISIO, Microsoft (Word, Access, Excel, Outlook).

Confidential, Belmont, CA

Sr.Tableau Developer

Responsibilities:

• Participated in requirement gathering meetings and translated business requirements into technical design documents/ report visualization specification design documents.
• Synthesized and translated Business data needs into creative visualizations in Tableau.
• Extracted digital marketing data from Adobe Marketing Cloud in Tableau Data Extract (TDE) format by connecting to Adobe Site Catalyst for developing Business Intelligence dashboards.
• Refreshed the Tableau Extract in production server using scheduler.
• Used Data Blending, Groups, combine Adobe Marketing Cloud data and other aggregated data, spotlight into compare and analyse data in different perspective.
• Developed various reports using best practices and different visualizations such as Lollypop Charts, Donut Charts, Funnel Charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.,
• Developed reports comparing multiple measures using Individual Axes, Blended Axes, and Dual Axes.
• Built complex calculations using advance functions such as LOD, ATTR, DATEDIFF, STR, Ifs, Nested Ifs, SUMIF, COUNTIF, LOOKUPs and Quick Table calculations.
• Created Actions in Dashboards for interactivity, to compare &analyse data in different perspectives and to easily navigate through different dashboards enabling users to drill down to more detail data.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Created SQL scripts for testing and validating data on various reports, dashboards, and scorecards and handled performance issues effectively in Tableau.
• Involved in administrating Tableau server and creating tabadmin scripts for automating backup procedures through windows scheduler.
• Worked in user management, group management and permission management for accessing dashboards based on security requirement.
• Deployed Tableau dashboards in production after user acceptance test clearance.
• Developed other supporting documentation such as source to target mapping documents, business logic flows, process flows, requirements traceability matrix, etc.
• Assisted users in creating and modifying worksheets and data visualization dashboards using Tableau Desktop.

Environment: Tableau 9.x/8.x (Desktop/Server), Oracle, SSIS,MS SQL Server, Adobe Marketing Cloud, Informatica, SQL, TOAD, CA Service Desk, UNIX, MS VISIO, Microsoft (Word, Access, Excel, Outlook).

Confidential, San Diego, CA

Tableau Developer

Responsibilities:

• Analysed requirements to understand business needs.
• Designed, developed and published customized interactive reports /dashboards and scheduled data refreshes for reports in Tableau Server.
• Develop, organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Converted business requirements into story-telling VIZ by developing views/ dashboards in Tableau Desktop and publishing the same to Tableau Server allowing end-users to control and filter data.
• Created calculated fields, action filters, parameters, groups, hierarchies, and sets for preparing dashboards and worksheets using Tableau (Desktop)for Tableau report development.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop for data validation.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Performance tuning of workbooks, data sources, and providing best practices for user community
• Provided 24/7 production support for Tableau users.

Environment: Tableau 8.3/8.1 (Desktop/Server), Teradata, SQL Assistant, SQL, PL SQL, Teradata Administrator, Putty, UNIX, MS VISIO, Microsoft Office Suite (Word, PowerPoint, Excel)

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Work with internal management and team members to understand and clarify reporting requirements / needs.
• Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.
• Use advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.
• Identify key business metrics measurements and develop methods to represent data in support of the measurements.
• Provide guidance and insight on data visualization and dashboard design best practices in Tableau.
• Used Tableau Desktop for blending data from multiple sources and creating different interactive views and dashboards.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Generated tableau dashboards for sales with forecast and reference lines.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.
• Embedded Tableau reports/dashboards on to the external web pages.
• Provide innovative solutions and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.
• Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development.
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.
• Maintain thorough and rigorous documentation related to all ETL changes, Metadata, database server configuration, operation, and database change management.

Environment: Tableau 8.x (Desktop/Server), MS SQL Server, SQL, Java API, Putty, UNIX, Microsoft (Word, Access, Excel, Outlook).

Confidential, Mount Laurel, NJ

BI Analyst/ Data Analyst

Responsibilities:

• Gathered user requirements, analysed and designed software solution based on the requirements.
• Conducted logical data analysis and data modelling JAD sessions, documented data-related standards.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Make use of data modelling techniques in designing the data marts project.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Involved in creating database objects such as tables, views, procedures, triggers, functions using PL/SQL to provide definition, structure and to maintain data efficiently.
• Worked with source system teams to understand source data and complete source data profiling.
• Created Source to Target mapping documents detailing Source rules, Target rules, Transformations required, Error handling etc., and worked with the team of ETL developers to implement the same.
• Designed database tables to feed Promotions, Campaigns, Customer data for effective targeting and direct marketing campaigns.
• Extensively worked on Pre-Campaign and Post-Campaign data analysis.
• Designed various analytical reports and dashboards on campaign response data in Tableau.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Involved in testing, fixing the bugs and troubleshooting the technical problems.
• Created the templates for test plan, test cases, process flow diagrams etc.
• Involved in Performance Tuning of Jobs and enhance the performance using the standard techniques.
• Experience in co-coordinating offshore team with responsibilities such as providing solutions for the issues/troubles/technical difficulties that offshore team has on top of design documents, source to target mappings.

Environment: Tableau7.x (Desktop/Server), Oracle, Informatica, SQL, TOAD, Autosys, UNIX, MS SQL Server, Erwin, MS VISIO, Microsoft (Word, Access, Excel, Outlook).

Confidential

MS SQL Server Developer/BI Developer

Responsibilities:

• Extracted and reviewed data from heterogeneous sources like ( Excel, CSV, Oracle, flat file, Text Format Data ) using SQL Server Integration Services (SSIS) from OLTP to OLAP .
• Implemented Data Mart, Facts, Dimensions, Snow Flake schema, Star Schema and OLAP cubes.
• Created Calculated Measures and Dimension Members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Worked in visually enhancing reports as per user requirements.
• Responsible for tuning and Optimizing Queries for the reports.
• Expert in SQL Server Management Studio interface for writing queries and stored procedures.
• Created database objects like views, indexes, user defined functions, triggers and stored procedures.
• Responsible for trouble shooting the reports.
• Maintained DTS 2000 Packages and migrated them to SSIS.

Environment: MS SQL Server 2005, MS Visual Studio 2005, Windows XP Professional, Team Foundation Server, ProClarity, SSIS, SSRS, SSAS.