Project Manager Testing
Resume:
SREEDHAR MARAM
****.*****@*****.***
Summary:
. Ten years of experience in Quality Assurance, Management, Testing,
Software Design, Development and Quality Analysis.
. Over Five Years of experience in creating Test Cases based on
Technical Specifications and Use Cases
. Over Three years of reporting experience using Business Objects and
Crystal Reports.
. Experience includes the testing of Client / Server, WEB based and
Legacy applications using automated testing tools like Quality Center,
Win Runner, Load Runner and Rational Robot.
. Expert in QA Life Cycle Process using Agile Methodology
. Experienced in writing the Master, Detail, System, and Integration &
Performance Test Plans.
. Experience includes testing the User interface of the application
(Front end) and Back end Testing
. Testing skills include performing Regression, System Interface,
Integration, volume and stress testing as well as development,
execution, maintenance of Test plans, Test specifications and Test
scenarios. Solid analytical and dynamic troubleshooting skills.
. Automated testing expertise includes concentrated application,
training, and interaction with Mercury Tools (Quality Center, Win
Runner, and Load Runner) and IBM Rational Tools (Rational Robot,
Performance Tester, Team Test and Clear Quest).
. Experienced in executing shell scripts and SQL queries to validate the
data in the back end
. Strong experience in Oracle, Sybase and DB2 Databases
. Good exposure to reporting tools like Cognos, Business Objects,
Crystal Reports, Oracle Reports 2.5/6i.
. Developing reports using Report Studio, Analysis Studio, Query Studio,
ReportNet, Cognos PowerPlay, Impromptu, IWR, data modeling.
. Experience in testing Enterprise Data ware House Applications
using Informatica.
. Knowledge in Data Modeling using Dimensional Data Modeling, Star
Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions
Tables, Physical and Logical Data Modeling
. Knowledge in Data Mining in Clustering and to search through large
amounts of data in order to find important connections and
relationships
. Excellent communication skills and is able to work individually or as
a Team member.
Technical Skills:
Testing Tools: Quick Test Professional, Quality Center
8.2/9.0, Test Director 8/9.2/10,
Win Runner, Load Runner 7, VCS VM, Clear Case,
VSS, RUP, Rational Robot, Requisite pro, PVCS
Tracker 7.0, Clear Quest.
Hardware: IBM PC/AT compatibles, Sun Workstations.
Operating System: Windows 95,98,2000, XP / NT, Novel NT,
UNIX, HP, Sun Solaris, and
MS-DOS
Languages: C, C++, Java, XML, SQL, PL/SQL, TSL.
RDBMS: Oracle 9i, Sybase, MS Access, DB2, SQL
Server 2000
GUI / Front-end: Visual Basic 4.0/5.0, Developer 2000,
Exceed 6.1, X-term.
SDLC: RUP Methodology, Agile Methodology
Scripting Languages: VB script, Java script.
App/Web servers: Web Sphere, Web Logic, Netscape.
ERP : Sap, People soft, Oracle Financials.
Reporting Tools: Business Objects, Web Intelligence,
Crystal Reports,
Work Experience:
Capital One (Chevy Chase Bank) MD
Jan' 2010 - Sep'2010
Capital One is a diversified financial services company offering a broad
array of credit, savings and loan products to customers in the United
States, UK, and Canada. Capital One Financial Corporation bought Chevy
Chase Bank. This project is Integration of Chevy Chase Bank with the
Capital one; I mainly worked on the ATM Debit card and the Deposits.
Responsibilities:
. Analyzed the Business Requirements Document, Functional Specifications
documents to prepare Test Cases based on the Test Plans and Use Cases.
. Developed Weekly and Final Test Status reports with all the Test
Metrics Such as Total Test Executed, Total Test Analyzed, Total Passed
and Total Failed
. Performed report generation & defect tracking activities by using
Quality Center.
. Used SQL queries and UNIX Shell scripts to check the database
integrity.
. Created and executed SQL queries to fetch data from database server to
validate and compare expected results with those actually obtained.
. Execution of CDW in a dedicated Teradata environment, Credit Bureau
testing and mock conversion and Data Mapping test strategy.
. Analyze & report defects (Test Summary) on Functional, System, and
Integration, Regression issues.
. Created the Test Traceability Matrix for the Tracking of the Issues
right from the Requirements
. Performed Black box, functional testing and System testing.
. Worked as the incident tracker for Mock1, Mock2 and the Dress
Rehearsal.
. Wrote & Tested UNIX shell Scripts / UNIX Commands extensively for
writing the Test Scripts
. Used SQL queries for Database Testing to verify the data integrity and
used the tools TOAD
. Generated RTM and provided Defect Reports to the entire team.
. Prepared test case to test the backend Database by retrieving the data
for the tables using SQL Queries.
. Actively performed functionality, Configuration, unit and integration
tests.
. Performed End-to-End testing manually and was associated with User
Acceptance Testing.
. Performed Field Validation testing.
. Created Data Conversion Scenarios.
. Performed Message Format Validation according to the business rules.
. Prepared test cases to test the backend Database by retrieving the
data for the tables using TOAD Software.
. Reported the Defects, Email notifications to the developers using the
Quality Center.
. Actively participated in preparing the Defect Report.
Environment: QTP, JAVA, UNIX, Oracle, SQL, MS Project, MS Office, Windows
2000/NT.TOAD software, MS Word, MS Excel, and Quality Center 9.2/10, Ab-
Initio, Business Object, Ab-Initio>EME.
CareFirst Blue Cross BlueShield, Washington, DC
Aug 2007 - Dec 2009
QA Analyst
Carefirst INC. is implementing Facets, a client/server membership and
billing system. While Facets system provides delinquency processing. It
does not adequately support the activities of the collection and Claims.
Therefore, the Collections System will replace the existing Facets
delinquency processing to fully support the BCBSNCA collections policy for
fully insured business both groups and direct bill accounts. The
Collections System will support users from operational area, as well as
marketing and finance. The system also interacts with Facets and the mobius
printing and tracking tool for batch reports and letters. The Collection
system will also support the checks for reinstatement or short pay and
generates written notification incase one occurs.
Responsibilities:
. Project is with the Care first Dc working as a QA tester and involved
in Testing of FACETS a Client server member ship and
Billing System.
. The Main application includes Mass transfer and Rate quote systems
. Designed test scripts and Conditions for manual testing of the Mass
Transfer application.
. Analyzed and defined testable requirements created and implemented
test plans, test cases and test scripts.
. Created various Test Suites for different modules as a part of manual
testing by analyzing business requirements and Use Case Realization
documents
. Involved in testing the functionality and usability of the system for
end user perspective.
. Created Test Matrices to report the progress and status of the testing
effort
. Involved in performing functional, application, integration, system-
system interface and regression testing.
. Worked with development team to ensure testing issues are resolved
. Performed Black Box Testing from end user's perspective
. Conducted the Regression tests for already reported defects to test
whether fix has been applied or not and also to test whether the fix
causes another problem or not
. Used ILOG BRMS that allows both business and IT users to manage the
rules that drive business.
. Involved in creation of Reports, Formatting reports, generation of
charts, as per user requirements.
. Worked with Mainframe TSO/ISPF and File Aid tools to analyze
sequential data files.
. Installed and Configured Cognos Server. Installed Impromptu on Client
Desktops and helped them configure and troubleshoot Client Server
issues. Implemented Cube security by creating Cube Views for specific
user classes.
Environment: Facets 4.1, Collections System, FLEX, Mass Transfer, TSO/ISPF,
File Aid, DB2, Cognos, Cognos ReportNet, Cognos PowerPlay Web, PowerPlay
Connect Designer 2000, Sql Loader.
Bank One, DE
Mar 2004 - Jul 2007
Sr. QA Analyst
Bank One provides investors, credit cardholders and Checking Account
holders with prompt disclosure of certain transactions through customer
internet group in TMS suite like Account Transfer, Information Reporting,
Trading options, Entitlements, Fixed income, Brokerage. Information
Reporting service helps to access reports and detailed information for
customer accounts anywhere in the world, at anytime, online or printed.
Data can be viewed in a browser, as a Microsoft Excel spreadsheet, or
received as an export file for use in First Window and other treasury
workstations, or in accounting software.
Responsibilities:
. Analyzed Functional Req Specification (FRS)
and System Design Specification (SDS)
. Developed test cases for the front end, which communicates with middle
tier developed by java for tracking of management financial day to day
transactions in QTP at the time of Regression and Pre production
Testing.
. Created and Executed Automation Test Scripts for Visa Card and
MasterCard Simulator using QTP
. Created test procedures in Mercury Test Director which was the test
repository used for creating, storing and maintaining test cases.
. The whole testing process was documented in Test Director 8.2 which was
used to carry out bug tracking, analyze Results, schedule test
requirements and Test Jobs
. Ran the ETL Load Process in UNIX for Data mart and Cubes and shell
scripts for truncating the data from DM
. Validated the data in the source, Target, Cube and Reports and did Data
Transfer
. Executed the SQL's against the source and against the Target and
compares the Results in the excel Sheets.
. Mismatches between the Actual and Expected Values are registered in TD.
. Did Data Migration and Validated target data writing SQL's and PL/SQL
against Business Rules.
. Prepared test scripts for the automation of the product using a web
based application-testing tool.
. Participated in writing Test plans, Test scenarios and Test cases from
the Use cases and the Wire frames.
. Created the Traceability Matrix to keep track of changes in the Business
requirements to that of the testing efforts
Environment: Java, XML Windows 2000/XP, Unix, DB2, Oracle9i, Access,
Informatica, Toad, Excel, HTML, IBM Web Sphere, Sun Solaris 8.0, QTP, Test
Director, Load Runner, Remedy, Crystal Reports,
Cognos, Cognos ReportNet, Cognos PowerPlay Web, PowerPlay Connect Designer
2000, Sql Loader, Business Objects and Ab-Initio.
ADP, New Jersey July
2002 - Feb 2004
QA Analyst
ADP is one of the financial companies, which do the Payroll for the
customers. ADP continues to develop innovative products and services to
help clients and save valuable time... make the most of their employees and
resources... and boost their bottom line. This solutions-oriented approach
has helped ADP to become the world's leading provider of computerized
transaction processing, data communications and information-based business
solutions.
Responsibilities:
. Conducted the Functional, System, Integration, Regression,
performance, UAT and Smoke Tests of the client server. Escalation of
critical problem/issues during testing and reporting them in Test
Director.
. Used the automated tool Win Runner for functional testing
. Used Load Runner extensively for the load and volume testing
. Performed backend testing
. Developed and Modified scripts as per testing requirements
. Prepared user requirements and developed business and technical
specifications accordance to business requirements
. Used Clear quest Tool for Bug Reporting
. Tested the project according to business rules and specifications
. Documented Test cases, Test results and Test procedures
. Involved in testing the application against different browsers -
Netscape Navigator and Internet Explorer
. Involved in System Integration Testing and Performance Testing of Java
application
. Involved in User Acceptance Testing(UAT) and got sign off from the
Business Users
Environment: Windows 2000/XP, Java, Struts, JSP, Servlets, Web sphere,
Oracle, Toad, HTML, Test director, Win runner, Load runner, Remedy Bug
Tracking Tool, Rational Clear case.
MCI WorldCom, CO
Oct 2001 - Jun 2002
QA Analyst
Worked as a Sr. QA Analyst in a team of eight members. Initially this
project was developed on Mainframe and VC++. Later this is migrated to
Windows NT Operating System using VC++ as front-end. The Project is named
as System One NT Migration. The overview of this project is to capture
Customer Account Information, gather Customer Information, Accept Order
Information, View Billing Information, Customer Resource Management and
Promotional Activities. This project has 28 sub applications like: Account
Locate, Customer Information, Call Detail, Invoice, Billing Summary, Name
and Address, Calling Card, Dial, Personal 800, Plan Install, Account
Promos, Credits, Consolidated Notes, Network Trouble, Reporting Summary,
Internet, Sales, Random Call Detail, Outbound Correspondence etc.
Responsibilities:
. Participated in meetings with Project Manager, Team Manager, Team Lead
and other team members regarding the test procedures, test result
analysis and test script inspection.
. Extensively used Data Tables.
. Involved in Win Runner GUI map configuration and recording, Development
of complex and critical test scripts to organize smooth and accurate
execution of regression tests.
. Used SQL, PL/SQL queries for backend testing.
. Written and executed Shell Scripts to run the Functional Tests In a batch
Process.
. Performed high level stress testing to evaluate system primary
responsiveness.
. Analyzed the test results, created reports on defects/bugs
. Involved in System Integration Testing, User Acceptance Testing and
Performance Testing using Load Runner and Test Director
Environment: Windows NT, Sun Solaris, VC++, C++, Java, Oracle8i, MS Access,
Load Runner, Test Director 5.0 and PVCS Tracker.
Bonds in Asia, New York
Jul 2000 - Sep 2001
QA Tester
BIA (BondsInAsia) project attempts to bring a measure of uniformity and
ease of access to the Asian Bond Markets. Users of the system will be able
to research, analyze and trade Asian fixed income securities with a large
community of dealers; all within a single, easy to use, web-based
environment. This interface emphasizes easy of use and complete access to
all of the functionality available within BondsInAsia, and real-time
delivery of both quote and trade information.
Responsibilities:
. Performed Manual and Automated testing
. Developed and executed Test cases for Foreign exchange (Euro, Dollar,Yen)
. Developed test cases after analyzing the specifications Document
. Developed Base line scripts for testing the future releases of the
application using Win Runner
. Used PVCS Tracker for Bug Reporting
. Conducted Functionality and Regression testing during the various
phases of the application using Win Runner
. Executed the test scripts using Win Runner and analyzed the results
. Developed and executed automated test case scripts using Win Runner
Test for the Front-end-applications
. Cross browser testing has been done on Netscape 4.75 and I.E 5.01
Environment: Mercury Win Runner, PVCS, Windows NT, UNIX, AS/400, COBOL 400,
Sybase, and Java
HONDA OF AMERICA, OH
Sep 1998 - Jun 2000
As a Programmer at Honda of America, I was involved in Y2K conversion
solutions, Design, Development, Code changes, Unit testing of various
Applications. Used ENDEVER in retrieving program Modules from Production to
test region. Implemented year 2000 coding changes, program data compliance,
testing of the modules. Conversion of Cobol-II program modules to MVS COBOL
environment including the utilities. So as fit into MVS Environment. Used
VIASOFT in Analysis, Impact Analysis, Staging, Planning. Tested online, MVS
Batch, DB2 Batch Programs.
Applications:
Payroll Management
Purchase ordering System.
Material Release System
Advanced Ship Notice.
Domestic Receiving
Environment: File Aid, OS/390, COBOL, CICS, DB2, SQL, MVS, VSAM,
EASYTRIEVE, QA Run, Manual Testing.
EDUCATION: BS in Engineering, India - 1992,
PG Diploma in Computer applications - 1993,
Post Graduate Diploma in Marketing and Sales Management - 1994.
Contact this candidate