We provide IT Staff Augmentation Services!

System Analyst Resume

Columbus, OhiO

Summary of Skills:

  • Over 6 years of diversified experience in system, manual, UI, and ETL/DW testing
  • Experience using Automation Tool - Quick Test Pro (QTP).
  • In depth knowledge of SDLC and its various aspects like functionality, performance and integration
  • Expert in test Scripts development and coordinating with development team to fix bugs
  • Resourceful team player and capable of delivering tasks within stringent timeline.
  • Perform system, unit, acceptance, regression, load and functional/performance testing on dozens of applications using manual testing methods.
  • Experience assessing testing processes, creating, implementing testing strategies and SQA strategies using Agile-testing methodology.
  • Leverage knowledge of object-oriented programming to help validate, verify, communicate and resolve software issues through careful, thoroughly documented testing to maximize return on investment (ROI) for IT initiatives.

Technical Skills:

Testing tools: Quality Center, Toad, WINSQL

Languages: SQL, PL/SQL, Shell Programming, SQL*PLUS, QMF

Databases: Oracle, Access, Teradata, Netezza, UNIX

Operating Systems: Unix, Windows Vista, XP, 98, 2000, 2003, Mainframe

Software/Application: Maestro, Harvest, HP Service Center, Lotus Notes, ESP Workstation, Mercury Quality Center, Mainframe

RDBMS: SQL Server, Oracle 10g

Basic Familiarity: C+, COBOL, Java, JavaScript, VB, QTP

Work EXPERIENCE:

Confidential, Columbus, Ohio,

System Analyst, Manual Tester

  • Work on new system enhancements, client roll outs, client conversions, Client support, Parameter support, and Production Support.
  • Reviewing and providing feedback on Technical/ Functional Requirements
  • Ensuring that the delivery dates through the life cycle are being
  • Work with internal group to develop test plans, test scripts/use cases that will test the Functional Requirements, to ensure that business and users’ needs are being met.
  • Test environments and execute processes to transition applications from the test environment to the production environments.
  • Work closely with developers in tracking and resolving any defects that are identified in test or production.
  • Experience on in-house POS application and TCOP application for various POS checkpoints.
  • Lead POS certifications call with clients to insure that all sales, authorization and transactions came through in on the TCOP application
  • Created scripts and test case for the clients so they have clear understanding on what transactions are coming through on the POS system.
  • Process test Prescreen, Mobile, IC applications through our GUI System to verify that that customer is approved for credit.

Confidential, Columbus, Ohio

SR Analyst, IT ATM Testing

  • Testing all the functionality of the ATM.
  • Supporting testing for the UAT/client user
  • Defect Reporting and tracking until closure
  • Production defect description, coordination with Development team.
  • ATM and POS Monitoring.
  • Test the EPs and SPs on ATMs before released into production
  • Verified the delivery of the ATMs, Hardware and software
  • Track defects using Mercury Quality Center to report, track and analyze bugs

Confidential ; Huntington National Bank,

SR Analyst, IT QA/Testing

  • Developing test strategy and test approach documents to cover all the requirements in the testing.
  • Performed Manual Testing and Created test cases including Functional test cases, Acceptance test cases and Regression Test cases for applications on the Mainframe system.
  • Creating, Maintaining and testing defect thru Mercury Quality Center
  • Utilizing Mercury Quality Center, executed test scripts based on system requirements and refined by design decisions
  • Analyzed system requirements and document entire software testing process accordingly
  • Track defects using Mercury Quality Center to report, track and analyze bugs
  • Analyze test specifications and perform manual testing
  • Creation and execution of test cases based on user requirements, functional requirements
  • Ensured that User Acceptance Test met all customer requirements.

Confidential, Columbus, Ohio:

Confidential Application Event Management, Analyst, Infrastructure Engineer

  • Supports and maintains applications in the production
  • Test environments and execute processes to transition applications from the test environment to the production environments.
  • Analyzed application data using the SQL to identify the ETL processes
  • Monitors end-to-end production business flows and batch flows
  • Supports application development and testing, disaster recovery testing, and IT Service Management (ITSM) processes
  • Transition to ”Run” organization activities and production environment configurations
  • Work with IT Application Development Profession teams to contribute recommendations based on operational observations, Service level agreement (SLA) adherence, production performance trending, performance analysis and end user needs/requirements..

Confidential, Administration and Project Management, Analyst, IT QA/Testing

  • Created test cases including Functional test cases, Acceptance test cases and Regression Test cases for the Web focus system.
  • Worked with the components of Data Warehousing like components model, ETL tools .
  • Attended weekly meetings to discuss bugs along with testers, business analysts, and developers
  • Analyzed application data using the SQL to identify the ETL processes
  • Assisted in project development, implementation and maintenance of test data files with valid and invalid records to thoroughly test program logic and verify system flow
  • Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX shell scripting.
  • Monitored and Run Batch jobs in maestro job scheduler.
  • Collaborated with system analysts, developers and test leads to determine appropriate solutions when defects were discovered
  • Creating, Maintaining and testing defect thru Mercury Quality Center
  • Performed Automation Test and Regression Test scripts in QTP
  • Coordinated with developers and system engineers to fix application defects
  • Used Quick Test Pro (QTP) for automating manual test cases for regression testing.

RADS National Financial Data Warehouse, Analyst, IT QA/Testing

  • Assisted in project development, implementation and maintenance of test data files with valid and invalid records to thoroughly test program logic and verify system flow.
  • Experience assessing testing processes, creating, implementing testing strategies and SQA strategies using Agile-testing methodology.
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
  • Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
  • Reviewed and updated the existing Test Plan. Developed test plans using Technical specifications, requirements and use cases.
  • Wrote SQL queries to test Data Integrity, Referential Integrity and performed Database Testing for the Application.
  • Regression testing to ensure that the functionality of the application matched with the Business Requirements.
  • Practiced Agile methodology to test production defect code solutions
  • Performed the tasks of developing testable user stories by coordinating with business staff
  • Analyzed application data using the SQL to identify the ETL processes
  • Run and Modify Updates, Inserts, and deletes Queries in Alpha and Beta test environments.
  • Create and Modify SQL code in Teradata, Netezza, and Oracle
  • Executed the Test Cases to verify actual results to expected results.
  • Perform backend data validation/testing
  • Use Agile Methodology with system software testing: black box, white box, regressing testing
  • Performed various functions prior to conducting tests such as data analysis and mapping
  • Tested the ETL Informatica mappings and other ETL Processes ( Data Warehouse Testing )
  • Carried out Manual Testing with UNIX Shell scripts, SQL scripts, etc.
  • Responsible for testing the product using SQL Queries/ UNIX command for the DB check and server startup/new builds.
  • Developed SQL queries and generated Audit reports based on business Requirements.
  • Experience assessing testing processes, creating, implementing testing strategies and SQA strategies using Agile-testing methodology in UAT phase.
  • Wrote SQL queries to test data integration and performed Database Testing for the Application.

Hire Now