Product Specialist - DB2
Hire IT People, LLC
Job Seekers, Please send resumes to resumes@hireitpeople.com Short Description: The Employee License System (ELS) is used by both Division of Gaming Enforcement (DGE) as well as the Casino Control Commission and the goal of this project would be to generate detailed design documents by examining source code for the ELS system.
Complete Description: Overview:The employee license system is used by both Division of Gaming Enforcement (DGE) as well as the Casino Control Commission (CCC) staff to capture relevant information regarding casino employee licensure. The system was developed on an IBM i server and enhancements were incorporated in 2000 to accommodate digital pictures and signatures and allow the system to generate digitally created credentials. The below list briefly describes the functionality provided by the current system:• Process initial casino employee license application.• Process renewal of casino employee license applications. • Collect digital pictures and signatures that allow the system to generate digitally created credentials. • Process informational changes submitted by licensees (e.g. changes of address).• Replace lost credentials• Identify licensees required to resubmit.• Collect/ Identify licensees Citizen Status• Collect/ Identify licensees fingerprint information.• Generate the appropriate lists and letters.
Scope of Work:The current system does not contain adequate documentation and the primary goal of this project will be to derive detailed documentation including Design Specification Document (DSD) as well as database schema, from analyzing source code. The source code is written primarily in IBM RPG IV but overall understanding of related technology is also needed including OS400 operations and DB2400. Database has been compiled using IBM data description specification (DDS). The flow of information for the system can be divided into two processes, namely, the initial process and the renewal process and the basic workflow is shown in the below diagrams. The end result of this project will be to fully document in detail the application flow by examining source code.
PROJECT DELIVERABLE'S:The deliverables for this project will be a set of documents that will fully explain the workings of the Employee License System and will include design specification document (DSD) and database schema. The DSD will include, at the least, functional specification as well as an overall architecture of each module. The deliverables will be broken down into the initial and renewal cycle and a set of corresponding documents will be handed over to CCC for review, testing and signoff.
Work breakdown structure: Scope assessment Initial meeting and review of scope - 2 day Analyze requirements and signoff on project schedule and deliverables - 2 day Initial licensing flow analysis Analyze current system and iteratively document and test findings - 40 days Finalize documentation - 3 days Signoff on Initial licensing process documents - 2 day Renewal licensing flow analysis Analyze current system and iteratively document and test findings - 40 days Finalize documentation - 3 days Signoff on Renewal licensing process documents - 2 day Finalize Signoff on project and close - 1 day
Employee License Documentation Total Estimate - 95 days
SkillRequired / DesiredAmountof ExperienceRPG IV, ILE RPG, Free form RPG and Embedded SQLRequired6YearsDB2 400 including SQL, stored procedures and triggersRequired6YearsIBM i serverRequired4YearsTechnical writing skillsRequired4Years
Complete Description: Overview:The employee license system is used by both Division of Gaming Enforcement (DGE) as well as the Casino Control Commission (CCC) staff to capture relevant information regarding casino employee licensure. The system was developed on an IBM i server and enhancements were incorporated in 2000 to accommodate digital pictures and signatures and allow the system to generate digitally created credentials. The below list briefly describes the functionality provided by the current system:• Process initial casino employee license application.• Process renewal of casino employee license applications. • Collect digital pictures and signatures that allow the system to generate digitally created credentials. • Process informational changes submitted by licensees (e.g. changes of address).• Replace lost credentials• Identify licensees required to resubmit.• Collect/ Identify licensees Citizen Status• Collect/ Identify licensees fingerprint information.• Generate the appropriate lists and letters.
Scope of Work:The current system does not contain adequate documentation and the primary goal of this project will be to derive detailed documentation including Design Specification Document (DSD) as well as database schema, from analyzing source code. The source code is written primarily in IBM RPG IV but overall understanding of related technology is also needed including OS400 operations and DB2400. Database has been compiled using IBM data description specification (DDS). The flow of information for the system can be divided into two processes, namely, the initial process and the renewal process and the basic workflow is shown in the below diagrams. The end result of this project will be to fully document in detail the application flow by examining source code.
PROJECT DELIVERABLE'S:The deliverables for this project will be a set of documents that will fully explain the workings of the Employee License System and will include design specification document (DSD) and database schema. The DSD will include, at the least, functional specification as well as an overall architecture of each module. The deliverables will be broken down into the initial and renewal cycle and a set of corresponding documents will be handed over to CCC for review, testing and signoff.
Work breakdown structure: Scope assessment Initial meeting and review of scope - 2 day Analyze requirements and signoff on project schedule and deliverables - 2 day Initial licensing flow analysis Analyze current system and iteratively document and test findings - 40 days Finalize documentation - 3 days Signoff on Initial licensing process documents - 2 day Renewal licensing flow analysis Analyze current system and iteratively document and test findings - 40 days Finalize documentation - 3 days Signoff on Renewal licensing process documents - 2 day Finalize Signoff on project and close - 1 day
Employee License Documentation Total Estimate - 95 days
SkillRequired / DesiredAmountof ExperienceRPG IV, ILE RPG, Free form RPG and Embedded SQLRequired6YearsDB2 400 including SQL, stored procedures and triggersRequired6YearsIBM i serverRequired4YearsTechnical writing skillsRequired4Years
Confirm your E-mail: Send Email
All Jobs from Hire IT People, LLC