Aleksandar Bahchevanov

Oracle Fusion Cloud reimplementation :

- OIC Integrations

- VBCS extensions

- BIP reports

Delivered key integrations between Oracle Fusion Cloud and Oracle EBS R12, covering the following business entities:

• Purchase Orders
• Items
• Item Relationships
• Item Categories
• Suppliers
• GTINs

The solution stack included Oracle Integration Cloud (OIC), Autonomous Transaction Processing (ATP), and BI Publisher (BIP). Data is pushed from Fusion to EBS and created using RESTful web services. Responsible for full-cycle development and deployment of these integrations from design to production.

• New Hire Sync project (DEV, UAT, PROD)
  Senior Technical Consultant responsible for delivering integration between SmartRecruiters and Oracle Fusion HCM Cloud for pending worker creation, worker updates, and rehire scenarios. Scope included person data maintenance, work relationship and assignment updates, manager hierarchy updates, salary processing, and Individual Compensation creation for hello/signing bonus scenarios.

HCM Modules: Core HR, Workforce Compensation / Individual Compensation
Functional Areas: Pending Workers, Person Management, Work Relationships, Assignments, Manager Hierarchy, Salary, EFFs

- OIC integrations

- BIP reports

- PL/SQL stored procedures

- HDL ( Work Scheduled creation)

• Onboarding module project (DEV, UAT, PROD)
  Senior Technical Consultant responsible for delivering integration between SmartRecruiters and Oracle Fusion HCM Cloud to process onboarding web form submissions, encrypt sensitive information, and create/update data across multiple HCM areas. Scope included personal and legislative information, identifiers, addresses, phones, extra information, emergency contacts, child/dependent information, document records, payroll-related information, and bank account setup for Payroll and Expenses, including Payee, Personal Payment Method, and bank account association.

HCM Modules: Core HR, Onboarding, Payroll
Functional Areas: Person Management, Personal Information, Legislative Information, Contacts and Dependents, Document Records, Bank Accounts, Personal Payment Methods, Payroll Information, EFFs

Approach used:

- OIC integrations

- PL/SQL stored procedures

- BIP reports

• Citco CBC project (DEV, UAT)

Senior technical resource to deliver an integration from a Citco Billing Centre app to Oracle Fusion Projects. The integration creates project draft invoices and expenditures in Fusion Cloud and runs custom reports ( print AR transactions).

- PL/SQL procedures to invoke Fusion REST APIs which validates logged in user, gets project details, queries project draft invoices, approves submitted invoices, gets/adjusts expenditure items(project costs).

- PL/SQL procedures to invoice Fusion SOAP services which calls Fusion BIP reports ( Print AR transactions , Generate Invoices ESS job, )

• SMBC project (DEV, UAT, PROD)
  Technical Lead and Senior Development Consultant responsible for delivering complex reporting, integrations, extensions, and document customizations across Oracle Fusion HCM Cloud and Oracle Fusion ERP Cloud. The project covered Payroll, Absence Management, and Talent Profile / Competencies on the HCM side, and Accounts Payable, Accounts Receivable, Procurement, General Ledger / Financial Reporting, and Tax on the ERP side. Scope included development of BI Publisher, OTBI, OAC, and FRS reports, OIC integrations, VBCS extensions, and customization of output documents and online documents.

HCM Modules: Core HR, Payroll, Absence Management
ERP Modules: Accounts Payable, Accounts Receivable, Procurement, General Ledger / Financial Reporting, Tax

Functional Areas: Payroll reporting and payslips, statutory payroll reporting, absences, employment profile, competencies, transaction reporting, VAT, financial statements, invoice and purchase order document customization, and online payslip delivery.

• Life Capital (SwissRE) project ( DEV,UAT,PROD) - Excellence Awards 2020 - Project of the year

Senior Technical resource to integrate Oracle Fusion Cloud with 3rd party systems using Oracle Integration Cloud (PaaS).

- Create AP invoices coming from Coupa system using App driven orchestration integration in OIC.

- Maintain staging area (Oracle ATP database to validate the incoming payload).

- Use Oracle REST APIs to create the invoice, SOAP web service to validate/create GL accounts.

- Create Expense reports in Oracle Cloud from GREET system using App driven orchestration integration in OIC.

- Use Oracle ATP database to validate the incoming payload.

- Use Oracle REST APIs to create the business entities in SaaS and SOAP web services to validate/create GL accounts.

- Create Employee bank accounts in Oracle cloud using App driven orchestration integration in OIC.

- Build files and upload to Oracle UCM using SOAP web services.

- Invoke ESS jobs to load the files via HCM loader.

- Support SIT phase, Fix bugs, apply changes to existing integrations.

- Use GIT Extensions to create pull requests.

- Use Azure DEVOPS for bug tracking and code repository.

- HDL to load employee bank accounts

• University of Birmingham project( DEV,UAT, PROD)

- Senior Technical resource responsible for ALL BI output documents customizations and BIP/OTBI custom reports/dashboards.

- Actively participate in solution design, technical/functional specifications, build (often leading and KT to other colleagues), unit test, UAT support and deployment steps.

- Configure and admin the whole ticketing system (MTM/TFS) and source control (BitBucket using SourceTree and Git).

- Work on site with business users during key milestones and support all UAT to PREPROD to PROD activities in BI area.

- Establish good relationships with key business users in FCSM - GL (build very complex reports to drill down from GL to based modules), AR, AP, Procurement and Projects area.

- HCM Cloud – Workforce structures, Person Management, Payroll Regulatory and Tax Reporting (PAE letters).

- Configure custom security roles and implement complex logic in custom BI reports to mirror the same security restriction as in OTBI reports.

- Build complex BI publisher reports with dynamic tab creation in Excel to support rows limitation in BIP.

- Build custom ESS jobs and job sets to support integration between Fusion and WCC (thru UCM).

- Often work on performance issues with reports.

- Deal with key Oracle SRs.

- 1st resource on any BI change requests.

• University of Oxford project (DEV, UAT)

Senior technical resource to deliver migration from Oracle EBS R12 to Oracle Fusion Cloud. Interfaced data using PL/SQL procedures which validates , transforms the data, prepares FBDI files , upload to UCM and invoke ESS jobs to create the data in Fusion. Data interfaced:

- Suppliers

- AP invoices

- Purchase Orders

• Primark project(DEV, UAT, PROD)

Senior technical resource in CEMLI team. Responsible to document, build, deploy and support customizations in EBS R12 modules – AR , AP, GL, CE, ebTax.

- PL/SQL stored procedures, functions, query performance (Develop and Unit Test Procedure, Concurrent Programs)

- Oracle Reports( Develop and unit test) • OAF pages(Develop and unit test)

- Financial modules - AR , AP , CE , GL

- Workflow

- Oracle Alerts

- XML Gateway

- Oracle WebADI (develop and unit test)

- Documentation – DS140, RD140

- More4APPS – Supplier Wizard

- Interfaces – Cash Management, Receivables, Payables

• DJEI project(DEV,UAT,PROD)

Technical resource to build, deploy and support custom solution based on Oracle Forms and Reports. Closely work with client resources to define the requirements and design the functionalities.

- Oracle Forms and Reports

- PL/SQL stored procedures, functions, query performance

- Oracle Reports

- Oracle Forms

• Creditsafe project (DEV,UAT,PROD)

Senior technical resource and architect of a custom solution to integrate Oracle EBS AR R12 with credit check company software using OAF pages. Participate with key stakeholder from client side to monitor the progress daily as the project was a key one for the credit check company( they have a lot of customers using EBS as implemented ERP and they wanted to monitor all their customers by purchasing a credit check functionality). Integration between credit check company and Oracle AR – Creditsafe ltd

- PL/SQL stored procedures, functions, query performance ( develop and unit test)

- Oracle Reports(develop and unit test)

- Parse SOAP web services

- Database design

- Extract routines – dump into csv files

- EBS R12.1.3 – concurrent programs

- Documentation – MD050, MD120, MD070, BR100

• National Car Parks EBS R12 project ( DEV,UAT,PROD)

Key resource on support , SRs and change requests. Work with business users in order to clarify all the requirements gathered by the functional consultants. Upgrade Oracle EBS R11.5.10 to R12.1.3. Modules upgraded and implemented – AR, AP, GL , CE, HRMS, iExpenses.

- Develop new customizations for Oracle EBS R12

- Customise forms and reports for version R12.1.3

- Develop new Oracle Reports with Reports Builder 10gR12

- Documentation – MD050, MD120, MD070, BR100

• Metroline EBS R12 project (DEV,UAT,PROD)

Key resource on support , SRs and change requests. Work with business users in order to clarify all the requirements gathered by the functional consultants. Upgrade Oracle EBS R11.5.10 to R12.2. Modules upgraded and implemented – AR, AP, GL , CE

- Develop new customizations for Oracle EBS R12

- Customise reports for version R12.1.3

- Customise forms for version R12.1.3

- Develop new Oracle Reports with Reports Builder 10gR12

- Documentation – MD050, MD120, MD070, BR100

Support Projects

• National Car Parks

- support modules – AR, AP, CE, iExpenses, GL

- Develop Oracle Reports

- PL/SQL stored procedures, functions, query performance, bash scripts - Integration with 3rd party system – AR, AP Import/Export

- Raise and manage service requests with Oracle

• Metroline ltd

- support modules – AR, AP, CE, GL

- Develop new Oracle Reports& Forms

- PL/SQL stored procedures, functions, query performance

- Deployment scripts

- Raise and manage service requests with Oracle

• Attenda

- support Oracle Projects

- Investigate revenue issues

- SQL queries

• Ann Summers

- support modules – AR, AP, GL Key resource on support , SRs and change requests. Work with business users in order to clarify all the requirements gathered by the functional consultants.

- PL/SQL stored procedures, functions, query performance

- Unix bash scripts

- Automation routines for daily checks

- Customize Oracle Forms

- Documentation – roll- out plans

- SQL Query optimization

• HID global

- support modules – AR, AP

- SQL Queries

- Investigate issues, fix data discrepancy

• Global Switch

- support module - AR

- Develop new XML Reports

- PL/SQL stored procedures, functions

• dsp ltd (IBM Cognos - internal purposes)

- Build IBM Cognos reports

- Automate reports

- Dashboards

• Implementation of Oracle Datawarehouse for National Revenue Agency and National Customs Agency in Bulgaria.
• Provide solutions and workarounds for solving report, migration and process issues.
• Develop Oracle Reports with Oracle BI Publisher, BI analytics.
• ETL processes – PL/SQL stored procedures (develop and unit test).
• Database design.
• Integration with third party softwares – Load huge amount of data.
• Query performance, tune processes.
• BI publisher reports and BI analytics – reports, data models, dashboards, KPIs.
• BI Analytics trainer – transfer knowledge to BI development team.
• OBIEE Unit testing (perform tests on interactive reports, dashboards, drilldown reports with user-defined functions, KPIs).

• Implementation of Oracle EBS R11.R12 – modules: AR, AP, GL, TRX, FA, CE.
• Integration with Oracle Primavera and INSIS.
• Implementation and support for core pensions system 'POK Doverie', insurance company 'LevIns ltd' and translation company – 'Lozanova48'.
• Support work for POK Doverie (support modules – AR, AP, GL, TRX, FA, CE).
• Develop Oracle reports and forms, PL/SQL stored procedure, triggers, functions, indexes, query performance, personalizations.
• Sort out issues within the Oracle EBS, including raising service requests with Oracle.
• Support work for Lozanova48 (support modules – AR, AP, CE, GL).
• Develop Oracle reports and forms, PL/SQL stored procedure, triggers, functions, indexes, query performance, personalizations.
• Sort out issues within the Oracle EBS, including raising service requests with Oracle.
• Integration with Oracle Primavera – AR import routines.
• Support work for LevIns ltd (implementation and support modules – AR, AP, CE, GL).
• Develop Oracle reports and forms, PL/SQL stored procedure, triggers, functions, indexes, query performance, personalizations.
• Sort out issues within the Oracle EBS, including raising service requests with Oracle.
• Integration with INSIS – AR import/export routines.
• Develop new cash module from scratch as Oracle Form and integrate it with Oracle AP and INSIS.