Abhay Chauhan

Projects

MONARCH (Automation of Bulk Data Processing) - US Based Firm

Duration Not Provided

• Developed a Python-based automation process to efficiently manage mass data creation, updates, activation, and deletion, streamlining data handling operations.
• Designed structured data templates to ensure accuracy, consistency, and system integrity, minimizing errors in data processing.
• Conducted rigorous testing of data templates to validate their effectiveness and ensure seamless integration with existing systems.
• Created and tested sample datasets to optimize automation performance, improving efficiency and reliability.
• Enhanced the overall data management workflow by implementing robust validation mechanisms and refining automation logic.

Projects

MONARCH (Oracle APEX) - US Based Firm

Duration Not Provided

• Designed and developed interactive reports in Oracle APEX, enabling businesses to gain critical insights and perform in-depth data analysis.
• Created and optimized database objects, including tables, views, functions, and procedures, to enhance data retrieval efficiency and streamline reporting processes.
• Improved query performance by implementing best practices in SQL, ensuring seamless data manipulation and faster report generation.
• Conducted thorough testing and validation of reports to ensure accuracy, consistency, and reliability of business data.
• Gained hands-on experience in SQL development, enhancing proficiency in writing complex queries and optimizing database operations.

Projects

MONARCH (Oracle VBCS) - US Based Firm

September 2024 - December 2024

• Implemented multi-language support in Oracle Visual Builder Cloud Service (VBCS), enabling application translations into Spanish, German, Dutch, Canadian English, and French Canadian.
• Configured and managed string translations to ensure accurate localization and a seamless user experience across diverse regions.
• Optimized the translation workflow by organizing and mapping language-specific content within the application.
• Conducted testing and validation to ensure consistency and correctness of translations across different UI components.
• Collaborated with stakeholders to refine localization strategies, improving accessibility and usability for global users.

Projects

Bike Wheels: Custom Bike Configuration and Information Portal

June 2024 - October 2024

• Developed an Oracle APEX web application, "Bike Wheels," to enable bike enthusiasts to customize their ideal bicycles with various personalization options.
• Implemented features allowing users to select frame colors, components, and accessories, supported by visual representations for an enhanced decision-making experience.
• Integrated detailed specifications for multiple bike models, ensuring users have access to comprehensive information for informed purchasing choices.
• Designed personalized user profiles to enhance engagement, allowing users to save preferences and track customization options.
• Ensured seamless integration with e-commerce platforms, streamlining the purchasing process and providing an interactive and user-friendly experience.

Projects

Demonstrating Oracle Integration Cloud (OIC): Connecting Systems, Empowering Businesses

April 2024 - July 2024

• Showcases how Oracle Integration Cloud (OIC) seamlessly integrates disparate systems, applications, and data sources.
• Demonstrates OIC’s capability to streamline business processes and optimize workflows through real-world use cases.
• Highlights the role of OIC in accelerating digital transformation initiatives for modern enterprises.
• Emphasizes enhanced agility and efficiency by automating integrations and reducing manual efforts.
• Showcases how businesses can leverage OIC to improve connectivity, scalability, and overall operational performance.

Projects

Building Web-Based Applications with Oracle APEX: A Showcase of Rapid Development and Customization

March 2024 - June 2024

• Showcases how Oracle APEX enables the rapid development and customization of web applications with minimal coding effort.
• Highlights the low-code capabilities of APEX, allowing users to efficiently build and deploy web-based solutions without extensive programming knowledge.
• Demonstrates the flexibility of APEX in tailoring applications to specific business needs, ensuring optimized workflows and enhanced user experience.
• Explores key features such as interactive reports, data visualization, and form-based applications to streamline business processes.
• Emphasizes the efficiency and scalability of Oracle APEX, making it a powerful tool for accelerating digital transformation initiatives.

Projects

Retail Inventory Management System App

June 2023 - July 2023

• A retail inventory management system is a software solution designed to track and manage store inventory efficiently.
• Helps retailers optimize stock levels, prevent overstocking or stockouts, and minimize product wastage.
• Improves order accuracy by automating inventory updates, ensuring seamless restocking and procurement processes.
• Enhances operational efficiency by generating real-time sales reports, identifying trends, and supporting data-driven decision-making.
• Contributes to better customer satisfaction by ensuring product availability and streamlining purchase and fulfillment processes.

Projects

Online Bike Purchase

July 2022 - August 2022

• Displays a diverse collection of bikes, ranging from standard models to high-performance superbikes, catering to riders of all skill levels.
• Offers detailed specifications and features for each bike, helping users make informed purchasing decisions.
• Provides an intuitive browsing experience, allowing users to explore various categories and filter options based on their preferences.
• Ensures a seamless and engaging interface for bike enthusiasts to compare models and find the perfect fit.
• Serves as a one-stop destination for discovering and selecting bikes that align with individual riding styles and needs.

BTech - Computer Science Engineering

DAV Institute Of Engineering And Technology - June 2020 - June 2024

Sql

C/c++

Power bi

Oracle cloud - application integration professional

Adobe photoshop

Oracle apex - developer professional

Python

Web development

Oracle visual builder studio (vbcs) - build visual applications

App development flutter (dart)