SPECIAL QUALIFICATIONS

10 years experience developing normalized multi-user database and spreadsheet solutions and reports using good coding practices. Demonstrated proficiency in the following programming languages and technologies: Business Objects, Microsoft Access and Excel '97, 2003, 2007, 2010, Oracle, PL/SQL, SQL Server 2008 R2, SQL Server Management Studio, Sharepoint, T-SQL, TOAD, Visual Basic 6.0, VBA. Excellent time and project management skills. Able to meet deadlines, work independently and in teams, and communicate well with all levels of management. Able to apply COTS software packages to obtain business solutions.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Analytics Consultant Contractor - Developed and distributed automated daily, weekly, and monthly management charts and reports using Windows Task Scheduler, MS-Access 2010, MS-Excel 2010, , MS-Outlook 2010 and Visual Basic for Applications. Developed and implemented an application to load large data sets into SQL Server 2008 R8 tables using MS-Access 2010/VBA. Used SQL Server Management Studio to create and edit SQL tables, SQL views, T-SQL stored-procedures, and perform daily ad-hoc queries against multiple department SQL tables using inner joins, outer joins, left joins, and right joins. Identified key data issues and recommended solutions. Identified process workflow gaps and recommended areas for improvements. Scheduled and performed automated application back-ups.

Confidential

Application Developer Contractor - Designed and developed a custom Microsoft Office 2010 MS-Access/VBA application which allowed the selection, importing, charting, analysis and exporting of customer raw data to MS Excel reports. The custom application involved the successful creation of MS-Access tables, queries, macros, modules, and functions as well as pre-formatted MS-Excel templates to create standardized MS-Excel charting and reports.

Confidential

Sr. IT Developer Contractor Assisted department with the managing, planning, scheduling, coordinating the conversion and migration of 200 legacy Microsoft Excel and MS-Access macros, workbooks, and applications to a Windows 7 / Office 2010 environment. Gathered end-user requirements, solicited users for issues and feedback, and conducted user acceptance testing. Provide on/off-site users with development, maintenance, and support of MS-Office applications.

Confidential

• Specialist 2, Total Customer Satisfaction Managed, supported, and maintained the QIS/Warranty department's Oracle data mart using TOAD for Oracle and PL/SQL. Managing department data involved creating and modifying PL/SQL stored-procedures, tables, views, indexes, and performing ad-hoc queries against multiple tables/department data mart using TOAD, SQL statements, and MS-Access via an ODBC connection. Designed, developed, implemented, and supported a complex MS-Access application which allowed 300 multiple location users to query department data mart and export results to MS-Excel which reduced man-hour efforts by 50 over previous method. Gathered end-user requirements, solicited users for issues and feedback, and conducted user acceptance testing. Performed complex SQL queries which included the regular use of inner joins, outer joins, left joins, and right joins against disparate data sources DB2, Oracle, SAS, SQL . Used MS-Office tools to analyze, prepare, and present reports to management. Prepared business requirements documentation user documentation, software requirement specifications . Developed and provided in-person and online user training to engineers. Maintained, scheduled, and supported Business Objects automated reporting. Oct 2004 Feb 2012
• Database Analyst Contractor Assisted the Remarketing department in the management and organization of Remarketing business systems development projects including project documentation, presentations, data analysis, information tracking, and department reports. Monitored daily departmental processes. Troubleshoot data inconsistencies. Aug 2001 Oct 2004

Confidential

Software Engineer Designed, coded, tested, and implemented multi-user database applications and reports utilizing Microsoft Access, Visual Basic for Applications, SQL, ADO, and Crystal Reports. Designed, developed, and implemented an Intranet based document retrieval system using Microsoft Access, JavaScript, ASP, HTML, and Adobe Acrobat. Supported and maintained existing Microsoft Access applications.

Confidential

Computer Programmer contractor Used good coding practices to develop distributed Microsoft Access applications and reports that supported the United States Marine Corps GPETE and Naval Sea Systems Command TMDE activities. Projects required development of user interfaces, development of queries and reports, retrieving and manipulating of data using SQL and ADO record sets, packaging and distribution of final applications.

Confidential

Database Developer part-time Developed custom Microsoft Access ERP forms and reports by linking to Oracle databases via ODBC.

Confidential

• Application Developer contractor Designed and developed relational databases, applications, and report for the Regulatory Affairs department using VBA, DAO, and Microsoft Access.
• Technical Support Analyst Supported 300 internal customers with desktop computer systems, network connections, installing and assisting with Microsoft Office products, Lotus Notes, and setting up of client server applications. Evaluated, recommended, and acquired third-party hardware and software products. Assisted with Novell 4.11, AS/400, and Windows NT Server 4.0 administration.
• Clinical Data Analyst Designed and developed DBASE IV forms and tables for the Regulatory Affairs department which allowed user entry, storage, and analysis of clinical trial data across multiple study sites.