JANARTHANAN ALWARRAMANUJAM. [pic][pic]
Contact Information:
( E-Mail Id. : *********@*****.***
( Phone No. : 91-982*******
Summary of Professional Experience
. Having 10+ years of total experience in Software Industry, inclusive
of Software Testing (Quality), Software Development, Project
management and Networking.
. International Software Testing Qualifications Board (ISTQB) Certified
Professional.
. Involved in Planning, Designing and Testing of the Windows based
application.
. Having good exposure to end-to-end Software Testing Life Cycle in
windows Based architectures.
. Domain Experience on Banking, Healthcare, Pharma, Geographical
Information System, Donation Management System and Networking.
. Major skill set includes Manual Testing, ETL Testing and Testing
Project Management using Mercury Quality Centre, Test Director.
. Hands-on experience to check the back end functionalities using
Oracle, SQL Server, informix.
. Have been following Agile approach for Misys Healthcare system and in
prior had followed Water fall and V-Model approaches.
. Have Managed 20+ members QA Team working in various applications.
Qualification
Academic
2003 - Master of Computer Applications (M.C.A) from Madurai Kamaraj
University, Madurai, Tamilnadu, India - First Class.
1994 - Bachelor of Science (B.Sc) from Manonmanium Sundarnar
University, Tamilnadu, India - First Class.
Technical
2005 - Software Quality Analyst Course - Winrunner, Manual Testing
from SQTL, Mumbai.
1998 - Honors Diploma in Oracle 8/Dev. 2000, SQL Server 6.5 / VB 6
from SSi, India.
1997 - Master Diploma in Software Engineering (MDSE) from APTECH,
Chennai, India.
Certifications & Other Achievements
. International Software Testing Qualifications Board (ISTQB) Certified
Professional at foundation level.
. CCNA Certified by CISCO at Associate level (CCNA - 200-120)
(Cisco ID(CSCO): CSCO12549229)
. Received Team Awards from various clients with TATA Consultancy
Services.
. Received many mails and oral appreciations from client for completion
of task before the schedule with quality and their expectations.
. Received Individual appreciation and Thanks cards from client Senior
Managers for Testing and Management Support, onsite/offshore team
handling, issue resolving and dedicative cooperation.
. Received TCS Team Appreciation Certificate for Welch Allyn
incorporation with EMR for the client Misys, Raleigh.
Technical Experience
OS : Ms-DOS, Microsoft Windows 7/9x/NT/XP/2000, Unix, Linux
RDBMS : Oracle, SQL Server DBMS : Foxpro
Tools : Manual Testing, ETL Testing, Cognos Testing, Mercury Quality
Centre 9, Test Director 8, Acrobat Framework. Having Knowledge
of WinRunner, Rational Clear Quest, QTP 9.2
Technologies: Microsoft Visual Studio and Microsoft Office
Versioning Tools: VSS
Language : Worked on: SQL, PL/SQL, C, C++
Having Knowledge of Java, Java Script, HTML, DHTML
GUI : Developer 2000, Forms 5.0, Reports 3.0, VB 6.0
Methodologies / Process : SDLC, Test Life Cycle, Agile, Waterfall, V-Model
Hardware : Pentium Based Machines
Routing : RIP, OSPF,IP addressing, VLSM, IP routing principle,
EIGRP,OSPF, RIP
Switching : STP, VTP Security : NAT Other Protocols : EIGRP,
SNMP
Protocol Suite: TCP/IP
Network Technologies : Frame-relay, PPP, Access Control List (ACL), NAT,
PAT
Switching : VLAN, inter-VLAN routing, multicast forwarding, spanning
tree, VTP
LAN Topologies : Ethernet, Fast Ethernet, Token Ring
Simulators : Packet Tracer 6.0.0.1, GNS3
Hands on with Cisco Routers and Switches. Protocol Analysers : Wireshark
Career Profile
Dates Organization Role
July 2012 - Till ISKCON, Mumbai, India Software Tester
Date (freelancer)
Oct. 2010 - TATA Consultancy Services, Mumbai, Assistant
May.2012 India Consultant
Oct. 2006 - Feb. TATA Consultancy Services, Mumbai, IT Analyst
2009 India
Jun. 2003 - Intrinsic Solutions, Pune, India Senior Executive
Sep.2006
Feb.1997 - Jan. Tablets (India) Limited, Chennai, Programmer
2000 India
Oct.1996 - Jan. Sona Computers, Chennai, India Programmer
1997
Passport Detail
Name as on Passport Passport Date of Expiry Place of
Number Issue Date Issue
Janarthanan L6883185 22-Jan-2014 21-Jan-202 Madurai
Alwarramanujam 4
Project Work Experience
ISKCON, India
Project: Donation Management System
Customer: ISKCON, Mumbai, India
Role: Software Support Engineer
Project: Donation Management System
Donation Management System helps ISKCON to maintain their Life member /
Donors detail and their donations detail. It also helps them to mail/email
birthday greeting, wedding greeting, donation appeal letter, gift on
special occasion for their donations, special pass on special festival
session, Donation Receipt printing on pre-printed receipt and generating
various reports to the management.
Responsibilities:
. Understanding the functionality of the existing system.
. Interact with client for functional understanding.
. Involved in issue analysis, detailed study of Functional Design
Specification related to issue
. Test Traceability matrix preparation.
. Test Case Creation in Mercury Quality Centre and Execution.
. Perform System Testing, Regression Testing, Re-testing and Acceptance
testing.
. Defect Reporting and tracking.
. Test Report and status report creation.
. Interact with developers in resolving the defect.
. Daily Status Reporting to Client
TATA Consultancy Services, India
Project: WMCMS / OPUS - HRDR
Customer: Canadian Imperial Bank of Commerce, Toronto, Canada
Role: Project Lead
Project: Wealth Management Compliance Management System & OPUS - HRDR
The Wealth Management Compliance Monitoring System will allow Wealth
Management Compliance (WMC), CIBC Wood Gundy Branch Managers and CIBC Wood
Gundy Business Risk and Sales Supervision (BRSS) to conduct highly critical
daily and monthly trading surveillance through web portal to comply with
regulatory requirements for Tier 1 (at business level) and Tier 2
(compliance) and to integrate the electronic evidence of supervision.
OPUS Technology project is to ensure a successful integration of AON
Hewitt's HR services with CIBC internal applications/interfaces which
requires a Human Resources data repository (HRDR), batch interfaces
including HR data service layer (DSL), and federated access management to
be implemented. The project is mainly based on ETL.
Responsibilities:
. Lead the team of 20+ members.
. Coordinate with client in Test Plan and Test Strategy preparation.
. Analyze the Functional Specification Document.
. Conduct QA and Dev team / DA discussion for Functional Flow
understanding.
. Interact with client for functional understanding.
. Involve in issue analysis, detailed study of Functional Design
Specification related to issue
. Involve in Test Traceability matrix preparation and review with client.
. Test Case Creation in Mercury Quality Centre reviews with client and
Execution.
. Involve in ETL Testing and Cognos Testing
. Involve in Re-testing, Regression Testing and Acceptance testing.
. Involve in System Testing.
. Involve in Defect Reporting and tracking.
. Involve in Test Report creation and status report
. Interact with developers in resolving the defect.
. Guide the QA team in Test Traceability Matrix preparation, internal
review and client review.
. Guide the QA team in Test case writing for the reviewed TTM, internal
review and client external review.
. Interact with client regularly for Task Assignments, Clarification and
Status Reporting.
. Daily Status Reporting to TCS Management and Client Management
. Involve in Project Management activities like WON creation, Resource
allocation, Billing - invoice preparation, Cost Budgeting, VQF, IPMS,
IQMS.
. Follow and guide the team to follow all the TCS process and the Client
Processes like IQMS, IPMS and Maintaining Internals.
. IPMS coordinator for the project and handle the activities like phase
creation, task creation and allocation, IQA, EQA, FI etc.
. Properly handled Team ramp-up and ramp-down process and arranged proper
KT sessions.
Project: Misys Pioneer 8.10 and 9.x
Customer: Misys Healthcare System, Raleigh, USA
Role: QA Lead / Backup PL
Misys is a premier Healthcare solution provider company in USA. The
Healthcare group of company develops and supports reliable, easy-to-use
software and services of exceptional quality that enable physicians and
caregivers to more easily manage the complexities of healthcare. It
provides a variety of products that serve healthcare organizations of all
sizes, including electronic health records for ambulatory, acute and post-
acute settings, departmental systems, practice management systems and EDI
connectivity. The customer is from Raleigh (US). It is all about Hospital
Management and settlement of Health Insurance claims.
Responsibilities:
. Following the Agile Process which is adopted by the Client.
. Leading the team of 11 members.
. Coordinate with client in Test Plan and Test Strategy preparation.
. Analyze the Functional Specification Document.
. Conduct QA and Dev team / DA discussion for Functional Flow
understanding.
. Interact with client for functional understanding.
. Involve in issue analysis, detailed study of Functional Design
Specification related to issue
. Involve in Test Traceability matrix preparation and review with
client.
. Test Case Creation in Mercury Quality Centre, review with client and
Execution.
. Involve in Re-testing, Regression Testing, Acceptance testing and
System testing.
. Involve in Defect Reporting and tracking in internal.
. Involve in Test Report creation and status report
. Interact with developers in resolving the defect.
. Participate in weekly client status meeting.
. Interact with client regularly for Task Assignments, Clarification and
Status Reporting.
. Daily Status Reporting to client and PM
. Involve in Project Management activities like Weekly Project Status
Report preparation, monthly Steering Committee meeting and Quarterly
Project Management Report preparation.
. VSS Administration.
. Followed and guided the team to follow all the TCS process and the
Client Processes like IQMS, IPMS and Maintaining Internals.
. IPMS coordinator for the project and handle the activities like phase
creation, task creation and allocation, IQA, EQA, FI etc.
. Properly handled Team ramp-up and ramp-down process and arranged
proper KT sessions.
Environment: VB6.0, .NET (.NET 2.0), Informix.
The Application was developed in a multi-tier architecture where
Client Side DLLs and EXEs were building in VB 6.0 and the server
side DLLs were developed in C#. The client-server interaction
was done through remoting.
Tools used: Internal System Issue Tracking tool provided by customer,
Test Director, Quality Center 9.0. QTP 9.0, MS-VSS
Intrinsic Solutions, India
Project: GCIS [GIS based Client Information System]
Customer: Town and Country Planning Department, Haryana, India
Role: QA Lead
Town and country planning department, Haryana has conceived a GIS & MIS
based project called GCIS. National Information Center is responsible for
implementation of this project. GCIS is customized desktop window-based
Geospatial Solutions for control area planning in Town and country planning
department, Haryana. The objective of the Project-CGIS is to provide
necessary information to fulfill the needs of applicant to apply license
for the control area usage and the department to maintain their records by
use of software and hardware tools.
Responsibilities:
. Requirement Analysis.
. Preparation of Test Plan.
. Assisting in Test bed creation
. Preparation of test cases on Test Director
. Participate and conduct Peer review of test cases
. End to End functional testing
. Executed integration and regression test cases
. Interacted with developers in resolving the defects and close them.
. Raising & analyzing various defects and providing clarification to the
same, log defects
Environment: Windows XP, VB 6, Oracle 8, Test Director 7.2
Tools: Test Director 7.2, Rational Clear Quest
Project: Cute GIS [SAMVAHAK]
Customer: CAIR (Center for Artificial Intelligence and Robotics),
Bangalore, India
Role: QA Lead
Ministry of Defense has conceived a GIS & MIS based project called
SAMVAHAK, "The Information Carrier". Center for Artificial Intelligence and
Robotics an organization is responsible for implementation of this project.
Samvahak is customized desktop window-based Geospatial Solutions for field
formation units in Indian army. The objective of the Project-SAMVAHAK is to
provide necessary information to fulfill the operational needs of the
Indian Army to make rapid and effective command decisions by use of
software and hardware tools. It is primarily meant for collecting,
collating, filtering, processing, formatting and displaying Operational,
Intelligence and Logistics information to commanders and staff at all
levels in a field force to enable them to assess the battle field scenario
and to take appropriate decisions.
Responsibilities:
. Involved in Test Plan, Test Case preparation.
. Involved in manual testing, GUI testing, regression testing,
integration testing, bug tracking and report generation.
Environment: Windows XP, VB 6, Oracle 8, Test Director 7.2
Tools: Test Director 7.2, Rational Clear Quest
Project: NMC [Nashik Municipal Corporation].
Customer: Nashik Municipal Corporation, Nashik, India
Role: QA Lead
The purpose of this project is limited to develop an integrated GIS / MIS
system for Nashik Municipal Corporation. The software includes development
of Asset & Work flow management system to fulfill the needs of all
departmental activities of Nashik Municipal Corporation.
Responsibilities:
. Preparation of Test Plan.
. Setting the test bed environment.
. Involved in preparation of test cases.
. Involved in Manual Testing, GUI testing, regression testing, integration
testing, bug tracking and report generation
Environment: Windows XP, VB 6, Oracle 8, Test Director 7.2
Tools: Test Director 7.2, Rational Clear Quest
Project: ICCS [INTEGRATED COMMAND AND CONTROL SYSTEM]
Customer: J & K Police, India
Role: Team Member
The Integrated Command and Control System software provides real-time
display of vehicle locations on an intelligent map. As a vehicle's updated
positional information is received within the system (GPS), the vehicle is
immediately and automatically moved to the correct geographic location on
the intelligent map. J & K Police has decided to modernize their Police
Control Room Operation using Dial 100 Control room along with the Global
Positioning System (GPS) in their Vehicles for Automatic Vehicle
Identification in order to help the Public in emergency without any delay
Responsibilities:
. Involved in test cases creation
. Involved in Test case execution against manual testing of application
. Involved in GUI testing, regression testing, integration testing, bug
tracking and report generation.
Environment: Windows XP, VB 6, Oracle 8, Test Director 7.2
Tools: Test Director 7.2, Rational Clear Quest
Project: HMS [HOSPITAL MANAGEMENT SYSTEM].
Customer: Kalyani Hospital, Chennai, India
Role: Team Member
This Package was developed to the client Kalyani Hospital, Chennai. This
package was developed to automate all back-office functions within a
hospital or nursing home. The flexibility provided within the design
allowed it to be used for a nursing home and it could very easily be scaled
up to handle the functions of a mid-sized hospital. It facilitates the
following: Hour wise doctors' appointment, Separate code for inpatients and
outpatients, to know free and occupy status of bed and room, provides
multilevel security.
Responsibilities:
. Understanding the requirements.
. Involved in Front-end designing, Coding and unit testing.
. Followed SDLC.
. Extended support in Test case writing, Test Plan generation.
. Participated in GUI testing, Module testing and integration testing of
. HMS.
Project: ADMIN PACK (Administration Package).
Customer: Microcode Consultant, Bangalore, India
Role: Team Member
The AdminPack system has been designed to handle all the administrative
activities of the training wing of Microcode Consultants. The
administrative activities include maintenance of training inquiries
details, inquiry conversion into a registration details, billing and
invoicing. The system also maintains faculty and other staff related
information as well as payroll.
Responsibilities: Front end designing and Coding
Environment: Visual Basic, Oracle 8.0, Windows NT 4.0
Tablets (India) Limited, India
Project: TIL OLAP SYSTEM.
Customer: Tablets (India) Limited, Chennai, India
Role: Team Member
This package was developed to bring and generate different kinds of reports
of various division of the company Tablets (India) Limited under the menu
system. It helps to get all combination of reports of the company. The
report flashed on the screen, option is provided for printing.
It facilitates the following:
. To maintain marketing people expense details
. To maintain Standard Fare Chart for all possible routes and
designation wise traveling allowance for the field persons travel.
. Administration department to maintain stockist and Field person
details.
. To get proportionate sale ratio at various levels based on no of
stockist and field persons and sales.
. Sales and Collection details month wise for the management.
. Product Management and Promote Team of Pharma Division in the product
launch and allotment of samples and gifts to promote sales.
. PMT Team to make decision on their effective launch and allotment of
samples and gifts to promote sales.
. Dispatch plans preparation for factory for their effective production
and dispatch.
. In generating reports like sales performance analysis at various
levels.
. Some of the reports generated are
o The Star Product report
o Sales performance for the month and up to the month
o Sales performance upon previous year
o Quarter wise sales
o Target vs. Achievement
Product family wise sales & comparison over last year on territory level,
state level, region level and various reports requested by the Marketing
Department from time to time.
Responsibilities:
. Participated in Requirement gathering.
. Participated in application flow designing and getting approval from
the management.
. Involved in front end designing.
. Involved in coding.
. Creating unit test cases and performed unit testing.
. Sample data creation and creating table with sample data.
Environment: Oracle 7.3, Visual Basic, Windows NT 4.0
Project: TIL EXPORT SYSTEM.
Customer: Tablets (India) Limited, Chennai, India
Role: Team Member
This package was developed to help the Export Division (Overseas division)
of Tablets (India) Limited in marketing & sales in overseas. Operation
starts with capturing date from order form. Then the system will capture
the payment details like Letter of Credit, Advance Payment, and Dispatch on
Payment, Dispatch after Payment. Then for that order, Invoice and Shipping
bills are raised and printed through the software. The software has been
moduled as Master Details, Order Form Details, Invoice & Shipping Bill
Details, and Reports. Some of the reports generated by this software are
Production Requirement, Pending Orders, Proforma indent based on order
details. The other reports are Country wise, Agent wise, Party wise,
Representative wise, Month wise, Quarterly, Half yearly, Annual Sales
Reports, Sales comparison at various levels. Pending payments, shipping
details etc is generated. MIS reports for company analysis are also
generated through the package.
Responsibilities:
. Involved in System study
. Involved in the Preparing ERD
. Participated in system designing
. Participated in table creation
. Participated in software Coding
. Planning and conducting unit testing
. Preparing User Manual.
Environment: Ms-access, Visual Basic, Windows NT 4.0
Sona Computers, India
Project: LIC PREMIUM SYSTEM.
Customer: LIC Agent, Chennai, India
Role: Team Member
This software is basically developed to cater the need of an LIC Agent Mr.
Rajendra Babu, Chennai. He is the agent dealing with premium and different
kinds of Life Insurance Corporation Policies. The basic operation starts
with entering Client Details, his Company Details etc. After the approval
of the premium by Life Insurance Corporation of India the details like
premium commencing date, duration of the premium, premium method / period,
premium ending date, maturity value, nominee details etc. are captured.
With this details the reports generated having the details like the client
name, company name, premium method/period, value of the premium, Official &
Residential address etc as required by the user for the particular period
opted by him.
Responsibilities:
. Involved in System study
. Involved in the Preparing ERD
. Participated in system designing
. Participated in table creation
. Participated in software Coding
. Planning and conducting unit testing
. Preparing User Manual.
Environment: Oracle 7.3, Developer 2000, Windows 95
Project: DIAGNOSTIC SYSTEM.
Customer: JOY Diagnostic Centre, Chennai
Role: Team Member
This software is developed for the client Joy Diagnostic Centre at
Thondairpet, Chennai. This Billing System maintains Patients diagnostic
details and payment details. It starts with patient detail entry which
helps to generate patient diagnostic report & billing. It also helps to
generate reports like day to day and monthly collection, patient wise
credit and debit details, Doctor wise Commission details etc.
Responsibilities:
. Involved in System study
. Involved in Front End Designing
. Participated in software Coding
. Preparing User Manual.
Environment: Visual Foxpro, Windows 95