Kapil C. Makkar
(MBA, Certified Scrum Product Owner)
Phone: 214-***-**** (Cell)
mailto:acqjim@r.postjobfree.com
SUMMARY
Over 7+ years of professional IT experience in Quality assurance and programming and 5 years of experience in System administration.
Worked on different applications, products, client server, web based, middleware, backend, and internet applications using Quality center and QTP.
Analyzed the business/functional requirements and test results to make sure that requirements are met and existing system functionality/requirements are not broken.
Experience in writing Test Strategy, Test Plans, Test Cases and Test Scripts.
Proficient in manual testing on Windows and UNIX platforms.
An in-depth understanding of all the phases of Software Development Life Cycle (SDLC).
Proficient in different phases of testing like smoke testing, System Integration testing SIT (which includes functional testing, Performance testing, Integration testing and Regression Testing), User Acceptance Testing.
Excellent proficiency with UNIX operating systems and writing SQL queries.
Proficient in Performing Functional testing which includes Data Integrity testing, Application security testing, Regression Testing, Data Conversion testing on various applications in different environments.
Experience in testing Client Server and web-based applications.
Extensively involved in Back-end testing using SQL statements.
Experience in Bug Reporting Tools like Rational Clear Quest and Quality Centre.
Involved in developing and maintaining Test Matrix and Requirements Traceability Matrix and performing Gap Analysis.
Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product
Well versed with IT and Financial controls mainly SOX.
Excellent communication and interpersonal skills. Good team player and interact closely with members of cross-functional feature teams for product success.
PROFESSIONAL EXPERIENCE
Dec 2013 to ABB Ventyx
Present QA Manager
Domain: Power Distribution Solutions
Project: Distributed Management system (DMS)
Network Manager DMS is a series of integrated applications used by utility companies to improve and automate distribution operations. It provides operations, control and customer support, as well as a common platform for simple integration with other IS systems. Network Manager DMS consists of the Network Manager DMS databases and the client and server processes that write to and read from these databases. It consists of two main modules, ORMap and OMI. ORMap provides a visual display of the power distribution grid assembled from database data, along with visual icons that describe power network components, crews, various kinds of outages, and the status of each. The OMI (Operations Management Interface) is a set of Java-based applications that allow users to view and work with large amounts of database data in various ways, through the use of status lists and detail windows; and, when necessary, to update that data.
Responsibilities:
Manage day-to-day activities of QA teams, readiness of QA Environments and facilitate the execution of a results-driven Quality Management Process that is focused on continuous improvement and customer satisfaction.
Works collaboratively and proactively with QA Teams and Development SCRUM teams to design and develop effective solutions, troubleshoot issues and resolve bugs.
Own and create documentation that communicates the standards and procedures of a large QA Team.
Analyze software defects; conduct weekly bug triage meetings with development and product management.
Project planning, tracking, and delivering quality products on time.
Lead testing efforts for new releases and ongoing application development/maintenance. Manage and mentor Team of 25 quality analysts. Provide leadership and direction for QA/QTP Test Automation team responsible for designing test automation and supporting, planning, managing, maintaining, coordinating and executing the end-to-end test automation process for complex applications.
Define and document test strategy, test plans and test cases by evaluating functional and non-functional requirements.
Communicated vision, plans, status, issues and activities to all levels, from individual contributors up to senior management.
Define QA processes, guide team towards detailed test plans and clear executions with emphasis on working closely with development teams.
Prepare test plan documents, write test procedures, and implement test plans within current guidelines by analyzing project requirement documents. Review project documentation for all assigned projects to ensure the project requirements are clearly defined.
Coordinate regression test activities across all supported applications, reporting defects and escalating issues as needed, and creating QA Status Reports.
Provide estimation for the time, resources and budget required to perform the testing.
Deploying and managing the appropriate testing framework to meet the testing mandate.
Assign task to all Testing Team members and ensure that all of them have sufficient work in the project.
Ensure content and structure of all Testing documents / artifacts is documented and maintained in ECM.
Document, implement, monitor, and enforce all processes for testing as per standards defined by the organization.
Check / Review the Test Cases documents. Keep track of the new requirements / change in requirements of the Project.
Work closely with development/business teams to reproduce, analyze and debug issues.
Conducted Regression testing, Integration testing, functional, ad hoc, security and exploratory testing for various combinations using Manual and automated tools.
Performed front end, backend, GUI, Functionality, System level testing on the application.
Performed Security Testing using Burp Tool and by tampering with the input and manipulating session Id.
Summarize and report results of testing to management and stakeholders.
Aug 2009 to Argo Data
Dec 2013 Lead QA Analyst
Worked on several SDLC Projects in Finance domain (Teller payments, Workforce management, Cash inventory optimization, Business lending and Loan loss)
Responsibilities:
Reviewed requirements in detail, identified Testable and Non-testable requirements, communicated discrepancies and gaps to the project team.
Developed Test cases and SQL Test Scripts for the assigned Module.
Attended Code review sessions to understand the directory
Structure, configuration files, and overall functionality
Of the complete system.
Executed Test cases through HP Quality Centre, and logged defects.
Used SOAP UI to test Web Services running on Web Logic Server
Developed Test Cases using WSDL, Schema files which defines Web Service Request, Response, methods/operations, End Point of web service to be tested.
Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members.
Tested the Application in different Web Browsers and on Multiple Platforms-UNIX, Linux and Windows.
Report bugs/defects in the Clear Quest and ensure problem resolution is communicated in a timely and effective manner between Developers, Lead QA and Project Manager
Conducted Regression testing, Integration testing and User acceptance testing for various combinations using Manual and automated tools.
Performed front end, backend, GUI, Functionality, System level testing on the application.
Executed automated test scripts using QTP for Regressions Testing.
Prepared and helped in creating several testing artifacts like Test readiness review, ST and UAT summary report for OQC Approval process after implementing TCOE recommendations.
Ensured that the integration testing is performed in SIT by reviewing system test plans of upstream and down stream systems.
Prepared testing progress and defects status graphs/charts depicting progress of each testing phase (Initial ST, Final ST, UAT) on weekly basis.
Prepared Requirement Traceability Matrix to map system test cases and User Acceptance Test cases to the Requirements in Excel
Feb-06 to GenSol, Inc
July-09 QA Analyst
Project #1: Mortgage application covers the entire process a consumer encounters in obtaining a real estate loan. The process includes the consumer's completion of a loan application form, lender's validation of the credit and property information, loan underwriting and closing of the mortgage loan.
Project # 2: CRM is web-enabled system for managing sales and customer service teams. CRM gives the organization the power to manage sales, marketing and service information all in one place.
Responsibilities:
Developed Test strategy and Test Plans to ensure that test cases reflect user needs for the Functional, User Interface, Usability and Security requirements.
Developed automated scripts using QTP for performing Functional and Regression testing.
Involved in System Testing, E2E testing and User Interface Testing.
Executed SQL queries to validate the information updated in the database and to test the data integrity.
Used Quality Center to store all testing results, metrics, implemented Test Plan Document, created Test cases, Defect Tracking and Reporting.
Documented the Problem Report for all the bugs detected and tracked the bug fixing process until they were closed.
Worked closely with Development on the resolution of defects.
Environment: Windows NT, UNIX, Oracle, Java, HTML, JSP, JavaScript, QTP, Quality center.
Nov-05 to Office of Chief Medical Examiner (Contractor)
Dec-06 Windows System Administrator
Installed Windows 2000 Advance server and implemented Microsoft SQL fail over Cluster in SAN environment. Installed windows xp/2000 operating system on IBM/dell machines. Troubleshoot and managed Windows based servers. Update all patches and hardware/ Software. Configure proprietary application to work with terminal server. Troubleshoot on day-to- day basis. Upgraded Windows NT 4.0 Servers to Windows 2000 platform. Upgraded Exchange 5.5 to exchange 2000 and then to exchange 2003
Mar-01 to DOT-NYC (Contractor)
Oct-05 Windows System Administrator
Upgrade Windows 2000 Active directory Implementation to Windows server 2003 AD. Migrate and Consolidate DNS/DHCP and WINS Server for Store and Corporate Network for centralized management and efficient name resolution. Maintained 100% LAN/Server uptime and involves installation & configuration of all Equipment’s. Upgraded Windows NT 4.0 Servers to Windows 2000 platform and designed framework and domain topology for Active Directory Migration. Migrate and Consolidate DNS/DHCP and WINS Server for Store and Corporate Network for centralized management and efficient name resolution. Administer Data Backup and Restoration, User Administration, Day-to-day maintenance activities. Migrated Windows NT domain users and consolidate NT domains, simplified administration and security configurations. Define disaster recovery plans and security guidelines for Windows NT Servers. Designed security policies & policies for Password policy enforcer software & implemented on PDC/BDC’s resulted in minimized cracking risk rate from more than 50% to less than 2%. Perform software distribution and upgrades to offices using Novell Zen Works.
Maintained 100% LAN/Server uptime and involves installation & configuration of all Equipment’s. Implemented procedure to Document & Analyze downtime / problem & maintain the Knowledge Base for future reference & comply with audit policy.
EDUCATIONAL QUALIFICATION
MBA (Finance), University Of Dallas, Irving, TX.
B.S in Computer Science, City University of New York – Queens College
Certifications
Certified Scrum Product owner
Completed PMP training
TECHNICAL SKILLS
Operating Systems: Windows NT/2000/2003/XP/Win 7/Win 8, UNIX/Linux
Databases: Oracle 8i, Oracle 10g, MS Access
Languages: TSL, SQL, PL/SQL, XML, HTML, Java, Java scripts, C, Unix Shell Script, VB Script, .NET
Tools: HP Quickest Pro 9.0,9.2,10, HP Quality Centre 9.2,10, ALM 11.5, SOAP UI, version One, Rational Clear Quest, Burp Suite, putty, TOAD, ECM (Enterprise Content Management)
App/Web servers: Web Logic 6.1, Web sphere, Apache
Other: MS Word, MS Excel, MS PowerPoint, MS Outlook, Lotus Notes