Quality Assurance Sql Server
Resume:
PRADEEP KUMAR [pic]
QA Analyst
****@*********.*** 314-***-****
SUMMARY:
. 9 years of IT experience in Software Testing of Web-Based, Data
Warehousing/ETL and Client Server Applications.
. Highly motivated professional with excellent experience in Software
testing and Quality Assurance.
. Excellent analytical skills for understanding the business requirements,
business rules/processes and detailed design of the application.
. 1 year Experience in E-Commerce Applications and Functionality.
. 2 year 2 months Selenium RC, Web driver With Junit and Experience in
implementing DataDriven and Keyword Driven Test Scripts.
. Good Experience in Web Platform Technologies in Web forms using Java,
.Net, Webservices, XML and SOAP UI.
. 2 years SOAP UI Experience in implementing Data Driven Test Scripts and
Generating SOAP UI Reports.
. 2 years experience in Mobile testing on various platforms like MACOSX,
Android, Brew, Symbian, J2ME and various devices like IPad, Tablet.
. Extensive knowledge on various Mobile Automation tools like Seetest,
Perfecto Mobile cloud, Selenium Robotium.
. Having extensive knowledge in mobile technologies like GSM, CDMA, GPRS,
WAP.
. Extensive experience in ADB Commands for testing android devices.
. Very good exposure on testing applications on wide range of mobile
handset of different vendors which includes, Apple IOS, Samsung, HTC,
Sony Ericson.
. Very good exposure in Mobile security tools, policies and Ethical Haking
and Penetration testing.
. Extensive Knowledge in Unix and Linux Commands and Shell Programming.
. Experience in coordinating and engaging teams for different phases.
. Extensive experience in design techniques, ETL processes, relational
database theory, N-Tier development.
. Expert in conducting various testing types like Functional, Integration,
Regression, UAT and End-to-end Testing
. Experience in Product Development, Retail Domain, Finance and Insurance
and Brokerage Domain
. Expertise in Process management using Quality center to Document test
cases and conduct triage meetings to resolve issues
. Experience in Technical writing Skills with hands on experience creating
Businesses Requirements, functional Specifications, Mapping Documents-R
Diagrams, Test Plan, Test Scripts and Status Reports.
. Expert in Defect Reporting and Tracking using Test Director/HP Quality
Center, IBM Rational Clear Quest.
. Preparation of Test Plan, Test Cases, Test Strategies and Test Effort
Estimation.
. Excellent skills in Database Testing. Experience in Testing Incoming Data
values and outgoing data value with queries, stored procedures, functions
and joins.
. Excellent Experience in Testing ETL Packages such as SSIS, SSRS,
Informatica. Validating Data in Destinations.
. Hands on Experience in Creating/ Testing Informatica Mappings.
. Proficiency in customization & implementation of Web Applications
. Strong Experience in Agile Methodologies, Scrum Methodologies.
. Experience in Wealth Management and Invest management.
. Experience in creating Data marts from different Data sources, and
filtering data in it and customizing and trouble shooting performance
counters in it
. Strong troubleshooting and organizational skills.
EDUCATION:
. Master of Computer Applications, Visvesvaraya Technology University.
TECHNICAL SKILLS:
SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export
& Import (DTS)
Databases: MS-SQL Server 6.5/7.0/8.0/9.0/10.0, MS Access 97 & 2000
Reporting Tools: MS SQL Server Reporting Services, Integrating Services,
Crystal Reports, Informatica, Analysis Services
Testing Tools: HP Quality Center, Smart Bear, Selenium RC Junit, Web
Driver Junit, ITKO
Web Servers: IIS 5 and 6
Languages: MS SQL Server 2005(9.0)/2000(8.0)/7.0/6.5, T-SQL, VB.NET, C#,
ASP.NET, TIBOC, BPF, AJAX, XML, PL/SQL, VB Script,
JavaScript, Turbo C, C++, Java, Informatica.
Tools: MS SourceSafe, Legacy mainframes, MS Office 97/2000/XP, MS
Front Page 98/2000, MS Outlook 97/2000
Operating System: Windows 2000 Advanced Server/Server
2003/Professional/ NT 4.0, Win XP Prof/Standard, MAC OS,
IPhoneOS, IPad, Tablet AndriodOS, Win 98.
PROFESSIONAL EXPERIENCE:
Multiplan, New York City, New York
April 13-Present
QA Analyst/Tester
Founded in 1980, MultiPlan is the industry's most comprehensive provider of
healthcare cost management solutions. Which have almost 900, 000 healthcare
providers under contract, an estimated 68 million consumers accessing our
network products, and 40 million claims processed through our networks each
year, giving us more of the experience and resources healthcare payers in
the commercial healthcare, government, workers' compensation and auto
markets need to face today's unprecedented cost and competitive pressures.
Responsibilities
. Participated in full life cycle for create invoice project. Analysis,
design and documentation.
. Involved in Preparing Master Test Plan and Reviewing with Developers and
made the changes according to business requirement.
. Created and tested the BO Objects reports and logged the defects and
closed the defects.
. Involved in Preparing Master Test Plan and Reviewing with Team and made
the changes according to business requirement.
. Participated in QA Meetings and provide status on Various QC's.
. Review the Business requirements of the Invoice Application documents.
. Attended the Triage call meetings and updated the status on various QC's.
. Using Quality center to log the defects, Analyze and Assign them to
responsible team and update the status accordingly.
. Deployed the TestScripts in TFS Server.
. Creating the SQL Server Stored Procedures and Functions
. Involved in Preparing Test Catalog's and Test Cases and Review with Test
Lead.
. Involved in writing the Test cases and Executing the Test cases.
Environment: Windows Server 2008, Fox Pro, SAP Business Objects, SQL Server
2008, HP Quality Center, QTP 11.0, TFS
Southwest Airlines, Dallas, Texas
Nov12- April 13
QA Analyst/Automation Tester
Southwest Airlines was incorporated in Texas and commenced Customer Service
on June 18, 1971, with three Boeing 737 aircraft serving three Texas cities
- Houston, Dallas, and San Antonio and grew to become a major airline in
1989 when it exceeded the billion-dollar revenue mark. Southwest topped the
monthly domestic originating passenger rankings for the first time in May
2003.
Responsibilities
. Participated in full life cycle of Master data management project (MDM).
Analysis, design and documentation
. Involved in Business meetings with TIBCO Architectures and gathered the
Requirements for Master data management Project (MDM).
. Involved in Preparing Master Test Plan for Master Data Management (MDM)
Project and Reviewing with Developers and made the changes according to
business requirement.
. Involved in Preparing Test Catalog's and Test Cases for Master data
management and Review with Test Lead.
. Involved in writing the Test cases and Executing the Test cases.
. Participated in QA Meeting's and provided status for various QC's
. Tested the TIBCO Web services using SOAP UI and Validated the functions
in it.
. Implemented the data driven frame in SOAP UI and Tested various functions
in web services with different sets of data.
. Conducted end-to-end mobile web application testing using emulator and
logged the defects for it.
. Conducted the task of executing the test cases on various devices like
emulator and IOS Devices with firmware 5.1.2 with 4G network.
. Conducted Regression testing on Pad and Tablets devices.
. Handle responsibilities of defining mobile specifications and
implementing the test plans.
. Implemented Telemetry approach for all Mobile Applications testing.
. Responsibilities included acceptance testing, functional testing,
Integration testing, system testing and performance testing.
. Reviewed the Mobile security polices and prepared test plan.
. Using Quality center to log the defects, Analyze and Assign them to
responsible team and update the status accordingly.
. Deployed the Test Scripts in TFS Server
. Implemented the Batch processing for T-SQL Procedures.
. Prepared Test Summary report and conditional acceptance memo if required.
. Conducted the cross browser testing to check the compatibility of the
Applications with different browsers (IE, Firefox, Nets Scape).
Environment: Windows Server 2008, TIBCO CIM, SOAPUI, HP QualityCenter.XML
SPY.XML Web services.
SIEMENS Enterprise, Irving, Texas
Jan12-Oct 12
QA Analyst & Engineer
Siemens Corporation is a U.S. subsidiary of Siemens AG, a global powerhouse
in electronics and electrical engineering, operating in the industry,
energy, healthcare, and infrastructure and cities sectors. For more than
160 years, Siemens has built a reputation for leading-edge innovation and
the quality of its products, services and solutions.
Responsibilities:
. Defined Testing Process and strictly following the process until testing
is certified for the test phases.
. Participated in Full Life cycle for multiple Data project: analysis,
design, documentation, development and testing.
. Implemented Data Driven Test Script using Selenium RC Junit.for Smart
Offer Project.
. Implemented Keyword Driven Test Scripts using Selenium Junit.
. Created Test Plan and Test Scenarios and Test cases according to Business
rules and Functional Requirements.
. Worked with Business Analyst, developers and managers to resolve the Key
issues in Project.
. Worked with BMC Quality Center to log the defects and analyze the tickets
and assigning them to responsible team.
. Tested Web services using SOAP UI and SOA Reported Defects to developer.
And generated Reports.
. Creating scenario based automation test scripts Right from Scratch for
Whole Smart Offer Project
. Conducted White box Testing for Smart Offer Tool.
. Implemented the Data Driven into SOAP UI and tested various functions in
Web services.
. Responsibilities included acceptance testing, functional testing,
Integration testing, system testing and performance testing.
. Conducted White box and Black box testing for Whole Smart Offer
Applications.
. Involved in Performance testing of Application using Jmeter.
. Generated Logs and reports using Jmeter.
. Responsible for performing the Functional, Integration, Regression and
UAT Testing.
. Fixed the issue in Data driven test scripts and delivered bug free test
scripts.
. Conducted Black box, White box and Cross Browser Testing to check the
compatibility of the Application with different Browsers (IE, AOL,
Netscape).
. Deploying the E-Commerce Automation (Smart offer) scripts into
Centralized Server SVN
. Created Automation test script for E-commerce Application (Smart Offer)
. Created Keyword Driven Framework using junit Web driver.
. Worked in Agile/Scrum Methodologies
. Participated in Review meetings and provided update on various QC's.
. Created Screen shots for using Selenium junit for all Applications in
project
. Executed test cases manually and identified the mismatches and logged the
defects using HP Quality Center.
Environment: Windows Server 2003, Java, Junit, SOAP UI, SOA, Selenium RC,
Web Driver BMC Quality Center, Fitness, Jmeter, XMLSPY,
Bank of America Pennington, New Jersey
April10- Nov11
QA Analyst & Engineer
Bank of America Corporation (Bank of America) is a bank holding company,
and a financial holding company. Bank of America is a financial
institution, serving individual consumers, small and middle market
businesses, corporations and governments with a range of banking,
investing, asset management and other financial and risk management
products and services. Through its banking subsidiaries (the Banks) and
various non-banking subsidiaries throughout the United States and in
selected international markets, it provides a range of banking and non-
banking financial services and products through six business segments:
Deposits, Global Card Services, Home Loans & Insurance, Global Commercial
Banking, Global Banking & Markets (GBAM) and Global Wealth & Investment
Management (GWIM), with the remaining operations recorded in All Other. In
April 2011, the Company merged its corporate and investment banking
divisions.
Responsibilities:
. Defined Testing Process and strictly following the process until testing
is certified for the test phases.
. Participated in Full Life cycle for multiple Data project: analysis,
design, documentation, development and testing
. Created Test Plans, Test Scenarios, Test cases, Test Scripts,
Traceability matrices according to Business and Functional Requirements.
. Work with business analyst, developers and manager to develop test plans,
produce test scenarios and repeatable test cases/scripts through all
parts of the development life cycle, execute and sign -off for a high
volume of data and regular release schedule for successful project
delivery.
. Responsibilities included acceptance testing, functional testing,
Integration testing, system testing and performance testing.
. Prepared test data for positive and negative test scenarios for
functional testing as documented in the test plan.
. Participated in QA meeting for providing update status on Various QC's.
. Tested the IF Service of TIBCO for OAO Applications and Using SOAP UI
solved the issues as per Business Requirement
. Conducted the GUI Functional and Integration testing for Mobile
Applications testing using Emulator and Simulator tools and logged the
defects for it.
. Implemented Telemetry approach for all Mobile Applications testing.
. Worked on various firmwares like 4.4.1, 5.2.1 for IOS and API Level 5, 6,
7, for Eclair and API 18 for Kitkat for Android.
. Conducted end-to-end testing for mobile applications. And various devices
like Ipad and Tablets
. Conducted end-to-end testing for Android devices with ADB Commands
. Reviewed the Mobile security polices and prepared test plan.
. Assigned the tasks of providing guidelines in mobile platforms
. Implemented Parameterization in SOAP UI and SOA Tested the Services and
written Test Cases for and reported the defects to Developers.
. Conducted Black box and White box Testing for OAO and US Trust projects.
. Implemented Data Driven in SOAP UI and tested various functions in Web
Services. With Data.
. Implemented Data driven Test scripts using Selenium RC Junit for OAO
Project.
. Implemented Hybrid driven test scripts using Selenium Junit for Alerts
projects.
. Implemented Fitness Framework using Selenium Junit for CAMU Project.
. Responsible for the Analysis of software applications and computer
systems, Focus of the effort is on batch process modules, UI screens, and
Reports
. Mentor testers and answer technical questions related to SQL and test
strategy.
. Using Clear Quest, Quality Center to log the defects, analyze them and
assign to the responsible team and update with the proper data to
reproduce the defects.
. Analyzing Test Results, Recording Defects encountered while Test
execution and Tracking them to their closure.
. Deployed the Test Script in TFS Server.
. Wrote test case scripts; executed and documented detailed results and
summary reports.
Environment : Windows Server 2003, Quality Center, Java, Junit, C#, TFS,
ASP.NET, TIBCO, BPF, SQL Server 2008, SOAP UI, IOS, Androids, Emulator,
Simulator, SOA, Fitness, TFS, Clear Quest, Selenium RC
National Life Insurance Montpelier, Vermont
June 09 - Mar 10
QA Analyst & Engineer
The flagship of the enterprise, National Life Insurance Company, was
established in Montpelier, Vermont in 1848 and is licensed in all 50 states
and the District of Columbia. From its very beginnings, National Life has
been one of the innovators of life insurance in America, having introduced
a number of improvements that are now regular features of policies sold by
a number of insurers. Over the years, the company has made available a
variety of new types of coverage and provided progressive improvements in
underwriting and service practices.
Responsibilities:
. Complete Responsibility in manual testing, Automation testing of the
compliance and discretionary projects in both Auto and property lines of
business.
. Prepared Test Plan Which covers the Test Estimation for Future Release.
. Performed manual testing of Active X components for windows flavor
(Windows XP/2000/NT).
. Created Mappings for the Requirements in Test Lab from iteration to
Iteration
. Participated in Business meeting for gathering requirements for multiple
projects.
. Executed test cases manually and identified the mismatches and logged the
defects using HP Quality Center.
. Execute and sign off on test scripts. Work closely with Ops Manager to
update Release Grids.
. Wrote test case scripts; executed and documented detailed results and
summary reports.
. Preparation of Test Procedures, Executing Test Cases both manual and
automated test cases using HP Quality Center.
. Executed SQL Queries for Database end-to-end testing
. Supported production deployments over the weekends.
. Configure test environment for the specific test cases, Create test data
and execute manual tests, document results.
. Conducted Black box and White box testing for SSIS and SSRS Packages and
Reports.
. Corrections made are Data Flow- Diagrams of Informatica.
. Implemented Data Driven Test Scripts for Whole Project. Using selenium RC
Junit.
. Responsible for performing the Functional, Integration, Regression and
UAT Testing.
. Worked on Web services to combine component based development and
internet standards and protocols that include HTTP, XML, SOAP UI and Web
services Description language.
. Perform Integration test by running ETL jobs, validating data loads,
troubleshooting job execution errors and executing test scripts
. Work with development, QA, and Automation engineers to research, design,
and develop complex test automation units.
. Implemented the Batch Processing for T-SQL Procedures for SSIS Packages.
. Using Clear Quest, Quality Center to log the defects, analyze them and
assign to the responsible team and update with the proper data to
reproduce the defects.
. Participate in production release validation to ensure successful
deployments of products without any performance issues.
. Worked in Agile/Scrum Methodologies.
. Prepared Test Summary report and conditional acceptance memo if required.
Environment: Windows Server 2003, Quality Center, SQL Server 2008, SOAP,
XML, TIBCO, BPF Services, Informatica, Web Services, SOAPUI, Clear Quest.
Freddie Mac (McLean, VA)
Fe09- June 09
QA Analyst
Freddie Mac works with mortgage lenders to help people get lower housing
costs and better access to home financing. Freddie Mac is one of the
financial institution involved in mortgage business for single family and
multi family business. All loans & Securities Transaction Accounting &
Reporting, duties during this project are finding defects in various
modules.
Responsibilities:
. Create test script and test cases by working with business analysts and
developers to review business requirements, functional specifications and
technical solution design.
. Analyzed Use Cases and developed Test Plan, Test Scripts and Test Cases
and executed them.
. Executed the test scripts on different releases as well as in different
modes and validated the actual results against the expected results using
HPQC.
. Performing Smoke, Integration, Validation and Compatibility testing of
the application manually.
. Automated Test cases and developed tests for Regression Testing using
Mercury Imperative's Quick Test Pro.
. Involved in the conversion of Manual regression test cases to Automation
Test Cases
. Maintained automation scripts, object repositories, functional libraries
in Selenium Junit RC
. Generated Bug (Defect) Reports and track the status of each defect.
. Worked with the development team to create a suite of test data to
exercises data validation and actual ETL functionality
. Created Data Driven Frame works using QTP/UFT.
. Performed Data Validation of the data flow by performing end to end
testing.
. Used Quality Center for defect tracking and reporting (logged defects,
change Requests, recorded defect details, assigned severity and reported
defect status).
. Involving in Risk Analysis, Root cause analysis, Walkthroughs and Release
support
. Developed and executed SQL queries to verify the proper insertion,
deletion and updates into the data Warehouse supporting tables and cubes
using TOAD.
. Worked closely with the development team and the State user in an Agile
environment to quickly identify issues
. Interaction with developers for resolving the critical bugs and
functionality modifications.
Environment :QTP/UFT., Quality Center 9.2, SOAP UI, Web services, Java,
Java Scripts, HTML, Vb Scripting, Oracle10g/11g, WindowsXP.
Always (In Style) New York City, NY
Jan 08 - Dec 08
QA Analyst/Engineer
Always(In Style) International, Inc. is a personal style training,
customer profiling, and data warehousing company that provides customized
fashion, beauty, style, and etiquette analysis and advice to both
individuals and organizations. Founded in 1982 by Doris Poser, with the
publication of her first book, Always In Style, the Always(In Style)
profiling software, books, products and training programs have been rolled
out in 25 countries. Always(In Style) 's corporate assets, including but
not limited to it's proprietary Personal Profiling software, reflects over
$8 million in investment and 25 years of operational experience.
Responsibilities:
. Production Infrastructure DBA Support-Responsible for administration of
almost a 40 instances out of which 10 are Production Instances 12 are
Development Instances and 18 are Testing Instances and comprising of 200
databases with size up to 300GB
. Perform quality assurance analysis and testing on an Enterprise-level web
application for the Life style Products
. Responsible for application analysis, test strategy development, test
case creation, test script development, test execution, defect tracking
and reporting.
. Involved in Business Requirement with various Retail experts.
. Responsible for the Analysis of software applications and computer
systems, Focus of the effort is on batch process modules, UI screens, and
Reports.
. Create automated test scripts for Retail Applications using QTP/UFT for
automation of the manual scripts
. Perform Backend database testing to validate the data using complex SQL
queries,
. Perform Integration test by running ETL jobs, validating data loads,
troubleshooting job execution errors and executing test scripts.
. Created a data driven framework using QTP/UFT and Automation Scripts
using QTP/UFT.
. Worked on Web services to combine component based development and
internet standards and protocols that include HTTP, XML, SOAP and Web
services Description language.
. Conducted Cross Browser Testing to check the compatibility of the
Application with different Browsers (IE, AOL, Netscape).
. Conducted Review meetings for Tickets raised for Retail Applications and
closed the tickets.
. Perform Regression test for every module of Software development
. Use chart graphs to test positive & negative scenarios based on the test
cases
. Work with development, QA, and Automation engineers to research, design,
and develop complex test automation units.
. Analyzed the testing progress by conducting walk through meetings with
internal quality assurance groups and with development groups.
. Participate in all stages of testing, such as Unit, Integration,
Regression System and UAT testing, in both manual and automation
environment.
. Absorb and understand system design, data model, and functional
components of large software system
. Mentor testers and answer technical questions related to SQL and test
strategy
Environment: Windows server 2003, Quality Center, SQL Server 2008,
QTP/UFT, Visual Studio 2005, SOAP, XML, ASP.NET, C#, Web Services. Clear
Quest.
East Collaborative Strategies Edison, New Jersey
April 2006 to Oct 2007
QA Analyst/Engineer
Systemic Enterprise Connector (SEC)
SEC PLM is a online project life cycle management system with powerful
Enterprise Application Integration processing needs in engineering and
manufacturing enterprise Confronted by various functions/departments having
operations at a tactical level to Strategic policy level.
Configuration control features in all the systems facilitate decision-
making persons or Groups of people across the product development or
project hierarchy for evaluating and approving or disapproving pieces of
data/ information in transactions.
SECPLM is highly scalable and integrated internet/intranet environment
with robust Systems that interplays addressing large data, information and
time bound functions. More specific to product development enterprise.
Responsibilities:
. Installed, Upgraded, and configured SQL Server 2000 and replication
servers on Sun Solaris and Windows NT.
. Reviewing business requirement documents to get a better understanding of
the system on both functional and business perspectives
. Perform quality assurance analysis and testing on an Enterprise-level web
application for the Life style Products
. Responsible for application analysis, test strategy development, test
case creation, test script development, test execution, defect tracking
and reporting.
. Involved in Business Requirement with various Retail experts.
. Responsible for the Analysis of software applications and computer
systems, Focus of the effort is on batch process modules, UI screens, and
Reports.
. Create automated test scripts for Retail Applications using QTP/UFT for
automation of the manual scripts
. Perform Backend database testing to validate the data using complex SQL
queries,
. Created a data driven framework using QTP and Automation Scripts using
QTP/UFT.
. Conducted Review meetings for Tickets raised for Retail Applications and
closed the tickets.
. Work with development, QA, and Automation engineers to research, design,
and develop complex test automation units.
. Analyzed the testing progress by conducting walk through meetings with
internal quality assurance groups and with development groups.
. Participate in all stages of testing, such as Unit, Integration,
Regression System and UAT testing, in both manual and automation
environment.
. Mentor testers and answer technical questions related to SQL and test
strategy
. Identify the test environments and prepare the Test Environments booking
and maintenance Plan. Coordinated the testing with different teams.
. Prepare Detailed Test Schedule and Test Resource allocation W.R.T Test
Estimation provided.
. Conducted Cross Browser Testing to check the compatibility of the
Application with different Browsers (IE, AOL, Netscape)
. Configure test environment for specific test cases, create test data, and
execute manual tests, document results, assigning the defects to
development team and update defect tracking systems.
. Participated in regular project status meetings related to testing
Environment: Windows Server 2000, SQL Server 2005, T-SQL, Quality Center,
Test Director, QTP/UFT.
System Domain Technology, Bangalore April 2003 to
March2006
Sybase Administrator
This project deals with the automation of the some of the steps involved in
Human Resource Management Process. In this era of software revolution.
Human Resource Management plays a significant role.
This Software is used to meet the requirement of the System Domain in
Human Resource Management Process. The software is an intranet application,
which can be extended to the internet with few modifications. The employees
are provided with a well defined GUI to carry out their operations along
with a greater security and ease.
Responsibilities:
. Designed and developed user interfaces using web forms.
. Involved in the Design of the Database (SQL Server 2000).
. Used Custom built Application Framework to build the Data Access Layer.
. Created Complex Stored Procedure and DTS Packages in Server 2000.
. Tracking and closing the Issues.
. Designing and modeling database according to Requirement. And made
changes according to it.
. Tested Sybase databases. Using DML Commands.
. Implemented Complex Procedures using UNIX Shell scripting Programming
Language.
. Maintained all the databases and making working in optimal level.
. Created database, Managed storage devices, fragment, segment, threshold,
and administered security role. Login, user/alias/group, object/command
permissions.
. Created Web services for PMS and Document management Modules Using
ASP.NET
. Created Custom and User Controls using ASP.NET Web forms.
Environment: Windows Server 2000 Sybase Server, C#, ASP.NET IIS,
JavaScript.
Contact this candidate