Doondi Majeti

User License Optimization

• Monitored, analyzed, and managed user license consumption to ensure optimal utilization, preventing underutilization or over-allocation.
• Implemented strategies to maximize license efficiency, reducing costs while maintaining seamless access for necessary users.
• Provided usage insights and reports to stakeholders, enabling informed decision-making on license allocation and renewals.

Production & Non-Production Job Monitoring

• Ensured the smooth execution, performance, and reliability of jobs across both production and non-production environments, proactively addressing potential issues.
• Conducted root cause analysis and troubleshooting for job failures, minimizing downtime and ensuring business continuity.

Dashboard Development & Client Engagement

• Designed and developed interactive and data-driven Tableau dashboards customized to meet diverse client requirements, ensuring seamless data visualization and decision-making.
• Engaged with stakeholders to gather business requirements, understand key performance indicators (KPIs), and translate them into insightful and visually compelling dashboards.
• Developed multiple dashboard versions with varying layouts, visualizations, and functionalities, allowing clients to select the most effective solution for their specific needs.
• Implemented dynamic filtering, drill-down capabilities, and real-time data updates to enhance usability and provide deeper insights.
• Provided ongoing dashboard maintenance, enhancements, and user training, ensuring clients maximize the value of Tableau for their business operations.

SQL Query Optimization & Adaptation: Updated SQL queries to accommodate occasional and upcoming changes in source data, ensuring the ETL process and pipelines continue functioning seamlessly as new data is pushed to production.

ETL & Scripting Enhancements: Modified Python, PySpark, and Shell scripting files to align with evolving source system requirements, optimizing data transformation processes.

Tableau Dashboard Management: Managed Tableau dashboards that provide insights into ETL counts before and after transformations, along with SLA tracking for better monitoring and reporting.

AWS & Big Data Processing:

• Utilized AWS services such as Athena for querying data and S3 for data storage.
• Leveraged PySpark within clusters to monitor job performance, diagnose failures, and conduct root cause analysis.
• Debugged job failures by analyzing errors and implementing corrective actions to ensure SLA compliance.

Production & Non-Production Job Monitoring: Responsible for ensuring smooth execution of jobs in both production and non-production environments while maintaining agreed SLAs.