VIJAY E

To be a part of a professional managed company with a scope of challenging career, opportunity for learning, excellence and continuous improvement. To work and grow in an environment where performance is rewarded with new responsibilities and challenges.

Experienced Software Developer with 3 years of expertise specializing in Web and Mobile Application Development. Skilled in utilizing Oracle SQL, PLSQL, and Oracle Apex for robust web applications, with proficiency ranging from Oracle Apex 5.1 to 22.2. Well-versed in a diverse tech stack including SQL PL/SQL, jQuery, JavaScript, HTML, CSS. Proficient in developing APEX reports, forms, and charts, cards, interactive reports & grid, and classic reports. leveraging the Apex collection concept for optimized performance. Proficient in working with APEX Page & Application level items, Page & application Processing, and Dynamic actions. Strong background in crafting SQL queries, Views, Procedures, Functions, Triggers, Cursors, and Packages, including expertise in Dynamic SQL and Bulk Collect. Creating and managing REST APIs for seamless integration. Experienced in Client-Server application development using Oracle APEX, TOAD, and SQL Developer for efficient backend operations. Proficient in Oracle APEX installation, ORDS setup with Apache Tomcat Server, ensuring smooth application deployment. Possess strong analytical and problem-solving skills, demonstrated through successful project deliveries in Production, HRM, CRM, and Sales domains. Experienced in system analysis, design, development, testing, and maintenance phases of applications. Skilled in client engagement, understanding requirements, and delivering solutions exceeding client expectations. Guided teams in handling projects with precision under tight schedules, ensuring successful development and implementation.

Managing and supporting the 50+ Clients and Delivering web application in APEX Platforms, Dashboards. Creating APEX Application with client requirements or reference to Oracle Forms and Reports. Created Tables, Constraints, Indexes, Triggers, Cursors, Sequences, Stored Procedures, Functions, Packages and API to provide custom functionality as per the client requirements. Create detailed technical documentation that includes system designs, and user manuals and Maintain documentation for codebase, APIs, and integrations. Interact with clients to gather feedback, understand requirements, and provide technical consultation. Mentor junior developers, providing guidance on coding standards, best practices, and professional development. Participate in code refactoring, optimization, and performance tuning initiatives to enhance application efficiency.

• English
• Tamil

Internal Portal, Issue Tracking, ERP Management Portal, Oracle APEX, SQL, PL/SQL, JavaScript, 3, Customer will raise the issue/defect and will track the status of that particular service ticket with time-to-time update. At the time of raising and completion of the ticket, mail will be trigger. Administrator can login and assign the tickets to the concern person., Actively involved in all phases of SLDC (Analysis, Design, Implementation, and Deployment). Involved in creating scheduler mail and HTML mails. Developed Oracle Apex Dashboard and reports as per business requirements. Fetched the data between two portal using REST API. Developed reports for tracking. Involved in maintaining the application. Involved in Team Handling. Bug fixes. Rajratan Thai wire co. Ltd., Production Module, Oracle APEX, SQL, PL/SQL, JavaScript, 3, Managed a client project focusing on developing user-friendly transaction screens for key production stages including Strand Pickling, Pre-Drawing, Patenting, Fine Wire Drawing, Coating and (FG)completion. Implemented QR code processes into the transaction screens, simplifying the input of critical data and ensuring accuracy throughout the manufacturing process. Led the team in creating a seamless interface that allowed operators to easily scan QR codes, providing instant access to input forms for efficient data entry. This project streamlined production operations by providing a digital solution that simplified data input, improved accuracy, and enhanced overall efficiency in the manufacturing process., Actively involved in all phases of SLDC (Analysis, Design, Implementation, and Deployment). Created Oracle Apex Forms and reports as per the client specification and business requirements while ensuring the continuation and enhancement of services. Functionality handled by PLSQL procedure and Packages. Involved in maintaining the application. Involved in Team Handling. Bug fixes. DMW CNC Solution Pvt. Ltd., Production & Plant Maintenance Module, Oracle APEX, SQL, PL/SQL, JavaScript, 3, Managed the creation of important production reports like Production OEE, Monitoring, FG Stock Availability, and BOM-based reports, giving clear insights into how well operations were running. Led the effort to set up and handle critical tasks such as Plant Maintenance Work Orders, Work Request Costs, MTBF, and MTTR, making sure we used our resources wisely and improved how we worked. Worked closely with team members to understand what reports were needed, making sure our system met the client's goals. Made sure our reports were accurate and reliable by using smart ways to check data and handle mistakes. Helped everyone see how the company was doing and make better decisions by giving them clear, on-time information about production and maintenance., Actively involved in all phases of SLDC (Analysis, Design, Implementation, Deployment) for the project. Created Oracle Apex Dashboard and reports as per the client specification and business requirements while ensuring the continuation and enhancement of services. Bug fixes. Alufit International, Project Management, Oracle APEX, SQL, PL/SQL, JavaScript, 5, This project will use the Project Management Module in our ERP system to create and manage project details similar to a work order. Once the project details are entered into the ERP system, Site Material Requests (SMRs) will be generated. These SMRs will include information about the building's floors, blocks, elevations, and production drawings necessary for installing unitized panels. These panels may contain finished or semi-finished items used in manufacturing various goods, typical of other activity classes. The APEX Drawing Module will handle the ERP procedure mentioned above. Following the drawing process, an automated email will be triggered to notify all individuals working on the project., Actively involved in all phases of SLDC (Analysis, Design, Implementation, Deployment) for the project. Created Oracle Apex Forms and reports as per the client specification and business requirements while ensuring the continuation and enhancement of services. Linked the Jasper reports from Oracle Apex. Functionality handled by PLSQL procedure and Packages. Involved in creating scheduler mail. Developed reports for tracking. Customized as per client requirement. Bug fixes. Gourmet Popcornica LLP, Production, Oracle APEX, SQL, PL/SQL, JavaScript, 3, This project helps the Farm Management user to post the Agreement Master to Harvesting Flow entries daily and reports developed to track the Harvesting Details. Used for Agreement, Seed Issue, Seed Return, Pesticide Issue, Pesticide Return, Sowing, Irrigation, PLD, Bag Issue, Bag Return, Material transfer, Dryer Receipt Voucher, Material Receipt Voucher by scanning the QR code the details. Warehouse to Warehouse and Warehouse to Unit Transfer details are shown based on Harvest and Material Issuance details. Related Seed Issue, Sowing, Harvest and Material transfer details reports also developed. Designed and automated the Material transfer Vehicle details process using QR code., Actively involved in all phases of SLDC (Analysis, Design, Implementation, Deployment) for the project. Designed and automated the whole application process using QR code. Functionality handled by PLSQL procedure and Packages. Customized as per client requirement. Bug fixes.

I hereby declare that the above-mentioned particulars are true to the best of my knowledge and belief.