•Key resource in development of the Consumer Strategic Five-Year Forecast •Develop financial models with a high level of sophistication that allow for creating multiple scenario analyses and respond quickly to changing•Projections to include line growth, profitability, Capital Expenditures, Free Cash Flows, Net Present Values and Internal Rates of Return•Organize the results of model in a clear and concise report for ease in interpretation•Work closely as trusted resource for those with budget responsibility to identify key drivers of the businessLead financial analyst for many key projects that are critical to the long-term success of TDS Telecom, including the following recent projects:1. IPTV Expansion•Developed all financial modeling to assess the viability of expanding IPTV into new markets2. Broadband Stimulus•Developed all financial sections for 46 government applications to Rural Utilities Service to receive funding to expand DSL service to unserved areas•42 applications approved resulting in over $100 million in government grant fundingAid in the Budget Process and Management Reporting•Perform required research for the analysis and model creation by interviewing subject matter experts•Organize data spanning 250+ cost centers for 130+ expense account categories on an annual expense budget greater than $100 million •Determine the key drivers by working with expense owners and develop drivers with own research when experts were uncertainKey financial resource for Business Development for acquisitions•Organize and interpret data from potential acquisition target to assess viability and synergies to determine proper valuation Assist with other management accounting and budgeting responsibilities as neededExpert Microsoft Excel and SAP user and have become a resource for all Excel related questions4-time nominee and 2-time winner of TDS Telecom’s Inspiring Excellence award

Special projects as directed from Corporate Executive Leadership Team•Critically analyze information from business units for potential major projects for a Fortune 500 company greater than $10 million ~or~ strategically important to the future of the firmLead the financial modeling for a team of 15 for a critical decision and future direction of the entire firm in 2005 Aid in the Strategic Five-Year Forecast, Quarterly Forecast and Preliminary Budget Process•Review financials for completeness and reasonability •Research unusual items with other departmentsDevelop and support the standard business case projectManage of business case review processAssist with other management accounting and budgeting responsibilities as needed

•Analyze financial reports utilizing spreadsheets, databases and teamwork using tools Excel, Oracle and Discoverer•Create Excel spreadsheets to show DoIT’s profitability resulting from Product Management in addition to organizing financial figures into like formats for comparison purposes•Aid Product Managers in budgeting, product line additions/deletions, breakeven analysis and general financial understanding

•Influenced physicians’ decisions to prescribe products resulting in achievement of sales and market share goals•Communicated key selling messages to targeted customers with frequency and implement promotional strategies for four distinct products, which include neuroscience and anti-microbial medicines•Managed results of sales process, demonstrating personal accountability and commitment to achieve objectives•Participated in the successful launch of two new products brought to market in 2000

Analyzed credit union membership for pre-qualified direct mail loan promotionsUtilized PowerStation database program and UNIX database to segment membership primarily by geo-demographic data to select highest propensity respondersCreated Return on Investment template to illustrate results of individual campaignCreated Excel spreadsheets to show CUNA Mutual's profitability resulting from all campaigns and summary sheet to display all individual campaign's successOrganized and monitored several campaigns at different stages within the processAssisted CUNA Field specialists in communicating the benefits of the program to the Field and to the Credit Union

Analyzed bank accounts of over 150 financial accounts totaling $125 to $200 million covering over 20 companiesOriginated several process improvements resulting in fewer hours required to complete duties, decreased expenses and significantly increased revenuesPerformed analytical reporting utilizing complex spreadsheets and databases