Malothu Surender Nayak

Project: Material Moving Control System (MMCS) – Version 2 (Matone) Role: Senior Database Developer / Software Engineer Technology:

Oracle Database, PL/SQL, Data Modeling Project Overview: The second version of the Material Moving Control System (Matone) expanded on the initial automated processes by introducing a more flexible, request-based system for inventory issuance and storage. This version introduced advanced validation methods and enhanced user management capabilities.

Key Responsibilities: Enhanced Issuance Process: Implemented a request-based issuance process, allowing quantity-based dispatching through prepared, dispatched, and delivered methods. Enhanced validation methods tailored to article transition types (manual, pallet, trolley) with dynamic stepper flows.

Improved Storage Process: Developed a partially automated storage system.

Refilling against purchase orders is automated for some articles, while others require manual input.

Generated Material Issue Notes (MIN) and managed the full transition from request to bin storage.

Advanced Development: Created and optimized medium to complex select queries, audit tables, and stored procedures to support the new workflows.

• Extended the Dashboard Module to include material balance, transaction pallets, and user-wise transactions.
• Expanded User Management: Added roles and modules, including scrap and QC reject management, with updated auditing and data modeling.

Project: Material Moving Control System (MMCS) Role: Senior Database Developer / Software Engineer Technology: Oracle Database, PL/SQL, Data Modeling Project Overview: The Material Moving Control System (MMCS) is an inventory management web application designed to detect, store, and issue pallets inside a warehouse.

The application is fully automated and helps streamline warehouse operations, ensuring efficient pallet management and article issuance.

Key Responsibilities:

Dashboard Module: Developed optimized select queries and utilized materialized views for efficient data retrieval and analysis.

Activity Module: Designed and implemented data models for pallet storage. The application automatically detects storage locations and processes article issuance requests. Implemented article-wise thresholds to trigger alerts when stock levels are low in day storage. User Management Module: Designed role-based management, including developing stored procedures and triggers for auditing.

Data Modeling and Optimization: Engaged in data modeling, writing stored procedures, creating triggers, and optimizing select queries for high performance.

Project: R-Works Role: Senior Database Developer / Software Engineer Technology: Oracle Database, PL/SQL, Data Migration Project Overview: R-Works is a procurement tool focused on migrating database objects from one schema to another. The migration process was implemented using the NewEnergy database and a DB link, ensuring data integrity and synchronization across systems.

Key Responsibilities: Data Migration: Developed and optimized stored procedures to efficiently migrate data from source tables to the target schema using the NewEnergy DB link.

Job Automation: Created jobs to automate data import procedures, ensuring regular synchronization between schemas.

Monitoring and Maintenance: Actively monitored the daily execution of jobs, manually intervening to rerun procedures in case of job failures, thereby maintaining data consistency.