We provide IT Staff Augmentation Services!

Databasse Administrater Resume

PROFESSIONAL SUMMARY:

  • Confidential TEMPhas more than 10 years’ experience as a MS Access Developer and MS Access Administrator.
  • Confidential can work independently or in a team environment and Confidential has excellent verbal and written communication skills.

TECHNICAL SKILLS:

Databases: Oracle 11g, MS Access 2.0/4.0/6.0

Languages: SQL, PL/SQL, T - SQL, Visual Basic, VBA, Cobol, JCL, Fortran, CL

Software: MS Office Suite (Word, Excel, PowerPoint), Outlook 98/2000, SQL*Developer, SQL*Plus, TOAD, Pick Ticket Management System, Lotus 123, Internet Explorer, PC Anywhere

OS: Windows 95/98/2000/NT/XP/Vista/7, Windows Server, MVS, UNIX, VMWare, DOS

Methods: Software Development Life Cycle (SDLC), Agile

PROFESSIONAL EXPERIENCE:

Confidential

Databasse Administrater

Responsibilities:

  • Implements and maintains smooth operation and physical design of databases.
  • Conducts performance tuning of indexes and databases in general. Reviews database design and integration of systems provides backup recovery and makes recommendations regarding enhancements and/or improvements. Maintains security and integrity controls. Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization. May develop stored procedures and/or triggers.

Confidential

MS Access Programmer

Responsibilities:

  • Learn and maintain existing company systems.
  • Using MS Access visual basic to automatic outlook to send emails.
  • Create, modify and design additional reports as requested by management. Using visual basic to automatic Excel and printout spreadsheets.
  • Migrate current MS Access based databases to SQL and integrate wif current front-end interfaces.
  • Migrate current MS Access based databases to SharePoint and integrate wif current front-end interfaces.
  • Troubleshoot and correct any Database server issues.
  • Analyze, audit, modify, and amend data in systems as required by other team members.
  • Assist wif efforts and development to define and automate data gathering, analysis and reporting processes.
  • Assist wif efforts and development to define and automate data gathering, analysis and reporting processes.
  • Creating new visual basic code for new functions and procedures.
  • Create technical document of existing company Microsoft Access databases.

Confidential

MS Access Programmer

Responsibilities:

  • Designed, modified, enhanced, implemented and maintained logical and physical databases
  • Performed maintenance, fixes and data cleanup on over 40 MS Access databases
  • Learned and translated the business objectives into deliverables
  • Modified and maintained HP Service Manager Job Scheduler
  • Performed MS Access and SQL Server database programming
  • Monitored MS Access databases seven days a week
  • Built and ran queries in SQL and MS Access databases
  • Extracted large datasets through programs and process queries
  • Environment - MS Access, SQL, SQL Server, HP Service Manager Job Scheduler.
  • Provided technical support
  • Ordered parts for IH technicians via the telephone
  • Communicated wif clients for end-to-end repair set-up
  • Provided over the phone diagnostics for clients
  • Captured product, client, and entitlement data to populate the work orders
  • Researched parts to perform repairs
  • Provided accurate estimates to the client for repairs
  • Interacted wif client to explain repair procedures
  • Scheduled repairs

Confidential

MS Access Database Administrator

Responsibilities:

  • Created and maintained an in-house developed CRM system, that uses a MS Access front-end wif extensive VBA code and links to data in a SQL back-end
  • Generated all report outputs to Excel spreadsheets
  • Created and maintained in-house developed automated data handling process using T-SQL, MS Access, and Visual Basic
  • Worked wif users to define, plan, coordinate, and implement new systems to meet the needs of the company and users
  • Performed ongoing maintenance on the SQL back-end using T-SQL, ensuring data integrity
  • Assisted upper management in decision making by providing data for analysis
  • Assisted in the ongoing maintenance of the network stability/security, including servers
  • Provided user support for both hardware and software
  • Environment - MS Access, VBA, Excel, SQL, T-SQL, SQL Server, Visual Basic.
  • Supported the BOM/Parts creation process by ordering parts from the Oracle SSP5 system
  • Located reusable parts in the ATO yard by matching the dimensions against the E-pims drawings
  • Assisted the Project Coordinators in tracking test parts delivery to NHR Receiving and to the Engineering Lab
  • Completed test request workflows
  • Helped gather parts for ATO lab tests
  • Wrote a MS Access Cost Estimate Database on SharePoint
  • Created Excel spreadsheets
  • Environment - MS Access, Excel, SharePoint,

Confidential

MS Access Programmer

Responsibilities:

  • Created complex MS Access programs using Visual Basic, SQL and T-SQL
  • Coordinated all aspects of shipping for over 25 million dollars a year of equipment
  • Created a shipping database that import salesman documents and product pull lists
  • Maintained custom information and backorder items
  • Created daily shipping lists, checking for duplicate shipments
  • Queried database for all items shipped, items shipped on any day or group of days, items shipped by customer, or items on backorder
  • Created an Inventory Control Database that subtracts parts for inventory when Mobile Lifting Systems are shipped
  • Maintained all parts received
  • Produced reorder reports, daily transaction reports, and items on backorder reports
  • Created a production database that let the Production Engineer create his own sub-component of a finished good and assign parts from inventory, so that Confidential can calculate future parts that Confidential need to order or has made
  • Created a task database that kept track of the time needed by each department, including welding, painting, sawing and assembly to product equipment
  • Created a pull list created from the MS Access database
  • Assigned a broker for overseas shipments
  • Determined the shipping payment, best method of shipment, and the carrier
  • Determined the correct documents and materials for overseas shipments
  • Environment - MS Access, Visual Basic, SQL, T-SQL.

Hire Now