First off, you should follow the Blog tutorial on the CakePHP cook book : http://book.cakephp.org/view/1528/Blog
It's a great example and walks you through all the main stuff.
In your example
www.example.com/profile, if you haven't changed the default routing, actually maps to the
index method in your
ProfileController. This method uses the view in
/views/profiles/index.ctp to display output.
First follow the tutorial and read up on the CookBook to figure out what all this means. It's very easy to learn and they have some good documentation. Also check out code generation in CakePHP. It helps you create your apps faster (if used properly).