Job Title : Access VBA Developer
Job Description :
Looking for Visual Basic Application developers with more than 2 years of experience and in process automation through Advance Excel, Access, and complex VBA Macros.
Strong MS Access skills with proven expertise of building complex MS Access applications using forms, queries and visual basic code in recent past.
Assist with the development of adho and analyze report results for data integrity and accuracy.
Have to be proficient to create and write queries in MS Access.
Experience using database systems and SQL and write stored procedures in SQL
Strong analytical and data mining skills
Responsibilites :
Experience in building dynamic dashboards and scorecards.
Knowledge on relational database (SQL Server / Oracle) design and build skills would be added advantage.
Knowledge on SSIS packages would be added advantage
Documenting and reporting the results and create process documents on working of tools based on necessity
Responsible for review of the deliverables maintaining/updating trackers (Quality tracker, Project tracker etc.).
Demonstrated ability in working on large scale automation projects within a services organization
Demonstrated technical capability in implementing enterprise automation products and applications such as VBA, SQL, Excel
Experience in Software testing and creating Functional Test Scripts, Testing Strategy Documents, Test Plans and Validation scripts.
Knowledge of insurance domain will be preferable.
Experience in writing stored procedures in SQL and create standardized queries to collect and analyze data from various data sources.
Knowledgable to build VBA prototypes and small scale applications, along with VBA scripts, in a bid to automate Excel spreadsheets.
Experience in develop, enhance, and maintain MS Office applications, and handle both frontend and backend development procedures.
Experience in design, configure, develop, and implement enhancements and production fixes to existing systems.
Experience in development best practices, and appropriate patterns to develop required software solutions.
Experience with Dashboards amd Run time Reports
Good Knowledge of Excel Object Model and Integrating Excel with PowerPoint, Word and other applications
Prepare extensive regulatory MIS reports for various business verticals within markets
Prepare presentation docs for different businesses across regions
Responsible for regulatory exceptions processing
Responsible for enhancing and maintaining the current application/system/ processes
Administration of data, process flows and documentation
Timely escalation of pending items and arising issues to the regional team leads
Develop, implement and maintain an efficient and effective control framework
Skill Set : MS Access, Advanced VBA , Database Design, Advanced Excel, SQL