Experience Summary

10 years of working experience in Analysis, Development, Implementation and Support of BSS Applications in Telecom Industry.

• Implementation of various Interfaces across Telecom Service providers
• Production Support for Amdocs Billing, CRM and Middleware Applications
• Requirements gathering and functional analysis on Amdocs Billing CES 8.5 and EPC
• Completed 2 Major Data Migration projects with full life cycle implementation.
• Configuring the Middleware like Tuxedo and EMBUS for process communication with Amdocs systems.
• Processing of Live CDR and Data Usage files and designing file operation process for MPS and Mediation.
• Product modeling expertise for Voice and Data Products for Wireline and Wireless services.
• Testing planning and QA Analysis for Amdocs Billing and CRM applications.
• Implementing Process improvements for Order Processing in AT&T’s billing and Middleware systems.
• Release Management and Configuration of Amdocs Billing and Clarify CRM for Production and Test environments.
• Communication with key managers and framing Business and technical requirements in accordance with SLAs.
• Resource and Time management with regards to handing multiple projects and resources in Onsite - Offshore model.

Strong experience in RDBMS like Oracle, DB2 and Reporting tools.

Educational Qualification

• Bachelors of Electrical Engineering

Technical skills

Languages : PL/SQL, Perl, PHP, XML, XSL, Javascript, J2EE, WSDL

Database : Oracle 8i/9i/10g, MS-Access, SQL Server 2000, DB2

User Interfaces : UI Editor, CBex, DD Editor, CSM Online

OS : HP-UX, Windows 2000/XP/98, RedHat Linux 7.3, Solaris 5.0

Unix Internals : Shell Scripting, Socket programming, IPC, Semaphores.

Middleware : BEA Weblogic 8.1, Tibco BPM, Tibco RV, BEA Tuxedo 8, SOAP

Applications : ClariFy CRM, Amdocs Enabler & Ensemble, ADC Singl.eView, OMS, IVR

Tools (3rd party) : TOAD, SQL Navigator, Actuate eReporting and Case Studio.

Testing Tools : Mercury Quality Center, Test Director, Performance Center

Version Control : Rational ClearQuest & ClearCase, Lotus Notes

EDW Tool : Oracle Warehouse Builder 10g, Informatica

Microsoft : MS Excel, Powerpoint, Visio

Client : Confidential

Duration : Aug 2011 till date

Position : Sr. Business Analyst (Information Systems)

Environment : Amdocs Billing, XIUS Prepaid Billing, Web Services, IVR, Telephony, INCOMM, SMSC gateway

Technologies : Amdocs Ensemble, Oracle Enterprise Service Bus, SOAP, WSDL, Informatica, Oracle 10g

Project Profile: 
The project purpose includes launching a phone-in-the-box product branded as ‘U Prepaid’ to be sold at Wal-Mart. In-order for U.S. Cellular® to launch this product at Wal-Mart stores, enhancements implemented to USCC Billing, XIUS Prepaid, Oracle Middleware systems to support Activations, U Prepaid price plans, INCOMM replenishments and new call routing queues to contact centers.IVR and Telephony systems enhanced to support U Prepaid customer service specific call routing, messages and menu options. Evaluate RFP from External Vendors for new U Prepaid web portal and logistics provider selection process.

Roles and Responsibilities:

• Finalize Business Requirements from Sales, Retail, Customer Care and Marketing stakeholders for U Prepaid product.
• Create Functional and Technical Requirements to implement U Prepaid line Activations in Amdocs Billing, Oracle Service Bus, IVR, and Product Catalog.
• Evaluate the existing BAU process for USCC prepaid and perform analysis to identify U prepaid product impacts and gaps.
• Assess As-Is systems flow and Create To-Be flow for activations, support activities and financial transactions between USCC and external vendors.
• Conduct JAD sessions to finalize the Billing system design, re-architect and streamline existing design changes impacting other BSS projects for Middleware services, Ensemble Billing, XIUS Prepaid and Retail systems.
• Create technical requirements to support U Prepaid in Existing USCC Marketing and Sales Reports and reconciliation processes with external vendors.
• Assess INCOMM capabilities for U Prepaid replenishment cards and create requirements for funds redemption via web and IVR channels.
• Participate in reviews of RFP from external vendors for new U Prepaid web activation portal.
• Act as conduit between IT and the Business owners; ensuring needed change requests created for system gaps.
• Create Requirements Traceability Matrix from Discovery to deployment phase and track change requests that arise in middle of SDLC.

Client : Confidential

Duration : Aug 2010 till Aug 2011

Position : Sr. Business Systems Analyst

Technologies : Amdocs Ensemble, CSM Online, Tuxedo, SOAP, WSDL, EPC

Project Profile: 
Re-architect existing BSS systems and also create a Universal UI (replacing CSM online) to streamline customer interactions and reduce the reliance on In-House Applications. Enrich customer experience and address some of the challenges like time to market, limited billing system capabilities and outdated architecture. Universal UI brings functional parity between service channels and allow the frontline Retail and CC&B representatives to focus on the customer rather than the systems.

Roles and Responsibilities:

• Gather Business Requirements from Retail and CC&B stakeholders for new BSS processes to-be implemented in Amdocs CES 8.5 and EPC.
• Create Functional and Technical Requirements to accommodate Postpaid and Prepaid line Activations to be implemented in Amdocs Billing and Enterprise Product Catalog.
• Identify, evaluate the impact of new requirements on an existing suite of complex applications and develop billing systems procedures that meet business requirements.
• Conduct JAD sessions to finalize the Billing system design, scoping of functionality to be implemented per release and design changes needed in Middleware services for Billing and Retail systems.
• Complete Impact Assessments for all defects in production and creating Change Requests for Development teams to implement fixes.
• Data and Product modeling of Wireless Voice and data services in Ensemble and EPC.
• Participate in reviews of proposed new UI prototype and map key fields to backend services and data elements of Ensemble and EPC systems
• Create Visio diagrams to depict ‘As-Is’ and ‘To-Be’ Architecture and Designs using Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, Context Models, Event Modeling, State Modeling, Process decomposition, and document Use Case Scenarios.
• Act as liaison between IT and the Business owners; ensuring tasks lined up for releases are properly being handled in Development and QAT phases.
• Maintain Requirements Traceability Matrix from planning to deployment phase and tracking emergency fixes that are handled by scrum teams.
• Work with Retail Partners, Service Assurance and Revenue Assurance teams to gather their requirements and implement Billing systems design and determine impacts on the current workflow. Perform Gap analysis in some cases.

Client : Confidential

Duration : March 2010 till July 2010

Position : Implementation – Telecom Interfaces with external carriers (Verizon Telecom acquisition)

Technologies : Solaris, JCL, NDM, Shell Scripting, OS/390, EMI and CDR record format (Usage)

Project Profile: 
Confidential signed a deal to acquire Verizon’s regional wireline assets in May 2009. My effort was to setup all the datafeeds and interfaces required between Confidential and all the CLECs with whom Verizon does business in the 14 acquired states. The idea of this conversion project was convert all residential and wholesale customers of Verizon communications to Frontier and also establishes the connectivity so this sale is seamless to the 3rd party carriers.

Responsibilities as Implementation Specialist:

• Requirements’ gathering for the Billing data feeds viz. Usage, BDT and MPB, which are to be exchanged between Frontier and other CLECs after acquisition of Verizon Telecom.
• Working with business and technical contacts of 3rd party CLECs and some service bureaus to finalize the billing and provisioning interface requirements.
• Configure connect direct jobs for feeds exchanged between Frontier and external carriers for Verizon migration.
• Undertook CLEC onboarding tasks such as setting connectivity for ASR, LSR and Trouble Administration, assigning file naming conventions.
• Co-ordinate the method of transfer such as NDM, FTP etc and conducting JAD sessions with technical teams of other telecom carriers to discuss solution details and finalize technical details.
• Identifying the existing carriers affected, develop contingency plans to if new data fails to be merged in the existing feeds.
• Maintaining the environments needed for conversion data, testing and development. Co-ordinate environment allocation requests across various teams
• Ensuring the conversion data is loaded properly into source system and all the master data needed are available prior to conversion.
• Identifying the existing and new feeds to be tested and supplying the test data to QA teams.

Client : Confidential

Duration : March 2006 till Feb 2010.

Position : Business Analyst / Application Support

Technologies : Oracle PL/SQL, Unix Shell Scripting, XML, XRICS, MPS, OMS, J2EE, Weblogic

Project Profile: 
In early 2006 Confidential acquired Bellsouth Communications was planning to launch its new set of Telecom Service viz. Video OnDemand, IPTV and VOIP for the US consumer market. My team tasks included Application Support of Order Management System and Billing Apps. Configuring and Troubleshooting EMBUS and Tuxedo for production and mirror environments were the daily activities.

Responsibilities as Developer and Business Analyst:

• Business Analysis and Data Modelling to migrate the Bellsouth Customer and Usage data into Amdocs Billing and CRM applications. Gathering Business requirements and performing gap analysis for every release
• Analysis of reference data which is shared by downstream applications and validating the consistency for each and every Product which is implemented in CRM, OMS and AMSS (U-Verse Customer Portal). Generating Interface Agreement Document which would be shared by all Application Developers.
• Co-ordination with Offshore development and testing teams and conducting meetings to update about the client expectations and deadlines. Resource and Time management decisions also were discussed daily and daily status reports updated to client
• Identifying the roadblocks in which could arise during deployment due to Reference data issues, code unavailability or incomplete business scenarios and reporting this status to the leadership.
• Product Modeling for U-Verse products and services and defining Line items and service attributed and mapping these according to network architechture.
• Creating Service Delivery and Service Assurance reports from GCAS and OSS applications about fault tracking.
• Studying OSS layers and the new changes to be implemented and modifying the job process and code to implement new functionality.
• Responsibilities as Application Support Analyst:
• Providing 24x7 Oncall Support for Production and Test Environments. Preparing Support Schedule that involved two teams from USA and one team from Offshore and decide action plan during outages.
• Working with Service Delivery, Assurance Managers and Operations Team Leads to gather requirements about the new reference data needed in Production for next release. Status tracking with testing teams and generating reports about the stability of the new data that would be made available.
• Creating PL/SQL packages for migrating conversion data to mirror environments and then validate data according to new product and data model.
• Identifying the Support tasks that would be needed for each release from Billing and CRM systems perspective. Tuning the SQL statements provided by development and deploying the data fix with help of ADBA after impact analysis have performed.
• Troubleshooting Order XML data issues with Enabler Pricing and Product Catalogue. Finding root cause of the order failures in Billing and investigate missing data passed from OMS or AMSS to Billing.
• Scheduling Job maps for Billing and AR processes and closely monitoring the progress incase any errors surface. Shell scripts were also developed to automate executing of routine job maps. Generating status reports after every bill run and automate these tasks.
• Configuring Tuxedo for Clarify CRM and Amdocs Ensemble for load balancing and process management. Updating Ubbconfig file to tune system parameters.
• Deploying J2EE applications on Weblogic Server on which Billing applications were hosted. Configuring Weblogic to interact with Middleware EMBUS.
• Developing Shell Scripts, PL/SQL programs to automate daily maintenance tasks. This helped in providing zero slippage of the installation deadlines. Error reporting was also automated so that the release team could act promptly in case of failure of build installation
• Creating Support Documentation and presentations to reverse shadow knowledge and functionality for forth coming releases and discuss with Development team to confirm the correct process for every release. A detailed and approved roadmap was created after these discussions for the troubleshooting tasks and workarounds for each release.
• Also performing Defect Management for the trouble tickets raised by Operations Teams and discussing the code fixes which are provided by Development and its impact on the Live Customer and Reference Data.

Client : Confidential

Duration : January 2005 till March 2006.

Position : Business Systems Analyst

Project Profile: 
Confidential has offered its telecomm service in many European countries under different names and schemes. The project involves the migration of CRM & Billing (Legacy systems) databases of different countries to a single Database to get one-view of the BT’s customer who is spanning across Europe. The new system is to be mainly responsible for Cross Border Order Management, Fault Management, Customer Inventory and e-Services. Development of PL/SQL packages for migration of the BT customers, services data and configuration data from the legacy systems to Clarify database and then migrate data from Clarify database to Billing (Geneva) database. The Report of the data migrated on Live environment was created for Operations and Business Teams.

Responsibilities as Business Systems Analyst:

• Analysis of the Fault Migration Process from Legacy systems to Clarify and Developing the PL/SQL scripts and Shell Scripts for the same.
• Writing PL/SQL code for migrating the data from the legacy systems to the ClariFy Database and from Clarify Database(CRM) to Geneva Database(Billing)
• Writing APIs to interact with provisioning and getting updates for the OSS layer faults from provisioning system and creating master cases in Clarify.
• Developing scripts for creation of commercial elements on basis of technical elements from Geneva (Billing System) Database to be inserted into Clarify (CRM System) Database.
• Writing Shell Scripts to validate and load data according to the client’s business logic from data files to the Oracle Database. SQL*Loader also used here.
• Developing and Modification of Stylesheet (XSL) and DTD files for the XMLs which are sent as blob to the Geneva Database for processing.
• Configuring Tuxedo for Clarify CRM to make it work in N Tier architecture and setting up load balancing using 1 master server and 3 slave tuxedo servers.
• Reference data validation to confirm the correctness of the associated entities in the Clarify data model created from old data of legacy systems.
• Configuration of Testing/Development/Production environments of SOE prior to Data migration.
• Execution of the scripts on Production, Development and Testing Environment for migrating the data to Clarify and Geneva.
• Report generation by executing SQL queries on Production Environment using TOAD.