Client Support Sql Server

David Weicker

Summary:

Results oriented I.T. Professional with extensive experience in developing new systems and maintaining existing systems in diverse business areas. Highly effective in client support, a proven track record in determining needs, recommending and implementing efficient solutions. Provides logical, detailed, and thorough analysis leading to rapid problem solving. Strong oral and written communication skills, excellent interpersonal skills, demonstrated ability to relate to all levels of technical and non-technical users and colleagues.

Technical Skills:

Mainframe: OS/MVS, TSO/ISPF, JCL, Panvalet, Endevor, XPEDITER, Abend-Aid, QMF, Spufi, File-Aid, File-Aid for DB2, File-Manager, Query Analyzer, CLIST, FTP, MQ, ChangeMan

Languages: COBOL, CICS, SQL, Easytrieve, Visual Basic, HTML, Perl Script

Database Structures: DB2, IDMS, VSAM, SQL Server

Software Tools: MS Excel, MS Word, Microsoft Office, Adobe Photoshop, Lotus Notes, Outlook

Operating Systems: Windows XP, Windows NT, Mac OS X

Professional Experience:

Northern Trust (Chicago, IL) Aug 2020 – Jan 2025

Mainframe Programmer – Dexian (Formerly Signature Consultants)

Created process to convert +300 JCL/Procs/Control cards to retrieve FTP UserIds and Passwords from an Offsite Electronic Password Vault (EPV). Worked with vendors for first successful Mainframe EPV usage at Northern Trust.

Converted communication with Equilend for Price Updates from MQ to SFTP.

Added Finance Fee process to the Loan update process

Modified Loan Settlement process to use Realtime updates via MQ

Technologies/skills utilized include Cobol, DB2, JCL, MQ, CICS, IDZ/GitHub, SCLM.

USG Corporation (Chicago, IL) 2012-2020

Mainframe Contractor – HiTech Solutions (Mokena, Illinois)

Consulted with clients to determine needs. Contributed to many and varied projects.

Was part of a team responsible for designing, coding, and testing changes to order processing, pricing, and invoicing systems.

These changes were designed to replace legacy CICS/DB2-based applications with an Oracle EBS - based system.

Some existing mainframe functions were retired, and online calls to pricing modules were replaced with CICS web service calls, to obtain pricing data from Oracle.

These enhancements were developed on an IBM mainframe using IBM Enterprise COBOL for z/OS, DB2, MVS, CICS, BMS maps, Unix System Services, VSAM, XML, Macro 4 InSync, Panvalet, and IBM Debug.

Created SQL queries and provided documentation of this system’s functionality for users.

Handled day and night support for various issues reported via CompuCom help desk portal.

Supported technical needs for business clients for USG Order systems. Performed functions in CICS, Cobol, DB2, JCL, SQL. Wrote many stand-alone SQL queries for analyzing problems.

Sears Holdings Corp (Hoffman Estates, IL) 2008-2012

Systems Engineer

Consulted with clients to determine needs. Contributed to many and varied projects.

Assigned to role in creating new customer pickup store (MyGofer). Built program specifications and contributed to system testing.

Contributed, in may roles, to new Purchase Order Management system

Have created both batch-based and CICS-based programs utilizing MQ. Started project with no pre-knowledge of MQ, but gained extensive knowledge so as to be considered a Subject Matter Expert within my group.

Supported technical needs for business clients for Sears/Kmart Receiving systems. Performed functions in CICS, Cobol, DB2, JCL, SQL, QMF. Wrote many stand-alone SQL queries for analyzing problems.

Worked on project to convert program repository system from ChangeMan to Endeavor.

Eddie Bauer (Formerly Spiegel Group - Westmont, IL) 1984-2008

Technical Specialist (1996-2008)

Consulted with clients to determine needs, served as Subject Matter Expert in many areas. Extensive design work, coding and analysis. Contributed to many and varied projects.

Served as Technical Lead in revisions of financial code to Amazon.Com / Eddie Bauer interface to meet Amazon.com requirements. Modified billing calculation using DB2 database and created FTP processes. Created new COBOL programs that executed SQL code. Built new JCL job streams. All modifications done in a TSO/ISPF environment.

Assigned to expedite implementation of expanded Retail Sales Trends Analysis. Built SQL queries and Excel reports against 600 million row Sales History DB2 database.

Co-designed administration tables in Returns Reporting System redesign. Wrote stand-alone Visual Basic application for Created Excel reports.

Enhanced CICS and Batch Retail Allocation systems. Ensured functionality of automated store inventory replenishment system.

Played key role in Merchandise inventory systems realignment affecting all merchandise subsystems. Used COBOL, UNIX, and MMSO (Merchandise Tracking package). Started project with no pre-knowledge of various systems, but gained extensive knowledge so as to be considered a Subject Matter Expert.

Supported technical needs and served as technical Subject Matter Expert of business clients including Merchandising, Order Processing, Finance, Warehouse Inventory, Liquidation, and Retail POS. Performed functions in CICS, Cobol, DB2, JCL, SQL, QMF. Wrote many stand-alone SQL queries for analyzing problems.

Senior Programmer Analyst (1988-1996)

Worked independently, designed solutions based on clients’ requests, performed a combination of coding and analysis functions.

Created and supported Merchandise Liquidation system. Developed DB2 tables and new CICS screens. Recognized with Employee of the Month award for implementation.

Developed Catalog Sales History in support of new Warehouse and Order Processing systems.

Programmer Analyst (1984-1989)

Performed coding functions with some analysis.

Supported and developed Corporate Name and Address database using IDMS and CICS.

Education:

Illinois State University (Normal, Illinois)

Bachelor of Science, Applied Computer Science

Contact this candidate