SUMMARY

• Over 11+ years of experience in the IT Industry and worked on Tableau Desktop, Tableau Server, Data Analyst and efficient in connecting various data sources, Developing and Designing BI Solutions utilizing SQL Server and Power BI.
• Experience in developing, implementing, documenting, monitoring and maintain the data ETL process in various industries like Financial, Health Care, etc.
• Proficient in creating multiple kinds of data visualization dashboards.
• Complete understanding in all facets of Software Development Life Cycle (SDLC)
• Extensive data analyst, Tableau Experience in Enterprise Environment, in Tableau 2019.1/2018.2/ 10.3/10.2/10.1/ 9. x/8.x as a Developer.
• Expertise in Power BI Desktop, Power BI Service, Power BI Pro, Power BI Mobile.
• Skilled in creating and developing BI Dashboards into rich look for better understanding.
• Imported data using Azure Data Link (ADL) to SQL Server in Power BI to generate reports.
• Involved in publishing Power BI Desktop reports to the Power BI service.
• Designed reports in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Cubes, SQL Server Integration Services (SSIS), and Power BI
• To generate underlying data for the reports and to export cleaned data from an Excel Spreadsheet, Flat file, and CSV files to the data warehouse.
• Database development for both OLTP and OLAP systems using MS SQL Server
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color - coded tabs etc. in Tableau 10 desktop/Server.
• Developed Tableau Data Extracts from the above-mentioned data sources using Pentaho Data Integration ETL tool.
• Hands-on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.
• Disaster Recovery setup, including Backup Primary setup and configuration.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Working knowledge of ODBC, OLEDB, T-SQL, SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers, and scripting languages.
• Expert in configuring, designing, development, implementation and using Oracle pre-build RPD's (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements. Experienced in Oracle EBS R12 Financial.
• Well-versed with Microsoft Office Suite including Office365, Lync, MS Visio, MS Access, Project, Power Query, PowerPivot, DAX, SharePoint, and SharePoint Design.
• Have an idea on state of Wisconsin privacy regulations while working on the dashboard workbook.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting etc. and Dashboard prompts.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau Hands-on experience in Git and CVS for version controlling and project management.
• Used Chrome Developer tool and other testing tool to do the debug.

TECHNICAL SKILLS

BI Tools: Tableau Desktop v2019.1, Tableau Server, Tableau online, Tableau Public, Tableau Reader, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS), SQL server Integrating Services (SSIS), Power BI

Databases: MS SQL Server, Oracle, Azure, MS Access, MySQL.

Data Modeling: ER/Studio 3.5/4.0, Erwin 4.1

Languages: MS-SQL, MySQL, hive

OS: Windows XP/03/07/10, OS X, Linux/Unix

Front-End Tools: Microsoft Teams, Microsoft Project, Microsoft Office, Microsoft Exce

PROFESSIONAL EXPERIENCE

Confidential

Power-BI Visualization/Dashboard Developer

Responsibilities:

• To develop user interface design and usability of the visualization. Use of graphic design skillsets, ensure accessibility, and color aesthetics align with organizational requirements.
• Interpret and implement agency design guidance for specific settings, and documents decision points for future guidance.
• Work with multiple teams to refine requirements and iterate on design alternatives, ensuring consistency of look, feel, and implementation.
• Graphic design UI/UX to ensure the usability of the site and change management to assist in the analysis and outreach in the adoption of the data.
• To develop a consistent user experience across multiple user interfaces, web browsers, and devices.
• Optimize existing user interface designs. Communicate with stakeholders to ensure dashboards are intuitive and useful.
• To prepare test data, review, and test developed UIs for adherence to specified UI/UX designs.
• Developed Page layouts, Navigations and presented designs, usability strategies and concepts to the clients and the management to review.
• Fetched the data from different sources like SharePoint. Able to load data from Excel, Flat Files, XML, Azure, and various other databases.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Developed Microsoft Power BI Dashboards to showcase the result of data analysis from the database.
• Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS). Used different types of visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Generated dashboards in Power BI Desktop and Power BI Service using latest data visualization features.
• Integrated custom visuals based on business requirements using Power BI desktop for better clarity of information.
• As Dashboard Developer, primary activities included designing technology roadmap for Power BI; product installation and implementation development of insightful dashboards; serving as SME point of contact for Power BI and delivery of solutions adhering to BI industry best practices.
• Created Power BI dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Created interactive data visualizations in Power BI, using relational and aggregate data sources.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Implemented metrics, filters, reports, dashboards and created advanced chart types, using calculations to manipulate the data and enable user driven parameters for visualizations and drilled down level of detail using sets.
• Developed interactive views with action/highlight filters to track-manage-correct system entry errors which provided strategic insights to Finance leaders, that helped decrease the faulty inputs into their projects software.
• Created advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Connected Power BI to various databases and performed live data connections, query auto updates on data refresh.
• Design and conduct user testing, gather, and report usage information and user feedback
• Prepare a detailed specification to describe sequence of steps that staff must follow and input, output, and logical operations involved.

Environment: Power BI and Tableau Desktop v2019.1, MS Office Suite, SQL Server, PL/SQL, MS Excel. SQL Server, SQL Server Management Studio (SSMS), Visual Studio, SSAS Tabular Cubes, T- SQL, Excel, DAX, and SSIS.

Confidential

Tableau Developer/Data Viz Specialist

Responsibilities:

• Developed Page layouts, Navigations and presented designs, usability strategies and concepts to the clients and the management to review.
• Fetched the data from different sources like SharePoint. Able to load data from Excel, Flat Files, XML, Azure, and various other databases.
• Imported data using Azure Data Link (ADL) to SQL Server in Tableau Desktop to generate reports.
• Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Integrated custom visuals based on business requirements using Tableau desktop for better clarity of information.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Analytic support for the company’s marketing campaigns; by predicting areas of promotion.
• Developed interactive views with action/highlight filters to track-manage-correct system entry errors which provided strategic insights to Finance leaders, that helped decrease the faulty inputs into their projects software.
• Implement complex formulas, calculations & Level of detail (LOD) within Tableau to meet the needs of complex business logic.
• Created advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Connected Tableau to various databases and performed live data connections, query auto updates on data refresh.
• Developed PL/SQL triggers on master tables for automatic creation of primary key values.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau Desktop v2019.1, MS Office Suite, SQL Server, PL/SQL, MS Excel. SQL Server, SQL Server Management Studio (SSMS), Visual Studio, SSAS Tabular Cubes, T- SQL, Excel, DAX, SSIS, Business Intelligence Development Studio (BIDS), TFS, Azure Analysis services (AAS) and Power BI.

Confidential

Tableau Developer/Power BI

Responsibilities:

• As Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Developed Page layouts, Navigations and presented designs, usability strategies and concepts to the clients and the management to review.
• Translated business requirements into workable functional and non-functional requirements at detailed production level using workflow diagrams, sequence diagrams and Use Case Modelling.
• Fetched the data from different sources like SharePoint. Able to load data from Excel, Flat Files, XML, Azure, and various other databases.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Imported data using Azure Data Link (ADL) to SQL Server in Power BI to generate reports.
• Utilized Power BI Gateway to keep dashboards and reports up to-date with on premise data sources.
• Developed Microsoft Power BI Dashboards to showcase the result of data analysis from the database.
• Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created stored procedures and performed index analysis for slow performing SSRS reports to bring down the report rendering time from 15 minutes to 30 seconds.
• Designed and developed Power BI dashboards, Reports and published it on Power BI service.
• Created SSIS Packages using Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Used MDX to interact with the back end OLAP Services.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for data cleansing and data massaging
• Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL Azure etc.
• Expert in creating Complex Crystal Reports Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, graphical aging reports.
• Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS). Used different types of visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Generated dashboards in Power BI Desktop and Power BI Service using latest data visualization features.
• Integrated custom visuals based on business requirements using Power BI desktop for better clarity of information.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Developed interactive views with action/highlight filters to track-manage-correct system entry errors which provided strategic insights to Finance leaders, that helped decrease the faulty inputs into their projects software.
• Migrated existing QlikView reports to Power BI reports.
• Created Drill down Reports, Summary Reports, Linked Reports and sub reports by region, year, quarter, month, and week for different departments.
• Practical knowledge on Azure related data management and good exposure to Python.
• Using Team Foundation Server (TFS) for managing source code changes.
• Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Analytic support for the company’s marketing campaigns; by predicting areas of promotion.
• Identify areas of opportunity to improve ROI of marketing activities by analyzing customer behavior.
• Implemented metrics, filters, reports, dashboards and also created advanced chart types, using calculations to manipulate the data and enable user driven parameters for visualizations and drilled down level of detail using sets.
• Implemented workbooks to display Year to Date, Month to Date, Quarter to Date analysis for Operational expenses for IT leaders based on Accounts, and generated bullet graphs.
• Implement complex formulas, calculations & Level of detail (LOD) within Tableau to meet the needs of complex business logic.
• Created advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Developed PL/SQL triggers on master tables for automatic creation of primary key values.
• 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.
• Connected Tableau to various databases and performed live data connections, query auto updates on data refresh.

Environment: Tableau Desktop 10.5/10.3, Tableau Server 10.5, MS Office Suite, SQL Server, PL/SQL, MS Excel, Visual Studio, SSAS Tabular Cubes, T- SQL, Excel, DAX, SSIS, Business Intelligence Development Studio (BIDS), TFS, Azure Analysis services (AAS) and Power BI