Shivangi Uppal

• Developed, tested, troubleshoot and maintained software applications
• Designed and implemented user interfaces for web-based applications.
• Provided technical assistance to junior developers in debugging code.
• Created efficient algorithms to optimize existing systems.
• Prioritized and organized tasks to efficiently accomplish service goals.
• Developed and maintained database systems to ensure data accuracy and integrity.
• Participated in design reviews for new or modified databases to ensure that all requirements are met.
• Executed complex SQL queries against multiple databases for reporting purposes.
• Designed API service for data loading from excel file template into oracle database.
• Analyzed user requests and identified potential areas of improvement in existing processes or applications connected to the database systems.

Designed and developed Clinical Study Payments system using Angular5, web API and typescript with oracle database as main lead. The system consists of different modules for setting up prices, sites as payees and reports based on the data. The system generates reports for amount calculated through payment process for the forms submitted by sites. These forms are used in clinical trials conducted by Abbott for the medical devices manufactured.

Developed and scheduled alerts with notification services based on business requirement.

Troubleshoot issues and resolve in timely manner.

• Worked on Database Insurance Agency Systems using Oracle Forms and structured Query Reports SQR tools. The system comprised of integrated insurance system designed for insurance agencies to maintain their customer Database, Policy Management, Claim Management, Calculating Agency Commission etc. Main duties included client support, designing, developing, testing, customized product, bug fixing
• Tested, debugged and corrected errors in programs to ensure accuracy and completeness.
• Developed and designed complex reports as per business needs using SQR.
• Prepared technical documentation including flowcharts, diagrams, manuals, reports. related to programming projects.