SUMMARY

• Data Visualization Consultant/ Tableau expert with over 10 years of experience working with BI applications using SSRS, Tableau, Power BI, Alteryx and Tableau prep in various industries such as Banking/Financial/Investment, Pharmaceutical, Healthcare, Retail, Manufacturing and Insurance.
• Expertise building custom visualizations and creating predictive models in Tableau using Python and R. Extensive experience in end to end implementations.
• Experience training end users, gathering requirements and self - servicing solutions for the users.
• Proficient working with various data sources such as RDBMS, Cloud, Cubes, Bigdata and Flat files.
• USC available Immediately for a new role. Willing to relocate anywhere in United States.

TECHNICAL SKILLS

OLAP/DSS Tools: Tableau Desktop/Server/Online 2019.x/2018.x/10.x/8.x/7.x, Power BI, SSRS

RDBMS: Oracle, DB2/400, MySQL, SQL Server, MS Access, Teradata, DB2.

Big Data: Hadoop, Hive, MongoDB

Cloud: Sales Force, AWS, Power BI online

Data Modeling Tools: Informatica Power Center 9.5, Alteryx, Tableau Prep

Languages: Python, R, T-SQL, PL/SQL, Stored Procedure, SQL, Hive QL

Operating System: MS-DOS, Windows, UNIX, HP- UNIX, Sun Solaris.

Web Technologies: Google Analytics, Adobe Analytics

Data warehousing: Normal forms (OLTP), Star Schemas (OLAP), Snowflake Schemas, and slowly changing dimensions.

Others: Report Tuning, Data mining, Free-hand SQL, Data Analyzation, JIRA, SharePoint, Version One, ALM, Microsoft Word, Power Point, Excel, Access and Outlook.

Industries: Financial, Banking/Investment, Health Care, Aerospace, Pharmaceutical and Manufacturing.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior Tableau Developer/Data Visualization Consultant

Responsibilities:

• Developing multiple dashboards including Product Quality, Right First Time, Capacity Tracker, Gap Pack Tracker, Completion Tracker to track the quality of customer-on-board process
• Hosting daily meetings and gathering business requirements from different groups of users and made sure dashboards meet all requirements
• Utilizing SQL and Tableau Prep to clean data as per data mapping documents and data dictionary requirements
• Extracting columns from multiple sources and applied joints and unions to add more dimensions to reports
• Deploying reports onto the server for different teams and set security level for different reviewers
• Pivoting data columns for enhancing calculation results
• Creating LOD calculation, parameters-based calculation in Tableau.
• Creating Geographic map, donut charts and dual axis bar chart with multiple measures.
• Working extensively with Advance analysis dashboard Actions, passing parameter in URL action, Trend Lines, Groups, hierarchies, sets to create detail level summary report and Dashboard using Tableau's Advanced Capabilities.
• Creating the Top N’s and others detail view.
• Built as-hoc and dynamic dashboards that contained relative actions of combination charts, bar charts, donut charts, line charts, tables, parameters, multiple filters, etc
• Handling large volumes of data around 40 million records in tableau.
• Involving tableau admin tasks such as Setting Permission, managing ownerships, providing access to the user and adding them in to tableau server.

Environment: MS SQL Server 2012, SQL, Tableau Prep, Tableau 10.x/2019.x, Tableau Server, MS Excel, MS Access, MS Word

Confidential, Clinton, NJ

Senior Tableau Developer/ Da ta Visualization Expert

Responsibilities:

• Actively participated in the IT department and supported the financial risk management team to analyzing suspicious transactions, fraud rates, and loan/credit performances by delivering Tableau reports
• Intensive development of views and dashboards using Tableau analytical tool, including rate of fraud, fraud clause of bank, default rate, performance of credit/loan given, etc.
• Developed the reports by combining different source files in database structure from UAT database source and QA data source
• Wrote complex customized SQL queries to enhance date functions and built the year-over-year reports and month-over-month reports
• Extensively applied sum and count distinct functions
• Engaging in BI workflows from importing data source to data mapping process, and then to the design stage, and finally to dashboard building process
• Designing customized queries in Tableau and handling the null/empty values in the Tableau to ensure the data to be accurate to use
• Attending daily discussion with teammates and managers to design reports and to dig information from tables
• Efficiently communicating to the managers about constraints of Tableau to improve report efficiency
• Implementing Tableau functions including views, interactive dashboards, action filters, parameters, and calculated fields when designing KPI reports
• Extensively used grouping, sets, parameters to handle views
• Executing type conversion functions in Tableau connected relational data sources
• Deploying the reports to the QA server after managers confirmed the accuracy of demo’s contents, formats and coloring; Applying the active users and open cases filters before publishing
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.

Environment: MS SQL Server 2012, Tableau 10.0, Tableau Server, MS Excel, MS Access, MS Word

Confidential, New York, NY

Senior Tableau Developer

Responsibilities:

• Interacting with the customer service team; reviewing and analyzing the business requirements and various data sources in order to design, develop, test and produce the reports in Tableau Desktop and Server
• Creating reports of customer profile analysis, customer satisfaction rate, product profile performance report to support the customer service team analysis
• Creating heat map by color, broken into age groups, salary groups, job category groups, and allowing business analysis team to understand customer groups difference
• Extracting data from different data sources including excel files, flat files, and T-SQL Server
• Designing the customized queries to blend and join tables together, using filter functions to reduce the data loading size and to ensure the accuracy
• Performing calculated fields, mapping and hierarchies to design the report
• Creating users filter to show the specific customer or specific product performance
• Applying Geo Maps, Heat Maps, Drill through, Drill down reports functionality
• Developing a dual-axes bar chart with multiple measures, creating donut charts and pie charts for better visualization
• Developing storytelling dashboards in Tableau and publishing them on Tableau Server allowing business users understand data and constructed quick filter for on demand needed information
• Creating comments and captions of the analysis to better explain the reports
• Deploying the reports to report server in time to ensure the efficiency of the analysis

Environment: Tableau 9.0/9.1, SQL Server Reporting Services (SSRS), T-SQL, Microsoft Excel 2010

Confidential, Memphis, TN

Tableau Analyst/report developer

Responsibilities:

• Gathering Business Requirements, interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Working extensively in documenting the Source to Target Mapping documents with data transformation logic
• Maintaining and Installing Tableau Server in all the environments.
• Preparing quarterly forecasts, annual budget, ad-hoc reporting and management reporting using Hyperion Interactive Reports and Financial Reporting Studio.
• Performing data analysis and data profiling using SQL on various sources systems including Oracle and Teradata.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
• Securing Tableau server to protect the Tableau environment, security group and AWS Direct Connect.
• Working in the application UI to present to the end users with Tableau dashboards and visualizations in multiple platforms.
• Effectively using data blending feature in Alteryx to combine the data from different sources like SAP Lynx, Vision etc. into a single report.
• Using Data Blending and combining Adobe Marketing Cloud data with other aggregated data, to compare and analyze data in different perspective using Alteryx.
• Developing Alteryx modules for big data analysis of geospatial information and SQL queries
• Expertise in writing JavaScript for advanced sorting and hide and show Reports.
• Designing, developing, testing, and maintaining Tableau reports and dashboards based on user requirements.
• Wrote SQL code with multiple joins to pull the data from multiple Oracle Database. Optimizing and automating the query in Alteryx.
• Developing Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx from multiple data sources and customized data.
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate Permission sets for Tableau server logins.

Environment: Tableau 10.5/10.x/9.x (Desktop/Server), Erwin9.1, Hyperion, Teradata, Teradata SQL Assistant, Oracle 11g, Big Data/Hadoop, VISIO, JIRA, SAP HANA, SAP BW, SAS, Alteryx, JavaScript, MS Office Suite (Word, Excel, PowerPoint).

Confidential, Raleigh, NC

Tableau Developer / Data Analyst

Responsibilities:

• Overseeing the performance of Design to develop technical solutions from Analysis documents.
• Analyzing the source systems and creating Business Requirement Document (BRD).
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XLS.
• Extracting digital marketing data from Adobe Marketing Cloud in Tableau Data Extract (TDE) format by connecting to Adobe Site Catalyst for developing Business Intelligence dashboards.
• Using Data Blending, Groups, combine Adobe Marketing Cloud data, aggregated data, spotlight into compare, and analyzing data in different perspective.
• Creating best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Designing and developing Tableau visualization solutions by connecting to Google Analytics, Oracle and SQL databases.
• Developing custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations.
• Involving in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins and security checks.
• Designing and developing trend reports including forecast and trend lines.
• Configuring incremental data refresh for the data sources.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Responsible for authorizing the users based on their privileges.
• Involving in migration activities related to Tableau across the environments.
• Establishing, maintaining and ensuring adherence to application standards for data reporting.

Environment: Tableau 8.x (Desktop/Tableau server), Splunk, Google Analytics, SQL developer, SQL 2008, Oracle, MS Access, Windows 2007 server, Java 1.5 platform, Microsoft office Suite (Office, Excel, PowerPoint) 5+.

Confidential, Louisville, KY

BI Developer / Data Analyst

Responsibilities:

• Acting as liaison between Business Intelligence and Business User groups to relay change requests.
• Conducting Requirement walk-through meetings with key stakeholders.
• Performing detailed requirement analysis and created data mapping documents
• Performing extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Overseeing the performance of Design to develop technical solutions from Analysis documents.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Mentoring business power users to create BI reports/dashboards using SSRS.
• Designing and developing various analytical reports from multiple data sources by blending data on a single worksheet in Xcelsius.
• Creating, modifying Interactive Dashboards, and Creating guided navigation links within Interactive Dashboards.
• Built complex SQL queries to validate ETL/Reporting code in Teradata and Oracle.
• Monitoring the project during Development phase and involved in User Acceptance testing (UAT) once the change requests are released from system testing.
• Developing test cases and test plans for unit and system tests for new or modified programs and job streams.

Environment: Tableau Desktop/Server, Teradata 12/13, Oracle 10g/11g, Informatica 8/9, Power Designer, TOAD, MicroStrategy 8/9, Autosys, UNIX, MS VISIO, MS Office.