Management Programmer Analyst

William Kuehn

** ********* ***. ******* ** *****

Home: 203-***-**** - Cell: 203-***-**** - *******@*****.***

Career Overview

Seasoned programmer analyst with more than 20 years of experience in fast-paced development environments. Excellent problem solving and design skills. Track record of achieving exceptional results in system development and user satisfaction.

Qualifications

Complex Problem Solving

Systems Analysis

Troubleshooting

Active Learning

Programming

Designing

Judgment and Decision Making

Strong Communicator

Skills

Data Base: MySQL, Oracle, SQL Server, Sybase, IMS, DB2

Software: HTML, CSS, jQuery, JavaScript, PHP, PL/SQL, T-SQL, Visual Basic, Powerbuilder,

COBOL, CICS, RPG, CCP, Nomad, Java, J Builder, SAS, Source Safe, GitHub,

XML, XLS, HTTP, FTP

ELT Tools: PL/SQL, T-SQL

Hardware: Main frames, desktops

Web Server: Apache

Web Frame Works: Bootstrap, Wrapbootstrap, Bootbox

Operating Systems: Windows, UNIX, MS/DOS, MVS, VM/CMS, Linix

Accomplishments

Completed projects on time for fortune 500 and 1000 companies. The client list includes: Brooklyn Union Gas, Dun & Bradstreet, Glencore, Pfizer, PHH, Time

Work Experience

Web Developer

Trupro - Trumbull, CT March 2016 to present

Involved in the development of a marketing and business automation cloud platform.

Provided logical and physical data base design for the MySQL data base, Developed middle tier programs using PPH, Developed/enhanced front end panels using HTML, CSS JavaScript, jQuery and AJAX for managing contacts, connections and maintaining the relationships between them.

Developed wrapbootsrap sites for the business solution section.,

Programmer Analyst

Glencore Stamford, CT August 1998 to December 2015

Provided logical and physical database design in support of the Common Trading and Traffic, Cash Management and Grain Forecasting Systems

Created multiple user interfaces using Powerbuilder, PL/SQL, T-SQL stored procedures, functions, triggers in support of the production systems

Developed the Lot Inventory application used to enter location of material, quantity, assay information and maintain balances

Developed data mining techniques to determine where the best location of material to ship based on quantity, quality and location

Developed the Shipment Entry application which tracked the movement of material, quantity shipped and received and bill of lading information, provided reports to determine which shipments were missing key data, not invoiced or under invoiced

Extracted, transformed and transmitted shipment information to warehouses using HTTPS, Oracle and XML

Developed the Shipment Import application using Java, PL/SQL and XML, Provided data cleansing of shipment data before it was loaded into the production system

Developed an EXCEL to XML converter of shipment data using JavaScript, FTP, PL/SQL and XML.

Developed the Auto Invoicing application which would allow the creation of provisional, final and the finalization of provisional invoices based on user input and shipment data

Developed the Grain Forecasting application which imported and displayed grain information based on country, region, year and crop, provided tools for the cleansing of the data

Modified the Cash Management system for the collecting of payments and receipts, deal creation, unraveling payments and audit functionality

Extracted, transformed and loaded into the Cash Management system payment and receipt information from source systems in Oracle, Sybase and SQL Server using PL/SQL, T-SQL and SOAP

Created the Cash Cube used by Finance to determine cash requirements

Extracted and transformed payment information from the Cash Management system and transmitted it to banks

Extracted and transformed payment confirmations from banks and loaded them into the Cash Management system

Business Analyst, Programmer Analyst, Sybase and SQL Server Database Administrator, Quality Assurance

Various Companies June 1979 to August 1998

Aonix

Quality Assurance

Tested and debugged a database extract and reporting tool

Brooklyn Union Gas

Sybase Database Administrator, Business Analyst, Programmer Analyst

Provided logical and physical design of the database used for advertising analysis

Developed the specifications for the Advertising Analysis application

Dun & Bradstreet

SQL Server Database Administrator, Programmer Analys

Provided logical and physical design of the databases for applications in development

Developed a Management Incentive application that was used to set goals,

track meeting the goals and calculate bonus

National CSS

Programmer Analyst

Developed a budget reporting application that was used to determine profitable

sale territories and phone stores

Pfizer

Programmer Analyst

Market Research

Developed reports to track Doctors and the pharmaceuticals http://www.merriam-webster.com/dictionary/pharmaceuticals they prescribed

Clinical Research

Developed a data mining application that showed the effects of pharmaceuticals that

were out of the normal range

PHH

Sybase Database Administrator, Programmer Analyst

Provided logical and physical design of the database used to develop an online

real estate application

Time

Programmer Analyst

Developed an business intelligence application that allow management to drill down

through advertising sale information

Application was expanded to determine supply and demand of paper usage

Xerox

Programmer Analyst

Developed an application that would help in tax planning for US citizens working over

seas

Education and Training

Bachelor of Science: Management, 1979 Central Connecticut State College New Britain, CT

U.S Army 82 Airborne Division, 1975 Paratrooper

Contact this candidate