Phoenix - Your AI AssistantOracle Pl Sql Projects
Looking for freelance Oracle Pl Sql jobs and project work? PeoplePerHour has you covered.
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.
Database, ER Diagram & SQL
I need database created with er diagram and sql querries using oracle apex
pre-funded
Data Analysis SMART PLS
Looking for an expert in Smart PLS who can carry out data analysis of Quantitative Data using Structural Equation Model to predict the influence of independent variable on dependent variables. Small Data Set would not require more than one hour of analysis time.
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
opportunity
Web scraping solution
Requerimiento: Solución de Web Scraping para Portales de Medios de Información Objetivo del Proyecto Diseñar e implementar una solución automatizada de web scraping para recopilar información de portales de medios de información. Los datos recolectados deberán ser almacenados en una base de datos mediante la ejecución de un procedimiento almacenado (stored procedure) en SQL. ________________________________________ Alcance 1. Realizar scraping en sitios web de medios de información predefinidos, incluyendo, pero no limitado a: o Noticias nacionales o Noticias internacionales o Deportes o Entretenimiento o Economía 2. Recolectar información clave, como: o Título de la noticia o Fecha de publicación o Autor (si está disponible) o Resumen o encabezado o Contenido completo del artículo o Categoría o sección del portal o URL de la noticia o Fuente del medio 3. Guardar los datos en una base de datos SQL mediante un stored procedure que permita: o Validar la integridad de los datos antes de insertarlos. o Evitar duplicidad de registros. ________________________________________ Requerimientos Funcionales 1. Extracción de Datos: o Implementar un módulo para realizar scraping de páginas HTML dinámicas y estáticas. o Manejar sitios con diferentes estructuras HTML, incluyendo aquellos que requieran interacción con JavaScript. 2. Gestión de Acceso: o Incorporar control de acceso para sitios protegidos (si aplica), como inicios de sesión. o Considerar técnicas anti-bloqueo (User-Agent Rotation, IP Proxy). 3. Almacenamiento de Datos: o Diseñar un esquema en SQL que soporte la información recolectada. o Implementar un procedimiento almacenado para insertar los datos en la base de datos, manejando validaciones como: Verificación de duplicados por URL. Registro de errores o inconsistencias en una tabla de logs. 4. Escalabilidad: o Posibilidad de agregar nuevos portales sin modificar significativamente el código base. 5. Frecuencia: o Programar ejecuciones automáticas en intervalos configurables (diario, semanal, etc.). ________________________________________ Requerimientos Técnicos 1. Lenguaje de Programación: o Python (preferiblemente) o Node.js, utilizando frameworks como Beautiful Soup, Scrapy o Puppeteer. 2. Base de Datos: o SQL Server o un motor compatible que permita la ejecución de procedimientos almacenados. 3. Integración con la Base de Datos: o El programa de scraping debe ejecutar el stored procedure tras procesar cada lote de datos. 4. Manejo de Excepciones: o Registro detallado de errores durante el scraping, almacenamiento o ejecución de stored procedures. 5. Compatibilidad: o Diseñar la solución para que sea compatible con sistemas operativos Windows y Linux. ________________________________________ Criterios de Aceptación 1. La solución debe ser capaz de recolectar y almacenar información de al menos 5 portales de noticias iniciales. 2. La inserción en la base de datos debe completarse sin errores y siguiendo las validaciones establecidas. 3. El sistema debe ser modular para facilitar la adición de nuevos portales. 4. Los datos deben ser accesibles para consultas SQL tras su almacenamiento. ________________________________________
DATABASE BUILD
A public sector database is required comprising company details across multiple UK cities. The developer will need to construct a structured storage solution incorporating name, full address, and manager contact information for organisations in London, Birmingham, Manchester and Leeds. The database schema should allow for efficient input and retrieval of information across key fields. additional components like user authentication and backup processes would strengthen the design. Priority will be given to candidates demonstrating expertise in SQL databases and compliance with public sector security and accessibility standards.
opportunity
Experienced .NET Developer
We are an esteemed innovation firm seeking a highly skilled .NET engineer to aid in a vital stage of an ongoing undertaking. The successful applicant will collaborate closely with the Chief Technology Officer to leverage their extensive expertise in .NET framework and related technologies. This is an opportunity to utilize an advanced skillset cultivated through previous roles developing intricate enterprise resource planning systems. The applicant should possess a strong portfolio evidencing achievements in architecture, design and implementation of full-stack solutions utilizing .NET Core, ASP.NET, C#, Entity Framework and associated tools. Experience with SQL Server, Azure DevOps and integrating third-party APIs is preferable. The applicant will be involved in all phases including requirements gathering, modeling, coding, testing and deployment. Passion for continuous learning and commitment to producing clean, well-documented code are essential. Only applicants with a proven history of effectively leading and contributing to medium to large-scale commercial projects need apply.
ERP module with unlimited users
Description: We are seeking a skilled web developer to design and implement an integrated enterprise resource planning (ERP) module. This comprehensive system should encompass human resource management, asset tracking, document uploads and version control, and a helpdesk interface for processing customer support tickets. Key requirements include user authentication for restricted access, role-based permissions to delineate staff abilities, and reporting capabilities to analyze organizational performance. The back-end infrastructure must utilize a relational database to centrally store and relate entity records. On the front-end, administrators require an intuitive interface consolidated across divisions yet granularly tailored per role. Data integrity, scalability for potential growth, and compliance with web standards are also of high priority. Applicants demonstrated proficiency designing database-driven applications, preferably with prior work experience integrating ERP solutions into CMS frameworks. Qualified developers ideally come with case studies highlighting modular design patterns, SQL optimization tactics, and usability testing methodologies. We seek a diligent partner to launch this strategic initiative on schedule and on budget. Continues support should be provided on yearly basis.
opportunity
Develop AI Agent for Automated Legal Case Processing
I'm a lawyer seeking an experienced developer to create an AI agent that can automatically collect, process, and integrate court decisions from Croatian legal websites into our database. The agent should be able to: 1. Scrape data from specific Croatian legal websites, including https://e-oglasna.pravosudje.hr/ 2. Navigate through search interfaces and handle dynamic content 3. Download and process PDF documents containing court decisions 4. Extract relevant information from these documents using NLP techniques 5. Categorize and index the decisions based on predefined legal areas and keywords 6. Integrate the processed information into our existing legal database Required Skills and Experience: - Proficient in Python, with expertise in web scraping libraries (e.g., Scrapy, Selenium) - Experience with PDF processing libraries (e.g., PyPDF2, pdfminer) - Strong background in Natural Language Processing (NLP) using libraries like NLTK or spaCy - Familiarity with database management and indexing (e.g., SQL, Elasticsearch) - Experience in developing AI/ML models for text classification and information extraction - Knowledge of web technologies and ability to handle dynamic content and CAPTCHAs - Understanding of data privacy and security best practices - Ability to work with Croatian language text (knowledge of Croatian is a plus but not mandatory) - Experience with legal documents or similar text-heavy domains is advantageous Deliverables: 1. A fully functional AI agent meeting the above requirements 2. Comprehensive documentation and user guide 3. Source code with clear comments 4. A report detailing the methodology, challenges, and potential improvements Please provide examples of similar projects you've worked on, especially those involving web scraping, PDF processing, or legal document analysis. Include your estimated timeline and budget for this project. Note: The successful candidate must be willing to sign a non-disclosure agreement due to the sensitive nature of legal data.
opportunity
Power BI / Quicksight Dashboard Configuration
Project Objective: Configure a dashboard using an existing service (e.g., Power BI, QuickSight, Tableau) to display business data collected via APIs. The dashboard should be integrated into our private admin panel, with the possibility of exposing certain data via a password-protected public URL if required. General Requirements - Accessibility: The dashboard must be accessible through our internal admin panel. It should also support the option to expose selected data through a password-protected public URL. - Flexibility and Customization: The configuration must support a multi-tenant setup: each client using our system should see only their relevant data. The data should update dynamically via integration with existing APIs. Tool Selection: Use a proven dashboarding solution like Power BI, QuickSight, or Tableau to ensure speed, scalability, and ease of use. Dashboard Structure Panel 1: Revenue Performance - Data to Display: - Company Revenue (Month to Date): Revenue generated from the start of the current month to date. - Company Revenue (Year to Date): Revenue generated from the start of the current year to date. - Suggested Visualization: - Cards or bar charts. - Highlighted numeric values for quick performance insights. Panel 2: Revenue Percentage by Business Line - Data to Display: - Revenue percentage for each business line. - Absolute revenue amount generated by each category. Suggested Visualization: Pie charts for percentages. Side tables for detailed breakdowns. Panel 3: Revenue vs. Budget by Business Line - Data to Display: Current revenue (Month to Date and Year to Date) for each business line. - Pre-set revenue budget for each line. - Positive/negative variance compared to the budget. Suggested Visualization: Bar charts for direct comparisons. Color indicators to highlight variances. Panel 4: Workflow Overview - Data to Display - Total number of tasks categorized by status: - To Be Managed - To Be Scheduled - To Started - In Progress - Completed - Lost - Other Status Interactive links to drill down into detailed information for each task (e.g., date, client, current status, notes). Suggested Visualization: Dynamic tables with drill-down capabilities. Bar charts or flow diagrams for overall progress representation. Technical Specifications API Integration: Configure the chosen tool to fetch data from REST APIs or other supported data sources (e.g., CSV files, SQL databases). Set up real-time or scheduled data refreshes. Multi-Tenant Access: Apply report-level filters to ensure each client views only their own data. Configure roles and permissions to manage data access. Admin Panel Integration: Embed the dashboard into the admin panel using iframe or embedded reporting options. Ensure a seamless and responsive user experience. Public Data Exposure: Configure a specific view of the dashboard to be shared via a password-protected public URL. Limit displayed data for privacy and security reasons. Scalability and Maintenance: Ensure the configuration is scalable to accommodate new companies, data types, or panels in the future. Simplify modifications to APIs or filters as business needs evolve. Expected Deliverables 1) Initial Dashboard Configuration with the specified four panels. 2) API Integration to dynamically update data in real-time or at scheduled intervals. 3) Dashboard Embedding within the admin panel. 4) Public URL Configuration (if feasible) to display selected data. 5) Operational Guide for adding new clients or modifying filters.
Past "Oracle-pl-sql" Projects
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
Canvas Art Project VISUALSKETCHES for Sales !
Based on the discussion pls start the work as discussed. Need to finish the liting as per pictorem integration and sales.
Restaurant Menu Change
Looking to get the restaurant menu updated, keeping the same fonts. Pl see existing menu to be changed.
Microsoft server setup with MS SQL to connect remotely
I need to setup a Microsoft server and install ms SQL. This SQL will be accessed remotely so we need to make sure ports are enabled. And a self signed SSL needs to be configured. Suggest me which cloud provider will be good and budget friendly.
opportunity
Troubleshoot sql server connection issues in linux/wine/c++
Using an simple c++ example program that works on windows and linux, get the program to sucessfully connect in a linux/wine environment, both using a .exe built in visual studio, and also built on linux using winemaker Currently the .exe fails on the SqlDriverConnect, and the winebuilder crashes in SQLAllocHandle. Development will take place on a remote linux server logged in via ssh. Communication will be via peopleperhour.
Playing international radio uk
Tune in has blocked international radio in UK. It can only work on the desktop live stations but am looking to play international radio stations on speakers Sonos systems I have tried VPN and it works on the desktop but how do I connect the speakers to vpn? Or is there another way to remove the block from TuneIn? Pls advise
Document archiv DB
I'm looking for a developer to create a straightforward archive system for me. I have a directory containing roughly 1000 files/documents. What I need is a system that allows me to store filenames along with 1-n keywords associated with each document in a database or table. The system should enable me to add, delete, and search for documents by their name and keywords. Key Requirements: - A user-friendly Graphical User Interface (GUI) is a must. - The choice of database system is flexible; it can be SQLite, MySQL or Microsoft SQL Server. - The search functionality should be basic, allowing me to search by document name and keywords.
Water Billing System
Top Skills: Programming: Proficiency in languages like Python, JavaScript, PHP, SQL, and legacy languages (e.g., VB6) for various software solutions. Web Development: Frontend (HTML, CSS, JavaScript) and backend (Node.js, Django) development, ensuring responsive, user-friendly websites. Database Management: Expertise in database design, SQL optimization, and data migration, ensuring secure and efficient data handling. Cloud Services: Experience with AWS, Azure, and Google Cloud for scalable, cost-effective cloud solutions. Cybersecurity: Skills in risk assessment, network security, and data protection to safeguard systems. Experience: Proven background in full-stack development and software maintenance for diverse clients. Strong portfolio in developing and maintaining legacy systems, especially for businesses with outdated infrastructure. Experience in remote collaboration tools, agile workflows, and project management. Strengths: Adaptability: Quickly adjusts to new technologies, industries, and project needs. Problem-Solving: Strong analytical skills for troubleshooting and optimizing systems. Communication: Ability to explain complex tech concepts to non-technical stakeholders. Reliability: Consistently meets deadlines and maintains high standards in deliverables.
opportunity
Power BI - Job Costing (2)
"We are seeking an experienced Power BI developer to build a job costing dashboard for our construction business. The dashboard should display key metrics related to project profitability, budget vs. actual costs, cost overruns by project manager etc. for active jobs. The underlying data will be pulled from our SQL Server database which tracks expenses, time logs, purchase orders etc. for all projects. The developer will be responsible for data modeling in Power BI to normalize and integrate data from various tables. Dashboards need to be created featuring charts, gauges and tiles to display job status at a glance as well as drill down capabilities. Natural language queries also need to incorporated to enable users to analyze data quickly. Since the dashboard will be used by managers on an ongoing basis, developing a robust and maintainable data model is essential. Security of sensitive costing data should be top priority and appropriate row-level security rules applied. The dashboard needs to support integration with our existing SSO authentication as well. Finally, the developer will be expected to provide documentation for dashboard usage and ongoing enhancements. Experience with construction management systems and Power BI service is preferred. Competitive rates will be offered to the right candidate based on portfolio and experience."
Python application
Design and develop a prototype application with core Python (version 3.7 - 3.10) in Anaconda environment using a Jupyter notebook that demonstrates how data from the given data set (3 csv files – one is a mapping file with 10 rows & other 2 files have data = 150k rows each) can be formatted, reshaped and used to generate specific outputs. The application needs to be a single programme that provides the required functionality. Based on interest & project finalization, further details would be shared. Would require deliverable with original thoughts & structure without any use of AI/Chat GPT or other AI generated content (if it’s AI generated content the project would be cancelled). Require following 2 deliverables - 1st prototype deliverable by 12 December'24 & second deliverable by 15 December'24. Deliverable: 1. Prototype program High level functionality The application should provide the basic functionality to load the initial data set (CSV file, translate it into a suitable format – preferably JSON or XML, JSON with means to back up the format using either files or a database (use an SQL or relational database - set up and populate database via a local host connection), keeping the current state of the data when the program is closed and make it available when the program is reopened. The file will require some cleaning & transformations. A GUI (Python with Tkinter on a Jupyter notebook) to interact with the data set(s) that enables the user to: o Load CSV file o Data transformation o Load transformed data o Manipulate data for desired output 2. Report: Section 1: 1200 words Section 2: 1200 words Section 3: 600 words Specific instructions: use NumPy, Pandas, Seaborn, Matplotlib only + appropriate Python core libraries to access/query a database & the application and its parts must not run concurrently, and must NOT use Python threads.