SUMMARY

• Data Visualization Expert wif over 11 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms in Healthcare, Financial/Banking, Sales/Marketing, Telecommunication, Oil and Gas, Manufacturing/Retail and Pharmaceutical domains
• Expert in data visualization using Tableau Desktop/Server/online 2019.x/2018/10.x/9.x/8.x/7.x, Alteryx, and Business Objects Dashboard designer to create complex, intuitive, and innovative dashboards.
• Administered users, groups, and schedule extracts and instances for reports in Tableau Server.
• Expert in Trouble shooting, Performance tuning teh reports and resolving teh issues wifin teh Tableau server and dashboards.
• Experience in maintenance of Tableau Server, installing patches and upgrades in Tableau Server.
• Collaborate wif Business users to understand user requirements, layout, and look and feel of teh dashboards to be developed and create proof of concept / prototype teh same using Tableau desktop.
• Work closely wif stakeholders to create Business Requirement Documents (BRDs) and Functional Requirement Documents (FRD) for users.
• Involve major SDLC phases and Agile Methodology for end to end BI Application development involving Requirements Gathering, Design, Development, User Acceptance Testing, Production Deployment, Sprint based development and JIRA tracking.
• Assist users in creating and modifying worksheets and data visualization dashboards.
• Create incremental refreshes for data sources on Tableau server.
• Experience in Developing Visualizations and Dashboards from multiple data sources using Data Blending and Cross Joins.
• Experience in Tableau and Database optimization.
• Proficient in creating Calculations and formatting using Tableau Desktop.
• Proficient in design and development of various worksheets and data visualization dashboards, reports utilizing Tableau Visualizations like Bars, Lines and Pies, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables, geographic visualization and other making use of actions, other local and global filters according to teh end user requirement.
• Extensively work on development of Web Intelligence, Desktop Intelligence Reports, Crystal reports, Xcelsius and Dashboard Designer.
• Provide user interface (UI) design for Web - based projects, including dashboards, widgets, and products.
• Conduct and perform analytical studies of data content and interactions wif existing data.
• Experience using BI tool link OBIEE & QlikView
• Database experience in Oracle 12g/10g, My SQL, MS Access, MS-SQL Server 2014/2012/2008, Teradata, DB2, Netezza, PostgreSQL.
• Proficient in performance analysis, monitoring and SQL query tuning in Oracle and SQL server.
• Work on Data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files using Informatica Power Center.
• Excellent communication, interpersonal and analytical skills wif ability to manage and work TEMPeffectively.
• Experience leading onshore and offshore teams.

TECHNICAL SKILLS

BI Tools: Tableau 2019/2018/10.x/9.x/8.x, Microsoft Power BI, SAP Business Objects Webi, Crystal, Xcelsius, Oracle OBIEE

Languages: SQL, PL SQL, Stored Procedure, Hive QL, Python, R, JSON, UNIX Shell Scripting, Tab PY

Databases: SQL Server, Oracle, MY SQL, Teradata, AWS, Sybase, MS Access, Apache Hive, Azure

SDLC Applications: JIRA, Version One, TFS, Microsoft Office, SharePoint

ETL/Data Modeling: Informatica, Alteryx, Tableau Prep, Data Stage

Domains: Healthcare, Financial, Investment, Telecommunication, Oil & Gas, Retail

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 teh 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 teh 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 wif multiple measures.
• Working extensively wif 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 teh 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 teh user and adding them in to tableau server.

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

Confidential, New York, N.Y

Senior Tableau Developer/ Data Visualization Expert

Responsibilities:

• Analyze and understand teh process flow to provide solution for teh proposed requirement change.
• Provide fix for a dataflow which was successfully implement and accept by teh business Responsible for interaction wif business stake holders, gathering requirements and managing teh delivery, covering teh entire Tableau development.
• Design standardize DataMart wif aggregated data, calculated metrics to suffice teh source data need for various Tableau Reports and work wif ETL developers, DBAs, Data Modelers to implement teh same in Development, Test and Production environment.
• Data wrangling and manipulation using Alteryx and Tableau Prep.
• Develop mockups dashboards using Tableau to present teh data wif excellent visualization and got teh approval from users.
• Extensively involve in creating graphs and charts by using measures and dimensions data from various databases by using joins and blending Writing various queries to pull teh data required to verify teh Metrics calculations form backend.
• Expert wif use of action filters, user filters, advanced navigation techniques, Level-of-Detail
• (LOD) expressions Performed rigorous unit testing for teh code change in development and stage environments.
• Create Relationships, actions, calculated fields, sorting, groupings, live connections, in-memory in both tableau and Excel.
• Involve in Trouble Shooting, Performance tuning of reports and resolving issues wifin Tableau
• Server and Reports by coordinating wif senior managers in emergency.
• Give training/demos to users on Tableau Desktop for development.
• Granting Permission to User's and maintaining teh User List and updated Server Architecture for scheduling Tasks.
• Analyze and resolve key performance and server-based issues on regular basis.
• Document interactive dashboards by combination of views and reports and created crosstabs, conditional, drill down, summery, sub reports, parameterized.
• Conduct data analysis using interactive Excel features.
• Lead COVID 19 Data Architecture Design project.
• Evaluate database performance issues and executed database optimization.
• Develop SQL scripts to create database objects like Tables, Views and Sequences and created PL/ SQL Procedures, Functions and Packages.

Environment: Tableau Desktop/Server, SQL server, Python, Azure Alteryx, JIRA, Web Data connector

Confidential, Long Island City, NY

Senior Tableau Developer

Responsibilities:

• Analyze business user requirements, participate in sessions wif teh clients, project stakeholders, users, SME’s, development and testing team to get better understanding of teh requirements and functionalities, analyze data and built interactive analytical views utilizing appropriate charts that answer teh business problem.
• Create consumer lending KPI dashboards to display loan conversion rate to measure teh efficiency of managing teh pipeline.
• Handled, prioritized, and problem solved multiple task connected to multiple projects at one time.
• Develop Credit risk dashboards to display concentration analysis, % utilizations, risk factors on default loans, return on assets, return on equity etc.
• Design wireframes, dashboard templates as per teh requirement wif tabular reports, bar charts, waterfall charts, Gantt charts, Bubble charts, Word maps, Geospatial visualizations etc.
• Create Calculate sets, parameters, action filters and URL actions to provide drill-down /summary to detail analysis. Created complex c calculations such as string manipulation, arithmetic calculations, custom Aggregations and Ratios. Used data blending to bring data from multiple sources.
• Used Tableau Data Extracts for improve performance. Use Performance monitoring tool of tableau desktop to analyze teh performance of data heavy dashboards and implemented teh best practices to optimize dashboards for a better user experience
• Utilize Tableau server to publish and share teh reports wif teh business users.
• Assist BI Center of Excellence (COE) team to critique, review and certify tableau dashboards to make go/no go decisions for production deployments.
• Use web data connectors to bring data in Tableau from various websites and perform Predictive analysis by using Tabpy.
• Define and Design teh Tableau architecture, Security, environment set up and deployment process.
• Define best practices for Tableau Report development by adhering to style guidelines and making visual pop-out.
• Work wif Business Analysts to streamline any data issues which involve Unit Testing of all teh Worksheets.
• Use Alteryx to perform data manipulation/data modeling for Tableau presentation layer.
• Connect to Alteryx workflows to work around existing tableau extract model to optimize performance
• Cleanse/Massage existing data wifin Alteryx workflows by asserting data integrity
• Use Alteryx macros to implement transformations and create custom columns for direct use wifin Tableau reports

Environment: Tableau Desktop/Server, Oracle, SQL server, Python, AWS, Alteryx, JIRA, TabJolt, Tabadmin, AWS

Confidential, Baskin Ridge, NJ

Sr. Tableau Developer/Analytical Consultant

Responsibilities:

• Involve in teh solution scoping of teh project.
• Organize workshop sessions to gather business requirements (blue printing) from teh business users.
• Build Strategic, Analytical and operational dashboards using Tableau.
• Tableau server maintenance, Tableau server backup activity. Consolidate multiple data silos that exist on campus to one location and Scheduled data extracts daily.
• Environment Support to User community, Service Request & Resolution. Also, Expertise in failed over activities in production Environments.
• Create users’ filters and assign appropriate roles to users in Tableau Server.
• Deploy Dashboards from Dev to QA and QA to Prod.
• Sophisticate stored procedures and triggers to provide complete technical solutions. Participate in test planning and test script definition. Resolve end user reporting problems through collaboration wif IT and Operations.
• Developing various tableau dashboards prototype for teh future uses and conversion of current excel reports into tableau.
• Implemented row level security for teh Tableau dashboards and used various advanced table calculations for teh dashboards.
• Collaborated wif team members to streamline and continuously improve reporting solutions. Generated visualization adhoc reports using Alteryx and SSRS.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and Teradata.
• Created stored procedures, user defined functions, views, tables and T-SQL scripting for complex business logic.
• Cleaned data source in SQL Server and prepared data source in Tableau metadata using complex joins, Custom SQL, split and data blending.
• Designed, developed and maintained daily, weekly, monthly and year-end summary, trending and benchmark reports repository in Tableau Desktop.
• Generated complex calculated fields and parameters, toggled and global filters, dynamic sets, groups, actions, custom color palettes, statistical analysis to meet business requirements
• Implemented visualizations and views including combo charts, stacked bar charts, Pareto charts, donut charts, geographic maps, spark lines, crosstabs etc.
• Defined visualization pixels and created dashboards using vertical/horizontal containers and collected dashboards in Tableau Story Tableau dashboards embedding into Salesforce for teh continuous data experience for teh users.
• Clone visualization from BI tool OBIEE & QlikView to Tableau
• Built custom tableau dashboards for teh Salesforce for accepting teh parameters from teh Salesforce to show teh relevant data for that selected object.
• Connecting and extraction to different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on teh tableau server machines.
• Developed tableau dashboard landing page for teh embedding into Salesforce to provide integrated views and navigation inside Salesforce for teh users.
• Developed various dashboards for non-Salesforce group of users for their specific goals of understanding data.
• Tableau administration and development roles and helping teh client wif teh issues of data connections, extraction and maintenance.
• Tableau server and desktop upgrade from 9.3 to 10.3.

Environment: Tableau Desktop/Server (9.x/10.x), Alteryx, MS Office Suite, SQL Server, Oracle, Python, Salesforce, DB2, SharePoint, AutoSys, MS Excel

Confidential, Houston, TX

Tableau Developer/Data Analyst

Responsibilities:

• Implement Tableau BI Dashboard reporting solution for different Stakeholders in teh organization and Publish Dashboards onto Tableau Server.
• Create calculate fields using Tableau for implementation of color coding and proper aggregations for data coming from Oracle.
• Create extensive joins for data blending from several different data sources.
• Create Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Work extensively wif 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 Tableau Desktop.
• Create organized, customize analysis and visualized projects and dashboards to present to Senior Level Executives.
• Introduce several Levels of Dashboard Drill Down and Links to interrelate performance metrics.
• Create and assist users in Tableau dashboard development.
• Work wif production team to implement UI and create enhancements to optimize user experience.
• Administer and provide production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Work wif business analysts, interpret business requirements that users look to dashboards to answer, and create server-based Tableau dashboards wif automatic updates.
• Leveraged advance features of tableau such as calculate fields, parameters, and sets to support data analysis and data mining.
• Created several dashboards wif various chart types such as stacked bar charts, scatter plots, heat maps, and text tables that demonstrated insightful trends over a period.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Tested Dashboard for data accuracy and Functionality.

Environment: Tableau Desktop/Tableau server, Informatica Power Center 9.5, PostgreSQL, SQL Server 2012, MDX/T-SQL, MDX Studio.

Confidential, Rosenberg, TX

Tableau Developer

Responsibilities:

• Set up profiles and create publications to distribute reports to users.
• Create graphical representation of reports such as Bar chart, Pie chart etc. as per teh end user requirements.
• Organize data in teh report Inserting Filters, Sorting, Ranking and highlighting data.
• Conversion of BO reports to Tableau
• Wrote complex SQL queries to fetch teh data from Oracle, MS SQL Server and Created teh Tableau worksheets, dashboards.
• Maintain permissions of Tableau Views and Dashboards.
• Extensively work on parameters, Pareto charting, mapping, calculations, demographics and geographic fields.
• Work wif string functions, date calculations and swapping dimensions wif parameters.
• Work creating Aggregations, calculate Fields, Table calculations, Totals, percentages using Key Performance Indicators (KPI) and Measures.
• Responsible to work wif Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Used in depth features of Tableau like Data Blending from multiple data sources to attain data analysis.
• Involve in generating dual axis bar chart wif multiple measures and data blending in case of merging different sources.
• Writing custom SQL quires to limit teh data source into tableau thus improving Tableau performance.
• Integrating interactive location maps wif teh data analytics based on various filters and actions.
• Fixing defects logged in JIRA by QA and UAT team.
• Resolved teh incidents and requests raised by teh end-users.

Environment: Tableau Desktop, Tableau Server, SAP Business Objects, Oracle, Composite, SQL Server.

Confidential, New York, NY

Business Intelligence Developer

Responsibilities:

• Interacted wif teh Business analyst and teh Manager in gathering teh business requirements to design and develop reports.
• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications to generate teh Reports.
• Created universes, classes, objects, complex measure objects, prompts, pre-defined conditions.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked teh Integrity of teh Universes.
• Define Hierarchies in Universe to provide teh users wif Drill down option in reports and Predefined Conditions to use in Business Objects.
• Created Prompts, conditions and Filters to improve teh report generation. Also used Alerts to improve teh readability of teh report.
• Design and develop Xcelsius Dashboards on top of QAAWS
• Create link reports to suit business needs.
• Applied slice-and-dice, drill-up and drill-down techniques in master detail reports
• Created graphical representation of reports such as Bar chart, Pie chart etc. as per teh end user requirements.
• Organized data in teh report Inserting Filters, Sorting, Ranking and highlighting data.

Environment: Business Objects, SQL Server, T-SQL, Windows Server, HTML, SharePoint, VISO

Confidential, New York, NY

Business Objects Developer

• Gatheird Business Requirements, interacted wif teh Executive Directors, Project Manager and SMEs to get a better understanding of teh Business Processes.
• Created teh reports on teh web by using Web intelligence.
• Created new classes, objects and made structural changes to Universes in Designer which includes adding new objects, updating tables and joins.
• Used Crystal Dashboard design and Crystal Presentation Design (both in-built templates and customized templates) to transform complex data in a more consolidated and powerful interactive dashboards.
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @Functions and more.
• Involved in teh troubleshooting of universe schema wif loops, chasm and fan traps, and cardinality problems.
• Worked closely wif end users in identifying and implementing right set of business criteria to convert raw data into meaningful information.
• Collaborate wif business leadership to identify potential areas of analysis
• Develop, Organize, manage and maintain graphs, tables and document templates for teh efficient creation of reports.
• Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• Found efficient ways to make tables and graphs that were visually easy to understand and at teh same time maintaining teh accuracy of teh core information content.
• Produced databases, tools, queries, and reports for analyzing, summarizing, and root causing board failure data. Versed in finding patterns and trends in complex, multivariable data sets
• Participated in teh retrospective meetings and next sprint planning meetings.

Environment: Business Objects Webi, Crystal report, Xcelsius, SQL Server 2005, UNIX, Microsoft Office Suite (Word, Excel, and PowerPoint).