Soma_Mishra_Resume
- 1. SOMA MISHRA Mobile: 09986645306 ~ E-Mail: soma.mishra.02@gmail.com Technocrat with expertise in Solution & Technical Architecture and Business Analysis S K I L L S E T k i l l s s e t System Configuration Solution Designing Software Analysis Requirement Gathering Maintenance Support Solution & Technical Architecture Business Analysis Unit Testing / UAT Product Development Team Management Client Relationship P R O F I L E S U M M A R Y F I L E S U M M A R Y Over 9 years of experience in Software Analysis Experienced in complete SDLC including requirement gathering & analysis, designing, testing, maintenance and support using PL/SQL and Oracle Forms & Reports Proficient in creation of documents like test plans, schedules, release notes and defect tracking reports Skilled in working on Comptel Eventlink 6.2, PERL, Shell Scripting, C, UNIX, SQL/PLSQL, C++; providing end-to-end solution for Roaming Management and handling telecom mediation system Recipient of Performance Award of the Month, thrice at Mobily Infotech Abilities in mapping the requirements, custom designing solutions & troubleshooting complex software & application problems Capable of leading & motivating individuals to maximise levels of productivity A team player with strong communication, analytical, logical and problem-solving skills C O R E C O M P E T E N C I E S Mapping requirements & providing them best solutions involving evaluation and definition of scope of project and finalisation of project requirements Analysing the user needs and software requirements to determine feasibility of design within time and cost constraints. Consulting with customers about software system design and maintenance Ensuring adherence to quality norms throughout the implementation process Identifying, analysing defects, questionable functions, errors, and inconsistencies in software program functions, outputs and content Conducting system study and coordinating with team members for product documentation, system design & integration, coding, application maintenance, etc. O R G A N I S A T I O N A L E X P E R I E N C E Since Nov07: Mobily Infotech (Sister Concern of Etisalat), Bangalore as Senior Software Analyst Key Result Areas Designing, planning and implementing Roaming Management System (NRTRDE and TAP functionalities) in COMPTEL Eventlink Tool Working on Effectuating SHELL, C, PL/SQL, PERL scripting in UNIX OS Competencies
- 2. Performing Unit Testing and co-ordinating with marketing people for User Acceptance. Highlights Certified in COMPTEL Roaming Management System and rater from COMPTEL, Finland. Recognised as consistent high performer Recipient of employee of the month for Oct 2009 and March 2010 Nov05-Nov07: Wipro Technologies, Bangalore as Software Engineer Key Result Areas Accountable for: o Coding and implementation of collection and transferring files in SDM and CBM switches of Nortel o Coding and implementation of CIS (Call Intercept Subsystem) to make the CBM operate as client o Unit testing and support for User Acceptance o Implementation using POSIX threads, C++ in UNIX OS T E C H N I C A L S K I L L S Technologies/Telco BSS: COMPTEL Eventlink Mediation 6.2 Programming Languages: C, C++, Shell, AWK, SED, SQL/PLSQL, PERL Scripting Operating Systems: Sun Solaris (UNIX), Windows- XP Protocol Knowledge: TCP/IP Other Tools: TOAD, SQL Developer, Clear-Case, Oracle 9i/10g A C A D E M I C D E T A I L S 2005 MCA from Utkal University with 88.5% (Gold Medallist) 2001 B.Sc. (Physics) from Sambalpur University with 76.5% Certifications & Training Oracle 9i Comptel Eventlink6.2 Comptel Rater Comptel Balance Management Tool Comptel Roaming management System P E R S O N A L D E T A I L S Date of Birth: 23 rd February 1981 Passport No F4783437 Location Preference: Bangalore
- 3. Industry Preference: Telecom ~ Please refer to annexure for projects ~ A N N E X U R E At Mobily Infotech Project Name: Roaming Management System Duration: January 2011 till date
- 4. Client: Mobily Infotech India Pvt Ltd. Solution Environment: HP UNIX, Perl/Shell Scripting, Comptel Mediation EL6 Project Description: The project involves the implementation of the TAP and NRTRDE functionalities to process the roaming CDR using the COMPTEL Event link tool. It is the end to end solution for roaming involving parsing, validating and sending the CDR to the different NRTRDE and TAP operators. The implementation involves the both the inbound and outbound roaming data processing. In case of inbound customers (VPMN customers roaming in HPMN), the TAP and NRTRDE files are created and sent after processing the roaming CDR. In case of outbound customers ( HPMN customers roaming in VPMN) , the TAP and NRTRDE files are received and validated and accordingly the RAP or NRTRDE error report as well as the NRTRDE delivery reports are sent. The files are sent to the EDCH which then delivers them to different operators. The files are received as well as sent through the SFTP connection. The summary for the complete process is stored in various DB tables from where the reports are shown in the portal. Team Size: 2 Responsibilities Designing and developing new process streams to provide complete roaming management solution using Comptel Eventlink Unit Testing of the code. Implementing necessary security standards in the coding. Preparation of Low level design document. Release management and Production support. Deployment and support to maintenance team. Project Name: Offline Mediation system Duration: January 2011 till date Client: Mobily Infotech India Pvt Ltd Solution Environment: HP UNIX, Perl/Shell Scripting, Comptel Mediation EL6 Project Description: The project provides the end to end mediation solution. The implementation is done in the COMPTEL Event link. The process involves collection, parsing (decoding), applying the various validations that is business rules, enrichment, correlation, aggregation, encoding in the downstream understandable format and then distributing to various downstream systems. The summary for the complete process is stored in various DB tables from where the reports are shown in the portal. Team Size: 6 Responsibilities Designing and developing new process streams to provide complete offline mediation solution using Comptel Eventlink Unit Testing of the code. Implementing necessary security standards in the coding. Preparation of Low level design document. Release management and Production support. Deployment and support to maintenance team. Project Name: CDF Development (Billing Mediation) Duration: April 2008 Dec 20111 Client: Mobily Infotech India Pvt Ltd Languages: C, Pro C, Shell, AWk Scripting, SQL/PLSQL Solution Environment: SUN SOLARIS (UNIX) Project Description: In CDF Online Processing System, AMA (Automatic Message Accounting) data is retrieved from the exchanges to the billing machines through the Network Protocols and is processed and converted to a Common Data Format (CDF) file, which is processed for charging and account assignment. Team Size: 6
- 5. Responsibilities Designing and developing the CDR processing system Unit Testing of the code. Implementing necessary security standards in the coding. Preparation of Low level design document. Release management and Production support. Deployment and support to maintenance team. Project Name: NRTRDE System Duration: Nov 2008 Mar 2009 Client: Mobily Infotech India Pvt Ltd Languages: C, PRO C, ocilib, xmllib, SQL/PLSQL Solution Environment: SUN SOLARIS (UNIX) Project Description: NRTRDE system is responsible for sending the roaming call details to the HPMN (home public mobile network) by the VPMN (visitor public mobile network to reduce fraud. Initially the records were shared between operators within 36 hrs due to which some of the frauds went undetectable. In order to minimize the fraud, now the records are shared between operators within 4 hours. Three types of reports are shared between operators. One is NRTRDE formatted file having all the roaming call details which the customer of the operator to which the file is sent makes in the network of the operator who sends the file. The other two are delivery report confirming that the file has reached the desired destination operator and the error report which will have the details of the errors found in the received file. The error code and error types are all standardized. Team Size: 2 Responsibilities Designing and developing the NRTRDE system Unit Testing of the code. Implementing necessary security standards in the coding. Preparation of Low level design document. Release management and Production support. Deployment and support to maintenance team. Project Name: Mediation Billing reconciliation systems Duration: Aug 2008 Oct 2008 Client: Mobily Infotech India Pvt Ltd Languages: Proc Solution Environment: SUN SOLARIS (UNIX) Project Description: The system developed is meant to reconcile the files sent to different systems from the mediation system. This is to ensure that the files that are sent to different systems are getting successfully processed at their end as well. This is required for the RA (Revenue assurance) team. The reconciliation was done for the files sent to the billing system which gets the files from the mediation system after it is processed as well as the EMM system which gets the files for processing from the switch. Team Size: 1 Responsibilities Designing and developing the mediation billing reconciliation system Unit Testing of the code. Implementing necessary security standards in the coding. Preparation of Low level design document. Release management and Production support.
- 6. Deployment and support to maintenance team Project Name: Loading System Development Duration: May 2008 July 2008 Client: Mobily Infotech India Pvt Ltd Language: C, Proc, Shell, AWK Scripting, SQL/PLSQL Solution Environment: SUN SOLARIS (UNIX), Project Description: This system is responsible for loading the CDF files to the DB using the sqlldr. The system is so developed that it gets the file name and paths from the database and then load into the destination table termed as the data table. Using this single system we can load data from different exchanges to different tables in different databases as per need. Team Size: 1 Responsibilities Designing and developing the loading system Unit Testing of the code. Implementing necessary security standards in the coding. Preparation of Low level design document. Release management and Production support. Deployment and support to maintenance team. Project Name: MEM Development Duration: Nov 2007 March 2008 Client: Mobily Infotech India Pvt Ltd Languages: C, IPC, Shell, AWk Scripting,SQL/PLSQL Solution Environment: SUN SOLARIS (UNIX), Project Description: The Mobily Event Mediator (MEM) is an Event Processing System applies various file level, field level configurable business logics based validations on the event records. All the file level, field level and business rules are user configurable. The Mobily Event Mediator Event Processing System is composed of different components, some of them are related to the Record Reading, record and field validation, some for Applying Business Rules, and others will be related to produce output file functionality. The main purpose of the Mobily Event Mediator Event Processing System development is to allow the user to configure rules dynamically, easy to use web user interface, efficiency and the high speed processing of input CDR files. As a specialist, I was a part of product design as well as developing. Team Size: 5 Responsibilities Designing and developing two modules ,the main parent process to control all the different modules by using multithreading as well as the file validation module which validates the batches (files) based on some configurable file validation rules Unit Testing of the code. Implementing necessary security standards in the coding. Preparation of Low level design document. Release management and Production support. Deployment and support to maintenance team. At Wipro Technologies, Bangalore Project Name: SDM OMDD enhancement and robustness Duration: May 2007 Nov 2007
- 7. Client: NORTEL Project Description: OMDD is application of SDM(supernode data manager) product which takes care of collecting the operation measurement reports from the switch and through the SDM sends to the downstream OSS which is the destination where the reports are getting collected. This feature was an enhancement of the application to introduce the FTP retries mechanism in case the FTP fails at the first attempt. This feature also introduced the audit of the application to happen at every 12 hours which will check whether the size of the directory in which the OM reports are getting collected in the SDM is not exceeding the stipulated size. This feature activity involved managing the multiple threads of FTP created during the file transfer from SDM to the destination. This feature was mainly done for the wireline market. Team Size: 3 Language: C++ Protocol: TCP/IP, FTP Solution Environment: Sun Solaris Project Title: CBM TCP Client for LI Duration: Jan 2007- May 2007 Client: NORTEL Project Description: This feature modified the existing CIS (Call Intercept Subsystem) application for CALEA to make the CBM operate as client when connecting to the CDDF (Call Data Delivery Function). Within the Cingular local area network, various IP issues can cause the CNR delivery links to go out of service. These outages can range from firewalls tearing down inactive TCP/IP sessions, software updates to IP nodes or network restructuring. Each time this connection is interrupted it requires that manual intervention be performed on the Client node to re-establish the IP Socket/connection. Manual intervention is required since the CDDF does not know when the link went down so that if can reinitiate the connection automatically. The provisioning for the call intercept is done through the INI1 interface while the delivery can be done through the CALEA CNR delivery application over these connections. The records that are sent to the client processes are the call notification records or CNRs. This feature allows the CIS application to act as a client. Therefore, the LI application is responsible to setup and maintain the CALEA CNR delivery connections to the mediation system. Thus, this feature provides consistent connection setup and recovery behavior across networks alleviating possible prolonged connectivity outages Team Size: 3 Solution Environment: Sun Solaris Languages: C++ Project Title: RCS to clearcase Migration Activity Duration: May 2006- Dec 2006 Client: NORTEL Project Description: This feature work was intended to migrate the code of the Wireless source code which was residing in the RCS server to the Clearcase server where the source code for the Wireline project resides. This activity included around 200 makefile changes and shell scripting to change the scripts working in the RCS to compile and build in the clearcase environment. The activity was done for seven releases of Wireless market. Team Size: 2 Solution Environment: Sun Solaris Languages: C++, Shell Scripting