Project : Network operations center(NOC)

Tools used : Symphony Summit, ITSM, ITAM, MYSQL

Project Description:

Symphony Summit is an advanced and intelligent cloud-based ITIL service management platform that utilizes latest innovations in IT technology including mobility, analytics, and automation to enable IT service firms and CIOs enhance the productivity of their IT service operations while bringing down their operational costs and removing usual complexities involved

Role & Responsibilities:

·Configured/Implemented Symphony Summit applications to customer/clients.

·Implemented Asset Management to the customer in Symphony Summit Application.

·Incident Management, Problem Management, Change Management, Request Management.

·Configuring the Report templates and auto alerts like Email, SMS Alertsystem.

·Templates creations to ITAM, ITSM, CMDB modules.

·Creating the auto run scripts using custom scheduler methods.

·Application Programming interface’s testing between custom application and Symphony Summitx

Project : Enterprise Data warehouse

Tools used : Teradata SQL Assistant, TD 13.10, Informatica, SQL

Project Description:

EDW implemented a data warehouse to better plan and manage revenue realization, customer retention and acquisition and also to establish a data warehouse of usage, billing and provisioning information for the telecom. Collect responses of the telephone numbers every month which provides the carrier information of a telephone number. There are different methods defined to get the response of a telephone number. Depending on the method assigned the response comes

in a specific file format. Also for some numbers the responses are collected from the third party vendor

Role & Responsibilities:

·Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.

·Used volatile table and derived queries for breaking up complex queries into simpler queries.

·Writing SQLqueries according to process needs

·Optimize the queries by performance tuning.

·Created unit test plans to unit test the code prior to the handover process to QA Preparation of Test Cases

·Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system.

·Providing support during the UAT phase

Project Description:

Sapphire One is an ERP, CRM, and business enterprise financial accounting software designed for small to medium-sized businesses and large business enterprises. Unique and easy to use, it is a suite of software solutions that organizes the business enterprise processes of organizations into a single unified database. Thus, it helps users manage the financial aspects of their business, their obligations to their employees; and the transactions and projects they are involved with. Sapphire One aims to simplify the flow of information between the processes within an organization.

Role & Responsibilities:

·Understanding the application thoroughly with help of Business Requirement document.

·Prepared Traceability Matrix to ensure the test case coverage for all requirements.

·Involved in Test Case Design, Test case Review, Updating Review Comments and Test Case Execution report.

·Performed Smoke, Functional, Integration, System testing.

·Performed Ad hoc and Regression testing.

·Detect the defects and logged the defects, after classifying them based on the priority and Severity.

·Engaged in the preparation of Daily Status Report and sharing it with the Clients.

·Active participation in Daily Status Calls and Defect calls.

·Handling ITIL Processes (Incident, Change and Problem Management) inSapphire.

·Features configuration of SapphireIMS – All modules and phases about product.Integration Testing to Custom Application from SapphireIMS using WebAPI Codes (Rest API - WSDL).

·Identify columns for Primary Keys in all the tables at the design time and create them.

·Develop reports in SQL Server Reporting Services.

·Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications

·Consultants implementing CRM by identifying success factors and focusing on any issues that might put a project at risk

Symphony Summit is an advanced and intelligent cloud-based ITIL service management platform that utilizes latest innovations in IT technology including mobility, analytics, and automation to enable IT service firms and CIOs enhance the productivity of their IT service operations while bringing down their operational costs and removing usual complexities involved