Lipika Ratra

  • Delhi 110055

Business Analyst


Accomplished and enthusiastic professional, possessing a proven business analyst ability in telecom BSS and database management, willing  to  contribute  to  a company  at  both  functional  and  strategic  level.

Work History

Work History
Nov 2013 - Present

Business Analyst

Global Logic

Skills & Achievements

  • Comprehensive understanding of overall Telecom domain (Functional) and interconnect business. 
    • Involved in Demo and UAT for client.
    • Implementation (Pricing/ Billing) of the complete life cycle for the various telecom clients.
    • Collecting, analyzing and understanding different business requirements, for various telecom client
    • Bridging the gap of understanding between Client and development team with continual follow-up till closure.
  • A confident and concise communicator, with well-developed presentation skills.
    • Strong team-player and a quick learner.

    Project Synopsis 

    PROJECT Telarix-iXLink (BR)

    Description: iXlink is a B2B information exchange platform which enables CSPs to use their own pricing and invoicing documents for various vendors.

    Duration: Jan 2015 – till date

    Responsibilities & Key Accomplishments:

    • Business domain and solutions knowledge of Telecom sector.
    • Collecting and Understanding clients business needs and providing optimal solution.
    • Communicated with the clients and project managers and served as first point of contact for information to the clients.
    • Automated the process of converting various different invoicing to one expected format. Worked on tools like OCR and BCS for the same.
    • Front-ended the Bill Receipt on-boarding and configuration of various telecom partners like Skype, ATT etc.
    • Monitored smooth Bill generation at the end of transaction, so as to keep up with the SLA. Maintained 98% of success rate.
    • Used to run procedures and jobs on database to extract requested information for a client for audit purposes.
    • Performing root cause analysis at database level for any data discrepancy at front end.
    • Established and trained a subordinate.

     Techniques used: iXlink BCS, various OCR tools, VB Macros, MS Excel (formulas and pivot tables) and MS SQL 2008.

    PROJECT Telarix-iXLink/iXConnect (PLR)

    Description: Telarix is a US-based vendor of Business Support System (BSS), such as interconnect settlement and least-cost routing to global telecom market. iXlink is a B2B information exchange platform which enables CSPs to use  their  own  pricing  and  invoicing  documents  for  various  vendors.  iXConnect provides  central  point  of management for CSPs interconnect business.

    Duration: Oct 2013- Dec 2014

    Responsibilities & Key Accomplishments:

    • Gathering and analyzing the new business requirements of various clients, suggesting the solutions, and implementing the system as per their need
    • Freezing and documenting the client needs, and exchanging the understanding with Development team.
    • Front-ended the Price List onboarding and maintenance of various APAC telecom partners like Airtel, Citic, Vodafone, et
    • Extracting and analyzing various reports from back end.
    • Arranging and providing training's to new onboarding clients.

     Techniques used: iXlink tools, MS Office, VB Macros, MS Excel (formulas and pivot tables) and MS SQL 2008.

    PROJECT Telarix-IDC (Interactive Data Corporation)

    Description: It is a big data framework to store big data in hadoop ecosystem from different data
    sources and represent data in tabular and graphical form for data analytics.

    Duration: Jul 2013- Oct 2013 (POC)

    Responsibilities & Key Accomplishments:

    • Data extraction from RDBMS to HDFS using Sqoop.
    • KPI development using HQL(HIVE Query Language).
    • Performance analysis with parameter tuning.
    • Published KPI results.


    Description: Worked as a trainee in Acme Cleantech Ltd on a project titled Complaint Management System using .net.
    Duration: Jan 2013 to April 2013 (Internship)
    Technologies Used: ASP .Net, C#, SQL Server 2005
    Roles & Responsibilities: Worked on UI and user controls. 


    Aug 2010 - Aug 2013


    GGS Indraprastha University


    Jul 2006 - Jul 2010

    B.Sc(H) Computer Science

    Delhi University


    Apr 2005 - May 2006

    Class XIIth

    N.C. Jindal Public School


    Apr 2003 - May 2004

    CBSE Xth

    N.C. Jindal Public School


    Personal Details

    Date of Birth: 26 Oct, 1988

    Gender: Female

    Hobbies: Travelling, Reading & collecting quotes

    Marital Status: Married