Venkata Sai Manish Vathumilli

United States | Aug 2023 – Present

• Engage with business stakeholders and SMEs to gather requirements and translate complex business needs into scalable Power BI and analytics solutions.
• Design, develop, and maintain end-to-end Power BI dashboards and paginated reports, including data modeling, DAX calculations, row-level security, and performance optimization.
• Develop and optimize SQL Server database objects such as stored procedures, views, functions, indexes, and triggers across development and production environments.
• Integrate data from multiple enterprise sources including SQL Server, Oracle, Excel, CSV files, and clickstream logs, ensuring clean, accurate, and reliable datasets.
• Build Power Automate workflows and Power Apps solutions to automate reporting processes, approvals, and data capture, reducing manual effort and turnaround time.
• Create SSRS and Power BI paginated reports, manage report subscriptions, scheduling, and secure access for end users.
• Enhance report usability through advanced visuals, bookmarks, synced slicers, KPIs, and interactive drill-through functionality.
• Support capital markets analytics initiatives and lead continuous improvements to reporting performance, data quality, and business adoption.

• Developed and automated ETL workflows using Python and Hive to process large-scale datasets, improving efficiency and data reliability.
• Designed and optimized complex SQL queries to support analytics and reporting, significantly reducing query execution time.
• Built and maintained Microsoft Access databases, improving schema design, enforcing referential integrity, and tuning performance.
• Automated data ingestion from Excel, CSV, and external systems, ensuring consistent and error-free data processing.
• Created interactive dashboards and reports using Power BI and Excel, translating complex data into actionable business insights.
• Developed VBA scripts to automate routine database tasks, reducing manual workload and operational errors.
• Supported big data and cloud initiatives using Hadoop, Spark, and AWS integrations.
• Conducted training sessions and documentation to enable business users to adopt self-service reporting tools.

• Collaborated with business stakeholders and Agile teams to gather requirements and deliver analytics solutions for healthcare and enterprise clients.
• Collected, cleansed, and transformed data from SQL Server, Excel, flat files, and cloud sources for reporting and analysis.
• Performed exploratory data analysis (EDA) using Python to uncover trends, patterns, and insights.
• Developed optimized SQL queries, stored procedures, and ETL pipelines to support reporting and operational analytics.
• Built interactive dashboards and KPI reports using Power BI and Tableau to enable real-time performance monitoring.
• Automated data pipelines using SSIS and Python, ensuring high data accuracy and timely availability.
• Supported cloud migration initiatives and automated report refresh processes in collaboration with DevOps teams.
• Mentored junior analysts, promoting best practices in SQL, Python, and data visualization.