Job Responsibilities:
- Build VB prototypes and small scale applications, along with VBA scripts, in a bid to automate Excel spreadsheets.
- Develop, enhance, and maintain MS Office applications, and handle both frontend and backend development procedures.
- Design, configure, develop, and implement enhancements and production fixes to existing systems.
- Develop and implement new systems, and ensure that their configuration is properly handled.
- Create SQL Server views, stored procedures, and queries, and actively mitigate potential security gaps.
- Create and maintain technical documentation, including user manuals and guides.
- Develop, maintain, and support existing MS Excel VBA applications, and analyze and convert business requirements as needed.
- Perform object-oriented analysis and design, and diligent testing to ensure optimal performance of all assigned systems and system modules.
Job Qualifications:
- Excel VBA programming experience
- Proficiency with Visual Basic for Application (VBA)
- With at least 3 years of experience in MS SQL, MS Access, MS Excel, Visual Basic, and Javascript.
- Comprehensive knowledge of MS Excel application - Pivot Tables, Formulas, Array Formula
- Experience in developing MS Access databases
- Understanding of OOP language
- Keen analytical, logic, and troubleshooting skills
- Experience with data analytics, BI reporting
- Good sense of responsibility and quality communication skills
- Ideally, knowledge in project management, SQL, and interface inheritance
- Preferably can start ASAP and amenable for a night shift schedule.