Consultant Systems Engineer Greenville, Tx
TECHNICAL SKILLS:
Operating Systems: Windows Server 2000, 2003, 2008, 2012, Windows 7/10 Windows XP ProfessionalLanguages: Visual Basic, C#, VBA, VBScript, PowerShell, JavaScript, HTML, DHTML
Environment: s: IIS, TFS, Visual Studio, Active Directory, DNS, SSMS, VMWare, SMS, ERP, ASP, .NET, Exchange
Databases: SQL Server 2000, 2005, 2008, Access, Oracle
Applications: Sharepoint, MQ, MS Office, Visio, Adobe Photoshop, Microsoft Office
Tools: Venafi, CA Stackgen, Installxpress, Splunk, Repliweb, Application Lifecycle Management, SCM
PROFESSIONAL EXPERIENCE:
Confidential, Greenville, TX
Consultant Systems Engineer
Enforced Global Information Security standards in server builds, configuration, deployment, and maintenance. Educated development groups about reasons for standards when needed. Worked closely with both Agile and Waterfall SDLC process to maintain and customize environments as needed. Structured DNS for Test environments.
Scripting complex server configurations and modifications in Batch, VBScript, PowerShell including Registry changes.
Managed and structured architecture for code changes in Team Foundation Server (TFS).
Monitored and deployed different versions of .NET framework from 2.0 through 4.5.2 to maintain code stability.
Developed server SSL certificate checking and validation scripts for large numbers of targeted servers. Ground up architecture and build of Venafi tree structure for Mortgage Technology for 458 servers/applications. Custom development of scripts to create Venafi imports. Validating and deploying large groups of SSL certificates with scripts and Venafi. Worked closely with PKI Administrators to resolve issues. Created 172 page “how to” reference document for certificate management and Venafi tasks to train team members both onshore and offshore. Trained other employees on CA Stackgen, and other inhouse tools.
Configuration, troubleshooting, and support of web server performance for the Mortgage Division of Confidential, supported over 20 applications in Artificial Intelligence and Central Services. Subject Matter Expert for Environment Management and Support, certificates, server farm deployments, configuration, testing and troubleshooting, requiring close interaction with management and teams both onshore and offshore in Europe and India.
Built and configured Repliweb servers and jobs for maintaining servers, deployments and applications. Responsible for setting up websites, Windows services and scheduled tasks, and SQL batch files before hand over for QA validation. Work was performed on Windows Server 2003 thorough 2012. Migrating Build servers with Visual Studio including 3rd party components. Installed and configured Single Sign - On (SSO) interfaces
Application interfaces with SQL Server 2005/2008. Created scripts for deployment automation and server inventories, scripts to remotely validate large numbers of server configurations with targeted groups. Scripting deployments for the First Mortgage Origination Systems groups.
Confidential, Greenville, TX
Contract Network Engineer
Configuration, troubleshooting, and support of web servers for the Mortgage Division of Confidential . Application interfaces with SQL Server 2005/2008. Created scripts for deployment automation and server inventories, scripts to remotely validate large numbers of server configurations with targeted groups. Scripting deployments for the First Mortgage Origination Systems groups.
Installation and configuration of CruiseControl.NET automated continuous integration and servers and NAnt. Setup and configuration of 4 Build servers with process custom scripting for backup and staging.
American Airlines
Technical Consultant Server Deployment Project
Subcontract for Microsoft Corporation. Designed and developed scripts for the custom wrapper configuration of Windows Server 2008 R2 images to automate the deployment of HP servers throughout the organization. Specific customizations included NIC configuration and teaming, ILO card configuration, manual IP configuration, and applying images. Design and coding of an IP configuration HTA and unit test. Major rewrite of NIC Teaming functions to use an XML library of all possible configurations for a given server model, including XML for non-teamed NICs. Wrote functions to determine slot and port ordering for physical NIC port locations and synchronize them with local area connection names in both PE and Windows. Designed and tested script to set the swap file. Modification and debugging of download update scripts. Created script catalog to define and describe the function of all scripts within the overall Build.
Confidential
Lead Consultant and DBA for Kaspersky Deployment Project
Designed and developed scripts for the complete uninstallation of all Symantec Antivirus products used in the DISD, then installation and configuration of Kaspersky Anti-Virus. Created VB Scripts to shutdown Windows System processes, remove leftover files and registry entries, ftp files, and email reports. Also created scripts for Kaspersky Admin server contact and process initiation. Wrote various utility scripts for tasks such as system evaluation and reporting, changing computer names, and joining computers to the domain. Installation reporting is done by uploading csv files to the ftp server, then using a scheduled SQL Server 2005 SSIS process to retrieve and add them to a database table. Created databases, installed and configured SSIS and SSRS, wrote custom SSIS process for imports and setup as a scheduled Job. Wrote custom views and stored procedures for maintenance. Used SSRS for reporting on installations. Created ad-hoc reporting tool that was compatible with both Access 2003 and 2007 in VBA for management. Wrote procedures, technical documentation, and user guides.
Point Solutions LLC Independent Contract
Technical Consultant MAS 500
Troubleshooting issues on a MAS 500 Point of Sale System integration. Made recommendations to developers to correct problems and smooth transaction integration through several versions of MAS 500 using C++ and SQL Server 2000 and 2005.
Confidential
Technical Consultant MAS
Began with MIS in the MAS 500 ERP Development Group, customizing and writing add-on solutions and modifications for Customers with Visual Basic, VBScript, JavaScript, and SQL triggers and stored procedures. Was asked to join the Technical Consulting Group to assist Customers and Application Consultants with a wide and unusual variety of problems, at the Application, Database, and Systems level. Evaluation and recommendation of applications, hardware, architecture, and configuration for optimum balance of cost benefit and projected future use. Made recommendations to Customers and Application Consultants to resolve a wide and unusual variety of problems, at the Application, Database, Systems and Configuration level. Often this required migrating databases, upgrading databases, creating and configuring SQL Servers, setting up and scheduling Jobs and DTS packages, importing legacy, customer data, and troubleshooting SQL issues.
Replicated customer server operating environments creating specialized images on over 50 VM Ware server instances with a wide variety of configurations. Managed VMWare environment to balance resource loading.
This ranged from Systems Administration, SQL Server DBA, and database troubleshooting activities, to creating custom Crystal Reports, complex data views, complex stored procedures, MS Office interfaces, to developing one-of-a kind custom solutions. Custom Business Intelligence Cube design and development. Created Saleslogix reports using ASP and JavaScript for company customer portal.
Confidential
Consultant
Systems Analysis and troubleshooting of development server and online web e-commerce application. Corrected issues with online credit card verification system, and certificate issues. Application written in VBScript and JavaScript, using ASP, IIS, Commerce Server 2000, and SQL Server 2000 with ADO connections to Elite Informix based accounting system. Created completed test server for evaluation and testing. Setup nightly job to refresh test environment and backup data from production. Evaluated of performance issues, made recommend ions for future updates, corrections, issue resolutions, and design changes of Confidential.
Confidential, Waxahatchie, TX
Systems Manager
End to end responsibility for development of Confidential web site. Hosted on Windows XP Server with IIS. Performed site search engine optimization (SEO). Designed and developed web catalog for machine shop services, marine, and power sports engines. Designed and developed mass email utility for marketing and dealer updates. Also performed all Systems Administration and Management, networking, and user support functions for a small office. Server was NT 4.0, workstations Windows XP Professional. Website written in ASP with Access database. Coding was in VB Script, JavaScript, DHTML, and HTML. Ad hoc training of users on Microsoft Office applications. Order entry in SBT Accounting System. Extracted raw data from SBT Accounting System for the e-commerce website, inventory, spreadsheets, and conversion to QuickBooks accounting system. Developed database driven automated HTML email mass mailer to prospect for new business; send newsletters to existing customers.
Confidential, Waxahatchie, TX
Developer
Troubleshooting, bug fixes, error correction, updating, research, and testing of very large scale skills system (1192 pages of ASP code). Code base was very large and complex, supporting multiple websites on a web farm. Also did performance testing of various configurations. Database was SQL Server 2000 (multiple databases). Coding was in VBScript and JavaScript, and SQL stored procedures and custom functions. Special project for a customer demo written in Access.
Confidential, Irving, TX
Consultant.
Wrote specifications, flow, designed and developed ASP pages for module in online broker system. Sever side code was written in VBScript; JavaScript for client side processing. Also wrote stored procedures for module in SQL. Database was SQL Server 2000 (multiple databases).
Confidential
Senior Consultant and DBA
Complete responsibility including hosting arrangements for a series of 15 outdoors and fishing oriented web portals, featuring an online reservation system for fishing guides, online ads, news stories, and forums utilizing SQL Server 2000 databases and ASP. Web design, user interface, graphics, coding. and testing. Performed Search Engine Optimization (SEO). Setup shared and replicated SQL Server environment and maintenance. Sites designed and created were 17 different portals with a common back end.