Servicenow Business Analyst, Healthcare Business Analyst, Business Int

Sindhu

Servicenow Business Analyst, Healthcare Business Analyst, Business Integration

Analyst, Manual QA & QA ETL Tester

*****************@*****.***

Professional Summary:

• Experienced Business Analyst & ETL Tester with over 6 years of experience in Software industry. Good understanding of ETL Testing principles and concepts. Fully versed in complete SDLC.

• Expertise in Business Analysis, Data Analysis, Business Rules, Business Process Modeling and Data Mapping, GAP Analysis and creating business process documents.

• Communicate client's business requirements by constructing easy-to-understand data and process models.

• Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation.

• Expert on business and systems requirements, user acceptance testing and end-user training. Accomplished at leveraging past lessons to inform future decision making.

• Assisted in building an Organized Change Management (OCM) communication plan.

• Involved in Database, Web - based Application testing in Data Warehouse and Data delivery side.

• Ability to perform backend data validation/testing. Proven skills in writing and implementing test cases, developing testing plans and identifying use cases.

• Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation. Experienced in writing test cases and User Acceptance Testing (UAT) using SQL server and other testing tools.

• Experience in creating Test Plans, Test Procedures, Test Cases, Test Scripts, Requirement Traceability Matrix, identifying different Testing Techniques.

• Proficient in defect tracking tools like JIRA, Quality Center and Service Now.

• Analyze and understand the ETL work flows developed. Strong in ETL data validation developed using Informatica ETL environments

• Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.

• Executed test scripts to check the data flow from Source tables to Data Warehouse and Data Marts.

• Tested the web reports by manually Querying data warehouse and comparing the results with Reports.

• Performed functional, integration, manual testing, user acceptance testing (UAT), regression testing and performance testing in a SCRUM Agile software development environment.

• Analyzed the business and technical specifications, requirements, use cases and user stories to create test plans, test cases, test scripts and scenarios.

• Involved in agile development and participated in everyday scrum meetings.

• Queried against source and target database objects in ETL testing.

• Performed column data mapping between source & target database.

• Validated the data loaded into the target database and staging area from backend.

• Validated data in Target database according to business rules.

• Experience in Team Foundation Server (TFS) for issue tracking and application lifecycle management.

• Involved in all the aspects of requirements testing (e.g. testing plan, scenarios, and documentation, defect management) to ensure minimal production UAT defects are realized and completing analysis of the results tying back to customer impacts.

• Have experience as Service Now Business analyst in Support, Implementation and Enhancement of ITSM modules. Experience on various IT Services of Service - Now tool like Incident, Problem and Change Management, Service Catalog Requests, Service-Now Administration,

• Collaborated with Test Data Lead and Test Data Analysts to identify test data requirements for assigned projects.

• Developed and maintained relationships with Business Analysts (BA) in IT Portfolio Management organization to ensure an understanding of Functional Testing needs. Skills

Business Analysis, Requirements documentation, Manual QA, Informatica Power Center 10.0/10.2 (Designer, workflow manager, workflow monitor), ETL Testing, Data extraction, Generic UNIX Scripts, Staging tables, Data Integrity, SQL Server 2008/2014, OLAP & OLTP, Oracle 1og/11g, DB2,Data Flow Validation, System performance Tests, Agile Scrum, Microsoft office, Windows XP/10, Flat files, Team Foundation Server (TFS), Defect Tracking Tool JIRA, Quality Center, ServiceNow, ITSM, Change management, Incident Management. Work History

2018-04 - Current Business Analyst & ETL Tester

Geisinger Health Plan, Danville, PA

• Hands-on experience in handling and processing ETL application with extensive knowledge of testing and validating data warehouse.

• Analyzed the business and technical specifications, requirements, use cases and user stories to create test plans, test cases, test scripts and scenarios.

• Involved in agile development and participated in everyday scrum meetings.

• Primarily responsible for validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables.

• Tested loaded data warehouse components like ODS (Stage), EDW and data marts tables after the jobs run.

• Modified the 834 file and then checked if the eligibility enrollment is properly loaded onto Facets.

• Worked closely with different EDI transaction file like 837I&P, 834,835 to understand the source structure and the source data pattern.

• Assisted business partners regarding best practices in organizational change management to assist with discussion and decision-making.

• Strong in ETL data validation developed using Informatica ETL environments.

• Test the flat file data transfers. Check modeling views based on the target tables.

• Check if CDC has been applied on the incremental load table. Data check in dimension table and history table check.

• Involve in gathering business requirements from sales/marketing team and business analysts and performed detailed analysis of business and technical requirements and designed the solution by customizing various standard objects.

• Created context and workflow models, information and business rule models, Use Case during the analysis using Rational Tools.

• Documented requirements and transformed them into functional and technical requirement specifications.

• Tested the ETL Informatica Jobs and other ETL Processes (Data Warehouse Testing).

• Handled SCD Type 1/ Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.

• Working Knowledge of Defect management process, Risk Framework and mitigation, and Enterprise Testing standards.

• Used Generic UNIX shell scripts to access and move files from production to development environment.

• Verify the tables in source system for count check, data type check, no spam data loaded.

• Develop and Design ETL test cases, scenarios, and scripts to ensure quality Data warehouse.

• Gathering requirements from stakeholders, slotting stories in ServiceNow SDLC SCRUM module and monthly releases. Collaborated with Service Desk team and Change Management to evaluate requests to change, customize, and configure SNOW.

• Led cross-functional teams to analyze and understand enterprise-wide operational impacts and opportunities of technology changes.

• Documented business processes and analyzed procedures to align with changing business needs.

• Met with stakeholders to establish favorable business relationships and support mutually beneficial interests.

• End data validation of the various sources to the target database.

• Queried against source and target database objects in ETL testing.

• Experience in Team Foundation Server (TFS) for issue tracking and application lifecycle management.

• Experience in using JIRA software to plan, track and release.

• Performed column data mapping between source & target database.

• Collaborated with developers and product owners to stay current on product features and intended functionality.

• Wrote and optimized test cases to maximize success of manual software testing with consistent, thorough approaches.

2016-06 - 2018-03 Business Analyst & ETL Tester

Highmark, Camp Hill, PA

• Experienced in ETL testing, manual and automated testing, and black/white box testing.

• Well-versed in ETL processes, performance based systems, and ETL process flow and standards.

• Involve in gathering business requirements from sales/marketing team and business analysts and performed detailed analysis of business and technical requirements.

• Assisted the senior business analyst in defining the scope, and defining business rules of the project.

• Also assisted in gathering business requirements, doing gap analysis and documents them textually or within models.

• In-depth knowledge of Enterprise Data warehousing ETL, Data warehousing requirements, and Enterprise level data warehousing.

• Familiar with UNIX, SQL, agile methodologies, and oracle data base.

• Experience in Data Analysis, Data Cleansing, Data Validation and Verification and Data Conversion.

• Developed business architecture using requirements such as scope, processes, alternatives, and risks.

• Expert in using Team Foundation Server (TFS) for source control, team build, project tracking,testing,data collection and reporting, team project portal and shared service.

• Analyzed client's business requirements and processes through document analysis, interviews, workshops, and workflow analysis.

• Experience in using JIRA software in creating user stories and issues, plan sprints, and distribute tasks across your software team.

• Involved in Implementation, Customization and Maintenance of ITIL modules such as Incident, Change, Problem, Knowledge, Service Catalog, CMDB, Reporting and Integrations in Service Now.

• Proficient in using ServiceNow for IT services management (ITSM), IT operations management (ITOM) and IT business management (ITBM), allowing users to manage projects, teams and customer interactions via a variety of apps and plugins

• Good experience in preparing test cases, test execution and report generation.

• Conducted user acceptance testing to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements.

• Designed, developed and implemented user acceptance testing protocols as the final phase of applications development.

• Captured and tested all modifications to proposed functional requirements.

• Preparing test cases and running test scripts for various applications and modules.

• Performing defect analysis for failed test cases and develops solutions for the same by coordinating with developers.

• Working Experience in Audit activities.

• Reviewed files, records and other documents to obtain business information and key data informing responses to development requests.

• Derived conceptual designs from business objectives to deliver software and applications according to specifications for usability, performance and functionality. 2016-02 - 2016-06 Business Analyst & ETL Test Analyst Citizens Bank, Rhode Island, RI

• Primarily responsible for validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables.

• Engage client to gather software requirements/business rules, and ensure alignment with development teams.

• Translate stakeholder requirements into over 10 tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.

• Draft and maintain business requirements and align them with functional and technical requirements.

• Experience in ETL Methodology for supporting data extraction, and testing.

• Worked of different file types delimited files, .csv and .xlsx

• Experience in software Development Life cycle like debugging, testing, maintenance and designing.

• Good in executing the test cases.

• Experience in dealing clients and understanding the requirements and providing the support.

• Creating the Test plan and test cases and testing with unit testing and sending them for approval.

• Involved in User Acceptance Testing (UAT) and training of the end users to improve business process.

2015-06 - 2016-01 ETL Test Analyst

Staples, Framingham, MA

• Assisted in extracting the data from heterogeneous data sources, transforming the data

(like applying calculations, joining fields, keys, removing incorrect data fields, etc.), and loading it into a Data Warehouse.

• Verifying tables in source system like count check, Data type check, ensures no spam data loaded, remove duplicate data.

• Developing the test plans and test cases and executing the test cases.

• Check modeling views based on the target tables.

• Check if CDC has been applied on the incremental load table.

• Data check in dimension table and history table check.

• Preparing the test plan and test strategies for ETL application.

• Maintaining daily status reports with complete information like passed, failed and executed test cases.

• Performed all test cases like Unit Testing, Regression Testing, and User Acceptance Testing.

Education

Master's Degree: Computer Science

Rivier University - NH

GPA: 3.43

Contact this candidate