Ragotham Kanchi

Responsibilities & Leadership

• Lead a cross-functional analytics team, overseeing project planning, task allocation, performance reviews, and delivery timelines.
• Partner with business stakeholders to define requirements, translate them into technical specifications, and deliver analytics solutions aligned with strategic objectives.
• Architect and manage Microsoft Fabric solutions, including Lakehouses, Warehouses, Datamarts, Eventhouses, and Dataflows Gen2 for API, on-premises, and cloud ingestion.
• Develop and maintain SSRS and PBIRS paginated reports for operational, compliance, and executive reporting needs.
• Use SSIS to create, schedule, and automate Excel workbook generation and data integration workflows.
• Enhance Power BI semantic models using Tabular Editor, SSAS XMLA endpoint connections, and DAX Studio for query optimization and performance tuning.
• Implement deployment pipelines for seamless promotion of reports, datasets, and models across environments.
• Manage data governance and quality control through automated validations, telemetry monitoring, and documentation best practices.
• Mentor and guide team members in Power BI, Fabric, SSRS, SSIS, Tabular Editor, SSAS, Python, and SQL development.

Core Projects Delivered

• Predictive Compliance Analytics Platform – Designed regression and Random Forest models to predict patch compliance rates; applied SHAP for interpretability in stakeholder reviews.
• Qualys Vulnerability Management Dashboard – Led end-to-end delivery of a centralized vulnerability analytics platform by extracting data from Qualys APIs, implementing ingestion into Microsoft Fabric’s OneLake via Data Pipelines, and designing interactive Power BI dashboards for security posture monitoring and executive reporting.
• Automated Patch Compliance Dataflow – Developed Fabric Dataflows Gen2 and Pipelines for API-based ingestion, reducing manual effort by 60% and improving refresh efficiency.
• Real-Time Telemetry Dashboard – Leveraged Log Analytics with Fabric Eventhouse for near real-time system monitoring, improving incident resolution by 35%.
• Enterprise Paginated Reporting Suite – Built and deployed SSRS and PBIRS reports integrated with Power BI datasets for hybrid reporting needs.
• Workbook Automation & Scheduling – Implemented SSIS workflows for automated Excel workbook creation and scheduled distribution to business units.
• Model Optimization Framework – Used Tabular Editor and DAX Studio via SSAS XMLA endpoint to optimize large semantic models, improving query performance and reducing refresh times.
• Unified Data Lakehouse Platform – Consolidated structured/unstructured datasets into a centralized Fabric Lakehouse for single-source-of-truth analytics.

Technical Stack

• Languages & Tools: Power BI, Microsoft Fabric, SSRS, PBIRS, SSIS, Tabular Editor, SSAS (XMLA), DAX Studio, KQL, SQL, T-SQL, Python, PySpark, Pandas, NumPy, Scikit-learn
• Data Engineering: Dataflows Gen2, Pipelines, Lakehouse, Warehouse, Datamart, Eventhouse
• Machine Learning: Regression, Random Forests, SHAP Explainability
• Integration & Monitoring: API ingestion, Log Analytics, Deployment Pipelines, Scheduled Workbooks

• Updated and developed scripts and queries to extract and analyze data from multiple sources.
• Created data models to support decision-making processes.
• Implemented business intelligence solutions to increase operational efficiency.
• Created dashboards to monitor and track key performance indicators.
• Utilized data visualization techniques to present and explain complex data sets.
• Generated standard and custom reports to provide insights into business performance.

Technical-Focused (for resumes targeting IT roles)

• Administered SCCM and Intune for application deployments, OS imaging, patch management, and compliance enforcement, ensuring accurate inventory and optimal device performance.

Business-Impact-Focused (for LinkedIn or HR-facing resumes)

• Streamlined endpoint management processes through SCCM and Intune, improving software delivery, compliance, and user experience across the organization.

Balanced Hybrid (mix of technical + business impact)

• Managed enterprise 500K endpoints via SCCM and Intune, delivering secure deployments, enforcing compliance policies, and reducing device-related support incidents.