Database Analyst, Project Leader

EDWARD L. KOSTRZEWA

**** **** **** *****

Jacksonville, FL 32244

Home 860-***-****

E-Mail: ******.*********@*****.***

EXPERIENCE

Goodwill Industries of North Florida AUG 2018 to Present

Jacksonville, FL

E-Commerce ITech Department

E-Commerce Media Team Lead

Ran GOODFLIX media department and managed 3 part time employees.

Scanned and listed DVD/CD’s for sale on SHOPIFY, GOODFLIX and eBay websites.

Maintained inventory and fulfilled customer orders.

Reported sales utilizing Excel spreadsheets.

AMAZON Fulfillment MAR 2018-AUG 2018

Jacksonville, FL

Amazon Fulfillment Associates

Warehouse Stower/Inbound Stow

Stowed items in robot pods to be used for customer orders.

Goodwill Industries of North Florida JAN 2018-MAR 2018

Jacksonville, FL

E-Commerce Department

E-Commerce Lister

Listed donations on website and built advertisements for auctions.

Macy’s

Cheshire, CT

Logistics and Fulfillment Center

Warehouse Associate(Seasonal) SEP 2015-JAN 2016

Replenished inventory in warehouse.

Operated and certified to operate high lift fork lift.

Utilized scan gun to log inventory in warehouse locations.

Mighty Auto Parts

New Britain, CT

Warehouse and Delivery

Warehouse and Delivery Driver Associate APR 2015-JUN 2015

Inventoried and entered customer orders for automotive parts at independent auto repair facilities.

Stocked and delivered auto parts at customer locations.

Received shipments and operated fork lift to unload and store inventory.

· Collected payments from customers.

Edward L. Kostrzewa Page 2

SEARS in Home Services

Rocky Hill, CT

Sales Associate

In Home Sales Associate FEB 2015-APR 2015

Entered customer orders for kitchen remodeling, refacing cabinets and countertops.

Visited customers at their homes and gave product, installation and warranty demonstrations.

· Estimated prices based on square footage and linear feet.

Used computer to enter orders and quote prices.

SLEEPY’s

Newington, CT

Mattress Professional

Sales Associate SEP 2014-JAN 2015

Entered customer orders and maintained showroom.

· Recorded days register count and made nightly deposits of cash.

Sales tagged merchandise .

Took inventory counts of merchandise and verified/reported discrepancies.

SEARS Parts and Service

Newington, CT

Sales Associate

Sales and Service Associate FEB 2014-SEP 2014

Entered customer orders for household appliances and power equipment repair.

· Assisted customers with do it yourself parts lookup and general repair questions and concerns.

Sales tagged merchandise for sales and clearance.

Maintained warehouse cleanliness and stock inventory.

SEARS

West Hartford, CT

Stock Room

Backroom Associate NOV 2013-FEB 2014

Unloaded semi-trailers of consumer goods.

· Unloaded and unboxed consumer goods for sales floor stock replenishment..

Operated carton baling machine.

Stocked and security tagged products for sale.

State Farm Insurance Company

Bloomington, IL

Data Services

Data Specialist / Data Services APR 2008-JUN 2012

Implemented mainframe OS/390 Z/OS production DB2 databases for Property and Casualty Systems. Resulted in increased performance efficiency thru DB2 Data Propagation methods for online/batch systems.

· Utilized TRIGGER’s to automate data replication across DB2 subsystems.

Implemented Global Temporary Tables and assisted the test centers in environment setup and RUNSTATS automation.

· Supported Systems Analysts with DB2 database structures and user testing environments.

· Maintained logical and physical database designs in EMBARCADERO ER/Studio data repository.

· Utilized IBM SEQUENCE numbers to allow state to state data transfers across DB2 subsystems.

Edward L. Kostrzewa Page 3

Winn Dixie Corporate Headquarters / ETTAIN Group

Jacksonville, FL

Information Systems

Consultant Database Analyst / Data Services JUL 2007-OCT 2007

Maintained mainframe OS/390 Z/OS production DB2 databases and tested PEOPLESOFT version upgrades with line of businesses. Resulted in increased performance efficiency for online/batch systems.

· Tuned SQL for PEOPLESOFT application areas during version upgrade testing.

· Supported Application Programmer Analysts with DB2 database structures/versions.

· Utilized IBM’s VISUAL EXPLAIN, QUERY MONITOR and SQL ANALYZER software to tune SQL.

· Assisted DBA’s with IBM’s DB2 ADMINISTRATION and AUTOMATION Tools for Z/OS.

CIGNA

Windsor, CT

Information Management Technologies & Services

Senior Database Administrator / CIGNA Systems 2000-2007

Maintained mainframe OS/390 Z/OS production DB2 databases and coordinated changes with line of business DB2 database analysts. Resulted in decreased run times, I/O and DASD utilization and increased performance efficiency for online/batch systems.

· Monitored tablespaces and indexes to ensure that applications operate at peak efficiency.

· Audited test systems to ensure production problems did not exist upon implementation.

· Supported Application Programmer Analysts with DB2 databases, testing and debugging.

· Assisted Project Teams with BIND procedures including DRDA protocol on DB2 cross subsystem

Applications.

· Worked with CIGNA's DB2 Products Group/MVS/ESM/IBM with analysis, testing, problem

reporting and resolution during DB2 Version upgrades.

· Represented the DBA Area in the implementation of CLOB data, testing and procedures for DB2 utility

maintenance.

· Responsible for maintaining CIGNA's Information Management DATAMART Warehouse storing over

14 terabytes of data.

Coordinated, developed standards and procedures and tested IBM DB2 Automation Tool for Z/OS.

CIGNA / THE ALLIANCE OF CONSULTING SERVICES INC.

Hartford, CT

Retirement & Investment Services

Consultant Database Analyst / Client Solutions 1998-1999

Maintained mainframe OS/390 DB2 test systems and coordinated changes with production DB2 database analysts.

Resulted in decreased run times, I/O and DASD utilization which increased performance efficiency for online/batch systems.

· Evaluated performance and created/altered indexes to improve access path strategy and eliminate

tablespace scans.

· Supported Systems/Programmer Analysts with database design, testing and debugging.

Consultant / Defined Benefits Systems Support

Supported mainframe production environment and changes to Benefits Administration and Customer Services Chargeback Systems. Resulted in minimal down time for online/batch systems.

· Enhanced CICS, DB2 and IMS programs to user specifications, tested and implemented into

production.

· Setup SQL queries and utilities for DB2 data analysis, updated DB2 table data in test environments

and worked with clients to ensure a smooth transition into production environment.

Edward L. Kostrzewa Page 4

Consultant / Benefits Administration Services 1998-1998

Remediated pension batch processing system for Year 2000. Resulted in no interruption to processing of data and reports on holidays, leap years and millenium run dates.

· Reviewed current date routines and added century.

· Setup VSAM files, IMS databases and test environments.

· Adjudicated batch jobs and resolved problems.

· Compared results to production jobs and explained all discrepancies for auditors.

BLUE CROSS & BLUE SHIELD OF CONNECTICUT

North Haven, CT

Information Services Group

Database Analyst / Database Tech Services 1993-1998

Responsible for IMS/DB2 databases including:

Automated REORG’s, DASD space management, compression, image copy/backup, DBD/PSB/ACB GENS, DB2 data definition language, plan/package and security creation and maintenance, performance monitoring, SQL explains and data integrity.

Applications Technical Support / Claims Processing

Assisted application programmers/consultants and database administrators with IMS/DB2 test environment setup, program debugging tools, DB2/SQL performance and IMS/DB2 database creation and maintenance.

Designed online debugging tools to assist programmers with abends, DB2 utility generation.

Designed automated production to test ENDEVOR-based turnover system.

Assisted ENDEVOR administrator with testing and procedures as they relate to application

test environments. Resulted in efficient troubleshooting and decreased downtime.

PITNEY BOWES WORLD HEADQUARTERS / HOWARD SYSTEMS INTERNATIONAL INC.

Stamford, CT

Management Information Systems

Consultant, Inventory Accounting/General Ledger 1991-1993

Converted financial subsystem which produces feeds to general ledger from Sperry-Unisys to IBM mainframe environment. Resulted in reduced CPU execution time and improved program processing logic.

Trained five-programmer task force in conversion and testing.

Converted 20 driver programs for transaction editing, error and suspense reporting.

Eliminated mainframe, service lease, and support personnel costs.

Consultant, Inventory Control and Management

Assisted project analyst to design and implement an IMS/MFS on-line shipping and receiving system

which tracked shipping, location, and physical storage of bulk mail processing machines. Resulted in

a real-time status of equipment availability and movement.

Wrote specifications for, programmed, and tested system.

Provided technical assistance and processing assistance to support staff.

CONNECTICUT NATIONAL BANK / COMPUTER HORIZONS CORPORATION

Hartford, CT

Information Services Division

Consultant, Investment Services Support 1990-1991

Designed and programmed a financial portfolio monthly statement utilizing IBM Advanced Function Printing Software. Resulted in a professional document similar to brokerage house-produced documents.

Assisted user liaison in defining requirements, file origins and portfolio layout.

Worked with software department to define programming and software requirements.

Edward L. Kostrzewa Page 5

SIKORSKY AIRCRAFT / COMPUTER HORIZONS CORPORATION

Stratford, CT

Information Management Division

Consultant, Applications Support 1989-1990

Worked with IBM consulting services on the conversion of an in-house PSEUDO-IMS to an IMS/MFS system. System tracked wire data used in the manufacturing of wiring harnesses for helicopter instrumentation. Resulted in reduced transaction processing and CPU resources.

Wrote online, BMP and batch programs to conform to user specifications.

Tested and debugged program-to-program transfer and overall system integrity.

Upgraded online Navy procurement contract system used for spare parts ordering and account tracking.

Modified online programs/screens to add/remove data fields.

PRATT & WHITNEY AIRCRAFT

East Hartford, CT

Manufacturing and Information Systems

Project Analyst, CAD/CAM Applications Support 1987-1988 Represented 100-member programming support group to assess the effects of manufacturing

process changes upon Information Systems support. Resulted in improved communication,

project completion time, and reduced computer down time.

Time Share Option (TSO) Committee: analyzed existing and new programming tools.

Project Analyst, Processing Planning Support 1986-1987

Designed and implemented the merging of separate text and graphic systems to produce a

laser-printed manufacturing process plan. Resulted in eliminating manual cut-and-paste approach,

provided master plan for easier editing or copying and reduced regenerative costs by 50% per page.

Tested software on IBM 3800-MOD 3 laser printer.

Converted in-house graphical format to IBM printable format: wrote specifications for,

programmed, and tested Graphical Data Display Manager (GDDM).

Wrote programs to format text into document: merged graphics with text output and created electronic overlay frames for text.

Senior Systems Programmer Analyst, Process Planning;

Manufacturing / Materials Support 1982-1986

Implemented and revised a purchased process planning system. Resulted in more efficient storage,

retrieval, and editing of process plan data.

Analyzed user requirements for vendor specifications.

Coordinated software support with system requirements.

Programmed and implemented an online manufacturing specification description system.

Resulted in decreased overall lead times in the manufacturing and tracking of aircraft parts.

Programmer Analyst, Manufacturing Support 1979-1982

Maintained Information Management System (IMS) for production information control part

tracking. Adjusted schedule for work in process. Resulted in reduced time to identify and locate

parts. Maintained system of daily clockings based upon worker productivity. Resulted in improved

tracking of discrepancies in shop performance.

Edward L. Kostrzewa Page 6

SPECIALIZED SKILLS

Proficient: BMC Tool Suites including: CATALOG, CHANGE, COMPARE, RECOVERY, DASD Manager, Hi-Speed Apply, MAINVIEW, APPTUNE, IBM DB2 Automation Tool for Z/OS, IBM DB2 Administration Tool, IBM Optimization Service Center/OPTIM Query Tuner, FILE-AID for DB2,

TSO/ISPF, REXX, COBOL Programming, IMS DB/DC, MFS, OS/Pattern JCL, IBM Advanced Function Printing (AFP), XPEDITER, SMARTEST, BTS, DB2 EXPLAIN, SPUFI, QMF, IMS XPERT, PLATINUM, CANDLE, OMEGAMON, TMON, PRINCETON MOVE/ACCESS, ENDEVOR/PANVALET.

Trained: DB2/IMS DATABASE ADMINISTRATION, DESIGN AND PROGRAMMING.

Experienced: Group Technology, Work Flow Analysis, Artificial Intelligence, Investment

Portfolio, Inventory Control, Financial Systems, Health Claims Processing,

Retirement, Investment and Benefit Systems, Policy and Claim Processing.

EDUCATION

B.S., Mechanical Technology, University of Connecticut, Storrs, CT 1979

A.S., Mechanical Technology, Hartford State Technical College, Hartford, CT 1977

Contact this candidate