Business Analyst Resume
PROFESSIONAL SUMMARY:
- Senior Quality Assurance Specialist with over twenty years (20) of combined experience as Test Manager, Agile Test Lead, Performance Test Lead, QA Lead, Business Analyst
- Software Engineer and Programmer/Analyst. He is a specialist in Quality Assurance, Quality Control, and Agile Testing. He has performed tasks related to Requirements Management
- Test Planning, Test Strategy, Test Execution, Security Testing, Performance Testing, Testing Metrics and Defect Tracking using ALM, Quality Center and JIRA.
- His background includes data warehousing using ETL, Informatica, and Cognos tools. He has substantial experience with Retail, Insurance, Financial, Manufacturing, Marketing, and Public Sector industries. In addition, he is a Certified Software Quality Analyst and Certified Scrum Master.
TECHNICAL SKILLS:
Operating Systems: Windows, UNIX
Languages: SQL, Progress
Databases: SQL Server, Oracle
Related Skills: Agile, Scrum, Application Lifecycle Management (ALM), Quality Center, JIRA, JMeter, Balsamiq, SoapUI, Keynote, Rational Team Concert, Rational composer, Rational Quality Manager, Rational ClearCase/ClearQuest, StarTeam, MS Office, SQL Server, MS Visual Studio MS Visio, Segment Studio, .NET, Informatica, ETL, ASP, COBOL, Progress 4GL, Mainframe.
PROFESSIONAL EXPERIENCE:
Business Analyst
Confidential
Responsibilities:
- Worked with Confidential assigned to Cardinal Health in the Prospect to Customer (PTC) tower team of P - Mod project.
- Identified new requirements for PTC team for customization of Sales Force and Steel Brick tools.
- Uploaded the new requirements in Confidential ALM 11.52 using MS Excel Add-in.
- Updated existing requirements for clean-up and added new requirements to create more details.
- Worked with current sprints to help the teams with requirement management: Quotes and Orders; Account, Contact and Onboarding; Sales Orders; Case Management; Campaign, Pricing and Marketing.
- Created Security requirements for based on Security profile matrix for PTC.
- Worked with Balsamiq tool to create and maintain screen mockups for requirements specification.
Confidential
Business Analyst
Responsibilities:
- Worked with Robert Half assigned to Honda R&D Americas in the Lotus Notes Migration to Microsoft solutions
- Identified the common functionalities for existing Lotus Notes custom applications internally designed.
- Created a project plan to interview business users and development team to identify common functionality for more than 1000 Lotus Notes custom application.
- Identified the possible solution for these applications like: MS Exchange, MS SharePoint, SAP, .Net custom application, Microsoft Visual Studio, Kronos, Service Now, Success Factors, Survey Monkey, etc.
Confidential
Business Analyst and Quality Assurance Lead
Responsibilities:
- Worked with Confidential assigned to BMW in Regional IT alignment (RITA) - Contract Management System (CMS) to define the Business Requirements of BMW Mexico.
- Create Use Cases of the current systems in BMW application used in USA Express and Panacredit application used in BMW Mexico and created new business requirements for the new system.
- Created the test goals for Business Proposal for all use cases.
- Worked with Quality Center to add the functional requirements and test goals in the Test Plan.
- Worked with QC Admin to customize requirements and test cases to add new fields to help to manage the test assets in QC.
- Created test cases using Behavior Driven Development (BDD) for RITA CMS.
- Worked on test planning and test execution for December 2014 Release for Credit Reporting and Payment Deferral systems.
- Application System used Microsoft Visual Studio and SQL server.
QA Lead
Confidential
Responsibilities:
- Worked with Confidential assigned to First Niagara Bank in Business Intelligence project powered by Informatica ETL tool to populate FNFG data warehouse from source systems using Agile Methodology.
- Worked with ALM as Defect Coordinator to assign to development team, follow up on open defects and assign back for retesting and closing by testers and end users.
- Created custom fields in ALM to manage defects for root cause, defect type, project, component, and other fields.
- Worked with development team to find the root cause of defects in ETL.
- Worked with development team to coordinate the Unit Test cases and publish in SharePoint by sprint for each release.
- Created reports for open defects and keep development and management informed of defects by status and severity.
Performance Test Lead
Confidential
Responsibilities:
- Worked with Confidential in partnership with Accenture assigned to Ohio Public Employees Retirement System (OPERS), Our Way Forward (OWF) - Compass project to provide one interface for all member, retiree and employer data.
- Created Performance Testing test plan and test scripts using JMeter tool for Baseline Testing and Load Testing, the goal was to support 500 external users and 500 internal users.
- Executed test scripts, created performance defects and created test results to keep development and management teams informed with timely performance results and deploy to production on project schedule.
- Created consolidated Performance Test results using MS Excel with aggregated data to analyze the trend of response time by date and by number of users.
- Used CA Wily for monitoring tool to analyze CPU, Memory, Web Services, and Garbage Collection performance; extracted SQL queries to analyze performance response time.
- Project architecture included: User Interface .Net servers, IBM’s BPM Java servers, mainframe zLinux servers with DB2, Team Foundation Server (TFS), SQL Server and Microsoft Visual Studio.
- Interfaces to legacy systems and LDAP Single Sign-on SSO.
BA/QA Lead
Confidential
Responsibilities:
- Worked with Confidential assigned to Huntington Bank in Commercial Risk Rating System (CRRS) project. Created Behavior Driven Development BDD test cases and used IBM Rational Team Concert RTC, Rational Composer, Rational Quality Manager for test strategy, Team Foundation Server (TFS).
- Used Agile Testing and Scrum Methodology, managed manual BDD test cases to deliver project sprints and releases in an Agile Development project. The development Architecture of CRRS used Java and Oracle database; Used Excel to validate the financial calculation of Risk Rating models.
- Worked with JMeter tool to execute performance testing using SoapUI web services and created performance test results.
- Participated in Sprint Planning, Release and Retrospective meetings; created test status reports and conducted defect meetings to manage the project quality.
- System application included Microsoft tools, SQL Server and Microsoft Visual Studio
Confidential
Test Lead
Responsibilities:
- Worked with Confidential State and Local Government to lead the testing team during system test. The STARS project was a 50+ million multi-year project. Created charts and status reports from Confidential Quality Center for Requirements, Test Plan, Test Lab and Defects. Used SoapUI XML to perform interface testing web services.
- Created test strategy and test design for different modules including Global Security, Documents Management System, Workflow, Returns Processing and Case Management.
- Led the team in the test case creation, review and execution of test cases for Functional Testing, Security Testing (including LDAP and SSO), To Do Testing, End to End Testing, Volume Testing and Batch Testing. Led the testing team to achieve test coverage from test cases to requirements and assisted in Defect Triage meeting for defect management.
- Worked with conversion and reporting teams to validate the converted data in STARS application from legacy systems. Worked with Agile testing and Scrum to create Behavior Driven Development (BDD) test cases.
- The STARS project used Oracle Enterprise Taxation Management ETM as code base and the ODT was applying customization for the state of Ohio business rules. The test plan includes about 8000 test cases and the requirements were more than 15,000.
- Created daily and weekly test metrics of system test and UAT, extracted data from Quality Center into Excel to create daily dashboards for test creation, test execution and defect management. Customized Quality Center Administration to add custom fields and custom code.
Test Manager
Confidential
Responsibilities:
- Worked with Confidential State and Local Government to manage the testing efforts in system testing and user acceptance testing. ERIC was 30+ million multi-year project.
- Created testing plan for system test and UAT, including test calendar for all planned test scenarios. Prepared daily, weekly, and final test results for system test and UAT to management and client.
- Provided support for test execution on different environments (Integration, System Testing, UAT and release to Production) on the Tax Unemployment Insurance (UI) project called ERIC for ODJFS.
- Created and maintained project deliverables such as System Test Plan, User Acceptance Testing Plan, UAT Calendar, System Test Results and User Acceptance Testing Results.
- Provided support on ClearQuest to manage defects and test scenarios. Collaborated with management to achieve project testing goals. The testing assets in the project were around 200 use cases, and more than 4,600 test scenarios. Managed testing meetings with client, business analysts and developers to achieve the test plan and monitor test progress.
- Provided the queries in ClearQuest to get status on test execution and open defects for system test and UAT. Provided test results, test status and metrics to management and client. Coordinated the testing efforts between the different project teams including infrastructure and security engineers, developers, testers, business analysts and trainers.
QA Lead/Business Analyst
Confidential
Responsibilities:
- Worked with Confidential State and Local Government in partnership with Accenture and Revenue Solutions Incorporated (RSI) on the Tax Unemployment Insurance (UI) project called Employer Resource Information Center (ERIC) for Ohio Department of Job and Family Services (ODJFS).
- As QA and BA for Registration module, created and maintained project deliverables such as System Requirements Design (SRD), System Requirements Specification (SRS), Use Cases, Test Scenarios, and Test Cases.
- Based on Rational Unified Process (RUP) and Unified Modeling Language (UML) worked on main project modules such as Rate, Registration, Monetary Accounting, Monetary Payments, Compliance, Collections and Common Functions. Created scenarios or test objectives to break down the use cases, specifications and business rules in testable requirements.
- Participated primarily in project documentation reviews, requirements management, integration testing, system testing, performance testing, user acceptance testing, security testing with LDAP and SSO and defect tracking. The goal of ERIC project was to provide collection of taxes based on experience rate to manage unemployment insurance for contributory and reimbursing employers.
- Tasks included create and review test scenarios, test cases and test results, defect management using ClearQuest.
Confidential
QA Lead
Responsibilities:
- Worked with Confidential at Reynolds & Reynolds Research Park in Kettering, OH for the Accounting Recovery project and Accounting Resonate Project (ARP) for RGSS as Quality Assurance Coordinator of both testing teams: Onsite QA team and Offshore QA team in Bangalore.
- Created test plan and executed manual test cases in the Accounting area for RGSS including Accounts Payable, Accounts Receivable, General Ledger, Cash Management, Purchasing, and Reports. The goal of RGSS is to provide an integrated system for all the dealership business process in the automotive industry similar to ERP.
- The project involved Sun Server, ASP Pages, and C++. Worked directly with Test Director 8.0 for requirements, test planning and test execution upgraded to Mercury Quality Center, Rational QCM/QTS and StarTeam for defect tracking and ClearCase for document repository.
- Tasks included integration and system testing and participation in review meetings to validate functional requirements and product design specifications to create test objectives, scenarios and test cases. Created test plan for effort estimation based on metrics and plan for testing resource allocation and work load distribution in both teams.
QA Tester
Confidential
Responsibilities:
- Worked with Confidential at Ohio Department of Job and Family Services (ODJFS) in Support Enforcement Tracking System (SETS) project. Executed manual and automated scripts for Case Intake, Support Enforcement, Financial Management, Case Tracking, Paternity Establishment, etc.
- The project used IBM Mainframe and COBOL and I directly used Symphony as in-house Testing tool and QARun from Compuware for automated scripts.
- Tasks included mainframe testing and execution of functional scripts during specific dates on different testing cycles to validate that sequence numbers were not generated throughout the system.
BA/QA Lead
Confidential
Responsibilities:
- Worked with Confidential at Ohio Department of Education, ODE in Ohio Education Directory System Redesign, OEDS-R project as Technical Analyst prepared an Application Conversion Plan.
- Used technologies and tools including .NET, ASP, Informatica for ETL, Oracle database on OpenVMS, SAS for data quality, ERwin for data modeling, and Test Director 7.6 for requirements, test planning, test execution and defect management. Used Keynote for load testing and Open VMS for DCL scripts to identify COBOL and SAS programs using the legacy flat files to convert.
- Prepared test plan and executed test cases. Prepared scripts in Keynote for performance testing and verify that the newly created Web application will be able to support 550 concurrent users simultaneously. Created Performance Testing reports.
Senior QA Engineer
Confidential
Responsibilities:
- Worked as System Tester for an implementation of ReactIR for In Situ Analytics (ISA) formerly Applied Systems Inc (ASI) scientific division of Mettler Toledo corporation. The ReactIR application was a scientific application that uses a reactor to create spectrum files from the reaction held is a vessel.
- The application was created in C++ and used MS Access 2000 in Client/Server or Stand Alone mode.
- Worked with Test Director 7.5 and WinRunner 7.0 for manual and automated testing, executed test cases for functional testing, test scripts for regression testing, reported test results, and identified application errors during system test to project leader and development team.
Senior QA Analyst
Confidential
Responsibilities:
- Worked as System Tester for an implementation of DealerKid in Reynolds and Reynolds. The purpose of the system was to provide to auto dealers an integrated system including customer care, car inventory, sales management, pricing information, contacts information, prospect information, bulk mail management, and interfaces with accounting system.
- Executed the test scripts, test cases, and test steps for the system. Reported the status and identified application errors during system testing to project leader and development team. This was done using a third party tool called Aardvark.
QA Manager
Confidential
Responsibilities:
- Worked as QA Manager for the Child Support Territory Automated Reporting System for Virgin Islands. PCSD (Paternity and Child Support Division) was an agency responsible for Child Support Enforcement for the US Virgin Islands. The purpose of CSTARS (Child Support Territory Automated Reporting System) was to help the PCSD - US Virgin Islands locate absent parents and recover child support obligations from them using available enforcement methods.
- Executed the test scripts, test cases, and test steps for the system and reporting the status and identified application errors during system testing to the project leader. This was done using an in-house tool SPECTRA. Also involved in some data conversion activity.
