Ba + Etl Qa Resume
3.00/5 (Submit Your Rating)
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.