Vanshika Singh Email & Phone Number

Kirkland, Wa, Us

Greensboro, North Carolina, United States

- Engineered a Python-based data archival pipeline for Azure SQL Database holding over 40M rows, leveraging Azure Data Factory for automated ETL operations and Databricks for real-time data transformations and aggregations. Optimized SQL query performance, reducing retrieval times by 65% and minimizing storage costs through efficient data partitioning and SQL indexing.- Shifted an existing batch processing pipeline to a data-driven architecture using Databricks, significantly enhancing real-time data processing and responsiveness. Implemented distributed processing patterns and optimized Spark jobs to handle high data throughput.

Greensboro, North Carolina, United States

- Redesigned an outdated distributed microservices system using Kafka for event-driven data streaming, improving overall reliability and scalability by 30%. Integrated Redis caching and adopted design patterns like Circuit Breaker to ensure high availability in high-load conditions.- Developed comprehensive technical documentation for the revamped architecture, detailing design patterns, microservices configurations, and scalability considerations for future enhancements.- Implemented CI/CD with Azure DevOps, integrating GitHub Actions, automated testing, and deployment pipelines, enhancing code reliability and deployment speed by 60%.- Led front-end feature enhancement using ReactJS within the MERN stack (MongoDB, Express, React, Node.js), improving user interface responsiveness and optimizing data flow between components with Redux and GraphQL for streamlined client-side state management.

Washington, United States

Chandigarh, India

- Executed full migration of the system code and database to MySQL 8, refactoring 40,000+ lines of Java and SQL code and updating 1800+ queries. Built automated testing workflows to validate API functionality, reducing manual testing by 50%.- Enhanced backend performance by 40% through Redis caching, advanced MySQL indexing, and Java-Spring Boot optimization. Implemented data structures and algorithms to minimize response times for high-traffic queries, improving end-user experience in transaction-heavy environments.- Integrated push notification services using Java, Spring Boot, and Firebase Cloud Messaging (FCM) to support real-time alerts for mobile applications.- Designed a secure AWS-WAF firewall with custom rule sets to bolster application security and DDoS protection. Utilized OAuth and encryption methods for data protection in financial transactions.- Led and mentored a team of four backend engineers in Agile development, focusing on Java design patterns (Factory, Singleton, Dependency Injection) and RESTful API design principles for scalable and maintainable codebases.

Chandigarh, India

- Served as the primary contact for production issues across a highly distributed service infrastructure, providing on-call 24/7 support. Used monitoring tools like solarwinds for in-depth analysis, ensuring timely hotfixes and minimal downtime.- Developed a secure transaction encryption model in FinTech using Java with AES and MD5 algorithms, enhancing ACH, Wire, and Check payment security. Integrated Keycloak for SSO and strong authentication.- Optimized performance across 160+ APIs by adopting advanced data modeling with techniques inspired by Google Bigtable. Leveraged Redis caching and code refactoring to increase API response times and scalability.- Guided a team of five interns on backend development with Java, SQL, and scalable design principles, ensuring the successful delivery of sprint tasks. Implemented Git-based version control and Jenkins for CI/CD.

- Designed and implemented new banking system entities such as Beneficiary and Authorized Contact using Java, SQL, and REST APIs, contributing to core banking functionalities.-Built and tested a service provider portal using ReactJS and Java, covering over 650 test cases for functionality and compatibility.-Independently designed an IVR integration with Ring Central APIs using Java, increasing customer service efficiency by 40% with an asynchronous communication model.-Integrated with Esker for efficient document and check delivery in payment processing, using Java and JSON parsing to build reliable APIs and workflows in a large-scale, microservices-based infrastructure.

Master Of Science - Ms, Computer Science

Activities and Societies: Member : Women in Computer Science, Society of Women EngineersCourses: Design and Analysis of Algorithms.

Bachelor Of Technology, Computer Science, 8.8 Cgpa

Activities and Societies: Coding Ninja BatchCourses: Operating Systems, Data Structures, Network Design and Management, Object Oriented.