Objective: Seeking an opportunity t apply database expertise, analytical ability, business office experience

Skills Summary 5 reasons t 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 t 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 t 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
• 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 t 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 t 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 t 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 t 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 t other workbooks and t MS Access Databases
• Working with standard formulas and data functions t create analytical charts and reports
• Creating and using PivotCharts, PivotTables
• VBA Coding and using nested IF functions t validate, convert, and analyze text or numeric data
• Using Excel as data source for data migration t other systems i.e. MS Access

Confidential

Confidential

• Wells Farg 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 t 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 t an approved hiring plan t 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 Farg Center, Charlotte NC location and remotely from Roanoke, VA.

Confidential

• 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 t evaluate and redesign an undocumented database cluster used t provide high-level reports t 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 t external source data with links int Hyperion t retrieve comparative figures for Tie Out t production details. Support for worldwide submission of production details, in the form of spreadsheet files, was required t 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.

Confidential

• 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 t 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 t the database t provide functionality per requirements many meetings were attended in person and by teleconference t discuss future needs and t provide feedback t 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 t provide compatibility with version 2010. The database was then provided t the CMRA dept and t the Eclipse Project team for incorporation int Marriott's Eclipse initiative.
• All work was done on site at the 10400 Fernwood Road, Bethesda MD location.

• The Human Resources Office monitors and maintains compliance between State and Local Regulations and Agreements regarding Employee wages and benefits.
• My job there was t create a database solution t replace the large spreadsheet which was being used by an employee that was scheduled t 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 t MS Access database tables
• Converting formulas from Excel spreadsheet t MS Access standards
• Building all Tables, Queries, Forms, Reports, Macros, Modules, and User Security
• Integrating the database solution int 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.

Confidential

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

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

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 t ensure data compatibility between multiple data sources and tracking databases
• Processed requests for IT training courses and contacting vendors t purchase and reserve classroom training, convention participation, and virtual classroom instruction according t the employee's available schedule.
• Updated formulas and functionality in spreadsheets and access databases t ensure accurate tracking and reporting t 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 t determine interest in working for Norfolk Southern's IT Department.