SUMMARY

• 12+ years of Experience in Business Intelligence with Experience in Data Visualization and Data warehousing.
• Have experience using TABLEAU 2021.1/2020. x/2019.x/2018.x/11.x/10.x/9.x/8.x and Microsoft Power BI for Data Visualization, generating reports and Dashboards.
• Experience as Tableau Server Administrator - Creating Users, Groups, Projects, Tasks, Server Settings and User Permissions as Tableau Server Admin and Site Admin.
• Experience in Data warehousing and ETL process using Informatica Power Center.
• Experience with SQL and in writing Complex SQL queries.
• Created Customized and Interactive Dashboards using multiple Data Sources like Snowflake, Oracle, SQL Server, Teradata, Hadoop, SAP HANA, EXCEL, Flat file Sources and SharePoint.
• Built Dataflows and Created Reports connecting to Dataflows in Power BI Desktop and published these Reports to Power Bi Service.
• Involved in publishing various kinds of interactive data visualizations, dashboards from Tableau Desktop to Tableau Server.
• Experience in Using Tableau Prep Builder for cleaning and organizing Data which is pulled from multiple Data sources.
• Skilled in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot table, pie charts, Heat maps, Scatter Plots, Geographic Map, Cross tabs, Histograms, Donut charts etc.
• Scheduled extract refresh and subscriptions.
• Created different KPI’s using Table calculations and calculated fields
• Developed effective and interactive Dashboards using Parameters and Actions
• Good understanding of OLAP and OLTP Concepts.
• Good knowledge of Data modeling techniques like Dimensional/Star Schema, Snowflake modeling, slowly changing Dimensions.

TECHNICAL SKILLS

Reporting/Analytic Tools: Tableau 2021.1, 2020.x/2019.x/2018.x/10.x/9.x 10.x/9.x/8.x, Power BI.Languages & Scripting SQL, Python, UNIX Scripting, Java script.

Database: Microsoft SQL Server, Oracle, Hadoop, Snowflake, Teradata, SAP HANA, PostgreSQL.

ETL Tools: Amazon Redshift, Alteryx Designer 2018.x,2019.x, Informatica Power Center 9.x/8.x,Tableau Prep Builder 2019.x

PROFESSIONAL EXPERIENCE:

Confidential

BI Lead Developer

Responsibilities:

• Conducted meeting with Business Users and SMEs to gather detailed requirements including data mapping, visualization and mockups for Tableau & Power BI Reports and Dashboards creation.
• Provided /demos and created documentation for users on how to access the Tableau Reports.
• Published Dashboards created on Tableau Desktop to Tableau Server.
• Connected and Written SQL queries using Data Sources like Oracle and SQL Server.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Developed Power BI Reports by connecting data from SharePoint Lists, SQL Server & Oracle.
• Created Reports in Power BI Desktop and Published them to Power Bi Service.
• Implemented Row level Security in Power BI Service.

Environment: Tableau 2021.1, Tableau Server 2021.1, Tableau, Microsoft Power BI, Microsoft SQL Server 2012, Oracle, SQL Server, SharePoint Lists.

Confidential, Florida

Tableau Reporting Lead

Responsibilities:

• Designed, developed, implemented, and managed Tableau & Power Bi reports.
• Migrated SSRS Reports to Tableau.
• Creating Users, Groups, Projects, Projects Schedules, Tasks, Server Settings and User Permissions as Tableau Server Admin and Site Admin.
• Embedded Tableau Reports on to Salesforce Application.
• Used Tableau Functions SCRIPT INT, SCRIPT REAL, SCRIPT STR, SCRIPT BOOL to run Python Code.
• Created multiple Star Schemas in Tableau Logic Layer using Relationships.
• Conducted meeting with Business Users and SMEs to gather detailed requirements including data mapping, visualization and mockups for Tableau Reports and Dashboards creation.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Combine Data sources by Joining multiple Tables and using Data Blending.

Environment: Tableau 2020.4, Tableau Server 2020.4, Tableau Prep Builder 2020.4, 2018.x, 2019.x, Teradata, Microsoft SQL Server 2012, Oracle Cloud Analytics, Python, TabPY, Windows 10.

Confidential, Charlotte - NC

Business Intelligence- Tableau Reporting Lead

Responsibilities:

• Designed, developed, implemented, and managed Tableau Business Intelligence reports.
• Conducted meeting with Business Users and SMEs to gather detailed requirements including data mapping, visualization and mockups for Tableau Reports and Dashboards creation.
• Used SQL queries to transform application raw data in SQL server Management studio
• Provided /demos and created documentation for users on how to access the Tableau Reports.
• Connected and Written SQL queries using Data Sources like SQL Server and Teradata.
• Developed Custom SQL Query to restrict data at source level.
• Combine Data sources by Joining multiple Tables and using Data Blending.
• Performed POC by building Dashboards and Reports using Power BI and QlikView.

Environment: Tableau 2018.x/10.x/9.x, Tableau Server 2019.x/2018.x/10.x9.x/8.x, Tableau Prep Builder 2019.x, Microsoft Power BI, Teradata, Microsoft SQL Server 2012, HTML, Java Script.

Confidential

ETL/Tableau Developer

Responsibilities:

• Extracted data from various heterogeneous sources like Oracle, SQL Server, MS Access and Flat files.
• Incoming data was loaded to the landing area and from there to staging area.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Use Tableau Server to publish reports online.
• Developed Custom SQL Query to restrict data at source level. Incoming data was loaded to the landing area and from there to staging area.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Developed various Mappings, Mapplets and Transformations for data marts and Data warehouse.

Environment: Informatica PowerCenter9.1, Tableau 8.x, Tableau Server 8.x, Oracle 10g, UNIX Shell Scripting, Autosys, Toad, PL/SQL, Windows 2003 Server

Confidential

ETL Developer

Responsibilities:

• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting in Dev environment.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, the Mapping Designer to map the sources to the target.
• Performed data validation by Unit testing, integration testing and System Testing
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.

Environment: Informatica PowerCenter8.6, Oracle 10g, TOAD, PL/SQL, MS Access, UNIX Shell Scripting.