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 LimitedMySQL
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 for different modules such as financials, procurement, human capital management. So, mainly, I worked on these all of the, uh, concepts which I've worked. These are the modules for our, actually, our different and the remaining concepts. So I worked for techno functional, like, technical aspect of, uh, requirements. Like, for example, user or client wants any technical, uh, technical, uh, error or, uh, she or he could not able to fetch the proper data. So I worked for these modules, which I've already mentioned, like financials, uh, procurement, and HCM. So I provide, uh, I delivered, uh, useful insights, like, helpful insights for users or clients wherever if it is technical or functional. We also use the Oracle, uh, our project is Oracle third party dependency vendor dependence that is Oracle support. So I also log the tickets, uh, in Oracle supports, like, uh, create a service request Oracle support and act as a mediator from Oracle support to the, uh, clients. So, basically, I work for UK based clients. Yeah. And, also, I have handled the upgrade activities. And post upgrade, we also receives few of the functional error or technical glitches. So I resolved those. I handled those. And I also have a team of around, uh, 5 to 6. So we communicate, and, uh, we also have, uh, cross functional teams, like, as our project is application dependent. So in the integrations part, we usually communicate with the other teams, and we deliver our thoughts. And we work, and we communicate, and we work together accordingly. Yeah. Thank you.
Experience and development, API, JRE, duration for just focus on this one. And, uh, this is strategy for acquiring these skills. Yeah. So for these questions, my answer would be so this is basically on APLNGL. So I have all I also have some hands on and some knowledge on APLNGL modules and projects. So I have done the custom reports. So, basically, we work on custom reports, not on a seeded reports. So that experience I have. So maybe so form personalization or a store approach procedures that 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, uh, currently working on. And if I got any chance to work in this company, I would definitely learn this. And my strategy is nothing but, uh, first thing I need to check how it how it is affecting these integrations and personalizations. First thing that is 1. And what is the impact? Like, uh, it will be a positive impact. For example, uh, if we do not do this personalization, what will be what will be the impact? And what if we do the change, what will be the positive impact? So this is the kind of, um, skills I can do this.
Explain your experience with Oracle EBS. Well, so my experience with Oracle EBS is so Yeah. So sorry. My sister's, uh, daughter has got woke up. So sorry. So yeah. My experience with Oracle ABS. Yeah. I already explained. So I have worked on Oracle ERP. So that is the latest version of EBS suite, e business suite. So different kinds of modules, which I have worked as financial procurement and SCM. And, uh, into technical and functional, that can be a techno functional role, which I worked on as a associate consultant. This is my designation. So my experience with, uh, ERP is very much helpful, and it is very much, uh, useful for me. And it is, uh, like, uh, I can grow grow up in my career as well as to my organizations where, uh, which the requirement is for. So I already explained this is for UK based project. So I spend time, like, uh, UK timings that is more, uh, like, uh, 4, uh, 4 and half beyond the Indian IST timings. So so yeah. Basically, I use different kinds of formats in my experience, like, uh, file formats, PDF, Excel, RTF, c CSV, XML, HTML. So these are the file format which I have used in Oracle, uh, ERP. And, yeah, I also like, in functional aspects of thing, I have experience in setting up the like, enabling the vacation rule that is nothing but if, for example, any user might going to a long term vacation rule or any vacation, like, 1 week or 10 days. So I usually enable the vacation rule for them and, uh, reload the transactions. I usually reload the transactions, whatever transactions are pending to the person, to the user who is available in their absence. So this is nothing but, uh, setting up the vacation rule. And I also, uh, have hands on and permanent proxy. That is nothing but if a user is leaving the, uh, company. So some kind of adoration. So I usually enable the permanent proxy for them. So coming to security wise, security console, I also have experience in has a hands on experience security console. That is one of the, uh, concept in, uh, Oracle ERP which we have. So for example, we have inherited privileges and inherited rules. So for that, uh, if, let's say, user is, uh, having unwanted privilege that is inheriting the role. So I have the hands on experience in removing that privilege. User want to remove that privilege for some inherited roles. So you also prepare a document and give it to the admin so that she can, uh, go through everything. And if it is right, then she will be performing the actions. So this is the, uh, experience which I have in, uh, procurement, like setting up the vacation role and the security concern. Thank you.
Development experience for API GL tuition projects from. Yeah. So, uh, firstly, I'll go with the custom reports. So I have developed, uh, many reports, for example, existing reports as well as a new reports. So, for example, use and want I'll take a a quick example. Like, if a client wants some of the columns in the report to be appeared with along with few more columns that we added, which are not even present in the present existing report, and, uh, those old columns, existing columns, and new columns that to be fetched in the new report. That is nothing but new development report. So I've taken I have, um, done some investigation and analysis from the back end where actual tables and columns are present in the cloud. So I've taken from there and designed a custom report, and I have provided the data, uh, fetched the data and provide the report to the users or clients. So this is the experience I have in the custom reports. Not only are the fields or columns and parameters, uh, joints, etcetera. Whatever the technical knowledge I have, I have created reports and provided to the users. And coming to integration projects, if I have worked on I have worked on, like, 1 or 2 integrations. For example, cash management and AP payment refund AP payment status refund. So if we take cash management starting from the lookups variables, namespaces, so these all nothing but the configurations. Lookups is nothing but a feature in the OIC. OIC is nothing but a platform, uh, where, uh, we can perform the integrations from end to end. So once we do the configuration, next step would be the we need to call the rest URI. That is nothing but from source to destination, uh, a URI needs to be, uh, present that we need to create. So that is nothing but already built in in the, like, OIC platform. We have different kind of adapters like, so press, 2 update, f t FTP adapters. So these kind of adapters, you can use whatever, uh, you need. So I have used the rest adapters, s t r a, and then we need to do the mapping. For example, if you're taking the cash management, what is the cash management fees? And we need to map the file name and properties. That is a mandatory one. Remaining are optional. So from file name and properties, we need to map from source to destination in. Next, we go to the adapter that is, uh, which use your ERP adapter. We need to select that, and we need to do the inbound and outbound integration regarding whichever the integration is set. So we also have the fault handlers, global fault handlers. If we if the, uh, case switch case or any other, uh, this part is not working, then we can able to, uh, call default handlers or global fault handlers, and we can resolve the issue. And coming to API, Agile, yes, I also have mentioned, like, I have some of the experience in, uh, AP and AR, like account payables and journal ledgers. So journals, I also have the experience in this kind of, uh, experience. Thank you.
Situations where an Oracle persistent enhancement reflects complex with existing workflow purposes. So if, uh, actually, our base system enhancement is reflect 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 a change workflow that is going to happen that already happened. So what why it is impacting and what is the impact if it is major impact or minor impact? Based on that, we need to check, like, from back end, what is the, uh, like, what is the effect that is made to the Oraclear p application and major impact, maybe it would take to financials module or HCM module. So which module it is going to take? So, firstly, we need to communicate with our team, entire team. So so that, uh, that, uh, each of the individual contribution will be, uh, added to this, uh, like, situation which we are handling. So we need to check first which of the concepts. So in our team, for each of the module, few individuals are working, like, financials. 1 or 2 are working. It's here. 1 one individual. 1 employee is working. So we need to, uh, gather this information from all of them, uh, few of them, like, whoever is working. So that is the main point because whoever is having no knowledge, uh, less knowledge in one of the model, they can't work in so for example, in financials module, one employee is having knowledge and for SCM, our employees have a knowledge. We can't, uh, give vice versa to them. So this will be helpful, and this will be easier to resolve these resolve the issue quickly. And, also, we have Oracle third party dependency that is Oracle support. So we also can take help from them. That is we by keeping the 247 to the timer. So priority 1. So that it will so by communicating and by gathering the team and information, we can quickly get the insights, get the solution quickly from from both of them, from team teamwork as well as, see, we also have their support. Yeah. This is the approach I follow.
Been the most earning aspect of implementing more RP financial model. How did you overcome it? Yeah. So one of the challenge I can, uh, share here is, uh, in our RP, uh, experience, one of the implementation I have done for, uh, I can say purchase orders purchase orders and purchase requisitions. So after I take all the chain management, so we have the change management process where change approval board meetings, like, cab approval board meetings are, uh, will take, like, from if within a week, Monday, Tuesday will be the meetings, and we need to create a change request, uh, for whatever the implementation is because it should, uh, not have an impact. We need like, this is the way we are, uh, priorly informing the business that we are, uh, taking this change ahead. And this is the impact, and this is the thing. If we do not do what is the impact, if we do what's the impact, and we need to take the availability terms for testing the, uh, change because as it is a production first, when you're in the lower environment, UAT test environment, they're into production. So as we are taking into the production environment, we need to take the availability testing timings from the user or a client who who's ever testing. So after all this, after, uh, representing the change, the change board meeting, uh, advisory, uh, members will, uh, approve our change so that we can able to implement, uh, unplanned the timings. So whenever I have done, uh, all the changes have been successfully implemented and regression, like, testing is also successfully done, and the change request also closed successfully. So one of the time as, uh, like, after I implement, some of the functionality is not working for the user. So what happened, user has raised this query to me and also to my concerned teammate or manager. So what we have done is we have, uh, quickly done the regression. So, like, backup, we need to take the backup. So after while taking the backup as it is a production, some of the users which they are working in, uh, creating a purchase orders, admins admins will be there. So while creating a purchase order, some of the users are list of vendors are listed out. So they have faced some of the, uh, issues. So we need to take out all the, um, customer names, usernames, whoever is, um, going to, uh, whoever are, uh, affected. So we need to take the list out from back end. That is approach. And after, uh, I have done the regression, I have taken this list view of the list names, and we have, um, so that's it. That is a change part that is closed. And later on from next day, what I have inquired is what is the issue, what why it is impacted. So the reason is, uh, we need to do it from the front end. The testing needs to done from the front end, but this is not I can't say this is not my issue. Basically, it is not my issue. It is from testing issue, not the implementation. So for testing also to users or clients, I need to check from back end, uh, the, uh, priorities, like, prerequisites, what needs to be done. Testing needs to be done in both ways. So from, um, back end, they have tested, but not from front end. Uh, sorry. They have checked from, uh, front end, but not the back end. So this is a issue that this is a, um, like, what I can say. This is not a current UAT or lower environment previously in test environment. This is a current production. So this is the main part main challenge which I face that it needs to be tested from uh, back end, not a front end. Yeah. That is 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 this question if I see this question, the first thing that comes under my, uh, head is integration spot. So in integrations, we have a different, uh, adapters like, or, like, Oracle, ERP and other enterprise systems also. So where we have source and destination point of end. So if Oracle ERP wants to map this data from another enterprise system, we use the file adapters where ARP is one of the file adapter. And if you want another enterprise system, we need to, uh, have the, um, back end, like, back end configuration need to be done priorly before we start the integration. And, also, we need to have the rest URI, like, uh, that is, uh, web service rest URI web service. For example, uh, if you take a cash management integration, Centimeters /extract/cashmanagement. So we are taking here the namespace and the lookups. So, basically, uh, Centimeters here is it is telling CSH, MJMT, so the name same similar name should be presented in the, uh, source as well as the destination. So the data mapping should be done in the mapping stage where we have mapped to stage right and stage date. So we are saving this folder from, uh, file 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 doing reading the file from one location to another location. We are reading all the data. It is, uh, acquiring, fetching all the data in the mapping. Like, already I said, like, file name, file type, and, uh, property file, we need to take these, uh, 2 mandatory things to be mapped in the fields, mapping fields. Yeah. Integration is the main, uh, thing that we need to, uh, 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 back end, if we are facing any, like, uh, user is user is going to run a report. For example, financials report or procurement report. So in financials, we have fixed asset report, fixed register and register creation date financial report. So you're just going to run that report, but she's unable to run due to the parameter which she which she has given he or she has given. User has given is too long. Example, if you take 2,011 to 2,020, 2021. So the duration between this gap is very long so that that technical error one of the example I'm taking, like, technical errors, uh, giving is, uh, report exceeds long. Like, reports exceeds size size of this so and so. So we need to, uh, uh, check. We need to identify what is the main error so that we can increase the size of the report from from properties, or else we can do one more thing. If it is, uh, if this the load duration is very long, we can schedule the report. So at the instant, we cannot run the report. So we can schedule the report so that it will take, uh, that, uh, her it will take its own its own sweet time, and it will give us the output. So this is a technical, uh, error technical issue, one of the examples you have taken. And function issue is nothing but if, uh, user is created a purchase order and, uh, user is clicking on submit submit button. So it is the button is not working. So this is one of the functional kind of error. An example, user has given all fields and missed to give one field in financial or any procurement or assume. That is one of the functional, uh, issue that can happens. So technical and functional, these are the both, uh, issues difference between both technical and functional system. Thank you.
Enforce a chain management protocol for ARP system updates among cross functional teams. So and for the chain management protocol. So as I discussed as we discussed earlier, uh, we have a change management process where, for example, any technical change or, uh, any functional changes going to implement if we are going to deploy it bit, uh, before, uh, a test environment and then into 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. Uh, what is the change? Uh, and, uh, 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, any change conflicts are there, like, for a particular change, uh, for if you are implementing this particular change tomorrow at evening 5 o'clock IST. So is there any other change that is conflicting in between in between these timings of this particular change and, uh, among cross functional teams. So if we have the cross functional teams and its changes, like, uh, there's an upgrade. So if we take the real example, which I have faced is, which I've worked this handle is, uh, a change upgrade change. So in this upgrade change, our financials team and another team, Boomi integrations team, and, uh, unified team, these 2 or 3 teams are involved in it where we need to communicate with each other according to that change. So we have our runbook also that is a Excel, uh, format. So in that Excel format, we have 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 is does not happen, and what is the regression testing performed. And post regression, what is the backup you are going to take after backup? Uh, you need to test whether it is, um, backed up correctly or not. So these all, uh, one team will be performing. And in one team in the sense, in one project, we have different teams. So one team will be performing implementation. One team will be performing testing from back end, uh, if any, uh, success or failures are happened. Like, for example, boom integration team. Um, from our end, we need to check if any if, uh, any functionality is working right, if any functional is going wrong. Users could usually check and tell us. We will check, uh, in that perspective. So this, uh, this way we need to communicate, and we also have different, uh, group, uh, chat communications going on. And we also have this is the main thing, like, meetings. Agile's come meetings we have. So in the meetings, we discuss so, for example, if the change is going to carried out, uh, to 1 to 4 days, so in this 4 days or prior to 4 days, we, uh, conduct a meeting, schedule a meeting. So in the meetings, we will be testing whatever from beginning to end. In between, whatever is going on, we'll communicate in the meetings. Thank you.
Approach. You have applied to automate recurring describe an innovative approach. You have applied in to automate recurring financial task in your activities. Have permission. I'm answering this question. 1 to 4. So automate recurring financial task. So in radical EBS or radical ERP, the financials, uh, module is basically a crucial part where if simple, uh, financials simple single module is not working also, then, uh, it will be a huge impact for every user for each user, uh, in financial model. For example, if you take purchase order so in the purchase order template, uh, the watermark is present. Uh, little bit, uh, like, that watermark should not be present in some of the templates, and watermark should be present in few templates. So I need to check the template first and from where this recurring sorry. From where this watermark is, uh, going to happen. So the functionality previously was not there. And after upgrade post upgrade, the functionality is the watermark, uh, users can able to see. So that needs to be removed. So we need to check with upgrade is nothing but Oracle information, and, uh, Oracle support will up, uh, implement this upgrade activities. So we need to check with Oracle support log in service request, log in SR. So I need to check with them why is this happening. If we remove this, any impact, or if we do not remove this, it's an impact. So they will give some, fix or a workaround for, uh, temporary first workaround or permanent fix in later, uh, future dates. So they'll give some implementation dates, and they'll also give us an impact. So we need to check that. And if it if we have any questions, we can ask them. Or if we have if we are clear, we can provide same update to the clients so that they can, uh, give us the insights, like, uh, if any more queries need to be done. If they're okay with then approving the implementation dates, the fix will be permanent fix will be applied. Yeah. Thank you.
To have implemented for the batch processing efficiency in Oracle ABS. So for batch processing efficiency in Oracle, So currently, from past few years from past years from where Oracle a b is is committed to Oracle ERP. So I worked for Oracle ERP, so there's no improvement for now as per my knowledge. So everything is up to the mark, I can say. So if going on and we use these, uh, kind of modules, so I have this much, like, not more experience and 2 to 3 years experience in fusion. So I can say this up to my knowledge, no improvement as of now. If it is implemented, if it needs to be improved, maybe if I have more experience, if you give me an opportunity, I can work more. I can contribute more by utilizing this, uh, valuable opportunity so that I can get, uh, like, I can deliver more, and I can suggest more of the improvements for actually BS match processing. Thank you.