Rohan Kumar Katkam

Received strong recommendation from Director of Engineering citing "measurable positive impact on project velocity and code quality" with endorsement for future engineering roles.

• Reduced financial analysis query time from hours to under 30 seconds by building AI-powered text-to-SQL system with 99%+ success rate, enabling non-technical analysts to perform complex multi-company comparisons through natural language interface.
• Automated categorization of 1,700+ daily financial news articles across 10,000+ ticker symbols from 189 publishers through adaptive clustering pipeline, eliminating manual categorization and enabling real-time market sentiment tracking.
• Delivered 3 production web applications serving internal analysts and traders, including Flask-based dashboards with REST APIs for news clustering, financial analysis, and HR candidate evaluation workflows.
• Achieved 99%+ clustering accuracy across 166K+ articles over 60 days by engineering adaptive algorithms with zero hardcoded parameters, automatically adjusting to data characteristics using statistical optimization methods.
• Standardized HR candidate evaluation process by developing AI-powered recruitment assistant that generates evaluation rubrics, ranks candidates, and produces personalized interview questions, reducing recruiter screening time.

• Built AWS-based data pipeline (S3, Glue, Athena) to process 100K+ public safety records for real-time analysis.
• Designed Power BI dashboard with 12+ KPIs and DAX measures for citywide performance insights.
• Automated ETL and AI summaries reducing manual reporting time by 60%.

• Automated risk scoring across 286K+ payment records from 28 agencies and 650+ vendors, replacing 2,400+ hours of manual Excel analysis
• Built 8-worksheet risk framework reducing audit planning from weeks to hours using spending concentration and temporal pattern detection
• Identified 12 high-risk vendors, 7 agencies with unusual patterns, and 15+ procurement inefficiencies through evidence-based roadmap

• Delivered 10+ analysis-ready GeoPackages processing 49K service requests across 35 Nashville districts, reducing spatial analysis prep from hours to minutes
• Implemented adaptive classification with silhouette-guided clustering that automatically adjusts to data changes without manual recalibration
• Automated end-to-end workflow from ArcGIS REST API to GeoPackage generation enabling predictive hotspot and capacity planning analysis