Resume

Sign in

Project Manager Data

Location:
Paradise Valley, Arizona, United States
Posted:
January 18, 2018

Contact this candidate

Johnny Daniel Confidential Resume

Education

University of Puerto Rico -- Bachelor Business Admin

Miami Dade Community College -- AA in Computer Science

Summary

It has been my experience that the one thing customer's crave the most is one individual who would first listen to their request and then listen some more. I bring to the table well over 25 years as a consultant, working with all levels of users. Ranging from the CEO to the data entry clerk.

The following Skill summary is what I bring to the table.

Skills Summary:

Over 29 years experience with Design, Development and Implementation

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, ABSTRACT and X-ANALYSIS

Experienced in the use of SEQUEL Server 2008

Experienced in the use of SEQUEL Server 2008 Managing tool

Experience in the use of Crystal Reports XI, SEQUEL & MicroStrategy

Experienced in the use of MS tools such as: Visio, MS Project, Excel, Word

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

Well versed in the use of all levels of HLL RPG in all of it’s existing forms

Experienced in working with OFF-Shore support

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

Technical Skills

Testing Automation Tools : SQL/400, ACCESS, QUERY/400, I-Series Navigator, Hawkeye, Abstract

Test Language : SQL/400 test scripts, Embedded SQL, Test Director

Report Writer : Crystal Reporting XI, SEQUEL, 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

Specialties: Business Analyst, Project Manager, Project Leader, Corporate Trainer, Senior Programmer Analyst

Project Management Experience

Senior Project Leader / DB Analyst

Swift Transportation, Inc. / Phoenix, AZ May 2015 to March 2017

My job description covers a wide range, from programming as well as operations and system tuning and one key element...training on newer and more advanced technologies. Initially the main focus will be that of enhancing / improving system performance on the I-Series. Making provision for the other aspects to also be implemented. We know that as a company there will be many challenges to face. We also know that unless we plan to face and conquer those challenges, we will be planning to fail when the challenges do occur. It is a fact that it is not a matter of if, but a matter of when the challenges do present themselves. It is my vision to provide guidance when it is needed as well as following established norms when required. I am a firm advocate of the team environment and an ardent follower of General Stanley Mc Chrystal’s concept of team of teams.

Senior Project Leader DB Analyst

Green Tree Credit Solutions / Tempe, AZ June 2013 to May 2015

My job description covers a wide range of responsibilities. It includes programming as well as operations and system tuning and one key element...training on newer and more advanced technologies. Initially the main focus will be that of enhancing / improving system performance on the I-Series. Making provision for the other aspects to also be implemented. We know that as a company there will be many challenges to face. We also know that unless we plan to face and conquer those challenges, we will be planning to fail when the challenges do occur. It is a fact that it is not a matter of if, but a matter of when the challenges do present themselves. I am confident that all elements of this operation will be ready. It is my pleasure and honor to have been chosen to be part of the GTS team.

Project Manager Consultant

JDS Consulting, Inc. / Chandler, AZ April 2009 to June 2013

I have moved my career path to that of an independent contractor in the Information Technology arena, both as a Sr Programmer Analyst and a Sr Quality Assurance Analyst. My expertise has been honed by well over 29 years in this arena.

I am well versed in several vertical markets including but not limited to:

• Retail - Point of sales

• Legal - Time management system

• Freight – Freight Forwarding, N.V.O.C.C, Overland

• Manufacturing – Inventory Control

• Distribution - Store chain distribution

• Warehouse Management – Logistics

• Data Warehouse - ETL Process, MQT processing

• Construction – Construction Management

• Accounting - Profit & Loss, Assets, Liabilities

• Human Resources - Payroll, Benefits

Senior Project Leader

Kinight Transportation / Phoenix, AZ August 2012 to November 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 filling the gap created by an unforeseen vacancy.

Senior Project Leader

Bank Of America / Addison, TX February 2012 to June 2012

My responsibilities included the analysis of existing code and creation of new code by using their preferred method of coding, the I-Series Stored procedures. In this environment most RPG code was replaced by the use of stored procedures, using only RPG as the shell language from where to launch the code. It was required of this position to shift from developer to leader in a regular basis. On this capacity I would share or train other developers in techniques that they may not be familiar with.

Senior Project Leader

City of Ocala Police / Ocala, FL February 2011 to November 2011

Expertise with the ever so popular SEQUEL Server 2008 as well as the use of Crystal Reports to replicate some of the reports being used in the AS/400 platform. While on assignment with the Ocala Police department and the City of Ocala I was given the assignment to interpret the High Level Language used (RPG Legacy Code) that resided in the AS/400 and replicating the reports in the SQL Server using the Crystal Reports tool.

Senior Project Leader

United Guaranty Corp / Greensboro, NC Sept 2010 to Nov 2010

It was a contract position and as such It was my responsibility to deliver an in-depth analysis in a variety of applications. An application as define 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. As an example, one process had over 100 applications and we provided this analysis showing via graphs, flow charts and data flows their connectivity amongst themselves and other applications. Performed extensive analysis of their software by utilizing the various analytical tools such as X-Analysis, Hawkeye, I-Series Navigator. Said analysis is to be the back bone of all future enhancements and or additions to their I-Series.

Senior Project Leader, Q/A Tester, Contractor

Advanced Auto Parts / Roanoke, VA Feb 2010 to June 2010

Write Test scripts using the Test Director Tool paying close attention to the setup steps as well as data collection after executing the test scripts Extensive program call research is a must for there can be several levels of the same code depending on specific circumstances. Hawkeye as the research tool was the tool of choice. Exposed to the use of MKS Implementer to promote programs through the various test and QA environments. While testing some of the programs it was crucial to understand the inner workings of ILE and the use of Procedures, sub-procedures, modules and service programs as well as their interrelation to bind directories and their connection with the binder source. Provide means for the QA tester or the RPG developer to extract data by using SQL scripts or mannually entering said scripts for quick access and determination.

Senior Project Leader

Computer Guidance Corp / Scottsdale, AZ May 2008 to Apr 2009

Maintenance of existing Construction Management software for the construction industry. Responsibilities included maintenance of the RPG Legacy 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. 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.

Responsibilities included maintenance of the RPG code with embedded SQL as well as writing SQL scripts to be driven by a CL program. We catered to the specific needs of the several local as well as national accounts. 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. We used as a testing tool the I-Series navigator.

Senior Project Leader

Food Services of America / Scottsdale, AZ Nov 2007 to Apr 2008

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.

Senior Project Leader

CSK Auto, Inc / Phoenix, AZ May 2000 to Sept 2007

Responsibilities included the modernization of legacy code by using SQL as the nested language. On this capacity I was charged with the creation and maintenance of their Data Warehouse using exclusively RPG and SQL the languages to extract data from the source system as well as generating the various reports to the over 1,200 stores in the network. We were assigned the task of creating a tracking system to be able to isolate the source of the company wide "Shrink". A system was designed and later rolled out that had an impact on shrink from the very beginning. The system could track any transaction from the time it was generated and any activity related to it (ie. warranties) for no less than 10 years. The area of performance we were also charged with the task of trimming down a process that was running for over 36 hours. We were able to trim it down to under 15 minutes by using SQL in a variety of ways including the use of materialize query tables. (MQT), triggers and indexes.

Project Leader

Computers Unlimited / Tempe, AZ March 1999 to May 2000

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 throughout 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.

Senior Programmer Analyst (Project Leader)

JDA Software / Phoenix, AZ October 1997 to March 1999

Maintenance of 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 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 the R & D department and was not part of my role.

Senior Programmer Analyst (Project Leader)

Andersen Consulting / Grand Rapids, MI March 1994 to Oct 1997

It was our responsibility to provide support to our client. The contract agreement placed several of our employees on site to accomplish this task. It was my responsibility to design, develop and implement changes to their software which was written in RPG. As part of the support provided we trained the employees in the use of the software which had been modified to their specifications.

Senior Programmer Analyst (Project Leader)

Software Alternatives, Inc. / Grand Rapids, MI Mar 1990 to Oct 1994

It was my responsibility as a Senior Programmer / Analyst and Project Leader to provide the necessary training and leadership to the junior programmers. My expertise was strictly on the mid-range system. More specifically I was fluent in all known IBM midrange platforms (S/32, S/34, S/36, S/38, S/3, AS/400.) and their respective RPG levels.

Senior Programmer Analyst (Consultant)

JD Systems, Inc. / Miami, FL Mar 1984 to Mar 1990

As programmer analyst it was my job to provide support to several accounts. The systems that they used included the S/34, S/36, S/38 and the AS/400. My client based covered several vertical markets such as transportation, Legal, Manufacturing, Distribution, Freight and wholesale. Programming language was RPG in all of it's various levels. Most of my clients were law firms so during this time a specialty was developed that included analysis of the various legal matters and tracking of results as well as who presided over each case.

M.I.S. Manager

Transconex, Inc. / Miami, FL Mar 1977 to Mar 1984

Manage the day to day processing of information in the existing Mid-Range system. We had operations in Miami, Jacksonville, New York and Puerto Rico. We also had terminals in the Virgin Islands as well as in California. On this capacity it was my responsibility to interact with all users local and remote providing the necessary training both with the software as well as the hardware.

M.I.S. Manager

Kole Industries, Inc. / Miami, FL Feb 1974 to Mar 1977

Manage the daily operation for this direct marketing firm. The original owners were from Wisconsin and later acquired by the Ivyridge conglomerate based in Philadelphia, PA. Their business was mostly through catalog sales. This being a small shop it was required of my position to manage 5 people, run the computer installation, train the user on the software modifications as well as interact with vendors and the upkeep of the system software enhancements (PTF appications).



Contact this candidate