Job Responsibilities:
- Build VB prototypes and small scale applications, along with VBA scripts, in a bid to automate Excel spreadsheets.
- Design and develop VBA/MS Access tools based on the requirements.
- Develop, enhance, and maintain MS Office applications, and handle both frontend and backend development procedures.
- Analyze complex data and/or processes to automate reporting with VBA (Excel/Access).
- Upgrade and support existing tools (Access/Excel).
- Create and maintain UAT test plan, 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.