Telecommunications Business & Operation Support Systems (BSS/OSS) framework is a fast paced changing platform driven by the technology for delivering Voice, Data, Internet & ICT services on a singular technology platform. Aided by market competition, deregulations, bundling and un-bundling of service portfolios to streamline with niche markets are a part of the on-going cycles for Telco’s. This, in addition to the increasing need for customer retention warrants reduced lead-Times in service enablement and tighter integration between the BSS and OSS. The constant flux in business scenarios caused by communications technology advancement, product offerings and customer service processes also make imperative, the need for in-built flexibility within the deployed BSS/OSS solution.

HTCL envisions to transform into digital and lifestyle service provider serving customers across Hong Kong. To fulfil its vision HTCL is embarking on journey of organization wide digital transformation. As part of its journey, HTCL issued RFP for digital transformation of its software components to which TechM is replying as one of the vendors.

Data migration has been proposed in big bang/One time (Phase 1) and phased manner for phase II & III where based on identified migration approach and execution method, several activities are scoped and executed to ensure successful migration.

Data analysis is the first and major activity which involves Identification of DQ issues, determine criteria and scope of qualified and unqualified subscribers for migration. In phase 1, all subscribers from Mobile online(MO) brand are considered for migration, in later stages which can be treated as Phase 2 and Phase 3,migration of the subscribers of the remaining on-demand and postpaid subscribers. Phase II & III will be performed in chunks, and this would ensure the business continuity without any major impact. The target systems will be updated with static data followed by balance updates in all phases. Reconciliation activities will be performed on source and target system to certify the completeness and successful migration.

Project: Data Transformation/migration from Oracle CRM to SFDC/Velocity CRM,Matrixx charging and Comviva billing application.

Role as a Data Migration Tech Lead

Responsibilities-

1. Understand the Source System DB level and current functionality
2. BRD and LLD reading for Identification of Functional rules
3. Prepare source and target systems field mapping with customer
4. Perform data analysis on existing legacy system
   1. Mandatory data fields that are required in target systems but missing or null in source
   2. Data type mismatch & Data length mismatch
   3. Referential integrity checks in source tables
   4. Record Duplication checks based upon identified data validation rules
   5. Runs data quality rules to identify data quality issues
   6. Runs Data selection & Exclusion rules
   7. Inter system issues
5. Identification of rules and Discussion with Client
6. Preparing the Mapping sheet for Transformation Source to Target (Source and Target System level filed analysis) to Identification of technical rules
7. Rule Master maintenance
8. Rule SQL writing
9. Development of PL/SQL procedure and package changes as per requirement in UDMF tool code.
10. Preparing the Data Quality (DQ) report and DQ report analysis.
11. PL/SQL Coding for Transformation from Source to EIM table and EIM to table UDMF table
12. Developed code using various procedure,views, package spec. &Package body.
13. Performance tunning of SQL’s for better performance.

Telecommunications Business & Operation Support Systems (BSS/OSS) framework is a fast paced changing platform driven by the technology for delivering Voice, Data, Internet & ICT services on a singular technology platform. Aided by market competition, deregulations, bundling and un-bundling of service portfolios to streamline with niche markets are a part of the on-going cycles for Telcos. This, in addition to the increasing need for customer retention warrants reduced lead-Times in service enablement and tighter integration between the BSS and OSS. The constant flux in business scenarios caused by communications technology advancement, product offerings and customer service processes also make imperative, the need for in-built flexibility within the deployed BSS/OSS solution. HTCL envisions to transform into digital and lifestyle service provider serving customers across Hong Kong. To fulfil its vision HTCL is embarking on journey of organization wide digital transformation. As part of its journey, HTCL issued RFP for digital transformation of its software components to which TechM is replying as one of the vendors. Data migration has been proposed in big bang/One time (Phase 1) and phased manner for phase II & III where based on identified migration approach and execution method, several activities are scoped and executed to ensure successful migration. Data analysis is the first and major activity which involves Identification of DQ issues, determine criteria and scope of qualified and unqualified subscribers for migration. In phase 1, all subscribers from Mobile online(MO) brand are considered for migration, in later stages which can be treated as Phase 2 and Phase 3,migration of the subscribers of the remaining on-demand and postpaid subscribers. Phase II & III will be performed in chunks, and this would ensure the business continuity without any major impact. The target systems will be updated with static data followed by balance updates in all phases. Reconciliation activities will be performed on source and target system to certify the completeness and successful migration.

VNM is one of the largest mobile network operator in Vietnam with a revenue of ₹23 billion having 8 million customers. It offers both prepaid GSM cellular phone coverage throughout Vietnam with better presence in the metros.

Project: Data Transformation/migration from Oracle CRM to Siebel CRM application

Role as a Data Migration Tech Lead

Responsibilities-

1. Understand the Source System DB level and current functionality
2. BRD and LLD reading for Identification of Functional rules
3. Perform data analysis on existing legacy system
   1. Mandatory data fields that are required in target systems but missing or null in source
   2. Data type mismatch & Data length mismatch
   3. Referential integrity checks in source tables
   4. Record Duplication checks based upon identified data validation rules
   5. Runs data quality rules to identify data quality issues
   6. Runs Data selection & Exclusion rules
   7. Inter system issues
4. Identification of rules and Discussion with Client
5. Preparing the Mapping sheet for Transformation Source to Target (Source and Target System level filed analysis) to Identification of technical rules
6. Rule Master maintenance
7. Rule SQL writing
8. Development of PL/SQL procedure and package changes as per requirement in UDMF tool code.
9. Preparing the Data Quality (DQ) report and DQ report analysis.
10. PL/SQL Coding for Transformation from Source to EIM table and EIM to table Siebel table
11. Developed code using various procedure,views, package spec. &Package body.
12. Performance tunning of SQL’s for better performance.

VNM is one of the largest mobile network operator in Vietnam with a revenue of 23 billion having 8 million customers. It offers both prepaid GSM cellular phone coverage throughout Vietnam with better presence in the metros.

Vodafone India is one of the largest mobile network operator in India with a revenue of ₹425 billion having 185 million customers. It offers both prepaid and postpaid GSM cellular phone coverage throughout India with better presence in the metros.

Project: Data Transformation/migration from Oracle CRM to Siebel CRM application

Role as a Tech Lead

Responsibilities-

1. Understand the Source System DB level and current functionality
2. BRD and LLD reading for Identification of Functional rules
3. Perform data analysis on existing legacy system
   1. Mandatory data fields that are required in target systems but missing or null in source
   2. Data type mismatch & Data length mismatch
   3. Referential integrity checks in source tables
   4. Record Duplication checks based upon identified data validation rules
   5. Runs data quality rules to identify data quality issues
   6. Runs Data selection & Exclusion rules
   7. Inter system issues
4. Identification of rules and Discussion with Client
5. Preparing the Mapping sheet for Transformation Source to Target (Source and Target System level filed analysis) to Identification of technical rules
6. Rule Master maintenance
7. Rule SQL writing
8. PL/SQL procedure and package changes as per requirement in UDMF tool code.
9. Preparing the Data Quality (DQ) report and DQ report analysis.
10. PL/SQL Coding for Transformation from Source to EIM table and EIM to table Siebel table
11. Developed code using various procedure,views, package spec. &Package body.
12. Performance tunning of SQL’s for better performance.

Worked in the role of a senior developer and Team Leader (technical Support) in EBZ Online Pvt. Ltd, an ISO 9000-9001 company into web application development for Banks. Here he maintained and enhanced the client’s banking module built on the banking software Bank EasyÔ. The banking module had achieved total automation across all the 400 branches of the co-operative bank in the state of Maharashtra in India. The solution was developed on Oracle and D2K 6i to manage over 400 branches. Mahesh developed modules that calculated interests on investment vehicles like recurring deposits, saving deposit and agricultural loans. He further worked on other banking functionalities that involved areas pertaining to tax- calculation, statement-creation and security and audit trail set-ups. His responsibilities included

Role & Responsibilities – Sr. Developer

• Requirement gathering at the very outset for various enhancements and product customization
• Developing solutions through D2K forms, PL-SQL procedures and packages as per various requirements.
• End to End ownership of solution development from documentation ,unit test case creation , coding to testing
• Participating in Quality Assurance tests for several new modules.
• Participating in data conversion using SQL loader, export & import of databases.
• Creating and managing database Instances,
• Installing Oracle 8i on Linux Red Hat 9, Windows 2000 and Windows NT Server and creating necessary database back-up scripts
• Configuring the database for the banking module “Bank Easy” on Oracle 8i
• Providing on-call and on-site support to client.

Environment: Oracle 9i, Oracle Forms and Reports 6i, PL/SQ Developer, CVS