Hi there

Welcome to the ILoveOracle website!

I want to introduce myself; my name is Aidan Duffy, and I have been making my living as an Oracle Functional consultant, working for Multinational companies across Europe and US since 1999. I’ve had a book on Oracle Consulting published by Oracle corporation and built a very successful career as an Oracle Functional Consultant.

Right now, I’ve reached the stage in my career where I want to give something back, so I have to let you know a few things about the Oracle Consulting world ( if you are not already aware)

  • I have made over 2.5 million USD in a 15 year career, that’s over 160k per annum on average
  • I do not know of another job that pays as well for what you actually do – most country presidents do not get paid as well
  • I used the same skills I had as a permanent employee to get my first Oracle Functional consultant role and built from there
  • While I was earning I got paid to train myself on latest Oracle EBS application releases and tools
  • I got paid to travel and live around Europe and in USA, working as an Oracle Functional Consultant in great locations such as London, New York, Amsterdam, Brussels, Frankfurt, Prague
  • I work 10 months of the year max, I could work far less if I wanted to
  • I built my career from Oracle technical developer to Oracle functional consultant to project manager with no impact on my earnings while I did it

If you are a

  • Permanent staff member
  • Big 5 consultant
  • Working Offshore
  • IT professional who wants to cross over to Oracle functional

then this could be the career for you!!

After working for 15 years I have been helped along the way by many experienced consultants, and now it’s my turn to help you, so why don’t you  read this online course by signing up here

The course will explain

  • Why you would want to become an Oracle Functional Consultant(if you need more convincing)
  • What Oracle Functional Consultants do
  • How you can pick up the required skills
  • What if you were a successful Oracle Functional Consultant

Regards,

Aidan Duffy.

P.S. As a bonus, I’m including a few Free chapters of my book “The Oracle Opportunity – A Blueprint for Success as an Oracle Consultant. The book was published in 2012 by Oracle corporation as they were, like me, looking to help the Oracle consultant community.

 

White_Book_Cover

P.P.S. I’m also excited to to offer you some cool bonuses! These bonuses will increase your Functional skillset as there is one bonus for each skill in the Functional Consultant Skillsets. Once you confirm you are joining the list, just tell me which bonus you are interested in, and why, and you will be on your way to increasing your functional skillset

  • System Features – Work Instructions for Accounts Receivable Creation
  • Process Knowledge – Receivables Monthend Process diagram
  • Technical Skills – Sample from my SQL for Ebusiness course
  • Testing – 5 things I know about EBS Testing framework
  • Solution Design – Functional Design for Accounts Receivable Customer Report
  • Oracle Configuration – Accounts Receivables configuration BR100 extract

 

All you have to do is click here and join the ILoveOracle community for the free book chapter and some cool bonuses.

P.P.P.S. I’d be delighted to answer your questions in the comments below, please connect with me on Linkedin, and add your linkedin profile in the comment so I can see your background…

148 thoughts on “How to Become an Oracle Functional Consultant/Business Analyst

  • April 5, 2016 at 15:29
    Permalink

    Hi Aidan ,

    Nice to mail you !!!

    I was working as Oracle developer for three years and then Applicative DBA for three years and i am certified professional in Oracle DBA and Oracle Programming and i worked in DWH environment fully and i know all those structures program and database (am working in MNC).

    Whether Oracle consultant/Oracle Business Analyst am capable ?
    And can you suggest how to make my career strong ?

    Regards
    Navan

    Reply
  • April 4, 2016 at 14:16
    Permalink

    I am having almost 20 years of accounting experience under diversified industries at various levels, branch, regional, HO. I am currently into BA role in IT dept. I am looking forward for this course ( Oracle financial-functional) and take this as a career going forward. I am a semi-qualified accountant with MBA (finance) as educational qualifications. Your advise on my plan, as an expert in this field will help to take this ambitions forward. Thanks….

    Reply
    • April 5, 2016 at 17:07
      Permalink

      Hi Hari
      Thanks a lot, accounting and BA experience is perfect for Oracle financial functional. Please engage by replying with questions to the emails.
      Aidan .

      Reply
  • March 27, 2016 at 19:17
    Permalink

    Hi Aidan,

    Very helpful website for better future career growth. Appreciate your efforts!
    I am having total 10 Years of experience, worked with IBM, TCS and other MNC’s in India. Presently I am working as a Sr. Oracle Finance Functional Consultant in IT Consulting Firm since last 2 Years, previously for 6 Years I was working in Oracle 11i & R12 as a end User in Finance Modules like AP, AR, FA, GL & CM. Right now I am getting offers from other big financial services Companies and some reputed Manufacturing Companies to work as a ‘Oracle Business Analyst’, but I have not yet accepted the offer because I am very much confused. I need your help seriously.

    Can you please let me know for getting opportunities for better salary packages and working for different international Countries, which profile would be better as a ‘Sr. Oracle Functional Consultant’ or as a ‘Oracle Business Analyst’.

    Please reply at the earliest.

    Thank you for your co-operation!

    Regards,
    Shahnoor

    Reply
    • March 31, 2016 at 10:49
      Permalink

      Hi Shahnoor

      I’m part of a Whatsapp discussion forum and this question was asked recently “what is the difference between a functional consultant and a business analyst”. Its an international group, there were different opinions and no clear answer. In mainland US, and some international offices for Multinational companies BA is the term used, whereas in Europe functional consultant is more popular. you could also say functional consultants implement, whereas BA’s work in post go-live, analyzing in stable environments. Perhaps BA’s are more associated with process activities than functional consultants, and functional consultants usually work for system integrators, like Big 4, smaller consultancies or independents(like me)
      You could check out the job listings per country to see what the job titles and associated job specs mean but I fear you will not get a consistent answer.
      Really you need to see what is in the spec, compare it to your skills and take it from there.
      Regards,
      Aidan.

      Reply
      • March 31, 2016 at 11:17
        Permalink

        Thanks Adian for your reply!

        I am still confused, I didn’t got the answer clearly. If you don’t mind can you please let me know shall I work as a ‘Sr. Oracle Functional Consultant’ or should I take offer from Financial Services Company as a ‘Oracle Business Analyst’ because my aspiration is very high and I want to go abroad and settle .Therefore I had decided to move from Finance End User to IT role purely as a Oracle Functional Consultant after 8 years.

        You just let me know if I will accept the offer as a ‘Oracle Business Analyst’ which I am getting, is it good for future aspects in terms of higher salary and growth or not for Gulf & USA, UK, Canada or any other international Countries.

        Please suggest.

        Regards,
        Shahnoor

        Reply
        • March 31, 2016 at 15:51
          Permalink

          Hi Shahnoor

          I don’t know the prospects and salaries per country as I’ve not done the research, I’m leaving that up to you! I would guess in the European market the roles are probably split 90% functional consultant, 10% BA.

          One company might call the same job BA or functional consultant, there is no universal guideline on what the job term is. In the whatsapp group I mentioned there is no concensus on what both job roles do, or which is better.

          So I don’t think it matters really.

          Reply
  • March 24, 2016 at 22:20
    Permalink

    Hi Aidan,
    I am working in computer /end user support from last 15 years.I wanted to change my career.Is orcale financial consultant will be a better choice?

    Reply
    • March 31, 2016 at 10:52
      Permalink

      Hi Haroon
      You haven’t given me a lot of information to make a recommendation. You can get support jobs for any system, Oracle financial consultant is related to Oracle only of course, so there are a lot less roles, and more competition. Are you tired of support?
      Regards,
      Aidan.

      Reply
  • March 18, 2016 at 13:44
    Permalink

    Hi,

    I am so glad to come across your website. This is my objective below. Can you help in the best route to take to achieve this please. I will also connect with you on linkedin. Thanks

    With over 15 years experience gained working within the IT, Finance, Housing and Banking sectors, I have realised my strength is particularly in transforming business processes.
    I am a dynamic IT/Finance professional (ACA Qualified Accountant and a grad of Computer Science). I am enthusiastic, skilled and a dedicated professional who enjoys being part of a successful and productive team. An effective ITIL qualified troubleshooter with the ability to quickly isolate and diagnose faults in accordance with Service Level Agreements.

    I have been actively involved in transforming the Oracle Purchase to Pay Process, the Anydoc/Basware Scanning Process, and the Swordfish Document Management Process for The Guinness Partnership.

    I possess excellent interpersonal skills and communicate well at all levels consistently providing a high standard of customer care and support. I particularly enjoy transforming customer vision into design reality and I am confident in finding quality solutions to business problems within scope, on budget and within tight schedules using my skills.
    I have a strong track record of managing multiple projects and assimilating and utilising new technologies, the focus of which is now shifting towards wanting to make a significant contribution within a Business Analyst role

    Reply
    • March 20, 2016 at 16:17
      Permalink

      Hi Aidan,

      I tried to sign up for the course but not sure what happened. I will try again
      I need some directions and guidance on how to become an Oracle Functional Consultant / Business Analyst. I currently support Oracle(mainly P2P and user administration) as one of many applications used by my organisation but I really desire to specialise as an Oracle Consultant.

      Reply
  • February 22, 2016 at 20:39
    Permalink

    Hi Aidan – It looks like when I read your website I felt like I am very close to what I am looking for. Please take a look at my profile and let me know what you think. I have worked for 9 years as a technical Oracle ERP applications consultant. I am not satisfied with overall technical and feel that I am missing something. Can you please advice how it would be if I switch to more of a functional consultant.

    Reply
    • February 24, 2016 at 16:49
      Permalink

      Hi Nagarjuna

      It seems like you feel the same way I did. I was quite tired of technical work, even though I was very good at it, and wanted to get more client-facing experience,. I wanted to figure out real business challenges, not just do technical work at my own desk all day. I transferred from technical into functional(without changing client), and then project management, so it can be done. Another of my PM colleagues made the same transformation, and so can you.
      In my first functional role it was difficult as I literally didn’t know what was coming next phase of project. I remember going to one meeting with exactly 90 seconds preparation from the solution architect “this is what you are going to be talking about”, and not surprisingly the meeting didn’t go too well. I soon learned what was required though, and I’m still with the same client today, 8 years later.

      You should transfer into functional using your technical skills as a base, and develop the other key functional skills from there. Have a look at this post which details the six key functional skills
      http://iloveoracle.com/oracle-consultant/functional-consultant-launch-formula-6-key-skills-of-a-functional-consultant/

      How many of these skills do you have already?
      Regards,
      Aidan.

      Reply
  • February 8, 2016 at 20:22
    Permalink

    Hi Aidan,

    EBS Testing was amazing.It was really helpful.
    Please let me know how we test interface in a step by step process.

    Regards,
    Murali

    Reply
  • February 1, 2016 at 12:53
    Permalink

    Hello Aidan,

    I’m working has a Technical Support Representative and I would like to know if I can change my domain to Oracle ERP consultant after completing a course in the same and would my experience come in handy?? I have completed my Engineering in Computer Science.

    Regards,
    Kavya

    Reply
    • February 3, 2016 at 13:48
      Permalink

      Hi Kavya
      Can you provide your linkedin profile or a detailed list of your skills so I can make a better judgement?
      Regards,
      Aidan.

      Reply
  • January 23, 2016 at 16:57
    Permalink

    Hi Aidan

    I have been a business analyst, with flavorful experience on different applications in retail, banking etc. I want to pick a specialization like Oracle HCM and want to be a functional consultant. You are a guru, so can you guide me how to get into such roles? I looked at oracle trainings that they offer .. Will that alone help me to find a job into it?

    Thanks
    Ria

    Reply
    • January 26, 2016 at 11:05
      Permalink

      Hi Ria
      At a high-level your approach should be to combine your BA experience, and associated training in the same area. Have you applied for functional roles? What are they looking for? Training alone will not guarantee a role, but combined with BA experience you should be a good candidate. Can I see your linkedin profile?
      Regards,
      Aidan.

      Reply
  • January 21, 2016 at 23:32
    Permalink

    Hi Aidan,
    I love Oracle as well. I have worked in the distribution/warehouse area for greater than 39 years with about 30 years in a management role. I was fortunate to have been asked to leave the warehouse to be on an ERP project on a team of business users and IT to replace our legacy systems with Oracle in 2004. I represented all of our warehouses globally to install Oracle WMS. I spent 6.5 years on this project. It was very challenging, yet extremely rewarding. This project included requirement gathering, configuration/set up, integration/regression/user acceptance testing, and successful global implementations. I am considered an Oracle WMS Superuser. I no longer work for this company and I am interested in being a functional consultant, sharing my knowledge and helping other companies implement Oracle WMS. Do you feel that it is possible to move from the business side to the consulting side effectively with no IT experience besides working with IT daily on this project? If so, would this be as a functional consultant? I appreciate your input.
    Joe

    Reply
    • January 25, 2016 at 12:40
      Permalink

      Hi Joe

      I see you have two options.

      There is a path into functional consulting from business teams. There are two PM’s on my team today who started their Oracle journey as business people working
      where Oracle was implemented. Once the rollout finished they left the company and started as independent consultants. My client retains independents long-term
      and fills out project teams using consulting companies for each project. This type of functional role would work on rollout projects in the detail of the
      project implemenation. Based on what you say above, I bet you have most of the experience required for this role.

      I wrote a recent post on the six key skills of a functional consultant, have a read and see what you think
      http://iloveoracle.com/oracle-consultant/functional-consultant-launch-formula-6-key-skills-of-a-functional-consultant/

      My client also has a business representative role, staying within business teams and representing them on project teams, sometimes on secondment. There are two
      independent consultants who work in this role at my client, and one of the business reps on my project team from 2007 now also works in this role, along with people
      like yourself who were in the business teams but volunteered for projects and liked them. The input into the project varies greatly depending on the project team
      and business stake in the project. I could see you being very valuable to a business organization in this role also.

      In relation to your experience, the long time you spent on the project is exactly what is required for the types of roles above. Having said that there is a great
      deal you could do to re-frame your experience based on your Linkedin profile and cv that I have access to. I think you face some challenges around the time since your
      project experience and experience concentrated in one module.

      Working as a consultant is different than a permanent employee but you have the experience to make it.

      What do you think?

      p.s. I offer career consulting as a paid service, this might be something you are interested in. Let me know via Linkedin if so.

      Regards,
      Aidan.

      Reply
  • January 9, 2016 at 14:05
    Permalink

    Hi Aidan,
    I have just appeared for my final year MBA finance and would like to make a career as oracle financial consultant. Plz suggest where do i start from. As of now i am looking for a job too.
    Thanks

    Reply
  • December 22, 2015 at 06:13
    Permalink

    Hi Aidan,

    Im Working as an HR executive from past 4 years. Having been worked as a HR for Retail & IT industry, i would like to explore myself in the world of technology and would like to shift my career towards IT. Having a science background in Bachelors and Masters in Bussiness administration, im confused whether i would be able to make it or not? Few of my friends asked me to learn Oracle Functional.Could you please suggest me on this..

    Regards
    Bharati

    Reply
    • January 7, 2016 at 17:19
      Permalink

      Hi Bharati
      Its difficult to say, but you could try to get a HR job with IT project exposure, and see how you like it? Indeed Oracle HR Functional could be a stepping stone into IT from business, you should try to become super user in Oracle HR system and get project experience before attempting it though. A few team members of mine transferred from business into IT consulting through working on IT projects. As business super user, you would have a lot to offer project team, you just need to be in a company that has a lot of change, and therefore system change. What do you think?
      Regards,
      Aidan.

      Reply
  • December 2, 2015 at 12:02
    Permalink

    Hi Aidan –
    Thanks for giving the opportunity to ask you questions. Let me get straight to the point.

    Which is better – in terms of learning and future growth? – Oracle Implementation projects or Oracle support projects?

    To give you some background –

    I am currently working in India with a french multinational company as an Oracle EBS financial consultant for the past two years.
    My background is from engineering so I have learned everything about Oracle on the job here.
    I have worked on 11i to R12 re-implementation projects, new implementation projects and data conversion projects. Modules that I have worked on are IProcurement, PO, AP and a bit of GL. I also have a good understanding about the tables and can write queries to analyze/debug certain issues. I can also look at the code and figure out what’s going on wrong in there. My role also involved regular interaction with client leadership.
    The catch is however that I have entirely worked on a highly customized platform built on oracle. So there are places where my knowledge of standard Oracle is limited.

    I recently have got an offer from an Indian MNC with about 60 percent hike in my salary which is a bit more than the industry standard. However they have told me that they cannot guarantee which kind of project they will put me in. It can be either a support, enhancement or implementation project. On asking around I gathered that this company has more support projects in their kitty so it is likely that I might be put in a support project.

    Now I am confused as to what should I be doing? Should I stay in my current organization and do implementation projects and maybe ask for an onsite opportunity (as there is no chance of increasing my salary, onsite = more money when you look at Indian currency in comparison to dollar or pound) OR should I take the offer from the other company and develop new skills/connections?

    P. S. – I do not have goodies to give away like you do at the end of an email. However please accept my heartfelt good wishes for the great job you are doing.

    Thanks,
    Prashant Bhat

    Reply
    • December 7, 2015 at 15:49
      Permalink

      Hi Prashant

      Great question, and I can see why you take a while to consider it. Have a look at the attached tool from my book – The Oracle Opportunity – A Blueprint for Success as an Oracle Consultant, to compare your current with possible opportunity, it might help.

      I prefer implementation experience over support, implementation is hardcore effort with a defined benefit at the end, support is a cost. Implementation consultants are more respected in a job where lots of new projects happen, and this is my background. If your new company is very large with lots of support guys it may be difficult to differentiate yourself, although implementation experience could be your differentiating factor.

      However financial considerations are also important, and you should consider what you/ your family could personally gain from the salary. If it enables you to reach your personal financial goals then it may be worth it, you could always go back to implementation if you have 2 years experience.

      Please review and let me know what you think?

      Regards,
      Aidan.

      Reply
  • December 2, 2015 at 09:43
    Permalink

    Morning Aiden,

    First of can I thank you for what you are doing with this [FREE!] ‘ILoveORACLE – How to be…’ layout and well-written kick-up the BS to us to become consultants – it all sounds fabulous.

    My background is that I have been an EBS Suite Functional Support Analyst within the UK public sector for over 12 years – one of only 3 team members supporting EBS Suite for 300+ users [with assistance from private consultancy on major upgrades]. I’ve become a ‘jack of all trades, master of none’ type.

    My experience covers 2 Oracle ERP releases (11i, R12), heavily involved in all the stages of the development cycle including requirement gathering, business analysis, functional support, maintenance, technical design, patching, testing, implementation and the documentation as well as all support, admin & report work. I would not consider myself however, a strong PL/SQL or OA FrameWork Java Programmer.

    What I need your advice on before I seriously think about this, is is my ‘jack of all trades’ knowledge & experience and help or hindrence, and either way, what would you suggest I do from here?

    many thanks

    Jack

    Reply
    • December 7, 2015 at 20:34
      Permalink

      Hi Jack
      Thanks for your comments, sometimes a bit of push is all people need!
      The six key skills of a functional consultant are Objectives, Requirements, Design, Build, Test and Transition. It would seem like you have covered most of
      these if not all. You dont need pl/sql or OA to be a functional consultant. If you check my recent linkedin post, https://www.linkedin.com/pulse/i-still-have-job-oracle-cloud-aidan-duffy?trk=pulse_spock-articles
      a portfolio of skills is very useful now and in future. This is also to be expected after 12 years experience. I would be worried if someone had only done a single module for that lenght of time! Similarly I would
      suggest you are probably master of many things over that timeframe.
      How does your experience map to the 6 skills I mentioned? Can you provide examples that demonstrate these skills? How does your Linkedin profile look?
      Start with these steps, and contact me again once you have done that.
      Regards,
      Aidan.

      Reply
  • November 25, 2015 at 15:20
    Permalink

    Hi Aidan,

    Hope you are doing well…
    I completed my Bachelors in 2012..I am working as an Linux Admin and wanted to shift my career.I am planning to learn either Oracle DBA or Oracle Apps DBA.Please suggest me the best one to start my career..

    Thank you

    Reply
    • November 30, 2015 at 13:08
      Permalink

      Hi Koteswar
      I’m fine thanks, but I don’t have a lot of DBA experience, so I’m unable to answer your question, sorry. I work mostly with APPS DBA’s, they are mostly offshore in fact. As a guiding principle, there will be far less APPS sites than pure Oracle sites. There are lots of links in Google with Oracle DBA career advice.
      Regards,
      Aidan.

      Reply
  • November 23, 2015 at 16:54
    Permalink

    Hi Aidan,

    Great website and articles so far. I’m very new to Oracle we just implemented Oracle EBS and OPM 1 year ago. My role in the project was side project lead ensuring local project teams stayed on track and kept the cooperate team and local teams in sync. I also had to step In and lead data conversion. Currently I have formed a business process cross functional team to optimize the system. What I feel I lack is the in depth knowledge of EBS. Any recommendations on best way to gain functional knowledge. We use OPM and it is very hard to find OPM experts so I would like to focus here. Are there trying classes you recommend? How should a newbie start?

    Thanks,

    Nick

    Reply
    • November 23, 2015 at 20:18
      Permalink

      Hi Nick

      Thanks for the comments, it sounds like you picked up some good EBS experience recently. As you have probably figured out by now, there is no dramatic shortcut to picking up EBS knowledge, as its so vast. OPM is a particularly tricky area to learn, we use it at my client, and I only have basic knowledge myself, how to configure my user to see data, basic inquiries and some SQL queries. The other problem with OPM is the documentation is not brilliant and there are not many OPM bloggers, or for that matter functional bloggers, so not much publicly available information.

      Having said that you can develop your own indepth functional knowledge using test environments, and publicly available Oracle EBS instances using your Oracle CSI number to get access(e.g. Biztech). I would start by taking your business’s most-understood OPM processes, and tracing them through each process stage on a copy of production environment. Once your understand the process flow, and have the manuals to hand, you can identify possible improvements or optimizations, testing them as you go and gain deep understanding of OPM in this way. Usually there is scope to change processes using configuration, or data interfaced from other EBS modules or external systems. You could create entire new process flows, new lines of business perhaps, on test systems, and check results using the knowledge you are building

      One more thing, most people on the blog want to know the fastest way to get ahead in EBS career, make themselves more marketable etc. In wider market terms OPM is not used everywhere, so knowledge is hard to find, but roles do not come up very often. Internally within your company, I can’t think of a better way to be indispensable to be the only resource that knows OPM at a deep level. I’m sure Oracle have an OPM course, which would get you there quicker, but you will build up more knowledge experimenting.

      What do you think? Incidentally I’m releasing a course soon – The Functional Launchpad, which is not modules-specific but teaches the 6 key skills of a functional consultant.
      Regards,
      Aidan.

      Reply
  • November 21, 2015 at 13:35
    Permalink

    Hi,

    I am a student from a reputed b-school in India specializing in finance and have been recruited as a Oracle apps techno functional consultant from a reputed firm which is oracle gold partner.Having said that i am a person who likes to work in a challenging work environment and love doing financial analysis work.So how do you think this profile will suit me because most of my college mates die to get into that company and they say it will be great as i will be trained on Oracle e business suite.

    What should i do further to develop my career as i am a fresher with no prior technical background /experience.

    Thanks and Regards.

    Reply
    • November 23, 2015 at 11:22
      Permalink

      Hi Teja
      Your friends are correct, it is good to be trained on EBS, the first few years will surely be challenging as you progress on the learning curve. A lot of people find EBS challenging enough to spend an entire career there, myself included :)
      If you want to find out more about functional and technical careers, I think you would benefit from my book, its on Amazon – The oracle opportunity – a blueprint for success as an oracle financials ebusiness consultant, there is a free chapter in the email course above.
      Regards,
      Aidan.

      Reply
  • November 18, 2015 at 19:21
    Permalink

    Hi Aidan

    i’m working in banking career and i have interview as a senior functional consultant in Oracle Egypt , i need your opinion in this shifting of the career and what about senior functional consultant career path

    Thanks

    Reply
    • November 23, 2015 at 11:14
      Permalink

      Hi Mohamed
      There are many functional consultants who started in business teams. The solution architect on my team is a good example who started in accounting for a corporate, and worked on an Oracle project for his company. After the project was finished he got bored and started working as a consultant, and is now an independent consultant, like myself. Business experience is desired on Oracle projects as there is a lot of interaction with business teams, and you will already understand the business position.
      I think the functional career has a long shelf-life, even with the new Oracle Cloud technologies the functional consultant is the key project team member.
      Regards,
      Aidan.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *