MS Office Specialist Resume Herndon, VA - Hire IT People

SUMMARY:

Access/Excel/InfoPath Designer with experience designing and maintaining customized data management solutions. *Collects data via Extract, Transfer & Load; writes SQL queries, form actions, reporting and some database administration. *Provides application/desktop issue support. *Translates requirements into program code; tests, debugs and refines programs to increase efficiency, reduce operating time. *Writes project technical documentation for stakeholders/users. *AGILE experience.

TECHNICAL SKILLS:

Over 15 yrs MS - ACCESS, VBA, SQL; Over 4 yrs INFOPATH, MS-EXCEL; Over 10 years QA and testing

WORK HISTORY:

Confidential, Herndon, VA

MS Office Specialist

Environment: VMWare, Windows 10, MS-Access 2016, MS-Excel 2016.

Responsibilities:

Downloaded reports and/or run ODBC queries (add, insert, delete, update) from external databases and imported these into the internal database using ETL . Used VBA and SQL code for custom back-end/front-end scenarios to achieve more complex solutions.
Designed Excel-based reports using external ODBC data sources. Provided daily Microsoft Access custom development support services. Defined and maintained organized file structures and assigned user access rights.
Tracked and documented all issues along with providing recommendations and resolution methods for USCG review. Created InfoPath forms with connected SharePoint list back-ends for more web-friendly use.
Developed live/production/test database apps and application administration, support for approved databases and applications that were based on the locally installed MS Office Suite. Assisted in the design of BI data cubes, administration of related FORCECOM SharePoint sites, lists, libraries, views and workflows via Sharepoint Designer.

Environment: Windows NT, MS-Access 2007/2013, MS-Excel 2010.

Confidential, Columbia, MD

Access /Excel 2007 DBA/Developer

Responsibilities:

Maintained and modified the HIGLAS Access-Excel database to include tables, forms, queries, macro and module modifications on demand. Performed VBA programming, Access - Excel data transfers, logic fixes, and SQL query re-designs, etc.

Environment: Access 2007, Windows NT, MS-Excel 2007.

Confidential, Washington, DC

Excel 2010 Developer

Responsibilities:

Designed, developed and implemented Management Assessment Operations (MASS) Excel app from user requirements and stakeholder business rules, used for determining Public Housing scores based on sets of calculations performed on data from a data warehouse.
Methodology used included Excel VBA functions and data analysis.

Environment: Windows NT, MS-Access 2010, MS-Excel 2010.

Confidential, Arlington, VA

Access 2007 Developer

Responsibilities:

Created, modified or maintained 10+ Access databases for 30+ divisions by utilizing VBA/VBScript code, SQL queries, SQL-based search forms, reports/macro creations, mail merges, to databases using ADO/DAO, record-set manipulation etc. Applied ad-hoc help-desk fixes to databases.

Confidential, Washington, DC

Access/Excel Developer

Responsibilities:

Managed Excel-Access transfer of data for Financial Agency Agreement tracking of contractors and employees.
Designed, developed and tested SQL queries for data pull-outs from back-end SQL Server database.
Created user interface for easier ad-hoc query-making.
Automated report processes with extended multi-action macros that performed query updates, deletions, make-tables and appends.

Confidential, Washington, DC

Software Systems Engineer

Responsibilities:

Designed, developed, tested, implemented and maintained various database applications from client business requirements using MS-Access and Excel, including:
Built using MS Access 2003 for purposes of tracking Confidential Unmanned Aircraft Systems experiments with entry screen and reporting section using Access/SQL.
Hep desk/Issue support.
FARPART database: Built using MS-Access 2003 and Data Access Pages (DAP) for tracking Confidential document reviews.
ADO connections, VBScript/JavaScript for coding recordset searches, data entry modules, etc

Confidential, Washington, DC

Excel Developer/Software Systems Analyst

Responsibilities:

Implemented Independent Verification & Validation SDLC Estimation and Scope tool using Microsoft Excel.
Designed, tested and debugged an enhanced application “proof of concept” using Excel VBA add-in and template.
Made use of complex VLOOKUP formulas, conditional formatting, VBA functions, classes and cell true/false value logic.

Confidential, Falls Church, VA

SQL Developer/Systems Analyst

Responsibilities:

Implemented modification and maintenance of contracts management database using MS-Access front-end, SQL/Server back-end.
Created Access objects and modules.
Used Visual Source Safe to track versions of database.
Coded VBA functions and procedures for various reports, forms, and modules including use of ADO connections to remote back-end.

We provide IT Staff Augmentation Services!

Ms Office Specialist Resume

Herndon, VA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship