ATLANTIC CITY, NJ, USA
19 days ago
Product Specialist - DB2
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
Confirm your E-mail: Send Email