PROFESSIONAL SUMMARY:

• Over 9 years of IT experience in Analysis, Design, and Development in the fields of Databases, Business Intelligence, Client Server Technologies and Web - based Applications.
• Proficient in all phases of the Software Development Lifecycle (SDLC (Water Fall & Agile methodology))
• 5 years Extensive Tableau experience in enterprise environment and administration and 3+ Years of Microsoft Power BI tool.
• End to end implementation experience in complex BI Report design, Dashboards, Project Management, Maintenance, upgrade, servers, Root cause analysis and Resolution Methods using different BI tools
• Expertise & In-depth knowledge on Tableau desktop, Tableau Server, Power BI Desktop and Power Service & Administration
• Integrate different databases to Tableau Desktop for ensuring fast report performance.
• Handling different data formats to get best visualizations by using analytical tools like R, Python.
• Creation of metrics, attributes, filters, reports, and dashboards on Tableau Desktop & Power BI tools.
• Creation of advanced chart types, visualizations and complex calculations to manipulate the data
• Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution
• Implementation of advanced techniques to build custom visuals in both Tableau and Power BI desktop.
• Develop Performance Dashboards, Score cards, Metrics, what if analysis, Drill down, Search, Reports/Dashboards for multiple functional areas in Power BI & Tableau.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created extracts and published data sources on tableau Server for the users from various databases and Used complex joins and validated them by running SQL scripts.
• Developing Custom Power BI reports and dashboards with advanced functionalities like Bookmarks, Drill-in/drill through, slicers and dicers enabling end-user to make filters to match stakeholder requirements.
• Experience in using various source systems: Bigdata sources (Hive, Impala), Azure SQL Server and RDBMS like Oracle 11gi, SQL Server 2012/2017.
• Strategic expertise in design of experiments, data collection, analysis and visualizations using different Analytical tools.
• Utilized Power BI to create various analytical dashboards that gives different KPI metrics using Time Intelligence functions.
• Performing extensive testing of developed BI reports against data sources by building and executing SQL Scripts.
• Involved in installation of Tableau desktop 9.3, Tableau server 9.3. Worked on latest versions of Tableau 10.x.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Having knowledge on Java API and Rest API which to integrate reports in webpages from tableau server.
• Analyzed report performance tuning in tableau desktop & server using performance recording feature and available capabilities in the Tableau server.
• Created workspaces, Apps and Published reports to workspaces on Power BI Service and created different types of schedules to refresh reports using power bi gateway.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.

TECHNICAL SKILLS:

LANGUAGES: C, C++, HTML, SQL

DATABASE SYSTEMS: MS SQL SERVER, Oracle (11g), Big data(Hadoop),Azure SQL Server

Business Intelligence: Tableau 8,9,10.x,2018 versions, Tableau Desktop,Tableau Prep, Tableau Server (Administration), Microsoft Power BI, Power BI Desktop, Power BI Administration, QlikView 9 version, Jasper soft, SSIS.

Other Technologies: Knowledge on R, Python (libraries) to integrate into Tableau & Power BI Desktop Azure Machine Learning.

Hadoop Ecosystems: Hive, Impala

Methodologies: Water Fall, Agile, Scrum, TFS, Version One

Operating Systems and Administration: Windows, Unix/Linux

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

BI Developer

Responsibilities:

• Created Power BI dashboards to provide insights for management and end users.
• Hosted the Power BI reports using Power BI service and created Workspaces and Apps.
• Integrated various data sources to created data model in Power BI.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar, and tree maps.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Implemented Bookmarks functionality in reports to showcase more detail visualization.
• Developed different KPI metrics to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis using various Time Intelligence functions.
• Created different KPI & Visualization reports on Member, Loan, Share & GL Data.
• Created workspaces, Apps and Published reports to workspaces on Power BI Service and created different types of schedules to refresh reports using power bi gateway.
• Migrating Excel reports to Tableau & Power BI Reports with latest drill down options and accessing reports in different output format.
• Explored data in variety of ways and across multiple visualizations using Power BI & Tableau.
• Contributed in development of knowledge transfer documentation.

Environment: Power BI Desktop, Tableau Desktop, SQL Server, SSIS, R, Power BI Service, VSTS, Azure SQL, Tableau Server.

Confidential, Madison, WI

Responsibilities:

• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop and publish them to Tableau server.
• Developed Tableau & Power BI reports and dashboards from multiple data sources using data blending and data modeling.
• 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 Workbooks and dashboards for analyzing Business application data using Tableau Desktop
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Converted Excel Reports to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Explored data in variety of ways and across multiple visualizations using Power BI & Tableau.
• Migrating SAP-BO reports to Tableau & Power BI Reports with latest drill down options and accessing reports in different output format.

Environment: Tableau Desktop, Power BI Desktop, SQL Server, SSAS, SAP BO, Power BI Service, Tableau Server.

Confidential

BI Developer

Responsibilities:

• Responsible for gathering and analyzing user requirements
• Analyze Confidential vehicle group warranty operations
• Identify warranty leakage based on claim operations using R model.
• Developed reports like Root cause and cost analysis for different warranty products and OEM
• Analyze operational effectiveness for existing reports.
• Integrated social media data to the reports using MySQL, Python scripts.
• End to end experience in designing and deploying data visualizations using Tableau

Environment: Tableau Desktop, Excel, Oracle, R, Python, Tableau Server.

Confidential

BI Developer

Responsibilities:

• Responsible for gathering and analyzing user requirements
• Experience with creating Worksheets and Dashboard with advanced visualizations techniques.
• Worked on Multiple data connections to showcase analytical capabilities
• Reports Contains design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau
• Experience with Tableau for Data Acquisition and data visualizations for client and customers
• Connected Analytical output model from R to tableau to showcase deep level analysis.
• Integrated social media data to the reports using MySQL, Python scripts.
• End to end experience in designing and deploying data visualizations using Tableau

Environment: Tableau Desktop, Excel, SQL Server, R, Python, Tableau Server

Confidential

Tableau Developer

Responsibilities:

• Responsible for gathering and analyzing user requirements
• Experience with creating Worksheets and Dashboard
• Working with Multiple data Connections
• Experience with different Sheets & Visuals like Text Table, Line, Bar, Tree Maps, Pie charts.
• To Integrate Developed Reports into Web Browser, Mobile, iPad Environment
• Reports Contains design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau
• End to end experience in designing and deploying data visualizations using Tableau

Environment: Tableau Desktop, Excel, SQL Server, Hive, R, Tableau Server

Confidential

Responsibilities:

• Responsible for gathering and analyzing user requirements
• Experience with creating Worksheets and Dashboard
• Working with Multiple data Connections
• Experience with different Sheets & Visuals like Text Table, Line, Bar, Tree Maps, Pie charts.
• To Integrate Developed Reports into Web Browser, Mobile, iPad Environment
• Reports Contains design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau
• End to end experience in designing and deploying data visualizations using Tableau

Environment: Tableau Desktop, Excel, SQL Server, Hive, R, Tableau Server

Confidential

Tableau Developer

Responsibilities:

• Migrating Jasper reports to Tableau
• Integrating developed reports to HTML webpages.
• Experience with creating Worksheets and Dashboard
• Working with Multiple data Connections
• To Integrate Developed Reports into Mobile and iPad Environment
• Reports Contains design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau

Environment: Tableau Desktop, Jasper Reports, Excel, SQL Server, Hive, R, Tableau Server