Sql Developer

Robert L. Williams

**** ******* *** [pic] St Louis, MO 63108 [pic] 847-***-**** [pic]

*****************@*****.*** http://www.linkedin.com/in/robertxwilliams

Synopsis of Candidate

. Strong natural analytical & problem solving ability.

. Experienced in all phases of SDLC, developing unit / system test plans

and documenting test results.

. Technical resource for the team. Helps others to resolve problems /

issues.

. Very innovative. Developing new methods such as using SQL report writer

to output an XML spreadsheet

Technical Skills

. Systems Analysis using SDLC - 20 years

. Level 3 production support - 18 years

. SQL reporting / application development - 20 years

. MS office / VB applications (Outlook Forms) - 12 years

. ETL development / applications - 10 years

. C - Unix - 4 years

. HP QC Test Plans - 3 years

. Defect Management - 10 years

. MS SQL Server 2000 / SSRS - 2 years

. Unix Shell script - 8 years

. Perl scripting - 1 year

. MS SharePoint - 2 years

. PC support / New Software Installs - 20 Years

Professional Experience

Lord & Taylor St Louis, MO

Jul 2010 to Apr 2011

ETL Data Analyst / Developer / Tester

. Played a key role in converting merchandise inventory from HBTC to L&T

RFS data base

. Mapped SQL tables / columns from Oracle to corresponding tables on LT

Tandem systems.

. Coded data conversion programs as needed.

. Utilized XML transactions sent using MQ to synchronize with an oracle

system

. Designed & coded message handling system to report errors and to be

used in transaction balancing

. Provided technical assistance to other team members and helped resolve

program debugging issues

. Developed and wrote test cases for the unit and system testing of

multiple system enhancements

Hardware, Languages utilized: HP NS Itanium, MQ Series, XML, ETL,COBOL,

SQL, TACL

Kohl's, Inc. Milwaukee, WI

Sep 2009 to Jul 2010

Systems Analyst / Developer / Tester

. Designed, Coded and Tested enhancements / fixes to the Credit Card

Billing System

. Utilized HP QC to create test plans and manage defects discovered in

testing

. Wrote technical specifications with detailed test plans and test results

for multiple enhancements.

. Prepared installation plans / scripts for changes to the QA, UAT, and

production environments

. Assisted members of the QA testing team with various issues such as

running SQL queries to identify data matching specific test conditions

. Coded many complex SQL queries to support management including one to

show different customer types making ACH payments and opting out of paper

statements

. Developed SQL top ten hit list of poor performing programs based on

Measure data

. Used top ten list to add 10 new SQL indexes and change over 40 programs

that reduced the daily billing EOD run time from over 12 hours to 8 hours

Hardware, Languages utilized: HP NS Itanium, COBOL, SQL, HP QC, TACL,

Remedy

Rock Island Arsenal, Rock Island, IL

Feb 2009 to Aug 2009

SQL Analyst / Developer / Tester

. Maintained HP NS CLX running application FACS system (Factory Auto

Control System)

. Prepared and ran SQL queries as per user requirements

. Converted many SQL report to produce ETL XML spreadsheet sent via email

. Improved performance of system backup job by removing the SQL indexes

Hardware, Languages utilized: HP NS CLX, SQL, ETL,TACL, SCF, SPOOLCOM,

Netbatch Plus

JP Morgan Chase, Chicago, IL

Apr 2008 to Jan 2009

Systems Analyst / Developer / Tester

. Designed, coded and tested enhancements to the Chase payment processing

systems

. Prepared Tech design and coded changes for the following:

. User entitlement ETL extract file for CCS, RUBIES, TKM, LTD, MTCAM

. Required by IST security team for company wide security audit

. New Operator ID verification. Where a second user / manager needs to

verify

. Paybase system using SQL server 2000 / SSRS

. Automation of CCS manual TACL batch jobs using Control / M

. Packaged PayBase application for deployment on company network

. Utilized HP QC to prepare test plans

Hardware, Languages utilized: HP NS, ETL, COBOL, C, TAL, SQL, HP QC, SQL

server 2000, SSRS

GE Healthcare, Seattle, WA

May 2007 to Apr 2008

Software engineer / Tester

. Coded and Tested enhancements /fixes to the Centricity Patient Data

System

. Coded and maintained Perl scripts such as DDL make and many to support

system installations

. Prepared Unit test plans and results

. Prepared Technical specifications

. Utilized Vantive problem and change management system

Sample of projects worked on

. Barcode Med Charting

. Drug Ingredient and therapeutic duplicate checking utilizing interface to

First Databank

. Enhanced inbound & outbound HL7 order process to allow custom services

. Prepared SQL queries for Mayo Clinic from user supplied specifications

Hardware, Languages utilized: HP NS, C, COBOL, SQL, PERL, TACL, HP QC, HL7,

First Databank

US Foodservice, Skokie, IL

Jul 2002 to Apr 2007

Lead Developer / Production Support Analyst / Tester

. Provided 24/7 support, identified and fixed issues and developed system

enhancements

. Utilized ETL to allow PS GL / AR to interface with tandem AR / credit

system

. Developed custom ETL interface file for new outside vendor to print AR

Statements at a 500K savings

. Technical Resource person for group

Sample of projects worked on

. New company wide GL reporting system. on People Soft GL with custom

interfaces

. Email delivery of AR status and collection reports to Sales personnel in

XML format

. System to automatically put delinquent customers on credit hold based on

credit risk factors

. SQL Server 2000 /SSRS system with custom interfaces to support credit

collections.

. Outlook forms to allow entry of credit memos using VB

Hardware, Languages utilized: HP NS S Series, HP Unix shell, ETL, COBOL,

SQL, TACL, SQL server 2000, SSRS

Alliant Foodservice, Deerfield, IL

Mar 1999 to Jun 2002

Senior Programmer Analyst / Tester

. Provided 24/7 support, identified and fixed issues and developed system

enhancements

. Utilized SDLC to manage developmental efforts

. Prepared presentations for PIE review to support SDLC efforts

Sample of projects worked on

. ETL file to report credit data to credit bureaus using Experian 7 day

format

. System to import and export Excel files into the Tandem SQL AR & Customer

master database to support company acquisitions

. ETL system to allow receipt of ACH 823 lock box file and post the

payments

. ETL system to allow automatic EFT/ACH payments of invoices utilizing 820

file

Hardware, Languages utilized: Tandem Himalaya, HP Unix shell, ETL,NM COBOL,

SQL, Visual Basic, TACL

McDonalds Corp, Oakbrook, IL

Jul 1998 to Feb 1999

Applications Developer

. Analyzed, modified and unit tested software for Cash & Sales, Restaurant

Administration and Crew Payroll Applications

. Utilized development methodology consistent with corporate standards

. Scanned source code using self-developed TACL macro FindY2K

. Technical Resource to others in the Y2K Team

Hardware, Languages utilized: Tandem, COBOL, SQL, Enscribe

Intuit Services Corp, Downers Grove, IL

Jul 1996 to Mar 1997

Applications Developer

. Processed Online Bank Transactions: Added a sort of the input recs in key

sequence to maximize disk cache. This resulted in a 65 % improvement

. Check Create: Changed to run in multiple partitions to reduced run time

. Session Control: Added product code table to minimize i/os & fixed bugs

. Assisted in the implementation of NCI Source Control

. Additionally was the Tandem technical resource person for group

Hardware, Languages utilized: Tandem, COBOL, SQL, Enscribe, Prognosis

Kraft Foodservice, Deerfield, IL

Apr 1988 to Apr 1996

Programmer Analyst

. Involved in new system development and maintenance for Accounts

Receivable Customer Master, Order Entry and Warehousing applications

. Provided after hours support by taking turn in the primary support

rotation

. Wrote TAL TCP user conversion routines, Xerox 9700 print driver NETBATCH

interface and several MONCOM monitor programs using TAL

. Key member of program performance review committee, C to D conversion

using Questicon QHDC and the C30 conversion

. Technical Resource person for group

Hardware, Languages utilized: Tandem, COBOL, SQL, Enscribe

BMA Data Processing, Salt Lake City, UT

Apr 1986 to Apr 1988

Programmer Analyst

. Program maintenance for banking system applications (DDA, Savings, I/L,

C/G, C/L, M/L, Home Equity Loans & Combined Statements)

. Developed Escrow Account System for IBM PC

Hardware, Languages utilized: Tandem, TAL, Enscribe

BSL Technology, Salt Lake City, UT

Jun 1984 to Mar 1986

Programmer Analyst

. Duties Included developing, debugging, & testing application software.

Designing data base file structures. Fixing problems in existing

software. Reviewing and correcting

Hardware, Languages utilized: Tandem, TAL, Enscribe

St Margaret Hospital, Hammond, IN

Apr 1979 to Jun 1984

Programmer Analyst

Duties Included analyzing computer systems and recommending changes to

software and hardware.

Worked with management science department to prepare statistical reports

using SPSS.

Education

GE Healthcare, Seattle, WA, Software Control Management, 1 week class-2008

Tandem, Chicago, IL, Professional, 1 week SQL class -1988

Tandem, Los Angeles, CA, Professional, 2 weeks TAL class-1984

Purdue Calumet, Hammond, IN, Managing the Systems Development Process -1

semester class-1980

Purdue University, W Lafayette, IN, Degree not completed, Computer

Information Services- 1976 - 1978

Contact this candidate