Russell Clemmons Email & Phone Number

Raymore, Missouri

Graphic Design, Screen Printing, Embriodery

Raymore, Missouri

Freelance project management work on process improvement for a Storm restoration company. Collected requirements and current business processes. Designed and implemented a streamlined process for claims procesiing and job status monitoring.

• Implemented RSVP application for E911 record processing and address validation using SCRUM methodology. Replaced two vendor Windows Client based applications with in-house web base developed application, merging address validation of 911 Service Address and record processing for providing ALI record 911 updates to PSAPs . Project provided cost savings of $2 million in software, hardware and record related expenses. Improved user efficiency by providing a single reference point for managing 20K – 25Krequests/ updates daily with access to historical data on entire customer record base of 8 million. o Liaison assisting business customer and SCRUM Master in developing user storieso Translated user stories to requirements and design diagrams for development teamo Created, documented and executed test plan for each incremental deploymento Coordinated and validated data accuracy for database extractso Provided user training for new functionalityo Lead Analyst in development and management of End to End test plan for users, developers and system support• Implemented automated process of file transfer and retrieval for E911 ALI updates and errors accommodating multiple protocols (FTP, sFTP, HTTP, email client). Integrated Windows Client functionality running on a desktop PC into RSVP application. Improved efficiency in time savings of 3 – 4 hours daily and cost savings by the elimination of hardware and software expenses.o Elicit requirements , document requirements and provide test caseso Identify, configure and load test environment data for positive and negative test scenarioso Execution of unit, system and regression testing• Analyze and identify opportunities for increased production and efficiency and provide possible remedies• Work as subject matter expert for RSVP application and E911 industry standards• Monitor trouble tickets and triage to determine if development is required• Create and execute SQL queries for data management and extracts

• Implemented ALI Record Processing System (ARPS) for Cable Operations E911 record processing. New business unit to handle E911 processing on behalf of multiple Cable Companies digital phone service. Cable E911 functions needed to be separated from Sprint local E911 operations in 90 days. Deployed ARPS, a Windows Client based application with SQL Server database in 73 days, allowing a window of dual processing time for data accuracy validation.o Created and submitted RFP (Request for Pricing) on E911 record processing solutionso Reviewed RFP responses and created an overview for management with recommendationo Documented and communicated business requirements, functional requirements and test caseso Secured hardware required based on vendor requirementso Created, validated and loaded data extractso Developed and documented a procedure to install Windows client for 40-45 userso Created and executed end to end functional test cases• Vendor management of application support and enhancements, invoice usage to actual usage reconciliation • Analyze and identify opportunities for increased production and efficiency and provide possible remedies• Work as subject matter expert for ARPS application and E911 industry standards• Application support/administration for ALI Record Processing System• Provide First level support to E911 Operations Team for issue reporting, analysis and resolution

• Implemented Service Order Interface (SOI) for E911 record processing and management. Integrated multiple platforms (Mainframe, Desktop, AS/400, UNIX) operating in multiple regions with varying standards into a single application. SOI presented a user friendly interface to view and manage approximately 15 million 911 customer records across the country.o Elicit requirements, document requirements and provide test caseso Document, coordinate and execute data migration plano Configured database tableso Managed vendor progress to keep on task, in budget and on schedule via weekly conference calls and monthly onsite meetingso Developed user guides and provided detailed training sessionso Managed post deployment vendor relations for issue tracking / resolution and quarterly enhancement deployments • Work as subject matter expert for SOI application and E911 industry standards• Developed and maintained 5 year system evolution plan based on 911 industry guidelines• Analyze and identify opportunities for increased production and efficiency and provide possible remedies• Provided first level support to internal/external clients/customers for problem reporting, analysis, and resolution.• Maintained E911 informational Intranet site.

• Lead Analyst in the creation and documentation of Year2000 E911 system contingency plano Coordinated documentation of requirements from PSAPs, internal users, developers and system supporto Scheduled and managed contingency plan test runs o Monitored the Year2000 events for each time zone to determine is contingency plan needed to be activatedo Communicated with each impacted party to validate all systems were operational • Implemented process for reporting and tracking SLA (Service Level Agreement) requirements dictating that each 911 record is updated in the ALI database within 48 hours of line service installation. There are financial penalties paid for non-compliance, with the exception of scheduled system outages.o Project Lead for identifying impact points and data elements required for accurate reportingo Elicit requirements from all impacted applications, document requirements and create a test plano Created and executed SQL scripts to produce daily status reports • Manage the 911 data integrity for 3 million 911 customer records in nine States.• Work as subject matter expert for E911 industry standards.• Worked with 911 addressing agencies at the City, County and State level on conversion projects from Basic 911 to Enhanced 911 territories.• Worked as SME representing Sprint for 911 PSAP database upgrades and new installation projects.• Maintained E911 informational Intranet site.

• Lead Business System Analyst for project to consolidate E911 processing functions performed in 8 operation centers across the country into a single operation center. This effort resulted in financial savings of approximately $500,000 annually with the reduction in workforce of 8 in addition to retiring outdated hardware and software.o Document processing requirements for each operations center o Schedule and manage each operation center transition without impacting daily processingo Communicate with each PSAP impacted to establish a testing scheduleo Integrated each operation center incrementallyo Verified each transfer and validated the data• Implement 911 File Gateway Server to automate E911 ALI update processing. Accommodate changes in the 911 industry with advances in technology. Replace outdated dial up processes with FTP transfers. This project resulted in time savings by using network technology instead of dial up connections, which also reduced cost by eliminating the need for software licenses.o Identify the PSAP locations with capabilities to utilize the enhanced process functionso Created and documented setup guide for the PSAPs to use in preparing for the new processo Provided individual assistance for setup and functionality training. • Maintain and manage schedule for 911 data transfers to approximately 150 locations throughout 18 States utilizing multiple protocols.• Provide first level support to internal/external clients/customers for problem reporting, analysis, resolution.• Manage system/application enhancement testing, deployment, and E911 Intranet site.• System administration for Windows NT Server, AS/400, RISC600, E911.

Education record

Education record