ROBERTO GIANNICOLA
2520 San Miguel Drive
Walnut Creek, CA 94596
  [Send email to request phone number] 86-6958
[Send email using form at bottom]

ACCOMPLISHMENTS

* Twelve years experience developing MS Access applications from Access 2 to
current version
* Six years developing Crystal Reports with SQL Server or Oracle backend
* Analyzed and documented old database Planned transition to new application
Migrated MS Access Databases to SQL server 2000 in client/server environment
* Developed multi-user MS Access financial applications in network environments
utilizing VB, SQL Server, Oracle and MS Office applications back-ends
* Lead development of applications throughout the entire project lifecycle:
Analysis of current work, Designing, Prototyping, Development, Testing and QA,
Presentations to various departments, 

Training and Documentation for users, as well as on-going support
* Collected and analyzed financial data Wrote and created surveys, statistical
reports, analysis and various charts using Access, Excel/VBA and PowerPoint for
marketing departments


COMPUTER SKILLS

Development:
MS Access XP/2003, SQL Server 2000, Crystal Reports 9, 11 Business Objects,
Oracle SQL,  MS Access VBA, Visual Basic for Applications, VB 60, Crystal Reports
85, Active X, 
T-SQL, Stored Procedures, DTS packages, RDBMS, Dreamweaver, Flash, Front Page
98/2000, Fireworks 4, Adobe Photoshop, Structured Query language – SQL, VBScript,
Brio

Office: MS Word 2003/XP, MS Excel 2003/XP, Outlook, Internet, HTML, Telnet, FTP,
MS-DOS, MS PowerPoint 2003/XP, MS Winproj, Visio, Meeting Maker, Internet
Browsers, Mail Systems, 

Windows 2003/XP



WORK HISTORY

Federal Home Loan Bank
San Francisco
Database Developer
February 2005 – January 2008

* Developed customized MS Access support accountability application for IS
department with MS Access and SQL server data Wrote technical documentation for
ongoing maintenance
* Developed numerous Crystal Reports 11 in Business Objects with Oracle backend,
using SQL command lines, including graphs and sub reports
* Acted as support for conversion of MS Excel and MS Access applications from 97
version to XP 2003 for various departments in the bank
* Followed up with all departments to ensure that conversion was applied by due
date


Marsh & McLennan
San Francisco
Database Developer
September 2004 – Jan 2005

* Provided enhancements to MS Access 2000 Database
* Build new Documentation MS Access database and implemented in current
application to build customized help information
* QAed current application, improved esthetics and brought new ideas for  new
interfaces and functionalities
* Worked through various bug and issues that needed to be resolved

The Gap
IT Business Solutions
San Francisco
Database Developer
May 2004  –  September 2004

* Developed MS Access 2000 database to import data from a central financial
database Attachmate Extra, using a screen scraping method
* Created procedure and interfaces to import data from various excel
spreadsheets
* Developed interfaces to run financial reports by pulling data from numerous
tables in various formats
* Created complex reports display retail data for various stores, countries and
several currencies 


Chiron Corporation
Shipping and Processing
Emeryville
Database Developer
April 2004  –  May 2004

* Developed MS Access 2002 Lot Tracking database to record packaging, processing
and shipping of various products
* Used detailed business requirements and intricate workflow diagram to build
the various tables, interfaces and ad-hoc reports

Wells Fargo Bank
Online Customer Services
Concord – San Francisco
Database Developer
Feb  –  April 2004

* Developed MS Access 2000 database to manipulate data for the conversion of
online bill pay customers from PNW bank
* Build a series of queries and programs to clean and analyze the data
* Created various reports in Access and Excel for data verification and final
bill pay registration


Wells Fargo Bank
Online Customer Services
Concord
Database Developer
Nov 2003  –  Dec 2003

* Developed MS Access 2000 Employee Performance database for the monitoring and
reporting of all customer support employees
* Followed written specification and old version of database to rebuild new
application
* Created ad-hoc reporting and the ability for all departments to customize the
database for their specific needs without the need to change the program, queries
or reports
* Development included users’ interviews, analysis, design and implementation,
QA & testing, and user training


Epocrates
San Mateo
Database Developer
September 2003  –  Oct 2003

* Worked with user for the analysis and requirements documentation 
* Developed MS Access 2000 quote log database in multi user environment
* Followed intricate business rules from Excel spreadsheet and converted it to
VBA programming
* Build various interfaces and reports reflecting the same documents used in
prior environment
* Offered continuous support and maintenance for application


Wells Fargo Bank
Internet Service Group -BillPay
San Francisco
Database Developer
Feb 2003  –  July 2003

* Developed MS Access 2000 database to map old vendors to new list of merchants,
using text string matching programs to match names and addresses from several
tables and lists on partial or 

entire fields
* Created user interface to view all mapping results with different matching
levels, as well as drag and drop capabilities to undo or edit matched data for
all categories
* Developed application for surveys, including compiled data and reporting
charts, with criteria input selection
* Developed additional applications for data and payees management with several
imbedded formulas to facilitate workload forecasting and budgeting
 
Wells Fargo Bank
Online Customer Service
Concord
Database Developer
Dec 2002– Jan 2003
* Developed MS Access 2000 database for Online Enrollment Error Tracking in
multi-user environment 
* Database includes features like input forms, elaborate interfaces for ad hoc
queries; mass report e-mailing and e-mail logs, statistical and productivity
reports for all users
* Developed additional Access 2000 database for Online Frauds tracking in multi
user environment with ad hoc reporting and querying
* Development included users interviews, analysis, design and implementation, QA
& testing, and user training

Wells Fargo Bank
Event Services
San Francisco
Database Developer
Oct 2002 – Nov 2002
* Developed MS Access XP database for Event management and invoicing with
schedulers, calendars, and ad hoc reporting tools
* Migrated old 4D database to Windows 2000 environment
* Trained users and provided various database documentation

Wells Fargo Bank
Supplier Diversity Program
San Francisco
Database – Web Developer
January 2001 – May 2002

* Migrated MS Access 97 database to SQL Server 2000 using MS Access 2000 Project
front-end
* Developed ASP Web application for company-wide accounts payable data reporting
using dynamic Crystal Reports
* Developed Access/VB interface to administer SQL server database, including
backup and restore, SAS data import/export, reporting and data manipulation
* Designed numerous Crystal Reports using stored procedures with parameters to
query several million records 
* Wrote DTS packages and stored procedures to import large datasets into SQL
Server 2000 and rendered the data available for reporting 
* Designed MWDBE Web site with Dreamweaver and Flash components
* Wrote Database documentation for support personnel and provided training to
database administrator and users

Berkeley HeartLab, Inc
Alameda
Database Developer
November 2000 – January 2001

* Worked with team to enhance current Access 97/VB  Client/Server application
with new reporting capabilities and user windows for data input onto SQL server
database
* Enhanced features on SQL server 70 for better performance
Seneca Capital Mgmt


San Francisco
Database Developer
September – November 2000

* Developed Accounting System with Access 97/VBA for the management of
securities and funds, with direct links to ILX and Bridge live brokerage data 
* Created a solution for import and export of files for end of day gain/loss
results


Wells Fargo Bank
Brokerage Quality Control –
San Francisco
Database Developer
July 1999 – September 2000

* Developed Brokerage Quality Control master database with MS Access 97 feeding
from SQL server, Oracle, and various Access back-ends on Windows NT environment
* On second phase, designed and developed eight custom databases in Access 97
and 2000 to provide coherent timely data for master BQC database
* Set elaborate security system for a multi-user environment with customized
windows for ease of maintenance
* Provided instruction manuals, training and support for users and database
administrator
* Participated in persuasive presentations to departments
* Set up secure distribution package on compact disks for deployment to
non-networked users


Cisco Systems Inc
Translation/Localization – Santa Clara
Database Developer
Project Manager
March 1997 – 
April 1999

* Developed MS Access Database to track translation terminology and phraseology
categorized in semantic and grammatical rules, including word type, parts of
speech, and genders agreement
* Developed MS Access Database to track the workflow status of documents from
translations to publication on network environment
* Developed MS Access Vendor database for translation services 
* Collected and analyzed data from numerous sources; delivered complete
statistical reports using MS Access and Excel
* Wrote surveys, reports and statistical analysis for translation services
department
* Wrote business requirements for Translation Management System
* Translated and managed content published on the Italian Web site


Pacific Gas and Electric
Research – San Francisco
Database Developer/Analyst 
March 1995 – March 1997


* Developed MS Access Database connected to a network environment to track and
report daily information between departments Wrote procedure manuals and trained
staff
* Implemented MS Access with MV90 Data retrieval system, using b-Trieve Planned
and created databases, queries, and spreadsheets for statistics and analysis
Developed procedures and 

provided support on existing applications
* Collected, processed and analyzed data from large industrial and commercial
customers utilizing SAS data and large databases in network environments

GTE Sylvania 
Bufiva SA
Andre Zufferey 
Switzerland 

Accountant 
1987 – 1991

* Managed control of monthly financial reports, consolidation and reporting
processes
* Prepared financial analyses for 12 European countries, delivered statistical
reports to GTE US headquarters monthly
* Consulted companies such as hotels, international firms, travel agencies and
import/export offices with accounting procedures and PC operations 
* Responsible for accounting system, established official reports, prepared
variances and other financial analysis


LANGUAGES

Italian		Native Language 
French		Native Language 
English		Fluent: spoken, written (14 years in US)

EDUCATION

* Systems Analysis and Local Area Network Classes, City College, San Francisco
* Various Computer courses and self taught software applications during the last
eight years
* Four years Business Administration and Accounting degree from Professional
Vocational School, Switzerland 1987  (Equivalent to US BA degree)