SANJANA ANUMANDLA

• Worked in an agile development team to create, test, and deploy production services for Office Depot's Warehouse Management Systems.

• Led the development team in implementing a core solution for the DFI project, leveraging Office Depot's freight services for partner package deliveries.

• Developed modular components using Spring Boot and Java within a microservices architecture for seamless integration and scalability.

• Utilized Azure AKS Kubernetes to orchestrate services, ensuring efficient management of Office Depot's freight operations.

• Implemented Kafka to process delivery details in real-time and generate unique IDs and dates for warehouse drivers.

• Led enhancements to a Warehouse Management System (WMS) for a retail client, including real-time inventory tracking and automated order processing.

• Integrated RESTful APIs for smooth communication with external systems such as inventory suppliers and shipping carriers.

• Spearheaded the redesign of a legacy CRM system for a financial services company, implementing a new Oracle database schema for optimized data storage and retrieval.

• Developed complex SQL queries and stored procedures to support advanced customer segmentation and analysis features.

• Utilized JavaScript frameworks like AngularJS and React to create dynamic and responsive user interfaces, improving user experience and engagement.

• Established version control and CI/CD pipelines for efficient software development processes.

• Implemented automated testing suites using JUnit and Mockito to ensure code quality and reliability.

• Enhanced critical modules within the Warehouse Management System (WMS) using advanced Struts/Tiles and Struts 2 frameworks, optimizing performance and scalability.

• Developed custom Servlets and JSP components to streamline order processing and inventory management functionalities, resulting in improved order fulfillment accuracy.

• Utilized advanced JPA/Hibernate features for efficient database interactions within the WMS, reducing query response time.

• Implemented complex DML and DDL statements in PL/SQL to handle intricate data transformations and schema modifications, ensuring seamless integration with legacy warehouse systems and third-party logistics partners.

• Implemented robust role-based security measures within the WMS, leveraging Oracle database features to enforce data access controls and protect sensitive warehouse information.

• Collaborated closely with the B2B team to ensure seamless integration of services, facilitating smooth communication and data exchange between internal and external systems.

• Conducted active code reviews and provided on-call support for project maintenance, ensuring high-quality code and continuous system availability.

• Collaborated with project managers to gather requirements and define project scope, ensuring alignment with business objectives and customer needs.

• Designed the flow and architecture of projects using Lucid charts for visualization and established Jenkins pipelines for continuous integration and deployment, ensuring efficient delivery of updates and enhancements.

• Implemented new delivery routes suitable for drivers, resulting in improved on-time delivery rates and enhanced customer satisfaction.

• Developed barcodes and labels crucial for drivers in various warehouses and states, utilizing PostgreSQL for data storage and database tables.

• Addressed challenges related to holiday calendar misalignment by proposing and implementing solutions using environment variables and Rancher secrets.

• Played a key role in maintaining smooth operation of delivery processes by proposing and implementing on-the-spot resolutions to challenges.

• Led the system design and documentation phase for large-scale enterprise applications, collaborating with stakeholders to gather requirements and create detailed use case diagrams using UML.

• Designed system architecture and components, documenting them using UML class diagrams and sequence diagrams.

• Prepared technical specifications and user manuals following ISDM guidelines, ensuring clarity and completeness.

• Conducted performance tuning and optimization for high-traffic web applications, analyzing database query execution plans using TOAD and SQL Developer to identify bottlenecks.

• Leveraged industry-standard protocols and technologies to integrate Warehouse Control Systems (WCS) with other warehouse systems, ensuring real-time visibility and control over warehouse activities.

• Spearheaded the migration of legacy monolithic applications to Kubernetes-based containerized deployments on Azure cloud, achieving cost reduction and improved resource utilization.

• Deployed and managed applications on AWS cloud infrastructure, utilizing AWS services for scalability, reliability, and security.

• Installed Kafka and configured producer and consumer coding for establishing connections, developed back-end rest services to manage databases, and integrated GitLab CI/CD pipelines for automated deployment.

• Developed and implemented complex database objects using PL/SQL for ETL tasks, contributing to streamlined data workflows.

• Developed the Eos Toolkit application for Office Depot's Warehouse Management system using Next.Js and JavaScript, designed webpages using HTML5, CSS3, JavaScript, React.js, and next.js, and built components library including Tree, Slide-View, and Table Grid.

• Used ReactJS to build UI components and developed filters for displaying data, implemented unit tests and automated testing using JUnit, Mockito, JMeter, Newman, and Cucumber.

Environment: Java 1.8, JavaScript, REST, SOAP, Spring Boot, visual studio, HTML, CSS, Jenkins, MSSQL, Kafka, React.js,next.js, JUnit, Eclipse, Git, node.JS, HDFS, Java 11, PLSQL, Jmeter, Newman, AWS

• Responsible for overseeing the development, migration, restructuring, and ongoing support of various modules within the E-commerce Application.

• Contributed effectively to Agile development teams, actively engaging in sprint planning sessions and ensuring adherence to Agile/Scrum methodologies.

• Played a pivotal role in the redesign of the front-end interface for an e-commerce website catering to a retail clientele.

• Leveraged AngularJS to craft dynamic and engaging product catalogs and shopping cart functionalities.

• Implemented React components to deliver real-time product recommendations and personalized shopping experiences.

• Integrated JavaScript frameworks with backend APIs to facilitate seamless data synchronization and updates.

• Architected and developed a robust real-time Transaction Monitoring System utilizing advanced Struts 2 and Servlets/JSP frameworks, seamlessly integrating with legacy mainframe systems via JDBC for efficient transaction data retrieval and processing.

• Engineered and optimized Oracle database schemas to support real-time transaction processing, employing partitioning strategies and advanced indexing techniques to handle large transaction volumes with minimal latency.

• Implemented intricate PL/SQL stored procedures and functions to execute transactional data transformations and aggregations, enabling real-time analytics and reporting functionalities within the monitoring system.

• Deployed granular role-based security controls within the system, leveraging Oracle Virtual Private Database (VPD) to dynamically filter sensitive transaction data based on user roles and access permissions.

• Implemented advanced database security measures such as Transparent Data Encryption (TDE) and Database Vault to safeguard sensitive transactional data both at rest and in transit, ensuring compliance with industry security standards.

• Developed an extensive dashboard catering to mortgage officers, delivering real-time insights into loan statuses, interest rates, and application progress.

• Enhanced the loan application interface to optimize data input and streamline the application submission process.

• Integrated credit scoring systems into the GUI, enabling loan officers to access and analyze borrower credit scores seamlessly within the application.

• Designed and implemented event-driven architectures utilizing the Kafka messaging platform, facilitating seamless data streaming and processing across distributed systems.

• Integrated Angular applications with RESTful APIs to fetch and display data from backend services effectively.

• Implemented GitLab CI/CD pipelines to automate the build, test, and deployment processes of Java applications, resulting in a 40% reduction in release cycle time and increased development efficiency.

• Ensured fault tolerance and message durability by configuring Kafka producers and consumers with appropriate acknowledgment settings and replication factors.

• Implemented Kafka consumer groups to achieve parallel processing and efficient load balancing.

• Utilized Azure cloud services for scalable and reliable hosting of web applications, ensuring high availability, disaster recovery, and compliance with security standards.

• Implemented serverless architectures using AWS Lambda functions for event-driven computing.

• Configured alerting rules within Grafana to proactively detect and notify stakeholders about abnormal system behavior.

• Developed Restful Web services using Spring Boot to handle HTTP requests and responses effectively.

• Created real-time data pipelines for streaming data using Kafka and Spark Streaming.

• Monitored AWS services using Amazon CloudWatch and monitored application logs using Amazon CloudWatch Logs.

• Demonstrated proficiency in creating and customizing database monitoring and alerting solutions within OEM.

• Enforced version control best practices within GitLab repositories, including branching strategies, commit message conventions, and code review workflows.

• Implemented GitLab hooks and webhooks to trigger automated processes and maintain code consistency.

• Created Unit and Integration test cases in JUnit4 to execute in Maven builds using Jenkins.

• Developed user-friendly web-based applications using AngularJS, HTML5, CSS3, Bootstrap, Spring, and MongoDB.

• Integrated ReactJS with RESTful APIs to facilitate seamless communication between the frontend and backend systems.

• Utilized asynchronous programming and AJAX techniques to optimize data retrieval and updates without disrupting the user experience.

• Developed and executed PL/SQL scripts for data extraction and transformation, ensuring the integrity and consistency of data across various processes.

Environment: Java 1.8, REST, SOAP, Spring Boot, OAuth 2.0, Hibernate, D2, Log4J2, MSSQL, JMS, Kafka, JUnit, Mockito, IntelliJ, Data Grip, AWS, HTTP, HTML5, CSS3, JPA, DAO, MS SQL, CloudWatch, Rest.

• Engaged in all phases of the Software Development Lifecycle (SDLC), employing agile methodology with bi-weekly iterations for analysis, design, development, and testing.

• Created and deployed RESTful web services using Java, Spring Boot, and related technologies to support diverse business functions and integration needs.

• Designed and executed custom APIs to expose internal system functionality and data securely and efficiently to external clients.

• Led the development and rollout of a student enrollment tracking system for NSC, utilizing Java and J2EE technologies for a web-based application interfacing with Oracle databases.

• Integrated with Oracle databases to securely manage student enrollment records and ensure compliance with data privacy regulations.

• Developed a user-friendly interface using AngularJS, enabling easy management of student enrollment data for NSC staff.

• Implemented role-based access controls to safeguard student enrollment records and manage user permissions effectively.

• Managed version control and collaboration using Git, ensuring codebase integrity and efficient code management.

• Implemented continuous integration pipelines with Jenkins for automated build, test, and deployment processes, ensuring rapid delivery and system reliability.

• Collaborated with stakeholders, including NSC's data analysts and educational institution partners, for successful system deployment.

• Spearheaded redevelopment of the Student Enrollment Tracking System, modernizing the user interface and enhancing system performance with Servlets/JSP and JPA/Hibernate frameworks.

• Designed and optimized a comprehensive Oracle database schema to support complex enrollment data queries and reporting.

• Developed advanced PL/SQL stored procedures and triggers for automated data validation and business rule enforcement.

• Implemented a role-based access control (RBAC) model with LDAP integration for user authentication and authorization.

• Applied Information Systems Development Methodology (ISDM) principles to analyze requirements and design scalable solutions for NSC's student enrollment data.

• Contributed to system scalability and performance optimization to meet NSC's growing data processing needs.

• Deployed and managed AWS infrastructure, utilizing services like EC2, RDS, VPC, Route53, and others for system deployment and management.

• Designed xml Schema for student matching algorithm and contributed to D2-Documentum enhancements.

• Developed custom instrumentation for Java applications for monitoring and analysis using Prometheus.

• Orchestrated end-to-end CI/CD pipelines with GitLab for code integration, testing, and deployment.

• Created Terraform templates for AWS resource provisioning and utilized Terraform graph for execution plan visualization.

• Integrated automated testing frameworks into GitLab pipelines to ensure code quality and reliability.

• Developed Java APIs for Amazon Lambda to manage AWS services.

• Implemented Model-View-Controller (MVC) Architecture using Spring Frameworks and Application Servers like Mongrel, Passenger, JBoss, and WebLogic.

• Leveraged TOAD for efficient database querying and analysis.

• Deployed Spring Boot based microservices Docker containers using Amazon EC2 container services.

• Implemented multiple JUnit test cases following TDD principles.

• Generated various reports using JReports API for different student ethnic groups.

• Developed a distribution mechanism for multi-client message delivery.

• Built middle-tier and business layer services using Spring MVC and Hibernate.

• Collaborated closely with business stakeholders to translate reporting requirements into effective Cognos solutions.

• Researched and proposed new technologies to improve system architecture.

• Developed presentation layer using HTML5, jQuery, AngularJS, and Bootstrap.

• Designed and developed Angular services/directives for reusable components and implemented Apache Axis Web Services for displaying signatures on spreadsheets and table resources.

Environment: Java 1.6/1.7, WebLogic Application server 6.x, MQ Series, D2-Documentum, IntelliJ, IDEA IDE,JReports, Mongo DB, LDAP, Spring, testing framework, JMS, Kafka, JUnit, Jenkins, Oracle10g, Maven, Git

• Played a key role in developing and customizing software solutions for the supply chain domain, with a focus on warehouse management and logistics operations at Rio Software client.

• Led the development of a supply chain visibility platform to optimize warehouse management and logistics operations for Rio Software Technologies' clients.

• Used Java EE design patterns and technologies to create scalable and efficient solutions tailored to the supply chain domain.

• Directed the development of a Supply Chain Visibility Platform using Struts/Tiles and Struts 2 frameworks, implementing a modular architecture for seamless integration with external supply chain systems via RESTful APIs.

• Designed and optimized Oracle database schemas, employing partitioning and indexing strategies for real-time supply chain data ingestion and analysis, and implementing advanced PL/SQL algorithms for data aggregation and forecasting.

• Implemented a comprehensive role-based access control (RBAC) model within the platform, integrating with Active Directory for user authentication and LDAP for role-based authorization, and enforcing fine-grained access controls based on user roles and permissions.

• Applied Information Systems Development Methodology (ISDM) principles for thorough requirements gathering and analysis, system architecture design, and development of scalable solutions to meet dynamic supply chain stakeholder needs.

• Utilized Bootstrap framework to implement responsive design principles, ensuring optimal user experience across desktop and mobile devices for supply chain visibility platform users.

• Employed Spring Boot framework to develop modular components and microservices architecture, facilitating flexible and agile platform development.

• Integrated with Kubernetes for container orchestration, ensuring scalability and reliability in cloud-based environments.

• Designed and implemented declarative configuration files (YAML) to define Kubernetes objects such as pods, services, and deployments, ensuring consistent and reliable deployment of supply chain solutions within warehouse management systems.

• Implemented event-driven architectures using Kafka messaging platform, enabling seamless data streaming and processing across distributed systems.

• Collaborated with Quality Assurance (QA) teams to ensure platform quality and reliability through thorough testing and validation.

• Prepared comprehensive documentation and technical reports during development to facilitate knowledge transfer and ensure efficient support and maintenance of the platform.

• Worked closely with stakeholders to gather requirements, conduct user acceptance testing, and successfully deploy the supply chain visibility platform.

• Contributed to continuous improvement and enhancement of the platform by incorporating feedback from clients and stakeholders to deliver solutions aligned with evolving business needs and industry standards.

• Utilized Java EE design patterns like Value Object Pattern, Business Delegate, Service Locator, and Singleton to develop scalable and efficient solutions for supply chain clients within the warehouse management domain.

• Provided technical support and troubleshooting expertise using OEM to promptly address database-related issues, ensuring continuous operation of supply chain solutions with minimal downtime.

• Collaborated with Quality Assurance (QA) teams to smoothly transition supply chain solutions to the production environment, ensuring seamless integration and deployment for warehouse management systems tailored to supply chain clients.

• Prepared technical reports and documentation manuals during the development of warehouse management solutions for supply chain clients, facilitating knowledge transfer and ensuring efficient supply chain operations.

Environment: JDK 1.6, Supply Chain Domain, Warehouse Management Systems (WMS), Warehouse Execution Systems (WES),Warehouse Control Systems (WCS), Java EE, GitLab, Kubernetes, SQL, OEM, Oracle SQL Developer Data Modeler