Ramneet Jaggi, PL/SQL Tuning Developer in Galway, Ireland
Ramneet Jaggi

PL/SQL Tuning Developer in Galway, Ireland

Member since April 25, 2018
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.
Ramneet is now available for hire

Portfolio

Experience

Location

Galway, Ireland

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.

Employment

  • 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, 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

Experience

  • Automation of Monthly Refresh Process (Development)

    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 (Development)

    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) (Other amazing things)

    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

Skills

  • Languages

    SQL, Core Java (J2EE), 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

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

    Agile Software Development
  • Frameworks

    Bootstrap
  • Platforms

    Windows

Education

  • Bachelor's degree in Computer Science Engineering
    2005 - 2009
    Dehradun Institute of Technology - India

To view more profiles

Join Toptal
Share it with others