Responsibilities: Data Pipeline Design and Implementation: Develop and implement data pipelines that ingest, transform, and load data into a format suitable for machine learning models. Data Quality and Management: Ensure data quality through data cleaning, validation, and transformation processes. Model Development and Deployment: Collaborate with data scientists to develop and deploy machine learning models, including building and testing them. Feature Engineering: Create and select relevant features from the data to improve model performance. Model Monitoring and Maintenance: Monitor model performance and identify areas for improvement. Scalability and Performance: Design and build data infrastructure that can handle large volumes of data and support real-time analytics. Collaboration: Work closely with data scientists, software engineers, and other stakeholders to achieve common goals. Data Security and Compliance: Ensure data security and compliance with relevant regulations. Documentation: Maintain comprehensive documentation for data pipelines and models. Key Skills: Programming Languages: Proficiency in Python Generative Ai: LLM Machine Learning Frameworks: Knowledge of frameworks . Data Warehousing: Experience with data warehousing solutions like Redshift or Panoply. Cloud Computing: Familiarity with cloud platforms like AWS, Azure, or GCP. Data Structures and Algorithms: Strong understanding of data structures and algorithms. Statistical Analysis: Ability to perform statistical analysis and interpret results. Communication and Collaboration: Excellent communication and collaboration skills.
Role Description This is a full-time on-site role located in Pune for a MSSQL DBA at Pansoft Technologies LLC. The responsibilities include database administration, database design, troubleshooting, managing databases, and replication on a day-to-day basis. Qualifications Database Administration and Troubleshooting skills Experience in Database Design and Databases management Experience in Replication of databases Excellent problem-solving and communication skills Ability to work effectively in a team environment Relevant certifications in MSSQL or database administration Bachelor's degree in Computer Science, Information Technology, or related field Job Description 1. Cluster Installation and Setup Cluster Configuration: Install and configure database clustering software (e.g., SQL Server Always On Availability Groups, Oracle Real Application Clusters (RAC), MySQL Group Replication). Example: Setting up a SQL Server Always On Availability Group across multiple nodes to ensure high availability and automatic failover. Node Configuration: Configure and prepare each node in the cluster environment, ensuring each instance has the correct configurations, storage paths, and required access. 2. Cluster High Availability (HA) and Disaster Recovery (DR) Setup Setting up Failover Mechanisms: Configure automatic failover to another node in the cluster to ensure high availability in case of node failure. This could involve configuring failover clustering or database mirroring. Example: Setting up automatic failover between SQL Server instances in an Availability Group. Disaster Recovery Configurations: Implement disaster recovery solutions to ensure minimal downtime and data loss in the event of a catastrophic failure. This may involve off-site replication, synchronous/asynchronous replication, or a standby replica. Example: Configuring a log shipping or Always On secondary replica to a geographically remote site for disaster recovery. Backup Strategy for Clustered Databases: Ensure that backups are correctly configured for the entire cluster, including full, differential, and transaction log backups. Example: Implementing a backup strategy using SQL Server's Backup to URL for cloud-based backups or ensuring backups happen on the primary node and are replicated to secondary nodes. 3. Database Instance and Resource Management Resource Allocation and Load Balancing: Manage the allocation of resources (CPU, memory, I/O) across nodes to ensure optimal performance and prevent resource contention. Load balancing across clustered nodes is often required for distributed databases. Example: Configuring load balancing in SQL Server Always On to distribute query traffic across secondary replicas, ensuring optimal read performance. Clustered Database Performance Tuning: Monitor the performance of the database cluster, identify bottlenecks, and optimize performance. Example: Adjusting the SQL Server MaxDOP (Maximum Degree of Parallelism) setting or tweaking Oracle's Clusterware settings to ensure balanced performance. Scaling the Cluster: Add or remove nodes from the cluster as needed to scale out the database architecture to meet growing demands. Example: Adding an additional node to a MySQL Cluster to handle increased traffic. 4. Database Synchronization and Replication Data Synchronization: Ensure that data across all nodes in the cluster is consistent, particularly for synchronous replication (where changes on the primary node are replicated to secondary nodes in real-time). Example: Managing the replication lag in SQL Server Always On or ensuring Oracle RAC nodes are synchronized with the shared storage for data consistency. Clustered Database Replication Setup: Configure and maintain data replication across multiple nodes in the cluster to ensure availability and redundancy. This can be asynchronous or synchronous, depending on the use case. Example: Setting up SQL Server replication or Oracle Streams for replicating data between primary and secondary cluster nodes. Conflict Resolution: Handle any conflicts that may arise during replication, ensuring that data consistency is maintained across all nodes in the cluster. Example: Resolving conflicts between replicated data using Oracle GoldenGate or ensuring SQL Server replication conflicts are handled automatically. 5. Database Cluster Monitoring and Alerts Cluster Health Monitoring: Set up continuous monitoring of the cluster for performance metrics, system health, and failover status. This involves checking for disk space, CPU usage, memory consumption, and any cluster-related errors or warnings. Example: Using SQL Server Management Studio (SSMS) or Oracle Enterprise Manager to monitor cluster status and alert the DBA team on potential issues (e.g., replication delays, node failure). Alerts and Notifications: Implement alerting mechanisms to notify administrators of failures, performance degradation, or other critical issues within the cluster. Example: Setting up SQL Server Agent or Oracle Grid Control to send alerts if a cluster node fails or if the replication process is behind schedule. Role & responsibilities Preferred candidate profile
Oracle Fusion EPM Lead Consultant Designation Functional Lead Consultant EPM Job Description • Candidates having good Knowledge in Fusion EPM • Should have 8 to 10 Years’ Experience in Oracle Fusion EPM • Should be able to handle independently • Should have the Knowledge in Oracle Fusion • Should have Implemented the 8 to 10 Projects in EPM • Minimum 4 Projects On-Site Experience with GCC Countries Knowledge • Important & Mandatory Modules are FCCS/Planning & Budgeting/ARCS/Narrative Reporting. Remaining Modules are added Advantage Desired Profile • Good team player with excellent verbal and written communication skills, presentation skills, interpersonal skills, customer handling capabilities • Should be Proactive and have analytical thinking abilities. • Demonstrate ability to work independently as well as a Team Lead. • Proficient in documentation and well versed with MS-Word, Excel, Power point • Willingness to learn and adapt to the latest business applications. • Should be able to handle the Team and Build EPM Practice • Willingness to travel abroad. Experience 8 - 10 Years of Industry experience Preferred candidate profile
Job Description Oracle Fusion Finance Consultant (Permanent) Role: Oracle Fusion Finance Consultant (Permanent, Full-time ) Work Mode & Location: WFO — Viman Nagar, Pune (no WFH) Travel: Open to onsite in the Middle East (e.g., KSA/Qatar/UAE) ; onsite work to be performed at the client location or respective Pansoft office Start: ASAP (30-day notice preferred) Primary Responsibilities Own L2/L3 support and enhancements for Oracle Fusion Financials (GL, AP, AR, FA, CM, Tax) with strict SLAs. Lead configurations, issue triage, RCA , and Oracle SR management; drive month-end/period-close support. Deliver change requests (BRD MD50/Setup SIT/UAT PROD move) with complete documentation. Build and maintain reports/integrations : OTBI, BI Publisher, FBDI/ADFdi , and OIC (REST/SOAP) . Govern security (roles, data access sets), COA/LE/Ledger design, SLA rules, and Tax setups (KSA/GCC). Coordinate data migration , UAT , user training, and hypercare. Added Advantage (Strong Preference) Hands-on with Oracle E-Business Suite (R12.2) Finance (GL/AP/AR/FA/CM), including EBS Fusion mapping , data conversion, and cutover experience. Qualifications 5–10 years total, with 2+ end-to-end Fusion implementations and steady L2/L3 support exposure. Deep knowledge of P2P/O2C , multi-currency, intercompany, and reconciliation processes. Proficiency with OTBI/BIP, FBDI/ADFdi, OIC , and REST/SOAP integrations. Excellent client communication, stakeholder management, and documentation discipline. Oracle Fusion Financials certification is a plus. Nice to Have Exposure to ZATCA/KSA tax/e-invoicing contexts. Experience with EBS to Fusion transition programs. Travel: Open to onsite in the Middle East (e.g., KSA/Qatar/UAE) ; onsite work to be performed at the client location or respective Pansoft office Start: ASAP (30-day notice preferred) Primary Responsibilities Own L2/L3 support and enhancements for Oracle Fusion Financials (GL, AP, AR, FA, CM, Tax) with strict SLAs. Lead configurations, issue triage, RCA , and Oracle SR management; drive month-end/period-close support. Deliver change requests (BRD MD50/Setup SIT/UAT PROD move) with complete documentation. Build and maintain reports/integrations : OTBI, BI Publisher, FBDI/ADFdi , and OIC (REST/SOAP) . Govern security (roles, data access sets), COA/LE/Ledger design, SLA rules, and Tax setups (KSA/GCC). Coordinate data migration , UAT , user training, and hypercare. Added Advantage (Strong Preference) Hands-on with Oracle E-Business Suite (R12.2) Finance (GL/AP/AR/FA/CM), including EBS Fusion mapping , data conversion, and cutover experience. Qualifications 5–10 years total, with 2+ end-to-end Fusion implementations and steady L2/L3 support exposure. Deep knowledge of P2P/O2C , multi-currency, intercompany, and reconciliation processes. Proficiency with OTBI/BIP, FBDI/ADFdi, OIC , and REST/SOAP integrations. Excellent client communication, stakeholder management, and documentation discipline. Oracle Fusion Financials certification is a plus. Nice to Have Exposure to ZATCA/KSA tax/e-invoicing contexts. Experience with EBS to Fusion transition programs.
Role & responsibilities Key Responsibilities 1) Implementations & Enhancements Run workshops, document requirements & fitgap; produce solution designs and configuration workbooks. Configure Fusion SCM modules, approval rules (BPM), document styles, and extensions where appropriate. Build end-to-end designs including P2P (RequisitionPOReceiptInvoice hand-off) and O2C (ItemOrderShipInvoice hand-off). Own CRPs/SIT/UAT, training materials, user adoption, and cutover/hypercare. Author deliverables (requirements, functional design, configuration/BR100-style setup docs, test scripts, cutover plans). 2) Support & Quarterly Updates L2/L3 incident/problem management with root cause analysis; drive SRs with Oracle. Regression test & implement quarterly updates (opt-in features), impact analysis, and release notes for business. Own data fixes, small enhancements, and performance troubleshooting. Maintain knowledge base, SOPs, and KT to operations. 3) Migrations (EBS Fusion and tenant-to-tenant) Lead object mapping, data cleansing, and FBDI/ADFdi -based conversions (Suppliers, Items/Structures, Catalogs, On-hand, Price Lists, Open POs/SOs, BOM/Routings, Cost elements). Sequence loads; reconcile counts; design cutover & fallback; execute mock runs with sign-offs. Rationalize legacy RICEW scope; propose standardization vs extensions. Plan and validate co-existence (if phased) and decommission steps. 4) Integrations & Reporting (techno-functional) Design/validate integrations with WMS/3PL, finance/AP, tax/e-invoicing, logistics, and legacy ERPs via Oracle Integration Cloud (OIC) , REST/SOAP APIs, file drops, or scheduled processes. Build reports/dashboards using OTBI and BI Publisher ; create burst distributions and schedules. Configure security (custom job/duty roles, data security), Sandboxes, Page Composer. Use SQL (and basic PL/SQL) for triage; leverage Postman/Swagger for API tests. Qualifications Experience: 5–12+ years total; 3–8+ years on Fusion SCM with at least 2 end-to-end implementations and one migration (EBSFusion or equivalent). Solid hands-on in the core modules listed, BPM approvals, FBDI/ADFdi, OTBI/BIP, REST/SOAP; strong process knowledge in P2P & O2C. Prior EBS SCM exposure (PO, iProc, INV, OM, BOM/WIP) is a strong plus. Bachelor’s in Engineering/IT/Business (or equivalent). Oracle Cloud certifications in SCM are a plus. Soft Skills Excellent client-facing communication, workshop facilitation, and stakeholder management. Ownership mindset, ability to work independently across offshore/onsite models, and mentor juniors. Deliverables (indicative) Requirements & Fit–Gap docs, Solution Design, Config workbooks, Test scripts & traceability, Data migration plan & reconciliation logs, Integration design & mappings, Security matrix, Cutover plan, Hypercare runbook, SOPs. Nice-to-Have Experience with OIC adapters , PIM extensibility (Application Composer), and light VBCS UI extensions. E-invoicing/Government integrations (e.g., ZATCA or similar). Exposure to Planning/Manufacturing/Maintenance/GOP.