We provide IT Staff Augmentation Services!

Data/business Analyst Resume

5.00/5 (Submit Your Rating)

Willmington, DE

SUMMARY

  • 8 Years of experience as a DATA/BUSINESS/SYSTEMS/QUALITY ANALYST Quality Control testing, Background testing, deployment of web - based, client-server applications, developing business processes and system solutions in in various domains such as Banking, Mortgage, Retail, Banking, Accounting/Tax, Ecommerce & Information Technology.
  • Exceptional Analysis skills with an ability to transform the needs of business users and stakeholders into functional / technical requirements.
  • Experience in preparing Business requirements documents (BRD’s), defining project plans, writing system requirements specifications, and delivering project / status reports.
  • Extensive experience with the System Development Life Cycle (SDLC) & Software Testing Life Cycle (STLC).
  • Working experience with various SDLC methodologies such as Waterfall, RUP and Agile.
  • Worked extensively through agile development methodology by dividing the application into iterations.
  • Experience in process modeling using UML to design Use Cases, Sequence Diagrams, Activity Diagrams, Class Diagrams and Data Modeling.
  • Ability to gather business and technical requirements from both formal and informal sessions and adept in prioritizing requirements based on business needs and managing resources and budget for the project.
  • A Key Team player in conducting Peer reviews, Brainstorming, walkthroughs and coordinating JAD sessions to confirm and playback business requirements for a project.
  • Experience with performing Gap Analysis to determine the existing system, documenting, and approving the variance between business requirements and system capabilities.
  • Effectively translated business rules and data rules to data transformation good understanding of the ETL process.
  • Experienced in MS Office Suite, MS Visio, iRise and gathering user requirements and technical documentation.
  • Experienced in Requirements Traceability Matrix (RTM), test plan and test procedure development and review, project customization and administration, defect management, configuration management and version control, and business documentation.
  • Worked extensively with the QA teams to support designing/writing Test Plan and Test Cases for the Unit/system/regression/User Acceptance testing.
  • Expertise in performing Manual and Automated tests using Test director and Quality Center.
  • Extensive experience in design, writing, implementation and execution of test plans/test cases, Bug reports and developing test scripts.
  • Experienced in Integration, Regression, Smoke and End- to-End Testing.
  • Analyzed and Reported Defects using Quality Center, and Interacted well with Developers and team members in fixing bugs.
  • Experience in all areas of manual software testing Data Validation and Verification, Functionality, System, Usability.
  • Have a solid foundation for working on SQL Server Databases, Queries, creating and optimizing Stored Procedures.
  • Experience in working on internet related technologies such as HTML, JavaScript, DHTML, CSS, XSLT, HTTP, and HTTPS.
  • Worked with web based, windows based and e-commerce applications.
  • Worked on Databases like Oracle/SQL, SQL Server 2000/2005/2008.
  • Ability to handle multiple tasks and work independently as well as in team.
  • Good Analytical, Technical, Organizational skills coupled with excellent written and verbal communication skills.
  • Ability to work with OFFSHORE team effectively.

TECHNICAL SKILLS

Business Analysis: MS Visio, MS Office, iRise, Requisite Pro, Rational Rose

Methodologies: Waterfall/Spiral, JAD, RUP, Agile, UML, Prototyping

Languages: SQL, UML, HTML, XML, Java Script, Java, J2EE, .NET

Testing: Manual Testing, Quality Center

Databases: Oracle, MS SQL, MS Access

Operating Systems: Windows 7/Vista/XP/NT/98/95, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, WILLMINGTON, DE

DATA/BUSINESS ANALYST

Responsibilities:

  • Interacted with the Business Users (SME) to get a better understanding of client business processes and gathered Business Requirements.
  • Efficiently created Business Process Models (BPM) to document the current state of the systems and business workflow using Visio.
  • Wrote and maintained Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) defining new systems operations for the project using Rational Requisite Pro.
  • Involved in writing Business Requirement Matrix.
  • Mapping back and documenting the calculation of each field in a report.
  • Identifying the source of all data back to SOR ( System of Record)
  • Identification of impact UDBA's solution may enhance controls or identifying ICDW as solution going forward
  • Involved in writing SQL queries using Joins, Unions to retrieve and test the date from the database.
  • Worked with SAS code to identify the source of data.
  • Involved in writing SQL queries using Joins, Unions to retrieve and test the data from the database.
  • Used HP Quality Center for Defect management, Requirements module, Test Design and execution.
  • Prepared the traceability matrices to fill the gap between the requirements and the test cases covered.
  • Efficiently coordinated with the offshore team for design as well as the testing.
  • Used Microsoft SharePoint for document management and as a common repository for project documents and deliverables.
  • Tools: ALM 11.0, SAS, Microsoft SharePoint, Microsoft Visio, Agile, UML, SQL, PL/SQL, SAS, MS Office, MS-Project, Microsoft Excel, Word.

Confidential, LAKE MARY, FL

BUSINESS ANALYST

Responsibilities:

  • Facilitated in the creation of functional requirements specifications (FRS) and preparation of business requirement documents using Rational Requisite Pro that provided appropriate scope of work for the technical team to develop a working prototype and an overall system.
  • Analyzed and documented the integration requirements for signature core to Corillian Online Banking System and Voice response Unit.
  • Documented the current state and future state of the system by creating activity diagrams to preform GAP analysis.
  • Conducted GAP analysis between the requirement specifications and the existing system.
  • Facilitated the discussions with the business users to arrive at the list of features of the application to be developed and rated the same on a criticality index.
  • Used Enterprise Architect to create activity diagrams, sequence diagrams and collaboration diagrams.
  • Obtained sign-off of the appropriate business documents from the internal management and end users
  • Collaborated with the implementation team and provided guidance for the development/integration team.
  • Participated in Test Plan creation to provide details of the scope and participated in planning the testing environment.
  • Reviewed development plans, quality assurance test plans, and user documentation to ensure correct interpretation of original specifications.
  • Tools: MS Office, MS Visio, Agile, Rational Requisite Pro, Rational Rose, UML, SQL, PL/SQL, MS Office, MS-Project, Windows 2000, Quality Center.

Confidential, CHICAGO, IL

BUSINESS/QA ANALYST

Responsibilities:

  • Interacted with the Business Users to get a better understanding of client business processes and gathered Business Requirements.
  • Wrote and maintained Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) defining new systems operations for the project using Rational Requisite Pro.
  • Automated the business work flow for Campaign management and email marketing of new loan products using Aprimo.
  • Created Use cases, Use Case Diagram, Business flow diagram using Unified modeling language (UML).
  • Created Use cases, and developed detailed Use Case Diagrams and Sequence diagrams describing how actions are to be carried out using MS Visio.
  • Created User Stories to communicate requirements to the development team.
  • Worked on creating the business requirements for Data Migration from Legacy system to new Oracle database.
  • Performed Back-end testing, compare and validate data between SQL Server 2005 and Oracle 11g using beyond compare tool.
  • Involved in writing SQL queries using Joins, Sub-Queries, and Unions to retrieve and test the data via SQL developer for Oracle 11g and SQL Server 2005.
  • Logging, trouble shooting and retesting defects, and provide testing and defects status reports.
  • Efficiently coordinated with the offshore team for design as well as the testing.
  • Involved in the Functional Design phase by creating Screen Mockups (UI) and Process Flow Diagrams using Microsoft Visio.
  • Conducted Application Simulation using iRise to assist Business Stakeholders with a preview to the actual Application Development.
  • Used Microsoft SharePoint for document management and as a common repository for project documents and deliverables.
  • Involved in verifying the change request for existing scripts.
  • Prepared the traceability matrices to fill the gap between the requirements and the test cases covered.
  • Involved in defect triage call.
  • Performed Root Cause Analysis of Defects found during Unit Testing.
  • Conducted GUI, functional and end-to-end testing of the applications.
  • Used HP Quality Center for Defect management, Requirements module, Test Design and execution.
  • Ongoing Knowledge transfer to users and the new comers.

Confidential, WICHITA, KS

BUSINESS/RELEASE SUPPORT ANALYST

Responsibilities:

  • Interacted with the Business Users to get a better understanding of client business processes and gathered Business Requirements.
  • Wrote and maintained Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) defining new systems operations for the project using Rational Requisite Pro.
  • Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project
  • Created Use cases, Use Case Diagram, Business flow diagram using Unified modeling language (UML).
  • Created Use cases, and developed detailed Use Case Diagrams and Sequence diagrams describing how actions are to be carried out using MS Visio.
  • Developed, reviewed and executed Functional test plans, Test Case (manual) from requirements and other sources that can be understood and easily followed by other quality associates.
  • Created and Executed System and Integration Test Scripts.
  • Worked in the testing of non-GUI systems with particular knowledge of interface/integration testing requirements.
  • Facilitated and participated in test plan and test case reviews with the test team, subject matter experts, and development to ensure the content, scope and accuracy of all test plans using Quality Center.
  • Research, develop, implement, and maintain various environmental changes in the testing environments (such as Operating System and software upgrades, database upgrades, hardware changes and migrations etc.)
  • Involved in the testing and implementing the DML, DDL and Store Proc.
  • Involved in writing SQL queries using Joins, Unions to retrieve and test the date from the database.
  • Extensive knowledge of functional and non-functional testing.
  • Logging, trouble shooting and retesting defects, and provide testing and defects status reports.
  • Extensively used XML to store the data and parse the data confirming to a specified schema for web service testing.
  • Involved in manual testing for web services, Enhanced and maintained scripts and functionality by adding various checkpoints and scenarios.
  • Responsible for handling multiple tasks meeting deadlines, Write and design the layout of the SQL statement and Store Proc.
  • Execute test cases and scripts and follow through on the prioritization and resolutions of defects.
  • Developed XML input file to test Web services implemented in STO, Helped create relevant test cases along with the testing team.
  • Efficiently coordinated with the offshore team for design as well as the testing.

Confidential

QA TESTER

Responsibilities:

  • Analyzed system requirements on base on business documents and developed detailed Test Cases.
  • Responsible for weekly status updates showing the progress of the testing effort and open issues to be resolved.
  • Involved in tracking, reviewing, analyzing and comparing bugs using Excel Sheet.
  • Generated the detailed reports of the Bugs, Pass-Fail report, Comparison Chart using Excel Sheet.
  • Prepared the Defect reports and interacted with developers for Debugging.
  • Performed Functional and Regression testing.
  • Involved in the testing and implementing the DML, DDL and Store Proc.
  • Involved in writing SQL queries using Joins, Unions to retrieve and test the date from the database.
  • Attended meetings on weekly basis and provide feedbacks and suggestions to Project Manager.
  • Tools: MS Excel, MS Word, Windows 2000.

Confidential

SYSTEM ANALYST

Responsibilities:

  • Designed and implemented systems for acquisition applications.
  • Performed system maintenance programming.
  • Wrote computer system procedure specifications and user manuals.
  • Designed and supervised programming of tracking system that determined more cost-effective transportation routes.

Confidential

SYSTEM ANALYST

Responsibilities:

  • Interacted with the Business Users to get a better understanding of client business processes and gathered Business Requirements.
  • Wrote and maintained Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) defining new systems operations for the project using Rational Requisite Pro.
  • Created Use cases, Use Case Diagram, Business flow diagram using Unified modeling language (UML).
  • Created Use cases, and developed detailed Use Case Diagrams and Sequence diagrams describing how actions are to be carried out using MS Visio.
  • Gathering user and usability requirements to create screen mockups and write UI specification documents.
  • Designed and implemented systems for acquisition applications.
  • Performed system maintenance programming.
  • Wrote computer system procedure specifications and user manuals.
  • Designed and supervised programming of tracking system that determined more cost-effective transportation routes.
  • Served as liaison between system users and technical support group.
  • Trained field system users.

We'd love your feedback!