Business Intelligence Specialist - Sailotech Private Limited
(2025-07)
Client: Flutter | Platform: Tableau, Tableau Prep, Power BI, DAX, SQL, Excel
- Built an Attrition & Retention Insights dashboard in Tableau, used by 40–50 senior decision-makers to drill into resignation drivers and at-risk segments and shape executive retention strategy.
- Built Tableau Prep pipelines to clean, blend, and refresh data automatically, replacing ~45 days of quarterly manual PPT reporting with continuous daily reporting — cutting ongoing manual reporting effort from 2–3 hours/day to ~2 hours/month (~90% reduction).
- Gathered and translated business requirements into actionable reporting solutions; led UAT sessions and user training to drive adoption of self-service analytics.
Assistant Manager – Data Analytics - Kasmo Technologies
(2023-01 - 2025-06)
Clients: Cloudtaru, Veolia, Manjushree Technopack | Platform: Power BI, Tableau, SQL, Snowflake, ADF, Redshift, SQL Server, ERP (SAP, Infor, Workday)
- Built gauge-chart production performance dashboards (tracking downtime, operational efficiency, and shift utilization) and reconciliation/ticket-tracking dashboards on Amazon Redshift — categorizing tickets by reason, status, and resolution SLA (1 day, 5 days, >10 days) to improve operational transparency.
- Automated data refresh and Excel-based reporting workflows via Tableau Prep and scheduled extracts, cutting recurring manual reporting effort from 2–3 hours/day to roughly 2 hours/month across multiple client engagements.
- Designed Star Schema dimensional models in Snowflake and MS SQL Server; built and streamlined ETL pipelines in Azure Data Factory to integrate and reconcile data from ERP systems (SAP, Infor, Workday) alongside cloud and on-prem sources.
- Wrote and optimized complex SQL queries against SQL Server, Snowflake, and Redshift; tuned DAX measures and applied query folding to significantly cut report load times.
- Built semantic models with DAX Calculation Groups, Composite Models, and Incremental Refresh for asset management and financial KPI reporting.
- Led and mentored analytics teams ranging from 5 to 30 members depending on project scope; implemented RLS and OLS in Power BI and established BI governance covering data lineage, workspace governance, and reporting standards.
Data Analyst - Independent Consultant
(2019-10 - 2022-12)
Platform: Power BI, SQL, MS Excel
- Designed and delivered Power BI dashboards for multiple clients — writing SQL queries, building Power Query transformations, DAX measures, and KPI frameworks aligned to each client's business reporting needs.
- Established self-service analytics standards and reporting best practices, enabling clients to adopt data-driven decision-making independently.
Technical Lead – Data Analytics - Wipro Technologies Ltd
(2011-05 - 2016-09)
Platform: SQL, Oracle, MS SQL Server, SSIS, SSRS, Power BI, Tableau
- Led end-to-end Tableau and Power BI dashboard development across enterprise reporting initiatives spanning Asset, Work Order, Inventory, and Helpdesk Ticket dashboards, translating business requirements into interactive, self-service dashboards for leadership visibility.
- Built and optimized Tableau and Power BI reporting layers on top of SQL Server and Oracle, using SQL, SSIS, and Informatica-based ETL pipelines to consolidate data marts and keep dashboards fast and reliable.
- Drove dashboard and data visualization standards - from data prep and validation to technical documentation - and mentored junior analysts on BI best practices.
Sr. Software Engineer - SAIC
(2007-12 - 2011-05)
Platform: Oracle, Maximo, SQL, MS SQL Server
- Developed and maintained SQL-based data reporting and analytics solutions for enterprise asset management systems using Oracle and SQL Server.
- Provided incident, problem, change, and configuration management support for client requests using BMC Remedy and FootPrints, resolving IBM Maximo Asset Management issues including inventory and equipment transfer workflows.
- Built BRIO reports and screen enhancements per client requirements; documented resolutions and maintained audit-compliant logs for issue tracking.