Oracle Expert – Mandeep Dhami


Hello Friedns, as in continuation to involve Subject Matter Experts to improve and get to knowledge, here today we showcasing Mr Mandeep Dhami, An Oracle Application experts in his area. I encourage you all to ask ur query/ question to him.

Name

Mandeep Dhami

Expertise

Module: Payables, Assets, Internet Expense and GL

Organization

Current: Merrill Lynch

Past: J.P. Morgan Chase

Contacts

Email: mandeepdhami4u@hotmail.com

 1.      Tell something about you, your professional experience/ background, past assignment, Interests.

Ans: I have just got into the world of Oracle Professionals, working as Functional Consultant on Payable, Assets, Internet Expense and GL modules. So far I have been involved in implementing the above modules of Oracle across various locations in Asia Pacific region. I have been involved from operations side giving requirements to the deployment team, who then sets up the system and then I get involved in doing System Integration Testing (SIT). Once SIT is successfully done we get the same testing done by end users as part of Users Acceptance Testing (UAT). This also involves giving training and preparing training material for the end users.

2.      If any professional want to become functional consultant (either in manufacturing or financials), how she/he should take it and go ahead?

Ans: It will be too early for me to comment on this as I am quit novice in this role. But whatever I have experienced so far I can say that the functional consultant should have good knowledge about the working of various modules from end users perspective.

3.      Give some commonly used Functional Concepts/ Questions in Oracle Applications’ Financials Modules.

Ans:  What accounting entries are generated when an invoice is entered and paid?

What’s the difference between cross validation rule and security rule?

4.      What is your favorite Oracle Applications modules, share some of your interesting professional work experience.

Ans: My favorite module is Payables. In terms of interesting experience I can recollect one when implementing oracle payables for one of the locations where they were giving cash advance to employee. This was also a new learning for me. I got the solution for the same after consultation with my colleagues from the team. The real problem was to sale this solution to the location as first of all this application was new for them and this functionality was to be used by them only in the region. It took couple of training sessions with detailed flow chart and training material to get them agree to the solution suggested.

5.      Your advice/ Suggestion for Oracle Technical and Functional Professions

Ans: I would say that the professional should have good knowledge about the modules they are working on and should always strive to be up to date with latest happenings on their areas of work. I would also suggest visiting such blog (http://knoworacle.wordpress.com/) which are full of information and knowledge.

6.      Your feedback on Knoworacle.wordpress.com

Ans: Very good initiative by you to share knowledge on Oracle. There are various articles on different modules of Oracle and all these is from your own practical experience which makes this initiative all that more special, important and accurate.

Thanks – Shivmohan Purohit ( knoworacle.wordpress.com )    

Oracle-Expert-Raju-ghosal


Hello Friedns, as in continuation to involve Subject Matter Experts to improve and get to knowledge, here today we showcasing Mr Raju Ghosal, An Oracle Applications DBA, experts in his area. I encourage you all to ask ur query/ question to him.

Name

 Raju Ghosal

Expertise

Oracle Application SysAdmin /Cloning

Contacts      

Email: raju.ghosal@gmail.com

 1.      Tell something about you, your professional experience/ background, past assignment, Interests.

Ans: Currently working with a Multinational in Developing strategic projects deployment plans; analyzing and coordinating ERP business applications across all phases of an entire Software Application Life Cycle (SALC).

I was involved in through out implementation of E-Business Financials module in my earlier assignment which includes interfaces of legacy data, GAP analysis, customization of FORMS, Reports and Maintaining 5 instances with scheduled refreshes, up to date patching etc.

I was also a part of management advisory board for all BCP activities.

 2.      Please share some/ any of your Oracle work related professional /project experience.

Ans:  I was involved in through out implementation of E-Business Financials module in my earlier assignment which includes interfaces of legacy data, GAP analysis, customization of FORMS, Reports and Maintaining 5 instances with scheduled refreshes, up to date patching etc.

 3.      What is term Environment Management in context of Oracle Applications, How it is relevant for Oracle Applications setups in various organizations

Ans: Environment management duties include:

Instance Management – Work with DBAs, SA’s and CT Application Teams in coordinating instance refreshes, downtimes, usage for initiatives.

Oracle Patch Management – Coordinating with Functional teams /DBA Teams /Prod Support teams/Oracle Teams, etc on Patches/SRs for Oracle Application Instances. 

Opening SR Reviews and Follow Ups – Host weekly status calls

Coordinating Finance Technology Environment Initiatives – examples:  10G Upgrades, Partitioning, etc with DBAs, Functional Teams, App Leads and Prod Support.

Status Reports – Produce various surveys, reports, logs, etc pertaining to Technology Initiatives, issues and standard operations.

Conducting Business Continuity Planning initiatives which includes Crash and Recovery test and High Availability Test etc.

 4.      You take lot of interview, what are the common professional skills you look in candidates, how you advise candidates to focus on to improve their interview performance.

Ans: The common qualifications I look for in a candidate are:

Should be confident of what he is speaking. Should have sound knowledge on the business impact of the task he is doing or has done. He/She should understand the business logic involved or the process flow of the application he is working on.

He/She should have excellent attitude towards work and always willing to learn.

5.      How you differentiate between Support, Development, Implementation and other different kind of activities as part of team scope and work. How they different and how a professional should identify his role and relevance. What are skills require for different kind of activities.

Ans: Implementation is the whole of processes that defines a complete method to implement software in an organization. It is based on best practices and case studies from various literature sources and presents a collection of processes and products that make up a complete implementation method to allow any organization to plan and execute the implementation of ERP software.

Developer Role is to prepare the Technical Specification (based on a Functional Specification given by a Functional Consultant), build the code, Review the code and finally to prepare the Unit Test Cases. Sometimes the developer may be asked to do a technical research for an optimal solution.

After a go live, the application needs a maintenance/support to resolve the issues/tickets raised by the users when using the application. Ticket is like a request for changes/bug fixing or a request for a new Developer Role includes bug fixing/change the existing code due to new requirements/build a new code etc.

 6.      Need your view on terms Functional, Technical and Techno-Functional. How you think these have relevance. Do techno-functional professional real advantageous or it is kind of overlapping.

Ans: Techno Functional professionals has always the advantage over Functional or Technical guys specially in cracking the Interviews as they are very good to map the Business needs with the jobs they are doing moreover they are in very high demands among Multinationals where you need to gel well with the actual business users.

To my understanding a professionals should be well versed with the business needs along with the technical jobs they are expected to perform. This gives a win-win feeling to both the Business needs and the technologies as a whole.

7.      Your feedback on Knoworacle.wordpress.com

Ans: Good going…I wish all the best for future Endeavour.

8.      Please any additional questions/ thoughts from your sides

Ans: You should publish few DBA related articles which are in high demands in current market scenarios.

Disclaimer:  Opinions expressed by the OCP Advisor is entirely his own and do not reflect the position of Oracle or any other corporation. Any advice or recommendations discussed are not validated by Oracle.

Thanks – Shivmohan Purohit ( knoworacle.wordpress.com )    

Introduction


Hello Friends,

To indtroduce first with myself. I am shivmohan purohit, professionally working in Oracle Applications, majority in Oracle Financials – General Ledger, Oracle Payables, Oracle Receivables, Oracle Fixed Assets and many more other related modules and technical tool along with IT Projects and IT Governance Areas.

For more details about my carrer, work profile, expertise , skills areas… plz contact me on shivmohan.purohit@gmail.com

As an introduction, i like to keep it short and i like to welcome you to participate in my effort to bring and share some of the good knowledge areas for Oracle Applications. Using this blog i like to cover Oracle Financials – in terms of technology, its business functions, how to make it work in different scenarios along with related areas. plz share your feedback, suggestion as well contribution.

thanks

Shivmohan Purohit