We provide IT Staff Augmentation Services!

Business Analyst / Uat Tester Edr - Party Master Resume

VA

SUMMARY:

  • Over twelve years experience in managing IT system development life cycle projects from scope definition, requirements gathering, analysis and design, development, testing plan and strategy development, to deployment and implementation.
  • Extensive experience in managing business requirements gathering, analysis, design and implement business systems projects in Financial, telecommunications and Risk Analysis domain applications.
  • Excellent analytical, technical skills, problem solving, customer relationship management and team building skills.
  • Solid experience leading teams working on business process design, data warehouse life cycle and business intelligence related projects.
  • Extensive experience in define stakeholder requirements, technical specifications, mapping document of data movement and BI reporting.
  • Solid experience in design and execute testing cases, testing scripts from unit testing, user acceptance testing, integration testing and regression testing.
  • Solid experience in define and execute data quality control by using metadata and data profiling tools.
  • Experience in streamlining business process and leading new development efforts.
  • Extensive knowledge of Investment Banking, Fixed Income and Derivative instruments such as CDS, IRS, Forwards and Futures etc.
  • Well experienced in all phases of SDLC (Software Development Life Cycle) with significant skills in requirement gathering, analysis, specification, design, development, deployment and testing. Good understanding and knowledge of RUP, Agile and Waterfall methodologies.
  • Experienced in conducting analysis and requirements sessions with Stakeholders, End Users and Development team.
  • Preparation of Business Requirement Document (BRD), Functional and Supplementary Specification Documents for comparison of Current State Analysis Document and Future State Analysis Document to do a thorough GAP Analysis for making enhancements.
  • Participate in requirements review, design review and code reviews to identify common errors
  • Expertise in estimating and deriving schedules for development / test execution
  • Experienced in replicating field issues reported by end users, investigate the problem and identify corrective measures
  • Expertise in writing complex SQL queries to analyze the data and prepare dev guides accordingly
  • Experience in working with Multiple Relational Databases like Oracle 9i/8i/7.x, SQL Server 2000, MS Access, XML and Flat Files.
  • Enthusiastic self - starter with great work attitude, excellent communication, presentation Skills and Leadership Qualities.

TECHNICAL COMPETENCIES:

ETL Tools: Informatica Power Center 8.5/7.1.2/7.1.3 , Data stage

Reporting Tools: Business Objects, Micro Strategy

RDBMS: MS SQLServer, Oracle, DB2, TOAD

Languages: C, C++, SQL, PL/SQL, JAVA, VB, VB.Net, PERL

Scripting Languages: HTML, DHTML

Operating Systems: Windows NT, 2000, XP, DOS, UNIX

Workflow Tools: MS-Visio, MS-Project 2000, MS-Excel, MS-Word, MS-PowerPoint

Bug Reporting Tools: Test Director 8.0, HP Quality Center 11.0

PROFESSIONAL EXPERIENCE:

Confidential, VA

Business Analyst / UAT Tester EDR - Party Master

Responsibilities:

  • Worked in understanding the business requirements, data requirements and writing requirement specs and technical specs and reporting needs to the end user community.
  • Investigating and resolving data issues across different documents, including discrepancies of definition, format and function.
  • Analyze and document data quality rules for validation of data between applications
  • Upon approval of requirement specification document, created project plan and test plan documents
  • Extensively participated in writing UAT test cases of the newly developed applications and map them to the requirements to ensure test coverage.
  • Developed SQL queries to validate the functionality and hence making sure it meets the end user specifications
  • Built test grids in microstrategy and match with the actual end user reports for data accuracy and UI functionality.
  • Analyze and update the source to target documents based on data dictionary and ELDM (Enterprise Logical Data Model) documents.
  • Coordinate the meetings/activities between the various IT teams and the clients to maintain effective communication and working relationships.
  • Verified the quality of the incoming Source data provided by vendors at the staging level
  • Upload and maintain the requirements in DOORS also running the baseline and difference reports.
  • Manage defects using the Defects module of HPALM and involved in impact analysis of the defects and discussing the issues with the technical team

Environment: Oracle, SQL, Sybase, TOAD for Oracle, TOAD for data Analytics, TOAD for SQL server, Aqua Data Studio, HPALM, Microstrategy, DOORS and Share Point.

Confidential, NJ

Sr. Business Analyst

Responsibilities:

  • Worked extensively in understanding the business rules, data requirements and writing requirement specs, technical specs and mapping documents from staging to data warehouse, data mart, and reporting needs to the end user community.
  • Document feed specification document according to ARCTIC SLAs and requirements.
  • Utilized Informatica Data explorer to perform data profiling to better understand the source data and refine the business requirements, especially the data quality requirements.
  • Investigating and resolving data issues across platforms and applications, including discrepancies of definition, format and function.
  • Analyzed and documented data mapping rules for movement of data between applications
  • Extensively participated in the testing of the newly developed applications to ensure quality meets the requirements by developing SQL queries and/or generate reports from application for huge volumes of data
  • Upon approval of requirement specification document, created project plan and test plan documents.
  • Coordinated the meetings/activities between the various IT teams and the clients to maintain effective communication and working relationships.
  • Worked closely with the Regulatory Requirements Reporting team on validating the data before the snapshots are delivered downstream.
  • Validated database by running automation scripts, SQL queries and comparing the Data. Extensively used the TOAD for Oracle/SQL server for writing SQL statements.
  • Verified the quality of the incoming Source data provided by vendors at the staging level
  • Performed UAT Testing and provided support in production by tracking production issues and troubleshooting them to sustain the application in production.
  • Managed defects using the Defects module of Quality Center and involved in impact analysis of the defects and discussing the issues with the technical team

Environment: Informatica Power Center, Oracle, SQL, Sybase, TOAD for Oracle, TOAD for data Analytics, TOAD for SQL server, Aqua Data Studio, Mercury Quality Center, Team Track, Share Point and JIRA

Confidential, VA

Sr. Business Analyst

Responsibilities:

  • Worked extensively in understanding the business rules, data requirements and writing requirement specs, technical specs and mapping documents from staging to data warehouse, data mart, and reporting needs to the end user community.
  • Collected, analyzed and prepared user requirements, definitions, scope and expectations for deliverable plans. Delivered system documents, processes, diagrams and test cases.
  • Defined business processes, identified gaps, evaluated requirements and change requests, and managed the project’s scope.
  • Utilized Informatica Data explorer to perform data profiling to better understand the source data and refine the business requirements, especially the data quality requirements.
  • Investigating and resolving data issues across platforms and applications.
  • Meeting with Upstream and Downstream users to finalize business requirements and customize data sent to downstreams.
  • Ensured all QA testing efforts meet company standards, goals and auditing requirements and delivered on time.
  • Gained expertise of the flow of the data from the source through the ETL process into the target warehouse.
  • Actively participated in creating test plans and requirements traceability matrices, i.e. tracing the test cases to business requirements, ensuring proper coverage.
  • Involved in developing entry & exit criteria and defined the pass and fail standards.
  • Validated the data at each transformation - The source tables, the staging tables, the loading tables and finally the destination tables/views - using the data mapping files and data dictionaries.
  • Responsible for creation of project plan, defining BA tasks to be done and estimating timelines for those tasks.
  • Analyzing the ETL process created in Informatica, developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables and suggest any corrective action.
  • Participate in bug reviews to ensure that quality criteria are met.
  • Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation (detecting and rejecting bad data) and actual ETL functionality (properly processing good data i.e., transformations, calculations, and derivations).
  • Responsible for analyzing and validation of any additions/modifications to the MicroStrategy reports before release to production.
  • Improving specification and design documents through active review and feedback with developers.
  • Having exposure to integration of data across more than 15 sources in an ETL process, versioning, manual correction of tables, address correction.
  • Identifying and logging defects if a test fails, if necessary, using SQL to narrow down the root cause of the problem for efficient investigation by the development team and log accordingly.
  • Using TOAD for generating SQL queries for checking the Data Transactions and Database Integrity.

Environment: Informatica Power Center 8.5/7.1.3/BI, Oracle 9i, SQL, TOAD, Mercury Quality Center, Team Track, Share Point.

Confidential, NJ

Business Analyst

Responsibilities:

  • Developed and assisted in the implementation of the project (SDLC) Software Development Lifecycle throughout the organization processes included Planning, Design, Testing and Implementation phases.
  • Analyzed business requirements and system specifications and defined business processes, identified gaps, evaluated requirements and change requests, and managed the project’s scope.
  • Verified the functional aspect as per the Business Process.
  • Interacted with various members at the management level to understand business processes, decision models and analysis needs and created functional and non-functional requirements using Rational Requisite Pro.
  • Performed the Analysis & Design workflow for same- day/ next-day/ zero day trade settlement systems by following the RUP including modeling the pre-defined business requirements with Rational Rose to document Business Use Cases, System Use Cases and create Process Scenarios.
  • Responsible for reviewing the UML-based design and resulting code to ensure that they met defined requirements.
  • Performed extensive requirement analysis including data analysis and gap analysis.
  • Documented the defects and their trailing history in the Test Director.
  • Responsible for creating complete test cases of varying complexity, executing tests, measuring expected and actual results, and reporting status ensuring accurate coverage of requirements and business rules.
  • Formulated the QA plan for black box testing of the application including Functional Testing, Performance Testing, Regression Testing, Usability Testing and User Acceptance Testing.
  • Verified the software application according to the requirement specification (SRS).

Environment: Informatica Power Center/BI, MicroStrategy, Oracle 9i, DB2, SQL, Mercury Quality Center, TOAD, Aqua Data studio, Windows NT & Unix.

Confidential, OR

Sr.QA/ BA

Responsibilities:

  • Responsible for managing a team(onshore and offsite), planning activities, creating Dev guide, creating test plan, review and suggest necessary modifications.
  • Review the requirements and prepare requirements documents based on review sessions.
  • Conduct weekly status meetings to discuss the testing progress and weekly activities.
  • Perform test data set-up for testing and update changes based on the requirements.
  • Create new build and database backups. Create and maintain test environment.
  • Responsible for writing Test plans, Test scenarios and Test cases based on business and functional requirements.
  • Creating test case and test sets, tracing them to requirements and executing them in Mercury Quality center.
  • Participate in bug reviews to ensure that quality criteria are met.
  • Import the .csv data file through Hyrda, an internal process tool and follow the complete flow until the generation of reports. Maintain data flow documentation.
  • Extensively used SQL queries to perform database testing to check the Data Integrity.
  • Verify the data in staging and permanent tables against the reports generated.
  • Execute the stored procedures and views for grouping of data and generation of reports.
  • Create SCRs(System change requests) and defects in PVCS Tracker and followed up until resolution with the developers.

Environment: Crystal reports, Visual Basic, Microsoft Visual SourceSafe, SQL, SQL Server management studio, Microsoft Quality center, Rational ClearCase, Rational ClearQuest, Manual Testing

Confidential, WA

Sr.QA/BA

Responsibilities:

  • Responsible for managing a team of 6 and executing planning activities, creating test plan and standard templates (Daily status, defect status, defect process etc.)
  • Responsible for assigning tasks and managing the onsite and offshore teams
  • Analysis/Design for User interface and databases. Estimation of the effort required for testing and test plan preparation.
  • Study and analysis of Functional Requirements
  • Configuration management and Review LLD (Low Level Design).
  • Used cluster test approach where appropriate.
  • Regress high-level functionality of previous releases to ensure new code/configuration has not adversely impacted code already in production.
  • Load and Unload flat files from Unix Box .
  • Executed PERL scripts to perform changes in MABEL files.
  • Verify not only the positive scenarios, but also conduct exception/negative testing (i.e. error handling).
  • Ensure that all systems included in a particular release are thoroughly tested before entering Integrated System Testing and/or Production.
  • Participated in checkpoint reviews and walkthroughs during the verification and validation process.
  • Involved in project planning, coordination and implementation of QA methodology.
  • Participated in writing HLS(High Level Scenarios), Test plans, Test scenarios and Test cases, software documentation from business and functional requirement.
  • Generated Reports using internal Cingular tools to report the daily status and Test Summary.
  • Reported defects in Clear quest and followed up on the resolution with the developers.

Environment: Sybase, UNIX, SQL Server, PERL, Shell Scripts, Java, Windows XP, Test Director, Toad and Manual Testing

Confidential, WA

Sr. Quality Analyst

Responsibilities:

  • Responsible for managing a team of 6 and executing planning activities, creating test plan and standard templates (Daily status, defect status, defect process etc.)
  • Participated in writing HLS (High Level Scenarios), Test plans, Test scenarios and Test cases, software documentation from business and functional requirement.
  • Tested the web application for multiple logins and verify unauthorised accesses
  • Performed stress and load test for the web application to verify the performance of the application
  • Conducted data integrity testing by extensive use of SQL Queries to perform back-end testing.
  • Performed Import / Export / SQL* Load in oracle database
  • Participated scheduled meetings and maintained good relationship with developers.
  • Attended daily status meetings to discuss the testing progress
  • Validated mocked up data to ensure that they follow the specifications
  • Load and Unload flat files from Unix Box
  • Executed PERL scripts to perform changes in MABEL files.
  • Reported and tracked function defects using Clear Quest, Issue Tracker
  • Testing to ensure that BID sends the feed files correctly and Confidential receives them in expected format.
  • Tested the application to verify Internationalization
  • Testing the format and content of feeds from BID to Confidential - BID Service Feed, BID Features Feed, BID Fan to Account Changes Feed and BID EOD Feed and loading them in Confidential Database.
  • MMT System Testing and Regression Testing

Environment: E-commerce, Oracle 8i, SQL, Unix, Windows XP, Java, Test Director7.6, Toad and Manual Testing

Confidential, CA

Sr. Quality Analyst

Responsibilities:

  • Prepared the Test cases and Test Scripts.
  • Performed manual testing by executing the test scripts.
  • Exclusively used the Mercury Interactive Test Directory to write test cases and executing and also logging the defects.
  • Performed Automation using Winrunner to automate the test cases.
  • Investigated faults and interacted with developers to resolve technical issues.
  • Performed functional, integration, regression and User Acceptance tests.
  • Generating and testing of customized reports for all maintenance related activities.
  • Regularly followed up with the development team to discuss the defects identified during testing.
  • Involved in submitting Bug Report weekly.
  • Involved in functional testing, System testing, Integration testing and Regression testing.
  • Regularly followed up with the development team to discuss the defects identified during testing.
  • Performed Load testing, Performance testing and Stress testing using LoadRunner

Environment: Java2, HTML, C++, Oracle9i, UNIX, Windows XP, Mercury Suite (Test Director7.5, Winrunner 7.5, LoadRunner 6.5), QTP, Manual Testing, SQL, PL/SQL

Confidential

Quality Analyst

Responsibilities:

  • Created a detailed Test plan manually as per requirement specification identifying various test scenarios.
  • Involved in both Manual and Automation testing.
  • Running Load Runner for Scenarios with various user-mix incrementing in constant ratios, thus reaching the peak load of 1000 Virtual Users.
  • Automation of test cases using WinRunner and developing and configuring the GUI map files for each line of business. Compatibility testing on different versions of Netscape and Internet Explorer browsers.
  • Performed Functionality, Security, system and User acceptance testing.
  • Performed Client/server testing using WinRunner.
  • Attending Change Request meetings to better understand the application. Used Test-Director to track the bugs.

Environment: Java, EJB, Weblogic, JSP, XML, WinRunner 6.0, Load Runner 6.0 and Toad.

Hire Now