Resume of Hands on IT Executive

Title
Hands on IT Executive

Primary Skills
MCSE+I MCDBA, MCSD, SQL Server, VB, ASP, .Net, RUP, CMM, Project Management

Location
US-CA-Corona

Posted
Mar-05-07

Christopher Thibodeaux Consulting
March 1994 - Present
Position: Principal
* Manage up to 35 personnel
* Manage all P&L, AP, AR, Invoicing, Collections, Banking, Procurement, Logistics, Contracts, Contract Negotiations, and ancillary functions
* Establish budgets in access of $10 million dollars, conduct Board meetings, administer corporate paperwork
* Create Unique Selling Propositions (USP's), marketing materials, and sales literature
* Solicit new business via various means and engage C-Level executives in selling the companies Management and Technical Consulting Service offerings
* Establish and Implement Change Management Procedures for IT Clientele, incorporating SEI/CMM, Joint Application Development (JAD), and the Rational Unified Process (RUP).
* Assist clients in development of Business Plans, Marketing Plans, Business/Pricing Models, and assist clients through stages of acquiring funding within the Investor communities.
* Provide Consulting Services in areas of Technical Architecture/Design, Infrastructure Security, Full-Lifecycle Software Development and specialized services, such as Project Tracking and Oversight, Database and Network Architecture/Deployment, and Object-Oriented/Relational Database Modeling.
* Provide Feasibility/Risk Analysis Surveys, Business Process Re-Engineering, Process Improvement, Due Diligence Studies, Contingency Planning, IT/MIS Security Audits, Business Development, Strategic Planning, and Staff Augmentation/Recruiting services to clientele.
* Architect global product website utilizing Microsoft .Net (ADO.Net, ASP.Net, VB.Net, C#, MSMQ), SQL Server 2000, SQL Server 2005, PC Charge, and Great Plains 8.5 and 9.0
* Architect and design Vignette Portal 7.1/7.2 B2C and B2B websites

NOTABLE CLIENTS INCLUDE:
------------------------
WesCorp Credit Union
Sept 2006 - Feb 2007
Position: Sr. Programmer/Analyst (Consultant)
* Modify and maintain Facilities Record Management application, utilizing Microsoft .Net 2003, C#, ASP.NET, SQL SERVER 2000
* Migrate Vignette Portal Server 7.1 applications and portlets to Vignette Portal Server 7.2, to include importing/exporting, creating remote portlets, redesign/re-layout pages, troubleshoot server/migration errors
* Maintain existing Investment Administration (IA) application written in Delphi and Oracle, to include customized report writing and financial data research and reconciliation

United Independent Inc.
Aug 2006 - Sept 2006
Position: Microsoft Project Server Consultant (Consultant)
* Install and configure Microsoft Sharepoint Server, Microsoft Project Server 2003, Microsoft SQL Server 2000, Microsoft Exchange 2003 Server, and Windows 2003 Servers
* Configure Project Server 2003 users, security, email notification alerts, risk/issues logs
* Architect, configure, and create Microsoft Project Server 2003 workflow, custom forms, and email templates.
* Train employee project managers in server configurations, redundancy, and project methodologies, such as task identification, resources, baselines, critical path, milestones, and how to customize views to retrieve desired information.

RSI Professional Builder Services
May 2006 - Aug 2006
Position: IT Manager (Consultant)
* Manage and administer a Windows 2000/2003 Server network, consisting of 15 servers and 85 Windows XP Professional workstations
* Manage and administer Microsoft Exchange 2003, SQL Server 2000, SQL Server 2005, DNS, DHCP, and Active Directory
* Manage and administer Avaya IP Office phone and voicemail system, as well as Honeywell NStar Access control system
* Manage and administer Snapgear firewall, Cisco Pix 515E Firewall, AdTran T-1 router, St. Bernard IPrism Content Filtering server
* Manage Visual Sourcesafe 2005 database and utilize Microsoft Visual Studio 2005/ASP.net/VB.net to develop corporate intranet
* Manage Delphi 2005 compiled source code, to include configuration management of controlled bills
* Architect, test, and implement companies Disaster Recovery Plan

WestPac Air Conditioning, Inc.
Mar 2005 - Mar 2006
Position: Project Manager/Data Architect (Consultant)
* Analyze Clients needs and document in SCOPE document
* Create Use cases, divisible by subject matter, as well as capture all business requirements into single document
* Create Project Plan and Ghantt Chart, analyzing needed resources to deliver project milestones within timely delivery
* Manage entire project life cycle from inception to deployment
* Architect Enterprise OLTP Data infrastructure utilizing SQL Server 2000, DTS, Analysis Services, Stored Procedures, Performance Tuning, Crystal Reports 8.5, and Microsoft Reporting Services.
* Reverse engineer existing data structures into Erwin Models, Physical and Logical
* Utilize RUP methodologies to document existing and new application and infrastructure environments
* Create Company Intranet utilizing existing ASP 3.0 and JavaScript WebPages, including incorporation of Microsoft .Net Technologies in an IIS Web Farm environment

California Bank & Trust
Oct 2004 - Mar 2005
Position: Project Manager/ Data Architect (Consultant)
* Analyze clients requirements and document business requirements, using Use Case methodology
* Create Project Plan and Ghantt Chart to fulfill project deliverables and analyze resource allocations
* Manage project from Inception and Acceptance to Implemented Reporting Warehouse
* Architect Enterprise Data Warehouse, ELT Processes & logic, Development Standards, and Architectural directives, as well as Cube design in a HOLAP/OLAP/Star Schema environment, and MDX Query Expressions.
* Model Logical and Physical Relational and Multi-Dimensional models using Erwin v4.1 and Modelmart
* Create ETL Processes, DTS Packages, Data Cleansing Stored Procedures, and Performance Benchmarking/Error Handling routines using SQL Server 2000
* Create Cubes in SQL Server Analysis Services and integrate Excel Pivot Table integration to emulate existing CVS formatted export reports

Advance Sterilization Products
Mar 2004 - Oct 2004
Position: Data Architect/SQL Server DBA (Consultant)
* Reverse engineer existing SQL Server 2000 databases and format both Logical and Physical ER diagrams in Erwin
* Create ETL modules using SQL DTS and ANSI-92 SQL Syntax
* Create SQL Server Cubes (OLAP) using Analysis Services for reporting
* Maintain backups, nightly jobs, and Operational Readiness for Data Environment
* Create Stored Procedures, Views, DTS, and helper modules with VBScript and WSH

Geary's of Beverly Hills
Nov 2003 - Mar 2004
Position: Project Manager/Architect (Consultant)
* Analyze client requirements, define project scope, and create Use Cases.
* Create Project Plan and attend weekly Management Meetings to advise of Risk Management issues, Budget, Resources, and Milestone Deliveries
* Architect global product website utilizing Microsoft .Net (ADO.Net, ASP.Net, C#, MSMQ), SQL Server 2000, PC Charge, and Great Plains
* Create Test Cases, thoroughly test website functionality, and remediate defects
* Interface with Corporate Executives and Clients Advertising Vendors to ensure the appropriate corporate image was met in the website design.

Broadcom, Inc.
Oct. 2003 - Oct. 2003
Position: Peoplesoft/SQL Server Database Performance Tuning Engineer (Consultant)
* Analyze existing database configuration and architecture and hypothesize areas of performance derogation
* Develop software utilities to analyze the database environments and produce metrics and reports
* Architect automated decision-tree logic to conform and rectify areas of performance derogation found in reports
* Document findings via reports and metrics and present to Sr. Management
* Identify areas of follow-up focus and questions for both Peoplesoft and Microsoft Consulting Services

Mailboxes Etc. (MBE)
Aug. 2003 - Oct. 2003
Position: Database Architect (Consultant)
* Utilize Erwin to reverse engineer existing OLTP schema to HOLAP star schema OLAP datamodel.
* Create ETL Scripts using DTS, Stored Procedures, T-SQL, and custom VB 6 code and ActiveX components.
* Architect replication methodology for Reporting OLTP and OLAP databases, per clients requirements of 0% down-time.
* Mentor junior dba's and application developers.
* Perform Project Management of the new 4.0 OLAP revision.
* Meet with Business Units to discuss and define logistical business requirements for Enterprise Data Warehouse and reporting requirements.

Automobile Club of Southern California - (AAA)
Jun. 2003 - Aug. 2003
Position: Database Architect/Performance Tuning Engineer (Consultant)
* Review California Jewel internal Insurance application (VB 6 - Fat Client) and remediate performance issues in production application using SQL Server 2000 Profiler, Query Plan estimation, T-SQL, and Query Statistics.
* Review California Jewel internal Insurance application (.Net Thin Client) and remediate performance issues in production application using SQL Server 2000 Profiler, Query Plan estimation, T-SQL, and Query Statistics.
* Reverse Engineer and consolidate California and Texas Insurance Application data models, creating both Logical and Physical diagrams utilizing IDEF modeling and Erwin design tool.

Rx Solutions, Inc.
Jun. 2002 - April 2003
Position: Project Manager/Application Architect (Consultant)
* Create Project Plans using MS Project 2000, Functional Specifications, Technical Specifications, Erwin data models, and UML using Visio 2000 Enterprise Edition.
* Create Stored Procedures, Views, User-Defined Functions, and OSQL Scripts using ANSI-92 T-SQL.
* Create Crystal Reports using Crystal Developer Edition, which utilizes Crystal Enterprise Server 9.0
* Perform SQL Server Query and ADO Performance Tuning, to include SQL Profiler, DBCC's, Indexing, and T-SQL Logic remediation.
* Create COM DLL's and DTS packages using VB 6, VBScript, OLE Automation functionality in SQL Server 2000, Excel Pivot-table integration, and both linked servers and ASP Classes using ADO 2.6 to IBM AS/400 data sources.
* Create ASP Pages using client side JavaScript, server-side VBScript, CSS, and J2EE/EJB/JSP integration into IIS, accessing SQL Server 2000 and IBM AS/400 data.
* Prototype and evaluate Microsoft .Net Framework solution to unify Microsoft and Java platforms.

InTouch Communications, Inc
Apr. 2002 - Jun 2002
Position: Sr. Software Engineer (Consultant)
* Create SQL Server 2000 stored procedures, views, and triggers using ANSI-92 T-SQL.
* Administer 4 SQL Server 2000 servers, to include replication, clustering, backups/restores, and nightly maintenance plans.
* Incorporate Seagate Crystal Reports 8.5 reporting engine with SQL Server data sources for both web and fat client application.
* Create COM DLL's to emulate CDONTS functionality, Excel Pivot-tables from OLAP Cubes, and Winsock interfaces to lease-line vendors.
* Create canned queries and DTS packages for Management reporting using T-SQL and VB6.

Global Resource Corporation
Oct. 2001 - Mar. 2002
Position: Sr. Development Technical Lead (Consultant)
* Provide Program Management, 2nd tier Project Management, Technical Oversight Planning, and Defect Remediation Management
* Create automated POS update and logging application using WSH, VB, C++, and Win 32 API.
* Port 16 bit applications from OS/2 to NT 4.0 using both VB 6 and C++ 6
* Create Reports using Crystal Reports 8.5, with SQL Server 2000 source Database
* Analyze existing environment and implement interaction between SQL Server 2000 and MSDE
* Perform Pre-sales support strategic Marketing, Sales, and Recruiting meetings with Director and C Level prospective clients

State Street / Pimco
Nov. 2000 - May 2001
Position: Web Architect (Consultant)
* Create intranet portal website for MS Project/Project Central reporting, using Visual Interdev, ASP, VBScript, JavaScript, XML, and SQL Server 2000.
* Create interfaces to Sybase data sources and for both fat client and web access.
* Introduced key Management personnel to the Rational Unified Process (RUP), develop preliminary Usecases and initial Object Model generation scripts
* Architect and implement Enterprise Security Standards and Practices consisting of Network security, Application Security, Intranet/Extranet security, Firewall and DMZ placement and configuration, and end-user workstation security for Straight-Through Processing solution between internal systems and Bloomberg.
* Architect scalable/redundant website and supporting backend infrastructure using technologies and methodologies such as MS Cluster Service, Site Server Farms, SQL Server Log Shipping, Replication, and daily backups/restores.
* Draft and define Contingency Plans for Website or Database failure/recovery practices and policies for System Security Breaches and/or Hacker infiltration, in accordance with clients' internal protocols.

Sagetree
May 2000 - Nov. 2000
Position: Senior Infrastructure & Technology Architect/Developer (Consultant)
* Architect and diagram Internal and Co-Located Application Service Provider (ASP) Solutions, to include corporate website, product demo website, and VPN security and connectivity.
* Develop Change Management procedures and implement the Rational Unified Process (RUP)
* Assist in configuration and implementation of Microstrategy DSS Web/Broadcaster, Viador Enterprise Portal, Oracle 8i, and Teradata Solution on Windows NT 4.0 and HP-Unix platforms.
* Architect Microsoft Backoffice Solution to emulate the existing Oracle/Informatica/Teradata solution on Windows NT4.0 and 2000 platform, utilizing ASP 3.0, COM+, Site Server 3.0, IIS 5, MTS/MSMQ, Outlook's Digital Dashboard functionality, SQL Server 2000 (Analysis Services, DTS, and Full-Text Indexing).

Cotelligent
Oct. 1999 - Oct. 2000
Position: Senior Infrastructure Engineer/Database Specialist (Consultant)
* Architect and Implement Backend Infrastructure consisting of MS SQL Server 7, ASP, IIS 4, MTS 2.0, Site Server 3.0 Commerce Edition, and incorporating custom interfaces to Great Plains Accounting Software Package.
* Architect and Design Use Case Diagrams, Sequence Diagrams, and Class Diagrams in UML, via Rational Rose, and Enterprise logical/physical data models using Erwin to facilitate deliverables for technical drilldowns and incorporation into the Rational Unified Process (RUP).
* Architect modified-EDI process utilizing MS Biztalk Servers for synchronous bi-directional XML data transmissions.
* Re-Engineer Business Requirements into an Architectural Model for an Electronic B2B/B2C Rich Media Portal utilizing Vignette Story Server.
* Manage Production and Development Database Servers to include, Logical/Physical Data Model via Erwin, Database Management, Scripting, Data Manipulation, Data Transformations (DTS), Stored Procedures, and Data Populations.
* Develop and Implement custom scripts to automate nightly batch jobs and server administration, via Windows Scripting Host (WSH), and SQL-DMO.

County of Orange Data Center
Sep. 1999 - Oct. 1999
Position: Senior Systems Analyst/SQL Server Developer (Consultant)
* Architect and programmatically implement error handling, 2PC, and Audit notifications via e-mail and pager.
* Create ASP pages to maintain automated schedule tracking of Client-Server/Mainframe job synchronization.
* Create Automation/Notification Scripts utilizing MS Windows Scripting Host - WHS.
* Configure MS SQL Server 6.5 Replication and SQL Mail to securely integrate across the Firewall.
* Install and configure SMTP via MS IIS 4.0 and begin planning and documentation procedures for SSL and Digital Certificate integration into the Counties Online Bidding Website.

SMS Settlement Services, Inc.
Dec. 1998 - Sep. 1999
Position: Senior Database Administrator/Data Architect (Consultant)
* Architect SQL Server 7.0 OLTP and OLAP Databases to facilitate business requirements for customized N-tiered Internet Software Package, which utilizes MTS v2.0, ADO v2.1, XML, Dynamic HTML, Java, and VBScript/JavaScript.
* Utilize Erwin's Modelmart functionality and Erwin to architect logical and physical data models to facilitate deliverables, incorporated with the Rational Unified Process (RUP).
* Administer SQL Server 7.0 Servers consisting of multiple v7.0 and v6.5 Databases.
* Design and Develop Stored Procedures/Views, DTS packages, automation of data migration/conversion/population
* Administer Physical Object Models (UML) via the Select Modeling Tool, Logical and Physical Data Models via Platinum Logicworks Erwin Case Tool, track software bugs identified by QA utilizing the Mercury Test Director Software, and store versioned objects and scripts in Rational Clearcase Software.

Cendant, Inc.
Feb. 1998 - Dec. 1998
Position: Senior Systems Integrator/Database Administrator (Consultant)
* Manage and maintain multiple MS SQL 6.5 Servers in an OLTP/OLAP environment, interfacing with DB2 backend
* Architect and Maintain Data Models via Erwin and Object Management via MS Visual Source Safe.
* Write usecases, perform systems analysis, architect both logical and physical datamodels to facilitate deliverables for business and technical drilldowns, while incorporating the Rational Unified Process (RUP).
* Evaluate, document, and Beta test Informatica and Sagent products for in-house ETL and heterogeneous coexistence with enterprise and OLTP/OLAP infrastructure.
* Perform Performance Tuning, to include data re-architecture/restructuring, DRI, Indexing, Network Bandwidth configuration, Hardware Upgrades, and NT 4.0/SQL 6.5 Server level configurations.
* Research/remedy performance degradation from Client-Server to Legacy System connectivity within MS SNA Server.
* Architect and design logical/physical data models, which includes integration with Enterprise Data Architecture, hardware/software recommendations, Use Case Development, and Defect remediation with SQA Suite Software.

Shopping.com
Oct. 1997 - Feb. 1998
Position: Senior Database Administrator/Systems Engineer (Consultant)
* Manage Administration and Development of multiple SQL 6.5 Servers in a high transactional E-Commerce/OLTP Internet environment, to include Stored Procedures/Triggers/Indexing, Data Manipulation, and Performance Tuning.
* Create Back-end repository in SQL Server for Custom Developed EDI Application and coordinate Data Transfer and Formatting for accurate processing, both internally and with external vendor systems via Extranet.
* Assist in overall architecture design of LAN/WAN infrastructure, pertaining to network architecture, data modeling, website code, and Intranet/Internet Site GUI.
* Write and modify Active Server Pages for Internet site accessing SQL Server, IIS, and Commerce Server with SSL integration utilizing MS Visual Interdev.

Toshiba America Information Systems - Computer Systems Engineering Division (CSE)
Aug. 1997 - Oct. 1997
Position: Web Developer/Systems Engineer (Consultant)
* Create ASP and HTML pages for CSE Corporate Intranet incorporating OCX, JavaScript, and Active Movies
* Install and configure NT Server 5.0 (Beta), Windows 98, and MS Exchange Server 5.5 (Beta) in a test environment in preparation for production implementation on 10/100MB switched Ethernet/FDDI LAN/VAN.
* Install, configure, and upgrade MS Exchange Server 4.0 to 5.0, configure RAID and alter DNS Tables.
* Configure heterogeneous integration of multi-domain nodes to utilize MS Exchange Server via MS Outlook v8.2/8.3.
* Troubleshoot Servers/Workstations, Routers/Gateways/Hubs, Performance Degradation, and Data Transference.

IBM Global Services (IGS) - Boeing/McDonnell Douglas Corporation
Feb. 1997 - Aug. 1997
Position: MS Exchange/MS Outlook Implementation Technical Project Manager (Consultant)
* Architect Execution & Rollout Plan for heterogeneous integration of MS Exchange/MS Outlook into current Enterprise Messaging Infrastructure consisting 700+ Nodes and existing MS Mail v3.5, Lotus Notes v 4.5, Groupwise, and Legacy systems users on Windows 95, NT 3.51/4.0, DOS/Windows, and UNIX workstations.
* Assist in architectural design of MS Exchange Server v5.0 backbone to support SMTP, POP3, and Gateway routing, to include NT domain planning/trust relationships, Site Connector configurations, synchronization issues, and naming convention designation, and performance degradation benchmarking.
* Author technical specifications pertaining to MS Exchange, MS Outlook and Techtronix WinDD Server implementation for Phase I rollout.
* Train IGS Mail-Team to install, configure, and administer Windows 95, Windows NT 3.51/4.0, MS Exchange Server, MS Exchange Client, and MS Outlook.

SUMMARY OF COMPUTER EXPERIENCE:
-------------------------------
Mainframe: Classified Material Control Mainframe, IBM Mainframe, and AS/400
Operating Systems: Windows NT 3.x/4.0/2000/2003/XP/Vista, Netware 3.x/4.x/5.x, UNIX, HP-UNIX, Solaris, OS/2, Macintosh v7, DOS, PICK
Protocols: NetBIOS, NetBEUI, TCP/IP, DHCP, PPTP, DLC, IPX/SPX, AppleTalk, SNMP, PPP, FTP, HTTP, SSL
Internet Languages: HTML, VRML, ASP, ASP.net, JavaScript, VBScript, ActiveX, Macromedia Flash, XML, CSS, and Java
Modeling Languages: UML, IDEF1X, Information Engineering, Dimensional Modeling
Programming Languages: Basic, Pascal, Natural/Adabas, COBOL, SQL, Transact SQL, Delphi, VB 4.0/5.0/6.0, FoxPro, MFC, IFC, OLE, COM/DCOM, Microsoft .Net (ADO.Net, C#, VB.Net, ASP.Net), and some MS C++
Databases: REMMPS, Jumps/MMS, COMPLETE, Paradox, MS Access, MS SQL Server 6.0/6.5/7.0/2000/2005, Peoplesoft Financials, Platinum SQL, Great Plains, Informix, Oracle 8/8i, Teradata, and Sybase SQL

MILITARY SERVICE:
-----------------
United States Marine Corps (1991-1994 | Honorably Discharged)
Awards: Meritorious Promotion, Certificate of Commendation (2), Certificate of Appreciation, Commanding General Certificate of Commendation, Secretary of the Navy Letter of Commendation, Naval Health Research Center Letter of Appreciation

EDUCATION:
----------
Associate of Science in Computer Science - 1998
Foley-Belsaw Institute - Certificate in Personal Computer Programming

CERTIFICATIONS/Certificates:
----------------------------
Microsoft Certified Professional + Internet (MCP+I)
Microsoft Certified Database Administrator (MCDBA)
Microsoft Certified Systems Engineer (MCSE + Internet)
Microsoft Certified Solutions Developer (MCSD)

LICENSES:
---------
California Real Estate Sales Agent License

ORGANIZATIONAL AFFILIATIONS:
----------------------------
Boy Scouts of America ()
Project Management Institute
World Wide Institute of Software Architects
Association of Certified Fraud Examiners
American Legion Post #472

EDUCATIONAL AFFILIATIONS:
-------------------------
Saddleback Community College (2001-2002)
Part-Time Instructor: SQL Database Design, Web Database Management, Internet/Intranet Security

LITERARY AFFILIATIONS:
-----------------------
Author - SQL Server 2000 and XML (Sams Publishing)
Technical Editor - .Net Server Bible (Sams Publishing)
Technical Editor - VB.Net, ASP.Net, and ADO.Net (Sams Publishing)
Technical Editor - SQL Server 2000 DBA Survival Guide ( Sams Publishing)
Technical Editor - SQL Server 2000 Unleashed (Sams Publishing)
Technical Editor - SQL Server 2000 Unleashed, 2nd Edition (Sams Publishing)
Technical Editor - Mastering Microsoft Access 2002 Desktop Development (Sams Publishing)
Technical Editor - Mastering Microsoft Access 2002 Enterprise Development (Sams Publishing)
Technical Editor - Microsoft Access 11 Programming Weekend Crash Course (Wiley Publishing)
Technical Editor - Analysis Services with SQL Server 2000 (Wrox Publishing)
Technical Editor - .Net Enterprise (Wrox Publishing)

Certifications
Microsoft Certified Professional + Internet (MCP+I)
Microsoft Certified Database Administrator (MCDBA)
Microsoft Certified Systems Engineer (MCSE + Internet)
Microsoft Certified Solutions Developer (MCSD)


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-CA-Corona »
View all resumes in US-CA »

View other Hands on IT Executive resumes, IT Manager resumes