Prachi Singh

1.Scaling eBook Processing Infrastructure

Designed and deployed a multi-environment scaling solution using AWS Auto Scaling Groups (ASGs) and host provisioning across 3 service teams to resolve a capacity mismatch where bulk ingestion of 45,000 books overwhelmed downstream systems limited to 1,000 items/day.

Impact: 400% throughput increase (1K to 5K books/day), 50K peak batch capacity, 45,000-book backlog cleared in 6 days, publishing cycle reduced from 15 to 7 days, 30% fewer support tickets (96/month reduction), 12 Sev-2 incidents prevented, zero downtime during rollout.


2. Multi-Region Instance Migration (18 Fleet Environments)

Led a 3-month migration of 18 fleet environments across 3 AWS regions, upgrading 19 legacy instance types to Graviton 3 ARM-based (i4i, m6g, r6g) and AMD-based (m6a) instances to meet peak scaling targets.

Impact: 45% compute capacity increase, peak throughput expanded from 1M to 2.5M TPS, $160K annual infrastructure cost reduction, 99.99% availability maintained with zero-downtime cutover, capacity constraints eliminated through 2030.


3. Authentication Protocol Migration (66 Environments)

Migrated 3 content processing applications from legacy symmetric authentication to CloudAuth protocol across 66 environments, managing 6 downstream service integrations with 8 days of continuous monitoring.

Impact: 100% legacy vulnerability elimination, auth latency reduced 35% (200ms to 130ms), 95/100 security audit score, all 8 security mandates and 3 encryption standards met, 99.99% availability maintained, completed ahead of deadline.


4. 14M-Book Accessibility Backfill - European Accessibility Act (EAA) Compliance

Performed capacity and cost analysis across 7 service environments for a 14M-book headings conversion backfill; modeled infrastructure costs across multiple TPS scenarios, identifying execution paths ranging from 41 to 162 days ($241K to $267K).

Impact: Delivered a four-phase rollout plan prioritizing high-impact accessibility content with dedicated TPS allocations and graceful failover; team completed the fastest path ahead of the EAA June 2025 deadline; framework reused for subsequent catalog-wide updates.


5. Multimedia eBook Preview Restoration

Diagnosed broken book preview functionality for multimedia-rich eBooks caused by automated preview workflows triggering incorrectly when publisher-provided samples were absent; coordinated a fix across Vendor Management, Technical Account Management, and Ingestion teams.

Impact: Restored customer preview experience for multimedia titles, eliminated recurring cross-team escalation overhead, established SOPs and publisher-facing FAQs preventing recurrence.


6. Legacy Format Ticket Elimination (938 Annual Tickets)

Led a cross-functional initiative targeting 938 annual customer tickets (96/month) for a deprecated eBook format; analyzed ticket routing root causes, redesigned routing mechanisms, and updated SOPs for internal and outsourced support teams.

Impact: 100% ticket elimination for the legacy format, 51% reduction in overall team incoming tickets, operational excellence score improved from 11 to 23.


7. Operational Readiness Review (ORR) - Preview Workflow

Led the ORR using the AWS ORR template, evaluating 147 assessment points (95 manual, 52 automated) and coordinating with senior/principal engineers and service teams.

Impact: 15 new runbooks created, 8 procedures updated, 5 automated monitoring solutions implemented, documentation coverage increased from 65% to 100%, onboarding time reduced from 4 to 2 weeks, MTTR reduced by 40%.


8. Ingestion Pipeline Bug Fix - Date Format Parsing

Identified a date format inconsistency (underscores vs. hyphens in timestamps) in an upstream service parameter blocking 952 file conversions; implemented a backward-compatible regex fix across two downstream services.

Impact: 952 stalled conversions unblocked, normal processing restored for 15,000 daily uploads, ingestion failures reduced by 23%, zero regex-related failures over the next 30 days.


9. Legacy Service Deprecation (45 Version Sets, 12 Services)

Executed a deprecation and migration plan across 45 version sets - deprecating 5 services and migrating 7 from legacy authentication to CloudAuth - to eliminate vulnerabilities in 20-year-old service calls.

Impact: 8 legacy service calls eliminated, service latency improved 25%, security scan coverage increased from 82% to 100%, memory utilization reduced 15%, all migrations completed ahead of deadline.


10. Vendor Catalog API Migration (100K Daily Transactions)

Migrated 3 high-traffic services processing 100,000 daily transactions from a deprecated vendor catalog API to a modern data path; executed phased load testing at 2x normal load (120K transactions/day) across 8 downstream dependencies.

Impact: 99.99% parity with legacy system, API response time improved 33% (180ms to 120ms), error rates reduced from 0.02% to 0.005%, reusable migration pattern established cutting future integration time from 4 to 2 weeks per service.


11. Monolithic Storage Format Deprecation ($160K Cost Elimination)

Led a cross-team investigation analyzing storage usage patterns, regionalization needs, and access methods across 4 scope views to identify safely depreciable monolithic eBook storage formats.

Impact: Annual infrastructure costs reduced from $160K to $0; framework established for future storage deprecation decisions.


12. Format Conversion Validation Enhancement

Investigated 26 titles triggering validation errors during eBook format transitions; implemented refined validation logic to handle null source file locations while preserving existing checks for other conversion types.

Impact: All 26 affected titles resolved, unblocked a program improving fixed-layout book processing. validation system made more robust for format switch scenarios.


13. Dashboard Access Control Fix (Java Servlet/JSP)

Identified a bug in a Java Servlet/JSP-based dashboard allowing unauthorized suppression of eBook delivery facets, dropping a delivery metric from 100% to 93%; implemented access-controlled redirect logic with user audit tracking.

Impact: Delivery metric restored to 100%, unauthorized access eliminated, audit trail added for all suppression actions. Tech: Java Servlets, JSP, HTTP Servlets.


14. Authentication Layer Migration (JSP Backend)

Migrated a dashboard's authentication layer from a deprecated access management service to a modern authorization API, removing all legacy dependencies from config and header files in a JSP-based backend.

Impact: Eliminated outage risk from service deprecation, simplified authentication codebase, maintained uninterrupted access for customer service, account management, and engineering teams.


15. Inbound CloudAuth Integration (TLS Configuration)

Integrated CloudAuth with inbound API calls of a content conversion service supporting iOS reading experience; configured end-to-end TLS for the load balancer and registered new authentication endpoints across multiple environments.

Impact: Zero customer impact during migration, supported org-wide executive mandate to upgrade all services to modern encrypted authentication.


16. Language Support Expansion (eBook Conversion Pipeline)

Identified a gap where the eBook conversion system rejected content in a supported language, impacting 250 publishers and blocking ~1,000 titles; implemented configuration updates to enable processing.

Impact: Language-related conversion failures reduced from 15% to 0%, 300 blocked titles processed in the first month generating $45K in new revenue, language coverage expanded to 77, future language integration time reduced from 2 weeks to 3 days.