Project Manager Engineer

GEORGE P. BONANO

*** ****** **** ? Walnut Creek, CA 94598 ? 925-***-**** ?

*******@*****.***

PROFESSIONAL PROFILE

Well-rounded, hands-on professional with background in database

development, report writing, mobile solution development, project

management, customer service, and hardware/software support.

TECHNICAL SKILLS

Platforms: MS Windows (various Application Server and Desktop

versions)

Databases: Oracle

Development Tools: Oracle Forms (including WebUtil) and Reports, Crystal

Reports,

MS Visual Studio .NET, MS Office Suite (Access,

Excel, Outlook, Project, Word)

Languages: SQL, PL/SQL, Visual Basic .NET (including Compact

Framework), Visual Basic, Visual Basic for Applications

Miscellaneous: MS Internet Information Services (IIS), MS Web

Services

Some experience: MS SQL Server, HTML, Javascript, XPath, UNIX

PROFESSIONAL EXPERIENCE

Oracle Corp. - Tax & Utilities Global Business Unit, Pleasanton, CA (Dec.

2006 - Mar. 2010)

Senior Applications Engineer. SPL WorldGroup was acquired by Oracle, from

which the Oracle Tax and Utilities Global Business Unit was created. I

held the same responsibilities until May 2008, when there was a re-org in

the business unit.

After re-org, my responsibilities included:

. Building Market Transaction Management product using the Oracle

Utilities Application Framework.

. Migrating the Mobile Workforce Management product to the Oracle

Utilities Application Framework.

SPL WorldGroup, Inc., Walnut Creek, CA (Jan. 2005 - Dec. 2006)

Senior Software Engineer. Synergen was merged together with SPL

WorldGroup.

Held same responsibilities as with Synergen.

Synergen, Inc., Walnut Creek, CA (Oct. 2000 - Jan. 2005)

Senior Software Engineer. Responsibilities included:

. Building and expanding a MS Windows Mobile based asset management

application using Visual Basic .NET Compact Framework and MS Web

Services.

. Oracle Forms and PL/SQL development.

. Creating production reports, and custom reports for customers, using

Oracle Reports and Forms.

. Developing various GIS integrations for our application using ESRI

ArcMap and ArcIMS products.

. Assisting customers with technical support issues.

. Building low-cost OLAP solution using MS Excel and Oracle database

views.

. Building low-cost analytical reports also using MS Excel and Oracle

database views.

. Implementing Oracle's WebUtil product for Oracle Forms when our

application went from a Client/Server application to a Web-only

application.

HealthCentral.com, Emeryville, CA (contracted through Advanced Resources

May 2000 - Oct. 2000)

Report Writer/Data Analyst on an Oracle/UNIX platform. Responsibilities

included:

. Creating various reports in Crystal Reports on Seagate Info 7.

. Creating reports to aid in the reconciliation of EDI data from outside

vendors, which aided the Accounting Dept.

. Creating scripts to validate that data from outside vendors was

getting processed into internal systems properly.

. Creating reports to aid the Merchandising Dept., such as reports that

track the margins of products sold during past day, week, month,

quarter, and year. Also created reports that helped track Sales to

Hits Ratios and Abandoned Shopping Carts.

. Extracting data from the system to aid the Marketing Dept. with

promotional email campaigns.

AirTouch Communications, Walnut Creek, CA (contracted through Q Consulting

Feb. 2000 - May 2000)

Business Systems Analyst for the Database Marketing Group.

Responsibilities included:

. Extracting data from various enterprise and regional databases on an

Oracle/UNIX platform.

. Sending data to Vendors who generate mass mailings for targeted

marketing campaigns.

. Working with Vendors to validate data and to help them define the data

they need for Segmentation analysis studies.

. Writing Oracle SQL*Plus scripts to format data to specifications of

Vendors receiving data.

. Using PostalSoft data integrity software to validate and format

mailing addresses.

. Loading data from Vendors into databases using Oracle SQL Loader.

Pacific Telesis/SBC, Oakland, CA (contracted through Chen-McGinley March

1999 - Feb. 2000)

Report Writer for the Human Resources organization. Responsible for

developing customized, executive quality reports, which supported the

staffing functions across the Pacific Telesis/SBC enterprise. I had to use

various combinations of Transact SQL, Oracle SQL, Visual Basic, Access, and

Excel to produce these reports. I was also involved in developing interim

solutions for reporting data across systems and functions until more

permanent data warehouse solutions are implemented.

Hewlett Packard, Palo Alto, CA (contracted through IMI Systems, Inc. May

1998 - March 1999)

Database Administrator/Manager for the IMT Year 2000 Infrastructure

Program. Primarily responsible for managing the Year 2000 Component

Inventory database and the Year 2000 World Wide Implementation databases.

This included:

. First-line support for trouble calls and modification requests.

. Development of database modification requirements and specifications.

. Working with programmers and internal customers to formulate solutions

to best meet business needs.

. Creating and producing reports using MS Access (with data imported

from Lotus Notes).

. Maintenance of support guides and documentation associated with both

the databases and reports.

. Assist with facilitating Program Team processes.

. Developed End User Support web site using Lotus Notes & the Domino web

server.

Pacific Bell, San Ramon, CA (contracted through SETKA, Inc. January 1996 -

Sept. 1997)

Assistant Project Manager in the Local Competition Group. Assisted with

running 5 core teams which were responsible for the implementation of the

various products for Resale as part of a mandate by the California Public

Utilities Commission and the Federal Telecommunications Act

Primary responsibilities were the following: Assisted with running and

facilitating core team meetings. Produced meeting minutes. Developed and

maintain timelines in MS Project to keep projects on track. Developed and

maintained spreadsheets used to track budgets for each core team. Created

and maintained ongoing issues and action items logs. Organized the

distribution of core team documents electronically. Managed logistics for

core team meetings.

Free-Lance Computer Consulting (June 1995 - Sept. 1995)

Assist various companies with hardware and software support as well as

database development.

Landstar ITCO, Inc., Dublin, CA

Company overview: Provider of transportation services including intermodal

shipping, over-the-road truck brokerage and less-than-truck-load service

with 40 US offices in seven regional centers and overall sales of $80M.

Acquired 1994 by Landstar Group, Shelton CT, third largest US truck load

carrier. Below are the various positions I held with this company:

Carrier Compliance Manager (1992 - June 1995)

Database Development & Administration -- Using Paradox for DOS, designed

and created database used to monitor and approve a motor carrier base of

over 4,000 trucking companies nationwide. Generated monthly list,

containing approval rating of carriers used in the truck brokerage and

intermodal drayage operations. This list was distributed to over 50

offices around the country. Designed a Paradox for DOS database for

Claims Department. This was used to facilitate complex intermodal claims

analysis, resolution and problem prevention by allowing manipulation of

such variables as problem routings and fragile commodities.

Billing Clerk/Claims Processor (1991 - 1992)

Hardware/Software Support -- Reduced field office billing time 50% and

eliminated field office clerks' problem calls after stream-lining forms

and training clerks on improved techniques using AS/400 billing system.

Trained Accounting personnel on usage of Lotus 123 for Windows. Provided

PC hardware and software support for 40 corporate employees.

Sales/Management Trainee (1990 - 1991)

EDUCATION

California State University Hayward: BS in Business Administration with

Real Estate Option

Minor in Economics, 1989

Oracle Education: Introduction to Oracle: SQL and PL/SQL Using

Procedure Builder

Developer/2000 Foundation

Developer/2000 Forms I

Developer/2000 Reports

Advanced SQL and SQL*Plus

Contact this candidate