Shafaqe Bin Faizi Sql, Plsql, Oracle Integration Cloud, DBMS. RDBMS
No reviews yet

SQL/PLSQL and Oracle Integration Cloud (OIC) Developer with 3.7 years of experience in SaaS integrations for Oracle ERP and HCM. Proficient in SQL and PL/SQL development, including stored procedures, functions, triggers, cursors, and performance tuning. Skilled in data extraction, transformation, and optimization, ensuring data integrity through cleaning, deduplication, and standardization.
Expert in Oracle Integration Cloud components (Integrations, Connections, Stage Activities) and adapters (REST, SOAP, File, FTP, DB, ERP, HCM). Hands-on experience with FBDI, HDL, REST/SOAP APIs, and advanced XSLT-based mappings for seamless data flow. Strong understanding of Oracle Financial Modules (AP, AR, GL, FA, P2P Cycle) and reporting tools like BI Publisher and OTBI.
Certified in:
Oracle Database 23ai SQL Certified Associate
Oracle Database 19c Program with PL/SQL
Oracle Fusion Cloud Applications ERP & HCM Process Essentials (Rel 1)
Known for analytical thinking, problem-solving, and clear communication, making complex concepts easy to understand. Passionate about sharing knowledge in SQL, PL/SQL, Oracle ERP/HCM integrations, and OIC workflows with learners at all levels.

Subjects

  • DBMS (Database Management Systems) Beginner-Intermediate

  • SQL Beginner-Intermediate

  • RDBMS Beginner-Intermediate

  • Oracle PL/SQL Beginner-Intermediate

  • Oracle Integration Cloud (OIC) Beginner-Intermediate


Experience

  • Associate (Feb, 2022Present) at 3.7 years of experience as Data Analyst/ SQL/PLSQL/Developer at Cognizant
    Equian Troveris Engagement | PL/SQL, SQL, OIC, XML, JSON
    – Developed stored procedures/packages, crafted SQL queries to optimize financial and transactional processes.
    – Led end-to-end design, development, and Implementation of OIC solutions for seamless application connectivity .
    – Created BI Reports and OTBI Reports tailored to client specifications.
    – Developed inbound integrations to Oracle ERP Cloud for seamless data migration using FBDI and REST APIs
    – Developed outbound integrations to extract transactional data and transfer files to external systems, ensuring automated and reliable data exchange across enterprise applications.
    – Extracted and transformed data from diverse sources. Clean and optimized data, handled missing values, removed duplicates and standardized formats.
    – Automation solutions implemented within the SDLC to improve efficiency and accuracy.
    McDonald-OHCM-OIC Interfaces | OIC, XML, JSON, SQL, PLSQL
    – End-to-end design, development, and Implementation OIC integrations by modularizing components into smaller units, ensuring process continuity with scope-level fault handling for enhanced reliability
    – Developed inbound integrations to HCM Cloud from external systems using the HDL approach for seamless data migration
    – Developed outbound integrations to submit HCM Extracts and transfer files to target systems, ensuring efficient data flow
    – Developed scalable workflows to handle file movement, directory listing, notifications and secure PGP encryption/decryption.
    – Conducted testing and validation of interfaces to ensure they met business requirements, provided ongoing support and troubleshooting for integration issues and documented processes, configurations and changes for future reference.

Education

  • Bachelor of Technology in Computer Science and Engineering (Aug, 2015Jul, 2019) from Government College Of Engineering and Textile Technology, Berhampore

Fee details

    1,0002,000/hour (US$10.5321.05/hour)

    Fee can vary based on the requirements and currency


Reviews

No reviews yet. Be the first one to review this tutor.