We provide IT Staff Augmentation Services!

Business System Analyst Resume

Columbus, OhiO


  • 7+ years of progressive professional experiences in Business System Analyst Framework designing and good experience in banking domain.
  • Experienced in complete Waterfall and AGILE environment, Client /server architecture providing a well - balanced understanding of business relationships and business requirements.
  • Analyzed and Tested for Directed dialogue, DTMF, IVR and Text to speech that increased customer utilization and retention in IVR
  • Worked on custom software applications that integrated the IVR, Advanced Speech Recognition, Directed Dialogue, Call Center solutions, Genesys and Avaya CTI, Web, and foreign host connectivity and transactions
  • Expert in using Jira scrum management system for feature/ task creation, task assignment and bug tracking.
  • Proficient in database validation and test data manipulation using complicated SQL scripts.
  • Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power center.
  • Good experience in Back-End Testing using SQL queries on Oracle, MS SQL Server to validate the consistency of data.
  • Excellent analytical skills for understanding the business requirements, business rules, business process and detailed design of the application.
  • Developed excellent professional skills, by working independently and as a team member in designing, developing.
  • Experience in drawing UML diagrams (Use Case Diagrams, State diagrams, Sequence diagrams, Activity diagrams, Collaboration diagrams) using MS Visio.


Methodologies: UML, RAD, RUP, JAD, Agile(Scrum), SDLC

Requirement Management Tools: Quality Center, SharePoint

Defect Tracking Tools: Quality Center

Testing Tools: Quick Test Pro, Win Runner, Load Runner, Performance Center

Business Modeling Tools: MS Visio, MS Project

Web/Design Tools: MS Front Page, Adobe Photoshop, MS Visual Studio

Databases: SQL Server, MS Access

Programming Languages: SQL, Visual Basic, VB Scripting, Matlab

Office Tools: MS-Word, PeopleSoft, PowerPoint, Outlook, Dropbox, SAS Operating Systems Win7, Windows NT/XP/2000, Vista, UNIX, LINUX

Data Warehousing Tools: Informatica


Confidential, Columbus, Ohio

Business System Analyst


  • Worked closely with the Developers and Engineering Teams in the review and modification of the product and its specifications using Agile-testing methodology.
  • Worked Closely with SME to understand the business flow and used QA Complete to store Test Cases and for bug tracking.
  • Assigned responsibilities of planning test strategies and executing test cases in mainframe environment
  • Experience on XML, JSON and API testing to validate entire mapping documents also use UNIX to validate columns as per our mapping sheet.
  • Taken responsibility in testing voice quality and voice recognition functionality of IVR systems for high and low confidence scenarios.
  • Run SQL queries testing and data transfer to the Mainframe for claims process. Performed rigorous manual testing such Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing
  • Managed the application as Lead Tester for an ongoing Internal Insurance IVR / CTI project called RAM Revenue Assurance Management. Interfaced with Clients and Managed the Testing Team.
  • Verified, updated and validated cardholder data information, account information and authorization of transaction data in green screens of Mainframe application.
  • Designed test plans for mainframe-based utility applications and Involved in testing of Universes from different data sources like Oracle/SQL Server.
  • Used HP ALM for maintaining the Test Plans, Test Cases, Test Execution, Defect Management and Bug Reporting.
  • Wrote complex queries in SQL Server to check the data from Source and Target
  • Verified, updated and validated cardholder data information, account information and authorization of transaction data in green screens of Mainframe application.
  • Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using JIRA
  • Experience in Understanding VUI Voice User Interface documents and Call flows to extract the IVR testing scenarios
  • Create Numerous Scripts in Cyara Replay and Cyara Cruncher for functional, regression and load testing of IVR applications. Develop grammars in Nuance Grammar Builder and use them in scripts for dynamic Speech Recognition.
  • Trained 3rd party off-site QA team with various tasks including performing various types of testing, bug tracking management in JIRA
  • Involved in various meeting with developers and testers as well as being involved during UAT and Production Deployment.
  • Coordinated with the development team to help them during the defect troubleshooting & Root cause analysis.

Confidential, Rhode Island

Business System Analyst


  • Worked with Business Analysis team to prepare Test strategy and Test plan. Self-managed and self- motivated under agile methodology and involved in scrum team work.
  • Involved in the creation test cases for manual Testing and Automated Testing using QTP and QC. Designed and Scripted in QTP.
  • Assist in creation of and ensure proper execution of test specifications, test cases, test scripts in alignment with established methodology and ensure that it supports Testing objectives.
  • Test experienced w/ IVR Interactive Voice Response and JAVA/J2EE/C application development projects.
  • Experienced in reporting bugs & UI flows using Defects tracking tools such as HP Quality Center (QC, ALM), and Jira
  • Write SQL queries to validate that actual test results match expected results.
  • Worked on mainframeapplications and Web Applications for Debit Card Services from project and Regression stand point.
  • Implemented Multiple signal file fix project in Unix environment to run oldest file first and other files waiting for rerun the jobs
  • Currently experienced with automated testing tools such as Empirix Hammer Call Master IVR automation Tool, demonstrated experience independently creating test automation. Have the ability to use scripting languages to automate testing tasks Visual Basic or VBA.
  • Have a well-rounded understanding of telephony systems including IVR Interactive Voice Response testing, call management, call routing and network topology.
  • Involved in developing Test cases using requirement documents and use cases for testing the entire application manually inALM QA.
  • Worked with Database administrators to mock the production data for Regression and UAT for ECRM/COP integration with IVR Interactive Voice Response system.
  • Manual testing of mainframe applications. Create and execute SQL queries to retrieve data from DB2 databases.
  • Involved in designing and implementing of hybrid automation framework to be used with WebDriver. Performing API testing using.
  • Managed the application as a Lead for ongoing external IVR clients Agencies and Brand Partners Interfaced with Clients and Managed the Testing Team.
  • Participated in meetings with Project Managers and Developers to discuss business requirements, test planning, resource utilization, and defect tracking.
  • Developed new and updated existing Automation test cases using Testing, usingSVNas VCS for a Java based Web application, usingMavenas build tool andJenkinsto create and run deployment jobs.
  • Experienced with Positive/Negative Testing, Performance Testing, and Regression testing for Several IVR applications
  • Created manual Test Cases in HP QC/HP ALM for various User Stories based on Release and Sprint Plan.
  • Involved in weekly walkthroughs and inspections meetings to verify the status of the testing effort and the project as a whole and leading the team.

Confidential, New York, NY

Business System Analyst


  • Connected to SQL plus in UNIX and created and executed complex SQL queries.
  • Wrote complex SQL queries to perform the Back End Testing of the Oracle database using SQL.
  • Interacted with business line and Business System Analyst, responding to questions and concerns regarding the testing effort.
  • Reviewed defect log, worked with management to resolve, and assist with follow-up to ensure remediation to run books is completed
  • Provided daily status updates directly to Test Manager, including test effort, resource effort, and schedule effort.
  • Reported UAT team status to executives.
  • Used HP Quality Center & JIRA for requirements management, planning, scheduling, running tests defect tracking and managing the defects.
  • Experienced with Functional Testing, Performance Testing, Smoke Testing and User Acceptance Testing (UAT).
  • Streamlined deployment process by developing automated tests for continuous integration tools.
  • Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
  • Created complicated SQL scripts to do test data preparation and back end data verification.
  • Created defects on company Jira management system and documented test execution processes on company Confluence page.
  • Provide a weekly status update directly to the Project Manager, identifying efforts completed during the past week, as well as upcoming efforts to be completed in the next week.
  • Managed the testing control process of UAT by monitoring and investigating failures within the testing environment and drafting/reviewing policies, standards, and procedures governing testing.

Confidential, Boston, MA

Business System Analyst


  • Working with different servers inUNIX environmentand written and locate table name and database names from various script.
  • Involved in Back End testing using SQL Queries on Oracle Database
  • Implementing Quality standards and testing methodologies forWeb/Windows/Mainframe Applicationsusing Use case Documents, functional Specifications, and Business Requirements.
  • Drafted Test Scripts for Data Driven Testing using QTP to dynamically allow to put different loan parameters
  • Perform and monitor internal audits to maintain compliance to our Agile procedures and instructions
  • Managed application usability testing in pre-production and production environments.
  • Proficiency in testing progress reporting, Defect tracking and maintaining using management tools like Quality Center, JIRA
  • Prepared test scripts and data sets; configured testing tools and developed complete, automated regression suites.
  • Prepared reports and presented to management and responded to highly specialized/technical testing questions.
  • Managed a group of UAT analysts and UAT testers to ensure an acceptable service level agreement and quality control.
  • Managed the testing control process of UAT by monitoring and investigating failures within the testing environment and drafting/reviewing policies, standards, and procedures governing testing.
  • Responsible for testing patches provided by Oracle as well as enhancements/fixes provided by Academy development team.
  • Enabled CI/CD on the application using tools likeReady API,Jenkins,XLRandDDCT(in-house tool).
  • Created test plans and test cases based on the customer requirement documentations and system design documentations.
  • Involved in mapping test cases with functional requirements on the Requirement Traceability Matrix.
  • Conducted UAT with business and project stockholders.
  • Performed Load Testing using Load Runner to identify bottlenecks and breakpoints at high volumes

Hire Now