Overview

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
Knowledge on SSIS packages
Responsible for review of the deliverables maintaining/updating trackers (Quality tracker, Project tracker etc.).
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 to collect and analyze data from various data sources.
Knowledgable to build VBA prototypes and VBA scripts.
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.
Good Knowledge of Excel Object Model and Integrating Excel with PowerPoint, Word and other applications
Prepare extensive regulatory MIS reports for various business verticals
Prepare presentation docs for different businesses across regions
Responsible for enhancing and maintaining the Administration of data, process flows and documentation

 

Skill Set : MS Access, Advanced VBA , Database Design, Advanced Excel, SQL

Tagged as: advanced excel, advanced vba, database design, ms access

About TechUnity Software Systems

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.