SUMMARY:

• Over 8 years of extensive IT Experience as a Data Analyst, Business Systems Analyst in Data Warehousing and Business Intelligence applications in Retail, Banking, Financial and Healthcare industries.
• Extensive experience in working with Tableau Desktop, Tableau Server, 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.
• Experience in facilitating Joint Requirement Planning sessions with Business User Groups, conducting Joint, Application Development sessions with IT Groups & Conflict Management with Project team members.
• Data blending, data preparation and SQL for tableau consumption, publishing data sources to Tableau server
• In depth understanding of the As - Is and To-Be business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
• Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.
• Developing Extract-Transform-Load process using Informatica, Data Modelling, Informatica Cloud, Informatica Connector, AWS and Amazon Redshift for Financial Reporting and Risk Analytics and Designing Risk Management plans.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source, Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based, Measures, Time series data for complex data analysis.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Good usage of Tableau JavaScript API for performance improvement of web page.
• 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 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.
• Liaison with IT and Process Subject Matter Experts (SMEs) to resolve technical bugs, system enhancements, upgrades and development for all HR Systems
• Working knowledge of performance improvement measures including aggregate tables, Indexes and Explain plan.
• Experience in writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member and individually.

TECHNICAL SKILLS:

Languages: SQL, Python, C#, ASP.Net, R programming, JSON, REST API.

Tools and Skills: SSIS, HTML5, CSS, JIRA, Angular JS, Tableau(Server, Desktop, Reports) PowerBI

Database: Microsoft SQL Server, DB2, Teradata, Oracle

Functional: Business Intelligence, ETL, SSIS, SDLC, STLC, Data Warehousing/integrity/mining/analytics.

WORK EXPERIENCE:

Tableau Developer

Confidential, Indianapolis, IN

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications
• Effectively interacted with Business Analysts and Data Modellers to define requirement document and design processes for various data sources and reporting needs.
• Built and published customized Interactive reports and dashboards along with data refresh by using Tableau Desktop.
• Created Cohort builder, Patient Viewer, Multiple myeloma dashboards for researchers, clinicians, etc.
• Created and modified some of the existing reports and dashboards
• Created Filters, Groups, Sets on Tableau Reports.
• Created, organized, customized analysis and visualized projects and dashboards to present to Doctors and Researchers.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• 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.
• Developed effective and interactive Dashboards using Parameters and Actions
• Developed donut charts for analyzing sales planning data.
• Created different KPI's using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations, aggregation options and Logical functions)
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Created demos in Tableau Desktop and published onto Tableau Server.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Deployed Tableau Dashboards and worksheets in clustered environment.
• Documented a whole process of working with Tableau Desktop, and evaluating Business Requirements.
• Provided support for Tableau training for various end users.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots and geographical maps.
• Worked on motion chart, Bubble chart, and Drill Down analysis using Tableau Desktop.
• Worked extensively with advance Analysis Actions, Calculations, Parameters, Background Images, Maps, Trend Lines, Statistics, and Log Axes. Groups, Hierarchies, sets to create detailed level summary reports and supported the reports developed and given in production support.

Environment: Tableau Desktop 10.3, Tableau server, Windows XP, MSOffice (Word, PowerPoint, Excel, Visio), Oracle, SQL Server, Teradata.

Tableau Developer

Confidential, Des Plains, IL

Responsibilities:

• Gathered user requirements, analysed and designed software solution based on the requirements.
• Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Prepared Business Requirement document and then converted business requirements into technical designs.
• Worked in Informatica Cloud- Provided a Solution to generate single view of customer with near real time capability using AWS framework.
• 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 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.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Collaborated with Payroll, Benefits, IT and other HR Departments to complete complex processes, including transfers over multiple HR platforms and off-cycle checks build dashboards for the stakeholders.
• Collaborated with IT & Payroll with selection and implementation of a new Time & Attendance and Payroll reports.
• Collaborated with IT to select, design and implement electronic recruiting process show them the trends with visualization in Tableau.
• Alteryx Data blending with multiple data sources, Tableau data objects using SQL queries. Dashboards using interactive parameters, filters, sets, charts and table calculations.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Created and assisted users in Tableau dashboard development.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• 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.
• Integration of Tableau reports with Asp.Net web applications and usage of JavaScript API for performance improvement.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Involved in testing the Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Create reports, which display the competitive advantages over its competitors.

Environment: Tableau Desktop 10.2, Tableau server, Alteryx, Redshift, SAP HANA, SQL Server 2012, HRIS, MS Access, Windows 2007 server, Teradata, MS Office 2007.

Sr. Data Visualization Developer & Data Analyst

Confidential, Walnut Creek, CA

Responsibilities:

• Created and hands on experience in Level of Detail Expressions ( Confidential ’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.
• Implemented Tableau, performed admin activities across multi-environment infrastructure.
• Interacted with SME & End Users and gathered business requirements.
• Responsible for writing Business Requirements Document ( Confidential ), Use Case Specifications, Functional Specifications Document ( Confidential ).
• Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
• Experienced working in Agile, Rally & 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.
• Understanding of and experience with real-time analytics, BI platforms and visualization tools such as Tableau and Power BI.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Converted Various Excel, Tableau and BO Reports to Power BI.
• 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.
• Experience in SQL Server 2016 like Model Data Refresh/Schedules/Jobs setup etc.
• 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.
• Created and administered user, user groups, and scheduled instances for reports in Tableau & Power BI Server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups.
• Developed effective and interactive Dashboards using Parameters and Actions. Setting the user permissions in Tableau Sever.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• 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.
• 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 informatica Alteryx workflow.
• Extensively working experience in Tableau Server Configuration/DB Connection for Oracle DB.
• Involved in integration of Tableau JavaScript API Filters in web application Excellent in Performing maintenance activities of Tableau Server incl. Backup, Logs Cleanup and Archiving Log files in prescribed intervals
• Generated Complex SSRS reports like reports using Cascading parameters, Snapshot reports Drill-down Reports, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SSRS based on Business Requirement Document.
• 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.
• 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.

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

Sr. Tableau BI Developer

Confidential, Mount Prospect, IL

Responsibilities:

• 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 ( Confidential ), Use Case Specifications, Functional Specifications Document ( Confidential ).
• Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Involved in requirements gathering, analysis, and functional specification documents.
• Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines as per project requirement.
• 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.,
• Created and administered user, user groups, and scheduled instances for reports in Tableau Server.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extensive experience in creating dashboards using calculations, parameters in Tableau.
• 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.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Prepared proof of concept for best practices in Tableau deployment.
• 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: Tableau (Desktop/ Server), Teradata, SQL developer, MS SQL Server, Oracle, SQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Windows 2007

BI Developer

Confidential

Responsibilities:

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• 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.
• 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.
• Played key role in enhancing client's Web reporting system, reducing time of delay financial tracking analysis by 30%.
• 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: Windows XP, Linux, Windows 7, SQL Developer, MS-Access, MS Excel and SQL, Java, JavaScript, SQL, VB.