VIJAI ANBUVEERAN

• 7+ years of experience with C#.NET, SQL databases 2008 R2 and 2019, ComponentOne Tool, and Crystal Report.

• Administering databases on a SQL server. Establishing and managing databases.

• Providing technical assistance to 40 branches.

• Created SQL queries and stored procedures with SQL server 2008 r2 and SQL database 2019.

• Complex problem deb

• Coordinating with various school principals and arranging meetings for explaining pedagogy activities.

• Conducting training sessions for development of the students.

• Assisting teachers along with daily routine to find best solution for the bright future of the students and to develop education.

• Experience in preparing Test cases.

• Involved in reviewing Test Cases.

• Experience in conducting (Smoke Testing, Functional Testing, and System Testing & Regression Testing).

1. Currency Buy and Sell

2. TT Sell

3. Inward TT

4. Import and Export of Currencies

5. Accounts Transactions (including Financials)

6. Day-end, Month-end, Year-end Programs

7. Uploading Various Remittances to Respective Banks (Online & Offline)

· Developed an exchange management system with the capability of handling: currency buy and sell, TT sell, inward TT, import and export of currencies, accounts transactions including financials, and day-end, month-end and year-end programs, as well as uploading of various remittances to respective banks both online and offline

• Implemented access control system by generating user IDs and passwords for all users and giving users the capability of changing their passwords with special encrypted method

• Developed a tracking system that records the execution of all functions of cashiers, officers, branch heads, managers, accounts and administrators

• Assigned rights for different levels of users according to their access levels

• Applied approval stage for all cashier transactions

• Assigned rate range accordingly to different levels of users

• Developed a secure online system so that all transactions affects the stock and GL heads simultaneously

• Implemented system that does not allow users to open the next day unless all users do their closing procedure on the system first.

• All modules of exchange management such as currency buy and sell, TT sell, inward TT, import and export of currencies, accounts transactions including financials and day-end, month-end and year-end programs, as well as uploading of various remittances to respective banks both online and offline.
• System is secured with user ID and password generated by system administrator which can be changed with a special method.
• Record the execution of all functions executed by all users at any time.
• Categorization of all users to Cashier, Officer, Branch Head, Manager, Accounts and Administrator with user rights.
• Setting rights for different levels of users.
• Cashier transactions require an approval stage.
• Rate range for different levels of users and higher rate requires an approval from upper level user and being logged.
• All transactions are online and stock and GL get updated when transaction gets saved.
• System stock and physical stock are equal at any point of time.

• Design:
• -Design and develop RESTful APIs using WCF, REST API, and visual studio 2015 web frameworks
• Integrate:
• -Integrate APIs with databases such as MS SQL
• Document:
• -Develop and maintain API documentation and specifications
• Test:
• -Develop and maintain unit tests for APIs
• Debug:
• -Troubleshoot and debug API issues
• Optimize:
• -Monitor API performance and optimize as needed
• Secure:
• -Develop and maintain API security measures
• Collaborate:
• -Collaborate with other developers and stakeholders to ensure API quality
• Research:
• -Research and evaluate new technologies to improve API performance
• Version:
• -Create and maintain API versioning
• control

Design and develop RESTful APIs to improve performance and security

Integrate APIs with databases such as MS SQL

Develop and maintain API documentation and specifications

Develop and maintain unit tests for APIs

Troubleshoot and debug API issues

Monitor API performance and optimize as needed

Develop and maintain API security measures

Collaborate with other developers and stakeholders to ensure API quality

Research and evaluate new technologies to improve API performance

• Create and maintain API versioning control
• Design and develop RESTful APIs to improve performance and security
• Integrate APIs with databases such as MS SQL
• Develop and maintain API documentation and specifications
• Develop and maintain unit tests for APIs
• Troubleshoot and debug API issues
• Monitor API performance and optimize as needed
• Develop and maintain API security measures
• Collaborate with other developers and stakeholders to ensure API quality
• Research and evaluate new technologies to improve API performance
• Create and maintain API versioning control

Refine

• Orchestrated seamless integration of TerrayPay,Transfast,Himal Bank, Prabhu Bank, Xpress Money, SBI Bank, Federal Bank, Islami Bank, and Janata Bank APIs using C#.net and SQL SERVER 2008 r2 & SQL Server 2019, SOAP XML, resulting in a 50% reduction in transaction time and a 30% increase in transaction volume.

• Resulted in:

• 50% reduction in transaction time
• 30% increase in transaction volume