Software Engineer

• Jan 2022 - Present

 Project name : Enterprise Resource Planning (ERP) Is enterprise resource planning (ERP) refers to a type of software that organizations use to manage day-to-day business activities such as accounting, procurement, project management, risk management and compliance, and supply chain operations. A complete ERP suite also includes enterprise performance management, software that helps plan, budget, predict, and report on an organization’s financial results. Responsibilities: __/ Gathered the requirements from business users and passed on the requirements to the team. __/ Created custom PL/SQL procedures to read data from flat files to dump to oracle database using SQL Loader. __/ Developed PL/SQL procedures and database triggers for the validation of input data and to implement business rules. __/ Created database objects like packages, procedures, and functions according to the client requirement. __/ Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan. __/ Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages. __/ Extracting the data from simple flat text files in the operational database. __/ Ensure the data quality. __/ Creation of test cases and execution of test cases. __/ Execute Alpha & Beta Testing, User Acceptance Testing, Regression Testing. __/ Critical review of documentation and requirements to create test plans. __/ Reporting the bugs, tracking defects, and managing outstanding release issues. __/ Interaction and working with internal team members and external customers. __/ Perform testing, analysis, generating test ideas, create and execute test plans. __/ Review product design documentation to ensure that requirements are correct. __/ Participate in risk management meetings. __/ Find critical bugs/defects quickly, analyzing in details level, bug reporting and follow up the reported bugs. Show less

Junior Software Engineer

• Mar 2020 - Dec 2021

 Project name: Hotel and Tourism management system This projects I worked Manage Building, Manage Room, Manage Bed, Manage Customers, Room Booking, Advance Room Booking, Payment. Responsibilities:- __/ Determined requirements, designed, built, tested, implemented, maintained, and enhanced business systems. __/ Created and documented test documentation. __/ Participated in preparing test plans and test scenarios. __/ Created test data and test cases for module, integration, and system testing. __/ Created PL/SQL stored procedures, database tables, views, synonyms, DDL scripts. __/ Created records, tables, collections for improving performance by reducing context switching. __/ Worked with application development team to develop and refine database architectures, coding standards, and best practices. __/ Led the project of migration of application database from one database environment to the other. Involved in database design, object creation, and sizing. __/ Involved in designing complex SQL queries, subqueries and complex joins based on the transformation rules and the STTM document. __/ Extensively used for all and bulk collect to fetch large volumes of data from the table. __/ Created custom PL/SQL procedures to read data from flat files to dump to oracle database using SQL Loader. __/ Extracting the data from simple flat text files in the operational database. __/ Report design in Oracle Reports. Show less

Customer Service Executive

• May 2017 - Nov 2019

Customer Service Representative

• Feb 2014 - Dec 2016

Overseeing and assessing customer service staff activities and providing them with regular performance-related feedback. Strategizing and monitoring the daily activities of customer service operations. Assisting customer service staff with duties where required. Training staff in areas of customer service and company policies. Overseeing and assessing customer service staff activities and providing them with regular performance-related feedback. Strategizing and monitoring the daily activities of customer service operations. Assisting customer service staff with duties where required. Training staff in areas of customer service and company policies.

Internship

• Jan 2014 - Jun 2014