ISHIKA MISHRA

1. Delivered $20M+ annual impact by reducing SAP workload deployment time by 50% through the design and rollout of Colo Solver 2.0—a scalable, rule-driven planning engine. Architected and coded 10+ modular, fault-tolerant job flows with robust error handling and full unit test coverage, from scratch enabling long-term maintainability and scalability.

2. Built a fault-tolerant, automated data sync platform to forecast power availability across Region, AZ, and DC levels. Designed a cron-based ingestion pipeline, persisted data to Data Lake, and integrated with Colo Solver to replace manual workflows and improve forecast accuracy—enabling data-backed capacity planning.

3. Resolved a P0 performance bottleneck in Power BI dashboards used for Colo planning. Optimized queries, removed unused data, and reduced refresh time from 2+ hours to under 30 minutes. This ensured real-time insights and eliminated UAT failures, directly improving planner productivity.

4. Refactored Buffer Planning SLA monitoring to address synthetic test latency spikes. Re-architected polling logic using exponential backoff, reducing average runtime from 10 min to , and ensuring 100% SLA compliance with improved system reliability.

5. Owned end-to-end delivery of the unified SAP Capacity Planning Dashboard, collaborating with cross-functional teams from requirements to production. Built scalable aggregations by Region, AZ, and T2 tiers with dynamic filters. Eliminated manual Excel workflows, streamlined capacity reviews, and received strong stakeholder praise for usability and performance.

Tech Stack: C#, SQL, Kusto, Power BI, Azure Data Lake, ADF, Cron, Git, Azure DevOps

• Directed the AI team in crafting a translation application, incorporating Python, FastAPI, and Hugging Face's translation models.
• Achieved a reduction in XLS and TXT translation times from 7 minutes to 60 seconds through advanced multithreading and multiprocessing techniques.
• Migrated to a microservice architecture for improved scalability and streamlined translation processes and successfully migrated the translation platform to AWS, ensuring enhanced scalability and uninterrupted service.
• Tech Stack: Python, FastAPI, Hugging Face Transformers, Docker, AWS, REST APIs, Git

• Built high-performance APIs using Python and Django to improve app functionality and user engagement.
• Integrated Celery servers for asynchronous task handling, achieving faster response times under a second.
• Designed an Analytics dashboard for performance monitoring and optimization across all core services.
• Implemented Trainman's Advanced Train Detection feature to suggest alternate stations for users, resulting in a 10k average increase in platform traffic.
• Managed a team of junior developers and interns, gathering requirements from various departments to deliver features and enhancements based on business needs.
• Tech Stack: Python, Django, Celery, Redis, PostgreSQL, JavaScript, HTML/CSS, REST APIs, Git

• Worked with a team in implementing a backend of Unified Communication Domain for Intel Client, which provides backups and real-time status of devices before and after an activity. Hosted the application on Amazon EC2 and wrote the business logic using Python and Django.
• Tech Stack: Python, Django, Amazon EC2, PostgreSQL, REST APIs, Git