Upendra Aengu

Seasoned IT professional with a wealth of 5.4 years of experience, specializing in Business Intelligence (BI) and excited about Tableau and Snowflake. I thrive on creating and fine-tuning dashboards and reports that not only look great but also perform like champions. Love collaborating with diverse teams, understanding their needs, and turning them into tech magic. Always up for a challenge, I bring solid problem-solving skills and a knack for making data dance. Let's team up and make some serious data waves together.

Over 5.4 years of experience in developing Tableau (versions 2019.2, 2019.1, 2018.2) including Tableau Desktop, Tableau Server, and Tableau Online. Extensive knowledge in various reporting objects such as Hierarchies, Filters, Calculated Fields, Sets, Groups, Bins, Parameters, and Forecasts in Tableau. Worked directly with decision-makers and end-users to understand, define, and document current and future reporting goals, needs, and requirements. Proficient in designing and developing various dashboards using Tableau Visualizations like Dual Axis, Stacked Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Crosstab, Lollipop chart, Donut Chart, Geographic Visualization, and Text tables. Designed and developed dashboards and reports from multiple data sources including Data Blending, Joins, and Merge Dimension. Designed, developed, and accelerated the build of key risk dashboards. Sound knowledge of Data Warehousing with exposure to Dimensional Data modeling including Star Schema, Snowflake Schema, Facts, and Dimension tables. Good knowledge in Building various views, Sorting, Grouping, Hierarchy, calculation fields using functions in Tableau Desktop. Built complex business calculations in Tableau using Level of Detail (LOD) expressions. Hands-on experience with data modeling and BI tools (e.g., Tableau). Successfully optimized queries in Snowflake to enhance performance and efficiency, resulting in improved data processing speed and reduced resource consumption. Proficiently executed Tableau migration activities, ensuring seamless transitions with error-free applications, and conducted rigorous unit testing to validate application functionality and data integrity. Leveraging Snowflake's advanced querying capabilities, the application facilitated the extraction of specific datasets tailored to the analytical requirements. SQL queries were meticulously crafted to retrieve, transform, and prepare the data for subsequent analysis, ensuring accuracy and reliability. Utilizing Tableau's rich suite of visualization tools, the application facilitated the creation of dynamic reports and dashboards tailored to the unique requirements of stakeholders. From interactive charts and graphs to comprehensive dashboards, the reports provided a holistic view of key performance metrics and trends, enabling informed decision-making. Utilized Jenkins automation server to schedule and manage the execution of scripts and Tableau refreshes, ensuring timely and reliable data updates and report generation. Proactively monitored Jenkins scheduled runs, promptly addressing any failures by troubleshooting and resolving issues to ensure uninterrupted data processing and reporting workflows. Conducted daily review of Fogbugz for client-reported tickets, prioritizing tasks based on urgency and impact, and promptly addressing issues to ensure client satisfaction and timely resolution of issues. Conducted thorough analysis of client-reported tickets in Fogbugz, assessing the nature of the issue and determining the appropriate course of action, whether it required resolution at the database level or through Tableau visualization enhancements, ensuring efficient and targeted problem-solving. Possessing comprehensive knowledge of SQL joins, queries, and analytical functions, facilitating effective data retrieval, manipulation, and analysis to derive valuable insights for decision-making processes. Proficiently built and published customized interactive reports and dashboards using Tableau, leveraging advanced visualization techniques to present data insights in a user-friendly and intuitive manner, enhancing decision-making processes for stakeholders. Implemented dashboard scheduling and refresh mechanisms using Tableau Server, ensuring timely updates of critical data visualizations to provide stakeholders with the most up-to-date information for informed decision-making. Effectively managed Tableau workbooks containing multiple data sources during migration processes, ensuring seamless transition and compatibility while preserving data integrity and functionality across different environments. Comprehensive comprehension of requirements, functional specifications, and technical specifications, ensuring alignment with project objectives and facilitating accurate implementation. Deploying Tableau workbooks with empty extracts linked to large-scale data sources, optimizing performance and facilitating efficient data visualization and analysis. Proficient in SQL with experience in querying and manipulating data in large-scale databases. Experienced in Snowflake data warehouse technology, including architecture, design, and optimization. Able to prioritize work and multitask in a fast-paced setting, while being willing to take on new projects and be flexible. Self-starter, result-oriented team player with the ability to manage multiple tasks simultaneously. Leveraged Python for data manipulation, automation, and integration tasks, enhancing the efficiency and effectiveness of Tableau development and ensuring seamless data workflows.