Sales Analyst

JEFFREY G CARSON

Willoughby, Ohio

440-***-**** ******.****@*****.***

www.linkedin.com/in/jeffrey-carson

COBOL MAINFRAME SENIOR PROGRAMMER ANALYST

Extensive COBOL and mainframe programming, system analysis, project development and application support experience including IDMS and DB2 databases. Excellent verbal and written communication skills. Known for building relationships with business clients. Demonstrated competencies include:

• Determine Project Requirements • Project Installation

• Project Leadership • System Performance

• Testing and Test Plan Development • Mentoring Colleagues

• System Analysis and Design • System Enhancement

• System Conversion • System Support

TECHNICAL SKILLS INCLUDE: TSO, FileAid, IDMS, DB2, SQL, IBM mainframe z/OS JCL, FTP, COBOL batch programming, ADSO on-line programming, CICS/VSAM, EZTRIEVE and EZTRIEVE Plus, Microsoft Office,

CA7 Scheduling, ENDEVOR change management, Service Now, Visio flowcharting

AMERICAN GREETINGS CORPORATION, Westlake, Ohio 1982 to 2019

Manufacturer and Distributor of Social Expression Products.

Lead Programmer Analyst Application Specialist, Scan Based Trading (SBT) 2010 to 2019

Provided support and development of mainframe pricing, discounting, and invoicing applications with particular emphasis on the company’s scan base trading applications which generate 80% of company revenue.

Made changes to z/OS JCL and procs and modified weekend CA7 schedules to run weekly processes on all application databases concurrently, thereby reducing overall weekend schedule run time in order to deliver reports to financial users by Monday morning.

Set up new retailer partners in the system and made any program changes required to support customer specific requirements including changes required to process retailer EDI 820 remittances.

Interfaced extensively with the corporate EDI, corporate data warehouse, and the corporate SAP financial applications.

Eliminated separate EDI 812 tax invoices for Canadian retailers to reduce invoices generated.

Improved efficiency and run time of monthly and year end fiscal reporting to provide reports earlier to business clients.

Reduced frequency of errors causing EDI 820 retailer remittances to suspend eliminating significant manual correction work.

Developed new programs supporting planned conversion of legacy system to SAP.

Developed new batch upload update of pricing changes to reduce manual effort.

Developed numerous reports and queries to support business user data analysis and problem resolution, including downloading of SBT inventory balances and shipments to data warehouse.

Lead Programmer Analyst, Supply Chain, Order Fulfilment, Returns, Pricing, Invoicing 1995 to 2010

Developed new distribution center functionality to support filling clusters of orders to realize significant order filling cost savings.

Developed legacy system interface to mobile computing device (tablets) application and contributed to design of DB2 database on the mobile platform, resulting in retirement of Telxon scanners.

Developed the mainframe side of a new credit system to recapture all customer discounts on returned merchandise resulting in significant savings on returned merchandise.

Integrated several acquired companies and Canadian subsidiary into corporate distribution and invoice systems, including design and creation of Canada specific invoice format to meet bilingual and tax requirements. This enabled Canadian systems to be retired with significant cost savings.

Developed new system to apply discounts on customer orders, including supplying customer specific pricing to other corporate systems including UPC communication to retailers.

Developed Order Processing and Invoice system changes to eliminate multiple discounts on certain types of product for specific retailers, resulting in more accurate pricing according to retailer contract terms and increased revenue.

Senior Programmer Analyst, Materials Management and Manufacturing 1991 to 1995

Supported Material Management System which generates manufacturing orders based on inventory levels and projected sales. Supported corporate MRP system and finished goods bills of material.

Programmer Analyst, Sales Reporting and Sales Force Compensation 1982 to 1991

Supported the corporate sales reporting systems, including integrating acquired companies into corporate reporting systems and a major rewrite to sales force compensation and bonus programs.

EDUCATION TRAINING

AB, Computer Information Technology, Cuyahoga Community College, Parma OH

BA, Sociology, Baldwin Wallace College, Berea OH

JAVA programming 1 and 2, Lakeland Community College, Mentor OH

Contact this candidate