We provide IT Staff Augmentation Services!

Ba + Etl Qa Resume

SUMMARY

  • 9+ Years of Experience as a combo of Business Analyst / Quality Analyst with depth strong working knowledge of all phases of Software Development Lifecycle. Worked in Banking, Insurance, ECommerce, Digital Marketing & Medical Health Care Industry.

TECHNICAL SKILLS

  • ALM, Trello, JIRA, Rational Requisite Pro, Microsoft Power BI, Business Objects
  • UNIX, Windows 10/8/7, Linux, Sun Solaris, Tableau, Balsamiq, SQL, Word, Excel
  • Visio PowerPoint, Outlook Project, SharePoint,Brain Storming - Miro, Google Doc
  • Google Sheet, Google Drive, DocHub,Slack, Skype For Business
  • Google, Mercury HP Quality Center, Selenium IDE

PROFESSIONAL EXPERIENCE

BA + ETL QA

Confidential

Responsibilities:

  • Executed several Test Scripts involving Negative and Critical Scenarios.
  • Prepared Business Process Models and business rules that included modeling of all activities of the business from conceptual to procedural level.
  • Collaborated with the User Experience team to design user interface specifications.
  • Facilitated conversations between software developers for different applications and QA testers to address all issues and open items.
  • Used SQL query extensively to test OLTP vs OLAP data and coordinated with the technical team to fix ETL/Filter related defects.
  • Track record of strong software development project management experience utilizing agile techniques and approaches.
  • Worked on the development and changes to the look and feel of the product and Lead the UAT phase of the project.
  • Discovered and documented as - is and to-be scenarios of organizational processes, technologies, and challenges in detail.
  • Performed the requirement analysis and documented the requirements using Visio.
  • Tested new application utilizing Agile Scrum methodology.
  • Prepare client presentations with PowerPoint, Project, or other media.
  • Performed required data analysis, interpretation, correction, and document presentation for various assignments.
  • Performed ongoing development assessments for evaluations of the SDLC Development Standards and other related documents.
  • Compiled the daily field reports from various inspection engineers, reviewed them, and uploaded them on SharePoint on daily basis.
  • Elicited requirements by observing the decision-makers to understand the business requirements for risk data mart and Data warehouse.
  • Involved in entering and updating Issues (Epics, Stories, and Tasks) into JIRA Agile application.
  • Involved in the discussions with Business users /Project SME's for complete end-to-end migration of TRAID to ODM.
  • Gathered requirements from using tools namely interviews and JAD sessions and translated them into functional requirements.
  • Plan and define system requirements for Use Case, Use Case Scenario, and Use Case Narrative using the UML methodologies.
  • Created Virtual users and test scenarios executed and monitored that scenario and analyzed the test results using JetStress Load Testing.
  • Have exposure to Java Scripting while working with the development team.
  • Experience in process modeling using Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class Diagrams.
  • Performed system compatibility tests on various platforms such as Macintosh and Windows.
  • Analyzed As-Is Application development process within the WorldPort IT department.
  • Analyzed system Specifications and design documents and developed test plans in Test Director.
  • Worked with UI designers on making changes to HTML, CSS, and Javascript.
  • Defined ETL for the data source systems.
  • Involved with the technical team in understanding the XML file format required for the billing process.
  • Developed using Agile methodology working on two-week sprints.
  • Performed functionality testing, GUI testing, regression testing, and black-box testing based on test cases.
  • Supported/managed a wide range of internal customer service tools and third-party vendor software using Agile project management methodologies.
  • Make recommendations for improvement and ensure integration into the system meets business requirements and technical specifications.
  • Analyzed, wrote technical specifications, and managed a team of outsourced developers for the DB2 inventory accounting system.
  • Detailed understanding and hands-on testing systems experience (HP QC and PC) across operational and corporate functional areas.
  • Tested backend files on the respective server (master and slave both) using UNIX commands.
  • Adhere to state-regulated standards as it pertains to HIPPA, SOX, and CMS Standards.
  • Performed Mainframe testing for different applications like SIS, Auto Plus, and Property Plus for Commercial Lines.
  • Worked on the Procedure and Diagnosis code sets
  • Translated business ideas and data into relational data models utilizing TOAD.
  • Prepared Use cases and Activity flow diagrams and Workflow diagrams, considering the scope of the project.
  • Support for Pre-Production System Integration Testing.
  • Executed and monitored initiatives that included planning, risk management, requirement management, procurement, and resource management.
  • Maintained requirements in Rational RequisitePro and tracked changes.
  • Documented components of BRD, FRD, non-functional Requirements, and data from the project stakeholders.

BA/QA

Confidential

Responsibilities:

  • Reviewed specifications, developed test plans and test scripts for Agent Recognition/Compensation.
  • Performed Requirement gathering and documentation of business processes use cases, functional specifications, and business rules in Agile SDLC methodology.
  • Documented the user interface design functional and non - functional requirements using visuals i.e.
  • Facilitated daily JAD sessions with off-shore third-party development vendors and QA resources to gather additional requirements or enhancements.
  • Performed Database integrity testing by executing SQL statements.
  • Performed Business and Technical requirements gathering for a web application developed using Agile software development methodology.
  • Involved in User Acceptance Testing (UAT), System Integration testing (SIT), and functional testing for each process.
  • Performed Gap Analysis based on AS-IS and To-BE documentation and prepared Business Requirement Document (BRD).
  • Analyzed business requirements and developed Use Cases and activity diagrams using Microsoft Visio according to UML methodology.
  • Followed Scrum Methodology for appropriate planning and development process.
  • Trained new associates on a global team using WebEx and PowerPoint, increasing productivity and functionality.
  • Performed data analysis and business rule research, developed functional business rules and program specifications.
  • Implemented SDLC which included requirements, specifications, design, analysis, and testing utilizing Agile methodology.
  • Developed, tested, and implemented internal intranet SharePoint site.
  • Facilitate data requirements sessions between data warehouse and business user teams as well as coordinate data migration tasks as needed.
  • Involved in IT Service Management software tools like JIRA for defect-tracking & reporting requests and tracking them to completion.
  • Tested Risk requirements through the Test director and evaluated results by interviewing users and Subject Matter Experts (SME).
  • Participated in JAD sessions to develop an architectural solution that the application meets the business requirements.
  • Involved in Requirement analysis along with the creation of Use Case Scenarios and modeling of the business and application using UML.
  • Presented supporting evidence of successful and deficient test results.
  • Worked as a Java developer for developing the front-end components and the web services.
  • Created Analysis Model and Data Model and used these artifacts to develop the Design Model: Collaboration, and Sequence Diagrams.
  • Created PIMS collection calendar and proposed the collection windows and data set combinations collected within each window.
  • Worked with the business users to create As-Is process maps.
  • Facilitated walk-through for a review of specification requirements and internal design documents with development.
  • Design and tested HTML web pages.
  • Conducted demo sessions for database architects and ETL developers for fitting the data from the new sources.
  • Worked on a project using the SOA architecture for making XML calls to TSYS for payment file processing.
  • Elicited and documented user requirements for Oracle Fusion Applications through Agile methodology.
  • Lead the system testing efforts for the application GUI and see if the data was consistent with the requirements.
  • Followed a hybrid of Waterfall, RUP, and Agile approaches of development throughout the project.
  • Project management of new module configuration and implementation for MSOW including electronic medical staff office credentialing and provider applications.
  • Inserted Synchronization, Standard, Bitmap, and Image checkpoints for greater accuracy of testing in Quick Test Professional (QTP).
  • Monitor testing procedures to ensure compliance with business and user needs to be documented in functional and technical specifications.
  • Created relational databases interfacing with numerous Mainframe DB2 systems increasing productivity
  • Performed manual testing by creating test documents, test cases, Bug/Defect tracking, defect management using HP Quality Center.
  • Experience in writing UNIX commands and shell scripting.
  • Elicit and document the requirements for an audit tracking system used by CMS to recover unused monies.
  • Implemented Web Services Engine that communicates with remote mainframe HMS server for getting information about the auto policies.
  • Identify Screen, Reports, Database, EDITS, policies, and procedures.
  • Documented Systems Integration specifications and performed detailed Data Modeling (using Toad Data modeler).
  • Identified data sources, construct data mapping sessions, provide data flow diagrams, and document the processes into HLD/LLD.
  • Participated in system integration and implementation activities.
  • Pioneer Solutions provide enterprise-wide risk management and environmental software solutions to commodities and Energy Trading Risk Management clients.
  • Reported and tracked software defects using Rational RequisitePro.
  • Involved in writing BRD & FRD with the help of Business users by conducting elaborate requirements detailing sessions with users.

Business Analyst /Quality Analyst

Confidential

Responsibilities:

  • Standardized test scripts, composed and submitted process improvement guidelines to management, and mentored incoming associates.
  • Interviewed conducted analysis and successfully documented multiple business processes of several applications so we may effectively improve efficiency and productivity.
  • Created UML - based use case models and activity diagrams, and usability analysis/user interface.
  • Defined and carried out QA assessments required helping achieve project milestones and providing confidence that quality requirements were performed adequately.
  • Perform data analysis within Oracle Business Intelligence application and SQL.
  • Interacted with developers and performed feasibility analysis of the system and used SCRUM methodology for software development.
  • Created test plans, test cases, tracked defects, conducted training sessions for UAT, and performed production verification for release.
  • Studied As-Is system and performed Gap Analysis for the existing system to map it to the To-Be system.
  • Generated documentation using WORD and VISIO diagramming.
  • Involved in agile development and participated in everyday scrum meetings.
  • Prepared use case scenarios using MS Word, PowerPoint for better presentation and understanding of the application.
  • Documented and managed all project requirements and changes to requirements throughout SDLC, followed waterfall methodology.
  • Developed and maintained an MS SharePoint site for project management documentation.
  • Created data quality engine to let accurate and correct data into data warehouse through ETL process and inaccurate data.
  • Documented defects in JIRA and then Rally issue tracking systems and interfaced project management and development team to expedite resolution.
  • Worked closely with a few SMEs across the firm to identify and analyze AML trends and develop risk remediation/ mitigation plans.
  • Created Requirement Specification Documents after conducting interviews with End-Users, JAD Sessions and analyzed their current systems.
  • Model the detailed design of the system using UML diagrams including Use Case diagrams, Sequence Diagrams, and Data Flow diagrams.
  • Managed test results and assured implementation recommendations are made based upon test results.
  • Developed RIA modules along with Java for Account Reporting (AR) and Billing web applications.
  • Created Use Case Diagrams, Class Diagrams, and Sequence Diagrams for the various modules in the claims system using Rational Rose.
  • Performed GUI testing on screens and verified the properties and functionality of the objects on various windows.
  • Conducted end-user interviews for documenting the AS-IS system specifications.
  • Analyzed the business requirements documents, requirement specifications,s and design documents to understand the requirements.
  • Worked with web designers to create HTML screen prototypes and wireframes.
  • Defined ETL (extraction, transformation, load) for the data from source systems to the data repository for the portal.
  • Worked on developing XML components in WSDL to transfer data between two interfaces using document object model and SOAP.
  • Initiated and guided agile methodology thereby fasten the product features delivery to production.
  • Tested for User Friendly (GUI) interface, Performance, Speed, System and also checked in for Beta Testing.
  • Project management experience using waterfall and Agile methodologies.
  • Coordinated project team, prepared questionnaire sets, and interviewed different people from the project management community people and project technology community.
  • Created a test plan and manual/automated test cases via Quality Center 9.0 and QTP (with Terminal Emulator Add-in).
  • Prepared and executed test plans to ensure functionality and compliance with technical specifications, business rules, and user requirements.
  • Developed automated DB2 queries to validate referential integrity for scheduled Information Warehouse extracts.
  • Automated more than 200 Use cases using Quick Test Pro integrated with Application Life Cycle Management and HP Quality center.
  • Used UNIX to execute the interface scripts according to the business requirements.
  • Worked in the mainframe environment for analyzing the various screen and programs.
  • Participated in requirement gathering sessions and created high-level business requirement documents.
  • Developed and executed database scripts using Toad for generating intended reports to verify key Business and functional requirements.
  • Developed process model/flow diagrams and UI prototyping.
  • Managed system integration, regression, and user acceptance test execution of the application.
  • Facilitated discussions involving BA, operations, business unit, and risk management resources for building consensus and documented business requirements.
  • Prepared Business Requirement Document and used Rational RequisitePro to Manage, Analyze, and convert Business Requirements into Functional Specifications.
  • Documented Functional Requirement Specifications (FRD) and assisted Systems analysts to come up with System Requirement Specifications (SRS).

BA/QA

Confidential

Responsibilities:

  • Coordinated with the Quality Control/Validation department to ensure all test scripts run successfully in the validation environment.
  • Performed business process re - engineering utilizing enterprise analysis.
  • Analyzed and wrote user interface rules and system configuration requirements to be implemented by software engineers.
  • Developed and implemented an automated regression test suite and quality-control methodologies to ensure compliance with QA standards, regulations, and customer specifications.
  • Generated business reports in the database using SQL to validate data integrity.
  • Prepared interview questionnaires for the users and gathered requirements to write specifications and to shape the software development process.
  • Performed and supported UAT testing for implementation and post-implementation support.
  • Participated in and contributed to As-Is and To-Be Process Modeling Sessions, and build process models responsible for analysis and reporting.
  • Used MS VISIO for creating the Use case and Activity Diagrams to elaborate requirements.
  • Participated with software developers in Scrum team meetings and documenting agile software processes.
  • Prepared PowerPoint presentations and Excel spreadsheets for business meetings.
  • Provide data analysis support including the design, project management, and documentation including final report preparation and presentation.
  • Planned and managed projects to implement online degree programs for educational institutions, utilizing SDLC and Agile/SCRUM methodologies.
  • Performed data mapping and distributed project management documents to Stakeholders using MS SharePoint.
  • Analyzed and developed data quality in the data warehouse.
  • Used JIRA for updating the status of all the test cases and test scenarios that were executed during the testing process.
  • Worked with the stakeholders, SME's, system architects, and managers to define business requirements and develop business requirements documents.
  • Facilitated and participated in JAD sessions to define Business Requirements, Statements of Work, and System Requirements.
  • Followed UML processes and standard operating procedures in developing Use Cases diagrams and other supporting documentation.
  • Increased overall testing effectiveness by the developed a streamlined process for executing tests and reporting test results.
  • Developed and executed WinRunner TSL scripts for functional and regression testing of Java and J2EE applications.
  • Developed and processed business mapping, activity diagrams, and functional software specification and requirements documentation.
  • Provided training of EDS policy, procedures, and the IndianaAIM windows to internal (EDS) and external areas.
  • Created functional specification documents from the requirements and As-Is process maps.
  • Gather test data used during execution phases from design documents and business analysis based on legacy systems information.
  • Involved in Tech upgrade which involves converting the screens that are built using Adobe FLEX to HTML.
  • Collaborated with the ETL team to trigger email notifications for customer billing applications.
  • Provided Usability Design, Usability Testing, Regression Testing, and Maintenance for all developed forms and XML changes for the Database.
  • Used agile methodology for the development and deployment of roadside assistance and scheduled property projects.
  • Involved in developing GUI interfaces for reports and maintaining documentation.
  • Experienced with Prototype development and both iterative and waterfall systems development processes.
  • Assisted the project management team with duties as necessary including research, documentation, training/education support, and validating release material.
  • Performed Functional and Regression testing using QTP during the iteration of the application development.
  • Elicited business requirements by conducting workshops and interviews with stakeholders, and translated them into meaningful functional and technical specifications.
  • Used such technologies as File-Aid, Endeavor, DB2, TSO, JCL, and VSAM.
  • Managed defects and submitted tickets to the development team using the HP Quality Center defect management tool during development and system testing phases.
  • Used Unix command prompt to execute the shell script file for my testing.
  • Worked with Verification and Validation team during the regression test to validate the Payloads sent and received from the CMS Hub.
  • Worked on RUMBA Mainframe on daily basis to differentiate between individuals with the same client-assigned identifier number, if any.
  • Participated in status update meeting for ICD 10 and capturing notes of the tasks and activities that need to be performed.
  • Used TOAD as an application to share project assets like Data scripts, templates.
  • Developed business requirements documents, detailing use cases, high-level architecture/concept diagrams, and data flow diagrams.
  • Defined user and system requirements for Investment Planning and Retirement Guidance for system integration and new system development initiatives.
  • Performed custom data conversions and developed custom software for risk management applications including general claims, vehicle accident, and administrative tracking.
  • Configured Rational RequisitePro server to support Test Director Integration, shared and mapped requirements, the project defined attributes, and requirement types.
  • Prepared Business requirement Document (BRD) and functional requirement document (FRD) for the enhancement of the existing services.

Hire Now