Johnny Daniel Confidential Resume:
EDUCATION
Bachelor Business Administration
University of Puerto Rico
Associate Computer Science
Miami Dade Community College
Certificate MicroStrategy
SUMMARY
• Senior Project Leader 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 it’s various
environments
• Well versed in the use of MKS Implementer object manager
• Developed robust test scripts per the required productions specs.
• Well versed in Load and Stress testing Scenarios (bench marking).
• Experienced in applying QA techniques while unit testing, system testing and
implementation.
• Experienced in the use of research tools like I-Series Navigator, Hawkeye and
SQL
• Experienced in the use of development tools like Websphere
Development Studio Client
• Many years experience using RPG in all of its levels as well as the
AS/400 and I-Series under OS/400
• Coordinated with Auditors and end Users in different phases of the test and
implementation process.
• Assisted in the enhancement and implementation of multiple accounting
applications
• Wrote enhancements to P/R packages both homegrown and packaged.
• Wrote enhancements to H.R packages
• Lead the design, development and implementation of a transaction
tracking system to assist with “Shrink”
•Excellent
communicator, on top of up to date coding standards and techniques.
• Project Leader and Project manager experience for over 15 year
• Corporate Trainer/Instructor for Software Alternative, Inc. (IBM
Business Partner)
TECHNICAL SKILLS
Testing Automation Tools : SQL/400, ACCESS, QUERY/400, I-Series Navigator,
Hawkeye
Test Language : SQL/400 test script, embedded SQL, Test Director
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
Professional Experience
Advance Auto Parts (Senior Project Leader ) January 2010 – Current. Roanoke,
VA.
Responsibilities:
• Contractor on the AS/400 interpreting RPG II, RPGIII, RPG IV code in order to
devise test scripts to be utilized by the QA personnel.
• Create SQL scripts that will provide direction for the QA tester to follow
thus facilitating the test process and ensuring accuracy.
• Detailed documentation on problem areas that were discovered as part of the
scope of my task.
• Extensive use of Test Director VIII
• Extensive use of Hawkeye as an analysis tool
Environment: AS/400, RPGII, RPGIII, RPGIV, RPGILE, CLP, CLLE, SQL400, Embedded
SQL, QUERY400, DBU, DDS, FTP, PDM, I-Series Navigator, Test Director, HawkEye
It is my responsibility to deliver an in-depth analysis in any program that I am
to create a test script for. Analysis included but was not limited to:
1. Maintenance of system documentation outlining the progress of said analysis
2. Usage of Hawkeye tool to determine all sources of calls from and calls to
said program.
3. Document all said calls and establish the test script on the lowest iteration
of the program call. (the first level call to the program. Ie. Menu option or
dynamic call)
4. Provide a step by step set up through completion test script, appraising the
project manager of the progress by submitting an updated spread sheet on the
project.
Computer Guidance Corp. (Senior Project Leader ) May 2008 - Apr 2009.
Scottsdale, AZ.
Responsibilities: Project Leader
• Project lead in the development of new code to enhance the existing
Construction Management software as well as custom business requirements
modifications.
• Lead the implementation of embedded SQL to enhance existing RPG code.
• Leading role in the design, development and implementation of the Copy
Company Delete utility to be used in the construction software.
• Active involvement in sharing my knowledge and expertise with junior
programmers.
• Lead the promoting in the use of “Test Scripts” thus minimizing errors and
omissions in the code.
• Create and maintain test environments to be used in the QA phase.
• Detailed documentation of all program modifications and areas affected both in
the programs and in addendums to the test scripts.
• Operate within the scope of ALDON Object Management System.
Testing Procedural Steps
At Computer Guidance I maintained in the AS/400 a comprehensive test environment
that could be use throughout the cycle. Creation, development and maintenance of
comprehensive test environments capable of handling migrations, conversions and
rollouts to a client base of over 400 customers through out the United States,
Canada and the U.S. Virgin Islands. Worked in conjunction with development teams
enforcing business rules. Used several stress test techniques (bench marks) in
the environments thus ensuring the most efficient processes were used.
Environment: AS/400, RPGII, RPGIII, RPGIV, RPGILE, CLP, CLLE, SQL400, Embedded
SQL, QUERY400, Websphere Development Studio Client (WDSC) ,RDI , ALDON Object
Mgr, DBU, DDS, FTP, PDM, I-Series Navigator
It was crucial to work within the confines of our business model making sure
that all of our tests were a true representation of the same. The set up of the
various AS/400 environments were handled as part of the test scripts. In them it
was detailed the order on which the production and test libraries were to be
arranged. (AS/400 library list set up). Note: Refer to “Environment Formats and
Functions” at the end of this section for more detail.
Food Services of America (contract programming through APEX Systems, Inc.) Nov
2007 - Apr 2008. Scottsdale, AZ
Responsibilities: Project Leader
• Maintenance of existing home grown software for the food industry.
• Provided 24/7 on call assistance.
• Benchmarking processes to insure peak performance.
• Provided support to the various departments with their programming changes
requests.
• Provided QA support in all modified software in both unit testing and system
testing.
• Creation of comprehensive test scripts for all testing stages.
Environment: AS/400, RPGIV, RPGILE, CLP, CLLE, SQL400, Embedded SQL, QUERY400,
DBU, DDS, FTP, PDM
Role:
As a contract to hire, it was expected of me to be proficient in many if not all
aspects of the Data Warehouse group operation. Due to said expertise with the
I-Series I was called upon to direct a specific programming approach from time to
time. If the implementation of the new approach was accepted by the team, then it
would be my responsibility to make sure that all other members fully understood
the process effectively becoming the corporate trainer. Change management was
also very crucial and the responsibility was evenly shared by all members of the
Data Warehouse Group.
Testing Procedural Steps
At Food Services of America I maintained a comprehensive test environment in the
I-Series that could be use throughout the test cycle. Creation, development
and maintenance of comprehensive test environments capable of handling
migrations, conversions and rollouts to warehouses and terminals in our system
through out the United States and Canada. Worked in conjunction with development
teams enforcing business rules. Used several stress test techniques (bench
marks) in the environments thus ensuring the most efficient processes were used.
It was crucial to work within the confines of our retail business model making
sure that all of our tests were a true representation of the same. The set up of
the I-Series environments were handled as part of the test scripts. In them it
specified which profile to use which in turn will determine the order on which
the production and test libraries were to be arranged. (I-Series library list set
up). Note: Refer to “Environment Formats and Functions” at the end of this
section for more detail.
CSK Auto, Inc. May 2000 – Sep 2007 Phoenix, Arizona
Responsibilities: Project Leader
• Developed, enhanced and implemented the ETL process on the Data Warehouse
environment.
• Implemented, designed and developed a “Shrink” tracking system for Corporate
Security.
• Designed, developed and implemented a Truck route tracking system.
• Designed, developed and implemented a commercial sales online tracking and
reporting.
• Spearheaded the use of MQTs as a viable option for massive file updates.
• Spearheaded the use of SQL triggers as a method to track file updates.
• Ensured the observance of the SARBANES/OXLEY (SOX) rules.
• Spearheaded the replacement of RPGIII code with SQL (embedded and scripts)
• Promoted the use of best coding practices while using RPG and SQL as the HLL.
• Actively involved in the move away from old technology while embracing some of
the newer methodology. This allowed me to provide support while improving
performance.
• Converted DDS physical files and logical files to SQL tables and indexes.
• Engaged in business analysis by applying the rules afforded by the corporate
business model.
• Created aggregate tables to minimize table scans and searches.
• Implemented the used of embedded SQL to supplement the existing code rather
than converting the whole thing.
A couple of approaches to move data from one AS/400 to another were utilized.
SARBANES / OXLEY (SOX) rules were in place hence all data movement in the
production environment was done using File Transfer Protocol (FTP).
Environment: AS/400, RPGII, RPGIII, RPGIV, RPGILE, CLP, CLLE, SQL400, Embedded
SQL, QUERY400, Websphere Client, ALDON Object Mgr, DBU, DDS, FTP, PDM, I-Series
Navigator
Role: Deliverables included business process reengineering by creating new code
with embedded SQL as well as writing SQL scripts. A combination of RPG Free,
RPGLE and embedded SQL provided the flexibility that was needed to keep the Data
Warehouse functioning at it’s peak performance. When the task required the use
of additional resources, I would be the project lead making sure that I kept the
department manager informed of every phase. Status meetings were used in a
regular basis as a mean to deliver good customer service by maintaining open
lines of communication that would guarantee a successful completion and
implementation.
The upkeep of our test environment was crucial to the operation. AS/400
triggers as well as SQL triggers were widely used and had to reflect how it would
affect the production environment when the objects were promoted. 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 tests 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.
Testing Procedural Steps
At CSK Auto it was required to maintain a comprehensive test environment in
both the source AS/400 and the Data Warehouse I-Series that could be use
throughout the test cycle. Creation, development and maintenance of
comprehensive test environments capable of handling migrations, conversions and
rollouts to over 1,200 stores in several major markets. Worked in conjunction
with development teams enforcing business rules while ensuring compliance with
SOX (Sarbanes / Oxley) mandates. Used several stress test techniques (bench
marks) in the environments thus ensuring the most efficient processes were used.
It was crucial to work within the confines of our retail business model making
sure that all of our tests were a true representation of the same. The set up of
the various AS/400 environments were handled as part of the test scripts. In
them it was detailed the order on which the production and test libraries were to
be arranged. (AS/400 library list set up). Note: Refer to “Environment Formats
and Functions” at the end of this section for more detail.
Computers Unlimited Mar 1999 – May 2000 Tempe, Arizona
Responsibilities: Senior Programmer Analyst
• Provided support to existing programming package for the natural gas industry.
• Designed, developed and implemented the code while applying best practices in
coding.
• Cultivated customer relationships by constantly catering to the specific needs
of the several accounts that were maintained.
Keeping in line with the business model 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. In the event that they were to be
added to the base product, we had to make sure that the business model was
followed at all times. 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.
Environment: AS/400, RPGII, RPGIII, RPGIV, CLP, QUERY400, DBU, DDS, PDM
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 it’s 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
Responsibilities: Project Leader
• Provided support to existing programming package for retail stores and POS
systems.
• Designed, developed and implemented the code while applying best practices in
coding.
Senior Project Leader providing support to their retail sales programming
package. Customer Relationship management was an integral part of my duties for
we provided support remotely and in person. Deliverables included their code
maintenance which was written mostly in RPG III and some portions were written in
RPG II. It was required the strict adherence of retail sales business rules.
Due to the complexity of the software we were restricted on the type of
modifications we were allowed to do so that the integrity of the package was not
compromised.
Environment: AS/400, RPGII, RPGIII, RPGIV, CLP, QUERY400, DBU, DDS, PDM
Role:
1. Code analysis insuring that all proper methodologies were followed.
2. Determine if in reality a bug existed or if it was a data issue.
3. If it was a data issue, correct the data and determine it’s origin, then
creating the proper documentation so that the cause of the data issue can be
corrected making sure that a proper strategy was drawn out and executed.
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.
Environment Formats and Functions
• Set up data refresh processes thus ensuring data integrity equal to production
data
• Managed all test environment data individually by application
• Created skeleton SQL scripts to assist on the various tests and data
extraction
• Worked with business analysts adding my expertise and knowledge when required
or needed
• Extensive expertise in the use of AS/400 utilities and HLL. (such as RPG III,
RPG IV, RPGLE, RPG $Free, Embedded SQL)
• Well versed in the use of RLU, DBU, Query 400, PDM, WDSC
• Strong Project management background and data conversions.
• Lead efforts to improve system performance by implementing the use of
aggregates as well as MQT (materialized query tables) processing.
• Created comprehensive test scripts providing support to Quality Assurance
prior to production implementation.
Certificate Micro Strategy
Micro Strategy Training Ctr
Certificate Computer Operations
IBM Atlanta
Certificate System Security
IBM Atlanta
Certificate INFORMATICA
Informatica Training Ctr.
Contact Information:
Johnny Daniel
Email: [Send email using form at bottom] Cell: [Send email to request phone number] 88-9275
|
