Senior Business Analyst Resume
Albany, NY
SUMMARY:
- Over 9 years’ experience in all phases of Software Development Life Cycle, including requirements gathering, Testing, Defect tracking and reporting in UNIX, Windows and Mainframe environments.
- Strong understanding of the healthcare delivery and regulatory environments of the Center for Medicare & Medicaid Services (CMS).
- Exposed to all phases of Methodologies like traditional Waterfall model and Agile development methods.
- Expertise in gathering and documenting Business Requirements Documents(BRD), Functional and Technical Specification documents(FRD), Control Change documents, Test plans and Test scripts using MS word.
- Strong experience in Requirements Managementincluding requirements elicitation, documentation, solution assessment and validation, Change Management, Scope Management and communicating requirements across key stakeholders.
- Experience in leading and facilitating in Joint Application Development(JAD) sessions and White Board Sessions with end - users, SMEs team, Architects and design group development and QA team for project meetings and walkthroughs.
- Proficient in using Unified Modeling Language(UML) for Business Process Modelling, Use case Diagrams, Activity Diagrams and Sequence Diagrams.
- Skilled in business and system requirement analyses and functional specifications with supporting business process flows, Gap Analysis, Risk Analysis, Data Analysis, Cost Benefit analysis and concept of operations for system utilizing company standards, processes and procedures.
- Hands on experience with Manual and Automation Testing using Quality Center and Selenium IDE.
- Experience working in client/server, web application, database and legacy systems like mainframes.
- Extensive experience in System, Functional, Integration, Regression, User acceptance Testing of Web applications and Mainframes data.
- Worked closely with designers, developers, business and user representatives during application testing.
- Hands on Knowledge of Managed Care Health Insurance programs with strong experience in claims adjudication.
- Strong knowledge of Healthcare Insurance, HIPAA transactions ANSI X12 data (837, 834, 270/271, 276/277).
- Experience with validating Web technologies, SOA Testing using SOAP UI (SOAP Web Services).
- Extensive experience in writing Stored Procedures, Packages, Database Triggers using SQL.
- Involved in writing SQL queries to validate the backend claims and Provider data on Mainframes.
- Experience in COGNOS to extract the data from various sources using different ETL transformations.
- Outstanding analytical, decision-making and problem-solving skills with the ability to organize activities.
- Ability to perform effectively in a team and individually with troubleshooting and good communication skills.
TECHNICAL SKILLS:
Languages: PL/SQL, Java, Java Script, Visual Basic, XML, JCL, HTML
Testing and UML Tools: IBM Clear Quest, Rational Jazz Team Server, HP Quality Center, Selenium IDE, QuickTest Pro, Test Director, Rational Requisite Pro, Visio, Rational Rose, Issue Tracker, Visual Studio.
Databases and Database Access Tool: Oracle, DB2, MS-SQL Server, MS-Access, TOAD, SQL Developer, XQMF.
Application/Web Servers: NASCO, WebLogic, JBoss, Apache Tomcat, IBM WebSphere.
BI Tools: IBM Cognos v 10.2.2 /IBM Cognos Analytics v 11.0.7, Informatica Power center 9.1/8x/7x,(source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Workflow Manager, Workflow monitor)
Other Software: Microsoft Project 2016, Microsoft Office Suite and OneNote 2016.
SDLC: Agile, Waterfall, Prototyping, Iterative.
Operating Systems: Windows W2K/XP, MOS (Michigan Operating System), UNIX (Solaris), IBM Mainframe (ES 9000), AIX.
PROFESSIONAL EXPERIENCE
Confidential, Albany, NY
Senior Business Analyst
Responsibilities:
- Works closely with Business users, Client staff and Stakeholders to assist them with Functional and Technical requirements review, testing, reporting and validation.
- Prioritizes IT system requirements to gain stakeholder agreement for IT projects or business process change documents detailing the project.
- Conducted JAD sessions, meetings, workshops to gather, analyze and review the business requirements and design specification documents with Business, BA’s and Developers.
- Documenting the business requirements in Use Cases, creating Use Cases process models using MS-Visio and generating work flow processes, Business Rules.
- Determines the impact of software and hardware releases on the IT system Reviews proposals from staff and recommends to management the criticality of revising system or business process requirements during and after IT system implementation, if applicable.
- Working in Agile methodology to ensure delivery of high quality work with every monthly iteration.
- Assists with the development of training related to business systems implementation for users.
- Involved in Gathering application system requirements, Data collection and Management of the reports to Business and Stakeholders for Internal, External, Audit purpose.
- Creating Report Specifications documents in word and Sample Mockups created in MS word, MS Excel and MS Visio.
- Facilitates defect management, defect triage and defect priority meetings.
- Analyze and execute software test cases with different scenarios for different lines of IT businesses.
- Evaluates the outcomes of systems testing, and confirms that the results are consistent with the system or business process specifications
- Involved in Development phase, Testing phase, Deployment phase and support phase.
- Perform validation of documented procedures and modify procedures as necessary.
- Development of expected entrance/exit criteria in to test cases.
- Run and test batch jobs.
- Test and verify X12 format for EDI (Electronic data Interchange) transactions.
- To assist in Plan, Develop, Test and Document programs.
- Analyze and test reporting modules using COGNOs.
- Presenting Weekly Status Report to the Manager and Stakeholders.
- Providing industry knowledge in areas of technology expertise.
Environment: IBM Rational Jazz Team server RTC Tool, IBM Cognos Business Intelligence 10.2.1, IBM Cognos Analytics v 11.0.7, Micro strategy, Rational Clear Quest Web client 7.1.2, IBMMainframe (WIN 3270), TSO, IMSS, JCL, CICS, COBOL, FILE-AID, OS/390, XML, Oracle, DB2, Putty, SOAP UI, Toad, MS Access.
Confidential, Detroit, MI
Senior Business Analyst
Responsibilities:
- Acted as the primary liaison between the client departments and the Information systems department and interacted with internal as well as external clients, to collect requirements and business process information, documented them in Business Requirement Document (BRD) post analysis of the business requirements by analyzing the Risks associated and strategies used to assess and mitigate them.
- Led and facilitated requirements meetings with key stakeholders to capture technical/design requirements.
- Analyse and review the requirements and design specification documents with BA’s and Developers.
- Working in Agile methodology to ensure delivery of high quality work with every monthly iteration.
- Developed the Use cases, Data Flow diagrams to depict the data flow.
- Involved in working on several web applications (BLUE CONNECT, BENEFIT CONFIGURATOR -SELECTOR) and software tools (Toad, Putty, SOAP UI, MetaVance-NASCO and SMART) within the project environment.
- Update the group numbers that are to be tested in SNDBXTBL to make sure benefits are read from Sandbox, if groups are not defined in SNDBXTBL benefits are read from Model office.
- Submitting the ICNS and validate the cost shares once the benefits loaded from the test region (ST2 environment) in to NASCO sandbox environment.
- Developed and Executed SQL Queries as a part of backend testing and involved in data validation and verifying data integrity.
- Documenting procedures for setup and maintenance of test environments.
- Perform validation of documented procedures and modify procedures as necessary.
- Participated in daily scrum stand-up calls to exchange updates with the team and discuss any challenges/defects encountered.
- Analyse and execute software test cases with different scenarios for different lines of IT Businesses.
- Applying knowledge of technical design, coding, and testing.
- Perform test plan preparation and system and Business testing.
- Involved code review, bug fixing and trouble shooting.
- Generated weekly status reports and Adhoc reports to monitor the progress and identify the critical points to reallocate resources and Decisions support for Development Life Cycle.
- Providing quality documentation, status updates and support.
- Conduct daily Review team meetings to discuss the daily status, progress and plans. Additional information relating to status of the test issues, business concerns and technical issues.
Confidential
Senior Business AnalystResponsibilities:
- Gathered business requirements, through interaction with the business users, the Project Manager, and Subject Matter Experts (SMEs), in order to obtain a better understanding of the business processes.
- Utilized with a waterfall methodology to ensure delivery of quality work within the short time frame.
- Responsible for conducting JAD sessions with extensive involvement from Business and Development teams, Architects, SME’s and Managers from various units.
- Identified and documented process flows and data requirements.
- Analysed system requirements to Use Cases, Use case scenarios and Business rules.
- Conducted End-To-End (E2E) Testing with other systems interfacing with the Acquire and Renew process, as well as performing validation of this data.
- Regression testing with web applications and mainframe applications dealing with both Medicaid and Medicare Services.
- Involved in preparing the test plan document, based on business requirements and system requirements.
- Developed and executed SQL queries as part of backend testing as well as being involved in verification, and data integrity.
- Executed test cases and the recorded any the testing defects in IBM Rational Clear Quest defect tracking tool.
- Prepared test cases for backend databases that involved retrieving data from DB2 tables and validating taxes and fees information utilizing TSO, IMS, and CICS tools on the Confidential mainframe. Also, worked with JCL to run the batch jobs that synched and updated the legacy rating mainframe DB2 tables.
- Involved in regression testing for the above application for both manual and functional testing.
- Supported and assisted business customer during the project’s User Acceptance Testing (UAT).
- Provided weekly management status reports and coordinated meetings between the test team and development team to review defects.
Confidential
Responsibilities:
- Analysed the application functionality with requirement documents like BRD (Business Requirements Definition) and FRD (Functional Requirements Definition).
- Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
- Developed and maintained test cases for the functional testing of all assigned modules (Connecture Quoting Application) for both Reform and Non-Reform Rating types for both 2013 and 2014 groups.
- Performed several iterations of regression testing using the following roles: Agent Admin, Sales Rep, Underwriter, Underwriter Manager, and Producer (Agent) for quoting Confidential individual health care and personal dental coverage’s on-line to ensure that no new problems have been introduced as a result of any recent code fixes.
- Validating the cost shares (deductibles, coinsurance and copay) as defined in the product level.
- Worked closely with the development team and reported issues on a daily basis prior to any build generation.
- Worked extensively with Clear Quest for entry, reporting, and tracking defects, and providing updates on resolved defects.
- Authored progress and completion reports, which were then submitted to project management on a weekly basis.
- Involved in reporting, tracking and reproducing defects, as well as participated in defect triage meetings.
- Participated in daily conference calls with business and development teams from different areas to discuss results, decisions, and planning of the testing and tracking progress.
- Worked closely with development, design, and testing teams to determine the best approach for testing any product releases.
- Attended and participated in daily scrum/sprint meetings.
Confidential
Responsibilities:
- Analysed, reviewed and assessed requirements and design specifications with Business Analysts and developers.
- Involved in testing with several web applications (Blue Connect, Benefit Configurator Selector) and software tools (Meta Vance and SMART) within the project testing environment.
- Responsible for testing Small groups products as community Blue, Simply blue and healthy blue achieve.
- Involved in End-to-End Testing effort for New Business (NBQ), Renewals and Group Wide Change (GWC) Processes.
- Worked extensively with Subject Matter Experts (SMEs) in identifying the scenarios, test conditions, and creating test requirement, as well as creating test cases, test procedure specifications, and test data.
- Executed test cases, logged the tests, evaluated the results, and documented any problems found in the defect log (MS Excel document).
- Extensively used the IBM Rational Clear Quest tool to log, report, prioritize, and track defects.
- Worked in the System Integration Testing (SIT), User Acceptance Testing (UAT), and Regression Testing (RT) environments.
- Performed backend testing, validated the data (rates, taxes and fees for Reform and Non-Reform Rating Groups) on the mainframe, using TSO, IMS, and CICS screens, and worked with JCL to run the batch jobs that synched and updated the legacy rating mainframe tables.
- Coordinated the upgrade of Transaction Sets 837P, 835 and 834 to HIPAA compliance.
- Expertise in testing EDI Transactions 834, 837, 835, 270/271 & 276/277.
- Involved in testing the claims conversion from Mainframe to Facets. Also involved in testing the EDI transactions 834, 837, 835. 270/271 & 276/277 conversion to Facets.
- Extensively used File-Aid and QMF (Query Management Facility) for DB2 to validate the prepared test data.
- Involved in all phases of testing and support.
- Conducted daily review meetings to discuss the status, progress, additional information relating to status of any test issues, business concerns and technical issues.
- Worked in a lead role to monitor and control, providing guidance to team members, and interacted with the business.
Environment: IBM Rational Clear Quest Web client 7.1.2, Share point (IBM tool), IBMMainframe (WIN 3270), TSO, IMSS, JCL, CICS, COBOL, FILE-AID, JOB Scan, OS/390, XML, Oracle, COGNOS, Microstartegy, DB2. MS Access, Confidential Blue Connect Connector, Benefit Configurator Selector, MetaVance v2.10-MTV MO and MOS.
Confidential, Bluebell, PA
Senior Business Analyst
Responsibilities:
- Requirement gathering from Business stakeholders on various aspects of insurance policies and claims.
- Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users and other stakeholders for open and pending issues.
- Created Workflow scenarios, designed new process flows, documented the Business Process and various Business Scenarios/activities of the business from the conceptual to procedural level.
- Requirements are story card based which impacts the test approach and test plan creation.
- Review the previous iteration in order to improve the future iteration.
- Managed testing activities like Functional, Regression, Smoke, Integration, and UAT.
- Designed service-oriented architecture (SOA) optimizing inter-component messaging and interaction.
- Participated in weekly meeting to provide the management with test metrics, reports, and schedules as necessary.
- Tested Provider Referral Portal Web Services using SOAP UI tool.
- Validated data on Mainframes and worked with JCL to run the batch jobs. Prepared test data using SQL, File-Aid.
- Monitor daily reports and perform quality control processes to ensure accurate processing of information and adherence to defined audit controls
- Utilized Quality Center as a Test management tool for planning and executing Tests, and for defect reporting.
- Tested Member data and Professional Claims that are processed in Mainframes.
- Used SQL to perform backend testing on the database server to test data reliability and integrity.
- Validated ETL Workflows for Parameter file create Daily member Extract Workflow and Full Member Extract Flow.
- Authored progress and completion reports, which were then submitted to project manager on a weekly basis.
- Attend short daily team meetings (scrum) to communicate the daily status, progress and plans of the team and communicate additional information relating to status of the test issues, business concerns and administrative issues.
Environment: Informatica Powercenter 8.6.1,Quality centre and ClearQuest, SQL, T- SQL, PL/SQL, Oracle 9i, SQL Server, DB2, JSP, Web Logic, XML,DB2, MS SQL Server200. IBMMainframe, COGNOS, TSO, JCL, CICS, COBOL, FILEAID, OS/390, Java, XML, Oracle, DB2, VSS.
Confidential, TN
Senior Business Analyst
Responsibilities:
- Facilitated collection of User Requirements and Business Requirements from Business User Group such as to document Business/User/Functional/Technical Requirement Specification using MS Word and MS Visio that provided appropriate scope of work for technical team to develop prototype and overall system. Shared SRS with developers and testers.
- Review tests specification and developed executed test cases, produced problem reports.
- Involved in working on several web applications within the project environment.
- Utlized UML/Rational Rose for creating the Use Cases, Activity Diagrams, Class diagrams, Sequence diagrams, Process Flows etc.
- Wrote Use Cases, Test scripts, Business process flows as per the URS and FRS.Managed product requirements using Rational Requisite Pro. Traced Requirements to Test Cases.
- Performed Unit testing, Integration testing, Functional testing, performance testing, user acceptance testing (UAT) and preproduction testing to validate reports and mappings.
- DesignedTest plansandTest casesfor testing the application.
- Identified the source tables, source columns, and referential joins using Data Stage Tools.
- Involved in several meetings to solve the Critical Issues with Developers and Business Team.
- Designed and implemented basic SQL queries for testing and report/data validation
- Used Firefox extension called Selenium IDE to automate testing.
- Involved with Development team and Management team daily on the overall testing progress.
- Recognized software problems, wrote easy-to-follow bug reports, logged them into bug tracking tool ClearQuest, monitored their progress and verified their fix.
- Worked extensively with Business Analysts and Developers to discuss the testing scenarios, defects and fixes.
- Generated weekly reports based on results and used SharePoint to store all Project Artifacts.
Environment: UNIX, Windows, SQL, T- SQL, PL/SQL, Oracle, SQL Server, Rational, Fiddler, Visual Studio, Issue tracker, Selenium IDE.
Universal Travels
Quality Analyst
Responsibilities:
- Prepared and implemented Test Plans and Test cases along with test lab setup.
- Interacted with Development team and Management team on a daily basis on the overall testing progress.
- Managed testing activities like Smoke, Integration, Functional, Regression and UAT.
- Designed automation Test scripts for the regression testing and actively involved in review of manual test scripts.
- Compare results of previous version with the latest execution to investigate the performance of the application.
- Troubleshoot any issues encountered, evaluate and perform upgrades on any of the tools in the Mercury test suite.
- Participated in weekly progress meetings, walkthroughs and inspections
- Utilized the Designer tools - Source Analyzer and Warehouse Designer to create and/or import the source and target database schemas.
- Accessed and validated Mainframe Test scenarios to keep track of the Jobs/Job schedules claim batches.
- Validated complex mappings in Informatica that load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
Environment: Windows-98, Mainframes (DB2, QMF, TSO/ ISPF, JCL, CICS), Informatica powercenter, IBM ClearCase, MQC 9.5, J2EE Technology, MS SQL Server 2005, Oracle 9i.