Ramneet Jaggi, Developer in Galway, Ireland
Ramneet is available for hire
Hire Ramneet

Ramneet Jaggi

Verified Expert  in Engineering

PL/SQL Tuning Developer

Location
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.

Oracle Application R12 EBSSQLOracle PL/SQLPL/SQL DeveloperOracle SQL DeveloperToadGitHubPostgreSQLOracle BI PublisherJiraXML PublisherJenkinsAgile Software DevelopmentHTML5Microsoft Power BIWinSCPPuTTYOracle Workflow

Portfolio

FIDELITY INVESTMENTS -US
Jira, Microsoft Power BI, Tableau, Data Warehousing, Data Warehouse Design...
FIDELITY INVESTMENTS INDIA LIMITED
Oracle Forms & Reports, PL/SQL, Informatica...
NTT Data Limited
SQL Loader, SQL, Oracle BI Publisher, PL/SQL

Experience

PL/SQL Tuning - 8 yearsOracle PL/SQL - 8 yearsSQL - 8 yearsOracle Application R12 EBS - 8 yearsGitHub - 3 yearsInformatica ETL - 3 yearsJira - 3 yearsPostgreSQL - 3 years

Availability

Part-time

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

2017 - PRESENT
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.
Technologies: Jira, Microsoft Power BI, Tableau, Data Warehousing, Data Warehouse Design, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Informatica, PL/SQL

Senior Software developer

2015 - 2017
FIDELITY INVESTMENTS INDIA LIMITED
  • Worked as an individual contributor working on Oracle complete Procure to Pay cycle .
Technologies: Oracle Forms & Reports, PL/SQL, Informatica, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Analytics, Procure to Pay

Systems Analyst

2013 - 2015
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.
Technologies: SQL Loader, SQL, Oracle BI Publisher, PL/SQL

Senior Systems Engineer

2009 - 2013
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.
Technologies: Oracle Workflow, Oracle Forms, PL/SQL, Oracle E-Business Suite (EBS) R12

Automation of Monthly Refresh Process

Procurement refreshes the monthly spend done by the organization in various categories and made it available to different business units for reporting and analytics purpose.

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

Created a visually appealing site for the employees using HTML, JavaScript, and Bootstrap. It served as a one-stop shop for all queries related to travel including policies and FAQs.

Non-profit Experience - The Budd Center(SMU)

The Budd Center addresses the challenges by equipping schools and nonprofits to work together and meet the extraordinary needs of children in poverty.

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

Languages

SQL, JavaScript, HTML5

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

Storage

PostgreSQL, Oracle PL/SQL, PL/SQL Developer, Oracle SQL Developer, XML Publisher, PL/SQL, SQL Loader

Other

Oracle Application R12 EBS, PL/SQL Tuning, Software Development, Procure to Pay, Analytics, Informatica, Oracle Forms & Reports, Data Warehousing, Data Warehouse Design

Paradigms

Agile Software Development

Platforms

Jakarta EE, Windows

Frameworks

Bootstrap

2005 - 2009

Bachelor's Degree in Computer Science Engineering

Dehradun Institute of Technology - India

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring