
Oracle Apex Projects
Looking for freelance Oracle Apex jobs and project work? PeoplePerHour has you covered.
urgent
Apex Strategy Partners
We seek Consultants with expertise spanning finance, economics, strategy, technology, and policy to lead high-stakes projects. This role demands a unique blend of analytical rigor, strategic foresight, and experience engaging with public-sector stakeholders (e.g., government agencies, regulatory bodies) to shape policies and commercial strategies. Key Responsibilities Strategic & Policy Advisory: Design growth strategies for clients in financial services, tech startups, and public institutions. Advise on regulatory compliance, policy frameworks, and government-funded initiatives. Collaborate with policymakers to align business objectives with national/regional economic priorities 15. Financial & Economic Analysis: Develop econometric models to forecast market trends and assess fiscal policies. Evaluate public-sector investments, including infrastructure and green energy projects. Tech Innovation: Guide digital transformation, leveraging AI/ML and data analytics to optimize public service delivery or private-sector operations. Cross-Sector Collaboration: Lead multidisciplinary teams to deliver end-to-end solutions for clients in regulated industries (e.g., fintech, healthcare, energy).
6 days ago20 proposalsRemoteExpires in 24Business Development Associate II, Enterprise Accounts
We hires talented people with diverse backgrounds who are ready to help build a transportation ecosystem that will make our roads safer, get crucial goods where they need to go, and make mobility more efficient and accessible for all. We're searching for a Business Development Associate II to go, and make mobility more efficient and accessible for all. We're searching for a Business Development Associate II to join our Enterprise Accounts team. You will support the creation of strategies for scale and lead key initiatives to establish and maintain relationships with critical enterprise accounts in the transportation industry. In this role, you will • Support initiatives with our trucking customers within our existing strategic relationships • Assist in developing sales strategies to support scaling the business with these key enterprise accounts. Drive initiatives and develop strategies for how to differentiate ourselves from our competitors, etc. Based on guidance from leadership, work cross-functionally with internal teams (Legal, Marketing, Operations, Strategy, Finance, etc.) and external points of contact to draft and negotiate key agreements with our partners. •Build and maintain working financial models to support negotiations and drive partner engagement strategy. • Assist with product refinement by bringing the customer voice into our product development process. Analyze competitive landscape and provide suggestions regarding implications to Aurora's partner engagements. • Analyze competitive landscape and provide suggestions regarding implications to Aurora's partner engagements. • Analyze competitive landscape and provide suggestions regarding implications to Aurora's partner engagements. Required Qualifications • Have 2+ years of BD, CorpDev, or strategy experience, including some in logistics or a field related to AVs, the automotive, mobility, or hardware spaces. • Have negotiation and contract experience. • Be detail-oriented and a strong communicator including experience presenting to leadership / C-suite. • Have demonstrable big "wins" from prior roles. • Passionate about the AV space. • Experience working with CRM applications (e.g., Salestorce, Oracle) is a plus.
11 days ago40 proposalsRemote
Past "Oracle-apex" Projects
Oracle Card Deck & Guidebook Illustrations
Project Overview I am looking for a talented illustrator to create artwork for my upcoming 46-card oracle deck. This deck is designed for soulful business owners who blend intuition with strategy in their branding, marketing, and decision-making. The artwork should be minimalist, symbolic, and evocative while maintaining a warm, earthy aesthetic that aligns with the deck’s themes. Alongside the deck, I will also require matching illustrations for the companion guidebook and a box design that reflects the overall aesthetic. The project includes: - 46 Illustrated Oracle Cards with a consistent portrait-oriented visual style. - Each card features a unique archetype that represents an aspect of business, branding, or intuitive strategy. - A cohesive guidebook aesthetic that includes small, aligned illustrations for each archetype. - Box design that matches the deck’s branding and aesthetic. Art Style & Aesthetic I am looking for: - Minimalist, Hand-Drawn Style Line Art Simple but expressive figurative illustrations with subtle conceptual elements. Evocative gestures and postures that convey the energy of each archetype. Soft organic textures incorporated into the background. - Earthy, Muted Color Palette Base Colors: Warm neutrals, sand, terracotta, ochre, muted greens. Subtle Contrast: Darker tones for line work and accents. No metallic/foil finishes – visuals should remain matte and minimal. - Symbolic, Conceptual Elements Each card should include subtle symbols to enhance its meaning. Category icons (small symbols near keywords) for quick recognition: - Consistent Backgrounds Uniform, textured backgrounds with slight variations based on categories. Typography: Small, elegant handwritten or serif font for three keywords per card. DELIVERABLES: - 46 high-resolution card illustrations in portrait orientation. - Small category symbols integrated near the keywords. - Companion guidebook illustrations that align with the deck. - Box design that reflects the deck’s minimal, warm, and earthy aesthetic. Ideal Illustrator I am seeking someone who: - Has experience illustrating oracle, tarot, or affirmation decks, or similar types of media (perhaps books). - Specialises in minimalist, hand-drawn, or conceptual art. - Can interpret symbolism and archetypes in visual storytelling. - Can maintain a consistent style across all 46 cards. - Is open to collaboration and feedback to refine the vision.
Salesforce Intergration Developer
Key Responsibilities: 1. Develop and implement Salesforce-Fatture integration using APIs and middleware. 2. Customize Salesforce (Apex, Lightning, Flows) to meet integration and business requirements. 3. Ensure data consistency, error handling, and performance optimization. 4. Work closely with stakeholders to gather requirements and provide technical solutions. 5. Troubleshoot and resolve integration issues.
opportunity
Oracle Database AWS RDS Performance Optimization
Oracle Database AWS RDS Performance Optimization is a project that aims to improve the performance of an Oracle Database running on AWS RDS. The project will involve analyzing the current performance of the database, identifying bottlenecks, and implementing optimization strategies to improve performance. The project will start by reviewing the current database configuration, including hardware, software, and database settings. This will help identify any areas that may be causing performance issues. Next, the project will analyze the database workload to identify the most resource-intensive queries and processes. This will involve using tools such as Oracle SQL Developer and Oracle Performance Analyzer to analyze the database's performance metrics. Based on the analysis, the project will develop and implement optimization strategies to improve performance. This may include optimizing database indexes, reducing database size, and improving database query performance. The project will also monitor the performance of the database after implementation of the optimization strategies to ensure that the improvements are sustained. This will involve using tools such as Oracle Performance Monitor and Oracle Database Performance Advisor to monitor the database's performance metrics. In addition to the technical aspects of the project, the project will also involve working with the AWS RDS team to ensure that the database is configured and managed properly. This will involve working with the AWS RDS team to optimize the database's configuration, monitor the database's performance, and troubleshoot any issues that may arise. The project will be completed in a timely manner, with a focus on delivering high-quality results. The project will be managed by a team of experienced Oracle Database administrators and developers who have a deep understanding of AWS RDS and Oracle Database performance optimization. The project will require access to the AWS RDS environment and the Oracle Database. The project team will work closely with the AWS RDS team to ensure that access is provided in a secure and timely manner. The project will be delivered in a format that is easy to understand and implement. This will include providing detailed documentation and training to the AWS RDS team and the project team. In conclusion, Oracle Database AWS RDS Performance Optimization is a project that aims to improve the performance of an Oracle Database running on AWS RDS. The project will involve analyzing the current performance of the database, identifying bottlenecks, and implementing optimization strategies to improve performance. The project will be completed in a timely manner, with a focus on delivering high-quality results.
Database, ER Diagram & SQL
I need database created with er diagram and sql querries using oracle apex
Oracle Apex reporting
I need you to do reporting for an already established Application. The following are to be configured: 1. User Login and Roles: I. To be able to use Email to login based on their CARD_NUMBER and COMPANY_ID II. Verify the Email Address and Change Password III. Different Roles as Per Administrator per company and users per company IV. ADMINISTRATORS: This will be per company have access to APPROVAL and the whole access to the application for the COMPANY_ID V. USERS: Have Access to Specific templates and REPORTS 2. USER ACCESS to the following: I. USER_DETAILS TABLE (ONLY THE SPECIFIC RECORDS) II. REPORTS (ONLY THE SPECIFIC RECORDS) III. INITIAL CONTRIBUTION FORM - CREATE/EDIT/CANCEL (THIS IS SUBJECT TO ADMINISTRATOR APPROVAL) IV. INITIAL LOAN FORM - CREATE/EDIT/CANCEL (THIS IS SUBJECT TO ADMINISTRATOR APPROVAL) 3. Reform the user report: I. USER_DETAILS report II. CONTRIBUTION REPORT TO HAVE LINK TO EDIT/CANCEL (Contribution Type is C then color Blue, When W then color Red, others Green) III. LOAN_DETAILS REPORT TO HAVE LINK TO EDIT/CANCEL IV. LOAN_REPAYMENT_DETAILS REPORT TO HAVE LINK TO EDIT/CANCEL V. WITHDRAWAL REPORT TO HAVE LINK TO EDIT/CANCEL VI. OPENING_BALANCE REPORT TO HAVE LINK TO EDIT/CANCEL VII. MONTHLY REPORT VIII. ACCOUNTING SUMMARY Target is a day delivery and price negotiable
opportunity
AI Voice Expert Needed for Custom Multilingual TTS Model
AI Voice Cloning & Multilingual Speech Synthesis (Open-Source Only / Mozilla TTS or Tacotron) Title: AI Voice Expert Needed for Custom Multilingual TTS Model Using Open-Source Tools – $500 Budget Project Overview: We are developing an AI-powered oracle called the Babalawo, which will provide multilingual spoken responses in a custom voice. We need an AI specialist to clone a specific voice from provided recordings and integrate it into a text-to-speech (TTS) model using only open-source solutions (no proprietary services like ElevenLabs or Microsoft Azure). Project Requirements: We are looking for a freelancer who can: - Clone a specific voice from at least 2+ hours of provided clean speech data. - Ensure multilingual speech synthesis (English, French, Swahili, Arabic preferred). - Train or fine-tune a custom AI voice modelusing open-source TTS frameworks such as Coqui AI or Vits models. - Optimize pronunciation, intonation, and expressiveness for natural, human-like speech. - Provide an offline, locally deployable model (no reliance on cloud-based services). Ideal Candidate Should Have: - Experience with open-source AI voice synthesis tools (Mozilla TTS, Tacotron, or similar). - Knowledge of voice cloning techniques and TTS model fine-tuning. - Ability to work with multilingual speech synthesis and phoneme adjustments. - Experience in deploying TTS models locally without cloud dependencies. Deliverables: - A fully trained custom TTS model replicating the provided voice. - Multilingual speech synthesis in at least 3 languages (English, French, Yoruba). - A local deployment setup that can run offline and be fully hosted on our server (self-hosted, no API reliance). - A brief technical guide on how to use, modify, and maintain the model. Budget & Timeline: - Budget: €200 (fixed). - Timeline: 3 weeks from project start. How to Apply: - Please send: - A brief overview of your experience with open-source AI voice cloning and TTS models. - Examples of past projects (if available). - Your preferred open-source tools for achieving this project. - Your approach to ensuring high-quality, expressive, and multilingual speech synthesis. Looking forward to collaborating with a skilled expert!
HR Retention & Talent Management APP
We seek a skilled graphic designer to develop an interactive app that shows a dashboard with several aspects of our employee retention, engagement and wellness monitoring. One aspects is to display the data related to employee engagement, retention and hiring and the second aspect is to show the factors contributing to the low or high rates of retention or engagement or slow hiring. The app will have a landing page with a product overview at various levels of aggregation of data. We want to show the data of how the tool supports companies, executives, managers, and individuals. Deliverables include a sleek and responsive Figma website layout, with detailed visual pages outlining interaction at each organizational level. Interactive Figma prototypes will allow stakeholders to preview the design for feedback prior to finalizing. Exported screen designs in PDF/PNG format will facilitate smooth review. Our extensive brief contains examples, inspiration, and expectations to guide execution. Selected candidates will be furnished all materials necessary for seamless completion. The tool aims to help HR professionals tackle employee burnout and retention, so emphasis should be placed on an intuitive and user-focused experience emphasizing these goals. The tool will also need to integrate with major HR Platforms such as Workday, SAP, Oracle. Preferred is a designer who worked on HR Analytics tool before. We seek a collaborative partner passionate about creating impactful and engaging visual communication. Compensation is negotiable depending on portfolio and proposed approach. Interested and qualified designers are invited to submit proposals outlining relevant experience and planned execution strategy.
Change SQL Coding
This project involves modifying SQL code to some reports in Oracle Fusion/Cloud to ensure compatibility with a different database instance. The goal is to ensure that the SQL code functions propertly on the new instance without any errors or discrepancies. The freelancer will need to review the existing SQL code, identify any potential issues, and make necessary adjustments to ensure it works seamlessly with the new database environment.
Tableau Developer
Key Responsibilities: Design, develop, and maintain interactive and user-friendly Tableau dashboards and reports based on business requirements. Work with stakeholders to understand business requirements, and translate them into effective data models, visualizations, and reports. Create data extracts, work with large datasets, and optimize the performance of Tableau reports and dashboards. Integrate data from multiple sources, such as SQL databases, Excel, APIs, and other systems, to create comprehensive views of business data. Perform data analysis to ensure accuracy, identify trends, and provide actionable insights through visualization. Develop and optimize complex SQL queries for data extraction and preparation. Ensure the security and accessibility of Tableau reports by setting appropriate access and permissions. Troubleshoot issues with data sources, reports, or Tableau server configurations. Collaborate with the IT team for deployment of Tableau reports and ensuring the seamless integration with other platforms. Participate in Tableau Server administration tasks including the deployment of workbooks and the configuration of Tableau Server. Provide end-user training and support for Tableau reporting solutions. Stay up-to-date with Tableau features and best practices to ensure the team is using the most efficient techniques and solutions. Skills and Qualifications: Proven experience as a Tableau Developer or similar role, with a strong portfolio of Tableau-based dashboards and reports. Expertise in Tableau Desktop, Tableau Server, and Tableau Prep. Proficient in SQL and experience with relational databases (e.g., MySQL, SQL Server, Oracle). Experience with data blending, data visualization best practices, and creating interactive dashboards. Ability to connect to various data sources, such as Excel, Google Analytics, Salesforce, and others. Strong understanding of data modeling and data transformation. Excellent problem-solving skills and attention to detail. Strong communication skills and ability to collaborate with business stakeholders. Knowledge of other visualization tools (e.g., Power BI, Qlik) is a plus. Familiarity with data warehousing concepts and working with large datasets. Experience in agile development methodologies is preferred
pre-funded
SAlesforce Problem solving
Problem Consider the following problem: Our sales organization uses Salesforce. It also frequently uses an external system (call it “Foobar”) in which the sales reps search for specific contacts. Once they have assembled a list of contacts, they request Foobar to inject these contacts into Salesforce as Leads. Foobar uses the sales rep’s credentials via OAUTH to authenticate to Salesforce and injects the Leads via the Salesforce API. The list may be as short as one Lead or as long as several hundred Leads. Our Marketing team wants these leads to be grouped via Salesforce Campaign records. That is, all the leads injected as a list by the sales rep from Foobar in a short period should be grouped, even if they arrive in more than one batch. Instructions Please set up a Salesforce instance (a Trailhead playground or a standard developer org) where you implement this using Apex and give us access to this instance. Your code should: Respond to insertions of Leads. Recognize leads injected by Foobar based on LeadSource = “Foobar”. Whenever the sales rep requests Foobar to inject one or more leads into Salesforce, recognize that a new list is being inserted and create a new Campaign to group them. Leads inserted within a short period should be part of the same campaign. The campaign should have a name that includes the string “Foobar”, the sales rep’s name, and a representation of the time the list was injected. All the Leads in the list should be associated with the Campaign via CampaignMember records. Be covered by unit tests. Follow Apex developer best practices. As this is a proof-of-concept, you are not expected to solve all possible operational and scaling issues now. However, please note in the code why you decided to take a shortcut or how it can be addressed in the future as a TODO item for the code reviewer. You will also be asked for a plan to address these concerns in your delivered project . Decide which abstractions are essential and which can be added later to meet these time constraints. It is also perfectly acceptable to submit a partial solution. Of course, the more complete the implementation, the better the advantage over partial ones. I will need explanation for each code and also a video Q&A Session afterwards to explain the solution.
Operations Assistant (Supply Chain & Procurement)
We are looking to hire an A TYPE PERSONALITY FAST MOVING PLAYER assistant for our beauty e-commerce & B2B Wholesale operations. Hard-working individual, who strives for excellence & is looking for a long-term partnership. We are one of the leading ecommerce beauty companies in the UK specializing in high-quality beauty products. We are committed to delivering exceptional customer experiences and maintaining strong relationships with our B2B partners. Our innovative and fast-paced environment offers a great opportunity for growth and development. Job Description: We are seeking a highly organized and detail-oriented Supply Chain & Procurement Assistant to join our team. In this role, you will support the supply chain operations, ensuring efficient and effective processes that meet the needs of our e-commerce and B2B operations. The ideal candidate will have a passion for the beauty industry, excellent communication skills, and the ability to thrive in a dynamic work environment. Key Responsibilities: • Assist in the overall supply chain management • Coordinate with suppliers and vendors to ensure timely delivery of products. • Monitor and track shipments, resolving any issues that arise. • Maintain accurate records of inventory, orders, and shipments. • Support the procurement process by preparing purchase orders and managing supplier relationships. • Collaborate with the logistics team to streamline distribution processes. • Generate and analyze reports on inventory levels, order status, and supply chain performance. • Assist in the implementation of supply chain strategies to improve efficiency and reduce costs. • Provide administrative support to the supply chain team as needed. Qualifications: • Study in Business management, logistics, business administration, or a related field preferred. • Previous experience in a supply chain, logistics, or related role, preferably in the ecommerce or beauty industry. • Proficiency in supply chain management software (e.g., SAP, Oracle, or other ERP systems) and Microsoft Office Suite (Excel, Word, PowerPoint). • Strong organizational skills and the ability to manage multiple tasks simultaneously. • Excellent communication and interpersonal skills. • Attention to detail and a high level of accuracy in data entry and documentation. • Ability to analyze data and generate reports. • Problem-solving skills and the ability to resolve issues efficiently. • Flexibility to adapt to changing environments and responsibilities. Preferred Qualifications: • Certifications in supply chain management or logistics • Knowledge of the beauty industry and its supply chain processes. Interested candidates are invited to submit their resume and cover letter detailing their qualifications and experience with the subject line: A Type Personality Supply Chain Operations Assistant Application. Preferred Working Hour: 9:00 - 17:00 BST Flexible Time. On-going Part Time are welcome to apply Please state at least 3 core values towards work and attach your CV when you submit your proposal. Thank you.
opportunity
Saas software developer
The project description is as follows: We are looking for a skilled Saas software developer to join our team and help us develop and maintain our platform. The ideal candidate should have experience with Saas development, be familiar with modern web technologies, and have a strong understanding of software development principles. Responsibilities: Develop and maintain the Saas platform, including front-end and back-end components. Work with a team of developers to design and implement new features and functionality. Write clean, efficient, and scalable code. Collaborate with other team members to ensure that the platform meets the needs of our users. Stay up-to-date with the latest trends in Saas development. Requirements: Bachelor's degree in Computer Science or a related field. Strong experience with Saas development, including experience with popular Saas platforms such as Salesforce, Oracle, or SAP. Experience with modern web technologies, including HTML, CSS, JavaScript, and React. Strong understanding of software development principles, including object-oriented programming, design patterns, and testing. Excellent problem-solving skills and attention to detail. Ability to work independently and as part of a team. Excellent communication skills. If you are a skilled Saas software developer with a passion for building great products, we would like to hear from you. Please submit your resume and cover letter for consideration.
Need artwork resized for printers
Hi I’ve been helping a client design her oracle cards for printing but the printing company keeps coming back looking for specific resizing that I don’t have the time to do. I’ve all the artwork on Canva so I just need someone to check and if needs be slightly resize everything ( cards, box and guidebook) to the measurements the printers need. I’m not to familiar with bleed areas etc. Need asap
opportunitypre-funded
1 hr advanced training Salesforce Flow HTTP Post w/nested JSON
Hello! I am an advanced Salesforce.com consultant/Flow user/developer and require a screen-sharing Zoom training on the advanced use of the relatively new Salesforce Flow HTTP Post callout function required for a specific purpose. I have been struggling to take in a single JSON text string with a 3 level nest of JSON objects in one HTTP Post callout response to Salesforce (I.e. a list of Grandparents, Parents and Children records. I have the objects and Flow built, the HTTP Post callout and the web service responding with the JSON response successfully but somehow in the setting up of the External Service action/response sample, I am struggling to take the data in and map it so that I can create the records in Salesforce. I presume that we can create the records either with a series of progressive loops in the Flow, (but ideally we would map and use the Transform element. Is this possible and if so, would we be able to do a paid consulting hour (I am based in the UK) on my Zoom account to show me how to do it? I believe that the solution lies in some error in the Apex defined variables used in the creation of the external service. Please only reply if: - you fully understand the requirements and how to solve this issue (I am confident in building Flows and using HTTP callouts. I am not looking for general training on this - it is the multi-nested response and Apex record variable callout response specific help needed. If you don't know the answer, the hour session will not be enough for a trial and error approach. I have done this already and gone round in circles :-) - You can solve the issue in Flow only. I am not looking for a suggestion of an alternative Apex only solution - We can hold the Zoom screen share session in English The solution to this I think should be able to be delivered in 20 minutes, so if we can do that, I am happy to end the session right there and complete the project and payment. I will have prepared the org, data and Flow and will these ready for us to jump straight in, so having described the requirement above, will be expecting us to jump straight into the solution (there is only 2 fields to map - Name and Age) in the Grandparent, Parent, Child schema. Thanks and look forward to hearing back! Will
opportunity
Structural Design of 12m x 24m Steel Portal Frame Building
I have a preliminary design (3 sample pages are attached) for a 12m x 24m steel portal frame building, with an overall height of 3.9m to the apex, a 6° roof slope and externally clad in a restraining-type metal profiled sheet. The building will be located in East-Norfolk, UK. This preliminary design gives an overview of what I’d like to achieve, including the use of inset purlins to comply with planning restrictions on overall building height. Extra to the standard design, I would also be interested in your opinion on the best method for including roof overhangs, the last page of the preliminary design ('AH-SPFW-8.png' attached) details a brief overview of what I’d like to achieve. I have also had a ground report completed on the site where the building will be located. The project requirements: Structural analysis and structural design calculations for the primary steelwork of the 12m x 24m steel portal frame building, ensuring the design complies with the relevant British Standards and Eurocodes for structural design. This includes • Design of portal frames and gable frames providing sizes and specification of members with all the necessary details for manufacture. • Design of stability bracing • Connections design and detailing, including at the haunch, at the apex and at the base considering fire boundary conditions. • Design of suitable strip and pad footings • Design of ground bearing slab capable of carrying a forklift and other small plant. • Opinions on best method for including roof overhangs in the design and including the relevant design details and specifications for manufacture if required. • Advice on UK fire boundary conditions I’m proficient with Fusion 360 and am happy to create the design file using details from your calculations.
Sourcing Datasets for Audit Analytics
I need assistance in sourcing high-quality, industry-relevant datasets for internal audit data analytics, particularly within the finance industry, focusing on internal audit and risk management. The datasets should simulate real-world scenarios, showcasing cross-system integrations where data flows between systems- free to use, distribute, and modify without restrictions. Key requirements: • Cross-system data flows to replicate real-world business processes. • Dataset size: Large enough to enable meaningful analytics but manageable for analysis, with enough data points to perform rule-based testing, fraud detection, anomaly detection, and machine learning. Areas for datasets: 1. Customer Relationship Management: o CRM Systems: Data related to customer interactions, such as sales pipelines, customer support, and service requests. Integration with workflow systems for task assignment and tracking. Ticketing system data for resolution tracking and escalation workflows. o Eg: Salesforce, HubSpot, Microsoft Dynamics. 2. Financial Transactions: o Financial Approval Systems: Approval workflow data for purchase orders, vendor payments, and authorisation processes. o Execution Systems: Systems responsible for the actual execution of transactions (e.g., ERP systems for payments). o Fund Transfer Systems: Bank transaction records, transfers between accounts, reconciliation, and intercompany fund transfers. o Eg: SAP, Oracle Financials, QuickBooks. 3. Human Resources (HR): o HR Management Systems: Payroll data, employee records, leave management, and performance evaluation data. Data on employee onboarding, compensation, benefits, and termination. o Time Management Systems: Time tracking and attendance data, leave balance calculations. o Eg: Workday 4. IT and Cybersecurity: o Cybersecurity Systems: Network logs, firewall events, and data from security incident and event management (SIEM) systems. Incident response workflows, access control logs, and vulnerability management. o IT Operations: Systems data related to IT asset management, software updates, and system performance monitoring. o Examples: Splunk, Cisco Security, Palo Alto Networks, CrowdStrike, ServiceNow. 5. Operations and Workflow: o Workflow Management Systems: Workflow and task management systems that track operational processes and task completion. o Operations Data: Task tracking, issue resolution workflows, and operations performance metrics. o Ticketing Systems: Data on incident management, service desk requests, and help desk tracking. Eg.ServiceNow, JIRA, Monday.com. 6. Governance, Risk, and Compliance: o GRC Systems: Risk assessment data, internal audit trails, and compliance monitoring. Data on policy enforcement, internal controls, and external regulatory compliance. o Regulatory Reporting Systems: Data related to mandatory reporting, such as GDPR compliance, Sarbanes-Oxley (SOX) compliance, and financial reporting regulations. o Eg. RSA Archer, MetricStream, IBM OpenPages, TeamMate. 7. Supply Chain Management: o Procurement Systems: Data on vendor management, purchase orders, contract tracking, and supplier performance. o Inventory Management Systems: Stock levels, reorder points, warehouse operations, and shipping data. o Vendor Payment Systems: Data on vendor payments, reconciliation, and procurement-to-pay cycles. o Eg.SAP Ariba, Oracle SCM, Coupa. 8. Trading and Portfolio Management Systems: o Front Office: Trade Execution Data: Information on executed trades, including timestamps, volumes, prices, and counterparties. Market Data: Real-time or historical market prices for stocks, bonds, derivatives, etc. Portfolio Management: Data on holdings, asset allocation, and portfolio performance analytics. Order Management Systems: Buy/sell orders, amendments, and cancellations. Eg. Aladdin o Middle Office: Risk Monitoring: Risk exposure, Value at Risk (VaR), compliance with investment mandates, and stress testing data. Trade Settlement: Data on trade confirmation and settlement, including pending or failed trades. Regulatory Reporting: Compliance data for regulatory frameworks like MiFID II, EMIR. o Back Office: Clearing & Settlement: Data related to clearing processes and settlement of transactions. Custody Data: Information on safekeeping of assets, including securities, corporate actions, and dividends. Reconciliation Data: Cash and securities reconciliation between systems, custodians, and brokers. o Related Systems: Collateral Management: Data on margin calls and collateral allocation for derivatives. Cash Management: Data on cash flows, fund transfers, and account balances. FX Hedging: Currency hedging positions and exposures. Derivative Trading: Data on options, futures, swaps, and their valuations. Deliverables: • Well-documented, accurate & complete datasets in structured/CSV format for business areas mentioned above with clear explanations of how the systems connect and data flows.
opportunity
Council Analytics Project - SQL Analysis & Power BI
hi, I have a requirement for a client project to develop a council data warehouse solution and to develop analytical data sets for end users to exploit data. The tech stack is a combination of source data in Oracle / SQL server / Excel spread sheets being loaded into a Azure SQL database. The scope will be to design and develop data sets for analysis using SQL and then to develop a set of Power BI Reports Local Council or similar experience required. Regards Pally
ONYX and ORACLE Sheffield / combine logo
I need to combine ONYX and ORACLE logo I can send your the logo for these 2