Naresh Sreerama
E-mail: *********@*****.***
Phone: 832-***-**** (Mobile) 678-***-**** (Home)
____________________________________________________________________________
_
Professional Summary:
. Possesses over 11 years of USA experience in Information Technology in
all phases of SDLC including QA in the finance, insurance,
telecommunications, banking, health care and e-commerce sectors.
. Experience in testing and QA of various web-based, object-oriented,
client-server and multi-tier applications.
. Experience in all aspects of the Software Development Life Cycle, with
specific focus on testing. Followed and implemented the Water fall
model, RUP, V-model of SDLC and Agile methodologies beginning from
initiation to deployment and support for projects.
. Experienced in performing business functionality testing at various
stages including Integration, System, User Interface, Performance,
Regression and User Acceptance Testing.
. Strong understanding of object oriented methodologies, software life
cycles and software testing methods. Experience in working with C,
C++, Java (JSP, EJB, J2EE and XML), VB Script, .Net, COBOL and C #
applications.
. Experienced in Manual and Automated Testing using Mercury/HP Suite's
tools (Win Runner, Quick Test Professional, Load Runner, Quality
Center, and Test Director.
. Expert in various testing methodologies like Black box, White-box,
Gray-box, Stress, Functional, Sanity, Data driven, Back end and basis-
path testing
. Proven ability in managing multiple priorities in a high paced
environment.
. Sound Knowledge in RDBMS i.e., Oracle, SQL Server, DB2, Backend
Testing of Stored Procedures, Triggers using PL/SQL Scripting, ETL
tools and Infomatica workflows.
. Excellent oral, written, problem solving and communication skills.
Professional Experience:
Cisco Systems - Lawrenceville, GA
August 2010 to Present
Software Quality Assurance Engineer/Lead
Responsibilities:
. Being a Quality Assurance Engineer/Lead in Cisco Systems, involved in
reviewing business requirement document to identify possible gaps in
the Requirements and involved in creation of project plan with project
managers and creation of test plans, test scenarios, test cases and
test execution with SQA test leads related to Generation 7 (GAIA - DVR
compatible) and Generation 6 (HERMES - non DVR compatible).
. Involved in Test Readiness performance testing, a basic acceptance
test, to determine if the full stack image is good enough to enter
into further regression testing
. Involved in Full Stack Functional Regression; Recording Reliability;
Long term stability testing; Memory testing; Performance testing for
the customers COX; Time Warner and Comcast.
. Involved in a OCAP based set top box project - Open Cable Application
Platform is a Java - based middle ware that resides on advanced cable
television set top boxes which brings two way interactive services to
the cable customer. Specified by Cable Labs for the cable operators of
North America. This type of applications include e Commerce, online
banking, Electronic Program Guides (EPG) and digital video recording
(DVR); utilizing the middle ware that resides on the specific set top
box or television, applications are not bound to a specific channel,
allowing the application to persist even when the viewer tunes away
from a specific television channel.
. OCAP based Cable set top box is a complex project with an operating
system layer operable to support cable network inter-connect ability
and to provide an application platform comprising one or more
profiles, each profile including personal information, personal
preferences and DVR capability.
. Involved in different types of Performance Testing which includes
1.Channel Change Performance. 2. Graphic/Guide Launch Performance. 3.
Boot time Performance 4. Stream Start Performance 5. Memory testing
and 6. MoCA/OCAP/Standard MIB testing.
. Involved in the regression bed by-weekly testing process interacting
with technical and system liaison team in identifying the issues;
distributing those to the different team members and make it clean for
the next transfer.
. Defect Fixing based on customer requirement OCAP specifications, Multi
room DVR Set top boxes and Non - DVR Set top boxes.
. Implementing Release documentation related to the functionality of the
Set top boxes.
. Analysing defects, training and assigning to the corresponding teams
through the SQA testing tools Clarify and TIMS.
. Involved in Back end testing of the application using ETL tools, SQL
and Informatica.
. Provided assistance to CIT, SQA Task Leads, analysts and testing team
in identifying, evaluating, resolving moderately complex test problems
and deploying test cases.
. Administrative support for various testing activities; testing
methodologies, data collection for on-going projects, status reports
on timely manner and creation of data reports to help test leads.
. Lead coordination with Project Managers; Business leads; onsite and
offshore model support with test leads and testers to create Master
Test plan as well as the development of system, integrations and
regression test plans, provide trainings related to application
support tools and project communications, assisted project tasks
determinations, Identify process improvement, issue resolution, risk
analysis and project milestones.
Environment: TIMS (Test Information Management System), Clarify;
Windows2000, 98, XP, Vista, Oracle 10g, .Net, Java, JavaScript, HTML, XML,
Ms Outlook, Excel, Access, Linux, Cisco Scientific Atlanta 8KG7/8KG6 Cronus
series chip sets, Power TV RTOS, CM Synergy and Gaia ASICs (integrated
MoCA, 3D graphics, HDMI 1.4), CDETS, Quality Center, Quick Test Pro. ETL,
Informatica and Microsoft Office Suite.
Principal Financial Group - Des Moines, Iowa
June 2008 to July 2010
Quality Control/Assurance Lead
Responsibilities:
. Being a Quality Control/Assurance Lead in Health IT department,
involved in reviewing business requirement document to identify
possible gaps in the Requirements and involved in creation of test
plans, test scenarios, test cases and test execution.
. Involved in the regression bed by-weekly testing process interacting
with technical and system liaison team in identifying the issues;
distributing those to the different team members and make it clean for
the next transfer.
. Work closely with project leads; successful QA Lead involvement in
health IT projects MSP, ID Cards, HIPAA, C4C, 2010 Medical Product,
Quote2Card and Wellness projects.
. Successful creation, implement and maintenance of VB scripts using QTP
automation tool in health IT projects such as E-Service, ID Cards,
C4C, Trizetto; Quote2Card, Renewals and Wellness projects.
. Provided assistance to QA Task Leads, analysts and testing team in
identifying, evaluating, resolving moderately complex test problems
and deploying test cases.
. Administrative support for various testing activities; testing
methodologies, data collection for on-going projects and creation of
data reports to help test leads.
. Involved in both manual and automation testing of all of the
applications using tools Quick Test Pro, Quality Center, Informatica
Power Center and 3rd party tools like THH and connector.
. Implemented testing objectives and analyzed the functionality of the
application under test. Mentor new resources, leading the team in
proficient way to understand QA best practices and various testing
methodologies to internal and external customers.
. Reviewed test cases written by the QA testers using business
requirements/ functional specifications documents and involved in
enhancing numerous test scripts to handle changes in the objects, in
the tested application and in the test environment.
. Involved in determining the test strategy and involved in execution of
Unit, Unit Integration, System, User Acceptance and Production
Acceptance test levels.
. Being as a subject matter expert in some areas, involved in conducting
training sessions to different teams and involvement in complete SDLC
as well as Functional, System, Integration, Data driven, End to End
and Regression testing of the application.
. Participating in functional and technical walk-through of deliverables
and artifacts.
. Perform data driven testing of the Principal Health IT applications
using the Quick Test Professional automation tool for checking page
contents, broken links, objects, frames and tables by developing VB
scripts.
. Involved in backend testing of the application using ETL tools and
Informatica Power Center for couple of Principal health IT projects.
. Perform database testing by writing queries in SQL, executing SQL
queries using PLSQL Developer and documenting the results in MS Excel.
. Extensive knowledge in test management/defect tracking process using
HP Quality Center and Compuware Track Record.
. Ability to understand XML and XML Schema to generate and upload the
files to GPS using SELENIUM server and Capture systems.
. Involved in performance testing of the C4C application using HP's Load
Runner.
. Extensively involved in using Compuware products Track Record, QA
Center and Test Partner in some of the Health IT projects.
. Acted as liaison between technical; business and offshore (Pune -
India) testing team.
. Conduct Automation review process meetings on quarterly basis with
System Liaison, SME's and QA/QC team leads to improve the Regression
Bed.
. Ensure QA artifacts are developed, meet stakeholder expectations,
attend review meetings and walkthroughs/signoffs are accomplished.
. Develop document status reports time to time, attend status meetings,
other project communications, and assisted in determining project
tasks and milestones.
. Work with Business Analyst to ensure project closing procedures are
completed.
. QA Lead coordination with Project Managers; Business leads; AM's to
create Master test plans; project communications, assisted project
tasks determinations, risk analysis, test execution, production
validation and milestones.
Environment: QTP, Quality Center, Load Runner, Visual Basic, Windows2000,
98, XP, Vista, SQL Server 2000, Oracle 10g, DB2, .Net, Java, JavaScript,
PL/SQL Developer, HTML, XML, Main Frames, Microsoft Outlook, Excel, Access,
Visio, Share point, Refresh, GPS, SELENIUM, UNIX,COBOL,CICS, JCL, ISPF,
TSO, Informatica and Principal health Systems.
Iowa Foundation for Medical Care - West Des Moines, Iowa
18 June 2005 - 30 June 2008
SQA Analyst/Lead
Responsibilities:
. Being a Lead SQA Analyst, heavily involved in the creation,
preparation, and execution of UA testing deliverables, functional and
regression testing of the applications.
. Involved in business requirement documents review; use cases to
identify possible gaps in the Requirements to create test plans; test
scenarios, test cases and test execution.
. Involved in both manual and automation testing of ASPEN applications
assisting in identifying, evaluating and resolving moderately complex
test problems.
. Implemented testing objectives and analyzed the functionality of the
application under test. Mentor new resources, leading the team in
proficient way to meet the dead lines.
. Wrote, executed and implemented test cases from business requirements/
functional specifications documents and involved in enhancing numerous
test scripts to handle changes in the objects, in the tested
application and in the test environment.
. Involved in Functional, System, Integration, Data driven, End to End
and Regression testing of the application.
. Ability to understand, evaluate XML data and upload the data to the MS
Excel sheets.
. Performed system testing on various hardware platforms and software
configurations.
. Perform functional and regression testing of the applications using
Win runner automation tool for some of the ASPEN releases by
developing TSL scripts.
. Perform data driven testing and functional testing of the ASPEN
applications using the QTP automation tools for checking page
contents, broken links, objects, frames and tables by developing
Visual Basic scripts.
. Extensively involved in using Compuware products QA Center and Test
Partner in ASPEN applications.
. Perform database testing by writing queries in SQL, executing SQL
queries using PLSQL Developer and documenting the results in Excel.
. Test co-ordination and lead the testing process, schedule batch tests,
logged and tracked defects using Manual and Automation techniques.
. Very good experience in using the defect tracking and management tools
Compuware Trackrecord and Mercury Quality Center.
. Assist QC training materials and presentations; expert in test
execution; test lab, defects and test plan modules.
. Conduct weekly testing meetings and training sessions related to QC.
. Coordinated and managed the resolution of issues that may impact
and/or impede the testing effort.
. Experience in Release management, test planning; test execution and
test management.
. Customer service experience and lead responsibilities for Production
Control Remedies.
. Developed status reports, attend status meetings, other project
communications, project risk analysis and assisted in determining
project tasks and milestones.
Environment: QTP, Win Runner, Windows 2000, 98, XP, SQL Server 2000, Oracle
10g, Java, PL/SQL Developer, HTML, XML, Main Frames, COBOL, DB2, CICS,
ISPF, TSO, FAILEAID, Test Track Pro, VB, CALIBER, Compuware
products(Trackrecord, QA Center, Test Partner) Group wise.
WELLS FARGO Home Mortgage, West Des Moines, IA
Sr.Automation Consultant.
December 2004 - May 2005
WELLS FARGO is one of the largest diversified financial service
organizations in the United States. Its major businesses include Regional
Community Banking, Corporate Banking, Private Banking, Mortgage Banking,
Secured Lending, Asset Management and Mutual Fund Servicing.
Responsibilities:
. Involved in Writing test scenarios, test scripts for manual, and
automated testing.
. Perform black box testing including regression, integration and
functional testing using WinRunner by developing TSL scripts
. Perform system testing on various hardware platforms and software
configurations
. Perform web test using WinRunner for checking page contents, broken
links, web objects, frames and tables.
. Perform database testing by writing queries in SQL
. Apply necessary add-ins for object identification using WinRunner GUI
mapping. Parameterize test scripts to input data from EXCEL. Analyze
the test results using Test Director.
. Import requirements, create test cases, validate requirements with
test cases and generate reports using Test Director.
. Manage the test process, schedule batch tests, log and track defects
using Test Director.
. Validated data/application based on business rules.
. Performed Smoke Testing, Integration testing, end-to end testing,
System testing, Function testing, Performance testing and User
Acceptance testing.
. Worked closely with developers to define the best GUI functions and
usability
. Reviewing Functional specs and Technical designs and providing
feedback from QA perspective.
. Parameterize the scripts to run using varying form data. Generalizing
the scripts using regular expressions and handling unexpected errors
using exception-handling mechanism of Load runner.
. Implemented Test Director for bug tracking and reporting followed up
with development team to verify bug fixes, and update bug status.
. Keeping up-to-date on QA training and methodologies.
. Conducted weekly project status meetings and updated the process
accordingly
. Conduct validation and verification of bug fixes.
. Using Quality Centre 8.0 as the Management and defect-tracking tool.
Environment: WinRunner 7.6, QTP 6.5, Mercury Quality Centre 8.0, DB-2,
Oracle, HTML, XML, Java, J2EE, Load Runner 7.5, DB2 UDB, Mainframes, IE
6.0, Window 2000/XP.
Sprint PCS, KS. June 2004 - October
2004
Sr. Test Analyst
Responsibilities:
. Acted as a liaison between the Business team and Delivery team by
participating in requirements gathering.
. Studied the application document and prepared test Scenarios based on
requirements.
. Involved as an automation test lead to create tests using Mercury's
QTP automation tool.
. Acted as a business analyst in the requirement gathering and design
process, and serves as a Subject Matter Expert to the UAT work effort.
. Involved as a lead for the off-shore team, reviewed the automation
scripts created using QTP and Win runner tools by the team mates and
worked as an On-site coordinator for the project GNC (Good neighbor
care) which is an Internet based auto application to provide
Quote/Application to the customers across the United States and
Canada.
. Prepared & executed test cases and communicated with team to resolve
issues and bugs.
. Managed the test cases and scripts using Configuration Management
Tools and Bi-directional Traceability from requirements to test cases
and scripts.
. Analyzes, tests, and certifies application-specific software and
performs ambiguity reviews of business requirements and functional
specification documents
. Conducted Functional, Integration and Regression testing.
. Wrote SQL queries to check for proper data population in application
tables.
. Maintained and updated scripts for regression test suite to
effectively manage the testing process.
. Conducted functional and data driven testing of the application by
passing data from MS excel sheets using QTP.
. Investigated and documented the errors using Test Director.
Coordinated with the development team for bug resolution.
. Interfaced with projects managers to ensure that all testing plans,
scripts and results are in appropriate project documentation.
. Performed Integration testing to verify the data interfaces between
various application modules.
. Participated in status meetings to report issues.
. Demonstrated an understanding of risk management by providing sign-off
of UAT test results.
Environment: QTP, Win Runner, Test Director, Windows NT/2000/XP, UNIX,
Java, EJB, JSP, JDBC, Servlets and Oracle.
Client: Bank of America, IL December 2002
- May 2004
Quality Analyst
Responsibilities:
. Analyzed system requirement specifications and developed test plans, test
cases to cover overall quality assurance testing.
. Developed automated test scripts defining scenarios and procedures to
test the performance security, recovery and reliability of the
application.
. Automated the deserving tests by using Win Runner and was responsible for
execution of various Test Scripts.
. Attending review meetings regularly.
. Identified defects using Test Director and worked closely with developers
to resolve technical issue
. Run the test scripts on multiple browsers and reviewing various Test
results.
. Initially performed manual testing of each unit/build.
Environment: Windows NT, EJB, JSP, Servlets, Web logic Server 4.5.1, JNDI,
Oracle, JDBC, UNIX, Win Runner 6.0, Load Runner 6.0, Test Director 6.0
Client: State Farm Insurance, IL Aug
2001 - Aug 2002
Test Analyst
Responsibilities:
. Analyzed System requirements and involved in writing the Test plan.
. Developed the test cases to test system, system integration and back
end testing.
. Analyzed business requirements, wrote, and executed test cases.
. Successful usage of Win Runner for recording and playback of sub-
system, editing the test scripts and playback the scripts after fixing
the bugs.
. Responsible for Functional testing of the Application developed in
Visual Basic using Win Runner.
. Performed Data Driven Testing using Win Runner.
Environment: Windows NT, Win Runner 6.0, Load Runner 6.0, EJB, JSP,
Servlets, Web logic Server 4.5.1, JNDI, Oracle I, JDBC.
Chemfab Electrical@ Indsoft Ltd, India March 2001 -
August 2001
Project: Inventory Management System
This project involved the testing of the application relating to the
inventory of the Manufacturing unit of the Chemfab Electrical Company. The
company had a very large warehouse, which would hold the spares of all the
models used in the manufacturing process. The testing of the application
involved preparation of test scripts for the input forms to input data of
serial number of each and every part that constitutes the manufacturing
process of each model of the single item.
Responsibilities:
. Analyzed Business requirements and Functional documents
. Designed test procedures and test cases
. Extensively involved in testing the application manually.
. Involved in the development of test procedures for various stages like
Smoke Integration, System and User Acceptance Testing, Positive and
Negative Testing.
. Performed system testing, Installation testing, Performance testing,
User interface testing and Work flow testing.
. Documented and reported the defects to developers.
Environment: Windows 98, Visual Basic 5.0, Oracle7.0, MS Word.
United Information Technology Inc., South Field, MI
December 2000 - Feb 2001
Quotation Billing System
1. Performed GUI interface testing on the client side using Win Runner.
2. Responsible for the testing of application at unit level, module level
and system level for quality of the software.
3. Responsible for analyzing large amount of expected Vs Actual results
using Test Director and Win Runner.
4. Responsible for generation of Data for execution of Test cases.
5. Responsible for execution of generated Test Cases Manually.
6. Responsible for UAT (User Acceptance Testing) and Regression Testing.
Performed Integration testing for the system compatibility.
Environment: JDK Java, JavaScript, HTML, Oracle 8.0, Win NT, Java Server
Pages, Win runner 6.0 and Test Director 6.0.
Data Consulting Inc., Decatur, AL June 2000 -
November 2000
Order Management System
. Developed Manual Test Cases by decomposing Use Cases for specific
functional requirements
. Made recommendations for manual and automated testing of varied
functionality
. Interacted with Business teams and Developers to understand business
requirements and bug fixes
. Wrote SQL queries to check proper data population in application
tables
. Worked with Super Users and Business Analysts to define and design
test scenarios and test data
. Performed Integration testing to verify the data interface between
various application modules
. Performed System and Regression Testing for new releases
Environment: JDK Java, JavaScript, HTML, Oracle 8.0, Win NT, Java Server
Pages, Win runner 6.0 and Test Director 6.0.
Employer: NGK Indsoft Pvt. Ltd.
Start Date: 07 April 1997
End Date: 02 June 2000
I've worked in NGK Indsoft Ltd for more than 3 years for the following
clients.
Client: Sabha Solar Energy, Bangalore, India December 1999 -
June 2000
Payroll System
The application is divided in to three modules.
The first module consists of transactions, check listing the transactions,
updating of transaction files and master files.
Second module contains various reports like pay slip, income tax, PF and
loan advances.
Third module gives employee details about the advances, recoveries.
Responsibilities:
Design; Development and Testing.
Environment: JDK, JDBC, Servlets, HTML, Oracle 7.3, Windows NT.
SRMT, India. June 1999 -
Nov 1999
Transportation Management System
The Project is divided in to three modules: Transportation, Accounting and
Personal Information.
Responsibilities:
. Developed and Designed screens for Transportation Module; which
generates reports like Invoices on weekly/monthly basis.
. Created tables and views in SQL.
Environment: VB5.0, ORACLE7.3, Windows.
Union Bank of India, India April 1997 -
May 1999
Banking Management System
7. Developed and Designed Screens.
8. Generated Reports, Created tables, views in sql.
9. Designed screens using HTML and Java Frames.
10. Involved in Design, Development & Testing
Environment: JAVA, JDK, JDBC, Servlets, HTML, Oracle 7.3, Windows NT, VB
5.0, ORACLE 7.3, Windows 95, AS/400, DB2/400, RPG/400, CL/400, COBOL/400,
COBOL.
TECHNICAL SKILLS
Testing Tools : Mercury/HP testing tools Win Runner, Test Director,
Quality Center, Load Runner, QTP, IBM
Rational Suite, TIMS
Operating Systems : MS-DOS, UNIX, Linux, Windows 2000, XP, 7, NT and
Vista.
Languages : COBOL, CICS, JCL, C, C++, Java, SQL, PL/SQL and
TSL.
Databases : DB2, Oracle 7, 8.X, 9i, 10g, SQL Server, MS-
Access.
Tools/Applications : Toad, Crystal Reports, Visual
SourceSafe, Visio & Informatica.
Business Tools : MS Word, MS Excel, MS Power point, MS Project & Clarify
Browsers : IE 5.0, 5.5, 6.0, Netscape 4.7, 6.1, 6.23, 7.0
Web Technologies : J2EE, HTML, JavaScript, ODBC, ActiveX, VBScript,
ASP
Application/Web servers : IIS, Apache, Weblogic, IBM Websphere.
EDUCATION
. Bachelors Degree in Engineering from Kuvempu University passed out
with First Class, India.
. Post Graduate Diploma in Computer Applications from Deepthi Computers,
Hyderabad, India.
. Certifications in Java, Mainframes and Oracle.