SUMMARY

• Around 7 years of IT experience in Analysis, Design, Development, Testing and Implementation of various applications in OLTP, Client/Server OLAP environment using BI tools.
• Extensive experience with design and development of Tableau visualization solutions.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau reader in various versions of Tableau (7.x/8.x/9.x) and VizQL, SQL, PL SQL and UNIX shell scripting.
• Experience in business process analysis/modeling, business requirements, and developing High level Designs and Prototypes for Business applications.
• Support and maintain Project Data Models at multiple levels of detail and functionality (conceptual, logical, physical and subject - level) in developing star schema and snowflake schema.
• Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.
• Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.
• Efficient in identifying and analyzing Business requirements from documents and end-user discussions and deliver the data requirements necessary to support DW subject areas.
• Proficient in creating the Design Documents for loading data into Data Warehouse and Data Mart tables.
• Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.
• Experience in aggregating data and configuring reports from different data sources using data blending.
• Proficient in creating different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Good expertise in building dashboards and stories based on the available data points.
• Expertise in Agile Scrum Methodology to implement project life cycles of reports design and development
• Harnessing best ways in designing stunning visualizations using tableau software, publishing and presenting dashboards on web and desktop platforms. Trouble Shooting skills, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Working knowledge of ODBC, OLEDB, T-SQL, SQL, PL/SQL, Teradata, Stored Procedures, Functions, Packages, Triggers, and scripting languages.
• Well-versed with Microsoft Office Suite including Office365, Lync, MS Visio, MS Access, Project, Power Query, Power Pivot, DAX, SharePoint, and SharePoint Designer.
• Widespread knowledge in using report building tools like Powe rBI, Tableau, Spotfire and Qlikview.
• Experience in working at various levels of software development cycle such as Analysis, Designing, Developing, and Testing & Implementation of business applications in Client Server / Relational Database Management environment for Windows Platform.
• An empathetic listener and persuasive speaker with excellent written and verbal skills.

TECHNICAL SKILLS

Tools: Tableau suite of tools 9, 8.2, 8.1, 8.0, 7, 6, which includes Desktop, Server, online and Public and Administration of Tableau Server, SSIS, Informatica

Operating systems: Windows XP, Windows Server 2003/2008, Windows Vista, Unix

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

Languages: SQL, HTML, C, C++

Methodologies: Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum

Office Tools: Microsoft Office 2003 / 2007 / 2010 / 2013 ((Word, Excel, PowerPoint, Visio, Project))

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, Arizona

Tableau Developer

Responsibilities:

• Collaborated with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Extensively worked on metadata in Tableau desktop to modify data types, rename fields, joins, assign roles, refresh data and change extract data options to prepare data sources to be used by users.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality and publishing them to tableau server and tableau Online.
• Designed standardized Data Mart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL developers, DBAs, Data Modelers to implement the same in Development, Test and Production environment.
• Translated business logic and rules from the existing system (SQL) to Alteryx.
• Created Alteryx macros in Alteryx designer for reporting and data manipulation.
• Created visual workflows in Alteryx for data blending and analysis using data quality, integration and transformation.
• Implemented the Tableau projects using Agile/Scrum development methodology.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Integration of Tableau reports with Asp.Net web applications and usage of JavaScript API for performance improvement.
• Experience in using tabadmin tools and tabcmd for setting up security profiles for various user groups and users.
• Used SAML for configuration of Tableau Server SSO supplementing Kerberos authentication on the side.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Manage the application's users, groups, and integration with Active Directory.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Setup and configuration of Tableau server 10.1 in various environments and used Tableau CMD.

Environment: s: Tableau Desktop 9.2, Tableau Desktop 10.0/10.3, Tableau server, Oracle SQL developer, SQL Server 2012, Oracle 10g, PL/SQL, T-SQL, MS Access, Windows 2007 server, Teradata, MS Office 2007.

Confidential, Charlotte, NC

Tableau Developer

Responsibilities:

• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Performed GAP and Risk analysis of existing system and evaluated benefits of new system.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server and embedded them into portal.
• Worked on setting permissions on content for specific users or group on a per site basis.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Trend Lines, Statistics, and Log Axes, Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Understand existing business incorporated in Oracle db and come up with workaround functions in Sybase.
• Created custom Locations on Maps using Longitude and Latitudes.
• Generated context filters and data source filters while handling huge volume of data.
• Creating users, groups, projects, Data Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• 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.
• Configured Active Directory authentication and enabled SSO.
• Manage the application's users, groups, and integration with Active Directory.
• Experience in taking back ups and restoration of Tableau repository.
• Developed reports in Tableau by connecting to various data sources like MS SQL Server, Oracle, MS Excel.
• Fine Tuned SQL Queries for Maximum efficiency and performance.
• Designed a Project for the Downstream, connecting to a huge SQL Database.
• Involved as a technical expert providing input to application design regarding performance tuning and administration requirements.
• Partner with the Technology teams to deliver a stable and highly available reporting platform.
• Experience in designing and development of Tableau visualization solutions and created Business requirement documents and plans for creating dashboards.
• Setup and configuration of Tableau server in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level
• Expertise in designing and Development of Tableau Visualization Solutions.
• Creating a whole new Open Access Tableau Environment for Opted Projects without Data Privacy Limitations.
• Designed New Interactive Dashboards from existing broken dashboard with higher quality visualizations and best performance.

Environment: s: Tableau Desktop (8.x/9.x), Tableau Server 9.0.4, SQL, SQL Server, DB2, Oracle, T-SQL, Teradata, MS Access, Microsoft Office Suite (Word, PowerPoint, Excel)

Confidential, Peoria, IL

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel, Oracle, SQLServer for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Worked with Tableau Box Plots and Trend lines.
• Expertise in working with data building Groups, Hierarchies and sets.
• Developed effective and interactive Dashboards using Parameters and Actions.
• Involved in creating interactive, parametrized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
• Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots and Bullet Graphs.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Reviewed and optimized SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Performed Database backups (operating system, flat file backups & export/import).
• Performance tuning and optimization of complex SQL queries using Teradata Explain.
• Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time.
• 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.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Validated the reports before publish reports to Tableau server, troubleshoot Tableau reports, dashboards, etc.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, SAP BO, Tableau Server, Talend, Qlikview11, Windows Server 2008 R

Confidential, Irvine, CA

Tableau Developer

Responsibilities:

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Transformed TABLEAU into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging andmonitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.
• Ensured projects were completed on time and within budget.
• Generate KPI for customer satisfaction survey results and disease management.
• 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. Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.

Confidential, North Wales, PA

Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of client requirements.
• 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.
• Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableau platform.
• Installing and configuring of Tableau worker servers.
• Created views in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
• Worked closely with business power users to create reports/complex dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• 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.
• Effectively used data blending, filters, actions, and hierarchies feature in tableau.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Projected and forecasted future growth in terms of number of customers in developing Area Maps to show details on which states were connected the most.
• Tableau server maintenance, Tableau server backup activity.
• Created users using Tableau Admin and assigning privileges to create report/publishing reports to server.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Enabled the data security filters for the users/groups in an AD.
• Tuned the reports performance using Cache options / Timely refreshes of data.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Responsible for creating /delivering monthly reports to business users.

Confidential, Louisville, KY

BI Developer

Responsibilities:

• Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram
• Created Stored Procedures, Views and User Defined Functions to facilitate the automation of data entry by a front end application
• Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server
• Created database documentation for table and column dictionaries and other reference material
• Implemented indexes on tables and views for optimum performance tuning
• Involved in dimensional data modeling and story boarding ETL processes
• Designed the ETL process using different data sources include Flat files, Access, Excel, SQL Server
• Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions)
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like de-fragmentation, re-indexing, and recompiling
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality
• Optimized the existing queries to improve performance with the use of Profiler and Execution Plan.

Confidential

BI Developer

Responsibilities:

• Responsible for the design, development and implementation of dynamic SSIS packages for ETL (extract, transform, and load) development following company standards and conventions.
• Transferred flat files from different sources to the Staging Area by using SSIS and executed BCP from a package to import all files to pre-staging database.
• Worked on different kinds of Transformations in SSIS as per the client requirements.
• Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key to streamline the process of replication.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications.
• Understanding the OLAP processing for changing and maintaining the Data Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Worked on the business requirements to change the behavior of the cube by using MDX scripting.
• Worked with database designing physical and logical database design.
• Coordinated with back-end programmers in optimized stored procedures, implemented referential integrity by using triggers, worked on performance tuning.