Johnny Daniel Confidential Resume:
SUMMARY
Senior Programmer Analyst with over 20 years experience in design, development
and implementation.
Strong background in the use of the IBM midrange systems AS/400 and the
I-Series under OS/400
Well versed in the use of object management software (ALDON) and its various
environments
Experienced in developing and maintaining robust test scripts per the required
productions specs.
Experience with Load and Stress testing Scenarios (bench marking). USE of MQT
to improve performance in the I-Series
Excellent experience in the entire test process from unit testing, to system
testing, to implementation and finally post implementation verification.
Knowledgeable in the use of tools like MicroStrategy and Informatica
Experienced in SQL/400, MS/SQL, RPG/400, RPG/ILE, I-Series Navigator,
QUERY/400, OS/400
Coordinated with Auditors and end Users in different phases of the test and
implementation process.
Excellent
communication, technical and interpersonal skills and a team player.
TECHNICAL SKILLS
Testing Automation Tools : SQL/400, ACCESS, QUERY/400, I-Series Navigator,
MS/SQL
Test Language : SQL/400 test script, embedded SQL
Development Tools : RPG/400, RPG/ILE, SQL//400, EMB SQL, MQT, Microstrategy,
Informatica
Databases : IBM/DB2
OS Expertise : Windows 95/98/2000/XP/NT, OS/400, CPF/OS, SSP/OS
WORK EXPERIENCE
Computer Guidance Corp. (Senior Programmer / Analyst) May 2008 - Apr 2009.
Scottsdale, AZ.
Senior Programmer/Analyst responsible for the maintenance of existing
Construction Management software and custom modifications requested by some
clients. My area of responsibilities included maintenance of the RPG code with
embedded SQL as well as writing SQL scripts to be driven by a CL program.
Creation of custom code as well as its maintenance were part of the daily
operation. The client base was comprised of a combination of fairly large
accounts as well as mid size to small accounts. All modifications were to be
documented both in the program itself and as an addendum to the test scripts.
The object manager of choice was ALDON and we had to operate within the
restriction of the software.
Food Services of America (contract programming through APEX Systems, Inc.) Nov
2007 - Apr 2008. Scottsdale, AZ
Senior programmer / analyst responsible for the maintenance of existing home
grown software for the food industry. Responsibilities included working with the
RPG code and embedded SQL as well as writing SQL scripts to be driven by CL
programs. Catering to the specific needs of the several local as well as
national accounts were part of my duties. As a member of the group we shared
some of the responsibilities of writing code, testing code and providing the
final quality assurance prior to production implementation. It was within the
scope of my position to analyze the code, determine the cause of the problem,
implement the correction, unit test and system test prior to implementation. The
creation of comprehensive test scripts for all stages was a very important aspect
of those responsibilities. All modifications were to be documented both in the
program itself and as an addendum to the test scripts. Several testing tools
were used specially the I-Series navigator when determining the efficiency of the
code being written.
Role:
As a contract to hire, I was tested in all aspects of the Data Warehouse group
operation. All of our work was done remotely and all of our office interaction
was done via a virtual office environment. In short we accounted for every
minute of the day via the virtual office.
CSK Auto, Inc. May 2000 Sep 2007 Phoenix, Arizona
Senior Programmer / Analyst and Extract Transform & Load (ETL) developer for
the Data warehouse system. Within this system I developed code to efficiently
move data from the source system to the system which house the data warehouse. I
was responsible for writing the code that kept the DW system up to date while
minimizing the processing time. I modified a process and improved its
performance in more than 300% by just taking advantage of some of the features
available in the newer version of the operating system. By moving away from old
technology and embracing some of the newer code we were able to provide support
while improving performance. Converted the data to SQL tables and SQL indexes
from DDS files and logical files thus lowering overhead and improving
performance. Used embedded SQL to supplement the existing code rather than
converting the whole thing. Created aggregate tables to minimize table scans
and searches. It was my responsibility to provide the end user with this ability
by designing the data base with enough flexibility that could be use in a variety
of internal applications. The main focus however was for the data to be accessed
by the MicroStrategy tool for the sake of generating reports for the various end
users.
Role: Responsibilities included maintenance of the RPG code with embedded SQL
as well as writing SQL scripts to be driven by a CL program. Create custom code
as well as maintain it when requested by the clients. Analyzed Requirement
Specifications documentation, Functional Specification Document, User Interface
Specifications to develop and Execute Test scripts.
Verified the flat files as well relational data base files by using SQL and
Queries in the source system as well as in the test environment. Used a quasi
live environment to test the generated data with cross references to the source
systems. Data integrity was crucial and in the test phase it was a requirement
that all levels of the data would have a perfect match . This was also part of
the test script generated for the specific application.
Performed manual and automated test using the test scripts generated for the
application or initial load.
Prepared test conditions, detailing the various level of test which covered
development, unit test and system test prior to implementation. All errors
discovered in the source system would be documented and a projected course of
action was then outlined for the source system teams to handle the issue.
Environment: OS/400 on the I-Series, Windows, I-Series Navigator, SQL/400,
Websphere(available not used)
Computers Unlimited Mar 1999 May 2000 Tempe, Arizona
Senior programmer/analyst providing support to existing programming package for
the natural gas industry. Responsibilities included maintenance of the code
which was written in a combination of RPGII, RPGIII and RPG/400. We mostly
catered to the specific needs of the several accounts that were maintained. No
modifications to the base package were allowed unless it was requested by the
majority of the customers. These requests were received through out the year
placing them in a queue in order of importance. Due to the nature of the
business all modifications and tests of those modifications were closely
monitored by the corporate office in Billings Montana. There were some very
strict guidelines that were followed by the QA person that would in turn notify
the programmer if the modification passed or failed their scrutiny.
Role:
1. Analyze the code that had been flagged as having an issue (bug)
2. Determine if in reality it is a bug or if it was a data issue.
3. If it was a data issue, correct the data and determine its origin, then
creating the proper documentation so that the cause of the data issue can
be corrected.
4. If it was not a data issue then generate work order to correct the program
bug which in turn will be part of a PTF that will be sent to all
customers.
5. New development was handled by another programmer and was not part of my
role.
JDA Software, Inc. Oct 1997 Mar 1999 Phoenix, Arizona
Senior Programmer Analyst providing support to their programming package which
dealt with all aspects of a retail distribution environment. My job description
was that of Level II support specialist. Responsibilities included maintenance
to their code which was written mostly in RPG III and some portions were written
in RPG II.
Role:
1. Analyze the code that had been flagged as having an issue (bug)
2. Determine if in reality it is a bug or if it was a data issue.
3. If it was a data issue, correct the data and determine its origin, then
creating the proper documentation so that the cause of the data issue can
be corrected.
4. If it was not a data issue then generate work order to correct the program
bug which in turn will be part of a PTF that will be sent to all customers.
5. New development was handled by the R & D department and was not part of my
role.
EDUCATION
Bachelor Business Administration
University of Puerto Rico
Associate Computer Science
Miami Dade Community College
Certificate MicroStrategy
Micro Strategy Training Ctr
Certificate Computer Operations
IBM Atlanta
Certificate System Security
IBM Atlanta
Certificate INFORMATICA
Informatica Training Ctr.
Contact Information:
Johnny Daniel
850 E. Canyon Way
Chandler, AZ. 85249
Phone: [Send email to request phone number] 02-8517 Fax: [Send email to request phone number] 06-8581 Email: [Send email using
form at bottom]
Cell: [Send email to request phone number] 88-9275
|
