Avinash Goud

• Primary activities include creating powerful visual reports, supply gap analysis, dashboards (real-time and non-real-time) in the business intelligence platform for executives to track current sales and trends, intelligent automation, maturity assessment, and risk register data by creating complex dashboards to provide powerful insights, including financial metrics, and publish them on the server and monitor them.
• Worked closely with higher management and the data analytics director/project manager for optimal solutions and envisioning the dashboards.
• Developed and was involved in various Power BI projects, including the Legal Invoice Model dashboard, which involved high-level data related to invoices, budgets, and predicted budgets.
• Worked on various projects, including legal and my skills datasets, in maintaining and managing BI applications and integrations.
• Extensively worked on optimizing the dashboard to capture YTD and MTD across cost categories and functional areas for various sectors and regions.
• Created various reports in Power BI, including the co-pilot, to create historical data strategies for specific matters.
• Increased efficiency, or saved time, using the time savings percentage, in data errors with the error reduction rate.
• Helped in cost-saving; stated the cost reduction figures, including the boost in report generation or decision-making speed, with report turnaround time.
• Revamped data collection processes using advanced DAX formulas, enhancing data analysis speed by 20% across the organization.
• Instituted an automated data cleansing process using Python scripts that reduced data preparation time by 40%, allowing the team to focus on in-depth analysis.
• Orchestrated a major Power BI implementation, integrating complex data warehouses, which propelled decision-making efficiency by 40%.
• Spearheaded a cross-departmental BI strategy, leading to a 25% reduction in report generation time through optimized data models.
• Crafted and automated over 50 interactive dashboards that led to a 30% increase in user engagement for strategic business units.
• Experience in writing complex DAX queries, data modeling, DAX formulas, data visualization techniques, SQL querying, and dashboard creation.
• Integrated SQL with Power BI to automate data extraction processes, saving 15 hours of manual work per week.
• Pioneered the introduction of data analytics practices that informed business decisions.
• Extensively worked on Tableau Desktop version 2023.2, 2022.3, 2021.3/2021.2, and Tableau Server 2021.3/2020.x.
• Creating powerful visual reports and dashboards (real-time and non-real-time) in a business intelligence platform for executives to track current sales and trends, and dealership data, by creating complex dashboards to provide powerful insights, including financial metrics, and publishing them on the server.
• Built dashboards to answer key business questions such as risk assessment, performance monitoring, investigative analysis, and solutions/decision support, etc.
• Extensively worked on huge volumes of data, segregated it across the board, and built action plans to mitigate product protection, market monitoring, commercial insights, etc.
• Work with business and engineering teams on data integration projects to deliver solutions for data needs, and be responsible for executing, reviewing, and enhancing a suite of Business Intelligence Dashboards and datasets for Tableau.
• Write complex queries in Structured Query Language (SQL) Server and Hadoop Cloudera to build database extracts and maintain a knowledge repository for project documentation, Business Intelligence, and other technical skills.
• Performed troubleshooting of post-release software faults to support live service and installed software patch design.
• Applied security measures into systems development, supporting final products' resistance to intrusion and exploitation.
• Analyzed user needs and software requirements to determine design feasibility.
• Leveraged Agile methodologies to move the development lifecycle rapidly through initial prototyping, enterprise-quality testing, and final implementation.

Environment: Tableau Desktop 2023.2, 2022.2/2021.3, Tableau Server 2023.2/2022.1, Power BI co-pilot, Python, Tableau Prep, Command Prompt, MS Office Suite, SQL, Postures-SQL, Amazon S3, Domino, MS Excel, PowerPoint, etc.

• Developed and implemented Tableau dashboards to provide insights into business metrics.
• Evaluated existing reporting procedures to recommend adjustments to reported data categories, enhancing visualization impact to maximize report utility.
• Optimized existing queries by leveraging best practices for improved performance of reports.
• Monitored usage analytics within the Tableau platform to identify areas for improvement in user experience.
• Implemented security measures within the Tableau server to protect confidential information from unauthorized access.
• Managed diverse projects for data capture, storage, and forecast analysis.
• Assessed programs to identify risks or problems to determine appropriate responses.
• Utilized advanced Tableau features, such as parameters, calculations, and visualizations, to create interactive dashboards.
• Provided technical assistance to junior developers in troubleshooting Tableau issues.
• Manipulated Tableau parameter controls, hierarchies, and filters to achieve LOD expressions and geospatial design configurations, leveraging multiple data joins for comprehensive analysis.
• Generated ad hoc reports based on customer requests using appropriate filters and parameters.
• Designed custom visuals with HTML5, CSS3, and JavaScript technologies for enhanced user experience.
• Conducted training sessions for users on how to use Tableau dashboards effectively.
• Automated manual tasks through scripting languages like Python or R for increased efficiency.
• Conducted system analysis and testing to identify and resolve technical issues or inefficiencies.

Environment: Tableau Desktop 2020.1/2020.3, Tableau Server 2020.1/2020.3, MS Office Suite, SQL, T-SQL, PL / SQL, MS-Excel, PowerPoint etc.

• As a Sr. Tableau, my primary activities included designing and developing the dashboards and combining multiple data sources in Tableau with current and previous period claims-related data.
• Extensively worked on Tableau Desktop version 2019.3, Tableau Server 2019.3, InVision, Adobe, Hive, and Impala.
• Supported the Tableau Dashboards integration in the web using JavaScript APIs.
• Worked exclusively on parameters, toggle buttons, action filters, navigating from one dashboard to another dashboard (interactivity), hiding/showing containers, and more advanced features in Tableau.
• Created views in Impala and Hive to handle complex data from various tables, by eventually creating data sources for Tableau.
• Upgraded out-of-the-box reports to new reports using list view and summary view rules using PEGA.
• Using PEGA, upgraded out-of-the-box reports to new reports using list view and summary view rules.
• Automated reporting processes for patient outcomes reduce manual report generation time by 10 hours monthly and increase data accuracy through ETL processes with SQL Server Integration Services (SSIS).
• Worked closely with web developers to create solutions by thinking outside the box for some of the functionalities that Tableau could handle, such as an image pop-up with 'No Data Available' whenever there is no data available for that specific chart in the dashboard, while using tiled options.
• Create powerful visual reports and dashboards (real-time and non-real-time) on the Tableau platform for executives to track current sales and trends, complex dashboards to provide powerful insights into the claims and financial metrics, and publish them on theTableau Server.
• Work with business and engineering teams on data integration projects to deliver solutions for data needs, and be responsible for executing, reviewing, and enhancing a suite of Business Intelligence Dashboards and datasets for Tableau.
• Deploy the code in the rest of the build and testing environments to sync up with Production servers.
• Investigate and resolve production code issues, technical conflicts, and integrating multiple systems.
• Find innovative ways to design graphs and charts that are visually exciting and aesthetically pleasing. Provide technological and development support, as well as assistance, when alerts or holds on transactions are not generated in the production and testing environment.

Environment: Tableau Desktop 2020.3/2019.3, Tableau Server 2020.3/2019, Hive, Impala, Adobe, Invision, MS Office Suite, JIRA, SQL, T-SQL, PL / SQL, MS-Excel etc.

• As a Tableau Developer, my primary activities included designing a technology roadmap for Tableau, maintaining a team of two Tableau developers, and ensuring the delivery of product installation, implementation, and development of insightful dashboards, while serving as the point of contact for Tableau-related products to the business.
• Extensively worked on various Tableau Desktop versions, Tableau Server, Tableau Online, and Tableau Reader.
• Played a key role in migrating Teradata objects into the Snowflake environment.
• Developed a data warehouse model in Snowflake for over 100 datasets using WhereScape.
• Implemented workbooks to display Year-to-Date, Month-to-Date, and Quarter-to-Date analysis for operational expenses for IT leaders based on accounts, and generated bullet graphs.
• Working closely with top management of the company, understanding the requirements of the business intensely, and ensuring the delivery of the production involves defining the whole project life cycle, following agile methodology, and analyzing business requirements to segregate them into high-level and low-level priorities, as well as determining the feasibility of design within time and cost constraints.
• Create powerful visual reports and dashboards (real-time and non-real-time) in the Tableau platform for executives to track current sales and trends, including complex dashboards such as YTD, QTD, and MTD, to provide powerful insights into the financial metrics.
• Extensively translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of the toolset available across the Business Intelligence suite..
• Developed and implemented solutions leveraging the Alteryx Designer Desktop, Alteryx Server, and Alteryx Scheduler, including process documentation and training clients on the theory of operation.
• Combined multiple data sources using data blending in Tableau to keep track of sensor data, operator inputs, and real-time systems, all in one dashboard.
• Mastered the ability to design and deploy rich graphic visualizations with drill-down and drop-down menu options, as well as parameterized views, using Tableau Desktop.
• Developed KPIs and dashboards based on reports, spreadsheets, and charts.
• Worked in web and GUI development using HTML, DHTML, XHTML, CSS, JSP, JavaScript, Splunk, jQuery, Dojo, POJO, AJAX, and JSON technologies.
• Architecting, developing, deploying, and administering Splunk Enterprise to support cybersecurity capabilities.
• Extensively built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story within the data using Tableau Desktop.

Environment: Tableau Desktop 2020.1/2020.3, Tableau Server 2020.1/2020.3, MS Office Suite, SQL, T-SQL, PL / SQL, MS-Excel, PowerPoint etc.

• As a 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
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards
• Extensively worked on pega KYC case management platform
• Developed REST services, Email Listeners
• Handled the Pega Application upgrades
• Implemented various PRPC components like Decision tables, Decision Maps, Declarative expressions, Constraints, and Indexes etc
• Designed case architecture based on the pega case management rules
• Ensured that the business and technical architecture of the delivered solution related to Pega PRPC (Pega Rules Process Commander) matches customer requirements
• Created and maintained SOX documentation required for critical financial file systems
• Created, maintained, and queried Relational database (MS Access)
• Understand and use SQL regularly for problem analysis
• 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
• Developed and implemented solutions leveraging the Alteryx Designer Desktop, Alteryx Server and Alteryx Scheduler including process documentation and training clients on theory of operation
• Member of a team that created the proof of concept for the selection of the ETL tool (BI tool)
• Sat with vendors and evaluated vendor tools during the proof of concept
• A member of the team that designed and created the infrastructure for a Data Store which was used for conversion and routing of information created outside of the company and moved to Safeco data source
• Broadened knowledge of Tableau and Alteryx through free classes and webinars to start turning
• Extensive knowledge in building Docker images and pushing those images into AWS ECR repository and Running the containers in AWS ECS
• Developed the UI user interface pages using HTML, DHTML, CSS, JSON, jQuery, and Ajax
• Extensively used Angular2/4/5 features such as Directives, Filters, Two-way Data Binding, Services, Templates, Routing, MVVM and Dependency Injection to build Single-Page-Applications in a clean and maintainable way
• Created specifications for the conversion of data outside of Safeco into legacy data
• Learned and understood complexities of outside systems and was able to convert into Safeco terms
• Provided 24/7-production support for Tableau & Looker users on Ad-Hoc basis
• Created incremental refreshes for data sources on Tableau Server
• Created report schedules, data connections, projects, groups in Tableau Server

Environment: Tableau Desktop 2019/2018, Tableau Server 2018, Tableau Online, Tableau Bridge, Tableau Prep, MS Office Suite, SQL, T-SQL, PL / SQL, MS-Excel.

• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc
• Created interactive data visualizations in Tableau, using relational and aggregate data sources
• Experienced in developing web services with the Python programming language, OLAP cubes.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Integrated Power BI dashboards with Azure SQL Database, providing seamless data updates, and improving real-time monitoring capabilities for management.
• Extensively used, as the client FCA wanted to try other BI tools to produce a cost-effective model.
• Power BI was considered cheaper than Tableau, and I've developed dashboards in Power BI.
• I took official training from Power BI (Microsoft training) and delivered the project.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning
• Involved in gathering the requirements, collecting sample data, and creating models (Attribute views, Analytic views, Calculation view) using SAP HANA Studio.
• Working on migrating legacy, on-premise applications to various cloud platforms, like Azure and AWS.
• Created Technical specifications and standard modeling documents for HANA
• Worked with JavaScript validations and developed Object-Oriented code
• Developed Web API using NodeJS and hosted on multiple load-balanced API instance
• Expertise in RESTful, SOAP web services to integrate between Application to Application
• Building models in HANA Enterprise like Attribute Views / Analytic Views & Calculation Views
• Connected Tableau to various databases and performed live data connections, query auto updates on data refresh

Environment: Tableau Desktop 2018.x/10.5, Tableau Server 2018, Looker (Look ml Development / Desktop / Admin, Server), MS Office Suite, SQL, T-SQL, PL / SQL, MS-Excel, MDX, DAX, OLAP Cubes.

• Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel.
• Worked on the motion chart, bubble chart, and drill-down analysis using Tableau Desktop.
• Involved in creating stored procedures, views, and custom SQL queries to import data from SQL Server to Tableau.
• Used Power BI to try its hand at developing dashboards as part of an experimental model for some dashboards that were developed and delivered to the client as per requirements.
• Created OLAP data sources in BI 4 CMC for AA reports.
• Developed parameter- and dimension-based reports, drill-down reports, matrix reports, charts, and tabular reports using Tableau Desktop.
• Responsible for delivering proof of concepts using AWS, and understanding customer business requirements.
• Secured the Tableau server to protect the Tableau environment, security group, and AWS Direct Connect.
• Developing various Tableau dashboard prototypes for future use and the conversion of current Excel reports into Tableau.
• Extensive experience in Salesforce.com setup, configuration, customization, administration, data migration, and integration tools like Apex Data Loader and Workbench.
• Ensure user login access, server-level, and database-level access to application users and developers.
• Tableau administration and development roles, and helping the client with the issues of data connections, extraction, and maintenance.

Environment: Tableau Desktop 2018.1/10.3, Tableau Server 10.3, MS Office Suite, SQL Server, PL / SQL, Informatica, Teradata, MS Excel.

• Built strategic, analytical, and operational dashboards using Tableau.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live, dynamic, and static datasets.
• Created SQL views to pull data from SQL Server, and developed reports using advanced calculations, filters, and parameters.
• Worked extensively with advanced analysis actions, calculations, parameters, background images, and maps.
• Tested reports and uploaded Tableau dashboards onto the server, and provided production support for Tableau users.
• Create advanced connections, join new tables, and create and manage extract and monitor queries using SQL Assistant.
• Maintaining server activities, user activity, and customized views on Tableau Server analysis.
• Migrated reports, and universes from Dev to QA, and to Prod using the import wizard.
• Created dashboards and visualizations using Tableau for several teams, and delivered demo sessions to expand the tool's reach in the IT environment.
• Created architecture design documents and technical specifications documents.
• Tableau integration for an enhanced experience for the users.
• Created extracts and published data sources on Tableau Server for the users from various databases in Greenplum.
• Used complex joins and validated them by running and tuning long SQL queries
• Experienced in writing complex SQL queries, stored procedures, triggers, views, cursors, joins, constraints, DDL, DML, and user-defined functions to implement business logic and create clustered and non-clustered indexes.
• 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 that the data matched the business requirements and to check for any changes in the underlying data.
• Created complex workbooks and dashboards by connecting to multiple data sources.
• Involved in conducting training for users on how to interact, filter, sort, and customize views on an existing visualization generated through Tableau Desktop.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolsets available across the Tableau BI suite
• Created complex data views using multiple measures; also used sort, filter, group, and create set functionality's
• Designed and developed two main technological components: a database to store data on all transactions related to each purchase, and a data warehouse to store historical forecasts and real demand by vaccine and by country, to measure the forecasting changes.
• Published various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards with Map Viewer / Big Maps / Google Maps, reports and three tier OBIEE architecture
• Generated reports using the OBIEE features like pivot tables, charts, and view selector
• Extensively worked on Tableau Desktop, by creating Sears &Kmart Complex reports& Dashboards
• Good experience in using URL’s, Hyperlinks, Filters for developing Complex dashboards
• Worked on creating aggregations, calculated fields, table calculations, totals, and percentages using key performance measures (KPI) and measures.re
• Interacted with the business users and supervisors to gather business requirements.
• Environment: SQL Server 2000, SQL Server 2005
• T-SQL, Windows Server, HTML, VBScript, JavaScript, Access, MS SQL Server 2000/2005/2008, Erwin, MS Access, SQL Server Integration Services (SSIS), SSRS Import and Export Data, SQL Reporting Services, XML.

Environment: SQL Server 2000, SQL Server 2005. T-SQL, Windows Server, HTML, VBScript, JavaScript, Access, MS SQL Server 2000/2005/2008, Erwin, MS Access, SQL Server Integration Services (SSIS), SSRS Import & Export Data, SQL Reporting Services, XML.