| 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 6 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
|
| Accent onSkills: 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 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 Pivot Charts
- 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 - 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
Contractor: Confidential The AFLAC contract resulted in 2 Projects Contractor for American Family Life Assurance Company - AFLAC GROUP IT Product Development Strategy Technical Support Analyst Access Ver - I worked in the company's newly acquired AFLAC GROUP Benefits for Corporate Groups
- I took over the project from where a previous consultant left off. My responsibility was t c n vert over 100 databases built in earlier versions of MS Access t version 2010 .accdb databases
- All work was done on site at the 400 Laurel St, Columbia SC location.
Contractor for American Family Life Assurance Company - AFLAC IT Product Development Strategy Technical Support Analyst Access Ver - The objective was t recreate an existing database, converting a VB front end int MS Access 2010. Files that had been derived int their VB source code were provided as text. I translated the code int MS Access database objects, enhanced forms and reports with VBA, converted prior version data tables, forms, and reports int version 2010compatible database objects . I recompiled VBA t execute in the stricter MS Access 2010 environment. successfully.
- All development was done on site at the ITC HQ building 200 location in Columbus GA.
|
Privacy Policy
