MANGAL TYAGI

[email protected] • +91-7503926048 • Ghaziabad, Uttar Pradesh
LinkedIn: https://www.linkedin.com/in/mangal1995/

PROFESSIONAL SUMMARY

Results-driven Senior Engineer with expertise in PL/SQL, SQL query tuning, and Unix shell scripting, dedicated to optimizing database performance and driving operational efficiency. Proven track record of reducing query execution times by up to 40% through advanced SQL optimization and data model tuning. Adept at leveraging strong problem-solving skills to deliver scalable solutions in fast-paced environments, enhancing system reliability and stakeholder satisfaction. Committed to applying technical acumen and collaborative leadership to support business objectives and accelerate project delivery.

WORK EXPERIENCE

Senior Engineer L1
12/2024 - Present
Emerson IT Solutions
• Led and mentored a team of 5 engineers in the development and support of over 15 Oracle EBS R12 technical components, including Reports, Interfaces, and Extensions, improving system reliability by 20% through innovative automation of error detection processes using Agile methodologies and Azure DevOps for project tracking
• Delivered customized Finance and SCM module solutions aligned with business requirements, collaborating cross-functionally with finance and supply chain teams to reduce manual processing time by 25%, while coaching junior team members on Oracle EBS best practices and PL/SQL optimization
• Developed and optimized PL/SQL packages for data conversions and implemented API-based integrations using Oracle ERP REST services and Oracle Integration Cloud, enhancing data accuracy by 30% and resolving complex data synchronization challenges
• Spearheaded cross-regional stakeholder management and led a global Oracle EBS rollout project across 5 countries, achieving go-live milestones 10% ahead of schedule by proactively addressing integration issues, streamlining communication channels, and applying Scrum framework principles
Associate Engineer L2
11/2022 - 11/2024
Emerson IT Solutions
• Led automation of Oracle EBS data integration workflows by developing complex PL/SQL packages, optimizing OTBI reports, and implementing Oracle RESTful services APIs, resulting in a 30% reduction in manual data processing time
• Spearheaded migration and enhancement of over 15 RICE (Reports, Interfaces, Conversions, Extensions) components within Oracle EBS, ensuring seamless transition with zero downtime and improving system scalability
• Conducted advanced SQL query tuning and refactored database schema designs to enhance transaction throughput by 25%, significantly boosting overall system performance
• Collaborated with cross-functional teams to implement best practices in Oracle EBS customization, driving a 20% increase in operational efficiency and reducing post-deployment defects
• Integrated AI-powered GitHub Copilot into the development workflow, accelerating code generation and reducing development time by 15%, while maintaining high code quality and adherence to standards
• Mentored junior developers on leveraging AI-assisted coding tools, fostering innovation and improving team productivity in Oracle EBS customizations
System Engineer
06/2020 - 11/2022
Tata Consultancy Services Ltd.
• Led the design, development, and optimization of over 50 custom Oracle EBS R12 concurrent programs and reports using PL/SQL for AR, SLA, and GL modules, leveraging Oracle Workflow Builder and Oracle Forms to improve data processing efficiency by 30%
• Executed seamless migration and rigorous validation of 200+ CEMLI components—including custom Oracle Forms, Oracle Reports, Workflows, and Concurrent Programs—during Oracle EBS R12 upgrade cycles, ensuring 100% compatibility and zero post-deployment defects
• Collaborated with cross-functional business and functional consultants to gather detailed requirements and translate them into scalable PL/SQL packages, Oracle Alerts, and custom APIs, reducing development cycle time by 20% and enhancing integration with Oracle EBS modules
• Played a pivotal role in the full SDLC of Oracle EBS projects, including configuration of Oracle Workflow processes, concurrent manager setups, and profile options, resulting in enhanced system stability, optimized concurrent processing, and improved end-user satisfaction
Assistant System Engineer
06/2018 - 05/2020
Tata Consultancy Services Ltd.
• Led performance optimization initiatives in Oracle EBS environments by implementing advanced PL/SQL enhancements, resulting in a 30% reduction in query execution time and improved system responsiveness
• Developed and deployed custom automation tools using shell scripting and SQL utilities, automating over 50 repetitive processes and reducing manual effort by 40 hours per month
• Collaborated with cross-functional teams to identify bottlenecks and implement scalable solutions, enhancing overall application stability and user satisfaction
• Maintained and supported critical Oracle EBS modules, ensuring 99.9% system uptime and timely resolution of incidents

EDUCATION

B.Tech in Computer Science
01/2014 - 01/2018
AIACT&R, Guru Gobind Singh Indraprastha University, Delhi GPA: 80%
Class XII (Computer Science)
01/2014
St. Paul’s Academy, Ghaziabad GPA: 92.2%
Class X (Computer Science)
01/2012
Fatima Convent School, Ghaziabad GPA: 91.8%

SKILLS

Technical Skills: PL/SQL, SQL Query Tuning, SQL Query Optimization, Unix Shell Scripting, Data Model Tuning, Oracle ERP REST APIs, Oracle Cloud ERP, Oracle Integration Cloud, Oracle Data Integrator, Oracle REST Data Services, Process Automation, Oracle Cloud Infrastructure
Soft Skills: Problem Solving, Analytical Thinking, Collaboration, Adaptability, Communication
Tools: BI Publisher, OTBI, Oracle Reports, Azure DevOps, UiPath, GitHub Copilot, Visual Builder Cloud Service
Other: Oracle SCM, ISG, OIC, VBCS, App Composer, Industry Knowledge: ERP Systems, Automation, Finance

CERTIFICATIONS

Oracle Cloud Infrastructure 2025 Certified AI Foundations Associate
08/2025
Oracle
Oracle Visual Builder Training
05/2025
TechSupper

ACHIEVEMENTS

• Received Business Impact Awards for delivering impactful projects at Emerson.
• Awarded ‘Star of the Month’ and ‘On the Spot’ for exceptional performance in project delivery and support.
• Recognized with the LIREL Award for leadership and knowledge-sharing excellence.
• Achieved AIR-10 in the Indian Engineering Olympiad (IEO) in February 2016.
• Secured State Rank-16 in the International Olympiad of Mathematics, 2013.

Similar Resumes

Kavitha S Ramadoss Senior Cloud Engineer/Platform Engineer Parth Atara Senior Software Engineer Ahmedabad, Gujarat KABILAN M Senior Software Engineer Chennai KABILAN M Senior Software Engineer Chennai KABILAN M Senior Software Engineer Chennai