Microsoft Office Specialist

Description

DESCRIPTION
The Microsoft Office Specialist will assist in the migration from Microsoft Office 2003 applications to Office 2010 as well as support any issues identified during the time of actual deployment from Office 2003 to Office 2010. Report development skills using Oracle and SQL Server 2005.

Responsibilities

• Data manipulation and transformation using MS Office or other tools.
• Collaboration and data integration/sharing with other MS Products such as Excel and SQL Server.
• Access, MS SQL Server 2005 or Oracle Database experience.
• Development experience in Microsoft Visual Studio and.NET framework.
• Development experience of web-based business application involving HTML, JAVA/ASP, etc. programming.

Qualifications

• BA or BS in Computer Science equivalent.
• 5 to 7 years experience in Excel and Access development.
• Microsoft Office Specialist Certification in Microsoft Access/Excel preferred.
• Knowledge of Windows XP/Windows 7 Operation Systems.
• Knowledge of MS Office: .
• Excel skills required.

Excel 2010 including forms, reports, VBA, and macros.

Fully versed with all Excel 2003 and 2010 workbook features and functions including formulas, macros, data filters, pivot tables, linked files, etc.

Ability to write Excel VBA to the Microsoft standards, ie, naming conventions etc.

Strong experience with ODBC, OLE, ADO and DAO connectivity to Access and SQL Server and Oracle.

The ability to create user forms and associated control events.

Able to create User Defined Functions.

• Access skills required

Strong MS-Access skills, including VBA, forms, ODBC and reports.

Microsoft Access Database Design: data model/entity relationship, data type and size, primary key/foreign key, index, unique constraint.

Microsoft Access Development: data accessibility, forms, reports, query design, user interface design, Visual Basic.

Microsoft Access Administration: data import, data export, data/performance analysis, capacity monitoring, installation/configuration of MS Access instance

Structured Query Language (SQL).

• Excellent oral and written communication skills.
• The ability to take direction from project managers and senior developers.
• The ability to complete a task with little or no direction.
• Fast learner with the ability to pick up concepts quickly.
• Ability to communicate technology based solutions to non-technical business users and project managers is very important.

SKILLS
Microsoft Office Specialist Certification in Microsoft Access/Excel preferred

Synectics offers competitive salaries and a full suite of benefits. EOE.