Ayushi Jain
Bangalore
Summary
Experienced Oracle Developer skilled in PL/SQL, SQL, Oracle Fusion, Oracle E-Business Suite and Supply Chain Management. Proven ability to design, optimize, and manage database systems to improve business operations. Strong problem-solving skills with a focus on delivering efficient and reliable solutions that support business needs. Experienced in working with teams to create custom reports, integrations, and system improvements within Oracle environments.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Senior Consultant
SymphonyAI
Bengaluru, India
06.2024 - Current
- Worked with well-known clients like Holland Pharma, Action and Poundstretcher, providing customized Oracle solutions to address their business needs
- Contributed to the full software development lifecycle (SDLC), including analysis, design, development, testing, and deployment of new features
- Designed and implemented PL/SQL solutions (packages, functions, procedures) and optimized SQL queries for performance tuning
- Managed integration of key business processes (items, orders, pricing, assortments, and receptions) within the G.O.L.D (Symphony Tool) system
- Responsible for fixing bug in production environment
- Developed and maintained outbound integrations using XML agents, ensuring smooth data transfer between systems and third-party applications
- Customized solutions to align with business requirements, including the generation of JAR, APPLI and XSD files for system integration
- Currently focused on implementing and optimizing allocations for Gold Store Operations, enhancing inventory management and operational efficiency
Senior Application Developer
IBM
Bengaluru, India
09.2021 - 05.2024
- As a technical developer, translating functional requirements into technical specifications across Oracle Cloud ERP modules such as Order Management (OM), Supply Chain Management (SCM), Procurement, Inventory Management, and Costing
- Designed and developed BI/OTBI reports and ESS jobs to support efficient data reporting and analysis
- Created SQL queries for data extraction, ensuring accurate and optimized data retrieval
- Gained experience in data conversion using FBDI and ADFDI methodologies for seamless data migration.
- Developed and optimized PL/SQL packages, functions, procedures and cursors, with a focus on performance tuning.
- Demonstrated a strong understanding of the O2C and P2P cycles within the Fusion environment.
- Created and maintained database objects, including tables, indexes, views and synonyms, ensuring efficient data management.
- Collaborated effectively with cross-functional teams (OIC, Data Warehouse, DBA, EBS/Fusion Functional) and utilized tools like Postman and SoapUI for testing, as well as writing shell and SQL scripts for migrating database objects across instances.
System Engineer
INFOSYS
Hyderabad, India
08.2019 - 09.2021
- Worked as a developer on two key projects: Cisco Oracle Lease & Finance Management and Cisco Order Management, contributing over 2 years of experience
- Participated in all phases of the projects, including requirement gathering, analysis, design, development and testing
- Implemented PL/SQL designs, including the creation of packages, functions, and procedures to meet business requirements
- Developed optimized SQL queries and performed performance tuning to enhance system efficiency
- Gained hands-on experience with Oracle E-Business Suite and Oracle Reports, supporting various business operations
- Utilized Oracle BPEL to build middleware composites, ensuring smooth system integration
- Contributed to the creation of key project documentation, including Solution Design Documents (SDD) and Technical Design Documents (TDD) and developed structured test plans and test cases
- Involved in Go-Live support activities, including code migration and deployment to production instances, ensuring smooth transitions to production environments
Intern
INFOSYS
Mysore
01.2019 - 04.2019
- Trained in PL/SQL, Oracle E-Business Suite, SQL Loader, Oracle Reports, Oracle Workflow Builder, as well as Python, DBMS, and Data Structures
- Contributed to the Oracle project 'Online Kart,' gaining hands-on experience in the development and implementation of Oracle-based solutions
Education
Bachelors of Engineering - Computer Science
ITM Group of Institutions
01.2019
High School -
The Radiant H.Sec.School
01.2015
Skills
- PL/SQL
- SQL
- Supply chain Management
- Oracle Fusion Cloud
- Oracle Reports (BI/OTBI)
- Oracle EBusiness Suite
- FBDI/ADFDI
- RDBMS
- OIC
- Python
Certification
- Oracle Cloud Infrastructure 2023 Certified Architect Associate
- Oracle Cloud Data Management
- Oracle Cloud Platform Application Integration
- Professional Oracle Fusion technical - A Complete Technical Guide
Timeline
Senior Consultant
SymphonyAI
06.2024 - Current
Senior Application Developer
IBM
09.2021 - 05.2024
System Engineer
INFOSYS
08.2019 - 09.2021
Intern
INFOSYS
01.2019 - 04.2019
Bachelors of Engineering - Computer Science
ITM Group of Institutions
High School -
The Radiant H.Sec.School