Client: Fidelity International

Client: Bharti Airtel Ltd.Project Name: Airtel Butterfly (CRM Implementation)Bharti Airtel Limited (commonly shortened to Airtel) is an Indian global telecommunications services company based in New Delhi, India. Airtel kicked off the Butterfly Transformation Project in India in 2016, with the objective to transform its post-paid business through the implementation of a new IT solution for the post-paid products – CRM, Billing, OM, EPC and Inventory starting with mobility line of business.Understood Data Migration Strategy and involved in Data Modelling to flow data from legacy Oracle iCRM to target system Siebel CRM.Captured the Business rules for validating and transforming data as per target system.Written Data migration scripts for processes like Validation, Transformation and Source to Target Reconciliation using SQL queries and PL/SQL language elements like Tables, Cursors, functions, Procedures, Packages, triggers to process huge volumes of data.PL/SQL Code Development and Unit testing.Written Shell scripts in UNIX for triggering and monitoring PL/SQL scripts and Java/Python code for handling data.Involved in SQL query Optimization and Performance Tuning activities for improving code performance.Tools/Platforms : Oracle Database11g, SQL Developer, TOAD, Java, SQL, PL/SQL, SQL*PLUS, SQL*LOADER, UNIX

Client: NBN Co LimitedProject Name: NBN Gemini IntegrationNBN Co Limited (trading as nbn) is an Australian government-owned corporation tasked to design,build and operate Australia's National Broadband Network as a monopoly wholesale broadband provider.Responsibility:Trained in Comptel SRI (Service and Resource Inventory) Tool and BST (Business Service Tool).Involved in Comptel SRI Code development mainly using Core Java and Comptel specific API's provided.Responsible for understanding the design document and other Comptel related manuals, gathering new requirements, and business rules.Tools/Platforms : Java- J2SE, Eclipse IDE, Git version control, Apache Maven, Enterprise Architect, Unix, Comptel SRI, Comptel BST, SOAP UI.