Jira / Hp Alm Administrator Resume
Richardson, TX
SUMMARY:
- A creative and professional team player with 15+ years of experience in Informational Technology with emphasis on Software Testing/ Quality Assurance, 10+years of Experience in QC and 5+ years of Experience in JIRA Administration Extensive experience in leading the QA teams to setup QA environment and to perform successful testing. Experience in testing Standalone, Client Server, Tools, and Web based applications using Automation tools and Manual testing techniques including White Box testing experience. Expertise Migration/ Administration and Configuration experience in setting up and configuration of Test Management and Change Request tracking tools like HP Quality Center, HP ALM 11.00, 11.5 and 12.2. and JIRA.
- Extensive experience in implementing and Migration QA processes for Retail, Merchandise Financial Planning, Travel, Healthcare Transformation, Energy, Telephone & Mobile application, approval systems, Credit Card Application
- Experience in setting and configuring QA Environments for different business domains such as Healthcare, Finance, Banking, HR, Communications Services (Telephone/Wireless), Retail and Energy.
- Extensively involved in various phases of Software Development Life Cycle (SDLC) with experience in managing testing lifecycle (STLC) using Waterfall, Agile, MSF, V - Model, RUP, and RAD Models.
- Experience in creating Test Plans and designing test cases covering all test conditions and eliminating redundancies.
- Experience in interacting with Business Analysts, Developers, Technical Support and help them base line the requirement specifications.
- Experience working with applications hosted in different Data Centers and Clouds. Strong experience working with SCM, DBA, Infrastructure, and System Admin Teams for the verification of systems, applications, and infrastructure during Data Center Migrations.
- Worked directly with Business Analysts to gather and understand the requirements and to automate the requirements management process. Automated Requirements Synchronization Process between HP Quality Center to provide the reports to the management.
- Expertise in Migration from ALM/Rally to JIRA.
- Support, compile and troubleshoot Atlassian tools, Design custom JIRA workflow.
- Integration with JIRA to HP ALM and other tools.
- Experience as a JIRA/Mercury Suite Admin with Installing, Configuring, and customizing the Quality Center application with a strong software testing and development experience.
- Experience in Migrating and upgrading from any version of Test Director to Test Director or Quality Center.
- Train, guide, and assist development groups in use of JIRA/Confluence as well as plugins such as AGILE, Subversion, Utilities, and reporting capabilities, etc.
- Compile and analyze development and operational bug reports. Support JIRA Project Administration involving custom, complex projects, workflows, security schemes, custom fields, dashboards and reports configurations.
- Manage various development tools, testing tools and monitoring tools.
- Plan, evaluate, deploy, operate, and maintain tools to suit the expanding user-base.
- Provide training to technical and non-technical teams to use Atlassian tools.
- Compile and analyze development and operational bug reports. Also Install, Upgrade Atlassian products.
- Troubleshooting and fixing errors common to Applications and Application servers.
- Strong experience in implementing JIRA and integrating it with HPALM 11/12.
- Installation and configuration of ALM 12, 12.2 followed by Validation.
- Designing the infrastructure architecture and migration plan aligned to organization process & guidelines.
- Best Practices and Value adds implementation.
- Migration of projects from QC 10.0 to ALM via 2 stage approach.
- Integration of third part tools with ALM. Creating, Archiving, and customizing projects.
- Developing various customized reporting tools using API to generate complex test execution reports, User permission report etc.
- Designing standard template and customizing workflow as per client requirement and rolling out to all projects.
- Experience in configuring QA Process in Quality Center/ALM/Load Runner with Project/Site administration knowledge for test requirements writing, requirements tracking, defect tracking, Test results, Defect status reporting and batch testing with customized VB scripting and work flow scripts.
- Extensive experience as lead for the implementation of manual, automation, performance, and smoke tests using HP UFT/QTP, Load Runner.
- Extensive experience in test estimations, scheduling, strategy, risk analysis and reporting.
- Experience in conducting different types of testing including White Box Testing, Black Box Testing, GUI Testing, Data Driven Testing, Back End Testing, Integration, Regression, Sanity, Functional and System testing, Load TetingStress Testing, Performance Testing.
- Experience as a Mercury Suite Admin with Installing, Configuring, and customizing the Quality Center application with a strong software testing and development experience.
- Strong experience in administration of mercury suit and well experience in installation of QTP, Load Runner and Quality center 8.0,9.2, 10 & 11, 12. version on a clustering and load balancing environment.
- Strong experience in implementing ALM 11 platform and integrating it with Performance center 11.
- Expertise in Integration between Quality Center & QC Dashboard.
- Customizing Quality Center as per industrial standards.
- Experience in Migrating and upgrading from any version of Test Director to Test Director or Quality Center.
- Experience in implementing LOG files to debug Test Director and SQL trace for DB checkpoints.
- Experienced in setting parameters for Site Configuration.
- Experienced in developing and using API(s) for Quality Center.
- Writing custom macros in Excel to import the Test Plan, Requirements into Test Director.
- Customizing Quality Center as per industrial standards.
- Experience in installation of all types Automation tool, Add-Ins, and 3rd party connectivity tools.
- Setup the e-Mail system with SMTP or IIS SMTP protocols.
- Customizing Test Director/QC Defect tracking module using VB Scripting.
- Expertise in Automate Business Process with Mercury & Compuware testing tools.
- Hands-on experience using QuickTestPro, Win Runner, Quality Center/Test Director, Load Runner.
- Experience in analyzing Business Requirements, Functional and Technical Specifications.
- Solid experience in Develop, Review, Execute, and Maintain Test Plans, Test Cases, and Test Procedures.
- Expertise in Manual and Automation Testing Client / Server, Mainframe & Web applications.
- Strong understanding of QA Principles, QA Process, Use Cases, and Software Development Life Cycle.
- Experience in Data Driven testing and parameterize the Performance Session Scripts. Proficient in the use of various testing tools such as Mercury Interactive tools and Rational Suite.
- Extensively involved in White-Box, Black-Box, and Full Life Cycle Testing.
- Experience in tracking test coverage and providing Metrics to the management.
- Involve in load balancing and identified the failures on the server and maintain the system administration.
- Developed numerous Load Scripts based upon the functionality and to perform the application.
- Responsible for test preparation, execution, reporting, and supervising daily activities of team.
- Perform Smoke, Integration, Functionality, Performance, Load, Regression, and System Tests.
- Experience in document Defects with high level of detail, accuracy, and informative recreation steps.
- Experience in Software Verification, Validation, and Testing Methodology.
- Experience in Oracle, MS-SQL databases, and Windows operating systems.
- Experience in using TOAD for querying Oracle databases.
- Extensive experience in setup and maintenance of Test Environment.
- Strong experience in installation of various Software’s and Tools.
- Involved in providing training on new products and responsible in preparing training documents.
TECHNICAL SKILLS:
Hardware: IBM PC, HP Workstation
Operating System: Windows 2000 Server & Professional, Windows NT, Windows 95/98/ME, Unix, Linux
Database: Oracle 9.2/10.2 0.4. SQL server 2003,2005,2008
Languages: COBOL, SQL, TSL, Visual Basic 4.0//5.0/6.0, Crystal Reports.
Web server: IIS 6.0, JBoss, Java Web Server
Networking/Web: FTP, Telnet, TCP/IP, and VPN
SDLC Tools: Mercury Interactive QuickTestPro 6.5/8.0/9.0, Win Runner Test Director, Quality center 9.0/10, Load Runner, Track Record 6.0/5.0, Mantis BT, PR Tracker, Test Track Pro, TRAC, Fogbugz. TASKTOP. JIRA
PROFESSIONAL EXPERIENCE:
Confidential, Richardson, TX
JIRA / HP ALM Administrator
Responsibilities:
- Responsible for setup the JIRA from Scratch administering and maintaining Atlassian JIRA and technical support and training; maintained documentation; customized software as workflow setup, setup Sandbox Windows Server.
- Configuring the user mapping/Releases/Standard field, Projects, Custom Workflows, Issues types, Boards, and Screens.
- Create and maintain QC domains and projects, set up QC roles and permissions, modify QC templates, troubleshoot developer issues.
- Expertise Analyze latest application versions from the vendor, and modify custom code to make it compatible.
- Experienced with QC add-ons and integration with other tools such as QTP and other QA Tools.
- Identify source data - fields/data from source system, Custom fields, Extract data from source, transform and prepared and scrips tor target. Load data into target system and validate data migration.
- Configure the workflow of a defect also link/relate an issue to another.
- Migrated RTC/ HP ALM instance to HP ALM and JIRA.
- Expertise working with SQL databases and writing SQL queries, working with Active Directory Groups.
- Experienced in the use, administration and integration of SDLC applications on the Windows platforms, such as requirements management systems, test applications, ticketing systems, and software development applications.
- Created Pre-Requisite document for Migration to use TASKTOP Synch from RTC/HP ALM to JIRA.
- Create issues/queries both in JIRA and ALM, the set of queries are for Epic, Story, and bug issue types.
- Manage various development tools, testing tools and monitoring tools. Coordinated with Confidential QA staff to develop solutions within HP ALM and JIRA.
- Expertise to bring in the QA process to the entire project - HP ALM and project and database migrations.
- Experienced Identify and implement process automation and optimizations.
- Expertise in Plan, assess impacts, test and perform application upgrades.
- Install, configure, maintain, administer, and enhance JIRA and Developed or acquired additional plug-ins, extensions and integration of systems when identified or requested.
- Customized complex projects, workflows, security schemes, custom fields, dashboards, and reports configurations.
- Lead minor and major JIRA upgrades as well as schedule and coordinate maintenance for systems.
- Training to technical and non-technical teams to use HP ALM/ JIRA and assist development groups in use of JIRA/ HP ALM as well as plugins such as AGILE, Subversion, Utilities, and reporting capabilities, etc.
- Design custom HP ALM/JIRA workflow, Plan, evaluate, deploy, operate, and maintain tools to suit the expanding user-base.
- Maintaining customizations Custom Issue Type, across versions of JIRA workflows, field permission schemes, notification schemes, screens schemes, etc.
- Administer the JIRA instances on a day to day basis including performance tuning/scaling the instances, storage, indexing, etc.
- Determine ways to optimize/improve JIRA and JIRA Agile setup and process workflows, as well as identify where functionality can/cannot meet user requests.
- Expertise to bring in the QA process to the entire project - JIRA, HP ALM, RTC. Migration from legacy system to New JIRA. Traceability matrix, reports and walk through with the stake holders.
- Providing daily and weekly Status Reports to the Client.
- Working closely with APP team and users in requirements gathering, reviewing business rules, and identifying data sources.
Environment: Windows 2008 Server, Oracle 11g, CA Site Minder, Sun IDM, JBoss AS, Active Directory domain services, Java, J2ee Windows XP, JIRA, ALM 11, ALM 11.5, ALM 12.2 SQL Developer, Putty, TASKTOP, MS Office, Orbiter, Nexus, JBOSS, Quick Test Pro, RTC.
Confidential, Plano, TX
QA Lead
Responsibilities:
- Expertise to bring in the QA process to the entire project - HP ALM and JIRA.
- Performance testing and Metrics - HP Load runner.
- Agile Methodology - Managing the entire team in Unit, Functional, Integration and regression testing process regards to Identity lifecycle.
- Involved and conducing Web Services Testing Also Integration Testing.
- Traceability matrix, reports and walk through with the stake holders.
- Participating in QA team meeting and bug tracking meetings, also Monitors and tracks metrics around testing code coverage to ensure continuous improvement.
- Performing different types of testing like Functional, Smoke, System, Integration, Regression tests and Database testing.
- Coordinates the dependencies between departments on projects with aggressive timelines.
- Involving in testing the new functionalities based on test cases and coordinated with the development team in fixing the issues.
- Oversees and communicates test approach to Portfolio and Line of Business leadership, working with the Execution Lead and Agile Train Engineer to ensure timelines and expectations are met.
- Identifying resource needs and provide formal test estimates and develop test schedules
- Working closely with business analysts and users in requirements gathering, reviewing business rules, and identifying data sources.
- Conducting smoke testing, Functionality testing, System testing, Regression testing and Data migration testing.
- Approach and method for reporting of testing status, Managing the overall performance and delivery of the cross-functional teams.
- Involved in project planning, coordination and implemented QA methodology.
- Managing the team's progress/successes and motivating scrum teams to make sure they are highly visible to product owner / stakeholders. Providing daily and weekly Status Reports to the Client.
- Knowledge in Analysis of Defect Severity, Defect tracking system and Defect Reporting. Responsible for maintaining test environments for multiple releases and regression testing.
- Coordinated and documented movement of code from test servers to production servers.
- Set Up corporate QA policies and procedures, advised senior management on quality practices.
Environment: RHEL 6.3, Windows 2008 Server, Oracle 11g, CA Identity Manager 12.6, CA Directory Server, CA Site Minder, Sun IDM, JBoss AS, Active Directory domain services, Java, J2ee
Confidential, Denver, CO
JIRA / HP ALM Administrator
Responsibilities:
- Working on TISSC tickets daily basis users issue resolved during the period 2800 plus tickets issue resolved.
- Customization of HP ALM Defect Module to map to the JIRA sorties.
- Designed the infrastructure architecture and migration plan aligned to organization process & guidelines.
- Upgrade HP ALM 11.5 to 12.2.
- Archived 365 projects backup to ALM repository. Also Defect Workflow standardization customization.
- Designed and rolled out of standard template across all projects.
- Developed various customized reporting tools using API to generate complex test execution reports, User permission report etc. customizations Custom Issue Type, across versions of JIRA workflows, field permission schemes, notification schemes, screens schemes, etc.
- Create issues/queries both in JIRA and ALM, the set of queries are for Epic, Story, and bug issue types
- Worked directly with QA and Development Team to coordinate requirements, Test Plan, and Test Lab.
- Created training documents for Requirement module. Perform the required testing effort by Regression Team.
- Created and Setup Users, Groups, Filters, and Reports. Worked with build manager to setup QA Environment.
- Participated in Change Control, Change Review, and Change Approval meetings to discuss Enhancements and modifications request issues.
- Participated in the test environment setup and in ensuring that the facilities, test tools and scripts are in place to successfully perform the required testing effort.
- Handled Quality Center Database related issues with DBAs and Network team.
- Communicated and discussed problems about testing environment with testing and development team and successfully implemented HP ALM 11.5 Mercury Quality Center Test execution, Requirements mapping and Defect Writing process guidelines to improve testing process in the company.
- Provided KT sessions and Trainings to the users on regular basis and communicated with them to make sure any changes in testing process should be informed and communicated in the team.
- Designed various Excel Macros and Reports using VBA, Pivot Charts, and Pivot Tables.
- Created various documents i.e., Test Plan, Defect Management Workflow Design Diagrams, Test Cases, Test Scripts, Assessment Report, User guide and System Documents.
Environment: Windows XP, Oracle 10g, ALM 11, ALM 11.5, ALM 12.2 SQL Developer, Putty, TISSC, MS Office, Orbiter, Nexus, JBOSS, Quick Test Pro, Java, J2EE.
Confidential, San Antonio, TX
QC Admin
Responsibilities:
- Provided KT sessions and Trainings to the users on regular basis and communicated with them to make sure any changes in testing process should be informed and communicated in the team
- Involved in project planning, coordination and implemented QA methodology
- Experience in web service testing tools like Soap UI pro or any supporting tool
- Participated in various meetings and discussed Enhancements and Modification Request issues
- Worked directly with Business Analysts to understand the changes and updated requirements and Stories standardization of role types and workflow, definitions of critical fields, domain categorization.
- Implemented Defect Template Standardization, field mapping Analyzed current usage and Process.
- Developed Standard defect template for future use. Created and Setup Users, Groups, Filters, and Reports.
- Look into solutions of users authenticating on different logins, Coordinating with off shore team daily users access issue.
- Participated in Change Control, Change Review, and Change Approval meetings to discuss Enhancements and modifications request issues
- Participated in the test environment setup and in ensuring that the facilities, test tools and scripts are in place to successfully perform the required testing effort
- Handled Quality Center Database related issues with DBAs and Network team
- Star team to ALM mapping (Micro focus) synchronization
- Communicated and discussed problems about testing environment with testing and development team and successfully implemented Mercury Quality Center Test execution, Requirements mapping and Defect Writing process guidelines to improve testing process in the company
- Designed various Excel Macros and Reports using VBA, Pivot Charts, and Pivot Tables.
- Administered and configured HP ALM 11.00 and Implemented HP ALM Synchronizer.
- Worked directly with SMEs, QA, and Development Team to coordinate requirements development and test cycles for HP ALM implementation. Worked with build manager to setup QA Environment.
- Created various documents i.e., Test Plan, Defect Management Workflow Design Diagrams, Test Cases, Test Scripts, Assessment Report, User guide and System Documents
- Designed Custom Excel Requirements and Test Plan Templates to support HP ALM Testing process.
- Managed Test planning process using Excel Templates, Macros, HP ALM 11.00.
- Worked in Agile and Scrum environment and managed teams to support development and test activities.
Environment: Windows XP, UNIX, Oracle 10g, Mercury Quality Center 10, Soap UI, ALM 11, ALM 11.5 Load Runner, MS Office, Java, J2EE.
Confidential, Washington, DC
QC Admin
Responsibilities:
- Synchronization of data between HP ALM and Serena SBM
- Customization of HP ALM Defect Module to map to the existing Serena SBM Defect Module
- Develop and Create custom reports within HP ALM
- Implemented Custom Defect Workflow for FEPOC Internal projects and over 80 Plan Projects
- Designed various Excel Macros and Reports using VBA, Pivot Charts, and Pivot Tables.
- Administered and configured HP ALM 11.00 and Implemented HP ALM Synchronizer.
- Worked directly with SMEs, QA, and Development Team to coordinate requirements development and test cycles for HP ALM implementation.
- Created various documents i.e., Test Plan, Defect Management Workflow Design Diagrams, Test Cases, Test Scripts, Assessment Report, User guide and System Documents
- Designed Custom Excel Requirements and Test Plan Templates to support HP ALM Testing process.
- Managed Test planning process using Excel Templates, Macros, HP ALM 11.00.
- Worked in Agile and Scrum environment and managed teams to support development and test activities.
- Managed Black box testing, Smoke testing, Screen Validation testing, Positive & Negative testing, System testing, Regression testing, End to End testing, Functional testing, integration testing, System testing and coordinated UAT for HP ALM integration and reports.
- Manage and control Requirements, Test Design, Execution and Defect management and tracking Process
- Provided KT sessions and Trainings to the users on regular basis and communicated with them to make sure any changes in testing process should be informed and communicated in the team
- Involved in project planning, coordination and implemented QA methodology
- Participated in various meetings and discussed Enhancements and Modification Request issues
- Worked directly with Business Analysts to understand the changes and updated requirements and Stories
- Participated in the test environment setup and in ensuring that the facilities, test tools and scripts are in place to successfully perform the required testing effort by Regression Team.
- Created and Setup Users, Groups, Filters, and Reports.
- Customized Defects Module according to the current workflow in Serena SBM.
- Analyzed and developed technical reports using MS-Word and MS-Excel and generated weekly reports from SQL Server and wrote various customized SQL queries to generate customized reports.
- Implemented HP ALM Synchronizer and Administered HP ALM Projects.
Environment: Windows XP, UNIX, Oracle 10g, Mercury Quality Center 10, Soap UI, ALM 11, ALM 11.5 Load Runner, MS Office, Java, J2EE.
Confidential, Lincolnshire. IL
QC Admin
Responsibilities:
- Involved QC SAAS ALM Migration.
- The Loyalty project migrating to SAAS and requirement gathering for upload.
- Working very closely with GDBA team in HP during the migration process for any assistance regarding databases.
- Create a QCP file and upload it to HP’s FTP Server setup.
- All the projects used for the dry run using the legacy process of Providing a copy of DB and File repository.
- All the Projects monitoring Dry Run and giving the access to users.
- After acceptance, the Dry Run projects proceed with the Production Migration.
- I am distinctly responsible for tools UP and Running the application Confidential all the time. Managing and creating users access, properties, users’ group’s privileges and rights, Project Entities, entity lists
- Project customization include setting up the rules, adding fields in to the project.
- Worked with business teams and developed a process for standardizing the Quality Center folder creations and test case creations and workflow templates. Setting new groups & Customizing them as per the roles and responsible.
- Implement new QC instance and migrate the existing project in to new environment.
- Look into solutions of users authenticating on different logins.
- Validating weather all the users are properly migrated along with the projects.
- Created projects and customized the projects and the fields as per the business needs.
- Responsible for migrating all the projects and its database schemas from legacy servers to the DCC new servers.
- Scheduling weekly status reports and sending reports to business sponsors
Environment: Windows 2003 Servers, Quality Center 10, ALM 11, Jboss, IIS, Oracle 10g2.
Confidential, San Diego. CA
QC Admin
Responsibilities:
- As a Lead Quality Center administration responsible for migration of Quality center from one version to other and responsible for migration of various other defect tracking tools to Quality Center.
- Responsible for Installing, and Configuring QC 9.2 development environment on clustering and load balancing environment and installing Client components on client machines.
- Upgrade and Migration of QC 9.2 Web logic application server in San Diego Production environment to Jboss in Anaheim production environment
- Migrate 100+ Gb of repository data from San Diego file system to Anaheim server using Robo copy
- Migrate all 300+ Quality Center project from SD QC server to NGDC QC servers
- Convert all the legacy Confidential user account to LDAP using SQL SERVER scripting.
- Created SQL Scripts for databases backup’s files to restore in new NGDC servers.
- Created Scripts to revoke admin permissions on all 300+ project databases and assign grants to all
- Created SQL Scripts for altering file sizes and changing object owners from TD to DBO
- Look into solutions of users authenticating on different logins.
- Responsible for requirements gathering and analysis. Also Customizing Test Director as per industrial standards.
- Installing, and Configuring QC 9.2 on clustering and load balancing on servers and installing Client components on client machines. Developed the macros to migrate the data from legacy tool to the QC 9.2.
- Migrate the users in to QC using bulk add user tool. Installed QC dashboard 9.2 and integrated with QC 9.2
- Consolidated the projects from another instance of QC9.2 into MYQC server in DCC.
- As a QC admin created projects and customized the projects and the fields as per the business needs.
- Enabled Site Configuration parameters. Writing custom macros in Excel to import the Test Plan, Requirements into Test Director.
- Setup the e-Mail system with SMTP or IIS SMTP protocols. Customizing Test Director/QC Defect tracking module using VB Scripting.
Environment: Oracle, SQL, Unix, XML, Quality Centre 10, ALM 11
Confidential, Plano,TX
QC Admin.
Responsibilities:
- Define Master Test Plan, Test Approach, test Scope and Identify Risks.
- Designed test design methodology and define naming standards.
- Create requirements and function coverage metrics.
- Co-ordinate on-site and off-shore QA Teams, to make sure that QA deliverable are of high standards.
- Analyze test report, produce test designs and Test Data strategy.
- Participate in the creation of the test execution schedule.
- Designed various Excel Macros and Reports using VBA, Pivot Charts, and Pivot Tables.
- Validated Confidential financial and Stores volume data in Excel using Macros, Excel advanced functions, external Data source and Pivot tables.
- As a Technical Lead responsible for handling team and assigning tasks to individuals.
- Scheduling weekly status reports and sending reports to business sponsors.
- Responsible for requirements gathering and analysis.
- Responsible for creating documents in all the phases of the project life cycle and training materials.
- Responsible for Installing, and Configuring QC 10/ ALM 11 on clustering and load balancing on servers and installing Client components on client machines.
- Responsible for installing and configuring performance center 11 and integration to ALM 11.
- Responsible for migrating all the projects and its database schemas from legacy servers to the DCC new servers.
- Validating weather all the users are properly migrated along with the projects.
- HP users LDAP authentication as a login process for QC. Strong experience in setting up LDAP Servers.
- Developed the tools to upload attachments, Linked defects in to QC 10 and list manager tool to import the list values in to the QC.
- Developed the macros to migrate the data from legacy tool to the QC 10
- Migrate the users in to QC using bulk add user tool.
- Consolidated the projects from another instance of QC10 into QC 10 Prod server in DCC.
- Working very closely with GDBA team in HP during the migration process for any assistance regarding databases.
- As a QC admin created projects and customized the projects and the fields as per the business needs.
- Experience in implementing LOG files to debug Test Director and SQL trace for DB checkpoints.
- Experienced in setting parameters for Site Configuration.
- Writing custom macros in Excel to import the Test Plan, Requirements into Test Director.
- Customizing Test Director as per industrial standards.
- Setup the e-Mail system with SMTP or IIS SMTP protocols.
- Customizing Test Director/QC Defect tracking module using VB Scripting.
- Experience in installation of all types Automation tool, Add-Ins, and 3rd party connectivity tools.
Environment: Windows 2003 Servers, Quality Center 10, ALM 11, Jboss, IIS, Oracle 10g2.
Confidential, Plano, TX
QC Admin
Responsibilities:
- As a Technical Lead responsible for handling team and assigning tasks to individuals.
- Scheduling weekly status reports and sending reports to business sponsors.
- Responsible for requirements gathering and analysis.
- Designed various Excel Macros and Reports using VBA, Pivot Charts, and Pivot Tables.
- Validated claims volume data in Excel using Macros, Excel advanced functions, external Data source and Pivot tables.
- Created Transition Plans using MS Project and completed transitions for all the Tools on time.
- Conducted Black box testing, Smoke testing, Screen Validation testing, Data driven testing, Positive & Negative testing, System testing, Regression testing, End to End testing, Functional testing, integration testing and coordinated UAT.
- Designed Workflow scripts in Quality Center using VB Scripts to manage and control Requirements, Test Design, Execution and Defect management and tracking process.
- Analyzed business and system requirements for all Integrations.
- Involved in documentation during various phases of product life cycle.
- Used MS Project for Project scheduling during the entire life cycle.
- Involve in preparing Test Plan, Analysis Documents and Involving in identifying gaps.
- Responsible for Installing, and Configuring TD, QC, and Client machines.
- Migrating Team Track Issues in to Quality Center.
- Configure and implemented LDAP authentication to enable QC to log in using group email address for secure authentication.
- Experienced in setting parameters for Site Config.
- Experienced in developing and using API(s).
- Extracting the data from different databases (SQL Server, MySQL, and Oracle) using complex queries.
- Writing Stored Procedures and functions to retrieve the data according to the client requirements.
- Writing custom macros in Excel to import the Test Plan, Requirements into Test Director.
- Customizing Quality Center as per industrial standards.
- Involved in analyzing System specifications, design, development and execution of test plans and test Cases for manual testing and Automated testing.
- Created criteria for data conditioning needed for Automated and manual testing.
- Reviewed the Business Requirements document with the business and development teams to understand the architecture and functionality of the application.
- Debug the Test Scripts, created Batch tests, verifying the test results, and reporting the defects to Test Director.
- Wrote SQL, PL/SQL queries/procedures to access the data from the database tables and crosscheck the results, also been used for Automation Regression Testing.
- Documented bugs, questionable functions, errors, and inconsistencies in application functions, outputs, and content.
- Develop Dynamic Reports using Macros developed in VB.
- Track test results for management, categorizing issues and creating/distributing defect reports and managing defect database using Test Director.
Environment: Oracle, SQL, Unix, XML, Quality Centre 10, ALM 11
Confidential, Tulsa, FL
QC Admin
Responsibilities:
- Integration: PHASE-1: QC/ JBOSS upgrade Tulsa/ Doxford.
- Installation and upgrade eLab - Development environment (AET P&D base+ new) with Jboss/IIS web server for Tulsa and Doxford
- Responsible for Installing, and Configuring QC 9.2 on clustering and load balancing on servers and installing Client components on client machines.
- Testing the functionality in Integration, UAT and Production environment upon the upgrade done by Production support team
- Upgrade and Migration of QC 9.2 WebLogic application server in Tulsa Production environment to Jboss/IIS server in NGDC, Atlanta production environment
- Upgrade of QC 9.2 WebLogic application server to Jboss/IIS in Doxford environment
- Apply Quality Center patches upon releases.
- Process defining and documentation as below:
- Implementation Plan
- Functional Test Plan
- Operational procedures document
- Training sessions power point
- Communication Plan
- Installed and configured Quality Center on Test, Dev, and Production NGDC Atlanta server
- Prepared document checklist for loading server
- Responsible for Installing, and Configuring QC 10 on clustering and load balancing on servers on Next Generation Datacenter.
- Configure QC 10 with LDAP authentication.
- Migrate 200+ Gb of repository data from Tulsa file system to Atlanta server using robo copy utility
- Migrate all 300+ Quality Center project from Tulsa QC server to NGDC QC servers
- Convert all the legacy Confidential user account to LDAP using SQL SERVER scripting.
- Created SQL Scripts for databases backups files to restore in new NGDC servers.
- Created Scripts to revoke admin permissions on all 300+ project databases and assign grants to all NGDC Admins.
- Created SQL Scripts for altering file sizes and changing object owners from TD to DBO.
- Created Stored Procedure and functions for LDAP conversions.
- Look into solutions of users authenticating on different logins.
Environment: Windows 2003 Servers, Quality Center 10/ 9.2, Quality Center Dashboard, Jboss, IIS, SQL Server 2005, SQL Server 2008.