Oracle Pl Sql Projects

Oracle EBS Consultant

Oracle E-Business Suite (EBS) Consultant – Functional & Technical (R12) Experience: 10+ years in Oracle EBS (R12) Skills: • Functional expertise across Finance, Procurement, SCM, Projects, HR modules • Technical proficiency: PL/SQL, Oracle Forms/Reports, OAF, ADF Responsibilities: • Support, stabilize, and enhance Oracle EBS R12 environment • Perform fit-gap analysis, configure modules, and develop customizations • Handle integrations, testing, user training, and documentation

Power BI Data Analyst (PL-300) Certification Trainer

##Trainer Needed: Intensive 3-Day Preparation for Microsoft Power BI Data Analyst (PL-300) Certification ### Project Overview I am a Business Analyst professional seeking dedicated, expert-led training to prepare for and pass the **Microsoft Power BI Data Analyst (PL-300) Exam**. I am looking for an instructor who can provide a fast-track, highly focused training experience, ideally delivered live and hands-on, covering every exam objective in depth. While the recommended experience level for this type of intensive training is intermediate, I require a comprehensive learning structure suitable for a professional serious about attaining this certification. ### Trainer Qualifications (Required) The ideal freelancer will possess the following background and expertise: 1. **Certification and Experience:** Must be a well experienced trainer, preferably a **Microsoft Certified Trainer (MCT)**, specializing in practical data solutions. 2. **Specialized Tools:** Expertise must include **Power BI, Excel, and Power Query**. 3. **Teaching Style:** Must bring a practical teaching approach with a focus on real-world scenarios and proven exam techniques. 4. **Content Delivery:** Able to provide interactive, live instruction and guide me through hands-on labs and exercises. ### Scope of Work and Training Objectives The training must be intensive, focused on transforming raw data into actionable insights using Power BI's advanced features, and designed to cover all necessary content for the PL-300 exam, potentially within a short timeframe (such as 3 days of intensive instruction). The training must cover the following core areas based on the PL-300 exam structure: #### 1. Get started with Microsoft data analytics * Essential insights into how data analysts use Power BI to drive informed business decisions. * Topics include: Discover Data Analysis, Get started building with Power BI, and creating interactive reports using Copilot for Power BI. #### 2. Prepare data for analysis with Power BI * Focus on using **Power Query** to extract data from different data sources, choosing storage modes and connectivity types. * Topics include: Getting data in Power BI, and cleaning, transforming, and loading data in Power BI before modeling. #### 3. Model data with Power BI * Instruction on what a Power BI semantic model is and which data loading approach to use. * Key modules include: Describing Power BI Desktop models, choosing a Power BI model framework, writing **DAX formulas** for models, adding measures, using DAX time intelligence functions, optimizing models for performance, and enforcing model security. #### 4. Build Power BI visuals and reports * Focus on turning data into interactive, actionable insights. * Topics include: Scoping report design requirements, designing Power BI reports, creating visual calculations, configuring report filters, enhancing report designs for user experience, and performing analytics in Power BI. #### 5. Manage workspaces and datasets in Power BI * Learning how to publish Power BI reports to the Power BI service. * Key modules include: Creating and managing workspaces, managing semantic models, creating dashboards, and implementing **row-level security**. ### Project Expectations * **Format:** Live, interactive instruction is crucial. * **Methodology:** Training must include real-world exercises and hands-on labs to ensure readiness for the exam. * **Support:** Guidance on certification logistics, including preparing for the exam itself and understanding the exam structure/question types, is highly valued. * **Quality:** I am seeking premium training equivalent in quality to high-end bootcamps, which often charge over $2,000 for similar content, but offered at a smart price suitable for an individual investment. ### Deliverables The primary deliverable is comprehensive training that provides the skills and confidence required to master Power BI and successfully pass the Microsoft Certified: Power BI Data Analyst Associate Exam (PL-300).

Transact SQL help

I have an OK knowledge of Transact SQL but struggle with more complex queries. I'm looking for someone who can help me create the queries that I need on an on-going basis. Typically my requests will be for help with specific queries and each one will almost certainly be no more than an hour at a time. So very short, sharp 'projects'. So I'm looking for a longer term 'helper' who I can call upon when needed. I *might* be interested in a one-to-one on-line session to get a better understanding of TSQL queries.

JS/TS + SQL Developer for Retool & API Integration (Long-Term)

// Please note: only contact me on the peopleperhour platform. **Why this project is worth your time**
 We’re offering a long-term opportunity to join a small, agile team working on meaningful automation tools. You don’t need prior Retool experience. You’ll learn it as part of the job while applying your strong core development skills. Here’s why this project stands out: • Learn Retool on the job — a fast-growing low-code platform that makes developers dramatically more productive. • Core tech focus — you’ll work daily with JavaScript/TypeScript, SQL, and APIs, solving real data and integration problems. • Long-term collaboration — not a one-off gig; we’ll continuously expand and improve automation over the coming years. • Growth potential — as the project evolves, there may be opportunities to expand into React, fullstack, or even AI-driven automation. • Direct impact — your work won’t disappear into a big codebase; it will immediately improve processes and be used by real people. You will be leading the technical development of this project. **What you should know before applying**
 This role is not for everyone. We run a structured recruitment process with multiple steps: a code reasoning challenge, culture fit interview, skills test, and a paid mini-project. Above all, we value problem-solving ability and mindset. If you’re looking for quick, low-effort gigs, or you’re not comfortable explaining your reasoning and constructively challenging ideas (and being challenged in return), this role won’t be a fit. We’re open to starting at a lower hourly rate for the right candidate, with the clear expectation that the rate will increase as trust is built and responsibilities grow. This is a long-term collaboration, and we want the developer who joins us to feel valued and fairly compensated as the project evolves. **How to apply** 1. First, read the full description here so you don’t miss anything: https://docs.google.com/document/d/1ogwl5INweUCKmHsthUToKIjhfAK4rSHR/ 2. At the **top of your message or comment**, answer these three questions (number each answer): a. Tell us about a time you proposed a different approach that improved the outcome. b. Share a link to your GitHub and/or website (mention any repos you’re proud of). c. What hours during the day can you work? Write them in **GMT+0**. Please keep all communication on PPH, no off-platform messages.

urgent

I need a logo design for my new beauty business

The business is called Youngish It’s a beauty brand / blog Run by a 45yr old woman helping other women 40yrs pls look young-ish

Audio typing of residential home surveys

Looking for audio typist for holiday cover. Experience of residential surveys preferred (RICS Level 2 and Level 3). Must be accurate and pay attention to detail. UK based only pls. Some proofreading work also.

opportunity

Need Senior Data Engineer

We are seeking an experienced Senior Data Engineer to join our dynamic team. The ideal candidate will possess a robust background in data architecture, data warehousing, and ETL processes. Responsibilities include designing and implementing scalable data pipelines, optimizing data storage solutions, and ensuring data quality and integrity. Proficiency in programming languages such as Python and SQL, along with experience in cloud platforms like AWS or Azure, is essential. The successful applicant will demonstrate strong analytical skills and the ability to collaborate effectively within a team-oriented environment.

Looking for FullStack Developer

We’re looking for a Full-Stack Developer with excellent English skills to join our international team. This role is both technical and client-facing—you’ll code (front-end, back-end, APIs, cloud) while also joining client calls, ensuring clear communication, and helping translate requirements into tasks for our developers. We need someone with: -Strong English (C1+ or native-level). -Solid full-stack development skills (React/Angular/Vue + Node.js/Python + SQL/NoSQL + cloud). -Good problem-solving and communication skills. Bonus if you’ve worked with CRMs (HubSpot/Salesforce), project tools (Jira/Trello/Asana), or have previous client-facing experience.

MIS Data Automation

We are seeking an experienced freelancer to automate our Management Information System (MIS) reports through advanced scripting techniques. The ideal candidate will possess expertise in Python scripting for data automation and handling, as well as proficiency in Visual Studio for development and integration. Key responsibilities include automating daily and weekly MIS reports, developing scripts for repetitive data tasks, and optimizing dashboards using tools such as Excel or Power BI. Additionally, strong database management skills in SQL, MySQL, or MS Access are essential. Preference will be given to freelancers based in Mumbai, with opportunities for project-based engagement that could evolve into long-term collaborations.

Data service

We're seeking a skilled AI Data Science expert to build and deploy machine learning models for our [e.g., e-commerce/analytics platform]. You'll analyze large datasets, develop predictive algorithms, and integrate AI solutions to optimize business processes. This is a freelance project with potential for ongoing work. Budget: [Specify your budget, e.g., $X - $Y]. Timeline: [e.g., 4-6 weeks initial phase].Key Responsibilities Collect, clean, and preprocess large datasets from various sources (e.g., SQL databases, APIs, CSV files). Design and implement machine learning models using frameworks like TensorFlow, PyTorch, or Scikit-learn for tasks such as classification, regression, NLP, or computer vision. Perform exploratory data analysis (EDA) and feature engineering to uncover insights and improve model performance. Train, validate, and tune models with techniques like cross-validation, hyperparameter optimization (e.g., GridSearch, Bayesian optimization), and handle overfitting/underfitting. Deploy models into production environments (e.g., via Docker, AWS SageMaker, or Flask APIs) and monitor performance with tools like MLflow or TensorBoard. Integrate AI features, such as recommendation systems or anomaly detection, into existing applications. Collaborate on data pipelines using tools like Apache Airflow, Spark, or Pandas for ETL processes. Document code, models, and findings; provide reports and visualizations (e.g., using Matplotlib, Seaborn, or Tableau). Ensure ethical AI practices, including bias mitigation and data privacy compliance (e.g., GDPR).

I want to build cross-platform React Native App from Figma

I am looking for an experienced developer to build a cross-platform mobile app using React Native with a Node.js backend, and publish it on both Google Play Store and Apple App Store. I already have a complete Figma design (UI/UX) for the entire app. Your responsibility will be to turn the design into a fully functional, production-ready mobile application. ✅ Scope of Work: Convert Figma designs into a polished React Native cross-platform app (Android & iOS). Develop a Node.js backend (with database, authentication, APIs, etc.). Implement all required app features (authentication, push notifications, real-time data handling, etc.). Ensure smooth navigation, responsiveness, and optimized performance. Set up and configure backend hosting (e.g., AWS, Firebase, or similar). Add app icons, splash screen, branding, and handle platform permissions. Conduct thorough testing & QA before release. Assist with publishing the app to both the App Store and Play Store (handling certificates, signing, and requirements). ✅ Requirements: Proven experience in React Native cross-platform app development. Strong skills in Node.js + database integration (SQL or NoSQL). Knowledge of API development & integration. Experience with app store publishing process (iOS + Android). Good communication and ability to provide regular updates. ✅ Deliverables: Fully functional React Native mobile app (Android & iOS). Node.js backend with complete API and documentation. Published apps live on both app stores. Full source code (frontend + backend) and deployment instructions.

Adobe Experience Manager (AEM) Developer – Remote (Philippines)

Technoledge LLC is seeking a skilled Adobe Experience Manager (AEM) Developer to join our delivery team. The ideal candidate will have extensive expertise in AEM, with a proven track record of designing and implementing innovative, scalable, and high-performance web solutions. This role involves collaborating with stakeholders to enhance enterprise digital platforms through robust AEM-driven solutions. Key Responsibilities Component and Template Development Design and develop customized AEM components, templates, and pages using HTL (Sightly), Sling Models, and Java. Leverage expertise in metadata management, taxonomy, and tagging to create effective AEM solutions. Content Management Streamline content publishing and unpublishing workflows for efficiency and accuracy. Plan and execute seamless content migration strategies to minimize downtime and ensure continuity. Replication and Deployment Configure and manage forward and reverse replication processes within AEM environments. Oversee AEM deployment pipelines using Maven to ensure reliable builds and deployments. Workflow and Automation Develop custom AEM workflows to optimize content authoring and publishing processes. Implement automated solutions for efficient content updates and management. Performance Optimization Enhance AEM performance using Adobe Dispatcher for caching and load balancing. Apply best practices for content delivery, including integration with AEM’s Content Delivery Network (CDN). AEM Architecture Design scalable AEM architectures leveraging OSGi, Apache Sling, and Apache Oak. Collaborate with cross-functional teams to integrate AEM solutions with enterprise systems. Analytics Integration Partner with analytics teams to integrate Adobe Analytics with AEM, enabling precise tracking of user interactions and content performance. Required Skills and Experience >6+ years of hands-on experience with AEM (version 6.4 and above). >Proficiency in developing AEM components, templates, and pages using HTL (Sightly), Java, and >Sling Models. >Strong knowledge of AEM replication mechanisms, including forward and reverse replication. >Deep expertise in OSGi, Apache Sling, and Apache Oak. >Proficient in Java 11 and above. >Experience with AEM solution development and deployment using Maven and related build tools. >Strong skills in HTML, CSS, JavaScript, and HTL (Sightly). >Familiarity with front-end frameworks such as React or Angular is a plus. >In-depth understanding of Adobe Dispatcher for optimizing AEM performance. >Knowledge of AEM security best practices, including user management, access controls, and vulnerability mitigation. >Experience integrating Adobe Analytics with AEM for effective tracking and reporting. Preferred Qualifications Adobe Certified Expert (ACE) in AEM or related certifications. Experience with CI/CD pipelines and DevOps practices in AEM environments. Familiarity with databases such as Oracle, PostgreSQL, or MongoDB. Strong understanding of software development best practices and design patterns. Ability to thrive in an agile, fast-paced development and prototyping environment.

Business Development Manager (Agency)

We are seeking a Business Development Manager to join our agency team. The ideal candidate will have experience in developing and executing business strategies to drive growth and expand our client base. This role requires strong communication skills and the ability to build and maintain client relationships. We’re a performance-driven digital marketing agency helping brands scale with content, social, email, and AI-powered lead generation. The Role We’re hiring a Business Development Manager to win new clients every month by: Proactively applying to relevant opportunities (Upwork, LinkedIn, RFP portals). Sourcing and qualifying prospects in Real Estate, SaaS, IT/Tech, and Finance. Running outbound campaigns that book discovery calls and convert deals. What You’ll Do Pipeline Ownership: Build and manage a qualified pipeline across target verticals (Real Estate, SaaS, IT/Tech, Finance) in priority markets (UK, North America, APAC, Middle East). Sourcing & Outreach: Daily outreach via LinkedIn, email, and curated job boards/marketplaces Apply to brief-based openings with tailored proposals. Discovery & Proposals: Run needs analyses, shape solutions with our service leads, craft proposals/SOWs, and negotiate terms. Account Handover: Close/warm-close and coordinate smooth onboarding with Delivery/CS. Services You’ll Sell Digital Marketing & Content Marketing (SEO content, blogs, thought leadership, lead magnets) Social Media Marketing (strategy, calendars, creative, paid social) Email Marketing & Marketing Automation (flows, campaigns, list growth) Sales & Lead Generation (B2B outbound, list building, appointment setting, funnel assets) Success Looks Like (KPIs) Monthly: 40–60 new, verified prospects added to pipeline 20–30 intro messages sent/day with consistent follow-ups 12–16 SQL meetings booked 3–5 new paying clients (mix of retainers and projects) You’ll Thrive If You Have 3–6 years in agency BD / growth selling digital marketing or MarTech services. Proven wins in Real Estate and at least one of SaaS / IT / Finance. Strong proposal writing & consultative selling skills (ROI, case studies, unit economics). Excellent English; extra points for UK/US market experience. Nice to Have Experience with AI-assisted prospecting, lead-gen workflows, or marketing automation. Existing network of decision-makers (CMO, Head of Growth, Founders) in target verticals. Deliverables Develop and execute business strategies Identify new business opportunities Build and maintain client relationships Collaborate with internal teams Analyze market trends

Shopify Wofklows (pipedrive, airtable)

Job Specification – Automation Specialist Role Overview We are seeking an Automation Specialist to design, build, and maintain automated workflows that streamline operations and improve customer engagement for our Shopify-based e-commerce business. The role involves creating integrations, triggers, and workflows across Shopify, Airtable, Pipedrive, and other SaaS tools, ensuring smooth data flow and efficient handling of events like abandoned carts, order management, and customer support ticketing. This role requires both technical execution (automation building, API connections, workflow testing) and business thinking (understanding customer journey, sales pipeline, and operations). ⸻ Key Responsibilities • Workflow Design & Implementation • Develop and maintain automated workflows across Shopify, Airtable, and Pipedrive. • Create workflows for e-commerce scenarios such as abandoned cart recovery, order follow-ups, upsell triggers, and customer segmentation. • Automate ticket creation for sales and support teams (e.g., when a cart is abandoned, generate a Pipedrive deal or Airtable task). • Systems Integration • Connect Shopify data (customers, orders, carts, products) to Airtable and Pipedrive. • Implement data syncing and ensure real-time accuracy across platforms. • Build error handling and logging processes to track automation health. • Optimization & Monitoring • Analyze workflow performance, propose improvements, and optimize for higher conversion (e.g., abandoned cart win-back rates). • Document all workflows and create SOPs for internal teams. • Ensure workflows align with business KPIs (sales growth, efficiency, customer experience). • Collaboration • Work closely with the marketing, sales, and operations teams to understand needs and translate them into automated solutions. • Train team members to use and monitor automation tools. ⸻ Requirements • Technical Skills • Hands-on experience with Shopify (Admin API, webhooks, checkout flows). • Strong knowledge of Airtable (bases, automations, formulas, API). • Experience with Pipedrive CRM (stages, deal creation, workflow automations). • Familiarity with workflow automation tools (e.g., n8n, Zapier, Make, or custom scripting with Python/JS). • Understanding of APIs, JSON, and webhook-based integrations. • Business & Analytical Skills • Experience in e-commerce automation (abandoned cart recovery, customer lifecycle flows, lead qualification). • Ability to map workflows from business requirements to technical execution. • Strong analytical mindset; able to measure workflow impact and optimize. • Soft Skills • Detail-oriented and structured. • Able to work independently while collaborating with non-technical teams. • Strong documentation and communication skills. ⸻ Desirable (Nice-to-Have) • Experience with HelpScout, Klaviyo, or other email/CS platforms. • Understanding of sales funnels and marketing automation. • Knowledge of SQL or database design for reporting. • Prior work in Shopify e-commerce environments. ⸻ Success in This Role Looks Like • Abandoned carts automatically trigger personalized recovery sequences in Pipedrive/Airtable. • Orders, customers, and product data flow seamlessly between Shopify, Airtable, and Pipedrive. • Manual tasks (like updating deals, creating support tickets, logging order data) are reduced by 80%+. • Team members have clear SOPs and visibility into workflow performance.