Swasti Kumar

Coding Ninjas — Data Analyst Trainee (Jul 2024 – Present) Python ETL pipelines for 500+ records — 30% reduction in manual reporting effort 5 Power BI dashboards (DAX, Power Query) — adopted as primary decision tool in 4 weeks SQL query optimization and automated categorisation — 40% fewer ad-hoc data-fix requests KPI modeling directly with stakeholders — cut revision cycles from 3 rounds to 1 Collaborated with cross-functional stakeholders to define KPI requirements and deliver reporting solutions.

SQL stored procedure optimization across SSRS — 25% report performance improvement Automated ingestion-to-distribution pipeline — 100% on-time report delivery Idempotency + retry logic for REST API failures — 40% reduction in invoice-cleanup effort Retool automation tool with frontend validation — 35% fewer operational user errors Worked in an Agile environment using Jira for sprint tracking and Confluence for documentation

PostgreSQL/MSSQL query rewrites and index tuning — 35% application performance boost on 10,000+ IoT devices Debugging playbooks and automated monitoring alerts — 50% faster incident resolution Load-testing and performance profiling — zero regressions across 3 major releases Used Git and Jenkins CI for version control and pipeline deployment across Scrum-based release cycles.

Table partitioning on Cassandra and PostgreSQL — 35–50% reduction in query scan time on 5G telemetry data Dynamic stored procedures for RBAC — replaced manual DBA process across multi-tenant systems