Project Manager Quality Assurance
Resume:
Johnny “JD” Daniel Confidential Resume:
I. Education:
University of Puerto Rico Bachelors Business Administration
Miami Dade Community College Associates Computer Science
Micro Strategy University Diploma Developer
Informatica University Diploma Developer
II. Employers Summary:
JDS Consulting, Inc. Scottsdale, AZ Contractor
Currently
Knight Transports, Inc. Phoenix, AZ Contractor 3 mth
Bank Of America Addison, TX Contractor 6mth
City of Ocala & Ocala Police Dpt Ocala, Fl Contractor 6 mth
United Guaranty (AIG Insurance) Greensboro, NC. Contractor 6 mth
Advance Auto Parts Roanoke, VA Contactor 6 mth
Computer Guidance Corp Scottsdale, AZ Full time employee 1 Year
Food Services of America Scottsdale, AZ Contractor 6 mth
CSK Auto, Inc. Phoenix, AZ. Full time employee 8 Years
Computers Unlimited Tempe, AZ Full time employee 2 years
JDA Software Phoenix, AZ Full time employee 2 years
Andersen Consulting Grand Rapids, MI Full time employee 2 years
Software Alternatives Grand Rapids, MI Full time employee 9 years
III. Skills Summary:
Over 25 years experience with Design, Development and Implementation
Experienced Project Manager and Project Leader with over 15 years
experience
Exceptional communicator in a team environment and stern enforcer of
coding standards
Corporate Trainer/Instructor for the IBM Mid range
Strong background in the use of the IBM mid-range systems AS/400 & I-Series
Well versed in the use of object management systems ALDON and MKS
Implementer
Experienced in the use of research tools HAWKEYE and X-ANALYSIS
Experienced in the use of SEQUEL Server 2008,SEQUEL Reporting Tool
Experienced in the use of SEQUEL Server 2008 Managing tool
Experience in the use of Crystal Reports XI
Experienced in the use of MS tools such as: Visio, MS Project, Excel, Word,
Etc.
Developed robust test scripts per required productions specs using Test
Director as a tool
Well versed in Load and Stress testing scenarios (bench marking)
Extensive expertise in the use of I-Series developments tools
Experienced in the use of Stored Procedures
Well versed in the use of all levels of HLL RPG in all of it’s existing forms
Experienced Project Manager and Project Leader with over 15 years
Exceptional communicator in a team environment and stern enforcer of
coding standards
Corporate Trainer/Instructor for the IBM Mid range
IV. Technical Skills:
Testing Tools :SQL/400, ACCESS, QUERY/400, I-Series Navigator, Hawkeye
Test Language :SQL/400 test scripts, Embedded SQL, Test Director
Report Writer :CRYSTAL REPORTING XI, SEQUEL SERVER 2008,
Microstrategy
Development Tools :RPG ILE, RPG Free, SQL/400, Embedded SQL, MQT
Office Software :MS Office, Visio, PowerPoint, Outlook, Excel, X-Analysis
Data Base :IBM/DB2
O/S Expertise :OS/400, CPF/OS, SSP/OS, Windows 95/98/2000/XP/NT
Hardware :S/3x, AS/400, I-Series, Personal Computer
V. Professional Experience:
Definition: On the last 25 years I have circumscribed my experience to the IBM Mid-
range system both in hardware as well as software. The last 18 years have been
actively spent as a Project Manager or as a Project Leader strictly guided by the
prevailing requirements.
It is not unusual on this environment to wear multiple hats as the projects develop.
This approach although not unusual, it applies almost exclusively to the IBM Mid-range
platform. As it is the case presented in this resume, I will show how a seemingly simple
task mushrooms to a never ending process. Brought back under control after
“switching hats” and providing the type of leadership required to bring the project to a
successful completion.
VI. 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 in system migrations and conversions.
• Lead efforts to improve system performance by implementing the use of
aggregates as well as MQT (materialized query tables) processing.
• Experienced in working with Off-Shore support and establishing operational
parameters.
• Created comprehensive test scripts providing support to Quality Assurance prior
to production implementation.
VII. Project Manager / Project Leader Work Experience:
JDS Consulting, Inc. Scottsdale, AZ January 2010 thru Present
My responsibilities include but are not limited to providing leadership in the
modification of business process that will apply to part of or the entire business model
currently in use. In that capacity I encourage the team concept by defining clear
goals and extracting ideas from them as a group while attempting to keep within the
time and cost constraints. My prior experience as a consultant does add a dimension
to what I bring to the table. I can look at the problem at hand from both sides of the
table. Having a good idea of the type of effort required for a given task, helps me
eliminate the ongoing problem of “padding” estimates. Better yet, it allows me to see
if a project is grossly underestimated. The other dimension that it provides is
understanding the programming languages and when it would be efficient to use and
how to use it. Being well versed in the I-Series and it's utilities affords me the luxury to
ask for specific test results or to require certain tests to be part of the process thus
avoiding unnecessary future bug fixes.
Knight Transports, Inc. Phoenix, AZ August 2012 thru October
2012
My responsibilities included but were not limited to code analysis and quality
assurance. While performing as an analyst it was required of me to suggest
improvements in the process if they were deemed necessary and appropriate for the
task at hand. Within the scope of my responsibilities I created code utilizing a system
tool known as SEQUEL Reporting. It was with this tool that several reports were created
to be used by their in house staff members. This was a short term assignment, mainly
focused on feeling the gap created by an unforeseen vacancy.
Bank Of America Addison, TX February 2012 thru June 2012
My responsibilities initially included code analysis and quality assurance. I was soon
asked to provide leadership in identifying latent problems and suggesting solutions.
This new approach led to code critique, suggest new and more efficient techniques.
Techniques such as the use of Materialized Query Tables (MQT), embedded SQL and
multiple occurrence data structures to name a few. To introduce new techniques
requires a subtle touch while stern in the enforcement of said new rules. There is a
very fine line between critique and criticize and I was able to have people come to me
asking to have their code critiqued. It is my pride and pleasure to provide such
guidance without damaging the team's cohesiveness. Understanding my strengths and
weaknesses does provide me with the road map to understand the strength and
weaknesses of those in my team or project. For it is that understanding that helped me
complete the project on time and on budget.
City of Ocala Police Dpt Ocala, FL May 2011 thru November 2011
My responsibilities included but were not limited to code analysis and code re-write.
The main goal was to migrate the tables that existed on the I-series to the SQL server
2008. I had to interpret the existing RPG code on the I-Series in order to create the
proper output file that will be migrated to the SQL server. This unorthodox approach
was needed due to lack of documentation on both the I-Series as well as the SQL
server. I had to fall back on my project management expertise by identifying the
problem and suggesting a possible course of action thus anticipating the expected
outcome. This project was initially slated to be 6 to 9 months in duration, but analysis
and subsequent plan allowed me to complete the conversion and migration tasks in
three months. I then concentrated the remaining time to developing new reports by
using Crystal Reports in the SQL Server 2008.
City of Ocala City Hall Ocala, FL February 2011 thru May 2011
My responsibilities were limited to migrate the tables that existed on the I-series to the
SQL server 2008. The city of Ocala had a totally different set up with their computer
system and most of their applications were running in the SQL server with a package
that was running in it. After the successful migration I was assigned the task to create
many of their reports using Crystal Reports 2009. It was part of my duties to meet with
the user to determine their requirements and creating the proper report for their use.
This task was made easier by the upfront work I had to do for the Ocala Police
Department. In essence we identified the problem, came up with a solution and
implemented the same. Falling back in my Project leadership expertise helped me
complete this project well under the originally estimated time frame.
United Guaranty (A.I.G. Insurance) Greensboro, NC September 2010 thru
November 2010
I was a member of group of analysts which were assigned the task of delivering a
comprehensive system analysis. Said analysis was in essence a feasibility study to
determine if the existing hardware and software combination was meeting
expectations. I was responsible for a segment of the system having to produce a
presentation to be delivered to management. Each member of the group had his or her
own responsibilities and in essence it was conducted as separate projects, conducting
interviews with users and developers. With the implied goal of a possible system
streamlining. An application as defined by X-ANALYSIS is any group of programs that
have a commonality. We used that commonality to build a comprehensive analytical
report showing in various forms their common ground and connectivity. All projects
were similar if not identical in structure hence we managed our time and available
resources to deliver the aforementioned report and analysis to upper management.
Advance Auto Parts Roanoke, VA January 2010 thru August 2010
My first responsibility was to deliver and in-depth analysis for any program that I was to
create a test script for. In doing so I was tapping into my ability to interact with others.
The position evolved into a project leadership position when I was the senior
consultant with three other programmers working with me. I was required to field their
questions and provide answers according to the established restrictions. Meaning that
if the issue was identified to be a local issue, then we were supposed to engage in the
local research with the local resources. If in the other hand we found that the issue was
related to the off-shore resources, then the approach had to be funneled through the in-
house project manager. In other words the in-house project manager will coordinate
long distance conferences for me to discuss with the off-shore team, what we have
discovered and to seek a resolution to the issue. We had several tools in the I-Series
and the one widely used for the aforementioned analysis and creation of test scripts
was Test Director VIII. My team was totally responsible for delivering comprehensive
test scripts to be used by developers, users and quality assurance testers for all
software including those delivered to us by the off-shore people.
Computer Guidance Corporation Scottsdale, AZ May 2008 thru April
2009
It was my responsibility to maintain 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. In this environment the capacity to work as a project
manager is minimal but it did occur often enough. It was customary for a team of
programmers to be assigned a task. No one individual is given the responsibility of
being the lead. I took the leadership role in several occasions because it suited the
needs of the project. My strengths were at the time in the use of SQL as a retrieval
tool. As such I lead the team in using some of the techniques and applying them to
existing code within existing business rules thus improving the overall performance of
the package. In addition I was able to share some of that knowledge with the other
programmers thus making our team more efficient. It was our most important priority
to be on time and on budget, both goals were met at least 90% of the time.
t 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.
Food Services of America Scottsdale, AZ November 2007 thru
April 2008
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 be the project leader and 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.
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 roll-outs 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.
CSK Auto, Inc Phoenix, AZ May 2000 thru September 2007
All throughout my employment at CSK Auto it was expected of me to be able to take
the ball and run with it. Meaning that when a project was assigned to me, it was my
responsibility to document the objectives, manpower requirement as well as any other
requirements paying close attention to production impact. It was my job to to see this
project from beginning to end making sure to keep all parties informed of progress or
issues developed that would impact completion. Project manager is what I was with a
few more twists added to it. Twists such as identifying programming challenges and
finding an effective resolution to the same. Provide support when one of the support
resources was not available or moved to another project. Being quick on my feet was
part of the job description. To be addressed as a project manager would not be a fair
assessment of all of my responsibilities. In short when a project was assigned to me I
had to make it work, no ifs or buts about it.
The re-engineering of business processes by creating new code with embedded SQL as
well as writing SQL scripts was a requirement. I was responsible for leading on the
effort of combining RPG Free, RPGLE and embedded SQL. The ultimate goal was to
provide 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.
Computers Unlimited, Inc Tempe, AZ March 1999 thru May 2000
On an installation that is fairly small I was required to wear many hats. The one hat I
wore quite frequently was that of project manager. We had a small group of very
dedicated people who knew the business extremely well. I was my job to coordinate
those able bodies into a cohesive unit thus achieving our intended goals.
It was my responsibility to provide support to the existing programming package for the
natural gas industry. Within that capacity I was required to design, develop and
implement 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.
VIII. Contact Information:
Name: Johnny Daniel
Phone: 480-***-**** (H)
Email: ab84zl@r.postjobfree.com
Contact this candidate