Keith Tedder Email & Phone Number

Tallahassee, Fl, Us

Mclean, Virginia, Us

Extract data, using SQL, from multiple tables to analyze errors, cleansing, and system issues. Pull data queries for comparison between tables to ensure accuracy and completeness of financial data prior to providing expenditure reports to client. Extract data from multiple tables simultaneously ensure accuracy between data in tables and prepare spreadsheets for developers to utilize for inserting correcting transactions into the tables. Run financial reports, twice monthly, from MicroStrategy to provide to Client. Extract pending refund transactions for approval by client, and once approval obtained provide client with coversheet for final refund transactions. Validate and reconcile trial refunds file to final refund and subsequently validate accuracy of check number file provided by client.

Serving as a consulting capacity for Disney Cruise Lines. Providing a system analysis to provide Disney with information to assist them in making the decision to replace an outdated critical accounting application. Identifying the requirements for the current state; how the current application is being utilized. Eliciting requirements to determine the gap between the outdated application and the current needs. Researching upstream and down stream applications to identify all inputs and outputs of the current application. Develop recommendations for the replacement of the current application.

Document the project information, product features, business requirements, functional requirements, use cases, process and wireframe diagrams, screen mockup, and identifying the traceability of the requirements, features, screen mockups, use cases, and process diagrams using Blueprint Requirements Management Software. Facilitate collaboration meetings between business/process owners, systems analysts, other business analysts from other areas of the organization, project managers, and testing staff to review the documented requirements and identify any issues that need to be resolved before development and/or implementation. Facilitate the documentation of the business and functional requirements from business analysts in other areas of the organization into the Blueprint Requirements Software repository. Assist other business analyst with research into issued needing to be identified and/or resolved

Served in a project leadership role to develop and maintain project plans, using MS Project, to track system changes and enhancements for multiple tax filing applications. Facilitate requirements gathering sessions, in a group meeting environment, individual meeting, and via electronic media. Developed business, functional, user, and system requirements documents and coordinated development with internal staff and contracted software developers. Complete research to determine "root cause" of issues related to taxpayer data problems or system shortcomings or inaccuracies where incorrect information was systematically provided to taxpayers when attempting to electronically file tax returns. Test application development for accuracy and completeness to business and functional requirements. Provided management with reports and updates on regular projects and special projects.• Identified and documented requirements for a new tax return application, including the implementation of electronic payments via ACH Debit (e-Check) and credit card payments. • Assist with the development of a “Payment Only” application for accepting ACH debits and Credit Card payments for DOR tax payments and payments for other agencies.• Assist and provide input for the inclusion of payments for taxes not managed by the GTA section.• Develop and present a solution, to management, to provide a new front-end, single sign-on for the for all current tax applications requiring a separate User ID and password for the individual tax filing applications

Santa Ana, Ca, Us

Local Project Analyst working with First Am's Optimization Team headquartered in Phoenix, AZ. Developing process maps, gathering requirements, and documenting procedures for the outsourcing of several processes from the local Financial Service Center to an off shore Service Center.

Sunnyvale, Ca, Us

Initially assigned to map current report data elements for integrating with the BI tool Microstrategy. Facilitated business and functional requirements gathering sessions, including JAD sessions and meeting with individual stakeholders. Documented the business and functional requirements, including logical work flow diagrams, data flow diagrams, and developing use cases for QA testing.Determined requirements to initiate data aggregation advertising performance data. Documented requirements to move the data loading from a MySQL database to an Oracle database.Provided a mapping of individual data elements for complex accounting calculations for dynamic performance measures.Identified a method for initiating a dynamic exchange rate process for entities using currencies other than USD.

Initially assigned to determine and document business and functional requirements for current accounting processes in order to comply with audit requirements. Facilitated requirements gathering sessions, including JAD sessions and meeting with individual stakeholders. Provided requirements to enhance several accounting and reporting processes, including logical work flow diagrams, data flow diagrams, and developing use cases for QA testing.Developed baseline business and functional requirements for an adjustment tool for accounting database.Documented requirements for a month-end closeout procedure including a reconciliation tool to ensure accounting standards are maintained within the reporting database.

Tallahassee, Florida, Us

Managed securities portfolio that grew to $80 million. Managed accounting staff of 10 professional and non-professional positions. Managed the program's accounting processes for up to $170 mil receipts and $100 claim disbursements, as well as the program budget of up to $7 mil. this included budgeted funds for a new computer system. Trained accounting staff and other groups in securities related issues. Developed and evaluated “Requests for Proposals” for contracted services. Testified at legislative hearings when necessary.Managed the almost 100% growth of receipts and disbursements Developed and maintained performance based budget initiativesProvided business and functional requirements for the accounting module for all cash receipts, securities receipts, securities transactions, securities liquidations and disbursements for the new computer system.Identified business and functional requirements for an auction module for the liquidation of physical contents of safe deposit boxes.Maintained an excellent working relationship with outside contractors.Spoke at training seminar

Managed securities portfolio of up to $40 mil. Developed and maintained policies and procedures for the processing securities from receipt through liquidation or claim disbursement. Recommended and implemented statutory and procedural changes. Prepared and reviewed “Requests for Proposals” for contractual services. Ensured all corporate transactions are posted accurately and efficiently to provide claim payments of cash and securities. Trained accounting staff and other groups in securities related issues. Managed a growth in the number of Mutual Fund and DRP accounts, in excess of 400%, being received by the program, using linked EXCEL spreadsheets.Provided functional requirements to enhance the computer system, to manage the growth of the stock and bonds received by the program. Developed and maintained an excellent working relationship with the outside contractor for the liquidation of the securities.

Bs, Mathematics/Business

Certification, Business Systems Analyst