Merline Terance

Project Name : Master Data Management - BT PMF WS

Project description : Product Master Files (PMF) is a BT's strategic application for implementing Product Master Data Management. PMF is a repository which contains the information about what BT does. PMF will make sure that all the data required for a launch is readily available during the launch process. PMF maintains a database, stores all the information related to Business Process of BT and hence enables the reusability of the database for creating new products. PMF was mainly designed to maintain the Data Integrity.

Project Role:

• My main role as designer to set the retail product model for British telecom. In recent competitive market each day in UK there are a lot of promotions/handsets or any type of discounts are getting launched. My work to design these requirement, their impact to customers these designs will take care the product model plus how these will look like in BT.com/Agent.com .
• Active participants in the discussion with architects.
• To document the business process by identifying the requirements.
• Preparing excellent documentation (User stories and Impact analysis) from the functional requirements and specifications.
  5. Communicating process changes, enhancements, and modifications to the team.
• To make the Test plan for the testing team.
• Handling various activities of the project like information gathering, analyzing the information gathered, documenting the functional or business requirements.
• Creating and executing SQL queries for project's internal purpose.
• Worked with business customers in understanding the business requirements and implementing solutions to support analytical and reporting needs.
• Solved issues related to xml validation and generation on day to day basis.

Software Tools: XML

Database:SQL

Project Name : PCM (Product Control Manager) BT/WLMS

Project description : The Product Control Manager (PCM) provides the mechanisms to create a robust set of product catalog data that can be used and shared by external Business Support Systems and Operation Support Systems (BSS/OSS). PCM provides the mechanisms to integrate this data with the external systems. The Order Negotiator API (ON API) supports active catalog use of PCM for order configuration and quote calculation. ON API supports both a web services interface and an RMI interface via a translation layer. It responds to queries regarding product availability and product content, and calculates pricing for a configured Product Offering and its associated Pricing Plans. The Order Negotiator API retrieves information for responses and for use in calculating results. It thus enables external systems to perform real-time execution of Product Offering Rules so that queries regarding availability and content can be answered. The Order Negotiator API allows Commercial Rules to be accessed by interactive queries pertaining to product availability and product configuration. This allows external programs to use the database as an active catalog in support of order processing and fulfillment.

Roles and Responsibilities:.

• Understanding the business requirement and functional specification of the client module.
• Coding and integration testing for the transformation service, support to the internal testing team.
• Prepare detailed design documents of each screen.
• Debugging the issues if any and find out the root cause of that and resolve the issues.
• Identify gaps in current controls and suggest ways improve the existing process.
• Implementing and enhancing new features to our applications.
• Interface development and complete build test in deploy phase.
• Addressing day to day technical issues.
• Coordinating closely and productively with the engineering and other teams.
• Ensure quality assurance of the deliverables.
• Support and advice QA team testing in various environments.
• Used Log4J for logging and debugging and JUnit for testing.
• Extensively worked with the QA team coordinating testing and automation cycles.
• Also involved in setting up guidelines for Automation and worked with the testers in creating and managing the scripts.
• Wrote SQL queries for updating data into the Oracle using SQL Developer tool.

Technologies : Core Java, Java/J2EE, JDK, Spring MVC, Hibernate, Tomcat, Agile methodology, RESTful Web Services, XML, SQL.

Project Name : Reactive Repair Tool - BT

Project description : Reactive Repair Tool would be used as a diagnosis tool by BT OR and BT WS for service assurance. It is used to identify the performance related issues in last 14/28 days. It has two flavors. One for SMCs and other for CPs. For SMCs, RRT would available via WOOSH and will offer graphical representation of service performance analysis to make it easier for users to understand. For CPS RRT information would be expected via GTCJ. Upstream Systems of RRT OR are WOOSH and GTCJ. Downstream systems of RRT OR are HUB, PHOENIX and YUKON. Upstream Systems of RRT WS are WOOSH, KBD, GTCJ and simple. Downstream systems of RRT WS are SIDB, and BIP.

Roles and Responsibilities:

• Understanding the flow specifications and responsible for the development of the application which is based on MVC architecture.
• Developed for new business scenarios and change requests.
• Provided support for offshore teams during testing.
• Took part in analyzing and resolving LIVE issues.
• Supported the Live Deployments.
• Fixing ERA Defects
• Unit testing using JUnit.
• Integrated, Build and tested using Hudson.
• Building and deploying the application on testing and production servers.

Technologies : Weblogic, HTML, CSS, SQL, JSON, JSP, Servlets, JDBC, JavaScript, Hudson, Oracle and Junit, Maven.

• Identified areas of improvement in current training programs and implemented necessary changes for better outcomes.
• Streamlined the onboarding process for new trainees, reducing time to productivity.
• Facilitated practical application of newly acquired skills through real-world scenarios and role-playing exercises.
• Continuously refined course content based on feedback from trainees and evolving industry trends, ensuring up-to-date knowledge for future participants.