DEEPTI DONTHAM

Responsibilities:

• Leading cross-organizational investigations to pinpoint data anomalies, determine root causes, quantify impacts, and provide stakeholders with practical solutions to maintain data integrity.
• Dedicated to optimizing data visualization by emphasizing design balance, simplicity, pattern usage, parameter comparison, and enhanced interactivity for the most effective visual outcomes.
• Constructing dashboards using tools like Tableau, Looker, Excel, and more while delivering actionable insights that achieved a notable 12% reduction in costs, failures, and project build intervals.
• Combined views and reports into interactive dashboards on Tableau desktop that are presented to business users, managers, and the data integrity team.
• Created comprehensive analytical reports by seamlessly integrating data from multiple sources into a single Tableau worksheet, employing a variety of Tableau features to enhance project analysis and generate insightful chart visualizations, including Treemaps, Bubble charts, and bar charts.
• Knowledge of integrating Tableau Dashboards into internal Web Applications.
• Generated data extraction, transformation, and data loading directly from different source systems like CSV files, Excel, SQL server, and custom SQL queries.
• Conducting crucial data mining tasks with SQL and Python to collect essential data and seamlessly integrate it with the host environment.
• Published diverse live/extract-based interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau server while offering ongoing support to address data, system, and performance issues.
• Proficient in crafting Custom SQL queries, developing stored procedures and views, and optimizing query performance for efficiency.
• Evaluated user group permissions for report management, data security filter implementation, and proactive monitoring of data source systems to address flaws, errors, and upstream data challenges.

Responsibilities:

• Coordination with various business users’ stakeholders and SMEs to get Functional expertise, design, business test scenarios review, UAT participation, and data validation from multiple sources.
• Part of member data engineering & services team that built an in-house auction activity alert & case management workflow utility and played an active role in achieving project deliverables on time & quality standards using Agile/Scrum methodology.
• Conducted daily transactional data reviews using advanced SQL routines and statistical models to support digital user and new customer authentication capabilities. Created intricate ETL processes with Pentaho and Alteryx to establish a robust data warehouse, efficiently handling sizeable flat file transfers to data marts.
• Handled massive quantities of business intelligence data, personally managing as much as 100 terabytes.
• Extensive experience in using Execution plans, Indexes, Table Partitions, Query analyzers, and SQL profilers to optimize queries and enhance the performance of the database SQL query.
• Led end-to-end development and implementation of data warehouse and BI solutions, encompassing real-time data pipelines, data visualizations, interactive reports, and custom ad-hoc reporting using Tableau and Pentaho.
• Identified facts, Dimensions, and Measures to construct an OLAP Mondrian Cube to build reports on Pentaho.
• Build SQL queries for performing various CRUD operations like create, update, read, and delete.
• Writing Python scripts to automate the process of deploying Insert/Updates to the Database.
• Performed Data migration Analysis. Created and executed data transformation jobs in Pentaho.
• Skilled in automating database deployments by integrating with GitHub and Python.
• Involved in Admin activities like creating users and groups, publishing workbooks to server and end users, assigning permissions, subscriptions, etc.

Responsibilities:

• Prepared the project plan and successfully delivered it on time, within scope and budget, by monitoring and tracking the progress
• Conducted business and technical gap analysis to identify root causes and plan for actions and remedies
• Expertise in end-to-end Business Intelligence (BI) implementation, including creating BRDs, loading data to the Data warehouse, and Creating Reports and Dashboards
• Performing admin activities like project management, migration of dashboards, and creating schedules for extract refreshes and subscriptions
• Based on reporting requirements, it worked on schema designing, leveraging the Fact and Dimension tables sourced for building Business object universes using the Information Design tool.
• Involved with the Business team in coming up with UAT testing strategy, planning, and scripts
• Assisting the QA team in setting up the Data and scenarios required for effective testing