J Edward "Jerry" Banasik
Missouri City, Texas 77489
E-mail: JerryB@E-ComWorks.net
Cellular Telephone: 281-989-4038


System Architect, Software Developer
Reliable, strong sense of accountability
Outstanding programming skills
Solid managerial abilities
Effective problem solver
Enthusiastic, committed
Inventive and creative

TECHNICAL SKILLS:

Software Developer

  • Programming with Microsoft® T-SQL, Oracle PL/SQL, Microsoft® .NET Framework, ASP.NET, ADO.NET, C#, VB.NET, Visual Studio 2003, Visual Studio 2005, Visual Studio 2008 and producing MSI (Microsoft Installer) files
  • Programming .NET Remoting, Web Services, Web Server and Windows Applications
  • Reading from and writing to Active Directory with the Lightweight Directory Access Protocol (LDAP) using Active Directory Services Interface (ADSI)
  • Developing the commercial grade HySecure 256-bit encryption system
  • Developing web based commercial appointment scheduling software for sports businesses and facilities
  • Developing web sites that use PayPal® checkout / credit card payment system
  • Configuring Microsoft® Internet Information Server (IIS) 5.0 & 6.0
  • Developing Electronic Commerce Enabled Web Sites for B2C and B2B use
  • Configuring Windows 2000®, Windows XP Pro and Windows 2003 Server (32-bit and 64-bit)
  • Programming and configuring Exchange 2003/2007 and SQL 2000/2005 servers
  • Creating client applications that communicate with RightFax Server
  • Performing Windows Administration and Security Management
  • Configuring Microsoft® DNS Server, Transaction Server (MTS), COM+
  • Programming Visual Basic® 6.0 COM Components and Windows Applications
  • Creating and interfacing ADO/ODBC COM objects to SQL stored procedures
  • Creating and modifying Transact-SQL (T-SQL) stored procedures, views, triggers, functions and security configurations
  • Creating and modifying Oracle PL/SQL procedures, functions, views, triggers and security configurations
  • Creating reports using SQL Server Reporting Services (SSRS)
  • Creating Data Transformation Services (DTS) / SQL Server Integration Services (SSIS) packages to transfer data between Oracle and SQL server
  • Programming Extensible Markup Language (XML, XSL, XSL/T, DTD, XHTML)

SQL Server Database Administration and Programming

  • Installing and upgrading Microsoft® SQL Server 6.5 / 7.0 / 2000 / 2005
  • Analyzing and configuring server and network security
  • Analyzing and configuring user security modes and authentication
  • Creating, placing and removing of database files and file groups
  • Creating, altering and managing databases and database objects
  • Analyzing and optimizing database performance
  • Backing-up and restoring database files
  • Performing integrity checks and establishing Maintenance Plans
  • Creating and managing SQL Server Agent jobs
  • Developing database schemas for web and windows applications
  • Troubleshooting transaction and locking problems
  • Importing and exporting data as well as managing DTS / SSIS packages
  • Establishing and managing Link Servers
  • Designing entity Foreign Keys, Primary Keys and Unique Constraints
  • Creating and modifying database tables and relational constraints
  • Optimizing SQL performance through the use of index tuning
  • Creating and modifying stored procedures, triggers, views and user-defined data
  • types
  • Creating result sets through the use of cursors and Transact-SQL and PL/SQL
  • Creating transactional based stored procedures
  • Creating Full Text Search fields and catalogs
  • Moving stored procedures and triggers from development to production servers

Project Management

  • Can conceptualize the big picture and effectively develop Work Breakdown Structure to accomplish required goals
  • Excellent project planning and tracking skills using tools like Microsoft® Project
  • Great people skills, derived from extensive training and successful interaction with stakeholders, clients, peers, subordinates and managers
  • Fluent and accurate in written and spoken English with strong ability to read and understand
  • Attentive and responsive to schedule deadlines while using resources effectively
  • Extensive background in cost reporting and cost projecting
  • Good inductive reasoning and strategic planning abilities
  • Manage multi-million dollar projects with a direct report of 250 people
  • Manage major portions of billion dollar projects
  • Great team builder with many successful and timely project completions

CERTIFICATIONS:

Registered Professional Engineer, Texas No. 54134, Inactive


WORK EXPERIENCE:

OCCIDENTAL PETROLEUM CORPORATION, Houston, Texas
04/05 - Present
Enterprise Systems Project Manager, Software Consultant & Developer

Project Manager to install, provide software support and upgrade the Knowledge Management System (KMS) application produced by Data Systems and Solutions (DS&S) used by the Health, Environment, Safety and Security (HES&S) departments of all Oxy business units.  Write custom Oracle PL/SQL code to update and modify KMS production data.  Maintain the KMS Windows 2003 web servers and KMS Oracle databases.  As project lead, transfer legacy data into the KMS application.  Produce custom reports via SQL Server Reporting Services from KMS data.  Provide support and assist with the training of KMS users.  Provide feedback and improvement suggestions to Data Systems and Solutions.  Develop scheduled DTS / SSIS packages to interface PeopleSoft to KMS.  Evaluate, debug and correct new versions of KMS.  Resolve operational issues, identify and correct data and code problems within the KMS application.  Provide product functional feedback and improvement suggestions to software producer of KMS application.  Using ASP.NET, develop Single-Sign-On Validation web site for KMS.  Make major updates to custom vendor insurance certificate tracking application to work with RightFax Server.  Develop ASP.NET web site for contractor insurance tracking application.  Create and maintain MS Project schedules.  Interview the many HES&S stakeholders about the applications they are using and produce a 62-page technical specification for an event notification and action tracking (ENACT) system, which is intended to replace several legacy applications.  Manage the client review and update of the ENACT specification.  Prepare submission package for commercial and technical proposals for ENACT or a similar commercial application.

AMERICANPASTIME.COM, Spring, Texas
01/07 - 06/07
Application Architect & Software Developer

Using C# and SQL 2005, produce a public E-Commerce web site providing facility reservation bookings and payment collections for many different client companies located in North America.  The ASP.NET web site integrates with the PayPal® checkout system.  Produce an administration web site to allow all client companies to manage their reservation system.  Incorporate client requested enhancements and pre-planned new features into the Production web site.

DXP ENTERPRISES, INC., Houston, Texas
12/04 - 03/05
Applications Architect and Software Developer

As technical lead, develop an ASP.NET E-Commerce web site for DXP Enterprises, Inc. for their Global Pump Sales and Service (GPSS) membership consortium.  The GPSS order entry / modification / RMA web site interfaces with the Prophet 21 Commerce Center ERP system.  This web site requires users to validate their login and obtain their user rights from a Windows Server 2003 Active Directory via LDAP using ADSI.  Additionally, the web site design allows the users to change their login password remotely via LDAP using ADSI in ASP.NET.  To overcome impersonation limitations, a special C# class was developed that used Win32 API functions to provide this capability.  The system design incorporates substantial use of DataGrid paging and paged SQL Stored Procedures with a modified Microsoft Data Application Block to allow the return of error codes.  Develop a multi-threaded email service that sends an HTML version of order and RMA acknowledgements.  This project also involves producing code documentation for the client.

PHOENIX SPECIAL PROGRAMS AND ACADEMIES, INC., Phoenix, Arizona
07/04 - 12/04
Applications Architect and Software Developer

Develop all business use cases, sample web pages, SQL database structure, strongly typed Data Sets, ASP.NET web pages; perform data migration for the Phoenix Special Programs and Academies, Inc.  This client delivers educational courses to homebound / home schooled 7th through 12th grade students either by mail or Internet.  The project involves moving the customer from a MS Access based client-server application to a web based C#, ASP.NET and SQL application as well as adjusting their business processes to handle a larger customer base without increasing staff.

STROMAN REALTY, Conroe, Texas
05/04 - 06/04
Applications Architect

Develop application architecture for a call center project for Stroman Realty, a timeshare real estate marketing firm in Conroe, TX. Work includes defining the SQL database structure, component interface structure, .NET programming execution plan, schedule and staffing requirements.

THOMSON CORPORATION, RIA GROUP, Carrollton, Texas
05/03 - 04/04
Software Developer

The Thomson Corporation is a leading global provider of integrated information solutions to business and professional customers with $7.6 billion in annual revenue.  The RIA Group produces the eForms RS, GoSystems, InSource RS, InSource CS and InSource Express Tax Compliance and Planning Software products.

  • Using VB 6.0 and third party components from Infragistics, ProtoView, Sheridan, VideoSoft and ComponentOne, add new functionality and correct errors in client portion of InSource CS Tax Planning client-server software package.
  • Write SQL 2000 stored procedure and make client software changes to reduce the response time for a section of code from 17 seconds to 250 milliseconds.
  • Develop migration plan to upgrade InSouce CS Tax Planning from the current DNA architecture to .NET code.  Identified 739 issues in 32,000 lines of code.
  • Develop Plan to improve the computational speed of 86 SQL stored procedures used in the InSource Tax Planning software.
  • Revise the Visual C++ 6.0 server COM module and XSL/T code to support new Tax Planning client features.
  • Make general software changes and syntax corrections to prepare the Insource CS Tax Planning product for conversion to C# .NET.

HOUSTON LIVESTOCK SHOW AND RODEO, Houston, Texas
12/02 - 04/03
Software Developer

The Houston Livestock Show and Rodeo is a 501(c)(3) charitable organization that annually generates more than $250 billion of economic global impact.  The Houston Livestock Show and Rodeo mission is to benefit youth, to support educational programs and institutions, to expand agricultural horizons and to preserve and honor pioneer heritages and cultures.

  • Using VB.NET, ADO.NET and T-SQL stored procedures, develop a Windows application assisting international guest check-in and printing of custom badges and tickets.
  • Using ASP.NET, ADO.NET, VB.NET and T-SQL stored procedures, develop a web site to administer International guest registration and to edit guest entries.
  • Using ADO.NET, VB.NET, ASP.NET and T-SQL stored procedures, develop a Photo administration web site to upload JPG images, dynamically create thumbnail images, store the full size image on a secure file server and store the thumbnail image in a SQL 2000 database.
  • Using ASP.NET and VB.NET, develop a web page that responds back to the user's browser as if it were a JPG image.
  • Using VB.NET and ASP.NET, develop a Web Service to issue images, located in a secure file server, to users' browsers.
  • Using VB.NET, ADO.NET, ASP.NET and SQL stored procedures, develop a full-text search engine to locate Photos and News Releases by keywords.
  • Using VB.NET and ADO.NET, convert data from old web site Access files to SQL 2000 database.
  • Using C#, develop a multi-level data encryption library to be used in Web and Windows applications to protect sensitive data while being held on the servers.
  • Using VB 6.0, develop a console application for Exchange 2000 to convert web registrations to Outlook Contact entries.
  • Segregate the existing Microsoft IIS 5.0 web site into secure, administration and public uses areas.

AM-METRICSEAL, INC., Stafford, Texas
07/02 - 12/02
Application Architect & Lead Software Developer

Am-MetricSeal, Inc. is a manufacturer of shaft seals for submersible pumps and other equipment with a rotating shaft.  Work with the company President to develop an understanding of his product line and marketing intentions.  Reflect this information into an overall site design concept.  Develop a marketing and E-Commerce web site using C# and SQL 2000.  The ASP.NET web site presents a functional way for customers to select one of the many hundreds of available seal materials and configuration combinations.

CYBER-DYNE, INC., Missouri City, Texas
10/01 - 07/02
Application Architect & Lead Software Developer

Cyber-Dyne, Inc. and E-ComWorks® provide innovative, unique and distinctive Internet solutions and business promotion, including Electronic Commerce.

  • Design and develop commercial Sales Order Completion web site that uses C# and .NET as its software core. This web site uses ADO.NET interface to SQL 2000 while incorporating 256-bit HySecure encryption process for protecting user data stored on the SQL server. This web site also provides direct integrated QuickBooks® qbXML accounting entries to reduce errors and workload.
  • Using C#, interface VeriSign PayFlow Pro payment services to the Sales Order Completion web site to handle personal and business credit cards, debit cards, checks and electronic funds transfer.
  • Using ASP.NET and C#, interface Federal Express ShipManager API to the Sales Order Completion web site to provide online international shipping costs.
  • Using C#, develop the proprietary HySecure encryption process for protecting private information.
  • Design SQL 2000 database and stored procedures for E-ComWorks® office records and its international web site.
  • Install NetScreen firewall between web servers and SQL server.
  • Upgrade operating system and security on Windows 2000 servers.
  • Upgrade to new Microsoft Exchange 2000 server with remote Outlook Web Access (OWA).

MPLANNERS.COM, Houston, Texas
10/00 - 10/01
Lead Software Developer & SQL Administrator

Effectively develop DHTML (ASP) code, COM objects, SQL stored procedures, JavaScript code used in a very complex and involved web site that manages large-scale events and attendee transportation.  Several well-known Fortune 500 companies are currently using this one million dollar ($1,000,000) web site.  The site allows end users to identify their travel dates and routes, select lodging, and sign up for meetings and activities.  The site provides a very robust administration functionality to manage purchasing of airline tickets, booking of hotels, and assigning support staff as well as generating management reports.  Other work includes developing security constraints used on both sides of the web site as well as administration of Microsoft NT based Internet Information and SQL Servers.

PHOTOFRAMES.COM, Houston, Texas
08/00 - 10/00
Software Developer

Successfully develop an XML based three hundred thousand dollar ($300,000) E-Commerce web site that sold picture frames and related products online.  This site transforms SQL XML data into web pages on user demand and fully incorporates the Microsoft DNA architecture on Windows 2000 Advanced Servers.  Work includes creating COM objects and writing SQL stored procedures as well as writing XHTML code.

KARA TECHNOLOGIES, Houston, Texas
06/00 - 08/00
Software Developer

Incorporate the company's core security and stamp printing technology into web sites for several clients.  Develop web sites used by government agencies to allow the public to purchase and print postage or taxation stamps via the Internet.


CYBER-DYNE, INC., Missouri City, Texas
03/99 - 06/00 Full Time   04/97 - 03/99 Part Time
Application Architect & Software Developer

  • Develop HoustonBizPages Web Site, a regional search engine (business and professional listings).
  • Develop a database-driven product selection system with online ordering for a local equipment manufacturer -- Am-MetricSeal.
  • Create flexible, user programmable Guest Book Registration system.
  • Set up and develop simple Web Sites, including domain name registration and Internet Information Services entries for web sites.
  • Establish a web site for Cyber-Dyne, Inc.


FLUOR DANIEL, INC., Sugar Land, Texas
04/89 - 03/99

Project Engineer and Manager

  • Manage sixty-five million dollar ($65,000,000) Control Systems and Information Technology project for the development phase of new petrochemical complex in Venezuela.
  • Manage the three hundred million dollar ($300,000,000) portion of a plant expansion for Yanpet in Saudi Arabia.
  • Manage thirty million dollar ($30,000,000) Information Technology project for the development phase of a new Equate petrochemical complex in Kuwait.
  • Manage several smaller projects for DuPont in Sabine, Texas.

Manager of Engineering

  • Manage the engineering and design staff for a one hundred sixty-five million dollar ($165,000,000) plant modification project for Sun Oil in Philadelphia, Pennsylvania.
  • Very profitably manage the engineering and design staff for a thirty-five million dollar ($35,000,000) lump-sum plant expansion for Valero in Corpus Christi, Texas.
  • Very profitably manage the engineering and design staff for a two hundred and eighty million dollar ($280,000,000) lump-sum plant expansion for Valero in Corpus Christi, Texas.

Senior Control System Engineer

  • Lead Control Systems Engineer on several small projects for Valero in Corpus Christi, Texas.
  • Control Systems Engineer on plant rebuild project for Quantum Chemical in Morris, Illinois.
  • Control Systems Engineer on two projects for Quantum Chemical in La Porte, Texas.

CYBER-DYNE, INC., Missouri City, Texas
03/88 - 04/89
Outside Sales & President

Function as CEO of privately held Delaware Corporation. Sales representative for industrial controllers and VAR (value added reseller) for AT&T, with offices in Baton Rouge, LA and Houston, TX .

POWELL PROCESS SYSTEMS, INC., Houston, Texas
10/85 - 03/88
Manager of Engineering, Project Manager

  • Profitably manage one million dollar ($1,000,000) lump sum SCADA and Distributed Control System (DCS) for new gas pipeline project for Korea.
  • Manage many smaller DCS and SCADA projects for different customers.
  • Lead the development of a new industrial controller as part of company’s Micon DCS equipment.
  • Develop new add-in processor boards for company’s SCADA system and modify the SCADA operating system.
  • Manage embedded controller software developers working on DCS and SCADA equipment.
  • Interface company products to DCS equipment manufactured by Fisher, Bailey and Honeywell.

EDUCATION:

Bachelor of Science Electrical Engineering (BSEE), West Virginia University Institute of Technology
Numerous People Management and Project Management Courses
Graduate studies in Business Administration



Click to download resume in Word RTF format.