Project: Integrated Establishment System.Integrated Establishment System (IES) is an automated and integrated package which is designed for HR management and Salary drawing system for rbi. It consists of 13 modules like Admin, Salary, Hosing Loan, Loan Advances, Bills, Leave, Budget, Employee Information System, Fund, Expenditure, Settlement, and Pension Processing.Role: Oracle PLSQL programmer, Handling Admin, Salary, Employee Information System… Show more Project: Integrated Establishment System.Integrated Establishment System (IES) is an automated and integrated package which is designed for HR management and Salary drawing system for rbi. It consists of 13 modules like Admin, Salary, Hosing Loan, Loan Advances, Bills, Leave, Budget, Employee Information System, Fund, Expenditure, Settlement, and Pension Processing.Role: Oracle PLSQL programmer, Handling Admin, Salary, Employee Information System Module.Responsibilities: Responsible for analyzing business functionality for the back end processes.To do New Changes or modification as per request in transactions related to Employee Information System, Payment/Recovery, Income Tax Transaction, Salary Processing, Housing Loan, Fund, Loans and Advances modules.In Fund and Loans module calculation of Interest, accounting and maintaining balance of all employees of RBI.Analyzed and designed tables based on small and large database transactions like Salary processing.Developed several business rules and translated it into procedures, functions, triggers for calculating HRA, HRR, various Loan recovery and generating various files like PF Schedule, ECS file etc.Responsible for performing code reviews.Design and create new customized reports and Reviewed and modified existing customized reports like form 12, form16, form24 and schedules using Oracle Reports Developer 9i.Developed user documentation for Admin, Salary, Housing Loan, Loans and Advances, Employee Information System modules, also responsible for writing test plan documents for the application modules.Lead the upgrade process of Oracle Database 9i to 10g including the setup of the 10g Oracle Development environment.Oracle Reports were deployed in RDF format over production server to enable generation of report in PDF format for direct access by RBI user throughout India. Show less

, Ahmedabad.Project: Business Application System.Business Application System is a Software created for Inventory Management, Sales, Invoice,Employee Payroll.; Responsible for analyzing business functionality for the back end processes.Used Microsoft Visual Basic 6.0 as Front-End and Microsoft Access 2000 as Back-End.Software also keeps track of Inventory. For example, If the Quantity of a particular item is lower in stock than what is required so it will inform the user… Show more , Ahmedabad.Project: Business Application System.Business Application System is a Software created for Inventory Management, Sales, Invoice,Employee Payroll.; Responsible for analyzing business functionality for the back end processes.Used Microsoft Visual Basic 6.0 as Front-End and Microsoft Access 2000 as Back-End.Software also keeps track of Inventory. For example, If the Quantity of a particular item is lower in stock than what is required so it will inform the user that the quantity of this particular item is low in stock so user can arrange for that.User has also given the Facility to take the Print-out of The Invoice. Show less