Oracle Orbit Analytics and Data Modelling Consultant

Remote but 10% travel is required to Work Location - Cleveland , OH Top 3 skills required are 1. Should have expertise in building Complex physical and logical data models including good knowledge of data modeling concepts. Must have a very good understanding of normal, complex, and circular joins. 2. Very good understanding of Object and data level securities, and roles and responsibilities. 3. Should have strong hold building complex Orbit reports using calculation measures and report insights. Responsibilities: Develop a comprehensive migration plan from Oracle Discoverer to Orbit Analytics. Conduct a detailed analysis of current Oracle Discoverer reports and dashboards. Design and implement solutions to migrate reports, dashboards, and data models to Orbit Analytics.   Development includes understanding of requirements, use of existing data models or working with a data modeler, build of report, technical unit testing, and  quality assurance testing before being moved to the UAT environment for CRP and UAT testing.  Provide technical leadership and guidance throughout the migration process. Ensure data integrity, accuracy, and consistency during the migration. Optimize the performance of the new Orbit Analytics environment. Utilize in-depth knowledge of Oracle R12 ERP and Oracle Fusion Cloud table structures in the migration process. Ensure seamless integration of data from Oracle R12 ERP and Oracle Fusion Cloud into Orbit Analytics. Collaborate with ERP and cloud teams to understand and address data requirements and challenges. Collaborate with business users to understand their reporting needs and ensure they are met post-migration. Conduct training sessions and create documentation to support end-users in the transition to Orbit Analytics. Communicate progress, challenges, and solutions to stakeholders. Develop and execute test plans to ensure all migrated reports and dashboards function as expected. Identify and resolve any issues that arise during the migration process. Conduct post-migration reviews to ensure all objectives are met. Stay up-to-date with the latest features and best practices in Orbit Analytics. Identify opportunities for further optimization and enhancement of the Orbit Analytics environment. Provide ongoing support and maintenance post-migration. Qualifications : - Bachelor's degree in Computer Science, Information Technology, or a related field. Masters degree preferred. -Proven experience in Oracle Discoverer and Orbit Analytics. -Extensive experience with Oracle R12 ERP and Oracle Fusion Cloud. - At least 5 years of experience in business intelligence and data analytics. -Demonstrated experience in leading migration projects. Technical Skills: - Strong knowledge of SQL, PL/SQL, and database management. -Proficiency in Orbit Analytics, Oracle Discoverer, Oracle R12 ERP, and Oracle Fusion Cloud. -Familiarity with ETL processes and data warehousing concepts. - Experience with data visualization tools and techniques. Soft Skills: -Excellent problem-solving and analytical skills. - Strong communication and interpersonal skills. - Ability to work independently and as part of a team. -Project management skills with the ability to manage multiple priorities.