Derrick Stephens Email & Phone Number

Little Rock Area, Arkansas

Client server application debugging and modification. Writing stored procedures in Microsoft sql.Writing batch programs in Microsoft sql.Responsible for defining, implementing and maintaining the functional business logic of various batch processes.Responsible for Analysis, Development, Documentation and System Testing of various Maintenance tickets.Responsible for code review of new SQL code for performance and adherence to coding standards.

Application development in korn shell, Oracle SQL, Ab Initio, and perl.Developer/Designer and Subject Matter Expert for our Customer Data Integration process.Data Analysis and User Requirements.ETL process design and maintenance.Develop adhoc production processes for the client upon request.

Application/report development and batch testing in SQL Server 2000.Team Leader for a five-member team responsible for the maintenance of existing daily, weekly, monthly, quarterly and annual reports. Responsible for the design, development, testing, documentation and implementation of new reports requested by the client. Maintenance and support of Federal Reports. Responsible for defining, implementing and maintaining the functional business logic of batch processes.Lead data quality control audits to capture and correct data errors.Provided client with a business solution for their billing process for a realized savings of over $150,000 in postage the first year.Re-designed billing program, reducing the run time from 8 hours to 45 minutes.Presented a Cost/Benefit Analysis for a new payment processing system for a client, which led to the development implementation of the system. Involved in the design, development, documentation, testing and implementation of the system. The new system allowed the client to reduce resources by 50%, increase document imaging from 45% to 100% and increase productivity to meet federal regulations. Created applications for the payment processing center which improved reliability and accuracy of payments submitted by various employers and other state government agencies.Designed and coded, using Xerox JDL, custom forms for billing and special mailings. Billing forms included mixed set logic using barcodes to determine package groups and page numbers for accuracy.Involved in the design, development, documentation, testing and implementation of the first web-based federally certified Child Support Enforcement System in the country. Designed an address standardization module for the client to use with all address entry interfaces. This module improved address standardization, reduced redundancy, and improved data reliability. Implemented batch processes with all external interfaces to maintain data integrity.