SUMMARY:

• Overall 8+ years of experience in Information Technology with a strong background in Data Visualization using Tableau 10.4/10.3 /10.2/10.0/9.3 /9.1/8.2/8.0 , Tableau Server, Tableau cloud, Tableau Online, Tableau mobile, Tableau Public, Tableau Reader.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Hands on experience on Tableau Desktop, Tableau Reader, and Tableau Server.
• Worked on beta version of 10.4
• Connected to Tableau Postgre SQL database to create customized interface for Tableau workbooks to provide native intranet style navigation.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Capability to learn modern technologies quickly for the project developments.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Have been working with various data sources such as Oracle, SQL Server, Teradata, Hadoop, ODBC and flat file sources.
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Involved in trouble shooting of performance issues which were associated with Tableau reports .
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop (10.4/10.3/10.2/10.1/9.3/9.2 ).
• Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users, and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Experience in working on different data warehousing methodologies including star schema and snowflake schema, ETL processes, dimensional modelling, reporting tools.
• Experience in using Custom SQL for tableau and in writing queries for generating tabular reports, formatting report layout and expressions.
• Combined multiple data sources using  blending in Tableau  to keep track of sensor data, operator inputs, and
• Real - time systems all in one dashboard.
• Proficient in integration, the configuration of  R with Tableau .
• Connected Tableau Server to Amazon Redshift  with SSL and insured the connections are encrypted.
• Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing, and HR.
• Analysing web traffic and creating google analytic dashboards to visualize the web traffic interactively.
• Knowledge of Medicare and Medicaid rules and regulation.
• Knowledge of Medicaid Managed Care encounter and claims data.
• Demonstrated knowledge of various database management systems to input, extract or manipulate information.
• Demonstrated experience and knowledge of health care information ( health claims data specifically Medicare and Medicaid, ICD-9-CM codes , physician specialty codes, pharmaceutical data including NCPDP file formats and codes, provider identifiers, etc)
• Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation, and end-user training.
• Experience in efficiently using standard Business Content , extending, and enhancing according to the report requirements.
• Good understanding of business environment, excellent communication skill and ability to work proactively in a fast-paced environment.
• Communicate effectively with colleagues and business users.
• Prepared  Training Manuals  and Knowledge Transfer Manuals.
• Excellent communication and presentation skills . Experience working with business users as well as  Senior Management.
• Strong work ethics, taking  ownership  of all duties and responsibilities and efficient  time management skills .
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Experience in Developing Performance Dashboards, Score cards, Metrics, what if analysis, Prompts, Drills, Search (using Add-ons) Reports/Dashboards for all the functional areas including Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory
• Warehouse Management, Supply Chain, and Transportation, Sales/Marketing, Variable Objects with formulas.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.

TECHNICAL SKILLS:

Business Methodologies: RUP, Agile, Waterfall

Accounting: QuickBooks Enterprise, MicroStrategy, Microsoft Excel.

Business Modeling Tools: UML, Rational Rose, MS Visio 2010, Brio

Requirement Analysis: Rational Requisite Pro, Test Director, Quality Centre

Business Intelligence Tools: Tableau 10.4/10.3 /10.2/10.0/9.3 /9.1/8.2/8.0 , Tableau Server, Tableau cloud, Tableau Online, Tableau mobile, Tableau Public, Tableau Reader Cognos, Business Objects, Tableau Server, SQL-Developer.

Databases/ Languages: Oracle, Microsoft SQL Server, SQL, Python

Operating Systems : Windows 7, XP, Unix

Testing Tool: HP QC, QTP, Load runner

Office Tool: MS Word, MS Excel, MS Power Point, MS one Note

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Senior Tableau Developer/ Analyst

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications.
• 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.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE's, Table Variables and Stored Procedures.
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart .
• Connected to the AWS Redshift directly from Tableau10.3 to access cloud data warehouse and quickly perform visual analysis.
• Worked on beta version of 10.4
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop 10.4.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations .
• Hands on building Groups, hierarchies , sets to create detail level summary reports and Dashboard using KPI's
• 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.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• 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.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: Tableau 10.4/10.3 /10.2/10.0/9.3 , Tableau Server, Tableau cloud, Tableau Online, Tableau mobile, Tableau Public, Tableau Reader., SQL, Business Object 5x, Amazon Redshift.

Confidential, Fort Worth, TX

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.
• Setup and configuration of Tableau server 9.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Created Dashboards from Tabular Models to help managers 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.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Oracle, Teradata and SQL Server.
• 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.
• Developed highly polished executive level dashboard prototype for the Operations Research Consulting group which provides BI for different Airlines to implement their decision support systems for developing competitive fares, low fare schedules, optimizing the codeshare data between partner airlines, etc.
• 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.
• Articulated best practices for Tableau report development and efficiently used data blending in tableau
• Configured Cache settings which improved the performance of the reports and Dashboards.
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
• Developed story telling 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 9.3/9.1, Visual Studio 2015, Tableau server, Oracle SQL developer, Oracle 10g, PL/SQL, MS Access, Windows 2007 server, Teradata, MS Office 2007.

Confidential, New York

Tableau Report Developer

Responsibilities:

• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server node to primary machine.
• Develop, Organize, manage, and maintain graphs, tables, slides, and document templates for the efficient creation of reports.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Experience in standardizing Tableau for shared service deployment.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scatter plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Creating users, groups, projects, Data connections, settings as a tableau Administrator.
• Involved in creating dashboards and reports in Tableau and maintaining server activities, user activity, and customized views on Server Analysis.
• Created and published packages for different functional areas and assigned security rules to them in Cognos Framework Manager.
• Created Active reports using data deck, tab data button bar and sliders.
• Created reports containing multiple data containers like List, Cross-tab, and Repeater tables in Cognos Report Studio.
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• Scheduled reports using Cognos scheduler and emailed to various recipients as required.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Developed Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analysed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Performed SQL reporting with the ability to create SQL views and wrote SQL queries.

Environment: Tableau 8.1/8.0, Tableau Server, Cognos 6.0/7.0, SQL 2014, Microsoft Office 2007, SQL Server 2008, PL/SQL, T-SQL.

Confidential, CA

Sr. Tableau Developer 

Responsibilities:

• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau. 
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite. 
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Experience on writing SQL Queries.
• Strong verbal and written communication skills, ability to work effectively with user departments.

Environment: Tableau 8.1/8.0, Tableau Server, Oracle, Microsoft SQL Server, Microsoft Office, Microsoft Visio, Windows 7 

Confidential, IL

Tableau Administration/ Developer 

Responsibilities:

• Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter, and Context filter to improve performance. Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension. Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends, and drill downs. Published Workbooks and Dashboards to the Tableau server. Combined visualizations into Interactive Dashboards and publish them to the web.
• Administration of Tableau and server maintenance, Tableau server backup activity. Consolidate multiple data silos that exist on campus to one location. Scheduled data extracts on a daily basis. Sophisticated stored procedures and triggers to provide complete technical solutions. Worked with all levels of development from analysis through implementation and support.
• Created groups and users in Tableau server. Used commands in Tabcmd and Tabadmin utility tool.
• Migrated Workbooks and Tableau upgrades/migration works. Implemented new features in Tableau to the existing Workbooks and Dashboards.
• Created Business Model to support Ad hoc Reports for User Access based on Requirements. Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.
• Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Managed Security privileges for each subject area and dashboards according to user requirements. Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations. Used the Catalog manager and maintained the web catalog to manage Dashboards and Answers. Responsible for documenting the OBIEE framework and track the progress.

Environment: Tableau Server, Tableau Desktop 6 & 7, Desktop Reports, SAP HANA, Web Intelligence Reports, MS SQL Server 2000, T-SQL, Access 2000

Confidential, Irving, TX

Business Objects Developer

Responsibilities:

• Inventory, Accounts Payable and Purchase Orders were the different subject areas within the data warehouse.
• Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
• Created custom hierarchies to aid in Drill-Through analysis of web documents and built cascading prompts.
• Participated in the complete development lifecycle: analysis, design, build and test reports
• Created several complex Web Intelligence and Desktop Intelligence reports to help management to track and monitor contract, commodity and price compliance.
• Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
• Created User Prompts, Conditions and Filters to improve the quality of report generation.
• Scheduled Reports using scheduler Info view as well as CMC.
• Key metrics ‘procure to pay cycle times’, ‘diversity spend’, ‘cash discounts captured and missed’.
• Spanning across different subject areas has been re-created using Xcelsius.
• Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts & material and cost specialists.
• Providing support for the users on application usage and conducting training walk through of salient features of the application.

Environment: Oracle 10G, Business Objects XIR2, Web Intelligence and Infoview XI R2, Desktop Intelligence, CMC, Import Wizard, Universe Designer, Java script, PL/SQL Developer, Windows 2003 advanced server.

Confidential, Dallas, Texas

Cognos Developer

Responsibilities:

• Generated various  List Reports ,  Grouped Reports ,  Cross tab Reports ,  Chart Reports, Drill-Down  and  Drill-Through Reports.
• Generated  Complex reports in Cognos 10.1 report studio including Drill Down reports  from  DMR modelled Frame work model.
• Created Dashboards to present critical   company data in a single report.
• Created list reports & cross tab reports using Cognos 10.1
• Manually modified the SQL in ReportStudio  to tune and/or to write complicated reports. Used  union/Join  objects in ReportStudio
• Experience in developing Framework Manager Models  and analyzed those models in analysis studio.
• Gathered and analyzed business requirements  from users and business community.
• Analyzing existing  transactional database schemas  and designing  star schema models  to support the users reporting needs and requirements.
• Created Sophisticated Reports using  Report Studio.
• Used some advanced features like  Conditional Formatting  in  Report Studio  in generating multipage Reports.

Environment: Cognos 8 & 10 BI, Cognos Connection, Cognos office Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager,  DB2 ,  SQL, XML and Windows NT/4.0.