Access VBA Developer
Experience: 3-5 Years
CTC: 3-5 LPA
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 the 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.
Experience using database systems and SQL and write stored procedures in SQL.
Strong analytical and data mining skills.
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.).
Prepare extensive regulatory MIS reports for various business verticals within markets.
Prepare presentation docs for different businesses across regions.
Responsible for regulatory exceptions processing, 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.
Experience in building dynamic dashboards and scorecards.
Knowledge on relational database (SQL Server / Oracle) design and build skills would be added advantage.
Knowledge of SSIS packages would be added advantage.
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 developing best practices, and appropriate patterns to develop required software solutions.
Good Knowledge of Excel Object Model and Integrating Excel with PowerPoint, Word and other applications.
TechUnity, Inc. is a Business Consultancy and Product Developer headquartered in Washington, DC. TechUnity implements high growth strategies and develops next-generation products for businesses across the United States, Canada, and the UK. Business Consulting and Product Development are performed by experts in business and technology and are delivered through robust practices in assessment, planning, engineering and maintenance.