Testing Sql Server
Resume:
NIRAV MEHTA
SUMMARY:
A challenging position, utilizes my technical skills, educational experience and accomplishments in the field of IT, where innovation is appreciated and growth is ensured.
PROFESSIONAL SUMMARY
• 9+ years of Quality Assurance experience in planning, coordinating and performing White box Testing, Black box Testing, Grey box Testing, Validation Testing, Unit Testing, Functionality Testing and Integration Testing, User Acceptance Testing (UAT) with large-scale applications with multiple interfaces.
• 3+ years of experience in Team leading for QA Projects.
• 4+years of experience in Internet Web testing and Client-Server Testing.
• 4+ years experience in System Testing on Web based and client Server application.
• 2+ years of experience in mainframe testing. Used Toad to query different databases.
• 6+ years of experience in back end testing using SQL Query Analyzer and SQL developer for SQL server and Oracle database.
• Tested application on Mac, UNIX, windows 2000 and XP for performance and functionality.
• 3+years experience in developing test scripts and testing them with automated testing tools.
• 3+ years of experience in testing application using WinRunner, LoadRunner, QuickTest Pro and Test Director.
• 6+ years of experience in testing application using Quality Center.
• 2+ year of experience in testing application using Rational Tools like Robot, Test Manager, ClearQuest.
EDUCATION QUALIFICATION:
• Master of Science in Computer Science, NYIT, Old Westbury, NY. – May 2002
• Bachelor of Engineering, LD College of Engineering, India. – July 1999
SKILLS:
Operating System : Windows 2000/NT, MS-DOS, UNIX.
Testing Tools : Quality Center 8.0/9.0,9.2,10.0, Mercury Win-Runner 7.5/7.0,
Mercury -Quick test 7.2, Mercury -Test Director 7.5/6.0/5.0, Mercury Load-Runner 5.0/6.0/7.0/7.5, QuickTest Pro 8.0/9.0, Rational Tools like rational robot, clearquest, requisite Pro, Test Manager
Configuration Tools : Visual Source Safe, LDAP, MQ-Workflow, Install shield V build
Development Tools : Visual Studio Environment, Visual InterDev6.0, Crystal Reports 8.5
Languages : Visual Basic 6.0, VBA, ASP, PHP, .Net, C-sharp, DHTML, Java, XML
Database : SQL Server 7.0 /2000/2005/2007, Oracle 10i, Access 2000, Siebel, Power Builder
Data Transformation : ETL, ESB (Enterprise Service Bus)
Microsoft Technologies : Active-x, COM/DCOM, MS-Exchange
Web Servers : Apache, IIS, Exposure to Oracle Web Application Server
Documentation Tools : MS-Project, MS Office Suite(Word, Excel, Power Point), Visio 2000
Application Servers : Web logic with ILOG rule
Bank of America, Jersey City, NJ March 2010 – Current
Position: QA Lead
Project:
The objective of this project is to define a solution for the deployment of Point of Presence 1 (POP1) to support delivery against the key business drivers as follows:
• Enable replication of the Product reference data from its current Product Master Environment (PME) to a self-contained POP system using real-time deterministic replication
• Create a real-time synchronized, mirror copy of the Product reference data within the POP
• Create a data delivery fabric for the Product reference using data services layer which supports Request / Response style of interactions
Environment: Oracle, XML, MQ Series, EMS, JAVA, TIBCO Business Works, UNIX and Windows Operating System.
Job Responsibilities:
• Lead QA Team for Testing for WebServices of Equity, Mortgage Pools, Future & Options, US Listed Options, Fixed Income, CMOs Reference data via HTTP/EMS technology.
• Developed of Test Plan, Test strategies, Traceability Matrix to meet all business requirements.
• Coordinate with QA Team to develop Test Conditions, Test Scripts, Test Data and review them
• Coordinate with Management Team, BA Team to discuss issues of QA Cycle and Overall Project.
• Coordinate with QA Team and Complete QA Project on time.
• Developed, measured, and reported QA project plans with detail schedule and status with MS-Project 2007
• Helped management in resource allocation of QA and ensured efficient use of QA resources across all projects
• Maintain Tracker Sheet that includes any risk/issues/clarifications using Sharepoint.
• Performed analysis on defects and work to improve quality using Quality Center and JIRA.
• Participated in meetings on a day-to-day basis with QA team to discuss the issues arising while test preparation or test execution.
• Participated in meetings on a weekly basis with Developement team to discuss the issues/clarifications arising while test preparation or test execution.
• Lead QA Team for Automation Testing for Webservices testing and make sure Automation framework created based on requirements.
• Lead QA Team for Performance Testing for Webservices testing and make sure Performance and Load Testing requirement covered.
Project:
The Fusion initiative is Bank Of America’s next generation strategic reference data repository for financial instrument (product) data. This initiative is necessary to ensure Company’s strategic repository can fully support all aspects of Company’s business including Front, Middle and Back Office applications.
Environment: Oracle, XML, ETL, MQ Series, Autosys, ASP, JAVA, UNIX and Windows Operating System.
My Job Responsibilities:
• Lead QA Team for Automation Testing for Equity, Mortgage Pools, Future & Options, US Listed Options, Fixed Income, CMOs feeds of different Vendor like Bloomberg, Reuters, etc using Inhouse Application called TCM.
• Coordinate with Management Team, BA Team to discuss issues of Automation QA Cycle and Overall Project.
• Coordinate with QA Team and Complete Automation QA Project on time.
• Maintain Tracker Sheet that includes status of each feed validation as well as regression functionality validity of each feed through Automation using Sharepoint.
• Performed analysis on defects and work to improve quality using Quality Center and JIRA.
• Developed of test strategies, plans and Traceability Matrix to meet all business requirements.
• Participated in meetings on a day-to-day basis with Implementation and Development team and QA team to discuss the issues arising while testing.
• Prepare all test data of each vendor’s feed based on mapping Specifications to perform Manually testing.
• Manually Testing of Equity, Mortgage Pools, Future & Options, US Listed Options, Fixed Income, CMOs feeds of different Vendors using UNIX and Oracle Toad.
• Performed Batch Jobs validation of different Vendor Data using AutoSys as well Manual.
• Performed Testing for Monthly Production Releases.
Project:
Global Relationship Capital Intelligence (GRCI) applies the science of social networking to the enterprise to create new business intelligence. This application enables and further empowers users to identify and provide deeper insight into client boards and senior executives leveraging and monetizing the Firm's relationship capital.
Environment: Oracle, XML, ETL, Autosys, ASP, JAVA, UNIX and Windows Operating System.
My Job Responsibilities:
• Analyzed Business & User requirements and wrote Test plans, Test Scripts, Traceability Maxtrix and Reporting using Quality Center.
• Developed of test strategies, plans and Traceability Matrix to meet all business requirements.
• Participated in meetings on a day-to-day basis with Implementation and Development team and testing team to discuss the issues arising while testing.
• Performed Data validation of Enhancement Testing as well as Integration Testing using ETL Tool (Informatica)
• Performed UI validation of Enhancement Testing as well as Integration Testing.
• Performed XML data validation between Vendor Data to GRCI Application using XML Spy and Oracle Toad.
• Performed Batch Jobs validation of different Vendor Data using AutoSys as well Manual.
• Developed and Executed SQL queries in SQL server as well as Oracle Database to perform Back End Testing and Grey End Testing.
NJM, West Trenton, NJ Sept 2008 – Feb 2010
Position: Sr. System Test Engineer
NJM (New Jersey Manufacturers Insurance Company) is insurance company which provides insurance for Workers' Compensation, Commercial Auto, Personal Auto, Home Owners, Renters, etc. Project is based on migration of Mainframe Applications (Account Payables (AP), Account Receivable (AR), General Ledger (GL), Asset Management) to PeopleSoft Financial Tools which includes PS AP, PS AR, and PS GL)
Environment: Oracle, SQL Server, XML, ETL, ESB, PeopleSoft, Xpression, MQ Series (RFHUtil), Windows Operating System, Main Frame System.
My Job Responsibilities:
• Analyzed Business & User requirements and wrote Test plans, Test Scripts for testing different functionality of the application, Test Coverage using Quality Center.
• Performed Smoke Testing, Functional Testing, Validation Testing, Integration Testing, Negative and Positive Testing.
• Responsible Agile development and testing in SCRUM framework.
• Created Traceability Matrix to check that all business requirements were met.
• Participated in meetings on a day-to-day basis with Business, Production Support, Implementation and Development team, to discuss the issues arising from the previous days testing (Functional/ Regression).
• Performed System testing for NJM's new financial system PeopleSoft/Oracle Financials which include following components: General Ledger, Accounts Payable, Accounts Receivable and Asset Management.
• Performed System Conversion Testing of Existing Financial System (A/R and A/P on the mainframe and G/L from a third party package, SunGuard) to PeopleSoft Financials.
• Performed Data validation of System Conversion Testing as well as Integration Testing using ETL Tool (Informatica)
• Performed Data validation of System Conversion Testing as well as Integration Testing using ESB.
• Performed XML data validation between Transformation of ESB to PeopleSoft Financials using MQ Series (RFHUtil).
• Performed application programming interfaces (APIs) Testing for different interfaces among Financial System.
• Performed Check Printing Process using XML and third party tool Xpression..
• Performed Image Scanning Process using third party tool Kofax.
• Performed Image Capturing Process using third party tool Onbase.
• Performed Grey box testing of Enhancements of PeopleSoft Financials System.
• Developed and Executed SQL queries in SQL server as well as Oracle Database to perform Back End Testing.
IBC, Wayne, PA April 2008 – Sept 2008
Position: QA Lead
Independence Blue Cross (IBC) has offered quality health care products and services designed specifically to meet the changing health care needs of customers. Project is based on their IVR system enhancements of Customer’s claims.
Environment: .net, Java, Oracle, SQL Server, XML, Windows Operating System,
My Job Responsibilities:
• Analyzed Business & User requirements and wrote Test plans, Test Scripts, defect matrix and Reporting using Quality Center.
• Developed of test strategies, plans and Traceability Matrix to meet all business requirements.
• Participated in meetings on a day-to-day basis with Implementation and Development team and testing team to discuss the issues arising while testing.
• Lead QA Team for Enhancement of IVR Projects.
• Coordinate with Management Team, UAT to discuss issues of QA Cycle and Overall Project.
• Coordinate with QA Team and Complete QA Cycle on time.
• Performed analysis on defects and work to improve quality.
• Reviewed and Understood IVR Scripts based on Designed flow diagram of Business Process through VRU.
• Created Scripts in Quality Center for VRU testing based on Business Requirements.
• Performed Manual testing of VRU which included Call routing, Call monitoring.
• Positive and Negative testing of VRU based on Business Requirements.
Access Group, Wilmington, DE Aug 2006 – March 2008
Position: Sr. QA Analyst / Lead
Access Group, a non-profit Graduate Student Lending Organization. Major Project which I worked here was newly launched Website with new features and new look , their Origination and Disbursement System, Yearly Enhancement of Marketing Strategy Projects, Worked on VRU System of Loan Process, Recently newly Implemented Origination and Disbursement System - reconciliation of migrated data into new line of business vendor package (AppWorks by vTek).
Environment: .net, Java, Oracle, SQL Server, Siebel, Power Builder, PHP, XML, Windows Operating System, Main Frame System.
My Job Responsibilities:
• Performed Manual Testing, Automation Testing, GUI Testing, Functional Testing, User Acceptance Testing (UAT), Validation Testing, Integration Testing, Negative and Positive Testing.
• Analyzed Business & User requirements, Designed and created Test plans, Test Scripts using Quality Center.
• Assisted QA Manger throughout project lifecycle.
• Lead QA Team for Enhancement Projects and Web Changes Projects.
• Coordinate with QA Team and Complete QA Cycle on time.
• Coordinate with Management Team, UAT to discuss issues of QA Cycle and Overall Project.
• Performed Web testing with XML which includes Manual Testing as well as Automation Testing.
• Performed Web testing for functionality provided for Users for Loan Applications.
• Reviewed and Understood IVR Scripts based on Designed flow diagram of Loan Process through VRU and Created Scripts in Quality Center for VRU testing based on Business Requirements.
• Performed Manual testing of VRU which included Call routing, Call monitoring.
• Positive and Negative testing of VRU based on Business Requirements of Loan Process include Loan Status, Credit Status, etc.
• Performed White box Testing of Origination and Disbursement System.
• Performed API Testing of different interfaces.
• Developed automation scripts using QuickTest Pro (QTP)
• Inserted Check Points and Synchronization Points in TSL Scripts for checking GUI feature and data storage / Record Update Verification using QuickTest Pro (QTP).
• Very good exposure in QuickTest Pro (QTP) for Data Driven and GUI, Bitmap check points.
• Used and built regression test bed.
• Managed Quality Center Admin to maintain User Settings and other settings.
• Participated in meetings on a day-to-day basis with Business, Production Support, Implementation and Development team, to discuss the issues arising from the previous days testing (Functional/ Regression).
Bank of America, Wilmington, DE Feb 2005 – July 2006
Position: Sr. QA Analyst
Bank of America Corporation is a full-service investment bank and brokerage firm. Bank of America Securities provides equity underwriting, acquisition financing and advisory, trading, private placements, senior loans and loan syndication, municipal finance, high yield and investment grade debt issuance.
Environment: .net, Java, Oracle, SQL Server, XML, FIX Protocol, Windows Operating System, UNIX
My Job Responsibilities:
• As a QA Analyst, my job was to test software upgrades to be compliant with business and functional requirements.
• Wrote test cases and test plans for New Account Applications, Request Wire Transfer to Bank, Electronic Funds Transfer in Account Services, Marginal Call requirement notification modules
• Wrote PL/SQL /Complex SQL queries for system testing
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Supported documentation efforts for active account compliance for day-trading margin and equity requirements, client’s notification of day-trading minimum equity compliance, account designation as day-trading/ non day-trading.
• Manually created FIX text messages and Manual evaluation of test results log files.
• Understood front office Equities Trading flows and setting up the FIX QA environments for the same, documenting same in Visio or MS office tools. Automate the process wherever feasible. Tested the same for FIX client on boarding
• Worked with strong team of professionals on reliable, high performance FIX systems. Designed and implemented FIX solutions for on-boarding FIX clients globally.
• Worked with business development team on issues of streamlining testing effort for upgrades, added functionality and new futures of online trading system
• Executed and recorded results of test cases using QTP as the tool
• Interacted with developers to report software bugs and re-tested the fixed issues found during UAT.
• Created process flow diagrams for third party vendors system and interaction with Ameritrade Holding Company internal reporting systems.
• Involved in Integration testing, UI, UAT, Functionality testing & Performance testing.
• Worked with automation test team to data drive the process of Equity Order ticket entrance in to the system for margin account for equities with special margin requirements as well as monitoring against non-margin able securities and/or stocks available for shorting
• Tested Equity Orders entrance in to the system for short-sell orders to be in compliance with SEC regulation of short-selling IPO’s.
• Identified data and reporting requirements needed to support business units, answer key questions from end users, recommend customizations or enhancements, review vendor feeds and interfaces.
Bethpage Credit Union, NY May 2002 – Jan 2005
Position: QA Analyst
Bethpage Federal Credit Union is a full-service financial institution. Projects mainly include their Web online system changes with new features (Real Time) for Brokerage Services, Mortgage, Home Equity, Automobile and Debt Consolidation. Modification implemented in their in-house Product for Internal Use.
Environment: .net, J2EE, XML, and C++ embedded programming, Oracle, SQL Server, Linux and Windows Operating System.
My Job Responsibilities:
• Used Test Director for gathering requirements and later collecting feedbacks.
• Used Test Director to develop and implement the Test cases.
• Initially performed manual testing of each unit and then each build.
• Executed all test cases manually based on test scripts and validated results using SQL Queries.
from MTS document and test plans for the system.
• Performed Manual Testing, GUI Testing, Functional Testing, User Acceptance Testing (UAT), Validation Testing, Integration Testing, Negative and Positive Testing.
• Reported bugs in shared folders manually and using Test Director.
• Performed Web Testing using XML for Real Time functionality for Web Online features of Brokerage Services, Mortgage, Home Equity, Automobile and Debt Consolidation.
• Created Virtual User Scripts and performed LoadRunner Volume and Performance testing operations for GUI part.
• Developed and maintained Scripts using SQL *PLUS to test whether Data Integrity and Referential Integrity were being met
• Developed and Executed SQL queries in SQL server Database to perform Back End Testing using SQL Query Analyzer.
• Inserted Check Points and Synchronization Points in TSL Scripts for checking GUI feature and data storage / Record Update Verification using Win Runner.
• Developed automation scripts using Win Runner.
• Analyzed the results and prepared reports based on the performance of the application and worked with developers to resolve performance issues.
Contact this candidate