SUMMARY:

• Over 10+ years of professional experience in Development, requirement gathering, Analyzing data and deployment.
• Over 6+ years of Experience in Tableau Desktop/Server, creating highly interactive Data Visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.
• Extensive experience in creating and implementing effective strategies/solutions for developing Business Intelligence/Data Warehousing (BI/DW), Client/Server applications, aspects of Database Management Systems, development and complete Project Life Cycle in Data Warehousing.
• Extensive Experience performing Statistical Analysis using Python and R integration with Tableau.
• Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• Utilized all Tableau tools including Tableau Desktop, Tableau Public/Online/Server, and Tableau Reader.
• Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth.
• Experience in Tableau Server configuration, creating Users, Groups, Projects and assign Privileges etc.
• Experience in configuration and administration of Tableau Server in a multi - server and multi-tier environment.
• Experience interacting with power user community to understand and document requirements.
• Extensive experience on building dashboards in Tableau and involved in Performance Tuning of reports and resolving issues within Tableau Server and Reports.
• Experienced in writing complex SQL scripts and queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports.
• Experience in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Informatica and Alteryx.
• Experience in Alteryx server installation and development of complex workflows.
• Extensive knowledge in Dimensional data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling.
• Used Alteryx to create workflows and generate predictive, statistical results by combining data.
• Experience in Configuring and Managing Linked Servers, Data transfer between SQL Server and other Heterogeneous Relational Databases such as Oracle and DB2.
• Worked with improving the performance on SQL, TSQL and SSIS procedures and provided the output to tableau for creating dashboards
• Extensive Experience in working with Agile Methods like Scrum, Open Agile, and Lean.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design.
• Capacity to work independently and effectively on a variety of tasks at the same time.
• Strong Analytical Skills and excellent verbal and communication skills.

TECHNICAL SKILLS:

• SQL, T: SQL, PL/SQL, Stored Procedure, Python, R, Hive QL, ANSI 89/92
• Databases: SQL Server, Oracle, Amazon Redshift, Postgres, MySQL, Various Cloud Technology, Aveva Database
• Operating Systems: Windows Server, Windows UNIX
• ETL Tools: Alteryx, Informatica, SSIS, Import/Export Wizard, BI Studio
• OLAP Tools: SSAS, MS Excel, Toad, SSMS, Query Analyzer, Bex designer, SQL Developer.
• Reporting/Dashboard Tools: Tableau, Alteryx, Xcelsius, SSRS, MS Excel, Webi, Crystal, Dashboard designer, SAC
• Business Tools: Word, Excel, PowerPoint, Access, Outlook, SharePoint, Jira
• Source Control: Team foundation Server 2010, Visual source safe (VSS)
• Data Modeling: Normalization, Denormalization, Star Schema, Snow Flake Schema, SCD Type 1/2/3

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Lead Tableau Developer / Data Visualization Expert

Responsibilities:

• Lead the off shore and on shore development team.
• Using POS dataset to create dashboard for the sales teams.
• Create work flow in altreyx to bring data from different sources to one source to create reports.
• Collected/gathered status of on shore and off shore tasks, worked with developers on any blockers and updated management on the project progress
• Insured the development is done in the timely manner within a given sprint without having to carry over the tasks to next sprint.
• Also worked with stack holders on backlog items and made sure those items are assigned to appropriate manner.
• Building executive level dashboards for CFOs and CEOs.
• Gathered and analyze the business requirements and then translate them to technical specifications.
• Created governance dashboard for tableau assets.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Responsible to Create Dashboards for compliance reports, treasury reports, Daily P&L reports for Client and internal management using Tableau Desktop and Server.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided Analytics, Interactive dashboard design and Visual best practices.

Environment: Tableau Desktop 9.1/10.5, Tableau Server, Oracle, Tab Jolt, MySQL, Hadoop, Cloud database, Salesforce, Microsoft PowerPivot, Pivotal HD, HDFS, Microsoft SQL server 2012, MS Excel/Access, Windows 8.

Confidential, New Jersey, NJ

Lead Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Designed, fulfilled and Deployed Tableau architecture.
• Developed the weekly status reporting for the management for project/tasks
• Also estimated each task, worked with product owner to ensure the story line and the tasks are approved before the project starts.
• Additionally, worked other developers by balancing the workload assigning sub tasks if necessary and break the tasks into multiple tasks.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL
• Server for design, development, Performance testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views/reports in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that was broken into regions allowing business user to understand where we have most users vs. least users.
• Worked closely with business power users to create reports/dashboards using tableau desktop.

Environment: Tableau 2018, Tableau server, SQL Server, Alteryx, Tableau Prep, JIRA, SharePoint

Confidential, New York, NY

Sr Tableau Developer/ Data Visualization Consultant

Responsibilities:

• Created business requirements and analyzed data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created dashboards by extracting data from various sources using parameters, sets, groups and calculations.
• Developed interactive dashboard and applied actions (filter, highlight and URL) to dashboard and created calculated fields, mapping, hierarchies and drilling through reports in dashboard.
• Developed 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.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Performed extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Performed Tableau type conversion functions when connected to relational data sources.
• Used Web data connector and developed Tableau dashboards using various websites based on Json and HTML.
• Maintained and Installed Tableau Server in all the environments and created incremental refreshes for data sources on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Performed administrative and support activities across a multi-environment tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
• Created External filter, internal filter and Context filter to improve performance.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Performance Tuning of Dashboards and working with users and Database teams for design review and modeling.
• Created workflows to get the data from various sources using Alteryx and performed Data modeling and loaded data in SQL server and Oracle using Alteryx.
• Used commands in Tabcmd and Tab admin utility tool.
• Created extensive documentation on the design, development, implementation, daily loads, process flow of the mappings, and provided Knowledge Transfer to the end users.

Environment: Tableau 10.5 and 9.1, Tableau server, Python, Web data connector, Alteryx, Teradata, Oracle 11i, Informatica 8.x, SQL, MySQL 6.3, Python, Teradata Sql, Windows 2003/ XP, UNIX.