EXPERIENCE

Confidential

GIS Software Engineer/Team Lead

• Solano County GIS team lead responsible for application architecture, development, web design, resource management and production support. Technical SME for the Solano County Regional GIS Technology Steering Committee. Additional duties include website/Sharepoint/Database design/administration as well as content management of Solano County Health and Social Services for data warehouse integration. Primary duties involve planning and development of custom B2C and GIS Geographic Information System mashups for desktop, mobile, web and Sharepoint. Interface with customers to drive IT efforts and mitigate business processes. Top advisor for technical issues/requests among multiple agencies within the county along withaligning objectives and requirements with third party vendors and resources.

Environment: ArcCatalog, ArcGlobe, ArcMap, ArcGIS Desktop, ArcGIS Server, ArcIMS, ArcSDE, Image Server, GeoCortex Essentials, Oracle 11g, MySQL, SQL Server 2005/2008, .Net, C , TOAD, SSIS, Visual Studio, SharePoint 2007/2010

Confidential

Systems Analyst

• Lead developer/analyst for Solano County's web development team responsible for architecture, design, and database administration of new intranet sites as well as converting/migrating legacy applications. The team-based environment allowed me to work cohesively with analysts, managers, administrative personnel, executive staff and developers from other county entities. Presentations, meeting facilitation, design reviews and production support were necessities in my daily tasks.

Environment: ArcCatalog, ArcGlobe, ArcMap, ArcGIS Desktop, ArcGIS Server, ArcIMS, ArcSDE, Image Server, GeoCortex Essentials, Oracle 11g, MySQL, SQL Server 2005/2008, .Net, C , TOAD, SSIS, Visual Studio, SharePoint 2007/2010

Confidential

Consulting Software Developer

• Developer/Analyst and Systems Architect involved solely responsible for re-designing the corporate Manufacturing Management Information System AIMS . This legacy, custom built, one-of-a-kind application is being re-architected from MS Access to .NET 2008, using ASP.NET, C and MS SQL Server. New features incorporate migration of financial data from SQL Server to Quickbooks. Team collaboration involves meeting with the company sales department, IT department and executives to gather requirements, map data, re-design the schema and approve documentation.

Environment:.Net, C , Sharepoint, SQL Server, MS Access, Excel, Visual Studio 2005, Microsoft Office Sharepoint Designer, Visio, All Fusion Erwin Data Modeler, TOAD, SSIS aka DTS , MS SQL Server Management Studio, Data Warehouse

Confidential

Consulting Software Developer/Analyst

• Technical lead responsible for analysis, design, installation, deployment and support of multiple applications. This includedupdating the legacy as well a migrating data from SQL Server to Oracle and building interfaces with internal systems, including MyCalPERS.com. Essential tasks involved collaborating with users, analysts and cross-functional teams to ensure success. Requirements gathering, mapping data, validating data and documentation were additional responsibilities.

Environment: Oracle 10g, PL/SQL, Sybase SQL Server, PowerBuilder, PFC, TOAD, Visio, MS Project

Confidential

• Accountable for Condocert's B2B ecommerce architecture, infrastructure design, software development and support. Inclusive duties were budgeting, resource management, project management, fiscal sanity, mitigation, gaining consensus to maintain participation between disparate groups,define and implement technology solutions according to business strategies and goals plan, organize, control and supervise subordinates establish and communicate clear expectations regarding work performance for both the individual and team create an environment for improving customer satisfaction which involved working with the business community to continue to drive technology forward as well as acting as the liaison between Condocerts, its trading partners and third-party vendors. My participation aided in Condocert's maturation from start-up to a multi-million dollar entity. Initial years were operated under extreme budget constraints thus requiring innovation through creative financial negotiations and determined perseverance.

Environment: Oracle 10g, PL/SQL, Oracle App Server, Oracle Portal, MS SQL Server 2005, Oracle Discoverer, MySQL, C , ASP.Net, MS Visual Studio 2008, Unix, RH Linux, J2EE, JavaScript, Apache, Perl, Shell Scripts, ACH, HTML, XML, SharePoint, SSIS, MS Project, Firewalls, TCP/IP, IPSec, sFTP, Https, VPN, TriCipher, Putty, TOAD, VNC, JDeveloper, XMLSpy, Visio, MS Project, Erwin, requirements gathering, resource planning, risk mitigation, cost/benefit analysis,use cases, GAP analysis, RFP

Confidential

• Member of a consulting team responsible for architecture and full SDLC of The World Sports Exchange's online products. Informix,. Java, 4GL SQL , HTML, XML and UNIX shell scripts were utilized in the development. The company expanded to Europe, which required my involvement in the design and development of a secure payment processing gateway. The resulting efforts had dramatically increased the company's revenue, at the time.

Environment: Offshore development, Informix, SQL, 4GL, Solaris, SCO Unix, VPN, Firewall IP Filtering, DMZ , Java, JSP, XML, JHTML, SAINT, Apache, LDAP, Apache, Tomcat, Java Webserver, Shell Scripts, Macromedia Flash, sFTP, JBuilder

Confidential

• Global Services System GSS , full-cycle development of this client-server Guest Services management application, used to track, monitor, and report VIP scheduling. GSS also provided the sales dept. with reporting and budget analysis related to cost center spending. This required the ability to gather, interpret and present complex data. I was able to successfully complete this fast-track project within its limited allotted timeline.

Environment: PowerBuilder, MS SQL Server 2000, Netware, sFTP, Excel

Confidential

Consulting Developer/Analyst/Project Manager

• Team developer of the high-exposure projects: MDSS, MARS and ES3. My responsibilities were: GUI development, server-side business logic, OO Analysis, ETL, integration, deployment and database synchronization. I was awarded responsibility of project management for the following: 1 SUN Enterprise Server upgrades 2 UNIX OS upgrades 3 ORACLE upgrades 4 Coordinate, plan and negotiate Disaster Recovery plans including implementation, testing and authoring technical documentation. Additionally, I was the group's mediator/facilitator for the SLAs and OLAs with the Operations Center. This required cross-organizational coordination, negotiation skills, maintaining vendor partnerships and conflict resolution between disparate groups.

Environment: Oracle, PL/SQL, Solaris, Excel, IBM Mainframe, AIX, RFP, RFQ, Disaster Recovery

Confidential

Consulting Software Developer/Analyst

• Full SDLC of the Data Transfer Management System DTMS for Retirement Processing Services RPS . This application merged disparate financial data from several internal heterogeneous sources ETL , including: mainframe GEIS , SchwabLink Web and the broker/dealer systems GTS . Upon validation, the data was inserted into SQL Server for evaluation by the Charles Schwab Trust Company CSTC and the Charles Schwab Broker/Dealer relationship associates PCRA . After approval, the data file is archived. DTMS errors generated an email and an alphanumeric page sent to production support personnel via a customized notification application. Additional responsibilities: OO Analysis DBA object prototyping integration testing implementation change management/clean management multi-departmental negotiations, 24x7 production support and technical documentation.

Environment: Powerbuilder, PFC, MS SQL Server, Solaris

Confidential

Consulting Software Developer/Analyst

• Reconstruction of the Central Fulfillment Distribution CEFUD application for the Business Operations Systems Group. This app was designed to collect, validate and migrate disparate data into an Oracle RDBMS via a custom-designed ETL tool. This task was followed by the team's re-engineering of this same application to a Java applet front-end using encryption. Additionally, sFTP was incorporated into the application and business processes using PKI. This led to my assignment as the application security audit compliance reviewer, RFP developer, vendor manager and business relationship manager.
• Developer for the codebase update of the GUS application. GUS is a Teller Reconciliation/ETL application, which interfaced with a DB2 and Oracle database. Data was also written to and collected from desktop databases. OLE was used to format and generate customer form letters.

Environment: MS Access, Excel, Oracle, Java, sFTP, PKI, OLE