Rodney L. | Elance
Last Sign-in: Mar 2, 2016

Rodney L.

Expert financial planning, analysis, & modeling
   United States
  |   Media, PA
  |  8:37 pm Local Time


My name is Rodney Lynch, and as principal of Media Financial Consulting I have a passion for what I do: taking incoherent mountains of data and helping business owners make sense of the data to help them make better (and more profitable) business decisions.

The Mission Statement: To provide business owners with expertise that a part time CFO can deliver for companies that can't afford to retain this type of expertise on their company budget.

I am about delivering a experience: the experience of a sound financial understanding of your business model to help you make the best decisions for your business.

This is an ideal situation for businesses who need assistance with understanding their financial situation from someone with Big 4 consulting experience as well as a strong finance industry knowledge.

"The bitterness of poor quality remains longer after the sweetness of low price is gone."
Service Description
What do I bring to the table?

Well to begin with I have 10 years of business experiences in a variety of roles. I began my career as a corporate financial analyst performing a variety of activities: financial reporting, forecasting, budgeting, and ad-hoc analysis.

My experiences in a Big4 consulting firm have helped to mold my skill set greatly Business owners need to be able to navigate through mountains of data and make informed business decisions in a very short amount of time. In the consulting world that is the heart of what they do best. Being outsiders you need to be skilled in quickly getting to the heart of the problem. I've also been able to observe a variety of business processes and models to help determine what truly is world class and incorporate this into my product.

I have earned an MBA with distinction fom a nationally recognized top25 business school.

My expertise is in several areas of corporate finance: business planning, providing development & maintenance of modeling tools, building information databases, financial reporting, peforming analysis on a variety of financial metrics, as well as budgeting and forecasting.

My combination of financial analysis experience and technical skils will allow me to quickly understand and analyze your data and then communicate the output to you in a format that is quickly and easily understandable.
My technical skills are complemented with strong writing skills to deliver a variety of documentation to support any modeling that is developed: business requirements, functional specifications, system process documentation, and user guides.

If you are looking to start a new business and need to construct a business plan I have a template that will help guide in answering all of the questions that someone starting a new business needs to know. From the results you provide to me in the business plan template, and the supporting financials I develop - you will have a rich & comprehensive business plan to that will explain your business in detail to help you understand the workings of this new business as well as impress prospective investors.

I'm customer serviced oriented and I am sure you will recognize this from my strong communication skills and prompt feedback that I deliver.

The complete spectrum of Corporate Finance activities:

Financial Analysis
Business Planning
Business Strategy
Data Modeling

Deliverables to be produced using a variety of the Microsoft suite of products.
Villanova University
Masters of Business Administration
2003 - 2005
Temple University
Bachelors of Business Administration Degree, Magna Cum Laude, Finance
1996 - 1998
Mars Information Services
Business Systems Manager
2001 - 2007
Responsible for effectively managing application support team in the America's region. Worked closely with senior financial officers as well as the Global Application manager to help ensure application meets the business needs. Assisted in development of business processes to support corporate financial submission requirements for North American business units. Managed completion of technical components for same project. Project managed from visioning stage through nurturing of a financial software implementation for 30 organizational entities worldwide both on time and on budget. Managed a team of 4 associates around the global to achieve implementation objectives. Coordinated, assisted in implementing (functional spec design and regression testing) and managed all necessary application model changes to support Corporate financial initiatives for corporate entities and selective revenue units. Responsible for developing functional specifications for new regional interfaces and overseeing all steps necessary to put into production (functional design, hubwork, UAT). Developed all necessary documentation to assist future associates in implementation a Lite version of financial application. Developed formal transition process for new hires on application support team to facilitate key learnings of job responsibilities. Responsible for developing application metrics scorecards in Business objects to be used to identify development areas and assess application teams ability to meet business needs.
First USA Bank
Senior Financial Analyst
2000 - 2001
Responsible for organizing and participating in all Finance Segmentation methodology meetings to produce the most accurate financial results for the bank. Developed new segmentation hierarchy for bank-wide initiative in efforts to more accurately report financials. Assisted in the design of hierarchical segmentation tool (designed in VB) creating a more efficient system for mapping of accounts to their proper segment. Developed Enhanced Pricing Model in SQL to increase efficiency and decrease process time of pricing tables. Designed Pricing database using VBA, Oracle, & Access to allow greater level of detail than what was currently in place. Greatly increased Segment Analysis reporting capabilities by designing and implementing automation of the Financial Reporting process using Visual Basic, SQL, MS Excel, and MS Access. Responsible for infrastructure improvements to the Segment Profitability Model to increase robustness, decrease process time, and automate manual processes using multiple software packages. Enhanced Revenue Sharing model to expand visibility and drill down capabilities.
KPMG Consulting
Financial Information Specialist
1998 - 2000
Responsibilities included forecasting, reporting, & analysis. Instrumental in development of financial reporting methodology and procedures. Worked closely with CFO, Controllers, and senior management in development of reports to manage their respective industries. Responsible for the preparation, review, and distribution of Industry & Departmental P&L. Responsible for Revenue Reconciliation between the General Ledger & Hyperion. Tracked & analyzed Revenue Credits, A/R Aging, and Expense information for managing directors to evaluate their engagements. Created numerous daily, monthly, & quarterly reports for senior management which analyzes business trends and monitor results. Was responsible for managing Suspense Report team in tracking down invalid and miscoded Time and Expense submission (for realignment to proper industries). Assisted in the coordination of the Financial Reporting aspect of the financial close process for the consulting practice. Greatly increased efficiency by assisting in design and implementation by automation of the Financial reporting process using Visual Basic, Business Objects, MS Excel, and MS Access.
Payment Terms
Payment schedule is flexible based upon the size of the project.
Dave Wolstenholme
Chilko Lake Developments, General Manager
Designed budgeting & forecast model to simulate 5 years of Cash Flows using a variety of parameters.
James Farrelly
Centrieve Corporation, CEO
Designed budgeting & forecasting model to help measure cash impacts of business decisions for long term plan (5 years).
Fred Maglione
New Era Tickets, President
Designed MS Excel Workbook to simulate annual net revenues for contracts signed with ticket agency based upon a variety of parameters. "I am hesitant to tell the Elance community about how great working with Rodney was for fear that I wont be able to get my future projects done. In saying that, Rodney far surpassed any expectation that I, or someone in the future may have when looking for an excel expert. His mastery of excel is clear, but more importantly his finance background, fantastic organizational skills and ability to communicate is what really set him apart. For those of you considering offshore assistance, I can assure you that whatever you think you may save, will be lost in the long term. If you want your project done right ,on budget and on time, look no further than Rodney! "
Rodney L. | Elance

Rodney L.