Description
I am Application Software Developer having 6+ years of experience in Application Software development using Oracle, Postgres. Developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.- Having 6+ years of experience in Application Software development using Oracle, Postgres
- 1) Project Abstract: The cars sales module is fully integrated with Proactive Automotive ERP system that extends the automation to the workshop management system, stock control management system and other back and front office modules. The system supports multi-brands and multi-branches automation and provides our customers with the latest technology that helps them get the best performance with real-time information needed for the different levels of managements.
- The system setups and identifies all cars stores/branches of the company and its users’ privileges to use different system functions as per company policy.
- The system also allows the users to setup all car models, types, color codes, accessories, customers’ data, suppliers, and other basic data required for the system workflow.
- Module: DMS (Dealer Management System)
- Role:
- Development and Implementation of Project using Oracle Pl/SQL Program.
- Allocate jobs and workloads to individual team member based on their ability.
- Executing and Monitoring Jobs. Perform Root cause analysis as per request.
- Create DB objects as per requirement.
- Data Modeling.
- Create python Script for Cron Job Scheduling.
- Scheduling job in ETL using Apache Airflow.
- Technologies: Oracle11g, Python, Unix and Shell Scripting
- Tools: PL SQL Developer, Toad for Oracle, Putty, Apache Airflow, Tableau
- 2) Project Abstract: Is an ERP solution for Coal India Ltd. Coal India is a public sector consisting of seven subsidiaries. It operates 486 collieries, produces and sells over 280 million tons of twenty different grades of coal and consists over half a million employees. This web-based application system integrates the different functional areas of Coal India Ltd and its subsidiaries.
- Module: Material Management System & Equipment Management System
- Role
- Development and Implementation of Project.
- Data Extraction according to the User requirements and preparing reports.
- Executing and Monitoring Jobs. Perform Root cause analysis as per Request.
- Resolving Production Support issues.
- Working in as module lead in Material Management System.
- Technologies: Oracle11g.
- Tools: PL SQL Developer 9.0.1, Toad for Oracle, Report Builder
