David Sacker
14712 S. Fern PlaceGlenpool, OK 74033
Phone: 918-261-8583
Email:
Updated:May 2016 /
Summary
Performance driven senior software developer, seasoned DB admin, ERP/ETL specialist, and project manager, with 35 years of industry experience. Strong track record of conceptualizing, implementing and managing short/long-term projects. Seasoned experience in analyzing, designing, developing, testing, implementing and managing Web, Windows, Unix and Mainframe applications. Strong background with most databases. Current with most technologies. Adaptable, knowledgeable, pro-active, loyal and faithful; both a leader and team player who lives by the rule of integrity.Experience at a Glance
Web / HTML / .NET / C#VB.NET / JavaScript / VBScript
ASP / ASP.NET / PHP / IIS
AJAX / Infragistics / CSS
ADO / ADO.NET / Web Tools (CMS, etc) / Datagrids
ERP / Syteline 8/9 / SAP R3
Development Tools
/ Visual Studio / Visual Studio Team System / Business ObjectsCrystal Reports / SSRS / DB Modeling Tools
SAP / R3 / Business Warehouse
Databases / DBA
/ Oracle / SQL Server / MySQLMS Access / SSIS/DTS / Enterprise Managers
SSAS/ETL
Languages
/ VB.Net / C#.Net / ASP.NetT-SQL / PL/SQL / SQL*Plus
Powershell / DOS BAT / WSH / VBScript
FTP Scripting / Rexx / C/C++
JCL / COBOL / ISPF / CLIST
ROSCOE / RPF / RAMIS / SYSTEM W
UNISYS ECL / VMS Scripting / Assembler
Software
/ MS Excel / VBA / MS Word / VBA / MS Outlook / VBAMS Project / Enterprise Managers / Query Tools
ODBC / TCP/IP / FTP
Apache / Weblogic / LDAP
IIS / Lotus Suite / Schedulers
Project Management
/ MS Project / Sharepoint / MS OfficeCommunication Skills / Writing Skills / Team Skills
Operating Systems
/ Unix / Windows / VAX/VMSIBM/MVS / DOS / Unisys
TI-990 / OS/2
Professional Experience
CONTRACT CONSULTANT –Navico, Inc. – 2010 to present
Syteline ERP 8 administration and development, using ERP tools and Visual Studio. DBA support for SQL Server
Accomplishments
●Developed numerous forms and reports.
●Integrated Syteline with invoicing and scanning product called Palette.
●Resolved many issues with add-on products.
CONTRACT CONSULTANT –Cimarex, Inc. – May 2015 to December 2015
Syteline ERP 8 administration and development, using ERP tools and Visual Studio. DBA support for SQL Server
Accomplishments
●Developed numerous Syteline ERP forms, scripts and IDOs.
●Stabilized Syteline 9 installation and infrastructure.
●Provided administrative help and training.
CONTRACT ADMIN/DEVELOPER – Sulzer Chemtech USA, Inc. – October 2008 to February 2016
Syteline ERP 8 administration and development, using ERP tools and Visual Studio. DBA support for SQL Server
Accomplishments
●Developed numerous Syteline ERP forms, scripts and IDOs.
●Developed numerous Syteline interfaces.
●Developed numerous windows applications using Visual Studio and VB.NET, with click-once deployment.
●Developed applications for Windows Mobile.
●Developed scanner application for Syteline ERP.
●Developed numerous reports using SSRS and Crystal Reports.
●Developed “live” reporting using data grid and Excel object programming.
●Set up multi-site replication.
●Set up Data Communications within SL8.
●Installed, administered, configured and tuned SQL Server databases (2005, 2008 R2) for Syteline.
●Installed, administered, configured and tuned Syteline utility servers.
●Set up users, installed licenses, set up sites, intranets, background task processing, etc.
●Migrated Syteline versions from version 6 to 8.0.
●Upgraded Syteline versions to 8.01, 8.02, 8.03 and 9 (current project).
CONTRACT DEVELOPER – Department of Veterans Affairs, Oklahoma City – April 2007 to October 2008
Web application development using .NET with Visual Studio, VSTS, C#, Reporting Services, SQL Server.
Accomplishments
●Developed various web applications with Visual Studio .NET Suite, C#, AJAX, Infragistics, JavaScript and CSS.
●Built JavaScript client-side processing in .NET apps.
●Built CSS stylesheets.
●Administered test databases using SQL Server.
●Developed various reports and reporting applications using Reporting Services.
CONTRACT SQL SERVER DEVELOPER – Pyramid Communications, Tulsa – April 2008 to June 2008
SQL Server upgrade, ASP application upgrade, DB & IIS administration.
Accomplishments
●Upgraded PreSales database in SQL Server.
●Upgraded PreSales functionality using HTML, ASP, VBScript, JavaScript and CSS (style sheets).
●Added AJAX technology to PreSales tool.
CONTRACT DEVELOPER – ConocoPhillips, Bartlesville – April 2005 to April 2007
Crystal Reports and Crystal Enterprise development and administration, Oracle fine-tuning and Web development.
Accomplishments
●Created Business Objects Designer Universes for SAP R3 databases directly against Oracle tables, namely BSEG, MSEG, GLPCA, COPA and ASSET.
●Developed Business Warehouse web applications from SAP/R3 systems.
●Developed Business Warehouse queries from SAP/R3 systems.
●Developed ASP web pages accessing Oracle.
●Developed various JavasSript solutions for web navigation needs.
●Developed views and queries for Oracle databases.
●Developed and administered Business Objects solutions.
●Developed and administered Crystal Enterprise solutions for web report deployment.
●Developed numerous reports using Crystal Reports.
CONTRACT SQL SERVER DEVELOPER – Pyramid Communications, Tulsa – January 2005 to April 2005
SQL Server database administration, design and development; web application development.
Accomplishments
●Developed PreSales database in SQL Server.
●Prototyped PreSales web application using Dreamweaver.
●Developed PreSales functionality using HTML, ASP, VBScript, JavaScript and CSS (style sheets).
●Developed ASP and VBScript subroutines to connect to database.
●Developed Javascript subroutines for calculation modules and web processing tasks.
●Developed CSS (style sheets) to standardize all front-end presentations.
●Developed VBScripts to interface, massage and load Excel data into SQL Server.
●Installed and administrated Crystal Reports 10.
●Installed and administrated Crystal Web Viewer.
●Developed reports in Crystal Reports.
●Developed triggers in SQL Server.
●Developed BCP load utilities for SQL Server.
●Developed DTS packages in SQL Server.
●Developed Job Scheduling packages in SQL Server.
●Set up job scheduling, alerts, email notification and DTS packages on SQL Server Enterprise Manager.
●Developed mirror SQL Server databases using Microsoft Access.
●Developed VBA processing for Microsoft Access.
CONTRACT ORACLE DBA – Devon Oil, Oklahoma City – September 2004 to January 2005
DBA tasks and responsibilities for Oracle 7.3.4, 8.1.7, 9.0.1, 9.2.0 and 10.1.0 databases.
Accomplishments
●Tuned data warehouses (star and snowflake schemas, temp and permanent tablespaces, partitioning, etc).
●Performed related tasks and maintenance with usernames, roles and privileges.
●Tailored seed databases for datamarts, history databases, and datastores.
●Performed related tasks with SNMP, LDAP (OID), Intelligence Agent, Audit parameters.
●Monitored daily stats on several production databases.
●Tuned several databases (db_writer_processes, tablespace increases, etc).
●Created ASP Web pages to publish database components, (servers, versions, etc).
●Turned on and monitored auditing functions in Oracle databases for SOX audit requirements.
CONTRACT PROGRAMMER – Alliance Data Systems, Tulsa OK - 1998 to August 2004
Responsible for Oracle Warehousing interfaces, extracts, conversions and ERP components.
Responsible for Oracle database and application solutions on Unix (Solaris) and Windows platforms.
Responsible for web application development using ASP and Perl.
Responsible for Visual Basic and MS Office/VBA applications.
Responsible for Business Office query applications.
Maintained Powerbuilder applications and IBM mainframe programs as needed.
Accomplishments
●Developed Oracle Stored Procedures.
●Developed Oracle SQLPlus scripts.
●Developed extensive UNIX scripts for Oracle ERP processing.
●Developed ERP Data Warehousing ERP components for Marketing
●Developed MS Excel/Word/VBA applications and querying solutions using Oracle and Stored Procedures.
●Developed VB applications using Oracle.
●Developed Web pages using HTML, Java, Perl, Oracle, SQL, ASP, on both IIS and Apache servers.
●Developed applications using MS Access/VBA.
●Developed and automated SQL reports using Business Objects and Crystal Reports.
●Developed Registration and Transmission applications using Visual Basic, SQL Server and FTP interfaces.
●Developed Billing Reconciliation web pages using Visual InterDev (HTML) and ASP with SQL Server.
●Developed User Administration web pages using Visual InterDev (HTML) and ASP with SQL Server.
●Developed T-SQL batch SQL streams using SQL Server's Enterprise Manager, Query Analyzer and Job Agent.
●Converted a Market Segmentation application from PowerBuilder/DB2 to Visual Basic/SQL Server.
●Developed applications using Powerbuilder and SQL Server scripting against SQL Server and Oracle databases.
●Developed DB2 and Oracle interfacing, FTP processing and COBOL/IDMS extractions.
●Performed Y2K compliance conversions on both client and mainframe platforms.
●Supported various existing Visual Basic/Visual InterDev/SQLServer applications.
●Supported various PowerBuilder/DB2 applications.
●Supported various COBOL/IDMS/DB2 programs.
●Managed project tracking using MS Project.
CONTRACT PROGRAMMER - Oklahoma Natural Gas, Tulsa OK - 1997 to 1998
Responsible to develop and maintain IBM mainframe programs as needed.
Accomplishments
●Developed several small CICS online programs on IBM mainframe using COBOL, DLI, and TSO.
●Developed several JCL batch programs on IBM mainframe using COBOL, CICS, DLI, DB2, and TSO.
●Developed COBOL database programs using IMS.
CONTRACT PROGRAMMER - International Paper, Memphis TN - 1997
Responsible to develop and maintain IBM mainframe programs as needed. Perform Y2K conversions as needed.
Accomplishments
●Performed various Y2K application conversions using CICS, COBOL, DB2, IDMS, JCL and TSO.
●Developed COBOL database programs using IMS.
●Managed project tracking using MS Project.
PROJECT LEADER - Hertz Data Center, Oklahoma City OK - 1985 to 1997
Responsible for new software development and administration. Managed several development and enhancement projects. Developed several applications, database queries and ad hoc solutions as needed. Maintained existing applications and programs as needed.
Accomplishments
●Designed and coded part of Global Accounts Receivables application using Power Builder for PC presentation and PC-CICS on a Windows NT server linked to CICS/MVS using CICS COBOL for validation with DB2 as the repository.
●Developed a TI-990 image parser to read and convert TI-990 backup tapes into their sequential files using C on HPUX.
●Set up an Oracle interface for Accounts Receivables using PL/SQL, SQL Plus and Developer 2000 Forms.
●Set up Unix interfaces to the IBM mainframe, HP MPE systems and PC's using TCP/IP and LAN utilities.
●Managed the conversion of Accounts Receivables for several European countries from a TI-990 COBOL environment onto Unix using Microfocus COBOL, AwareSystems COBOL, random-access files, Oracle and MS Project.
●Installed and administered the LAN version of Excelerator Case Modeler For OS/2.
●Set up OS/2 FTP and TELNET applications.
●Developed various interfaces from IBM mainframe to PC products (Lotus, System W, Excel) using DOS ".bat" files, PASCAL and Paradox.
●Designed, coded and implemented a Global Front End management subsystem using CICS and DB2.
●Converted several DEC applications onto IBM mainframe using IDMS, DB2 and CICS.
●Designed, coded and implemented a Rental Agreement entry subsystem on a DEC VAX using UserBase.
●Designed, coded, implemented and trained personnel for a Bank Reconciliation application using APS for MVS, CICS and DB2.
●Designed, coded, implemented and trained personnel for a Tax Reconciliation application using IMS/DC and DB2.
●Coded various ISPF interfaces for APS using ISPF panels, COBOL and DB2.
●Installed and administered APS (source code generator) on IBM mainframe and PC server.
●Designed several inquiry reports using JCL, EZYTRIEVE, QMF for various IDMS and DB2 databases, sequential files and VSAM.
●Converted several Dunn & Bradstreet budget and planning systems onto SYSTEM W.
●Designed, coded, implemented and trained personnel for a Commercial Billing Special Account application using RAMIS.
●Developed multiple system utilities in ROSCOE using RPF’s.
●Designed, coded and implemented a Property & Concessions application using IDMS/DC and ADSO.
●Maintained various applications on Unisys mainframes.
●Converted Central Billing Application from Univac to IBM.
●Converted a Daily Receipt of Business application from Unisys to IBM mainframe using IDMS/DC, ADSO, JCL and EZYTRIEVE.
●Maintained Daily Receipt of Business application on a Univac 1100 using COBOL and random files.
SENIOR SYSTEMS PROCESSOR - Liberty National Bank, Oklahoma City OK - 1982 to 1985
Responsible for system processing and reports production for the Trust Department.
Accomplishments
●Wrote various DEC VAX/VMS applications and programs using COBOL, MUMPS and Assembler.
●Migrated all existing applications from PDP-11 to DEC VAX.
●Performed backups on DEC PDP-11.
●Performed backups on VAX/VMS.
●Performed upgrades, applied patches and system administered PDP-11 and VAX systems.
●Developed system utilities using MUMPS.
Education
1975 - Graduated from Crowley High School, Crowley, LA.
1975 - Attended the University of Southern Louisiana, Lafayette, LA.
1978 - Graduated from Jackson College of Ministries, Jackson MS. Degree in Theology.
1979 - Attended Northwestern State University, Natchitoches, LA.
1984 - Graduated from Southern Nazarene University, Bethany, OK. B.A. in Theology.
1985 - Attended Oklahoma City Community College, Oklahoma City, OK. COBOL Assembler.
Awards / Achievements
1976 - Dean's List, Jackson College of Ministries.
1976 - President's List, Jackson College of Ministries.
1977 - College Student Body VP, Jackson College of Ministries.
1984 - Employee of the Year, Liberty National Bank.
References
Available upon request.