Develop Microsoft Access Databases, including tables, queries, forms and reports, using standard IT processes, with data normalization and referential integrity
Use Visual Basic in Microsoft Applications, including Excel, Access, Word and PowerPoint
Use Advanced Excel capabilities, including pivot tables, lookups, complex formulas and graphing to streamline business processes
Develop test plans and software documentation to support new releases and code modifications
Confer with internal customers to gain understanding of needs
Roles & Responsibilities:
Develop Macro/VBA based custom solutions within agreed timelines
Write VB scripting while automate 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 other programming language
Lead data handling with a proactive and problem-solving approach with good logical reasoning abilit
Demonstrated technical capability in implementing enterprise automation products and applications such as VBA, SQL, Excel
Write, Modify,Troubleshoot and Maintain VBA Code
Experience in Oracle/or MS SQL server or Similar database
Proficient User of MS office( Word,Excel,Powepoint,Access)
Skills
Microsoft SQL Server, MS Access, Advanced VBA , Database Design, Advanced Excel