Post Job Free

Resume

Sign in

Team Member Sql Server

Location:
Needham, MA
Posted:
October 03, 2023

Contact this candidate

Resume:

Suman Sahu

Cell: 781-***-****

Email: adz44g@r.postjobfree.com

SUMMARY:

Over 10+ years of experience in Software QA lifecycle developing and implementing QA processes for Web and Client/Server based Applications and Software as a Service Products, Financial and Insurance industries.

Extensive experience in creating Test Deliverables- Test Plan, Test Cases, Test Strategy, Requirements traceability Matrix and Final Test Report

Experience with Agile Development with DevOps using CI/CD Process.

Executing testing for trading and portfolio management systems to include functional testing, system end to end testing, regression testing, and performance testing

Experience with managing 25-20 testers across departments and distributed division.

Experience in Manual and Automation Testing in creating Test cases and raising defects using Selenium, Quality Center, VSS. Created automation framework, defining standards, best practices and testing procedures, creating functions, establishing naming conventions; participated in the Test Plan composition.

Lead the automation and manual team on a product basis. Assign tasks and bugs.

Communicate test progress to management through weekly status report and QA Project plan.

Experience in analyzing requirements – Business requirements, Functional requirements and technical specifications and created test strategies.

Expertise in Writing Test Plans, Test cases, Test Scenarios. Creating and Managing Defect Cycle, Responsibility Assignment Matrix, traceability Matrix and eliminating redundancy and duplications.

Strong skills in Backend Testing and in executing SQL commands and writing SQL queries.

Expertise in Testing ERP development with Microsoft Dynamics and SAP GUI, SAP HR, and SAP web applications.

Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatches.

Ability to interact with the developers to resolve issues using Defect Tracking tools like SaladBar, TFS, AzureDevOps, Jira, and Rational Clear Quest.

Ensured timely deployment of production deliverable and providing post-production support and maintenance.

Experience in identifying bugs, analyzing, prioritizing, and generating reports by creating queries using Defect Management Tools like AzureDevOps, Jira, Quality center, Microsoft Test Manager and Rational Clear Quest.

Strong Team building and mentoring skills and excellent team lead capability and strong Logical and Analytical Reasoning, Excellent Management, Excellent communication with good listening, Presentation and Intrapersonal. Demonstrating new implementations to clients, business on completion of project.

Deep Knowledge in using testing tools like AzureDevOps, QTP, WinRunner, LoadRunner, Jira, TMT, ALM/Quality Center, Terminal Emulator, Rational Test Suite and Client/Server applications.

Excellent analytical, problem solving, decision-making and presentation skills with ability to co-ordinate activities in a fast-paced team environment.

TECHNICAL SKILL:

Testing Tools: Selenium, Appium, Cucumber, LoadRunner, SoapUI, MS Dynamics (Navision), Azure DevOps.

Devops Tools: Jenkins, Git, Terraform, Docker, Kubernetes, Selenium, Jira, GitHub, Azure.

Management, Defect Tracking and Reporting: Azure DevOps, Wrike, TeamGantt, HP ALM (Quality Center (ALM/QC)), Bugzilla/ JIRA, Rational ClearQuest, Salad Bar

Languages: Java, Python, SQL, Shell Scripting, HTML, XML, .NET

Operating systems: Linux, Unix, Windows.

DBMS: MySQL, Microsoft Access, MS SQL server, Snowflake

EDUCATION:

Masters in Computer Application (Alliance Business Academy) 2000-2003

Bachelors in Commerce (Shreemati Nathibai Damodar Thackersey Women's University (SNDT) 1997-2000

PROJECTS:

Income Research and Management Boston, MA

QA Lead Engineer and CMP Manager Sep 2019 – Till Date

Company delivers investment results and client service. Team manages broad- market and fixed income portfolios for institutional and private Clients. IR+M offer options to clients to meet a variety of needs. As Tech Team Member I am responsible for designing, maintaining, and executing Test plans for the assigned project. With Agile methodology I was involved in participating in daily scrum meeting to understand the prioritization of project phase and spawning the time estimate on completion of testing.

Responsibilities:

Proactively maintain testing priorities and communicate priorities to the team.

Working closely with software developers, Business Analyst and Stakeholders.

Collaborating with team on escalation and connecting daily in Agile scrum meeting for reviewing requirements specifications.

Develop, design, and execute complete functional test plans and test cases.

Create, update, and provide test status, and confirmation reports at regular intervals for assigned projects.

Prioritizing, planning, coordinating testing activities, flagging test cases for automation, and maintaining the automated test scripts.

Managing and Maintaining cloud Testing.

Training Newbie and interns for support. Preparing training documents, SOP’s for overnight On-Call Support.

Track/maintain testing schedules for assigned projects.

Track defects and proactively communicate issues with project team members.

Accountable for bug triaging with project team members.

Maintaining and documenting thoroughly on Testing in Azure Test Suits.

Additional responsibilities for senior level applicants include expanding the automation coverage, process improvement, and risk mitigation.

Responsible for categorize process gaps, suggest improvements, and underwrite to the better processes and methodologies.

Prepares test reports summarizing test results including system errors, configuration changes or in case of something which is not normal e.g, CAPA.

Responsible for Change Management process, evaluating the Change Impact and organizational readiness to limit potential risk. Lead and implement process enhancements for quality business functions.

Execute testing for trading and portfolio management systems to include functional testing, system end to end testing, regression testing, and performance testing.

Support training and communication as part of Change Management. Activities include designing and training resources.

Authorize any Change requests and coordinate with the Change Manager/Change Requester for changes presenting higher risk.

Responsible to SOC Audit twice a year by reviewing, authorizing each Change request items. Change request items vary from Emergency to Normal to Routine Changes.

Environment:

XML, .NET, MS SQL Server, Simcorp System, SharePoint, Citrix, ETL, CSV, Agile Methodology, Azure, Azure DevOps, Change Management Process (CMP), Postman, Swagger, SaaS Based Application, Jenkins, Kubernetes, Docker.

PCG Company Boston, MA

QA Lead Mar 2014 – Sept 2019

Company partners with state and local agencies in 24 states to provide financial management services for participant-directed programs. PCG Public Partnerships helps state, county, and local public agencies deliver a participant -directed service model that allows individuals with disabilities and their families to make their own choices about services.

Responsibilities:

Analyze, design, and build testing procedures that deliver the client’s goals and provide our clients with maximum value.

Develop and document test plans, training manuals, test results.

Coordinate and manage testing with IT staff and business.

Involve and derive in Manual and automation testing include Mobile testing.

Coaching and mentoring QA members, being the voice for QA team cross organizations.

Analyzed the Functional Requirements and Design Specifications documents to ensure that the system meets all the technical and business requirements.

Analyzed, maintained, and go over test documents to meet 21 CFR 820 (FDA QSR) and ISO requirements.

Manually generated and implemented templates for Test plan, Test Cases, and Test Scripts and performed Testing on the entire application.

Worked closely with software developers, business analysts, Sys admin, and other project management personnel involved in Software Development Life Cycle (SDLC).

Performed back-end testing of SQL Server data using XML and ETL.

Execute database testing in Microsoft SQL environments including designing and manipulating test data, validating stored procs, jobs, triggers, and replication.

Participated in requirements and design specification reviews and technical documentation reviews as essential to performed assigned duties.

Provide leadership, reinforce best practices, such as providing QA workflow processes across offshore, onshore in hybrid situations, testing of front-end UIs through backend Mobile platforms, and help each team member contribute to the group's success.

Executed manual and automated scripts, documented results, communicated issues, and verified issues resolved.

Identify and perform the root cause analysis, isolate, replicate, and report defects and verify defect fixes.

Prioritized defects to be fixed using business requirements understanding and the needs of the customer.

Environment:

MS/Dynamics 2009, ASP.NET, XML, MS/SQL Server - 2017, Citrix, VSS, MTM, SQL SMS, Salad Bar, ETL Testing, Using Agile Methodology and Hybrid methodology between Waterfall and Agile, Azure.

Achievement:

Certification for Team Award.

Bose Corporation Framingham, MA

QA Engineer Aug 2013 – Mar 2014

Windchill 10.1 based PLM system at Bose Corporation by understanding program changes, developing, and documenting new business unit specific work processes for successful rollout of the application.

Responsibilities:

Learning about the system and design for the new PLM program.

Working with business units to understand and document their current design and product development practices.

Write and Execute test cases, scripts, and reports in Quality Center application with all aspects for Windchill PDMLink 10.1 and ProjectLink Interfacing and publishing to SAP.

Create validation deliverables e.g., Effort Assessments, Validation Plans, Test Plans, Test Protocols, Test Reports, Validation Summary Reports and Trace Matrices, as needed to support local and enterprise system implementation.

Collaboratively creating new work practices to complement our new Windchill 10.1 PLM and CAD data management solution within the business unit e.g., include team design using CAD, data storage and collaboration, part number and BOM management, and product data release.

Write test cases related to Creo 2.0, MCAD, ECAD data from Windchill application and using WorkGroup manager.

Testing data from Windchill to SAP.

Continuously improve the new processes and roll out additional training as required working collaboratively with the core team.

Participate in writing Quality policy and procedures, training development and rollout activities.

ECC 6.0 SAP Testing in SD, MM, PP, FI

Writing test scripts for System Testing, Unit Testing of Interfaces, forms, reports, conversions, and enhancements business processes in ECC 6.0 modules FI, MM, SD, and PP.

Expertise in developing the regression suite for custom code development in SAP.

Expertise in creating Scripting components, Business Components, scenarios, and Test Sets using QTP 10.0 and Quality Center 10.0.

Writing test conditions from the functional specification.

Automation test and executing test scripts manually in HP Quality Center.

Experienced in testing SD modules like Sales Order, Outbound Delivery using Transaction Codes Va01, VL01n and VL02n Shipment and Billing using Tcode Vf01.

Experienced in testing PP modules Production Order creation, Production Order Confirmation

Experienced in testing MM module involving MIGO using various combination of movement types.

Environment:

Jira, Quality Center, QTP, SAP GUI, SAP HR, and SAP web applications

Achievement:

Appreciation from Manager on excellent work, and project completion on time.

ITC Infotech; Client – PTC, Needham Bangalore, India - Boston, MA

Lead QA March 2010 – Aug 2013

Responsibilities:

Gathered, Understood, and analyzed, requirements for project by attending User Group Meetings and created SRS (System Requirements Specifications) Document

Created workflow/lifecycle, assignment of participants, validation of each task, customized activity like applying dated effectively, tally expressions.

Designed Automation framework from Scratch.

Quality Center was used for overall Test Management (Requirements in Requirements Tab, Test Cases in Test Plan, Execution in Test Lab, and Defects in Defects Tab).

Project involved configuration and installation of system from scratch, working with onshore and Offshore Team.

Conducting Day to Day status meeting with QA Team for updates and Development to fix defects.

Windchill Implementation:

Japanese Engine Manufacturing Company which supplies engines to car manufacturers across the world. They have recently implemented the PTC Suite of PLM Products - Windchill to manage their manufacturing processes.

This evolves WTPart, CADDocument (EPMDocument), two soft typed class of WTDocument i.e. Project Plan Document & Design Document, State based versioning scheme for the WTPart within BOM, each having the same states throughout their lifecycle and Change Management Process including ECR, ECN and Implementation plan.

Tested both manually and automatically using QTP - BOM Report.

Tested Configuration for Auto Creation and Auto Association of Document with WTPart both manual and automation using QTP.

Use Change Process to Test the CAD Document in the Design State using QTP. The WTPart and Associated Design Document were tested automatically using QTP.

Windchill Testing

PLM & SE (Service Engineering) is a Global Services Partner of Parametric Technologies Corporation Inc. (PTC) for system study, product customization, system integration and deployment.

This project involves maintaining QA Environment including installation with various configuration of windchill and patch codes and

Testing the Application using QTP simulating the same environment for a problem and finding the appropriate solution. This also involves configuration of Pro/E for Windchill.

OnDemand Templates

This project aimed at Testing of creation of template in Windchill PDMLink that will configure organization, product, project, OIR and the lifecycle.

Tested Wildfire Workspaces to find the parts with views using the Latest Configuration Setting based on the Workspaces Configuration Specification Preferences, QTP was used for automatically testing the whole process.

Versioning scheme & Integration of OnDemand server in PDMLink

Configure and Test PDMLink R7 Versioning Scheme, which supported different schemes for customers, configuration was controlled by OIR at organization level. This included testing – both manually and automatically using QTP. This configuration supported Harvard series (OOTB default), Mil Spec and Integer Series added specifically for OnDemand or ASME Standard Y14.35M.

Value Added Resellers (VAR’s)

Creation and testing of packages for the Value-Added Resellers (VAR Team) so that they can deploy the PLM solutions at the customer site.

Creation of Jar files after preparing the worksheet for the entire process tree in a package and then finally at EOD we must also send the test report.

Creation of templates for some packages like Six Sigma Template Project generated template, and PACE PDP Template Project generated template.

Testing of Import and Export of Templates both manually and automatically using QTP.

Environment:

JSP, Servlet, XML, Unix, Oracle, Selenium, Tomcat, Wildfire, Wildfire, Pro/Engineer, and Windchill, Windchill PDMLink, Pro/Engineer, PJL, PTC server like ICConnector, Packgen server.

ADDITIONAL EXPERIENCE:

Bluechip Software Inc. Bangalore (India)

Developer Oct 2004 – Dec 2006

Environment: J2EE, Java, HTML, Unix, Oracle, Windows, Quality Center, QTP (VB Script), C#, .Net.

Brainsoft Consulting Bangalore (India)

Technical Human Resource Manager Mar 2003 – Oct 2004

Gandhi Enterprise Bangalore (India)

Accountant (Internship) Nov 2000 (6 months)

Environment: Tally, Microsoft Tools.



Contact this candidate