
Ramneet Jaggi
Verified Expert in Engineering
PL/SQL Tuning Developer
Galway, Ireland
Toptal member since June 18, 2020
Ramneet is a highly skilled software development professional with advanced knowledge of PL/SQL, Informatica, BI Analytics, and Oracle E-Business Suite. She is also experienced as a data analyst, supporting and enhancing a custom data warehouse. Ramneet is proficient in full project life cycle including requirements gathering and risk analysis, technical design, implementation, and integration testing.
Portfolio
Experience
- Oracle PL/SQL - 8 years
- PL/SQL Tuning - 8 years
- Oracle Application R12 EBS - 8 years
- SQL - 8 years
- Jira - 3 years
- GitHub - 3 years
- PostgreSQL - 3 years
- Informatica ETL - 3 years
Availability
Preferred Environment
Windows
The most amazing...
...project I've worked on was the automation of a monthly refresh reducing the processing time from 15 days to four hours using PLSQL and Informatica.
Work Experience
Lead Software developer
FIDELITY INVESTMENTS -US
- Worked with business partners through requirements gathering.
- Led the way to stabilizing a procurement spend refresh process bringing it down from 10 days to five hours by doing database design, facilitating the team, absorbing new enhancements, reducing data redundancy, Integration testing, and working for user acceptance.
- Served as the data analyst for a procurement information portal using OBIEE Dashboards.
- Assisted with analysis, design, and development of Informatica workflows and PL/SQL procedures to automate the procurement information portal monthly process, projected to reduce run time from two days to a few hours.
- Improved data availability for procurement information portal (PIP) users through SQL optimization techniques.
Senior Software developer
FIDELITY INVESTMENTS INDIA LIMITED
- Worked as an individual contributor working on Oracle complete Procure to Pay cycle .
Systems Analyst
NTT Data Limited
- Worked as an individual contributor, code mentor, and reviewer for the client Quest Global Limited for implementing end-to-end Oracle HRMS and Oracle Project Accounting solution for their India location.
Senior Systems Engineer
Infosys Limited
- Contributed to design, development, and testing of RICE components related to order management, P2P, inventory, general ledger, price protection, and a custom cost engine.
- Conducted performance tuning of custom interfaces.
- Led developers and performance engineers to enhance supportability and identify performance bottlenecks.
Experience
Automation of Monthly Refresh Process
The process of refreshing used to take many days, automation made the task easier and faster.
Process Benefits:
1) Reduction in processing time from 10 days to one day.
2) Significant reduction of data volume thereby eliminating the redundancy of data.
Business Benefits:
1) Availability of spend data on the second business day of the month.
2) No outage during the process.
Creation of a Travel Site
Non-profit Experience - The Budd Center(SMU)
I worked with the team to formulate a database design using RDBMS concepts so that they could better manage the school data pouring in from several sources
Education
Bachelor's Degree in Computer Science Engineering
Dehradun Institute of Technology - India
Skills
Tools
GitHub, PuTTY, WinSCP, Oracle BI Publisher, Toad, Informatica ETL, Jenkins, Microsoft Power BI, Jira, Oracle E-Business Suite (EBS) R12, Oracle Forms, Oracle Workflow, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Tableau
Languages
SQL, JavaScript, HTML5
Storage
PostgreSQL, Oracle PL/SQL, PL/SQL Developer, Oracle SQL Developer, XML Publisher, PL/SQL, SQL Loader
Paradigms
Agile Software Development
Platforms
Jakarta EE, Windows
Frameworks
Bootstrap
Other
Oracle Application R12 EBS, PL/SQL Tuning, Software Development, Procure to Pay, Analytics, Informatica, Oracle Forms & Reports, Data Warehousing, Data Warehouse Design
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