Duration

Organization

Role

January *********************

CitiusTech

Sr. Software Engineer

August 2014 – January 2016

IBM India

Software Test Engineer

June 2011 – August 2014

Reliance Communications

Application Tester

CitiusTech IT Solutions Pvt Ltd, Mumbai

Project # 1

BI Clinical using Java rule engine

Project Description

BI-Clinical is a Citius proprietary product. It is basically a rule-based engine which calculates clinical data and generates reports. BI-Clinical is integrated with various EHR and hospital recording systems. Data gets churned in the engine and clinical reports are generated which are then used by physicians to submit it to the CMS and earn incentives out of it.

Software

Languages

Java8, Python

DBs/Tool

SQL Server, Netezza, Redshift, JIRA, SVN, PyCharm, Jupyter

Team Size

7 (including me)

Responsibilities

• Hands-on experience in Test Automation using Python and basic knowledge of Java.

• Creating functional tests for web project (Python: Selenium).

• Fetching records from database using Python as per the requirement.

• Highlighting project risks/regression impacts with genuine reasoning.

• Provide testing estimations; weekly test status report and daily reporting to the on-shore team.

• Develop test suites that cover testing requirements and to create test cases.

• Raising defect through JIRA and follow defect life cycle.

• Monitored, troubleshoot and aided with ETL/SSIS.

• Prepared complex SQL Join & Hive(HQL) Queries and T-SQL queries as per the requirements.

• Post production support – handling production incidents.

• Giving process and system training to new members on the team.

IBM India, Mumbai.

Project # 1

MetLife for IBM Client

Project Description

MetLife is a web-based software application, used to process and settle claims raised by registered customers. The application allows faster processing, tracking and settlement of claims. When register customers have an incident in which the product is damaged, then they lodge a claim. If the product is damaged and it can be repaired, then to verify the extent of damage and amount that can be paid, details of the incident are entered in different screens of MetLife. Once these details are entered, then the Product can be sent for repairs to authorize garages from MetLife network Database.

Software

Languages

Data warehouse using ETL

Dbs/Tool

DB2, HP ALM, SharePoint, Informatica, Citrix

Team Size

07

Responsibilities

• Conducted code and design reviews for suggesting and approval of design specifications.

• Raising defect through HP Quality Center and follow defect life cycle.

• Hands on experience in Informatica for getting the table mappings.

• Validation of data movement from the Source to the Target system.

• Verifying all the Schema Objects as per the requirements.

• Prepared complex SQL Join Queries and PL/SQL queries as per the requirements.

Reliance Communications Pvt Ltd, Mumbai.

Project # 1

CRM Upgrade

Project Description

This is Amdocs Product and this Application is completely Application based. This application is used for Postpaid and Prepaid customer details. It means whenever customers are calling to Call Center then customer’s details are automatically displayed in this application.

Project # 2

Integrated Credit Control Management (ICCM)

Project Description

ICCM is the in-house software which is used for all Postpaid issues like Billing, Activation, Deactivation, Payment, Credit limit, all postpaid related issue. You can View all postpaid services by ICCM application. By a TOAD application, we can fire query and fetch any kind of data which is related to Postpaid Billing and also check postpaid services. ICCM application is totally dependent on Database. We are handling ICCM application all over India.

Software

Languages

Java

DBs & Tools

Oracle, Tibco, Smart Client, UNIX

Team Size

11

Responsibilities

• Prepared and executed the Manual functionalities like Test Plan, Test Scenarios, Test Cases as per the requirements.

• Done the E2E execution (CRM->Tibco-> DB->Tibco->Clarity Network).

• Reviewed of SRS, CR, and Technical Design document as per Requirements.

• Bug tracking and reporting.

• Coordination with the Development team for effective issue resolution.

• Internal review of test cases.

• Daily status report.

• Preparation of documents- User Acceptance Sign Off and Traceability matrix document.

• Maintenance of the complete SDLC life cycle documents.

Address (Correspondence)

:

6 Rue Des Cordiers 06600 Antibes, Nice, France.

Address (Permanent)

:

105, 1st floor, Parijat Apt, Surya Nagar, Vithawa, Kalwa E, Thane, Maharastra, India-400605.

Gender

:

Male.

Nationality

:

Indian.

Marital status

:

Unmarried.

Date of Birth

:

*************

Languages known

:

English, Hindi, and Odia.