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 teh SDLC.
• Efficient in identifying and analyzing Business requirements from documents and end-user discussions and deliver teh data requirements necessary to support DW subject areas.
• Proficient in creating teh 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 teh development of Dashboard reports for teh Key Performance Indicators (KPI) for teh 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 teh 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 teh 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 noledge 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 noledge 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 teh source data need for various Tableau Reports and worked with ETL developers, DBAs, Data Modelers to implement teh same in Development, Test and Production environment.
• Translated business logic and rules from teh 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 teh Tableau projects using Agile/Scrum development methodology.
• Created complex formulas and calculations within Tableau to meet teh 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 teh 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 teh application's users, groups, and integration with Active Directory.
• Good SQL reporting skills with teh 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 teh 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 teh task's daily on teh server.
• Configured Active Directory authentication and enabled SSO.
• Manage teh 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 teh 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 teh 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 teh server according to best practices.
• Designed teh architecture of Tableau security by customizing teh 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 teh 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 teh existing filters and Tableau data extract to publish it in server by optimizing it to reduce teh 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 teh 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 teh 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 teh 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 teh 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 teh views and dashboards were displaying teh changed data accurately.
• Enabled teh data security filters for teh users/groups in an AD.
• Tuned teh reports performance using Cache options / Timely refreshes of data.
• Involved in testing teh SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled teh 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 teh tables and relationships based on teh finalized ER-Diagram
• Created Stored Procedures, Views and User Defined Functions to facilitate teh automation of data entry by a front end application
• Utilized teh Dynamic SQL for user customizable queries to be answered by teh 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 teh 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 teh 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 teh existing queries to improve performance with teh use of Profiler and Execution Plan.

Confidential

BI Developer

Responsibilities:

• Responsible for teh 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 teh 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 teh client requirements.
• Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key to streamline teh process of replication.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications.
• Understanding teh OLAP processing for changing and maintaining teh Data Warehousing, Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Worked on teh business requirements to change teh behavior of teh 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.