Systech Solutions · Client: OLAM
▲ Saved 2–3 hrs of manual work per day
Designed and built a complete end-to-end analytics solution as sole individual contributor for one of the world's largest agriculture export companies. The project replaced a fully manual Excel-based reporting process with an automated, database-driven daily refresh pipeline.
- Database design using Kimball Methodology and Star Schema
- Built ETL pipeline for daily automated data ingestion and processing
- Created BI-ready tables and views in the data warehouse
- Processed and loaded 10 years of historical data — creating a strong analytical foundation
- Delivered final dashboards providing daily cost and freight visibility
Kimball MethodologyStar SchemaETL PipelineDashboardData Warehouse
Tiger Analytics · Insurance Clients
▲ Used by senior leadership for strategic performance decisions
Led comprehensive exploratory data analysis to support a data science team building an insurance advisor segmentation model using clustering. The final dashboards became a key tool for senior leadership to monitor advisor performance and guide strategic decisions.
- Performed EDA using SQL and Tableau to identify key variables and fields
- Worked closely with data scientists to define clustering inputs and validate outputs
- Built multiple EDA dashboards to visualise distributions and patterns
- Delivered post-clustering dashboards highlighting advisor strengths and improvement areas
- Dashboards adopted by senior leadership for ongoing advisor performance reviews
TableauSQLEDAClusteringLeadership Dashboard
Trimble Inc.
▲ Batch → Live streaming with RLS data governance
Led the migration of operational dashboards from a batch-refresh model to live streaming at Trimble, providing real-time visibility into service team operations. Implemented data governance controls as part of the migration.
- Migrated Snowflake-based pipelines from scheduled batch to live streaming
- Rebuilt Power BI dashboards to consume real-time data feeds
- Implemented Row-Level Security (RLS) in Power BI semantic models
- Controlled user access so teams only see their own operational data
- Led 3-member team through the migration with onsite stakeholder coordination
SnowflakePower BIRow-Level SecurityReal-TimeData Governance
Autodesk India Pvt Ltd
▲ 7–10 min → 1–2 min per request · ~50 hrs/year saved
Automated the Salesforce portfolio member creation process using Python scripting, dramatically reducing the time taken to process each change request across a high-volume annual cycle.
- Analysed existing manual process and identified automation opportunities
- Built Python automation scripts to handle portfolio member creation in Salesforce
- Reduced per-request processing time from 7–10 minutes to 1–2 minutes
- Applied across 500+ annual requests — saving approximately 50 hours per year
PythonSalesforceAutomationSales Operations
Autodesk India Pvt Ltd
▲ 70% adoption across 600+ annual requests
Designed Excel automation templates using VBA and advanced formulas to streamline the sales team's assignment request workflow, replacing a previously manual and error-prone process.
- Built Excel templates with VBA macros and formula automation
- Templates auto-populate assignment data, reducing manual data entry
- Rolled out to sales teams — 70% of 600+ annual requests now use the template
- Significantly reduced per-request effort and improved data accuracy
Excel VBAFormulasAutomationSales Operations
Autodesk India Pvt Ltd
▲ SLA breach reduction without adding headcount
Built an Incident Timeline dashboard to give operations leadership clear visibility into where and why SLA breaches occur, enabling data-driven process improvements rather than reactive resource additions.
- Modelled incident lifecycle data from ServiceNow into Power BI
- Identified incident state as the primary factor driving SLA breaches
- Enabled business to understand handoff delays between customer and internal teams
- Teams improved coordination workflows based on dashboard insights
- Reduced SLA breach frequency without adding shifts or headcount
Power BIServiceNowSLA AnalyticsOperations
Personal Initiative · Voluntary
▲ Proposed to Kerala CM's office and individual MLAs
Independently designed and proposed a citizen-facing grievance tracking and routing platform to improve government accountability and transparency in Kerala. A voluntary public service initiative applying BI and data architecture expertise toward civic impact.
- Designed intelligent grievance routing logic based on department and category
- Proposed data-driven visibility into resolution timelines and bottlenecks
- Formally submitted to the Kerala Chief Minister's office
- Actively pitching to individual MLAs across Kerala constituencies
- Creates Malayalam and English social media content on governance and public policy data
Civic TechData ArchitecturePublic PolicyKerala