Alexander (Pete) Bardea
1513 Terry Lynn Lane
Concord, Ca.  94521
925 689-5376 Home    925 586-6056 Cell
apbard@aol.com

Profile
Results oriented IT professional with a solid background of designing and implementing solutions using MS Access, 
VBA, Excel, SQL Server, Oracle and an Intranet.  
Strong business analysis and technical writing skills.  
Works independently or as part of a team.  
Adept at working with users to determine requirements and turning them into easy to use solutions. 
Proven mentor and coach to fellow programmers.

Proficient using the following tools:
Microsoft: Access, Access VBA, Excel VBA, SQL Server, Front Page, ASP, IIS
Other:  HTML, SQL, TOAD, Oracle Discoverer

Professional Experience

April 2005 – November 2008
MS Access Specialist, Business Programmer Analyst	 		
Toshiba America Business Solutions,  Irvine Ca.

Toshiba America Business Solutions is the copier division of Toshiba 
Corporation. 	
    Primary focus was working remotely with the Oracle Implementation 
    Team to extract data from U.S. based copier dealers’ legacy systems, 
    work with end users on data cleansing and prepare the 
    data for importing into Toshiba’s main Oracle system.

Major Accomplishments:
o  Reverse translated MS Access 97 database used for prior conversions, 
   converted it to Access 2003 and modified the objects and VBA code so 
   it would accommodate multiple dealer conversions.
o  Using MS Access, VBA, SQL Server and Oracle, extract data and prepare 
   files for Supply Chain conversion consisting of Item Master, Product 
   Categories, Price List, Approved Supplier List, Sourcing Rules, On Hand 
   Inventory, Default Receiving Locations, Default Warehouse Bin Locations, 
   Vendor Names, Vendor Sites and Vendor Contacts.
o  Design, write program specifications, test and run Oracle application to 
   generate Excel spreadsheets for user cleanup and prepare 
   final files for importing into Oracle production environment.
o  Develop Access database to reconcile On Hand data extracts with legacy 
   system Inventory Valuation Reports both before and after conversion.
o  Work with copier dealer IT Department to extract legacy system data 
   (OMD and LaCrosse systems) and map to Oracle tables.
o  Perform extensive analysis on user data and notify users of changes 
   required to their legacy system data and/or configure Oracle override 
   tables to handle the exceptions. 
o  Using MS Access, develop a data dictionary of all tables used in the 
   conversion application and write VBA code to generate 
   Oracle CREATE TABLE scripts for all tables. 
o  Develop an intranet web site for the project to provide users with 
   project information and links to applications, training documents, 
   calendars and issues using IIS virtual folders to link to a server 
   where the documents were stored by the implementation team.

Typical conversions spanned 4-5 months and dealt with 3 copier dealers at 
a time.  Converted over 21 dealers during my tenure.  

 
July 2004 - March 2005
Consultant, MS Access Specialist	Info Crossings   Brea Ca.

Hired to join the Toshiba Oracle Implementation Team to assist in converting 
copier dealers from in house legacy systems to Toshiba’s Oracle platform.  
Later hired by Toshiba to join their team as an employee.

August 1992 - March 2004	IKON Office Solutions,  Walnut Creek Ca
Western Region Intranet Web Master (1999 -  2004)			   
o  Designed and implemented the Western Region Intranet to serve 13 Western 
   States.  Site logged over 950,000 hits per month.
o  Much of the web content was extracted from the legacy system (OMD) and 
   processed using MS Access 97 VBA modules and later converted to MS Access 2003 
   and later migrated to SQL Server.
o  Intranet reporting was developed using Microsoft ASP language and 
   interfaced with MS Access, SQL Server and Oracle.
o  Awarded Northwest District 2001 Administrative Employee of the Year for 
   the contribution the Intranet made in the district being awarded 2001 
   District of the Year.

Data Warehouse Development Team (1997 - 1999)
o  SAP implementation cancelled.
o  Worked on conversion team to convert non SAP applications to OMD.
o  Built Oracle Data Warehouse and fed data from OMD system using SQL Loader

SAP Materials Management Configuration Team (1995 - 1997)
o  Designed and wrote legacy system programs to extract data for SAP 
   Materials Management module and configured various Materials Management features.
o  Trained users on overall use of the SAP Application.

Senior Programmer (1993 - 1995)
o  Senior Programmer on VAX machines supporting in-house developed 
   applications.

Business Analyst / Project Manager (1992 - 1993)
o  Hired to design and manage software enhancements to support moving local 
   warehouse from Concord Ca. to Livermore Ca.
o  Wrote detailed specifications for contract programmer and tested results.


January 1980 -  September 1991
Director of MIS							Dakin Inc.  Brisbane Ca.

Managed the IT department of 44 persons consisting of managers, programmers, 
computer operators, data entry clerks and sales order processing. personnel.

Managed department of 44 persons and an IT budget of over 3 million dollars.


Education Over 3 ˝ years of credits in Business and Information Processing 
at the following colleges:
College of Marin, Thomas More College, San Mateo College, Diablo Valley
College, Dominican College

References available upon request.