We provide IT Staff Augmentation Services!

Sqa Consultant Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • Over 10 years of IT experience in Testing, Problem Resolution and Implementation of various software projects.
  • Expertise in Automated Tools (Quality Center, ALM (Application life cycle Management), QuickTest Pro and SOAP UI), Manual, Black Box, White Box, Functional, Integration and Regression testing.
  • Excellent understanding of Software Life Cycle and importance of QA in development and maintenance of software applications.
  • Experience in testing non-GUI applications (SQL, Flat Files, XML etc.)
  • Extensively used XML for web service testing and sql and unix scripting for testing commerce back-end jobs.
  • Strong knowledge in securities processing, Order Management Systems, JMS queue processing and e-commerce marketing tools to manage product catalog, pricing, targeted marketing and promotions
  • Experience testing service based web applications (SOAP, REST)
  • Experience testing web pages on mobile devices (IPAD, Android...)
  • Experience in Agile/Scrum methodology
  • Experience in MS Excel Macro development
  • Expertise in project management - Determine project scope and business requirements, estimate schedules, track item completion, manage QA resources allocated for project, maintain project documentation and project status, review test-support software for automation

COMPUTER SKILLS:

Languages : C++, C, C#, Java, Power Builder, Shell (ksh), Sql scripting, Word, Excel.
RDBMS : ORACLE, SYBASE, MS SQL Server, ACCESS
Testing Tools : Soap UI, WinRunner 7.0, LoadRunner 7.5, Mercury Quality Center,Quick Test Pro, Manual Testing.
Web Technology : JSP, J2EE, IIS 4.0/5.0, CSS, HTML, XML, MicroSoft Visual Studio .Net 2003, ADO.NET, ASP.NET, Web Services.
Operating Systems: Linux, AIX (4.2), SUN SOLARIS, Windows 2000, XP & NT

EXPERIENCE:
SQA Consultant - Confidential, NJ (Oct 2012 - Present)
Client: Pro Services
Environment: VS .NET 2010, C#, Web Services, Oracle and MS SQL Server
Project - Redesign existing in house software product with new GUI, new internal service objects and change underlying DB structure to support new requirements

  • Tested Installation of product on both physical and virtual machines with different configurations to support multiple client requirements.
  • Creating a separate QA domain to better emulate client environments, administered the domain, including MS Virtual Server images
  • Manage test project using Agile / Scrum methodology
  • Develop Test process documents and test procedures for System Analysis.
  • Develop test plan, test cases with detailed procedure for validating web based .NET applications
  • Create project status reports for use in reporting test progress and project status during QA cycle

SQA Consultant - Confidential, NYC (Feb 2012 - Sep 2012)
Environment: Linux, Java 1.5, Jboss, Oracle 10g, Informatica, Mainframe IMS, QTP, JMS queues, XML
Project - Securities Modernization Migrating legacy batch and online jobs to new Java based platform. IMS data is converted and imported to oracle DB and old GUI is replaced with new java based service orientated GUI

Analyzed business flow of the application and develop test plan and supporting test cases and scripts. Test scripts are written using keyword driven frame work called UTP which uses QTP as execution engine. This scripts can be executed both manually and automated way. Co-ordinate functional, regression, automation and load test. Attend daily status meetings with project managers, tech leads and business analysts of the project
  • Data conversion validation - Wrote SQL scripts for validating the data conversion from IMS to oracle DB. Verified the data import scripts form IMS to Oracle
  • Comparison testing - Created test data files for comparision testing of legacy Vs new system. Output from two systems is compared by feeding same test data and prod data. JMeter was used to send input messages to JMS queue

QA Lead - Confidential, NJ (Aug 2006 - Dec 2011)
Environment: Linux, Java 1.5, JMS, Jboss, Oracle 10g, SOAP, XML, Ruby, ATG
Project - Online Commerce Systems and Web for one of the world\'s largest paid for content subscription sites, The Wall Street Journal and Barrons managing over 1mil customers annually.
Commerce system handles back-end billing and finanace related cron jobs and front-end web application for registration, login/logout, user interactive account management, self service and customer service web interface.

QA lead for following projects in ecommerce group
Commerce evolution project - Migrate commerce apps running on Solaris env to
new Linux env, Oracle upgrade from 8i to 10g and new web based registration front end with service based architecture.

Mosiac Project - Verify database triggers implemented for migration of customers, JMS queue processing and provisioning services using SOAP UI tool before integrating the services with other applications. Test new POMs ATG tool (Product and offer management) and create test offers for QA team to verify the offer set up before production implementation

Legacy subscriber migration to new Mosiac platform - Verify subscriber data after migration in new fulfillment and billing system.

Analyzed business flow of the application and develop test plan and supporting Test cases and scripts. Co-ordinate functional, regression, automation and load test. Attend daily status meetings with project managers, tech leads and business analysts of the project. Test Rest Services functionality through soap UI before integrating services with different applications. Verify each operation supported by the service giving various XML input values and validate the service output returned by the service Identify automation load testing scenarios and analyze stress test results. Write automation requirement and assign them to offshore team in India. Support vender recommended security patch's on production/test servers on quarterly basis. Quality Assurance Analyst - Client: ETS Princeton (January 2005 - Aug 2006 )

Environment: Java, JSP, Oracle 9.2, SOAP, XML, Actuate tool for reports.

Create Test case Matrix, Datasets and Test scripts based upon detailed Use Cases, Specification and Requirements. Execute Integration, Functional and Regression testing within the Development environment using both manual and automated test scripts within an Intranet web interface utilizing Silk 7.0. Wrote SQL scripts to verify ETS financial reports. SQL Data manipulation/verification using TOAD. Signoff on Pre-Admin and Post-Admin testing to the System Test organization.

QA Analyst/Developer - Confidential, NJ (Aug'2002 - Dec' 2004)
Environment: VS .NET 2003, C#, ASP.NET, Crystal Reports, VB.NET, IIS 5.0, CSS,
MS SQL Server

Analyzed business flow of the application and developed test plan and supporting test cases and scripts. Ensured conformance to QA entry and exit criteria. Performed Load Test using Load Runner Created, executed and validated automated test scripts using WinRunner and QuickTest Pro based upon the system requirements. Recording of test scripts was performed using TSL, C language designed for creating scripts. The GUI objects and Bitmaps were checked, Visual Programming was used to add functionality and logic to the test scripts Identified and documented defects in Test Director when performing test execution and followed-up with developers until all issues were resolved. Communicated with management team about client concerns, project status, and pending changes in business needs. Client :KPMG

Projects:

  • ADT is a web based Advisory Delivery Tool that offers practical advice and

assistance depending on the business segment to enhance business processes
and controls to manage these risks and maximize the likelihoodto meet it objectives.
This application is developed with Visual Basic .Net Technology and MS SQL
Database.

  • Created User Controls for site navigation. Data Grids were used to display data from database. Wrote SQL queries and stored procedures. Developed and maintained user documentation and validation test scripts. Practiced coding standards that are readable, modular, understandable and easily modifiable.

Systems Engineer, Confidential, NJ (Jan'99 - JUN'2001)
Environment: C, C++, Power Builder, JAVA, Oracle.

  • Involved in the Design and development of CAD Project(Computer Aided Dispatch System)
  • Developed Test Plans and Test Cases and performed Manual Testing.
  • Performed automated testing using WinRunner for some modules
  • Interacted with Developer, Network administrator and Database Administrator to resolve application issues.
  • Participated in system Enhancement, Modification and maintaining GUI Standards.
  • Created a Database in Access to perform Defect Tracking.
  • Used MS Excel to report Test Results and Summary.
  • Used SQL quires to verify data in the database.
  • Developed and maintained many Unix scripts using Perl and Ksh for extraction and BCP between servers with extremely large Databases. These Scripts are used to generate Management Reports and will run everyday from Cron.

Projects:

  • CAD (Computer Aided Dispatch system) used by New York Fire department (FDNY), this application was used by fire house personnel after an fire engine has been dispatched and was developed using JAVA as a Front End and Oracle Database as backend running on RS 6000 machines with AIX 4.2 operating system.
  • Worked on MAP of New York City used by Fire Department. This application was developed using C. It has capabilities like locating the Fastest Path, Zoom-in, Zoom-out, etc.
  • UPENN application used by University of Pennsylvania security system personnel to Sign in, enter number of hours on duty, sign off etc. This application front end was developed in Power Builder and with Oracle 8 on the back end.

Projects:

  • Designed and developed electronic checkbook in C++, which functions like a bank\'s ATM machine, on RS6000 (AIX). Implementation involved basic class, derived class, friend functions, operator overloading and much more.
  • Designed and developed a systems program in C, which keeps track of the process in the system by maintaining a queue of the process and allocating a time slice of CPU for each process until the process is finished. This is like a simulation of UNIX functionality on a PC.

Education:

  • Completed 16 credit hours towards MS in Computer Science
  • BS Mathematics

Personal Information:

  • U.S Citizen.

We'd love your feedback!