Project Sql Server
Resume:
Jeffrey D. Binnig
*** ****** ( Forney, TX *****
214-***-****(M)
*******@*****.***
Objective
Currently seeking challenging position requiring multi-tasking skills.
Professional Experience
Santander Consumer USA Dallas, TX
Application Team Lead May 2006 - September 2014
SCUSA offers solutions for non-prime finance through our network of dealer
partnerships.
Project: MySupervisor Purpose: MySupervisor is for servicing loans. C#
winforms development, multi-tier, Remoting, MSMQ, MQ Series, XML, Windows
Services, Asynchronous Web Services, Citrix environment, SQL Server
2005/2008/2012, SOAP, WSDL, Custom Framework Integration, Avaya telephony,
Aspect Telephony, MOSAIC telephony, LINQ, XAML, WPF, ASP.NET, JQuery, JSON,
MVC, MVVM, Blend, HTML5, CSS, Infragistics controls, Attribute based
programming, Delegates, PowerShell.
Project: CARS Purpose: Cars is for funding loans. C# winforms development,
multi-tier, remoting, XML, Windows Services, Infragistics controls.
Project: Credit Purpose: Credit is for loan originations. C# winforms
development, multi-tier, remoting, XML, Windows Services, Infragistics
controls.
Project: ETL Purpose: confidential and secure ETL of data between business
partners, third party vendors and government compliance entities. SQL
Server 2008/2012 Development, Administration and Support, DTS, Powershell,
SSIS, Informatica, Control-M scheduling, Batch scheduling, Microsoft SQL
Agent, Replication, EBCDIC, ASCII, PGP File Encryption, SFTP, FTPS, Control-
M migration, SQL Server migration.
Developer lead and team lead. Systems support. Onsite support, offsite
support, 24 hour support. Microsoft Cluster deployment and support. Onshore
support. Deployment support. Post deployment support. Tier IV support.
Enterprise debugging and support including SQL Server, active directory,
clustering, SCRUM environment, iterative development. Code Reviews. Intern
mentoring and training.
Software Architects (now Sogeti) Irving, TX
Managing Consultant Jan., 1999 - May,
2006
National company employing IT consultants developing Custom Applications
and Enterprise Application Integration.
Complete Life cycle involvement covering Microsoft, Oracle, web and
intranet. Debugging enterprise issues including database errors and
performance. Executive mentoring.
Project: EBGames Migration Client: GameStop, Inc.. Purpose: database
support, design and develop Retention Process for Internet, Order
Management, and Fulfillment databases. SQL Server 2000, CA ER/Win,
Sharepoint. Biztalk demo.
Project: Promotions Master Client: 7-11. Purpose: Support, design and
develop ASP.NET application. SQL server 2000 Reporting Services, ASP.NET,
Visual C#.NET, Visual Studio 2003, XML, XSLT, Oracle 9i DB developer.
Project: KUME Client: Horizon Lines. Purpose: Support, design and develop
ASP.NET applications. SQL server 2000 Reporting Services, ASP.NET, Visual
Basic.NET, Visual Studio 2003, HTTPPipeline hijacking, Javascript, CSS,
MVC, XML, XSLT, Web Services.
Project: iCASH Client: Brinks. Purpose: Design, develop, deploy Business
Objects WebIntelligence. Design, develop, deploy Biztalk 2004
orchestrations. Sharepoint, Biztalk 2004, Windows Services, Web Services,
RSA security, firewalls, reverse proxies, OneNote. LDAP, Active Directory
2003, Apache Server, SQL Server 2000, JSP, ASP.NET, Visual C#.NET, Visual
Studio 2003, XML, XSLT.
. Project: Support Client: Orthofix. Purpose: Support SAS and FoxPro
applications. Interview candidates for permanent placement.
Project: CCD/MIU migration to PDM. Client: Conseco Insurance Group.
Purpose: Modify data mart. Oracle DBA, Oracle 8i, Oracle 9i, HP Unix, Korn
Shell, C Shell, Autosys scheduler. Project leader.
Project: Peoplesoft conversion Oracle to SQL Server. Client: Alcon.
Purpose: Oracle 8i, SQL Server 2000, VBScript, Peoplesoft development, Unix
Batch, Unix Shell, Windows Batch, Korn, Perl, Sed. Project Leader.
Project: CPS.NET. Client: 7-11. Purpose: Oracle batch development, Oracle
DBA, Oracle Networking, Oracle Schema development. Oracle 8i, Korn, HP/UX
(Superdomes), Pro*C, C#, .NET. Technical lead for Oracle, technical
resource for .NET.
Project: SIMS. Client: Pagenet Purpose: Oracle batch development, Oracle
Schema development, Data modeling, Oracle DBA. Oracle 7.3 batch development
using PL/SQL Korn. VB6 prototype.
Project: Credit. Client: Drive Financial. Purpose: VB6, COM+, SQL Server
2000, XML. Microsoft DNA architecture. Custom XML parser. Deployments and
Post Deployment support.
Project: www.yesbanker.com/www.yesbroker.com. Client CitiFinance. Purpose:
ASP website development, CSS, Javascript.
Project: B2B. Client Sante Fe. Purpose: ASP, SQL Server 7 DTS packages.
Convert COBOL extracts to mainframe to SQL server table using DTS and batch
programming.
Chemical Information Systems, Inc., Dallas, TX
Programmer Sept., 1999 - Jan., 2001
A research and software company offering information based software for the
base chemical industry. CIS also has a website offering the same
information on-line.
Develop commercial Visual Basic ver.3 and ver. 6 applications with various
database backends. Design and build data entry forms and reports.
Collaborate with marketing on design of program.
Project: Wayfinder. Purpose: Supply 3rd party with VB executable, and data
files for demo program. My role: Create new 32-bit VB6 program and design
and build Access97 data file. We went from nothing to shippable demo in
less than 5 days.
Project: WBDU. Purpose: Stand-alone VB3 application that accesses encrypted
dBase tables to sell to our customers. My Role Build and repair VB 3.0
front-end. Build a string search engine. Design and build install program.
Apps used: MS Visual Basic 3.0, InstallShield Express 2.12, Norton Ghost
for the test machines. Easy-CD CD creator ver 3.5c. Technologies used:
Successware data access engine ver. 2.
Project: DWCP. Purpose: Stand-alone VB6 application that accesses an
Access97 database to sell to our customers. My Role Build VB 6.0 front-end.
Build a search engine. Design and build install program. Collaborate with
Installshield on Install program. Apps used: MS Visual Basic 6.0,
InstallShield Express 2.12, Norton Ghost for the test machines.
Technologies used: ADO- ActiveX Data Objects, ADOX, TrueDBGrid pro 6.0 add-
in, AgFastForm ActiveX, AniGIF animated GIF display tool, Installshield
6.2.
Project: FDA Base. Purpose: Stand-alone VB6 application that accesses an
Access97 database to sell to our customers. My Role Convert data from dbase
III and comma delimited text files to Access97. Build VB 6.0 front-end, 6
forms. Build a search engine. Design and build install program. Apps used:
MS Visual Basic 6.0, InstallShield Express 2.11, 2.12, VB Package and
deployment Wizard, Norton Ghost for the test machines. Technologies used:
ADO- ActiveX Data Objects, TrueDBGrid pro 6.0 add-in, AgFastForm ActiveX,
Installshield 6.2.
Moyes & Co., Inc., Dallas, TX
Technical Director 1997 to Jan., 2001
A financial and strategic management service to the natural resource
industry cutting across the traditional demarcations between financial
advisors, project evaluators, and technical advisors. Moyes & Co., Inc.
maintains a comprehensive database of country, industry and company
activity globally.
Develop Internet/Intranet database applications with Active Server Pages
technology. Design and build VB data entry forms and reports. Design,
build and manage databases. Maintain Windows NT 4.0 and Windows 2000
network and accounts, including RAS. Maintain ISDN Internet connections
and accounts. Full responsibility for all computer hardware and software.
Consult with president on direction of Web site and computer systems.
Provide technical support to users for Office 97 Professional applications,
Adobe and Corel Graphics Software, as well as GIS Software.
Project: Data Entry. Purpose: We were running a non-SQL, non-ODBC compliant
database, Omnis7 alongside MS Access97. We needed to combine data from both
and needed a single database solution with a single front-end. We chose MS
SQL Server 7.0 and Visual Studio 6.0. My Role: Import data from Omnis7 and
Access into SQL Server 7.0 using DTS and Import and Export Wizard. Build VB
6.0 front end (over 40 forms), modify our existing ASP pages to work with
SQL Server. Build a boolean search engine for website. Manage part-time
programmer, train data entry. Modify Excel97 to work with SQL Server 7.0.
Apps used: MS Visual Studio 6.0, MS Sql Server 7.0, MS Visual FoxPro 6.0,
MS Access97, Microsoft IIS 4.0, NT Server 4.0, Microsoft IE 4.0+ Netscape
Navigator 4.0+, Pinnacle Web Works Graphics Server 5.4, ASPChart
Technologies used: ADO- ActiveX Data Objects.
Project: On-line Database. Purpose: Show Production, License, and Company
Directory on-line for sale to subscribers. The databases are query-able.
Graphics Server creates charts from database dynamically on-line. Beginning
GIS system. Editable web pages by internal users. My role: Design and Code
Asp pages, html pages, customize ActiveX dll's, install and maintain
security, system testing, response testing, UI testing. Apps used:
Microsoft IIS 4.0, NT Server 4.0, Microsoft IE 4.0+ Netscape Navigator
4.0+, Pinnacle Web Works Graphics Server 5.4, ASPChart Technologies used:
ADO- ActiveX Data Objects, HTML, DHTML, ActiveX dll's, ActiveX exe's,
VBScript, Javascript, HTML image maps, and HTML frames, SQL Server 7, 2000
and Access database.
Project: Access to Excel to Access. Purpose: This project is to allow a
petroleum engineer to read oilfield production data into Excel to
interpolate and forecast the data. The current data sets available to
petroleum engineers are sparse and difficult to verify. By pulling the
data into Excel, Excel can show the data in tabular format and in a semi-
log chart simultaneously, quickly revealing errors and anomalies in the
dataset Data is then saved back to the Access file in either of two, user
selectable, ways, interactively and non-interactively. Interactively the
application will prompt the user to update/insert records record by record.
Excel was used because engineers are familiar with the application,
allowing quicker learning curve. No custom-built equation editor would need
to be built had the project been built in a stand-alone Visual Basic or
Access system. Database has 3 main tables, 39 fields, 25 megabytes of data,
and over 50 queries. My Role: Design and build the database, design data
entry schema, built spreadsheet, test on LAN network, and train users and
clients. Apps used: Excel97, Access97, Technologies used: VBA- Visual Basic
for Applications, DAO- Data Access Objects, SQL- Structured Query Language.
See also Project: On-line Database.
Project: License Database. Purpose: The License Database is for storing
data on License Blocks all over the world. Quick reference and comparisons
of blocks and countries is the object of this project, for an in-depth
history of the blocks, a hyperlink to a proprietary database is available.
Each license has several dollar values, and qualities that on-line users
can sort and query. The access database has 6 main tables and multiple
records. My Role: Built database, built Access forms, train users, train
clients, built Active Server Pages interface for clients. Apps used:
Microsoft IIS, Netscape Navigator, Microsoft Internet Explorer Technologies
used: VBA- Visual Basic for Applications
Project: Company Directory. Purpose: The Company Directory is for storing
names, titles, addresses, web sites, emails, phone numbers, and resumes of
various players in the Oil and Gas industry. My part consisted of improving
the Access form, splitting the data into multiple tables, and displaying
the data online in a query-able, sorted format. Online (see Project IIS)
subscribers can sort on last name using a "like" query, and search by
country, city and industry, and search by company. Clients can click on
emails and web sites. See also Project: on-line.
Project: File Upload Facility. Purpose: To allow sharing of private
documents for various clients on-line. The File Upload Facility allows one
to upload files to a protected directory that they and others can access
over the Internet. When uploading a file, the client must insert name and
email. The name and email are used to log the uploading of the file. A
dynamic web page is used to download the file, see version, date and person
who uploaded it. My Role: Install web server application, act as web server
Admin, client subscriber maintenance, train clients, modification of Web
server Windows CGI add-on. Apps used: O'Reilly and Associates Website Pro
1.1, Netscape Navigator, Microsoft Internet Explorer, Visual Basic 4.0, 5.0
Technologies used: Windows CGI framework.
Project: LAN Admin. Purpose: Upgrade and maintain NT LAN with dedicated
ISDN connection to the Internet. Role: Determine needs and budget with
president of company, upgrade, buy, and build File Servers, Web Servers,
Workstations, Notebooks and routers. Maintain security, NT Accounts. Train
Users, and Documentation. Apps used: NT Server, NT Workstation, Windows95
and 98, PCAnywhere 8.0, Microsoft Office97, Microsoft NT Option Pack, FTP
Server Hardware used: Gandalf Edge Router 5242I, Ascend Pipeline 75 router,
Nortel NetGear RH328 router. Technologies used: Windows NT Security,
TCP/IP, NetBeui, SCSI, RAID mirroring, Routing, RAS, RRAS, VPN, Hewlett
Packard TCP/IP printing, ftp, Microsoft Front Page extensions.
Arlington Youth Services Arlington, TX
Kross Kolors Manager 1995 to 1997
AYS is a not for profit agency that provides youth involvement in after-
school activities for ages 4-18.
Build and maintain systems and network. Provide technical support for and
training of end-users. Supervise teenagers doing volunteer work in the
community. Manage resources, supplies, budgeting and purchasing.
Veco International, Inc. Prudhoe Bay, AK
General Maintenance Technician 1988 to 1995
VECO delivers valued engineering, construction, operations, maintenance,
and management services to key clients in selected locations worldwide.
Pipe-fitter helper, welder helper, front-end loader operator, painter, and
insulator. Lead man on 3-month construction job, coordinating materials
and workers.
Education
University of Texas at Arlington, Bachelor of Science, Information Systems,
1997.
Oracle Certified Associate Oracle 9i.
Microsoft Certified Professional ASP.NET
Additional Training. Two semesters of Statistics with Excel 5.0, Excel95,
and Excel97. CompUSA classes include Microsoft Excel97 Advanced, Microsoft
Access97 Advanced. AutoCAD Rel. 11. Biztalk training. Biztalk trainer.
Sharepoint training, Content Management Server training, Commerce Server
training. Mastering Computers Microsoft TCP/IP 3-day seminar. Landmark
Aries, an economic analysis tool.
[pic][pic][pic][pic][pic][pic][pic]
Contact this candidate