todd parker

* Supported the analytical needs of the SPARTON system through SQL development within MS SQL Server 2008 and MySQL environments * Created simple/complex SQL queries, statements, functions, views, rows, tables, etc. * Compiled and analyzed production / financial information to prepare reports for engineering team via SQL 2008 Reporting Services * Conducted audits for SPARTON team to assess effectiveness of controls, accuracy of data records, and efficiency of operations * Assisted in the preparation of periodic forecasts/budgets for Scholastic Book Fairs operational capital funds * Identified areas of concern and presented proposed solutions to senior operations management teams * Organized and documented financial analyses and prepare recommendations for implementation of new systems, procedures or organizational changes * Tracked expense and inventory items and verified reporting based on accrual based accounting system * Contributed to planning, forecast and trend analysis * Projects and other duties as assigned

* Handled the maintenance of internal and client databases in FoxPro format * Performed manipulation and conversion of client data in a variety of applications per internal guidelines utilizing SQL and FoxPro * Handled the presorting of letters and flats for targeted mail marketing campaigns * Lead communication efforts with other departments that included clients, sales personnel and print shops * Planned and developed an intranet website for the use of Direct Mail USA that outlined detailed instructions for every job description in the Information Technology department * Additional responsibilities included National Change of Address (NCOA) processing, maintenance of customer profiles, maps, fulfilling customer research requests and network archiving * Software used: FoxPro 2.5 for DOS, SQL, Mail Manager 2010, DataRight Views 2.52a, ACE Views 6.0a, Merge/Purge Views 5.40a, Presort Views 5.75b, Microsoft Access

* Developed web-based scripting, data validation, and data capture methods utilizing JavaScript and Microsoft Front Page for the use in telemarketing campaigns * Developed stored procedures for data file creation and transfer via Microsoft SQL Query Analyzer * Planned, developed and tested procedures to manipulate data per client or internal project requirements utilizing FoxPro 2.6 for Windows, FoxPro 2.5 for DOS, Visual FoxPro 6.0, Microsoft Excel 2000 (macros VBA), Visual Basic 6.0 * Acted as Information Technology project manager on assignments that required analysis, planning, building and implementing data structures and process flow * Processed client sales leads to meet internal company requirements and then applied that data into various telemarketing campaigns via SQL utilizing Microsoft Enterprise Manager, UNIX, and other proprietary software * Other data procedures included the maintenance of federal, state, and local “do not call” lists and the subsequent removal of that data under strict policy

* Configure, provide technical support and administration for multiple in-house software applications as well as create and format various SQL reports. * Key Responsibilities * Troubleshooting and end-user support for various in-house software products. * Write ad-hoc reports using SQL and PL/SQL. * Administration of users/passwords for software applications. * Business process analysis and configuration of various software applications. * Write and maintain programming documentation. * Maintain confidentiality with regard to the information being processed, stored or accessed. * Work with business analysts to determine user requirements.

Activities and Societies: Tennis