Business Analyst
Tata Consultancy Services Limited
مجموع سنوات الخبرة :7 years, 0 أشهر
Unify Circle Operations - Assam and North East Circle:
Project: Unify circle operations-Assam and North East
Customer: Vodafone India Limited
Description:
Vodafone India, formerly Vodafone Essar and Hutchison Essar, a joint venture with UK-based Vodafone Group Plcis the second largest mobile network operator in India. It has approximately 140.84 million customers as of November 2011. Vodafone India provides 2.75G services based on 900 MHz and 1800 MHz digital GSM technology.
ANE circle is the most important centre of VIL in the Eastern HUB of India.
Support for all application in Postpaid and PrepaidActivation in VIL is provided at circle level as well as to all the HUB-s of Eastern region of India, which includes the states of Uttar Pradesh, Bihar, Orissa, West Bengal and North Eastern Zone.Applications include cPOS(Centralized Point of Sale) and UPSS (Unified Prepaid Support System).
Reports are provided on ad-hoc basis as required by the Clients for all applications. These helps the users in various type of reconciliations and at many times help them in forecasting the business depending on the past and current trends. This also helps them in Identifying Revenue Leakage, Monitoring Usage, Identifying Fraud Customers, Barring of Customers, high potential customers etc.
L1 and L2 support for daily operations issues. Application Calls (Tickets raised by Users) are resolved for cPOS and UPSS. Supporting the activities related to new Project Roll-Outs for the circle and New product configured.
Expertise in analyzing and translating business requirements into technical specifications in collaboration with application developers.
New Product Configuration as per Marketing Team requirement/ others Team at UPSS.
New Keyword Configuration at CAD as well UPSS.
RFC and CR information providing to concern stakeholder.
Role: Business Analyst
Responsibility:
Requirements Gathering
Developing applications based on User requirements.
Providing Customer details and Call details to circle Nodal officer who in turn provide the same to VTM cells and Security agencies.
Regularly monitoring Rejected CDR cases, identifying the reason after analysis, and taking measures to reduce the number of rejected CDR-s.
Implementing the best practises, this is being shared by other circles.
Doing UAT for various new application rollouts.
Reduction of Remedy calls &Adhoc requests.
Providing training to the users to newly developed application at circle end as well as new roll outs.
Number reconciliation between various IT systems and HLR
Solution Environment: Windows XP, Windows 7
Oracle 9i database
CPOS
UPSS
Tools: Toad 7.5.2.0, SQL, PL/SQL
Duration: September 2012- till date
Project: TTL Hub IT Operations - North East and Assam (NESA)
Customer: Tata Teleservices Ltd.
Description: Tata Teleservices Limited is India’s leading Private Basic Telecom Service Operator. TTSL provides products and services like CDMA mobiles, Fixed Wireless & Wire line Telephony, Post Paid Internet Services, Public Booth Telephony, Walky 10, V-data card & HSIA.
NESA circle is the most important centre of TTSL in the Eastern HUB of India.
Support for all kinds of application in TTSL is provided at circle level as well as to all the HUB-s of Eastern region of India, which includes the states of Uttar Pradesh, Bihar, Orissa, West Bengal and North Eastern Zone.
Applications include ePOS, Metasolv, BP, Prepaid Systems, FIS, etc.
Reports are provided on ad-hoc basis as required by the Clients for all applications. These helps the users in various type of reconciliations and at many times help them in forecasting the business depending on the past and current trends. This also helps them in Identifying Revenue Leakage, Monitoring Usage, Identifying Fraud Customers, Barring of Customers, high potential customers, ARPU trend analysis etc.
L1 and L2 support for daily operations issues. Application Calls (Tickets raised by Users) are resolved for ePOS, Metasolv& CRM applications.
As per requirement, subscriber details and call details are provided to circle Nodal Officer who in turn provides the same to VTM (Vigilance Telecom Monitoring) cells and Security Agencies.
Creating web based applications according to the circle requirements and maintaining and enhancing them henceforth.
Supporting the activities related to new Project Roll-Outs for the circle.
Role Application Management
Responsibility Requirements Gathering
Ad-hoc reporting for BP, Prepaid, ePOS, Metasolv and other systems.
Developing applications based on User requirements.
Providing Customer details and Call details to circle Nodal officer who in turn provide the same to VTM cells and Security agencies.
Regularly monitoring Rejected CDR cases, identifying the reason after analysis, and taking measures to reduce the number of rejected CDR-s.
Implementing the best practises, this is being shared by other circles.
Doing UAT for various new application rollouts.
Reduction of CCM calls &Adhoc requests.
Providing training to the users to newly developed application at circle end as well as new roll outs.
Number reconciliation between various IT systems and HLR
Solution Environment:
Windows XP, Windows 7
Oracle 9i database
Metasolv Solution 5.2.13.65.
CRM application
Tools: Toad 7.5.2.0, SQL, PL/SQL
Highlights Prepared few scripts in Oracle which gets dumped in Local FTP server for various BU’s for specific Itemised Billing/CDR etc.
Designed a portal for tracking employee confirmation procedure, which is used by TTSL HR.
Designed a portal for tracking the SITE details for Network team, which helped them to track the progress of the newly acquired site.
Reconciliation reports from both Billing and Journals for the Back-out Invoices have helped in prevention of revenue leakage.
Reconciliation of Dels as well as VAS features between various IT systems and HLR.
Designed and Automate different type of Feedback Mechanism for Circle FMSS Team.
Implemented best practices at Circle.
Duration July 2009- September 2012
Project: TTL--Wireline Acquisitions & Service Mgmt PSG
Customer: Tata Teleservices Ltd.
Description TATA Teleservices Limited (TTL) promoted by TATA Group is a licensed private operator for providing basic telephony services in all the Telecom Circles. In this project TIBCO Active Enterprise product was chosen as the EAI solution to integrate the following applications.
MetaSolv (Order Management)
Customer Relationship Management (Oracle Applications)
Subscriber Administration Services (Comptel)
Billing system (Arbor BP)
Point Of Sale (TCS Proprietary)
IN (Prepaid Billing and Routing System)
Role: Team member
Solution Environment Solaris 2.8 (Unix)
Windows NT
Oracle 8i database
TIBCO (TIBCO BuisnessWorks 5.2, TIB/Rendezvous 7.2, TIB/Repository 4.1.1, TIB/Integration Manager 4.x, TIB/Adapter for Active Database 4.1.0, TIB/Adapter for MetaSolv 4.1.0, TIB/Designer 4.1.1, TIB/Adapter for Arbor BP 4.1.0).
Tools: TOAD
Highlights:
Developed business process for OM-CRM interfaces in Business Works.
Configured TIBCO Components like ADB’s, enginesetc in training environments.
Implemented Distributed queue mechanism in engines to improve performance.
Writing UNIX shell scripts to automate the Process of monitoring the engines and adapters.
Implementing CR (Change Request) Changes.
Managed performance issues in production environment.
The task clearance for CRM related order.
Database: Oracle
Work Location: Tata Consultancy Services Limited, Hyderabad
Project: TTL Operations Support TIBCO
Customer: Tata Teleservices Ltd.
Description:
TATA Teleservices Limited (TTL) promoted by TATA Group is a licensed private operator for providing basic telephony services in all the Telecom Circles. In this project TIBCO Active Enterprise product was chosen as the EAI solution to integrate the following applications.
MetaSolv (Order Management)
Customer Relationship Management (Oracle Applications)
Subscriber Administration Services (Comptel)
Billing system (ArborBp)
POS (point of sale)
Role: Team Member
Solution Environment:
Solaris 2.8 (Unix), Windows NT, Windows 2003 Server (BPM Server), Oracle 8I, 9i database
TIBCO BPM Staffware 10.2 iProcess Engine, TIBCO BusinessWorks 5.2, TIBCO Enterprise Administrator 5.2, TIB/Rendezvous 7.2, TIBCO EMS 4.0, TIB/Repository 4.1.1, TIB/Adapter for MetaSolv 4.1.0, TIB/Designer 5.2, TIB/Adapter for Arbor BP 4.1.0)
Tools: TOAD
Highlights:
Developed business process for OM-CRM interfaces in Business Works
Configured TIBCO Components like ADB’s, enginesetc in training environments.
Implemented Distributed queue mechanism in engines to improve performance
Writing Unix shell scripts to automate the Process of monitoring the engines and adapters
Implementing CR (Change Request) Changes
Managed performance issues in production environment
The task clearance for CRM related order
Project: Mathematical aspects of a class of discretization schemes for Maxwell's equations
Client: Electrical Engineering Department, Padua University, Italy
Project Description:
A formulation for the solution of coupled problems of steady-state electric and transient thermal conductions in three-dimensional regions. The model is based on the cell method approach, taking advantages of the very agile algebraic formulations that it can provide for field theories.
Responsibilities
• Communication with the Client
• Work allocation and scheduling
• Coding
• Preparation of design documents, unit test plans and System Test Plan
• Review of the design documents and unit/system testing of the system
• Quality Assurance
• Code Integration
Software/Tools/Languages: Oracle PL/SQL, MATLAB, Unix
Operating System: Windows XP
Database: Oracle
M.Sc. in Mathematics & Computing Department of Mathematics, IIT Guwahati
B.Sc. (Hons) in Mathematics Aligarh Muslim University, Aligarh
•Higher Secondary (10+2) in Science Stream (May 2001) Cotton College, Guwahati (AHSEC)