Bhugatha Bhargav

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.

• Developed efficient stored procedures for seamless data retrieval and manipulation, increasing application response time.
• Optimized existing PLSQL routines using performance tuning techniques such as indexing, query optimization, and partitioning strategies.
• Implemented advanced error handling techniques in PLSQL code, resulting in robust applications with minimal crashes.
• Improved database performance by optimizing PLSQL code and implementing best practices.

Project: CMU Dashboard
Role: Senior Database Developer / Software Engineer
Technology: Oracle Database, PL/SQL, Data Loading

Project Overview:
The CMU Dashboard project involved automating the loading of data from Excel sheets into database tables to ensure the availability of fresh data every morning. The project also focused on optimizing dashboard queries for efficient reporting.

Key Responsibilities:

• Data Loading Automation: Developed a UTL_PACKAGE procedure to load data from Excel files into database tables. Scheduled a job to run the procedure automatically every morning at 6:00 AM, ensuring timely data updates.
• Dashboard Optimization: Wrote optimized queries to support the dashboard, improving data retrieval performance and reporting accuracy.

Project: TaskMapper
Role: Senior Database Developer / Software Engineer
Technology: Oracle Database, PL/SQL, Dynamic SQL

Project Overview:
TaskMapper is a task management application similar to Jira, providing functionalities for user and project management, task assignment, and tracking. The application includes dynamic features that allow users to customize their workspace and workflow.

Key Responsibilities:

• User Management Module: Implemented role-based management, enabling users to create projects, add team members, and assign roles.
• Task and Subtask Management: Developed features for creating tasks and assigning them to team members. Supported the creation of subtasks to manage dependencies and ensure task completion.
• Dynamic SQL Development: Utilized dynamic SQL for data modeling, allowing users to create and delete fields in the front end dynamically, ensuring flexibility and customization.
• Dashboard Module: Wrote optimized select queries to support data visualization and reporting on the dashboard.