MAYUR MHATRE
Navi Mumbai
Summary
- Overall, 11 years of IT experience in Retail and Energy Domain.
- Having relevant experience in Oracle Retail domain as a Techno Functional Consultant.
- Leading the discovery and implementation phase for upgrading Oracle Retail from v14 to v25.
- Leading the team to fill the process gap and to provide the information to ORC team and helping them with existing functionality to develop the new v25 applications.
- Leading the development team with comprehensive experience in managing high-quality software development projects.
- Extensive hands-on experience on Oracle Retail version 14.0.2 including modules like Oracle Retail Merchandising System (ORMS), Oracle Retail Price Management System (ORPM) and Deals and Rebate (DARA) Custom Application.
- Having knowledge of Oracle Retail Cloud services like MFCS, RPCS and POM.
- Able to drive innovation and efficiency while maintaining tight schedules and budgets.
- Proven track record for delivering robust solutions that increase business productivity.
- Technical capabilities in building solutions using PL/SQL objects, Unix Shell Scripts, Oracle ADF and Oracle Forms.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Oracle Retail Practice & Developer Lead
John Lewis Partnership
Navi Mumbai
11.2020 - Current
- Leading a Development team for different projects within JLP account for the ORMS, Deals, and Rebate modules. This includes discussion with the client to gather requirements and gain efficient knowledge for the project.
- Leading the discovery and implementation phase for upgrading Oracle Retail applications from v14 to v25.
- Leading the team to fill the process gap and to provide the information to ORC team and helping them with existing functionality to develop the new v25 applications.
- Leading the team for effort estimation for any new requirement and preparing a functional and technical design document.
- Responsible for the development or enhancement of the Oracle ADF custom application, custom Oracle Forms, custom batches, and Unix shell scripts.
- Having exposure to Agile Methodology as well.
- Responsible for guiding the peer team members in production issues and problem root cause analysis.
- Leading the change review process and peer code reviews.
- Handling outside business hours on-call support as well for Oracle Retail Batches.
- Hands-on experience in JDeveloper, ADF Faces, ADF Task Flows, ADF Business Components, ADF Skinning, and implementing UI Validations & Core Java.
Developer Lead (PL/SQL & Java)
Centrica
Navi Mumbai
04.2020 - 10.2020
- I was handling NWBF batch process along with the failures to avoid loss of client's data and to make sure all the data is processing accurately
- I was leading the SAP CE application issues to help user to insert/update business sensitive PROJECTS data into the database
- Leading development & enhancement business requirements along with RFIs for the business users.
- Responsible for building the PL/SQL queries to gather the client requested reports and other information.
- Responsible for leading the day-to-day support activity.
- Coordinating with other teams and guide and support in the process.
- Hands-on experience in Procedures, Cursors, Functions, Triggers, Views and Indexes in Oracle SQL Developer.
Team Leader, Operations
Scottish Power
Navi Mumbai
11.2012 - 04.2020
- Client interaction for requirement gathering, system analysis, technical & functional knowledge for the application development
- Providing post-implementation, application maintenance and enhancement support with regards to the Product / Software Application
- Responsible for documenting application overview documents, technical documents, specifications and function documents
- Responsible for the client for meetings, plan discussion and requirement analysis
- Handling remedy or IT-Now incidents and tickets
- Ensuring 100 % SLA Service level agreements) meet on Remedy queues
- Having good knowledge across all the applications of Scottish Power project
- Responsible for handling the client's major incidents and also helping businesses to repatriate the MPANs back to the legacy system which was migrated to SAP Paid task)
- Writing PL/SQL queries to gather the client requested reports
- Working on Procedures, Cursors, Functions, Triggers, Views and Indexes in oracle and basic development knowledge as well
- Having good knowledge in Energy domain and currently playing Team Lead role in Scottish Power project from more than 4 years
- Project Star Award received in Nov 2019.
Education
B. Sc.: Information Technology -
University of Mumbai
01.2012
Skills
- Oracle PL/SQL
- SQL Developer
- Oracle Forms
- Oracle ADF
- JDeveloper
- Core Java
- Unix Shell Scripting
- BitBucket
- SVN
- GitLab
- Service NOW
- IT-Now
- Remedy
- JIRA
Certification
- Consumer Product and Retail L2 - June 24
- Oracle Apex: Foundation 2024 - April 24
- Oracle Cloud Infrastructure 2023 Certified Foundations Associate
- Retail Merchandising Cloud Service Next-Gen Technical Implementation Specialist - May 23
- Agile Software Development, University of Minnesota
- Microsoft Certified: Azure Fundamentals 2020
- Oracle Cloud Infrastructure Foundations 2020 Certified Associate
Awards
- JLP Honour Roll Award in Aug 2023
- Appreciated by Customer for handling the project
- JLP Honour Roll Award in Sep 2021
- Project Star Award received in Nov 2019
Hobbies and Interests
- Playing Saxophone
- Chess & Carrom
- Book Reading
- Music and Movies
Timeline
Oracle Retail Practice & Developer Lead
John Lewis Partnership
11.2020 - Current
Developer Lead (PL/SQL & Java)
Centrica
04.2020 - 10.2020
Team Leader, Operations
Scottish Power
11.2012 - 04.2020
B. Sc.: Information Technology -
University of Mumbai