SUMMARY

• Over 9 years of work experience as Data Visualization consultant, Senior Tableau Developer/Admin, BI Analyst, Analytical consultant, and Regional Business Intelligence developer with fortune Corporates, Public and Private Companies, international companies, private businesses and consulting firms in the areas of Business Intelligence, Visual Analytics, Data Warehousing, Data Management, Project Cycle Management, Consulting, Audit and Planning (Strategic and Operational).
• Strong technical background and experience in Data Visualization using TABLEAU 8.x and higher (DESKTOP / SERVER). Extensive experience in creating extracts (TDE), tuning existing extracts, publishing and working with TDEs published to Tableau server.
• Hands - on experiences in designing and implementing data pipelines for Tableau reporting, integrating Tableau technological suite with other UI/UX applications and workflows, and developing Storyboards and Dashboards using Tableau Desktop.
• Skill in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot tables, scatter plots, pie charts and packed bubbles and use multiple measures for comparison such as Individual Axis, Blended Axis, and Dual Axis.
• Strong ability to design and deploy rich graphic visualizations with Drill Down and Drop-Down menu options and Parameterization using Tableau.
• Create customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and Tableau.
• Extensive experience using python and R integration with Tableau to create predictive models.
• Proficient in writing complex SQL queries, scripts in Python & automating the data pulling from multiple sources by creating Alteryx workflows.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleaning and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Experienced using various data source such as, SQL Server, Oracle, Teradata, My SQL, DB2, Flat files, AWS, Big data platforms, Web Data Connectors and SAS files.
• Intensive experience working in all the phases of the projects such as, Analyzing, Requirement gathering, Development, QA and Deployment in Agile Methodology.
• Extensive experience training end users and self-servicing the solutions.
• Experience working with Off Shore Team
• Excellent communication, interpersonal and analytical skills with ability to manage and work effectively to meet deadlines in fast paced environment.

TECHNICAL SKILLS

Dashboarding/Reporting Tools: TABLEAU Desktop/Sever/Online 2019/2018/10. x/9.x/8.x/7.x, Power BI, Business Objects Webi, Crystals, Dashboard designer, Xcelsius, Google Analytics, Adobe Analytics

Databases/ Data Sources: SQL Server, Oracle, DB2, My SQL, Teradata, Apache Hive, Hadoop, Postgre, AWS, Flat Files, Web Data Connector, SAS

Industries: Health Care, Financial/ Banking, Supply Chain, Taxation, Retail, Telecommunication, Sales and Marketing

Languages: SQL, T- SQL, PL SQL, Stored Procedure, HiveQL, Python, R, JSON, Java

Data Modeling Tools: Alteryx, Tableau Prep, Informatica

Data warehousing: Star Schema, Snow Flake Schema, SCD Type 1/2/3, Normalized Schema, Conformed Dimension

Methodology: Agile, waterfall

Others: JIRA, TFS, Version One, SharePoint, ALM, Microsoft Office

PROFESSIONAL EXPERIENCE

Confidential, Port Washington, New York

Senior Tableau Consultant/ Data Visualization Consultant

Responsibilities:

• Design validate and implement Tableau Technological suite deployment and support applications within the price and promotion department.
• Design and implement Tableau reporting infrastructure and integration with other applications for enhanced UI/UX experience using Tableau workbooks and data source deployment.
• Provide recommendations with respect to cloud migrations and prepare technical implementation roadmaps for AWS and Databricks platform adoption.
• Create functional design specifications, reference architectures, and assist with other project deliverables as needed. Facilitate offshore functional clarifications.
• Build and implement a workflow that integrates Stash and Tableau Server by triggering Jenkins builds, Databricks notebooks and using curl command and Tableau REST API.
• Coordinate and provide guidance between Product Owners and the Tableau Technical team offshore and onsite. Ensure that best practices & methodologies are followed.
• Partner with application mangers and developers to ensure projects meet end user requirements and are completed successfully.
• Compile and present updates for projects and key initiatives, such as milestones and percent complete client management with respect to Tableau reporting.
• Provide end user documentation, training, implementation coordination, and post implementation support on Tableau reporting as needed.
• Design, develop, document and unit testing of BI Reports using Tableau.
• Design, validate and implement state-of-the-art technical solutions on AWS and Databricks (Big Data) platform that address customer's requirements for scalability, security, and performance.
• Design and implement the report development environment and infrastructure.
• Ensure code migration from development to QA and design and implement release activities.

Environment: Tableau, Power BI, Python, AWS, Hadoop, SQL Server, Jira

Confidential, New York, N.Y

Senior Tableau Consultant/ Analytical Consultant

Responsibilities:

• Analyze data and develop Tableau dashboards from multiple sources such as Google Analytics, Adobe Analytics, external marketing data, and sales data to formulate and develop insights used to grow revenue and profit within the sales/marketing organization.
• Regularly generate insights by analyzing actual business performance versus targeted business performance.
• Gather Business requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Create views/reports in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Work in the application UI to present to the end users with Tableau dashboards and visualizations in multiple platforms.
• Create customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle, Hadoop and performing data blending in reports.
• Work extensively in documenting the Source to Target Mapping documents with data transformation logic
• Perform Python and R integration in Tableau for statistical analysis.
• Use Google and Adobe analytics data to build the dashboards in Tableau for enterprise website analysis.
• Use Data Blending and combined Adobe Marketing Cloud data with other aggregated data, to compare and analyze data in different perspective using Alteryx.
• Develop Alteryx modules for big data analysis of geospatial information and SQL queries
• Write SQL code with multiple joins to pull the data from multiple Oracle Database. Optimized and automated the query in Alteryx.
• Perform extensive task in excel such as Pivots, Vlookup, conditional formatting and data manipulation and cleaning for large number of data set.

Environment: Tableau Desktop/ Sever 2019.x, Adobe Analytics, Google Analytics, JIRA, SharePoint, SQL Server, Teradata

Confidential, New York, N.Y

Senior Tableau Developer

Responsibilities:

• Gather requirement and developed Tableau visualizations using Tableau Desktop and published on the server for the business user.
• Create dashboards by extracting data from various sources using parameters, sets, groups and calculations.
• Develop interactive dashboard and applied actions (filter, highlight and URL) to dashboard and created calculated fields, mapping, hierarchies and drilling through reports in dashboard.
• Build complex calculations using advance functions (ATTR, LOD, DATEDIFF, Ifs, Nested Ifs, RANK DENSE, OR, NOT, AND, and Quick Table calculations).
• Use Python integration in tableau using Script bool, Script Int, Script real and Script string and performed Statistical/predictive analysis.
• Develop Charts like, Bar over bar, Butterfly chart, Donut Chart, dual-axis bar chart with multiple measures and data blending in case of merging various sources.
• Use Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Perform extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Use Web data connector and developed Tableau dashboards using various websites based on Json and HTML.
• Perform Python and R integration in Tableau to perform Predicative and Statically analysis.
• Create Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Optimize Tableau dashboards by improving performance in Tableau and Data base side.
• Perform Tableau Administrative Task such as, Scheduling, Permission, Deployment, Creating Extracts, User Filters and Deployment.

Environment: Tableau 2018/10.2, Python, Unix & Microsoft Windows, SAS, Teradata, Oracle, Apache Hive, Power BI Hadoop.

Confidential, New York, N.Y

Senior Tableau Developer/Analytical Consultant

Responsibilities:

• Create Interactive views in Tableau Desktop and published to internal team for review and further data analysis and customization using filters and actions.
• Identify the business function activities and processes, data attributes, and table metadata, and documented detailed design specifications
• Create Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time.
• Gather requirements for application and converted their requirements into project plan and developed flow charts for conversion of data from SAS to Oracle.
• Generate leads targeting specific customers as per business user requirements submitted by various departments.
• Extract and sorted data from various databases like Oracle, DB2 and MS Access using SQL and Alteryx.
• Use Alteryx to massage and manipulate data for Tableau reporting.
• Call Python functions in Tableau using Script Bool, Script Int, Scipt Real and Script Sting.
• Ensuring that manually updated dashboards are published on daily, weekly and monthly basis for use by the sales and marketing organization.
• Identifying and develops system and/or applications in conjunction with IT to aid in the reporting and processing of data.
• Use Web Data Connector to bring data in Tableau from Various web sites.
• Successfully increase portability of existing SAS programs and created new programs using SAS macro variables to improve efficiency and consistency of results.

Environment: Tableau 8.x/9.x, Unix & Microsoft Windows, Alteryx, Jira, SharePoint, AWS, Teradata, Oracle, DB2.

Confidential, Morris plains, N.J

Senior Tableau Developer/Data Visualization Developer

Responsibilities:

• Create relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel.
• Create customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and Tableau.
• Involve in creating views, stored procedures, and custom SQL queries to import data from SQL server to Tableau.
• Create Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, Publish on Tableau Server for usage with Operational or Monitoring Dashboards.
• Review the Server logs on the local and server repository for any errors or security issues that are unexpected.
• Review the performance metrics to determine if the baseline exceeded or for the slow points during the day that need to be reviewed.
• Create Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Work on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Review basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Environment: Tableau, Dashboard designer, Unix & Microsoft Windows, DB2, Oracle, Cloudera Hadoop.

Confidential, Morris Town N.J

Tableau Developer/BO Developer

Responsibilities:

• Gather requirement and created a meta data layer using UDT.
• Convert Xcelsius dashboards to Tableau dashboards.
• Participate in JRD meetings for analyzing business requirements and facilitating planning and implementation phases of the data mart
• Successfully maintain referential, domain, and column integrity utilizing available options
• Contribute in developing logical and physical data models using the Erwin data modeler tool.
• Design critical staging procedures to load data marts and report databases with multiple features
• Develop complex SQL queries using scalar and table variables which held user inputs and performed business logic
• Establish transactions with multiple isolation levels and locks technique to avoid dirty reads and deadlocks
• Participate in optimizing SSIS packages with non-blocking/synchronous transformations and task/transformation properties
• Utilize Tableau to implement calculations, groups, hierarchies, and sets to design attractive dashboard for analysis.
• Prepare dashboards and worksheets utilizing different types of filters, charts and calculated sets in Tableau.
• Publish and shared the reports with users and end-clients utilizing Tableau server.
• Supervise the maintenance of different versions of documents, scripts and reports on Team Foundation Server (TFS).

Environment: Tableau, Webi, Crystal, Xcelsius, Dashboard designer, Oracle, UDT, SharePoint.