Praful Solanki
Verified Expert in Engineering
Data Engineer and Developer
Pune, Maharashtra, India
Toptal member since June 18, 2020
Praful is a data engineer with 19 years of experience specializing in data processing, SQL tuning, and database architecture. He creates efficient data solutions and delivers various Oracle performance engineering projects using Python, Apache Spark, Snowflake, Power BI, Azure Data Factory, Databricks, and Data Lake. Praful's expertise in Oracle, PL/SQL, and performance optimization has led to innovative solutions for Oracle EBS, enhancing business processes and system scalability.
Portfolio
Experience
- Oracle - 19 years
- SQL - 19 years
- Query Optimization - 15 years
- Oracle E-Business Suite (EBS) R12 - 15 years
- SQL Performance - 15 years
- Oracle Performance Tuning - 15 years
- PL/SQL Tuning - 12 years
- Microsoft Power BI - 3 years
Availability
Preferred Environment
Data Engineering, Microsoft Power BI, SQL Performance, Python, Apache Spark, Amazon Web Services (AWS), Snowflake, Azure Data Factory, Azure Databricks, Azure Data Lake
The most amazing...
...things I've worked on were various Oracle performance engineering projects that allowed me to think of an out-of-the-box solution.
Work Experience
Data Engineer
Freelance
- Managed a data integration project for sub-ledger accounting from supply chain to global finance applications.
- Performed data integration tasks, collecting and moving data to the required destination.
- Utilized ETL data pipelines to help customers efficiently track and perform financial data reconciliations and postings on time.
Solution Architect
Self-employed
- Built an interactive dashboard using PowerBI to connect to the data source, fetching data through Power Query for transformation into an efficient format.
- Converted the data into various graphical representations such as bar graphs, cards, and pie charts to identify trends and gain valuable business insights.
- Developed a solution used by customers and support staff to measure the performance of solving business users' problems.
- Built a solution utilized by customers to measure the performance of addressing business users' issues in period trends, using bar and line charts featuring drill-down and filter capabilities within an interactive dashboard.
- Used the Oracle database, SQL, Power BI with Power Query, DAX, and Python for complex data processing per business logic.
DBA/Oracle Engineer
Synergy Infoconnect LLC
- Improved the large size JavaScript Object Notation (JSON) data into the Oracle database using a JSON API and SQL tuning and applying the degree of parallelism efficiently on the cloud platform for healthcare data over 3.5 million records.
- Used Oracle Cloud Infrastructure (OCI) platform utilities to execute and monitor the job.
- Made use of AWS platform utilities to execute and monitor the job.
Senior Oracle Consultant
Jacobs Engineering
- Handled various Oracle application development tasks.
- Managed and conducted Oracle performance tuning required.
- Supervised and carried out Oracle shell scripting.
Senior Oracle Architect
An Indian CMM Level 5 Company
- Worked as a solution architect in Oracle performance engineering for Oracle ERP (Oracle EBS) to improve the performance of critical business processes with SQL query optimization and Oracle database-level tuning concepts.
- Aided in replacing 11i with R12 as a financial transaction processing and maintenance service system. The main objective was to review 50+ objects in terms of scalability, best practices, and optimum utilization of resources.
- Acted as an SME and senior architect on multiple Oracle performance engineering projects to fix any performance issues related to Oracle ERP (Oracle EBS) on Oracle 12c databases.
- Executed, managed, and delivered multiple performance engineering projects.
Experience
Innovative Tool Development and Supporting for Customers
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.
Oracle Financials Reimplementation Performance Review From Scalability and Best Practices
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.
Oracle Performance Engineering for Oracle Applications (EBS)
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.
OTM OBIEE Performance Improvement
Oracle Applications GL, AR, and FA Support
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.
Education
Master's Degree in Computer Applications
Gujarat University - Ahmedabad, Gujarat, India
Certifications
Data Engineering Professional Certificate
IBM | via Coursera
Python for Data Science, AI & Development
IBM | via Coursera
Introduction to Data Engineering
IBM | via Coursera
AWS Cloud Technical Essentials
AWS | via Coursera
Oracle Certified Expert in SQL Tuning
Oracle
Skills
Tools
Microsoft Power BI, Microsoft Excel, Power Query, Oracle E-Business Suite (EBS) R12, Oracle BI Publisher, AWS IAM, Amazon Virtual Private Cloud (VPC), Oracle ERP, Oracle Transportation Management (OTM)
Languages
SQL, Python, Snowflake
Paradigms
Oracle Database Architecture, ETL
Platforms
Oracle, Oracle Database, Microsoft Power Automate, Amazon Web Services (AWS), Amazon EC2, AWS Lambda
Storage
SQL Performance, Oracle PL/SQL, PL/SQL, MySQL, Data Pipelines, Databases, JSON, NoSQL, PostgreSQL, Amazon S3 (AWS S3)
Frameworks
Apache Spark
Other
Oracle Performance Tuning, Query Optimization, Performance Tuning, Data Engineering, PL/SQL Tuning, Oracle EBS, Microsoft Power Virtual Agents, Unix Shell Scripting, DAX, Oracle Forms & Reports, Amazon RDS, Cloud Computing, Azure Data Factory, Azure Databricks, Azure Data Lake, Coordinate Measuring Machine (CMM)
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring