Database and Integration resume

Hi, I'm posting my resume here, researching new opportunities.  I can
be contacted through the email listed below.  Thanks!

Brad St. Germaine
me@xxxxxxxxxxxxx
Cave Creek, AZ. 85331

Objective
To work in a dynamic, cutting edge environment, and grow personally
and professionally

Experience

2005 ? Present Prudential Financial
Scottsdale, AZ
Database Specialist - Systems Analysis & Development Specialist

* Joined Prudential as Full-time employee.  Development and design of
a new platform for delivering Relocation Services, the Global Services
Platform (GSP).  Development of web services for GSP in C#.  Moved to
Data Assets team to work on integration of GSP with legacy systems via
BizTalk 2004.  Development in BizTalk utilizing orchestrations,
mapping, functoids, pipelines and scripting.  Managed contractors
assigned to integration.  Continuing to develop system.  New design
and development commencing for Real Estate to come under the GSP
project.  Analysis, design and coding for upgrade to BizTalk 2006 and
SQL Server 2005.

2003 ? 2005 Prudential Financial
Scottsdale, AZ
Contract Development

* Software support and development of relocation software for major
corporation.  Legacy software is three-tier, with ASP as the
front-end, Visual Basic 6 for the middle layer, and SQL 7 for
database.  Support for existing bridge between SQL database and
mainframe.  Also development, testing and research for upgrade of
systems to SQL 2000.  New development for next generation software to
be developed using the .NET platform, against SQL 2000 database, with
eye toward upgrade to SQL 2005.  Programming and testing in C#,
VB.NET.  Development in BizTalk, Commerce Server and MS-CRM.

2003 ? 2003 ISSSP
Scottsdale, AZ
Contract Development

* Develop and maintain software for management training and rating
company.  Network and SQL administration with Server 2000 and SQL
2000.  Setup replication and management routines.  ASP and VB development.

2003 ? 2003 Unity Software
Scottsdale, AZ
Contract Development

* Develop and maintain software for financial institution, dealing
with residential and commercial property loans.  Upgrade dated
components into SQL 2000, VB 6.0 and Access 2002 Crystal Reports. 
Utilized VB 6.0, SQL 2000. Crystal Reports and Access 2000 and 2002.

2002 ? 2002 Matrix Resources
Scottsdale, AZ
Contract Development

* Develop and alter current procedures for end-of-month processing for
financial client business.  Update procedures to pull data from
several MS-SQL servers across domains.  Update procedures to pull data
from Sybase SQL system directly into MS-SQL server for reporting. 
Create DTS transformations and jobs to automate processing.  Utilized
VB 6.0, SQL 2000 and Sybase 11.

1999 ? 2002 McKesson, Inc.
Scottsdale, AZ
Senior Programmer Analyst

* Development of transaction and customer service application for
major dental and pharmaceutical companies.  Mentoring of junior
programmers.  Import of ANSI 834 and 835 EDI files.  This includes the
application adjudication engine, which approves, rejects or pends each
claim, averaging 10 claims per second.  Utilizes VB 6.0, SQL 7.0 and
2000, HTML, DHTML, VBScript, and ASP.  Application is expected to be
the new standard for dental claims processing.  Client-side data entry
checks were coded for the front end.  All main processing was done in
SQL procedures and triggers.  Database numbered over 225 tables, with
over 2200 stored procedures.    Indexes were examined and evaluated
for efficiency and speed, as well as ease of maintenance.  Queries
were traced using SQL 2000 tools, to show where bottlenecks would
occur.  Extensive query optimization was required due to the large
size of the tables, which were to be used in real-time adjudication
procedures.   All processing was to take into account HIPAA regulations.

1997 - 1999 CPG, Inc.
Scottsdale, AZ
Senior Systems Developer

* Complete rate conversion application for international billing
* Web based customer service application used in the US and the UK,
allowing for real-time updates of customer records, check expedites,
and client inquiries
* Scanning application for resubmit processing, saving the company
approximately $100,000 annually
* Custom programming for management applications 
* Utilized FoxPro, Visual FoxPro, SQL 6.5 +7.0, HTML, FoxWeb, Visual Basic

1996-1997 AfterMarket Company
Tempe, AZ
Programmer/Analyst

* Coded "Client Memo" report detailing activities for all AMC clients
* Responsible for setup and custom programs for all new and existing
programs
* Cited for speed and efficiency by Vice President
* Utilized FoxPro 2.X and FoxPro for Windows


1995-1996 New Strategies
Phoenix, AZ
Programmer/Analyst

* Credit card processing 
* Check printing application re-write saved company approximately $30,000
* Custom reports for management
* Utilized FoxPro 2.X, FoxPro for Windows

Education
2000 ? Present University of Phoenix
* Masters Candidate, Computer Information Sciences

2002 Paradise Valley Community College                  Phoenix, AZ
* Java I

1990-1997 Arizona State University - West       Phoenix, AZ
* B.A., Business Management and Computer Science.

1994-1995 Glendale Community College Glendale, AZ
Visual Basic 3.0, 4.0

Skills
C#, VB.NET, ASP.NET, BizTalk 2004 and 2006, Visual FoxPro 5.0, Visual
Basic 4.0, 6.0, HTML 3.2 and 4, DHTML, FoxWeb, SQL 6.5, 7, 2000, and
2005, VBScript, Java, Access, FoxPro 2.X

References furnished upon request


 





==AzTech-Work List======================================================
* $6.95 Domain Name Registrations/Transfers: http://www.domaindo.com
* Deru Internet. When you need more than low price: http://www.deru.com
* The tech resource everyone can help build: http://www.geeksmart.com
* Desert Wolf Tours. 20% AZIPA Discount: http://www.desertwolftours.com
Become a Member and/or Sponsor: http://paypal.azipa.org
AZIPA (Arizona Internet Professionals Association) http://www.azipa.org
=================================================================AZIPA==