Objective:

• Seeking an opportunity to apply database expertise, analytical ability, business office experience
• Skills Summary 5 reasons to review this resume :
• Advanced competency in Microsoft Office Professional, Access, Excel, Word, etc.
• Quality Assurance, Access Database Administration and Processing role 8 years
• Integrate new technologies and programming
• Well organized, team player with proven record of quality customer service
• Work well with supervisors, executives, and co-workers at all levels Experienced

KEYPOINT:

• Highly skilled with ALL Microsoft Office Professional products through version 2010, including MS Access Version 2010. Know how to use MS Office Applications effectively in combination with one another to:
• Research, analyze data, develop data management tools, and execute computer aided business procedures
• Customize and communicate business data to support written reports and oral presentations
• Document procedures in a user-friendly way for technical manuals

Accent on Skills:

• Microsoft Access Database Advanced Level Specialist/Developer
• Database Architecture and Development : MS Access Versions 2003, 2007, 2010
• Focus is placed on business needs, user acceptance, scalability, responsiveness, integration, interoperation, and fiscal responsibility
• Full RDBMS lifecycle development, creative/innovative expression through technology
• Creating multiple tables using advance control of indices and field properties
• Establishing complex relationships while maintaining referential integrity
• Customizing ANSI SQL based queries to incorporate complex criteria
• Compiling Switchboard navigation TOC menu
• Designing multi-page forms enhanced with
• Macros
• VBA Event Procedures, Modules, Functions, Error Handling, Debug
• OLE embedded objects
• Active X Controls calendars, display webpage within a form, etc
• Hyperlinks external links
• Multi-level sub-forms related forms within forms
• Data entry, updating, and importing data from multiple sources
• Linking external data resources over LAN/WAN
• Creating automated, multi-stage, data normalization process
• Importing Excel, Word, Access, XML, or text docs
• Data Mining external ODBC databases Read only access
• Analyzing data interactively with PivotTables, PivotCharts
• Customizing comprehensive report data and designing presentation formats
• Exporting Excel, Word, Access, XML, Snapshot, or text docs
• Snapshots sent via e-mail share read-only reports in WYSIWYG
• Employing Data Access Pages to interact w/database via html webpages
• Data entry and retrieval
• PivotTables and PivotCharts
• Replication Design Master and Replicas for distribution
• Access Database Administration Abilities
• Desktop support for any MS Access databases in use
• User-level Database Security
• DBA PASSWORD SECURITY
• Restricts design and control changes, including VBA access
• Establishing workgroup logon to database
• Defining individual user passwords and access levels
• Setting database startup options
• Setting up database-specific, internal security using VBA
• Monitoring user logon with automatic time stamping
• Monitoring current logged on users with external utility

Split Database

• Front End / Back End split for multi-user environment
• Replication of Front End to allow for design updates
• User-friendly updating process, enhanced by VBA, activated at logon
• Optional forced shutdown/reboot process controllable by DBA
• Microsoft Excel Power User since 1993
• Creating Excel workbooks with multiple related/linked worksheets and links to other workbooks and to MS Access Databases
• Working with standard formulas and data functions to create analytical charts and reports
• Creating and using PivotCharts, PivotTables
• VBA Coding and using nested IF functions to validate, convert, and analyze text or numeric data
• Using Excel as data source for data migration to other systems i.e. MS Access

Contractor: confidential Client: confidential Contractor for Wells Fargo Securities LLC IT Dept APPS System Engineer - MS Access Developer Access Ver. 2010

• Wells Fargo Securities brings together the company's market-leading businesses in debt and equity underwriting, mergers and acquisitions, loan syndications, debt and equity sales and trading, tax-exempt products, research and economics, and hedging products relating to equity, commodities and interest rate risks.
• One of the department's Area VPs required an application that tracks Human and Physical Resources, both onshore and offshore, beginning with budget year 2013-2014. The tracker includes pre-existing employee data, budget allocations according to an approved hiring plan to meet business development requirements, provisions for data import, data entry, and a reporting component with complex queries and conditional formatting. Data maintenance is supported with automated processes through customized forms with training and reference documentation. Reports provide verification of assets onboard and projections of assets required for future expansion and business projects. The Database was EXPANDED for all Managers in Tech with automated sts import from PeopleSoft, IQNavigator and Vendor submissions.
• Work is being performed both on site at ONE Wells Fargo Center, Charlotte NC location and remotely from Roanoke, VA.

Contractor: confidential Client: confidential

• Finance Dept MS Access Developer Access Ver. 2003 Minerals Technologies Inc. is a resource- and technology-based company that develops, produces, and markets worldwide a broad range of specialty minerals, mineral-based and synthetic mineral products and related systems and services.
• The Finance department objective was to evaluate and redesign an undocumented database cluster used to provide high-level reports to decision makers, with data based on corporate sales details and sales forecast goals. Documentation of the existing functionality was required, and a user-friendly GUI and connections to external source data with links into Hyperion to retrieve comparative figures for Tie Out to production details. Support for worldwide submission of production details, in the form of spreadsheet files, was required to gather data from Asia, Europe, and the Americas. Additional reports and enhancements were planned.
• All work was done on site at the 35 Highland Ave, Bethlehem PA location.

Contractor: confidential confidential confidential Client: confidential confidential confidential

• Information Resources MS Access Developer Access Ver. 2003 and 2010 Marriott Corporate Headquarters Information Resources Department provides support for corporate business worldwide
• I took over this business analysis, contract management tracking project from where the previous consultant left off. The objective was to repair and enhance the existing database .mdb for use with MS Access 2010. I thoroughly researched the VBA code and SQL statements which were customized and added to the database to provide functionality per requirements many meetings were attended in person and by teleconference to discuss future needs and to provide feedback to the CMRA dept regarding the state of the database development MS Access database objects, including forms, reports, macros, modules, queries stored procedures , and tables were enhanced DLL references were revised and set to provide compatibility with version 2010. The database was then provided to the CMRA dept and to the Eclipse Project team for incorporation into Marriott's Eclipse initiative.
• All work was done on site at the 10400 Fernwood Road, Bethesda MD location.

Client: confidential confidential confidential

• Contractor for Health Department Human Resources Office -MS Access Version 2007
• The Human Resources Office monitors and maintains compliance between State and Local Regulations and Agreements regarding Employee wages and benefits.
• My job there was to create a database solution to replace the large spreadsheet which was being used by an employee that was scheduled to retire.

Duties included:

• Gathering Requirements for the database solution from stakeholders and users
• Creating the Database Architecture for the 'from scratch' database solution
• Reviewing historic processes, State and Local policies, and required calculations
• Converting Excel data to MS Access database tables
• Converting formulas from Excel spreadsheet to MS Access standards
• Building all Tables, Queries, Forms, Reports, Macros, Modules, and User Security
• Integrating the database solution into an established LAN based storage system for simultaneous multiple-user operation
• Solving other unforeseen issues that arise regarding the database solution
• NOTE: Most work was done by TELECOMMUTE with NET meetings held at least once a week.

Contractor: confidential confidential confidential Client: confidential confidential confidential Contractor for Human Resources Department - MS Access Version 2007 Towers Watson is a merger between two international corporations: Towers Perrin and Watson Wyatt. My job there was to facilitate the reconciliation and integration of Human Resources Data between two databases: Oracle and PeopleSoft. Duties included:

• Converting data extracts in Excel format to MS Access database tables
• Normalizing data to ensure compatibility between the two Applications
• Automating related file processing using Queries, Macros, and VBA
• Splitting data by designated requirements to export reports for review
• Reintegrating returned reports to find any changes made from original
• Create batch upload of changed records only

Contractor: confidential confidential confidential Client: confidential confidential confidential

• IT Department / Human Resources Training Coordinator MS Access Version 2007
• Direct recruiting and tracking of candidates and personnel in the IT Department using MS Access and Excel resources
• Worked as IT Department HR Training Coordinator Contractor Duties included:
• Analyzed employee data for accuracy.
• Updated employee records.
• Worked on data normalization projects to ensure data compatibility between multiple data sources and tracking databases
• Processed requests for IT training courses and contacting vendors to purchase and reserve classroom training, convention participation, and virtual classroom instruction according to the employee's available schedule.
• Updated formulas and functionality in spreadsheets and access databases to ensure accurate tracking and reporting to support upper management's employee retention and promotion incentives
• Researched recent college graduate resumes for technology trainee positions
• Contacted grads for preliminary phone interviews and to determine interest in working for Norfolk Southern's IT Department.