
Supriya Pulluru is an experienced professional with 4 years of expertise in data integration, finance modules, and ERP implementations. She has 2 years of experience in data integration, where she has successfully managed and integrated data across multiple systems, ensuring smooth data flow and consistency. Supriya has 3 years of hands-on experience working with finance modules, contributing to the optimization and implementation of financial solutions within enterprise systems. With a strong background in Oracle EBS R12 and Oracle ERP, Supriya has spent 2 years working with Oracle E-Business Suite (EBS) R12, focusing on module integrations, customizations, and supporting business operations. She also has 3 years of experience in Oracle ERP, including managing modules related to finance, supply chain, and procurement. In addition to her ERP expertise, Supriya has 1 year of experience in optimization, enhancing system performance and streamlining processes. Her combined experience in implementation and optimization makes her adept at driving efficient business processes, ensuring smooth transitions, and improving system functionality for enhanced business operations.
Associate Consultant
Capgemini Technology Services India LimitedSoftware Engineer
Thomson Reuters International Services India Limited
MySQL

Oracle Database

Microsoft SQL Server

Microsoft Power BI
Developing reports/dashboards in OBIEE 11g, Defect Fixing and Migration activities for OBIEE 11g and BIP reports, Developing SQLs for Data Analysis, Scheduling/Monitoring. Incident management, task assignments, and problem resolution, Configuring Extract jobs, job Scheduling in Oracle Fusion Reporting, Hands-on experience on Financial, Procurement and HCM modules. Worked with cross-functional teams on Data Integrations and Mapping. Handled Upgrade activities. Participated in Code and Design Reviews, and Lead activities for Report Track.
Designed and maintained databases to support data analysis and reporting, Code Backups using Outer Branch Tool, Developed data models, Worked on SQL queries to extract data, Imported data from SQL Server DB. Generated reports and explored data using Power BI, Published reports and dashboards using Power BI.
Yeah, hi. So, could you help me understand more about your background by giving a brief introduction? Sure. So, I have experience in Oracle Fusion Cloud applications where I have worked on different modules such as financials, procurement, and human capital management. So, mainly, I worked on these concepts, which I've worked on. These are the modules for our various different concepts. So, I worked on the techno-functional aspect of requirements. For example, if a user or client wants to resolve a technical issue or cannot fetch proper data, I worked on these modules, which I've already mentioned, like financials, procurement, and HCM. I provide useful insights, helpful insights for users or clients, whether it's technical or functional. We also use Oracle's third-party dependency, which is Oracle support. I also log tickets in Oracle support, create a service request, and act as a mediator between Oracle support and the clients. So, basically, I work with UK-based clients. And, also, I have handled upgrade activities. After the upgrade, we receive functional errors or technical glitches. I resolve those issues. I handle those issues. I also have a team of around five to six members. So, we communicate, and we have cross-functional teams, like, as our project is application-dependent. In the integrations part, we communicate with other teams and deliver our thoughts. We work together accordingly. Yeah, thank you.
Experience and development, API, JRE, duration for just focus on this one. And this is strategy for acquiring these skills. So for these questions, my answer would be that this is basically on APLNGL. I have all the knowledge and also have some hands-on experience on APLNGL modules and projects. So I have done custom reports. We work on custom reports, not seeded reports. That experience I have. To form personalization or a store approach procedures, that's something I need to work on. But, definitely, I would work on to acquire these skills because this is most related to the Oracle Financials, which I'm currently working on. If I got a chance to work in this company, I would definitely learn this. My strategy is to first check how it affects these integrations and personalizations. First, I would identify the impact. Like, it will be a positive impact. For example, if we do not do this personalization, what will be the impact? And what if we make the change, what will be the positive impact? This is the kind of skill I can develop.
My experience with Oracle EBS is as follows. So, my experience with Oracle EBS is so I have worked on Oracle ERP. So, that is the latest version of EBS suite, also known as e-business suite. I have worked with different kinds of modules, including financial, procurement, and SCM. Additionally, I have worked in a techno-functional role, which I held as an associate consultant. This was my designation. My experience with ERP is very helpful, and it's also very useful for me. It's like I can grow both in my career and in my organization, where the requirement is for. I already explained that this is for a UK-based project. I spent time in UK timings, which is more than Indian IST timings, by about 4 to 4 and a half hours. I used different kinds of file formats in my experience, such as file formats, PDF, Excel, RTF, CSV, XML, and HTML. These are the file formats I've used in Oracle ERP. I also have experience in functional aspects, such as setting up vacation rules. For example, if a user is going on a long-term vacation or a vacation of 1 week or 10 days, I enable the vacation rule for them and reload the transactions. I usually reload the transactions for the user who is available in their absence. I also have hands-on experience with permanent proxies. This is when a user is leaving the company. I enable the permanent proxy for them. From a security perspective, I have experience with the security console. One of the concepts in Oracle ERP is inherited privileges and inherited rules. For example, if a user is inheriting unwanted privileges through a role, I have hands-on experience in removing that privilege. I also prepare a document and give it to the admin so they can review everything. If it's correct, they will perform the actions. This is the experience I have in procurement, including setting up vacation roles and security concerns.
Development experience for API GL tuition projects from. So, I'll start with the custom reports. I have developed many reports, for example, existing reports as well as new reports. For instance, if a client wants some columns in the report to appear along with a few more columns that we added, which are not present in the existing report, and those old columns, existing columns, and new columns to be fetched in the new report. That is a new development report. I've taken some investigation and analysis from the back end where actual tables and columns are present in the cloud. I've taken from there and designed a custom report, and I have provided the data and provided the report to the users or clients. This is the experience I have in custom reports. Not only have I created reports with fields or columns and parameters, but I've also used my technical knowledge to create reports and provided them to users. Coming to integration projects, I have worked on one or two integrations. For example, cash management and AP payment refund AP payment status refund. If we take cash management, starting from the lookups, variables, and namespaces, these are all configurations. Lookups are a feature in OIC, which is a platform where we can perform integrations from end to end. Once we do the configuration, the next step would be to call the rest URI. That is from source to destination, a URI needs to be present that we need to create. This is already built into the OIC platform. We have different kinds of adapters, such as HTTP, FTP, and file adapters. I have used the rest adapters, and then we need to do the mapping. For example, if you're taking the cash management fees, we need to map the file name and properties. That is a mandatory one. The remaining are optional. From file name and properties, we need to map from source to destination. Next, we go to the adapter that uses the ERP adapter. We need to select that and do the inbound and outbound integration regarding whichever the integration is set. We also have fault handlers, global fault handlers. If the case switch case or any other part is not working, then we can call the default handlers or global fault handlers, and we can resolve the issue. Coming to API, Agile, I also have some experience in AP and AR, such as account payables and journal ledgers. I also have experience with journals. Thank you.
Situations where an Oracle persistent enhancement reflects complexity with existing workflow purposes. So if, actually, our base system enhancement reflects a custom context. So in this case, we need to check the process, what is happening behind the process or behind the workflow, what is the change in the workflow that is going to happen or has already happened. So, what is the impact and what is the impact if it is a major impact or minor impact? Based on that, we need to check from the back end, what is the effect made to the Oracle application and whether it would have a major impact, maybe on the financials module or HCM module. So, which module is it going to affect? Firstly, we need to communicate with our entire team. So that each individual's contribution will be added to this situation that we are handling. We need to check first which concepts are being handled by each of the team members. In our team, for each module, a few individuals are working, like, financials. One individual is working on the financials module. One employee is working on SCM. We need to gather this information from all of them, whoever is working. So that is the main point because whoever has less knowledge in one of the modules cannot work in that module, for example, in the financials module, one employee has knowledge, and for SCM, our employees have knowledge. We cannot give vice versa to them. This will be helpful, and this will be easier to resolve the issue quickly. And also, we have Oracle third-party dependency, which is Oracle support. So we can also take help from them. That is why, by keeping it as a priority 1, by communicating and by gathering the team and information, we can quickly get the insights and get the solution quickly from both our team and from Oracle support.
Been the most earning aspect of implementing more RP financial model. How did you overcome it? Yeah. So one of the challenges I can share here is in our RP experience, one of the implementations I've done for purchase orders and purchase requisitions. So after taking all the chain management, we have a change management process where change approval board meetings, like, take place from Monday to Tuesday, and we need to create a change request for whatever the implementation is because it should not have an impact. We need to inform the business that we're taking this change ahead, and this is the impact, and this is the thing. If we do this, what's the impact, and if we don't do this, what's the impact. We need to take the availability terms for testing the change because as it's a production-first approach, when you're in the UAT test environment, they're not in production. So as we're taking it to the production environment, we need to take the availability testing timings from the user or client who's testing. So after all this, after representing the change, the change board meeting advisory members will approve our change so that we can implement it at unplanned timings. So whenever I've done all the changes have been successfully implemented, and regression testing is also successfully done, and the change request is also closed successfully. So one time, after I implemented some of the functionality wasn't working for the user. So the user raised this query to me and also to my concerned teammate or manager. So what we did is we quickly did the regression testing. We need to take a backup. So after taking the backup, as it's a production environment, some users who were working on creating purchase orders, admins would be there. While creating a purchase order, some users faced issues with the list of vendors being listed out. We need to take out all the customer names, usernames, whoever is affected. We need to take the list out from the back end. That's the approach. And after I did the regression, I took the list view of the list names, and we have so that's it. That's the change part that's closed. And later on, from the next day, I inquired about the issue and why it was impacted. The reason is we need to do it from the front end. The testing needs to be done from the front end, but this is not my issue. It's a testing issue, not an implementation issue. For testing, I need to check with users or clients from the back end, the priorities, like prerequisites, what needs to be done. Testing needs to be done in both ways. From the back end, they have tested, but not from the front end. Sorry. They have checked from the front end, but not the back end. This is a current production environment, and this is the main part of the challenge I face, which is it needs to be tested from the back end, not the front end. Yeah. That's a challenge I face. Thank you.
Data mapping between Oracle ERP and another enterprise system. So excuse data mapping. Okay. So in the integration flow, this question if I see this question, the first thing that comes to my head is integration spot. So in integrations, we have different adapters like Oracle ERP and other enterprise systems also. So we have a source and destination point. So if Oracle ERP wants to map this data from another enterprise system, we use the file adapters where ARU is one of the file adapters. And if you want another enterprise system, you need to have the back end configuration done prior to starting the integration. And also, you need to have the REST URI, that is, the web service REST URI web service. For example, if you take a cash management integration, Centimeters /extract/cashmanagement. So we are taking here the namespace and the lookups. So basically, Centimeters here is telling CSH, MJMT, so the name should be presented in the source as well as the destination. So the data mapping should be done in the mapping stage where we have mapped to stage and stage date. So we are saving this data from one folder to another location, that is nothing but a stage. Right? And in the reading, we are doing the stage in the stage, we are reading the file from one location to another location. We are reading all the data, acquiring, fetching all the data in the mapping. Like, I said, file name, file type, and property file, we need to take these two mandatory things to be mapped in the fields, mapping fields. Yeah. Integration is the main thing that we need to map between one source to one destination. Thank you.
In the difference between technical and a functional issue in the Oracle ERP system. So it's nothing but a simple one. Technical is nothing but from the back end, if we are facing any issues, like when a user is going to run a report. For example, a financials report or a procurement report. So in financials, we have a fixed asset report, fixed asset register, and a register creation date financial report. So you're just going to run that report, but she's unable to run it due to the parameter she has given. The user parameter is too long. For example, if you take 2011 to 2020, 2021. The duration between this gap is very long, which is a technical error. An example of a technical error is when a report exceeds the allowed size. So we need to check and identify what the main error is. We can increase the size of the report from the properties, or else we can schedule the report. If the load duration is very long, we can schedule the report. At the instant, we cannot run the report. So we can schedule the report so that it will take its own time, and it will give us the output. So this is a technical issue, one of the examples you have taken. And a functional issue is nothing but if a user creates a purchase order and clicks on the submit button. However, the button is not working. This is one of the functional kind of errors. An example is when a user gives all fields but misses one field in a financial or procurement order. That is one of the functional issues that can happen. So technical and functional issues are the two main differences between both technical and functional systems. Thank you.
Enforce a chain management protocol for ARP system updates among cross functional teams. So, for the chain management protocol. So as I discussed as we discussed earlier, we have a change management process where, for example, any technical change or functional changes going to be implemented, we are going to deploy it in a test environment and then into the production environment. Change management process is very crucial, where for Oracle ERP system, we need to enter all the details related to that change, whether it is functional or technical. What is the change? And if we do not do this change, what is going to happen? If we do this change, what is the impact? And if it is a major impact or minor impact, are there any change conflicts? For a particular change, if you are implementing this particular change tomorrow at 5 o'clock IST, are there any other changes that are conflicting between these timings of this particular change and among cross functional teams? So, if we have cross functional teams and its changes, like, there's an upgrade. So, if we take the real example, which I have faced, which I've worked on, is a change upgrade. So in this upgrade change, our financials team and another team, Boomi integrations team, and unified team, these two or three teams are involved in it, where we need to communicate with each other according to that change. So, we have our runbook also in an Excel format. In that Excel format, we have the runbook. In that, we have the implementation timings, implementation details, what the change is about, and how it will be carried out, what is the impact if it does not happen, and what is the regression testing performed. And post regression, what backup will you take after backup? You need to test whether it is backed up correctly or not. So, these all will be performed by one team, in one project, we have different teams. One team will be performing implementation. One team will be performing testing from the back end, if any successes or failures are happened. For example, the Boomi integration team. From our end, we need to check if any functionality is working right, if any functionality is going wrong. Users could usually check and tell us. We will check from that perspective. So, this way we need to communicate, and we also have different group chat communications going on. And we also have this is the main thing, like, meetings. Agile meetings we have. In the meetings, we discuss, for example, if the change is going to be carried out in one to four days, so in these four days or prior to four days, we conduct a meeting, schedule a meeting. In the meetings, we will test whatever from beginning to end. In between, whatever is going on, we'll communicate in the meetings.
I have applied to automate recurring financial tasks in my activities. I have the permission to do so. 1 to 4. So, automating recurring financial tasks. In radical EBS or radical ERP, the financial module is basically crucial, where if the simple financial single module is not working, it will have a huge impact on every user in the financial model. For example, if you take a purchase order, in the purchase order template, the watermark is present. However, the watermark should not be present in some templates, and it should be present in a few templates. So I need to check the template first and from where this recurring watermark is going to happen. The functionality previously was not there, and after the upgrade, the functionality is that users can see the watermark. So, that needs to be removed. So, we need to check with Oracle, and Oracle support will implement this upgrade activity. So we need to check with Oracle support by logging into the service request, logging into SR. I need to check with them why this is happening. If we remove this, will there be an impact, or if we do not remove this, there will be an impact. They will give us a fix or a workaround for the temporary first workaround or a permanent fix in the later future dates. So, they'll give us some implementation dates, and they'll also give us an impact. We need to check that. And if we have any questions, we can ask them. Or if we are clear, we can provide the same update to the clients so that they can give us insights, like if any more queries need to be done. If they are okay with it, then we can approve the implementation dates, and the fix will be applied permanently.
To implement batch processing efficiency in Oracle ABS. For batch processing efficiency in Oracle, currently, over the past few years, Oracle has committed to Oracle ERP. I worked on Oracle ERP, and as per my knowledge, there's no improvement now. Everything is up to the mark, I can say. If we use these kind of modules, I have this much experience, like, not more than 2 to 3 years in fusion. I can say this up to my knowledge, there's no improvement as of now. If it's implemented and needs to be improved, maybe with more experience, I can contribute more by utilizing this valuable opportunity, so that I can deliver more and suggest more improvements for actual BS match processing. Thank you.