PROFESSIONAL SUMMARY:

• Over 9 years of extensive IT Experience as a BI Developer, Data Analyst in Data Warehousing and Business Intelligence applications in Financial, Healthcare and Entertainment industries.
• Extensive experience in working with Tableau Desktop, Tableau Server, Tableau Online and Tableau Reader in various versions of Tableau 10.x/9.x/8.x/7.x.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Proficient in data visualization, Reporting, Analysis, Bar Charts, Pie Charts, Heat Maps, Scatter Plots, Page Trails, Geographic Map and Density Charts in Tableau Desktop.
• Created actions, customized relationships, data blending, filters, calculated fields, parameters, hierarchies, groupings, sorting, live and extract connections, drill down analysis and in - memory in Tableau 10.1
• Experience in writing complex SQL and PL/SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Extensively worked on Alteryx designer to connect to and clean data from data warehouses and spreadsheets.
• Adept at Predictive Modeling, Statistical Analysis, Customer Profiling & Segmentation, and Data mining.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Proficient skills with Excel, Word, PowerPoint and data mining software (R, SAS).
• Utilised Tableau JavaScript API for performance improvement of web page.
• Expertise in Tableau Server for site creation, server setup for administration and security. Hands on experience in server patch setups, server health monitoring and setting up the backup. Prepared proof of concept for best practices in Tableau deployment
• Experience working with Big Data and Analytics space exploring/building data visualizations using Splunk.
• Experience working on integration of AWS with Tableau.
• Expertise in web integration of Tableau Reports with HTML or Asp.Net.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Proficient in Star Schema dimensional modelling, which includes understanding business processes, modelling, dimensions, hierarchies and facts.
• Experience in development of user defined reports to provide on demand data analysis using Excel and created charts and pivot tables in Excel.
• Requested data from Google Analytics from Tableau, and overcome the sampling limits that would typically apply in the interface and the Core Reporting API .

WORK EXPERIENCE:

Confidential - Phoenix, AZ

Sr. Tableau Developer & Admin

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 DataMart 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.
• Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.
• Mastered in different formatting techniques, using Annotations and Mark Label.
• Developed effective and interactive Dashboards using Parameters and Actions. Setting the user permissions in Tableau Sever.
• Translated business logic and rules from the existing system (SQL) to Alteryx.
• Created Alteryx macros in Alteryx designer for reporting and data manipulation.
• Implemented the Tableau projects using Agile/Scrum development methodology.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Extensively used SQL/ PL SQL in data profiling, modelling and mining of data.
• 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.
• Worked with R functions and R model in Tableau.
• 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: /Skills: Tableau Desktop 10.0/10.3, Tableau server, SAP HANA, Oracle SQL developer, SQL Server 2012, Oracle 10g, PL/SQL, T-SQL, MS Access, Windows 2007 server, Teradata, MS Office 2007.

Confidential - Cary, NC

Sr. Data Visualization Developer & Data Analyst

Responsibilities:

• Created and hands on experience in Level of Detail Expressions (LOD’s) such as Customer order frequency, Cohort analysis, Daily profit KPI, Percent of total, New customer acquisition, Comparative sales analysis, Average of top deals by sales rep, Actual vs. target, Value on the last day of a period, Return purchase by cohort etc.
• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Worked on embedding Tableau reports to Microsoft Power BI Launchpad and Crystal reports.
• Experienced working in Agile, Rally and Scrum implemented Environment.
• Handled the tasks of building, deploying and maintaining metadata inventories and data support tools. Experienced working on different ticketing systems such as Agile ticketing.
• Implemented Tableau, performed admin activities across multi-environment infrastructure.
• Utilised AngularJS to write Tableau Web Data Connectors which interact with the URLs and gather data into Tableau using tableau.dataCallback() and tableau.headersCallback().
• Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• Extensive knowledge on creating APIs using ASP.NET
• Extensive worked on using spatial fields, geo maps and geo-coding.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Integrated R with Tableau and utilized RServe package to perform deep statistical analysis.
• Created detailed dashboards utilizing Microsoft Power BI desktop to improve analysis and decision making.
• Worked on PowerBI Desktop for Data model preparation and Visuals and real-time reports Hands on experience on Integration of Power BI dashboards with data feed integration Implemented Row Level Security in PowerBI.
• Created and administered user, user groups, and scheduled instances for reports in Tableau & Power BI Server.
• Maintaining server activities, user activity, and customized views on Server Analysis..
• Expertise in providing business solutions by analysing various trends, risks and patterns in the data using interactive crystal reports.
• Setting up complete ETL Workflow in Alteryx. Enhanced existing oracle views in the ETL Alteryx workflow.
• Configured AWS for Tableau and Installed Tableau Server. Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Worked on data management using micro SAS for statistics. Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Experience in working on sourcing the data from HADOOP platform using scoop.
• Experience in running queries in HIVE. Worked on different Hadoop distributions such as HDP and CDH.

Environment: /Skills: Tableau (Desktop/ Server) 9.3, Alteryx, Microsoft Power B.I., Teradata V2R5/R6/R12/R13, Python and R, Hadoop, AWS, SQL developer, MS SQL Server & TFS, Oracle MySQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Amazon Redshift, AWS, Windows 2012 R2 server.

Confidential - Ann Arbor, MI

Sr. Tableau BI Developer & Admin

• Involved in full project lifecycle of SDLC and coordinated with all project teams. Interacted with Subject Matter Experts & End Users and gathered business requirements. Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
• Implemented the Tableau projects using Agile/Scrum development methodology.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases.
• Well versed with the usage of variables to make the packages dynamic and scheduling the package in SSIS (sequential scheduling).
• Integrated Tableau Desktop to OBIEE (Oracle Business Intelligence) to recuse the metadata layer and calculations and incorporated tableau views in OBIEE dashboards using iframes.
• Migrated data using different SSIS packages and integrated data into the data warehouse.
• Created and administered user, user groups, and scheduled instances for reports in Tableau Server.
• Extensive experience in creating dashboards using calculations, parameters in Tableau.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Prepared proof of concept for best practices in Tableau deployment.
• Integrated Python with Tableau using TabPy to gain deeper insights from the data.
• Expertise in providing business solutions by analysing various trends, risks and patterns in the data using interactive reports.
• Extensive use of advanced filters, groups, actions, complex calculations in Tableau Desktop
• Involved in integration of Tableau JavaScript API Filters in web application
• Defined best practices for Tableau report development.
• Created dashboards and reports for ad-Hoc Reporting.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Provided post implementation production support.

Environment: /Skills: Tableau (Desktop/ Server), Teradata, SQL developer, MS SQL Server, Oracle, SQL, PL/SQL, T-SQL, Teradata SQL Assistant, Python, R, Visual Basic, Toad, MS Access, Windows 2007

Confidential

Sr. Tableau Developer/Admin

Responsibilities:

• Optimized existing pivot tables reports using Tableau and proposed an expanded set of views in the form of interactive dashboards using line graphs, bar charts, heat maps, tree maps, trend analysis, Pareto charts and bubble charts to enhance data analysis.
• Built many visualizations and dashboards using Tableau Desktop and also leveraged the Data Blending aspect of Tableau to develop workbooks from multiple data sources.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Automated the entire report generation process which included steps like downloading the raw data from SharePoint (Using ODATA), data cleaning, creating dashboards and uploading the final report back to the SharePoint.
• Created presentations to communicate findings and offer recommendations to management and external audiences using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Involved in the complete migration of reports from Cognos to Tableau.
• Hands on experience in running SQL commands in the debugging context
• Used SQL stored procedures, created alias data tables as required to improve report performance.
• Extensively worked on VB to create macros for data manipulation and report generation.
• Created Stored Procedures and Views as data sources using Oracle databases for reports.
• Wrote different queries and stored procedures to make our daily data verification and conversion processes faster, more accurate and automated.
• Worked with DBMS PROFILER to tune PL/TSQL Procedures.
• Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments.
• Created Tables, Views, Constraints, Indexes and developed Complex database objects including Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL with exception handling.
• Created mockup dashboards and presented to the higher level end users to have them a look and feel of the dashboards.

Environment: and Tools: Tableau 8.x, Tableau Server, Linux, Windows 7, SQL Developer, MS-Access, MS Excel, Toad, PL/SQL, Visual Basic

Confidential

Business Intelligence Developer

Responsibilities:

• 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 and monitoring, and troubleshooting issues.
• Worked on creating Universes using the Business Objects and connected to the database using ODBC.
• Created queries for multidimensional analysis using Slice and Dice, Drill Down, Drill By and Drill Through.
• Worked on WEBI InfoView to create and modify the existing reports
• Submitted and presented the reports in user-defined formats like Tabular, Master Detail, and Cross Tab.
• Upgraded Business Objects Universes, User groups, and reports from Version 5x to 6x.
• Performed release management of Business Objects reports using Broadcast Agent Server.
• Designed, tuned and optimized the Star Schema to implement core database.
• Worked with the QA team to review the test plan and test cases for System Integration Testing and UAT.
• Generated Business Objects XI 3.1 (Webi Intelligence), dynamic report, which allows business users to select multiple dates, or range of dates.
• Created macros in Visual Basic to create automated monthly reports in MS Excel.
• Ensured projects were completed on time and within budget.
• Played key role in enhancing client's Web reporting system, reducing time of delay financial tracking analysis by 25%.
• 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.

Environment: and Tools: Windows XP, Linux, Windows 7, Business Objects, SQL Developer, MS-Access, MS Excel and SQL, Java, JavaScript, SQL, Visual Basic.