Alkesh Rathod

Location : Evanston, IL *****

Mobile : 847-***-****

Home : 847-***-****

Email : xfooc9@r.postjobfree.com

Experience Summary

 7 years of working experience in Analysis, Development, Implementation & Support of BSS Applications in Telecom Industry.

o Implementation of various Interfaces across Telecom Service providers

o Production Support for Amdocs Clarify CRM and Billing Applications

o Completed 2 Major Data Migration projects with full life cycle implementation.

o Configuring the Middleware like Tuxedo and EMBUS for process communication with Amdocs systems.

o Processing of Live CDR and Data Usage files and designing file operation process for MPS and Mediation.

o Product modeling expertise for Voice and Data Products for Wireline and Wireless services.

o Testing planning and QA Analysis for Amdocs Billing and CRM applications.

o Implementing Process improvements for Order Processing in AT&T’s billing and Middleware systems.

o Release Management and Configuration of Amdocs Billing and Clarify CRM for Production and Test environments.

o Communication with key managers and framing Business and technical requirements in accordance with SLAs.

o Resource and Time management with regards to handing multiple projects and resources in Onsite - Offshore model.

 Strong experience in RDBMS like Oracle and Reporting tools.

Educational Qualification

 Bachelors of Electrical Engineering. Graduated in 2001-2002, Mumbai University

Technical skills

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

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

User Interfaces : UI Editor, CBex, DD Editor.

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, BEA Tuxedo 7.1

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

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

Microsoft : MS Excel, Powerpoint, Visio

Work Experience

Client : Frontier Communications (formerly known as Citizens Communications)

Duration : March 2010 till date.

Position : Implementation – Telecom Interfaces with external carriers

Environment : DPI (Telecom Billing), Payment Gateway, CDG CABS billing

Technologies : Unix, JCL, NDM, Shell Scripting, OS/390, EMI record format

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 is to migrate all residential and wholesale customers of Verizon communications to Frontier and also establish the connectivity so this sale is seamless to the 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 the acquisition.

 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.

 Undertrook CLEC onboarding tasks such as setting connectivity for ASR, LSR and Trouble Administration, assigning filenaming 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 : AT&T Services Inc

Duration : March 2006 till Feb 2010.

Position : Business Analyst / Application Support

Environment : Amdocs Billing, Mediation, MPS, Clarify CRM, Amdocs OMS, AMSS

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

Project Profile:

In early 2006 AT&T 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 : British Telecommunications Plc

Duration : January 2005 till March 2006.

Position : Business Systems Analyst

Environment : ClariFy CRM, Solaris 5.0, Oracle 9i, PL/SQL programming, XML, XSLT.

Project Profile:

BT 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.

Client : Reliance Communications Ltd (www.relianceada.com)

Duration : June 2002 to January 2005.

Position : Tech/Team lead – Enterprise Operations

Environment : ClariFy CRM, Solaris 5.0, Oracle 8i, Tuxedo, Weblogic, MS Access, Singl.eView, J2EE

Project Profile:

Reliance Communications was a new telecom company that planned to launch Wireless and Wireline services. I was working in team responsible for customizing applications for Enterprise customers. Initial kick off included cases studies of various CRM and Billing applications available by vendors and suggesting the best system to be selected for Reliance. After that, implementation and customization of these systems was performed.

Responsibilities as Team Lead:

 Design & Development on Clarify CRM, setting up clarify environment in N – tier. Configuring Tibco adapters for establishing communications between Billing and CRM apps.

 PL/SQL coding on Clarify Data Model to develop stored procedures for enhancing reporting process for Service & Revenue Assurance teams.

 Reconciliation process with our provisioning system - ClariTy for TT creation.

 Analysis and Testing for the MACD Process for Broadband Products from Clarify (CRM) to ADC(Billing) and ClariTy (Provisioning).

 Database configuration and schema design for Various Broadband Products like POTS, ISDN, PBX, Leased Line, TLAN and IPVPN.

 Training the team members from time to time about the new processes implemented.

 Coordinating with various Teams for Code review, Unit Testing and Integrated Testing.

 Involved in design and development of Clarify application for customer care, Sales and order Automation and integrating Clarify with other Systems

 Release Management using Rational Clearcase and code versioning in Clearquest

 Developing Clarify APIs to interact with Singl.eView and OMS in J2EE

 Configuring Tuxedo for Clarify CRM to achieve load balancing and process management.

 Maintaining the Interface Agreement Documents which baseline the reference data between all the enterprise applications.

 Developing Service Assurance and Ordering Portal in Vb.Net with SQL Server backend and writing APIs to interact with Clarify CRM and ClariTy to pull status reports for Faults and Service Order status.

 Reconciliation process with service Assurance and provisioning by creating daily MS Access reports and mapping them for FDA validation

Contact this candidate