Pranav Shah

Oracle EPBCS, Oracle OIC/SOA,OneStream, Workday Adaptive

Oracle EPBCS-

• Proposed system integration architecture design with legacy and cloud-based modern applications with Oracle EPM.
• Supported end-to-end implementation, starting from client blueprint workshops to implementation and support.
• Created around 25 data load rules in Oracle EPBCS using Data Management.
• Loaded metadata and actual data using DLRs. The data was read from flat files.
• Installed EPM agent on client's Linux server in non-clustered mode.

OneStream-

• Proposed system integration architecture design with legacy and cloud-based modern applications with OneStream.
• Supported end-to-end implementation, starting from client blueprint workshops to implementation and support.
• Devised integration architecture using EPM/CPM solutions such as OneStream and Oracle EPM.
• Developed reusable VB.NET code to enable REST-based integration with SAP S/4 Hana and OneStream. The same code has enabled integration for 3 clients to date.
• Developed a reusable utility for enabling the latest OAuth 2.0-based client authentication in OneStream.
• Effectively communicated requirements to SAP team so that OneStream could be provided with correct CDS view APIs for data import.
• Created Connectors/Datasources to integrate OneStream with SAP. This was done for both SAP on-prem and on-cloud solutions.
• Created Datasources to read .CSV files and load data into cubes using workflow profiles.
• Triggered various business rules using custom calculate using Data Management steps.
• Worked on multiple business rules to enable automated allocations and FX rate translations, created table views, and enabled certain business checks using relational blending.
• Created custom tables, and wrote SQL queries to enable business checks and extract data to table views.
• Worked on performance tuning of SQL related business rules increasing efficiency of the rules by up to 70%.

Workday Adaptive-

• Provided technical leadership to team members during system design.
• Created JavaScript code to pull out extracts from workday adaptive. The same code was used in different Datasources to pull out extracts for budget, forecast, plan, and trial balance.
• Created SFTP credentials to place these extracts to client's SFTP location which was on AWS S3 bucket.
• Created PGP credentials to encrypt files before sending them to client's SFTP location.
• The same architecture was followed throughout the project.

Oracle OIC/SOA-

• Developed Integration architecture according to business needs. Catered various integration needs involving Oracle SOA,Oracle ERP, OIC, Oracle Essbase, Oracle HCM.
• Collaborated with clients to determine project specifications and scope.
• Wrote and maintained custom scripts to increase system efficiency and performance time. Have done performance testing using JMeter, SOAPUI, POSTMAN on various OIC components. This performance testing included testing around 70 interfaces by loading them to a maximum load of 120%, and user concurrency of 200%. Bottlenecks were identified and the design was optimized by changing the existing monolithic services to smaller microservices, making the integrations asynchronous, and optimizing the DB scripts.
• Participated in system development life cycle from requirements analysis through system implementation.
• Provided SME support for multiple project solutioning and architecture. Worked on various RFPs involving OIC, Oracle ERP, Oracle SOA, Oracle HCM, etc.
• Mentored junior team members on best practices and technical skills, fostering a culture of continuous learning and improvement
• Resolved complex technical issues by troubleshooting systems, analyzing root causes, and implementing effective fixes
• Proactively monitored system performance trends to anticipate potential issues before they escalated into larger problems

Oracle OIC, SOA, ERP, HCM.

• Designed and architected an Oracle PAAS solution for one of the major clients in the public sector in the UK.
• Lead a team of 10 excellent colleagues to ensure project delivery from discovery to PGLS.
• Provided estimates and project delivery timelines for projects.
• Developed interfaces using Oracle SOA and OIC technologies.

BPEL, ODI.

• Developed new flows based on new IRs (Integration Requests). This was basically development using BPEL and ODI.
• Performed development upgrades, wherein the existing functionality needed to be extended for new custom fields.
• I was the client coordinator for one of the very active projects within the IKEA team.
• I was responsible for code testing and migration to the production environment.
• I Leveraged the ODI Webservice to create a SoapUI prototype plug-in to trigger a load plan and scenarios. This was later handed to the testers as one-stop testing UI for both SOA and ODI interfaces.
• Interviewed fresh talent for the team and increased the overall churn out as a whole.

Oracle SOA – BPEL, OSB, ESB, AIA

Oracle Event Server – Oracle CEP, CQL

• Developed Integrations in BPEL and ESB using Oracle AIA architecture.
• Created technical Designs For the integration points assigned to me.
• Involved in Unit Testing and Integration Testing.
• Created a smart meter hub using Oracle CEP, BPEL, OSB, Oracle Coherence.
• Created an Accenture specific white paper on the design of the INDE architecture that leveraged a smart meter monitoring system using a home-grown solution that used Oracle CEP, BPEL, OSB, Java, and Oracle Coherence.
• Managed a team for various B2B related development and tracking the team’s progress.
• Was the Client Coordination/Offshore point of contact.
• Conducted interviews to absorb fresh talent into the project.
• Created Integrations from scratch using Oracle AIA (foundation pack).
• Provided ticket-based support and maintenance of the existing model. Ticket priority ranging from P3, P2 and even P1.
• Developed new Proof-Of-Concepts for the client that helped reduce the overall project maintenance cost for e.g., automation using Quartz Scheduler for termination of stuck sessions while interacting with Siebel end points.
• Developed webservices in OSB (10g and 11g) using the WSDLS provided by the client end.
• Implemented Weblogic security using signed certificates (SSL).
• Inserted Orders into the database using database adapters, queues using JMS and AQ adapter.