Prerna Kumari Singh
Bengaluru
Summary
Certified Oracle Cloud Platform (OIC, VBCS, Fusion, oracle database) developer with extensive experience in PaaS, cloud applications, and integrations. Skilled in developing responsive VBCS web apps, using Knockout JS, and integrating with Oracle Fusion using OIC and ICS. Led key projects including ALNG and ACS CX at Oracle, working on cloud storage integration, OCI functions, and UAT testing. Previously worked with Mastek on complex integration scenarios with Oracle ERP Cloud, leveraging REST, SOAP, and middleware solutions. Strong expertise in SQL/PL-SQL, problem-solving, and delivering successful solutions in cloud environments. Recognized for excellent communication and customer handling skills
Overview
4
4
years of professional experience
1
1
Certification
Work History
Oracle Consultant
Oracle
07.2024 - Current
- ALNG Project: Developed a responsive VBCS web app for creating pre-receipts in Oracle Fusion, enabling seamless data entry and validation. Utilized Knockout JS for declarative binding, automatic UI refresh, and templating. Integrated backend data using ICS services to store and fetch data from database, ensuring smooth interaction between the app and Fusion. Additionally, integrated VBCS app pages with Fusion middleware for seamless communication between the frontend and backend systems.
- ACS CX Project: Developed a VBCS extension for uploading/downloading files to Oracle Cloud Storage, enabling users to manage documents directly within the Oracle Cloud environment. Created a history validation table to track the status of uploaded files and ensure data consistency. Worked on building and deploying micro services and 5 OCI functions, providing custom functionality to enhance application performance. Gained hands-on exposure to the Ora Hub platform for advanced cloud integrations. Collaborated with the team through UAT/Production testing to ensure smooth deployment and post-launch support.
- Technologies: Visual Builder Cloud Services (VBCS), Oracle Integration Cloud (OIC), OCI, Microservices, Knockout JS, JavaScript, SQL, PL/SQL.
Consultant
Mastek(Evosys Pvt. Ltd.)
04.2021 - 06.2023
- South Lanarkshire Project: Developed and delivered Making Tax Digital (MTD) solution, a PaaS extension designed to enable users to file VAT returns directly from Oracle ERP Cloud without navigating to HMRC website. This extension improved accuracy and efficiency of tax filings for users. Designed and implemented RPF Extension (NOPO), enabling invoice creation via REST services and seamless tracking in Oracle Fusion. Additionally, developed Journal Creation Form (JCF) extension using a FBDL approach, allowing users to manage and track journal entries within Fusion Financials, ensuring accuracy and reducing manual intervention in financial processes.
- Argyll & Bute Council Project: Developed a CIS Tax Returns Solution, enabling organizations to file CIS Tax Returns directly to HMRC from Oracle ERP Cloud, ensuring compliance with HMRC regulations. Worked on the Accounts Payable (AP) and General Ledger (GL) Integrations, creating seamless interfaces between Oracle Fusion and external payment systems to automate financial transactions. Developed an Integration Dashboard using VBCS to track and visualize the status of AP/GL files processed through the integrations, providing real-time visibility and control to users.
- Technologies: Visual Builder Cloud Services (VBCS), Oracle Integration Cloud (OIC), REST, SOAP, XML, JSON, SQL, PL/SQL.
Education
B.Tech -
Trident Academy Of Technology, IT
Bhubaneswar01.2021
Intermediate -
Kendriya Vidyalaya
Jharkhand01.2017
SSC -
Kendriya Vidyalaya
Jharkhand01.2015
Skills
- Oracle web-services
- PaaS
- Fast API
- OCI Function
- Oracle Fusion
- Oracle Integration cloud (OIC)
- Visual Builder Cloud Service (VBCS)
- PL-SQL programming
- Oracle Integration cloud Development
- Oracle VBCS web App Development
- PaaS/SaaS
- BIP Report integration
- FBDI Integration
- AP/GL/OTP Integration
- Oracle SOAP API’s
- ORDS rest API's
- Xml/Xpath/xslt
- Database Handling
- Postman
- Oracle SQL Developer
- Oracle 11g/12c
- WinSCP
- Netbeans
- Eclipse
- Visual Builder Studio
Certification
- Oracle Cloud Infrastructure 2024 Generative AI Certified Professional
- Oracle Database Program with PL/SQL (1Z0-149)
- Certified Oracle Cloud Platform Application Integration 2021 Specialist
- Oracle Cloud Infrastructure 2023 AI Certified Foundations Associate
- Oracle Cloud Infrastructure 2023 Certified Application Integration Professional
- Oracle Redwood Application 2023 Certified Developer Associate
Languages
English
Hindi
Courses
- Completed javascript course from UDEMY
- Certificate from Quantumware on completing the MVC project internship
- Completed the Certification Course In J2SE Programming Language From NIIT
- Completed the Certification Course In J2EE From NIIT
- Completed the Certification Course In C Programming Language From NIIT
Designation
Oracle staff Consultant
Personal Information
- Phone : 7327967554
- Date of Birth: 01/12/00
- Nationality: Indian
Timeline
Oracle Consultant
Oracle
07.2024 - Current
Consultant
Mastek(Evosys Pvt. Ltd.)
04.2021 - 06.2023
- Oracle Cloud Infrastructure 2024 Generative AI Certified Professional
- Oracle Database Program with PL/SQL (1Z0-149)
- Certified Oracle Cloud Platform Application Integration 2021 Specialist
- Oracle Cloud Infrastructure 2023 AI Certified Foundations Associate
- Oracle Cloud Infrastructure 2023 Certified Application Integration Professional
- Oracle Redwood Application 2023 Certified Developer Associate
B.Tech -
Trident Academy Of Technology, IT
Intermediate -
Kendriya Vidyalaya
SSC -
Kendriya Vidyalaya
Similar Profiles
BRANDON HAYESBRANDON HAYES
System Analyst II at OracleSystem Analyst II at Oracle
Alex PerrineAlex Perrine
Cybersecurity Analyst I at OracleCybersecurity Analyst I at Oracle
Farhat SafiFarhat Safi
Director of Integration Strategy, Construction & Engineering GBU at OracleDirector of Integration Strategy, Construction & Engineering GBU at Oracle