Develop Microsoft Access Databases, including tables, queries, forms and reports, using standard IT processes, with data normalization and referential integrityUse Visual Basic in Microsoft Applications, including Excel, Access, Word and PowerPointUse Advanced Excel capabilities, including pivot tables, lookups, complex formulas and graphing to streamline business processesDevelop test plans and software documentation to support new releases and code modifications
Confer with internal customers to gain an understanding of needs
Roles and Responsibilities:
Develop Macro/VBA based custom solutions within agreed timelines
Write VB scripting while automating web pages and ERP application Working on dashboard development using BI tools
Work with Microsoft Office programs
Lead projects around solution delivery based on VBA coding, SQL and another programming language
Lead data handling with a proactive and problem-solving approach with good logical reasoning ability
Demonstrated technical capability in implementing enterprise automation products and applications such as VBA, SQL, ExcelWrite, Modify, Troubleshoot and Maintain VBA CodeExperience in Oracle/or MS SQL server or Similar databaseProficient User of MS Office( Word, Excel, Powerpoint, Access)