Experience Summary

11+ years of working experience in Analysis, Development, Implementation and Support of BSS and IT 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 3 Major Data Migration projects with full life cycle implementation.
• 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.

Educational Qualification

• Bachelors of Electrical Engineering.

Languages : PL/SQL, Perl, PHP, XML, XSD, JavaScript, C++, APL, UFDL, WSDL

Database : Oracle 11g, MS-Access, SQL Server 2000, DB2

User Interfaces : UI Editor, CBex, DD Editor, CSM Online, Wireframes, UML Diagrams, Eclipse

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

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

Middleware : Weblogic 8.1, Tibco BPM-RV, Tuxedo, SOAP, Websphere MQ

Applications : ClariFy CRM, Amdocs Billing, ADC Singl.eView, OMS, MediationZone®

Tools (3rd party) : TOAD, SQL Developer, 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

Work Experience

Confidential,Atlanta, GA
Duration : May 2012 till date
Position : Sr. Implementation Analyst/ Sr. Developer
Environment : MediationZone® from DigitalRoute, Oracle SQL Developer, RedHat Linux, Websphere MQ
Technologies : Mediation Workflows, APL, UFDL, Oracle PL/SQL 11.2, XSD, Web Services, Usage Decoders, Shell scripts, SCP, Convergys RBM, Perl (DBI, Curl, XML)

Project Profile:
Development and enhancement to MediationZone® with new market requirements; incorporate complex rules and processing for Voice, SMS, MMS, 3G and 4G Call detail records; decoding usage from various types of switches like Lucent, Nortel, Motorola, Kodiak etc. These Usage records are to be enriched with additional information by performing database lookups, apply business rules, encode and send to downstream systems for Rating/Billing and other legacy systems.

Responsibilities:

• Analyze new functionality to be implemented and creating customization requirements, High Level Solutions and Technical Design documents (TDD)
• Develop APL (Analysis Programming Language), UFDL (Ultra Format Definition Language) code to support change requests, defects and integration projects. Unit testing and help QA teams to create test data.
• Develop Mediation workflows and decoders for XML and Binary usage requests, validate usage data; create PL/SQL packages to invoke remote stored procedures on Geneva system with Usage data for billing migration.
• Create shell scripts to automate mediation workflows; perform auditing and reporting.
• Peer reviews of the code developed by fellow colleagues and suggest enhancements for better performance and coding standards
• Create Perl scripts using DBI, Curl, DBD::Oracle modules to refresh Test/Dev/Perf environments, move/copy tables across Databases, purge filesystems and clone MQ queue data.
• Develop mediation WFs and PL/SQL code to execute Convergys RBM stored procedures which would migrate Subscriber & Real-time usage data from Billing system to an intermediate ‘Just-in-Time Rating’ system ( henceforth be used to rate usage records) and send back rated usage to Billing system for invoicing.

Confidential,Rochester, NY
Duration : Dec 2011 - Apr 2012
Position : Sr. Systems Analyst/Developer – Data Migration/Conversion/Mapping
Environment : MetaSolv M6, Synchronoss VFO, DPI Billing (AS/400), Exchange Path, LSR, ASR, ESB
Technologies : Oracle 11g, PL/SQL 11.2, XSD, XML, XPath, XQuery, LSR, SOAP Web Services, WSDL, UML

Project Profile:
As a part of Frontier’s deal to acquire Verizon’s regional wireline assets for 14 states, my effort was to perform requirements gathering, analysis and development to migrate all the inflight ISP Orders from Verizon systems to Legacy frontier systems for downstream provisioning by Synchronoss VFO and DPI Billing.

Responsibilities:

• Requirements gathering to migrate all type of ISP Orders (LSR) from Verizon provisioning systems to Frontier’s Legacy systems. Create technical system design document and architecture diagrams for conversion process.
• Working with business and technical contacts of source systems and understand the key tables and fields to create filter criteria for migration.
• Create source to target system field mapping specifications and gather business rules for data validation, filtering and inconsistencies. Create UML diagrams to depict conversion process flow. Create shell scripts for data mapping, conversion and report generation.
• Gather stage reporting requirements from business and identify the changes to existing conversion reports.
• Create staging tables, PL/SQL packages, XSD schema in Oracle database, incorporate master data and business logic in reference tables to validate, map and extract data from source system and load into staging database.
• Develop PL/SQL package to read data from staging tables, perform data mapping, create XML blobs and send to Synchronoss VFO web service (referencing from WSDL) using SOAP call.
• Support business users testing in MOCK and Production. Resolving defects during conversion.

Confidential,Chicago, IL
Duration : Aug 2011 - Nov 2011
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, J2EE

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.

Responsibilities:

• Finalize Business Requirements (BRD) from Sales, Retail, Customer Care and Marketing stakeholders for U Prepaid product.
• Create Functional and System Requirements (FSD, PRD) to implement U Prepaid line Activations in Amdocs Billing, Oracle Service Bus, IVR and Product/Service Catalog.
• Assess As-Is systems flow and Create To-Be flow for activations using UML, support activities and financial transactions between USCC and external vendors and reconciliation processes with 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 for reverse engineering and reverse logistics for faulty devices and shipment returns between Walmart and Warehouse. Also getting the appropriate information into SAP inventory from OEM manufacturers and distributors.
• Assess INCOMM capabilities for U Prepaid replenishment cards and create requirements for funds redemption via web and IVR channels.
• Create Requirements Traceability Matrix from Discovery to deployment phase and track change requests that arise in middle of SDLC.

Confidential,Seattle, WA
Duration : Aug 2010 - Aug 2011
Position : Sr. Billing Systems Analyst
Environment : Amdocs CES 8.5, Enterprise Product Catalog, Quickview Universal UI, Tibco BPM
Technologies : Amdocs Ensemble, CSM Online, Tuxedo, SOA, WSDL, EPC, J2EE, C++, Agile

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.

Responsibilities:

• Gather Business Requirements (BRD) from Retail and CC&B stakeholders for new BSS processes to-be implemented in Amdocs CES 8.5 and EPC.
• Create Functional, Technical Requirements, Proof of Concept (FSD, POC) to accommodate Postpaid and Prepaid line Activations to be implemented in Amdocs Billing and Enterprise Product Catalog.
• Conduct JAD and Discovery sessions to finalize the Billing system design, scoping of functionality to be implemented per sprint and design changes needed in Middleware services for Billing and Retail systems. Identify, evaluate the impact of new requirements on an existing suite of J2EE applications and develop billing systems procedures that meet business requirements.
• 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 using UML.
• Participate in wireframe 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 RTM throughout SDLC.
• Work with Reseller 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.

Confidential,Rochester, NY
Duration : March 2010 - July 2010
Position : Implementation – Telecom Interfaces with external carriers (Verizon Telecom acquisition)
Environment : DPI Billing (AS/400), Payment Gateway, CDG CABS billing
Technologies : Solaris, JCL, NDM, Shell Scripting, OS/390, EMI and CDR record format (Usage)

Project Profile:
Frontier 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 Frontier 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:

• Requirements’ gathering (FSD, BRD) 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, method of transfer such as NDM, FTP.
• Requirement analysis and configuration of connect direct jobs for feeds exchanged between Frontier and external carriers for Verizon telecom acquistion.
• Undertook CLEC onboarding tasks such as setting connectivity for ASR, LSR and Trouble Ticket Administration using Exchange Path, UOM Web interface and EDI, assigning file naming conventions.
• 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