Charanpreet Singh Sr. QA Lead

718-***-****

adoyaz@r.postjobfree.com

Summary

Over 21+ years of experience of Web, Client/Server, Legacy and/or Mobile based applications. Conversant with all phases of Software Development Life Cycle (SDLC) including Requirement gathering, Analysis, Design, Development, Implementation, Testing, Software quality standards, configuration management, change management, Quality procedures and effectively interpret Requirement Documents in most of the current Methodologies like Agile, XP, Stagnant, Waterfall etc.

Results-driven and hands-on leader with a unique combination of technical expertise, analytical problem-solving ability, strong interpersonal and communication skills, and management proficiency. Participated in Tool Selection team for evaluation and creating the Road Map.

Experience with various domains like NYC Govt. Agencies, Financial, Insurance, eCommerce and Health Care Industries. Focused on delivering high-quality, high-performance solutions in a timely and cost-effective manner. Endeavor to excel at every task.

Excellent professional skills in preparation of Test Strategy & Plans, test cases, Test Scenarios, traceability matrices and executing test cases manually and using automated testing. Prepared the different Test Scenarios and Test Suites for better QA efforts and coverage including User Stories and Use Cases based on Functional Requirement Documents

Experience includes the testing of Legacy, Client/Server and WEB based applications using Testing and Test Management tools like HP-QC(ALM), Quick Test Pro (QTP/UFT), HP-Load Runner, Selenium, SharePoint, JIRA and many more.

Extensively involved in Architecting Test Suites for Smoke Testing, Functional, Regression, System Integration, Security, Performance and End-to-End Testing, furthermore coordinating UAT efforts along with preparing Test Data.

Architected Data Driven, Keyword Driven, Test Driven, Modular Driven and Behavior Driven Frameworks for QTP/UFT and/or Selenium Automation scripts with POM(Page Object Model) and/or AOM (Automation Object Model), VB-script, MS-Excel, HP-QC/ALM, DevOps.

Proficiency in Web Service Testing using SOAP UI, manual and as well Automation Groovy Scripts Designed & Executed.

Expertise in Selenium, WebDriver, Objet Oriented Programming (OOP) Java, JavaScript, Eclipse(IDE), etc. Creating APIs, Frameworks interacting with JSON, XML etc. file formats and interacting NoSQL, Document based Database, MongoDB etc.

Widely involved in System Integration Testing frameworks including various ERPs, Mobile Devices, POS systems, AS400 etc.

Well Skilled in Data migration testing procedures and participating in designing, planning and review meetings

Participated in Daily Scrum meetings, Sprint Task Planning, Retrospective and Sprit review meetings, as part of QA efforts in Agile Methodology. Proficient in various Defect tracking tools to tracked, reviewed, analyze the root cause and follow complete Defect Lifecycle using like JIRA, Quality Center/ALM, SharePoint, TFS, Test Director etc.

Expertise in management reporting using the Requirement Traceability Matrix (RTM), Daily/Weekly Status Reports, Defect Reports and Project Reports, following up in the version controlled environment.

Interacting with Analysts, Developers and other project team for investigating the root cause, Defect Fixes and Problem resolution.

Strong Oracle and SQL Server skills for generating Automation or Manual scripts in order to perform Database testing, generating reports and Experience in writing SQL queries using Joins (inner and outer) and sub-queries.

Ability to work with minimal direction – taking concept to analysis and potentially in QA through development, debugging, testing, defect documentation, regression and conclusion. Mentoring Team members for adequate, efficient and effective Manual & Automation QA efforts.

Establish and maintain productive working relationship with Management, Clients and Team Members. Self-starter, entrepreneurial, highly motivated team player with excellent communication / problem-solving skills. Capable to quickly learn new technology and adapt to a new environment.

Education: BS in Computer Science

Technical Skills

Quick Test Pro/UFT, Win Runner, Quality Center/ALM, HP - Load Runner, SOAP UI, Docker, Selenium, Test Track Pro, UNIX, Linux, Windows, Oracle 9i, SQL Server, Sybase, Docker, Container Orchestration, MongoDB, NoSQL, MySQL, JAVA, DynaTrace, Visio, SQL, PL/SQL

Professional Experience

ConEdison, NYC March 2019 - Present

Designation: Sr. QA Lead/Automation Architect: One of the world's largest energy delivery systems, and provide electric, gas, and steam service for the 10 million people who live in New York City and Westchester County. System integration, Data integrity and application flow among Legacy applications and Web applications.

CIT Group, NYC July 2016 – Feb 2019

Designation: Sr. QA Lead: The Group's principal activities are to provide insurance, investment, mortgage banking and consumer financing services. The internet and other distribution channels across North America and elsewhere internationally. Post-Close project which consisted of migration from various legacy systems to a common platform that can be utilized by all CIT Group line of businesses.

DSNY - The City of New York Department of Sanitation (SMART) March 2014 - June 2016

Designation: Sr. QA Lead: The Smart Operations Board is a project to automate existing paper daily operations board used at all District and Borough locations throughout DSNY. The current Operations Board has come to pass over a 100 years of operation experience. There are many subtle rules, procedures and processes that must accounted for and built-in to the SMART Web Application. DSNY key operation system, the Web Application must be built as robust and scalable enterprise-level system and replace the Day-to-Day Paper system.

HPD - NYC Department of Housing Preservation & Development (311) May 2013 - Feb 2014

Designation: QA Lead: Department of Housing Preservation and Development (HPD) integrated with 311 Online Customer Service Integration Web Application involves NYC cross agency project including HPD internal Online and Client-Server based Legacy Application.

SCA - NYC School Construction Authority (PTS) Sept 2012 – April 2013

Designation: QA Lead: Various Legacy Applications were transformed in to Centralized Web Application, Created QA Team from ground up. Designed Frameworks for Automation and being mentor and review tasks/scripts assigned. Involved in the gathering of specifications, and requirements with SME’s, developers. Interacting with the client on the problems related to business process and functionalities and impart functional knowledge to the QA team. Periodically generate the QA execution, defect analysis reports for higher management.

TD Bank, Mount Laurel, NJ Jan 2012 - Aug 2012

Designation: QA Lead: As QA Lead, responsible for management of all Quality Assurance efforts includes planning, strategy, testing execution and tools. Ensure that QA process is documented and communicated and adequate to ensure agreed quality levels for the application. Ensure traceability of test cases to requirements, working with the project Business Analyst to ensure all requirements are tested. QA issue prioritization and resolution facilitation. Provide formal sign-off on all testing deliverables and events.

Farmers Insurance, LA, CA Sep 2010 – Dec 2011

Designation: QA Lead: Farmers Insurance is one of the world’s largest financial institutions with their prime area of business being Insurance. As a QA Tester, I was involved in testing various interfaces and conducting Functional testing. This application enabled customers to buy online Auto insurance, get a free quote, report the claim or view the claim, make online payments, chat to customer service and manager their policies

Bank of America, Jersey City, NJ Jan 2009 – Aug 2010

Designation: Sr. QA Analyst: Involved in analyzing Business requirements/Product Design documents, specifications and development of Test Scripts, Test Cases and executing & reviewing them. Performed Functional, GUI, Regression, System Integration, User Acceptance, Configuration and content testing for web-based e-Commerce application and Content Management System. Implemented Extensive SQL queries to verify the Data Integrity. Responsible for creating automation scripts by using QTP with Data driven testing framework. Created Automation framework for Custom Build CRM tool. Acted as a facilitator and liaison between the business stakeholders and the development team, aligning each others’ expectation of the final product, suggesting and visualizing the solution to the business team, and providing technical insight that helps the business team to decide on achievable, realistic solutions.

Cardus Inc, Farmington Hills, MI Mar 2007 – Dec 2008

Designation: Sr. QA Analyst: Involved in all stages of Software Development Life Cycle from requirements gathering to post-production. Involved and responsible for creating and reporting daily status reports regarding the progress of testing process and sent status updates to Project Manager. Have participated in Requirements Walkthroughs, Defect Review Meetings, and Status Meetings. Performed Manual Testing and localization testing (as part of data validation) for testing functionality

First Citizens Bank, Annapolis, MD Apr 2006 – Feb 2007

Designation: QA Analyst: Extensively involved QA Efforts for Web Application of Customer online Mortgage transactions, Mortgage Calculators, Home buying and Refinancing. Developed System Test Plans, Test cases and Test Scripts. Tested all jobs, software modules, Database interactions, all external interfaces, all features of the application and end to end functionality as part of System/Functional Testing. Verified Test data validity with SQL queries. Performed Regression and System testing by executing the test scripts using QTP. Experienced in writing VBscripts, Developing Framework, Creating Shared Object Repository.

Fleet Credit Card Services, Horsham, PA Jan 2005 – Mar 2006

Designation: QA Tester: Project: Online Credit Card Services - Fleet is a leading small business and commercial banking provider in the Northeast and a premier provider of financial services to the selected industries nationwide. The credit card holder could log into the website and could pay the bill online by enrolling bank account, access the statement history, get rewards information on the credit cards

PT-1 Communication, Inc (W2) New York City, NY March 2000 - Dec 2004

Unified Raw Data Processing Project (Java Application), Dial Plan, L.E.R.G Lookups (Web Application) And CDR Search Project

These projects involves the striping and massaging the Raw Text Files and further update the Database. The text files consists the different layouts in the same file. Files received are the plan text files, stripping and the processing is done in Java based on the given layout, in which the front end was GUI based, Applets as Client side applications, ODBC-JDBC bridge was used to access and update the database Pervasive. Then run the reports on it using Crystal. Extensively used Active Data Objects (ADO) to interact with the MS-Access 2000 database was used for data storage MS Internet Information Server (IIS) was used on Windows NT 4.0 as a web server.

Contact this candidate