Access VBA Developer Job in Techunity Software Systems India

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