Abhishek Mishra

Experience

• 

  Design A Website

  Sept 2008 - Feb 2011

  Software Developer

  Software Developer for Design A Website, India – it was my role to planning and design B2B website, E commerce website and online shopping cart and product catalogue 1 Designing of new Website2. Designing of new APIs3 Member of the development team tasked with the expansion of the Database4 Actively involved in the Design phase of the development; Responsible for both the creation of logical design.5 Reviewed data access controls and provided recommendations in improving the security.6 Search engine optimization Show less

• 

  Vcare Corporation

  Mar 2011 - now

  Developing Operation support system (OSS) and Billing software system(BSS) for Vcare – My role was to design support & billing software for USA based MVNO. The role saw full SDLC starting from Scoping, Design, Preparing test cases, Implementation, Production deployment. The product was unique as DB was in cloud for Operation support and Billing software. Making API for Verizon, Sprint, AT&T and Tmobile for Provision phone, Not Provision phone, Activate subscriber, Deactivate subscriber, Suspend subscriber etc1. Designing of Operation support and Billing software( Lifeline and non lifeline) for different MVNO2. Designing of APIs for carrier like Verizon, Sprint, AT&T and Tmobile.3. Provide training to Team members4. Interacting with Client for closure of gaps, future planning5. Stabilization and performance improvement of the system • Creating and modifying the PL and SQL procedure, function according to the business requirement.• Involved in data modelling for the application and created ER diagram.• Database Objects like Tables, Stored Procedures, packages, Cursor, Views, Triggers and functions for this project.• Wrote and modified Oracle PL and SQL, SQL statements procedures and functions that are called in the Java Scripts, PHP and Python.• Created and used XML for data management and transmission.• Involved in analysis, design, coding and Testing.• Involved in creating Database Design (Physical and logical) as per the requirement given by business.• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database. Show less

  • OCS (VOICE,TEXT,DATA), OSS/BSS Solution Architect

    Mar 2011 - now

  • tech lead

    Mar 2011 - now