SUMMARY

• Qualified professional with 7+ years of extensive IT Experience as a Tableau Developer, Data Analyst, and Business intelligence Developer. Proficient in delivering transformative solutions to clients that are aligned to industry best practices and provide thought leadership in data space using data extraction, cleansing, and analysis.
• Experience working on Hadoop, AWS to generate reports using tableau.
• Expertise in designing and development of various dashboards used 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 actions, other local and global filters according to the business/client requirement.
• Extensive experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Extensive experience in SQL and in performance tuning SQL queries.
• Experience in administering user, user groups, and scheduled instances for reports in Tableau.
• Excellent knowledge of Business Intelligence platforms and processes across Banking, IT and Financial industries.
• Experience in implementing Data blending, replace references, Customized queries and advanced visualizations in Tableau.
• Highly proficient in design and development of prototype reports/ dashboards in Tableau during the requirement gathering phase to visualize the reports and clarify requirements.
• Expertise in creating quick filters, data source filters, global filters, context filters, user filters and creating Dashboards for key Performance Indicators.
• Expert in creating Calculations (LOD, Cube Calculations, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Extensive experience in using Tableau (Desktop/ Server), SQL Server, Oracle, Teradata, Informatica Power Center, Oracle 11g, and DB2.
• Experience in reviewing business requirements and analyzing data sources from Excel, Oracle, Hadoop, SAS, Teradata, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
• Knowledge in design and development of PL/SQL Stored Procedures, Functions, Cursors, Packages and Triggers.
• Hands on experience in publishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Experience in leading teams to reach goals using strong intrapersonal, analytical, problem-solving skills and ability to learn quickly.

TECHNICAL SKILLS

Analytics: SAS, Tableau, Google Analytics, Python, R, Big Data Hadoop- Map Reduce, Hive, Pig

SDLC Methodologies: Waterfall, Waterfall-Scrum Hybrid, Agile-Scrum

Business Skills: SWOT, Change Management, Risk Management, Business & Technical Impact Analysis, Cost-Benefit Analysis, Value Chain Analysis

Databases: Oracle PL/SQL, MySQL, MS Access, MS SQL Server (BI, ETL, OLAP), PostgreSQL, MongoDB

Project Management Tools: MS Project, MS SharePoint, Smart Sheet, Google Docs, Dropbox, Keynote, Slack, DocuSign, GoToMeeting, WebEx

Web: JavaScript, Bootstrap CSS, WordPress, MEAN stack

ETL Tools: Informatica, SSIS, Business Objects

Reporting tools: Tableau Desktop, IBM Cognos v10, MS Office Suite, Spotfire, MS SSRS, Oracle BI Publisher

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up

Applications: Apache Tomcat, NGINX, Hadoop, Map Reduce, JIRA, Confluence

Platforms and OS: Microsoft Azure, Amazon Web Services, OpenStack, CentOS, Ubuntu, Windows Server

PROFESSIONAL EXPERIENCE

Senior Tableau Developer

Confidential, Wilmington, DE

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form CSV/Oracle/SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map by color that was broken into Counties and Zip codes allowing business user to understand and help the state officials to focus on the Low KPI areas.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Worked with administration team to configure and installation of tableau server and proof of concepts.
• Connected to SQL server and SAS as data sources.
• Used data blending concepts to blend data from different data sources (CSV and MySQL and CSV and Oracle and between data bases).
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• 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.
• Applied Cascading Prompts and Multi Level Prompts on dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence dashboards and Reports.
• Trained end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Exhibited internal sales trends using Tableau for better understanding of profitability of different client segments. This replaced time consuming Excel/ SAS based data analysis.
• 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.
• Created Test Scenarios to validate Tableau dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau Desktop 9.4, 10.1, 10.2, Tableau Server 9.4, 10.1, 10.2, CSV, MySQL and Oracle, SQL Server, SAS, Tableau Mobile.

Senior Tableau Developer

Confidential, Berkley Heights, NJ

Responsibilities:

• Gathered requirements from end users, involved in modifying various technical & functional specifications.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advanced features of Tableau software like, to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Involved in new KPI generation for Scorecards.
• Assisted in installation and upgrading of Tableau server and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Using Tableau JavaScript API for performance improvement of the web page.
• Filtering Views in the dashboards Using JavaScript API.
• Extracted large data to Tableau from Amazon Redshift to analyze, visualize and share information.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins and security checks.
• Data collection and leveraging on data manipulation teams for required data.
• Identify new metrics and enhance the existing KPI's.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Scheduled frequency and time to refresh data for when sources are published or extracted to the server.
• Proof-read all documents and maintain the accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing Ad-hoc Reporting.

Environment: Tableau Desktop 8.1-8.2, Tableau server / Administrator, SQL developer, SQL 2008, Oracle 10g, PL/SQL, T-SQL Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007, Business objects 4.0, Amazon Redshift

Tableau Developer

Confidential, Cincinnati, OH

Responsibilities:

• Interacted with business user group for domain requirements gathering.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Involved in defining the whole project life cycle, following agile methodology. Analyze business requirements and segregated them into high level and low level.
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Interact professionally with a diverse group of professionals in the organization including managers and executives.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in a clustered environment by mapping server nodes to primary machine.
• The 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, 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, set to create a detail level summary report and Dashboard using KPI's.
• Defined best practices for Tableau report development and effectively used data blending feature in the tableau.
• Create, customize and share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Environment: Tableau Desktop/Server 6.x-7.x, SQL Server 2008, SSRS, HPQC, Oracle 11g, SQL, PL/SQL, T-SQL, Microsoft office 2007.

BI / Tableau Developer

Confidential, Chicago, IL

Responsibilities:

• 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.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Worked closely with business power users to create reports/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.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• 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.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.

Environment: Tableau, MS SQL Server 2008 SQL BI Suite (SSIS, SSRS), MS Access 2010 & Windows Server 2008, Oracle, MS Visual Studio.

BA/ Tableau Developer

Confidential

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Analyzed the source systems and created Business Requirement Document (BRD).
• Deep experience with the design and development of Tableau visualization solutions.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server.
• Configured different data sources using Tableau Desktop.
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Created Inventory trends, sales integration and forecast accuracy related dashboards.
• Designed, developed, and maintained Tableau functional reports based on user requirements.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: Tableau Desktop 8.x/7.x (Desktop/ Server), SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, Java 1.5 platform, Microsoft office Suite 2007 (Word, Excel, PowerPoint).

SQL Developer

Confidential

Responsibilities:

• Performed data validation and transformed data from RDBMS oracle to SAS datasets.
• Worked with all phases of the software development life cycle (SDLC) with business process models: Waterfall & Agile (Scrum)
• Responsible for database analysis, design, development, testing, implementation & maintenance of the database application.
• Worked in BI team to fulfill the needs of regulatory/management/finance/loss mitigation/fraud reporting and 10Q.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Build a common utility frame work to handle all the exceptions in a Business process.
• Using Excel and VBA in the development of robust and flexible reporting systems.
• Retrieved data from data warehouse and generated a series of meaningful business reports using SSRS.
• Validated and tested reports, then published the reports to the report server.
• Performed and conducted complex custom analytics as needed by clients.
• Designed and developed specific databases for collection, tracking and reporting of data.
• Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.
• Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableau platform.
• Built data input and designed data collection screens - Managed database design and maintenance, administration and security for the company.
• Discussed intelligence and information requirements with internal and external personnel.
• Data output - Made data chart presentations, coded variables from original data, conducted statistical analysis as and when required and provided summaries of analysis.
• Consistently achieved good customer satisfaction by efficiently translating customer functional requirements into technical solutions.

Environment: SQL Server 2008 Enterprise Edition, T-SQL, SSRS.