Mangesh Badgujar

• Projects: AbbVie Projects
• Responsibilities

Proposed and implemented database packages to offload heavy operations from Java, enhancing performance by utilizing the bulk bind concept.

Analyzed application requirements based on the Functional Requirement Specification (FRS) document.

Ensured adherence to quality processes throughout the project life cycle.

Prioritized and resolved critical business and production issues with high urgency.

Participated in regular client calls for technical discussions and solutions.

Conducted impact analysis for program enhancements and modifications.

Provided production support during the warranty period.

Developed complex functions, stored procedures, triggers, and scripts to support application development.

Designed, built, and maintained efficient, reusable, and reliable code.

Optimized and maintained materialized views to improve performance.

Created scripts for complex data migration tasks.

Contributed to maintaining code quality, organization, and automation practices.

Collaborated closely with developers, UX designers, project managers, business analysts, and QA analysts.

Translated complex requirements into independent coding tasks and strategies.

Participated in design and code reviews to ensure high-quality outcomes.

Developed and optimized database schemas, tables, and relationships.

Ensured data integrity and quality across the database.

Tested databases and performed bug fixes as necessary.

• Project: UKMU Digital Support (BUPA UK)
• Responsibilities

Monitored incident alert systems during both normal hours and after-hours periods, alerting appropriate departments and personnel of malfunctions or incidents

Monitoring Production API servers and services using New Relic tool.

Creating dashboard in New Relic to provide insights of application performance metrics.

Engaged in advanced training and increased troubleshooting knowledge for resolution of highly complex customer issues.

• Project Name: Bupa Global Applications
• Responsibilities

Analyzing packaged stored procedures and functions to investigate the cause of the issue and suggest code fixes accordingly.

To create PL/SQL script for data fix according to requirements.

Writing complex SQL queries to extract data from the database.

Monitoring production servers, scheduled jobs, and applications.

Incident management and issue-solving within SLA's defined

Responsible for Server patching and system availability

Worked successfully with a diverse group of coworkers to accomplish goals and address issues related to critical services.