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.
 
