Praful Solanki

Developed a chatbot tool for automating business processes, along with two additional tools for support projects. The technologies used include Power BI, Power Automate, Power Virtual Agents, Python, Oracle, and SQL.

I created a three-page dashboard using Power BI after processing snow tickets data using Python with the pandas library and extracting data from an Oracle database using SQL.

In customer projects, my focus was on designing and developing interactive dashboards using Power BI. This involved connecting to source systems, utilizing Power Query for efficient data transformation, managing data models, establishing relationships between fact and dimension tables, and creating visualizations such as bar charts, pie charts, and cards. The interactive dashboards allow users to analyze trends and patterns and gain valuable business insights.

Also, I designed and developed an ERP system and a custom chatbot using Microsoft Power Platform, specifically Power Virtual Agents and Power Automate. The chatbot integrates with various ERP systems via HTTP connectors (REST APIs) and enables the automation of tasks based on user responses on collaborative communication channels like Microsoft Teams.

R12 replaces Core 11i for a client's business services as a shared service system for financial transaction processing and maintenance. The project objective was to review 50+ customizations in terms of scalability, Oracle best practices, and the optimum utilization of Oracle resources.

I worked as a project lead on executing this project with the help of three senior technical consultants and carried out the below review points for 50+ customizations:
• Inculcate scalability in the solution design;
• Design for complexity, decomposition, and modularity;
• Review tables and index design;
• Validation of the redesign and refactoring of existing 11i customizations.
• Optimal algorithm and iteration.
• Input, output, and processing.
• New Oracle features plugin for customizations.
• A service-oriented integration.
• A PE checklist to follow Oracle's recommended features, standards, and architecture.

Benefits: a robust design with high availability and reliability and improved scalability and agility. It also has a high throughput, a reduced response time, and effective utilization of infrastructure resources.

The client had 28+ Oracle applications Instances to support their business functions. They needed support for the client in making the Oracle apps’ ERP systems more responsive to business needs and to avoid any performance issues (pro-active and re-active).

Contribution:
Worked as a project lead (SME/senior architect) on multiple Oracle performance engineering (PE) projects to fix all performance issues related with Oracle applications (ERP) on Oracle 11g/10g databases. I executed, managed, and delivered on multiple PE projects.
- Found and obtained the right business opportunities in the Oracle performance area to achieve organizational growth.
- Improved their Oracle customizations to have more than 150+ program performance of over 85%.
- Defined the overall PE process, guidelines, approach, and PE checklist.
- Mentored teams on Oracle performance techniques and advance features.
- Assisted the development team on how to write effective code in order to avoid any performance issues.
- Guided the business on how to improve the scalability of any Oracle based program, database, or app in design, development, and in a live environment.

The client wanted an implementation of the Oracle Transport Management (OTM) with complex and critical OBIEE finance reports for their European region with Oracle Database 12c on the cloud. These reports take up lots of time in the production environment before and after a database upgrade—they were looking for PE expertise to resolve and improve the Oracle resource utilization and the reports' response time and throughput to make a business decision within their SLA.

The Oracle Applications General Ledger & Account Receivable module needed support and customization done. The client had many entities across the world (in more than 7 countries) with them using Oracle applications manufacturing instances.

Contribution:
Worked as a project leader at a remote site and handled a team of 6 offshore members to support the Oracle Applications GL, AR, and FA modules with coordination from onsite.
- Managed the remedy tickets created from Appworx end-users for various issues.
- Provided value adds to the existing customization to improve the performance.
- Analyzed the repetitive tickets and reduced them by providing RCA (root cause analysis).
- Provided 24x7 support due to critical GL and AR transactions.
- Guiding the team for any challenging/complex problem tickets.
- Implemented various data setup and env creations in production, staging, and testing instances.
- Performed various job processes done at the month’s end close period.
- Monitored the data movement jobs and scheduled Appworx jobs.
- Coordinated with the onsite coordinator and various entity users.