SQL Server data programmer.

Consult regularly with customers on project status, proposals, and technical issues. Conduct application testing and provide database management support. Develop computer systems specifications that address business requirements and that fit with company/customer system architecture standards. Analyze and evaluate existing or proposed systems and design computer systems to process data. Review systems and procedures to refine their formulation and convert them to programmable formats. Create logical data models based on functional requirements. Perform quality assurance review of specifications. Troubleshoot and provide technical support and solutions to users. Analyze detail systems factors, including input and output requirements, information flow, hardware and software requirements, and reliability characteristics. Monitor system effectiveness in satisfying user needs.• Worked closely with clients to develop daily workflow screen that merged information from several printed reports into single screen, increasing user efficiency and reducing errors. • Converted US mail solicitation order forms to email, saving clients thousands of dollars in processing and mailing costs.• Directed team to develop E-commerce solicitation website, achieving the goal of improving the order and payment process.• Managed team to convert software from MySQL database to Microsoft SQL Server, performing an analysis of the existing database structure and developing a conversion plan.• Performed enhancements to client’s GM account electronic billing interface by working with GM billing liaison, addressing changes to their electronic interface, and required pre-installation tests, and implementing the changes to the production environment.• Developed sub-system to track local search advertising for Starcom Mediavest Group, meeting with, eliciting, capturing and documenting requirements from the client’s digital advertising team.

Provide on-site consulting services to a West Chicago, IL Marketing Agency.