OBJECTIVE:

• A dedicated quality assurance professional credited with defining, planning, and executing expertise to deliver technical solutions on time and within budget. Driven by passion for quality with strong expertise in communicating and collaborating with internal and external stakeholders as well as problem solving and thinking abstractly to resolve issues quickly with diverse group of people in a dynamic environment.
• Highly accomplished 6+ Years of experience in testing software solutions effectively by applying QA concepts and methodologies like Manual Testing & Automation Testing with the help of tools and procedures like SDLC, SAP, OBIEE, SalesForce, PL/SQL etc.

SUMMARY

• Experience in Quality Assurance, Testing and Development of Web and Client/Server based applications on Java and .Net environment.
• Strong data base experience in Oracle, SQL Server, DB2 and Sybase.
• 2+ years experience in QTP (UFT) Automation Testing.
• Professional experience in Insurance and Financial industries, working on Mobile, Fixed Income Trading, Equity Trading, Banking, Health Care / Public Sector, Retail and E - Commerce.
• Understanding of System Development Life Cycle (SDLC) and testing life-cycle, testing procedures, Bug life-cycle and methodologies.
• Experience with Mobile App (Android/iOS) and Mobile Web Testing.
• Having extensive knowledge in mobile technologies like GSM, GPRS, WAP
• Expertise of testing the application developed using various mobile technologies including J2ME, Blackberry, Andriod, Symbian, .Net Technology etc.
• Testing of the chat conversations, Send Receive Picture messages, MMS, sending sms from the chat, calling from the conversation.
• Strong experience in manual and automated testing of web, web services and client/server applications using SoapUI, LISA middleware testing tool, Quality Center, Quick Test Professional, WinRunner, LoadRunner and TestDirector. (Web E-Commerce, ERP, BI and CRM).
• Experienced in testing web applications using Oracle, PL/SQL, Java, JSP, JMS, JNDI, RMI, JDBC and ODBC.
• Proficient in GUI Testing, Functional Testing, Regression Testing, Integration Testing, Database testing, System testing, Security testing, Smoke testing, Build Verification Testing, User Acceptance Testing and Cross browser Testing.
• Experience in/with testing BI and CRM tools and technologies.
• Experience in developing Test Plans, Test Cases and Test Scripts, documenting Test results and Defect Tracking.
• Proven in-depth experience in SQA principles and methodologies
• Experience in representing SQA in cross-functional team environments
• Ability to operate effectively, and with a sense of possibility, in a fast-paced, deadline-driven environment and managing multiple projects simultaneously.
• Expertise in identifying, recalibrating, and executing manual and automated tests for multiple builds within the same scheduled release.
• Have good knowledge of Business Acceptance Testing(BAT) testing.
• Ability to thrive in fast-paced environment with being resourceful and determined.
• Strong understanding and worked with Object Oriented Languages and Techniques.
• Extensive experience in designing effective test plans, test scenarios, test cases and test reports
• Experience in Test Result Evaluation, Reporting, Metrics and developing templates.
• Experience with data-driven testing, including creating and maintaining large amount of data
• Technical aptitude to execute tests in manual fashion in web, mobile and client/server environments
• Proficient with defect tracking tool and change management processes using Quality Center, Test Director, Mantis, and JIRA
• Ability to identify issues, make decisions and work with the team get them resolved.
• Well-developed scripting skills with VB Script and Java Script.
• Experience in Different Software development methodologies like Waterfall Model, RUP methodology, and Agile Software Development process.
• Proficient with database testing using SQL(DDL and DML queries) on Oracle, SQL Server, and MySQL.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Strong knowledge of PL/SQL and in creating Packages, Procedures, Functions, Views, Tables and Dynamic SQL.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracleapplications.
• Expertise in ETL BACKEND TESTING.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Ability to assist QA Lead and Manager in managing project schedules, staff resourcing, and communication with onsite and offshore team.
• Basic Knowledge of Macro programming.
• Ability to work under minimal supervision and strong commitment to high quality work and timely deliverables.
• Ability to work well under pressure and meet deadlines as required
• Strong interpersonal and communication skills and ability to work effectively with staff at all levels
• Self-starter with positive presence and a can-do attitude
• Excellent Oral, Written, Interpersonal and Communication skills.

TECHNICAL SKILLS

Software Languages: C, C++, Java, C#, VB.NET

J2EE Technologies: Java Servlets, JSP, EJB

Middleware Technologies: Web Services (WSDL), SOAP, RMI

Database Applications: Oracle, Sybase, MS-SQL Server, MySQL, DB2, Informatica

Database Technologies: JDBC, SQL, PL/SQL, MySQL

Web/Application Servers: WebLogic, WebSphere, WebSpheere Commerce, Apache Tomcat, IIS

Web Technologies: HTML, XML, CSS, JavaScript

Browser and Servers: Internet Explorer, Mozilla Firefox, Google Chrome, Opera, Safari, Aol

Development Environment: Eclipse 3.0 - 4.2, Netbeans, IBM RAD, Visual Studio .Net 2005/2008/2013

Mercury Interactive Tools: Test Director, Quality Center, QTP (UFT), LoadRunner

Defect Tracking System: PVCS Tracker, JIRA, DotProject

CRM Tools: SalesForce, Siebel

Tools: /Applications: MS Office 2007/2010/2013 , MS Visio, MS Project, UML, Acrobat Reader

Operating Systems: Windows 98/XP/Vista/7/8, Linux, UNIX, Mac OSX, DOS

BI Tools: OBIEE, SAP

PROFESSIONAL EXPERIENCE

Confidential - Augusta ME

Senior QA Analyst

Responsibilities:

• Working with Test Management to create and implement Quality Control Processes
• Involve with the systems development life cycle (SDLC)
• Testing reports and dashboards in OBIEE using Answers
• Working with the physical queries behind the OBIEE Reports
• Using OBIEE repository layers (RPD)
• Designed and Implemented Performance Testing Plan for QM, eReporting, OEM's (BT, Avaya), Balance, and WFO.
• Involved in testing HIPAA EDI Transactions.
• Involved in Medicare/Medicaid (Insurance) Projects.
• Extensive experience in customizing Siebel Analytics/OBIEE dashboards and reports.
• Extensive experience in Repository and Reports performance tuning.
• Working in a continual test mode in Agile based development process
• Leading testing activities with minimal or no supervision of test management
• Creating a relationship with Project team, including Line of Business, Interface Partners and coordinating testing activities
• Conducting meetings with Cross Functional team for Defect Triaging, Test Coordination, Troubleshooting activities
• Creating Test Strategy and Test Plan documents, documenting test scenarios and Test Cases for System and UAT Testing.
• Quality Center - Defining Releases, loading Requirements, Test Cases, adding Test Sets and Defect Management; link between Releases/ Requirements/ Test Cases/ Defects; Traceability Matrix against Release, Requirements, Test cases, Defects
• Defining Entry Criteria and Exit Criteria for all QA/Test Deliverables.
• Querying QC database, and creating automated reports for Daily Reporting purposes for management
• Web site and application updates and maintenance on ASP and static HTML sites.
• Working with oracle database bases using JDBC, connection strings.
• Wrote SQL queries to test the application for data integrity and verified the contents of the datatable.
• Created PL/SQL procedures/functions for database load performance testing and data validation
• Extensively used SQL queries to check storage and accuracy of data in database table
• Worked on trimming the SQL and optimizing the SQL by using various VLDB settings in the MSTR toavoid the cross join and removing multiple passes.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculateinformation to fulfill data and reporting requirements including identifying the tables and columnsfrom which data is extracted.
• Involved in the production support team for planning cycle after production implementation. Strongability in developing advanced SQL queries to extract, manipulate, and/or calculate information tofulfill data and reporting requirements including identifying the tables and columns from which datais extracted
• Written several UNIX scripts for invoking data reconciliation.
• Used SQL for Querying the Oracle database in UNIX environment
• Involved in extensive DATA validation using SQL queries and backendtesting
• Automated Functional and Regression tests using QTP (UFT).
• Tested mobile web version of the portal/site on emulators and devices (iOS/Android).
• Recording and documenting the details of bug in the bug tracking system (JIRA).
• Recognizing bug severity and escalating and prioritizing accordingly based on the severity and impact of any product bugs detected.
• Performed Functional Testing in QA, Staging, Pre-production and Post-production builds.
• Work independently with engineers on following up on any blocking issues associated with fixing or validating fixed bugs.
• Interfacing with multiple internal teams (QA, Dev, PMs, Ops, etc.)
• Tested business batch process and executed mock/test runs for batch process.
• Web Service testing with Soap UI Pro - Creating Data Validation points and adding Assertions - to validate against DB/ external data
• Working on parallel projects
• Attending Daily Stand ups and other project related meetings.

Environment: Soap UI Pro, HP Quality Center 11/ ALM (Application Lifecycle Management), QTP (UFT) 11, Oracle 11g, HTML, Oracle 11g, Toad, Microsoft Office Excel, FireBug, Microsoft Internet Explorer, Microsoft Office Word, Unix, Windows XP, 7.

Confidential, New York, NY

Senior QA Analyst

Responsibilities:

• Reviewing Requirements and Specifications documentation.
• Writing Test Cases, and detailed Test Scripts BAT, Module, Integration, system, and UAT Testing.
• Manage Test Cases and Requirement Traceability Matrix usingQuality Center.
• Building Request in XML to send to service endpoints.
• ASP.NET and HTML used to change the structure of web pages using webaptive the content management tool.
• Validating XML Responses using HTTP Poster/ Postman (Firefox/chrome plug-in).
• Automating the web services using Soap UI Pro.
• Adding Assertions, and Data Validation points in Soap UI to automate request and response validation.
• Developed SQL and PL./SQL scripts for ETL testing.
• UsedSQLqueries to extract data fromSQL Server, Oracledatabases.
• Assisted in creating fact and dimension table implementation in Star Schema model based onrequirements.
• Extensively used SQL programming in backend and frontend functions, procedures, packages to implement business rules and security
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked withperformance tuning of complex SQL queries.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process ofloading, pulling the data.
• Validated the data after running the batch process from different Mainframe systems.
• Tested mobile version of the website and mobile app.
• Tested POS system application on POS hardware and emulator.
• Maintained defect tracking and reporting usingJIRA.
• Documenting manual test cases using Quality Center, and maintaining test execution.
• Helped end users in performing UAT testing.
• Maintained and updated web service automation scripts using Soap UI Pro.

Environment: Soap UI Pro, Quality Center, HTML, JIRA, HTTP Poster, Postman Chrome Plug-in, SOAP UI, JIRA, Oracle, SQL Server, Microsoft Office Excel, Microsoft Internet Explorer, Microsoft Office Word, Windows XP, 7 & 8.

Confidential, Jersey City, NJ

QA Analyst

Responsibilities:

• Reviewing requirements and design documentation for clarity, completeness and testability.
• Interpreting complex business/data requirements and translating these into a comprehensive test plan.
• Responsible for providing Quality Assurance for a Fixed Income Trading System, developed on Java/J2EE platform.
• Responsible for documenting Test plan, Test cases, Test scripts as per Business rules for each release.
• Co-ordinate testing activities with onshore and offshore resources.
• Worked on the Functional Requirements gathering, design and implementation.
• Worked on streamlining of profiles in Salesforce by creating reports and analyzing them.
• Worked on configuration of the Salesforce applications according the new requirements.
• Worked on testing the Salesforce application for the new set of changes done.
• Extensive use of Quality Center for developing, managing and executing Manual Test scripts, and defect tracking.
• Automate Functional and Regression tests using LISA middleware testing tool and QTP for web testing.
• Determine product line readiness and recreate customer reported issues for development review.
• Performed Data Migration and Support of Salesforce CRM.
• Involved in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews.
• Performed data validation testing writing SQL queries.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Write Java classes in LISA to perform white box testing for JAXRPC services - White Box Testing.
• Extensive use of UNIX and Windows Shell Scripts - White/Gray Box Testing.
• Extensive use of SQL queries to extract data from Oracle, SQL and Cache database - White/Gray Box Testing.
• Being a liaison between Business Analysts, the development team, and other stakeholders of systems issues/concerns.

Environment: LISA 5, Soap UI Pro 3.5, Quality Center 10, Quick Test Professional 10, Java, MS SQL Server, Cache db, Microsoft Office Excel, SalesForce, Siebel, Microsoft Internet Explorer, Microsoft Office Word, Windows XP.

Confidential, Jersey City, NJ

QA Analyst

Responsibilities:

• Wrote Test Cases, and detailed Test Scripts after reviewing Requirements and Specifications documentation.
• Managed Test Cases and Requirement Traceability Matrix using Quality Center.
• Wrote Java classes to perform white box testing.
• Wrote scripts in Linux environment and Windows Shell Scripts.
• Used SQL queries to extract data from SQL Server, Oracle databases.
• Used Microsoft Excel extensively to store the extracted data from the database, and analyze it.
• Used LoadRunner for Performance and Load Testing.
• Verification of functional correctness and completeness of mobile application SW within component project level according to its requirements specification
• Worked on informatica to resolve production issues perform testing and debugging of mappings and reports Extraction of test data from tables and loading of data into SQL tables.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Very good exposure of testing applications on wide range of Mobile handset of different vendors which includes Nokia, Samsung, Google G1, Sony Erricson, Motorola, Windows Mobile, HTC, LG, Iphone and many more.
• Expertise of testing the application developed using various mobile technologies including J2ME, Blackberry, Andriod, Symbian, .Net Technology etc.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Confirmed database integrity using SQL queries.
• Created the database schema and set up Oracle to work with it.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Worked with data validation, constraints, source to target row counts.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Monitored the Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions.
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
• Used TOAD, DB Artisan tools to connect to Oracle Database to validate data that was populated by ETL applications.
• Involved in testing Unix Korn Shell wrappers to run various ETL Scripts to load the data into Target Database (Oracle).
• Maintained defect tracking and reporting using PVCS Tracker with vendors.
• Helped end users in performing UAT testing.
• Acted as a database and Linux admin.
• Acted as a liaison between Business Analysts, the development team, and other stakeholders of systems issues/concerns.

Environment: Quality Center 9.2, Quick Test Professional 9.2, PVCS tracker 8, LoadRunner 9.1, Java, Eclipse, Oracle 9i, Informatica, Toad, Microsoft Office Excel, Microsoft Internet Explorer, Microsoft Office Word, Windows XP.

Confidential, New York, NY

QA Analyst

Responsibilities:

• Collected the software requirements and specifications.
• Analyzed software specifications to gain a better understanding of the application.
• Used Quality Center to define and develop test plans and test cases.
• Responsible for documenting Test plan/Test cases/ Test scripts as per Business rules for each release.
• Prepared test cases that provide detailed list of conditions under which the system will be tested.
• Created GUI checkpoints for verifying object properties.
• Designed and implemented basic SQL queries for QA testing and report/ data validation
• Involved in extensive DATA validation using SQL queries and backendtesting.
• Used workflow manager for session management, database connection management and schedulingof jobs.
• Thorough knowledge of mobile platforms such as Android and iOS.
• Creating the catalogs and analyzing the joins.
• Extensively used Informatica power center for ETL process.
• Tested the application oniPadandiPhonewhen the operating system was unveiled and made sure the application was enhanced to be compatible with theAndroid devices
• Involved in validating the ETL mappings from various systems(CRM,OLTP) to transactionhistory/reporting database.
• Involved in validating the Informatica mappings from OLTP servers/databases into the stagingtables using reporting platform to new management personnel.
• Performed in system testing, regression testing, security testing, performance testing and usability testing.
• Writing detailed test descriptions in accordance with the Use Cases Design.
• Maintained defect tracking and reporting using Quality Center.

Environment: Quality Center, Quick Test Professional, Load Runner, Microsoft Visual Studio, SQL Server, Informatica,SSIS, MS-word, MS-Excel, Windows XP Professional.