Bhiwandi, Maharashtra, India
Worked on the ICICI Bank OFSA Project (Oracle Financial Services Analytical Application). OFSA Application: Provides a common platform for risk, finance, treasury, compliance, and customer applications. It integrates source information, standardizes and reconciles the data, and enables a faster financial close process. Frontend & Backend: The application has two domains. Created users and granted access based on their roles aligned to mapped products (using webforms) with maker-checker functionality. Handled the backend database and wrote query-based procedures in the existing packages based on requirements. Wrote NUnit test cases in .NET for testing specific or entire web page requests in accordance with the project-based functionality, as well as acknowledging those tests through the console. Scanned and debugged major critical vulnerabilities using Checkmarx, resolving them by removing deprecated code with the latest secure code and repeatedly re-testing.
Salesforce CRM Integration: Creation of queryable REST APIs to be consumed by Salesforce to map database objects into objects in the Salesforce Lightning environment. Developed web-based APIs for storing Salesforce requests for case creation in the database and providing acknowledgment for the same through a Callback API. Email Bot: Utility for the categorization of incoming emails based on artificial intelligence and contextual analysis, providing a dashboard for the same based on insights derived from the email bot service results. Responsibilities: Client interaction and requirement gathering. Developed and tested Web APIs using Postman and ASP.NET Core, integrating third-party services with the API. Developed business logic in PL/SQL and tested procedures and functions. Worked on the IRM (Investor Relational Module) using .NET and Oracle procedures
Worked for the principal companies (Bajaj, Birla White, etc.) and their distributors for easy integration and maintenance using Tally. Worked on the development of the front-end as well as the back-end. Front-end developed using TDL (Tally Definition Language) and back-end developed using SQL. Created simple to complex queries on a regular basis for database management in MySQL. Wrote functions in TDL for the front-end process, showcasing skills in designing creative and attractive front-end screens in Tally customization. Worked on integration and data export using XML and JSON in Tally. Created GET and POST APIs for data from the mobile app to Tally and vice versa. Hands-on experience in building Web APIs using the .NET Framework in C# for add-ons integration and data retrieval using XML and JSON.