SUMMARY

• Over 10 years of experience with development using BI applications including Tableau, Bussiness objects, Power BI, and Alteryx. Experince in all phases of SDLC including Requirement gathering, Data analyst, Business Analysis, reporting, training end users and deployment.
• Proven ability to identify business needs and deliver valuable solutions with accuracy and process efficiency. A career dedicated to creating custom complex data analytics in Tableau to identify trends within quality data and find new sources of revenue within customer data.
• Consistently recognized for understanding and leveraging business analysis, data analysis, data migration, data transformation, data integration and provided quality reports in industries like retail, manufacturing, finance/banking and health care.
• Experience pulling data from various data sources including RDBMS, CUBES, CLOUD, Websites, Big Data platform and Flat files.
• 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

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

Databases: SQL Server, Oracle, Amazon Redshift, Postgres, snowflake, MS Azure, 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

Sr. 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 Alteryx 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.
• Used AWS Redshift to pull data into Tableau Desktop for creating reporting.
• 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.
• Created External filter, internal filter and Context filter to improve performance.
• Used Web data connector and developed Tableau dashboards using various websites based on Json and HTML.
• Also, involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Experience in efficiently using standard Business Content, extending and enhancing according to the report requirements.
• Created dashboards using Excel and Microsoft SQL server data sources.
• Involved in trouble shooting of performance issues which were associated with Tableau Reports.
• Good understanding of business environment, excellent communication skill and ability to work proactively in a fast-paced environment.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau Desktop.
• Worked directly with business users to build reports, dashboards.
• Worked in all phases of full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.
• Used Tableau API such as Python and Web Data Connector and Performed Predictive Analysis.

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, N.J

Sr. 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.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Trend Lines and changed the formatting of the dashboard.
• Created Bar charts and tableau Reports as per the business Requirement and created the own template by pulling the table or view from vector wise
• Gave permissions to specified Business users to access the Report.
• Replace the data sources by adding the flat table for improving the performance on tableau side.
• Publish the workbooks on QC and Production Server.
• Used Parameters and Calculation to build the report and Edit the Alias and Replace the References.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Utilized advance features of Tableau software like to link data from Action Vector together on one dashboard and to filter data in multiple views at once.
• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.

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

Confidential, New York, NY

Sr Tableau Developer/ Data Visualization Expert

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, and SQL Server, online sources included AWS Redshift and MS Azure.
• 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.

Confidential, NY

Sr Tableau Developer

Responsibilities:

• Gathered and analyze the business requirements and then translate them to technical specifications.
• Developed Interactive dashboard from multiple sources like Hadoop, Teradata and Oracle using Tableau.
• Used Python integration in tableau using Script bool, Script Int, Script real and Script string and performed Statistical/predictive analysis.
• Develop Ad-hoc reports according to user's requests and meet the expectation.
• Presented, interacted, and communicated with business user for explaining the dashboards that was created with the change timely fashion.
• Used different Mark types and Mark properties in views to provide better insights into large data sets
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Created incremental refreshes for data sources on Tableau server to improve the performance.
• Monitored Application Server and data server activity to track Performance and system stability.
• Experience in Tableau Server upgrades, taking backup's and restoring
• Published of various kinds of live/extract based interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Trained user to interact, filter, sort, customize views and enable subscription on Tableau Server for an existing visualization generated through Tableau.
• Identified and solve the issues in coordinating with testing team within marked SLA.
• Prepared detailed documents for the Dashboard specifications.
• Created custom database connections, join tables as needed, create & manage Extract and Monitor Queries using SQuirreL SQL Client.
• Implemented best-practices for the dashboards with a solid understanding of the use of Contexts filter, hiding sheet functionality and their impact on performance.
• Experience in publishing reports, data source and dashboards, scheduling refresh, create projects, groups, users, exporting the reports in different Formats in Tableau server.
• Experienced in data source transition and troubleshooting its impact.
• Provided 24/7 production support for Tableau users.
• Created ad-hoc reports in SSRS
• Extracted data from internal data warehouse system to SSRS

Environment: Tableau 10.1 and 9.1, Tableau server, Hadoop, Alteryx, Python, Teradata, Oracle 11i, Informatica 8.x, SQL, MySQL 6.3, SQL*Plus, SSRS, TOAD, Windows 2003/ XP, UNIX.

Confidential, New York N.Y

Sr Tableau Developer

Responsibilities:

• Created Tableau worksheet, which involves Schema Import, Implementing the business logic by customization.
• Developed and published customized interactive reports and dashboards, report scheduling using Tableau desktop and server.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created 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.
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop for Amazon.
• Created stored procedures, views, and custom SQL queries to import data from sql server to tableau.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Tested reports, uploaded tableau dashboards on to server, and provided production support for tableau users.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
• Created dashboards using the data pulled by Alteryx from Hadoop Hive queries.
• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Analyzed Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.

Environment: Tableau Desktop 9.0, Tableau Server, Alteryx, Hadoop, Teradata, DTS, Windows server 2003, MS SQL Server, SSRS, Crystal reports, Unix, AWS

Confidential, Fort Worth, TX

Sr Tableau Developer/Sr. Business Intelligence Developer

Responsibilities:

• Developed and Reviewed Business requirements and prepared the dashboards as per the requirement.
• Developed narratives that describe the technical process in business terms.
• Communicated on daily basis with stakeholders and clients on Tableau related activities
• Created several types of charts to provide better visualization.
• Modified the existing dashboard as per the user requirements and used Tableau Desktop for creating different interactive views and dashboards.
• Publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Installed and upgraded of Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extracted data from various sources connecting them and used the same to create dashboard
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Used Tableau Desktop created Interactive-reporting dashboards by combining multiple views.
• Wrote UNIX and SQL scripts for pre, post session processes to automate daily loads.
• Performed unit test/integrated testing scenarios to obtain the UAT's.
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.

Environment: Tableau, Business Objects Webi, SQL Server, Teradata, Crystal Reports, Xcelsius, Informatica, Tab jolt, R, ProClarity, TFS

Confidential, Rockville, MD

Sr. Business Intelligence Developer/Tableau Analyst

Responsibilities:

• Involved in the complete process cycle including Functional skills in analyzing the client requirements translating innovative ideas into client-specific solutions using opportunity identification, requirements development, delivery, support, analysis and quick learner.
• Converted business objects reports to tableau dashboards using multiple different data sources.
• Created URL Actions to navigate from one Dashboard visual to another visual opened in a new browser window using separate TDE to improve report performance.
• Created database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Responsible for interaction with business stakeholders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Used parameters to make dashboards dynamic and worked extensively with Date, String and Logical Functions.
• Created Inventory trends, sales integration and forecast accuracy related dashboards
• Interacted and worked with ETL team for improving performance on data from multiple data sources
• Worked with ETL team for performance improvement using efficient transformations for reporting.

Environment: Tableau, Informatica 9.1, MS SQL Server Integration Services (SSIS), Crystal Reports, Dashboard designer, TFS, Share point, Toad, Teradata, Teradata, Visual source safe (VSS).

Confidential

SQL BI Developer

Responsibilities:

• Gathered user requirements, Analyzed and designed of software and database solutions.
• Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, SSIS/SSAS/SSRS development,
• Architected and implemented the Operational Data Store, Tables, and Stored Procedure, Triggers.
• Involved in planning and designing Cubes and building attribute relationships for optimal query performance of Hierarchies and Fact Dimensions
• Developed stored procedures, functions, views, triggers, and migrated data from different databases to SQL server.
• Designed and developed Crystal Reports like Cross Tab Reports, Top N Reports for highlighting significant data, summary reports with drill-down capabilities.
• Designed and managed Crystal reports and Xcelsius dashboards for daily and monthly reporting.
• Configured server for sending automatic mails on the failure and success of the scheduled job
• Created database maintenance plan for the maintenance of SQL Server, which covers Database integrity checks, update statistics and reorganizing/rebuilding of indexes
• Worked on data preparation, data massaging, extractions and transformations from various data sources like MS SQL Server, MS Excel, MS Access, Text, CSV and xml
• Used various transformations of SSIS like lookup, conditional split, merge, merge join to clean the data
• Created SSIS packages for application that would transfer data among servers and perform other data transformations; scheduled the SSIS packages by creating the corresponding job tasks.
• Implemented SSIS with SQL Server stored procedures for data manipulations. Created Complex joins, sub-queries and User Defined Functions (UDFs) in the Data warehouse.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups.
• Implemented Error handling and utilized Event handlers for automated notifications using SSIS.
• Identified and created Data Source Views, defined advanced attribute and dimensions properties.
• Responsible for implementing, deploying and maintaining SQL Server Reporting Services platform.

Environment: SQL Server, Oracle, Crystal Reports, Windows Enterprise Server 2003, SSRS, SSIS, Dashboard designer, ALM