Ba Analyst Resume
- 6 yearsofexperience as aBusinessandQuality Analyst, assisting in various stages of Software/System Development Life Cycle (SDLC) such as defining scope, design, and development strategy and quality assurance.
- Proficient in writing Use Case Specifications Functional Requirement Specifications(FRS),Technical Requirements Specifications(TRS),BRD,and Requirements Traceability Matrices(RTM).
- Proficient inUnderstanding User Stories, Requirement Elicitation, Requirement Documentation, by I Want This\">Validation, Modeling, andAnalysis. Competent in creating Unified Modeling Language (UML) such as Use Case Diagrams, Activity Diagrams, and Sequence Diagrams. Proficient in using Business Analysis tools such asMS Visio,Word,Excel, Clear Questand Project Workbook. Proficient inSQL querying with Databases. Have clear understanding of Business Intelligence and Data Warehousing concepts and knowledge in ETL tool Informatica. In depth knowledge of SDLC: Agile, Waterfall andmethodologies.
- Knowledge on Team Foundation Server.
- Involved in Test Planning, Test Preparation, Test Execution, and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
- Responsible in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
- Strong knowledge in test management tools such as Test director, Quality center, Jira and QTP.
- Well versed in project management tools like MS-Project for status reporting and planning.
- Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
TECHNICAL SKILLS
Languages: C++, Java, .Net, Java Script, XML, HTML, PLSQL
Databases: MS Access, Oracle 9i/8i, MS SQL Server, DB2
Platforms:Windows NT/2000/XP/7
Tools: Putty, TOAD, SQL*Plus, SQL*Loader, Informatica, Team Foundation Server
Utilities: MS Office Suite, MS Project, MS FrontPage, MS Excel, MS Word
Test Management Tools:Quick test Pro, Test Director, Quality Center, Jira, Clear Quest
Modeling Tools: UML, MS Visio
WORK EXPERIENCE
Confidential,June 2011- Oct 2012
BA Analyst
Project 1:
Medicaid is a state administered program. KMAP’s pharmacy data source, First Databank (FDB), discontinued the publication of the Blue Book Average Wholesale Price (Blue BookAWP) Because of this action, NEW Kansas Medicaid drug pricing Wholesale Acquisition Cost (WAC) based (WEAC) has to be implemented for dates of service on and after the policy E2011-007.
Project 2:
Affordable care act includes significant changes to the Medicaid state administered program. These changes include revising the definition of average manufacturer price, and establishing a new formula for calculating the Federal upper limit, and increasing the rebate percentages for covered outpatient drugs dispensed to Medicaid patients, and including the rebate offset associated with the increase in the rebate percentages, and extending the Prescription drug rebates to covered outpatient drugs dispensed to enrollees of Medicaid managed care organizations (MCOs).
Project 3:
KDHE-DHCF has contracted with Accenture to provide the Kansas Eligibility Enforcement System. This Project contains the necessary tasks for the MMIS to exchange information with Kansas eligibility enforcement system. The information in the MMIS system will be converted in the KEES system.
- Conduct interviews with Business Users, Subject Matter Experts (SMEs) at all levels covering multiple departments for Requirements Elicitation.
- Involved in analysis and design, created design documents identifying thewindow changes, letter changes,external system interfaces, data model changes, job stream and scripts, reports, inputs and outputsand non-change order related changes for KEES transmission Input.
- Started enforcing process reviews with development team and Stakeholders respectively.
- Developed and maintained all operationalwork flows using Visio and Power point.
- Work with the architects, technical leads and developers to translate requirements into system designs.
- Managed schedules and collaborated with different teams working on the project.
- Prepared project progress reports and Status reports and submitted to management on an ongoing basis.
- Perform other duties and responsibilities as assigned.
- Preparation of System andRegression test cases and participated in testing widely the MMIS windows stemming from the new changes related to the policy E2011-007.
- Updating/creating user and technical documentation procedures and manuals.
- Conducted Change Order reviews with the development team. Created test scenarios for User Acceptance Testing (UAT).
- Created a Process document to depict the flow of critical information.
- Responsible for making sure all the requirements are thoroughly tested in all the test environments and also resolve issues if any occur.
- Involved in testing the new pricing logic for claims submitted by the providers.
- Owned Drug Rebate sub-system in the MMIS.
- Initiated /coordinated status meetings with the Business contact/Clients.
Environment: Windows 7, PowerBuilder, Oracle, .NET, C++, UNIX, MS Office
Confidential,New York Dec 2010 – May 2011
BA Analyst
Fresh Direct is a New York based online grocer, serving a large portion of metropolitan New York City, as well as other selected communities. Fresh Direct focuses on the quality of the food and concentrates on higher margin items like: fresh produce, fresh meat and seafood, baked goods, and prepared dishes. Fresh Direct, offers 5,000 perishable products and 3,000 packaged goods, and three-quarters of its revenues come from perishables.
- Effectively prioritized requirements in multiple phases which resulted in better requirements management and control.
- Create User Stories and prepare Acceptance Criteria by working with the SME’s and business users.
- Responsible for documenting the Sprint backlog and maintenance.
- Worked closely with development and QA teams during design and testing phases of the website.
- Report and review the defects in Mercury Quality Center &Jira Defect tracking systems.
- Involved in identifying the test cases that are affecting the basic and major functionality of the application in order to Smoke Test the application.
- Maintained the requirement traceability matrices (RTM) to track the coverage of requirements vs. designed test cases.
Environment: Quick Test Pro 9.5, Internet Explorer, Quality Center 9.5, Fire Fox, Safari, HTML, Script, Java Scripting, XML, Oracle and Access.
Confidential,Dallas Oct 2008 – Oct 2010
Jr.BA Analyst/QA Analyst
The Enterprise Data Warehouse (EDW) provides integrated information from a number of EDS Systems and sources. This information is used by the CIO BI Application data marts over a strategic (long term) implementation. The goal is a centralized, integrated set of enterprise information to be used as the basis for all enterprise Business Intelligence applications.Have knowledge on developing mappings and transformations using Informatica tool.
- Attended meetings and documented meeting minutes when necessary. Review draft documentation and distribute once finalized with action items. Ensure follow-up on all assigned action items.
- Prepared ETL Process flow diagrams and also assisted ETL Lead in preparing source-to-target mapping document.
- Developed Workflows to load the data from the source to various staging levels and from staging tables to the respective Dimensions and Fact table of EDW.
- Document business requirements and translate those into Fact and Dimension definitions, ultimately delivering a data dictionary.
- Developing Test Scenarios and uploading them in to Quality Center and executing them.
- Maintained Requirement Traceability Matrix (RTM).
- Performed Regression Testing and created test scripts for User Acceptance Testing (UAT).
- Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loaded to the dimension tables and fact tables properly.
- Maintaining issue log of the issues during the UAT phase for future reference.
- Actively involved in the production support and also transferred knowledge to the other team members.
Environment: Erwin, Informatica PC 8.1, Oracle 10G, SQL Server Microsoft Analysis Services, ProClarity, MS Visual Source Safe, Quality Center 9.2.
Confidential,Dallas April 2007 – Sep 2008QA Analyst
- Analyze System Business requirements and Analysis and Design documents (A&Ds) to categorize the units.
- Worked closely with users, developers, business analyst, configuration management team, project managers, and test lead for a better understanding of requirements for QA testing.
- Managed & scheduled all Manual and Automation scripts from Mercury Quality Center using the Test Plan, Test Lab and Defects module.
- Generated an execution grid in the Test Lab module of Quality Center, group test cases and executing them simultaneously.
- Analyzing and reviewing the requirements and creating System, Regression, Functional, E2E and User acceptance test cases and executing them.
- Developing UAT test cases, test cases/test scripts, test completion reports, defect reports etc.
- Created Test data and configuring and setting up Test environments and Production Environments.
- Used File-aid for browsing the VSAM files and QMF for executing the SQL queries and Manipulating data.
- Extensively worked with if then, for loops and Select Cases. And Retrieving Data from The mainframe DB2 tables using Terminal Emulator (TE).
- Submitting the Load jobs and loading data into DB2 tables. Working with the batch Jobs in the Test region to test the functionality before moving to Production.
- Involved in converting manual test cases into automated scripts on Mercury Quick Test Pro (QTP).
- Involved in creating Scripts for regression and E2E testing using QTP by creating reusable actions and parameterized the actions in the various scenarios during scripting the regression test cases using QTP.
- Participate in various meetings and discussed Enhancement and Modification Request issues.
- Involved in identifying the test cases that are affecting the basic and major functionality of the application in order to Smoke Test the application.
- Involved in Daily Meetings and weekly Team Meetings, meetings with the clients, testing team and project managers.
Environment: QTP 9.2, Mercury Quality Center 9.2, Java,J2EE,EJB, Enterprise Edition, Crystal Reports, DB2, Cobol, File-aid, TSO/ISPF, Vsam, JCL.
Confidential, SavannahJuly 2006 –March 2007
QA Tester
- As a Tester, developed Manual Test scripts based on Use cases developed.
- Extensively used SQL commands for data check in the database.
- Reviewed Business, Functional and System Requirement Specifications, and performing extensive manual testing for POS(Point of Sale) and Billing Modules according to SDLC
- Created SQL scripts for executing the database queries.
- Assisted in creating System Test Plans.
- Involved in Regression Testing, Backend testing and Functionality Testing.
- Maintained a centralized tracking system to track defects.
- Involved in development of Requirements Traceability Matrix.
- In the Test Module of Test Director using Execution Grid checked the test status, reporteddefects to the development team.
- In the Execution Flow Tab set test conditions to Finished and Passed as well as set Time dependency between steps and performed the layout.
- Involved in collecting and documenting the test execution reports.
- Participated in weekly meeting with the management team and walkthroughs.
- Provide weekly Test Summary Reports for projects.
Environment:UNIX, J2EE Architecture, Web Logic, Oracle9i, Crystal Reports, Test Director 5.0, TOAD and MS Office.
EDUCATION
Masters in I.T,
B.Sc.,
