Sales System
Resume:
EDWARD P. SMITH
Ave., #**
Cincinnati, Ohio 45208
E-Mail: acc7kl@r.postjobfree.com Phone:
SENIOR PROGRAMMER/ANALYST with 15+ years of results-oriented
experience
in application development and batch support hosted on an IBM
mainframe with
a core focus in COBOL(II), db2 & JCL.
QUALIFICATION HIGHLIGHTS:
. Hands-on experience working with internal customers in preparing test
data, reviewing testing results and ensuring expectations are met.
. Strong experience in all stages of the SDLC, including solution
design, requirements analysis, integration testing, development and
customization, a strong emphasis on successful production
roll-out, user training and on-going support.
. Expertise in all phases of DB2: coding SQL in COBOL module,
troubleshooting SQL return codes, loading\unloading test databases,
package\plan binds, cursor logic, normalization, design\implement new
table, image copies, RUNSTATS, work with DBA's as needed.
. Strong Interpersonal and communication skills, ability to work in a
team as well as independently with minimal supervision.
. Extremely well organized, with proven ability to multi-task and
prioritize workload.
. Actively participate in daily team meetings, code walkthroughs and all
project related activities.
. Very enthusiastic about opportunities to learn new skills.
TECHNICAL SKILLS:
Languages: COBOL(II), PL/I, SQL, Focus.
Operating Systems: IBM(AS/400), TSO/ISPF, MVS, MS(DOS), VAX, Windows
XP, Windows 7, UNIX,
OS/2.
Tools: FileAid, AbendAid, Microsoft Office Applications. ChangeMan,
Endevor, Expeditor, Direct
Connect, Convey Taxport, SmartStream, Spufi, IBM Tools
(FileManager, FaultAnal, & Debug
Tool), SERENA (MAR compliance tool), INFOPAC, SAR, QMF,
Chameleon FTP. Telnet,
SPFSource Edit, COGNOS Impromptu & Powerplay, DB Artisan,
Candle, Panvalet, BrownStone
Repository, CA-11, CA-7, Accuchek, Animator, OS/2, Visio
4.0, Witt.
Databases: DB2, Sybase, MS Access, SQL Server.
Professional Experience:
Ohio National Financial Services - Montgomery, Oh
Senior Programmer/Analyst - June 2001 to Present
Senior Programmer/Analyst for a mid-sized Financial services company
working in the agents
compensation group and currently responsible for the payroll system.
. Provide ongoing system ownership of Payroll system, supporting Agents
comp area; perform maintenance as needed, respond to production
issues, analyze new project proposals. implement new and modify
existing code, maintain scheduling for daily, weekly and semi-monthly
pay cycles, oversee year-end processing and production bonus payments.
Responded to customer problem logs\did upkeep of existing modules.
. Provide support for NSCC team, ensure wire transmissions successfully
transmitted thru DTCC to meet deadlines, tasked with general system
maintenance and enhancements, upgrades, etc, setup new firms, send
test files and confirm successful production moves.
Continued...
. Played instrumental role in setting up and maintaining the companies
Anti Money Laundering (AML) system; coded, tested and rolled out AML,
working with LIMRA to receive\send data via FTP to ensure agents
receive government mandated training.
. Implemented new 1099 tax processing system to replace old legacy
process; worked closely with Convey Taxport vendors thru initial
server install, performed periodic release updates, worked closely to
train end users company wide.
. Worked on team to convert old Sales Compensation System to CSC
proprietary software, Performance Plus(PPS) to realize company
strategic goal to be on CSC platform; translated all existing payroll
programs from SCS to PPS tables, performed table loads\unloads, file
compares, unit, regression and full system testing between old and new
system, worked closely with team of end-users to verify results.
. Expanded semi-monthly payroll cycle to include weekly and daily pay
options; coding JCL, creating new Job structures and CA7 schedules,
create new reports, implementing into production and verifying
results; offers flexible pay options to agents and gives ONFS a
competitive edge in the recruitment of agents.
. Perform on-call support duties 24/7 for several nightly scheduled
batch systems and backup support for several more.
The following products\tools are used:
TSO/ISPF, MVS, FileAid, AbendAid, DB2, ChangeMan, Expeditor,
Microsoft Office Suite, Direct
Connect, Convey Taxport, SmartStream, SPUFI, IBM Tools (FileManager,
FaultAnal, & Debug Tool),
SERENA (MAR compliance tool).
Square D Company - Florence, Ky.
Programmer/Analyst - July 1999 to June 2001
Programmer/Analyst for a Decision Support team at a large electrical
products manufacturing company.
The 'Information Factory' was responsible for producing a relevant &
timely data warehouse to aid
upper management as well as the sales force in achieving their strategic
planning & goal assessment.
. Coded, tested and implemented CICS, UNIX and COBOL(II) modules.
. Responded to customer problem logs\did upkeep of existing modules.
. Assessed Y2K changes needed across systems and provided estimates.
. Developed Kornshell scripts that worked as a buffer for a CICS system
to interface with UNIX Cobol programs and Sybase tables via MQ.
. Created CICS rebates system that allowed users in the Lexington plant
to process special rebates for customers who met pre-determined
criteria.
. Supported Marketing Decision support system responcible for providing
the sales force with critical data funneled down through a batch Cobol
system, into Sybase and used by COGNOS to create reports in Impromptu
& Powerplay.
. Performed off hours on-call support duties.
The following products\tools were used:
TSO/ISPF, MVS, FileAid, AbendAid, SAR, UNIX, SYBASE, QMF, DB2,
Endevor, Expeditor, Microsoft
Office Suite, Chameleon FTP. Telnet, SPFSource Edit, COGNOS.
Continued...
Great American Insurance Company - Cincinnati, Ohio
Programmer - Sept. 1997 to July 1999
Programmer for the Claims Dept. at a large Insurance company during the
height of the Y2K period;
assigned to work with a team of consultants to convert legacy systems to
Y2K compliance.
. Responsible for the coding and testing of online COBOL(II) screen map
programs, developed with APS Code Generator & MicroFocus Cobol for PC.
. Responded to customer problem logs as needed.
. Maintained existing modules as requested.
. Assessed Y2K changes needed across systems and provided estimates.
. Wrote test plans and tested modules for Y2K certification.
. Performed Y2K testing for claims; was responsible for setting up JCL
to run procs changed by overseas consulting firm.
. As a member of the Y2K conversion team, played critical role in
tracking, cataloging and organizing code deliveries from our
consultants overseas.
The following products\tools were used:
TSO/ISPF, MVS, FileAid, AbendAid, SAR, Candle, QMF, Spufi, DB2, Panvalet,
BrownStone Repository, Expeditor, CA-11, Accuchek, Animator, OS/2, Visio
4.0, Witt 2.0, Microsoft Office Suite.
EDUCATION
Northern
Kentucky University - Highland Heights, Kentucky
Bachelor of Science in Information Systems
Graduation: December
1999
RELATED COURSEWORK
Cobol
Programming I & II - structured programming techniques.
Data Modeling - E-R diagrams\normalization
techniques to design and implement DBMS. Info
Systems Analysis - used Data Flow Diagrams to analyze the logical flow of a
small business.
DB Management Systems - used PowerBuilder 4.0 to create a DBMS consisting
of DB driven App.
Internet
Programming - created eCommerece website - ASP, HTML, VBScript/JAVAscript.
Advanced Windows Programming - wrote advanced Windows applications using
Visual Basic.
Programming with C++ - learned programming techniques using C++.
Programming with JAVA - learned programming techniques
using JAVA.
MILITARY HISTORY
U.S. Army
(Honorable discharge) 11/83 - 02/87
REFERENCES Available upon request.
Contact this candidate