Yogita Singh

• Working with business users to understand the current financial processes in R12 and map them to Fusion Cloud
• Gather and document business requirements related to data migration
• Created custom reports using OTBI and Power BI reporting tools
• Ensuring integration strategy aligns with business objectives, technical requirements, and best practices
• Providing workshop to Oracle implementation team, mapping the data structure of 3rd party data for 150+ integrations
• Coordinate with stakeholders to understand integration requirements and constraints
• Resolve technical challenges related to data integration, ensuring smooth data flow between Oracle R12 and Fusion Cloud
• Oversee the design and development of integration solutions, ensuring they meet project requirements
• Perform data mapping between Oracle R12 and Fusion Cloud schemas

• Led the integration of Oracle systems, serving as the lead Oracle Techno-Functional Consultant, for migration of MRO system from Ultramain on prem to Trax Cloud system
• Performed setup of supply chain modules in new MRO cloud environment
• Managed and mentored a team of 6, ensuring seamless coordination between technical and functional aspects
• Collaborated closely with Supply chain(SCM), Accounts Payable (AP), Account Receivables (AR) and General Ledger (GL) teams to gather and analyse business requirements
• Worked closely with Supply chain SMEs and WSLs for implementation and enhancement of MRO (Maintenance, Repair, and Overhaul) functionalities and Supply Chain modules
• Drive workshops with business and Trax vendor for understanding the system capabilities and designing the system as per business requirement
• Successfully developed and drive implementation of 15 integrations between Oracle and MRO system and the development of 20+ Oracle reports, 10+ business objects reports and 10+ Power BI report, significantly enhancing system functionality and reporting capabilities
• Developed custom reports, interfaces, conversions, and extensions (RICE) as needed
• Worked with Azure team for setting up azure function, logic apps and storage accounts
• Provided training sessions end-users on how to effectively use the Oracle ERP system and MRO system
• Created and maintained documentation, including user guides, system architecture diagrams, and process workflows
• Delivered end-to-end solutions by bridging the gap between business requirements and Oracle technical capabilities
• Assisted setup of MRO system, accounting, depreciation, etc
• Enhanced system performance and user experience through expert configuration and customization
• Successfully met project deadlines and goals, driving efficiency and system optimization with 100% customer CSI
• Successfully met supply chain and aircraft cutover distributed over multiple phases ranging for 4 months

• Handling RFCs, Service Requests & Incidents using Service Now
• Delivered 3 service improvement programs to business adding value to service provided
• Created new AP Inbound and outbound Interface including package, Unix script, BI publisher report and incident generation program for tradeshift and CRM source
• Integrated Virgin’s payment interface solution with Coupa and Bellin for different currency and created payment solution for new flight routes
• Started working on Oracle Application Framework pages and components
• Performed front end personalization for OAF, created new buttons and new attributes as per requirement
• Created new OAF data entry pages, search pages and workflow approvals pages for AP and AR modules
• Created new Controller and View Objects and extended existing Controller Objects
• Created one new data insertion page for end users and new package for Account receivables to enter data for transaction, used standard APIs to enter data into standard table and created new summary reports
• Created eText reports for handling bulk data replacing excel Bl publisher reports
• Provided business with setup for new Payment Document Category and demonstrations
• Coordinating with multiple stakeholders from Business, cross functional IT teams, QA, business analysts and external vendors
• Conducting weekly service review with business and with internal management too

• Successfully delivered ‘Cash management Enhancement Project-Phase 2’ for Bank of America with 100% CSI
• Integrated Cash management module with Bank of America, including creation of request sets to support the changes, added several programs for counter and for receipt and payment number generation
• Provided demo to customer presenting all the changes done in this project work

• Designed and developed Inbound AR Invoice Interface as a part of support to load customer invoices from third party system into Oracle AR
• Created remittance programs and provided setup change to replace standard remittance program with custom program for business
• Setup credit card program and expense template for China and India operating units
• Created Inbound interface for uploading credit card transactions and successfully delivered to production
• Proactively actioned on incidents and system change request and closed them within SLA provided
• Worked majorly on custom components creation, and modification such as custom programs, Unix shell scripts, mailer creations and interface designing
• Personalized Oracle Application using custom.pll and form personalization
• Created MD070 and unit test documents and developed interface for inbound and outbound interfaces for chart of accounts and journal upload to Oracle
• Actively trouble shooted and provided fixes and solutions for support issues

• Successfully delivered ‘People System and Processes’ Project.

• It involved two phases of organization re-design and person type re-categorization. Oracle EBS HR alerts, triggers, reports and packages was modified which was affected as a part of this project.

• Modified more than 50 reports and 10+ alerts individually.

• Created new interface for supervisor update process in HR for all person types.

• Worked on Break fix defects raised during project tenure.

• Designed and developed Inbound AR Invoice Interface as a part of support to load customer invoices from third party system into Oracle AR.

• Created remittance programs and provided setup change to replace standard remittance program with custom program for business.

• Setup credit card program and expense template for China and India operating units. Created Inbound interface for uploading credit card transactions and successfully delivered to production.

• Proactively actioned on incidents and system change request and closed them within SLA provided.

• Worked majorly on custom components creation, and modification such as custom programs, Unix shell scripts, mailer creations and interface designing.

• Personalized Oracle Application using custom.pll and form personalization.

• Created MD070 and unit test documents and developed interface for inbound and outbound interfaces for chart of accounts and journal upload to Oracle.

• Actively trouble shooted and provided fixes and solutions for support issues.

• Translating business issues/requirements into technology solutions and working closely with business to understand their expectations
• Involved in development, testing and implementation of various changes, preparing technical design document, release notes and Unit testing document
• Worked on Oracle Financials modules including General Ledger (GL), Accounts Payable (AP), Cash Management (CM) and Accounts Receivable (AR)
• Customized Oracle Forms and Reports to meet client-specific financial reporting requirements
• Developed complex PL/SQL scripts, stored procedures, triggers, and functions to automate financial processes
• Optimized database queries for improved performance and reduced execution time by 30%
• Assisted in the development of Oracle ERP financial modules, focusing on General Ledger and Cash Management
• Wrote and tested PL/SQL code for financial reports and data extraction processes
• Provided first-level support for Oracle Financials users, resolving issues related to data entry, reporting, and system access
• Understanding and obtaining deep knowledge of Oracle ERP applications
• Resolving tickets for business issues as a part of support
• Working on data fixes and Oracle SR for issue resolution
• Development of report as per business requirement using Oracle report builders
• Setting up GL codes and defining cross validation rules in General Ledger
• Creating various functions for report modification
• Applying form personalization in General Ledger modules to restrict various fields