Melroy Coelho, Principal Software Engineer

Melroy Coelho

Principal Software Engineer

Epicor

Location
India - Bengaluru
Education
Bachelor's degree, Computer Science
Experience
17 years, 5 Months

Share My Profile

Block User


Work Experience

Total years of experience :17 years, 5 Months

Principal Software Engineer at Epicor
  • India - Bengaluru
  • June 2021 to September 2023

At Epicor, I have worked on multiple projects Integration/Core that span various
components of the Prophet21 Distribution ERP. These range from security projects to automatic
scheduling services that are listed below.

Epicor Scheduling and Capacity Planning
This is a cloud-based solution which will be used to connect to any application and extract information
that then allows capacity and scheduling planners to get visual representations of their resource
availability and then use Gannt charts to organize entities to meet delivey deadlines.
It uses all cloud-native components for scalability and deployment. The project also uses Google OR Tools
to provide linear algorithms for the scheduling and capacity forecasting. This data is then transformed to
data-sets that can be sent back to the application for updates to schedules and planned times.

Epicor Identity Provider
Prophet 21’s authentication provider capabilities were extended to use an internal OAUTH2.0 enabled
authentication provider so that we could provide our customers with MFA and OAUTH2.0 capabilities.
My responsibilities on this project involved ensuring that our current authentication standards can be
consolidated with the new OAUTH provider as well as eliminating any redundant code to improve
security.

Automation Studio (Integration)
Prophet 21 now integrates with a workflow automation tool called Workato which allows customers to
create low-code/no-code worlflows that can perform actions with their existing third-party integrations.
This helps customers achieve workflow integrations faster without having Prophet 21 do any of these
integrations thereby reducing time to execution and delivery for our customers.

Core Responsibilities
As part of my core responsibilties for Prophet 21, I have been involved in the following activities
P21 Scheduler - This component allows customers to automate activities that they perform on P21.
These can involve invoice generation, pick ticket printing, etc.
P21 ODATA Services - I have improved performance of our ODATA services that customers use for data
access and also improved related services that our integrations use.
Caching for Performance Improvements - The introduction of a simplified caching system has reduced
frequent calls by approximately 900% in certain cases where information in sessions were making
unnecessary database calls. The solution also uses a thread-safe approach to caching allowing multiple
calls via threading/api infrastructure calls to the system.

Software Architect at Ridgehead Software
  • India - Bengaluru
  • January 2011 to June 2021

During my time at Ridgehead, I have worked for multiple clients architecting, developing,
maintaining and upgrading a plethora of applications and integration systems. I have listed my
work as per the clients I have worked with.

CLIENT - NetApp Inc. (Jan 2011 - Jun 2021)

Net2 Application
Java/JBOSS solution developed for NetApp to provide document dispersal via a web-interface or a thick
client for employees and partners with access to Net2. The additional features of the tool also include a
Survey building and deployment facility which deploys the survey created to a mobile device,
web-browser or the thick client. Reporting functions are also a part of the application and are used by
adminisrtators and users for discerning data in the application. The system also acts as a transaction
initiation gateway between SAP and field service engineers allowing them to get information in the field
and process service orders for partners that NetApp sells its hardware to for maintenance. This web-app
allows chat interfacing options so that field service engineers can talk to CSRs for quicker resolution.

Net2 Client
This is a client that installs on both Windows and OSX. It uses the content delivery system of the Net2
Web Application to allow field engineers access to content that they use at client locations for servicing
and replacing parts. It works in both online and offline mode thus allowing users to always be able to
use it irrespective of customer network security constraints.

CSS Track
This is a CRM tool used to track work/projects in the form of tickets that can be administered by project
administrators. The tool also has a workflow feature which allows admins to create workflows for tickets
based on user-interactions as well as system triggers. It was originally written with a SQL back-end but
is currently using a MongoDB back-end.

Net2 Billing
This is a financial reporting tool used by NetApp to track the costs and partner payments associated
with all their contracts and services provided as part of maintenance plans. The system interacts with
a reporting system (SQL) to build data that is then used by Financial Administrators to be pused to a
master billing system which is then used to invoice partners or for payments. It also has a cost projection
system which allows users to project costs over a month so that they can use the data to improve
contracts. The core system for building is done in SSIS and the reporting structure uses a combination of
SSRS and C# to build data that can be used for analysis.

Net2 RMA Tool (Asset Recovery)
This tool is used by NetApp to track parts that have not been returned by clients that have either asked
for servicing and simply not returned the defective hardware or in cases where historical data is
inaccurate and requires to be consolidated. The system also allows CSRs to track their interactions with
clients so as to provide an audit trail for follow-up should it be necessary. The entire process for this
was manual before it was converted to a system that does not require user-intervention when items
are returned or their status is changed. The key integration points in this system are SAP, Oracle and the
Reporting System (SQL) from which data is gathered and automatically transformed to provide value
to the client for tracking and re-acquiring their hardware. The system also provides a robust search
interface for granular as well as macro search capabilities where necessary.

Miscellaneous
As part of all my development activities, I also manage the servers that host our applications from a
health and software upgrade perspective. The applications are monitored for any defects and server
performance issues are dealt with by me and dealing with technology stack architectural decisions as
well as moving applications into the continuous integration path with testing implemented

Lotus Application Developer at Ibm - India
  • India - Bengaluru
  • May 2006 to January 2011

During my time at IBM I worked on pre-developed Lotus Notes solutions used by Helpdesks worldwide
providing content, authoring soltuions, workflow management for content approvals and content
meta-data management. I was also involved in a system that provided content to up-skill CSRs so that
they could provide customers with better support

ASP.NET System (ITHC) Application Developer
Global IT KM Lead
Lotus Notes System (ITKM) Database Designer

- Special projects in Mobile development for site using the Mobile SDK for .NET Frameworks
- Broken Link Tools for internal documentation fixing and reporting related to ITHC V8
- Worked on Site integration with Windows Task for Broken Links Tool \[WinForms\] which offers users
the ability to manage their tasks after the Windows Task has run
- Worked on SEO Friendly URL Aliasing and Redirect systems for ITHC V8.0 \[UrlRewriting.Net\]
- Worked on Lotus Notes integration solution for content synchronization between
ITHC V8.0 (ASP.NET Solution) and a Notes DB (Java and Domino XML)
- Worked on ITHC V8.0 SQL validation and report generation code for Administration backend,
- Category Administration for ITHC Content Taxonomy, Template definition module
and News Deployment/Management
- Release 3.2 Development Lead for Global ITKM Systems. Changing Geography remapping systems to
incorporate changes in World geographies as per client needs.
- Worked with IT Help Central v8.0 as an ASP.NET web developer on the backend Administration Systems.
- Developed Lotus Notes solutions related to content management systems used by Helpdesk professionals
with IBM for internal accounts and Worldwide IBM users
- Worked on project requirements and liaised with customers for improvements to the IT KM System
- Performed change management requests with regards to maintenance and improvement of existing
functions in the Lotus Notes system
- Worked with IT Help Central (Web Portal) for export of Lotus Notes content to the website used by
IBM internally. In addition to this, import functions were also handled and improved for speed and efficiency
- Worked with release 3.0 from a development perspective and have worked with TeamStudio
Configurator tools in relation to database functionality offered to clients
- Tested and developed on release Global IT KM Release 3.1 for content management improvement of the
system and direct integration with IT Help Central Release 7.1

EMEA CSC Database Administrator/HAL (Helpdesk Active Learning)

- Content management and revision for products and services in EMEA supported
by IBM (internal user support)
- Conducted training sessions for new services offered by internal IBM teams for EMEA agents
- Development of HAL modules and tests
- HAL improvement planning
- EMEA CSC Database content migration to Global Knowledge Base (North America and EMEA Knowledge
Consolidation Project)
- Development of portal for test results and report generation of trainee progress
- Interaction with Service development teams for information on product to provide adequate technical
training to agents along with support documentation

Education

Bachelor's degree, Computer Science
  • at Florida Institute Of Technology
  • December 2022

My degree is a CS degree but it also covers software development and in particular it covers testing as a subset of that as well. Anywhere I have gone since I have gotten this degree, I have always used my knowledge of testing to help improve the work I am doing.

Specialties & Skills

Web Development
ASP.NET AJAX
INTEGRATION
JAVA (PROGRAMMING LANGUAGE)
CHANGE MANAGEMENT
ASP.NET
CONTENT MANAGEMENT
EXTENSIBLE MARKUP LANGUAGE (XML)
MANAGEMENT

Languages

English
Expert

Hobbies

  • Scale Model Building
    I build scale models as a hobby interest