SUMMARY

• 8+ years of experience in Data Analysis, Design, Implementation, Administration, Data warehousing and support of Business Intelligence technologies along with strong experience of data visualization using Tableau and Power BI.
• Experienced in developing BI applications utilizing SQL Server, Power BI, and Tableau.
• Experience with the development of automated reporting solutions
• Experience with Creating and delivering Reports, dashboard, and analyses for senior and executive level audiences
• Experience with Creating and maintaining detailed documentation on all projects/requests
• Experienced in implementing BI solutions by addressing user questions and inquiries, monitoring performance, and communicating functional and technical issues
• Strong knowledge of Microsoft BI reporting tools (SSRS, SSAS) and other reporting tools e.g., Power BI
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Design and development of Tableau visualization solutions like Dashboards, Standard Reports, Scorecards, charts, and Ad - hoc Reports
• Experience in documenting system requirement specifications in accordance with approved standards and procedures.
• Experience with Analyzing Business Operations to understand strengths and weaknesses to determine opportunities to automate processes and functions
• Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.
• Strategic expertise in designing of experiments, data collection, analysis, and visualization.
• Extensive Tableau Desktop, Tableau Server Experience in Enterprise Environment, in various Tableau versions of 6.x, 7.x, 8.x, 9.x and 10.x as a developer and Administrator.
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources and proficient in Tableau 2020/2019/10. x/9.x/8.x/7.x (Desktop, Server, Public),
• Experienced business analyst specializing in requirements analysis and SDLC documentation. Waterfall, UP, Agile and Scrum methodologies. Business Process Re-engineering (BPR). Experience in full life cycle. Provide project coordination.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations, and complex calculations to manipulate the data.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Excellent knowledge in Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
• Experience in development of user defined reports to provide on demand data analysis using excel and created charts and pivot tables in Excel.
• Used Data Blending, groups, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Quickly and effectively diagnose and respond to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards in Finance and Funds sector.

TECHNICAL SKILLS

BI Tools: Tableau 2020.3/2019/9 x/ 10x (Desktop, Server, Public), Looker. Business Intelligence Development Studio (SSRS), SSIS, Alteryx, Qlik sense, Einstein Analytics and Power BI, Crystal Report, Cognos.

ETL Tools: Informatica Power Center 7/8, SQL Server Integration Services (SSIS), OLAP(Cubes)

Databases: Teradata, SQL Server, MySQL, SQLite, Hadoop/HBase, Hive, MS Access, Oracle 12c, Vertica, Salesforce, DB2, Neo4j

Applications: Microsoft Office, MS Visio, Visible Analyst, Share point

Web Technologies: HTML, CSS, JavaScript

Web Scripting: XML, XHTML, JavaScript, Ajax, J Query, ASP 3.0, Visual Studio

Web Tools: MS-Front Page, Dream Weaver

Methodologies: Agile, TDD, Waterfall.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Sr. Tableau Developer/Admin

Responsibilities:

• Participated in Regulation W Banking Project and requirements gathering and translate business requirements into report visualization specifications design documents.
• Translate business requirements into Tableau Dashboards.
• Using Tableau Prep for Data preparation and combine them into single source of data using joins and unions.
• Extensive experience in Tableau Administration (TSM) Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Extensive usage of Amazon web services (AWS) for connecting to the data sources on cloud using Amazon redshift services.
• Connected to the AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Setting up active directory on the tableau server for the effortless password management for the single sign on (SS0) in the Salesforce and to view the embedded dashboards.
• Expertise in performance tuning of the Tableau infrastructure including the application configurations and the interaction.
• Developed Python application for Google Analytics aggregation and reporting.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many Tableau reports.
• Leverage Tableau and Salesforce Einstein, giving more actionability of data using salesforce Einstein prediction data in tableau.
• Connecting to Einstein analytics through Tableau and start performing amazing explorations leveraging power of tableau directly against salesforce CRM data.
• Predictive Capabilities from Einstein Discovery into Tableau.
• Developed complex SQL scripts for Teradata database.
• Effectively involved in the data migration from Teradata server to MySQL Server of other reporting Systems.
• Responsible for working with our Enterprise BI Team and Deploying the ThoughtSpot in Cloud (AWS).
• Experienced with reporting tools, software, and other applications, including SQL Database, Looker, Tableau and Salesforce dashboards (reports designing tool) &Experience on snowflake.
• Worked in Requirement Collections, Analysis, Development and Customization of the Application and implementing Requirements for the Project.
• Advise Business users on data quality requirements for ThoughtSpot.
• Involved in Publishing of various kinds of Live, Interactive data visualizations, Dashboards, reports and workbooks from Tableau Desktop to Server.
• Developed Parameters and Dimension based reports, drill down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Produce high quality and high value visualizations in Tableau that are Regulation W restricts certain kinds of transactions between banks and their affiliates.
• Used Alteryx to change unstructured to structured data for better Tableau reporting and data analysis.
• Experience in integrating Alteryx and Tableau, publishing data extracts from Alteryx to tableau server, Pulling data from Alteryx App on the server though Web data connector into Tableau Desktop.
• The main scope of this project is Regulation W aims to protect banks and federal deposit insurance funds from undue financial risk.
• Develop Tableau reports that provide clear visualizations of various industry specific KPIs.
• Use various data source like SQL server, Google Analytics, App Dynamics, Hadoop and Hive.
• Increased revenue by 1.5% and reduced disconnects of cable accounts by 6% through new Health check customer data dashboard.
• Utilizing scripting languages to leverage Tableau's APIs (JavaScript API, Data Extract API, REST API).
• As a Tableau Developer designed, developed, prototyping the various dashboards using tableau desktop 2019.3 version. Also involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering ranking, Top-N Analysis, hierarchies)
• Develop Tableau reports that provide clear visualizations of various industry specific KPIs.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Created a dashboard on Transactions Between Member Banks and Their Affiliates and Intercompany Transactions (Transactions Between Member Banks and Their Affiliates - Sections 23A and 23B of the Federal Reserve Act.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications Designed various practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in various Tableau workbooks.
• Creating Alters for Transactions between a bank and its nonbank affiliates must occur according to arm’s-length terms and circumstances.

Environment: Tableau Desktop 2019.4, 10x, Tableau Server, SQL Server 2008/2008 R2, Netezza, Tableau Prep, SharePoint, MS Visio, SAS, spark, Agile, Looker, Linux, Jira Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Reston, VA

Business Intelligence Consultant

Responsibilities:

• Participated in requirements gathering and translate business requirements into report visualization specifications design documents.
• Translate business requirements into Tableau Dashboards
• Created and managed plans using JIRA Portfolio.
• Assigned the appropriate resources to the JIRA agile Portfolio - Story, Epics.
• Experience in using python API, java script API.
• Produce high quality and high value visualizations in Tableau that are widely adopted by CPI
• Facilitated discussion, decision making, and conflict resolution to ensure consistent progresses.
• Tracked metrics that are important to the team to deliver success and continuous improvement.
• Helped the scrum team ensure they meet the definition of 'done' for each product feature and removed internal and external impediments to their progress
• Quickly resolve any internal customers issues raised and publish new versions of dashboards on a regular basis.
• Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams.
• Translated business user concepts and ideas into comprehensive business requirements and design documents.
• Created project plans in accordance with project management framework standards and procedures. Identified ongoing issues and gaps within project plans, to eliminate implementation issues.
• Planned, facilitated, and reported on quality assurance testing efforts.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Work with existing data model to produce accurate dashboards with respect to Rally and other tools.
• Involved in the user requirement gathering and Design meetings. Translate business needs into reporting and analytic requirements.
• Created different views in workbook to visually analyze the data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Gathered user requirements analyzed and designed software solution based on the requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created many Dashboard reports for company's decision-making purpose and made them Key Performance Indicators (KPI).
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Restricted data for users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.

Confidential , Austin, TX

Business Intelligence Consultant

Responsibilities:

• Created Tableau Dashboards with interactive views, trends, and drill downs along with user level security.
• Participated in requirements gathering and translate business requirements into report visualization specifications design documents.
• Translate business requirements into Tableau Dashboards
• Created and managed plans using JIRA Portfolio.
• Assigned the appropriate resources to the JIRA agile Portfolio - Story, Epics.
• Experience in using python api, java script api.
• Produce high quality and high value visualizations in Tableau that are widely adopted by CPI
• Facilitated discussion, decision making, and conflict resolution to ensure consistent progresses.
• Tracked metrics that are important to the team in order to deliver success and continuous improvement.
• Helped the scrum team ensure they meet the definition of 'done' for each product feature and removed internal and external impediments to their progress.
• Design the ThoughtSpot solution for performance and scalability.
• Quickly resolve any internal customers issues raised and publish new versions of dashboards on a regular basis.
• Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams.
• Translated business user concepts and ideas into comprehensive business requirements and design documents.
• Extensive practical knowledge in importing data for use in reporting software (Tableau & Looker) graphs, and flowcharts.
• Planned, facilitated and reported on quality assurance testing efforts.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Work with existing data model to produce accurate dashboards with respect to Rally and other tools.
• Involved in the user requirement gathering and Design meetings. Translate business needs into reporting and analytic requirements.
• Created different views in workbook to visually analyze the data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Gathered user requirements analyzed and designed software solution based on the requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created many Dashboard reports for company's decision-making purpose and made them Key Performance Indicators (KPI).
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Restricted data for users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.

Environment: Oracle11g, ABC 11g, OWB 10g Release2, TOAD, PL/SQL, Bigdata (python, java) JDE, S3, SQL Loader, Microsoft SQL Server, Unix

Confidential, Chicago, IL

Business Intelligence Analyst

Responsibilities:

• Tableau license procurement and reporting across organization (United States, Asia Pacific, Europe, Middle East, and Africa).
• Interacting with business users to identify and build out visualizations. Experience with Sorting, Building Groups and using in visualizations.
• Worked on Global, local and Context filters.
• Build our reporting and KPI’s for executive team and multiple functional areas.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Mappings, Trends, Hierarchies, Sets, Groups, Data Blending and Maps etc.
• As a Tableau Developer designed, developed, prototyping the various dashboards using tableau desktop 2019.3 version. Also involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting, and report operations (sorting, filtering ranking, Top-N Analysis, hierarchies)
• Develop Tableau reports that provide clear visualizations of various industry specific KPIs.
• Experienced with reporting tools, software, and other applications, including SQL Database, Looker, Tableau and Salesforce dashboards (reports designing tool) and Data warehouse.
• Extensive practical knowledge in importing data for use in reporting software (Tableau & Looker) graphs, and flowcharts.
• Involved in Interacting with business users and performed Gap Analysis according to Client requirements.
• Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources using Python and developed frontend backend python modules.
• Created various interactive reports/dashboards using tableau desktop.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management. Created different Calculation fields according to requirement, various conditions and applied multiple Filters for various analytical reports and dashboards.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report. Experienced on Date functions creating, executing test Cases, and documenting the Test Results.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Environment: Tableau (Desktop/Online) Informatica, MS Access, Python, MS SQL Server 2012, Excel.