Total Experience- 4-6 years
Role Description:
Technical Skills:
4+ years of hands-on experience with MS Access, including database design, forms, tables, queries, and reports.
Proficient in VBA/VB, with the ability to debug and code complex functions/macros.
Experience with ActiveX controls, COM, SQL procedures, DAO, ADO, and SQL Server databases.
Excel Integration, skilled in creating and managing MS Excel macros and programmatically manipulating worksheet and cell properties using VBA.
System Upgrades, experience with MS Access upgrades and Windows Server configuration.
Domain Knowledge:
Understanding of Securities & Derivatives, P&L settlement, and P&L reporting.
Responsibilities: Gather functional and application data requirements from customers.
Develop and provide data analysis solutions using Microsoft Access.
Support upgrades for MS Office and MS Access.
Communicate effectively with all stakeholders.
Integrate best practices in application development, data visualization, and process flows.
Utilize external databases like SQL to create comprehensive analysis solutions.
Generate various reports as required.
Develop and maintain process documentation.
"