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.