Eric Couch

Experience

*/****-*******

Fort Worth, TX

SQL Architect

US Bank

Implemented data warehouse and reporting system for 50,000 ATMs. System was used for in public earning reports.

Converted large scale Access database and UI to SQL server and ASP MVC website. This system was used for maintenance and installation of ATMs.

Streamlined existing data systems, import and export packages for efficiency.

Coordinated disaster recovery plans and setup failover mechanisms and redundancy for existing database systems and data feeds.

Setup and maintenance of Golden Gate replication services between multiple environments.

Setup transactional replication in one-to-one and one-to-many distributions. Setup log shipping between servers where non-real time data replication was needed.

Analyzed and fixed several production database issues.

Helped with upgrade and migration of databases from SQL 2000/2005 to 2008.

Implemented a Business Objects server solution for reporting.

Developed a reporting system for Cirrus interchange fees.

8/2010-8/2011

Self Employed

Fort Worth, TX

Architect

SAT Investments

Created several complex SQL Server Integration Services applications that imported execution status, time and sales, and quote book data into SQL Server

Wrote SQL stored procedures to convert time and sales data into meaningful reports

Built customized Streambase application to import real-time market data order data into SQL

Made P&L reporting application that included real-time reporting on our trading application instances, account summaries, account details, and account totals. All reporting applications were writing using ASP.net MVC to supply data to a JQuery and EXTJS front end. The data layer utilized the Linq to Entities framework to get data from the SQL Server backend

Architected data infrastructure for the company web portal including a unified authentication model

Created real-time web-based monitoring application to inspect and research our Streambase trading applications performance. This data was imported into the SQL database in real time and then served to advanced real-time graphs to help pinpoint performance issues at all points in our systems. Also included a back-end alert system in SQL with configurable thresholds that monitored performance and responsiveness of data and services throughout out system

SQL SSIS applications that imported market venue fee data for reporting purposes

End of day financial reports in our data warehouse were used to validate market fees and accounting

Reporting applications for real-time trade data and market prices from our data warehouse

Architected and built a custom client application, using c#, that is a trading platform similar to Tradestation for monitoring and placing real-time orders

Made recommendations on packaged application based on research

Interpro

Built process to create and upload order files to fulfillment center using SSIS

Developed watchdog application in SQL to watch orders flow through the system and report on issues or raise events based on configurable thresholds and criteria

Built backend process to receive order shipment files from fulfillment center and send out customer notifications and update order status and tracking information using SSIS

Architected skinnable web front end web model to act as a portal for all clients

Built infrastructure for PCI compliant web ordering system

Orchestrated migration of live systems to new version of SQL Server along with upgraded web servers

Managed and directed a team of programmers, systems engineers and network engineers

Setup development and testing environments

2/2008-8/2010

Transcom

Fort Worth, TX

Lead Architect

Architecture and design of multiple systems including large customer facing web sites and web services, back end products to rate minutes for our billing system, several service oriented backend systems for internal application development, and SSIS for moving large amounts of data in real time. Also, data/object models for all of these systems

Developed blue prints for internal application design based on an MVC architecture. Technologies included ASP MVC, Microsoft Entity Framework, JQuery/EXTJS, and SQL Server

Built front end web services for LNP dips to our backend SQL server

Scripted applications to handle large incoming data feeds from multiple sources using perl, sed/awk, and SSIS

Implemented multiple solutions using SQL supporting services such as SSIS and Reporting Services

Oversaw development of maintenance tasks such as building of development, test, and production servers, building of SAN and migration of several database and system servers to that SAN, SQL maintenance plans, and an enterprise wide database backup solution

Programmed several complicated SQL Server stored procedures for data manipulation, including CLR stored procedures

Assisted management with project plans, technical staffing, and budgeting.

Setup database transactional replication between servers using distribution databases, including handling initial datasets using automated and manual snapshots.

2/2007-2/2008

Self Employed

Dallas, TX

Programmer/Analyst

Platinum Select

Migration of an apache website to a new hosting environment

Programmed a new resume application process using php and mysql

Setup site wide error handling and reporting system

Designed and built database structures/models

Setup regular database maintenance tasks

Built a data import process to allow recruiters to import mass amounts of new job data

Coded a refer-a-friend function on the job board to allow for referrals and rewards for those referrals

Complete search engine optimization of the site including keyword analysis, content changes, content relocation and HTTP status codes, cloaking, geo-targeting, increasing keyword densities, keyword rich URLs, setup of ranking metrics, Google analytics, and domain listings

Security project that included implementation of password rules, logging, security roles, IP restrictions, and type checking form data

Blog site setup for articles using Wordpress

Tditx

Built a partner site for affiliates and partners which was integrated into their sales automation package utilizing ASP.net and Microsoft SQL Server technology.

Setup AWStats for reporting

Programmed a database driven whitepaper/survey function for their site

Tailwaters

Setup ecommerce application using zen-cart

Custom theme

Custom search functions

Tangenergy

Setup database driven globalized site with custom localized content management system

Wyndham hotels

Large scale data migration of their production web databases

Enviro

Architected a custom web based application built on the .net platform that included these features:

Custom ASP.net authentication and membership providers on top of a real SQL data model

Complex large database design

Custom XSDs for storing XML data fields in MS SQL

Business object layer design and code in C# objects

2/2006-2/2007

Milliman

Dallas, TX

Development Manager

Designed and implemented build/deployment system across a 4 level testing and QA platform

Helped code changes to resolve defects across various systems

Designed and programmed a data import/data update service to handle hundreds of customers with various data formats. Solution included scaling across services/servers by managed custom weighting metrics

Helped implement code changes to improve performance in several systems, including an 1800% increase in performance needed to our core engine in order to support the needs of new clients

Programmed a single sign on solution for our external web portal

12/2004-2/2006

Gamestop.com

Grapevine, TX

IT Manager

Managed and helped develop new web site functionality for Gamestop.com such as:

A new fraud system for credit cards to take orders instead of using a third-party gateway

oBuild a Commerce Server pipeline component to flag credit card orders with status based on complex business rules

oImplemented a C# .NET web application for fraud reps to manage credit card orders

An advanced site advertising system that supports advertising by storefront, genre, and affiliate brand

oExtended the existing ASP and Bizdesk code to allow for more granular manipulation and management of online advertising

Implemented site wide security measures to harden our hardware and software

oDocumented internal software development standards to insure security

oBuilt encryption components for sensitive data

oFacilitated exhaustive security testing of our websites

Migrated our existing fulfillment application to a new system using C# web services

Built C# backend application to enhance existing fulfillment applications to handle added functionality for rate shopping and address correction

Oversaw the operation to move our environment to new servers including adding new application servers, moving 5 database servers to a SAN, adding 12 new web servers, and adding 6 new web trends servers

Implemented an entire Webtrends solution for site trends monitoring for all of our internal and public websites

Managed the entire merger of Electronics Boutique which consisted of:

oIntegration of two unique web sites that command 100 million dollars of revenue a year

oImplementing a redirection service for extinct links and product pages

oBuilding an accurate real-time invalid link reporting

oHelping with data migration and data integration

Migration of EB direct and indirect affiliates and tiers to the GameStop affiliate model

Migration of third party integrated services from EB.com to Gamestop.com

Managed large group of developers and engineers.

Built and managed our direct marketing system using listserv and SQL

7/2002-12/2004

TicToc, Inc.

Dallas, TX

Chief Technology Officer

Oversaw the development of several large-scale projects from the ground up including several internal systems and approximately 30 web sites including an e-commerce template for alumni associations for several large universities including Alabama, Nebraska, Navy, and Auburn. These sites were created using a Microsoft platform with Microsoft Commerce Server 2000, IIS, Microsoft SQL Server, Biztalk, and MSMQ

Built e-commerce sites for several large companies including Home Depot, Southwest Airlines, AOL, and SBC/Yahoo. These included both uniform programs and promotional branding sites

Managed large group of full-time employees and technical consultants to complete projects 100% on time.

Built internal systems to facilitate the operations of all of our e-commerce sites

Effectively managed SEO and pay-per-click marketing budget of $20,000 a month to produce positive gains

Programmed a back-end order management system using C#

11/2001-7/2002

Microsoft, Inc.

Dallas, TX

Technical Consultant

Training in Microsoft ASP .NET, .NET Framework, Microsoft Reference Architecture for Commerce SQL Server 2000 and Microsoft Commerce Server 2000

Handled consultant services for SQL Server 2000, Biztalk 2000, Microsoft Commerce Server 2000 and Commerce 2002, including cases for .NET

8/1999-8/2001

IT Partners, Inc.

Dallas, TX

E-Commerce Technical Architect

Constructed an internal network of servers for use as an Internet application service provider using Cisco Local Director scaling technologies for the web servers, Microsoft Commerce Server 3.0 for e-commerce applications, FTP servers and a SQL Server database. Later this environment was moved to Windows 2000 with scaled middle tier COM+ application servers and clustered SQL 2000 databases

Acting architect and manager for a team to build an extranet portal from the ground up for ABC Radio Networks to provide affiliates with images and broadcast material. We used ASP and MS SQL 7.0 for this solution. This site was hosted on our servers

Architect and manager for a team to build an online lottery site for eDirect, LLC. I built an internal network to host the site consisting of scaled IIS 5.0 web servers, COM+ component servers, ILAP servers, media servers, and clustered MS SQL servers. Commerce Server 3.0 was used for personalization and membership and direct mailing

I spent 9 months as an onsite consultant and team lead for Lifecast.com. Lifecast.com is a portal site for country clubs with over 1000 independent web sites in their network. Technologies used were ASP, MSSQL 7.0, Vignette, COM+ components, and Engage ad software

Architect and programmer for an online loan application processing system for Pacific Technology. Car dealerships, mortgage companies, and other loan applications use this site

Constructed an online store using Commerce 2000 while the product was still in beta form for Statlab.com

I worked with our internal networking professional to build an administration web for our production server co-located at the Infomart. Our network engineers can access this site to remotely administrate our production environment via any browser including PDAs and cell phones

Managed training of consultants and internal employees in structured classes on ASP, VB, Microsoft SQL, and MS Site Server/Commerce Edition

3/1999-8/1999

Beckett

Dallas, TX

Consultant

Developed business rules and data model to replace all internal systems consisting of a very rich interface tailored for IE5 to support the publishing, ordering, and distribution systems for all books and magazines for over 4000 distribution accounts across the nation. I built SQL databases from the ground up to support all of these internal systems. This project was a complete success with all internal systems redeveloped in less than 6 months and is still in use today. I managed a team of consultants and acted as mentor to complete this project

Helped out with the construction of the external Internet web site for www.beckett.com. Help was provided in the areas of security and standards, online real-time credit card transactions, and database architecture

8/1997-3/1999

Mary Kay, Inc.

Dallas, TX

Senior Programmer/Analyst

Acting architect for migration of online ordering system from an FTP architecture to a NT 4.0/IIS 4.0/Commerce 3.0 solution by designing architect, supporting development, implementing business rules, creating data models, and implementing process flows, security, and standards. Approximately 500,000 consultants use this site worldwide. As of 1999, it was the 4th largest retail site in the entire Internet with over 500 web servers in the production environment.

Built an order tracking intranet application for tracking orders received online with our e-commerce web for monitoring and researching problems with orders. It has been in place for a year and continues to accurately report on as many as 40,000 orders a day

Created browser independent online web reports for over 20,000 director level consultants using HTML, DHTML, ASP, and client-side JavaScript. These reports are real time and vital to highest-level consultants in the company

Facilitated a technology analyst role by reporting new and interesting technology that applied to the business such as chat server, MS Netshow, DHTML, web based discussion groups, Commerce Server 3.0, MSSQL 7.0, Windows 2000, Visual Studio 6.0, and Internet steaming audio/video

9/1995-8/1997

Software Spectrum, Inc.

Garland, TX

Application Support/Lead

Windows application development using C++, Visual Basic, and Powerbuilder.

Development and maintenance of Sybase transact SQL stored procedures and data modeling

Unix C, Csh, Ksh script development for maintenance and procedures for Sybase database

Future Technology Analyst

Established a business-to-business electronic commerce site and integrated its processes and data into an existing legacy business processes and databases. The site automates consumer/corporate order requests, order tracking, and reporting via the web. Designed web pages following the Microsoft DNA architecture blueprint using Microsoft Visual Interdev as a tool. Web pages consisted of HTML, Active Server Pages, and Microsoft Commerce Server code. Our solution was a balance of using ADO to access and manipulate data in our Microsoft SQL server directly in ASP and a component layer of MTS user interface/business objects accessing and manipulating data directly from ASP and the Commerce Server pipeline. Currently, the site handles approximately 1 billion dollars in revenue annually. This was one of the 5 largest B2B commerce sites on the entire Internet at the time

Designed and created server side components for IIS 3.0 and Commerce Server 2.0 with VB 5.0. Programmed Internet related and web enabled applications with VB 5.0. Developed client side components and applets using ActiveX and Java. Implemented Microsoft Usage Analyst/Site Analyst for site reporting. Built Internet servers straight out of the box, installed and configured a NT 4.0 TCP/IP network, and installed and configured IIS 3.0 servers, Commerce servers, application servers, MTS servers, FTP servers, and chat servers for development, staging, and production environments

Investigated and researched new and future hardware/software technology for business application. Presentations were given directly to the officer group on possible effects and implementations in our company. Acted as quality control for software qualification and evaluation

5/1992-8/1995

United States Air Force

Dyess AFB, TX

Air Launched Missile Systems Specialist

Component level electronics repair and maintenance on missile systems

Received a National Defense medal for my efforts in support of Desert Storm

Top Secret security clearance

Technical Order Distribution Office NCOIC

Awarded a Meritorious Service medal for excellence above and beyond the call of duty

Wrote various programs for organizing and tracking technical orders, updates, and changes for the entire base

References

NAME: David Oldright

COMPANY: Trinity MSP

TITLE: President

PHONE: 972-***-****

E-MAIL: acqd4a@r.postjobfree.com

NAME: Todd Wallace

TITLE: CTO

COMPANY: Transcom

PHONE: 682-***-****

E-MAIL: acqd4a@r.postjobfree.com

NAME: Steven Haynes

COMPANY: TicToc

TITLE: CEO

PHONE: 972-***-****

E-MAIL: acqd4a@r.postjobfree.com

NAME: Butch Johnson

COMPANY: Interpro Group, Inc.

TITLE: President

PHONE: 817-***-****

E-MAIL: acqd4a@r.postjobfree.com

Contact this candidate