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 SQLStrong analytical and data mining skills
Responsibilities :
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 advantageDocumenting 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, ExcelExperience 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 developing best practices, and appropriate patterns to develop required software solutions.
Experience with Dashboards and Run time ReportsGood 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/ processesAdministration of data, process flows and documentation
Timely escalation of pending items and arising issues to the regional team leadsDevelop, implement and maintain an efficient and effective control framework
Skill Set: MS Access, Advanced VBA, Database Design, Advanced Excel, SQL