We provide IT Staff Augmentation Services!

Systems Analyst Resume Profile

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

Confidential

System Analyst

  • 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

SR Analyst

  • 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

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

  • 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..

Project Management

  • 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.

Data Warehouse

Confidential

  • 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